/* MakeTables.sql */

CREATE TABLE GeneInfoHW5 (
  GeneID varchar(100),
  Organism varchar(100),
  Function varchar(100)
);

INSERT INTO GeneInfoHW5 VALUES
  ('E001','E. Coli','Signaling'),
  ('E002','E. Coli','Transport'),
  ('E003','E. Coli','Signaling'),
  ('E004','E. Coli','Degradation'),
  ('E005','E. Coli','Motility'),
  ('E006','E. Coli','Metabolism'),
  ('D001','D. Melanogaster','Development'),
  ('D002','D. Melanogaster','Signaling'),
  ('D003','D. Melanogaster','Metabolism'),
  ('D004','D. Melanogaster','Signaling'),
  ('D005','D. Melanogaster','Transport'),
  ('B001','B. Subtilis','Metabolism'),
  ('B002','B. Subtilis','Metabolism'),
  ('B003','B. Subtilis','Signaling'),
  ('B004','B. Subtilis','Transport'),
  ('B005','B. Subtilis','Signaling'),
  ('B006','B. Subtilis','Motility'),
  ('B007','B. Subtilis','Motility'),
  ('B008','B. Subtilis','Degradation');

CREATE TABLE GeneSeqsHW5 (
  GeneID varchar(100),
  Promoter varchar(100)
);

INSERT INTO GeneSeqsHW5 VALUES
  ('E001','TCACGCCTTCAGTCTTCGGTTGCAGGACAA'),
  ('E002','TGCAGGAACTACTGAGCGGACATAAGCGCT'),
  ('E003','TCCACTCAAACATTGGGTCCGGCGTGGTTG'),
  ('E004','TATCCACAATTGGGATGCAACCGTAAGCGG'),
  ('E005','TGCTAAAAGTAAGGCTTTGAGACTACTGTC'),
  ('E006','GTGGACGCCCGACAGGGGAGTCAGGTGACA'),
  ('D001','CCAGCAAGAGATTCTAACTTGGCAGTATGG'),
  ('D002','GGGCCAAAACTAGACTACTCACTGGGAGAA'),
  ('D003','GATTGTGCAATGTAACTACTTCAGCTCCTC'),
  ('D004','TAGTTCGGGGGCTATACTACTACATTCACA'),
  ('D005','GAGTATACTTCGTCTTGACTACTTCAATGC'),
  ('B001','CATCGACCTTCGTTGTGTTTATAACTACTT'),
  ('B002','GCTTTGCACTTCCCTTAGACCTCCTTTGCG'),
  ('B003','TACCTTACTCTATGCCGTCGCGTCCACTAC'),
  ('B004','GCTGATATGCCTCACCGATAGAGATGTTCC'),
  ('B005','TACGTACTAAGCAAGTCTCGCGTATGGGCA'),
  ('B006','ATATCCACTACTCCAAACTCTACGAGCGGA'),
  ('B007','TGACTCTGGGGTACTACTACTCCGAAATCG'),
  ('B008','TCCGTCGCGGTCTTATTAGTCACTACGCAA');


