Skip to main content
Schema for wgEncodeGencodeRefSeqV49
  Database: hg38    Primary Table: wgEncodeGencodeRefSeqV49    Row Count: 96,209   Data last updated: 2025-09-08
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 ENST00000378391.6varchar(255) values GENCODE transcript identifier
rnaAcc NM_199454.3varchar(255) values RefSeq mRNA or non-coding RNA accession
pepAcc NP_955533.2varchar(255) values RefSeq peptide identifier for coding accession

Connected Tables and Joining Fields
        hg38.refGene.name (via wgEncodeGencodeRefSeqV49.rnaAcc)
      hg38.wgEncodeGencodeAttrsV49.transcriptId (via wgEncodeGencodeRefSeqV49.transcriptId)

Sample Rows
 
transcriptIdrnaAccpepAcc
ENST00000378391.6NM_199454.3NP_955533.2
ENST00000270722.10NM_022114.4NP_071397.3
ENST00000420522.1NR_147025.1
ENST00000443270.1NR_183671.1
ENST00000449969.5NM_001303012.2NP_001289941.1
ENST00000378486.8NM_001303013.1NP_001289942.1
ENST00000378486.8NM_014638.4NP_055453.2
ENST00000378412.8NM_033467.4NP_258428.2
ENST00000620676.6NM_015378.4NP_056193.2
ENST00000613099.4NM_018156.4NP_060626.2

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