metadata: contig_metadata: 33 rows where analysis = "diamond", bioproject = "PRJNA896973" and tax

33 rows where analysis = "diamond", bioproject = "PRJNA896973" 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
873198	873198	PRJNA896973_P_NODE_21701_length_251_cov_0.865169_g21607_i0	PRJNA896973	21701	251	0.865169	2.17157419	Segetibacter sp. 3557_3	2547429	Bacteria	Bacteria	144	1.67e-38	NR	WP_133267512.1	2547429	g21607	i0	83.1	0.99203187250996006	83	14	99.2	0	250	2	468	550	WP_133267512.1 phospho-sugar mutase [Segetibacter sp. 3557_3]	diamond	249	144	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Segetibacter	Segetibacter sp. 3557_3
2148611	2148611	PRJNA896973_P_NODE_26722_length_243_cov_0.905882_g26628_i0	PRJNA896973	26722	243	0.905882	2.20129326	Ferruginibacter sp.	1940288	Bacteria	Bacteria	133	1.78e-35	NR	MEO6540209.1	1940288	g26628	i0	82.3	0.975308641975309	79	14	97.5	0	238	2	164	242	MEO6540209.1 histidine kinase [Ferruginibacter sp.]	diamond	237	133	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter sp.
3424005	3424005	PRJNA896973_P_NODE_23723_length_248_cov_0.880000_g23629_i0	PRJNA896973	23723	248	0.88	2.1824	Prevotella sp. CAG:891	1262937	Bacteria	Bacteria	67.4	8.09e-11	NR	CDE86668.1	1262937	g23629	i0	100	0.435483870967742	36	0	43.5	0	248	141	596	631	CDE86668.1 inner membrane protein translocase component YidC [Prevotella sp. CAG:891]	diamond	108	67.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. CAG:891
19999794	19999794	PRJNA896973_P_NODE_22956_length_249_cov_0.875000_g22862_i0	PRJNA896973	22956	249	0.875	2.17875	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	140	9.1e-37	NR	RYZ56850.1	1869212	g22862	i0	90.8	13.6024096385542	76	7	91.6	0	230	3	1	76	RYZ56850.1 MAG: methylmalonyl-CoA mutase, partial [Chitinophagaceae bacterium]	diamond	3387	140	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
21275206	21275206	PRJNA896973_P_NODE_25577_length_245_cov_0.895349_g25483_i0	PRJNA896973	25577	245	0.895349	2.19360505	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	62.4	5.45e-10	NR	MBL0136188.1	1869212	g25483	i0	87.5	0.391836734693878	32	4	39.2	0	148	243	1	32	MBL0136188.1 hypothetical protein [Chitinophagaceae bacterium]	diamond	96	62.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
26644030	26644030	PRJNA896973_P_NODE_25961_length_244_cov_0.900585_g25867_i0	PRJNA896973	25961	244	0.900585	2.1974274	Sphingobacteriales bacterium	2044944	Bacteria	Bacteria	168	1.46e-50	NR	MBN8855087.1	2044944	g25867	i0	100	0.995901639344262	81	0	99.6	0	243	1	59	139	MBN8855087.1 hypothetical protein [Sphingobacteriales bacterium]	diamond	243	168	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales			Sphingobacteriales bacterium
26675552	26675552	PRJNA896973_P_NODE_25061_length_246_cov_0.890173_g24967_i0	PRJNA896973	25061	246	0.890173	2.18982558	Spirosoma endophyticum	662367	Bacteria	Bacteria	65.9	1.28e-11	NR	WP_093824866.1	662367	g24967	i0	86.8	0.463414634146341	38	5	46.3	0	116	3	1	38	WP_093824866.1 T9SS type A sorting domain-containing protein [Spirosoma endophyticum]	diamond	114	65.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae	Spirosoma	Spirosoma endophyticum
26770881	26770881	PRJNA896973_P_NODE_22961_length_249_cov_0.875000_g22867_i0	PRJNA896973	22961	249	0.875	2.17875	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	154	7.79e-45	NR	MBK8494957.1	1869212	g22867	i0	93.9	0.987951807228916	82	4	98.8	1	2	247	5	85	MBK8494957.1 gliding motility protein GldL [Chitinophagaceae bacterium]	diamond	246	154	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
27348081	27348081	PRJNA896973_P_NODE_27303_length_242_cov_0.911243_g27209_i0	PRJNA896973	27303	242	0.911243	2.20520806	Cytophagales	768507	Bacteria	Bacteria	138	1.02e-35	NR	HYG20574.1	2066019	g27209	i0	77.5	3.96694214876033	80	18	99.2	0	242	3	619	698	HYG20574.1 SusC/RagA family TonB-linked outer membrane protein [Ohtaekwangia sp.]	diamond	960	138	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Ohtaekwangia	Ohtaekwangia sp.
27529638	27529638	PRJNA896973_P_NODE_24743_length_246_cov_0.890173_g24649_i0	PRJNA896973	24743	246	0.890173	2.18982558	Hymenobacter aranciens	3063996	Bacteria	Bacteria	54.7	7.18e-7	NR	WP_305006246.1	3063996	g24649	i0	80.6	0.378048780487805	31	6	37.8	0	1	93	134	164	WP_305006246.1 YdeI/OmpD-associated family protein [Hymenobacter aranciens]	diamond	93	54.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter aranciens
28003502	28003502	PRJNA896973_P_NODE_15505_length_288_cov_1.106977_g15411_i0	PRJNA896973	15505	288	1.106977	3.18809376	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	91.3	2.72e-19	NR	MBL7709642.1	1869212	g15411	i0	93.9	0.510416666666667	49	3	51	0	140	286	1	49	MBL7709642.1 hypothetical protein [Chitinophagaceae bacterium]	diamond	147	91.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
28224105	28224105	PRJNA896973_P_NODE_25946_length_244_cov_0.900585_g25852_i0	PRJNA896973	25946	244	0.900585	2.1974274	Chitinophagaceae bacterium IBVUCB1	1985173	Bacteria	Bacteria	152	5.72e-42	NR	OSZ79044.1	1985173	g25852	i0	87.7	5.91393442622951	81	10	99.6	0	2	244	294	374	OSZ79044.1 DNA methylase [Chitinophagaceae bacterium IBVUCB1]	diamond	1443	152	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium IBVUCB1
28382175	28382175	PRJNA896973_S_NODE_1326_length_329_cov_2.265625_g1312_i0	PRJNA896973	1326	329	2.265625	7.45390625	Taishania pollutisoli	2766479	Bacteria	Bacteria	110	1.69e-25	NR	WP_216713762.1	2766479	g1312	i0	96.2	0.474164133738602	52	2	47.4	0	157	2	606	657	WP_216713762.1 hypothetical protein [Taishania pollutisoli]	diamond	156	110	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Crocinitomicaceae	Taishania	Taishania pollutisoli
28508517	28508517	PRJNA896973_S_NODE_707_length_439_cov_2.221311_g693_i0	PRJNA896973	707	439	2.221311	9.75155529	Flavobacterium lacus	1353778	Bacteria	Bacteria	197	1.52e-56	NR	WP_112084634.1	1353778	g693	i0	72	0.806378132118451	118	33	80.6	0	23	376	505	622	WP_112084634.1 SprT-like domain-containing protein [Flavobacterium lacus]	diamond	354	197	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium lacus
28635026	28635026	PRJNA896973_P_NODE_26027_length_244_cov_0.900585_g25933_i0	PRJNA896973	26027	244	0.900585	2.1974274	Prevotella sp. 885	2022527	Bacteria	Bacteria	169	1.6999999999999998e-48	NR	WP_094880736.1	2022527	g25933	i0	100	0.995901639344262	81	0	99.6	0	243	1	301	381	WP_094880736.1 DUF3868 domain-containing protein [Prevotella sp. 885]	diamond	243	169	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. 885
28982298	28982298	PRJNA896973_P_NODE_25088_length_246_cov_0.878613_g24994_i0	PRJNA896973	25088	246	0.878613	2.16138798	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	157	2.18e-44	NR	MBY0478305.1	1869212	g24994	i0	100	1	82	0	100	0	1	246	18	99	MBY0478305.1 molybdopterin molybdotransferase MoeA [Chitinophagaceae bacterium]	diamond	246	157	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
29140180	29140180	PRJNA896973_P_NODE_25229_length_245_cov_1.546512_g25135_i0	PRJNA896973	25229	245	1.546512	3.7889544	Ferruginibacter sp.	1940288	Bacteria	Bacteria	120	1.74e-29	NR	MBP6287066.1	1940288	g25135	i0	79.7	1.93469387755102	79	16	96.7	0	7	243	1147	1225	MBP6287066.1 hypothetical protein [Ferruginibacter sp.]	diamond	474	120	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter sp.
29171653	29171653	PRJNA896973_P_NODE_26909_length_243_cov_0.905882_g26815_i0	PRJNA896973	26909	243	0.905882	2.20129326	Chryseolinea sp.	2059303	Bacteria	Bacteria	172	3.59e-53	NR	HMG92944.1	2059303	g26815	i0	100	1.97530864197531	80	0	98.8	0	3	242	80	159	HMG92944.1 hypothetical protein [Chryseolinea sp.]	diamond	480	172	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Fulvivirgaceae	Chryseolinea	Chryseolinea sp.
30094847	30094847	PRJNA896973_P_NODE_18512_length_268_cov_1.579487_g18418_i0	PRJNA896973	18512	268	1.579487	4.23302516	Lacibacter	649461	Bacteria	Bacteria	95.9	3e-21	NR	MFN8265437.1	1869212	g18418	i0	85.7	1.6455223880597	49	7	54.9	0	149	3	7	55	MFN8265437.1 hydrogenase expression/formation protein HypE [Chitinophagaceae bacterium]	diamond	441	96.7	0.991726990692865	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
30118776	30118776	PRJNA896973_P_NODE_28012_length_241_cov_0.916667_g27918_i0	PRJNA896973	28012	241	0.916667	2.20916747	Ferruginibacter sp.	1940288	Bacteria	Bacteria	115	1.28e-27	NR	MFN8305891.1	1940288	g27918	i0	73.8	0.995850622406639	80	21	99.6	0	2	241	349	428	MFN8305891.1 hypothetical protein [Ferruginibacter sp.]	diamond	240	115	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter sp.
30182011	30182011	PRJNA896973_P_NODE_21592_length_251_cov_1.550562_g21498_i0	PRJNA896973	21592	251	1.550562	3.89191062	Lacibacter sp. MH-61	1915409	Bacteria	Bacteria	150	3.24e-44	NR	WP_407524758.1	3020883	g21498	i0	86.6	0.9800796812749	82	11	98	0	248	3	82	163	WP_407524758.1 DUF4199 domain-containing protein [Lacibacter sp. MH-610]	diamond	246	150	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter sp. MH-610
30182012	30182012	PRJNA896973_P_NODE_25812_length_244_cov_1.789474_g25718_i0	PRJNA896973	25812	244	1.789474	4.36631656	Bacteroidota bacterium	1898104	Bacteria	Bacteria	123	5.8e-32	NR	MBI1768487.1	1898104	g25718	i0	71.6	2.96311475409836	81	23	99.6	0	244	2	50	130	MBI1768487.1 NAD-dependent epimerase [Bacteroidota bacterium]	diamond	723	123	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
30308967	30308967	PRJNA896973_P_NODE_22532_length_250_cov_0.870056_g22438_i0	PRJNA896973	22532	250	0.870056	2.17514	Ferruginibacter sp.	1940288	Bacteria	Bacteria	168	5.58e-49	NR	MEO6254294.1	1940288	g22438	i0	93.9	3.936	82	5	98.4	0	248	3	62	143	MEO6254294.1 glucosaminidase domain-containing protein [Ferruginibacter sp.]	diamond	984	168	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter sp.
30435161	30435161	PRJNA896973_P_NODE_18873_length_266_cov_1.398964_g18779_i0	PRJNA896973	18873	266	1.398964	3.72124424	Hymenobacter lapidiphilus	2608003	Bacteria	Bacteria	57	4.99e-8	NR	WP_176907743.1	2608003	g18779	i0	35.1	0.868421052631579	77	49	86.8	1	31	261	9	84	WP_176907743.1 hypothetical protein [Hymenobacter lapidiphilus]	diamond	231	57	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Hymenobacter	Hymenobacter lapidiphilus
30655958	30655958	PRJNA896973_P_NODE_21833_length_251_cov_0.865169_g21739_i0	PRJNA896973	21833	251	0.865169	2.17157419	Weeksellaceae bacterium	2823802	Bacteria	Bacteria	100	1.1200000000000001e-22	NR	MDD3458111.1	2823802	g21739	i0	61.4	0.99203187250996006	83	32	99.2	0	251	3	314	396	MDD3458111.1 ATP-binding protein [Weeksellaceae bacterium]	diamond	249	100	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae		Weeksellaceae bacterium
30853274	30853274	PRJNA896973_P_NODE_25454_length_245_cov_0.895349_g25360_i0	PRJNA896973	25454	245	0.895349	2.19360505	Ferruginibacter	1004303	Bacteria	Bacteria	155	1.6299999999999999e-43	NR	MBK8521833.1	1869212	g25360	i0	88.9	6.94285714285714	81	9	99.2	0	244	2	304	384	MBK8521833.1 anthranilate synthase component I family protein [Chitinophagaceae bacterium]	diamond	1701	155	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
31066970	31066970	PRJNA896973_P_NODE_24535_length_246_cov_1.861272_g24441_i0	PRJNA896973	24535	246	1.861272	4.57872912	Ferruginibacter sp.	1940288	Bacteria	Bacteria	72	1.94e-12	NR	MEP7164059.1	1940288	g24441	i0	44.4	0.98780487804878	81	45	98.8	0	243	1	587	667	MEP7164059.1 PAS domain S-box protein [Ferruginibacter sp.]	diamond	243	72	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter sp.
31129622	31129622	PRJNA896973_P_NODE_23035_length_249_cov_0.875000_g22941_i0	PRJNA896973	23035	249	0.875	2.17875	Bacteroides uniformis	820	Bacteria	Bacteria	40.8	0.0305	NR	WP_208081283.1	820	g22941	i0	56.7	0.36144578313253	30	13	36.1	0	130	219	8	37	WP_208081283.1 hypothetical protein, partial [Bacteroides uniformis]	diamond	90	40.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides uniformis
31192788	31192788	PRJNA896973_P_NODE_26875_length_243_cov_0.905882_g26781_i0	PRJNA896973	26875	243	0.905882	2.20129326	Cyclobacteriaceae bacterium	2099675	Bacteria	Bacteria	112	1.9400000000000003e-27	NR	MEQ9439094.1	2099675	g26781	i0	68.4	0.975308641975309	79	25	97.5	0	242	6	124	202	MEQ9439094.1 hypothetical protein [Cyclobacteriaceae bacterium]	diamond	237	112	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae		Cyclobacteriaceae bacterium
31793881	31793881	PRJNA896973_S_NODE_1697_length_299_cov_1.818584_g1683_i0	PRJNA896973	1697	299	1.818584	5.43756616	Elizabethkingia meningoseptica	238	Bacteria	Bacteria	55.5	2.34e-6	NR	WP_275140391.1	238	g1683	i0	62.5	0.40133779264214	40	15	40.1	0	182	63	301	340	WP_275140391.1 PBSX family phage terminase large subunit [Elizabethkingia meningoseptica]	diamond	120	55.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia meningoseptica
32110526	32110526	PRJNA896973_S_NODE_2138_length_271_cov_0.782828_g2124_i0	PRJNA896973	2138	271	0.782828	2.12146388	Bacteroidia bacterium	2044936	Bacteria	Bacteria	169	1.02e-49	NR	GHT29907.1	2044936	g2124	i0	96.4	0.929889298892989	84	3	93	0	269	18	256	339	GHT29907.1 hypothetical protein FACS189432_09150 [Bacteroidia bacterium]	diamond	252	169	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia				Bacteroidia bacterium
32371484	32371484	PRJNA896973_P_NODE_8299_length_373_cov_1.026667_g8205_i0	PRJNA896973	8299	373	1.026667	3.82946791	Ferruginibacter	1004303	Bacteria	Bacteria	141	8.699999999999998e-39	NR	MBK6379780.1	1869212	g8205	i0	61.5	1.96246648793566	122	46	98.1	1	371	6	148	268	MBK6379780.1 tetratricopeptide repeat protein [Chitinophagaceae bacterium]	diamond	732	141	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
32773830	32773830	PRJNA896973_S_NODE_960_length_376_cov_1.930693_g946_i0	PRJNA896973	960	376	1.930693	7.25940568	Cyclobacteriaceae bacterium	2099675	Bacteria	Bacteria	93.2	1.16e-19	NR	HRI80142.1	2099675	g946	i0	44.5	1.93085106382979	119	61	93.4	3	375	25	107	222	HRI80142.1 NHL repeat-containing protein [Cyclobacteriaceae bacterium]	diamond	726	93.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cyclobacteriaceae		Cyclobacteriaceae 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);;