Schema for knownToHInv
  Database: hg17    Primary Table: knownToHInv    Row Count: 28,910   Data last updated: 2005-06-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 NM_018390varchar(255) values primary ID
value HIT000004659varchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
NM_018390HIT000004659
AK023392HIT000006666
NM_005088HIT000040464
L03426HIT000040464
BC028151HIT000040464
NM_004043HIT000030522
BC001620HIT000030522
NM_002414HIT000034807
CR611199HIT000034807
CR599762HIT000034807

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