Schema for knownToVisiGene
  Database: mm10    Primary Table: knownToVisiGene    Row Count: 83,570   Data last updated: 2019-09-20
Format description: Map known gene to VisiGene image ids.
fieldexampleSQL type info description
name ENSMUST00000208660.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
        mm10.bioCycPathway.kgID (via knownToVisiGene.name)
      mm10.ccdsKgMap.geneId (via knownToVisiGene.name)
      mm10.ceBlastTab.query (via knownToVisiGene.name)
      mm10.dmBlastTab.query (via knownToVisiGene.name)
      mm10.drBlastTab.query (via knownToVisiGene.name)
      mm10.foldUtr3.name (via knownToVisiGene.name)
      mm10.foldUtr5.name (via knownToVisiGene.name)
      mm10.hgBlastTab.query (via knownToVisiGene.name)
      mm10.keggPathway.kgID (via knownToVisiGene.name)
      mm10.kgAlias.kgID (via knownToVisiGene.name)
      mm10.kgColor.kgID (via knownToVisiGene.name)
      mm10.kgProtAlias.kgID (via knownToVisiGene.name)
      mm10.kgProtMap2.qName (via knownToVisiGene.name)
      mm10.kgSpAlias.kgID (via knownToVisiGene.name)
      mm10.kgTargetAli.qName (via knownToVisiGene.name)
      mm10.kgTxInfo.name (via knownToVisiGene.name)
      mm10.kgXref.kgID (via knownToVisiGene.name)
      mm10.knownAttrs.kgID (via knownToVisiGene.name)
      mm10.knownBlastTab.query (via knownToVisiGene.name)
      mm10.knownBlastTab.target (via knownToVisiGene.name)
      mm10.knownCanonical.transcript (via knownToVisiGene.name)
      mm10.knownCds.name (via knownToVisiGene.name)
      mm10.knownGene.name (via knownToVisiGene.name)
      mm10.knownGeneMrna.name (via knownToVisiGene.name)
      mm10.knownGenePep.name (via knownToVisiGene.name)
      mm10.knownIsoforms.transcript (via knownToVisiGene.name)
      mm10.knownToEnsembl.name (via knownToVisiGene.name)
      mm10.knownToKeggEntrez.name (via knownToVisiGene.name)
      mm10.knownToLocusLink.name (via knownToVisiGene.name)
      mm10.knownToLynx.name (via knownToVisiGene.name)
      mm10.knownToMrna.name (via knownToVisiGene.name)
      mm10.knownToMrnaSingle.name (via knownToVisiGene.name)
      mm10.knownToPfam.name (via knownToVisiGene.name)
      mm10.knownToRefSeq.name (via knownToVisiGene.name)
      mm10.knownToSuper.gene (via knownToVisiGene.name)
      mm10.knownToTag.name (via knownToVisiGene.name)
      mm10.knownToWikipedia.name (via knownToVisiGene.name)
      mm10.rnBlastTab.query (via knownToVisiGene.name)
      mm10.scBlastTab.query (via knownToVisiGene.name)
      mm10.ucscScop.ucscId (via knownToVisiGene.name)
      visiGene.image.id (via knownToVisiGene.value)
      visiGene.imageProbe.image (via knownToVisiGene.value)

Sample Rows
 
namevaluegeneId
ENSMUST00000208660.118046712939
ENSMUST00000208793.118046712939
ENSMUST00000194992.618046712939
ENSMUST00000027032.518046712939
ENSMUST00000027035.91524141797
ENSMUST00000195555.11524141797
ENSMUST00000192650.51524141797
ENSMUST00000116652.71524141797
ENSMUST00000192505.11524141797
ENSMUST00000191647.11524141797

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