metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA799842" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA799842" 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
3345181	3345181	PRJNA799842_P_NODE_178023_length_243_cov_0.905882_g176450_i0	PRJNA799842	178023	243	0.905882	2.20129326	Nitrospira sp.	70125	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|2290906964\|gb\|CP058931.1\|	70125	g176450	i0	99.18	1.00411522633745	244	1	100	1	1	243	3207317	3207074	MAG: Nitrospira sp. isolate DJ chromosome	blastn	244	438	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
3770609	3770609	PRJNA799842_P_NODE_164463_length_246_cov_0.890173_g162890_i0	PRJNA799842	164463	246	0.890173	2.18982558	Nitrospira	1234	Bacteria	Bacteria	196	9.7e-46	NTclustered	gi\|2290906964\|gb\|CP058931.1\|	70125	g162890	i0	95.868	2.40243902439024	121	5	95	0	126	246	3592953	3592833	MAG: Nitrospira sp. isolate DJ chromosome	blastn	591	196	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
4621960	4621960	PRJNA799842_P_NODE_147304_length_249_cov_0.875000_g145731_i0	PRJNA799842	147304	249	0.875	2.17875	Nitrospira sp.	70125	Bacteria	Bacteria	387	5.439999999999998e-103	NTclustered	gi\|2290906964\|gb\|CP058931.1\|	70125	g145731	i0	94.758	3.00803212851406	248	13	99	0	1	248	3144573	3144326	MAG: Nitrospira sp. isolate DJ chromosome	blastn	749	387	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
5897612	5897612	PRJNA799842_P_NODE_172685_length_244_cov_0.900585_g171112_i0	PRJNA799842	172685	244	0.900585	2.1974274	Candidatus Nitrospira kreftii	2652173	Bacteria	Bacteria	387	5.31e-103	NTclustered	gi\|1884724763\|gb\|CP047423.1\|	2652173	g171112	i0	95.455	0.991803278688525	242	11	99	0	1	242	1463796	1464037	Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome	blastn	242	387	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira kreftii
8446622	8446622	PRJNA799842_P_NODE_148287_length_249_cov_0.875000_g146714_i0	PRJNA799842	148287	249	0.875	2.17875	Nitrospira sp.	70125	Bacteria	Bacteria	339	1.5399999999999998e-88	NTclustered	gi\|2290907019\|gb\|CP060499.1\|	70125	g146714	i0	91.498	3.90763052208835	247	19	99	2	4	249	1558984	1558739	MAG: Nitrospira sp. isolate DH1 chromosome, complete genome	blastn	973	339	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
9721946	9721946	PRJNA799842_P_NODE_160728_length_246_cov_0.890173_g159155_i0	PRJNA799842	160728	246	0.890173	2.18982558	Nitrospira sp.	70125	Bacteria	Bacteria	444	3.14e-120	NTclustered	gi\|2290906964\|gb\|CP058931.1\|	70125	g159155	i0	99.187	3	246	2	100	0	1	246	1658291	1658536	MAG: Nitrospira sp. isolate DJ chromosome	blastn	738	444	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
9722000	9722000	PRJNA799842_P_NODE_163868_length_246_cov_0.890173_g162295_i0	PRJNA799842	163868	246	0.890173	2.18982558	Candidatus Nitrospira allomarina	3020900	Bacteria	Bacteria	427	3.16e-115	NTclustered	gi\|2582126190\|gb\|CP116967.1\|	3020900	g162295	i0	97.967	2.99186991869919	246	5	100	0	1	246	1075650	1075405	Candidatus Nitrospira allomarina strain VA chromosome, complete genome	blastn	736	427	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira allomarina
9722059	9722059	PRJNA799842_P_NODE_167828_length_245_cov_0.895349_g166255_i0	PRJNA799842	167828	245	0.895349	2.19360505	Nitrospira sp.	70125	Bacteria	Bacteria	414	2.45e-111	NTclustered	gi\|2290906964\|gb\|CP058931.1\|	70125	g166255	i0	97.143	2.96734693877551	245	7	100	0	1	245	558606	558362	MAG: Nitrospira sp. isolate DJ chromosome	blastn	727	414	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
9722320	9722320	PRJNA799842_P_NODE_181508_length_242_cov_0.911243_g179935_i0	PRJNA799842	181508	242	0.911243	2.20520806	Candidatus Nitrospira neomarina	3020899	Bacteria	Bacteria	182	2.66e-41	NTclustered	gi\|2582130041\|gb\|CP116968.1\|	3020899	g179935	i0	84.127	0.78099173553719	189	28	78	2	47	234	239956	240143	Candidatus Nitrospira neomarina strain DK chromosome, complete genome	blastn	189	182	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira neomarina
9723638	9723638	PRJNA799842_P_NODE_72508_length_337_cov_0.875000_g70935_i0	PRJNA799842	72508	337	0.875	2.94875	Nitrospira sp.	70125	Bacteria	Bacteria	300	1.03e-76	NTclustered	gi\|2290906964\|gb\|CP058931.1\|	70125	g70935	i0	96.685	3.04451038575668	181	4	100	2	1	181	317262	317084	MAG: Nitrospira sp. isolate DJ chromosome	blastn	1026	300	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
12272724	12272724	PRJNA799842_P_NODE_136650_length_251_cov_0.865169_g135077_i0	PRJNA799842	136650	251	0.865169	2.17157419	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	108	4.79e-19	NTclustered	gi\|2108110650\|gb\|CP070737.1\|	2026770	g135077	i0	76.923	1.84860557768924	208	36	80	10	39	238	1517828	1517625	MAG: Nitrospiraceae bacterium isolate bin398 chromosome	blastn	464	108	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
12272933	12272933	PRJNA799842_P_NODE_148550_length_249_cov_0.875000_g146977_i0	PRJNA799842	148550	249	0.875	2.17875	Nitrospira sp.	70125	Bacteria	Bacteria	438	1.4799999999999996e-118	NTclustered	gi\|2290906964\|gb\|CP058931.1\|	70125	g146977	i0	98.394	3	249	4	100	0	1	249	2652604	2652356	MAG: Nitrospira sp. isolate DJ chromosome	blastn	747	438	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
12273496	12273496	PRJNA799842_P_NODE_176310_length_243_cov_0.905882_g174737_i0	PRJNA799842	176310	243	0.905882	2.20129326	Nitrospira sp.	70125	Bacteria	Bacteria	399	6.789999999999999e-107	NTclustered	gi\|2290906964\|gb\|CP058931.1\|	70125	g174737	i0	96.296	5.34979423868313	243	9	100	0	1	243	1498828	1499070	MAG: Nitrospira sp. isolate DJ chromosome	blastn	1300	399	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
13972697	13972697	PRJNA799842_P_NODE_135971_length_251_cov_0.865169_g134398_i0	PRJNA799842	135971	251	0.865169	2.17157419	Nitrospira	1234	Bacteria	Bacteria	424	4.18e-114	NTclustered	gi\|2290906964\|gb\|CP058931.1\|	70125	g134398	i0	97.2	3.35856573705179	250	7	99	0	2	251	3186177	3186426	MAG: Nitrospira sp. isolate DJ chromosome	blastn	843	424	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
16096694	16096694	PRJNA799842_P_NODE_180093_length_243_cov_0.905882_g178520_i0	PRJNA799842	180093	243	0.905882	2.20129326	Candidatus Nitrospira neomarina	3020899	Bacteria	Bacteria	305	1.52e-78	NTclustered	gi\|2582130041\|gb\|CP116968.1\|	3020899	g178520	i0	90	0.987654320987654	240	18	97	2	7	242	928017	927780	Candidatus Nitrospira neomarina strain DK chromosome, complete genome	blastn	240	305	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira neomarina
17371810	17371810	PRJNA799842_P_NODE_137574_length_251_cov_0.865169_g136001_i0	PRJNA799842	137574	251	0.865169	2.17157419	Candidatus Nitrospira neomarina	3020899	Bacteria	Bacteria	359	1.2e-94	NTclustered	gi\|2582130041\|gb\|CP116968.1\|	3020899	g136001	i0	92.43	3	251	19	100	0	1	251	402367	402117	Candidatus Nitrospira neomarina strain DK chromosome, complete genome	blastn	753	359	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira neomarina
17372129	17372129	PRJNA799842_P_NODE_155874_length_247_cov_0.885057_g154301_i0	PRJNA799842	155874	247	0.885057	2.18609079	Nitrospira sp.	70125	Bacteria	Bacteria	350	7.07e-92	NTclustered	gi\|2290906964\|gb\|CP058931.1\|	70125	g154301	i0	92.623	1.96356275303644	244	17	99	1	4	247	159758	159516	MAG: Nitrospira sp. isolate DJ chromosome	blastn	485	350	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
17372179	17372179	PRJNA799842_P_NODE_158854_length_247_cov_0.885057_g157281_i0	PRJNA799842	158854	247	0.885057	2.18609079	Nitrospira sp.	70125	Bacteria	Bacteria	440	4.079999999999999e-119	NTclustered	gi\|2290906964\|gb\|CP058931.1\|	70125	g157281	i0	98.785	3	247	3	100	0	1	247	42873	42627	MAG: Nitrospira sp. isolate DJ chromosome	blastn	741	440	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
19920233	19920233	PRJNA799842_P_NODE_138156_length_251_cov_0.865169_g136583_i0	PRJNA799842	138156	251	0.865169	2.17157419	Nitrospira sp.	70125	Bacteria	Bacteria	204	5.93e-48	NTclustered	gi\|1938802452\|gb\|CP054184.1\|	70125	g136583	i0	81.275	1	251	47	100	0	1	251	2279076	2278826	MAG: Nitrospira sp. isolate H3_NOB1 chromosome, complete genome	blastn	251	204	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
21196046	21196046	PRJNA799842_P_NODE_150437_length_248_cov_0.880000_g148864_i0	PRJNA799842	150437	248	0.88	2.1824	Nitrospira sp.	70125	Bacteria	Bacteria	167	7.679999999999999e-37	NTclustered	gi\|2290907019\|gb\|CP060499.1\|	70125	g148864	i0	83.333	0.838709677419355	180	30	73	0	66	245	4179400	4179221	MAG: Nitrospira sp. isolate DH1 chromosome, complete genome	blastn	208	167	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
22470653	22470653	PRJNA799842_P_NODE_148258_length_249_cov_0.875000_g146685_i0	PRJNA799842	148258	249	0.875	2.17875	Nitrospira sp.	70125	Bacteria	Bacteria	438	1.4799999999999996e-118	NTclustered	gi\|2290906964\|gb\|CP058931.1\|	70125	g146685	i0	98.394	3.00401606425703	249	4	100	0	1	249	92172	92420	MAG: Nitrospira sp. isolate DJ chromosome	blastn	748	438	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
22473088	22473088	PRJNA799842_P_NODE_91838_length_303_cov_0.943478_g90265_i0	PRJNA799842	91838	303	0.943478	2.85873834	Nitrospira sp.	70125	Bacteria	Bacteria	156	2.09e-33	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g90265	i0	80.583	1.90759075907591	206	37	67	3	98	301	479557	479761	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	578	156	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
23746937	23746937	PRJNA799842_P_NODE_182899_length_242_cov_0.911243_g181326_i0	PRJNA799842	182899	242	0.911243	2.20520806	Candidatus Nitrospira neomarina	3020899	Bacteria	Bacteria	403	5.22e-108	NTclustered	gi\|2582130041\|gb\|CP116968.1\|	3020899	g181326	i0	96.694	3	242	8	100	0	1	242	3860788	3860547	Candidatus Nitrospira neomarina strain DK chromosome, complete genome	blastn	726	403	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira neomarina
25445345	25445345	PRJNA799842_P_NODE_117860_length_270_cov_1.167513_g116287_i0	PRJNA799842	117860	270	1.167513	3.1522851	Nitrospira	1234	Bacteria	Bacteria	460	3.4699999999999996e-125	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g116287	i0	97.407	142.992592592593	270	7	100	0	1	270	1279294	1279563	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	38608	460	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis

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);;