Schema for wgEncodeGencodeRefSeqVM24
  Database: mm10    Primary Table: wgEncodeGencodeRefSeqVM24    Row Count: 36,135   Data last updated: 2020-01-16
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.4varchar(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
        mm10.refGene.name (via wgEncodeGencodeRefSeqVM24.rnaAcc)
      mm10.wgEncodeGencodeAttrsVM24.transcriptId (via wgEncodeGencodeRefSeqVM24.transcriptId)
      mm10.wgEncodeGencodeTagVM24.transcriptId (via wgEncodeGencodeRefSeqVM24.transcriptId)

Sample Rows
 
transcriptIdrnaAccpepAcc
ENSMUST00000070533.4NM_001011874.1NP_001011874.1
ENSMUST00000194992.6NM_001195662.1NP_001182591.1
ENSMUST00000027032.5NM_011283.2NP_035413.1
ENSMUST00000027035.9NM_011441.5NP_035571.1
ENSMUST00000195555.1NM_001289467.1NP_001276396.1
ENSMUST00000192650.5NM_001289465.1NP_001276394.1
ENSMUST00000192650.5NM_001289466.1NP_001276395.1
ENSMUST00000116652.7NM_001289464.1NP_001276393.1
ENSMUST00000130201.7NM_025300.4NP_079576.1
ENSMUST00000130201.7NR_033530.1

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