Schema for knownToVisiGene
  Database: hg18    Primary Table: knownToVisiGene    Row Count: 40,420   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 uc001aab.2varchar(255) values primary ID
value 179407varchar(255) values associated ID, label, quantity etc.

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

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