Schema for ensGene
  Database: macEug1    Primary Table: ensGene    Row Count: 53,057   Data last updated: 2012-08-24
On download server: MariaDB table dump directory
fieldexampleSQL type info
bin 585smallint(5) unsigned range
name ENSMEUT00000010658varchar(255) values
chrom Scaffold10varchar(255) values
strand -char(1) values
txStart 48310int(10) unsigned range
txEnd 48444int(10) unsigned range
cdsStart 48310int(10) unsigned range
cdsEnd 48444int(10) unsigned range
exonCount 1int(10) unsigned range
exonStarts 48310,longblob  
exonEnds 48444,longblob  
score 0int(11) range
name2 ENSMEUG00000010607varchar(255) values
cdsStartStat incmplenum('none', 'unk', 'incmpl', 'cmpl') values
cdsEndStat incmplenum('none', 'unk', 'incmpl', 'cmpl') values
exonFrames 0,longblob  

Connected Tables and Joining Fields
        knownGeneV39.knownToEnsembl.value (via ensGene.name)
      macEug1.ensGtp.transcript (via ensGene.name)
      macEug1.ensPep.name (via ensGene.name)
      macEug1.ensemblSource.name (via ensGene.name)
      macEug1.ensemblToGeneName.name (via ensGene.name)

Sample Rows
 
binnamechromstrandtxStarttxEndcdsStartcdsEndexonCountexonStartsexonEndsscorename2cdsStartStatcdsEndStatexonFrames
585ENSMEUT00000010658Scaffold10-48310484444831048444148310,48444,0ENSMEUG00000010607incmplincmpl0,
585ENSMEUT00000004047Scaffold10+1010301057381010301057389101030,101110,101117,101130,101141,102865,104981,105542,105736,101108,101116,101129,101139,101225,102957,105135,105735,105738,0ENSMEUG00000004037cmplcmpl0,0,0,0,0,0,2,0,1,
585ENSMEUT00000004068Scaffold10-1079641241351079641241357107964,108193,108883,112065,113966,114688,124062,108065,108385,109009,112171,114101,114775,124135,0ENSMEUG00000004053incmplcmpl1,1,1,0,0,0,0,
585ENSMEUT00000016218Scaffold100+74384744497438474449174384,74449,0ENSMEUG00000016181incmplincmpl0,
585ENSMEUT00000011549Scaffold100+81831867048183186704281831,86550,81906,86704,0ENSMEUG00000011515cmplincmpl0,0,
585ENSMEUT00000004961Scaffold10000+33012338703301233870333012,33628,33765,33627,33744,33870,0ENSMEUG00000004951cmplincmpl1,1,0,
585ENSMEUT00000010342Scaffold100008-746575277465752717465,7527,0ENSMEUG00000010297incmplcmpl0,
585ENSMEUT00000012944Scaffold100022-10076101961007610196110076,10196,0ENSMEUG00000012905cmplincmpl0,
585ENSMEUT00000003433Scaffold100027+809887880988784809,3035,3199,8703,938,3197,3286,8878,0ENSMEUG00000003404incmplincmpl0,0,0,0,
585ENSMEUT00000012187Scaffold10003+27830278672783027867127830,27867,0ENSMEUG00000012163cmplcmpl2,

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