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	name2 Name2	cdsstartstat CdsStartStat	cdsendstat CdsEndStat	exonframes ExonFrames
585	g1.t1	chr2L	+	6485	10574	6590	9276	6	6485,7573,7979,8192,8667,10454,	6808,7910,8116,8589,9741,10574,	g1	cmpl	cmpl	0,2,0,2,0,-1,
585	g1.t2	chr2L	+	6485	10574	6590	9276	5	6485,7573,8192,8667,10454,	6808,8116,8589,9741,10574,	g1	cmpl	cmpl	0,2,2,0,-1,
585	g2.t1	chr2L	-	10706	40875	11770	40784	26	10706,12285,13519,13682,14932,22268,22527,22742,22993,23488,23928,26765,27052,28014,28460,28732,28981,30393,31783,33844,34557,34719,35745,38534,39300,40756,	12221,12928,13625,14874,15275,22446,22687,22935,23089,23873,24210,26964,27490,28211,28639,28926,29068,31723,33270,34288,34604,34912,38298,38731,39857,40875,	g2	cmpl	cmpl	2,1,0,2,1,0,2,1,1,0,0,2,2,0,1,2,2,1,2,2,0,2,2,0,1,0,
585	g3.t1	chr2L	+	56305	71879	67624	70895	6	56305,61885,67568,67891,68084,70606,	56356,61966,67762,68023,70549,71879,	g3	cmpl	cmpl	-1,-1,0,0,0,2,
585	g3.t2	chr2L	+	56305	76202	67624	76098	11	56305,66675,67568,67891,68084,70606,72597,74479,74902,75077,75426,	56356,67003,67762,68023,70549,70806,72977,74572,75018,75366,76202,	g3	cmpl	cmpl	-1,-1,0,0,0,2,1,0,0,2,0,
585	g4.t1	chr2L	-	81824	87415	83267	87062	2	81824,87019,	84277,87415,	g4	cmpl	cmpl	1,0,
585	g5.t1	chr2L	+	90635	104028	90688	103936	15	90635,94988,95131,95353,97883,98787,99658,99784,100571,100761,101015,101248,102583,103005,103877,	90813,95070,95301,97833,98470,99346,99723,100516,100703,100942,101194,101619,102906,103434,104028,	g5	cmpl	cmpl	0,2,0,2,1,0,1,0,0,0,1,0,2,1,1,
585	g5.t2	chr2L	+	94785	104145	94851	103936	15	94785,94988,95131,95353,97883,98787,99658,99784,100571,100761,101015,101248,102583,103005,103877,	94892,95070,95301,97833,98470,99346,99723,100516,100703,100909,101194,101619,102906,103434,104145,	g5	cmpl	cmpl	0,2,0,2,1,0,1,0,0,0,1,0,2,1,1,
585	g6.t1	chr2L	-	104058	106755	104472	106642	5	104058,105004,105390,105511,106038,	104947,105336,105455,105823,106755,	g6	cmpl	cmpl	2,0,1,1,0,
585	g7.t1	chr2L	+	107875	114304	108685	113542	7	107875,108147,110405,110754,111004,112689,113433,	108101,108809,110483,110877,111117,113369,114304,	g7	cmpl	cmpl	-1,0,1,1,1,0,2,


CREATE TABLE genes_augustus (
  "bin" BIGINT,
  "name" VARCHAR,
  "chrom" VARCHAR,
  "strand" VARCHAR,
  "txstart" BIGINT,
  "txend" BIGINT,
  "cdsstart" BIGINT,
  "cdsend" BIGINT,
  "exoncount" BIGINT,
  "exonstarts" VARCHAR,
  "exonends" VARCHAR,
  "score" BIGINT,
  "name2" VARCHAR,
  "cdsstartstat" VARCHAR,
  "cdsendstat" VARCHAR,
  "exonframes" VARCHAR
);