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

33 rows where analysis = "diamond", bioproject = "PRJNA902515" 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
3431925	3431925	PRJNA902515_P_NODE_14883_length_245_cov_0.906977_g14860_i0	PRJNA902515	14883	245	0.906977	2.22209365	Bacteroides	816	Bacteria	Bacteria	158	2.74e-46	NR	CUP40648.1	820	g14860	i0	100	1.98367346938776	81	0	99.2	0	2	244	49	129	CUP40648.1 signal peptidase II . Aspartic peptidase. MEROPS family A08 [Bacteroides uniformis]	diamond	486	158	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides uniformis
3431934	3431934	PRJNA902515_P_NODE_15363_length_244_cov_0.906433_g15340_i0	PRJNA902515	15363	244	0.906433	2.21169652	Bacteria	2	Bacteria	Bacteria	142	2.1e-37	NR	MFN7602529.1	1898104	g15340	i0	86.4	17.9262295081967	81	11	99.6	0	1	243	28	108	MFN7602529.1 ATP-binding cassette domain-containing protein [Bacteroidota bacterium]	diamond	4374	142	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
4709822	4709822	PRJNA902515_P_NODE_15244_length_244_cov_0.912281_g15221_i0	PRJNA902515	15244	244	0.912281	2.22596564	Muribaculaceae bacterium	2498093	Bacteria	Bacteria	153	1.08e-43	NR	MFR7512257.1	2498093	g15221	i0	100	0.848360655737705	69	0	84.8	0	243	37	259	327	MFR7512257.1 RHS repeat-associated core domain-containing protein [Muribaculaceae bacterium]	diamond	207	153	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Muribaculaceae		Muribaculaceae bacterium
5984503	5984503	PRJNA902515_P_NODE_15105_length_244_cov_0.912281_g15082_i0	PRJNA902515	15105	244	0.912281	2.22596564	Muribaculaceae bacterium	2498093	Bacteria	Bacteria	168	5.36e-51	NR	MFR7512270.1	2498093	g15082	i0	100	0.983606557377049	80	0	98.4	0	242	3	67	146	MFR7512270.1 aconitase family protein [Muribaculaceae bacterium]	diamond	240	168	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Muribaculaceae		Muribaculaceae bacterium
20007842	20007842	PRJNA902515_P_NODE_15056_length_244_cov_0.912281_g15033_i0	PRJNA902515	15056	244	0.912281	2.22596564	Phocaeicola plebeius	310297	Bacteria	Bacteria	167	1.81e-49	NR	WP_007560655.1	310297	g15033	i0	98.8	1.97950819672131	80	1	98.4	0	4	243	156	235	WP_007560655.1 amidohydrolase family protein [Phocaeicola plebeius]	diamond	483	167	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola plebeius
22558248	22558248	PRJNA902515_P_NODE_4498_length_361_cov_1.260417_g4475_i0	PRJNA902515	4498	361	1.260417	4.55010537	Lepagella muris	3032870	Bacteria	Bacteria	168	5.46e-51	NR	WP_123481328.1	3032870	g4475	i0	98.8	0.714681440443213	86	1	71.5	0	74	331	1	86	WP_123481328.1 hypothetical protein [Lepagella muris]	diamond	258	168	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Muribaculaceae	Lepagella	Lepagella muris
26738887	26738887	PRJNA902515_P_NODE_10801_length_256_cov_1.278689_g10778_i0	PRJNA902515	10801	256	1.278689	3.27344384	Bacteroides oleiciplenus	626931	Bacteria	Bacteria	169	1.75e-48	NR	WP_009131433.1	626931	g10778	i0	98.8	0.984375	84	1	98.4	0	3	254	341	424	WP_009131433.1 MBOAT family O-acyltransferase [Bacteroides oleiciplenus]	diamond	252	169	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides oleiciplenus
26738888	26738888	PRJNA902515_P_NODE_13081_length_249_cov_0.886364_g13058_i0	PRJNA902515	13081	249	0.886364	2.20704636	Lepagella muris	3032870	Bacteria	Bacteria	97.1	2.4300000000000003e-21	NR	WP_123483822.1	3032870	g13058	i0	81.3	0.771084337349398	64	12	77.1	0	247	56	3	66	WP_123483822.1 Fe-S cluster assembly protein SufB [Lepagella muris]	diamond	192	97.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Muribaculaceae	Lepagella	Lepagella muris
27024172	27024172	PRJNA902515_P_NODE_11182_length_253_cov_0.866667_g11159_i0	PRJNA902515	11182	253	0.866667	2.19266751	Prevotellaceae	171552	Bacteria	Bacteria	78.2	3.1e-15	NR	WP_089542934.1	171552	g11159	i0	74.5	2.41897233201581	51	13	60.5	0	15	167	169	219	WP_089542934.1 MULTISPECIES: LytR/AlgR family response regulator transcription factor [Prevotellaceae]	diamond	612	78.2	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae
27118814	27118814	PRJNA902515_P_NODE_12802_length_249_cov_0.886364_g12779_i0	PRJNA902515	12802	249	0.886364	2.20704636	Prevotella sp. CAG:386	1262925	Bacteria	Bacteria	155	2.2199999999999998e-43	NR	CDC25467.1	1262925	g12779	i0	98.8	0.987951807228916	82	1	98.8	0	2	247	208	289	CDC25467.1 putative membrane-associated zinc metalloprotease [Prevotella sp. CAG:386]	diamond	246	155	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. CAG:386
27435329	27435329	PRJNA902515_P_NODE_12583_length_250_cov_0.881356_g12560_i0	PRJNA902515	12583	250	0.881356	2.20339	Segatella copri	165179	Bacteria	Bacteria	179	1.99e-53	NR	WP_264964304.1	165179	g12560	i0	98.8	1.992	83	1	99.6	0	1	249	212	294	WP_264964304.1 hypothetical protein [Segatella copri]	diamond	498	179	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
27466801	27466801	PRJNA902515_P_NODE_11743_length_252_cov_0.871508_g11720_i0	PRJNA902515	11743	252	0.871508	2.19620016	Alistipes ihumii	1470347	Bacteria	Bacteria	176	7.73e-53	NR	WP_273364032.1	1470347	g11720	i0	100	0.988095238095238	83	0	98.8	0	2	250	31	113	WP_273364032.1 radical SAM protein [Alistipes ihumii]	diamond	249	176	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Alistipes	Alistipes ihumii
27656262	27656262	PRJNA902515_P_NODE_11964_length_251_cov_0.876404_g11941_i0	PRJNA902515	11964	251	0.876404	2.19977404	Alistipes sp.	1872444	Bacteria	Bacteria	169	9.869999999999998e-47	NR	WP_276722417.1	1872444	g11941	i0	100	5.95219123505976	83	0	99.2	0	250	2	432	514	WP_276722417.1 alpha-glucan family phosphorylase, partial [Alistipes sp.]	diamond	1494	169	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Alistipes	Alistipes sp.
28579453	28579453	PRJNA902515_P_NODE_14347_length_246_cov_0.901734_g14324_i0	PRJNA902515	14347	246	0.901734	2.21826564	Duncaniella	2518495	Bacteria	Bacteria	166	8.71e-51	NR	MDO4320189.1	2030927	g14324	i0	95.1	3.95121951219512	81	4	98.8	0	3	245	66	146	MDO4320189.1 pyridoxal-dependent decarboxylase [Bacteroidales bacterium]	diamond	972	166	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
28642638	28642638	PRJNA902515_P_NODE_11487_length_252_cov_0.871508_g11464_i0	PRJNA902515	11487	252	0.871508	2.19620016	Bacteroidaceae	815	Bacteria	Bacteria	168	2.31e-46	NR	WP_337650190.1	310297	g11464	i0	97.6	2	84	2	100	0	252	1	160	243	WP_337650190.1 glycoside hydrolase family 97 catalytic domain-containing protein [Phocaeicola plebeius]	diamond	504	169	0.994082840236686	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola plebeius
28792587	28792587	PRJNA902515_P_NODE_11127_length_253_cov_0.866667_g11104_i0	PRJNA902515	11127	253	0.866667	2.19266751	Puia sp.	2045100	Bacteria	Bacteria	151	2.3e-40	NR	HEY4290432.1	2045100	g11104	i0	88.1	1.99209486166008	84	10	99.6	0	253	2	147	230	HEY4290432.1 SusC/RagA family TonB-linked outer membrane protein [Puia sp.]	diamond	504	151	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Puia	Puia sp.
28918862	28918862	PRJNA902515_P_NODE_11128_length_253_cov_0.866667_g11105_i0	PRJNA902515	11128	253	0.866667	2.19266751	uncultured Prevotella sp.	159272	Bacteria	Bacteria	166	5.609999999999998e-47	NR	WP_302749541.1	159272	g11105	i0	98.8	0.99604743083004	84	1	99.6	0	253	2	137	220	WP_302749541.1 NAD(P)H-hydrate dehydratase [uncultured Prevotella sp.]	diamond	252	166	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	uncultured Prevotella sp.
28950847	28950847	PRJNA902515_P_NODE_14428_length_246_cov_0.901734_g14405_i0	PRJNA902515	14428	246	0.901734	2.21826564	Muribaculaceae bacterium	2498093	Bacteria	Bacteria	167	1.32e-49	NR	GFI14561.1	2498093	g14405	i0	98.8	0.98780487804878	81	1	98.8	0	2	244	43	123	GFI14561.1 lipid A biosynthesis lauroyltransferase [Muribaculaceae bacterium]	diamond	243	167	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Muribaculaceae		Muribaculaceae bacterium
29140310	29140310	PRJNA902515_P_NODE_13789_length_247_cov_0.896552_g13766_i0	PRJNA902515	13789	247	0.896552	2.21448344	Segatella copri	165179	Bacteria	Bacteria	119	6.82e-30	NR	WP_158463942.1	165179	g13766	i0	100	0.65587044534413	54	0	65.6	0	246	85	375	428	WP_158463942.1 M64 family metallopeptidase [Segatella copri]	diamond	162	119	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Segatella	Segatella copri
29392777	29392777	PRJNA902515_P_NODE_11989_length_251_cov_0.876404_g11966_i0	PRJNA902515	11989	251	0.876404	2.19977404	Bacteroidales bacterium	2030927	Bacteria	Bacteria	89	1.24e-18	NR	MBR5604234.1	2030927	g11966	i0	55.8	0.920318725099602	77	33	90.8	1	249	22	59	135	MBR5604234.1 cysteine desulfurase [Bacteroidales bacterium]	diamond	231	89	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
29392778	29392778	PRJNA902515_P_NODE_14909_length_245_cov_0.889535_g14886_i0	PRJNA902515	14909	245	0.889535	2.17936075	Phocaeicola coprocola	310298	Bacteria	Bacteria	177	2.16e-52	NR	WP_410523180.1	310298	g14886	i0	98.8	7.93469387755102	81	1	99.2	0	243	1	185	265	WP_410523180.1 glycoside hydrolase family 26 protein [Phocaeicola coprocola]	diamond	1944	177	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola coprocola
29455429	29455429	PRJNA902515_P_NODE_13750_length_247_cov_0.896552_g13727_i0	PRJNA902515	13750	247	0.896552	2.21448344	Bacteroidaceae bacterium	2212467	Bacteria	Bacteria	143	1.97e-37	NR	MBP3615249.1	2212467	g13727	i0	90.2	0.995951417004049	82	8	99.6	0	247	2	364	445	MBP3615249.1 ATP-binding protein [Bacteroidaceae bacterium]	diamond	246	143	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae		Bacteroidaceae bacterium
29873948	29873948	PRJNA902515_P_NODE_15251_length_244_cov_0.912281_g15228_i0	PRJNA902515	15251	244	0.912281	2.22596564	Alistipes	239759	Bacteria	Bacteria	97.4	2.61e-24	NR	MFR4026925.1	626932	g15228	i0	100	1.15573770491803	47	0	57.8	0	103	243	1	47	MFR4026925.1 hypothetical protein [Alistipes indistinctus]	diamond	282	97.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Rikenellaceae	Alistipes	Alistipes indistinctus
29873949	29873949	PRJNA902515_P_NODE_16111_length_242_cov_0.923077_g16088_i0	PRJNA902515	16111	242	0.923077	2.23384634	Vicingus	2058169	Bacteria	Bacteria	72.8	9.67e-13	NR	MBV6485471.1	2021391	g16088	i0	100	1.33884297520661	36	0	44.6	0	133	240	1	36	MBV6485471.1 hypothetical protein [Flavobacteriales bacterium]	diamond	324	72.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales			Flavobacteriales bacterium
29897986	29897986	PRJNA902515_P_NODE_12471_length_250_cov_0.881356_g12448_i0	PRJNA902515	12471	250	0.881356	2.20339	Phocaeicola	909656	Bacteria	Bacteria	167	1.56e-49	NR	WP_007561758.1	909656	g12448	i0	98.8	0.996	83	1	99.6	0	249	1	214	296	WP_007561758.1 MULTISPECIES: LysR family transcriptional regulator [Phocaeicola]	diamond	249	167	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola
29961032	29961032	PRJNA902515_P_NODE_15911_length_242_cov_0.923077_g15888_i0	PRJNA902515	15911	242	0.923077	2.23384634	Xylanibacter caecicola	2736294	Bacteria	Bacteria	97.4	8.1e-25	NR	WP_172345533.1	2736294	g15888	i0	92.5	0.65702479338843	53	4	65.7	0	59	217	1	53	WP_172345533.1 hypothetical protein [Xylanibacter caecicola]	diamond	159	97.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Xylanibacter	Xylanibacter caecicola
29992720	29992720	PRJNA902515_P_NODE_3631_length_392_cov_1.244514_g3608_i0	PRJNA902515	3631	392	1.244514	4.87849488	Algibacter sp. L4_22	2942477	Bacteria	Bacteria	132	4.989999999999998e-35	NR	WP_368736185.1	2942477	g3608	i0	71.4	2.56377551020408	84	23	63.5	1	250	2	123	206	WP_368736185.1 hypothetical protein [Algibacter sp. L4_22]	diamond	1005	132	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Algibacter	Algibacter sp. L4_22
30340751	30340751	PRJNA902515_P_NODE_11532_length_252_cov_0.871508_g11509_i0	PRJNA902515	11532	252	0.871508	2.19620016	Phocaeicola plebeius	310297	Bacteria	Bacteria	162	1.05e-44	NR	WP_195204904.1	310297	g11509	i0	100	2	84	0	100	0	1	252	498	581	WP_195204904.1 PL29 family lyase N-terminal domain-containing protein [Phocaeicola plebeius]	diamond	504	162	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola plebeius
30877298	30877298	PRJNA902515_P_NODE_13014_length_249_cov_0.886364_g12991_i0	PRJNA902515	13014	249	0.886364	2.20704636	Muribaculaceae bacterium	2498093	Bacteria	Bacteria	125	5.78e-34	NR	MBO5444960.1	2498093	g12991	i0	98.3	0.710843373493976	59	1	71.1	0	178	2	1	59	MBO5444960.1 nicotinamide mononucleotide transporter [Muribaculaceae bacterium]	diamond	177	125	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Muribaculaceae		Muribaculaceae bacterium
31351501	31351501	PRJNA902515_P_NODE_12916_length_249_cov_0.886364_g12893_i0	PRJNA902515	12916	249	0.886364	2.20704636	Barnesiella intestinihominis	487174	Bacteria	Bacteria	172	9.47e-52	NR	WP_229036929.1	487174	g12893	i0	100	1	83	0	100	0	1	249	42	124	WP_229036929.1 XRE family transcriptional regulator [Barnesiella intestinihominis]	diamond	249	172	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Barnesiellaceae	Barnesiella	Barnesiella intestinihominis
31794008	31794008	PRJNA902515_P_NODE_16077_length_242_cov_0.923077_g16054_i0	PRJNA902515	16077	242	0.923077	2.23384634	Parabacteroides distasonis	823	Bacteria	Bacteria	134	7.86e-39	NR	MFS6555288.1	823	g16054	i0	100	0.855371900826446	69	0	85.5	0	208	2	1	69	MFS6555288.1 hypothetical protein [Parabacteroides distasonis]	diamond	207	134	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Tannerellaceae	Parabacteroides	Parabacteroides distasonis
32142306	32142306	PRJNA902515_P_NODE_10198_length_262_cov_1.238095_g10175_i0	PRJNA902515	10198	262	1.238095	3.2438089	Bacteroides sp.	29523	Bacteria	Bacteria	119	4.13e-29	NR	MCD7815710.1	29523	g10175	i0	66.7	0.99618320610687	87	29	99.6	0	261	1	410	496	MCD7815710.1 BREX-1 system adenine-specific DNA-methyltransferase PglX [Bacteroides sp.]	diamond	261	119	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Bacteroides	Bacteroides sp.
32363949	32363949	PRJNA902515_P_NODE_6659_length_312_cov_1.351464_g6636_i0	PRJNA902515	6659	312	1.351464	4.21656768	Lepagella muris	3032870	Bacteria	Bacteria	224	2.65e-70	NR	WP_123482293.1	3032870	g6636	i0	100	0.990384615384615	103	0	99	0	310	2	138	240	WP_123482293.1 phosphatidylserine decarboxylase [Lepagella muris]	diamond	309	224	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Muribaculaceae	Lepagella	Lepagella muris

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