metadata: contig_metadata: 16 rows where bioproject = "PRJNA315314", tax_kingdom = "Pseudomonadati" and tax

16 rows where bioproject = "PRJNA315314", 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
380981	380981	PRJNA315314_S_NODE_31721_length_151_cov_6.483607_g31400_i0	PRJNA315314	31721	151	6.483607	9.79024657	Candidatus Nitrospira kreftii	2652173	Bacteria	Bacteria	239	8.81e-59	NTclustered	gi\|1884724763\|gb\|CP047423.1\|	2652173	g31400	i0	95.333	89.2119205298013	150	7	99	0	2	151	2707047	2707196	Candidatus Nitrospira kreftii isolate comreactor17 chromosome, complete genome	blastn	13471	239	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Candidatus Nitrospira kreftii
1065416	1065416	PRJNA315314_S_NODE_6541_length_315_cov_19.332168_g6220_i0	PRJNA315314	6541	315	19.332168	60.8963292	Nitrospira	1234	Bacteria	Bacteria	396	1.18e-105	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g6220	i0	90.397	514.450793650794	302	27	96	2	1	302	1278377	1278078	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	162052	396	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
2931658	2931658	PRJNA315314_S_NODE_5343_length_347_cov_4.694969_g5022_i0	PRJNA315314	5343	347	4.694969	16.29154243	Nitrospira moscoviensis	42253	Bacteria	Bacteria	141	6.82e-29	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g5022	i0	74.862	225.461095100865	362	66	99	22	1	346	1277783	1277431	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	78235	141	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
2931689	2931689	PRJNA315314_S_NODE_7003_length_305_cov_8.626812_g6682_i0	PRJNA315314	7003	305	8.626812	26.3117766	Nitrospira moscoviensis	42253	Bacteria	Bacteria	359	1.5e-94	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g6682	i0	95.154	83.8918032786885	227	11	74	0	79	305	1277501	1277275	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	25587	359	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
3615855	3615855	PRJNA315314_S_NODE_14863_length_212_cov_2.546448_g14542_i0	PRJNA315314	14863	212	2.546448	5.39846976	Bacteria	2	Bacteria	Bacteria	62.1	3.1e-5	NTclustered	gi\|2108422624\|gb\|CP070632.1\|	2026770	g14542	i0	100	8.2877358490566	33	0	16	0	1	33	2965764	2965732	MAG: Nitrospiraceae bacterium isolate bin97 chromosome	blastn	1757	62.1	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae		Nitrospiraceae bacterium
4207907	4207907	PRJNA315314_S_NODE_15564_length_207_cov_70.550562_g15243_i0	PRJNA315314	15564	207	70.550562	146.03966334	uncultured Nitrospirales bacterium	367762	Bacteria	Bacteria	111	2.95e-20	NTclustered	gi\|2531976035\|emb\|OY282373.1\|	367762	g15243	i0	89.773	173.647342995169	88	7	42	2	1	86	91638	91551	MAG: uncultured Nitrospirales bacterium genome assembly, chromosome: 1	blastn	35945	111	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales			uncultured Nitrospirales bacterium
6168087	6168087	PRJNA315314_S_NODE_17325_length_197_cov_4498.214286_g17004_i0	PRJNA315314	17325	197	4498.214286	8861.48214342	Nitrospira	1234	Bacteria	Bacteria	274	3.34e-69	NTclustered	gi\|3451289\|emb\|Y14644.1\|	70125	g17004	i0	100	75.3045685279188	148	0	75	0	35	182	52	199	Nitrospira sp. 16S rRNA gene, strain GC86	blastn	14835	276	0.992753623188406	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
6758528	6758528	PRJNA315314_S_NODE_2466_length_504_cov_9.562105_g2162_i0	PRJNA315314	2466	504	9.562105	48.1930092	Nitrospira moscoviensis	42253	Bacteria	Bacteria	771	0	NTclustered	gi\|922305621\|gb\|CP011801.1\|	42253	g2162	i0	94.246	81.9742063492064	504	29	100	0	1	504	1277275	1277778	Nitrospira moscoviensis strain NSP M-1, complete genome	blastn	41315	771	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira moscoviensis
6758749	6758749	PRJNA315314_S_NODE_8006_length_285_cov_18.156250_g7685_i0	PRJNA315314	8006	285	18.15625	51.7453125	Nitrospira sp.	70125	Bacteria	Bacteria	488	1.6899999999999999e-133	NTclustered	gi\|2511640680\|gb\|CP126121.1\|	70125	g7685	i0	97.544	170.445614035088	285	7	100	0	1	285	200740	200456	MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome	blastn	48577	488	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
8034089	8034089	PRJNA315314_S_NODE_22407_length_175_cov_179.226027_g22086_i0	PRJNA315314	22407	175	179.226027	313.64554725	Nitrospira sp.	70125	Bacteria	Bacteria	263	6.26e-66	NTclustered	gi\|2511635996\|gb\|CP126122.1\|	70125	g22086	i0	93.714	217.914285714286	175	11	100	0	1	175	753886	754060	MAG: Nitrospira sp. isolate bin_005 chromosome	blastn	38135	263	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
11268460	11268460	PRJNA315314_S_NODE_14389_length_215_cov_38.962366_g14068_i0	PRJNA315314	14389	215	38.962366	83.7690869	Nitrospira	1234	Bacteria	Bacteria	387	4.57e-103	NTclustered	gi\|2511640680\|gb\|CP126121.1\|	70125	g14068	i0	99.07	163.413953488372	215	2	100	0	1	215	199889	199675	MAG: Nitrospira sp. isolate bin_001 chromosome, complete genome	blastn	35134	387	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
24607123	24607123	PRJNA315314_S_NODE_5440_length_344_cov_13.834921_g5119_i0	PRJNA315314	5440	344	13.834921	47.59212824	Nitrospira sp.	70125	Bacteria	Bacteria	542	1.58e-149	NTclustered	gi\|2863125063\|dbj\|AP038805.1\|	70125	g5119	i0	95.072	95.9854651162791	345	15	100	2	1	344	2094838	2095181	MAG: Nitrospira sp. AFB01 DNA, complete genome	blastn	33019	542	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
27439801	27439801	PRJNA315314_S_NODE_31643_length_152_cov_1.081301_g31322_i0	PRJNA315314	31643	152	1.081301	1.64357752	Pseudomonadati	3379134	Bacteria	Bacteria	41.6	0.0246	NR	MBA4372995.1	2067987	g31322	i0	53.1	2.94078947368421	49	18	96.7	1	152	6	81	124	MBA4372995.1 amino acid transporter [Thermodesulfovibrio sp.]	diamond	447	42	0.990476190476191	Bacteria	Pseudomonadati	Nitrospirota	Thermodesulfovibrionia	Thermodesulfovibrionales	Thermodesulfovibrionaceae	Thermodesulfovibrio	Thermodesulfovibrio sp.
27453775	27453775	PRJNA315314_S_NODE_14703_length_213_cov_3.668478_g14382_i0	PRJNA315314	14703	213	3.668478	7.81385814	Nitrospirota bacterium	2026887	Bacteria	Bacteria	57.4	7.24e-9	NR	HEY6010389.1	2026887	g14382	i0	54.5	1.49295774647887	55	17	66.2	1	167	27	25	79	HEY6010389.1 hypothetical protein [Nitrospirota bacterium]	diamond	318	57.4	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium
29997219	29997219	PRJNA315314_S_NODE_27351_length_161_cov_2.113636_g27030_i0	PRJNA315314	27351	161	2.113636	3.40295396	Pseudomonadati	3379134	Bacteria	Bacteria	52.4	4.84e-6	NR	MDH5642359.1	70125	g27030	i0	51.2	3.96894409937888	43	21	80.1	0	158	30	76	118	MDH5642359.1 protein ndvB [Nitrospira sp.]	diamond	639	52.4	1	Bacteria	Pseudomonadati	Nitrospirota	Nitrospiria	Nitrospirales	Nitrospiraceae	Nitrospira	Nitrospira sp.
32192500	32192500	PRJNA315314_S_NODE_25098_length_167_cov_2.956522_g24777_i0	PRJNA315314	25098	167	2.956522	4.93739174	Nitrospirota bacterium	2026887	Bacteria	Bacteria	70.9	4.25e-14	NR	NCO68327.1	2026887	g24777	i0	56.4	3.95209580838323	55	24	98.8	0	2	166	12	66	NCO68327.1 RNA-binding protein [Nitrospirota bacterium]	diamond	660	70.9	1	Bacteria	Pseudomonadati	Nitrospirota					Nitrospirota bacterium

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