Schema for kgXref
  Database: mm10    Primary Table: kgXref    Row Count: 142,446   Data last updated: 2019-09-20
Format description: Link together a Known Gene ID and a gene alias
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID ENSMUST00000193812.1varchar(255) values Known Gene ID
mRNA AK016604varchar(255) values mRNA ID
spID  varchar(255) values UniProt protein Accession number
spDisplayID  varchar(255) values UniProt display ID
geneSymbol 4933401J01Rikvarchar(255) values Gene Symbol
refseq  varchar(255) values RefSeq ID
protAcc  varchar(255) values NCBI protein Accession number
description 4933401J01Rik (from geneSym...longblob   Description
rfamAcc  varchar(255) values Rfam accession number
tRnaName  varchar(255) values Name from the tRNA track

Connected Tables and Joining Fields
        mm10.cgapAlias.alias (via kgXref.geneSymbol)
      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)
      mm10.bioCycPathway.kgID (via kgXref.kgID)
      mm10.ccdsKgMap.geneId (via kgXref.kgID)
      mm10.ceBlastTab.query (via kgXref.kgID)
      mm10.dmBlastTab.query (via kgXref.kgID)
      mm10.drBlastTab.query (via kgXref.kgID)
      mm10.foldUtr3.name (via kgXref.kgID)
      mm10.foldUtr5.name (via kgXref.kgID)
      mm10.hgBlastTab.query (via kgXref.kgID)
      mm10.keggPathway.kgID (via kgXref.kgID)
      mm10.kgAlias.kgID (via kgXref.kgID)
      mm10.kgColor.kgID (via kgXref.kgID)
      mm10.kgProtAlias.kgID (via kgXref.kgID)
      mm10.kgProtMap2.qName (via kgXref.kgID)
      mm10.kgSpAlias.kgID (via kgXref.kgID)
      mm10.kgTargetAli.qName (via kgXref.kgID)
      mm10.kgTxInfo.name (via kgXref.kgID)
      mm10.knownAttrs.kgID (via kgXref.kgID)
      mm10.knownBlastTab.query (via kgXref.kgID)
      mm10.knownBlastTab.target (via kgXref.kgID)
      mm10.knownCanonical.transcript (via kgXref.kgID)
      mm10.knownCds.name (via kgXref.kgID)
      mm10.knownGene.name (via kgXref.kgID)
      mm10.knownGeneMrna.name (via kgXref.kgID)
      mm10.knownGenePep.name (via kgXref.kgID)
      mm10.knownIsoforms.transcript (via kgXref.kgID)
      mm10.knownToEnsembl.name (via kgXref.kgID)
      mm10.knownToKeggEntrez.name (via kgXref.kgID)
      mm10.knownToLocusLink.name (via kgXref.kgID)
      mm10.knownToLynx.name (via kgXref.kgID)
      mm10.knownToMrna.name (via kgXref.kgID)
      mm10.knownToMrnaSingle.name (via kgXref.kgID)
      mm10.knownToPfam.name (via kgXref.kgID)
      mm10.knownToRefSeq.name (via kgXref.kgID)
      mm10.knownToSuper.gene (via kgXref.kgID)
      mm10.knownToTag.name (via kgXref.kgID)
      mm10.knownToVisiGene.name (via kgXref.kgID)
      mm10.knownToWikipedia.name (via kgXref.kgID)
      mm10.rnBlastTab.query (via kgXref.kgID)
      mm10.scBlastTab.query (via kgXref.kgID)
      mm10.ucscScop.ucscId (via kgXref.kgID)
      hgFixed.refLink.protAcc (via kgXref.protAcc)
      knownGeneV39.kgProtAlias.alias (via kgXref.protAcc)
      knownGeneV39.kgSpAlias.alias (via kgXref.protAcc)
      knownGeneV39.kgXref.protAcc (via kgXref.protAcc)
      mm10.kgProtAlias.alias (via kgXref.protAcc)
      mm10.kgSpAlias.alias (via kgXref.protAcc)
      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)
      mm10.ccdsInfo.mrnaAcc (via kgXref.refseq)
      mm10.knownToRefSeq.value (via kgXref.refseq)
      mm10.mrnaOrientInfo.name (via kgXref.refseq)
      mm10.refFlat.name (via kgXref.refseq)
      mm10.refGene.name (via kgXref.refseq)
      mm10.refSeqAli.qName (via kgXref.refseq)
      go.goaPart.dbObjectSymbol (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)
      mm10.spMrna.spID (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)
      knownGeneV39.kgProtAlias.alias (via kgXref.spID)
      knownGeneV39.kgSpAlias.spID (via kgXref.spID)
      knownGeneV39.kgXref.spID (via kgXref.spID)
      mm10.kgSpAlias.spID (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
ENSMUST00000193812.1AK0166044933401J01Rik4933401J01Rik (from geneSymbol)
ENSMUST00000082908.1Gm26206Gm26206 (from geneSymbol)
ENSMUST00000162897.1AK220428Xkr4Xkr4 (from geneSymbol)
ENSMUST00000159265.1AK135172Xkr4Xkr4 (from geneSymbol)
ENSMUST00000070533.4NM_001011874Q5GH67XKR4_MOUSEXkr4NM_001011874NM_001011874Mus musculus X-linked Kx blood group related 4 (Xkr4), mRNA. (from RefSeq NM_001011874)
ENSMUST00000195335.1Gm37180Gm37180 (from geneSymbol)
ENSMUST00000192336.1Gm37363Gm37363 (from geneSymbol)
ENSMUST00000194099.1AK051499Gm37686Gm37686 (from geneSymbol)
ENSMUST00000161581.1Gm1992Gm1992 (from geneSymbol)
ENSMUST00000192973.1AK051123Gm37329Gm37329 (from geneSymbol)

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