Schema for knownCanonToDecipher
  Database: hg19    Primary Table: knownCanonToDecipher    Row Count: 1,567,567   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 uc001aak.3varchar(255) primary ID
value 1481varchar(255) associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
uc001aak.31481
uc001aak.32246
uc001aak.3263986
uc001aak.3266575
uc001aak.3268586
uc001aak.3272172
uc001aak.3276493
uc001aak.3283043
uc001aak.3283601
uc001aak.3286391

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