metadata: contig_metadata: 6 rows where bioproject = "PRJNA1067370", tax_clade = "FCB group" and tax

6 rows where bioproject = "PRJNA1067370", 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
28488481	28488481	PRJNA1067370_P_NODE_53027_length_290_cov_1.419355_g52478_i0	PRJNA1067370	53027	290	1.419355	4.1161295	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	122	7.98e-30	NR	MBC8197018.1	2026760	g52478	i0	59.8	4.89310344827586	92	35	95.2	1	13	288	239	328	MBC8197018.1 DUF2817 domain-containing protein [Fidelibacterota bacterium]	diamond	1419	122	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
31047015	31047015	PRJNA1067370_P_NODE_8595_length_616_cov_1.760589_g8066_i0	PRJNA1067370	8595	616	1.760589	10.84522824	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	164	2.33e-44	NR	MCJ7802186.1	2026760	g8066	i0	39.8	1.05194805194805	216	110	96.4	6	2	595	228	441	MCJ7802186.1 S10 family peptidase [Fidelibacterota bacterium]	diamond	648	164	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
31615850	31615850	PRJNA1067370_P_NODE_61036_length_278_cov_1.502439_g60487_i0	PRJNA1067370	61036	278	1.502439	4.17678042	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	44.7	0.0123	NR	MED5475719.1	2026760	g60487	i0	51.7	0.31294964028777	29	14	31.3	0	276	190	433	461	MED5475719.1 T9SS type A sorting domain-containing protein [Fidelibacterota bacterium]	diamond	87	44.7	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
31670694	31670694	PRJNA1067370_P_NODE_26917_length_371_cov_1.436242_g26369_i0	PRJNA1067370	26917	371	1.436242	5.32845782	Pseudomonadati	3379134	Bacteria	Bacteria	69.7	5.75e-12	NR	MAV15393.1	2026760	g26369	i0	44	8.02964959568733	84	42	67.1	3	1	249	79	158	MAV15393.1 superoxide dismutase [Fidelibacterota bacterium]	diamond	2979	70.1	0.994293865905849	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
31963711	31963711	PRJNA1067370_P_NODE_55158_length_287_cov_1.439252_g54609_i0	PRJNA1067370	55158	287	1.439252	4.13065324	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	62.8	5.35e-9	NR	MEE9166475.1	2026760	g54609	i0	40.9	0.9198606271777	88	52	92	0	287	24	151	238	MEE9166475.1 tetratricopeptide repeat protein [Fidelibacterota bacterium]	diamond	264	62.8	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
32533589	32533589	PRJNA1067370_P_NODE_76079_length_256_cov_0.819672_g75530_i0	PRJNA1067370	76079	256	0.819672	2.09836032	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	51.6	3.14e-5	NR	MEE3139360.1	2026760	g75530	i0	39.2	2.4609375	74	44	85.5	1	253	35	132	205	MEE3139360.1 SMP-30/gluconolactonase/LRE family protein [Fidelibacterota bacterium]	diamond	630	51.6	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);;