Schema for knownToHprd
  Database: hg19    Primary Table: knownToHprd    Row Count: 28,770   Data last updated: 2013-06-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 uc004ajd.3varchar(255) values primary ID
value 00001varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg19.bioCycPathway.kgID (via knownToHprd.name)
      hg19.ceBlastTab.query (via knownToHprd.name)
      hg19.dmBlastTab.query (via knownToHprd.name)
      hg19.drBlastTab.query (via knownToHprd.name)
      hg19.foldUtr3.name (via knownToHprd.name)
      hg19.foldUtr5.name (via knownToHprd.name)
      hg19.gnfAtlas2Distance.query (via knownToHprd.name)
      hg19.gnfAtlas2Distance.target (via knownToHprd.name)
      hg19.gnfU95Distance.query (via knownToHprd.name)
      hg19.gnfU95Distance.target (via knownToHprd.name)
      hg19.humanHprdP2P.query (via knownToHprd.name)
      hg19.humanHprdP2P.target (via knownToHprd.name)
      hg19.humanVidalP2P.query (via knownToHprd.name)
      hg19.humanVidalP2P.target (via knownToHprd.name)
      hg19.humanWankerP2P.query (via knownToHprd.name)
      hg19.humanWankerP2P.target (via knownToHprd.name)
      hg19.keggPathway.kgID (via knownToHprd.name)
      hg19.kgAlias.kgID (via knownToHprd.name)
      hg19.kgColor.kgID (via knownToHprd.name)
      hg19.kgProtAlias.kgID (via knownToHprd.name)
      hg19.kgProtMap2.qName (via knownToHprd.name)
      hg19.kgSpAlias.kgID (via knownToHprd.name)
      hg19.kgTargetAli.qName (via knownToHprd.name)
      hg19.kgTxInfo.name (via knownToHprd.name)
      hg19.kgXref.kgID (via knownToHprd.name)
      hg19.knownAttrs.kgID (via knownToHprd.name)
      hg19.knownBlastTab.query (via knownToHprd.name)
      hg19.knownBlastTab.target (via knownToHprd.name)
      hg19.knownCanonToDecipher.name (via knownToHprd.name)
      hg19.knownCanonical.transcript (via knownToHprd.name)
      hg19.knownCds.name (via knownToHprd.name)
      hg19.knownGene.name (via knownToHprd.name)
      hg19.knownGeneMrna.name (via knownToHprd.name)
      hg19.knownGenePep.name (via knownToHprd.name)
      hg19.knownGeneTxMrna.name (via knownToHprd.name)
      hg19.knownGeneTxPep.name (via knownToHprd.name)
      hg19.knownIsoforms.transcript (via knownToHprd.name)
      hg19.knownToAllenBrain.name (via knownToHprd.name)
      hg19.knownToDecipher.name (via knownToHprd.name)
      hg19.knownToEnsembl.name (via knownToHprd.name)
      hg19.knownToGnfAtlas2.name (via knownToHprd.name)
      hg19.knownToHInv.name (via knownToHprd.name)
      hg19.knownToKeggEntrez.name (via knownToHprd.name)
      hg19.knownToLocusLink.name (via knownToHprd.name)
      hg19.knownToLynx.name (via knownToHprd.name)
      hg19.knownToMrna.name (via knownToHprd.name)
      hg19.knownToMrnaSingle.name (via knownToHprd.name)
      hg19.knownToMupit.name (via knownToHprd.name)
      hg19.knownToNextProt.name (via knownToHprd.name)
      hg19.knownToPfam.name (via knownToHprd.name)
      hg19.knownToRefSeq.name (via knownToHprd.name)
      hg19.knownToSuper.gene (via knownToHprd.name)
      hg19.knownToTag.name (via knownToHprd.name)
      hg19.knownToTreefam.name (via knownToHprd.name)
      hg19.knownToU133.name (via knownToHprd.name)
      hg19.knownToU133Plus2.name (via knownToHprd.name)
      hg19.knownToU95.name (via knownToHprd.name)
      hg19.knownToVisiGene.name (via knownToHprd.name)
      hg19.knownToWikipedia.name (via knownToHprd.name)
      hg19.mmBlastTab.query (via knownToHprd.name)
      hg19.rnBlastTab.query (via knownToHprd.name)
      hg19.scBlastTab.query (via knownToHprd.name)
      hg19.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.300001
uc011lsg.200001
uc011lsh.200001
uc001ocx.300002
uc001tst.300003
uc002gwj.300004
uc004aay.300005
uc022bgy.100005
uc010kjy.300006
uc002ujd.200007

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