Schema for knownToDecipher
  Database: hg19    Primary Table: knownToDecipher    Row Count: 3,922,673   Data last updated: 2020-08-10
Format description: Map a primary ID to another type of ID, label, quantity etc.
On download server: MariaDB table dump directory
fieldexampleSQL type description
name uc001aaa.3varchar(255) primary ID
value 1481varchar(255) associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg19.bioCycPathway.kgID (via knownToDecipher.name)
      hg19.ceBlastTab.query (via knownToDecipher.name)
      hg19.dmBlastTab.query (via knownToDecipher.name)
      hg19.drBlastTab.query (via knownToDecipher.name)
      hg19.foldUtr3.name (via knownToDecipher.name)
      hg19.foldUtr5.name (via knownToDecipher.name)
      hg19.gnfAtlas2Distance.query (via knownToDecipher.name)
      hg19.gnfAtlas2Distance.target (via knownToDecipher.name)
      hg19.gnfU95Distance.query (via knownToDecipher.name)
      hg19.gnfU95Distance.target (via knownToDecipher.name)
      hg19.humanHprdP2P.query (via knownToDecipher.name)
      hg19.humanHprdP2P.target (via knownToDecipher.name)
      hg19.humanVidalP2P.query (via knownToDecipher.name)
      hg19.humanVidalP2P.target (via knownToDecipher.name)
      hg19.humanWankerP2P.query (via knownToDecipher.name)
      hg19.humanWankerP2P.target (via knownToDecipher.name)
      hg19.keggPathway.kgID (via knownToDecipher.name)
      hg19.kgAlias.kgID (via knownToDecipher.name)
      hg19.kgColor.kgID (via knownToDecipher.name)
      hg19.kgProtAlias.kgID (via knownToDecipher.name)
      hg19.kgProtMap2.qName (via knownToDecipher.name)
      hg19.kgSpAlias.kgID (via knownToDecipher.name)
      hg19.kgTargetAli.qName (via knownToDecipher.name)
      hg19.kgTxInfo.name (via knownToDecipher.name)
      hg19.kgXref.kgID (via knownToDecipher.name)
      hg19.knownAttrs.kgID (via knownToDecipher.name)
      hg19.knownBlastTab.query (via knownToDecipher.name)
      hg19.knownBlastTab.target (via knownToDecipher.name)
      hg19.knownCanonToDecipher.name (via knownToDecipher.name)
      hg19.knownCanonical.transcript (via knownToDecipher.name)
      hg19.knownCds.name (via knownToDecipher.name)
      hg19.knownGene.name (via knownToDecipher.name)
      hg19.knownGeneMrna.name (via knownToDecipher.name)
      hg19.knownGenePep.name (via knownToDecipher.name)
      hg19.knownGeneTxMrna.name (via knownToDecipher.name)
      hg19.knownGeneTxPep.name (via knownToDecipher.name)
      hg19.knownIsoforms.transcript (via knownToDecipher.name)
      hg19.knownToAllenBrain.name (via knownToDecipher.name)
      hg19.knownToEnsembl.name (via knownToDecipher.name)
      hg19.knownToGnfAtlas2.name (via knownToDecipher.name)
      hg19.knownToHInv.name (via knownToDecipher.name)
      hg19.knownToHprd.name (via knownToDecipher.name)
      hg19.knownToKeggEntrez.name (via knownToDecipher.name)
      hg19.knownToLocusLink.name (via knownToDecipher.name)
      hg19.knownToLynx.name (via knownToDecipher.name)
      hg19.knownToMrna.name (via knownToDecipher.name)
      hg19.knownToMrnaSingle.name (via knownToDecipher.name)
      hg19.knownToMupit.name (via knownToDecipher.name)
      hg19.knownToNextProt.name (via knownToDecipher.name)
      hg19.knownToPfam.name (via knownToDecipher.name)
      hg19.knownToRefSeq.name (via knownToDecipher.name)
      hg19.knownToSuper.gene (via knownToDecipher.name)
      hg19.knownToTag.name (via knownToDecipher.name)
      hg19.knownToTreefam.name (via knownToDecipher.name)
      hg19.knownToU133.name (via knownToDecipher.name)
      hg19.knownToU133Plus2.name (via knownToDecipher.name)
      hg19.knownToU95.name (via knownToDecipher.name)
      hg19.knownToVisiGene.name (via knownToDecipher.name)
      hg19.knownToWikipedia.name (via knownToDecipher.name)
      hg19.mmBlastTab.query (via knownToDecipher.name)
      hg19.rnBlastTab.query (via knownToDecipher.name)
      hg19.scBlastTab.query (via knownToDecipher.name)
      hg19.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)
      hg19.decipher.name (via knownToDecipher.value)
      hg19.decipherRaw.id (via knownToDecipher.value)
      hg19.knownCanonToDecipher.value (via knownToDecipher.value)

Sample Rows
 
namevalue
uc001aaa.31481
uc001aaa.32246
uc001aaa.3263986
uc001aaa.3266575
uc001aaa.3268586
uc001aaa.3272172
uc001aaa.3283043
uc001aaa.3283601
uc001aaa.3286391
uc001aaa.3300695

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