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
777	NM_005051	chr3R	-	25263316	25265638	25263337	25265638	5	25263316,25263487,25263877,25265278,25265596,	25263463,25263649,25264975,25265347,25265638,	QARS	incmpl	cmpl	0,0,0,0,0,
776	NM_021758	chr3R	-	25064649	25065415	25064649	25065415	3	25064649,25064860,25065145,	25064796,25064992,25065415,	Lin7b	incmpl	incmpl	0,0,0,
585	NM_020812	chr2L	+	95834	101578	95834	101578	12	95834,96764,98991,99000,99378,99468,99769,99784,100577,100764,101032,101425,	96002,97115,98997,99018,99438,99720,99772,100495,100700,100929,101194,101578,	DOCK6	incmpl	incmpl	0,0,2,0,0,0,0,0,0,0,0,0,
736	NM_001172995	chr3L	+	19858461	19860590	19858461	19860590	6	19858461,19858811,19858862,19859398,19859572,19860482,	19858489,19858837,19859242,19859527,19860250,19860590,	Papss1	incmpl	incmpl	0,1,1,0,0,0,
612	NM_001196298	chr2R	-	3590032	3590326	3590032	3590326	1	3590032,	3590326,	LOC100501614	incmpl	incmpl	0,
606	NM_001242674	chr3L	-	2769383	2771474	2769383	2771474	3	2769383,2770047,2771267,	2769977,2770491,2771474,	AHCYL1	incmpl	cmpl	0,0,0,
585	NM_001191574	chr2L	+	95774	101584	95774	101584	11	95774,96017,96182,96824,99468,99784,100577,100764,101017,101248,101425,	95987,96125,96272,97121,99723,100495,100700,100923,101194,101392,101584,	Dock7	incmpl	incmpl	0,0,0,0,0,0,0,0,0,0,0,
749	NM_001193191	chr3R	+	21507147	21512115	21507147	21512115	2	21507147,21512049,	21507360,21512115,	TLX3	incmpl	incmpl	0,0,
88	NM_001301152	chr2R	-	15858189	15860446	15858189	15860446	6	15858189,15858498,15859080,15860008,15860200,15860378,	15858258,15858837,15859938,15860119,15860306,15860446,	GPD2	incmpl	incmpl	0,0,2,0,2,0,
721	NM_001301150	chr3L	+	17847615	17849016	17847615	17849016	4	17847615,17847987,17848137,17848422,	17847933,17848071,17848398,17849016,	DLD	incmpl	incmpl	0,0,0,0,


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