Schema for knownToHInv
  Database: hg18    Primary Table: knownToHInv    Row Count: 54,754   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 uc004fon.1varchar(255) values primary ID
value HIT000004659varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg18.bioCycPathway.kgID (via knownToHInv.name)
      hg18.ccdsKgMap.geneId (via knownToHInv.name)
      hg18.ceBlastTab.query (via knownToHInv.name)
      hg18.dmBlastTab.query (via knownToHInv.name)
      hg18.drBlastTab.query (via knownToHInv.name)
      hg18.foldUtr3.name (via knownToHInv.name)
      hg18.foldUtr5.name (via knownToHInv.name)
      hg18.gnfAtlas2Distance.query (via knownToHInv.name)
      hg18.gnfAtlas2Distance.target (via knownToHInv.name)
      hg18.gnfU95Distance.query (via knownToHInv.name)
      hg18.gnfU95Distance.target (via knownToHInv.name)
      hg18.humanHprdP2P.query (via knownToHInv.name)
      hg18.humanHprdP2P.target (via knownToHInv.name)
      hg18.humanVidalP2P.query (via knownToHInv.name)
      hg18.humanVidalP2P.target (via knownToHInv.name)
      hg18.humanWankerP2P.query (via knownToHInv.name)
      hg18.humanWankerP2P.target (via knownToHInv.name)
      hg18.keggPathway.kgID (via knownToHInv.name)
      hg18.kgAlias.kgID (via knownToHInv.name)
      hg18.kgColor.kgID (via knownToHInv.name)
      hg18.kgProtAlias.kgID (via knownToHInv.name)
      hg18.kgProtMap2.qName (via knownToHInv.name)
      hg18.kgSpAlias.kgID (via knownToHInv.name)
      hg18.kgTargetAli.qName (via knownToHInv.name)
      hg18.kgTxInfo.name (via knownToHInv.name)
      hg18.kgXref.kgID (via knownToHInv.name)
      hg18.knownBlastTab.query (via knownToHInv.name)
      hg18.knownBlastTab.target (via knownToHInv.name)
      hg18.knownCanonToDecipher.name (via knownToHInv.name)
      hg18.knownCanonical.protein (via knownToHInv.name)
      hg18.knownCanonical.transcript (via knownToHInv.name)
      hg18.knownGene.name (via knownToHInv.name)
      hg18.knownGeneMrna.name (via knownToHInv.name)
      hg18.knownGenePep.name (via knownToHInv.name)
      hg18.knownIsoforms.transcript (via knownToHInv.name)
      hg18.knownToAllenBrain.name (via knownToHInv.name)
      hg18.knownToDecipher.name (via knownToHInv.name)
      hg18.knownToEnsembl.name (via knownToHInv.name)
      hg18.knownToGnf1h.name (via knownToHInv.name)
      hg18.knownToGnfAtlas2.name (via knownToHInv.name)
      hg18.knownToHprd.name (via knownToHInv.name)
      hg18.knownToKeggEntrez.name (via knownToHInv.name)
      hg18.knownToLocusLink.name (via knownToHInv.name)
      hg18.knownToMupit.name (via knownToHInv.name)
      hg18.knownToPfam.name (via knownToHInv.name)
      hg18.knownToRefSeq.name (via knownToHInv.name)
      hg18.knownToSuper.gene (via knownToHInv.name)
      hg18.knownToTreefam.name (via knownToHInv.name)
      hg18.knownToU133.name (via knownToHInv.name)
      hg18.knownToU133Plus2.name (via knownToHInv.name)
      hg18.knownToU95.name (via knownToHInv.name)
      hg18.knownToVisiGene.name (via knownToHInv.name)
      hg18.mmBlastTab.query (via knownToHInv.name)
      hg18.rnBlastTab.query (via knownToHInv.name)
      hg18.scBlastTab.query (via knownToHInv.name)
      hg18.ucscScop.ucscId (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)
      hg18.HInv.geneId (via knownToHInv.value)
      hg18.HInvGeneMrna.qName (via knownToHInv.value)

Sample Rows
 
namevalue
uc004fon.1HIT000004659
uc004foo.1HIT000032168
uc004fop.1HIT000015873
uc004fpa.1HIT000031053
uc004fpb.1HIT000028509
uc004fpc.1HIT000031053
uc004fpd.1HIT000031053
uc010nvt.1HIT000028509
uc010nvu.1HIT000031053
uc004fpe.1HIT000028509

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