Schema for knownToDecipher
  Database: hg18    Primary Table: knownToDecipher    Row Count: 280,093   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 uc004fou.1varchar(255) values primary ID
value 253249varchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
uc004fou.1253249
uc004fov.1253249
uc004fow.1253249
uc010nwg.1251637
uc004fqp.1251637
uc004fql.1251637
uc004fqm.1251637
uc004fqn.1251637
uc004fqo.1251637
uc004fra.1253561

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