Schema for knownGene
  Database: hg17    Primary Table: knownGene    Row Count: 39,368   Data last updated: 2005-06-03
Format description: Transcript from default gene set in UCSC browser
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name BC073913varchar(255) values Name of gene
chrom chr1varchar(255) values Reference sequence chromosome or scaffold
strand -char(1) values + or - for strand
txStart 4268int(10) unsigned range Transcription start position (or end position for minus strand item)
txEnd 7438int(10) unsigned range Transcription end position (or start position for minus strand item)
cdsStart 6607int(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 6int(10) unsigned range Number of exons
exonStarts 4268,4832,5658,6469,6720,7095,longblob   Exon start positions (or end positions for minus strand item)
exonEnds 4692,4901,5810,6628,6918,7438,longblob   Exon end positions (or start positions for minus strand item)
proteinID Q6GMS0_HUMANvarchar(40) values UniProt display ID, UniProt accession, or RefSeq protein ID
alignID G220323varchar(8) values Unique identifier (GENCODE transcript ID for GENCODE Basic)

Connected Tables and Joining Fields
        hg17.bioCycPathway.kgID (via knownGene.name)
      hg17.blastKGPep01.name (via knownGene.name)
      hg17.blastKGPep02.name (via knownGene.name)
      hg17.blastKGRef01.acc (via knownGene.name)
      hg17.blastKGRef02.acc (via knownGene.name)
      hg17.ccdsKgMap.geneId (via knownGene.name)
      hg17.ceBlastTab.query (via knownGene.name)
      hg17.cgapAlias.alias (via knownGene.name)
      hg17.dmBlastTab.query (via knownGene.name)
      hg17.drBlastTab.query (via knownGene.name)
      hg17.dupSpMrna.mrnaID (via knownGene.name)
      hg17.foldUtr3.name (via knownGene.name)
      hg17.foldUtr5.name (via knownGene.name)
      hg17.gladHumESDistance.query (via knownGene.name)
      hg17.gladHumESDistance.target (via knownGene.name)
      hg17.gnfAtlas2Distance.query (via knownGene.name)
      hg17.gnfAtlas2Distance.target (via knownGene.name)
      hg17.gnfU95Distance.query (via knownGene.name)
      hg17.gnfU95Distance.target (via knownGene.name)
      hg17.humanHprdP2P.query (via knownGene.name)
      hg17.humanHprdP2P.target (via knownGene.name)
      hg17.humanVidalP2P.query (via knownGene.name)
      hg17.humanVidalP2P.target (via knownGene.name)
      hg17.humanWankerP2P.query (via knownGene.name)
      hg17.humanWankerP2P.target (via knownGene.name)
      hg17.keggPathway.kgID (via knownGene.name)
      hg17.kgAlias.kgID (via knownGene.name)
      hg17.kgProtAlias.kgID (via knownGene.name)
      hg17.kgSpAlias.kgID (via knownGene.name)
      hg17.kgTargetAli.qName (via knownGene.name)
      hg17.kgXref.kgID (via knownGene.name)
      hg17.knownBlastTab.query (via knownGene.name)
      hg17.knownBlastTab.target (via knownGene.name)
      hg17.knownCanonical.transcript (via knownGene.name)
      hg17.knownExpDistance.query (via knownGene.name)
      hg17.knownExpDistance.target (via knownGene.name)
      hg17.knownGeneLink.name (via knownGene.name)
      hg17.knownGeneMrna.name (via knownGene.name)
      hg17.knownGenePep.name (via knownGene.name)
      hg17.knownIsoforms.transcript (via knownGene.name)
      hg17.knownToAllenBrain.name (via knownGene.name)
      hg17.knownToEnsembl.name (via knownGene.name)
      hg17.knownToGnf1h.name (via knownGene.name)
      hg17.knownToGnfAtlas2.name (via knownGene.name)
      hg17.knownToHInv.name (via knownGene.name)
      hg17.knownToHprd.name (via knownGene.name)
      hg17.knownToKeggEntrez.name (via knownGene.name)
      hg17.knownToLocusLink.name (via knownGene.name)
      hg17.knownToPfam.name (via knownGene.name)
      hg17.knownToRefSeq.name (via knownGene.name)
      hg17.knownToSuper.gene (via knownGene.name)
      hg17.knownToU133.name (via knownGene.name)
      hg17.knownToU133Plus2.name (via knownGene.name)
      hg17.knownToU95.name (via knownGene.name)
      hg17.knownToVisiGene.name (via knownGene.name)
      hg17.mmBlastTab.query (via knownGene.name)
      hg17.rankProp.query (via knownGene.name)
      hg17.rankProp.target (via knownGene.name)
      hg17.rnBlastTab.query (via knownGene.name)
      hg17.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
BC073913chr1-426874386607717364268,4832,5658,6469,6720,7095,4692,4901,5810,6628,6918,7438,Q6GMS0_HUMANG220323
AF346307chr1-24416259442500025599324416,25139,25583,25037,25344,25944,Q8NG00_HUMANG163921
NM_001005484chr1+58953598715895359871158953,59871,OR4F5_HUMANR21338
NM_001005221chr1+4075214084604075214084601407521,408460,OR4F3_HUMANR21036
NM_001005221chr1-6609586618976609586618971660958,661897,OR4F3_HUMANR21038
AK097327chr1+7926137950777927527932322792613,793965,793445,795077,Q8N852_HUMANG163926
NM_024796chr1-8014498027498019428024341801449,802749,Q9H632_HUMANR1
AK096928chr1-8928178962598957358961791892817,896259,Q8N8E4_HUMANG163929
BC024295chr1+91128892009791483291967610911288,914562,914797,916666,917658,917932,918081,918775,919220,919430,911419,914652,914935,916829,917774,918011,918581,918900,919331,920097,Q8TB59_HUMANG163930
AK054643chr1+9147959197829148329196767914795,916666,917658,917932,918081,918775,919220,914983,916829,917774,918011,918581,918900,919782,Q8N195_HUMANG163931

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