Schema for wgEncodeGencodeRefSeqV23
  Database: hg38    Primary Table: wgEncodeGencodeRefSeqV23    Row Count: 74,748   Data last updated: 2015-10-02
Format description: GENCODE transcript to RefSeq mRNA or non-coding RNA and peptide accession mapping
On download server: MariaDB table dump directory
fieldexampleSQL type info description
transcriptId ENST00000576030.5varchar(255) values GENCODE transcript identifier
rnaAcc NM_023015.3varchar(255) values RefSeq mRNA or non-coding RNA accession
pepAcc NP_075391.3varchar(255) values RefSeq peptide identifier for coding accession

Connected Tables and Joining Fields
        hg38.refGene.name (via wgEncodeGencodeRefSeqV23.rnaAcc)
      hg38.wgEncodeGencodeAttrsV23.transcriptId (via wgEncodeGencodeRefSeqV23.transcriptId)
      hg38.wgEncodeGencodeTagV23.transcriptId (via wgEncodeGencodeRefSeqV23.transcriptId)

Sample Rows
 
transcriptIdrnaAccpepAcc
ENST00000576030.5NM_023015.3NP_075391.3
ENST00000576030.5NM_023015.3NP_075391.3
ENST00000623839.3NM_024330.1NP_077306.1
ENST00000623839.3NM_024330.1NP_077306.1
ENST00000576342.2NM_020699.2NP_065750.1
ENST00000576342.2NM_020699.2NP_065750.1
ENST00000612646.2NM_005286.2NP_005277.2
ENST00000612646.2NM_005286.2NP_005277.2
ENST00000613234.3NM_004535.2NP_004526.1
ENST00000613234.3NM_004535.2NP_004526.1

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.