Schema for kgXref
  Database: mm7    Primary Table: kgXref    Row Count: 30,631   Data last updated: 2005-11-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 AB001539varchar(40) values Known Gene ID
mRNA AB001539varchar(40) values mRNA ID
spID Q8K335varchar(40) values UniProt protein Accession number
spDisplayID Q8K335_MOUSEvarchar(40) values UniProt display ID
geneSymbol AB001539varchar(40) values Gene Symbol
refseq  varchar(40) values RefSeq ID
protAcc  varchar(40) values NCBI protein Accession number
description Glutamate-rich WD repeat co...varchar(255) values Description

Connected Tables and Joining Fields
        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)
      mm7.affyGnfU74ADistance.query (via kgXref.kgID)
      mm7.affyGnfU74ADistance.target (via kgXref.kgID)
      mm7.affyGnfU74BDistance.query (via kgXref.kgID)
      mm7.affyGnfU74BDistance.target (via kgXref.kgID)
      mm7.affyGnfU74CDistance.query (via kgXref.kgID)
      mm7.affyGnfU74CDistance.target (via kgXref.kgID)
      mm7.dmBlastTab.query (via kgXref.kgID)
      mm7.drBlastTab.query (via kgXref.kgID)
      mm7.dupSpMrna.mrnaID (via kgXref.kgID)
      mm7.foldUtr3.name (via kgXref.kgID)
      mm7.foldUtr5.name (via kgXref.kgID)
      mm7.gnfAtlas2Distance.query (via kgXref.kgID)
      mm7.gnfAtlas2Distance.target (via kgXref.kgID)
      mm7.hgBlastTab.query (via kgXref.kgID)
      mm7.keggPathway.kgID (via kgXref.kgID)
      mm7.kgAlias.kgID (via kgXref.kgID)
      mm7.kgProtAlias.kgID (via kgXref.kgID)
      mm7.kgSpAlias.kgID (via kgXref.kgID)
      mm7.knownBlastTab.query (via kgXref.kgID)
      mm7.knownBlastTab.target (via kgXref.kgID)
      mm7.knownCanonical.transcript (via kgXref.kgID)
      mm7.knownGene.name (via kgXref.kgID)
      mm7.knownGeneLink.name (via kgXref.kgID)
      mm7.knownGeneMrna.name (via kgXref.kgID)
      mm7.knownGenePep.name (via kgXref.kgID)
      mm7.knownIsoforms.transcript (via kgXref.kgID)
      mm7.knownToAllenBrain.name (via kgXref.kgID)
      mm7.knownToEnsembl.name (via kgXref.kgID)
      mm7.knownToGnfAtlas2.name (via kgXref.kgID)
      mm7.knownToKeggEntrez.name (via kgXref.kgID)
      mm7.knownToLocusLink.name (via kgXref.kgID)
      mm7.knownToPfam.name (via kgXref.kgID)
      mm7.knownToRefSeq.name (via kgXref.kgID)
      mm7.knownToVisiGene.name (via kgXref.kgID)
      mm7.rnBlastTab.query (via kgXref.kgID)
      mm7.scBlastTab.query (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)
      mm7.kgProtAlias.alias (via kgXref.protAcc)
      mm7.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)
      mm7.dupSpMrna.dupMrnaID (via kgXref.refseq)
      mm7.dupSpMrna.mrnaID (via kgXref.refseq)
      mm7.knownToRefSeq.value (via kgXref.refseq)
      mm7.mrnaOrientInfo.name (via kgXref.refseq)
      mm7.mrnaRefseq.mrna (via kgXref.refseq)
      mm7.mrnaRefseq.refseq (via kgXref.refseq)
      mm7.refFlat.name (via kgXref.refseq)
      mm7.refGene.name (via kgXref.refseq)
      mm7.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)
      mm7.dupSpMrna.dupProteinID (via kgXref.spDisplayID)
      mm7.dupSpMrna.proteinID (via kgXref.spDisplayID)
      mm7.kgProtAlias.displayID (via kgXref.spDisplayID)
      mm7.kgSpAlias.alias (via kgXref.spDisplayID)
      mm7.knownCanonical.protein (via kgXref.spDisplayID)
      mm7.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)
      mm7.kgProtAlias.alias (via kgXref.spID)
      mm7.kgProtMap.qName (via kgXref.spID)
      mm7.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
 
kgIDmRNAspIDspDisplayIDgeneSymbolrefseqprotAccdescription
AB001539AB001539Q8K335Q8K335_MOUSEAB001539Glutamate-rich WD repeat containing 1.
AB001926AB001926P48722-2P48722-2AB001926Splice isoform 2 of P48722
AB003147AB003147O54770O54770_MOUSEAB003147Lens fiber cell beaded-filament structure protein.
AB003503AB003503O88180O88180_MOUSEAB003503Guanine Nucleotide Regulatory Protein.
AB004048AB004048O35081O35081_MOUSEAB004048Neuronatin (8 days embryo whole body cDNA, RIKEN full-length enriched library, clone:5730414I02 product:neuronatin, full insert ...
AB005654AB005654Q9QWG6Q9QWG6_MOUSEAB005654MAP kinase kinase 7.
AB005654AB005654Q9R1Z3Q9R1Z3_MOUSEAB005654MAP kinase kinase 7 alpha 2.
AB005662AB005662Q9ESN9-2Q9ESN9-2AB005662Splice isoform 1a of Q9ESN9
AB005909AB005909Q9JHU8Q9JHU8_MOUSEAB005909Muclin (Fragment).
AB006034AB006034O35084CP27B_MOUSEAB00603425-hydroxyvitamin D-1 alpha hydroxylase, mitochondrial precursor (EC 1.14.13.13) (Calcidiol 1-monooxygenase) (25-OHD-1 alpha- hy ...

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