Schema for knownToVisiGene
  Database: mm39    Primary Table: knownToVisiGene    Row Count: 91,743   Data last updated: 2024-08-15
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
ENSMUST00000208793.218046712939
ENSMUST00000027032.618046712939
ENSMUST00000027035.101524141797
ENSMUST00000195555.21524141797
ENSMUST00000192650.61524141797
ENSMUST00000116652.81524141797
ENSMUST00000192505.21524141797
ENSMUST00000191647.21524141797
ENSMUST00000191939.21524141797

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