Schema for knownGene
  Database: hg16    Primary Table: knownGene    Row Count: 43,232   Data last updated: 2004-03-27
Format description: Transcript from default gene set in UCSC browser
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name BC063682varchar(255) values Name of gene
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
strand -char(1) values + or - for strand
txStart 4224int(10) unsigned range Transcription start position (or end position for minus strand item)
txEnd 7502int(10) unsigned range Transcription end position (or start position for minus strand item)
cdsStart 4558int(10) unsigned range Coding region start (or end position if for minus strand item)
cdsEnd 7173int(10) unsigned range Coding region end (or start position if for minus strand item)
exonCount 7int(10) unsigned range Number of exons
exonStarts 4224,4832,5658,6469,6719,70...longblob   Exon start positions (or end positions for minus strand item)
exonEnds 4692,4901,5810,6631,6918,72...longblob   Exon end positions (or start positions for minus strand item)
proteinID AAH63682varchar(40) values UniProt display ID, UniProt accession, or RefSeq protein ID
alignID 2425varchar(8) values Unique identifier (GENCODE transcript ID for GENCODE Basic)

Connected Tables and Joining Fields
        hg16.bioCycPathway.kgID (via knownGene.name)
      hg16.cgapAlias.alias (via knownGene.name)
      hg16.dmBlastTab.query (via knownGene.name)
      hg16.drBlastTab.query (via knownGene.name)
      hg16.dupSpMrna.mrnaID (via knownGene.name)
      hg16.foldUtr3.name (via knownGene.name)
      hg16.foldUtr5.name (via knownGene.name)
      hg16.gnfAtlas2Distance.query (via knownGene.name)
      hg16.gnfAtlas2Distance.target (via knownGene.name)
      hg16.gnfU95Distance.query (via knownGene.name)
      hg16.gnfU95Distance.target (via knownGene.name)
      hg16.hg17Kg.name (via knownGene.name)
      hg16.keggPathway.kgID (via knownGene.name)
      hg16.kgAlias.kgID (via knownGene.name)
      hg16.kgProtAlias.kgID (via knownGene.name)
      hg16.kgXref.kgID (via knownGene.name)
      hg16.knownBlastTab.query (via knownGene.name)
      hg16.knownBlastTab.target (via knownGene.name)
      hg16.knownCanonical.transcript (via knownGene.name)
      hg16.knownGeneLink.name (via knownGene.name)
      hg16.knownGeneMrna.name (via knownGene.name)
      hg16.knownGenePep.name (via knownGene.name)
      hg16.knownIsoforms.transcript (via knownGene.name)
      hg16.knownToEnsembl.name (via knownGene.name)
      hg16.knownToGnfAtlas2.name (via knownGene.name)
      hg16.knownToHInv.name (via knownGene.name)
      hg16.knownToLocusLink.name (via knownGene.name)
      hg16.knownToPfam.name (via knownGene.name)
      hg16.knownToRefSeq.name (via knownGene.name)
      hg16.knownToSuper.gene (via knownGene.name)
      hg16.knownToU133.name (via knownGene.name)
      hg16.knownToU95.name (via knownGene.name)
      hg16.scBlastTab.query (via knownGene.name)
      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)

Sample Rows
 
namechromstrandtxStarttxEndcdsStartcdsEndexonCountexonStartsexonEndsproteinIDalignID
BC063682chr1-422475024558717374224,4832,5658,6469,6719,7095,7468,4692,4901,5810,6631,6918,7231,7502,AAH636822425
AL137714chr1-42661934674131934684266,4832,6720,7095,7777,8130,14600,19183,4692,6628,6918,7605,7924,8229,14754,19346,Q9NSV741739
BC015400chr1-426858084558580834268,4832,5658,4692,4901,5808,Q96BN332430
BC048328chr1-426814754455814749104268,4832,5658,6469,6719,7095,7468,7777,8130,14600,4692,4901,5810,6631,6918,7231,7605,7924,8242,14754,Q86TK920915
BX537637chr1-426819672427319433124268,4427,4867,5658,6469,6720,7095,7468,7777,8130,14600,19396,4363,4434,4901,5810,6628,6918,7231,7605,7924,8229,14754,19672,Q7Z3N419370
AK024481chr1-426985966607725124269,6720,6628,8596,Q9H7J939841
AY217347chr1-4271962245587173114271,4832,5658,6469,6600,6719,7095,7468,7777,8130,8775,4692,4901,5810,6590,6631,6918,7231,7605,7924,8242,9622,Q86WN021802
AK024448chr1-10369192001417119200210369,19183,14754,19200,Q9H7N039871
AF346307chr1-24416259442500025599324416,25139,25583,25037,25344,25944,Q8NG0029040
AK128780chr1-1247761293221255741275743124776,127240,129109,126020,127929,129322,BAC876099630

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