metadata: contig_metadata: 58 rows where bioproject = "PRJNA429937", tax_kingdom = "Pseudomonadati" and tax

58 rows where bioproject = "PRJNA429937", tax_kingdom = "Pseudomonadati" and tax_phylum = "Nitrospirota"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	analysis_used	target	taxid	gene	allele	pident	sumperc_cov	alnlen	mismatch	qcov	gapopen	qstart	qend	tstart	tend	target_title	analysis	sumalnlen	maxbits	bits_percmax	tax_superkingdom	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1700791	1700791	PRJNA429937_P_NODE_140142_length_205_cov_2.636364_g117515_i0	PRJNA429937	140142	205	2.636364	5.4045462	Nitrospira defluvii	330214	Bacteria	Bacteria	187	4.6999999999999985e-43	NTclustered	gi\|300603458\|emb\|FP929003.1\|	330214	g117515	i0	96.46	1.02926829268293	113	4	100	0	1	113	1325806	1325918	Candidatus Nitrospira defluvii chromosome, complete genome	blastn	211	187	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira defluvii
1701065	1701065	PRJNA429937_P_NODE_21082_length_801_cov_14.480570_g12470_i0	PRJNA429937	21082	801	14.48057	115.9893657	Nitrospira sp.	70125	Bacteria	Bacteria	898	0	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g12470	i0	87.859	8.27965043695381	766	92	96	1	20	785	3238364	3237600	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	6632	898	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
1701092	1701092	PRJNA429937_P_NODE_22002_length_784_cov_24.170861_g13058_i0	PRJNA429937	22002	784	24.170861	189.49955024	Nitrospira sp.	70125	Bacteria	Bacteria	590	1.3499999999999998e-163	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g13058	i0	84.124	0.779336734693878	611	95	78	2	23	631	1126273	1126883	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	611	590	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
1701096	1701096	PRJNA429937_P_NODE_22182_length_781_cov_3.510638_g13176_i0	PRJNA429937	22182	781	3.510638	27.41808278	Nitrospira sp.	70125	Bacteria	Bacteria	614	7.969999999999998e-171	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g13176	i0	85.354	1.01024327784891	594	85	80	2	171	763	2078282	2077690	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	789	614	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
1701849	1701849	PRJNA429937_P_NODE_56722_length_463_cov_14.271889_g37802_i0	PRJNA429937	56722	463	14.271889	66.07884607	Nitrospira sp.	70125	Bacteria	Bacteria	632	1.2599999999999996e-176	NTclustered	gi\|2511640680\|gb\|CP126121.1\|	70125	g37802	i0	96.354	81.3131749460043	384	14	83	0	2	385	201355	201738	MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome	blastn	37648	632	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
2976363	2976363	PRJNA429937_P_NODE_115283_length_260_cov_4.722944_g92657_i0	PRJNA429937	115283	260	4.722944	12.2796544	Nitrospira tepida	2973512	Bacteria	Bacteria	193	1.34e-44	NTclustered	gi\|2526808154\|emb\|OX365700.1\|	2973512	g92657	i0	81.513	0.915384615384615	238	41	91	3	24	259	333361	333125	Nitrospira sp. DNF genome assembly, chromosome: NsDNF	blastn	238	193	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira tepida
2977221	2977221	PRJNA429937_P_NODE_34923_length_613_cov_2.924658_g21652_i0	PRJNA429937	34923	613	2.924658	17.92815354	Nitrospira lenta	1436998	Bacteria	Bacteria	352	2.63e-115	NR	WP_121989553.1	1436998	g21652	i0	85.1	1.01794453507341	208	18	96.9	2	2	595	437	641	WP_121989553.1 alpha-1,4-glucan--maltose-1-phosphate maltosyltransferase [Nitrospira lenta]	diamond	624	352	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira lenta
2977503	2977503	PRJNA429937_P_NODE_47283_length_518_cov_1.889571_g30657_i0	PRJNA429937	47283	518	1.889571	9.78797778	Dissulfurispiraceae bacterium	2952959	Bacteria	Bacteria	160	2.66e-47	NR	HSW63685.1	2952959	g30657	i0	81.1	0.55019305019305	95	18	55	0	400	116	1	95	HSW63685.1 3TM-type holin [Dissulfurispiraceae bacterium]	diamond	285	160	1	Bacteria	Pseudomonadati	Nitrospirota	Thermodesulfovibrionia	Thermodesulfovibrionales	Dissulfurispiraceae		Dissulfurispiraceae bacterium
4252632	4252632	PRJNA429937_P_NODE_112984_length_266_cov_6.274262_g90361_i0	PRJNA429937	112984	266	6.274262	16.68953692	PVC group	1783257	Bacteria	Bacteria	150	4.62e-40	NR	MDH4088013.1	70125	g90361	i0	93.1	48.7105263157895	72	5	81.2	0	49	264	568	639	MDH4088013.1 alpha-glucan family phosphorylase [Nitrospira sp.]	diamond	12957	151	0.993377483443709	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
4252888	4252888	PRJNA429937_P_NODE_138724_length_207_cov_92.056180_g116097_i0	PRJNA429937	138724	207	92.05618	190.5562926	Nitrospira sp.	70125	Bacteria	Bacteria	342	9.599999999999999e-90	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g116097	i0	98.953	162.951690821256	191	2	92	0	1	191	2094005	2094195	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	33731	342	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
4253713	4253713	PRJNA429937_P_NODE_43324_length_545_cov_2.298450_g27672_i0	PRJNA429937	43324	545	2.29845	12.5265525	Candidatus Nitrospira inopinata	1715989	Bacteria	Bacteria	163	2.37e-35	NTclustered	gi\|952974062\|emb\|LN885086.1\|	1715989	g27672	i0	90.323	0.607339449541284	124	12	23	0	422	545	2124014	2124137	Nitrospira sp. ENR4 genome assembly NiCh1, chromosome : 1	blastn	331	163	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira inopinata
5530061	5530061	PRJNA429937_P_NODE_2605_length_1939_cov_4.958639_g1563_i0	PRJNA429937	2605	1939	4.958639	96.14801021	Nitrospira sp.	70125	Bacteria	Bacteria	320	4.86e-102	NR	TKB80191.1	70125	g1563	i0	92.8	0.256833419288293	166	12	25.7	0	1378	881	21	186	TKB80191.1 MAG: Eco29kI family restriction endonuclease [Nitrospira sp.]	diamond	498	320	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
6803260	6803260	PRJNA429937_P_NODE_10426_length_1122_cov_3.763038_g5815_i1	PRJNA429937	10426	1122	3.763038	42.22128636	Nitrospira sp.	70125	Bacteria	Bacteria	311	1.71e-79	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g5815	i1	84.79	0.275401069518717	309	47	28	0	291	599	2197830	2197522	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	309	311	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
6803293	6803293	PRJNA429937_P_NODE_10666_length_1112_cov_3.605725_g1563_i2	PRJNA429937	10666	1112	3.605725	40.095662	Nitrospira lenta	1436998	Bacteria	Bacteria	214	4.46e-65	NR	WP_146216153.1	1436998	g1563	i2	99.1	0.294064748201439	109	1	29.4	0	933	607	71	179	WP_146216153.1 hypothetical protein [Nitrospira lenta]	diamond	327	214	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira lenta
8079252	8079252	PRJNA429937_P_NODE_14467_length_965_cov_4.149573_g1174_i2	PRJNA429937	14467	965	4.149573	40.04337945	Nitrospira moscoviensis	42253	Bacteria	Bacteria	242	2.36e-74	NR	WP_053377998.1	42253	g1174	i2	94.4	1.93989637305699	125	7	38.9	0	591	965	1	125	WP_053377998.1 alpha-ketoacid dehydrogenase subunit beta [Nitrospira moscoviensis]	diamond	1872	242	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
8079803	8079803	PRJNA429937_P_NODE_32187_length_640_cov_5.178396_g17314_i1	PRJNA429937	32187	640	5.178396	33.1417344	Nitrospira sp.	70125	Bacteria	Bacteria	632	1.7899999999999997e-176	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g17314	i1	87.143	8.7859375	560	68	87	4	62	618	3197046	3197604	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	5623	632	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
9353649	9353649	PRJNA429937_P_NODE_104388_length_289_cov_5.857692_g81770_i0	PRJNA429937	104388	289	5.857692	16.92872988	Nitrospira moscoviensis	42253	Bacteria	Bacteria	422	1.77e-113	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g81770	i0	93.056	279.543252595156	288	20	99	0	2	289	1277504	1277791	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	80788	422	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
9354269	9354269	PRJNA429937_P_NODE_18108_length_864_cov_4.770060_g10720_i0	PRJNA429937	18108	864	4.77006	41.2133184	Nitrospira lenta	1436998	Bacteria	Bacteria	493	1.7299999999999995e-171	NR	WP_121988443.1	1436998	g10720	i0	97	0.9375	270	8	93.8	0	840	31	223	492	WP_121988443.1 sensor histidine kinase [Nitrospira lenta]	diamond	810	493	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira lenta
9354798	9354798	PRJNA429937_P_NODE_39088_length_577_cov_3.529197_g24624_i0	PRJNA429937	39088	577	3.529197	20.36346669	Nitrospira sp.	70125	Bacteria	Bacteria	569	1.2699999999999997e-157	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g24624	i0	89.686	0.974003466204506	446	46	77	0	19	464	2001735	2002180	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	562	569	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
9355127	9355127	PRJNA429937_P_NODE_54208_length_477_cov_3.395089_g35859_i0	PRJNA429937	54208	477	3.395089	16.19457453	Nitrospira sp.	70125	Bacteria	Bacteria	118	5.69e-28	NR	MBM4134044.1	70125	g35859	i0	39.3	1.0251572327044	163	87	95	2	459	7	123	285	MBM4134044.1 imidazole glycerol phosphate synthase subunit HisF [Nitrospira sp.]	diamond	489	118	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
10631504	10631504	PRJNA429937_P_NODE_92709_length_324_cov_5.013559_g70123_i0	PRJNA429937	92709	324	5.013559	16.24393116	Candidatus Nitrospira inopinata	1715989	Bacteria	Bacteria	255	2.16e-63	NTclustered	gi\|952974062\|emb\|LN885086.1\|	1715989	g70123	i0	93.567	207.833333333333	171	11	53	0	1	171	1781595	1781425	Nitrospira sp. ENR4 genome assembly NiCh1, chromosome : 1	blastn	67338	255	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira inopinata
11904788	11904788	PRJNA429937_P_NODE_15150_length_944_cov_4.457923_g1174_i3	PRJNA429937	15150	944	4.457923	42.08279312	Nitrospira moscoviensis	42253	Bacteria	Bacteria	242	1.86e-74	NR	WP_053377998.1	42253	g1174	i3	94.4	1.98305084745763	125	7	39.7	0	375	1	1	125	WP_053377998.1 alpha-ketoacid dehydrogenase subunit beta [Nitrospira moscoviensis]	diamond	1872	242	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
11904835	11904835	PRJNA429937_P_NODE_15710_length_926_cov_22.208473_g9285_i0	PRJNA429937	15710	926	22.208473	205.65045998	Nitrospira sp.	70125	Bacteria	Bacteria	933	0	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g9285	i0	85.73	3.39740820734341	883	126	95	0	20	902	304795	303913	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	3146	933	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
13180025	13180025	PRJNA429937_P_NODE_2611_length_1938_cov_4.998952_g1563_i1	PRJNA429937	2611	1938	4.998952	96.87968976	Nitrospira sp.	70125	Bacteria	Bacteria	406	1.48e-135	NR	TKB80191.1	70125	g1563	i1	93.3	0.323529411764706	209	14	32.4	0	562	1188	21	229	TKB80191.1 MAG: Eco29kI family restriction endonuclease [Nitrospira sp.]	diamond	627	406	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
13180837	13180837	PRJNA429937_P_NODE_63911_length_429_cov_2.042500_g43445_i0	PRJNA429937	63911	429	2.0425	8.762325	Dissulfurispiraceae bacterium	2952959	Bacteria	Bacteria	157	1e-46	NR	HSW63685.1	2952959	g43445	i0	84.4	0.629370629370629	90	14	62.9	0	159	428	1	90	HSW63685.1 3TM-type holin [Dissulfurispiraceae bacterium]	diamond	270	157	1	Bacteria	Pseudomonadati	Nitrospirota	Thermodesulfovibrionia	Thermodesulfovibrionales	Dissulfurispiraceae		Dissulfurispiraceae bacterium
14455084	14455084	PRJNA429937_P_NODE_20132_length_820_cov_3.792668_g11903_i0	PRJNA429937	20132	820	3.792668	31.0998776	Nitrospira lenta	1436998	Bacteria	Bacteria	122	7.99e-32	NR	WP_146216181.1	1436998	g11903	i0	94.9	0.215853658536585	59	3	21.6	0	393	569	1	59	WP_146216181.1 hypothetical protein [Nitrospira lenta]	diamond	177	122	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira lenta
15729701	15729701	PRJNA429937_P_NODE_58353_length_455_cov_4.352113_g39053_i0	PRJNA429937	58353	455	4.352113	19.80211415	Nitrospira sp.	70125	Bacteria	Bacteria	525	2.1599999999999992e-144	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g39053	i0	89.26	0.920879120879121	419	45	92	0	23	441	3091134	3090716	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	419	525	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
17005004	17005004	PRJNA429937_P_NODE_9894_length_1150_cov_3.756467_g5815_i0	PRJNA429937	9894	1150	3.756467	43.1993705	Nitrospira sp.	70125	Bacteria	Bacteria	340	2.23e-88	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g5815	i0	84.866	0.29304347826087	337	51	29	0	524	860	2197522	2197858	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	337	340	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
18277740	18277740	PRJNA429937_P_NODE_17075_length_890_cov_4.242741_g1563_i3	PRJNA429937	17075	890	4.242741	37.7603949	Nitrospira lenta	1436998	Bacteria	Bacteria	187	2.2399999999999996e-55	NR	WP_146216153.1	1436998	g1563	i3	98.9	0.31685393258427	94	1	31.7	0	3	284	86	179	WP_146216153.1 hypothetical protein [Nitrospira lenta]	diamond	282	187	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira lenta
18278433	18278433	PRJNA429937_P_NODE_4695_length_1569_cov_4.323377_g2777_i0	PRJNA429937	4695	1569	4.323377	67.83378513	Nitrospira sp.	70125	Bacteria	Bacteria	1053	0	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g2777	i0	83.659	1.23199490121096	1126	177	82	7	168	1289	1815351	1814229	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	1933	1053	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
19552078	19552078	PRJNA429937_P_NODE_1956_length_2146_cov_4.380727_g1174_i0	PRJNA429937	1956	2146	4.380727	94.01040142	Nitrospira sp.	70125	Bacteria	Bacteria	634	1.7299999999999994e-176	NTclustered	gi\|2290911150\|gb\|CP060501.1\|	70125	g1174	i0	79.109	1.96738117427773	943	180	44	10	2	936	1437590	1436657	MAG: Nitrospira sp. isolate NSFW chromosome, complete genome	blastn	4222	634	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
19552890	19552890	PRJNA429937_P_NODE_54956_length_473_cov_3.684685_g36419_i0	PRJNA429937	54956	473	3.684685	17.42856005	Nitrospira sp.	70125	Bacteria	Bacteria	473	8.289999999999999e-129	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g36419	i0	86.27	0.923890063424947	437	58	92	2	23	457	3259528	3259964	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	437	473	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
20827953	20827953	PRJNA429937_P_NODE_23197_length_763_cov_2.942779_g13823_i0	PRJNA429937	23197	763	2.942779	22.45340377	Nitrospira lenta	1436998	Bacteria	Bacteria	250	2.45e-78	NR	WP_121989730.1	1436998	g13823	i0	98.4	0.503276539973788	128	1	49.9	1	381	1	1	128	WP_121989730.1 polyamine ABC transporter substrate-binding protein [Nitrospira lenta]	diamond	384	250	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira lenta
22102667	22102667	PRJNA429937_P_NODE_16618_length_901_cov_4.932339_g9839_i0	PRJNA429937	16618	901	4.932339	44.44037439	Nitrospira sp.	70125	Bacteria	Bacteria	737	0	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g9839	i0	81.88	0.980022197558269	883	152	98	7	23	901	960945	960067	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	883	737	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
22102980	22102980	PRJNA429937_P_NODE_28658_length_681_cov_5.119632_g17314_i0	PRJNA429937	28658	681	5.119632	34.86469392	Nitrospira sp.	70125	Bacteria	Bacteria	632	1.9099999999999995e-176	NTclustered	gi\|2194428397\|gb\|CP092079.1\|	70125	g17314	i0	87.143	8.25697503671072	560	68	82	4	103	659	3197046	3197604	MAG: Nitrospira sp. isolate UBC3 chromosome	blastn	5623	632	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
22103111	22103111	PRJNA429937_P_NODE_34618_length_616_cov_3.432709_g21432_i0	PRJNA429937	34618	616	3.432709	21.14548744	Nitrospira sp.	70125	Bacteria	Bacteria	299	1.4499999999999996e-96	NR	MEQ1795159.1	70125	g21432	i0	96.8	2.29383116883117	157	5	76.5	0	144	614	192	348	MEQ1795159.1 oligosaccharide flippase family protein [Nitrospira sp.]	diamond	1413	299	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
28166151	28166151	PRJNA429937_P_NODE_150545_length_180_cov_2.145695_g127918_i0	PRJNA429937	150545	180	2.145695	3.862251	Pseudomonadati	3379134	Bacteria	Bacteria	63.2	8.15e-10	NR	TLY34026.1	2026887	g127918	i0	45.8	3.55	59	32	98.3	0	179	3	257	315	TLY34026.1 MAG: toll/interleukin-1 receptor domain-containing protein [Nitrospirota bacterium]	diamond	639	63.2	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
28339097	28339097	PRJNA429937_P_NODE_99066_length_305_cov_2.898551_g76457_i0	PRJNA429937	99066	305	2.898551	8.84058055	Nitrospirota bacterium	2026887	Bacteria	Bacteria	211	1.02e-67	NR	MEK6632600.1	2026887	g76457	i0	96	1.9672131147541	100	4	98.4	0	1	300	76	175	MEK6632600.1 hypothetical protein [Nitrospirota bacterium]	diamond	600	211	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
28513414	28513414	PRJNA429937_P_NODE_82767_length_357_cov_2.716463_g60287_i0	PRJNA429937	82767	357	2.716463	9.69777291	Pseudomonadati	3379134	Bacteria	Bacteria	68.2	1.77e-10	NR	MBF0557825.1	2026887	g60287	i0	28.9	4.34453781512605	190	52	90.8	3	34	357	822	1010	MBF0557825.1 cation-transporting P-type ATPase [Nitrospirota bacterium]	diamond	1551	68.2	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
28717990	28717990	PRJNA429937_P_NODE_46167_length_525_cov_4.086694_g11903_i1	PRJNA429937	46167	525	4.086694	21.4551435	Nitrospira lenta	1436998	Bacteria	Bacteria	80.5	1.68e-16	NR	WP_146216181.1	1436998	g11903	i1	94.6	0.211428571428571	37	2	21.1	0	413	523	1	37	WP_146216181.1 hypothetical protein [Nitrospira lenta]	diamond	111	80.5	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira lenta
29002542	29002542	PRJNA429937_P_NODE_78488_length_371_cov_3.409357_g56176_i0	PRJNA429937	78488	371	3.409357	12.64871447	Nitrospirota bacterium	2026887	Bacteria	Bacteria	57	1.32e-7	NR	MEK7279519.1	2026887	g56176	i0	71	0.752021563342318	31	9	25.1	0	94	2	55	85	MEK7279519.1 rhodanese-like domain-containing protein [Nitrospirota bacterium]	diamond	279	57	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
29081838	29081838	PRJNA429937_P_NODE_7308_length_1307_cov_4.026604_g4321_i0	PRJNA429937	7308	1307	4.026604	52.62771428	Nitrospira	1234	Bacteria	Bacteria	59.7	9.59e-7	NR	HRC43098.1	70125	g4321	i0	41.1	0.961744452945677	73	43	16.8	0	345	127	65	137	HRC43098.1 tetratricopeptide repeat protein [Nitrospira sp.]	diamond	1257	59.7	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
29128638	29128638	PRJNA429937_P_NODE_78589_length_371_cov_2.239766_g56274_i0	PRJNA429937	78589	371	2.239766	8.30953186	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	233	1.07e-74	NR	MBX9661659.1	2026770	g56274	i0	91.9	1.98921832884097	123	10	99.5	0	3	371	67	189	MBX9661659.1 M23 family metallopeptidase [Nitrospiraceae bacterium]	diamond	738	233	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
29791232	29791232	PRJNA429937_P_NODE_59731_length_448_cov_5.346062_g40128_i0	PRJNA429937	59731	448	5.346062	23.95035776	Nitrospirota bacterium	2026887	Bacteria	Bacteria	203	9.1e-65	NR	MBU6434285.1	2026887	g40128	i0	86.8	4.01785714285714	121	16	81	0	3	365	7	127	MBU6434285.1 type IV pili twitching motility protein PilT [Nitrospirota bacterium]	diamond	1800	203	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
29822781	29822781	PRJNA429937_P_NODE_93411_length_322_cov_3.000000_g70822_i0	PRJNA429937	93411	322	3	9.66	Nitrospira sp.	70125	Bacteria	Bacteria	207	8.97e-65	NR	HNK16059.1	70125	g70822	i0	98.1	0.996894409937888	107	2	99.7	0	2	322	139	245	HNK16059.1 hypothetical protein [Nitrospira sp.]	diamond	321	207	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
29886306	29886306	PRJNA429937_P_NODE_109811_length_275_cov_1.723577_g87190_i0	PRJNA429937	109811	275	1.723577	4.73983675	Nitrospirota bacterium	2026887	Bacteria	Bacteria	45.8	7.32e-4	NR	MBI5410818.1	2026887	g87190	i0	100	1.00363636363636	23	0	25.1	0	71	3	36	58	MBI5410818.1 YciI family protein [Nitrospirota bacterium]	diamond	276	45.8	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
30423616	30423616	PRJNA429937_P_NODE_30513_length_659_cov_2.936508_g18567_i0	PRJNA429937	30513	659	2.936508	19.35158772	Nitrospira sp.	70125	Bacteria	Bacteria	345	3.49e-115	NR	MBX3319752.1	70125	g18567	i0	89.4	0.983308042488619	216	2	88.8	2	73	657	180	395	MBX3319752.1 TolC family protein [Nitrospira sp.]	diamond	648	345	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
30455216	30455216	PRJNA429937_P_NODE_25093_length_732_cov_5.113798_g14989_i0	PRJNA429937	25093	732	5.113798	37.43300136	Nitrospira lenta	1436998	Bacteria	Bacteria	494	1.2999999999999994e-175	NR	WP_245924567.1	1436998	g14989	i0	94.3	2.95491803278689	244	14	100	0	1	732	14	257	WP_245924567.1 acyl-CoA desaturase [Nitrospira lenta]	diamond	2163	494	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira lenta
30549583	30549583	PRJNA429937_P_NODE_8273_length_1238_cov_4.462366_g1174_i1	PRJNA429937	8273	1238	4.462366	55.24409108	Nitrospira sp.	70125	Bacteria	Bacteria	343	1.5799999999999996e-112	NR	HSN04156.1	70125	g1174	i1	91.9	1.98222940226171	185	15	44.8	0	3	557	148	332	HSN04156.1 alpha-ketoacid dehydrogenase subunit beta [Nitrospira sp.]	diamond	2454	343	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
30675892	30675892	PRJNA429937_P_NODE_87053_length_343_cov_2.974522_g64496_i0	PRJNA429937	87053	343	2.974522	10.20261046	Candidatus Magnetobacterium casense	1455061	Bacteria	Bacteria	80.9	3.16e-15	NR	WP_218254340.1	1455061	g64496	i0	64.8	0.472303206997085	54	19	47.2	0	204	43	96	149	WP_218254340.1 hypothetical protein, partial [Candidatus Magnetobacterium casense]	diamond	162	80.9	1	Bacteria	Pseudomonadati	Nitrospirota	Thermodesulfovibrionia	Thermodesulfovibrionales	Candidatus Magnetobacteriaceae	Candidatus Magnetobacterium	Candidatus Magnetobacterium casense
30770995	30770995	PRJNA429937_P_NODE_63874_length_429_cov_2.640000_g43408_i0	PRJNA429937	63874	429	2.64	11.3256	Nitrospirota bacterium	2026887	Bacteria	Bacteria	203	1.25e-63	NR	MEK6632600.1	2026887	g43408	i0	93.1	1.41258741258741	101	7	70.6	0	429	127	76	176	MEK6632600.1 hypothetical protein [Nitrospirota bacterium]	diamond	606	203	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
30960455	30960455	PRJNA429937_P_NODE_48394_length_511_cov_2.151452_g31488_i0	PRJNA429937	48394	511	2.151452	10.99391972	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	191	1.08e-57	NR	MBX9661659.1	2026770	g31488	i0	92.2	1.19765166340509	102	8	59.9	0	509	204	67	168	MBX9661659.1 M23 family metallopeptidase [Nitrospiraceae bacterium]	diamond	612	191	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
31071838	31071838	PRJNA429937_P_NODE_32135_length_641_cov_2.686275_g19679_i0	PRJNA429937	32135	641	2.686275	17.21902275	Nitrospira	1234	Bacteria	Bacteria	341	4.45e-114	NR	OQW67014.1	1978765	g19679	i0	91.9	1.60998439937598	173	14	81	0	634	116	191	363	OQW67014.1 MAG: hypothetical protein BVN29_05120 [Nitrospira sp. ST-bin5]	diamond	1032	343	0.994169096209913	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp. ST-bin5
31134574	31134574	PRJNA429937_P_NODE_99815_length_303_cov_2.014599_g77206_i0	PRJNA429937	99815	303	2.014599	6.10423497	root	1	Root_unresolved	Root_unresolved	86.3	1.44e-17	NR	HKU52657.1	70125	g77206	i0	78	3.4950495049505	50	11	49.5	0	2	151	271	320	HKU52657.1 hypothetical protein [Nitrospira sp.]	diamond	1059	86.7	0.995386389850058	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
31307937	31307937	PRJNA429937_P_NODE_24695_length_738_cov_7.080395_g14757_i0	PRJNA429937	24695	738	7.080395	52.2533151	Thermodesulfovibrionales bacterium	2814272	Bacteria	Bacteria	183	1.0199999999999997e-54	NR	MFA4828265.1	2814272	g14757	i0	72.2	1.7479674796748	108	30	43.9	0	8	331	58	165	MFA4828265.1 dTDP-4-dehydrorhamnose 3,5-epimerase [Thermodesulfovibrionales bacterium]	diamond	1290	183	1	Bacteria	Pseudomonadati	Nitrospirota	Thermodesulfovibrionia	Thermodesulfovibrionales			Thermodesulfovibrionales bacterium
31577696	31577696	PRJNA429937_P_NODE_52396_length_487_cov_3.266376_g34501_i0	PRJNA429937	52396	487	3.266376	15.90725112	Pseudomonadati	3379134	Bacteria	Bacteria	77.4	3.6e-13	NR	KJU83032.1	29290	g34501	i0	61.8	1.73716632443532	68	22	41.9	1	371	168	374	437	KJU83032.1 secreted protein containing DUF1566, partial [Candidatus Magnetobacterium bavaricum]	diamond	846	77.4	1	Bacteria	Pseudomonadati	Nitrospirota	Thermodesulfovibrionia	Thermodesulfovibrionales	Candidatus Magnetobacteriaceae	Candidatus Magnetobacterium	Candidatus Magnetobacterium bavaricum
32130715	32130715	PRJNA429937_P_NODE_46738_length_521_cov_4.065041_g11903_i2	PRJNA429937	46738	521	4.065041	21.17886361	Nitrospira lenta	1436998	Bacteria	Bacteria	80.5	1.63e-16	NR	WP_146216181.1	1436998	g11903	i2	94.6	0.213051823416507	37	2	21.3	0	409	519	1	37	WP_146216181.1 hypothetical protein [Nitrospira lenta]	diamond	111	80.5	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira lenta
32604991	32604991	PRJNA429937_P_NODE_8540_length_1223_cov_4.214405_g4321_i1	PRJNA429937	8540	1223	4.214405	51.542173150000004	Nitrospira sp.	70125	Bacteria	Bacteria	59.7	8.8e-7	NR	HRC43098.1	70125	g4321	i1	41.1	0.179067865903516	73	43	17.9	0	960	1178	65	137	HRC43098.1 tetratricopeptide repeat protein [Nitrospira sp.]	diamond	219	59.7	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;