metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA938397" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA938397" and tax_clade = "FCB group"

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
13667291	13667291	PRJNA938397_S_NODE_44291_length_165_cov_1.562500_g44050_i0	PRJNA938397	44291	165	1.5625	2.578125	Limibacter armeniacum	466084	Bacteria	Bacteria	90.1	2.59e-19	NR	WP_334245523.1	466084	g44050	i0	84.6	9.45454545454546	52	8	94.5	0	8	163	642	693	WP_334245523.1 methylmalonyl-CoA mutase [Limibacter armeniacum]	diamond	1560	90.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae	Limibacter	Limibacter armeniacum
26874099	26874099	PRJNA938397_S_NODE_39101_length_176_cov_1.942446_g38860_i0	PRJNA938397	39101	176	1.942446	3.41870496	root	1	Root_unresolved	Root_unresolved	61.6	3.26e-9	NR	WP_132773138.1	28453	g38860	i0	57.4	13.0397727272727	54	22	92	1	176	15	13	65	WP_132773138.1 MULTISPECIES: glycerol kinase GlpK [Sphingobacterium]	diamond	2295	62	0.993548387096774	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium
28667362	28667362	PRJNA938397_S_NODE_37087_length_181_cov_2.305556_g36846_i0	PRJNA938397	37087	181	2.305556	4.17305636	Pricia mediterranea	3076079	Bacteria	Bacteria	45.4	0.00159	NR	WP_314016521.1	3076079	g36846	i0	64.3	1.39226519337017	28	10	46.4	0	3	86	208	235	WP_314016521.1 6-phosphogluconolactonase [Pricia mediterranea]	diamond	252	45.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Pricia	Pricia mediterranea
28951608	28951608	PRJNA938397_S_NODE_22828_length_231_cov_7.458763_g22587_i0	PRJNA938397	22828	231	7.458763	17.22974253	Chitinophagales bacterium	2448779	Bacteria	Bacteria	62.8	3.89e-10	NR	MFN8261091.1	2448779	g22587	i0	54.7	2.75324675324675	53	24	68.8	0	3	161	103	155	MFN8261091.1 TspO/MBR family protein [Chitinophagales bacterium]	diamond	636	62.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales			Chitinophagales bacterium
29431730	29431730	PRJNA938397_S_NODE_25829_length_217_cov_4.722222_g25588_i0	PRJNA938397	25829	217	4.722222	10.24722174	Bacteroidota	976	Bacteria	Bacteria	42.4	0.0349	NR	MBQ1276413.1	2021391	g25588	i0	51.6	1.34101382488479	31	15	42.9	0	18	110	375	405	MBQ1276413.1 phosphoribosylformylglycinamidine synthase subunit PurQ [Flavobacteriales bacterium]	diamond	291	42.7	0.992974238875878	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
29551096	29551096	PRJNA938397_S_NODE_41510_length_170_cov_6.496241_g41269_i0	PRJNA938397	41510	170	6.496241	11.0436097	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	58.9	2.63e-8	NR	MBD23917.1	2026760	g41269	i0	54	7.2	50	23	88.2	0	2	151	328	377	MBD23917.1 hypothetical protein [Fidelibacterota bacterium]	diamond	1224	58.9	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota					Fidelibacterota bacterium
29677223	29677223	PRJNA938397_S_NODE_21490_length_238_cov_6.930348_g21249_i0	PRJNA938397	21490	238	6.930348	16.49422824	Bacteroidota bacterium	1898104	Bacteria	Bacteria	44.3	0.00822	NR	MEI7724864.1	1898104	g21249	i0	46.8	0.592436974789916	47	22	59.2	2	94	234	125	168	MEI7724864.1 polysaccharide deacetylase family protein [Bacteroidota bacterium]	diamond	141	44.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
32111404	32111404	PRJNA938397_S_NODE_31238_length_197_cov_7.025000_g30997_i0	PRJNA938397	31238	197	7.025	13.83925	Bacteroidales bacterium	2030927	Bacteria	Bacteria	62	3.01e-9	NR	NLV52593.1	2030927	g30997	i0	74.3	4.29441624365482	35	9	53.3	0	192	88	324	358	NLV52593.1 galactose mutarotase [Bacteroidales bacterium]	diamond	846	62	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
32238232	32238232	PRJNA938397_S_NODE_39778_length_174_cov_4.883212_g39537_i0	PRJNA938397	39778	174	4.883212	8.49678888	Candidatus Hydrogenedentota bacterium	2030809	Bacteria	Bacteria	42.7	0.0146	NR	MCH7958893.1	2030809	g39537	i0	64	1.32758620689655	25	9	43.1	0	5	79	427	451	MCH7958893.1 protoporphyrinogen oxidase [Candidatus Hydrogenedentota bacterium]	diamond	231	42.7	1	Bacteria	FCB group	Pseudomonadati	Candidatus Hydrogenedentota					Candidatus Hydrogenedentota 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);;