metadata: contig_metadata: 11 rows where bioproject = "PRJNA724011", tax_clade = "FCB group" and tax

11 rows where bioproject = "PRJNA724011", 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
27178434	27178434	PRJNA724011_P_NODE_73922_length_291_cov_1.059633_g72899_i0	PRJNA724011	73922	291	1.059633	3.08353203	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	44.3	0.0176	NR	MBK7229118.1	2049428	g72899	i0	35.4	0.494845360824742	48	31	49.5	0	283	140	235	282	MBK7229118.1 dipeptide epimerase [Ignavibacteriales bacterium]	diamond	144	44.3	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales		Ignavibacteriales bacterium
29010538	29010538	PRJNA724011_P_NODE_83828_length_269_cov_2.484694_g82805_i0	PRJNA724011	83828	269	2.484694	6.68382686	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	58.2	9.72e-8	NR	RCK76482.1	2026749	g82805	i0	48.7	3.5910780669145	76	31	84.8	3	13	240	14	81	RCK76482.1 MAG: Deoxyadenosine kinase [Ignavibacteriota bacterium]	diamond	966	58.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriota bacterium
30652275	30652275	PRJNA724011_P_NODE_52033_length_358_cov_1.350877_g51010_i0	PRJNA724011	52033	358	1.350877	4.83613966	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	53.5	2.42e-5	NR	MFA7419280.1	2614255	g51010	i0	39.8	5.20391061452514	83	47	67.9	2	95	337	1373	1454	MFA7419280.1 SdrD B-like domain-containing protein [Melioribacteraceae bacterium]	diamond	1863	53.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacteraceae bacterium
30747351	30747351	PRJNA724011_P_NODE_76734_length_284_cov_2.597156_g75711_i0	PRJNA724011	76734	284	2.597156	7.37592304	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	47	9.65e-4	NR	MCX7875075.1	2614255	g75711	i0	54.3	0.982394366197183	46	18	45.4	1	250	122	1	46	MCX7875075.1 lipocalin family protein [Melioribacteraceae bacterium]	diamond	279	47	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacteraceae bacterium
31000105	31000105	PRJNA724011_P_NODE_50274_length_365_cov_1.945205_g49251_i0	PRJNA724011	50274	365	1.945205	7.09999825	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	101	3.72e-24	NR	MCB9207625.1	2049428	g49251	i0	44.5	0.904109589041096	110	60	89.6	1	328	2	27	136	MCB9207625.1 ion transporter [Ignavibacteriales bacterium]	diamond	330	101	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales		Ignavibacteriales bacterium
31410992	31410992	PRJNA724011_P_NODE_13356_length_843_cov_1.475325_g12443_i0	PRJNA724011	13356	843	1.475325	12.43698975	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	140	8.630000000000001e-36	NR	MCX7875137.1	2614255	g12443	i0	33.6	4.0355871886121	256	127	88.3	4	10	753	80	300	MCX7875137.1 fatty acid desaturase [Melioribacteraceae bacterium]	diamond	3402	140	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacteraceae bacterium
31663902	31663902	PRJNA724011_P_NODE_6017_length_1282_cov_9.592225_g155_i2	PRJNA724011	6017	1282	9.592225	122.9723245	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	48.9	0.0179	NR	MCF8413947.1	2614255	g155	i2	32.2	0.526521060842434	87	44	20.4	2	1003	1263	120	191	MCF8413947.1 hypothetical protein [Melioribacteraceae bacterium]	diamond	675	48.9	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacteraceae bacterium
32360269	32360269	PRJNA724011_P_NODE_100259_length_247_cov_0.885057_g99236_i0	PRJNA724011	100259	247	0.885057	2.18609079	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	110	1.82e-26	NR	MBZ0199031.1	2651163	g99236	i0	58	0.983805668016194	81	34	98.4	0	247	5	206	286	MBZ0199031.1 beta-lactamase family protein [Ignavibacteriaceae bacterium]	diamond	243	110	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae bacterium
32801721	32801721	PRJNA724011_P_NODE_30500_length_500_cov_1.960187_g29482_i0	PRJNA724011	30500	500	1.960187	9.800935	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	99	1.61e-20	NR	MBI3195314.1	2026749	g29482	i0	33.6	0.894	149	98	89.4	1	475	29	1269	1416	MBI3195314.1 T9SS type A sorting domain-containing protein [Ignavibacteriota bacterium]	diamond	447	99	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriota bacterium
32843611	32843611	PRJNA724011_P_NODE_74660_length_289_cov_1.425926_g73637_i0	PRJNA724011	74660	289	1.425926	4.12092614	Bacteria	2	Bacteria	Bacteria	98.6	8.379999999999999e-23	NR	NCS88116.1	2053306	g73637	i0	52.4	29.2110726643599	82	39	85.1	0	279	34	170	251	NCS88116.1 3-oxoacyl-[acyl-carrier-protein] reductase [Ignavibacteria bacterium]	diamond	8442	99.4	0.991951710261569	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
32875155	32875155	PRJNA724011_P_NODE_37760_length_438_cov_0.969863_g36737_i0	PRJNA724011	37760	438	0.969863	4.24799994	Bacteria	2	Bacteria	Bacteria	96.3	5.9e-20	NR	OIP63676.1	1805221	g36737	i0	39.9	2.02739726027397	148	83	97.9	5	8	436	75	221	OIP63676.1 MAG: hypothetical protein AUK34_01090 [Ignavibacteria bacterium CG2_30_36_16]	diamond	888	96.3	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium CG2_30_36_16

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