metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA624323" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA624323" 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	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
13350561	13350561	PRJNA624323_P_NODE_8131_length_250_cov_0.870056_g7969_i0	PRJNA624323	8131	250	0.870056	2.17514	Prevotellaceae bacterium	2049047	Bacteria	Bacteria	159	3.47e-48	NR	MBF1070171.1	2049047	g7969	i0	97.6	0.996	83	2	99.6	250	2	58	140	MBF1070171.1 MaoC family dehydratase [Prevotellaceae bacterium]	diamond	249	159	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae		Prevotellaceae bacterium
19001621	19001621	PRJNA624323_P_NODE_8915_length_245_cov_0.895349_g8753_i0	PRJNA624323	8915	245	0.895349	2.19360505	Taishania pollutisoli	2766479	Bacteria	Bacteria	157	9.9e-47	NR	WP_163490935.1	2766479	g8753	i0	98.8	0.991836734693878	81	1	99.2	2	244	12	92	WP_163490935.1 50S ribosomal protein L6 [Taishania pollutisoli]	diamond	243	157	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Taishania	Taishania pollutisoli
27712781	27712781	PRJNA624323_P_NODE_9224_length_243_cov_0.905882_g9062_i0	PRJNA624323	9224	243	0.905882	2.20129326	Chryseosolibacter sp.	2963351	Bacteria	Bacteria	124	7.54e-32	NR	HEU5145716.1	2963351	g9062	i0	76.3	1.97530864197531	80	19	98.8	3	242	112	191	HEU5145716.1 MFS transporter [Chryseosolibacter sp.]	diamond	480	124	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Chryseotaleaceae	Chryseosolibacter	Chryseosolibacter sp.
28817153	28817153	PRJNA624323_P_NODE_6108_length_291_cov_1.192661_g5946_i0	PRJNA624323	6108	291	1.192661	3.47064351	Flavobacteriales bacterium	2021391	Bacteria	Bacteria	43.9	0.0196	NR	QQR85409.1	2021391	g5946	i0	37.1	0.639175257731959	62	39	63.9	27	212	65	126	QQR85409.1 MAG: hypothetical protein IPJ76_12410 [Flavobacteriales bacterium]	diamond	186	43.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
28893277	28893277	PRJNA624323_P_NODE_8928_length_245_cov_0.895349_g8766_i0	PRJNA624323	8928	245	0.895349	2.19360505	root	1	Root_unresolved	Root_unresolved	81.3	1.02e-15	NR	WP_002705279.1	1027	g8766	i0	53.2	7.40816326530612	77	36	94.3	241	11	1	77	WP_002705279.1 acyl-CoA carboxylase subunit beta [Microscilla marina]	diamond	1815	82	0.991463414634146	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Microscillaceae	Microscilla	Microscilla marina
29196496	29196496	PRJNA624323_P_NODE_8949_length_245_cov_0.895349_g8787_i0	PRJNA624323	8949	245	0.895349	2.19360505	Segetibacter koreensis	398037	Bacteria	Bacteria	43.9	0.0151	NR	WP_018613890.1	398037	g8787	i0	41.2	0.624489795918367	51	30	62.4	167	15	27	77	WP_018613890.1 phosphatidylglycerol lysyltransferase domain-containing protein [Segetibacter koreensis]	diamond	153	43.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Segetibacter	Segetibacter koreensis
30175256	30175256	PRJNA624323_P_NODE_8792_length_246_cov_0.884393_g8630_i0	PRJNA624323	8792	246	0.884393	2.17560678	Hymenobacter pini	2880879	Bacteria	Bacteria	138	2.97e-38	NR	WP_226270064.1	2880879	g8630	i0	90.1	0.98780487804878	81	8	98.8	244	2	89	169	WP_226270064.1 ferritin-like domain-containing protein [Hymenobacter pini]	diamond	243	138	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter pini
30870414	30870414	PRJNA624323_P_NODE_8294_length_249_cov_0.875000_g8132_i0	PRJNA624323	8294	249	0.875	2.17875	Cyclobacteriaceae bacterium	2099675	Bacteria	Bacteria	152	1.6e-44	NR	MBX2942725.1	2099675	g8132	i0	95.1	0.987951807228916	82	4	98.8	247	2	63	144	MBX2942725.1 conjugal transfer protein TraI [Cyclobacteriaceae bacterium]	diamond	246	152	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae		Cyclobacteriaceae bacterium
30965394	30965394	PRJNA624323_P_NODE_7994_length_251_cov_0.865169_g7832_i0	PRJNA624323	7994	251	0.865169	2.17157419	Flavobacterium sp. H122	2529860	Bacteria	Bacteria	157	3.41e-46	NR	WP_136667468.1	2529860	g7832	i0	88	0.99203187250996006	83	10	99.2	251	3	19	101	WP_136667468.1 hypothetical protein [Flavobacterium sp. H122]	diamond	249	157	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp. H122
32830248	32830248	PRJNA624323_P_NODE_8420_length_248_cov_0.880000_g8258_i0	PRJNA624323	8420	248	0.88	2.1824	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	122	3.8399999999999998e-31	NR	MFN2456759.1	1869212	g8258	i0	70.7	1.95967741935484	82	24	99.2	3	248	91	172	MFN2456759.1 chromate transporter [Chitinophagaceae bacterium]	diamond	486	122	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae 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);;