metadata: contig_metadata: 8 rows where bioproject = "PRJNA724011", tax_phylum = "Nitrososphaerota" and tax

8 rows where bioproject = "PRJNA724011", 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
27652614	27652614	PRJNA724011_P_NODE_7924_length_1126_cov_2.925926_g7226_i0	PRJNA724011	7924	1126	2.925926	32.94592676	Candidatus Nitrosotalea sp. TS	2341020	Archaea	Archaea	114	1.42e-23	NR	WP_166391621.1	2341020	g7226	i0	35.2	2.56571936056838	321	186	82.9	11	936	4	1060	1368	WP_166391621.1 fibronectin type III domain-containing protein [Candidatus Nitrosotalea sp. TS]	diamond	2889	114	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosotaleales	Nitrosotaleaceae	Nitrosotalea	Candidatus Nitrosotalea sp. TS
27946961	27946961	PRJNA724011_P_NODE_111265_length_234_cov_2.111801_g110242_i0	PRJNA724011	111265	234	2.111801	4.94161434	root	1	Root_unresolved	Root_unresolved	57.8	1.68e-7	NR	MDE1826414.1	2026795	g110242	i0	41.9	7.33333333333333	86	40	98.7	4	2	232	875	959	MDE1826414.1 fibronectin type III domain-containing protein [Nitrososphaerota archaeon]	diamond	1716	58.2	0.993127147766323	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
29294223	29294223	PRJNA724011_P_NODE_24929_length_568_cov_2.614141_g23913_i0	PRJNA724011	24929	568	2.614141	14.84832088	Candidatus Nitrosopolaris rasttigaisensis	2959596	Archaea	Archaea	47.8	0.0111	NR	HMH09660.1	2959596	g23913	i0	30.1	0.77112676056338	146	81	72.4	7	526	116	181	314	HMH09660.1 histidine kinase dimerization/phospho-acceptor domain-containing protein [Candidatus Nitrosopolaris rasttigaisensis]	diamond	438	47.8	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Candidatus Nitrosopolaris	Candidatus Nitrosopolaris rasttigaisensis
29651593	29651593	PRJNA724011_P_NODE_98070_length_248_cov_1.320000_g97047_i0	PRJNA724011	98070	248	1.32	3.2736	Nitrososphaeria	1643678	Archaea	Archaea	64.7	6.91e-10	NR	HEX7258731.1	2169593	g97047	i0	39	7.83870967741935	82	43	99.2	1	248	3	275	349	HEX7258731.1 aldo/keto reductase [Nitrososphaeraceae archaeon]	diamond	1944	64.7	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
30463324	30463324	PRJNA724011_P_NODE_67513_length_307_cov_1.645299_g66490_i0	PRJNA724011	67513	307	1.645299	5.05106793	Nitrososphaerales archaeon	2268197	Archaea	Archaea	43.9	0.0317	NR	HVC26619.1	2268197	g66490	i0	28.6	0.957654723127036	98	63	88.9	1	303	31	228	325	HVC26619.1 hypothetical protein [Nitrososphaerales archaeon]	diamond	294	43.9	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales			Nitrososphaerales archaeon
31252836	31252836	PRJNA724011_P_NODE_51115_length_362_cov_0.799308_g50092_i0	PRJNA724011	51115	362	0.799308	2.89349496	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	45.8	0.0109	NR	MFL6326028.1	2169593	g50092	i0	57.1	2.15469613259669	35	15	29	0	76	180	321	355	MFL6326028.1 ATP-binding protein [Nitrososphaeraceae archaeon]	diamond	780	45.8	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
31379513	31379513	PRJNA724011_P_NODE_92056_length_253_cov_3.100000_g91033_i0	PRJNA724011	92056	253	3.1	7.843	Nitrosopumilales archaeon	2026768	Archaea	Archaea	42.4	0.0442	NR	KAG2477888.1	2026768	g91033	i0	30.3	0.901185770750988	76	50	90.1	1	242	15	126	198	KAG2477888.1 MAG: Alkyl hydroperoxide reductase [Nitrosopumilales archaeon]	diamond	228	42.4	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales			Nitrosopumilales archaeon
32612880	32612880	PRJNA724011_P_NODE_18060_length_701_cov_1.649682_g17062_i0	PRJNA724011	18060	701	1.649682	11.56427082	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	232	5.74e-70	NR	HZD34881.1	2169593	g17062	i0	61.7	1.48930099857347	175	67	74.9	0	535	11	295	469	HZD34881.1 CocE/NonD family hydrolase [Nitrososphaeraceae archaeon]	diamond	1044	232	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae 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);;