Schema for knownToRefSeq
  Database: mm10    Primary Table: knownToRefSeq    Row Count: 102,339   Data last updated: 2019-09-20
Format description: Map a primary ID to another type of ID, label, quantity etc.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSMUST00000096791.11varchar(255) values primary ID
value NM_009492varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        knownGeneV39.bioCycPathway.kgID (via knownToRefSeq.name)
      knownGeneV39.ceBlastTab.query (via knownToRefSeq.name)
      knownGeneV39.dmBlastTab.query (via knownToRefSeq.name)
      knownGeneV39.drBlastTab.query (via knownToRefSeq.name)
      knownGeneV39.foldUtr3.name (via knownToRefSeq.name)
      knownGeneV39.foldUtr5.name (via knownToRefSeq.name)
      knownGeneV39.gnfAtlas2Distance.query (via knownToRefSeq.name)
      knownGeneV39.gnfAtlas2Distance.target (via knownToRefSeq.name)
      knownGeneV39.kgAlias.kgID (via knownToRefSeq.name)
      knownGeneV39.kgColor.kgID (via knownToRefSeq.name)
      knownGeneV39.kgProtAlias.kgID (via knownToRefSeq.name)
      knownGeneV39.kgSpAlias.kgID (via knownToRefSeq.name)
      knownGeneV39.kgTargetAli.qName (via knownToRefSeq.name)
      knownGeneV39.kgXref.kgID (via knownToRefSeq.name)
      knownGeneV39.knownAttrs.kgID (via knownToRefSeq.name)
      knownGeneV39.knownBlastTab.query (via knownToRefSeq.name)
      knownGeneV39.knownBlastTab.target (via knownToRefSeq.name)
      knownGeneV39.knownCanonical.protein (via knownToRefSeq.name)
      knownGeneV39.knownCanonical.transcript (via knownToRefSeq.name)
      knownGeneV39.knownCds.name (via knownToRefSeq.name)
      knownGeneV39.knownGene.name (via knownToRefSeq.name)
      knownGeneV39.knownGeneMrna.name (via knownToRefSeq.name)
      knownGeneV39.knownGenePep.name (via knownToRefSeq.name)
      knownGeneV39.knownIsoforms.transcript (via knownToRefSeq.name)
      knownGeneV39.knownToEnsembl.name (via knownToRefSeq.name)
      knownGeneV39.knownToGnfAtlas2.name (via knownToRefSeq.name)
      knownGeneV39.knownToHprd.name (via knownToRefSeq.name)
      knownGeneV39.knownToLocusLink.name (via knownToRefSeq.name)
      knownGeneV39.knownToMrna.name (via knownToRefSeq.name)
      knownGeneV39.knownToMrnaSingle.name (via knownToRefSeq.name)
      knownGeneV39.knownToMupit.name (via knownToRefSeq.name)
      knownGeneV39.knownToPfam.name (via knownToRefSeq.name)
      knownGeneV39.knownToRefSeq.name (via knownToRefSeq.name)
      knownGeneV39.knownToSuper.gene (via knownToRefSeq.name)
      knownGeneV39.knownToTag.name (via knownToRefSeq.name)
      knownGeneV39.knownToU133.name (via knownToRefSeq.name)
      knownGeneV39.knownToU95.name (via knownToRefSeq.name)
      knownGeneV39.knownToVisiGene.name (via knownToRefSeq.name)
      knownGeneV39.knownToWikipedia.name (via knownToRefSeq.name)
      knownGeneV39.mmBlastTab.query (via knownToRefSeq.name)
      knownGeneV39.rnBlastTab.query (via knownToRefSeq.name)
      knownGeneV39.scBlastTab.query (via knownToRefSeq.name)
      knownGeneV39.ucscScop.ucscId (via knownToRefSeq.name)
      mm10.bioCycPathway.kgID (via knownToRefSeq.name)
      mm10.ccdsKgMap.geneId (via knownToRefSeq.name)
      mm10.ceBlastTab.query (via knownToRefSeq.name)
      mm10.dmBlastTab.query (via knownToRefSeq.name)
      mm10.drBlastTab.query (via knownToRefSeq.name)
      mm10.foldUtr3.name (via knownToRefSeq.name)
      mm10.foldUtr5.name (via knownToRefSeq.name)
      mm10.hgBlastTab.query (via knownToRefSeq.name)
      mm10.keggPathway.kgID (via knownToRefSeq.name)
      mm10.kgAlias.kgID (via knownToRefSeq.name)
      mm10.kgColor.kgID (via knownToRefSeq.name)
      mm10.kgProtAlias.kgID (via knownToRefSeq.name)
      mm10.kgProtMap2.qName (via knownToRefSeq.name)
      mm10.kgSpAlias.kgID (via knownToRefSeq.name)
      mm10.kgTargetAli.qName (via knownToRefSeq.name)
      mm10.kgTxInfo.name (via knownToRefSeq.name)
      mm10.kgXref.kgID (via knownToRefSeq.name)
      mm10.knownAttrs.kgID (via knownToRefSeq.name)
      mm10.knownBlastTab.query (via knownToRefSeq.name)
      mm10.knownBlastTab.target (via knownToRefSeq.name)
      mm10.knownCanonical.transcript (via knownToRefSeq.name)
      mm10.knownCds.name (via knownToRefSeq.name)
      mm10.knownGene.name (via knownToRefSeq.name)
      mm10.knownGeneMrna.name (via knownToRefSeq.name)
      mm10.knownGenePep.name (via knownToRefSeq.name)
      mm10.knownIsoforms.transcript (via knownToRefSeq.name)
      mm10.knownToEnsembl.name (via knownToRefSeq.name)
      mm10.knownToKeggEntrez.name (via knownToRefSeq.name)
      mm10.knownToLocusLink.name (via knownToRefSeq.name)
      mm10.knownToLynx.name (via knownToRefSeq.name)
      mm10.knownToMrna.name (via knownToRefSeq.name)
      mm10.knownToMrnaSingle.name (via knownToRefSeq.name)
      mm10.knownToPfam.name (via knownToRefSeq.name)
      mm10.knownToSuper.gene (via knownToRefSeq.name)
      mm10.knownToTag.name (via knownToRefSeq.name)
      mm10.knownToVisiGene.name (via knownToRefSeq.name)
      mm10.knownToWikipedia.name (via knownToRefSeq.name)
      mm10.rnBlastTab.query (via knownToRefSeq.name)
      mm10.scBlastTab.query (via knownToRefSeq.name)
      mm10.ucscScop.ucscId (via knownToRefSeq.name)
      hgFixed.gbCdnaInfo.acc (via knownToRefSeq.value)
      hgFixed.gbSeq.acc (via knownToRefSeq.value)
      hgFixed.imageClone.acc (via knownToRefSeq.value)
      hgFixed.refLink.mrnaAcc (via knownToRefSeq.value)
      hgFixed.refSeqStatus.mrnaAcc (via knownToRefSeq.value)
      hgFixed.refSeqSummary.mrnaAcc (via knownToRefSeq.value)
      knownGeneV39.kgXref.refseq (via knownToRefSeq.value)
      knownGeneV39.knownToRefSeq.value (via knownToRefSeq.value)
      mm10.ccdsInfo.mrnaAcc (via knownToRefSeq.value)
      mm10.kgXref.refseq (via knownToRefSeq.value)
      mm10.mrnaOrientInfo.name (via knownToRefSeq.value)
      mm10.refFlat.name (via knownToRefSeq.value)
      mm10.refGene.name (via knownToRefSeq.value)
      mm10.refSeqAli.qName (via knownToRefSeq.value)

Sample Rows
 
namevalue
ENSMUST00000096791.11NM_009492
ENSMUST00000071277.13NM_009488
ENSMUST00000179115.1NM_009492
ENSMUST00000099422.4NM_009488
ENSMUST00000178970.7NM_009488
ENSMUST00000077235.3NM_001033326
ENSMUST00000179505.7NR_003518
ENSMUST00000178343.1NR_003518
ENSMUST00000177783.1NM_001167567
ENSMUST00000177979.1NM_001167568

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