Schema for knownToVisiGene
  Database: hg19    Primary Table: knownToVisiGene    Row Count: 46,676   Data last updated: 2013-06-14
Format description: Map known gene to VisiGene image ids.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name uc009vis.3varchar(255) values Same as name field in known gene
value 179407varchar(255) values Image id
geneId 12172int(11) range Locus Link or other gene id

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

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