-- inserts for seed data for the database
insert into genome (name, chromosomes) values ('Human hg19', 'chr1,chr2,chr3,chr4,chr5,chr6,chr7,chr8,chr9,chr10,chr11,chr12,chr13,chr14,chr15,chr16,chr17,chr18,chr19,chr20,chr21,chrX,chrY'), ('Mouse mm9', null), ('Rat rn4', null);
insert into method (name) values ('ChIP-Seq'), ('RNA-Seq'), ('Microarray'),('DNAse hypersensitivity'),('Small RNA-Seq'),('Annotation BED'), ('Other');
insert into researcher (email, firstname, lastname, username, pword) values ('ccf@bu.edu', 'Clark', 'Freifeld', 'clark', '9999');
-- copy data from Christina's microarray_hypox_probe table
-- insert into microbed (experiment_id, chromosome, startpos, endpos, probe_name, directionality, regulation) select 1, chromosome, startpos, endpos, probe_name, directionality, trim(both '"' from regulation) from microarray_hypox_probe;
