metadata: contig_metadata: 5 rows where bioproject = "PRJNA849822", tax_phylum = "Nitrososphaerota" and tax

5 rows where bioproject = "PRJNA849822", 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
3389298	3389298	PRJNA849822_P_NODE_24603_length_292_cov_1.415525_g24429_i0	PRJNA849822	24603	292	1.415525	4.133333	Nitrosopumilus sp.	2024843	Archaea	Archaea	52.8	0.027	NTclustered	gi\|2805380108\|emb\|OY763927.2\|	2024843	g24429	i0	92.105	0.13013698630137	38	2	13	1	179	216	927685	927721	MAG: Nitrosopumilus sp. isolate e501d42f-d10b-4094-a589-3c4c61670bda genome assembly, chromosome: 1	blastn	38	52.8	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
19964929	19964929	PRJNA849822_P_NODE_11816_length_429_cov_1.685393_g11642_i0	PRJNA849822	11816	429	1.685393	7.23033597	root	1	Root_unresolved	Root_unresolved	104	5.219999999999999e-23	NR	MDH3677794.1	2024843	g11642	i0	44.8	2.70629370629371	134	67	93	4	17	415	350	477	MDH3677794.1 peroxidase family protein [Nitrosopumilus sp.]	diamond	1161	105	0.990476190476191	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus sp.
26651464	26651464	PRJNA849822_P_NODE_37401_length_248_cov_2.240000_g37227_i0	PRJNA849822	37401	248	2.24	5.5552	root	1	Root_unresolved	Root_unresolved	53.9	4.7e-6	NR	WP_179363299.1	1959104	g37227	i0	39.4	9.16935483870968	71	37	85.9	1	2	214	1484	1548	WP_179363299.1 Ig-like domain-containing protein [Nitrosopumilus oxyclinae]	diamond	2274	54.3	0.992633517495396	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus oxyclinae
27915885	27915885	PRJNA849822_P_NODE_15125_length_374_cov_1.368771_g14951_i0	PRJNA849822	15125	374	1.368771	5.11920354	root	1	Root_unresolved	Root_unresolved	48.5	0.00158	NR	MDG6921989.1	2026795	g14951	i0	28.3	1.85294117647059	152	58	81	4	304	2	1049	1200	MDG6921989.1 hypothetical protein [Nitrososphaerota archaeon]	diamond	693	48.5	1	Archaea	Thermoproteati	Nitrososphaerota					Nitrososphaerota archaeon
30781623	30781623	PRJNA849822_P_NODE_41394_length_244_cov_0.912281_g41220_i0	PRJNA849822	41394	244	0.912281	2.22596564	Nitrososphaera sp.	1971748	Archaea	Archaea	126	9.8e-32	NR	NOJ27505.1	1971748	g41220	i0	84	0.995901639344262	81	13	99.6	0	1	243	64	144	NOJ27505.1 hypothetical protein [Nitrososphaera sp.]	diamond	243	126	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaera	Nitrososphaera 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);;