metadata: contig_metadata: 7 rows where bioproject = "PRJNA1144090", tax_clade = "FCB group" and tax

7 rows where bioproject = "PRJNA1144090", tax_clade = "FCB group" and tax_phylum = "Fidelibacterota"

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_species
27038796	27038796	PRJNA1144090_P_NODE_18402_length_637_cov_2.322695_g17881_i0	PRJNA1144090	18402	637	2.322695	14.79556715	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	208	1.9800000000000001e-59	NR	MBL7046163.1	2026760	g17881	i0	51.2	0.993720565149137	211	97	98.4	3	632	6	161	367	MBL7046163.1 S9 family peptidase [Fidelibacterota bacterium]	diamond	633	208	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
28070148	28070148	PRJNA1144090_P_NODE_26265_length_519_cov_1.549327_g25732_i0	PRJNA1144090	26265	519	1.549327	8.04100713	Bacteria	2	Bacteria	Bacteria	179	7.51e-50	NR	MCF7824419.1	2026760	g25732	i0	57.8	5.36994219653179	154	65	89	0	464	3	23	176	MCF7824419.1 NAD-dependent malic enzyme [Fidelibacterota bacterium]	diamond	2787	179	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
29312603	29312603	PRJNA1144090_P_NODE_54589_length_344_cov_2.173432_g54054_i0	PRJNA1144090	54589	344	2.173432	7.47660608	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	51.2	1.19e-4	NR	MDP6275827.1	2026760	g54054	i0	32.2	1.00290697674419	115	61	97.7	5	2	337	213	313	MDP6275827.1 dienelactone hydrolase family protein [Fidelibacterota bacterium]	diamond	345	51.2	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
29691165	29691165	PRJNA1144090_P_NODE_81550_length_279_cov_1.485437_g81015_i0	PRJNA1144090	81550	279	1.485437	4.14436923	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	43.5	0.00371	NR	HOV24074.1	2026760	g81015	i0	42.6	0.505376344086022	47	26	50.5	1	246	106	16	61	HOV24074.1 hypothetical protein [Fidelibacterota bacterium]	diamond	141	43.5	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
30038898	30038898	PRJNA1144090_P_NODE_79591_length_282_cov_2.928230_g79056_i0	PRJNA1144090	79591	282	2.92823	8.2576086	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	68.9	3.42e-11	NR	MAP84712.1	2026760	g79056	i0	42	2.01063829787234	100	46	98.9	4	281	3	4	98	MAP84712.1 carboxypeptidase [Fidelibacterota bacterium]	diamond	567	68.9	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
31860946	31860946	PRJNA1144090_P_NODE_97057_length_254_cov_1.469613_g96522_i0	PRJNA1144090	97057	254	1.469613	3.73281702	root	1	Root_unresolved	Root_unresolved	82.8	1.1e-16	NR	MFL2998725.1	2026760	g96522	i0	47	2.94094488188976	83	44	98	0	249	1	47	129	MFL2998725.1 diacylglycerol/lipid kinase family protein [Fidelibacterota bacterium]	diamond	747	83.6	0.990430622009569	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
32820178	32820178	PRJNA1144090_P_NODE_82680_length_277_cov_1.485294_g82145_i0	PRJNA1144090	82680	277	1.485294	4.11426438	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	82	7.89e-16	NR	MFC1536017.1	2026760	g82145	i0	43.2	1.90613718411552	88	50	95.3	0	272	9	194	281	MFC1536017.1 SLC13 family permease [Fidelibacterota bacterium]	diamond	528	82	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota 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);;