From: <hs...@us...> - 2013-06-06 13:29:43
|
Revision: 1101 http://sourceforge.net/p/treebase/code/1101 Author: hshyket Date: 2013-06-06 13:29:18 +0000 (Thu, 06 Jun 2013) Log Message: ----------- Added Paths: ----------- trunk/treebase-core/db/cleaning/2013-06-04_add_ncbi_tables/ncbi.sql Removed Paths: ------------- trunk/treebase-core/db/cleaning/2013-06-04_add_ncbi_tables/ncbi_nodes.sql Added: 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 (rev 0) +++ trunk/treebase-core/db/cleaning/2013-06-04_add_ncbi_tables/ncbi.sql 2013-06-06 13:29:18 UTC (rev 1101) @@ -0,0 +1,2539974 @@ +-- +-- PostgreSQL database dump +-- + +-- Dumped from database version 8.4.0 +-- Dumped by pg_dump version 9.1.3 +-- Started on 2013-05-31 14:03:07 + +SET statement_timeout = 0; +SET client_encoding = 'UTF8'; +SET standard_conforming_strings = off; +SET check_function_bodies = false; +SET client_min_messages = warning; +SET escape_string_warning = off; + +SET search_path = public, pg_catalog; + +SET default_tablespace = ''; + +SET default_with_oids = false; + +-- +-- TOC entry 309 (class 1259 OID 95406) +-- Dependencies: 3 +-- Name: ncbi_names; Type: TABLE; Schema: public; Owner: treebase_app; Tablespace: +-- + +CREATE TABLE ncbi_names ( + tax_id integer NOT NULL, + name_txt character varying(255) NOT NULL, + unique_name character varying(255), + name_class character varying(32) +); + + +ALTER TABLE public.ncbi_names OWNER TO treebase_app; + +-- +-- TOC entry 310 (class 1259 OID 95412) +-- Dependencies: 2230 3 +-- Name: ncbi_nodes; Type: TABLE; Schema: public; Owner: treebase_app; Tablespace: +-- + +CREATE TABLE ncbi_nodes ( + tax_id integer NOT NULL, + parent_tax_id integer NOT NULL, + rank character varying(32), + embl_code character varying(16), + division_id integer NOT NULL, + inherited_div_flag integer NOT NULL, + genetic_code_id integer NOT NULL, + inherited_gc_flag integer NOT NULL, + mitochondrial_genetic_code_id integer NOT NULL, + inherited_mgc_flag integer NOT NULL, + genbank_hidden_flag integer NOT NULL, + hidden_subtree_root_flag integer NOT NULL, + comments character varying(255) DEFAULT NULL::character varying, + left_id integer NOT NULL, + right_id integer NOT NULL +); + + +ALTER TABLE public.ncbi_nodes OWNER TO treebase_app; + +-- +-- TOC entry 2239 (class 0 OID 95406) +-- Dependencies: 309 +-- Data for Name: ncbi_names; Type: TABLE DATA; Schema: public; Owner: treebase_app +-- + +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (1, 'all', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (1, 'root', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (2, 'Bacteria', 'Bacteria <prokaryote>', 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (2, 'Monera', 'Monera <Bacteria>', 'in-part'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (2, 'Procaryotae', 'Procaryotae <Bacteria>', 'in-part'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (2, 'Prokaryota', 'Prokaryota <Bacteria>', 'in-part'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (2, 'Prokaryotae', 'Prokaryotae <Bacteria>', 'in-part'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (2, 'bacteria', 'bacteria <blast2>', 'blast name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (2, 'eubacteria', NULL, 'genbank common name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (2, 'not Bacteria Haeckel 1894', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (2, 'prokaryote', 'prokaryote <Bacteria>', 'in-part'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (2, 'prokaryotes', 'prokaryotes <Bacteria>', 'in-part'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (6, 'Azorhizobium', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (6, 'Azorhizobium Dreyfus et al. 1988', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (6, 'Azotirhizobium', NULL, 'equivalent name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (7, 'ATCC 43989', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (7, 'Azorhizobium caulinodans', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (7, 'Azorhizobium caulinodans Dreyfus et al. 1988', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (7, 'Azotirhizobium caulinodans', NULL, 'equivalent name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (7, 'CCUG 26647', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (7, 'DSM 5975', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (7, 'IFO 14845', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (7, 'JCM 20966', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (7, 'LMG 6465', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (7, 'NBRC 14845', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (7, 'ORS 571', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (9, 'Acyrthosiphon pisum symbiont P', NULL, 'includes'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (9, 'Buchnera aphidicola', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (9, 'Buchnera aphidicola Munson et al. 1991', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (10, '"Cellvibrio" Winogradsky 1929', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (10, 'Cellvibrio', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (10, 'Cellvibrio (ex Winogradsky 1929) Blackall et al. 1986 emend. Humphry et al. 2003', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (11, '"Cellvibrio gilvus" Hulcher and King 1958', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (11, 'Cellvibrio gilvus', NULL, 'equivalent name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (11, '[Cellvibrio] gilvus', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (13, 'Dictyoglomus', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (13, 'Dictyoglomus Saiki et al. 1985', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (14, 'ATCC 35947', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (14, 'DSM 3960', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (14, 'Dictyoglomus thermophilum', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (14, 'Dictyoglomus thermophilum Saiki et al. 1985', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (14, 'strain H-6-12', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (16, 'Methyliphilus', NULL, 'equivalent name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (16, 'Methylophilus', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (16, 'Methylophilus Jenkins et al. 1987', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (16, 'Methylotrophus', NULL, 'misspelling'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (17, 'ATCC 53528', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (17, 'DSM 46235', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (17, 'LMG 6787', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (17, 'Methyliphilus methylitrophus', NULL, 'equivalent name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (17, 'Methyliphilus methylotrophus', NULL, 'equivalent name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (17, 'Methylophilus methylitrophus', NULL, 'equivalent name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (17, 'Methylophilus methylotrophus', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (17, 'Methylophilus methylotrophus Jenkins et al. 1987', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (17, 'Methylophilus sp. CBMB147', NULL, 'includes'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (17, 'Methylotrophus methylophilus', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (17, 'NCIB 10515', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (17, 'NCIMB 10515', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (17, 'VKM B-1623', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (18, 'Pelobacter', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (18, 'Pelobacter Schink and Pfennig 1983', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (19, 'DSM 2380', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (19, 'NBRC 103641', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (19, 'Pelobacter carbinolicus', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (19, 'Pelobacter carbinolicus Schink 1984', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (19, 'strain Gra Bd 1', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (20, 'Phenylobacterium', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (20, 'Phenylobacterium Lingens et al. 1985 emend. Abraham et al. 2008', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (20, 'Phenylobacterium Lingens et al. 1985 emend. Kanso and Patel 2004', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (20, 'Phenylobacterium Lingens et al. 1985 emend. Oh and Roh 2012', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (20, 'Phenylobacterium Lingens et al. 1985 emend. Tiago et al. 2005', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (21, 'ATCC 35973', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (21, 'CIP 103305', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (21, 'DSM 1986', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (21, 'LMG 6165', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (21, 'Phenylobacterium immobile', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (21, 'Phenylobacterium immobile Lingens et al. 1985', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (22, 'Shewanella', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (22, 'Shewanella MacDonell and Colwell 1986', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (23, 'ATCC 39565', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (23, 'Alteromonas colwelliana', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (23, 'Alteromonas colwelliana Weiner et al. 1988', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (23, 'Shewanella affinis', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (23, 'Shewanella affinis Ivanova et al. 2004', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (23, 'Shewanella colwelliana', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (23, 'Shewanella colwelliana (Weiner et al. 1988) Coyne et al. 1990', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (23, 'strain LST-W', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, '"Pseudomonas putrefaciens" (Derby and Hammer) Long and Hammer 1941', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, 'ATCC 8071', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, 'Alteromonas putrefaciens', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, 'Alteromonas putrefaciens (ex Derby and Hammer) Lee et al. 1981', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, 'Alteromonas putrifaciens', NULL, 'misspelling'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, 'CCUG 13452 D', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, 'CFBP 3033', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, 'CFBP 3034', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, 'CIP 80.40', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, 'DSM 6067', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, 'IFO 3908', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, 'JCM 20190', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, 'JCM 9294', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, 'LMG 2268', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, 'NBRC 3908', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, 'NCIB 10471', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, 'NCIMB 10471', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, 'NCTC 12960', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, 'Pseudomonas putrefaciens', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, 'Shewanella putrefaciens', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, 'Shewanella putrefaciens (Lee et al. 1981) MacDonell and Colwell 1986', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, 'Shewanella putrifaciens', NULL, 'misspelling'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (24, 'strain Hammer 95', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (25, 'ATCC 33224', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (25, 'Alteromonas hanedai', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (25, 'Alteromonas hanedai Jensen et al. 1981', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (25, 'CCUG 16097', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (25, 'CIP 103207', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (25, 'DSM 6066', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (25, 'JCM 20706', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (25, 'LMG 19004', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (25, 'NBRC 102223', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (25, 'Shewanella hanedai', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (25, 'Shewanella hanedai (Jensen et al. 1981) MacDonell and Colwell 1986', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (25, 'strain 281', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (27, 'halophilic eubacterium (NRCC 41227)', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (27, 'halophilic eubacterium NRCC 41227', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (27, 'halophilic eubacterium NRCC41227', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (28, 'halophilic eubacterium', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (29, 'Myxobacteria', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (29, 'Myxococcales', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (29, 'Myxococcales Tchan et al. 1948', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (29, 'The Myxobacteria', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (29, 'fruiting gliding bacteria', NULL, 'genbank common name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (31, 'Myxococcaceae', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (31, 'Myxococcaceae Jahn 1924', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (32, 'Myxococcus', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (32, 'Myxococcus Thaxter 1892', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (33, '"Micrococcus fulvus" Cohn 1875', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (33, 'ATCC 25199', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (33, 'Micrococcus fulvus', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (33, 'Myxococcus fulvus', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (33, 'Myxococcus fulvus (Cohn 1875) Jahn 1911', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (33, 'NBRC 100333', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (33, 'NCIMB 13349', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (34, 'ATCC 25232', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (34, 'CCUG 2079', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (34, 'CIP 107069', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (34, 'IFO 13542', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (34, 'Myxococcus xanthus', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (34, 'Myxococcus xanthus Beebe 1941', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (34, 'Myxococcus xanthus retron Mx162', NULL, 'includes'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (34, 'Myxococcus xanthus retron Mx65', NULL, 'includes'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (34, 'NBRC 13542', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (35, '"Chondrococcus macrosporus" Krzemieniewska and Krzemieniewski 1926', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (35, 'CIP 109128', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (35, 'Chondrococcus macrosporus', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (35, 'Corallococcus macrosporus', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (35, 'Corallococcus macrosporus Reichenbach 2007', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (35, 'DSM 14697', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (35, 'JCM 12621', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (35, 'Myxococcus macrosporus', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (35, 'Myxococcus macrosporus (Krzemieniewska and Krzemieniewski 1926) Zahler and McCurdy 1974 (Approved Lists 1980)', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (35, 'not "Myxococcus macrosporus" Zukal 1897', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (35, 'strain Cc m8', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (38, '"Angiococcus disciformis" (Thaxter 1904) Jahn 1924', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (38, '"Cystobacter disciformis" (Thaxter 1904) Brockman and McCurdy 1989', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (38, 'Angiococcus disciformis', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (38, 'Angiococcus disciformis (Thaxter 1904) Hook et al. 1980', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (38, 'Cystobacter disciformis', NULL, 'genbank synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (38, 'Myxococcus disciformis', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (38, 'Myxococcus disciformis Thaxter 1904 (Approved Lists 1980)', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (39, 'Archangiaceae', NULL, 'includes'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (39, 'Archangiaceae Jahn 1924', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (39, 'Cystobacteraceae', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (39, 'Cystobacteraceae McCurdy 1970', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (40, 'Stigmatella', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (40, 'Stigmatella Berkeley and Curtis 1875', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (41, '"Chondromyces aurantiacus" (Berkeley and Curtis) Thaxter 1892', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (41, 'ATCC 25190', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (41, 'Chondromyces aurantiacus', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (41, 'Stigmatella aurantiaca', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (41, 'Stigmatella aurantiaca Berkeley and Curtis 1875', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (42, '"Angiococcus" Jahn 1924', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (42, 'Angiococcus', NULL, 'includes'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (42, 'Angiococcus (ex Jahn 1924) Hook et al. 1980', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (42, 'Cystobacter', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (42, 'Cystobacter Schroeter 1886', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (43, '"Polyangium fuscum" (Schroeter 1886) Thaxter 1904', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (43, 'ATCC 25194', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (43, 'Cystobacter fuscus', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (43, 'Cystobacter fuscus Schroeter 1886', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (43, 'DSM 2262', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (43, 'Polyangium fuscum', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (44, 'Melittangium', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (44, 'Melittangium Jahn 1924', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (45, '"Chondromyces gracilipes" Thaxter 1897', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (45, '"Chondromyces lichenicolus" Thaxter 1892', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (45, '"Chondromyces minor" Krzemieniewska and Krzemieniewski 1930', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (45, '"Podangium gracilipes" (Thaxter 1897) Jahn 1924', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (45, '"Podangium lichenicolum" (Thaxter 1892) Jahn 1924', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (45, 'ATCC 25944', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (45, 'Chondromyces gracilipes', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (45, 'Chondromyces lichenicolus', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (45, 'Chondromyces minor', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (45, 'Melittangium lichenicola', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (45, 'Melittangium lichenicola (Thaxter 1892) McCurdy 1971', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (45, 'Podangium gracilipes', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (45, 'Podangium lichenicolum', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (47, 'Archangium', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (47, 'Archangium Jahn 1924', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (48, '"Chondrococcus cerebriformis" (Kofler) Jahn 1924', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (48, '"Chondromyces serpens" Quehl 1906', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (48, '"Myxococcus cerebriformis" Kofler 1913', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (48, 'ATCC 25201', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (48, 'Archangium gephyra', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (48, 'Archangium gephyra Jahn 1924', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (48, 'Chondrococcus cerebriformis', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (48, 'Chondromyces serpens', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (48, 'DSM 2261', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (48, 'Myxococcus cerebriformis', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (49, '"Sorangiaceae" Jahn 1924', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (49, 'Polyangiaceae', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (49, 'Polyangiaceae Jahn 1924', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (49, 'Sorangiaceae', NULL, 'includes'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (50, '"Myxobotrys" Zukal 1896', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (50, '"Polycephalum" Kalchbrenner and Cooke 1880', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (50, 'Chondromyces', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (50, 'Chondromyces Berkeley and Curtis 1874', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (50, 'Chrondromyces', NULL, 'misspelling'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (50, 'Myxobotrys', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (50, 'Polycephalum', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (51, 'Chondromyces apiculatus', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (51, 'Chondromyces apiculatus Thaxter 1897', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (51, 'Chrondromyces apiculatus', NULL, 'misspelling'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (51, 'TC 4481', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (52, '"Myxobotrys variabilis" Zukal 1896 (putative synonym)', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (52, 'Chondromyces crocatus', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (52, 'Chondromyces crocatus Berkeley and Curtis 1874', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (52, 'Chrondromyces crocatus', NULL, 'misspelling'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (52, 'Myxobotrys variabilis', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (52, 'TC 601', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (53, 'Nannocystis', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (53, 'Nannocystis Reichenbach 1970', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (54, 'ATCC 25963', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (54, 'DSM 71', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (54, 'Nannocystis exedens', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (54, 'Nannocystis exedens Reichenbach 1970', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (55, 'Polyangium', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (55, 'Polyangium Link 1809', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (56, '"Polyangium compositum" Thaxter 1904', '"Polyangium compositum" Thaxter 1904 <Sorangium cellulosum>', 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (56, '"Sorangium cellulosum" (Imshenetski and Solntseva 1936) Imshenetski and Solntseva 1937', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (56, '"Sorangium compositum" Jahn 1924', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (56, '"Sorangium compositum" Krzemieniewska and Krzemieniewski 1937', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (56, '"Sorangium nigrescens" Krzemieniewska and Krzemieniewski 1937', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (56, '"Sorangium nigrum" Krzemieniewska and Krzemieniewski 1937', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (56, 'CIP 109122', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (56, 'DSM 14627', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (56, 'JCM 12707', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (56, 'Polyangium cellulosum', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (56, 'Polyangium cellulosum (ex Imshenetski and Solntseva 1936) Brockman 1989', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (56, 'Polyangium compositum', 'Polyangium compositum <Sorangium cellulosum>', 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (56, 'Sorangium cellulosum', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (56, 'Sorangium cellulosum (Brockman 1989) Reichenbach 2007', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (56, 'Sorangium compositum', 'Sorangium compositum <Sorangium cellulosum>', 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (56, 'Sorangium nigrescens', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (56, 'Sorangium nigrum', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (56, 'strain So ce1871', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (57, 'Polyangium sp.', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (59, 'Vitreoscilla', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (59, 'Vitreoscilla Pringsheim 1949', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (60, 'Vitreoscilla sp.', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (61, 'ATCC 15218', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (61, 'DSM 513', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (61, 'LMG 7756', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (61, 'Vitreoscilla stercoraria', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (61, 'Vitreoscilla stercoraria Pringsheim 1951 (Approved Lists 1980) emend. Strohl et al. 1986', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (62, 'ATCC 43189', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (62, 'Vitreoscilla beggiatoides', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (62, 'Vitreoscilla beggiatoides Pringsheim 1949 (Approved Lists 1980) emend. Strohl et al. 1986', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (62, 'strain B23SS', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (63, '"Vitreoscilla filiformis" Pringsheim 1951', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (63, 'ATCC 43190', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (63, 'Vitreoscilla filiformis', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (63, 'Vitreoscilla filiformis (ex Pringsheim 1951) Strohl et al. 1986', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (63, 'strain L1401-2', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (64, 'Herpetosiphon', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (64, 'Herpetosiphon Holt and Lewin 1968', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (65, 'ATCC 23779', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (65, 'CCUG 48726', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (65, 'DSM 785', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (65, 'HAMBI 1968', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (65, 'Herpetosiphon aurantiacus', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (65, 'Herpetosiphon aurantiacus Holt and Lewin 1968', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (65, 'Herpetosiphon giganteus', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (68, 'Lysobacter', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (68, 'Lysobacter Christensen and Cook 1978 (Approved Lists 1980) emend. Park et al. 2008', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (69, 'ATCC 29487', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (69, 'DSM 2043', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (69, 'LMG 8762', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (69, 'Lysobacter enzymogenes', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (69, 'Lysobacter enzymogenes Christensen and Cook 1978', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (69, 'UASM 495', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (71, 'Simonsiella', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (71, 'Simonsiella Schmid 1922', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (72, '"Caryophanon muelleri" (Schmid 1922) Peshkoff 1948', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (72, 'ATCC 29453', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (72, 'CCUG 30554', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (72, 'CIP 103436', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (72, 'Caryophanon muelleri', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (72, 'DSM 2579', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (72, 'LMG 7828', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (72, 'Scheibenbakterien', NULL, 'common name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (72, 'Scheibenbakterien Muller 1911', NULL, 'common name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (72, 'Simonsiella muelleri', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (72, 'Simonsiella muelleri Schmid 1922', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (75, 'Caulobacter', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (75, 'Caulobacter Henrici and Johnson 1935 (Approved Lists 1980) emend. Abraham et al. 1999', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (78, 'Caulobacter sp.', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (81, 'Hyphomicrobium', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (81, 'Hyphomicrobium Stutzer and Hartleb 1898', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (81, 'Hyphomicrobium Stutzer and Hartleb 1899 (sic)', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (82, 'Hyphomicrobium sp.', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (83, 'ATCC 33404', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (83, 'Hyphomicrobium vulgare', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (83, 'Hyphomicrobium vulgare Stutzer and Hartleb 1898', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (83, 'Hyphomicrobium vulgare Stutzer and Hartleb 1899 (sic)', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (83, 'JCM 6889', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (83, 'NCIB 9698', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (84, 'ATCC 35216', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (84, 'DSM 5458', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (84, 'Hyphomicrobium methylovorum', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (84, 'Hyphomicrobium methylovorum Izumi et al. 1983', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (84, 'IFO 14180', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (84, 'JCM 6890', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (84, 'NBRC 14180', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (84, 'strain KM 146', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (85, 'Hyphomonas', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (85, 'Hyphomonas (ex Pongratz 1957) Moore et al. 1984 emend. Weiner et al. 2000', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (86, 'ATCC 33883', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (86, 'DSM 5153', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (86, 'Hyphomonas jannaschiana', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (86, 'Hyphomonas jannaschiana Weiner et al. 1985', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (86, 'strain VP2', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (87, 'Hyphomonas sp.', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (88, '"Chlamydothrix" Migula 1900', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (88, '"Detoniella" Trevisan in de Toni and Trevisan 1889', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (88, 'Chlamydothrix', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (88, 'Detoniella', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (88, 'Leptothrix', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (88, 'Leptothrix Kutzing 1843', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (89, '"Leptothrix crassa" Cholodny 1924', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (89, '"Leptothrix discophora" (Schwers 1912) Dorff 1934', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (89, '"Megalothrix discophora" Schwers 1912', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (89, 'ATCC 43182', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (89, 'LMG 8141', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (89, 'Leptothrix crassa', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (89, 'Leptothrix discophora', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (89, 'Leptothrix discophora (ex Schwers 1912) Spring et al. 1997', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (89, 'Megalothrix discophora', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (89, 'strain SS-1', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (93, 'Stella', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (93, 'Stella Vasilyeva 1985', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (94, 'ATCC 43930', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (94, 'AUCM B-1137', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (94, 'DSM 5900', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (94, 'Stella humosa', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (94, 'Stella humosa Vasilyeva 1985', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (94, 'VKM B-1137', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (96, 'Gallionella', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (96, 'Gallionella Ehrenberg 1838', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (97, '"Chlamydothrix ferruginea" (Ehrenberg 1838) Migula 1900', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (97, '"Spirillum ferrugineum" (Ehrenberg 1838) de Toni and Trevisan 1889', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (97, '"Spirophyllum ferrugineum" (Ehrenberg 1838) Ellis 1907', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (97, 'Chlamydothrix ferruginea', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (97, 'Gallionella ferruginea', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (97, 'Gallionella ferruginea Ehrenberg 1838', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (97, 'Spirillum ferrugineum', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (97, 'Spirophyllum ferrugineum', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (99, '"Renobacter" Nikitin 1971', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (99, 'Ancylobacter', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (99, 'Ancylobacter Raj 1983', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (99, 'Microcyclus', 'Microcyclus <bacteria>', 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (99, 'Microcyclus Orskov 1928 (Approved Lists 1980)', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (99, 'Renobacter', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (100, 'ATCC 25396', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (100, 'Ancylobacter aquaticus', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (100, 'Ancylobacter aquaticus (Orskov 1928) Raj 1983', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (100, 'CCUG 1820', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (100, 'CCUG 30551', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (100, 'DSM 101', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (100, 'JCM 20518', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (100, 'LMG 4052', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (100, 'Microcyclus aquaticus', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (100, 'Microcyclus aquaticus Orskov 1928 (Approved Lists 1980)', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (100, 'NBRC 102453', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (100, 'VKM B-1287', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (100, 'strain rskov', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (101, 'Flectobacillus', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (101, 'Flectobacillus Larkin et al. 1977 (Approved Lists 1980) emend. Raj and Maloy 1990', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (102, 'ACAM 171', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (102, 'ATCC 43844', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (102, 'CIP 103112', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (102, 'Flectobacillus glomeratus', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (102, 'Flectobacillus glomeratus McGuire et al. 1988', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (102, 'LMG 13858', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (102, 'Polaribacter glomeratus', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (102, 'Polaribacter glomeratus (McGuire et al. 1988) Gosink et al. 1998', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (102, 'UQM 3055', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (103, '"Microcyclus major" Gromov 1963', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (103, 'ATCC 29496', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (103, 'DSM 103', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (103, 'Flectobacillus major', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (103, 'Flectobacillus major (Gromov 1963) Larkin et al. 1977', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (103, 'LMG 13163', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (103, 'Microcyclus major', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (103, 'VKM B-859', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (104, '"Microcyclus marinus" Raj 1976', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (104, 'ATCC 25205', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (104, 'Cyclibacterium marinum', NULL, 'misspelling'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (104, 'Cyclobacterium marinum', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (104, 'Cyclobacterium marinum corrig. (Raj 1976) Raj and Maloy 1990', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (104, 'Cyclobacterium marinus', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (104, 'DSM 745', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (104, 'Flectobacillus marinus', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (104, 'Flectobacillus marinus (Raj 1976) Borrall and Larkin 1978 (Approved Lists 1980)', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (104, 'LMG 13164', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (104, 'Microcyclus marinus', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (104, 'strain Raj', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (105, 'Runella', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (105, 'Runella Larkin and Williams 1978', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (106, 'ATCC 29530', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (106, 'DSM 19594', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (106, 'LMG 11500', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (106, 'Runella slithyformis', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (106, 'Runella slithyformis Larkin and Williams 1978', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (107, 'Spirosoma', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (107, 'Spirosoma Migula 1894 (Approved Lists 1980) emend. Finster et al. 2009', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (108, 'ATCC 33905', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (108, 'DSM 74', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (108, 'LMG 10896', NULL, 'type material'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (108, 'Spirosoma linguale', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (108, 'Spirosoma linguale Migula 1894', NULL, 'authority'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (109, 'Blastobacter', NULL, 'scientific name'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (109, 'Blastobacter Zavarzin 1961 (Approved Lists 1980) emend. Sly 1985', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (110, '"Blastobacter viscosus" Loginova and Trotensko 1979', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, name_class) VALUES (110, '"Blastobacter viscosus" Loginova and Trotsenok 1979', NULL, 'synonym'); +INSERT INTO ncbi_names (tax_id, name_txt, unique_name, ... [truncated message content] |