metadata: contig_metadata: 57 rows where analysis = "diamond", bioproject = "PRJNA1145574" and tax

57 rows where analysis = "diamond", bioproject = "PRJNA1145574" 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
288667	288667	PRJNA1145574_P_NODE_13701_length_245_cov_0.906977_g13517_i0	PRJNA1145574	13701	245	0.906977	2.22209365	Bacteria	2	Bacteria	Bacteria	165	1.33e-47	NR	NDG06736.1	1871070	g13517	i0	100	2.97551020408163	81	0	99.2	0	2	244	99	179	NDG06736.1 argininosuccinate lyase [Oxalobacteraceae bacterium]	diamond	729	165	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae		Oxalobacteraceae bacterium
288741	288741	PRJNA1145574_P_NODE_8661_length_292_cov_1.383562_g8477_i0	PRJNA1145574	8661	292	1.383562	4.04000104	Zavarzinia compransoris	1264899	Bacteria	Bacteria	184	9.17e-52	NR	WP_109921542.1	1264899	g8477	i0	100	2.98972602739726	97	0	99.7	0	291	1	741	837	WP_109921542.1 translation initiation factor IF-2 [Zavarzinia compransoris]	diamond	873	184	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodospirillales	Zavarziniaceae	Zavarzinia	Zavarzinia compransoris
2839461	2839461	PRJNA1145574_P_NODE_12123_length_250_cov_0.881356_g11939_i0	PRJNA1145574	12123	250	0.881356	2.20339	Betaproteobacteria bacterium	1891241	Bacteria	Bacteria	122	4.36e-33	NR	MEP6504837.1	1891241	g11939	i0	75	0.96	80	20	96	0	2	241	55	134	MEP6504837.1 LysE family translocator [Betaproteobacteria bacterium]	diamond	240	122	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria				Betaproteobacteria bacterium
5391818	5391818	PRJNA1145574_P_NODE_10725_length_256_cov_1.448087_g10541_i0	PRJNA1145574	10725	256	1.448087	3.70710272	Simplicispira	352450	Bacteria	Bacteria	141	2.61e-41	NR	HCE30156.1	1871071	g10541	i0	84.5	6.890625	84	13	98.4	0	2	253	6	89	HCE30156.1 LacI family transcriptional regulator [Comamonadaceae bacterium]	diamond	1764	141	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae		Comamonadaceae bacterium
6666529	6666529	PRJNA1145574_P_NODE_12146_length_250_cov_0.881356_g11962_i0	PRJNA1145574	12146	250	0.881356	2.20339	Bacteria	2	Bacteria	Bacteria	86.3	1.82e-17	NR	MDE2474611.1	1913988	g11962	i0	90.4	1.248	52	5	62.4	0	174	19	1	52	MDE2474611.1 RNA polymerase factor sigma-54 [Alphaproteobacteria bacterium]	diamond	312	86.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria				Alphaproteobacteria bacterium
6666634	6666634	PRJNA1145574_P_NODE_986_length_839_cov_1.309399_g828_i0	PRJNA1145574	986	839	1.309399	10.98585761	Bacteria	2	Bacteria	Bacteria	165	1.4899999999999999e-47	NR	EBX4971012.1	600	g828	i0	70.1	1.67342073897497	117	34	41.5	1	837	490	24	140	EBX4971012.1 hypothetical protein [Salmonella enterica subsp. enterica serovar Thompson]	diamond	1404	165	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Salmonella	Salmonella enterica
7941668	7941668	PRJNA1145574_P_NODE_11307_length_252_cov_0.871508_g11123_i0	PRJNA1145574	11307	252	0.871508	2.19620016	Vogesella mureinivorans	657276	Bacteria	Bacteria	166	5.75e-49	NR	WP_147695802.1	657276	g11123	i0	96.4	0.988095238095238	83	3	98.8	0	250	2	177	259	WP_147695802.1 glutathione-dependent disulfide-bond oxidoreductase [Vogesella mureinivorans]	diamond	249	166	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Chromobacteriaceae	Vogesella	Vogesella mureinivorans
10492376	10492376	PRJNA1145574_P_NODE_889_length_880_cov_1.815366_g735_i0	PRJNA1145574	889	880	1.815366	15.9752208	Citrobacter portucalensis	1639133	Bacteria	Bacteria	234	4.39e-73	NR	WP_319846319.1	1639133	g735	i0	67.3	1.16590909090909	171	56	58.3	0	880	368	71	241	WP_319846319.1 hypothetical protein [Citrobacter portucalensis]	diamond	1026	234	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Citrobacter	Citrobacter portucalensis
16865802	16865802	PRJNA1145574_P_NODE_1454_length_688_cov_1.643902_g1276_i0	PRJNA1145574	1454	688	1.643902	11.31004576	Salmonella enterica	28901	Bacteria	Bacteria	179	1.4e-53	NR	EJB4242367.1	28901	g1276	i0	59.6	1.88808139534884	146	57	63.2	2	65	499	1	145	EJB4242367.1 cell wall hydrolase [Salmonella enterica]	diamond	1299	179	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Salmonella	Salmonella enterica
19414718	19414718	PRJNA1145574_P_NODE_14216_length_244_cov_0.912281_g14032_i0	PRJNA1145574	14216	244	0.912281	2.22596564	Comamonadaceae bacterium	1871071	Bacteria	Bacteria	151	9.589999999999999e-43	NR	MCE2878117.1	1871071	g14032	i0	93.4	0.934426229508197	76	5	93.4	0	2	229	257	332	MCE2878117.1 MBL fold metallo-hydrolase [Comamonadaceae bacterium]	diamond	228	151	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae		Comamonadaceae bacterium
20690124	20690124	PRJNA1145574_P_NODE_13297_length_247_cov_0.896552_g13113_i0	PRJNA1145574	13297	247	0.896552	2.21448344	Betaproteobacteria bacterium	1891241	Bacteria	Bacteria	151	3.97e-45	NR	MBM3338702.1	1891241	g13113	i0	93.9	0.995951417004049	82	5	99.6	0	1	246	20	101	MBM3338702.1 50S ribosomal protein L15 [Betaproteobacteria bacterium]	diamond	246	151	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria				Betaproteobacteria bacterium
20690216	20690216	PRJNA1145574_P_NODE_8277_length_300_cov_0.969163_g8093_i0	PRJNA1145574	8277	300	0.969163	2.907489	Citrobacter portucalensis	1639133	Bacteria	Bacteria	188	3.31e-53	NR	WP_319846420.1	1639133	g8093	i0	88.9	4.95	99	11	99	0	298	2	594	692	WP_319846420.1 DNA polymerase [Citrobacter portucalensis]	diamond	1485	188	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Citrobacter	Citrobacter portucalensis
23241008	23241008	PRJNA1145574_P_NODE_1199_length_754_cov_1.659325_g1032_i0	PRJNA1145574	1199	754	1.659325	12.5113105	root	1	Root_unresolved	Root_unresolved	244	1.52e-74	NR	EOO0559612.1	562	g1032	i0	87	2.93236074270557	123	16	48.9	0	2	370	368	490	EOO0559612.1 anaerobic ribonucleoside-triphosphate reductase [Escherichia coli]	diamond	2211	244	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
24514528	24514528	PRJNA1145574_P_NODE_13620_length_246_cov_0.884393_g13436_i0	PRJNA1145574	13620	246	0.884393	2.17560678	Burkholderiales bacterium	1891238	Bacteria	Bacteria	166	2.56e-46	NR	HTM61657.1	1891238	g13436	i0	97.5	0.98780487804878	81	2	98.8	0	245	3	228	308	HTM61657.1 ABC transporter substrate-binding protein [Burkholderiales bacterium]	diamond	243	166	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales			Burkholderiales bacterium
26817570	26817570	PRJNA1145574_P_NODE_11641_length_251_cov_0.876404_g11457_i0	PRJNA1145574	11641	251	0.876404	2.19977404	Betaproteobacteria bacterium	1891241	Bacteria	Bacteria	116	1.34e-30	NR	NBQ86518.1	1891241	g11457	i0	75.6	0.932270916334661	78	19	93.2	0	14	247	1	78	NBQ86518.1 hypothetical protein [Betaproteobacteria bacterium]	diamond	234	116	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria				Betaproteobacteria bacterium
26849223	26849223	PRJNA1145574_P_NODE_14821_length_242_cov_0.923077_g14637_i0	PRJNA1145574	14821	242	0.923077	2.23384634	Pandoraea sputorum	93222	Bacteria	Bacteria	41.2	0.0406	NR	VVE77358.1	93222	g14637	i0	37.5	0.694214876033058	56	30	69.4	1	194	27	57	107	VVE77358.1 membrane protein [Pandoraea sputorum]	diamond	168	41.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Pandoraea	Pandoraea sputorum
26932915	26932915	PRJNA1145574_P_NODE_10322_length_263_cov_1.642105_g10138_i0	PRJNA1145574	10322	263	1.642105	4.31873615	root	1	Root_unresolved	Root_unresolved	107	3.0800000000000004e-27	NR	WP_349043629.1	29459	g10138	i0	66.2	6.20532319391635	68	23	77.6	0	58	261	1	68	WP_349043629.1 ribonuclease H family protein [Brucella melitensis]	diamond	1632	107	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Brucellaceae	Brucella	Brucella melitensis
27102069	27102069	PRJNA1145574_P_NODE_10982_length_253_cov_0.866667_g10798_i0	PRJNA1145574	10982	253	0.866667	2.19266751	Rhizomicrobium sp.	1978228	Bacteria	Bacteria	159	4.62e-43	NR	HET7084869.1	1978228	g10798	i0	92.9	0.99604743083004	84	6	99.6	0	252	1	53	136	HET7084869.1 TonB-dependent receptor [Rhizomicrobium sp.]	diamond	252	159	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Micropepsales	Micropepsaceae	Rhizomicrobium	Rhizomicrobium sp.
27133399	27133399	PRJNA1145574_P_NODE_12282_length_249_cov_1.750000_g12098_i0	PRJNA1145574	12282	249	1.75	4.3575	Agrobacterium vitis	373	Bacteria	Bacteria	42.7	0.0221	NR	MBB4952410.1	373	g12098	i0	38.6	0.530120481927711	44	27	53	0	118	249	32	75	MBB4952410.1 hypothetical protein [Agrobacterium vitis]	diamond	132	42.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Rhizobiaceae	Agrobacterium	Agrobacterium vitis
27260273	27260273	PRJNA1145574_P_NODE_10983_length_253_cov_0.866667_g10799_i0	PRJNA1145574	10983	253	0.866667	2.19266751	Aquabacterium sp.	1872578	Bacteria	Bacteria	42.4	0.0444	NR	MDH4393850.1	1872578	g10799	i0	33.3	0.640316205533597	54	31	64	1	17	178	119	167	MDH4393850.1 hypothetical protein [Aquabacterium sp.]	diamond	162	42.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Aquabacterium	Aquabacterium sp.
27260276	27260276	PRJNA1145574_P_NODE_1663_length_641_cov_1.517606_g1484_i0	PRJNA1145574	1663	641	1.517606	9.72785446	Citrobacter portucalensis	1639133	Bacteria	Bacteria	266	8.929999999999998e-87	NR	WP_319846309.1	1639133	g1484	i0	66.4	1.99375975039002	214	70	99.7	2	2	640	9	221	WP_319846309.1 hypothetical protein [Citrobacter portucalensis]	diamond	1278	266	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Citrobacter	Citrobacter portucalensis
27576090	27576090	PRJNA1145574_P_NODE_1884_length_602_cov_1.032136_g1703_i0	PRJNA1145574	1884	602	1.032136	6.21345872	Brucella melitensis	29459	Bacteria	Bacteria	147	3.2299999999999993e-40	NR	WP_349043648.1	29459	g1703	i0	74	2.44186046511628	96	25	47.8	0	290	3	4	99	WP_349043648.1 hypothetical protein [Brucella melitensis]	diamond	1470	147	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Brucellaceae	Brucella	Brucella melitensis
27797274	27797274	PRJNA1145574_P_NODE_11824_length_251_cov_0.876404_g11640_i0	PRJNA1145574	11824	251	0.876404	2.19977404	Novosphingobium sp.	1874826	Bacteria	Bacteria	47	0.00118	NR	MCB2063654.1	1874826	g11640	i0	37.5	0.764940239043825	64	33	68.1	2	220	50	139	202	MCB2063654.1 amidohydrolase family protein [Novosphingobium sp.]	diamond	192	47	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Novosphingobium	Novosphingobium sp.
27860092	27860092	PRJNA1145574_P_NODE_10285_length_264_cov_1.287958_g10101_i0	PRJNA1145574	10285	264	1.287958	3.40020912	Amnimonas aquatica	2094561	Bacteria	Bacteria	75.1	1.41e-13	NR	WP_105191560.1	2094561	g10101	i0	97.5	0.454545454545455	40	1	45.5	0	262	143	320	359	WP_105191560.1 aminoglycoside phosphotransferase family protein [Amnimonas aquatica]	diamond	120	75.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Amnimonas	Amnimonas aquatica
27955010	27955010	PRJNA1145574_P_NODE_2365_length_532_cov_1.348584_g2183_i0	PRJNA1145574	2365	532	1.348584	7.17446688	Brucella melitensis	29459	Bacteria	Bacteria	69.7	2.06e-11	NR	WP_349043629.1	29459	g2183	i0	60	0.31015037593985	55	22	31	0	531	367	104	158	WP_349043629.1 ribonuclease H family protein [Brucella melitensis]	diamond	165	69.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Brucellaceae	Brucella	Brucella melitensis
28070162	28070162	PRJNA1145574_P_NODE_5605_length_359_cov_1.363636_g5421_i0	PRJNA1145574	5605	359	1.363636	4.89545324	root	1	Root_unresolved	Root_unresolved	148	1.67e-42	NR	EJO9576627.1	28901	g5421	i0	59.5	4.69637883008357	121	45	98.6	2	2	355	56	175	EJO9576627.1 ribonucleotide-diphosphate reductase subunit beta [Salmonella enterica]	diamond	1686	149	0.993288590604027	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Salmonella	Salmonella enterica
28081163	28081163	PRJNA1145574_P_NODE_1285_length_729_cov_1.538110_g1118_i0	PRJNA1145574	1285	729	1.53811	11.2128219	Brucella melitensis	29459	Bacteria	Bacteria	179	1.12e-53	NR	WP_349043560.1	29459	g1118	i0	68.8	2.10699588477366	128	40	52.7	0	1	384	11	138	WP_349043560.1 hypothetical protein [Brucella melitensis]	diamond	1536	179	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Brucellaceae	Brucella	Brucella melitensis
28238926	28238926	PRJNA1145574_P_NODE_14466_length_243_cov_0.917647_g14282_i0	PRJNA1145574	14466	243	0.917647	2.22988221	Pseudomonas sp. DCB_BG	2993595	Bacteria	Bacteria	42	0.0172	NR	WP_265980552.1	2993595	g14282	i0	36.8	0.703703703703704	57	34	67.9	1	188	24	37	93	WP_265980552.1 hypothetical protein, partial [Pseudomonas sp. DCB_BG]	diamond	171	42	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas sp. DCB_BG
28270506	28270506	PRJNA1145574_P_NODE_5546_length_361_cov_1.034722_g5362_i0	PRJNA1145574	5546	361	1.034722	3.73534642	Neisseria meningitidis	487	Bacteria	Bacteria	188	3.84e-59	NR	MBW3909050.1	487	g5362	i0	99	0.814404432132964	98	1	81.4	0	2	295	42	139	MBW3909050.1 hypothetical protein [Neisseria meningitidis]	diamond	294	188	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Neisseria	Neisseria meningitidis
28365237	28365237	PRJNA1145574_P_NODE_4826_length_382_cov_2.000000_g4642_i0	PRJNA1145574	4826	382	2	7.64	Citrobacter freundii complex	1344959	Bacteria	Bacteria	116	8.22e-30	NR	WP_015989812.1	1344959	g4642	i0	72.6	1.71989528795812	73	20	57.3	0	2	220	132	204	WP_015989812.1 hypothetical protein [Citrobacter portucalensis]	diamond	657	116	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Citrobacter
28397002	28397002	PRJNA1145574_P_NODE_9006_length_286_cov_2.093897_g8822_i0	PRJNA1145574	9006	286	2.093897	5.98854542	Stellaceae bacterium	2910174	Bacteria	Bacteria	91.7	4.09e-19	NR	HVB15548.1	2910174	g8822	i0	63.6	1.61538461538462	77	26	80.8	1	286	56	462	536	HVB15548.1 NF038122 family metalloprotease [Stellaceae bacterium]	diamond	462	91.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodospirillales	Stellaceae		Stellaceae bacterium
28460343	28460343	PRJNA1145574_P_NODE_6466_length_338_cov_1.037736_g6282_i0	PRJNA1145574	6466	338	1.037736	3.50754768	Citrobacter portucalensis	1639133	Bacteria	Bacteria	129	4.53e-34	NR	WP_319846332.1	1639133	g6282	i0	58.2	1.95266272189349	110	46	97.6	0	333	4	17	126	WP_319846332.1 hypothetical protein [Citrobacter portucalensis]	diamond	660	129	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Citrobacter	Citrobacter portucalensis
28523410	28523410	PRJNA1145574_P_NODE_3367_length_446_cov_1.463807_g3183_i0	PRJNA1145574	3367	446	1.463807	6.52857922	Salmonella enterica	28901	Bacteria	Bacteria	189	7.459999999999998e-55	NR	EJB4242426.1	28901	g3183	i0	68.7	2.01121076233184	150	44	99.6	2	1	444	272	420	EJB4242426.1 Ig-like domain-containing protein [Salmonella enterica]	diamond	897	189	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Salmonella	Salmonella enterica
28618169	28618169	PRJNA1145574_P_NODE_11547_length_252_cov_0.871508_g11363_i0	PRJNA1145574	11547	252	0.871508	2.19620016	Pelomonas aquatica	431058	Bacteria	Bacteria	142	1.87e-37	NR	WP_268147823.1	431058	g11363	i0	84.3	0.988095238095238	83	13	98.8	0	250	2	258	340	WP_268147823.1 TonB-dependent receptor domain-containing protein [Pelomonas aquatica]	diamond	249	142	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Roseateles	Pelomonas aquatica
28618172	28618172	PRJNA1145574_P_NODE_5747_length_355_cov_1.638298_g5563_i0	PRJNA1145574	5747	355	1.638298	5.8159579	Brucella melitensis	29459	Bacteria	Bacteria	154	1.35e-40	NR	WP_349043811.1	29459	g5563	i0	67.5	0.988732394366197	117	35	98	2	353	6	695	809	WP_349043811.1 phage tail protein [Brucella melitensis]	diamond	351	154	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Brucellaceae	Brucella	Brucella melitensis
29175471	29175471	PRJNA1145574_P_NODE_4929_length_379_cov_1.529412_g4745_i0	PRJNA1145574	4929	379	1.529412	5.79647148	root	1	Root_unresolved	Root_unresolved	68.9	2.31e-12	NR	EJB4242341.1	28901	g4745	i0	53.8	1.82058047493404	65	30	51.5	0	379	185	18	82	EJB4242341.1 hypothetical protein [Salmonella enterica]	diamond	690	68.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Salmonella	Salmonella enterica
29533676	29533676	PRJNA1145574_P_NODE_5190_length_371_cov_1.308725_g5006_i0	PRJNA1145574	5190	371	1.308725	4.85536975	Brucella melitensis	29459	Bacteria	Bacteria	175	7.7199999999999995e-53	NR	WP_349043587.1	29459	g5006	i0	69.9	1.98921832884097	123	36	99.5	1	3	371	45	166	WP_349043587.1 hypothetical protein [Brucella melitensis]	diamond	738	175	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Brucellaceae	Brucella	Brucella melitensis
29596453	29596453	PRJNA1145574_P_NODE_550_length_1119_cov_1.713193_g432_i0	PRJNA1145574	550	1119	1.713193	19.17062967	Edwardsiella tarda	636	Bacteria	Bacteria	222	4.18e-61	NR	WP_302528270.1	636	g432	i0	52.6	0.560321715817694	209	93	55.8	2	125	748	448	651	WP_302528270.1 pyocin knob domain-containing S74 family peptidase [Edwardsiella tarda]	diamond	627	222	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Hafniaceae	Edwardsiella	Edwardsiella tarda
29711672	29711672	PRJNA1145574_P_NODE_12290_length_249_cov_1.329545_g12106_i0	PRJNA1145574	12290	249	1.329545	3.31056705	Bacteria	2	Bacteria	Bacteria	87	1.01e-17	NR	EBX7861880.1	58096	g12106	i0	64.2	3.07228915662651	95	19	96.4	1	245	6	508	602	EBX7861880.1 phage tail protein [Salmonella enterica subsp. enterica serovar Bareilly]	diamond	765	87	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Salmonella	Salmonella enterica
29912768	29912768	PRJNA1145574_P_NODE_1411_length_698_cov_1.900800_g1235_i0	PRJNA1145574	1411	698	1.9008	13.267584	Kosakonia cowanii	208223	Bacteria	Bacteria	58.2	3.53e-7	NR	TNL04528.1	208223	g1235	i0	39.4	0.305157593123209	71	43	30.5	0	352	564	5	75	TNL04528.1 hypothetical protein CYD30_23540 [Kosakonia cowanii]	diamond	213	58.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Kosakonia	Kosakonia cowanii
29996449	29996449	PRJNA1145574_P_NODE_3491_length_439_cov_1.278689_g3307_i0	PRJNA1145574	3491	439	1.278689	5.61344471	Bacteria	2	Bacteria	Bacteria	128	1.14e-34	NR	WP_319846421.1	1224	g3307	i0	60.4	1.38041002277904	101	39	69	1	437	135	66	165	WP_319846421.1 MULTISPECIES: hypothetical protein [Pseudomonadota]	diamond	606	128	1	Bacteria	Pseudomonadati	Pseudomonadota
30028021	30028021	PRJNA1145574_P_NODE_1651_length_643_cov_1.915789_g1472_i0	PRJNA1145574	1651	643	1.915789	12.31852327	root	1	Root_unresolved	Root_unresolved	206	1.27e-59	NR	WP_349043909.1	29459	g1472	i0	51.9	8.9253499222395	210	94	94.7	3	611	3	6	215	WP_349043909.1 hypothetical protein [Brucella melitensis]	diamond	5739	206	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Brucellaceae	Brucella	Brucella melitensis
30217363	30217363	PRJNA1145574_P_NODE_1652_length_643_cov_1.505263_g1473_i0	PRJNA1145574	1652	643	1.505263	9.67884109	root	1	Root_unresolved	Root_unresolved	151	3.04e-39	NR	WP_349043975.1	29459	g1473	i0	69.4	1.00777604976672	108	33	50.4	0	327	4	1	108	WP_349043975.1 DnaB-like helicase C-terminal domain-containing protein [Brucella melitensis]	diamond	648	151	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Brucellaceae	Brucella	Brucella melitensis
30691305	30691305	PRJNA1145574_P_NODE_6093_length_346_cov_1.714286_g5909_i0	PRJNA1145574	6093	346	1.714286	5.93142956	root	1	Root_unresolved	Root_unresolved	107	2.83e-26	NR	WP_015989712.1	1639133	g5909	i0	74.2	2.15895953757225	62	16	53.8	0	18	203	167	228	WP_015989712.1 hypothetical protein [Citrobacter portucalensis]	diamond	747	107	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Citrobacter	Citrobacter portucalensis
30722864	30722864	PRJNA1145574_P_NODE_13734_length_245_cov_0.906977_g13550_i0	PRJNA1145574	13734	245	0.906977	2.22209365	Bacteria	2	Bacteria	Bacteria	103	4.15e-27	NR	NDG07651.1	1871070	g13550	i0	98.1	3.96734693877551	54	1	66.1	0	164	3	1	54	NDG07651.1 HTH domain-containing protein [Oxalobacteraceae bacterium]	diamond	972	103	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae		Oxalobacteraceae bacterium
31176110	31176110	PRJNA1145574_P_NODE_14215_length_244_cov_0.912281_g14031_i0	PRJNA1145574	14215	244	0.912281	2.22596564	Methylorubrum extorquens	408	Bacteria	Bacteria	96.3	9.9e-22	NR	WP_253369352.1	408	g14031	i0	69.1	1.67213114754098	68	21	83.6	0	41	244	187	254	WP_253369352.1 helix-turn-helix transcriptional regulator [Methylorubrum extorquens]	diamond	408	96.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae	Methylorubrum	Methylorubrum extorquens
31207538	31207538	PRJNA1145574_P_NODE_2555_length_511_cov_1.632420_g2373_i0	PRJNA1145574	2555	511	1.63242	8.3416662	Citrobacter portucalensis	1639133	Bacteria	Bacteria	241	5.29e-75	NR	WP_319846422.1	1639133	g2373	i0	68.2	3.99217221135029	170	54	99.8	0	510	1	231	400	WP_319846422.1 DEAD/DEAH box helicase [Citrobacter portucalensis]	diamond	2040	241	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Citrobacter	Citrobacter portucalensis
31386804	31386804	PRJNA1145574_P_NODE_11076_length_253_cov_0.866667_g10892_i0	PRJNA1145574	11076	253	0.866667	2.19266751	Bacteria	2	Bacteria	Bacteria	94.4	1.33e-22	NR	MFN5152375.1	1891238	g10892	i0	100	1.09090909090909	46	0	54.5	0	3	140	88	133	MFN5152375.1 hypothetical protein [Burkholderiales bacterium]	diamond	276	94.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales			Burkholderiales bacterium
31797629	31797629	PRJNA1145574_P_NODE_11397_length_252_cov_0.871508_g11213_i0	PRJNA1145574	11397	252	0.871508	2.19620016	Pseudomonadati	3379134	Bacteria	Bacteria	166	1.4299999999999999e-47	NR	NDE94218.1	1891241	g11213	i0	91.7	4	84	7	100	0	252	1	120	203	NDE94218.1 hypothetical protein [Betaproteobacteria bacterium]	diamond	1008	167	0.994011976047904	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria				Betaproteobacteria bacterium
31808962	31808962	PRJNA1145574_P_NODE_1217_length_748_cov_1.155556_g1050_i0	PRJNA1145574	1217	748	1.155556	8.64355888	Pseudomonadota	1224	Bacteria	Bacteria	340	1.63e-114	NR	WP_319846428.1	1224	g1050	i0	70.3	0.998663101604278	249	68	99.9	1	2	748	18	260	WP_319846428.1 MULTISPECIES: 5'-3' exonuclease H3TH domain-containing protein [Pseudomonadota]	diamond	747	340	1	Bacteria	Pseudomonadati	Pseudomonadota
31872157	31872157	PRJNA1145574_P_NODE_6057_length_347_cov_1.740876_g5873_i0	PRJNA1145574	6057	347	1.740876	6.04083972	Escherichia coli	562	Bacteria	Bacteria	211	7.670000000000001e-64	NR	EOO0559612.1	562	g5873	i0	83.5	4.97118155619597	115	19	99.4	0	347	3	249	363	EOO0559612.1 anaerobic ribonucleoside-triphosphate reductase [Escherichia coli]	diamond	1725	211	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
31903793	31903793	PRJNA1145574_P_NODE_11537_length_252_cov_0.871508_g11353_i0	PRJNA1145574	11537	252	0.871508	2.19620016	Phyllobacterium myrsinacearum	28101	Bacteria	Bacteria	157	1.12e-46	NR	WP_105734190.1	28101	g11353	i0	96.4	1.92857142857143	83	3	98.8	0	2	250	11	93	WP_105734190.1 DsbE family thiol:disulfide interchange protein [Phyllobacterium myrsinacearum]	diamond	486	157	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Phyllobacteriaceae	Phyllobacterium	Phyllobacterium myrsinacearum
32030528	32030528	PRJNA1145574_P_NODE_10498_length_260_cov_1.668449_g10314_i0	PRJNA1145574	10498	260	1.668449	4.3379674	Brucella melitensis	29459	Bacteria	Bacteria	124	1.16e-33	NR	WP_349043630.1	29459	g10314	i0	64	0.992307692307692	86	31	99.2	0	259	2	35	120	WP_349043630.1 hypothetical protein [Brucella melitensis]	diamond	258	124	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Brucellaceae	Brucella	Brucella melitensis
32050958	32050958	PRJNA1145574_P_NODE_10998_length_253_cov_0.866667_g10814_i0	PRJNA1145574	10998	253	0.866667	2.19266751	Bacteria	2	Bacteria	Bacteria	168	1.06e-47	NR	MFN5811693.1	1891238	g10814	i0	98.8	3.98418972332016	84	1	99.6	0	2	253	223	306	MFN5811693.1 glycine--tRNA ligase subunit beta [Burkholderiales bacterium]	diamond	1008	169	0.994082840236686	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales			Burkholderiales bacterium
32220315	32220315	PRJNA1145574_P_NODE_9898_length_271_cov_1.575758_g9714_i0	PRJNA1145574	9898	271	1.575758	4.27030418	Neisseria meningitidis	487	Bacteria	Bacteria	136	4.24e-39	NR	WP_219227383.1	487	g9714	i0	94.1	2.25830258302583	68	4	75.3	0	66	269	1	68	WP_219227383.1 hemoglobin beta-like protein, partial [Neisseria meningitidis]	diamond	612	136	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Neisseria	Neisseria meningitidis
32283840	32283840	PRJNA1145574_P_NODE_11079_length_253_cov_0.866667_g10895_i0	PRJNA1145574	11079	253	0.866667	2.19266751	Alphaproteobacteria bacterium	1913988	Bacteria	Bacteria	157	1.59e-42	NR	MBM3627046.1	1913988	g10895	i0	95.2	0.99604743083004	84	4	99.6	0	1	252	190	273	MBM3627046.1 efflux RND transporter permease subunit [Alphaproteobacteria bacterium]	diamond	252	157	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria				Alphaproteobacteria bacterium
32788549	32788549	PRJNA1145574_P_NODE_10960_length_253_cov_0.866667_g10776_i0	PRJNA1145574	10960	253	0.866667	2.19266751	Burkholderiales bacterium	1891238	Bacteria	Bacteria	102	4.21e-26	NR	MCF8192183.1	1891238	g10776	i0	98.1	0.616600790513834	52	1	61.7	0	158	3	1	52	MCF8192183.1 hypothetical protein [Burkholderiales bacterium]	diamond	156	102	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales			Burkholderiales 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);;