metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA900999" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA900999" and tax_phylum = "Bacteroidota"

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
15273961	15273961	PRJNA900999_S_NODE_1892_length_280_cov_2.330677_g1836_i0	PRJNA900999	1892	280	2.330677	6.5258956	Emticicia soli	2027878	Bacteria	Bacteria	65.5	5.98e-11	NR	WP_340240531.1	2027878	g1836	i0	100	0.364285714285714	34	0	36.4	0	280	179	6	39	WP_340240531.1 hypothetical protein [Emticicia soli]	diamond	102	65.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Leadbetterellaceae	Emticicia	Emticicia soli
26929307	26929307	PRJNA900999_S_NODE_3742_length_219_cov_3.684211_g3686_i0	PRJNA900999	3742	219	3.684211	8.06842209	Adhaeribacter pallidiroseus	2072847	Bacteria	Bacteria	90.9	5.09e-21	NR	WP_115372044.1	2072847	g3686	i0	93.8	1.31506849315068	48	3	65.8	0	3	146	37	84	WP_115372044.1 chemotaxis protein CheW [Adhaeribacter pallidiroseus]	diamond	288	90.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Adhaeribacter	Adhaeribacter pallidiroseus
27087517	27087517	PRJNA900999_S_NODE_4622_length_202_cov_2.312139_g4566_i0	PRJNA900999	4622	202	2.312139	4.67052078	Hoylesella saccharolytica	633701	Bacteria	Bacteria	130	5.6e-37	NR	WP_025798762.1	633701	g4566	i0	97	0.995049504950495	67	2	99.5	0	202	2	53	119	WP_025798762.1 Dps family protein [Hoylesella saccharolytica]	diamond	201	130	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Hoylesella	Hoylesella saccharolytica
27529759	27529759	PRJNA900999_S_NODE_8223_length_161_cov_2.272727_g8167_i0	PRJNA900999	8223	161	2.272727	3.65909047	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	78.6	6.84e-16	NR	HWB23949.1	1869212	g8167	i0	78.7	0.875776397515528	47	10	87.6	0	160	20	207	253	HWB23949.1 hypothetical protein [Chitinophagaceae bacterium]	diamond	141	78.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
28382279	28382279	PRJNA900999_S_NODE_9546_length_152_cov_1.780488_g9490_i0	PRJNA900999	9546	152	1.780488	2.70634176	Bacteroidales bacterium	2030927	Bacteria	Bacteria	44.7	0.00224	NR	MDD4149040.1	2030927	g9490	i0	44.9	1.55921052631579	49	26	94.7	1	1	144	131	179	MDD4149040.1 hypothetical protein [Bacteroidales bacterium]	diamond	237	44.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
28413973	28413973	PRJNA900999_S_NODE_8646_length_158_cov_2.217054_g8590_i0	PRJNA900999	8646	158	2.217054	3.50294532	Hoylesella loescheii	840	Bacteria	Bacteria	111	1.12e-29	NR	WP_304060721.1	840	g8590	i0	100	0.987341772151899	52	0	98.7	0	1	156	36	87	WP_304060721.1 SsrA-binding protein SmpB [Hoylesella loescheii]	diamond	156	111	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Hoylesella	Hoylesella loescheii
28824034	28824034	PRJNA900999_S_NODE_5508_length_189_cov_1.625000_g5452_i0	PRJNA900999	5508	189	1.625	3.07125	Paludibacter sp.	1898105	Bacteria	Bacteria	77.4	3.51e-17	NR	MBP6662603.1	1898105	g5452	i0	98.1	0.841269841269841	53	1	84.1	0	178	20	1	53	MBP6662603.1 hypothetical protein [Paludibacter sp.]	diamond	159	77.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Paludibacteraceae	Paludibacter	Paludibacter sp.
29077070	29077070	PRJNA900999_S_NODE_4448_length_205_cov_1.829545_g4392_i0	PRJNA900999	4448	205	1.829545	3.75056725	Crocinitomicaceae bacterium	2026728	Bacteria	Bacteria	96.7	1.4500000000000002e-21	NR	MDC1403573.1	2026728	g4392	i0	98	5.70731707317073	49	1	71.7	0	2	148	387	435	MDC1403573.1 UDP-N-acetylglucosamine 1-carboxyvinyltransferase [Crocinitomicaceae bacterium]	diamond	1170	96.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae		Crocinitomicaceae bacterium
29400239	29400239	PRJNA900999_S_NODE_7609_length_166_cov_2.912409_g7553_i0	PRJNA900999	7609	166	2.912409	4.83459894	Chitinophagaceae	563835	Bacteria	Bacteria	96.3	1.85e-21	NR	MFT4202772.1	1869212	g7553	i0	92.3	15.0361445783133	52	4	94	0	2	157	125	176	MFT4202772.1 type I DNA topoisomerase [Chitinophagaceae bacterium]	diamond	2496	96.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
29771377	29771377	PRJNA900999_S_NODE_4951_length_196_cov_7.011976_g4895_i0	PRJNA900999	4951	196	7.011976	13.74347296	Aquimarina sp. ERC-38	2949996	Bacteria	Bacteria	41.6	0.0489	NR	WP_265771865.1	2949996	g4895	i0	33.3	0.826530612244898	54	25	73.5	2	161	18	123	171	WP_265771865.1 hypothetical protein [Aquimarina sp. ERC-38]	diamond	162	41.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Aquimarina	Aquimarina sp. ERC-38
31793975	31793975	PRJNA900999_S_NODE_3457_length_226_cov_2.538071_g3401_i0	PRJNA900999	3457	226	2.538071	5.73604046	Bacteroidota bacterium	1898104	Bacteria	Bacteria	105	7.97e-26	NR	MCA0426190.1	1898104	g3401	i0	74.3	3.86283185840708	74	19	98.2	0	3	224	78	151	MCA0426190.1 MotA/TolQ/ExbB proton channel family protein [Bacteroidota bacterium]	diamond	873	105	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
31825675	31825675	PRJNA900999_S_NODE_4917_length_197_cov_3.690476_g4861_i0	PRJNA900999	4917	197	3.690476	7.27023772	Hoylesella loescheii	840	Bacteria	Bacteria	105	3.66e-27	NR	WP_304060721.1	840	g4861	i0	94.8	0.883248730964467	58	3	88.3	0	197	24	84	141	WP_304060721.1 SsrA-binding protein SmpB [Hoylesella loescheii]	diamond	174	105	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Hoylesella	Hoylesella loescheii

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