Skip to main content
Schema for knownToVisiGene
  Database: hg38    Primary Table: knownToVisiGene    Row Count: 17,401   Data last updated: 2026-07-16
Format description: Map known gene to VisiGene image ids.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENST00000428771.6varchar(255) values Same as name field in known gene
value 37481varchar(255) values Image id
geneId 3036int(11) range Locus Link or other gene id

Connected Tables and Joining Fields
        hg38.bioCycPathway.kgID (via knownToVisiGene.name)
      hg38.ccdsKgMap.geneId (via knownToVisiGene.name)
      hg38.ceBlastTab.query (via knownToVisiGene.name)
      hg38.dmBlastTab.query (via knownToVisiGene.name)
      hg38.drBlastTab.query (via knownToVisiGene.name)
      hg38.foldUtr3.name (via knownToVisiGene.name)
      hg38.foldUtr5.name (via knownToVisiGene.name)
      hg38.gnfAtlas2Distance.query (via knownToVisiGene.name)
      hg38.gnfAtlas2Distance.target (via knownToVisiGene.name)
      hg38.gnfU95Distance.query (via knownToVisiGene.name)
      hg38.gnfU95Distance.target (via knownToVisiGene.name)
      hg38.humanHprdP2P.query (via knownToVisiGene.name)
      hg38.humanHprdP2P.target (via knownToVisiGene.name)
      hg38.humanVidalP2P.query (via knownToVisiGene.name)
      hg38.humanVidalP2P.target (via knownToVisiGene.name)
      hg38.humanWankerP2P.query (via knownToVisiGene.name)
      hg38.humanWankerP2P.target (via knownToVisiGene.name)
      hg38.keggPathway.kgID (via knownToVisiGene.name)
      hg38.kgAlias.kgID (via knownToVisiGene.name)
      hg38.kgColor.kgID (via knownToVisiGene.name)
      hg38.kgProtAlias.kgID (via knownToVisiGene.name)
      hg38.kgSpAlias.kgID (via knownToVisiGene.name)
      hg38.kgTargetAli.qName (via knownToVisiGene.name)
      hg38.kgXref.kgID (via knownToVisiGene.name)
      hg38.knownAttrs.kgID (via knownToVisiGene.name)
      hg38.knownBlastTab.query (via knownToVisiGene.name)
      hg38.knownBlastTab.target (via knownToVisiGene.name)
      hg38.knownCanonical.transcript (via knownToVisiGene.name)
      hg38.knownCds.name (via knownToVisiGene.name)
      hg38.knownGene.name (via knownToVisiGene.name)
      hg38.knownGeneMrna.name (via knownToVisiGene.name)
      hg38.knownGenePep.name (via knownToVisiGene.name)
      hg38.knownIsoforms.transcript (via knownToVisiGene.name)
      hg38.knownToEnsembl.name (via knownToVisiGene.name)
      hg38.knownToGnfAtlas2.name (via knownToVisiGene.name)
      hg38.knownToHprd.name (via knownToVisiGene.name)
      hg38.knownToKeggEntrez.name (via knownToVisiGene.name)
      hg38.knownToLocusLink.name (via knownToVisiGene.name)
      hg38.knownToLynx.name (via knownToVisiGene.name)
      hg38.knownToMrna.name (via knownToVisiGene.name)
      hg38.knownToMrnaSingle.name (via knownToVisiGene.name)
      hg38.knownToMupit.name (via knownToVisiGene.name)
      hg38.knownToNextProt.name (via knownToVisiGene.name)
      hg38.knownToPfam.name (via knownToVisiGene.name)
      hg38.knownToRefSeq.name (via knownToVisiGene.name)
      hg38.knownToSuper.gene (via knownToVisiGene.name)
      hg38.knownToTag.name (via knownToVisiGene.name)
      hg38.knownToU133.name (via knownToVisiGene.name)
      hg38.knownToU95.name (via knownToVisiGene.name)
      hg38.knownToWikipedia.name (via knownToVisiGene.name)
      hg38.mmBlastTab.query (via knownToVisiGene.name)
      hg38.rnBlastTab.query (via knownToVisiGene.name)
      hg38.scBlastTab.query (via knownToVisiGene.name)
      hg38.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
ENST00000428771.6374813036
ENST00000484667.3374813036
ENST00000854802.2374813036
ENST00000985004.1374813036
ENST00001017706.1374813036
ENST00001017707.1374813036
ENST00001140281.1374813036
ENST00000304952.11374813036
ENST00000481869.1374813036
ENST00000378453.4339192838

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