Menu
▾
▴
treebase-guts
|
From: <hs...@us...> - 2013-06-06 19:33:23
|
Revision: 1102
http://sourceforge.net/p/treebase/code/1102
Author: hshyket
Date: 2013-06-06 19:32:24 +0000 (Thu, 06 Jun 2013)
Log Message:
-----------
Updating with ownership changes to NCBI tables.
Modified Paths:
--------------
trunk/treebase-core/db/cleaning/2013-06-04_add_ncbi_tables/ncbi.sql
Modified: trunk/treebase-core/db/cleaning/2013-06-04_add_ncbi_tables/ncbi.sql
===================================================================
--- trunk/treebase-core/db/cleaning/2013-06-04_add_ncbi_tables/ncbi.sql 2013-06-06 13:29:18 UTC (rev 1101)
+++ trunk/treebase-core/db/cleaning/2013-06-04_add_ncbi_tables/ncbi.sql 2013-06-06 19:32:24 UTC (rev 1102)
@@ -22,7 +22,7 @@
--
-- TOC entry 309 (class 1259 OID 95406)
-- Dependencies: 3
--- Name: ncbi_names; Type: TABLE; Schema: public; Owner: treebase_app; Tablespace:
+-- Name: ncbi_names; Type: TABLE; Schema: public; Owner: treebase_owner; Tablespace:
--
CREATE TABLE ncbi_names (
@@ -33,8 +33,13 @@
);
-ALTER TABLE public.ncbi_names OWNER TO treebase_app;
+ALTER TABLE public.ncbi_names OWNER TO treebase_owner;
+GRANT ALL ON TABLE ncbi_names TO treebase_owner;
+GRANT SELECT, UPDATE, INSERT, DELETE ON TABLE ncbi_names TO treebase_app;
+GRANT SELECT ON TABLE ncbi_names TO treebase_read;
+GRANT ALL ON TABLE ncbi_names TO postgres;
+
--
-- TOC entry 310 (class 1259 OID 95412)
-- Dependencies: 2230 3
@@ -60,8 +65,13 @@
);
-ALTER TABLE public.ncbi_nodes OWNER TO treebase_app;
+ALTER TABLE public.ncbi_nodes OWNER TO treebase_owner;
+GRANT ALL ON TABLE ncbi_nodes TO treebase_owner;
+GRANT SELECT, UPDATE, INSERT, DELETE ON TABLE ncbi_nodes TO treebase_app;
+GRANT SELECT ON TABLE ncbi_nodes TO treebase_read;
+GRANT ALL ON TABLE ncbi_nodes TO postgres;
+
--
-- TOC entry 2239 (class 0 OID 95406)
-- Dependencies: 309
@@ -2178080,361895 +2178090,3 @@
INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937579, 101273, 'species', 'CS', 1, 1, 1, 1, 5, 1, 1, 0, NULL, 1353850, 1353851);
INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937520, 937477, 'species', 'DN', 1, 1, 1, 1, 5, 1, 1, 0, NULL, 1538029, 1538030);
INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937521, 937478, 'species', 'DN', 1, 1, 1, 1, 5, 1, 1, 0, NULL, 1538033, 1538034);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937526, 937489, 'species', 'DN', 1, 1, 1, 1, 5, 1, 1, 0, NULL, 1538039, 1538040);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937513, 32374, 'no rank', NULL, 1, 1, 1, 1, 5, 1, 0, 0, NULL, 1538042, 1538059);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937514, 58306, 'species', 'DN', 1, 1, 1, 1, 5, 1, 1, 0, NULL, 1538119, 1538120);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937519, 58306, 'species', 'DN', 1, 1, 1, 1, 5, 1, 1, 0, NULL, 1538121, 1538122);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937527, 58306, 'species', 'DN', 1, 1, 1, 1, 5, 1, 1, 0, NULL, 1538123, 1538124);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937515, 58307, 'species', 'DN', 1, 1, 1, 1, 5, 1, 1, 0, NULL, 1538149, 1538150);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937516, 58307, 'species', 'DN', 1, 1, 1, 1, 5, 1, 1, 0, NULL, 1538151, 1538152);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937517, 58307, 'species', 'DN', 1, 1, 1, 1, 5, 1, 1, 0, NULL, 1538153, 1538154);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937518, 58307, 'species', 'DN', 1, 1, 1, 1, 5, 1, 1, 0, NULL, 1538155, 1538156);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937523, 58307, 'species', 'DN', 1, 1, 1, 1, 5, 1, 1, 0, NULL, 1538157, 1538158);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937524, 58307, 'species', 'DN', 1, 1, 1, 1, 5, 1, 1, 0, NULL, 1538159, 1538160);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937525, 58307, 'species', 'DN', 1, 1, 1, 1, 5, 1, 1, 0, NULL, 1538161, 1538162);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937495, 48384, 'no rank', NULL, 1, 1, 1, 1, 5, 1, 0, 0, NULL, 1538322, 1538325);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937550, 489821, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 40410, 40411);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937522, 504575, 'species', 'DN', 1, 1, 1, 1, 5, 1, 1, 0, NULL, 1538390, 1538391);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937551, 489821, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 40412, 40413);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937553, 489821, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 40416, 40417);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937528, 504575, 'species', 'DS', 1, 1, 1, 1, 5, 1, 1, 0, NULL, 1538392, 1538393);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937554, 489821, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 40418, 40419);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937555, 489821, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 40420, 40421);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937501, 504493, 'species group', NULL, 1, 1, 1, 1, 5, 1, 1, 0, NULL, 1538405, 1538408);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937556, 489821, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 40422, 40423);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937557, 489821, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 40424, 40425);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937558, 489821, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 40426, 40427);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937559, 489821, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 40428, 40429);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937560, 489821, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 40430, 40431);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937561, 489821, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 40432, 40433);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937562, 489821, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 40434, 40435);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937563, 489821, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 40436, 40437);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937565, 489821, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 40440, 40441);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937566, 489821, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 40442, 40443);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937567, 489821, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 40444, 40445);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937568, 489821, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 40446, 40447);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937569, 489821, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 40448, 40449);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937546, 490039, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 44148, 44149);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937547, 490039, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 44150, 44151);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937548, 490041, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 44788, 44789);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937570, 499193, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 54178, 54179);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937571, 684605, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 54786, 54787);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937572, 684605, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 54788, 54789);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937574, 684605, 'no rank', NULL, 9, 1, 1, 1, 0, 1, 1, 0, NULL, 54792, 54793);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937530, 469, 'species', 'AS', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 261891, 261892);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937531, 469, 'species', 'AS', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 261893, 261894);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937532, 469, 'species', 'AS', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 261895, 261896);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937533, 469, 'species', 'AS', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 261897, 261898);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937496, 286, 'species', 'PS', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 285877, 285878);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937497, 286, 'species', 'PS', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 285879, 285880);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937498, 286, 'species', 'PS', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 285881, 285882);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937499, 286, 'species', 'PS', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 285883, 285884);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937543, 286, 'species', 'PS', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 285885, 285886);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937536, 547, 'species', 'ES', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 301397, 301398);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937537, 547, 'species', 'ES', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 301399, 301400);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937538, 547, 'species', 'ES', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 301401, 301402);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937542, 586, 'species', 'PS', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 312077, 312078);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (289808, 23672, 'genus', NULL, 4, 1, 1, 1, 1, 1, 0, 0, NULL, 1099686, 1099717);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (35212, 35211, 'species', 'GE', 1, 1, 1, 1, 1, 1, 1, 0, NULL, 2044514, 2044515);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937604, 139076, 'species', 'OC', 4, 1, 1, 1, 4, 1, 1, 0, NULL, 1304210, 1304211);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937621, 7490, 'species', 'TS', 1, 1, 1, 1, 5, 1, 1, 0, NULL, 1608458, 1608459);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937603, 935900, 'species', 'DG', 4, 1, 1, 1, 4, 1, 1, 0, NULL, 1304236, 1304237);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937656, 1663, 'species', 'AS', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 728719, 728720);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937598, 862241, 'genus', NULL, 4, 1, 1, 1, 4, 1, 0, 0, NULL, 1304239, 1304242);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (827707, 156408, 'species', 'HS', 1, 1, 1, 1, 5, 1, 1, 0, NULL, 1624358, 1624359);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (289811, 289810, 'species', 'HT', 4, 1, 1, 1, 1, 1, 1, 0, NULL, 1099719, 1099720);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (289810, 23672, 'genus', NULL, 4, 1, 1, 1, 1, 1, 0, 0, NULL, 1099718, 1099721);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937657, 1663, 'species', 'AS', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 728721, 728722);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937643, 374, 'species', 'BS', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 399565, 399566);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (289812, 23672, 'genus', NULL, 4, 1, 1, 1, 1, 1, 0, 0, NULL, 1099722, 1099729);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937596, 131324, 'species', 'PS', 4, 1, 1, 1, 4, 1, 1, 0, NULL, 1207516, 1207517);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937658, 1663, 'species', 'AS', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 728723, 728724);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937644, 374, 'species', 'BS', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 399567, 399568);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937599, 862241, 'genus', NULL, 4, 1, 1, 1, 4, 1, 0, 0, NULL, 1304243, 1304248);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937645, 374, 'species', 'BS', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 399569, 399570);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937600, 862241, 'genus', NULL, 4, 1, 1, 1, 4, 1, 0, 0, NULL, 1304249, 1304254);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937669, 1663, 'species', 'AS', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 728725, 728726);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937670, 468922, 'species', 'HS', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 737917, 737918);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937655, 2034, 'species', 'CS', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 738721, 738722);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937646, 374, 'species', 'BS', 0, 1, 11, 1, 0, 1, 1, 0, NULL, 399571, 399572);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937602, 1281901, 'forma', 'MM', 4, 1, 1, 1, 4, 1, 1, 0, NULL, 1304260, 1304261);
-INSERT INTO ncbi_nodes (tax_id, parent_tax_id, rank, embl_code, division_id, inherited_div_flag, genetic_code_id, inherited_gc_flag, mitochondrial_genetic_code_id, inherited_mgc_flag, genbank_hidden_flag, hidden_subtree_root_flag, comments, left_id, right_id) VALUES (937647, 37...
[truncated message content] |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X