Schema for kgXref
  Database: hg18    Primary Table: kgXref    Row Count: 66,803   Data last updated: 2009-03-04
Format description: Link together a Known Gene ID and a gene alias
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID uc001aaa.2varchar(40) values Known Gene ID
mRNA BC032353varchar(40) values mRNA ID
spID  varchar(40) values UniProt protein Accession number
spDisplayID  varchar(40) values UniProt display ID
geneSymbol BC032353varchar(40) values Gene Symbol
refseq  varchar(40) values RefSeq ID
protAcc  varchar(40) values NCBI protein Accession number
description Homo sapiens cDNA FLJ36366 ...longblob   Description

Connected Tables and Joining Fields
        hg18.allenBrainGene.geneSymbol (via kgXref.geneSymbol)
      hg18.cgapAlias.alias (via kgXref.geneSymbol)
      hg18.gad.name (via kgXref.geneSymbol)
      hg18.gadAll.geneSymbol (via kgXref.geneSymbol)
      hg18.geneReviews.name (via kgXref.geneSymbol)
      hg18.geneReviewsDetail.geneSymbol (via kgXref.geneSymbol)
      hg18.huge.geneSymbol (via kgXref.geneSymbol)
      hg18.kgAlias.alias (via kgXref.geneSymbol)
      hg18.kgSpAlias.alias (via kgXref.geneSymbol)
      hg18.omimGeneMap.geneSymbol (via kgXref.geneSymbol) Note: genome-wide queries are not available for this table.
      hg18.omimGeneMap2.geneSymbol (via kgXref.geneSymbol) Note: genome-wide queries are not available for this table.
      hg18.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)
      hg18.bioCycPathway.kgID (via kgXref.kgID)
      hg18.ccdsKgMap.geneId (via kgXref.kgID)
      hg18.ceBlastTab.query (via kgXref.kgID)
      hg18.dmBlastTab.query (via kgXref.kgID)
      hg18.drBlastTab.query (via kgXref.kgID)
      hg18.foldUtr3.name (via kgXref.kgID)
      hg18.foldUtr5.name (via kgXref.kgID)
      hg18.gnfAtlas2Distance.query (via kgXref.kgID)
      hg18.gnfAtlas2Distance.target (via kgXref.kgID)
      hg18.gnfU95Distance.query (via kgXref.kgID)
      hg18.gnfU95Distance.target (via kgXref.kgID)
      hg18.humanHprdP2P.query (via kgXref.kgID)
      hg18.humanHprdP2P.target (via kgXref.kgID)
      hg18.humanVidalP2P.query (via kgXref.kgID)
      hg18.humanVidalP2P.target (via kgXref.kgID)
      hg18.humanWankerP2P.query (via kgXref.kgID)
      hg18.humanWankerP2P.target (via kgXref.kgID)
      hg18.keggPathway.kgID (via kgXref.kgID)
      hg18.kgAlias.kgID (via kgXref.kgID)
      hg18.kgColor.kgID (via kgXref.kgID)
      hg18.kgProtAlias.kgID (via kgXref.kgID)
      hg18.kgProtMap2.qName (via kgXref.kgID)
      hg18.kgSpAlias.kgID (via kgXref.kgID)
      hg18.kgTargetAli.qName (via kgXref.kgID)
      hg18.kgTxInfo.name (via kgXref.kgID)
      hg18.knownBlastTab.query (via kgXref.kgID)
      hg18.knownBlastTab.target (via kgXref.kgID)
      hg18.knownCanonical.protein (via kgXref.kgID)
      hg18.knownCanonical.transcript (via kgXref.kgID)
      hg18.knownGene.name (via kgXref.kgID)
      hg18.knownGeneMrna.name (via kgXref.kgID)
      hg18.knownGenePep.name (via kgXref.kgID)
      hg18.knownIsoforms.transcript (via kgXref.kgID)
      hg18.knownToAllenBrain.name (via kgXref.kgID)
      hg18.knownToEnsembl.name (via kgXref.kgID)
      hg18.knownToGnf1h.name (via kgXref.kgID)
      hg18.knownToGnfAtlas2.name (via kgXref.kgID)
      hg18.knownToHInv.name (via kgXref.kgID)
      hg18.knownToHprd.name (via kgXref.kgID)
      hg18.knownToKeggEntrez.name (via kgXref.kgID)
      hg18.knownToLocusLink.name (via kgXref.kgID)
      hg18.knownToMupit.name (via kgXref.kgID)
      hg18.knownToPfam.name (via kgXref.kgID)
      hg18.knownToRefSeq.name (via kgXref.kgID)
      hg18.knownToSuper.gene (via kgXref.kgID)
      hg18.knownToTreefam.name (via kgXref.kgID)
      hg18.knownToU133.name (via kgXref.kgID)
      hg18.knownToU133Plus2.name (via kgXref.kgID)
      hg18.knownToU95.name (via kgXref.kgID)
      hg18.knownToVisiGene.name (via kgXref.kgID)
      hg18.mmBlastTab.query (via kgXref.kgID)
      hg18.rnBlastTab.query (via kgXref.kgID)
      hg18.scBlastTab.query (via kgXref.kgID)
      hg18.ucscScop.ucscId (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)
      hg18.kgProtAlias.alias (via kgXref.protAcc)
      hg18.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)
      hg18.ccdsInfo.mrnaAcc (via kgXref.refseq)
      hg18.knownToRefSeq.value (via kgXref.refseq)
      hg18.mrnaOrientInfo.name (via kgXref.refseq)
      hg18.mrnaRefseq.refseq (via kgXref.refseq)
      hg18.refFlat.name (via kgXref.refseq)
      hg18.refGene.name (via kgXref.refseq)
      hg18.refSeqAli.qName (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)
      hg18.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)
      hg18.kgSpAlias.spID (via kgXref.spID)
      hg18.lsSnpPdb.protId (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
uc001aaa.2BC032353BC032353Homo sapiens cDNA FLJ36366 fis, clone THYMU2007824.
uc009vip.1AX748260AX748260Homo sapiens cDNA FLJ36366 fis, clone THYMU2007824.
uc009vjg.1BC048429BC048429Homo sapiens cDNA clone IMAGE:5275617, **** WARNING: chimeric clone ****.
uc001aal.1NM_001005484Q8NH21OR4F5_HUMANOR4F5NM_001005484NP_001005484olfactory receptor, family 4, subfamily F,
uc009vjh.1AY972817Q52R92Q52R92_HUMANOR4F5NM_001005484NP_001005484olfactory receptor, family 4, subfamily F,
uc001aaq.1DQ599874DQ599874DQ599874
uc001aar.1DQ599768DQ599768DQ599768
uc001aas.1DQ574670DQ574670DQ574670
uc001aat.1DQ596298DQ596298DQ596298
uc001aau.1DQ599768DQ599768DQ599768

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