Schema for knownToVisiGene
  Database: hg38    Primary Table: knownToVisiGene    Row Count: 6,747   Data last updated: 2022-05-15
Format description: Map known gene to VisiGene image ids.
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)
      visiGene.image.id (via knownToVisiGene.value)
      visiGene.imageProbe.image (via knownToVisiGene.value)

Sample Rows
 
namevaluegeneId
ENST00000428771.6374813036
ENST00000304952.11374813036
ENST00000481869.1374813036
ENST00000484667.2374813036
ENST00000378453.4339192838
ENST00000377532.8345202871
ENST00000377541.5345202871
ENST00000613533.4345202871
ENST00000614998.4345202871
ENST00000361923.2345202871

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