Schema for wgEncodeGencodeRefSeqVM33
  Database: mm39    Primary Table: wgEncodeGencodeRefSeqVM33    Row Count: 44,342   Data last updated: 2023-07-19
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 ENSMUST00000061280.17varchar(255) values GENCODE transcript identifier
rnaAcc NM_183028.3varchar(255) values RefSeq mRNA or non-coding RNA accession
pepAcc NP_898849.1varchar(255) values RefSeq peptide identifier for coding accession

Connected Tables and Joining Fields
        mm39.refGene.name (via wgEncodeGencodeRefSeqVM33.rnaAcc)
      mm39.wgEncodeGencodeAttrsVM33.transcriptId (via wgEncodeGencodeRefSeqVM33.transcriptId)

Sample Rows
 
transcriptIdrnaAccpepAcc
ENSMUST00000061280.17NM_183028.3NP_898849.1
ENSMUST00000027542.13NM_001316743.1NP_001303672.1
ENSMUST00000172005.8NM_001316744.1NP_001303673.1
ENSMUST00000172005.8NM_172853.3NP_766441.1
ENSMUST00000039725.12NM_012012.4NP_036142.2
ENSMUST00000201297.2NM_001290692.1NP_001277621.1
ENSMUST00000126008.8NM_001368287.1NP_001355216.1
ENSMUST00000126008.8NM_001368288.1NP_001355217.1
ENSMUST00000126008.8NM_001368289.1NP_001355218.1
ENSMUST00000126008.8NM_026430.4NP_080706.1

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