Schema for knownToEnsembl
  Database: hg17    Primary Table: knownToEnsembl    Row Count: 35,521   Data last updated: 2005-06-04
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_001008varchar(255) values primary ID
value ENST00000250784varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg17.bioCycPathway.kgID (via knownToEnsembl.name)
      hg17.ccdsKgMap.geneId (via knownToEnsembl.name)
      hg17.ceBlastTab.query (via knownToEnsembl.name)
      hg17.dmBlastTab.query (via knownToEnsembl.name)
      hg17.drBlastTab.query (via knownToEnsembl.name)
      hg17.dupSpMrna.mrnaID (via knownToEnsembl.name)
      hg17.foldUtr3.name (via knownToEnsembl.name)
      hg17.foldUtr5.name (via knownToEnsembl.name)
      hg17.gladHumESDistance.query (via knownToEnsembl.name)
      hg17.gladHumESDistance.target (via knownToEnsembl.name)
      hg17.gnfAtlas2Distance.query (via knownToEnsembl.name)
      hg17.gnfAtlas2Distance.target (via knownToEnsembl.name)
      hg17.gnfU95Distance.query (via knownToEnsembl.name)
      hg17.gnfU95Distance.target (via knownToEnsembl.name)
      hg17.humanHprdP2P.query (via knownToEnsembl.name)
      hg17.humanHprdP2P.target (via knownToEnsembl.name)
      hg17.humanVidalP2P.query (via knownToEnsembl.name)
      hg17.humanVidalP2P.target (via knownToEnsembl.name)
      hg17.humanWankerP2P.query (via knownToEnsembl.name)
      hg17.humanWankerP2P.target (via knownToEnsembl.name)
      hg17.keggPathway.kgID (via knownToEnsembl.name)
      hg17.kgAlias.kgID (via knownToEnsembl.name)
      hg17.kgProtAlias.kgID (via knownToEnsembl.name)
      hg17.kgSpAlias.kgID (via knownToEnsembl.name)
      hg17.kgTargetAli.qName (via knownToEnsembl.name)
      hg17.kgXref.kgID (via knownToEnsembl.name)
      hg17.knownBlastTab.query (via knownToEnsembl.name)
      hg17.knownBlastTab.target (via knownToEnsembl.name)
      hg17.knownCanonical.transcript (via knownToEnsembl.name)
      hg17.knownExpDistance.query (via knownToEnsembl.name)
      hg17.knownExpDistance.target (via knownToEnsembl.name)
      hg17.knownGene.name (via knownToEnsembl.name)
      hg17.knownGeneLink.name (via knownToEnsembl.name)
      hg17.knownGeneMrna.name (via knownToEnsembl.name)
      hg17.knownGenePep.name (via knownToEnsembl.name)
      hg17.knownIsoforms.transcript (via knownToEnsembl.name)
      hg17.knownToAllenBrain.name (via knownToEnsembl.name)
      hg17.knownToGnf1h.name (via knownToEnsembl.name)
      hg17.knownToGnfAtlas2.name (via knownToEnsembl.name)
      hg17.knownToHInv.name (via knownToEnsembl.name)
      hg17.knownToHprd.name (via knownToEnsembl.name)
      hg17.knownToKeggEntrez.name (via knownToEnsembl.name)
      hg17.knownToLocusLink.name (via knownToEnsembl.name)
      hg17.knownToPfam.name (via knownToEnsembl.name)
      hg17.knownToRefSeq.name (via knownToEnsembl.name)
      hg17.knownToSuper.gene (via knownToEnsembl.name)
      hg17.knownToU133.name (via knownToEnsembl.name)
      hg17.knownToU133Plus2.name (via knownToEnsembl.name)
      hg17.knownToU95.name (via knownToEnsembl.name)
      hg17.knownToVisiGene.name (via knownToEnsembl.name)
      hg17.mmBlastTab.query (via knownToEnsembl.name)
      hg17.rankProp.query (via knownToEnsembl.name)
      hg17.rankProp.target (via knownToEnsembl.name)
      hg17.rnBlastTab.query (via knownToEnsembl.name)
      hg17.scBlastTab.query (via knownToEnsembl.name)
      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)
      hg17.ensGene.name (via knownToEnsembl.value)
      hg17.ensGtp.transcript (via knownToEnsembl.value)
      hg17.ensPep.name (via knownToEnsembl.value)
      knownGeneV39.knownToEnsembl.value (via knownToEnsembl.value)

Sample Rows
 
namevalue
NM_001008ENST00000250784
NM_003411ENST00000155093
NM_139214ENST00000321217
NM_032971ENST00000333703
NM_032972ENST00000333703
NM_032973ENST00000215473
NM_022573ENST00000320701
AY130858ENST00000320701
AK056903ENST00000355162
NM_033284ENST00000346432

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