Schema for knownToVisiGene
  Database: hg17    Primary Table: knownToVisiGene    Row Count: 28,182   Data last updated: 2007-02-15
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 BC073913varchar(255) values primary ID
value 179407varchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
BC073913179407
NM_03212924703
NM_02117037481
NM_198576153970
AB191264153970
AK128761153970
AK057368184710
BC008788184710
AK000591184710
AK128271184710

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