Schema for kgXref
  Database: hg19    Primary Table: kgXref    Row Count: 82,960   Data last updated: 2021-12-13
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.3varchar(255) values Known Gene ID
mRNA NR_046018varchar(255) values mRNA ID
spID  varchar(255) values UniProt protein Accession number
spDisplayID  varchar(255) values UniProt display ID
geneSymbol DDX11L1varchar(255) values Gene Symbol
refseq  varchar(255) values RefSeq ID
protAcc  varchar(255) values NCBI protein Accession number
description Homo sapiens DEAD/H (Asp-Gl...longblob   Description
rfamAcc  varchar(255) values Rfam accession number
tRnaName  varchar(255) values Name from the tRNA track

Connected Tables and Joining Fields
        hg19.allenBrainGene.geneSymbol (via kgXref.geneSymbol)
      hg19.cgapAlias.alias (via kgXref.geneSymbol)
      hg19.gad.name (via kgXref.geneSymbol)
      hg19.gadAll.geneSymbol (via kgXref.geneSymbol)
      hg19.geneReviews.name (via kgXref.geneSymbol)
      hg19.geneReviewsDetail.geneSymbol (via kgXref.geneSymbol)
      hg19.kgAlias.alias (via kgXref.geneSymbol)
      hg19.kgSpAlias.alias (via kgXref.geneSymbol)
      hg19.omimGeneMap.geneSymbol (via kgXref.geneSymbol) Note: genome-wide queries are not available for this table.
      hg19.omimGeneMap2.geneSymbol (via kgXref.geneSymbol) Note: genome-wide queries are not available for this table.
      hg19.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)
      hg19.bioCycPathway.kgID (via kgXref.kgID)
      hg19.ccdsKgMap.geneId (via kgXref.kgID)
      hg19.ceBlastTab.query (via kgXref.kgID)
      hg19.dmBlastTab.query (via kgXref.kgID)
      hg19.drBlastTab.query (via kgXref.kgID)
      hg19.foldUtr3.name (via kgXref.kgID)
      hg19.foldUtr5.name (via kgXref.kgID)
      hg19.gnfAtlas2Distance.query (via kgXref.kgID)
      hg19.gnfAtlas2Distance.target (via kgXref.kgID)
      hg19.gnfU95Distance.query (via kgXref.kgID)
      hg19.gnfU95Distance.target (via kgXref.kgID)
      hg19.humanHprdP2P.query (via kgXref.kgID)
      hg19.humanHprdP2P.target (via kgXref.kgID)
      hg19.humanVidalP2P.query (via kgXref.kgID)
      hg19.humanVidalP2P.target (via kgXref.kgID)
      hg19.humanWankerP2P.query (via kgXref.kgID)
      hg19.humanWankerP2P.target (via kgXref.kgID)
      hg19.keggPathway.kgID (via kgXref.kgID)
      hg19.kgAlias.kgID (via kgXref.kgID)
      hg19.kgColor.kgID (via kgXref.kgID)
      hg19.kgProtAlias.kgID (via kgXref.kgID)
      hg19.kgProtMap2.qName (via kgXref.kgID)
      hg19.kgSpAlias.kgID (via kgXref.kgID)
      hg19.kgTargetAli.qName (via kgXref.kgID)
      hg19.kgTxInfo.name (via kgXref.kgID)
      hg19.knownBlastTab.query (via kgXref.kgID)
      hg19.knownBlastTab.target (via kgXref.kgID)
      hg19.knownCanonical.transcript (via kgXref.kgID)
      hg19.knownGene.name (via kgXref.kgID)
      hg19.knownGeneMrna.name (via kgXref.kgID)
      hg19.knownGenePep.name (via kgXref.kgID)
      hg19.knownGeneTxMrna.name (via kgXref.kgID)
      hg19.knownGeneTxPep.name (via kgXref.kgID)
      hg19.knownIsoforms.transcript (via kgXref.kgID)
      hg19.knownToAllenBrain.name (via kgXref.kgID)
      hg19.knownToEnsembl.name (via kgXref.kgID)
      hg19.knownToGnfAtlas2.name (via kgXref.kgID)
      hg19.knownToHInv.name (via kgXref.kgID)
      hg19.knownToHprd.name (via kgXref.kgID)
      hg19.knownToKeggEntrez.name (via kgXref.kgID)
      hg19.knownToLocusLink.name (via kgXref.kgID)
      hg19.knownToLynx.name (via kgXref.kgID)
      hg19.knownToMupit.name (via kgXref.kgID)
      hg19.knownToNextProt.name (via kgXref.kgID)
      hg19.knownToPfam.name (via kgXref.kgID)
      hg19.knownToRefSeq.name (via kgXref.kgID)
      hg19.knownToSuper.gene (via kgXref.kgID)
      hg19.knownToTreefam.name (via kgXref.kgID)
      hg19.knownToU133.name (via kgXref.kgID)
      hg19.knownToU133Plus2.name (via kgXref.kgID)
      hg19.knownToU95.name (via kgXref.kgID)
      hg19.knownToVisiGene.name (via kgXref.kgID)
      hg19.knownToWikipedia.name (via kgXref.kgID)
      hg19.mmBlastTab.query (via kgXref.kgID)
      hg19.rnBlastTab.query (via kgXref.kgID)
      hg19.scBlastTab.query (via kgXref.kgID)
      hg19.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)
      hg19.kgProtAlias.alias (via kgXref.protAcc)
      hg19.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)
      hg19.ccdsInfo.mrnaAcc (via kgXref.refseq)
      hg19.knownToRefSeq.value (via kgXref.refseq)
      hg19.mrnaOrientInfo.name (via kgXref.refseq)
      hg19.refFlat.name (via kgXref.refseq)
      hg19.refGene.name (via kgXref.refseq)
      hg19.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)
      hg19.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)
      hg19.kgSpAlias.spID (via kgXref.spID)
      hg19.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
 
kgIDmRNAspIDspDisplayIDgeneSymbolrefseqprotAccdescriptionrfamAcctRnaName
uc001aaa.3NR_046018DDX11L1Homo sapiens DEAD/H (Asp-Glu-Ala-Asp/His) box helicase 11 like 1 (DDX11L1), non-coding RNA.
uc001aac.4BC063459WASH7PHomo sapiens WAS protein family homolog 7 pseudogene (WASH7P), non-coding RNA.
uc001aae.4BC053987WASH7PHomo sapiens WAS protein family homolog 7 pseudogene (WASH7P), non-coding RNA.
uc001aah.4NR_024540WASH7PHomo sapiens WAS protein family homolog 7 pseudogene (WASH7P), non-coding RNA.
uc001aai.1AY217347WASH7PHomo sapiens WAS protein family homolog 7 pseudogene (WASH7P), non-coding RNA.
uc001aak.3NR_026820FAM138AHomo sapiens family with sequence similarity 138, member F (FAM138A), non-coding RNA.
uc001aal.1NM_001005484Q8NH21OR4F5_HUMANOR4F5NM_001005484NP_001005484Homo sapiens olfactory receptor, family 4, subfamily F, member 5 (OR4F5), mRNA.
uc001aaq.2DQ597235DQ597235Homo sapiens piRNA piR-59592, complete sequence.
uc001aar.2DQ599768DQ599768Homo sapiens piRNA piR-42430, complete sequence.
uc001aau.3NR_028325C9J4L2C9J4L2_HUMANLOC100132062Homo sapiens uncharacterized LOC100132062 (LOC100132062), non-coding RNA.

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