Schema for wgEncodeGencodeRefSeqV47
  Database: hg38    Primary Table: wgEncodeGencodeRefSeqV47    Row Count: 95,583   Data last updated: 2024-10-17
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 wgEncodeGencodeRefSeqV47.rnaAcc)
      hg38.wgEncodeGencodeAttrsV47.transcriptId (via wgEncodeGencodeRefSeqV47.transcriptId)

Sample Rows
 
transcriptIdrnaAccpepAcc
ENST00000378391.6NM_199454.3NP_955533.2
ENST00000270722.10NM_022114.4NP_071397.3
ENST00000288774.8NM_001374425.1NP_001361354.1
ENST00000288774.8NM_001374426.1NP_001361355.1
ENST00000288774.8NM_153818.2NP_722540.1
ENST00000447513.7NM_001374427.1NP_001361356.1
ENST00000447513.7NM_002617.4NP_002608.1
ENST00000650293.1NR_164636.1
ENST00000356607.9NM_004565.3NP_004556.1
ENST00000420522.1NR_147025.1

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