Schema for knownAttrs
  Database: mm10    Primary Table: knownAttrs    Row Count: 142,446   Data last updated: 2019-09-27
Format description: Fields in Gencode attrs table that aren't in kgXref
fieldexampleSQL type info description
kgID ENSMUST00000193812.1varchar(255) values Known Gene ID
geneId ENSMUSG00000102693.1varchar(255) values ENSG* locus identifier
geneStatus  varchar(255) values KNOWN or NOVEL
geneType TECvarchar(255) values gene function
transcriptName 4933401J01Rik-201varchar(255) values transcript Name
transcriptType TECvarchar(255) values transcript Type
transcriptStatus  varchar(255) values KNOWN or NOVEL or PUTATIVE
havanaGeneId OTTMUSG00000049935.1varchar(255) values Havana project Id
ccdsId  varchar(255) values CCDS project Id
supportLevel 2varchar(255) values transcript support level
transcriptClass problemvarchar(255) values pseudo, nonCoding, coding, or problem

Connected Tables and Joining Fields
        mm10.bioCycPathway.kgID (via knownAttrs.kgID)
      mm10.ccdsKgMap.geneId (via knownAttrs.kgID)
      mm10.ceBlastTab.query (via knownAttrs.kgID)
      mm10.dmBlastTab.query (via knownAttrs.kgID)
      mm10.drBlastTab.query (via knownAttrs.kgID)
      mm10.foldUtr3.name (via knownAttrs.kgID)
      mm10.foldUtr5.name (via knownAttrs.kgID)
      mm10.hgBlastTab.query (via knownAttrs.kgID)
      mm10.keggPathway.kgID (via knownAttrs.kgID)
      mm10.kgAlias.kgID (via knownAttrs.kgID)
      mm10.kgColor.kgID (via knownAttrs.kgID)
      mm10.kgProtAlias.kgID (via knownAttrs.kgID)
      mm10.kgProtMap2.qName (via knownAttrs.kgID)
      mm10.kgSpAlias.kgID (via knownAttrs.kgID)
      mm10.kgTargetAli.qName (via knownAttrs.kgID)
      mm10.kgTxInfo.name (via knownAttrs.kgID)
      mm10.kgXref.kgID (via knownAttrs.kgID)
      mm10.knownBlastTab.query (via knownAttrs.kgID)
      mm10.knownBlastTab.target (via knownAttrs.kgID)
      mm10.knownCanonical.transcript (via knownAttrs.kgID)
      mm10.knownCds.name (via knownAttrs.kgID)
      mm10.knownGene.name (via knownAttrs.kgID)
      mm10.knownGeneMrna.name (via knownAttrs.kgID)
      mm10.knownGenePep.name (via knownAttrs.kgID)
      mm10.knownIsoforms.transcript (via knownAttrs.kgID)
      mm10.knownToEnsembl.name (via knownAttrs.kgID)
      mm10.knownToKeggEntrez.name (via knownAttrs.kgID)
      mm10.knownToLocusLink.name (via knownAttrs.kgID)
      mm10.knownToLynx.name (via knownAttrs.kgID)
      mm10.knownToMrna.name (via knownAttrs.kgID)
      mm10.knownToMrnaSingle.name (via knownAttrs.kgID)
      mm10.knownToPfam.name (via knownAttrs.kgID)
      mm10.knownToRefSeq.name (via knownAttrs.kgID)
      mm10.knownToSuper.gene (via knownAttrs.kgID)
      mm10.knownToTag.name (via knownAttrs.kgID)
      mm10.knownToVisiGene.name (via knownAttrs.kgID)
      mm10.knownToWikipedia.name (via knownAttrs.kgID)
      mm10.rnBlastTab.query (via knownAttrs.kgID)
      mm10.scBlastTab.query (via knownAttrs.kgID)
      mm10.ucscScop.ucscId (via knownAttrs.kgID)

Sample Rows
 
kgIDgeneIdgeneStatusgeneTypetranscriptNametranscriptTypetranscriptStatushavanaGeneIdccdsIdsupportLeveltranscriptClass
ENSMUST00000193812.1ENSMUSG00000102693.1TEC4933401J01Rik-201TECOTTMUSG00000049935.12problem
ENSMUST00000082908.1ENSMUSG00000064842.1snRNAGm26206-201snRNA3nonCoding
ENSMUST00000162897.1ENSMUSG00000051951.5protein_codingXkr4-203lncRNAOTTMUSG00000026353.22nonCoding
ENSMUST00000159265.1ENSMUSG00000051951.5protein_codingXkr4-202lncRNAOTTMUSG00000026353.22nonCoding
ENSMUST00000070533.4ENSMUSG00000051951.5protein_codingXkr4-201protein_codingOTTMUSG00000026353.2CCDS14803.12coding
ENSMUST00000192857.1ENSMUSG00000102851.1processed_pseudogeneGm18956-201processed_pseudogeneOTTMUSG00000049958.11pseudo
ENSMUST00000195335.1ENSMUSG00000103377.1TECGm37180-201TECOTTMUSG00000049960.12problem
ENSMUST00000192336.1ENSMUSG00000104017.1TECGm37363-201TECOTTMUSG00000049961.12problem
ENSMUST00000194099.1ENSMUSG00000103025.1TECGm37686-201TECOTTMUSG00000049930.12problem
ENSMUST00000161581.1ENSMUSG00000089699.1lncRNAGm1992-201lncRNAOTTMUSG00000026352.12nonCoding

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