metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA401346" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA401346" 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
10618276	10618276	PRJNA401346_P_NODE_8109_length_203_cov_0.901408_g8088_i0	PRJNA401346	8109	203	0.901408	1.82985824	Bacteroidota	976	Bacteria	Bacteria	129	5.42e-36	NR	WP_166552624.1	976	g8088	i0	100	6.10344827586207	59	0	87.2	0	2	178	119	177	WP_166552624.1 MULTISPECIES: superoxide dismutase [Bacteroidota]	diamond	1239	129	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota
27201653	27201653	PRJNA401346_P_NODE_942_length_480_cov_1.904535_g921_i0	PRJNA401346	942	480	1.904535	9.141768	Flavobacteriia bacterium	2044941	Bacteria	Bacteria	174	1.62e-50	NR	NBO60432.1	2044941	g921	i0	56.1	16.45625	155	64	94.4	3	4	456	164	318	NBO60432.1 hypothetical protein [Flavobacteriia bacterium]	diamond	7899	174	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia				Flavobacteriia bacterium
27739174	27739174	PRJNA401346_P_NODE_3484_length_279_cov_1.761468_g3463_i0	PRJNA401346	3484	279	1.761468	4.91449572	Flavobacterium cerinum	2502784	Bacteria	Bacteria	57.8	1.09e-8	NR	WP_256550751.1	2502784	g3463	i0	90.3	0.333333333333333	31	3	33.3	0	2	94	2	32	WP_256550751.1 hypothetical protein [Flavobacterium cerinum]	diamond	93	57.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium cerinum
28275451	28275451	PRJNA401346_P_NODE_2926_length_300_cov_0.928870_g2905_i0	PRJNA401346	2926	300	0.92887	2.78661	Prevotella sp.	59823	Bacteria	Bacteria	100	1.02e-24	NR	MBO4719996.1	59823	g2905	i0	65.2	0.66	66	23	66	0	248	51	71	136	MBO4719996.1 hypothetical protein [Prevotella sp.]	diamond	198	100	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp.
29412143	29412143	PRJNA401346_P_NODE_5609_length_223_cov_1.771605_g5588_i0	PRJNA401346	5609	223	1.771605	3.95067915	Cellulophaga sp. BC115SP	2683263	Bacteria	Bacteria	57	6.09e-8	NR	WP_166552178.1	2683263	g5588	i0	97.1	0.457399103139013	34	1	45.7	0	120	221	86	119	WP_166552178.1 hypothetical protein [Cellulophaga sp. BC115SP]	diamond	102	57	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Cellulophaga	Cellulophaga sp. BC115SP
29538447	29538447	PRJNA401346_P_NODE_1570_length_386_cov_1.378462_g1549_i0	PRJNA401346	1570	386	1.378462	5.32086332	Bacteroides sp.	29523	Bacteria	Bacteria	63.9	7.09e-9	NR	MBQ8501021.1	29523	g1549	i0	41.4	1.0880829015544	70	37	54.4	1	1	210	685	750	MBQ8501021.1 hypothetical protein [Bacteroides sp.]	diamond	420	63.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides sp.
29917602	29917602	PRJNA401346_P_NODE_4631_length_247_cov_2.064516_g4610_i0	PRJNA401346	4631	247	2.064516	5.09935452	Bacteroidia bacterium	2044936	Bacteria	Bacteria	111	9.35e-29	NR	TXH57036.1	2044936	g4610	i0	66.3	1.0080971659919	83	27	99.6	1	246	1	68	150	TXH57036.1 MAG: pyridoxal-phosphate dependent enzyme [Bacteroidia bacterium]	diamond	249	111	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
30138236	30138236	PRJNA401346_P_NODE_5792_length_219_cov_1.215190_g5771_i0	PRJNA401346	5792	219	1.21519	2.6612661	Bacteroidota bacterium	1898104	Bacteria	Bacteria	47.4	6.48e-4	NR	MEM9819696.1	1898104	g5771	i0	47.9	2.94520547945205	71	24	90.4	4	203	6	1169	1231	MEM9819696.1 gliding motility-associated C-terminal domain-containing protein [Bacteroidota bacterium]	diamond	645	47.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30328722	30328722	PRJNA401346_P_NODE_4512_length_250_cov_1.666667_g4491_i0	PRJNA401346	4512	250	1.666667	4.1666675	Bacteroidia bacterium	2044936	Bacteria	Bacteria	140	1.22e-40	NR	MBL7936892.1	2044936	g4491	i0	98.6	0.876	73	1	87.6	0	249	31	88	160	MBL7936892.1 50S ribosomal protein L13 [Bacteroidia bacterium]	diamond	219	140	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
30454912	30454912	PRJNA401346_P_NODE_7253_length_206_cov_0.882759_g7232_i0	PRJNA401346	7253	206	0.882759	1.81848354	Bacteroidales bacterium	2030927	Bacteria	Bacteria	87.8	1.18e-18	NR	MBO5877806.1	2030927	g7232	i0	60.3	1.98058252427184	68	27	99	0	206	3	150	217	MBO5877806.1 replication initiation protein [Bacteroidales bacterium]	diamond	408	87.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
30517766	30517766	PRJNA401346_P_NODE_3193_length_289_cov_2.245614_g3172_i0	PRJNA401346	3193	289	2.2456140000000002	6.48982446	Flammeovirgaceae bacterium	2026740	Bacteria	Bacteria	148	2.49e-44	NR	MFM7855543.1	2026740	g3172	i0	79.3	0.85121107266436	82	17	85.1	0	283	38	1	82	MFM7855543.1 50S ribosomal protein L37e [Flammeovirgaceae bacterium]	diamond	246	148	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae		Flammeovirgaceae bacterium
30707262	30707262	PRJNA401346_P_NODE_1154_length_438_cov_1.933687_g1133_i0	PRJNA401346	1154	438	1.933687	8.46954906	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	128	1.19e-35	NR	MCC6447635.1	1869212	g1133	i0	72.8	0.554794520547945	81	22	55.5	0	245	3	1	81	MCC6447635.1 hypothetical protein [Chitinophagaceae bacterium]	diamond	243	128	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
31149242	31149242	PRJNA401346_P_NODE_7055_length_207_cov_0.876712_g7034_i0	PRJNA401346	7055	207	0.876712	1.81479384	Chryseobacterium	59732	Bacteria	Bacteria	129	1.91e-37	NR	WP_116097270.1	59732	g7034	i0	100	0.985507246376812	68	0	98.6	0	2	205	2	69	WP_116097270.1 MULTISPECIES: hypothetical protein [Chryseobacterium]	diamond	204	129	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium
31655499	31655499	PRJNA401346_P_NODE_797_length_516_cov_1.184615_g776_i0	PRJNA401346	797	516	1.184615	6.1126134	Flammeovirgaceae bacterium	2026740	Bacteria	Bacteria	145	9.189999999999998e-42	NR	MFM7854286.1	2026740	g776	i0	81.3	0.465116279069767	80	15	46.5	0	2	241	11	90	MFM7854286.1 WD40 repeat domain-containing protein [Flammeovirgaceae bacterium]	diamond	240	145	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae		Flammeovirgaceae bacterium
32066843	32066843	PRJNA401346_P_NODE_5858_length_217_cov_1.814103_g5837_i0	PRJNA401346	5858	217	1.814103	3.93660351	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	47	4.43e-4	NR	HRI35345.1	2202734	g5837	i0	45.8	1.70046082949309	48	24	65	2	214	74	31	77	HRI35345.1 hypothetical protein [Saprospiraceae bacterium]	diamond	369	47	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
32778568	32778568	PRJNA401346_P_NODE_4400_length_254_cov_0.994819_g4379_i0	PRJNA401346	4400	254	0.994819	2.52684026	Flavobacteriales	200644	Bacteria	Bacteria	104	3.16e-24	NR	WP_259130942.1	687846	g4379	i0	58.3	16.7716535433071	84	35	99.2	0	252	1	107	190	WP_259130942.1 antibiotic biosynthesis monooxygenase [Chryseobacterium ginsenosidimutans]	diamond	4260	105	0.990476190476191	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Chryseobacterium	Chryseobacterium ginsenosidimutans

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);;