Drosophila Melanogaster Genome

bin Bin	chrom Chrom	chromstart ChromStart	chromend ChromEnd	name Name	period Period	copynum CopyNum	consensussize ConsensusSize	permatch PerMatch	perindel PerIndel	score Score	a A	c C	g G	t T	entropy Entropy	sequence Sequence
585	chr2L		5204	trf	458	11.4	458	99		10363	31	19	20	28	1.97	CGACAATGCACGACAGAGGAAGCAGAACAGATATTTAGATTGCCTCTCATTTTCTCTCCCATATTATAGGGAGAAATATGATCGCGTATGCGAGAGTAGTGCCAACATATTGTGCTCTTTGATTTTTTGGCAACCCAAAATGGTGGCGGATGAACGAGATGATAATATATTCAAGTTGCCGCTAATCAGAAATAAATTCATTGCAACGTTAAATACAGCACAATATATGATCGCGTATGCGAGAGTAGTGCCAACATATTGTGCTAATGAGTGCCTCTCGTTCTCTGTCTTATATTACCG…
585	chr2L	224	503	trf	147	2	137	84	11	357	31	21	20	26	1.98	ATATGATCGCGTATGCGAGAGTAGTGCCAACATATTGTGCCATAATGACTGCCTCTCATTCTGTCTTATATTACCGCAAACCCAAAAAGACAATACACGACAGAGGAAGCAGAACAGATATTTAGATTGCCTATTAA
585	chr2L	682	961	trf	147	2	137	84	11	357	31	21	20	26	1.98	ATATGATCGCGTATGCGAGAGTAGTGCCAACATATTGTGCCATAATGACTGCCTCTCATTCTGTCTTATATTACCGCAAACCCAAAAAGACAATACACGACAGAGGAAGCAGAACAGATATTTAGATTGCCTATTAA
585	chr2L	1140	1419	trf	147	2	137	84	11	357	31	21	20	26	1.98	ATATGATCGCGTATGCGAGAGTAGTGCCAACATATTGTGCCATAATGACTGCCTCTCATTCTGTCTTATATTACCGCAAACCCAAAAAGACAATACACGACAGAGGAAGCAGAACAGATATTTAGATTGCCTATTAA
585	chr2L	1598	1877	trf	147	2	137	84	11	357	31	21	20	26	1.98	ATATGATCGCGTATGCGAGAGTAGTGCCAACATATTGTGCCATAATGACTGCCTCTCATTCTGTCTTATATTACCGCAAACCCAAAAAGACAATACACGACAGAGGAAGCAGAACAGATATTTAGATTGCCTATTAA
585	chr2L	2056	2335	trf	147	2	137	84	11	357	31	21	20	26	1.98	ATATGATCGCGTATGCGAGAGTAGTGCCAACATATTGTGCCATAATGACTGCCTCTCATTCTGTCTTATATTACCGCAAACCCAAAAAGACAATACACGACAGAGGAAGCAGAACAGATATTTAGATTGCCTATTAA
585	chr2L	2514	2793	trf	147	2	137	84	11	357	31	21	20	26	1.98	ATATGATCGCGTATGCGAGAGTAGTGCCAACATATTGTGCCATAATGACTGCCTCTCATTCTGTCTTATATTACCGCAAACCCAAAAAGACAATACACGACAGAGGAAGCAGAACAGATATTTAGATTGCCTATTAA
585	chr2L	2972	3251	trf	147	2	137	84	11	357	31	21	20	26	1.98	ATATGATCGCGTATGCGAGAGTAGTGCCAACATATTGTGCCATAATGACTGCCTCTCATTCTGTCTTATATTACCGCAAACCCAAAAAGACAATACACGACAGAGGAAGCAGAACAGATATTTAGATTGCCTATTAA
585	chr2L	3430	3709	trf	147	2	137	84	11	357	31	21	20	26	1.98	ATATGATCGCGTATGCGAGAGTAGTGCCAACATATTGTGCCATAATGACTGCCTCTCATTCTGTCTTATATTACCGCAAACCCAAAAAGACAATACACGACAGAGGAAGCAGAACAGATATTTAGATTGCCTATTAA
585	chr2L	3888	4167	trf	147	2	137	84	11	357	31	21	20	26	1.98	ATATGATCGCGTATGCGAGAGTAGTGCCAACATATTGTGCCATAATGACTGCCTCTCATTCTGTCTTATATTACCGCAAACCCAAAAAGACAATACACGACAGAGGAAGCAGAACAGATATTTAGATTGCCTATTAA


CREATE TABLE meta_simple_repeat (
  "bin" BIGINT,
  "chrom" VARCHAR,
  "chromstart" BIGINT,
  "chromend" BIGINT,
  "name" VARCHAR,
  "period" BIGINT,
  "copynum" DOUBLE,
  "consensussize" BIGINT,
  "permatch" BIGINT,
  "perindel" BIGINT,
  "score" BIGINT,
  "a" BIGINT,
  "c" BIGINT,
  "g" BIGINT,
  "t" BIGINT,
  "entropy" DOUBLE,
  "sequence" VARCHAR
);