Schema for knownToMupit
  Database: hg18    Primary Table: knownToMupit    Row Count: 28,177   Data last updated: 2019-08-14
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 uc001acj.2varchar(255) values primary ID
value 1Z2Mvarchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
uc001acj.21Z2M
uc001acj.23SDL
uc001acj.22HJ8
uc001acj.23PHX
uc001acj.23PSE
uc001acj.23R66
uc001acj.23RT3
uc001ade.11D0A
uc001ade.12HEV
uc001ade.12HEY

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