Schema for knownGene
  Database: mm7    Primary Table: knownGene    Row Count: 31,449   Data last updated: 2005-11-13
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 3211363int(10) unsigned range Transcription start position (or end position for minus strand item)
txEnd 3667076int(10) unsigned range Transcription end position (or start position for minus strand item)
cdsStart 3212903int(10) unsigned range Coding region start (or end position if for minus strand item)
cdsEnd 3666926int(10) unsigned range Coding region end (or start position if for minus strand item)
exonCount 3int(10) unsigned range Number of exons
exonStarts 3211363,3417279,3666129,longblob   Exon start positions (or end positions for minus strand item)
exonEnds 3213850,3417479,3667076,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)
      mm7.affyGnfU74ADistance.query (via knownGene.name)
      mm7.affyGnfU74ADistance.target (via knownGene.name)
      mm7.affyGnfU74BDistance.query (via knownGene.name)
      mm7.affyGnfU74BDistance.target (via knownGene.name)
      mm7.affyGnfU74CDistance.query (via knownGene.name)
      mm7.affyGnfU74CDistance.target (via knownGene.name)
      mm7.cgapAlias.alias (via knownGene.name)
      mm7.dmBlastTab.query (via knownGene.name)
      mm7.drBlastTab.query (via knownGene.name)
      mm7.dupSpMrna.mrnaID (via knownGene.name)
      mm7.foldUtr3.name (via knownGene.name)
      mm7.foldUtr5.name (via knownGene.name)
      mm7.gnfAtlas2Distance.query (via knownGene.name)
      mm7.gnfAtlas2Distance.target (via knownGene.name)
      mm7.hgBlastTab.query (via knownGene.name)
      mm7.keggPathway.kgID (via knownGene.name)
      mm7.kgAlias.kgID (via knownGene.name)
      mm7.kgProtAlias.kgID (via knownGene.name)
      mm7.kgSpAlias.kgID (via knownGene.name)
      mm7.kgXref.kgID (via knownGene.name)
      mm7.knownBlastTab.query (via knownGene.name)
      mm7.knownBlastTab.target (via knownGene.name)
      mm7.knownCanonical.transcript (via knownGene.name)
      mm7.knownGeneLink.name (via knownGene.name)
      mm7.knownGeneMrna.name (via knownGene.name)
      mm7.knownGenePep.name (via knownGene.name)
      mm7.knownIsoforms.transcript (via knownGene.name)
      mm7.knownToAllenBrain.name (via knownGene.name)
      mm7.knownToEnsembl.name (via knownGene.name)
      mm7.knownToGnfAtlas2.name (via knownGene.name)
      mm7.knownToKeggEntrez.name (via knownGene.name)
      mm7.knownToLocusLink.name (via knownGene.name)
      mm7.knownToPfam.name (via knownGene.name)
      mm7.knownToRefSeq.name (via knownGene.name)
      mm7.knownToVisiGene.name (via knownGene.name)
      mm7.rnBlastTab.query (via knownGene.name)
      mm7.scBlastTab.query (via knownGene.name)

Sample Rows
 
namechromstrandtxStarttxEndcdsStartcdsEndexonCountexonStartsexonEndsproteinIDalignID
NM_001011874chr1-321136336670763212903366692633211363,3417279,3666129,3213850,3417479,3667076,XKR4_MOUSER1
AK140060chr1+367573236773663676148367649013675732,3677366,Q3USV4_MOUSEG205663
NM_011283chr1-433973643559844340191434841744339736,4347501,4347793,4355791,4345683,4347673,4348429,4355984,RP1_MOUSER2
AK004781chr1-448651944920054487307448818354486519,4488691,4489363,4490727,4491882,4488260,4489058,4489455,4491534,4492005,Q61473-2U152286
NM_011441chr1-448651944920054487307448899854486519,4488691,4489363,4490727,4491882,4488260,4489058,4489455,4491534,4492005,SOX17_MOUSER3
NM_025300chr1-476880247813024770043478126954768802,4773116,4778159,4779542,4781164,4770108,4773240,4778325,4779697,4781302,Q9CPP5_MOUSER4
BC068230chr1-476880247813014772055478126954768802,4773116,4778159,4779542,4781164,4772393,4773240,4778325,4779697,4781301,Q9CPR5_MOUSEU20604
NM_008866chr1+480348448423264803505484060894803484,4804046,4824175,4825859,4827902,4832592,4834978,4836547,4840554,4803574,4804078,4824241,4825907,4827973,4832666,4835080,4836724,4842326,LYPA1_MOUSER5
AK050549chr1+480350948368524803520483675184803509,4804046,4824175,4825859,4827902,4832592,4834978,4836547,4803574,4804078,4824241,4825907,4827973,4832666,4835080,4836852,P97823-2G157848
NM_011541chr1+4853405489349448535054891956104853405,4863061,4873618,4882335,4885048,4886331,4887506,4889008,4890525,4891947,4853568,4863124,4873724,4882423,4885194,4886388,4887661,4889155,4890597,4893494,TCEA1_MOUSER6

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