Drosophila Melanogaster Genome

bin Bin	name Name	chrom Chrom	strand Strand	txstart TxStart	txend TxEnd	cdsstart CdsStart	cdsend CdsEnd	exoncount ExonCount	exonstarts ExonStarts	exonends ExonEnds
585	chr2L.1	chr2L	+	7573	9276	7573	9276	3	7573,8228,8667,	8116,8589,9276,
585	chr2L.2	chr2L	-	11770	19944	11770	19944	5	11770,12285,13678,14932,19884,	12221,12850,14874,15711,19944,
585	chr2L.3	chr2L	-	21918	25004	21918	25004	4	21918,22742,23488,24746,	22687,22935,23744,25004,
585	chr2L.4	chr2L	-	27048	41395	27048	41395	12	27048,28014,28732,30393,31783,33904,34557,34719,35745,38534,39300,41175,	27484,28358,28817,31723,33270,34288,34604,34912,38298,38731,39857,41395,
585	chr2L.5	chr2L	+	67624	76098	67624	76098	8	67624,67891,68084,70606,72660,73494,74902,75077,	67762,68023,70549,70869,72977,73692,75018,76098,
585	chr2L.6	chr2L	+	76430	79199	76430	79199	2	76430,79098,	77583,79199,
585	chr2L.7	chr2L	-	83267	92232	83267	92232	3	83267,91152,92138,	84277,91233,92232,
585	chr2L.8	chr2L	+	94851	103763	94851	103763	9	94851,95353,97883,98526,99784,101332,102553,103005,103515,	94892,97833,98470,99486,100516,101619,102906,103434,103763,
585	chr2L.9	chr2L	-	104472	106642	104472	106642	3	104472,105511,106038,	104918,105850,106642,
585	chr2L.10	chr2L	+	108685	113542	108685	113542	6	108685,110405,110754,111004,112689,113433,	108809,110483,110877,111117,113369,113542,


CREATE TABLE genes_genscan (
  "bin" BIGINT,
  "name" VARCHAR,
  "chrom" VARCHAR,
  "strand" VARCHAR,
  "txstart" BIGINT,
  "txend" BIGINT,
  "cdsstart" BIGINT,
  "cdsend" BIGINT,
  "exoncount" BIGINT,
  "exonstarts" VARCHAR,
  "exonends" VARCHAR
);