metadata: contig_metadata: 63 rows where analysis = "diamond", bioproject = "PRJNA1103784" and tax

63 rows where analysis = "diamond", bioproject = "PRJNA1103784" and tax_phylum = "Pseudomonadota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
212193	212193	PRJNA1103784_P_NODE_6301_length_248_cov_0.880000_g6246_i0	PRJNA1103784	6301	248	0.88	2.1824	Pseudoxanthomonas	83618	Bacteria	Bacteria	139	9.9e-37	NR	WP_245106647.1	128785	g6246	i0	89.5	2.75806451612903	76	8	91.9	0	19	246	1	76	WP_245106647.1 glycogen debranching N-terminal domain-containing protein [Pseudoxanthomonas mexicana]	diamond	684	139	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Pseudoxanthomonas	Pseudoxanthomonas mexicana
212194	212194	PRJNA1103784_P_NODE_6321_length_248_cov_0.880000_g6266_i0	PRJNA1103784	6321	248	0.88	2.1824	Phyllobacterium sp.	1871046	Bacteria	Bacteria	164	9.54e-49	NR	MBN9136697.1	1871046	g6266	i0	100	1.98387096774194	82	0	99.2	0	1	246	59	140	MBN9136697.1 phosphoglucosamine mutase [Phyllobacterium sp.]	diamond	492	164	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium sp.
4038884	4038884	PRJNA1103784_P_NODE_3284_length_304_cov_1.333333_g3229_i0	PRJNA1103784	3284	304	1.333333	4.05333232	Phyllobacterium sp.	1871046	Bacteria	Bacteria	136	1.46e-38	NR	WP_346308462.1	1871046	g3229	i0	91.5	0.809210526315789	82	7	80.9	0	248	3	1	82	WP_346308462.1 spore coat U domain-containing protein [Phyllobacterium sp.]	diamond	246	136	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium sp.
4848199	4848199	PRJNA1103784_P_NODE_2144_length_363_cov_1.503448_g2089_i0	PRJNA1103784	2144	363	1.503448	5.45751624	Pararhizobium sp.	1977563	Bacteria	Bacteria	126	8.27e-34	NR	WP_325438262.1	1977563	g2089	i0	56.8	1.03305785123967	125	47	99.2	3	361	2	52	174	WP_325438262.1 hypothetical protein, partial [Pararhizobium sp.]	diamond	375	126	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Rhizobiaceae	Pararhizobium	Pararhizobium sp.
5315006	5315006	PRJNA1103784_P_NODE_4025_length_282_cov_1.311005_g3970_i0	PRJNA1103784	4025	282	1.311005	3.6970341	Phyllobacterium	28100	Bacteria	Bacteria	181	1.0399999999999998e-55	NR	WP_182551765.1	28101	g3970	i0	92.3	2.9468085106383	91	7	96.8	0	275	3	100	190	WP_182551765.1 alpha/beta hydrolase [Phyllobacterium myrsinacearum]	diamond	831	181	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium myrsinacearum
6590201	6590201	PRJNA1103784_P_NODE_3706_length_289_cov_1.388889_g3651_i0	PRJNA1103784	3706	289	1.388889	4.01388921	Litoribrevibacter	1649464	Bacteria	Bacteria	87.8	4.07e-19	NR	WP_284380540.1	1473156	g3651	i0	48.4	7.70242214532872	93	39	96.5	1	281	3	13	96	WP_284380540.1 cysteine hydrolase family protein [Litoribrevibacter albus]	diamond	2226	87.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Oceanospirillaceae	Litoribrevibacter	Litoribrevibacter albus
7864874	7864874	PRJNA1103784_P_NODE_6667_length_246_cov_0.890173_g6612_i0	PRJNA1103784	6667	246	0.890173	2.18982558	Paeniroseomonas aquatica	373043	Bacteria	Bacteria	161	1.7699999999999998e-45	NR	WP_290317273.1	373043	g6612	i0	100	1.97560975609756	81	0	98.8	0	244	2	3	83	WP_290317273.1 FAD-dependent oxidoreductase [Paeniroseomonas aquatica]	diamond	486	161	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Acetobacterales	Acetobacteraceae	Paeniroseomonas	Paeniroseomonas aquatica
10415505	10415505	PRJNA1103784_P_NODE_2749_length_326_cov_1.217391_g2694_i0	PRJNA1103784	2749	326	1.217391	3.96869466	Phyllobacterium sp.	1871046	Bacteria	Bacteria	211	9.97e-67	NR	MBN9137704.1	1871046	g2694	i0	100	1.97852760736196	108	0	99.4	0	3	326	136	243	MBN9137704.1 peptidylprolyl isomerase [Phyllobacterium sp.]	diamond	645	211	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium sp.
10415552	10415552	PRJNA1103784_P_NODE_4909_length_264_cov_2.340314_g4854_i0	PRJNA1103784	4909	264	2.340314	6.17842896	Phyllobacterium myrsinacearum	28101	Bacteria	Bacteria	153	1.5e-41	NR	WP_130268759.1	28101	g4854	i0	98.8	0.931818181818182	82	1	93.2	0	19	264	492	573	WP_130268759.1 pseudouridine synthase [Phyllobacterium myrsinacearum]	diamond	246	153	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium myrsinacearum
10415574	10415574	PRJNA1103784_P_NODE_5849_length_250_cov_0.870056_g5794_i0	PRJNA1103784	5849	250	0.870056	2.17514	Phyllobacterium calauticae	2817027	Bacteria	Bacteria	106	2.35e-25	NR	WP_223612300.1	2817027	g5794	i0	96.4	0.66	55	2	66	0	2	166	280	334	WP_223612300.1 cytochrome d ubiquinol oxidase subunit II [Phyllobacterium calauticae]	diamond	165	106	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium calauticae
11223587	11223587	PRJNA1103784_P_NODE_6009_length_249_cov_1.289773_g5954_i0	PRJNA1103784	6009	249	1.289773	3.21153477	Phyllobacterium sp. OV277	1882772	Bacteria	Bacteria	160	1.41e-46	NR	WP_091879354.1	1882772	g5954	i0	93.9	1.97590361445783	82	5	98.8	0	248	3	69	150	WP_091879354.1 DUF1402 family protein [Phyllobacterium sp. OV277]	diamond	492	160	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium sp. OV277
11690885	11690885	PRJNA1103784_P_NODE_7570_length_242_cov_0.911243_g7515_i0	PRJNA1103784	7570	242	0.911243	2.20520806	Phyllobacterium sp. OV277	1882772	Bacteria	Bacteria	169	2.74e-50	NR	WP_091880028.1	1882772	g7515	i0	98.8	0.991735537190083	80	1	99.2	0	2	241	71	150	WP_091880028.1 SDR family oxidoreductase [Phyllobacterium sp. OV277]	diamond	240	169	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium sp. OV277
12965953	12965953	PRJNA1103784_P_NODE_1651_length_403_cov_0.909091_g1596_i0	PRJNA1103784	1651	403	0.909091	3.66363673	unclassified Phyllobacterium	2638441	Bacteria	Bacteria	185	1.4699999999999997e-57	NR	WP_091877519.1	2638441	g1596	i0	95.4	0.803970223325062	108	5	80.4	0	401	78	31	138	WP_091877519.1 MULTISPECIES: hypothetical protein [unclassified Phyllobacterium]	diamond	324	185	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium
12965984	12965984	PRJNA1103784_P_NODE_3911_length_285_cov_0.849057_g3856_i0	PRJNA1103784	3911	285	0.849057	2.41981245	Phyllobacterium myrsinacearum	28101	Bacteria	Bacteria	182	1.9099999999999994e-55	NR	WP_245457762.1	28101	g3856	i0	91.6	1	95	8	100	0	1	285	7	101	WP_245457762.1 alpha/beta fold hydrolase [Phyllobacterium myrsinacearum]	diamond	285	182	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium myrsinacearum
14240974	14240974	PRJNA1103784_P_NODE_7212_length_244_cov_0.900585_g7157_i0	PRJNA1103784	7212	244	0.900585	2.1974274	Rubellimicrobium aerolatum	490979	Bacteria	Bacteria	124	4.709999999999999e-31	NR	WP_209839038.1	490979	g7157	i0	87.3	1.85655737704918	71	9	87.3	0	32	244	137	207	WP_209839038.1 serine protease [Rubellimicrobium aerolatum]	diamond	453	124	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Roseobacteraceae	Rubellimicrobium	Rubellimicrobium aerolatum
18063890	18063890	PRJNA1103784_P_NODE_8115_length_227_cov_2.467532_g8060_i0	PRJNA1103784	8115	227	2.467532	5.60129764	Phyllobacterium	28100	Bacteria	Bacteria	105	6.25e-27	NR	WP_342635193.1	28101	g8060	i0	98.1	1.40088105726872	53	1	70	0	226	68	86	138	WP_342635193.1 DUF192 domain-containing protein [Phyllobacterium myrsinacearum]	diamond	318	106	0.990566037735849	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium myrsinacearum
20613345	20613345	PRJNA1103784_P_NODE_6777_length_246_cov_0.890173_g6722_i0	PRJNA1103784	6777	246	0.890173	2.18982558	Phyllobacterium sp.	1871046	Bacteria	Bacteria	142	1.9699999999999998e-42	NR	WP_346308488.1	1871046	g6722	i0	98.6	0.865853658536585	71	1	86.6	0	1	213	13	83	WP_346308488.1 DUF2171 domain-containing protein [Phyllobacterium sp.]	diamond	213	142	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium sp.
21888944	21888944	PRJNA1103784_P_NODE_4998_length_263_cov_1.278947_g4943_i0	PRJNA1103784	4998	263	1.278947	3.36363061	Phyllobacterium sp. OV277	1882772	Bacteria	Bacteria	171	2.67e-51	NR	WP_091880424.1	1882772	g4943	i0	94.3	0.992395437262357	87	5	99.2	0	3	263	106	192	WP_091880424.1 DNA repair protein RecO [Phyllobacterium sp. OV277]	diamond	261	171	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium sp. OV277
23164450	23164450	PRJNA1103784_P_NODE_3639_length_290_cov_2.082949_g3584_i0	PRJNA1103784	3639	290	2.082949	6.0405521	Undibacterium squillarum	1131567	Bacteria	Bacteria	154	2.79e-41	NR	WP_374519238.1	1131567	g3584	i0	90.6	1.98620689655172	96	9	99.3	0	2	289	23	118	WP_374519238.1 alkaline phosphatase D family protein [Undibacterium squillarum]	diamond	576	154	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium squillarum
26592640	26592640	PRJNA1103784_P_NODE_5721_length_251_cov_0.865169_g5666_i0	PRJNA1103784	5721	251	0.865169	2.17157419	Phyllobacterium	28100	Bacteria	Bacteria	162	7.06e-50	NR	WP_223612331.1	28100	g5666	i0	100	0.99203187250996006	83	0	99.2	0	1	249	22	104	WP_223612331.1 MULTISPECIES: hypothetical protein [Phyllobacterium]	diamond	249	162	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium
26750782	26750782	PRJNA1103784_P_NODE_4201_length_278_cov_1.448780_g4146_i0	PRJNA1103784	4201	278	1.44878	4.0276084	Novosphingobium panipatense	428991	Bacteria	Bacteria	187	7.63e-56	NR	WP_283406657.1	428991	g4146	i0	100	1.98561151079137	92	0	99.3	0	276	1	208	299	WP_283406657.1 M48 family metallopeptidase [Novosphingobium panipatense]	diamond	552	187	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Novosphingobium	Novosphingobium panipatense
26941010	26941010	PRJNA1103784_P_NODE_6662_length_246_cov_0.890173_g6607_i0	PRJNA1103784	6662	246	0.890173	2.18982558	Candidatus Afipia apatlaquensis	2712852	Bacteria	Bacteria	142	3.04e-41	NR	NGX97895.1	2712852	g6607	i0	100	1	82	0	100	0	246	1	55	136	NGX97895.1 DUF2721 domain-containing protein [Candidatus Afipia apatlaquensis]	diamond	246	142	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Nitrobacteraceae	Afipia	Candidatus Afipia apatlaquensis
27194003	27194003	PRJNA1103784_P_NODE_8002_length_234_cov_2.298137_g7947_i0	PRJNA1103784	8002	234	2.298137	5.37764058	Oceanimonas baumannii	129578	Bacteria	Bacteria	67	8.89e-11	NR	WP_094276848.1	129578	g7947	i0	47.8	1.76923076923077	69	32	88.5	1	229	23	401	465	WP_094276848.1 cytochrome P450 [Oceanimonas baumannii]	diamond	414	67	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Oceanimonas	Oceanimonas baumannii
27257332	27257332	PRJNA1103784_P_NODE_4023_length_282_cov_1.320574_g3968_i0	PRJNA1103784	4023	282	1.320574	3.72401868	Aromatoleum toluolicum	90060	Bacteria	Bacteria	159	1.98e-43	NR	WP_169142133.1	90060	g3968	i0	73.1	0.98936170212766	93	25	98.9	0	279	1	343	435	WP_169142133.1 alkyl/aryl-sulfatase [Aromatoleum toluolicum]	diamond	279	159	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Rhodocyclales	Rhodocyclaceae	Aromatoleum	Aromatoleum toluolicum
27320652	27320652	PRJNA1103784_P_NODE_6223_length_248_cov_0.880000_g6168_i0	PRJNA1103784	6223	248	0.88	2.1824	Phyllobacterium calauticae	2817027	Bacteria	Bacteria	163	5.04e-50	NR	WP_223612779.1	2817027	g6168	i0	97.6	0.991935483870968	82	2	99.2	0	1	246	16	97	WP_223612779.1 nitrile hydratase accessory protein [Phyllobacterium calauticae]	diamond	246	163	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium calauticae
27415606	27415606	PRJNA1103784_P_NODE_4923_length_264_cov_1.586387_g4868_i0	PRJNA1103784	4923	264	1.586387	4.18806168	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	67.8	2.9e-11	NR	MEC9348058.1	1977087	g4868	i0	40	3.93181818181818	85	51	96.6	0	260	6	141	225	MEC9348058.1 acetoacetate decarboxylase [Pseudomonadota bacterium]	diamond	1038	67.8	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
27510183	27510183	PRJNA1103784_P_NODE_3983_length_283_cov_1.138095_g3928_i0	PRJNA1103784	3983	283	1.138095	3.22080885	Phyllobacterium sp.	1871046	Bacteria	Bacteria	158	1.07e-44	NR	MBN9134438.1	1871046	g3928	i0	97.8	1.97173144876325	93	2	98.6	0	281	3	127	219	MBN9134438.1 ABC transporter permease subunit [Phyllobacterium sp.]	diamond	558	158	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium sp.
27573218	27573218	PRJNA1103784_P_NODE_3724_length_289_cov_1.097222_g3669_i0	PRJNA1103784	3724	289	1.097222	3.17097158	Rhizobium tubonense	484088	Bacteria	Bacteria	132	1.42e-33	NR	WP_111159753.1	484088	g3669	i0	68.1	2.87543252595156	91	28	94.5	1	287	15	713	802	WP_111159753.1 phosphoketolase [Rhizobium tubonense]	diamond	831	132	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Rhizobiaceae	Rhizobium	Rhizobium tubonense
27785759	27785759	PRJNA1103784_P_NODE_5964_length_250_cov_0.870056_g5909_i0	PRJNA1103784	5964	250	0.870056	2.17514	Pseudomonadati	3379134	Bacteria	Bacteria	101	1.06e-22	NR	HMU38595.1	1977087	g5909	i0	64.1	14.784	78	27	93.6	1	17	250	154	230	HMU38595.1 M28 family peptidase [Pseudomonadota bacterium]	diamond	3696	102	0.990196078431373	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
27794388	27794388	PRJNA1103784_P_NODE_6704_length_246_cov_0.890173_g6649_i0	PRJNA1103784	6704	246	0.890173	2.18982558	Undibacterium squillarum	1131567	Bacteria	Bacteria	99	2.64e-23	NR	WP_189356188.1	1131567	g6649	i0	63.6	1.90243902439024	77	27	92.7	1	1	228	162	238	WP_189356188.1 SDR family oxidoreductase [Undibacterium squillarum]	diamond	468	99	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium squillarum
27888852	27888852	PRJNA1103784_P_NODE_4545_length_271_cov_1.505051_g4490_i0	PRJNA1103784	4545	271	1.505051	4.07868821	Methylobacteriaceae	119045	Bacteria	Bacteria	43.5	0.0164	NR	WP_012455863.1	119045	g4490	i0	87.5	0.265682656826568	24	3	26.6	0	200	271	1	24	WP_012455863.1 MULTISPECIES: hypothetical protein [Methylobacteriaceae]	diamond	72	43.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae
27952137	27952137	PRJNA1103784_P_NODE_6365_length_248_cov_0.880000_g6310_i0	PRJNA1103784	6365	248	0.88	2.1824	Methylobacterium sp.	409	Bacteria	Bacteria	135	5.25e-37	NR	WP_286963833.1	409	g6310	i0	88.1	2.00806451612903	84	8	99.2	1	247	2	14	97	WP_286963833.1 hypothetical protein [Methylobacterium sp.]	diamond	498	135	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae	Methylobacterium	Methylobacterium sp.
27983629	27983629	PRJNA1103784_P_NODE_5885_length_250_cov_0.870056_g5830_i0	PRJNA1103784	5885	250	0.870056	2.17514	Amnimonas aquatica	2094561	Bacteria	Bacteria	122	1.2099999999999999e-32	NR	WP_105191027.1	2094561	g5830	i0	100	0.816	68	0	81.6	0	2	205	139	206	WP_105191027.1 Holliday junction branch migration protein RuvA [Amnimonas aquatica]	diamond	204	122	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Amnimonas	Amnimonas aquatica
28015394	28015394	PRJNA1103784_P_NODE_3685_length_290_cov_0.875576_g3630_i0	PRJNA1103784	3685	290	0.875576	2.5391704	Pseudomonadales bacterium	1891229	Bacteria	Bacteria	96.7	2.15e-22	NR	MEQ9450020.1	1891229	g3630	i0	51.2	1.70689655172414	82	40	84.8	0	1	246	32	113	MEQ9450020.1 sulfotransferase [Pseudomonadales bacterium]	diamond	495	96.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales			Pseudomonadales bacterium
28046806	28046806	PRJNA1103784_P_NODE_5585_length_251_cov_2.011236_g5530_i0	PRJNA1103784	5585	251	2.011236	5.04820236	Phyllobacterium calauticae	2817027	Bacteria	Bacteria	149	6.699999999999998e-43	NR	WP_223614981.1	2817027	g5530	i0	96.3	0.9800796812749	82	3	98	0	5	250	5	86	WP_223614981.1 NAD-dependent epimerase/dehydratase family protein [Phyllobacterium calauticae]	diamond	246	149	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium calauticae
28235997	28235997	PRJNA1103784_P_NODE_2986_length_315_cov_1.909091_g2931_i0	PRJNA1103784	2986	315	1.909091	6.01363665	Pararhizobium sp.	1977563	Bacteria	Bacteria	68.6	5.64e-12	NR	WP_325439747.1	1977563	g2931	i0	62.5	0.457142857142857	48	18	45.7	0	299	156	1	48	WP_325439747.1 hypothetical protein, partial [Pararhizobium sp.]	diamond	144	68.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Rhizobiaceae	Pararhizobium	Pararhizobium sp.
28258965	28258965	PRJNA1103784_P_NODE_3986_length_283_cov_1.100000_g3931_i0	PRJNA1103784	3986	283	1.1	3.113	Pseudomonadati	3379134	Bacteria	Bacteria	99	1.07e-21	NR	MFH1808975.1	1977087	g3931	i0	57.4	5.97879858657244	94	40	99.6	0	1	282	599	692	MFH1808975.1 DUF2135 domain-containing protein [Pseudomonadota bacterium]	diamond	1692	100	0.99	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
29152286	29152286	PRJNA1103784_P_NODE_6449_length_247_cov_0.885057_g6394_i0	PRJNA1103784	6449	247	0.885057	2.18609079	Aestuariibacter sp.	1872400	Bacteria	Bacteria	84.7	2.34e-18	NR	XOV77624.1	1872400	g6394	i0	50	4.09311740890688	84	40	99.6	1	246	1	64	147	XOV77624.1 MAG: DUF924 family protein [Aestuariibacter sp.]	diamond	1011	84.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Alteromonadaceae	Aestuariibacter	Aestuariibacter sp.
29593563	29593563	PRJNA1103784_P_NODE_7190_length_244_cov_0.900585_g7135_i0	PRJNA1103784	7190	244	0.900585	2.1974274	Massilia brevitalea	442526	Bacteria	Bacteria	77.8	7.73e-16	NR	WP_305824602.1	442526	g7135	i0	67.3	0.676229508196721	55	18	67.6	0	78	242	95	149	WP_305824602.1 hypothetical protein [Massilia brevitalea]	diamond	165	77.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Massilia	Massilia brevitalea
29625052	29625052	PRJNA1103784_P_NODE_6730_length_246_cov_0.890173_g6675_i0	PRJNA1103784	6730	246	0.890173	2.18982558	Phyllobacterium sp.	1871046	Bacteria	Bacteria	166	1.4e-46	NR	WP_346306774.1	1871046	g6675	i0	96.3	1	82	3	100	0	246	1	137	218	WP_346306774.1 sensor histidine kinase [Phyllobacterium sp.]	diamond	246	166	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium sp.
29814868	29814868	PRJNA1103784_P_NODE_3111_length_310_cov_2.510549_g3056_i0	PRJNA1103784	3111	310	2.510549	7.7827019	Phyllobacterium calauticae	2817027	Bacteria	Bacteria	92.4	1.37e-20	NR	WP_319025568.1	2817027	g3056	i0	91.8	0.948387096774194	49	4	47.4	0	149	3	34	82	WP_319025568.1 hypothetical protein [Phyllobacterium calauticae]	diamond	294	92.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium calauticae
30130529	30130529	PRJNA1103784_P_NODE_3112_length_310_cov_2.485232_g3057_i0	PRJNA1103784	3112	310	2.485232	7.7042192	Legionellales bacterium RIFCSPHIGHO2_12_FULL_35_11	1798567	Bacteria	Bacteria	178	9.46e-52	NR	OGV36309.1	1798567	g3057	i0	66	1.36451612903226	141	10	99.7	1	309	1	219	359	OGV36309.1 MAG: delta(24(24(1)))-sterol reductase, partial [Legionellales bacterium RIFCSPHIGHO2_12_FULL_35_11]	diamond	423	178	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Legionellales			Legionellales bacterium RIFCSPHIGHO2_12_FULL_35_11
30193951	30193951	PRJNA1103784_P_NODE_5592_length_251_cov_1.685393_g5537_i0	PRJNA1103784	5592	251	1.685393	4.23033643	Phyllobacterium myrsinacearum	28101	Bacteria	Bacteria	73.2	4.61e-13	NR	WP_105733865.1	28101	g5537	i0	82.2	0.537848605577689	45	8	53.8	0	137	3	1	45	WP_105733865.1 tonB-system energizer ExbB [Phyllobacterium myrsinacearum]	diamond	135	73.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium myrsinacearum
30193952	30193952	PRJNA1103784_P_NODE_6292_length_248_cov_0.880000_g6237_i0	PRJNA1103784	6292	248	0.88	2.1824	Zoogloea dura	2728840	Bacteria	Bacteria	155	1.29e-41	NR	WP_169145070.1	2728840	g6237	i0	96.3	1.98387096774194	82	3	99.2	0	247	2	857	938	WP_169145070.1 ATP-binding protein [Zoogloea dura]	diamond	492	155	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Rhodocyclales	Zoogloeaceae	Zoogloea	Zoogloea dura
30667976	30667976	PRJNA1103784_P_NODE_5113_length_261_cov_1.117021_g5058_i0	PRJNA1103784	5113	261	1.117021	2.91542481	Phyllobacterium sp.	1871046	Bacteria	Bacteria	90.5	1.19e-20	NR	WP_346307008.1	1871046	g5058	i0	92.6	0.781609195402299	68	5	78.2	0	204	1	1	68	WP_346307008.1 Holotricin-3 precursor [Phyllobacterium sp.]	diamond	204	90.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium sp.
30699488	30699488	PRJNA1103784_P_NODE_2914_length_318_cov_1.873469_g2859_i0	PRJNA1103784	2914	318	1.873469	5.95763142	Phyllobacterium calauticae	2817027	Bacteria	Bacteria	184	7.9e-58	NR	WP_223613992.1	2817027	g2859	i0	98.1	0.990566037735849	105	2	99.1	0	2	316	20	124	WP_223613992.1 hypothetical protein [Phyllobacterium calauticae]	diamond	315	184	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium calauticae
30731158	30731158	PRJNA1103784_P_NODE_8214_length_203_cov_5.153846_g8159_i0	PRJNA1103784	8214	203	5.153846	10.46230738	Phyllobacterium sp.	1871046	Bacteria	Bacteria	117	8.629999999999998e-32	NR	WP_346307967.1	1871046	g8159	i0	98.5	0.990147783251232	67	1	99	0	202	2	8	74	WP_346307967.1 flagellar basal body-associated FliL family protein [Phyllobacterium sp.]	diamond	201	117	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium sp.
30889219	30889219	PRJNA1103784_P_NODE_4014_length_282_cov_1.430622_g3959_i0	PRJNA1103784	4014	282	1.430622	4.03435404	Chelativorans sp. ZYF759	2692213	Bacteria	Bacteria	87.8	4.93e-18	NR	WP_169284877.1	2692213	g3959	i0	97.8	0.478723404255319	45	1	47.9	0	277	143	342	386	WP_169284877.1 alanine racemase [Chelativorans sp. ZYF759]	diamond	135	87.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Chelativorans	Chelativorans sp. ZYF759
31521559	31521559	PRJNA1103784_P_NODE_5996_length_249_cov_1.619318_g5941_i0	PRJNA1103784	5996	249	1.619318	4.03210182	Phyllobacterium sp.	1871046	Bacteria	Bacteria	168	8.01e-49	NR	MBN9134650.1	1871046	g5941	i0	97.6	2	83	2	100	0	249	1	51	133	MBN9134650.1 MBL fold metallo-hydrolase [Phyllobacterium sp.]	diamond	498	168	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium sp.
31521561	31521561	PRJNA1103784_P_NODE_7636_length_242_cov_0.911243_g7581_i0	PRJNA1103784	7636	242	0.911243	2.20520806	Cellvibrio sp.	1965322	Bacteria	Bacteria	140	1.88e-36	NR	HSX52220.1	1965322	g7581	i0	86.3	2.97520661157025	80	11	99.2	0	241	2	336	415	HSX52220.1 ATP-dependent DNA helicase [Cellvibrio sp.]	diamond	720	140	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Cellvibrionales	Cellvibrionaceae	Cellvibrio	Cellvibrio sp.
31616286	31616286	PRJNA1103784_P_NODE_7736_length_241_cov_0.916667_g7681_i0	PRJNA1103784	7736	241	0.916667	2.20916747	Phyllobacterium calauticae	2817027	Bacteria	Bacteria	155	1.6e-43	NR	WP_223613217.1	2817027	g7681	i0	100	0.983402489626556	79	0	98.3	0	239	3	235	313	WP_223613217.1 M23 family metallopeptidase [Phyllobacterium calauticae]	diamond	237	155	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium calauticae
31639111	31639111	PRJNA1103784_P_NODE_6496_length_247_cov_0.885057_g6441_i0	PRJNA1103784	6496	247	0.885057	2.18609079	Pseudomonadota	1224	Bacteria	Bacteria	92.4	1.3e-22	NR	WP_163413799.1	562	g6441	i0	76.4	1.33603238866397	55	13	66.8	0	82	246	1	55	WP_163413799.1 hypothetical protein, partial [Escherichia coli]	diamond	330	92.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
31733926	31733926	PRJNA1103784_P_NODE_5257_length_257_cov_2.239130_g5202_i0	PRJNA1103784	5257	257	2.23913	5.7545641	Phyllobacterium	28100	Bacteria	Bacteria	64.3	1.04e-9	NR	WP_105732395.1	28101	g5202	i0	97.3	1.29571984435798	37	1	43.2	0	146	256	1	37	WP_105732395.1 Na+/H+ antiporter NhaA [Phyllobacterium myrsinacearum]	diamond	333	64.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium myrsinacearum
31774361	31774361	PRJNA1103784_P_NODE_6237_length_248_cov_0.880000_g6182_i0	PRJNA1103784	6237	248	0.88	2.1824	Labrys wisconsinensis	425677	Bacteria	Bacteria	135	8.51e-36	NR	WP_307279930.1	425677	g6182	i0	90.7	1.04032258064516	86	3	99.2	2	246	1	147	231	WP_307279930.1 CDF family Co(II)/Ni(II) efflux transporter DmeF [Labrys wisconsinensis]	diamond	258	135	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Xanthobacteraceae	Labrys	Labrys wisconsinensis
31892262	31892262	PRJNA1103784_P_NODE_6577_length_247_cov_0.885057_g6522_i0	PRJNA1103784	6577	247	0.885057	2.18609079	Muricoccus	3409995	Bacteria	Bacteria	162	2.24e-47	NR	WP_043840164.1	452982	g6522	i0	95.1	2.98785425101215	82	4	99.6	0	247	2	143	224	WP_043840164.1 NAD(P)-dependent oxidoreductase [Roseomonas aerilata]	diamond	738	162	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Acetobacterales	Roseomonadaceae	Muricoccus	Muricoccus aerilatus
31923839	31923839	PRJNA1103784_P_NODE_6617_length_246_cov_1.693642_g6562_i0	PRJNA1103784	6617	246	1.693642	4.16635932	Phyllobacterium	28100	Bacteria	Bacteria	107	1.17e-28	NR	WP_346305511.1	1871046	g6562	i0	98.2	1.39024390243902	57	1	69.5	0	244	74	7	63	WP_346305511.1 hypothetical protein [Phyllobacterium sp.]	diamond	342	107	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium sp.
32122658	32122658	PRJNA1103784_P_NODE_6558_length_247_cov_0.885057_g6503_i0	PRJNA1103784	6558	247	0.885057	2.18609079	Methylobacterium sp. J-	409	Bacteria	Bacteria	163	9.55e-45	NR	WP_243955673.1	2836648	g6503	i0	97.5	0.983805668016194	81	2	98.4	0	245	3	111	191	WP_243955673.1 glycoside hydrolase family 2 protein [Methylobacterium sp. J-067]	diamond	243	163	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae	Methylobacterium	Methylobacterium sp. J-067
32280903	32280903	PRJNA1103784_P_NODE_3719_length_289_cov_1.185185_g3664_i0	PRJNA1103784	3719	289	1.185185	3.42518465	Ketobacter sp.	2083498	Bacteria	Bacteria	78.2	2.18e-14	NR	MCP5019832.1	2083498	g3664	i0	44.4	0.934256055363322	90	49	93.4	1	12	281	407	495	MCP5019832.1 HAD-IC family P-type ATPase [Ketobacter sp.]	diamond	270	78.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Ketobacteraceae	Ketobacter	Ketobacter sp.
32280905	32280905	PRJNA1103784_P_NODE_5439_length_254_cov_1.596685_g5384_i0	PRJNA1103784	5439	254	1.596685	4.0555799	Brucella/Ochrobactrum group	2826938	Bacteria	Bacteria	54.3	4.01e-7	NR	WP_124915971.1	2826938	g5384	i0	56.9	0.602362204724409	51	22	60.2	0	100	252	1	51	WP_124915971.1 MULTISPECIES: hypothetical protein [Brucella/Ochrobactrum group]	diamond	153	54.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Brucellaceae
32375719	32375719	PRJNA1103784_P_NODE_7659_length_242_cov_0.911243_g7604_i0	PRJNA1103784	7659	242	0.911243	2.20520806	Phyllobacterium sp. NPDC	1871046	Bacteria	Bacteria	154	1.0599999999999999e-42	NR	WP_403176279.1	3364404	g7604	i0	96.3	0.991735537190083	80	3	99.2	0	242	3	364	443	WP_403176279.1 FAD-dependent oxidoreductase [Phyllobacterium sp. NPDC097923]	diamond	240	154	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium sp. NPDC097923
32565742	32565742	PRJNA1103784_P_NODE_6419_length_247_cov_1.402299_g6364_i0	PRJNA1103784	6419	247	1.402299	3.46367853	Paucibacter sp. Y2R2-4	2893553	Bacteria	Bacteria	152	1.1799999999999999e-43	NR	WP_263537713.1	2893553	g6364	i0	96.3	0.983805668016194	81	3	98.4	0	246	4	117	197	WP_263537713.1 hypothetical protein [Paucibacter sp. Y2R2-4]	diamond	243	152	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Roseateles	Paucibacter sp. Y2R2-4
32848795	32848795	PRJNA1103784_P_NODE_3780_length_288_cov_0.902326_g3725_i0	PRJNA1103784	3780	288	0.902326	2.59869888	Candidatus Parabeggiatoa sp. HSG14	3055593	Bacteria	Bacteria	87	1.73e-17	NR	WP_349647841.1	3055593	g3725	i0	44.6	2.88541666666667	83	46	86.5	0	259	11	328	410	WP_349647841.1 CHASE domain-containing protein [Candidatus Parabeggiatoa sp. HSG14]	diamond	831	87	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Thiotrichales	Thiotrichaceae	Candidatus Parabeggiatoa	Candidatus Parabeggiatoa sp. HSG14
32848796	32848796	PRJNA1103784_P_NODE_4340_length_275_cov_1.618812_g4285_i0	PRJNA1103784	4340	275	1.618812	4.451733	Pararhizobium sp.	1977563	Bacteria	Bacteria	145	8.48e-41	NR	WP_325438253.1	1977563	g4285	i0	91.5	0.774545454545455	71	6	77.5	0	273	61	230	300	WP_325438253.1 transposase, partial [Pararhizobium sp.]	diamond	213	145	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Rhizobiaceae	Pararhizobium	Pararhizobium 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);;