metadata: contig_metadata: 9 rows where bioproject = "PRJNA966993", tax_clade = "FCB group" and tax

9 rows where bioproject = "PRJNA966993", tax_clade = "FCB group" and tax_phylum = "Ignavibacteriota"

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
24217170	24217170	PRJNA966993_P_NODE_15679_length_528_cov_1.560440_g15237_i0	PRJNA966993	15679	528	1.56044	8.2391232	Bacteria	2	Bacteria	Bacteria	204	1.83e-61	NR	KXK50762.1	1617412	g15237	i0	61.3	3.59659090909091	160	62	90.9	0	480	1	2	161	KXK50762.1 MAG: Tryptophan 2,3-dioxygenase [Chlorobi bacterium OLB5]	diamond	1899	206	0.990291262135922	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Candidatus Tepidiaquacellales			Candidatus Tepidiaquacellales bacterium OLB5
26677405	26677405	PRJNA966993_P_NODE_71701_length_267_cov_3.237113_g71249_i0	PRJNA966993	71701	267	3.237113	8.64309171	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	75.1	3.07e-14	NR	HJY64145.1	2053306	g71249	i0	60.3	1.32584269662921	58	19	65.2	1	89	262	4	57	HJY64145.1 aquaporin [Ignavibacteria bacterium]	diamond	354	75.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
27089246	27089246	PRJNA966993_P_NODE_96762_length_242_cov_1.769231_g96310_i0	PRJNA966993	96762	242	1.769231	4.28153902	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	87.4	5.29e-18	NR	MBN1301843.1	2614255	g96310	i0	51.3	0.991735537190083	80	39	99.2	0	241	2	196	275	MBN1301843.1 Glu/Leu/Phe/Val dehydrogenase [Melioribacteraceae bacterium]	diamond	240	87.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae		Melioribacteraceae bacterium
29337537	29337537	PRJNA966993_P_NODE_52729_length_298_cov_2.933333_g52277_i0	PRJNA966993	52729	298	2.933333	8.74133234	Pseudomonadati	3379134	Bacteria	Bacteria	83.6	1.05e-17	NR	OGV03533.1	1798447	g52277	i0	41.7	9.02013422818792	103	54	97.7	2	1	291	64	166	OGV03533.1 MAG: hypothetical protein A2330_06670 [Ignavibacteria bacterium RIFOXYB2_FULL_36_7]	diamond	2688	84	0.995238095238095	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium RIFOXYB2_FULL_36_7
29836316	29836316	PRJNA966993_P_NODE_70231_length_270_cov_1.192893_g69779_i0	PRJNA966993	70231	270	1.192893	3.2208111	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	53.5	7.59e-6	NR	MDP3444116.1	2053306	g69779	i0	43.6	0.866666666666667	78	42	86.7	2	268	35	198	273	MDP3444116.1 IPT/TIG domain-containing protein [Ignavibacteria bacterium]	diamond	234	53.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
29994492	29994492	PRJNA966993_P_NODE_96631_length_242_cov_1.822485_g96179_i0	PRJNA966993	96631	242	1.822485	4.4104137	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	53.5	5.46e-6	NR	MDP3444116.1	2053306	g96179	i0	45.2	0.768595041322314	62	32	76.9	1	231	46	197	256	MDP3444116.1 IPT/TIG domain-containing protein [Ignavibacteria bacterium]	diamond	186	53.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
30562705	30562705	PRJNA966993_P_NODE_101473_length_226_cov_3.418301_g101021_i0	PRJNA966993	101473	226	3.418301	7.72536026	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	60.5	8.69e-10	NR	MCX8009861.1	2053306	g101021	i0	56.3	4.57964601769912	48	21	63.7	0	64	207	3	50	MCX8009861.1 RNA-binding protein [Ignavibacteria bacterium]	diamond	1035	60.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
31447950	31447950	PRJNA966993_P_NODE_22936_length_439_cov_1.262295_g22489_i0	PRJNA966993	22936	439	1.262295	5.54147505	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	256	8.120000000000001e-80	NR	NWF50469.1	2651163	g22489	i0	79.6	11.0637813211845	147	29	99.8	1	1	438	183	329	NWF50469.1 phosphoenolpyruvate carboxykinase (GTP) [Ignavibacteriaceae bacterium]	diamond	4857	256	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
32371887	32371887	PRJNA966993_P_NODE_2539_length_1254_cov_4.579170_g2301_i0	PRJNA966993	2539	1254	4.57917	57.4227918	root	1	Root_unresolved	Root_unresolved	156	7.25e-39	NR	WP_014856245.1	1134405	g2301	i0	34.3	7.16746411483254	329	185	74.9	15	1137	199	24	337	WP_014856245.1 PQQ-dependent sugar dehydrogenase [Melioribacter roseus]	diamond	8988	157	0.993630573248408	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacter	Melioribacter roseus

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