Schema for knownAttrs
  Database: hg38    Primary Table: knownAttrs    Row Count: 272,178   Data last updated: 2022-05-15
Format description: Fields in Gencode attrs table that aren't in kgXref
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

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)

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

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