Schema for knownToVisiGene
  Database: mm9    Primary Table: knownToVisiGene    Row Count: 40,112   Data last updated: 2011-03-03
Format description: Map known gene to VisiGene image ids.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name uc007aew.1varchar(255) values Same as name field in known gene
value 180467varchar(255) values Image id
geneId 12939int(11) range Locus Link or other gene id

Connected Tables and Joining Fields
        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)
      mm9.affyGnfU74ADistance.query (via knownToVisiGene.name)
      mm9.affyGnfU74ADistance.target (via knownToVisiGene.name)
      mm9.affyGnfU74BDistance.query (via knownToVisiGene.name)
      mm9.affyGnfU74BDistance.target (via knownToVisiGene.name)
      mm9.affyGnfU74CDistance.query (via knownToVisiGene.name)
      mm9.affyGnfU74CDistance.target (via knownToVisiGene.name)
      mm9.bioCycPathway.kgID (via knownToVisiGene.name)
      mm9.ccdsKgMap.geneId (via knownToVisiGene.name)
      mm9.ceBlastTab.query (via knownToVisiGene.name)
      mm9.dmBlastTab.query (via knownToVisiGene.name)
      mm9.drBlastTab.query (via knownToVisiGene.name)
      mm9.foldUtr3.name (via knownToVisiGene.name)
      mm9.foldUtr5.name (via knownToVisiGene.name)
      mm9.gnfAtlas2Distance.query (via knownToVisiGene.name)
      mm9.gnfAtlas2Distance.target (via knownToVisiGene.name)
      mm9.hgBlastTab.query (via knownToVisiGene.name)
      mm9.keggPathway.kgID (via knownToVisiGene.name)
      mm9.kgAlias.kgID (via knownToVisiGene.name)
      mm9.kgColor.kgID (via knownToVisiGene.name)
      mm9.kgProtAlias.kgID (via knownToVisiGene.name)
      mm9.kgProtMap2.qName (via knownToVisiGene.name)
      mm9.kgSpAlias.kgID (via knownToVisiGene.name)
      mm9.kgTargetAli.qName (via knownToVisiGene.name)
      mm9.kgTxInfo.name (via knownToVisiGene.name)
      mm9.kgXref.kgID (via knownToVisiGene.name)
      mm9.knownBlastTab.query (via knownToVisiGene.name)
      mm9.knownBlastTab.target (via knownToVisiGene.name)
      mm9.knownCanonical.protein (via knownToVisiGene.name)
      mm9.knownCanonical.transcript (via knownToVisiGene.name)
      mm9.knownGene.name (via knownToVisiGene.name)
      mm9.knownGeneMrna.name (via knownToVisiGene.name)
      mm9.knownGenePep.name (via knownToVisiGene.name)
      mm9.knownIsoforms.transcript (via knownToVisiGene.name)
      mm9.knownToAllenBrain.name (via knownToVisiGene.name)
      mm9.knownToEnsembl.name (via knownToVisiGene.name)
      mm9.knownToGnfAtlas2.name (via knownToVisiGene.name)
      mm9.knownToKeggEntrez.name (via knownToVisiGene.name)
      mm9.knownToLocusLink.name (via knownToVisiGene.name)
      mm9.knownToPfam.name (via knownToVisiGene.name)
      mm9.knownToRefSeq.name (via knownToVisiGene.name)
      mm9.knownToSuper.gene (via knownToVisiGene.name)
      mm9.rnBlastTab.query (via knownToVisiGene.name)
      mm9.scBlastTab.query (via knownToVisiGene.name)
      mm9.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
uc007aew.118046712939
uc007aex.218046712939
uc007aey.11524141797
uc007aez.11524141797
uc007afa.11524141797
uc007afb.11524141797
uc007afc.11524141797
uc007aff.21789144571
uc007afd.21789144571
uc007afe.21789144571

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