Schema for knownToHprd
  Database: hg17    Primary Table: knownToHprd    Row Count: 19,345   Data last updated: 2006-09-11
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 AB002292varchar(255) values primary ID
value 09735varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg17.bioCycPathway.kgID (via knownToHprd.name)
      hg17.ccdsKgMap.geneId (via knownToHprd.name)
      hg17.ceBlastTab.query (via knownToHprd.name)
      hg17.dmBlastTab.query (via knownToHprd.name)
      hg17.drBlastTab.query (via knownToHprd.name)
      hg17.dupSpMrna.mrnaID (via knownToHprd.name)
      hg17.foldUtr3.name (via knownToHprd.name)
      hg17.foldUtr5.name (via knownToHprd.name)
      hg17.gladHumESDistance.query (via knownToHprd.name)
      hg17.gladHumESDistance.target (via knownToHprd.name)
      hg17.gnfAtlas2Distance.query (via knownToHprd.name)
      hg17.gnfAtlas2Distance.target (via knownToHprd.name)
      hg17.gnfU95Distance.query (via knownToHprd.name)
      hg17.gnfU95Distance.target (via knownToHprd.name)
      hg17.humanHprdP2P.query (via knownToHprd.name)
      hg17.humanHprdP2P.target (via knownToHprd.name)
      hg17.humanVidalP2P.query (via knownToHprd.name)
      hg17.humanVidalP2P.target (via knownToHprd.name)
      hg17.humanWankerP2P.query (via knownToHprd.name)
      hg17.humanWankerP2P.target (via knownToHprd.name)
      hg17.keggPathway.kgID (via knownToHprd.name)
      hg17.kgAlias.kgID (via knownToHprd.name)
      hg17.kgProtAlias.kgID (via knownToHprd.name)
      hg17.kgSpAlias.kgID (via knownToHprd.name)
      hg17.kgTargetAli.qName (via knownToHprd.name)
      hg17.kgXref.kgID (via knownToHprd.name)
      hg17.knownBlastTab.query (via knownToHprd.name)
      hg17.knownBlastTab.target (via knownToHprd.name)
      hg17.knownCanonical.transcript (via knownToHprd.name)
      hg17.knownExpDistance.query (via knownToHprd.name)
      hg17.knownExpDistance.target (via knownToHprd.name)
      hg17.knownGene.name (via knownToHprd.name)
      hg17.knownGeneLink.name (via knownToHprd.name)
      hg17.knownGeneMrna.name (via knownToHprd.name)
      hg17.knownGenePep.name (via knownToHprd.name)
      hg17.knownIsoforms.transcript (via knownToHprd.name)
      hg17.knownToAllenBrain.name (via knownToHprd.name)
      hg17.knownToEnsembl.name (via knownToHprd.name)
      hg17.knownToGnf1h.name (via knownToHprd.name)
      hg17.knownToGnfAtlas2.name (via knownToHprd.name)
      hg17.knownToHInv.name (via knownToHprd.name)
      hg17.knownToKeggEntrez.name (via knownToHprd.name)
      hg17.knownToLocusLink.name (via knownToHprd.name)
      hg17.knownToPfam.name (via knownToHprd.name)
      hg17.knownToRefSeq.name (via knownToHprd.name)
      hg17.knownToSuper.gene (via knownToHprd.name)
      hg17.knownToU133.name (via knownToHprd.name)
      hg17.knownToU133Plus2.name (via knownToHprd.name)
      hg17.knownToU95.name (via knownToHprd.name)
      hg17.knownToVisiGene.name (via knownToHprd.name)
      hg17.mmBlastTab.query (via knownToHprd.name)
      hg17.rankProp.query (via knownToHprd.name)
      hg17.rankProp.target (via knownToHprd.name)
      hg17.rnBlastTab.query (via knownToHprd.name)
      hg17.scBlastTab.query (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
AB00229209735
AB00229415886
AB00231513794
AB00233110363
AB00237110856
AB00237216081
AB00245403169
AB00317704394
AB00488512232
AB00790011559

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