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

6 rows where bioproject = "PRJNA1105232", 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
26878134	26878134	PRJNA1105232_S_NODE_9941_length_202_cov_3.771242_g9725_i0	PRJNA1105232	9941	202	3.771242	7.61790884	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	94.7	7.63e-21	NR	MDB4859268.1	2026760	g9725	i0	66.7	5.88118811881188	66	21	98	1	200	3	379	443	MDB4859268.1 glycoside hydrolase family 1 protein [Fidelibacterota bacterium]	diamond	1188	94.7	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
27130499	27130499	PRJNA1105232_S_NODE_8722_length_213_cov_1.268293_g8506_i0	PRJNA1105232	8722	213	1.268293	2.70146409	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	42.7	0.00948	NR	HPD26207.1	2026760	g8506	i0	37.9	2.7887323943662	66	37	93	1	209	12	60	121	HPD26207.1 dihydroneopterin aldolase [Fidelibacterota bacterium]	diamond	594	42.7	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
28583744	28583744	PRJNA1105232_S_NODE_5407_length_257_cov_1.250000_g5191_i0	PRJNA1105232	5407	257	1.25	3.2125	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	47.8	7.46e-4	NR	MCH7620101.1	2026760	g5191	i0	53.1	0.571984435797665	49	22	57.2	1	235	89	464	511	MCH7620101.1 hypothetical protein [Fidelibacterota bacterium]	diamond	147	47.8	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
31458314	31458314	PRJNA1105232_S_NODE_12116_length_186_cov_1.788321_g11900_i0	PRJNA1105232	12116	186	1.788321	3.32627706	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	75.5	4.8e-14	NR	RTZ96105.1	2026760	g11900	i0	59.3	2.88709677419355	59	24	95.2	0	179	3	382	440	RTZ96105.1 MAG: hypothetical protein DSY36_01315, partial [Fidelibacterota bacterium]	diamond	537	75.5	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
32027611	32027611	PRJNA1105232_S_NODE_10878_length_195_cov_1.068493_g10662_i0	PRJNA1105232	10878	195	1.068493	2.08356135	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	78.6	4.54e-15	NR	MBL7013117.1	2026760	g10662	i0	57.8	12.5076923076923	64	27	98.5	0	2	193	433	496	MBL7013117.1 NAD-dependent malic enzyme [Fidelibacterota bacterium]	diamond	2439	78.6	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
32628254	32628254	PRJNA1105232_S_NODE_7340_length_228_cov_1.486034_g7124_i0	PRJNA1105232	7340	228	1.486034	3.38815752	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	77.4	1.72e-14	NR	MFB0515659.1	2026760	g7124	i0	52.2	6.31578947368421	69	32	90.8	1	2	208	354	421	MFB0515659.1 M28 family metallopeptidase [Fidelibacterota bacterium]	diamond	1440	77.4	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);;