Schema for knownToWikipedia
  Database: hg19    Primary Table: knownToWikipedia    Row Count: 121,875   Data last updated: 2024-08-23
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.10_4varchar(255) values primary ID
value ARF5varchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg19.bioCycPathway.kgID (via knownToWikipedia.name)
      hg19.ceBlastTab.query (via knownToWikipedia.name)
      hg19.dmBlastTab.query (via knownToWikipedia.name)
      hg19.drBlastTab.query (via knownToWikipedia.name)
      hg19.foldUtr3.name (via knownToWikipedia.name)
      hg19.foldUtr5.name (via knownToWikipedia.name)
      hg19.gnfAtlas2Distance.query (via knownToWikipedia.name)
      hg19.gnfAtlas2Distance.target (via knownToWikipedia.name)
      hg19.gnfU95Distance.query (via knownToWikipedia.name)
      hg19.gnfU95Distance.target (via knownToWikipedia.name)
      hg19.humanHprdP2P.query (via knownToWikipedia.name)
      hg19.humanHprdP2P.target (via knownToWikipedia.name)
      hg19.humanVidalP2P.query (via knownToWikipedia.name)
      hg19.humanVidalP2P.target (via knownToWikipedia.name)
      hg19.humanWankerP2P.query (via knownToWikipedia.name)
      hg19.humanWankerP2P.target (via knownToWikipedia.name)
      hg19.keggPathway.kgID (via knownToWikipedia.name)
      hg19.kgAlias.kgID (via knownToWikipedia.name)
      hg19.kgColor.kgID (via knownToWikipedia.name)
      hg19.kgProtAlias.kgID (via knownToWikipedia.name)
      hg19.kgProtMap2.qName (via knownToWikipedia.name)
      hg19.kgSpAlias.kgID (via knownToWikipedia.name)
      hg19.kgTargetAli.qName (via knownToWikipedia.name)
      hg19.kgTxInfo.name (via knownToWikipedia.name)
      hg19.kgXref.kgID (via knownToWikipedia.name)
      hg19.knownAttrs.kgID (via knownToWikipedia.name)
      hg19.knownBlastTab.query (via knownToWikipedia.name)
      hg19.knownBlastTab.target (via knownToWikipedia.name)
      hg19.knownCanonToDecipher.name (via knownToWikipedia.name)
      hg19.knownCanonical.transcript (via knownToWikipedia.name)
      hg19.knownCds.name (via knownToWikipedia.name)
      hg19.knownGene.name (via knownToWikipedia.name)
      hg19.knownGeneMrna.name (via knownToWikipedia.name)
      hg19.knownGenePep.name (via knownToWikipedia.name)
      hg19.knownGeneTxMrna.name (via knownToWikipedia.name)
      hg19.knownGeneTxPep.name (via knownToWikipedia.name)
      hg19.knownIsoforms.transcript (via knownToWikipedia.name)
      hg19.knownToAllenBrain.name (via knownToWikipedia.name)
      hg19.knownToDecipher.name (via knownToWikipedia.name)
      hg19.knownToEnsembl.name (via knownToWikipedia.name)
      hg19.knownToGnfAtlas2.name (via knownToWikipedia.name)
      hg19.knownToHInv.name (via knownToWikipedia.name)
      hg19.knownToHprd.name (via knownToWikipedia.name)
      hg19.knownToKeggEntrez.name (via knownToWikipedia.name)
      hg19.knownToLocusLink.name (via knownToWikipedia.name)
      hg19.knownToLynx.name (via knownToWikipedia.name)
      hg19.knownToMrna.name (via knownToWikipedia.name)
      hg19.knownToMrnaSingle.name (via knownToWikipedia.name)
      hg19.knownToMupit.name (via knownToWikipedia.name)
      hg19.knownToNextProt.name (via knownToWikipedia.name)
      hg19.knownToPfam.name (via knownToWikipedia.name)
      hg19.knownToRefSeq.name (via knownToWikipedia.name)
      hg19.knownToSuper.gene (via knownToWikipedia.name)
      hg19.knownToTag.name (via knownToWikipedia.name)
      hg19.knownToTreefam.name (via knownToWikipedia.name)
      hg19.knownToU133.name (via knownToWikipedia.name)
      hg19.knownToU133Plus2.name (via knownToWikipedia.name)
      hg19.knownToU95.name (via knownToWikipedia.name)
      hg19.knownToVisiGene.name (via knownToWikipedia.name)
      hg19.mmBlastTab.query (via knownToWikipedia.name)
      hg19.rnBlastTab.query (via knownToWikipedia.name)
      hg19.scBlastTab.query (via knownToWikipedia.name)
      hg19.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.10_4ARF5
ENST00000000412.3Cation-dependent_mannose-6-phosphate_receptor
ENST00000000442.11_8Estrogen-related_receptor_alpha
ENST00000001008.6_4FKBP52
ENST00000001146.7_7CYP26B1
ENST00000002125.9_4NDUFAF7
ENST00000002165.11_7FUCA2
ENST00000002596.6_7HS3ST1
ENST00000002829.8_6SEMA3F
ENST00000003084.11_5Cystic_fibrosis_transmembrane_conductance_regulator

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