1INSERT INTO users (fname, lname, username) VALUES ('jane', 'doe', 'j_doe'); 2INSERT INTO users (fname, lname, username) VALUES ('john', 'doe', 'johnd'); 3INSERT INTO users (fname, lname, username) VALUES ('willem', 'doe', 'w_doe'); 4INSERT INTO users (fname, lname, username) VALUES ('rick', 'smith', 'slash'); 5-- multi table tests 6-- 7INSERT INTO taxonomy (name) VALUES ('HIV I') ; 8INSERT INTO taxonomy (name) VALUES ('HIV II') ; 9INSERT INTO taxonomy (name) VALUES ('HCV') ; 10INSERT INTO entry (accession, txid) VALUES ('A00001', '1') ; 11INSERT INTO entry (accession, txid) VALUES ('A00002', '1') ; 12INSERT INTO entry (accession, txid) VALUES ('A00003', '1') ; 13INSERT INTO entry (accession, txid) VALUES ('A00004', '2') ; 14INSERT INTO entry (accession, txid) VALUES ('A00005', '2') ; 15INSERT INTO entry (accession, txid) VALUES ('A00006', '3') ; 16INSERT INTO sequences (sequence, eid, product, multipart) VALUES ('ABCDEF', 1, 'env', 'true') ; 17INSERT INTO xsequences (sequence, pid) VALUES ('GHIJKL', 1) ; 18INSERT INTO sequences (sequence, eid, product) VALUES ('ABCDEF', 2, 'env') ; 19INSERT INTO sequences (sequence, eid, product) VALUES ('ABCDEF', 3, 'env') ; 20INSERT INTO sequences (sequence, eid, product) VALUES ('ABCDEF', 4, 'gag') ; 21INSERT INTO sequences (sequence, eid, product) VALUES ('ABCDEF', 5, 'env') ; 22INSERT INTO sequences (sequence, eid, product) VALUES ('ABCDEF', 6, 'ns1') ; 23