metadata: contig_metadata: 10 rows where bioproject = "PRJNA796753", tax_clade = "FCB group" and tax

10 rows where bioproject = "PRJNA796753", 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_species
10984810	10984810	PRJNA796753_P_NODE_5229_length_590_cov_1.234043_g4922_i0	PRJNA796753	5229	590	1.234043	7.2808537	Bacteria	2	Bacteria	Bacteria	253	3.5e-75	NR	MDP3441810.1	2053306	g4922	i0	64.6	31.7593220338983	195	69	99.2	0	6	590	459	653	MDP3441810.1 carbamoyl-phosphate synthase (glutamine-hydrolyzing) large subunit [Ignavibacteria bacterium]	diamond	18738	253	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
26610477	26610477	PRJNA796753_P_NODE_27741_length_287_cov_1.799065_g27429_i0	PRJNA796753	27741	287	1.799065	5.16331655	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	53.9	7.16e-6	NR	MBI5471685.1	2026749	g27429	i0	34.8	0.689895470383275	66	42	69	1	6	203	322	386	MBI5471685.1 T9SS type A sorting domain-containing protein [Ignavibacteriota bacterium]	diamond	198	53.9	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriota bacterium
26927303	26927303	PRJNA796753_P_NODE_42502_length_249_cov_0.875000_g42190_i0	PRJNA796753	42502	249	0.875	2.17875	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	80.5	2.15e-16	NR	MCW8803186.1	2651163	g42190	i0	43.9	5.92771084337349	82	46	98.8	0	247	2	106	187	MCW8803186.1 pyridoxamine 5'-phosphate oxidase [Ignavibacteriaceae bacterium]	diamond	1476	80.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae bacterium
27116869	27116869	PRJNA796753_P_NODE_48482_length_245_cov_0.895349_g48170_i0	PRJNA796753	48482	245	0.895349	2.19360505	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	71.6	2.51e-12	NR	MBK9248460.1	2053306	g48170	i0	46.2	1.92244897959184	78	38	94.3	2	240	10	309	383	MBK9248460.1 T9SS type A sorting domain-containing protein [Ignavibacteria bacterium]	diamond	471	71.6	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
27284259	27284259	PRJNA796753_P_NODE_19423_length_333_cov_1.450000_g19111_i0	PRJNA796753	19423	333	1.45	4.8285	Pseudomonadati	3379134	Bacteria	Bacteria	101	4.07e-24	NR	MEO8664062.1	2053306	g19111	i0	57	4.06306306306306	93	40	83.8	0	332	54	115	207	MEO8664062.1 aquaporin [Ignavibacteria bacterium]	diamond	1353	101	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
27284274	27284274	PRJNA796753_P_NODE_47303_length_246_cov_0.890173_g46991_i0	PRJNA796753	47303	246	0.890173	2.18982558	Pseudomonadati	3379134	Bacteria	Bacteria	63.2	2.5e-9	NR	MBM4168930.1	2053306	g46991	i0	60.9	1.8780487804878	69	17	80.5	3	200	3	227	288	MBM4168930.1 choice-of-anchor D domain-containing protein [Ignavibacteria bacterium]	diamond	462	63.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
28759110	28759110	PRJNA796753_P_NODE_20247_length_328_cov_1.043137_g19935_i0	PRJNA796753	20247	328	1.043137	3.42148936	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	84	3.66e-16	NR	PLX33511.1	2053306	g19935	i0	43.2	1.98475609756098	111	60	98.8	1	5	328	1492	1602	PLX33511.1 MAG: hypothetical protein C0600_00325 [Ignavibacteria bacterium]	diamond	651	84	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
30211664	30211664	PRJNA796753_P_NODE_29072_length_283_cov_1.466667_g28760_i0	PRJNA796753	29072	283	1.466667	4.15066761	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	67.8	3.67e-11	NR	HQY19360.1	2053306	g28760	i0	45.3	1.60070671378092	75	40	78.4	1	44	265	143	217	HQY19360.1 hypothetical protein [Ignavibacteria bacterium]	diamond	453	67.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
31887086	31887086	PRJNA796753_P_NODE_20497_length_326_cov_1.399209_g20185_i0	PRJNA796753	20497	326	1.399209	4.56142134	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	44.7	0.0195	NR	MBZ0202785.1	2053306	g20185	i0	31.7	0.552147239263804	60	41	55.2	0	222	43	253	312	MBZ0202785.1 hypothetical protein [Ignavibacteria bacterium]	diamond	180	44.7	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
32307909	32307909	PRJNA796753_P_NODE_16179_length_357_cov_1.683099_g15867_i0	PRJNA796753	16179	357	1.683099	6.00866343	Pseudomonadati	3379134	Bacteria	Bacteria	90.1	3.53e-20	NR	MBL8006168.1	2053306	g15867	i0	41.6	2.78991596638655	113	62	91.6	2	4	330	34	146	MBL8006168.1 GNAT family N-acetyltransferase [Ignavibacteria bacterium]	diamond	996	90.9	0.991199119911991	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium

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