Schema for knownToEnsembl
  Database: mm7    Primary Table: knownToEnsembl    Row Count: 28,862   Data last updated: 2006-06-22
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 NM_172252varchar(255) values primary ID
value ENSMUST00000025745varchar(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)
      mm7.affyGnfU74ADistance.query (via knownToEnsembl.name)
      mm7.affyGnfU74ADistance.target (via knownToEnsembl.name)
      mm7.affyGnfU74BDistance.query (via knownToEnsembl.name)
      mm7.affyGnfU74BDistance.target (via knownToEnsembl.name)
      mm7.affyGnfU74CDistance.query (via knownToEnsembl.name)
      mm7.affyGnfU74CDistance.target (via knownToEnsembl.name)
      mm7.dmBlastTab.query (via knownToEnsembl.name)
      mm7.drBlastTab.query (via knownToEnsembl.name)
      mm7.dupSpMrna.mrnaID (via knownToEnsembl.name)
      mm7.foldUtr3.name (via knownToEnsembl.name)
      mm7.foldUtr5.name (via knownToEnsembl.name)
      mm7.gnfAtlas2Distance.query (via knownToEnsembl.name)
      mm7.gnfAtlas2Distance.target (via knownToEnsembl.name)
      mm7.hgBlastTab.query (via knownToEnsembl.name)
      mm7.keggPathway.kgID (via knownToEnsembl.name)
      mm7.kgAlias.kgID (via knownToEnsembl.name)
      mm7.kgProtAlias.kgID (via knownToEnsembl.name)
      mm7.kgSpAlias.kgID (via knownToEnsembl.name)
      mm7.kgXref.kgID (via knownToEnsembl.name)
      mm7.knownBlastTab.query (via knownToEnsembl.name)
      mm7.knownBlastTab.target (via knownToEnsembl.name)
      mm7.knownCanonical.transcript (via knownToEnsembl.name)
      mm7.knownGene.name (via knownToEnsembl.name)
      mm7.knownGeneLink.name (via knownToEnsembl.name)
      mm7.knownGeneMrna.name (via knownToEnsembl.name)
      mm7.knownGenePep.name (via knownToEnsembl.name)
      mm7.knownIsoforms.transcript (via knownToEnsembl.name)
      mm7.knownToAllenBrain.name (via knownToEnsembl.name)
      mm7.knownToGnfAtlas2.name (via knownToEnsembl.name)
      mm7.knownToKeggEntrez.name (via knownToEnsembl.name)
      mm7.knownToLocusLink.name (via knownToEnsembl.name)
      mm7.knownToPfam.name (via knownToEnsembl.name)
      mm7.knownToRefSeq.name (via knownToEnsembl.name)
      mm7.knownToVisiGene.name (via knownToEnsembl.name)
      mm7.rnBlastTab.query (via knownToEnsembl.name)
      mm7.scBlastTab.query (via knownToEnsembl.name)
      knownGeneV39.knownToEnsembl.value (via knownToEnsembl.value)
      mm7.ensGene.name (via knownToEnsembl.value)
      mm7.ensGtp.transcript (via knownToEnsembl.value)
      mm7.ensPep.name (via knownToEnsembl.value)

Sample Rows
 
namevalue
NM_172252ENSMUST00000025745
BC028768ENSMUST00000025743
NM_013495ENSMUST00000025835
BC024377ENSMUST00000025840
AK015732ENSMUST00000025840
NM_028077ENSMUST00000039048
NM_144871ENSMUST00000052699
AY555192ENSMUST00000052699
AK082660ENSMUST00000052699
BC011214ENSMUST00000052699

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