Schema for knownToHprd
  Database: hg18    Primary Table: knownToHprd    Row Count: 22,081   Data last updated: 2009-03-04
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 uc004ajd.1varchar(255) values primary ID
value 00001varchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
uc004ajd.100001
uc001ocx.100002
uc001tst.100003
uc009zvy.100003
uc002gwj.100004
uc004aay.100005
uc010kjy.100006
uc002uje.200007
uc002ujd.200007
uc002fzk.100008

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