Schema for knownToHInv
  Database: hg19    Primary Table: knownToHInv    Row Count: 57,807   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 uc004cos.5varchar(255) values primary ID
value HIT000002823varchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
uc004cos.5HIT000002823
uc031tga.1HIT000009821
uc011mfi.2HIT000010204
uc004cov.5HIT000048995
uc011mfg.1HIT000046980
uc004con.1HIT000046980
uc002kix.1HIT000046661
uc002qvo.3HIT000030785
uc021vde.1HIT000045707
uc021vdf.1HIT000045707

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