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

5 rows where bioproject = "PRJNA846486", 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
19959721	19959721	PRJNA846486_P_NODE_65856_length_178_cov_2.178295_g65760_i0	PRJNA846486	65856	178	2.178295	3.8773651	Nitrosopumilus adriaticus	1580092	Archaea	Archaea	62.1	2.5e-5	NTclustered	gi\|2790751567\|gb\|CP167059.1\|	1580092	g65760	i0	97.222	0.202247191011236	36	1	20	0	124	159	882923	882958	Nitrosopumilus adriaticus strain CCS1 chromosome	blastn	36	62.1	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus adriaticus
27875969	27875969	PRJNA846486_P_NODE_81905_length_167_cov_0.881356_g81809_i0	PRJNA846486	81905	167	0.881356	1.47186452	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	56.2	2.31e-7	NR	HTH21692.1	2169593	g81809	i0	52.2	0.826347305389222	46	20	79	1	9	140	137	182	HTH21692.1 metallophosphoesterase [Nitrososphaeraceae archaeon]	diamond	138	56.2	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
30497219	30497219	PRJNA846486_P_NODE_92253_length_162_cov_1.840708_g92157_i0	PRJNA846486	92253	162	1.840708	2.98194696	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	63.5	4.97e-10	NR	HEX5186900.1	2169593	g92157	i0	51.9	0.962962962962963	52	25	96.3	0	161	6	38	89	HEX5186900.1 hypothetical protein [Nitrososphaeraceae archaeon]	diamond	156	63.5	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
32014604	32014604	PRJNA846486_P_NODE_52738_length_194_cov_1.310345_g52642_i0	PRJNA846486	52738	194	1.310345	2.5420693	Nitrosopumilaceae archaeon	2202732	Archaea	Archaea	56.6	5.74e-8	NR	HWY33630.1	2202732	g52642	i0	51.7	1.85567010309278	60	24	92.8	2	7	186	1	55	HWY33630.1 hypothetical protein [Nitrosopumilaceae archaeon]	diamond	360	56.6	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae		Nitrosopumilaceae archaeon
32741648	32741648	PRJNA846486_P_NODE_79520_length_168_cov_0.873950_g79424_i0	PRJNA846486	79520	168	0.87395	1.468236	Nitrosopumilus sp.	2024843	Archaea	Archaea	51.6	8.63e-6	NR	MDF2425642.1	2024843	g79424	i0	80.8	1.01785714285714	26	5	46.4	0	18	95	239	264	MDF2425642.1 arginine deiminase-related protein [Nitrosopumilus sp.]	diamond	171	51.6	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrosopumilales	Nitrosopumilaceae	Nitrosopumilus	Nitrosopumilus 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);;