Schema for wgEncodeGencodeRefSeqV40
  Database: hg38    Primary Table: wgEncodeGencodeRefSeqV40    Row Count: 82,486   Data last updated: 2022-04-21
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 ENST00000379236.4varchar(255) values GENCODE transcript identifier
rnaAcc NM_003327.4varchar(255) values RefSeq mRNA or non-coding RNA accession
pepAcc NP_003318.1varchar(255) values RefSeq peptide identifier for coding accession

Connected Tables and Joining Fields
        hg38.refGene.name (via wgEncodeGencodeRefSeqV40.rnaAcc)
      hg38.wgEncodeGencodeAttrsV40.transcriptId (via wgEncodeGencodeRefSeqV40.transcriptId)

Sample Rows
 
transcriptIdrnaAccpepAcc
ENST00000379236.4NM_003327.4NP_003318.1
ENST00000328596.10NM_148901.2NP_683699.1
ENST00000379268.7NM_004195.3NP_004186.1
ENST00000379265.5NM_148902.2NP_683700.1
ENST00000673477.1NM_001317238.2NP_001304167.1
ENST00000673477.1NM_031921.6NP_114127.3
ENST00000424215.1NR_121638.1
ENST00000378391.6NM_199454.3NP_955533.2
ENST00000270722.10NM_022114.4NP_071397.3
ENST00000354700.10NM_030649.3NP_085152.2

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