Schema for knownToWikipedia
  Database: hg38    Primary Table: knownToWikipedia    Row Count: 132,239   Data last updated: 2023-08-22
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 ENST00000000233.10varchar(255) values primary ID
value ARF5varchar(255) values associated ID, label, quantity etc.

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

Sample Rows
 
namevalue
ENST00000000233.10ARF5
ENST00000000412.8Cation-dependent_mannose-6-phosphate_receptor
ENST00000000442.11Estrogen-related_receptor_alpha
ENST00000001008.6FKBP52
ENST00000001146.7CYP26B1
ENST00000002125.9NDUFAF7
ENST00000002165.11FUCA2
ENST00000002596.6HS3ST1
ENST00000002829.8SEMA3F
ENST00000003084.11Cystic_fibrosis_transmembrane_conductance_regulator

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