Schema for knownToWikipedia
  Database: mm39    Primary Table: knownToWikipedia    Row Count: 53   Data last updated: 2024-08-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 ENSMUST00000021948.15varchar(255) values primary ID
value Factor_XIIvarchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        knownGeneV39.bioCycPathway.kgID (via knownToWikipedia.name)
      knownGeneV39.ceBlastTab.query (via knownToWikipedia.name)
      knownGeneV39.dmBlastTab.query (via knownToWikipedia.name)
      knownGeneV39.drBlastTab.query (via knownToWikipedia.name)
      knownGeneV39.foldUtr3.name (via knownToWikipedia.name)
      knownGeneV39.foldUtr5.name (via knownToWikipedia.name)
      knownGeneV39.gnfAtlas2Distance.query (via knownToWikipedia.name)
      knownGeneV39.gnfAtlas2Distance.target (via knownToWikipedia.name)
      knownGeneV39.kgAlias.kgID (via knownToWikipedia.name)
      knownGeneV39.kgColor.kgID (via knownToWikipedia.name)
      knownGeneV39.kgProtAlias.kgID (via knownToWikipedia.name)
      knownGeneV39.kgSpAlias.kgID (via knownToWikipedia.name)
      knownGeneV39.kgTargetAli.qName (via knownToWikipedia.name)
      knownGeneV39.kgXref.kgID (via knownToWikipedia.name)
      knownGeneV39.knownAttrs.kgID (via knownToWikipedia.name)
      knownGeneV39.knownBlastTab.query (via knownToWikipedia.name)
      knownGeneV39.knownBlastTab.target (via knownToWikipedia.name)
      knownGeneV39.knownCanonical.protein (via knownToWikipedia.name)
      knownGeneV39.knownCanonical.transcript (via knownToWikipedia.name)
      knownGeneV39.knownCds.name (via knownToWikipedia.name)
      knownGeneV39.knownGene.name (via knownToWikipedia.name)
      knownGeneV39.knownGeneMrna.name (via knownToWikipedia.name)
      knownGeneV39.knownGenePep.name (via knownToWikipedia.name)
      knownGeneV39.knownIsoforms.transcript (via knownToWikipedia.name)
      knownGeneV39.knownToEnsembl.name (via knownToWikipedia.name)
      knownGeneV39.knownToGnfAtlas2.name (via knownToWikipedia.name)
      knownGeneV39.knownToHprd.name (via knownToWikipedia.name)
      knownGeneV39.knownToLocusLink.name (via knownToWikipedia.name)
      knownGeneV39.knownToMrna.name (via knownToWikipedia.name)
      knownGeneV39.knownToMrnaSingle.name (via knownToWikipedia.name)
      knownGeneV39.knownToMupit.name (via knownToWikipedia.name)
      knownGeneV39.knownToPfam.name (via knownToWikipedia.name)
      knownGeneV39.knownToRefSeq.name (via knownToWikipedia.name)
      knownGeneV39.knownToSuper.gene (via knownToWikipedia.name)
      knownGeneV39.knownToTag.name (via knownToWikipedia.name)
      knownGeneV39.knownToU133.name (via knownToWikipedia.name)
      knownGeneV39.knownToU95.name (via knownToWikipedia.name)
      knownGeneV39.knownToVisiGene.name (via knownToWikipedia.name)
      knownGeneV39.knownToWikipedia.name (via knownToWikipedia.name)
      knownGeneV39.mmBlastTab.query (via knownToWikipedia.name)
      knownGeneV39.rnBlastTab.query (via knownToWikipedia.name)
      knownGeneV39.scBlastTab.query (via knownToWikipedia.name)
      knownGeneV39.ucscScop.ucscId (via knownToWikipedia.name)
      mm39.bioCycPathway.kgID (via knownToWikipedia.name)
      mm39.ceBlastTab.query (via knownToWikipedia.name)
      mm39.dmBlastTab.query (via knownToWikipedia.name)
      mm39.drBlastTab.query (via knownToWikipedia.name)
      mm39.foldUtr3.name (via knownToWikipedia.name)
      mm39.foldUtr5.name (via knownToWikipedia.name)
      mm39.hgBlastTab.query (via knownToWikipedia.name)
      mm39.kgAlias.kgID (via knownToWikipedia.name)
      mm39.kgColor.kgID (via knownToWikipedia.name)
      mm39.kgProtAlias.kgID (via knownToWikipedia.name)
      mm39.kgSpAlias.kgID (via knownToWikipedia.name)
      mm39.kgTargetAli.qName (via knownToWikipedia.name)
      mm39.kgXref.kgID (via knownToWikipedia.name)
      mm39.knownAttrs.kgID (via knownToWikipedia.name)
      mm39.knownBlastTab.query (via knownToWikipedia.name)
      mm39.knownBlastTab.target (via knownToWikipedia.name)
      mm39.knownCanonical.transcript (via knownToWikipedia.name)
      mm39.knownCds.name (via knownToWikipedia.name)
      mm39.knownGene.name (via knownToWikipedia.name)
      mm39.knownGeneMrna.name (via knownToWikipedia.name)
      mm39.knownIsoforms.transcript (via knownToWikipedia.name)
      mm39.knownToEnsembl.name (via knownToWikipedia.name)
      mm39.knownToLocusLink.name (via knownToWikipedia.name)
      mm39.knownToMrna.name (via knownToWikipedia.name)
      mm39.knownToMrnaSingle.name (via knownToWikipedia.name)
      mm39.knownToMupit.name (via knownToWikipedia.name)
      mm39.knownToNextProt.name (via knownToWikipedia.name)
      mm39.knownToPfam.name (via knownToWikipedia.name)
      mm39.knownToRefSeq.name (via knownToWikipedia.name)
      mm39.knownToSuper.gene (via knownToWikipedia.name)
      mm39.knownToTag.name (via knownToWikipedia.name)
      mm39.knownToVisiGene.name (via knownToWikipedia.name)
      mm39.rnBlastTab.query (via knownToWikipedia.name)
      mm39.scBlastTab.query (via knownToWikipedia.name)
      mm39.ucscScop.ucscId (via knownToWikipedia.name)

Sample Rows
 
namevalue
ENSMUST00000021948.15Factor_XII
ENSMUST00000022749.17Complement_component_9
ENSMUST00000022788.15Complement_component_6
ENSMUST00000024988.15Complement_component_3
ENSMUST00000025230.15Complement_component_2
ENSMUST00000028681.15Thrombin
ENSMUST00000029771.13Tissue_factor
ENSMUST00000033477.5Factor_IX
ENSMUST00000033539.13Factor_VIII
ENSMUST00000033820.4Factor_VII

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