Schema for wgEncodeGencodeRefSeqVM14
  Database: mm10    Primary Table: wgEncodeGencodeRefSeqVM14    Row Count: 34,022   Data last updated: 2017-05-31
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 wgEncodeGencodeRefSeqVM14.rnaAcc)
      mm10.wgEncodeGencodeAttrsVM14.transcriptId (via wgEncodeGencodeRefSeqVM14.transcriptId)
      mm10.wgEncodeGencodeTagVM14.transcriptId (via wgEncodeGencodeRefSeqVM14.transcriptId)

Sample Rows
 
transcriptIdrnaAccpepAcc
ENSMUST00000070533.4NM_001011874.1NP_001011874.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
ENSMUST00000156816.6NM_001177658.1NP_001171129.1

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