Schema for knownToEnsembl
  Database: mm9    Primary Table: knownToEnsembl    Row Count: 50,601   Data last updated: 2011-10-12
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 uc009vfm.1varchar(255) values primary ID
value ENSMUST00000163671varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        knownGeneV39.bioCycPathway.kgID (via knownToEnsembl.name)
      knownGeneV39.ceBlastTab.query (via knownToEnsembl.name)
      knownGeneV39.dmBlastTab.query (via knownToEnsembl.name)
      knownGeneV39.drBlastTab.query (via knownToEnsembl.name)
      knownGeneV39.foldUtr3.name (via knownToEnsembl.name)
      knownGeneV39.foldUtr5.name (via knownToEnsembl.name)
      knownGeneV39.gnfAtlas2Distance.query (via knownToEnsembl.name)
      knownGeneV39.gnfAtlas2Distance.target (via knownToEnsembl.name)
      knownGeneV39.kgAlias.kgID (via knownToEnsembl.name)
      knownGeneV39.kgColor.kgID (via knownToEnsembl.name)
      knownGeneV39.kgProtAlias.kgID (via knownToEnsembl.name)
      knownGeneV39.kgSpAlias.kgID (via knownToEnsembl.name)
      knownGeneV39.kgTargetAli.qName (via knownToEnsembl.name)
      knownGeneV39.kgXref.kgID (via knownToEnsembl.name)
      knownGeneV39.knownAttrs.kgID (via knownToEnsembl.name)
      knownGeneV39.knownBlastTab.query (via knownToEnsembl.name)
      knownGeneV39.knownBlastTab.target (via knownToEnsembl.name)
      knownGeneV39.knownCanonical.protein (via knownToEnsembl.name)
      knownGeneV39.knownCanonical.transcript (via knownToEnsembl.name)
      knownGeneV39.knownCds.name (via knownToEnsembl.name)
      knownGeneV39.knownGene.name (via knownToEnsembl.name)
      knownGeneV39.knownGeneMrna.name (via knownToEnsembl.name)
      knownGeneV39.knownGenePep.name (via knownToEnsembl.name)
      knownGeneV39.knownIsoforms.transcript (via knownToEnsembl.name)
      knownGeneV39.knownToEnsembl.name (via knownToEnsembl.name)
      knownGeneV39.knownToGnfAtlas2.name (via knownToEnsembl.name)
      knownGeneV39.knownToHprd.name (via knownToEnsembl.name)
      knownGeneV39.knownToLocusLink.name (via knownToEnsembl.name)
      knownGeneV39.knownToMrna.name (via knownToEnsembl.name)
      knownGeneV39.knownToMrnaSingle.name (via knownToEnsembl.name)
      knownGeneV39.knownToMupit.name (via knownToEnsembl.name)
      knownGeneV39.knownToPfam.name (via knownToEnsembl.name)
      knownGeneV39.knownToRefSeq.name (via knownToEnsembl.name)
      knownGeneV39.knownToSuper.gene (via knownToEnsembl.name)
      knownGeneV39.knownToTag.name (via knownToEnsembl.name)
      knownGeneV39.knownToU133.name (via knownToEnsembl.name)
      knownGeneV39.knownToU95.name (via knownToEnsembl.name)
      knownGeneV39.knownToVisiGene.name (via knownToEnsembl.name)
      knownGeneV39.knownToWikipedia.name (via knownToEnsembl.name)
      knownGeneV39.mmBlastTab.query (via knownToEnsembl.name)
      knownGeneV39.rnBlastTab.query (via knownToEnsembl.name)
      knownGeneV39.scBlastTab.query (via knownToEnsembl.name)
      knownGeneV39.ucscScop.ucscId (via knownToEnsembl.name)
      mm9.affyGnfU74ADistance.query (via knownToEnsembl.name)
      mm9.affyGnfU74ADistance.target (via knownToEnsembl.name)
      mm9.affyGnfU74BDistance.query (via knownToEnsembl.name)
      mm9.affyGnfU74BDistance.target (via knownToEnsembl.name)
      mm9.affyGnfU74CDistance.query (via knownToEnsembl.name)
      mm9.affyGnfU74CDistance.target (via knownToEnsembl.name)
      mm9.bioCycPathway.kgID (via knownToEnsembl.name)
      mm9.ccdsKgMap.geneId (via knownToEnsembl.name)
      mm9.ceBlastTab.query (via knownToEnsembl.name)
      mm9.dmBlastTab.query (via knownToEnsembl.name)
      mm9.drBlastTab.query (via knownToEnsembl.name)
      mm9.foldUtr3.name (via knownToEnsembl.name)
      mm9.foldUtr5.name (via knownToEnsembl.name)
      mm9.gnfAtlas2Distance.query (via knownToEnsembl.name)
      mm9.gnfAtlas2Distance.target (via knownToEnsembl.name)
      mm9.hgBlastTab.query (via knownToEnsembl.name)
      mm9.keggPathway.kgID (via knownToEnsembl.name)
      mm9.kgAlias.kgID (via knownToEnsembl.name)
      mm9.kgColor.kgID (via knownToEnsembl.name)
      mm9.kgProtAlias.kgID (via knownToEnsembl.name)
      mm9.kgProtMap2.qName (via knownToEnsembl.name)
      mm9.kgSpAlias.kgID (via knownToEnsembl.name)
      mm9.kgTargetAli.qName (via knownToEnsembl.name)
      mm9.kgTxInfo.name (via knownToEnsembl.name)
      mm9.kgXref.kgID (via knownToEnsembl.name)
      mm9.knownBlastTab.query (via knownToEnsembl.name)
      mm9.knownBlastTab.target (via knownToEnsembl.name)
      mm9.knownCanonical.protein (via knownToEnsembl.name)
      mm9.knownCanonical.transcript (via knownToEnsembl.name)
      mm9.knownGene.name (via knownToEnsembl.name)
      mm9.knownGeneMrna.name (via knownToEnsembl.name)
      mm9.knownGenePep.name (via knownToEnsembl.name)
      mm9.knownIsoforms.transcript (via knownToEnsembl.name)
      mm9.knownToAllenBrain.name (via knownToEnsembl.name)
      mm9.knownToGnfAtlas2.name (via knownToEnsembl.name)
      mm9.knownToKeggEntrez.name (via knownToEnsembl.name)
      mm9.knownToLocusLink.name (via knownToEnsembl.name)
      mm9.knownToPfam.name (via knownToEnsembl.name)
      mm9.knownToRefSeq.name (via knownToEnsembl.name)
      mm9.knownToSuper.gene (via knownToEnsembl.name)
      mm9.knownToVisiGene.name (via knownToEnsembl.name)
      mm9.rnBlastTab.query (via knownToEnsembl.name)
      mm9.scBlastTab.query (via knownToEnsembl.name)
      mm9.ucscScop.ucscId (via knownToEnsembl.name)
      knownGeneV39.knownToEnsembl.value (via knownToEnsembl.value)
      mm9.ensGene.name (via knownToEnsembl.value)
      mm9.ensGtp.transcript (via knownToEnsembl.value)
      mm9.ensPep.name (via knownToEnsembl.value)
      mm9.ensemblSource.name (via knownToEnsembl.value)
      mm9.ensemblToGeneName.name (via knownToEnsembl.value)

Sample Rows
 
namevalue
uc009vfm.1ENSMUST00000163671
uc009vfq.1ENSMUST00000111374
uc012hsg.1ENSMUST00000170889
uc009vgg.1ENSMUST00000105221
uc012hsn.1ENSMUST00000166856
uc012hsq.1ENSMUST00000168829
uc009vgl.1ENSMUST00000165290
uc009vgt.1ENSMUST00000115973
uc009vgv.1ENSMUST00000104945
uc009vgz.1ENSMUST00000115508

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