Schema for knownCanonToDecipher
  Database: hg18    Primary Table: knownCanonToDecipher    Row Count: 110,181   Data last updated: 2011-01-11
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 uc009vip.1varchar(255) values primary ID
value 2246varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg18.bioCycPathway.kgID (via knownCanonToDecipher.name)
      hg18.ccdsKgMap.geneId (via knownCanonToDecipher.name)
      hg18.ceBlastTab.query (via knownCanonToDecipher.name)
      hg18.dmBlastTab.query (via knownCanonToDecipher.name)
      hg18.drBlastTab.query (via knownCanonToDecipher.name)
      hg18.foldUtr3.name (via knownCanonToDecipher.name)
      hg18.foldUtr5.name (via knownCanonToDecipher.name)
      hg18.gnfAtlas2Distance.query (via knownCanonToDecipher.name)
      hg18.gnfAtlas2Distance.target (via knownCanonToDecipher.name)
      hg18.gnfU95Distance.query (via knownCanonToDecipher.name)
      hg18.gnfU95Distance.target (via knownCanonToDecipher.name)
      hg18.humanHprdP2P.query (via knownCanonToDecipher.name)
      hg18.humanHprdP2P.target (via knownCanonToDecipher.name)
      hg18.humanVidalP2P.query (via knownCanonToDecipher.name)
      hg18.humanVidalP2P.target (via knownCanonToDecipher.name)
      hg18.humanWankerP2P.query (via knownCanonToDecipher.name)
      hg18.humanWankerP2P.target (via knownCanonToDecipher.name)
      hg18.keggPathway.kgID (via knownCanonToDecipher.name)
      hg18.kgAlias.kgID (via knownCanonToDecipher.name)
      hg18.kgColor.kgID (via knownCanonToDecipher.name)
      hg18.kgProtAlias.kgID (via knownCanonToDecipher.name)
      hg18.kgProtMap2.qName (via knownCanonToDecipher.name)
      hg18.kgSpAlias.kgID (via knownCanonToDecipher.name)
      hg18.kgTargetAli.qName (via knownCanonToDecipher.name)
      hg18.kgTxInfo.name (via knownCanonToDecipher.name)
      hg18.kgXref.kgID (via knownCanonToDecipher.name)
      hg18.knownBlastTab.query (via knownCanonToDecipher.name)
      hg18.knownBlastTab.target (via knownCanonToDecipher.name)
      hg18.knownCanonical.protein (via knownCanonToDecipher.name)
      hg18.knownCanonical.transcript (via knownCanonToDecipher.name)
      hg18.knownGene.name (via knownCanonToDecipher.name)
      hg18.knownGeneMrna.name (via knownCanonToDecipher.name)
      hg18.knownGenePep.name (via knownCanonToDecipher.name)
      hg18.knownIsoforms.transcript (via knownCanonToDecipher.name)
      hg18.knownToAllenBrain.name (via knownCanonToDecipher.name)
      hg18.knownToDecipher.name (via knownCanonToDecipher.name)
      hg18.knownToEnsembl.name (via knownCanonToDecipher.name)
      hg18.knownToGnf1h.name (via knownCanonToDecipher.name)
      hg18.knownToGnfAtlas2.name (via knownCanonToDecipher.name)
      hg18.knownToHInv.name (via knownCanonToDecipher.name)
      hg18.knownToHprd.name (via knownCanonToDecipher.name)
      hg18.knownToKeggEntrez.name (via knownCanonToDecipher.name)
      hg18.knownToLocusLink.name (via knownCanonToDecipher.name)
      hg18.knownToMupit.name (via knownCanonToDecipher.name)
      hg18.knownToPfam.name (via knownCanonToDecipher.name)
      hg18.knownToRefSeq.name (via knownCanonToDecipher.name)
      hg18.knownToSuper.gene (via knownCanonToDecipher.name)
      hg18.knownToTreefam.name (via knownCanonToDecipher.name)
      hg18.knownToU133.name (via knownCanonToDecipher.name)
      hg18.knownToU133Plus2.name (via knownCanonToDecipher.name)
      hg18.knownToU95.name (via knownCanonToDecipher.name)
      hg18.knownToVisiGene.name (via knownCanonToDecipher.name)
      hg18.mmBlastTab.query (via knownCanonToDecipher.name)
      hg18.rnBlastTab.query (via knownCanonToDecipher.name)
      hg18.scBlastTab.query (via knownCanonToDecipher.name)
      hg18.ucscScop.ucscId (via knownCanonToDecipher.name)
      knownGeneV39.bioCycPathway.kgID (via knownCanonToDecipher.name)
      knownGeneV39.ceBlastTab.query (via knownCanonToDecipher.name)
      knownGeneV39.dmBlastTab.query (via knownCanonToDecipher.name)
      knownGeneV39.drBlastTab.query (via knownCanonToDecipher.name)
      knownGeneV39.foldUtr3.name (via knownCanonToDecipher.name)
      knownGeneV39.foldUtr5.name (via knownCanonToDecipher.name)
      knownGeneV39.gnfAtlas2Distance.query (via knownCanonToDecipher.name)
      knownGeneV39.gnfAtlas2Distance.target (via knownCanonToDecipher.name)
      knownGeneV39.kgAlias.kgID (via knownCanonToDecipher.name)
      knownGeneV39.kgColor.kgID (via knownCanonToDecipher.name)
      knownGeneV39.kgProtAlias.kgID (via knownCanonToDecipher.name)
      knownGeneV39.kgSpAlias.kgID (via knownCanonToDecipher.name)
      knownGeneV39.kgTargetAli.qName (via knownCanonToDecipher.name)
      knownGeneV39.kgXref.kgID (via knownCanonToDecipher.name)
      knownGeneV39.knownAttrs.kgID (via knownCanonToDecipher.name)
      knownGeneV39.knownBlastTab.query (via knownCanonToDecipher.name)
      knownGeneV39.knownBlastTab.target (via knownCanonToDecipher.name)
      knownGeneV39.knownCanonical.protein (via knownCanonToDecipher.name)
      knownGeneV39.knownCanonical.transcript (via knownCanonToDecipher.name)
      knownGeneV39.knownCds.name (via knownCanonToDecipher.name)
      knownGeneV39.knownGene.name (via knownCanonToDecipher.name)
      knownGeneV39.knownGeneMrna.name (via knownCanonToDecipher.name)
      knownGeneV39.knownGenePep.name (via knownCanonToDecipher.name)
      knownGeneV39.knownIsoforms.transcript (via knownCanonToDecipher.name)
      knownGeneV39.knownToEnsembl.name (via knownCanonToDecipher.name)
      knownGeneV39.knownToGnfAtlas2.name (via knownCanonToDecipher.name)
      knownGeneV39.knownToHprd.name (via knownCanonToDecipher.name)
      knownGeneV39.knownToLocusLink.name (via knownCanonToDecipher.name)
      knownGeneV39.knownToMrna.name (via knownCanonToDecipher.name)
      knownGeneV39.knownToMrnaSingle.name (via knownCanonToDecipher.name)
      knownGeneV39.knownToMupit.name (via knownCanonToDecipher.name)
      knownGeneV39.knownToPfam.name (via knownCanonToDecipher.name)
      knownGeneV39.knownToRefSeq.name (via knownCanonToDecipher.name)
      knownGeneV39.knownToSuper.gene (via knownCanonToDecipher.name)
      knownGeneV39.knownToTag.name (via knownCanonToDecipher.name)
      knownGeneV39.knownToU133.name (via knownCanonToDecipher.name)
      knownGeneV39.knownToU95.name (via knownCanonToDecipher.name)
      knownGeneV39.knownToVisiGene.name (via knownCanonToDecipher.name)
      knownGeneV39.knownToWikipedia.name (via knownCanonToDecipher.name)
      knownGeneV39.mmBlastTab.query (via knownCanonToDecipher.name)
      knownGeneV39.rnBlastTab.query (via knownCanonToDecipher.name)
      knownGeneV39.scBlastTab.query (via knownCanonToDecipher.name)
      knownGeneV39.ucscScop.ucscId (via knownCanonToDecipher.name)
      hg18.decipher.name (via knownCanonToDecipher.value)
      hg18.decipherRaw.id (via knownCanonToDecipher.value)
      hg18.knownToDecipher.value (via knownCanonToDecipher.value)

Sample Rows
 
namevalue
uc009vip.12246
uc009vip.11481
uc009viw.12246
uc009viw.11481
uc009vjg.12246
uc009vjg.11481
uc001aak.12246
uc001aak.11481
uc001aal.12246
uc001aal.11481

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