Schema for kgColor
  Database: mm39    Primary Table: kgColor    Row Count: 278,375   Data last updated: 2024-08-15
Format description: What color to draw known gene in?
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID ENSMUST00000000001.5varchar(255) values Known gene ID
r 12tinyint(3) unsigned range Red component 0-255
g 12tinyint(3) unsigned range Green component 0-255
b 120tinyint(3) unsigned range Blue component 0-255

Connected Tables and Joining Fields
        knownGeneV39.bioCycPathway.kgID (via kgColor.kgID)
      knownGeneV39.ceBlastTab.query (via kgColor.kgID)
      knownGeneV39.dmBlastTab.query (via kgColor.kgID)
      knownGeneV39.drBlastTab.query (via kgColor.kgID)
      knownGeneV39.foldUtr3.name (via kgColor.kgID)
      knownGeneV39.foldUtr5.name (via kgColor.kgID)
      knownGeneV39.gnfAtlas2Distance.query (via kgColor.kgID)
      knownGeneV39.gnfAtlas2Distance.target (via kgColor.kgID)
      knownGeneV39.kgAlias.kgID (via kgColor.kgID)
      knownGeneV39.kgColor.kgID (via kgColor.kgID)
      knownGeneV39.kgProtAlias.kgID (via kgColor.kgID)
      knownGeneV39.kgSpAlias.kgID (via kgColor.kgID)
      knownGeneV39.kgTargetAli.qName (via kgColor.kgID)
      knownGeneV39.kgXref.kgID (via kgColor.kgID)
      knownGeneV39.knownAttrs.kgID (via kgColor.kgID)
      knownGeneV39.knownBlastTab.query (via kgColor.kgID)
      knownGeneV39.knownBlastTab.target (via kgColor.kgID)
      knownGeneV39.knownCanonical.protein (via kgColor.kgID)
      knownGeneV39.knownCanonical.transcript (via kgColor.kgID)
      knownGeneV39.knownCds.name (via kgColor.kgID)
      knownGeneV39.knownGene.name (via kgColor.kgID)
      knownGeneV39.knownGeneMrna.name (via kgColor.kgID)
      knownGeneV39.knownGenePep.name (via kgColor.kgID)
      knownGeneV39.knownIsoforms.transcript (via kgColor.kgID)
      knownGeneV39.knownToEnsembl.name (via kgColor.kgID)
      knownGeneV39.knownToGnfAtlas2.name (via kgColor.kgID)
      knownGeneV39.knownToHprd.name (via kgColor.kgID)
      knownGeneV39.knownToLocusLink.name (via kgColor.kgID)
      knownGeneV39.knownToMrna.name (via kgColor.kgID)
      knownGeneV39.knownToMrnaSingle.name (via kgColor.kgID)
      knownGeneV39.knownToMupit.name (via kgColor.kgID)
      knownGeneV39.knownToPfam.name (via kgColor.kgID)
      knownGeneV39.knownToRefSeq.name (via kgColor.kgID)
      knownGeneV39.knownToSuper.gene (via kgColor.kgID)
      knownGeneV39.knownToTag.name (via kgColor.kgID)
      knownGeneV39.knownToU133.name (via kgColor.kgID)
      knownGeneV39.knownToU95.name (via kgColor.kgID)
      knownGeneV39.knownToVisiGene.name (via kgColor.kgID)
      knownGeneV39.knownToWikipedia.name (via kgColor.kgID)
      knownGeneV39.mmBlastTab.query (via kgColor.kgID)
      knownGeneV39.rnBlastTab.query (via kgColor.kgID)
      knownGeneV39.scBlastTab.query (via kgColor.kgID)
      knownGeneV39.ucscScop.ucscId (via kgColor.kgID)
      mm39.bioCycPathway.kgID (via kgColor.kgID)
      mm39.ceBlastTab.query (via kgColor.kgID)
      mm39.dmBlastTab.query (via kgColor.kgID)
      mm39.drBlastTab.query (via kgColor.kgID)
      mm39.foldUtr3.name (via kgColor.kgID)
      mm39.foldUtr5.name (via kgColor.kgID)
      mm39.hgBlastTab.query (via kgColor.kgID)
      mm39.kgAlias.kgID (via kgColor.kgID)
      mm39.kgProtAlias.kgID (via kgColor.kgID)
      mm39.kgSpAlias.kgID (via kgColor.kgID)
      mm39.kgTargetAli.qName (via kgColor.kgID)
      mm39.kgXref.kgID (via kgColor.kgID)
      mm39.knownAttrs.kgID (via kgColor.kgID)
      mm39.knownBlastTab.query (via kgColor.kgID)
      mm39.knownBlastTab.target (via kgColor.kgID)
      mm39.knownCanonical.transcript (via kgColor.kgID)
      mm39.knownCds.name (via kgColor.kgID)
      mm39.knownGene.name (via kgColor.kgID)
      mm39.knownGeneMrna.name (via kgColor.kgID)
      mm39.knownIsoforms.transcript (via kgColor.kgID)
      mm39.knownToEnsembl.name (via kgColor.kgID)
      mm39.knownToLocusLink.name (via kgColor.kgID)
      mm39.knownToMrna.name (via kgColor.kgID)
      mm39.knownToMrnaSingle.name (via kgColor.kgID)
      mm39.knownToMupit.name (via kgColor.kgID)
      mm39.knownToNextProt.name (via kgColor.kgID)
      mm39.knownToPfam.name (via kgColor.kgID)
      mm39.knownToRefSeq.name (via kgColor.kgID)
      mm39.knownToSuper.gene (via kgColor.kgID)
      mm39.knownToTag.name (via kgColor.kgID)
      mm39.knownToVisiGene.name (via kgColor.kgID)
      mm39.knownToWikipedia.name (via kgColor.kgID)
      mm39.rnBlastTab.query (via kgColor.kgID)
      mm39.scBlastTab.query (via kgColor.kgID)
      mm39.ucscScop.ucscId (via kgColor.kgID)

Sample Rows
 
kgIDrgb
ENSMUST00000000001.51212120
ENSMUST00000000003.141212120
ENSMUST00000000010.91212120
ENSMUST00000000028.141212120
ENSMUST00000000033.121212120
ENSMUST00000000049.61212120
ENSMUST00000000058.71212120
ENSMUST00000000080.81212120
ENSMUST00000000087.131212120
ENSMUST00000000090.81212120

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