Schema for knownToWikipedia
  Database: hg19    Primary Table: knownToWikipedia    Row Count: 46,655   Data last updated: 2016-04-06
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 uc001aby.4varchar(255) values primary ID
value NOC2Lvarchar(255) values associated ID, label, quantity etc.

Connected Tables and Joining Fields
        hg19.bioCycPathway.kgID (via knownToWikipedia.name)
      hg19.ccdsKgMap.geneId (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.knownBlastTab.query (via knownToWikipedia.name)
      hg19.knownBlastTab.target (via knownToWikipedia.name)
      hg19.knownCanonical.transcript (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.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.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.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
uc001aby.4NOC2L
uc001abz.4NOC2L
uc001acj.4ISG15
uc001ack.2Agrin
uc001ada.3TNFRSF18
uc001adb.3TNFRSF18
uc001adc.3TNFRSF18
uc001add.3TNFRSF18
uc001ade.3CD134
uc001adf.3CD134

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