Schema for wgEncodeGencodeRefSeqVM27
  Database: mm39    Primary Table: wgEncodeGencodeRefSeqVM27    Row Count: 44,014   Data last updated: 2021-06-29
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 ENSMUST00000070533.5varchar(255) values GENCODE transcript identifier
rnaAcc NM_001011874.1varchar(255) values RefSeq mRNA or non-coding RNA accession
pepAcc NP_001011874.1varchar(255) values RefSeq peptide identifier for coding accession

Connected Tables and Joining Fields
        mm39.refGene.name (via wgEncodeGencodeRefSeqVM27.rnaAcc)
      mm39.wgEncodeGencodeAttrsVM27.transcriptId (via wgEncodeGencodeRefSeqVM27.transcriptId)

Sample Rows
 
transcriptIdrnaAccpepAcc
ENSMUST00000070533.5NM_001011874.1NP_001011874.1
ENSMUST00000208660.2NM_001370921.1NP_001357850.1
ENSMUST00000027032.6NM_011283.2NP_035413.1
ENSMUST00000027035.10NM_011441.5NP_035571.1
ENSMUST00000195555.2NM_001289467.1NP_001276396.1
ENSMUST00000192650.6NM_001289465.1NP_001276394.1
ENSMUST00000192650.6NM_001289466.1NP_001276395.1
ENSMUST00000116652.8NM_001289464.1NP_001276393.1
ENSMUST00000130201.8NM_025300.4NP_079576.1
ENSMUST00000130201.8NR_033530.1

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