metadata: contig_metadata: 66 rows where bioproject = "PRJNA699078" and tax

66 rows where bioproject = "PRJNA699078" 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
1184145	1184145	PRJNA699078_S_NODE_99221_length_168_cov_0.873950_g98272_i0	PRJNA699078	99221	168	0.87395	1.468236	Variovorax	34072	Bacteria	Bacteria	294	2.12e-75	NTclustered	gi\|1913357307\|gb\|CP062121.1\|	2774875	g98272	i0	98.214	16.8392857142857	168	3	100	0	1	168	576786	576953	Variovorax sp. 38R chromosome, complete genome	blastn	2829	294	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax sp. 38R
1958936	1958936	PRJNA699078_S_NODE_89822_length_176_cov_2.062992_g88873_i0	PRJNA699078	89822	176	2.062992	3.63086592	Methylorubrum extorquens	408	Bacteria	Bacteria	78.7	2.45e-10	NTclustered	gi\|240011718\|gb\|CP001511.1\|	272630	g88873	i0	82.796	0.528409090909091	93	10	51	6	42	131	270939	270850	Methylobacterium extorquens AM1 megaplasmid, complete sequence	blastn	93	78.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae	Methylorubrum	Methylorubrum extorquens
3232995	3232995	PRJNA699078_S_NODE_29863_length_315_cov_2.548872_g28914_i0	PRJNA699078	29863	315	2.548872	8.0289468	Delftia acidovorans	80866	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|1943113412\|gb\|CP065627.1\|	80866	g28914	i0	100	0.0888888888888889	28	0	9	0	250	277	3911761	3911788	Delftia acidovorans strain FDAARGOS_939 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Delftia	Delftia acidovorans
3233091	3233091	PRJNA699078_S_NODE_36263_length_287_cov_3.289916_g35314_i0	PRJNA699078	36263	287	3.289916	9.44205892	Sphingopyxis sp. EG6	1874061	Bacteria	Bacteria	364	2.9999999999999993e-96	NTclustered	gi\|1417740650\|dbj\|AP017603.1\|	1874061	g35314	i0	91.078	0.937282229965157	269	24	94	0	19	287	1548932	1548664	Sphingopyxis sp. EG6 DNA, complete genome	blastn	269	364	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingopyxis	Sphingopyxis sp. EG6
3233769	3233769	PRJNA699078_S_NODE_79203_length_189_cov_1.057143_g78254_i0	PRJNA699078	79203	189	1.057143	1.99800027	Variovorax sp. Varisp41	3243033	Bacteria	Bacteria	150	5.59e-32	NTclustered	gi\|2897244045\|gb\|CP168540.1\|	3243033	g78254	i0	88.618	0.835978835978836	123	14	65	0	1	123	6725647	6725769	Variovorax sp. Varisp41 strain CT11-41 chromosome 1, complete sequence	blastn	158	150	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax sp. Varisp41
5012391	5012391	PRJNA699078_S_NODE_36724_length_285_cov_4.834746_g35775_i0	PRJNA699078	36724	285	4.834746	13.7790261	Xanthomonas	338	Bacteria	Bacteria	62.1	4.37e-5	NTclustered	gi\|2786213386\|gb\|CP162490.1\|	3160839	g35775	i0	92.857	1.82456140350877	42	3	15	0	128	169	658725	658766	Xanthomonas sp. DAR 34887 chromosome, complete genome	blastn	520	62.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Xanthomonas	Xanthomonas tesorieronis
5786457	5786457	PRJNA699078_S_NODE_91205_length_175_cov_1.238095_g90256_i0	PRJNA699078	91205	175	1.238095	2.16666625	Variovorax paradoxus	34073	Bacteria	Bacteria	307	2.8500000000000004e-79	NTclustered	gi\|2921529653\|gb\|CP157635.1\|	34073	g90256	i0	98.286	1	175	3	100	0	1	175	227	401	Variovorax paradoxus strain 110B chromosome 2, complete sequence	blastn	175	307	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax paradoxus
5786512	5786512	PRJNA699078_S_NODE_95445_length_171_cov_1.008197_g94496_i0	PRJNA699078	95445	171	1.008197	1.72401687	Burkholderiales bacterium YL45	1834205	Bacteria	Bacteria	315	1.65e-81	NTclustered	gi\|1173528573\|gb\|CP015403.2\|	1834205	g94496	i0	100	269.315789473684	170	0	99	0	2	171	751216	751047	Burkholderiales bacterium YL45 chromosome, complete genome	blastn	46053	315	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales			Burkholderiales bacterium YL45
7060814	7060814	PRJNA699078_S_NODE_44186_length_259_cov_1.695238_g43237_i0	PRJNA699078	44186	259	1.695238	4.39066642	Variovorax guangxiensis	1775474	Bacteria	Bacteria	155	1.28e-43	NR	RUR71902.1	1775474	g43237	i0	89.4	0.984555984555985	85	9	98.5	0	257	3	31	115	RUR71902.1 3-deoxy-7-phosphoheptulonate synthase [Variovorax guangxiensis]	diamond	255	155	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax guangxiensis
7061358	7061358	PRJNA699078_S_NODE_78906_length_189_cov_1.485714_g77957_i0	PRJNA699078	78906	189	1.485714	2.80799946	Stappiaceae bacterium	2952973	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|2891482222\|emb\|OZ219955.1\|	2952973	g77957	i0	100	0.592592592592593	28	0	15	0	16	43	59895	59868	MAG: Stappiaceae bacterium isolate 2e4ab203-d541-464b-9f6f-4552e35f8f23 genome assembly, chromosome: 4	blastn	112	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Stappiaceae		Stappiaceae bacterium
7061637	7061637	PRJNA699078_S_NODE_97886_length_169_cov_0.866667_g96937_i0	PRJNA699078	97886	169	0.866667	1.46466723	Variovorax sp. PAMC26660	2762322	Bacteria	Bacteria	263	5.989999999999999e-66	NTclustered	gi\|1896689433\|gb\|CP060295.1\|	2762322	g96937	i0	94.675	47.6272189349112	169	9	100	0	1	169	4309482	4309314	Variovorax sp. PAMC26660 chromosome, complete genome	blastn	8049	263	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax sp. PAMC26660
9610873	9610873	PRJNA699078_S_NODE_54408_length_231_cov_1.582418_g53459_i0	PRJNA699078	54408	231	1.582418	3.65538558	Rhizobium tumorigenes	2041385	Bacteria	Bacteria	309	1.11e-79	NTclustered	gi\|2490899830\|gb\|CP117255.1\|	2041385	g53459	i0	91.189	168.935064935065	227	20	98	0	1	227	2665181	2665407	Rhizobium tumorigenes strain 1078 chromosome, complete genome	blastn	39024	309	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Rhizobiaceae	Rhizobium	Rhizobium tumorigenes
10887019	10887019	PRJNA699078_S_NODE_89249_length_177_cov_1.375000_g88300_i0	PRJNA699078	89249	177	1.375	2.43375	Sphingomonas aliaeris	2759526	Bacteria	Bacteria	285	1.3499999999999998e-72	NTclustered	gi\|1958866958\|gb\|CP061037.1\|	2759526	g88300	i0	96	1.92655367231638	175	7	99	0	1	175	110612	110786	Sphingomonas aliaeris strain DH-S5 plasmid punnamed2, complete sequence	blastn	341	285	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas aliaeris
11387665	11387665	PRJNA699078_S_NODE_19829_length_374_cov_11.027692_g18880_i0	PRJNA699078	19829	374	11.027692	41.24356808	Pseudomonadaceae	135621	Bacteria	Bacteria	640	5.969999999999999e-179	NTclustered	gi\|2798691846\|gb\|CP166923.2\|	301	g18880	i0	99.713	492.708556149733	349	1	93	0	1	349	1100307	1099959	Ectopseudomonas oleovorans strain ERA chromosome, complete genome	blastn	184273	645	0.992248062015504	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Ectopseudomonas	Ectopseudomonas oleovorans
12663585	12663585	PRJNA699078_S_NODE_107430_length_162_cov_1.504425_g106481_i0	PRJNA699078	107430	162	1.504425	2.4371685	Pseudomonadaceae	135621	Bacteria	Bacteria	294	2.03e-75	NTclustered	gi\|1539751175\|emb\|LR134290.1\|	300	g106481	i0	99.383	467.746913580247	162	1	100	0	1	162	4441585	4441424	Pseudomonas mendocina strain NCTC10897 genome assembly, chromosome: 1	blastn	75775	294	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Ectopseudomonas	Ectopseudomonas mendocina
12663607	12663607	PRJNA699078_S_NODE_3450_length_712_cov_2.457014_g2775_i0	PRJNA699078	3450	712	2.457014	17.49393968	Enterobacteriaceae	543	Bacteria	Bacteria	1315	0	NTclustered	gi\|2588984424\|gb\|CP135658.1\|	562	g2775	i0	100	687.772471910112	712	0	100	0	1	712	1525226	1525937	Escherichia coli strain TUM10008 chromosome, complete genome	blastn	489694	1315	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
12663632	12663632	PRJNA699078_S_NODE_74310_length_195_cov_1.842466_g73361_i0	PRJNA699078	74310	195	1.842466	3.5928087	root	1	Root_unresolved	Root_unresolved	361	2.46e-95	NTclustered	gi\|1370526425\|gb\|CP027376.1\|	562	g73361	i0	100	336.564102564103	195	0	100	0	1	195	2409891	2409697	Escherichia coli strain 2013C-4404 chromosome, complete genome	blastn	65630	361	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
12663643	12663643	PRJNA699078_S_NODE_90790_length_175_cov_2.000000_g89841_i0	PRJNA699078	90790	175	2	3.5	Variovorax	34072	Bacteria	Bacteria	219	1.37e-52	NTclustered	gi\|2741163780\|dbj\|AP028666.1\|	3065956	g89841	i0	90.361	2.84571428571429	166	16	95	0	8	173	6042224	6042059	Variovorax sp. V35 DNA, complete genome	blastn	498	219	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax sp. V35
13436317	13436317	PRJNA699078_S_NODE_62951_length_213_cov_1.609756_g62002_i0	PRJNA699078	62951	213	1.609756	3.42878028	Vibrio chagasii	170679	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|2271101966\|dbj\|AP025465.1\|	170679	g62002	i0	100	0.131455399061033	28	0	13	0	56	83	2357394	2357421	Vibrio chagasii LMG 21353 DNA, chromosome 1, complete sequence	blastn	28	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio chagasii
13938065	13938065	PRJNA699078_S_NODE_73811_length_196_cov_1.312925_g72862_i0	PRJNA699078	73811	196	1.312925	2.573333	Variovorax	34072	Bacteria	Bacteria	230	7.299999999999999e-56	NTclustered	gi\|2189435386\|gb\|CP091716.1\|	34073	g72862	i0	89.888	22.0612244897959	178	18	91	0	19	196	7617977	7617800	Variovorax paradoxus strain IPSP_MA_2 chromosome	blastn	4324	230	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax paradoxus
14711590	14711590	PRJNA699078_S_NODE_68592_length_204_cov_0.903226_g67643_i0	PRJNA699078	68592	204	0.903226	1.84258104	Variovorax sp. PAMC26660	2762322	Bacteria	Bacteria	361	2.6e-95	NTclustered	gi\|1896689433\|gb\|CP060295.1\|	2762322	g67643	i0	98.529	46.5343137254902	204	3	100	0	1	204	6755371	6755574	Variovorax sp. PAMC26660 chromosome, complete genome	blastn	9493	361	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax sp. PAMC26660
15985089	15985089	PRJNA699078_S_NODE_56253_length_227_cov_1.168539_g55304_i0	PRJNA699078	56253	227	1.168539	2.65258353	Variovorax sp. PAMC26660	2762322	Bacteria	Bacteria	169	1.92e-37	NTclustered	gi\|1896689433\|gb\|CP060295.1\|	2762322	g55304	i0	85.625	1.06607929515419	160	23	70	0	67	226	7152944	7153103	Variovorax sp. PAMC26660 chromosome, complete genome	blastn	242	169	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax sp. PAMC26660
16487075	16487075	PRJNA699078_S_NODE_97213_length_169_cov_1.250000_g96264_i0	PRJNA699078	97213	169	1.25	2.1125	Burkholderia	32008	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|2090904009\|gb\|CP082808.1\|	488447	g96264	i0	100	100	169	0	100	0	1	169	889038	888870	Burkholderia contaminans strain SCAID TST1-2021 (11/270) chromosome 2, complete sequence	blastn	16900	313	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Burkholderia	Burkholderia contaminans
17761922	17761922	PRJNA699078_S_NODE_38514_length_278_cov_8.834061_g37565_i0	PRJNA699078	38514	278	8.834061	24.55868958	Enterobacteriaceae	543	Bacteria	Bacteria	472	1.6599999999999998e-128	NTclustered	gi\|2618357005\|gb\|CP137721.1\|	562	g37565	i0	100	628.197841726619	255	0	92	0	1	255	5149719	5149973	Escherichia coli strain HNTH2207 chromosome	blastn	174639	472	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
19035893	19035893	PRJNA699078_S_NODE_33855_length_297_cov_2.096774_g32906_i0	PRJNA699078	33855	297	2.096774	6.22741878	Turicimonas	1918598	Bacteria	Bacteria	399	8.549999999999999e-107	NTclustered	gi\|1957935753\|gb\|CP065313.1\|	1796652	g32906	i0	100	147.292929292929	216	0	100	0	1	216	44040	43825	Turicimonas muris strain YL45 chromosome	blastn	43746	399	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sutterellaceae	Turicimonas	Turicimonas muris
19035910	19035910	PRJNA699078_S_NODE_82675_length_184_cov_3.125926_g81726_i0	PRJNA699078	82675	184	3.125926	5.75170384	Halomonas	2745	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|1036082207\|emb\|LT593974.1\|	1666906	g81726	i0	100	0.304347826086957	28	0	15	0	33	60	2947681	2947708	Halomonas sp. HL-93 genome assembly, chromosome: I	blastn	56	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Halomonadaceae	Halomonas	Halomonas sp. HL-93
20310451	20310451	PRJNA699078_S_NODE_50136_length_241_cov_9.786458_g49187_i0	PRJNA699078	50136	241	9.786458	23.58536378	Enterobacteriaceae	543	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|2211724983\|gb\|CP066839.1\|	562	g49187	i0	100	677.788381742739	241	0	100	0	1	241	78374	78614	Escherichia coli strain Ec-RL2-1X chromosome, complete genome	blastn	163347	446	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
21084204	21084204	PRJNA699078_S_NODE_14477_length_421_cov_2.384409_g13539_i0	PRJNA699078	14477	421	2.384409	10.03836189	Alphaproteobacteria bacterium	1913988	Bacteria	Bacteria	472	2.63e-128	NTclustered	gi\|2893358410\|emb\|OZ220701.1\|	1913988	g13539	i0	89.446	177.619952494062	379	33	89	7	1	376	2702004	2702378	MAG: Alphaproteobacteria bacterium isolate a603a0a2-d098-4ec7-8fb6-76c879e39c7f genome assembly, chromosome: 1	blastn	74778	472	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria				Alphaproteobacteria bacterium
21084511	21084511	PRJNA699078_S_NODE_34497_length_294_cov_5.293878_g33548_i0	PRJNA699078	34497	294	5.293878	15.56400132	Acinetobacter calcoaceticus	471	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2591781342\|gb\|CP130683.1\|	471	g33548	i0	100	0.0952380952380952	28	0	10	0	254	281	1812081	1812108	Acinetobacter calcoaceticus strain AC001_UM chromosome, complete genome	blastn	28	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter calcoaceticus
22359675	22359675	PRJNA699078_S_NODE_60198_length_218_cov_3.047337_g59249_i0	PRJNA699078	60198	218	3.047337	6.64319466	Acinetobacter baumannii	470	Bacteria	Bacteria	52.8	0.019	NTclustered	gi\|2470454228\|gb\|CP113071.1\|	470	g59249	i0	100	0.770642201834862	28	0	13	0	158	185	2016407	2016380	Acinetobacter baumannii strain A118 DeltaH0N27_10830::kan chromosome, complete genome	blastn	168	52.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii
23635854	23635854	PRJNA699078_S_NODE_88759_length_178_cov_0.844961_g87810_i0	PRJNA699078	88759	178	0.844961	1.50403058	Sodalis praecaptivus	1239307	Bacteria	Bacteria	65.8	1.93e-6	NTclustered	gi\|573019581\|gb\|CP006569.1\|	1239307	g87810	i0	93.182	0.921348314606742	44	3	25	0	12	55	648470	648427	Sodalis praecaptivus strain HS1 chromosome, complete genome	blastn	164	65.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Bruguierivoracaceae	Sodalis	Sodalis praecaptivus
26670904	26670904	PRJNA699078_S_NODE_45001_length_256_cov_2.618357_g44052_i0	PRJNA699078	45001	256	2.618357	6.70299392	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	43.1	0.0252	NR	MDA0763400.1	1977087	g44052	i0	32.6	1.04296875	89	42	98.4	4	1	252	120	195	MDA0763400.1 glutathione S-transferase N-terminal domain-containing protein [Pseudomonadota bacterium]	diamond	267	43.1	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
27019470	27019470	PRJNA699078_S_NODE_43822_length_260_cov_2.218009_g42873_i0	PRJNA699078	43822	260	2.218009	5.7668234	Massilia phyllostachyos	2898585	Bacteria	Bacteria	43.1	0.0343	NR	WP_231057056.1	2898585	g42873	i0	38.3	0.692307692307692	60	30	61.2	2	190	32	289	348	WP_231057056.1 TIM-barrel domain-containing protein [Massilia phyllostachyos]	diamond	180	43.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Massilia	Massilia phyllostachyos
27062288	27062288	PRJNA699078_S_NODE_69682_length_202_cov_1.359477_g68733_i0	PRJNA699078	69682	202	1.359477	2.74614354	Pseudomonadota	1224	Bacteria	Bacteria	53.1	4.6e-6	NR	MDH3690358.1	1913989	g68733	i0	42.2	5.86633663366337	64	37	95	0	196	5	288	351	MDH3690358.1 adenylate/guanylate cyclase domain-containing protein [Gammaproteobacteria bacterium]	diamond	1185	53.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria				Gammaproteobacteria bacterium
27145504	27145504	PRJNA699078_S_NODE_45062_length_256_cov_1.898551_g44113_i0	PRJNA699078	45062	256	1.898551	4.86029056	Oceanisphaera arctica	641510	Bacteria	Bacteria	43.5	0.00878	NR	WP_104487639.1	641510	g44113	i0	40.3	2.203125	67	38	77.3	2	51	248	48	113	WP_104487639.1 ectoine synthase [Oceanisphaera arctica]	diamond	564	43.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Oceanisphaera	Oceanisphaera arctica
27240702	27240702	PRJNA699078_S_NODE_21643_length_362_cov_4.977636_g20694_i0	PRJNA699078	21643	362	4.977636	18.01904232	Pseudomonas syringae group genomosp. 7	251699	Bacteria	Bacteria	44.3	0.0263	NR	WP_395588033.1	251699	g20694	i0	51.4	0.613259668508287	74	19	58.8	5	66	278	42	101	WP_395588033.1 hypothetical protein [Pseudomonas syringae group genomosp. 7]	diamond	222	44.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas syringae group genomosp. 7
27619900	27619900	PRJNA699078_S_NODE_23904_length_348_cov_2.234114_g22955_i0	PRJNA699078	23904	348	2.234114	7.77471672	Candidatus Thiodiazotropha sp.	2847306	Bacteria	Bacteria	75.1	5.56e-13	NR	MEW8545044.1	2847306	g22955	i0	41.6	0.767241379310345	89	43	71.6	2	340	92	467	552	MEW8545044.1 reverse transcriptase family protein [Candidatus Thiodiazotropha sp.]	diamond	267	75.1	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Sedimenticolaceae	Candidatus Thiodiazotropha	Candidatus Thiodiazotropha sp.
27777824	27777824	PRJNA699078_S_NODE_89024_length_177_cov_1.718750_g88075_i0	PRJNA699078	89024	177	1.71875	3.0421875	Sphingomonas sp. PsM26	3030534	Bacteria	Bacteria	124	3.5600000000000004e-33	NR	MDN4633550.1	3030534	g88075	i0	100	0.983050847457627	58	0	98.3	0	3	176	138	195	MDN4633550.1 hypothetical protein [Sphingomonas sp. PsM26]	diamond	174	124	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas sp. PsM26
27978291	27978291	PRJNA699078_S_NODE_74685_length_195_cov_1.068493_g73736_i0	PRJNA699078	74685	195	1.068493	2.08356135	Pseudomonadati	3379134	Bacteria	Bacteria	59.7	2.1e-8	NR	MBP5534215.1	1913988	g73736	i0	51.7	13.1538461538462	58	24	87.7	3	25	195	278	332	MBP5534215.1 molecular chaperone HtpG [Alphaproteobacteria bacterium]	diamond	2565	60.1	0.993344425956739	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria				Alphaproteobacteria bacterium
28061771	28061771	PRJNA699078_S_NODE_57585_length_224_cov_1.188571_g56636_i0	PRJNA699078	57585	224	1.188571	2.66239904	Pinisolibacter aquiterrae	2815579	Bacteria	Bacteria	44.3	0.00769	NR	WP_217925751.1	2815579	g56636	i0	48.9	0.602678571428571	45	22	60.3	1	162	28	38	81	WP_217925751.1 DUF3108 domain-containing protein [Pinisolibacter aquiterrae]	diamond	135	44.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Ancalomicrobiaceae	Pinisolibacter	Pinisolibacter aquiterrae
28167829	28167829	PRJNA699078_S_NODE_62645_length_214_cov_0.945455_g61696_i0	PRJNA699078	62645	214	0.945455	2.0232737	Comamonas	283	Bacteria	Bacteria	61.6	1.28e-9	NR	WP_054067142.1	225992	g61696	i0	48.3	6.5607476635514	58	30	81.3	0	195	22	70	127	WP_054067142.1 SET domain-containing protein [Comamonas kerstersii]	diamond	1404	62	0.993548387096774	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Comamonas	Comamonas kerstersii
28409195	28409195	PRJNA699078_S_NODE_98606_length_168_cov_1.310924_g97657_i0	PRJNA699078	98606	168	1.310924	2.20235232	Hoeflea ulvae	2983764	Bacteria	Bacteria	42	0.0261	NR	WP_267611041.1	2983764	g97657	i0	39.6	0.946428571428571	53	32	94.6	0	1	159	152	204	WP_267611041.1 MFS transporter [Hoeflea ulvae]	diamond	159	42	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Rhizobiaceae	Hoeflea	Hoeflea ulvae
28787853	28787853	PRJNA699078_S_NODE_46947_length_250_cov_2.845771_g45998_i0	PRJNA699078	46947	250	2.845771	7.1144275	Marinomonas algicola	2773454	Bacteria	Bacteria	63.5	1.13e-9	NR	WP_191602975.1	2773454	g45998	i0	51.4	4.236	70	31	81.6	2	28	231	176	244	WP_191602975.1 glucosamine-6-phosphate deaminase [Marinomonas algicola]	diamond	1059	63.5	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Oceanospirillaceae	Marinomonas	Marinomonas algicola
28819291	28819291	PRJNA699078_S_NODE_102428_length_166_cov_0.820513_g101479_i0	PRJNA699078	102428	166	0.820513	1.36205158	Sedimenticola sp.	1940285	Bacteria	Bacteria	42	0.0211	NR	MES9883958.1	1940285	g101479	i0	35.2	0.975903614457831	54	35	97.6	0	164	3	107	160	MES9883958.1 SGNH/GDSL hydrolase family protein [Sedimenticola sp.]	diamond	162	42	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Sedimenticolaceae	Sedimenticola	Sedimenticola sp.
29304377	29304377	PRJNA699078_S_NODE_91289_length_175_cov_1.174603_g90340_i0	PRJNA699078	91289	175	1.174603	2.05555525	Variovorax	34072	Bacteria	Bacteria	117	1.31e-29	NR	WP_162572868.1	434009	g90340	i0	84.5	5.96571428571429	58	9	99.4	0	175	2	58	115	WP_162572868.1 glycosyltransferase [Variovorax sp. PBL-H6]	diamond	1044	118	0.991525423728814	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Variovorax	Variovorax sp. PBL-H6
29734970	29734970	PRJNA699078_S_NODE_14110_length_424_cov_15.922667_g13175_i0	PRJNA699078	14110	424	15.922667	67.51210808	Methylobacter sp.	2051955	Bacteria	Bacteria	102	7.839999999999999e-23	NR	PPD05376.1	2051955	g13175	i0	48.3	2.65330188679245	118	57	82.8	2	375	25	206	320	PPD05376.1 MAG: malate dehydrogenase [Methylobacter sp.]	diamond	1125	102	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Methylococcales	Methylococcaceae	Methylobacter	Methylobacter sp.
29829946	29829946	PRJNA699078_S_NODE_82131_length_185_cov_1.529412_g81182_i0	PRJNA699078	82131	185	1.529412	2.8294122	Candidatus Pelagibacter sp.	2024849	Bacteria	Bacteria	62.8	1.15e-9	NR	MDC3042712.1	2024849	g81182	i0	53.3	4.55675675675676	60	24	94.1	2	184	11	215	272	MDC3042712.1 ribokinase [Candidatus Pelagibacter sp.]	diamond	843	62.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Candidatus Pelagibacterales	Candidatus Pelagibacteraceae	Candidatus Pelagibacter	Candidatus Pelagibacter sp.
29924878	29924878	PRJNA699078_S_NODE_91591_length_175_cov_0.801587_g90642_i0	PRJNA699078	91591	175	0.801587	1.40277725	Neptunomonas phycophila	1572645	Bacteria	Bacteria	43.9	0.00574	NR	WP_215150724.1	1572645	g90642	i0	41.7	0.822857142857143	48	25	77.1	2	33	167	452	499	WP_215150724.1 primosomal protein N' [Neptunomonas phycophila]	diamond	144	43.9	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Oceanospirillales	Oceanospirillaceae	Neptunomonas	Neptunomonas phycophila
30030815	30030815	PRJNA699078_S_NODE_13311_length_433_cov_14.885417_g12379_i0	PRJNA699078	13311	433	14.885417	64.45385561	Bacteria	2	Bacteria	Bacteria	49.7	6.53e-4	NR	WP_004855275.1	202952	g12379	i0	43.4	1.12240184757506	53	30	36.7	0	3	161	182	234	WP_004855275.1 HAD family hydrolase [Acinetobacter gerneri]	diamond	486	50.1	0.992015968063872	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter gerneri
30208832	30208832	PRJNA699078_S_NODE_53612_length_233_cov_1.413043_g52663_i0	PRJNA699078	53612	233	1.413043	3.29239019	Comamonas sp. JC664	2801917	Bacteria	Bacteria	42.4	0.0368	NR	WP_191265366.1	2801917	g52663	i0	41.4	0.746781115879828	58	30	69.5	1	31	192	92	149	WP_191265366.1 DsbA family oxidoreductase [Comamonas sp. JC664]	diamond	174	42.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Comamonas	Comamonas sp. JC664
30473198	30473198	PRJNA699078_S_NODE_75833_length_193_cov_1.527778_g74884_i0	PRJNA699078	75833	193	1.527778	2.94861154	root	1	Root_unresolved	Root_unresolved	47.8	1.94e-4	NR	WP_019211760.1	629	g74884	i0	34.7	1.49222797927461	49	32	76.2	0	188	42	139	187	WP_019211760.1 MULTISPECIES: EF-hand domain-containing protein [Yersinia]	diamond	288	47.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Yersiniaceae	Yersinia
30525031	30525031	PRJNA699078_S_NODE_99473_length_168_cov_0.873950_g98524_i0	PRJNA699078	99473	168	0.87395	1.468236	Vibrio sp. V29_P1S3	678	Bacteria	Bacteria	67.8	1.73e-11	NR	WP_161428017.1	1938681	g98524	i0	52.8	1.82142857142857	53	25	94.6	0	2	160	311	363	WP_161428017.1 histidine decarboxylase, partial [Vibrio sp. V29_P1S30P107]	diamond	306	67.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio sp. V29_P1S30P107
30588111	30588111	PRJNA699078_S_NODE_26153_length_334_cov_13.554386_g25204_i0	PRJNA699078	26153	334	13.554386	45.27164924	Enterobacter hormaechei	158836	Bacteria	Bacteria	66.6	1.19e-11	NR	RRR14636.1	158836	g25204	i0	47.1	1.22155688622754	68	35	61.1	1	302	99	1	67	RRR14636.1 50S ribosomal protein P1, partial [Enterobacter hormaechei]	diamond	408	66.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Enterobacter	Enterobacter hormaechei
31409994	31409994	PRJNA699078_S_NODE_32936_length_301_cov_1.857143_g31987_i0	PRJNA699078	32936	301	1.857143	5.59000043	Pseudohongiellaceae bacterium	3085159	Bacteria	Bacteria	56.2	7.5e-7	NR	MEX1197604.1	3085159	g31987	i0	40.6	2.3421926910299	69	41	68.8	0	60	266	149	217	MEX1197604.1 nitroreductase [Pseudohongiellaceae bacterium]	diamond	705	56.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudohongiellaceae		Pseudohongiellaceae bacterium
31452936	31452936	PRJNA699078_S_NODE_94076_length_172_cov_1.268293_g93127_i0	PRJNA699078	94076	172	1.268293	2.18146396	root	1	Root_unresolved	Root_unresolved	46.6	4.49e-4	NR	MDI9527161.1	1977087	g93127	i0	53.7	2.30232558139535	41	19	71.5	0	11	133	155	195	MDI9527161.1 V-type ATP synthase subunit E [Pseudomonadota bacterium]	diamond	396	46.6	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
31568345	31568345	PRJNA699078_S_NODE_39236_length_276_cov_1.674009_g38287_i0	PRJNA699078	39236	276	1.674009	4.62026484	Stenotrophomonas maltophilia	40324	Bacteria	Bacteria	44.7	0.0113	NR	WP_100437827.1	40324	g38287	i0	40	0.706521739130435	65	35	70.7	3	243	49	300	360	WP_100437827.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Stenotrophomonas maltophilia]	diamond	195	44.7	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Stenotrophomonas	Stenotrophomonas maltophilia
31599882	31599882	PRJNA699078_S_NODE_31016_length_309_cov_7.869231_g30067_i0	PRJNA699078	31016	309	7.869231	24.31592379	Sphingopyxis bauzanensis	651663	Bacteria	Bacteria	76.3	3.83e-14	NR	WP_088441595.1	651663	g30067	i0	45.7	3.76699029126214	94	49	89.3	1	307	32	163	256	WP_088441595.1 SDR family NAD(P)-dependent oxidoreductase [Sphingopyxis bauzanensis]	diamond	1164	76.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingopyxis	Sphingopyxis bauzanensis
31599890	31599890	PRJNA699078_S_NODE_84116_length_183_cov_1.164179_g83167_i0	PRJNA699078	84116	183	1.164179	2.13044757	Candidimonas sp. SYP-B2681	2497686	Bacteria	Bacteria	72.4	2e-13	NR	WP_126706838.1	2497686	g83167	i0	58.6	0.950819672131147	58	24	95.1	0	3	176	175	232	WP_126706838.1 5'-methylthioadenosine/adenosylhomocysteine nucleosidase [Candidimonas sp. SYP-B2681]	diamond	174	72.4	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Alcaligenaceae	Candidimonas	Candidimonas sp. SYP-B2681
31694572	31694572	PRJNA699078_S_NODE_45977_length_253_cov_2.029412_g45028_i0	PRJNA699078	45977	253	2.029412	5.13441236	Histophilus somni	731	Bacteria	Bacteria	61.2	4.28e-9	NR	WP_011608490.1	731	g45028	i0	45.8	0.853754940711462	72	32	84.2	3	11	223	99	164	WP_011608490.1 NAD(P)H-dependent oxidoreductase [Histophilus somni]	diamond	216	61.2	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Histophilus	Histophilus somni
31884331	31884331	PRJNA699078_S_NODE_12157_length_447_cov_18.188442_g11234_i0	PRJNA699078	12157	447	18.188442	81.30233574	Porticoccaceae bacterium	2026782	Bacteria	Bacteria	119	4.189999999999999e-31	NR	MDB4352070.1	2026782	g11234	i0	49.6	0.798657718120805	119	58	79.2	2	416	63	27	144	MDB4352070.1 hypothetical protein [Porticoccaceae bacterium]	diamond	357	119	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Cellvibrionales	Porticoccaceae		Porticoccaceae bacterium
32042636	32042636	PRJNA699078_S_NODE_99538_length_167_cov_5.262712_g98589_i0	PRJNA699078	99538	167	5.262712	8.78872904	Klebsiella pneumoniae	573	Bacteria	Bacteria	54.3	2.03e-7	NR	WP_416532855.1	573	g98589	i0	61.8	1.20359281437126	34	13	61.1	0	2	103	98	131	WP_416532855.1 hypothetical protein, partial [Klebsiella pneumoniae]	diamond	201	54.3	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
32296102	32296102	PRJNA699078_S_NODE_28399_length_323_cov_0.886861_g27450_i0	PRJNA699078	28399	323	0.886861	2.86456103	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	44.3	0.0269	NR	MEM8635693.1	1977087	g27450	i0	35.2	0.501547987616099	54	34	50.2	1	165	4	150	202	MEM8635693.1 aminopeptidase N [Pseudomonadota bacterium]	diamond	162	44.3	1	Bacteria	Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
32390689	32390689	PRJNA699078_S_NODE_47519_length_249_cov_1.285000_g46570_i0	PRJNA699078	47519	249	1.285	3.19965	Rhodocyclaceae bacterium	1898103	Bacteria	Bacteria	45.8	0.00314	NR	MBK7813012.1	1898103	g46570	i0	34.9	1.51807228915663	63	37	71.1	1	244	68	282	344	MBK7813012.1 HAMP domain-containing histidine kinase [Rhodocyclaceae bacterium]	diamond	378	45.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Rhodocyclales	Rhodocyclaceae		Rhodocyclaceae bacterium
32517472	32517472	PRJNA699078_S_NODE_22799_length_355_cov_2.676471_g21850_i0	PRJNA699078	22799	355	2.676471	9.50147205	Pseudomonas syringae group genomosp. 7	251699	Bacteria	Bacteria	47	7.78e-4	NR	WP_395587741.1	251699	g21850	i0	45.6	0.870422535211268	103	38	73.5	5	92	352	3	103	WP_395587741.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7]	diamond	309	47	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas syringae group genomosp. 7
32654258	32654258	PRJNA699078_S_NODE_24040_length_347_cov_2.953020_g23091_i0	PRJNA699078	24040	347	2.95302	10.2469794	Methylobacterium	407	Bacteria	Bacteria	142	7.859999999999999e-40	NR	WP_287749706.1	409	g23091	i0	72.3	11.3602305475504	94	26	81.3	0	282	1	1	94	WP_287749706.1 trna delta -isopentenylpyrophosphate transferase [Methylobacterium sp.]	diamond	3942	143	0.993006993006993	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae	Methylobacterium	Methylobacterium sp.
32895156	32895156	PRJNA699078_S_NODE_21900_length_361_cov_1.673077_g20951_i0	PRJNA699078	21900	361	1.673077	6.03980797	Salmonella sp. s51933	3160127	Bacteria	Bacteria	57.8	1.06e-7	NR	WP_395241646.1	3160127	g20951	i0	47.1	0.581717451523546	70	29	58.2	2	356	147	75	136	WP_395241646.1 EF-hand domain-containing protein, partial [Salmonella sp. s51933]	diamond	210	57.8	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Salmonella	Salmonella sp. s51933

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