metadata: contig_metadata: 12 rows where bioproject = "PRJNA382357", tax_phylum = "Nitrososphaerota" and tax

12 rows where bioproject = "PRJNA382357", tax_phylum = "Nitrososphaerota" and tax_superkingdom = "Archaea"

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
1678549	1678549	PRJNA382357_P_NODE_38082_length_370_cov_7.501618_g37343_i0	PRJNA382357	38082	370	7.501618	27.7559866	Candidatus Nitrosotenuis cloacae	1603555	Archaea	Archaea	309	1.89e-79	NTclustered	gi\|808354332\|gb\|CP011097.2\|	1603555	g37343	i0	89.388	0.97027027027027	245	26	95	0	66	310	1204623	1204379	Candidatus Nitrosotenuis cloacae strain SAT1, complete genome	blastn	359	309	1	Archaea	Thermoproteati	Nitrososphaerota				Candidatus Nitrosotenuis	Candidatus Nitrosotenuis cloacae
1678595	1678595	PRJNA382357_P_NODE_40002_length_362_cov_4.538206_g39263_i0	PRJNA382357	40002	362	4.538206	16.42830572	root	1	Root_unresolved	Root_unresolved	110	2.5200000000000003e-27	NR	MBA4453716.1	2202732	g39263	i0	96.4	1.44198895027624	55	2	45.6	0	272	108	1	55	MBA4453716.1 aminodeoxychorismate/anthranilate synthase component II [Nitrosopumilaceae archaeon]	diamond	522	111	0.990990990990991	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae		Nitrosopumilaceae archaeon
2954291	2954291	PRJNA382357_P_NODE_32663_length_397_cov_0.916667_g31924_i0	PRJNA382357	32663	397	0.916667	3.63916799	Nitrosopumilus sp.	2024843	Archaea	Archaea	54.7	0.011	NTclustered	gi\|1885871577\|gb\|CP046181.1\|	2024843	g31924	i0	96.875	0.0806045340050378	32	1	8	0	350	381	648138	648107	MAG: Nitrosopumilus sp. isolate MH-Pat-all_metabat2_16 chromosome	blastn	32	54.7	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
28969865	28969865	PRJNA382357_P_NODE_128988_length_215_cov_1.688312_g128249_i0	PRJNA382357	128988	215	1.688312	3.6298708	Nitrosopumilaceae archaeon	2202732	Archaea	Archaea	55.8	5.77e-7	NR	HWY33017.1	2202732	g128249	i0	59.5	0.586046511627907	42	17	58.6	0	158	33	117	158	HWY33017.1 ATP-binding protein [Nitrosopumilaceae archaeon]	diamond	126	55.8	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae		Nitrosopumilaceae archaeon
29285415	29285415	PRJNA382357_P_NODE_117769_length_225_cov_1.548780_g117030_i0	PRJNA382357	117769	225	1.54878	3.484755	Nitrosopumilaceae archaeon	2202732	Archaea	Archaea	59.7	3.03e-8	NR	NIT99516.1	2202732	g117030	i0	65.1	0.573333333333333	43	15	57.3	0	221	93	552	594	NIT99516.1 hypothetical protein [Nitrosopumilaceae archaeon]	diamond	129	59.7	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae		Nitrosopumilaceae archaeon
29380333	29380333	PRJNA382357_P_NODE_37229_length_374_cov_1.738019_g36490_i0	PRJNA382357	37229	374	1.738019	6.50019106	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	89	7.96e-18	NR	HJS63236.1	2169593	g36490	i0	33.9	1.98128342245989	124	74	93	2	19	366	256	379	HJS63236.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	741	89	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
30485847	30485847	PRJNA382357_P_NODE_153453_length_203_cov_0.915493_g152714_i0	PRJNA382357	153453	203	0.915493	1.85845079	Nitrososphaerota archaeon	2026795	Archaea	Archaea	54.3	7.87e-7	NR	MDG6949145.1	2026795	g152714	i0	67.7	0.458128078817734	31	10	45.8	0	190	98	157	187	MDG6949145.1 site-specific integrase [Nitrososphaerota archaeon]	diamond	93	54.3	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
30612009	30612009	PRJNA382357_P_NODE_107973_length_234_cov_1.491329_g107234_i0	PRJNA382357	107973	234	1.491329	3.48970986	Nitrososphaerota archaeon	2026795	Archaea	Archaea	43.5	0.00185	NR	NMJ87812.1	2026795	g107234	i0	76	0.320512820512821	25	6	32.1	0	6	80	16	40	NMJ87812.1 hypothetical protein [Nitrososphaerota archaeon]	diamond	75	43.5	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
30850281	30850281	PRJNA382357_P_NODE_121234_length_222_cov_1.453416_g120495_i0	PRJNA382357	121234	222	1.453416	3.22658352	Nitrososphaeraceae	1033997	Archaea	Archaea	104	5.19e-25	NR	WP_292643163.1	1971748	g120495	i0	65.3	1.94594594594595	72	25	97.3	0	222	7	21	92	WP_292643163.1 DUF5655 domain-containing protein [Nitrososphaera sp.]	diamond	432	104	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera sp.
30928302	30928302	PRJNA382357_P_NODE_60494_length_302_cov_0.887967_g59755_i0	PRJNA382357	60494	302	0.887967	2.68166034	Nitrosopumilus sp.	2024843	Archaea	Archaea	83.2	9.18e-17	NR	MEK0324373.1	2024843	g59755	i0	56.5	2.90066225165563	69	30	68.5	0	208	2	120	188	MEK0324373.1 hypothetical protein [Nitrosopumilus sp.]	diamond	876	83.2	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
31180595	31180595	PRJNA382357_P_NODE_41195_length_358_cov_1.087542_g40456_i0	PRJNA382357	41195	358	1.087542	3.89340036	Candidatus Nitrosocosmicus sp.	2109671	Archaea	Archaea	129	9.229999999999999e-35	NR	HEY0579649.1	2109671	g40456	i0	56.3	0.863128491620112	103	45	86.3	0	356	48	127	229	HEY0579649.1 methyltransferase domain-containing protein [Candidatus Nitrosocosmicus sp.]	diamond	309	129	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosocosmicus	Candidatus Nitrosocosmicus sp.
32730342	32730342	PRJNA382357_P_NODE_46620_length_339_cov_1.338129_g45881_i0	PRJNA382357	46620	339	1.338129	4.53625731	Nitrososphaerota archaeon	2026795	Archaea	Archaea	54.3	6.56e-6	NR	MDG6912588.1	2026795	g45881	i0	33.6	0.946902654867257	107	64	92.9	3	327	13	121	222	MDG6912588.1 hypothetical protein [Nitrososphaerota archaeon]	diamond	321	54.3	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon

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