Schema for knownToEnsembl
  Database: hg19    Primary Table: knownToEnsembl    Row Count: 76,178   Data last updated: 2014-03-06
Format description: Map a primary ID to another type of ID, label, quantity etc.
fieldexampleSQL type info description
name uc022bqo.2varchar(255) values primary ID
value ENST00000389680varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg19.bioCycPathway.kgID (via knownToEnsembl.name)
      hg19.ccdsKgMap.geneId (via knownToEnsembl.name)
      hg19.ceBlastTab.query (via knownToEnsembl.name)
      hg19.dmBlastTab.query (via knownToEnsembl.name)
      hg19.drBlastTab.query (via knownToEnsembl.name)
      hg19.foldUtr3.name (via knownToEnsembl.name)
      hg19.foldUtr5.name (via knownToEnsembl.name)
      hg19.gnfAtlas2Distance.query (via knownToEnsembl.name)
      hg19.gnfAtlas2Distance.target (via knownToEnsembl.name)
      hg19.gnfU95Distance.query (via knownToEnsembl.name)
      hg19.gnfU95Distance.target (via knownToEnsembl.name)
      hg19.humanHprdP2P.query (via knownToEnsembl.name)
      hg19.humanHprdP2P.target (via knownToEnsembl.name)
      hg19.humanVidalP2P.query (via knownToEnsembl.name)
      hg19.humanVidalP2P.target (via knownToEnsembl.name)
      hg19.humanWankerP2P.query (via knownToEnsembl.name)
      hg19.humanWankerP2P.target (via knownToEnsembl.name)
      hg19.keggPathway.kgID (via knownToEnsembl.name)
      hg19.kgAlias.kgID (via knownToEnsembl.name)
      hg19.kgColor.kgID (via knownToEnsembl.name)
      hg19.kgProtAlias.kgID (via knownToEnsembl.name)
      hg19.kgProtMap2.qName (via knownToEnsembl.name)
      hg19.kgSpAlias.kgID (via knownToEnsembl.name)
      hg19.kgTargetAli.qName (via knownToEnsembl.name)
      hg19.kgTxInfo.name (via knownToEnsembl.name)
      hg19.kgXref.kgID (via knownToEnsembl.name)
      hg19.knownBlastTab.query (via knownToEnsembl.name)
      hg19.knownBlastTab.target (via knownToEnsembl.name)
      hg19.knownCanonToDecipher.name (via knownToEnsembl.name)
      hg19.knownCanonical.transcript (via knownToEnsembl.name)
      hg19.knownGene.name (via knownToEnsembl.name)
      hg19.knownGeneMrna.name (via knownToEnsembl.name)
      hg19.knownGenePep.name (via knownToEnsembl.name)
      hg19.knownGeneTxMrna.name (via knownToEnsembl.name)
      hg19.knownGeneTxPep.name (via knownToEnsembl.name)
      hg19.knownIsoforms.transcript (via knownToEnsembl.name)
      hg19.knownToAllenBrain.name (via knownToEnsembl.name)
      hg19.knownToDecipher.name (via knownToEnsembl.name)
      hg19.knownToGnfAtlas2.name (via knownToEnsembl.name)
      hg19.knownToHInv.name (via knownToEnsembl.name)
      hg19.knownToHprd.name (via knownToEnsembl.name)
      hg19.knownToKeggEntrez.name (via knownToEnsembl.name)
      hg19.knownToLocusLink.name (via knownToEnsembl.name)
      hg19.knownToLynx.name (via knownToEnsembl.name)
      hg19.knownToMupit.name (via knownToEnsembl.name)
      hg19.knownToNextProt.name (via knownToEnsembl.name)
      hg19.knownToPfam.name (via knownToEnsembl.name)
      hg19.knownToRefSeq.name (via knownToEnsembl.name)
      hg19.knownToSuper.gene (via knownToEnsembl.name)
      hg19.knownToTreefam.name (via knownToEnsembl.name)
      hg19.knownToU133.name (via knownToEnsembl.name)
      hg19.knownToU133Plus2.name (via knownToEnsembl.name)
      hg19.knownToU95.name (via knownToEnsembl.name)
      hg19.knownToVisiGene.name (via knownToEnsembl.name)
      hg19.knownToWikipedia.name (via knownToEnsembl.name)
      hg19.mmBlastTab.query (via knownToEnsembl.name)
      hg19.rnBlastTab.query (via knownToEnsembl.name)
      hg19.scBlastTab.query (via knownToEnsembl.name)
      hg19.ucscScop.ucscId (via knownToEnsembl.name)
      hg19.ensGene.name (via knownToEnsembl.value)
      hg19.ensGtp.transcript (via knownToEnsembl.value)
      hg19.ensPep.name (via knownToEnsembl.value)
      hg19.ensemblSource.name (via knownToEnsembl.value)
      hg19.ensemblToGeneName.name (via knownToEnsembl.value)

Sample Rows
 
namevalue
uc022bqo.2ENST00000389680
uc004cor.1ENST00000387342
uc004cos.5ENST00000387347
uc031tga.1ENST00000361624
uc011mfi.2ENST00000361739
uc022bqu.2ENST00000361227
uc004cov.5ENST00000361381
uc004cow.2ENST00000387449
uc004cox.4ENST00000361567
uc022bqw.1ENST00000361789

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