Schema for knownGene
  Database: mm8    Primary Table: knownGene    Row Count: 31,863   Data last updated: 2006-02-27
Format description: Transcript from default gene set in UCSC browser
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name NM_001011874varchar(255) values Name of gene
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
strand -char(1) values + or - for strand
txStart 3204562int(10) unsigned range Transcription start position (or end position for minus strand item)
txEnd 3661579int(10) unsigned range Transcription end position (or start position for minus strand item)
cdsStart 3206102int(10) unsigned range Coding region start (or end position if for minus strand item)
cdsEnd 3661429int(10) unsigned range Coding region end (or start position if for minus strand item)
exonCount 3int(10) unsigned range Number of exons
exonStarts 3204562,3411782,3660632,longblob   Exon start positions (or end positions for minus strand item)
exonEnds 3207049,3411982,3661579,longblob   Exon end positions (or start positions for minus strand item)
proteinID XKR4_MOUSEvarchar(40) values UniProt display ID, UniProt accession, or RefSeq protein ID
alignID R1varchar(8) values Unique identifier (GENCODE transcript ID for GENCODE Basic)

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

Sample Rows
 
namechromstrandtxStarttxEndcdsStartcdsEndexonCountexonStartsexonEndsproteinIDalignID
NM_001011874chr1-320456236615793206102366142933204562,3411782,3660632,3207049,3411982,3661579,XKR4_MOUSER1
AK140060chr1+367023536718693670651367099313670235,3671869,Q3USV4_MOUSEG168464
NM_011283chr1-433422543504734334680434290644334225,4341990,4342282,4350280,4340172,4342162,4342918,4350473,RP1_MOUSER2
AK004781chr1-448100844864944481796448267254481008,4483180,4483852,4485216,4486371,4482749,4483547,4483944,4486023,4486494,Q61473-2U95834
NM_011441chr1-448100844864944481796448348754481008,4483180,4483852,4485216,4486371,4482749,4483547,4483944,4486023,4486494,SOX17_MOUSER3
NM_025300chr1-476329147757914764532477575854763291,4767605,4772648,4774031,4775653,4764597,4767729,4772814,4774186,4775791,Q9CPP5_MOUSER4
BC068230chr1-476329147757904766544477575854763291,4767605,4772648,4774031,4775653,4766882,4767729,4772814,4774186,4775790,Q9CPR5_MOUSEU147577
NM_008866chr1+479797348368154797994483509794797973,4798535,4818664,4820348,4822391,4827081,4829467,4831036,4835043,4798063,4798567,4818730,4820396,4822462,4827155,4829569,4831213,4836815,LYPA1_MOUSER5
AK050549chr1+479799848313414798009483124084797998,4798535,4818664,4820348,4822391,4827081,4829467,4831036,4798063,4798567,4818730,4820396,4822462,4827155,4829569,4831341,P97823-2G168484
NM_011541chr1+4847894488798348479944886445104847894,4857550,4868107,4876824,4879537,4880820,4881995,4883497,4885014,4886436,4848057,4857613,4868213,4876912,4879683,4880877,4882150,4883644,4885086,4887983,TCEA1_MOUSER6

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