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

11 rows where bioproject = "PRJNA770826", 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
18598569	18598569	PRJNA770826_P_NODE_12135_length_231_cov_1.142857_g11964_i0	PRJNA770826	12135	231	1.142857	2.63999967	Bacteria	2	Bacteria	Bacteria	122	3.939999999999999e-31	NR	MBH90782.1	2026760	g11964	i0	76.3	5.83116883116883	76	18	98.7	0	229	2	285	360	MBH90782.1 ADP-forming succinate--CoA ligase subunit beta [Fidelibacterota bacterium]	diamond	1347	122	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
26641715	26641715	PRJNA770826_P_NODE_5961_length_344_cov_1.057627_g5790_i0	PRJNA770826	5961	344	1.057627	3.63823688	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	49.7	3.81e-4	NR	UCD36831.1	2026760	g5790	i0	55.3	0.697674418604651	38	17	33.1	0	124	11	95	132	UCD36831.1 MAG: D-2-hydroxyacid dehydrogenase [Fidelibacterota bacterium]	diamond	240	49.7	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
27758133	27758133	PRJNA770826_P_NODE_17324_length_194_cov_1.475862_g17153_i0	PRJNA770826	17324	194	1.475862	2.86317228	root	1	Root_unresolved	Root_unresolved	85.5	1.65e-17	NR	MFQ6610910.1	2026760	g17153	i0	65.6	6.81958762886598	64	21	99	1	194	3	441	503	MFQ6610910.1 NAD-dependent malic enzyme [Fidelibacterota bacterium]	diamond	1323	85.5	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
27789486	27789486	PRJNA770826_P_NODE_1084_length_810_cov_1.454665_g955_i0	PRJNA770826	1084	810	1.454665	11.7827865	root	1	Root_unresolved	Root_unresolved	277	4.58e-90	NR	MCF7800763.1	2026760	g955	i0	57.7	8.46666666666667	253	107	93.7	0	789	31	5	257	MCF7800763.1 SDR family oxidoreductase [Fidelibacterota bacterium]	diamond	6858	277	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
29147437	29147437	PRJNA770826_P_NODE_19749_length_182_cov_1.563910_g19578_i0	PRJNA770826	19749	182	1.56391	2.8463162	Bacteria	2	Bacteria	Bacteria	73.2	3.04e-13	NR	MAV71195.1	2026760	g19578	i0	56.9	6.74175824175824	58	25	95.6	0	2	175	217	274	MAV71195.1 hypothetical protein [Fidelibacterota bacterium]	diamond	1227	73.2	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
30621880	30621880	PRJNA770826_P_NODE_9873_length_257_cov_1.221154_g9702_i0	PRJNA770826	9873	257	1.221154	3.13836578	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	97.8	4.19e-22	NR	MFL2501077.1	2026760	g9702	i0	74.6	1.36575875486381	59	15	68.9	0	2	178	277	335	MFL2501077.1 glutamine synthetase GlnII [Fidelibacterota bacterium]	diamond	351	97.8	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
30906567	30906567	PRJNA770826_P_NODE_9674_length_260_cov_0.985782_g9503_i0	PRJNA770826	9674	260	0.985782	2.5630332	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	80.5	1.52e-15	NR	MBT3179511.1	2026760	g9503	i0	62.9	0.715384615384615	62	17	71.5	2	68	253	2	57	MBT3179511.1 tryptophan 2,3-dioxygenase [Fidelibacterota bacterium]	diamond	186	80.5	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
31064556	31064556	PRJNA770826_P_NODE_10095_length_254_cov_1.268293_g9924_i0	PRJNA770826	10095	254	1.268293	3.22146422	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	44.3	0.011	NR	MEA3499510.1	2026760	g9924	i0	30.9	0.956692913385827	81	56	95.7	0	251	9	112	192	MEA3499510.1 2-oxo acid dehydrogenase subunit E2 [Fidelibacterota bacterium]	diamond	243	44.3	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
31222086	31222086	PRJNA770826_P_NODE_14815_length_210_cov_0.968944_g14644_i0	PRJNA770826	14815	210	0.968944	2.0347824	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	66.6	9.05e-11	NR	MBS1271721.1	2026760	g14644	i0	50.8	2.81428571428571	65	28	87.1	1	194	12	316	380	MBS1271721.1 hypothetical protein [Fidelibacterota bacterium]	diamond	591	66.6	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
32139766	32139766	PRJNA770826_P_NODE_30158_length_167_cov_0.881356_g29987_i0	PRJNA770826	30158	167	0.881356	1.47186452	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	62.4	3.4e-10	NR	MDP7071417.1	2026760	g29987	i0	62	3.59281437125748	50	19	89.8	0	167	18	58	107	MDP7071417.1 M20/M25/M40 family metallo-hydrolase [Fidelibacterota bacterium]	diamond	600	62.4	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
32234910	32234910	PRJNA770826_P_NODE_318_length_1323_cov_3.730769_g261_i0	PRJNA770826	318	1323	3.730769	49.35807387	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	318	9.8e-97	NR	MBC8197595.1	2026760	g261	i0	39.3	4.67120181405896	433	241	94.3	9	1303	56	1	428	MBC8197595.1 trypsin-like peptidase domain-containing protein [Fidelibacterota bacterium]	diamond	6180	318	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);;