Schema for wgEncodeGencodeRefSeqV25
  Database: hg38    Primary Table: wgEncodeGencodeRefSeqV25    Row Count: 49,105   Data last updated: 2016-07-23
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 ENST00000456328.2varchar(255) values GENCODE transcript identifier
rnaAcc NR_024005.2varchar(255) values RefSeq mRNA or non-coding RNA accession
pepAcc  varchar(255) values RefSeq peptide identifier for coding accession

Connected Tables and Joining Fields
        hg38.refGene.name (via wgEncodeGencodeRefSeqV25.rnaAcc)
      hg38.wgEncodeGencodeAttrsV25.transcriptId (via wgEncodeGencodeRefSeqV25.transcriptId)
      hg38.wgEncodeGencodeTagV25.transcriptId (via wgEncodeGencodeRefSeqV25.transcriptId)

Sample Rows
 
transcriptIdrnaAccpepAcc
ENST00000456328.2NR_024005.2
ENST00000456328.2NR_046018.2
ENST00000456328.2NR_051986.1
ENST00000456328.2NR_110561.1
ENST00000619216.1NR_106918.1
ENST00000607096.1NR_036051.1
ENST00000417324.1NR_026818.1
ENST00000417324.1NR_026820.1
ENST00000417324.1NR_026822.1
ENST00000335137.3NM_001005484.1NP_001005484.1

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