Schema for knownToVisiGene
  Database: mm8    Primary Table: knownToVisiGene    Row Count: 25,088   Data last updated: 2007-02-15
Format description: Map a primary ID to another type of ID, label, quantity etc.
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name NM_011283varchar(255) values primary ID
value 180467varchar(255) values associated ID, label, quantity etc.

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)
      mm8.affyGnfU74ADistance.query (via knownToVisiGene.name)
      mm8.affyGnfU74ADistance.target (via knownToVisiGene.name)
      mm8.affyGnfU74BDistance.query (via knownToVisiGene.name)
      mm8.affyGnfU74BDistance.target (via knownToVisiGene.name)
      mm8.affyGnfU74CDistance.query (via knownToVisiGene.name)
      mm8.affyGnfU74CDistance.target (via knownToVisiGene.name)
      mm8.ccdsKgMap.geneId (via knownToVisiGene.name)
      mm8.ceBlastTab.query (via knownToVisiGene.name)
      mm8.dmBlastTab.query (via knownToVisiGene.name)
      mm8.drBlastTab.query (via knownToVisiGene.name)
      mm8.dupSpMrna.mrnaID (via knownToVisiGene.name)
      mm8.foldUtr3.name (via knownToVisiGene.name)
      mm8.foldUtr5.name (via knownToVisiGene.name)
      mm8.gnfAtlas2Distance.query (via knownToVisiGene.name)
      mm8.gnfAtlas2Distance.target (via knownToVisiGene.name)
      mm8.hgBlastTab.query (via knownToVisiGene.name)
      mm8.keggPathway.kgID (via knownToVisiGene.name)
      mm8.kgAlias.kgID (via knownToVisiGene.name)
      mm8.kgProtAlias.kgID (via knownToVisiGene.name)
      mm8.kgSpAlias.kgID (via knownToVisiGene.name)
      mm8.kgTargetAli.qName (via knownToVisiGene.name)
      mm8.kgXref.kgID (via knownToVisiGene.name)
      mm8.knownBlastTab.query (via knownToVisiGene.name)
      mm8.knownBlastTab.target (via knownToVisiGene.name)
      mm8.knownCanonical.transcript (via knownToVisiGene.name)
      mm8.knownGene.name (via knownToVisiGene.name)
      mm8.knownGeneMrna.name (via knownToVisiGene.name)
      mm8.knownGenePep.name (via knownToVisiGene.name)
      mm8.knownIsoforms.transcript (via knownToVisiGene.name)
      mm8.knownToAllenBrain.name (via knownToVisiGene.name)
      mm8.knownToEnsembl.name (via knownToVisiGene.name)
      mm8.knownToGnfAtlas2.name (via knownToVisiGene.name)
      mm8.knownToKeggEntrez.name (via knownToVisiGene.name)
      mm8.knownToLocusLink.name (via knownToVisiGene.name)
      mm8.knownToPfam.name (via knownToVisiGene.name)
      mm8.knownToRefSeq.name (via knownToVisiGene.name)
      mm8.knownToSuper.gene (via knownToVisiGene.name)
      mm8.rnBlastTab.query (via knownToVisiGene.name)
      mm8.scBlastTab.query (via knownToVisiGene.name)
      knownGeneV39.knownToVisiGene.value (via knownToVisiGene.value)
      visiGene.image.id (via knownToVisiGene.value)
      visiGene.imageProbe.image (via knownToVisiGene.value)

Sample Rows
 
namevalue
NM_011283180467
AK004781152414
NM_011441152414
NM_025300178914
BC068230178914
NM_008866178561
AK050549178561
NM_011541181807
BC083127181807
AK078208180369

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