metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA966993" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA966993" and tax_phylum = "Nitrospinota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26962467	26962467	PRJNA966993_P_NODE_84642_length_250_cov_0.870056_g84190_i0	PRJNA966993	84642	250	0.870056	2.17514	Nitrospinota bacterium	2026769	Bacteria	Bacteria	94.4	2.77e-21	NR	MCH8209702.1	2026769	g84190	i0	53.1	6.78	81	36	97.2	2	244	2	109	187	MCH8209702.1 lipase maturation factor family protein [Nitrospinota bacterium]	diamond	1695	94.4	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
29148452	29148452	PRJNA966993_P_NODE_87469_length_248_cov_0.880000_g87017_i0	PRJNA966993	87469	248	0.88	2.1824	Nitrospinota/Tectimicrobiota group	1802340	Bacteria	Bacteria	52.8	3.45e-6	NR	MDP6620276.1	2026769	g87017	i0	38.5	3.03629032258065	65	35	78.6	2	247	53	41	100	MDP6620276.1 nitrite reductase (NAD(P)H) small subunit [Nitrospinota bacterium]	diamond	753	53.1	0.994350282485876	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
29173467	29173467	PRJNA966993_P_NODE_60649_length_284_cov_1.222749_g60197_i0	PRJNA966993	60649	284	1.222749	3.47260716	Nitrospinota bacterium	2026769	Bacteria	Bacteria	134	6.22e-36	NR	MDH4184548.1	2026769	g60197	i0	65.6	6.83450704225352	93	32	98.2	0	2	280	124	216	MDH4184548.1 class 1 fructose-bisphosphatase [Nitrospinota bacterium]	diamond	1941	134	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
29463383	29463383	PRJNA966993_P_NODE_18790_length_483_cov_1.707317_g18345_i0	PRJNA966993	18790	483	1.707317	8.24634111	Pseudomonadati	3379134	Bacteria	Bacteria	261	2.27e-78	NR	MBU4320326.1	2026769	g18345	i0	80.5	19.4409937888199	149	29	92.5	0	35	481	312	460	MBU4320326.1 phosphoribosylformylglycinamidine synthase [Nitrospinota bacterium]	diamond	9390	263	0.992395437262357	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinota bacterium
31068749	31068749	PRJNA966993_P_NODE_62275_length_281_cov_2.096154_g61823_i0	PRJNA966993	62275	281	2.096154	5.89019274	Nitrospina sp.	2024844	Bacteria	Bacteria	49.7	6.16e-5	NR	MBT5028867.1	2024844	g61823	i0	33.8	0.854092526690391	80	48	85.4	2	240	1	55	129	MBT5028867.1 response regulator [Nitrospina sp.]	diamond	240	49.7	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota	Nitrospinia	Nitrospinales	Nitrospinaceae	Nitrospina	Nitrospina sp.
31701030	31701030	PRJNA966993_P_NODE_97197_length_242_cov_0.911243_g96745_i0	PRJNA966993	97197	242	0.911243	2.20520806	Nitrospinae bacterium AH_259_B05_G02_I21	2935765	Bacteria	Bacteria	73.6	3.27e-13	NR	MDA2916262.1	2935765	g96745	i0	52.3	2.46694214876033	65	31	80.6	0	3	197	247	311	MDA2916262.1 ketoacyl-ACP synthase III [Nitrospinae bacterium AH_259_B05_G02_I21]	diamond	597	73.6	1	Bacteria	Nitrospinota/Tectimicrobiota group	Pseudomonadati	Nitrospinota					Nitrospinae bacterium AH_259_B05_G02_I21

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