  name text,
  type text
 );
-CREATE INDEX ontologies_id ON ontologies (id);
+CREATE INDEX ontologies_id ON ontologies (name);
 CREATE INDEX ontologies_type ON ontologies (type);

 length integer,
 is_protein boolean
);
#COPY job_md5s (version,job,md5,abundance,evals,exp_avg,exp_stdv,len_avg,len_stdv,ident_avg,ident_stdv,seek,length,is_protein) FROM 'FILE' WITH NULL AS '';
CREATE UNIQUE INDEX job_md5s_key ON job_md5s (version, job, md5);
CREATE INDEX job_md5s_job_protein ON job_md5s (job, is_protein);
CREATE INDEX job_md5s_seek_length ON job_md5s (seek, length);


DROP TABLE IF EXISTS ontologies;
CREATE TABLE ontologies (
 _id integer PRIMARY KEY,
 level1 text,
 level2 text,
 level3 text,
