Schema for knownAttrs
  Database: hg38    Primary Table: knownAttrs    Row Count: 276,905   Data last updated: 2023-08-22
Format description: Fields in Gencode attrs table that aren't in kgXref
On download server: MariaDB table dump directory
fieldexampleSQL type info description
kgID ENST00000000233.10varchar(255) values Known Gene ID
geneId ENSG00000004059.11varchar(255) values ENSG* locus identifier
geneStatus  varchar(255) values KNOWN or NOVEL
geneType protein_codingvarchar(255) values gene function
transcriptName ARF5-201varchar(255) values transcript Name
transcriptType protein_codingvarchar(255) values transcript Type
transcriptStatus  varchar(255) values KNOWN or NOVEL or PUTATIVE
havanaGeneId OTTHUMG00000023246.7varchar(255) values Havana project Id
ccdsId CCDS34745.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
        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.11protein_codingARF5-201protein_codingOTTHUMG00000023246.7CCDS34745.12coding1
ENST00000000412.8ENSG00000003056.8protein_codingM6PR-201protein_codingOTTHUMG00000168276.4CCDS8598.12coding1
ENST00000000442.11ENSG00000173153.17protein_codingESRRA-201protein_codingOTTHUMG00000150641.9CCDS41667.12coding1
ENST00000001008.6ENSG00000004478.8protein_codingFKBP4-201protein_codingOTTHUMG00000090429.4CCDS8512.12coding1
ENST00000001146.7ENSG00000003137.9protein_codingCYP26B1-201protein_codingOTTHUMG00000129756.5CCDS1919.12coding1
ENST00000002125.9ENSG00000003509.16protein_codingNDUFAF7-201protein_codingOTTHUMG00000128468.7CCDS1788.12coding1
ENST00000002165.11ENSG00000001036.14protein_codingFUCA2-201protein_codingOTTHUMG00000015728.3CCDS5200.12coding1
ENST00000002501.11ENSG00000003249.15protein_codingDBNDD1-201protein_codingOTTHUMG00000138984.4CCDS42223.12coding1
ENST00000002596.6ENSG00000002587.10protein_codingHS3ST1-201protein_codingOTTHUMG00000090547.7CCDS3408.12coding1
ENST00000002829.8ENSG00000001617.12protein_codingSEMA3F-201protein_codingOTTHUMG00000156806.9CCDS2811.12coding1

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