metadata: contig_metadata: 15 rows where bioproject = "PRJNA662254", tax_clade = "FCB group" and tax

15 rows where bioproject = "PRJNA662254", tax_clade = "FCB group" and tax_phylum = "Ignavibacteriota"

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_class	tax_order	tax_family	tax_genus	tax_species
628280	628280	PRJNA662254_P_NODE_31461_length_296_cov_1.654709_g30810_i0	PRJNA662254	31461	296	1.654709	4.89793864	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1938792964\|gb\|CP054182.1\|	2049428	g30810	i0	96.97	0.111486486486486	33	1	11	0	19	51	4162919	4162951	Ignavibacteriales bacterium isolate H2_BAC3 chromosome, complete genome	blastn	33	56.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
24113913	24113913	PRJNA662254_P_NODE_65779_length_241_cov_0.916667_g65128_i0	PRJNA662254	65779	241	0.916667	2.20916747	Pseudomonadati	3379134	Bacteria	Bacteria	157	2.44e-43	NR	MEI9970730.1	2026749	g65128	i0	93.8	1.99170124481328	80	5	99.6	0	2	241	101	180	MEI9970730.1 serine/threonine-protein kinase [Ignavibacteriota bacterium]	diamond	480	157	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
26669643	26669643	PRJNA662254_P_NODE_54021_length_247_cov_0.885057_g53370_i0	PRJNA662254	54021	247	0.885057	2.18609079	Rosettibacter firmus	3111522	Bacteria	Bacteria	72.8	5.83e-13	NR	WP_353680176.1	3111522	g53370	i0	76.7	1.04453441295547	43	10	52.2	0	119	247	1	43	WP_353680176.1 FAD-dependent thymidylate synthase [Rosettibacter firmus]	diamond	258	72.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Rosettibacter	Rosettibacter firmus
26701434	26701434	PRJNA662254_P_NODE_60461_length_243_cov_1.158824_g59810_i0	PRJNA662254	60461	243	1.158824	2.81594232	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	74.7	1.34e-13	NR	HEY6437597.1	2651163	g59810	i0	51.3	0.987654320987654	80	39	98.8	0	3	242	54	133	HEY6437597.1 hypothetical protein [Ignavibacteriaceae bacterium]	diamond	240	74.7	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
26986384	26986384	PRJNA662254_P_NODE_45282_length_251_cov_0.865169_g44631_i0	PRJNA662254	45282	251	0.865169	2.17157419	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	157	1.7499999999999999e-46	NR	MDR3667804.1	2651163	g44631	i0	90.4	0.99203187250996006	83	8	99.2	0	250	2	57	139	MDR3667804.1 16S rRNA (cytidine(1402)-2'-O)-methyltransferase [Ignavibacteriaceae bacterium]	diamond	249	157	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
27049931	27049931	PRJNA662254_P_NODE_46822_length_250_cov_0.870056_g46171_i0	PRJNA662254	46822	250	0.870056	2.17514	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	145	4.05e-39	NR	HEY6436679.1	2651163	g46171	i0	83.1	1.992	83	14	99.6	0	249	1	241	323	HEY6436679.1 DnaB-like helicase C-terminal domain-containing protein [Ignavibacteriaceae bacterium]	diamond	498	145	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
27808214	27808214	PRJNA662254_P_NODE_63604_length_242_cov_0.911243_g62953_i0	PRJNA662254	63604	242	0.911243	2.20520806	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	57.4	2.56e-7	NR	MDR3627005.1	2651163	g62953	i0	40	0.929752066115702	75	45	93	0	2	226	331	405	MDR3627005.1 cohesin domain-containing protein [Ignavibacteriaceae bacterium]	diamond	225	57.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
29051724	29051724	PRJNA662254_P_NODE_54128_length_247_cov_0.885057_g53477_i0	PRJNA662254	54128	247	0.885057	2.18609079	Pseudomonadati	3379134	Bacteria	Bacteria	87.8	1.5e-18	NR	OGU61889.1	1798431	g53477	i0	50.6	7.42105263157895	81	39	98.4	1	244	2	56	135	OGU61889.1 MAG: hypothetical protein A2X60_16000 [Ignavibacteria bacterium GWF2_35_20]	diamond	1833	87.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium GWF2_35_20
29102643	29102643	PRJNA662254_P_NODE_57828_length_245_cov_0.895349_g57177_i0	PRJNA662254	57828	245	0.895349	2.19360505	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	151	1.35e-44	NR	MEP7234891.1	2026749	g57177	i0	85.2	1.98367346938776	81	12	99.2	0	1	243	5	85	MEP7234891.1 NAD(P)H-dependent oxidoreductase subunit E [Ignavibacteriota bacterium]	diamond	486	151	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
30303076	30303076	PRJNA662254_P_NODE_55452_length_246_cov_0.890173_g54801_i0	PRJNA662254	55452	246	0.890173	2.18982558	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	108	2.69e-25	NR	MEI9975406.1	2026749	g54801	i0	66.3	0.975609756097561	80	27	97.6	0	245	6	302	381	MEI9975406.1 PIG-L family deacetylase [Ignavibacteriota bacterium]	diamond	240	108	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
30397908	30397908	PRJNA662254_P_NODE_61793_length_243_cov_0.905882_g61142_i0	PRJNA662254	61793	243	0.905882	2.20129326	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	94.4	2.71e-20	NR	MDQ7815668.1	2614255	g61142	i0	63.9	0.888888888888889	72	26	88.9	0	216	1	2238	2309	MDQ7815668.1 fibronectin type III domain-containing protein [Melioribacteraceae bacterium]	diamond	216	94.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae		Melioribacteraceae bacterium
30649918	30649918	PRJNA662254_P_NODE_52073_length_248_cov_0.880000_g51422_i0	PRJNA662254	52073	248	0.88	2.1824	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	55.5	2.9e-7	NR	MEI9973697.1	2026749	g51422	i0	50.9	1.29435483870968	53	26	64.1	0	164	6	6	58	MEI9973697.1 PIG-L family deacetylase [Ignavibacteriota bacterium]	diamond	321	55.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
31535372	31535372	PRJNA662254_P_NODE_58776_length_244_cov_0.900585_g58125_i0	PRJNA662254	58776	244	0.900585	2.1974274	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	166	1.4099999999999998e-45	NR	MBI2419802.1	2049428	g58125	i0	97.5	3.95901639344262	81	2	99.6	0	243	1	511	591	MBI2419802.1 DEAD/DEAH box helicase family protein [Ignavibacteriales bacterium]	diamond	966	166	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
32516170	32516170	PRJNA662254_P_NODE_45039_length_251_cov_0.865169_g44388_i0	PRJNA662254	45039	251	0.865169	2.17157419	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	118	5.59e-32	NR	MEI9971789.1	2026749	g44388	i0	67.1	1.9601593625498	82	27	98	0	4	249	56	137	MEI9971789.1 hypothetical protein [Ignavibacteriota bacterium]	diamond	492	118	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
32799330	32799330	PRJNA662254_P_NODE_45200_length_251_cov_0.865169_g44549_i0	PRJNA662254	45200	251	0.865169	2.17157419	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	163	1.7199999999999998e-47	NR	HEY5533896.1	2053306	g44549	i0	79.5	1.9840637450199201	83	17	99.2	0	251	3	37	119	HEY5533896.1 alcohol dehydrogenase [Ignavibacteria bacterium]	diamond	498	163	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria 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);;