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

10 rows where bioproject = "PRJNA966993", 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
20391859	20391859	PRJNA966993_P_NODE_26196_length_412_cov_1.817109_g25749_i0	PRJNA966993	26196	412	1.817109	7.48648908	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	160	4.76e-43	NR	MED5474657.1	2026760	g25749	i0	58.9	3.09466019417476	141	49	99	4	410	3	118	254	MED5474657.1 M14 family zinc carboxypeptidase [Fidelibacterota bacterium]	diamond	1275	160	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
28225835	28225835	PRJNA966993_P_NODE_88386_length_248_cov_0.880000_g87934_i0	PRJNA966993	88386	248	0.88	2.1824	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	79	6.96e-15	NR	MCK4689299.1	2026760	g87934	i0	53.9	3.85887096774194	76	33	90.7	2	22	246	499	573	MCK4689299.1 glycoside hydrolase family 3 C-terminal domain-containing protein [Fidelibacterota bacterium]	diamond	957	79	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
28289005	28289005	PRJNA966993_P_NODE_101906_length_206_cov_5.135338_g101454_i0	PRJNA966993	101906	206	5.135338	10.57879628	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	70.9	2.72e-12	NR	MEE2765532.1	2026760	g101454	i0	52.9	4.82038834951456	68	14	99	1	205	2	422	471	MEE2765532.1 NAD-dependent malic enzyme [Fidelibacterota bacterium]	diamond	993	70.9	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
29078710	29078710	PRJNA966993_P_NODE_26008_length_413_cov_3.582353_g25561_i0	PRJNA966993	26008	413	3.582353	14.79511789	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	68.9	3.43e-11	NR	MCF7885864.1	2026760	g25561	i0	54.7	0.937046004842615	64	20	46.5	2	356	165	16	70	MCF7885864.1 bifunctional nicotinamidase/pyrazinamidase [Fidelibacterota bacterium]	diamond	387	68.9	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
29078769	29078769	PRJNA966993_P_NODE_93528_length_244_cov_1.801170_g93076_i0	PRJNA966993	93528	244	1.80117	4.3948548	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	119	3.22e-31	NR	MCF7796703.1	2026760	g93076	i0	71.3	0.983606557377049	80	23	98.4	0	241	2	85	164	MCF7796703.1 SDR family NAD(P)-dependent oxidoreductase [Fidelibacterota bacterium]	diamond	240	119	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
30120543	30120543	PRJNA966993_P_NODE_38752_length_345_cov_1.698529_g38300_i0	PRJNA966993	38752	345	1.698529	5.85992505	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	132	1.76e-35	NR	MCH7497998.1	2026760	g38300	i0	52.6	0.991304347826087	114	54	99.1	0	344	3	67	180	MCH7497998.1 pirin family protein [Fidelibacterota bacterium]	diamond	342	132	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
30183825	30183825	PRJNA966993_P_NODE_10312_length_652_cov_2.449050_g9888_i0	PRJNA966993	10312	652	2.44905	15.967806	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	55.5	5.14e-5	NR	MFL2982758.1	2026760	g9888	i0	31.5	0.570552147239264	124	76	55.2	4	631	272	249	367	MFL2982758.1 hypothetical protein [Fidelibacterota bacterium]	diamond	372	55.5	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
30247253	30247253	PRJNA966993_P_NODE_100012_length_238_cov_2.618182_g99560_i0	PRJNA966993	100012	238	2.618182	6.23127316	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	62	5.36e-9	NR	MEE9162194.1	2026760	g99560	i0	44.7	1.91596638655462	76	42	95.8	0	9	236	323	398	MEE9162194.1 M28 family metallopeptidase [Fidelibacterota bacterium]	diamond	456	62	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
30594519	30594519	PRJNA966993_P_NODE_98973_length_241_cov_0.916667_g98521_i0	PRJNA966993	98973	241	0.916667	2.20916747	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	77	3.11e-14	NR	MCH7575338.1	2026760	g98521	i0	50	1.0207468879668	82	36	95.9	2	235	5	249	330	MCH7575338.1 alkaline phosphatase D family protein [Fidelibacterota bacterium]	diamond	246	77	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
32371917	32371917	PRJNA966993_P_NODE_9619_length_676_cov_2.122720_g9201_i0	PRJNA966993	9619	676	2.12272	14.3495872	Bacteria	2	Bacteria	Bacteria	228	5.26e-68	NR	MBT4068219.1	2026760	g9201	i0	48.7	10.0295857988166	226	114	99.9	2	676	2	312	536	MBT4068219.1 hypothetical protein [Fidelibacterota bacterium]	diamond	6780	229	0.995633187772926	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);;