Skip to main content
Schema for knownToVisiGene
  Database: mm39    Primary Table: knownToVisiGene    Row Count: 271,823   Data last updated: 2026-07-12
Format description: Map known gene to VisiGene image ids.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENSMUST00000208660.2varchar(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)
      mm39.bioCycPathway.kgID (via knownToVisiGene.name)
      mm39.ceBlastTab.query (via knownToVisiGene.name)
      mm39.dmBlastTab.query (via knownToVisiGene.name)
      mm39.drBlastTab.query (via knownToVisiGene.name)
      mm39.foldUtr3.name (via knownToVisiGene.name)
      mm39.foldUtr5.name (via knownToVisiGene.name)
      mm39.hgBlastTab.query (via knownToVisiGene.name)
      mm39.kgAlias.kgID (via knownToVisiGene.name)
      mm39.kgColor.kgID (via knownToVisiGene.name)
      mm39.kgProtAlias.kgID (via knownToVisiGene.name)
      mm39.kgSpAlias.kgID (via knownToVisiGene.name)
      mm39.kgTargetAli.qName (via knownToVisiGene.name)
      mm39.kgXref.kgID (via knownToVisiGene.name)
      mm39.knownAttrs.kgID (via knownToVisiGene.name)
      mm39.knownBlastTab.query (via knownToVisiGene.name)
      mm39.knownBlastTab.target (via knownToVisiGene.name)
      mm39.knownCanonical.transcript (via knownToVisiGene.name)
      mm39.knownCds.name (via knownToVisiGene.name)
      mm39.knownGene.name (via knownToVisiGene.name)
      mm39.knownGeneMrna.name (via knownToVisiGene.name)
      mm39.knownIsoforms.transcript (via knownToVisiGene.name)
      mm39.knownToEnsembl.name (via knownToVisiGene.name)
      mm39.knownToLocusLink.name (via knownToVisiGene.name)
      mm39.knownToMrna.name (via knownToVisiGene.name)
      mm39.knownToMrnaSingle.name (via knownToVisiGene.name)
      mm39.knownToMupit.name (via knownToVisiGene.name)
      mm39.knownToNextProt.name (via knownToVisiGene.name)
      mm39.knownToPfam.name (via knownToVisiGene.name)
      mm39.knownToRefSeq.name (via knownToVisiGene.name)
      mm39.knownToSuper.gene (via knownToVisiGene.name)
      mm39.knownToTag.name (via knownToVisiGene.name)
      mm39.knownToWikipedia.name (via knownToVisiGene.name)
      mm39.rnBlastTab.query (via knownToVisiGene.name)
      mm39.scBlastTab.query (via knownToVisiGene.name)
      mm39.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
ENSMUST00000208660.218046712939
ENSMUST00000437316.118046712939
ENSMUST00000208793.218046712939
ENSMUST00000027032.618046712939
ENSMUST00000437317.118046712939
ENSMUST00000116652.91524141797
ENSMUST00000027035.111524141797
ENSMUST00000521568.11524141797
ENSMUST00000521571.11524141797
ENSMUST00000521567.11524141797

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