Schema for knownAttrs
  Database: mm39    Primary Table: knownAttrs    Row Count: 278,375   Data last updated: 2024-08-15
Format description: Fields in Gencode attrs table that aren't in kgXref
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID ENSMUST00000000001.5varchar(255) values Known Gene ID
geneId ENSMUSG00000000001.5varchar(255) values ENSG* locus identifier
geneStatus  varchar(255) values KNOWN or NOVEL
geneType protein_codingvarchar(255) values gene function
transcriptName Gnai3-201varchar(255) values transcript Name
transcriptType protein_codingvarchar(255) values transcript Type
transcriptStatus  varchar(255) values KNOWN or NOVEL or PUTATIVE
havanaGeneId OTTMUSG00000007197.1varchar(255) values Havana project Id
ccdsId CCDS17751.1varchar(255) values CCDS project Id
supportLevel 2varchar(255) values transcript support level
transcriptClass codingvarchar(255) values pseudo, nonCoding, coding, or problem
transcriptRank 1int(11) range  

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

Sample Rows
 
kgIDgeneIdgeneStatusgeneTypetranscriptNametranscriptTypetranscriptStatushavanaGeneIdccdsIdsupportLeveltranscriptClasstranscriptRank
ENSMUST00000000001.5ENSMUSG00000000001.5protein_codingGnai3-201protein_codingOTTMUSG00000007197.1CCDS17751.12coding1
ENSMUST00000000003.14ENSMUSG00000000003.16protein_codingPbsn-201protein_codingOTTMUSG00000017891.1CCDS30249.12coding1
ENSMUST00000000010.9ENSMUSG00000020875.10protein_codingHoxb9-201protein_codingOTTMUSG00000001991.1CCDS25292.12coding1
ENSMUST00000000028.14ENSMUSG00000000028.16protein_codingCdc45-201protein_codingOTTMUSG00000026176.1CCDS28027.12coding1
ENSMUST00000000033.12ENSMUSG00000048583.18protein_codingIgf2-201protein_codingOTTMUSG00000035324.1CCDS52458.12coding2
ENSMUST00000000049.6ENSMUSG00000000049.12protein_codingApoh-201protein_codingOTTMUSG00000003129.1CCDS25574.12coding1
ENSMUST00000000058.7ENSMUSG00000000058.7protein_codingCav2-201protein_codingOTTMUSG00000024026.1CCDS19923.12coding1
ENSMUST00000000080.8ENSMUSG00000000078.8protein_codingKlf6-201protein_codingOTTMUSG00000066476.1CCDS26229.12coding1
ENSMUST00000000087.13ENSMUSG00000000085.17protein_codingScmh1-201protein_codingOTTMUSG00000008809.1CCDS18589.12coding2
ENSMUST00000000090.8ENSMUSG00000000088.8protein_codingCox5a-201protein_codingOTTMUSG00000063187.1CCDS23223.12coding1

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