Skip to main content
Schema for wgEncodeGencodeRefSeqV50
  Database: hg38    Primary Table: wgEncodeGencodeRefSeqV50    Row Count: 99,718   Data last updated: 2026-04-24
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 ENST00000420522.1varchar(255) values GENCODE transcript identifier
rnaAcc NR_147025.1varchar(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 wgEncodeGencodeRefSeqV50.rnaAcc)
      hg38.wgEncodeGencodeAttrsV50.transcriptId (via wgEncodeGencodeRefSeqV50.transcriptId)

Sample Rows
 
transcriptIdrnaAccpepAcc
ENST00000420522.1NR_147025.1
ENST00000443270.1NR_183671.1
ENST00000417651.1NR_110758.1
ENST00000376030.7NM_201628.3NP_963922.2
ENST00000503743.5NM_001370230.2NP_001357159.1
ENST00000503743.5NM_001437721.1NP_001424650.1
ENST00000503743.5NM_015209.3NP_056024.1
ENST00000361144.9NM_001018000.4NP_001018000.1
ENST00000400797.3NM_001017999.3NP_001017999.1
ENST00000400798.6NM_001018001.3NP_001018001.1

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