Schema for wgEncodeGencodeRefSeqV24
  Database: hg38    Primary Table: wgEncodeGencodeRefSeqV24    Row Count: 75,365   Data last updated: 2015-12-09
Format description: GENCODE transcript to RefSeq mRNA or non-coding RNA and peptide accession mapping
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 wgEncodeGencodeRefSeqV24.rnaAcc)
      hg38.wgEncodeGencodeAttrsV24.transcriptId (via wgEncodeGencodeRefSeqV24.transcriptId)
      hg38.wgEncodeGencodeTagV24.transcriptId (via wgEncodeGencodeRefSeqV24.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.