Schema for wgEncodeGencodeRefSeqVM31
  Database: mm39    Primary Table: wgEncodeGencodeRefSeqVM31    Row Count: 44,247   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 ENSMUST00000188305.2varchar(255) values GENCODE transcript identifier
rnaAcc NR_038011.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
        mm39.refGene.name (via wgEncodeGencodeRefSeqVM31.rnaAcc)
      mm39.wgEncodeGencodeAttrsVM31.transcriptId (via wgEncodeGencodeRefSeqVM31.transcriptId)

Sample Rows
 
transcriptIdrnaAccpepAcc
ENSMUST00000188305.2NR_038011.1
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

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