Schema for wgEncodeGencodeRefSeqV42lift37
  Database: hg19    Primary Table: wgEncodeGencodeRefSeqV42lift37    Row Count: 78,315   Data last updated: 2022-11-03
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 ENST00000488147.1_4varchar(255) values GENCODE transcript identifier
rnaAcc NR_024540.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
        hg19.refGene.name (via wgEncodeGencodeRefSeqV42lift37.rnaAcc)
      hg19.wgEncodeGencodeAttrsV42lift37.transcriptId (via wgEncodeGencodeRefSeqV42lift37.transcriptId)

Sample Rows
 
transcriptIdrnaAccpepAcc
ENST00000488147.1_4NR_024540.1
ENST00000469289.1_1NR_036051.1
ENST00000469289.1_1NR_036266.1
ENST00000469289.1_1NR_036267.1
ENST00000469289.1_1NR_036268.1
ENST00000417324.1_4NR_026818.1
ENST00000641515.2_4NM_001005484.2NP_001005484.2
ENST00000442987.3_2NR_024368.1
ENST00000426406.1NM_001005221.2NP_001005221.2
ENST00000452176.2_4NR_125957.1

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