Schema for knownToHInv
  Database: hg16    Primary Table: knownToHInv    Row Count: 32,822   Data last updated: 2004-06-25
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 AK097327varchar(255) values primary ID
value HIT000022181varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg16.bioCycPathway.kgID (via knownToHInv.name)
      hg16.dmBlastTab.query (via knownToHInv.name)
      hg16.drBlastTab.query (via knownToHInv.name)
      hg16.dupSpMrna.mrnaID (via knownToHInv.name)
      hg16.foldUtr3.name (via knownToHInv.name)
      hg16.foldUtr5.name (via knownToHInv.name)
      hg16.gnfAtlas2Distance.query (via knownToHInv.name)
      hg16.gnfAtlas2Distance.target (via knownToHInv.name)
      hg16.gnfU95Distance.query (via knownToHInv.name)
      hg16.gnfU95Distance.target (via knownToHInv.name)
      hg16.hg17Kg.name (via knownToHInv.name)
      hg16.keggPathway.kgID (via knownToHInv.name)
      hg16.kgAlias.kgID (via knownToHInv.name)
      hg16.kgProtAlias.kgID (via knownToHInv.name)
      hg16.kgXref.kgID (via knownToHInv.name)
      hg16.knownBlastTab.query (via knownToHInv.name)
      hg16.knownBlastTab.target (via knownToHInv.name)
      hg16.knownCanonical.transcript (via knownToHInv.name)
      hg16.knownGene.name (via knownToHInv.name)
      hg16.knownGeneLink.name (via knownToHInv.name)
      hg16.knownGeneMrna.name (via knownToHInv.name)
      hg16.knownGenePep.name (via knownToHInv.name)
      hg16.knownIsoforms.transcript (via knownToHInv.name)
      hg16.knownToEnsembl.name (via knownToHInv.name)
      hg16.knownToGnfAtlas2.name (via knownToHInv.name)
      hg16.knownToLocusLink.name (via knownToHInv.name)
      hg16.knownToPfam.name (via knownToHInv.name)
      hg16.knownToRefSeq.name (via knownToHInv.name)
      hg16.knownToSuper.gene (via knownToHInv.name)
      hg16.knownToU133.name (via knownToHInv.name)
      hg16.knownToU95.name (via knownToHInv.name)
      hg16.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)
      hg16.HInv.geneId (via knownToHInv.value)
      hg16.HInvGeneMrna.qName (via knownToHInv.value)

Sample Rows
 
namevalue
AK097327HIT000022181
BC015393HIT000021425
AK124125HIT000018305
AK093438HIT000018305
AK093239HIT000018106
BC034304HIT000042093
BC004366HIT000024862
BC059409HIT000021628
BC003543HIT000021628
AK094502HIT000019357

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