metadata: contig_metadata: 34 rows where analysis = "diamond", bioproject = "PRJNA949785" and tax

34 rows where analysis = "diamond", bioproject = "PRJNA949785" 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
12412281	12412281	PRJNA949785_P_NODE_16670_length_248_cov_0.880000_g16473_i0	PRJNA949785	16670	248	0.88	2.1824	Sphingobacteriaceae bacterium	2021370	Bacteria	Bacteria	162	2.2099999999999997e-47	NR	MBK7666256.1	2021370	g16473	i0	97.6	0.991935483870968	82	2	99.2	0	248	3	189	270	MBK7666256.1 arginase [Sphingobacteriaceae bacterium]	diamond	246	162	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae		Sphingobacteriaceae bacterium
21335298	21335298	PRJNA949785_P_NODE_18937_length_241_cov_0.916667_g18740_i0	PRJNA949785	18937	241	0.916667	2.20916747	Bacteroidales bacterium	2030927	Bacteria	Bacteria	148	5.3e-41	NR	MCF8307389.1	2030927	g18740	i0	96.3	0.995850622406639	80	3	99.6	0	241	2	106	185	MCF8307389.1 ATP-dependent Clp protease ATP-binding subunit ClpX [Bacteroidales bacterium]	diamond	240	148	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
26708652	26708652	PRJNA949785_P_NODE_13121_length_279_cov_1.567961_g12924_i0	PRJNA949785	13121	279	1.567961	4.37461119	Pontimicrobium sp. SW4	3153519	Bacteria	Bacteria	43.1	0.0291	NR	WP_347921916.1	3153519	g12924	i0	35.7	0.602150537634409	56	35	60.2	1	94	261	134	188	WP_347921916.1 hypothetical protein [Pontimicrobium sp. SW4]	diamond	168	43.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Pontimicrobium	Pontimicrobium sp. SW4
26772340	26772340	PRJNA949785_P_NODE_9281_length_343_cov_1.140741_g9084_i0	PRJNA949785	9281	343	1.140741	3.91274163	Christiangramia salexigens	1913577	Bacteria	Bacteria	48.1	9.1e-4	NR	WP_072553953.1	1913577	g9084	i0	29.9	1.02332361516035	117	64	95.3	4	9	335	11	117	WP_072553953.1 NAD(P)-dependent oxidoreductase [Christiangramia salexigens]	diamond	351	48.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Christiangramia	Christiangramia salexigens
26803900	26803900	PRJNA949785_P_NODE_16141_length_249_cov_0.875000_g15944_i0	PRJNA949785	16141	249	0.875	2.17875	Bacteroidales bacterium	2030927	Bacteria	Bacteria	84.7	6.6e-17	NR	MDO9580496.1	2030927	g15944	i0	64.9	0.686746987951807	57	20	68.7	0	247	77	729	785	MDO9580496.1 phosphoenolpyruvate synthase [Bacteroidales bacterium]	diamond	171	84.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
27373486	27373486	PRJNA949785_P_NODE_12303_length_290_cov_1.419355_g12106_i0	PRJNA949785	12303	290	1.419355	4.1161295	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	57.4	4.52e-7	NR	KAF0147144.1	2053306	g12106	i0	47.2	1.15862068965517	53	28	54.8	0	71	229	322	374	KAF0147144.1 MAG: Uncharacterized protein FD143_3102 [Ignavibacteria bacterium]	diamond	336	57.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
27436604	27436604	PRJNA949785_P_NODE_18063_length_244_cov_0.900585_g17866_i0	PRJNA949785	18063	244	0.900585	2.1974274	Flavipsychrobacter stenotrophus	2077091	Bacteria	Bacteria	132	4.14e-34	NR	WP_105041071.1	2077091	g17866	i0	75.3	2.96311475409836	81	20	99.6	0	244	2	289	369	WP_105041071.1 alkaline phosphatase PafA [Flavipsychrobacter stenotrophus]	diamond	723	132	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavipsychrobacter	Flavipsychrobacter stenotrophus
27625981	27625981	PRJNA949785_P_NODE_4244_length_556_cov_1.082816_g4050_i0	PRJNA949785	4244	556	1.082816	6.02045696	Phocaeicola coprocola	310298	Bacteria	Bacteria	48.9	0.00455	NR	WP_270230392.1	310298	g4050	i0	24	0.922661870503597	171	108	84.7	5	73	543	149	311	WP_270230392.1 hypothetical protein [Phocaeicola coprocola]	diamond	513	48.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola coprocola
27884974	27884974	PRJNA949785_P_NODE_12885_length_282_cov_1.473684_g12688_i0	PRJNA949785	12885	282	1.473684	4.15578888	Pseudomonadati	3379134	Bacteria	Bacteria	117	7.33e-29	NR	MBT5782964.1	2026760	g12688	i0	63	3.88297872340426	92	34	97.9	0	280	5	116	207	MBT5782964.1 choline dehydrogenase [Fidelibacterota bacterium]	diamond	1095	117	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota					Fidelibacterota bacterium
27884975	27884975	PRJNA949785_P_NODE_15605_length_251_cov_0.865169_g15408_i0	PRJNA949785	15605	251	0.865169	2.17157419	Mucilaginibacter	423349	Bacteria	Bacteria	124	1.13e-32	NR	WP_144909995.1	652788	g15408	i0	76.2	1.99601593625498	84	19	99.2	1	251	3	182	265	WP_144909995.1 helix-turn-helix domain-containing protein [Mucilaginibacter frigoritolerans]	diamond	501	124	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter frigoritolerans
28225475	28225475	PRJNA949785_P_NODE_17986_length_244_cov_0.900585_g17789_i0	PRJNA949785	17986	244	0.900585	2.1974274	Salinimicrobium sp.	1966347	Bacteria	Bacteria	89.4	6.350000000000001e-21	NR	HET8886409.1	1966347	g17789	i0	83.7	1.2172131147541	49	8	60.2	0	244	98	62	110	HET8886409.1 tRNA-binding protein [Salinimicrobium sp.]	diamond	297	89.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Salinimicrobium	Salinimicrobium sp.
28390139	28390139	PRJNA949785_P_NODE_15226_length_254_cov_0.872928_g15029_i0	PRJNA949785	15226	254	0.872928	2.21723712	Bacteria	2	Bacteria	Bacteria	42	0.00899	NR	MCZ2224457.1	2448779	g15029	i0	56.7	1.22834645669291	30	13	35.4	0	91	2	7	36	MCZ2224457.1 hypothetical protein [Chitinophagales bacterium]	diamond	312	42	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales			Chitinophagales bacterium
28446932	28446932	PRJNA949785_P_NODE_3726_length_599_cov_35.115970_g3541_i0	PRJNA949785	3726	599	35.11597	210.3446603	Candidatus Aegiribacteria sp.	2528271	Bacteria	Bacteria	95.1	8.39e-22	NR	MFO8183585.1	2528271	g3541	i0	57.7	1.65776293823038	78	33	39.1	0	12	245	2	79	MFO8183585.1 RNA-binding protein [Candidatus Aegiribacteria sp.]	diamond	993	95.1	1	Bacteria	FCB group	Pseudomonadati					Candidatus Aegiribacteria	Candidatus Aegiribacteria sp.
28541682	28541682	PRJNA949785_P_NODE_18687_length_242_cov_0.911243_g18490_i0	PRJNA949785	18687	242	0.911243	2.20520806	Flavobacteriaceae bacterium	1871037	Bacteria	Bacteria	48.9	1.39e-4	NR	NBU81945.1	1871037	g18490	i0	58.5	0.65702479338843	53	21	64.5	1	8	163	138	190	NBU81945.1 hypothetical protein [Flavobacteriaceae bacterium]	diamond	159	48.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
28958714	28958714	PRJNA949785_P_NODE_17408_length_245_cov_1.790698_g17211_i0	PRJNA949785	17408	245	1.790698	4.3872101	Pedobacter	84567	Bacteria	Bacteria	130	4.79e-34	NR	WP_090995664.1	414048	g17211	i0	77.8	3.96734693877551	81	18	99.2	0	1	243	13	93	WP_090995664.1 threonine synthase [Pedobacter insulae]	diamond	972	130	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Pedobacter	Pedobacter insulae
28983753	28983753	PRJNA949785_P_NODE_16568_length_248_cov_0.880000_g16371_i0	PRJNA949785	16568	248	0.88	2.1824	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	42.7	0.04	NR	MXX38617.1	2026742	g16371	i0	36.4	1.99596774193548	55	35	66.5	0	208	44	510	564	MXX38617.1 4Fe-4S binding protein [Gemmatimonadota bacterium]	diamond	495	42.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
29173124	29173124	PRJNA949785_P_NODE_18489_length_242_cov_1.319527_g18292_i0	PRJNA949785	18489	242	1.319527	3.19325534	Chitinophagales bacterium	2448779	Bacteria	Bacteria	53.9	4.32e-6	NR	MCZ2224572.1	2448779	g18292	i0	47.5	0.756198347107438	61	31	74.4	1	62	241	850	910	MCZ2224572.1 hypothetical protein [Chitinophagales bacterium]	diamond	183	53.9	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales			Chitinophagales bacterium
29204697	29204697	PRJNA949785_P_NODE_17629_length_245_cov_0.895349_g17432_i0	PRJNA949785	17629	245	0.895349	2.19360505	Bacteroidales bacterium	2030927	Bacteria	Bacteria	151	6.9e-42	NR	MCF8308318.1	2030927	g17432	i0	98.8	0.991836734693878	81	1	99.2	0	2	244	218	298	MCF8308318.1 Trk system potassium transporter TrkA [Bacteroidales bacterium]	diamond	243	151	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
29488503	29488503	PRJNA949785_P_NODE_18690_length_242_cov_0.911243_g18493_i0	PRJNA949785	18690	242	0.911243	2.20520806	Bacteroidales bacterium	2030927	Bacteria	Bacteria	143	4.4e-40	NR	MCF8231436.1	2030927	g18493	i0	98.8	0.991735537190083	80	1	99.2	0	242	3	108	187	MCF8231436.1 DMT family transporter [Bacteroidales bacterium]	diamond	240	143	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
29772650	29772650	PRJNA949785_P_NODE_15831_length_250_cov_0.870056_g15634_i0	PRJNA949785	15831	250	0.870056	2.17514	Flavisolibacter sp.	1954249	Bacteria	Bacteria	61.6	8.13e-9	NR	HEU4633650.1	1954249	g15634	i0	43.4	0.996	83	45	99.6	2	2	250	118	198	HEU4633650.1 T9SS type A sorting domain-containing protein [Flavisolibacter sp.]	diamond	249	61.6	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavisolibacter	Flavisolibacter sp.
29899298	29899298	PRJNA949785_P_NODE_15651_length_251_cov_0.865169_g15454_i0	PRJNA949785	15651	251	0.865169	2.17157419	Balneolaceae bacterium	2053516	Bacteria	Bacteria	145	2e-40	NR	MEX0719678.1	2053516	g15454	i0	96.4	1.9840637450199201	83	3	99.2	0	249	1	229	311	MEX0719678.1 STAS domain-containing protein [Balneolaceae bacterium]	diamond	498	145	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
30246926	30246926	PRJNA949785_P_NODE_5372_length_483_cov_2.058537_g5175_i0	PRJNA949785	5372	483	2.058537	9.94273371	Lacibacter sp.	1915409	Bacteria	Bacteria	47	0.00783	NR	WP_324232586.1	1915409	g5175	i0	31.9	0.583850931677019	94	63	57.8	1	434	156	3	96	WP_324232586.1 hypothetical protein [Lacibacter sp.]	diamond	282	47	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Lacibacter	Lacibacter sp.
30506144	30506144	PRJNA949785_P_NODE_1373_length_1017_cov_8.230932_g1243_i0	PRJNA949785	1373	1017	8.230932	83.70857844	Bacteria	2	Bacteria	Bacteria	108	3.29e-24	NR	WP_142454166.1	1302730	g1243	i0	29.6	4.39233038348083	243	103	70.8	4	981	262	2	179	WP_142454166.1 adenylate kinase [Gracilimonas mengyeensis]	diamond	4467	109	0.990825688073395	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Gracilimonas	Gracilimonas mengyeensis
30657402	30657402	PRJNA949785_P_NODE_5093_length_500_cov_1.081967_g4896_i0	PRJNA949785	5093	500	1.081967	5.409835	Cytophagaceae bacterium	2026729	Bacteria	Bacteria	62.4	2.55e-8	NR	HWZ23099.1	2026729	g4896	i0	38.6	0.498	83	51	49.8	0	251	499	27	109	HWZ23099.1 hypothetical protein [Cytophagaceae bacterium]	diamond	249	62.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Cytophagaceae		Cytophagaceae bacterium
30878565	30878565	PRJNA949785_P_NODE_16754_length_247_cov_1.327586_g16557_i0	PRJNA949785	16754	247	1.327586	3.27913742	Chitinophagales bacterium	2448779	Bacteria	Bacteria	63.5	1.72e-9	NR	MCZ2224480.1	2448779	g16557	i0	44	0.910931174089069	75	41	89.9	1	2	223	231	305	MCZ2224480.1 metallophosphoesterase [Chitinophagales bacterium]	diamond	225	63.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales			Chitinophagales bacterium
31068367	31068367	PRJNA949785_P_NODE_16255_length_249_cov_0.875000_g16058_i0	PRJNA949785	16255	249	0.875	2.17875	Sphingobacterium wenxiniae	683125	Bacteria	Bacteria	157	1.5299999999999998e-42	NR	WP_093363274.1	683125	g16058	i0	94	1	83	5	100	0	249	1	449	531	WP_093363274.1 type I restriction-modification system endonuclease [Sphingobacterium wenxiniae]	diamond	249	157	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Sphingobacterium	Sphingobacterium wenxiniae
31542578	31542578	PRJNA949785_P_NODE_18056_length_244_cov_0.900585_g17859_i0	PRJNA949785	18056	244	0.900585	2.1974274	Ferruginibacter sp. HRS2-29	2487334	Bacteria	Bacteria	44.3	0.00404	NR	WP_255155307.1	2487334	g17859	i0	55	0.983606557377049	40	18	49.2	0	121	2	1	40	WP_255155307.1 HEPN domain-containing protein [Ferruginibacter sp. HRS2-29]	diamond	240	44.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Ferruginibacter	Ferruginibacter sp. HRS2-29
31574263	31574263	PRJNA949785_P_NODE_18076_length_244_cov_0.871345_g17879_i0	PRJNA949785	18076	244	0.871345	2.1260818	Chitinophagales bacterium	2448779	Bacteria	Bacteria	48.1	4.63e-4	NR	MCC7224211.1	2448779	g17879	i0	49.2	0.799180327868853	65	32	78.7	1	43	234	230	294	MCC7224211.1 polysaccharide biosynthesis C-terminal domain-containing protein [Chitinophagales bacterium]	diamond	195	48.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales			Chitinophagales bacterium
31795296	31795296	PRJNA949785_P_NODE_15517_length_251_cov_0.865169_g15320_i0	PRJNA949785	15517	251	0.865169	2.17157419	Prevotella sp. HMSC	59823	Bacteria	Bacteria	183	1.42e-51	NR	WP_070723738.1	1739459	g15320	i0	98.8	5.95219123505976	83	1	99.2	0	249	1	260	342	WP_070723738.1 two-component regulator propeller domain-containing protein [Prevotella sp. HMSC073D09]	diamond	1494	183	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Prevotellaceae	Prevotella	Prevotella sp. HMSC073D09
31826973	31826973	PRJNA949785_P_NODE_13617_length_273_cov_1.565000_g13420_i0	PRJNA949785	13617	273	1.565	4.27245	Mucilaginibacter sp.	1882438	Bacteria	Bacteria	64.3	1.43e-9	NR	HVW97493.1	1882438	g13420	i0	37.5	0.967032967032967	88	52	95.6	3	7	267	566	651	HVW97493.1 hypothetical protein [Mucilaginibacter sp.]	diamond	264	64.3	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales	Sphingobacteriaceae	Mucilaginibacter	Mucilaginibacter sp.
31890359	31890359	PRJNA949785_P_NODE_16617_length_248_cov_0.880000_g16420_i0	PRJNA949785	16617	248	0.88	2.1824	Flavipsychrobacter stenotrophus	2077091	Bacteria	Bacteria	152	7e-44	NR	WP_105038542.1	2077091	g16420	i0	81.7	0.991935483870968	82	15	99.2	0	1	246	19	100	WP_105038542.1 MBL fold metallo-hydrolase [Flavipsychrobacter stenotrophus]	diamond	246	152	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Flavipsychrobacter	Flavipsychrobacter stenotrophus
32175405	32175405	PRJNA949785_P_NODE_12998_length_281_cov_1.259615_g12801_i0	PRJNA949785	12998	281	1.259615	3.53951815	Flavobacteriaceae bacterium	1871037	Bacteria	Bacteria	59.7	6.44e-8	NR	MBL6649012.1	1871037	g12801	i0	48.8	0.918149466192171	86	31	85.4	3	279	40	666	744	MBL6649012.1 alanine--tRNA ligase [Flavobacteriaceae bacterium]	diamond	258	59.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
32238741	32238741	PRJNA949785_P_NODE_17758_length_244_cov_1.695906_g17561_i0	PRJNA949785	17758	244	1.695906	4.13801064	Bacteroidales bacterium	2030927	Bacteria	Bacteria	115	2.18e-29	NR	MCF8339140.1	2030927	g17561	i0	67.5	0.983606557377049	80	26	98.4	0	2	241	55	134	MCF8339140.1 hypothetical protein [Bacteroidales bacterium]	diamond	240	115	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales			Bacteroidales bacterium
32530102	32530102	PRJNA949785_P_NODE_13959_length_269_cov_1.178571_g13762_i0	PRJNA949785	13959	269	1.178571	3.17035599	Bacteroidota	976	Bacteria	Bacteria	122	2.25e-30	NR	HBI01610.1	239	g13762	i0	53.9	1.97397769516729	89	41	99.3	0	269	3	140	228	HBI01610.1 ribonucleoside-diphosphate reductase subunit alpha [Flavobacterium sp.]	diamond	531	123	0.991869918699187	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.

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