1 CREATE TABLE mrna_cds_table (
4 accession TEXT NOT NULL,
5 accession_ver INT NOT NULL,
10 sequence TEXT NOT NULL,
11 prot_seq TEXT NOT NULL
14 CREATE UNIQUE INDEX ON mrna_cds_table(gi);
15 CREATE INDEX ON mrna_cds_table(cds_gi);
16 CREATE UNIQUE INDEX ON mrna_cds_table(accession,accession_ver);
17 CREATE INDEX ON mrna_cds_table(gene);