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	FBtr0300690.1	chr2L	+	7528	9484	7679	9276	3	7528,8192,8667,	8116,8589,9484,	FBgn0031208.1	cmpl	cmpl	0,2,0,
585	FBtr0330654.1	chr2L	+	7528	9484	7679	8610	2	7528,8228,	8116,9484,	FBgn0031208.1	cmpl	cmpl	0,2,
585	FBtr0300689.1	chr2L	+	7528	9484	7679	8610	2	7528,8192,	8116,9484,	FBgn0031208.1	cmpl	cmpl	0,2,
585	FBtr0306589.1	chr2L	-	9838	21376	11214	17136	10	9838,11409,11778,12285,13519,13682,14932,17052,19879,21135,	11344,11518,12221,12928,13625,14874,15711,17212,20015,21376,	FBgn0002121.1	cmpl	cmpl	2,1,2,1,0,2,0,0,-1,-1,
585	FBtr0078169.1	chr2L	-	9838	21376	11214	15648	10	9838,11409,11778,12285,13519,13682,14932,19879,21065,21348,	11344,11518,12221,12928,13625,14874,15711,20020,21200,21376,	FBgn0002121.1	cmpl	cmpl	2,1,2,1,0,2,0,-1,-1,-1,
585	FBtr0330655.1	chr2L	-	9838	21376	11309	17136	9	9838,11778,12285,13519,13682,14932,17052,19879,21065,	11344,12221,12928,13625,14874,15711,17212,20020,21376,	FBgn0002121.1	cmpl	cmpl	1,2,1,0,2,0,0,-1,-1,
585	FBtr0306592.1	chr2L	-	9838	21376	11214	17136	11	9838,11409,11778,12285,13519,13682,14932,17052,19879,20830,21065,	11344,11518,12221,12928,13625,14874,15711,17212,20015,20973,21376,	FBgn0002121.1	cmpl	cmpl	2,1,2,1,0,2,0,0,-1,-1,-1,
585	FBtr0078170.1	chr2L	-	9838	18570	11214	17136	9	9838,11409,11778,12285,13519,13682,14932,17052,18260,	11344,11518,12221,12928,13625,14874,15711,17212,18570,	FBgn0002121.1	cmpl	cmpl	2,1,2,1,0,2,0,0,-1,
585	FBtr0078168.1	chr2L	-	9838	21376	11214	15648	9	9838,11409,11778,12285,13519,13682,14932,19879,21065,	11344,11518,12221,12928,13625,14874,15711,20015,21376,	FBgn0002121.1	cmpl	cmpl	2,1,2,1,0,2,0,-1,-1,
585	FBtr0078167.1	chr2L	-	9838	21376	11214	15648	9	9838,11409,11778,12285,13519,13682,14932,19879,21065,	11344,11518,12221,12928,13625,14874,15711,20020,21376,	FBgn0002121.1	cmpl	cmpl	2,1,2,1,0,2,0,-1,-1,


CREATE TABLE genes_ensembl (
  "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
);