Schema for kgXref
  Database: hg17    Primary Table: kgXref    Row Count: 38,468   Data last updated: 2005-08-05
Format description: Link together a Known Gene ID and a gene alias
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID AB000409varchar(40) values Known Gene ID
mRNA AB000409varchar(40) values mRNA ID
spID Q9BUB5-2varchar(40) values UniProt protein Accession number
spDisplayID Q9BUB5-2varchar(40) values UniProt display ID
geneSymbol MKNK1varchar(40) values Gene Symbol
refseq  varchar(40) values RefSeq ID
protAcc  varchar(40) values NCBI protein Accession number
description MAP kinase interacting seri...varchar(255) values Description

Connected Tables and Joining Fields
        hg17.huge.geneSymbol (via kgXref.geneSymbol)
      hg17.kgAlias.alias (via kgXref.geneSymbol)
      hg17.kgSpAlias.alias (via kgXref.geneSymbol)
      hg17.refFlat.geneName (via kgXref.geneSymbol)
      hgFixed.ctdSorted.GeneSymbol (via kgXref.geneSymbol)
      hgFixed.ggGeneClass.gene (via kgXref.geneSymbol)
      hgFixed.ggGeneName.gene (via kgXref.geneSymbol)
      hgFixed.ggLink.gene1 (via kgXref.geneSymbol)
      hgFixed.ggLink.gene2 (via kgXref.geneSymbol)
      hgFixed.refLink.name (via kgXref.geneSymbol)
      visiGene.gene.name (via kgXref.geneSymbol)
      hg17.bioCycPathway.kgID (via kgXref.kgID)
      hg17.ccdsKgMap.geneId (via kgXref.kgID)
      hg17.ceBlastTab.query (via kgXref.kgID)
      hg17.dmBlastTab.query (via kgXref.kgID)
      hg17.drBlastTab.query (via kgXref.kgID)
      hg17.dupSpMrna.mrnaID (via kgXref.kgID)
      hg17.foldUtr3.name (via kgXref.kgID)
      hg17.foldUtr5.name (via kgXref.kgID)
      hg17.gladHumESDistance.query (via kgXref.kgID)
      hg17.gladHumESDistance.target (via kgXref.kgID)
      hg17.gnfAtlas2Distance.query (via kgXref.kgID)
      hg17.gnfAtlas2Distance.target (via kgXref.kgID)
      hg17.gnfU95Distance.query (via kgXref.kgID)
      hg17.gnfU95Distance.target (via kgXref.kgID)
      hg17.humanHprdP2P.query (via kgXref.kgID)
      hg17.humanHprdP2P.target (via kgXref.kgID)
      hg17.humanVidalP2P.query (via kgXref.kgID)
      hg17.humanVidalP2P.target (via kgXref.kgID)
      hg17.humanWankerP2P.query (via kgXref.kgID)
      hg17.humanWankerP2P.target (via kgXref.kgID)
      hg17.keggPathway.kgID (via kgXref.kgID)
      hg17.kgAlias.kgID (via kgXref.kgID)
      hg17.kgProtAlias.kgID (via kgXref.kgID)
      hg17.kgSpAlias.kgID (via kgXref.kgID)
      hg17.kgTargetAli.qName (via kgXref.kgID)
      hg17.knownBlastTab.query (via kgXref.kgID)
      hg17.knownBlastTab.target (via kgXref.kgID)
      hg17.knownCanonical.transcript (via kgXref.kgID)
      hg17.knownExpDistance.query (via kgXref.kgID)
      hg17.knownExpDistance.target (via kgXref.kgID)
      hg17.knownGene.name (via kgXref.kgID)
      hg17.knownGeneLink.name (via kgXref.kgID)
      hg17.knownGeneMrna.name (via kgXref.kgID)
      hg17.knownGenePep.name (via kgXref.kgID)
      hg17.knownIsoforms.transcript (via kgXref.kgID)
      hg17.knownToAllenBrain.name (via kgXref.kgID)
      hg17.knownToEnsembl.name (via kgXref.kgID)
      hg17.knownToGnf1h.name (via kgXref.kgID)
      hg17.knownToGnfAtlas2.name (via kgXref.kgID)
      hg17.knownToHInv.name (via kgXref.kgID)
      hg17.knownToHprd.name (via kgXref.kgID)
      hg17.knownToKeggEntrez.name (via kgXref.kgID)
      hg17.knownToLocusLink.name (via kgXref.kgID)
      hg17.knownToPfam.name (via kgXref.kgID)
      hg17.knownToRefSeq.name (via kgXref.kgID)
      hg17.knownToSuper.gene (via kgXref.kgID)
      hg17.knownToU133.name (via kgXref.kgID)
      hg17.knownToU133Plus2.name (via kgXref.kgID)
      hg17.knownToU95.name (via kgXref.kgID)
      hg17.knownToVisiGene.name (via kgXref.kgID)
      hg17.mmBlastTab.query (via kgXref.kgID)
      hg17.rankProp.query (via kgXref.kgID)
      hg17.rankProp.target (via kgXref.kgID)
      hg17.rnBlastTab.query (via kgXref.kgID)
      hg17.scBlastTab.query (via kgXref.kgID)
      knownGeneV39.bioCycPathway.kgID (via kgXref.kgID)
      knownGeneV39.ceBlastTab.query (via kgXref.kgID)
      knownGeneV39.dmBlastTab.query (via kgXref.kgID)
      knownGeneV39.drBlastTab.query (via kgXref.kgID)
      knownGeneV39.foldUtr3.name (via kgXref.kgID)
      knownGeneV39.foldUtr5.name (via kgXref.kgID)
      knownGeneV39.gnfAtlas2Distance.query (via kgXref.kgID)
      knownGeneV39.gnfAtlas2Distance.target (via kgXref.kgID)
      knownGeneV39.kgAlias.kgID (via kgXref.kgID)
      knownGeneV39.kgColor.kgID (via kgXref.kgID)
      knownGeneV39.kgProtAlias.kgID (via kgXref.kgID)
      knownGeneV39.kgSpAlias.kgID (via kgXref.kgID)
      knownGeneV39.kgTargetAli.qName (via kgXref.kgID)
      knownGeneV39.kgXref.kgID (via kgXref.kgID)
      knownGeneV39.knownAttrs.kgID (via kgXref.kgID)
      knownGeneV39.knownBlastTab.query (via kgXref.kgID)
      knownGeneV39.knownBlastTab.target (via kgXref.kgID)
      knownGeneV39.knownCanonical.protein (via kgXref.kgID)
      knownGeneV39.knownCanonical.transcript (via kgXref.kgID)
      knownGeneV39.knownCds.name (via kgXref.kgID)
      knownGeneV39.knownGene.name (via kgXref.kgID)
      knownGeneV39.knownGeneMrna.name (via kgXref.kgID)
      knownGeneV39.knownGenePep.name (via kgXref.kgID)
      knownGeneV39.knownIsoforms.transcript (via kgXref.kgID)
      knownGeneV39.knownToEnsembl.name (via kgXref.kgID)
      knownGeneV39.knownToGnfAtlas2.name (via kgXref.kgID)
      knownGeneV39.knownToHprd.name (via kgXref.kgID)
      knownGeneV39.knownToLocusLink.name (via kgXref.kgID)
      knownGeneV39.knownToMrna.name (via kgXref.kgID)
      knownGeneV39.knownToMrnaSingle.name (via kgXref.kgID)
      knownGeneV39.knownToMupit.name (via kgXref.kgID)
      knownGeneV39.knownToPfam.name (via kgXref.kgID)
      knownGeneV39.knownToRefSeq.name (via kgXref.kgID)
      knownGeneV39.knownToSuper.gene (via kgXref.kgID)
      knownGeneV39.knownToTag.name (via kgXref.kgID)
      knownGeneV39.knownToU133.name (via kgXref.kgID)
      knownGeneV39.knownToU95.name (via kgXref.kgID)
      knownGeneV39.knownToVisiGene.name (via kgXref.kgID)
      knownGeneV39.knownToWikipedia.name (via kgXref.kgID)
      knownGeneV39.mmBlastTab.query (via kgXref.kgID)
      knownGeneV39.rnBlastTab.query (via kgXref.kgID)
      knownGeneV39.scBlastTab.query (via kgXref.kgID)
      knownGeneV39.ucscScop.ucscId (via kgXref.kgID)
      hg17.kgProtAlias.alias (via kgXref.protAcc)
      hg17.kgSpAlias.alias (via kgXref.protAcc)
      hgFixed.refLink.protAcc (via kgXref.protAcc)
      knownGeneV39.kgProtAlias.alias (via kgXref.protAcc)
      knownGeneV39.kgSpAlias.alias (via kgXref.protAcc)
      knownGeneV39.kgXref.protAcc (via kgXref.protAcc)
      hg17.altGraphX.mrnaRefs (via kgXref.refseq)
      hg17.ccdsInfo.mrnaAcc (via kgXref.refseq)
      hg17.dupSpMrna.dupMrnaID (via kgXref.refseq)
      hg17.dupSpMrna.mrnaID (via kgXref.refseq)
      hg17.knownToRefSeq.value (via kgXref.refseq)
      hg17.mrnaOrientInfo.name (via kgXref.refseq)
      hg17.mrnaRefseq.mrna (via kgXref.refseq)
      hg17.mrnaRefseq.refseq (via kgXref.refseq)
      hg17.refFlat.name (via kgXref.refseq)
      hg17.refGene.name (via kgXref.refseq)
      hg17.refSeqAli.qName (via kgXref.refseq)
      hg17.spMrna.mrnaID (via kgXref.refseq)
      hgFixed.gbCdnaInfo.acc (via kgXref.refseq)
      hgFixed.gbSeq.acc (via kgXref.refseq)
      hgFixed.imageClone.acc (via kgXref.refseq)
      hgFixed.refLink.mrnaAcc (via kgXref.refseq)
      hgFixed.refSeqStatus.mrnaAcc (via kgXref.refseq)
      hgFixed.refSeqSummary.mrnaAcc (via kgXref.refseq)
      knownGeneV39.kgXref.refseq (via kgXref.refseq)
      knownGeneV39.knownToRefSeq.value (via kgXref.refseq)
      go.goaPart.dbObjectSymbol (via kgXref.spDisplayID)
      hg17.dupSpMrna.dupProteinID (via kgXref.spDisplayID)
      hg17.dupSpMrna.proteinID (via kgXref.spDisplayID)
      hg17.kgProtAlias.displayID (via kgXref.spDisplayID)
      hg17.kgSpAlias.alias (via kgXref.spDisplayID)
      hg17.knownCanonical.protein (via kgXref.spDisplayID)
      hg17.spMrna.spID (via kgXref.spDisplayID)
      knownGeneV39.kgProtAlias.displayID (via kgXref.spDisplayID)
      knownGeneV39.kgSpAlias.alias (via kgXref.spDisplayID)
      knownGeneV39.kgXref.spDisplayID (via kgXref.spDisplayID)
      knownGeneV39.knownCanonical.protein (via kgXref.spDisplayID)
      proteome.spOldNew.newDisplayId (via kgXref.spDisplayID)
      proteome.spOldNew.oldDisplayId (via kgXref.spDisplayID)
      uniProt.displayId.val (via kgXref.spDisplayID)
      go.goaPart.dbObjectId (via kgXref.spID)
      hg17.kgProtAlias.alias (via kgXref.spID)
      hg17.kgProtMap.qName (via kgXref.spID)
      hg17.kgSpAlias.spID (via kgXref.spID)
      knownGeneV39.kgProtAlias.alias (via kgXref.spID)
      knownGeneV39.kgSpAlias.spID (via kgXref.spID)
      knownGeneV39.kgXref.spID (via kgXref.spID)
      proteome.hgncXref.uniProt (via kgXref.spID)
      proteome.spOldNew.acc (via kgXref.spID)
      proteome.spReactomeEvent.spID (via kgXref.spID)
      proteome.spReactomeId.spID (via kgXref.spID)
      uniProt.accToKeyword.acc (via kgXref.spID)
      uniProt.accToTaxon.acc (via kgXref.spID)
      uniProt.citation.acc (via kgXref.spID)
      uniProt.comment.acc (via kgXref.spID)
      uniProt.description.acc (via kgXref.spID)
      uniProt.displayId.acc (via kgXref.spID)
      uniProt.extDbRef.acc (via kgXref.spID)
      uniProt.feature.acc (via kgXref.spID)
      uniProt.gene.acc (via kgXref.spID)
      uniProt.geneLogic.acc (via kgXref.spID)
      uniProt.info.acc (via kgXref.spID)
      uniProt.otherAcc.acc (via kgXref.spID)
      uniProt.protein.acc (via kgXref.spID)
      visiGene.gene.uniProt (via kgXref.spID)

Sample Rows
 
kgIDmRNAspIDspDisplayIDgeneSymbolrefseqprotAccdescription
AB000409AB000409Q9BUB5-2Q9BUB5-2MKNK1MAP kinase interacting serine/threonine kinase 1
AB000460AB000460P78311P78311_HUMANAB000460Homo sapiens.
AB000461AB000461P78313P78313_HUMANAB000461Homo sapiens.
AB000463AB000463P78314-2P78314-2SH3BP2SH3-domain binding protein 2
AB000781AB000781Q76NI1Q76NI1_HUMANKNDC1kinase non-catalytic C-lobe domain (KIND) containing 1
AB000815AB000815O00327-3O00327-3ARNTLaryl hydrocarbon receptor nuclear translocator-like
AB001025AB001025Q15413-2Q15413-2RYR3ryanodine receptor 3
AB001328AB001328Q9BZ22Q9BZ22_HUMANAB001328Solute carrier family 15 (Oligopeptide transporter), member 1.
AB001535AB001535Q5KTC1Q5KTC1_HUMANAB001535Transient receptor potential cation channel, subfamily M, member 2, striatum short form (SSF-TRPM2).
AB002292AB002292O15013ARHGA_HUMANARHGEF10Rho guanine nucleotide exchange factor (GEF) 10

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