Schema for knownAttrs
  Database: hg38    Primary Table: knownAttrs    Row Count: 533,740   Data last updated: 2025-09-26
Format description: Fields in Gencode attrs table that aren't in kgXref
On download server: MariaDB table dump directory
fieldexampleSQL type description
kgID ENST00000000233.10varchar(255) Known Gene ID
geneId ENSG00000004059.12varchar(255) ENSG* locus identifier
geneStatus  varchar(255) KNOWN or NOVEL
geneType protein_codingvarchar(255) gene function
transcriptName ARF5-201varchar(255) transcript Name
transcriptType protein_codingvarchar(255) transcript Type
transcriptStatus  varchar(255) KNOWN or NOVEL or PUTATIVE
havanaGeneId OTTHUMG00000023246.7varchar(255) Havana project Id
ccdsId CCDS34745.1varchar(255) CCDS project Id
supportLevel 2varchar(255) transcript support level
transcriptClass codingvarchar(255) pseudo, nonCoding, coding, or problem
transcriptRank 1int(11)  

Connected Tables and Joining Fields
        hg38.bioCycPathway.kgID (via knownAttrs.kgID)
      hg38.ccdsKgMap.geneId (via knownAttrs.kgID)
      hg38.ceBlastTab.query (via knownAttrs.kgID)
      hg38.dmBlastTab.query (via knownAttrs.kgID)
      hg38.drBlastTab.query (via knownAttrs.kgID)
      hg38.foldUtr3.name (via knownAttrs.kgID)
      hg38.foldUtr5.name (via knownAttrs.kgID)
      hg38.gnfAtlas2Distance.query (via knownAttrs.kgID)
      hg38.gnfAtlas2Distance.target (via knownAttrs.kgID)
      hg38.gnfU95Distance.query (via knownAttrs.kgID)
      hg38.gnfU95Distance.target (via knownAttrs.kgID)
      hg38.humanHprdP2P.query (via knownAttrs.kgID)
      hg38.humanHprdP2P.target (via knownAttrs.kgID)
      hg38.humanVidalP2P.query (via knownAttrs.kgID)
      hg38.humanVidalP2P.target (via knownAttrs.kgID)
      hg38.humanWankerP2P.query (via knownAttrs.kgID)
      hg38.humanWankerP2P.target (via knownAttrs.kgID)
      hg38.keggPathway.kgID (via knownAttrs.kgID)
      hg38.kgAlias.kgID (via knownAttrs.kgID)
      hg38.kgColor.kgID (via knownAttrs.kgID)
      hg38.kgProtAlias.kgID (via knownAttrs.kgID)
      hg38.kgSpAlias.kgID (via knownAttrs.kgID)
      hg38.kgTargetAli.qName (via knownAttrs.kgID)
      hg38.kgXref.kgID (via knownAttrs.kgID)
      hg38.knownBlastTab.query (via knownAttrs.kgID)
      hg38.knownBlastTab.target (via knownAttrs.kgID)
      hg38.knownCanonical.transcript (via knownAttrs.kgID)
      hg38.knownCds.name (via knownAttrs.kgID)
      hg38.knownGene.name (via knownAttrs.kgID)
      hg38.knownGeneMrna.name (via knownAttrs.kgID)
      hg38.knownGenePep.name (via knownAttrs.kgID)
      hg38.knownIsoforms.transcript (via knownAttrs.kgID)
      hg38.knownToEnsembl.name (via knownAttrs.kgID)
      hg38.knownToGnfAtlas2.name (via knownAttrs.kgID)
      hg38.knownToHprd.name (via knownAttrs.kgID)
      hg38.knownToKeggEntrez.name (via knownAttrs.kgID)
      hg38.knownToLocusLink.name (via knownAttrs.kgID)
      hg38.knownToLynx.name (via knownAttrs.kgID)
      hg38.knownToMrna.name (via knownAttrs.kgID)
      hg38.knownToMrnaSingle.name (via knownAttrs.kgID)
      hg38.knownToMupit.name (via knownAttrs.kgID)
      hg38.knownToNextProt.name (via knownAttrs.kgID)
      hg38.knownToPfam.name (via knownAttrs.kgID)
      hg38.knownToRefSeq.name (via knownAttrs.kgID)
      hg38.knownToSuper.gene (via knownAttrs.kgID)
      hg38.knownToTag.name (via knownAttrs.kgID)
      hg38.knownToU133.name (via knownAttrs.kgID)
      hg38.knownToU95.name (via knownAttrs.kgID)
      hg38.knownToVisiGene.name (via knownAttrs.kgID)
      hg38.knownToWikipedia.name (via knownAttrs.kgID)
      hg38.mmBlastTab.query (via knownAttrs.kgID)
      hg38.rnBlastTab.query (via knownAttrs.kgID)
      hg38.scBlastTab.query (via knownAttrs.kgID)
      hg38.ucscScop.ucscId (via knownAttrs.kgID)
      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)

Sample Rows
 
kgIDgeneIdgeneStatusgeneTypetranscriptNametranscriptTypetranscriptStatushavanaGeneIdccdsIdsupportLeveltranscriptClasstranscriptRank
ENST00000000233.10ENSG00000004059.12protein_codingARF5-201protein_codingOTTHUMG00000023246.7CCDS34745.12coding1
ENST00000000412.8ENSG00000003056.9protein_codingM6PR-201protein_codingOTTHUMG00000168276.4CCDS8598.12coding1
ENST00000000442.11ENSG00000173153.18protein_codingESRRA-201protein_codingOTTHUMG00000150641.9CCDS41667.12coding1
ENST00000001008.6ENSG00000004478.9protein_codingFKBP4-201protein_codingOTTHUMG00000090429.4CCDS8512.12coding1
ENST00000001146.7ENSG00000003137.9protein_codingCYP26B1-201protein_codingOTTHUMG00000129756.5CCDS1919.12coding1
ENST00000002125.9ENSG00000003509.17protein_codingNDUFAF7-201protein_codingOTTHUMG00000128468.7CCDS1788.12coding1
ENST00000002165.11ENSG00000001036.15protein_codingFUCA2-201protein_codingOTTHUMG00000015728.3CCDS5200.12coding1
ENST00000002501.11ENSG00000003249.16protein_codingDBNDD1-201protein_codingOTTHUMG00000138984.4CCDS42223.12coding1
ENST00000002596.6ENSG00000002587.11protein_codingHS3ST1-201protein_codingOTTHUMG00000090547.7CCDS3408.12coding1
ENST00000002829.8ENSG00000001617.13protein_codingSEMA3F-201protein_codingOTTHUMG00000156806.9CCDS2811.12coding1

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