Schema for knownToEnsembl
  Database: hg18    Primary Table: knownToEnsembl    Row Count: 60,456   Data last updated: 2009-08-05
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 uc004fqd.1varchar(255) values primary ID
value ENST00000402072varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg18.bioCycPathway.kgID (via knownToEnsembl.name)
      hg18.ccdsKgMap.geneId (via knownToEnsembl.name)
      hg18.ceBlastTab.query (via knownToEnsembl.name)
      hg18.dmBlastTab.query (via knownToEnsembl.name)
      hg18.drBlastTab.query (via knownToEnsembl.name)
      hg18.foldUtr3.name (via knownToEnsembl.name)
      hg18.foldUtr5.name (via knownToEnsembl.name)
      hg18.gnfAtlas2Distance.query (via knownToEnsembl.name)
      hg18.gnfAtlas2Distance.target (via knownToEnsembl.name)
      hg18.gnfU95Distance.query (via knownToEnsembl.name)
      hg18.gnfU95Distance.target (via knownToEnsembl.name)
      hg18.humanHprdP2P.query (via knownToEnsembl.name)
      hg18.humanHprdP2P.target (via knownToEnsembl.name)
      hg18.humanVidalP2P.query (via knownToEnsembl.name)
      hg18.humanVidalP2P.target (via knownToEnsembl.name)
      hg18.humanWankerP2P.query (via knownToEnsembl.name)
      hg18.humanWankerP2P.target (via knownToEnsembl.name)
      hg18.keggPathway.kgID (via knownToEnsembl.name)
      hg18.kgAlias.kgID (via knownToEnsembl.name)
      hg18.kgColor.kgID (via knownToEnsembl.name)
      hg18.kgProtAlias.kgID (via knownToEnsembl.name)
      hg18.kgProtMap2.qName (via knownToEnsembl.name)
      hg18.kgSpAlias.kgID (via knownToEnsembl.name)
      hg18.kgTargetAli.qName (via knownToEnsembl.name)
      hg18.kgTxInfo.name (via knownToEnsembl.name)
      hg18.kgXref.kgID (via knownToEnsembl.name)
      hg18.knownBlastTab.query (via knownToEnsembl.name)
      hg18.knownBlastTab.target (via knownToEnsembl.name)
      hg18.knownCanonToDecipher.name (via knownToEnsembl.name)
      hg18.knownCanonical.protein (via knownToEnsembl.name)
      hg18.knownCanonical.transcript (via knownToEnsembl.name)
      hg18.knownGene.name (via knownToEnsembl.name)
      hg18.knownGeneMrna.name (via knownToEnsembl.name)
      hg18.knownGenePep.name (via knownToEnsembl.name)
      hg18.knownIsoforms.transcript (via knownToEnsembl.name)
      hg18.knownToAllenBrain.name (via knownToEnsembl.name)
      hg18.knownToDecipher.name (via knownToEnsembl.name)
      hg18.knownToGnf1h.name (via knownToEnsembl.name)
      hg18.knownToGnfAtlas2.name (via knownToEnsembl.name)
      hg18.knownToHInv.name (via knownToEnsembl.name)
      hg18.knownToHprd.name (via knownToEnsembl.name)
      hg18.knownToKeggEntrez.name (via knownToEnsembl.name)
      hg18.knownToLocusLink.name (via knownToEnsembl.name)
      hg18.knownToMupit.name (via knownToEnsembl.name)
      hg18.knownToPfam.name (via knownToEnsembl.name)
      hg18.knownToRefSeq.name (via knownToEnsembl.name)
      hg18.knownToSuper.gene (via knownToEnsembl.name)
      hg18.knownToTreefam.name (via knownToEnsembl.name)
      hg18.knownToU133.name (via knownToEnsembl.name)
      hg18.knownToU133Plus2.name (via knownToEnsembl.name)
      hg18.knownToU95.name (via knownToEnsembl.name)
      hg18.knownToVisiGene.name (via knownToEnsembl.name)
      hg18.mmBlastTab.query (via knownToEnsembl.name)
      hg18.rnBlastTab.query (via knownToEnsembl.name)
      hg18.scBlastTab.query (via knownToEnsembl.name)
      hg18.ucscScop.ucscId (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)
      hg18.ensGene.name (via knownToEnsembl.value)
      hg18.ensGtp.transcript (via knownToEnsembl.value)
      hg18.ensPep.name (via knownToEnsembl.value)
      hg18.ensemblToGeneName.name (via knownToEnsembl.value)
      knownGeneV39.knownToEnsembl.value (via knownToEnsembl.value)

Sample Rows
 
namevalue
uc004fqd.1ENST00000402072
uc004fqe.1ENST00000250784
uc004fqf.1ENST00000250784
uc004fqh.1ENST00000402072
uc004fqi.1ENST00000250784
uc010nwd.1ENST00000383052
uc004fqj.1ENST00000155093
uc010nwe.1ENST00000155093
uc004fqk.1ENST00000321217
uc010nwf.1ENST00000321217

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