metadata: contig_metadata: 17 rows where bioproject = "PRJNA1158727", tax_kingdom = "Pseudomonadati" and tax

17 rows where bioproject = "PRJNA1158727", 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
2312729	2312729	PRJNA1158727_P_NODE_120182_length_267_cov_1.546392_g112721_i0	PRJNA1158727	120182	267	1.546392	4.12886664	Nitrospira	1234	Bacteria	Bacteria	399	7.569999999999998e-107	NTclustered	gi\|2511635996\|gb\|CP126122.1\|	70125	g112721	i0	94.253	97.7153558052434	261	15	98	0	1	261	751815	752075	MAG: Nitrospira sp. isolate bin_005 chromosome	blastn	26090	399	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
10508173	10508173	PRJNA1158727_P_NODE_163909_length_241_cov_0.916667_g156447_i0	PRJNA1158727	163909	241	0.916667	2.20916747	Nitrospira defluvii	330214	Bacteria	Bacteria	235	2.0099999999999997e-57	NTclustered	gi\|300603458\|emb\|FP929003.1\|	330214	g156447	i0	84.647	2.96680497925311	241	31	99	5	2	239	4294083	4293846	Candidatus Nitrospira defluvii chromosome, complete genome	blastn	715	235	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira defluvii
15606331	15606331	PRJNA1158727_P_NODE_120853_length_266_cov_1.595855_g113392_i0	PRJNA1158727	120853	266	1.595855	4.2449743	Nitrospira sp.	70125	Bacteria	Bacteria	364	2.7499999999999986e-96	NTclustered	gi\|2290911150\|gb\|CP060501.1\|	70125	g113392	i0	91.386	1.00375939849624	267	21	100	2	1	266	3849319	3849584	MAG: Nitrospira sp. isolate NSFW chromosome, complete genome	blastn	267	364	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
18889067	18889067	PRJNA1158727_P_NODE_139055_length_250_cov_0.870056_g131593_i0	PRJNA1158727	139055	250	0.870056	2.17514	Nitrospira	1234	Bacteria	Bacteria	377	3.29e-100	NTclustered	gi\|1167499077\|emb\|LT828648.1\|	1325564	g131593	i0	93.976	26.86	249	15	99	0	2	250	2391542	2391790	Nitrospira japonica isolate Genome sequencing of Nitrospira japonica strain NJ11 genome assembly, chromosome: I	blastn	6715	377	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira japonica
19430043	19430043	PRJNA1158727_P_NODE_142576_length_248_cov_1.582857_g135114_i0	PRJNA1158727	142576	248	1.582857	3.92548536	Nitrospira sp.	70125	Bacteria	Bacteria	403	5.38e-108	NTclustered	gi\|2290907019\|gb\|CP060499.1\|	70125	g135114	i0	95.968	74.5241935483871	248	10	100	0	1	248	2683244	2683491	MAG: Nitrospira sp. isolate DH1 chromosome, complete genome	blastn	18482	403	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
19431540	19431540	PRJNA1158727_P_NODE_46296_length_537_cov_1.612069_g38851_i0	PRJNA1158727	46296	537	1.612069	8.65681053	Nitrospira sp.	70125	Bacteria	Bacteria	869	0	NTclustered	gi\|2290907019\|gb\|CP060499.1\|	70125	g38851	i0	95.911	137	538	18	100	4	1	537	2683913	2684447	MAG: Nitrospira sp. isolate DH1 chromosome, complete genome	blastn	73569	869	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
27261689	27261689	PRJNA1158727_P_NODE_160363_length_242_cov_0.911243_g152901_i0	PRJNA1158727	160363	242	0.911243	2.20520806	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	163	4.67e-47	NR	MBX9659041.1	2026770	g152901	i0	98.8	1.98347107438017	80	1	99.2	0	240	1	124	203	MBX9659041.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Nitrospiraceae bacterium]	diamond	480	163	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
27388182	27388182	PRJNA1158727_P_NODE_141843_length_249_cov_0.875000_g134381_i0	PRJNA1158727	141843	249	0.875	2.17875	Nitrospirota bacterium	2026887	Bacteria	Bacteria	53.1	7.07e-6	NR	MBU6483083.1	2026887	g134381	i0	44.3	3.32530120481928	70	38	83.1	1	12	218	201	270	MBU6483083.1 glycosyltransferase [Nitrospirota bacterium]	diamond	828	53.1	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
27861486	27861486	PRJNA1158727_P_NODE_114265_length_274_cov_1.532338_g106804_i0	PRJNA1158727	114265	274	1.532338	4.19860612	Nitrospira sp.	70125	Bacteria	Bacteria	99.4	1.1799999999999999e-23	NR	MEQ1627049.1	70125	g106804	i0	100	0.514598540145985	47	0	51.5	0	133	273	1	47	MEQ1627049.1 hypothetical protein [Nitrospira sp.]	diamond	141	99.4	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
29439996	29439996	PRJNA1158727_P_NODE_148010_length_246_cov_1.554913_g140548_i0	PRJNA1158727	148010	246	1.554913	3.82508598	Nitrospira sp.	70125	Bacteria	Bacteria	110	3.39e-27	NR	MBH0192386.1	70125	g140548	i0	100	0.682926829268293	56	0	68.3	0	245	78	214	269	MBH0192386.1 hypothetical protein [Nitrospira sp.]	diamond	168	110	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
30040331	30040331	PRJNA1158727_P_NODE_156651_length_243_cov_0.905882_g149189_i0	PRJNA1158727	156651	243	0.905882	2.20129326	Nitrospiraceae bacterium	2026770	Bacteria	Bacteria	87	9.42e-18	NR	HAM52220.1	2026770	g149189	i0	55.1	0.851851851851852	69	31	85.2	0	35	241	450	518	HAM52220.1 hypothetical protein [Nitrospiraceae bacterium]	diamond	207	87	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
30198087	30198087	PRJNA1158727_P_NODE_131632_length_254_cov_1.701657_g124171_i0	PRJNA1158727	131632	254	1.701657	4.32220878	Nitrospira defluvii	330214	Bacteria	Bacteria	74.3	3.140000000000001e-13	NR	WP_213042236.1	330214	g124171	i0	100	0.413385826771654	35	0	41.3	0	253	149	479	513	WP_213042236.1 hypothetical protein [Nitrospira defluvii]	diamond	105	74.3	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira defluvii
30470611	30470611	PRJNA1158727_P_NODE_146713_length_247_cov_0.885057_g139251_i0	PRJNA1158727	146713	247	0.885057	2.18609079	Nitrospira	1234	Bacteria	Bacteria	163	6.72e-47	NR	MBL8037992.1	70125	g139251	i0	93.8	11.8056680161943	81	5	98.4	0	3	245	160	240	MBL8037992.1 FIST C-terminal domain-containing protein [Nitrospira sp.]	diamond	2916	163	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
30881123	30881123	PRJNA1158727_P_NODE_160414_length_242_cov_0.911243_g152952_i0	PRJNA1158727	160414	242	0.911243	2.20520806	Nitrospira	1234	Bacteria	Bacteria	146	3.77e-41	NR	MBH0177984.1	70125	g152952	i0	93.8	2.97520661157025	80	5	99.2	0	241	2	83	162	MBH0177984.1 ABC transporter substrate-binding protein [Nitrospira sp.]	diamond	720	147	0.993197278911565	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
30912961	30912961	PRJNA1158727_P_NODE_163914_length_241_cov_0.916667_g156452_i0	PRJNA1158727	163914	241	0.916667	2.20916747	Pseudomonadati	3379134	Bacteria	Bacteria	60.8	1.03e-9	NR	NGZ08543.1	2039809	g156452	i0	57.1	1.50622406639004	56	20	68.5	2	181	17	11	63	NGZ08543.1 hypothetical protein [Nitrospira sp. LK70]	diamond	363	61.2	0.993464052287582	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp. LK70
31019852	31019852	PRJNA1158727_P_NODE_112875_length_276_cov_1.172414_g105414_i0	PRJNA1158727	112875	276	1.172414	3.23586264	Nitrospira sp.	70125	Bacteria	Bacteria	43.9	0.0128	NR	HNG00894.1	70125	g105414	i0	32.2	1.85869565217391	90	61	97.8	0	3	272	81	170	HNG00894.1 hypothetical protein [Nitrospira sp.]	diamond	513	43.9	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
32379961	32379961	PRJNA1158727_P_NODE_153159_length_244_cov_1.801170_g145697_i0	PRJNA1158727	153159	244	1.80117	4.3948548	Nitrospira sp.	70125	Bacteria	Bacteria	132	1e-34	NR	MEI8016501.1	70125	g145697	i0	85	0.983606557377049	80	12	98.4	0	242	3	146	225	MEI8016501.1 ISL3 family transposase [Nitrospira sp.]	diamond	240	132	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);;