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

10 rows where bioproject = "PRJNA884104", 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
7239721	7239721	PRJNA884104_S_NODE_83966_length_242_cov_0.911243_g83223_i0	PRJNA884104	83966	242	0.911243	2.20520806	Ignavibacterium sp.	2651167	Bacteria	Bacteria	67.6	7.78e-7	NTclustered	gi\|2108406931\|gb\|CP070637.1\|	2651167	g83223	i0	93.333	0.18595041322314	45	3	19	0	195	239	1280938	1280894	MAG: Ignavibacterium sp. isolate bin94 chromosome	blastn	45	67.6	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium sp.
26714788	26714788	PRJNA884104_S_NODE_68301_length_251_cov_1.297753_g67558_i0	PRJNA884104	68301	251	1.297753	3.25736003	Bacteria	2	Bacteria	Bacteria	45.4	0.00457	NR	MDH3267954.1	2053306	g67558	i0	41.1	1.49402390438247	73	33	83.7	4	40	249	302	367	MDH3267954.1 T9SS type A sorting domain-containing protein [Ignavibacteria bacterium]	diamond	375	45.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
26834032	26834032	PRJNA884104_S_NODE_76141_length_247_cov_0.885057_g75398_i0	PRJNA884104	76141	247	0.885057	2.18609079	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	81.6	1.83e-16	NR	MCF8267528.1	2049428	g75398	i0	43.9	1.96761133603239	82	46	99.6	0	247	2	68	149	MCF8267528.1 SDR family NAD(P)-dependent oxidoreductase [Ignavibacteriales bacterium]	diamond	486	81.6	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
27971372	27971372	PRJNA884104_S_NODE_46685_length_305_cov_2.323276_g45942_i0	PRJNA884104	46685	305	2.323276	7.0859918	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	50.8	1.09e-4	NR	MBK7631904.1	2049428	g45942	i0	40	0.786885245901639	80	41	71.8	1	16	234	420	499	MBK7631904.1 APC family permease [Ignavibacteriales bacterium]	diamond	240	50.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
29834292	29834292	PRJNA884104_S_NODE_49211_length_298_cov_1.368889_g48468_i0	PRJNA884104	49211	298	1.368889	4.07928922	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	71.2	2.74e-12	NR	HOI30057.1	2614255	g48468	i0	65.4	0.523489932885906	52	18	52.3	0	141	296	9	60	HOI30057.1 SDR family oxidoreductase [Melioribacteraceae bacterium]	diamond	156	71.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae		Melioribacteraceae bacterium
31097914	31097914	PRJNA884104_S_NODE_2255_length_1321_cov_4.225160_g1938_i0	PRJNA884104	2255	1321	4.22516	55.8143636	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	187	8.6e-52	NR	MCX7875137.1	2614255	g1938	i0	34	1.43981831945496	321	169	71.1	4	1037	99	15	300	MCX7875137.1 fatty acid desaturase [Melioribacteraceae bacterium]	diamond	1902	187	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae		Melioribacteraceae bacterium
31192467	31192467	PRJNA884104_S_NODE_33315_length_355_cov_1.542553_g32572_i0	PRJNA884104	33315	355	1.542553	5.47606315	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	45.8	0.0108	NR	MDP2886256.1	2053306	g32572	i0	40.3	0.650704225352113	77	38	63.4	4	27	251	243	313	MDP2886256.1 protein kinase [Ignavibacteria bacterium]	diamond	231	45.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
31825280	31825280	PRJNA884104_S_NODE_76457_length_247_cov_0.885057_g75714_i0	PRJNA884104	76457	247	0.885057	2.18609079	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	108	2.01e-25	NR	HJY64558.1	2053306	g75714	i0	61	0.995951417004049	82	32	99.6	0	1	246	200	281	HJY64558.1 aminomethyl-transferring glycine dehydrogenase [Ignavibacteria bacterium]	diamond	246	108	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
32332080	32332080	PRJNA884104_S_NODE_84519_length_242_cov_0.911243_g83776_i0	PRJNA884104	84519	242	0.911243	2.20520806	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	46.2	0.00215	NR	MCF6269964.1	2614255	g83776	i0	36.8	0.706611570247934	57	35	69.4	1	236	69	201	257	MCF6269964.1 T9SS type A sorting domain-containing protein [Melioribacteraceae bacterium]	diamond	171	46.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae		Melioribacteraceae bacterium
32875943	32875943	PRJNA884104_S_NODE_81680_length_244_cov_0.888889_g80937_i0	PRJNA884104	81680	244	0.888889	2.16888916	Pseudomonadati	3379134	Bacteria	Bacteria	90.1	7.38e-19	NR	MCX6144561.1	2049428	g80937	i0	50	10.4139344262295	80	40	98.4	0	3	242	207	286	MCX6144561.1 ATP-binding protein [Ignavibacteriales bacterium]	diamond	2541	90.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales 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);;