metadata: contig_metadata: 62 rows where bioproject = "PRJNA658591" and tax

62 rows where bioproject = "PRJNA658591" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
625491	625491	PRJNA658591_S_NODE_7601_length_178_cov_1.612403_g7538_i0	PRJNA658591	7601	178	1.612403	2.87007734	Bartonella harrusi	2961895	Bacteria	Bacteria	111	2.45e-20	NTclustered	gi\|2273385562\|gb\|CP101114.1\|	2961895	g7538	i0	80.38	1.3876404494382	158	22	86	6	2	154	1979872	1980025	Bartonella harrusi strain 117A chromosome, complete genome	blastn	247	111	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Bartonellaceae	Bartonella	Bartonella harrusi
1161371	1161371	PRJNA658591_S_NODE_3641_length_234_cov_2.745946_g3578_i0	PRJNA658591	3641	234	2.745946	6.42551364	Herbaspirillum	963	Bacteria	Bacteria	433	6.41e-117	NTclustered	gi\|2204876709\|gb\|CP049334.1\|	964	g3578	i0	100	406.961538461538	234	0	100	0	1	234	521967	521734	Herbaspirillum seropedicae strain Z69 chromosome	blastn	95229	433	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum seropedicae
3713145	3713145	PRJNA658591_S_NODE_10403_length_161_cov_5.892857_g10340_i0	PRJNA658591	10403	161	5.892857	9.48749977	Herbaspirillum	963	Bacteria	Bacteria	298	1.56e-76	NTclustered	gi\|2204876709\|gb\|CP049334.1\|	964	g10340	i0	100	215.024844720497	161	0	100	0	1	161	523486	523326	Herbaspirillum seropedicae strain Z69 chromosome	blastn	34619	298	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum seropedicae
3713149	3713149	PRJNA658591_S_NODE_343_length_626_cov_6.975737_g288_i0	PRJNA658591	343	626	6.975737	43.66811362	Hydrogenophaga	47420	Bacteria	Bacteria	1066	0	NTclustered	gi\|1796319018\|gb\|CP044549.1\|	2651974	g288	i0	97.448	187.222044728434	627	13	100	2	1	626	5746710	5747334	Hydrogenophaga sp. BPS33 chromosome, complete genome	blastn	117201	1072	0.994402985074627	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Hydrogenophaga	Hydrogenophaga sp. BPS33
4989700	4989700	PRJNA658591_S_NODE_1544_length_332_cov_6.575972_g1481_i0	PRJNA658591	1544	332	6.575972	21.83222704	Pseudomonas	286	Bacteria	Bacteria	608	1.479999999999999e-169	NTclustered	gi\|2703326990\|gb\|CP148752.1\|	294	g1481	i0	99.699	613.602409638554	332	1	100	0	1	332	739144	739475	Pseudomonas fluorescens strain AB1 chromosome, complete genome	blastn	203716	614	0.990228013029316	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas fluorescens
6265223	6265223	PRJNA658591_S_NODE_1725_length_316_cov_2.528090_g1662_i0	PRJNA658591	1725	316	2.52809	7.9887644	Pseudomonas	286	Bacteria	Bacteria	481	3.18e-131	NTclustered	gi\|2496337635\|gb\|CP093428.1\|	78543	g1662	i0	94.304	571.977848101266	316	14	99	3	2	316	116605	116293	Pseudomonas migulae strain 8R6 chromosome, complete genome	blastn	180745	481	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas migulae
7004072	7004072	PRJNA658591_S_NODE_10906_length_157_cov_2.398148_g10843_i0	PRJNA658591	10906	157	2.398148	3.76509236	Pseudomonas mosselii	78327	Bacteria	Bacteria	243	7.159999999999999e-60	NTclustered	gi\|2087963363\|gb\|CP081966.1\|	78327	g10843	i0	100	83.5031847133758	131	0	83	0	1	131	800841	800971	Pseudomonas mosselii strain DSM 17497 chromosome, complete genome	blastn	13110	243	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas mosselii
7004078	7004078	PRJNA658591_S_NODE_1866_length_306_cov_113.731518_g1803_i0	PRJNA658591	1866	306	113.731518	348.01844508	Escherichia coli	562	Bacteria	Bacteria	67.6	1.02e-6	NTclustered	gi\|2418631980\|gb\|CP114344.1\|	562	g1803	i0	97.5	0.633986928104575	40	0	13	1	263	302	1592207	1592169	Escherichia coli strain 2022CK-00558 chromosome, complete genome	blastn	194	67.6	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
7004087	7004087	PRJNA658591_S_NODE_3606_length_235_cov_1.709677_g3543_i0	PRJNA658591	3606	235	1.709677	4.01774095	Stenotrophomonas geniculata	86188	Bacteria	Bacteria	429	8.33e-116	NTclustered	gi\|2579505983\|gb\|CP134450.1\|	86188	g3543	i0	99.574	23.3276595744681	235	1	100	0	1	235	1751260	1751494	Stenotrophomonas geniculata strain BR23 chromosome, complete genome	blastn	5482	429	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Stenotrophomonas	Stenotrophomonas geniculata
7004100	7004100	PRJNA658591_S_NODE_8206_length_173_cov_1.983871_g8143_i0	PRJNA658591	8206	173	1.983871	3.43209683	Herbaspirillum seropedicae	964	Bacteria	Bacteria	320	3.61e-83	NTclustered	gi\|1062756882\|gb\|CP013136.1\|	964	g8143	i0	100	18.5549132947977	173	0	100	0	1	173	740236	740408	Herbaspirillum seropedicae strain AU14040 chromosome, complete genome	blastn	3210	320	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum seropedicae
7539311	7539311	PRJNA658591_S_NODE_2326_length_279_cov_3.491304_g2263_i0	PRJNA658591	2326	279	3.491304	9.74073816	Sphingomonas	13687	Bacteria	Bacteria	490	4.59e-134	NTclustered	gi\|1441477124\|gb\|CP029985.1\|	2219696	g2263	i0	98.556	168.207885304659	277	4	99	0	1	277	1038023	1038299	Sphingomonas sp. FARSPH chromosome, complete genome	blastn	46930	490	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas sp. FARSPH
7539315	7539315	PRJNA658591_S_NODE_4606_length_214_cov_2.000000_g4543_i0	PRJNA658591	4606	214	2	4.28	Erwinia	551	Bacteria	Bacteria	305	1.31e-78	NTclustered	gi\|1996386410\|gb\|CP066796.1\|	552	g4543	i0	96.721	560.116822429907	183	6	86	0	32	214	3462129	3462311	Erwinia amylovora strain ATCC 15580 chromosome, complete genome	blastn	119865	305	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Erwiniaceae	Erwinia	Erwinia amylovora
8278742	8278742	PRJNA658591_S_NODE_587_length_492_cov_6.264108_g525_i0	PRJNA658591	587	492	6.264108	30.81941136	Pseudomonadota	1224	Bacteria	Bacteria	278	6.029999999999998e-88	NR	WP_325323754.1	306	g525	i0	81	134.19512195122	163	31	99.4	0	490	2	339	501	WP_325323754.1 bifunctional aconitate hydratase 2/2-methylisocitrate dehydratase, partial [Pseudomonas sp.]	diamond	66024	280	0.992857142857143	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas sp.
10090020	10090020	PRJNA658591_S_NODE_3688_length_233_cov_1.114130_g3625_i0	PRJNA658591	3688	233	1.11413	2.5959229	Pseudomonas	286	Bacteria	Bacteria	425	1.07e-114	NTclustered	gi\|2868393811\|gb\|CP127120.1\|	287	g3625	i0	100	98.7124463519313	230	0	99	0	4	233	1940768	1940539	Pseudomonas aeruginosa strain USA_2_BIM chromosome, complete genome	blastn	23000	425	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
10090021	10090021	PRJNA658591_S_NODE_4468_length_216_cov_6.065868_g4405_i0	PRJNA658591	4468	216	6.065868	13.10227488	root	1	Root_unresolved	Root_unresolved	130	3.47e-33	NR	WP_196229824.1	2426	g4405	i0	91.5	212.986111111111	71	6	98.6	0	215	3	512	582	WP_196229824.1 bifunctional aconitate hydratase 2/2-methylisocitrate dehydratase [Teredinibacter turnerae]	diamond	46005	131	0.99236641221374	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Cellvibrionales	Cellvibrionaceae	Teredinibacter	Teredinibacter turnerae
10090024	10090024	PRJNA658591_S_NODE_6128_length_192_cov_2.342657_g6065_i0	PRJNA658591	6128	192	2.342657	4.49790144	Neisseriales	206351	Bacteria	Bacteria	233	5.5e-57	NTclustered	gi\|1272225406\|gb\|CP024029.1\|	536	g6065	i0	100	349.625	126	0	66	0	67	192	401797	401672	Chromobacterium violaceum strain CV1197 chromosome	blastn	67128	233	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Chromobacteriaceae	Chromobacterium	Chromobacterium violaceum
10829730	10829730	PRJNA658591_S_NODE_8209_length_173_cov_1.677419_g8146_i0	PRJNA658591	8209	173	1.677419	2.90193487	Aeromonas	642	Bacteria	Bacteria	89	3.24e-19	NR	MDX2126969.1	644	g8146	i0	71.4	7.7514450867052	56	16	97.1	0	5	172	102	157	MDX2126969.1 aconitate hydratase B [Aeromonas hydrophila]	diamond	1341	89	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas hydrophila
11364852	11364852	PRJNA658591_S_NODE_9589_length_165_cov_1.793103_g9526_i0	PRJNA658591	9589	165	1.793103	2.95861995	Limnobacter	131079	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2591690181\|dbj\|AP028947.1\|	131080	g9526	i0	100	490	165	0	100	0	1	165	511049	511213	Limnobacter thiooxidans CS-K2 DNA, complete genome	blastn	80850	305	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Limnobacter	Limnobacter thiooxidans
12104857	12104857	PRJNA658591_S_NODE_6690_length_186_cov_2.905109_g6627_i0	PRJNA658591	6690	186	2.905109	5.40350274	Caldimonas thermodepolymerans	215580	Bacteria	Bacteria	326	8.490000000000001e-85	NTclustered	gi\|2326450780\|gb\|CP110415.1\|	215580	g6627	i0	98.378	292.494623655914	185	3	99	0	1	185	2510920	2511104	Caldimonas thermodepolymerans strain LMG 21645 chromosome, complete genome	blastn	54404	326	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Caldimonas	Caldimonas thermodepolymerans
12640603	12640603	PRJNA658591_S_NODE_8590_length_170_cov_2.438017_g8527_i0	PRJNA658591	8590	170	2.438017	4.1446289	root	1	Root_unresolved	Root_unresolved	315	1.64e-81	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g8527	i0	100	220.047058823529	170	0	100	0	1	170	187832	188001	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	37408	315	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
13379585	13379585	PRJNA658591_S_NODE_2931_length_253_cov_13.009804_g2868_i0	PRJNA658591	2931	253	13.009804	32.91480412	Rheinheimera mangrovi	2498451	Bacteria	Bacteria	409	1.18e-109	NTclustered	gi\|1546439273\|gb\|CP034683.1\|	2498451	g2868	i0	97.107	650.02371541502	242	7	96	0	12	253	264707	264948	Rheinheimera mangrovi strain LHK132 chromosome, complete genome	blastn	164456	409	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Chromatiaceae	Rheinheimera	Rheinheimera mangrovi
13379590	13379590	PRJNA658591_S_NODE_4491_length_216_cov_2.149701_g4428_i0	PRJNA658591	4491	216	2.149701	4.64335416	Gammaproteobacteria	1236	Bacteria	Bacteria	120	2.35e-30	NR	WP_297331369.1	53249	g4428	i0	85.9	13.8055555555556	71	10	98.6	0	1	213	331	401	WP_297331369.1 bifunctional aconitate hydratase 2/2-methylisocitrate dehydratase, partial [Pseudoalteromonas sp.]	diamond	2982	121	0.991735537190083	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Pseudoalteromonadaceae	Pseudoalteromonas	Pseudoalteromonas sp.
15189937	15189937	PRJNA658591_S_NODE_11472_length_152_cov_5.368932_g11409_i0	PRJNA658591	11472	152	5.368932	8.16077664	Paracoccus	265	Bacteria	Bacteria	281	1.46e-71	NTclustered	gi\|1767635315\|gb\|CP045072.1\|	135740	g11409	i0	100	178.335526315789	152	0	100	0	1	152	98141	97990	Paracoccus kondratievae strain BJQ0001 chromosome 1, complete sequence	blastn	27107	281	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Paracoccaceae	Paracoccus	Paracoccus kondratievae
15189938	15189938	PRJNA658591_S_NODE_11612_length_151_cov_4.431373_g11549_i0	PRJNA658591	11612	151	4.431373	6.69137323	Stenotrophomonas	40323	Bacteria	Bacteria	279	5.19e-71	NTclustered	gi\|2065946896\|gb\|CP078103.1\|	86188	g11549	i0	100	99.7483443708609	151	0	100	0	1	151	1125862	1125712	Stenotrophomonas geniculata strain E119 chromosome, complete genome	blastn	15062	279	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Stenotrophomonas	Stenotrophomonas geniculata
15189942	15189942	PRJNA658591_S_NODE_3852_length_228_cov_88.955307_g3789_i0	PRJNA658591	3852	228	88.955307	202.81809996	root	1	Root_unresolved	Root_unresolved	71.3	5.61e-8	NTclustered	gi\|959225436\|emb\|LN899825.1\|	305	g3789	i0	100	6.71491228070175	38	0	17	0	191	228	1582428	1582465	Ralstonia solanacearum genome assembly 9 genomes, chromosome : VII	blastn	1531	71.3	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia solanacearum
16464223	16464223	PRJNA658591_S_NODE_10573_length_160_cov_2.360360_g10510_i0	PRJNA658591	10573	160	2.36036	3.776576	Paracoccaceae	31989	Bacteria	Bacteria	291	2.5799999999999998e-74	NTclustered	gi\|2731720636\|dbj\|AP031493.1\|	267	g10510	i0	99.375	190.80625	160	1	100	0	1	160	1127792	1127951	MAG: Paracoccus sp. (in: a-proteobacteria) S3_2 DNA, complete genome	blastn	30529	291	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Paracoccaceae	Paracoccus	Paracoccus sp. (in: a-proteobacteria)
16464229	16464229	PRJNA658591_S_NODE_5753_length_197_cov_1.851351_g5690_i0	PRJNA658591	5753	197	1.851351	3.64716147	root	1	Root_unresolved	Root_unresolved	289	1.1899999999999998e-73	NTclustered	gi\|2278608021\|emb\|OX250398.1\|	847	g5690	i0	100	87.8984771573604	156	0	79	0	28	183	290	445	Oxalobacter formigenes partial 16S rRNA gene	blastn	17316	289	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Oxalobacter	Oxalobacter formigenes
16464231	16464231	PRJNA658591_S_NODE_9873_length_164_cov_0.904348_g9810_i0	PRJNA658591	9873	164	0.904348	1.48313072	Erwinia	551	Bacteria	Bacteria	294	2.06e-75	NTclustered	gi\|1996386410\|gb\|CP066796.1\|	552	g9810	i0	100	96.9512195121951	159	0	97	0	6	164	1749061	1749219	Erwinia amylovora strain ATCC 15580 chromosome, complete genome	blastn	15900	294	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Erwiniaceae	Erwinia	Erwinia amylovora
17739294	17739294	PRJNA658591_S_NODE_6814_length_185_cov_1.213235_g6751_i0	PRJNA658591	6814	185	1.213235	2.24448475	Herbaspirillum	963	Bacteria	Bacteria	289	1.11e-73	NTclustered	gi\|2204876709\|gb\|CP049334.1\|	964	g6751	i0	98.765	16.827027027027	162	2	88	0	24	185	755515	755676	Herbaspirillum seropedicae strain Z69 chromosome	blastn	3113	289	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum seropedicae
17739295	17739295	PRJNA658591_S_NODE_6854_length_184_cov_4.451852_g6791_i0	PRJNA658591	6854	184	4.451852	8.19140768	root	1	Root_unresolved	Root_unresolved	296	6.57e-76	NTclustered	gi\|2204876709\|gb\|CP049334.1\|	964	g6791	i0	100	328.701086956522	160	0	87	0	25	184	524116	523957	Herbaspirillum seropedicae strain Z69 chromosome	blastn	60481	296	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum seropedicae
19012939	19012939	PRJNA658591_S_NODE_2495_length_271_cov_2.828829_g2432_i0	PRJNA658591	2495	271	2.828829	7.66612659	Chromobacteriaceae	1499392	Bacteria	Bacteria	468	2.08e-127	NTclustered	gi\|1272225406\|gb\|CP024029.1\|	536	g2432	i0	97.786	516	271	6	100	0	1	271	400408	400138	Chromobacterium violaceum strain CV1197 chromosome	blastn	139836	468	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Chromobacteriaceae	Chromobacterium	Chromobacterium violaceum
19012940	19012940	PRJNA658591_S_NODE_2735_length_261_cov_5.783019_g2672_i0	PRJNA658591	2735	261	5.783019	15.09367959	Herbaspirillum	963	Bacteria	Bacteria	418	2.0399999999999995e-112	NTclustered	gi\|2204876709\|gb\|CP049334.1\|	964	g2672	i0	96.8	261.314176245211	250	8	97	0	12	261	524614	524365	Herbaspirillum seropedicae strain Z69 chromosome	blastn	68203	418	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum seropedicae
19012947	19012947	PRJNA658591_S_NODE_9435_length_166_cov_0.888889_g9372_i0	PRJNA658591	9435	166	0.888889	1.47555574	Herbaspirillum	963	Bacteria	Bacteria	302	1.2500000000000001e-77	NTclustered	gi\|2204876709\|gb\|CP049334.1\|	964	g9372	i0	99.398	30.4457831325301	166	1	100	0	1	166	128897	128732	Herbaspirillum seropedicae strain Z69 chromosome	blastn	5054	302	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum seropedicae
19752487	19752487	PRJNA658591_S_NODE_3656_length_233_cov_239.211957_g3593_i0	PRJNA658591	3656	233	239.211957	557.36385981	Escherichia coli	562	Bacteria	Bacteria	115	2.6200000000000003e-21	NTclustered	gi\|2463378371\|dbj\|AP027461.1\|	511145	g3593	i0	94.737	17.9442060085837	76	1	32	2	1	74	1299705	1299631	Escherichia coli str. K-12 substr. MG1655 D41c DNA, complete genome	blastn	4181	115	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
21028017	21028017	PRJNA658591_S_NODE_2557_length_268_cov_4.831050_g2494_i0	PRJNA658591	2557	268	4.83105	12.947214	Rheinheimera sp. F8	1763998	Bacteria	Bacteria	435	2.09e-117	NTclustered	gi\|975021511\|gb\|CP013656.1\|	1763998	g2494	i0	95.911	963.60447761194	269	9	100	2	1	268	417660	417393	Rheinheimera sp. F8 genome	blastn	258246	435	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Chromatiales	Chromatiaceae	Rheinheimera	Rheinheimera sp. F8
21563368	21563368	PRJNA658591_S_NODE_2477_length_271_cov_113.720721_g2414_i0	PRJNA658591	2477	271	113.720721	308.18315391	root	1	Root_unresolved	Root_unresolved	87.9	6.81e-13	NTclustered	gi\|959204059\|emb\|LN899819.1\|	305	g2414	i0	100	8.73431734317343	47	0	18	0	7	53	496633	496587	Ralstonia solanacearum genome assembly 9 genomes, chromosome : I	blastn	2367	87.9	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia solanacearum
22302756	22302756	PRJNA658591_S_NODE_2078_length_292_cov_177.798354_g2015_i0	PRJNA658591	2078	292	177.798354	519.17119368	Vogesella sp. XCS3	2877939	Bacteria	Bacteria	401	2.3299999999999993e-107	NTclustered	gi\|2124242701\|gb\|CP085530.1\|	2877939	g2015	i0	99.548	314.246575342466	221	0	76	1	1	221	79302	79521	Vogesella sp. XCS3 chromosome, complete genome	blastn	91760	401	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Chromobacteriaceae	Vogesella	Vogesella sp. XCS3
24113347	24113347	PRJNA658591_S_NODE_10639_length_159_cov_6.272727_g10576_i0	PRJNA658591	10639	159	6.272727	9.97363593	Stenotrophomonas	40323	Bacteria	Bacteria	294	1.98e-75	NTclustered	gi\|2754047287\|gb\|CP159509.1\|	40324	g10576	i0	100	100	159	0	100	0	1	159	3615082	3614924	Stenotrophomonas maltophilia strain SM911 chromosome, complete genome	blastn	15900	294	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Stenotrophomonas	Stenotrophomonas maltophilia
24113348	24113348	PRJNA658591_S_NODE_1119_length_384_cov_2.877612_g1056_i0	PRJNA658591	1119	384	2.877612	11.05003008	Pseudomonas	286	Bacteria	Bacteria	582	1.0499999999999996e-161	NTclustered	gi\|1024771698\|gb\|CP011789.1\|	303	g1056	i0	97.101	600.130208333333	345	10	90	0	1	345	4251570	4251226	Pseudomonas putida strain PC2, complete genome	blastn	230450	582	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas putida
24113349	24113349	PRJNA658591_S_NODE_1739_length_315_cov_3.744361_g1676_i0	PRJNA658591	1739	315	3.744361	11.79473715	root	1	Root_unresolved	Root_unresolved	63.9	1.36e-5	NTclustered	gi\|1925240908\|gb\|CP043980.1\|	2608262	g1676	i0	97.368	0.711111111111111	38	0	12	1	274	310	42	5	MAG: Candidatus Stammera capleta isolate 1 chromosome, complete genome	blastn	224	63.9	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Stammera	Candidatus Stammera capleta
24851739	24851739	PRJNA658591_S_NODE_7020_length_183_cov_1.164179_g6957_i0	PRJNA658591	7020	183	1.164179	2.13044757	Aquirhabdus parva	2283318	Bacteria	Bacteria	316	5.009999999999999e-82	NTclustered	gi\|1438669448\|gb\|CP031222.1\|	2283318	g6957	i0	97.814	548.48087431694	183	4	100	0	1	183	37707	37889	Aquirhabdus parva strain HYN0046 chromosome, complete genome	blastn	100372	316	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Aquirhabdus	Aquirhabdus parva
24851745	24851745	PRJNA658591_S_NODE_9000_length_168_cov_1.210084_g8937_i0	PRJNA658591	9000	168	1.210084	2.03294112	Sphingomonas sp. AAP5	1523415	Bacteria	Bacteria	257	2.79e-64	NTclustered	gi\|1593517331\|gb\|CP037913.1\|	1523415	g8937	i0	99.296	162.970238095238	142	1	85	0	27	168	3116554	3116695	Sphingomonas sp. AAP5 chromosome, complete genome	blastn	27379	257	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas sp. AAP5
25387860	25387860	PRJNA658591_S_NODE_700_length_459_cov_3.256098_g638_i0	PRJNA658591	700	459	3.256098	14.94548982	root	1	Root_unresolved	Root_unresolved	743	0	NTclustered	gi\|1373233848\|gb\|CP028288.1\|	80867	g638	i0	95.861	252.403050108932	459	19	100	0	1	459	1733879	1733421	Paracidovorax avenae strain AA81_1 chromosome	blastn	115853	749	0.991989319092123	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Paracidovorax	Paracidovorax avenae
26669572	26669572	PRJNA658591_S_NODE_11501_length_152_cov_3.310680_g11438_i0	PRJNA658591	11501	152	3.31068	5.0322336	Paracoccaceae bacterium	1904441	Bacteria	Bacteria	54.7	6.47e-7	NR	GIS52924.1	1904441	g11438	i0	93.1	0.572368421052632	29	2	57.2	0	66	152	1	29	GIS52924.1 MAG: chaperone protein HtpG [Paracoccaceae bacterium]	diamond	87	54.7	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rhodobacterales	Paracoccaceae		Paracoccaceae bacterium
26872452	26872452	PRJNA658591_S_NODE_701_length_459_cov_2.007317_g639_i0	PRJNA658591	701	459	2.007317	9.21358503	root	1	Root_unresolved	Root_unresolved	139	9.589999999999999e-35	NR	WP_171385959.1	171383	g639	i0	72.2	15.5555555555556	97	27	63.4	0	163	453	3	99	WP_171385959.1 bifunctional aconitate hydratase 2/2-methylisocitrate dehydratase [Vibrio hepatarius]	diamond	7140	140	0.992857142857143	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio hepatarius
27018073	27018073	PRJNA658591_S_NODE_7122_length_182_cov_1.556391_g7059_i0	PRJNA658591	7122	182	1.556391	2.83263162	Pseudomonadota bacterium	1977087	Bacteria	Bacteria	57	1.53e-7	NR	MCG8336191.1	1977087	g7059	i0	52.5	1.94505494505495	59	27	97.3	1	2	178	807	864	MCG8336191.1 insulinase family protein [Pseudomonadota bacterium]	diamond	354	57	1	Bacteria		Pseudomonadati	Pseudomonadota					Pseudomonadota bacterium
27049878	27049878	PRJNA658591_S_NODE_5802_length_196_cov_8.210884_g5739_i0	PRJNA658591	5802	196	8.210884	16.09333264	Kangiella koreensis	261964	Bacteria	Bacteria	86.3	9.37e-18	NR	WP_012801033.1	261964	g5739	i0	73.2	3.39795918367347	56	15	85.7	0	29	196	19	74	WP_012801033.1 NADP-dependent isocitrate dehydrogenase [Kangiella koreensis]	diamond	666	86.3	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Kangiellales	Kangiellaceae	Kangiella	Kangiella koreensis
27144152	27144152	PRJNA658591_S_NODE_5442_length_201_cov_1.368421_g5379_i0	PRJNA658591	5442	201	1.368421	2.75052621	Thiotrichales bacterium 32-46-8	1970604	Bacteria	Bacteria	61.6	4.44e-9	NR	OYX03948.1	1970604	g5379	i0	67.6	1.11940298507463	37	12	55.2	0	199	89	199	235	OYX03948.1 MAG: hypothetical protein B7Z05_08990, partial [Thiotrichales bacterium 32-46-8]	diamond	225	61.6	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Thiotrichales			Thiotrichales bacterium 32-46-8
27315005	27315005	PRJNA658591_S_NODE_4263_length_220_cov_1.654971_g4200_i0	PRJNA658591	4263	220	1.654971	3.6409362	Bacteria	2	Bacteria	Bacteria	90.1	5.04e-19	NR	WP_025240548.1	316	g4200	i0	60.6	9.7227272727272709	71	25	96.8	1	213	1	305	372	WP_025240548.1 NADP-dependent succinate-semialdehyde dehydrogenase [Stutzerimonas stutzeri]	diamond	2139	90.9	0.991199119911991	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Stutzerimonas	Stutzerimonas stutzeri
27492245	27492245	PRJNA658591_S_NODE_11523_length_152_cov_2.524272_g11460_i0	PRJNA658591	11523	152	2.524272	3.83689344	Nitrosomonadales bacterium	2026761	Bacteria	Bacteria	45.1	0.00165	NR	MEK9771194.1	2026761	g11460	i0	44.7	0.927631578947368	47	23	86.8	1	139	8	583	629	MEK9771194.1 [protein-PII] uridylyltransferase [Nitrosomonadales bacterium]	diamond	141	45.1	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Nitrosomonadales			Nitrosomonadales bacterium
28597388	28597388	PRJNA658591_S_NODE_7867_length_176_cov_1.220472_g7804_i0	PRJNA658591	7867	176	1.220472	2.14803072	Vogesella urethralis	2592656	Bacteria	Bacteria	114	7.1e-30	NR	WP_144371639.1	2592656	g7804	i0	100	0.988636363636364	58	0	98.9	0	175	2	67	124	WP_144371639.1 TetR/AcrR family transcriptional regulator [Vogesella urethralis]	diamond	174	114	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Chromobacteriaceae	Vogesella	Vogesella urethralis
29638851	29638851	PRJNA658591_S_NODE_3570_length_235_cov_194.532258_g3507_i0	PRJNA658591	3570	235	194.532258	457.1508063	Pseudomonas fluorescens BRIP34879	1205750	Bacteria	Bacteria	47.4	1.22e-4	NR	ELQ05789.1	1205750	g3507	i0	69.7	0.421276595744681	33	10	42.1	0	3	101	1	33	ELQ05789.1 protocatechuate 3,4-dioxygenase subunit alpha, partial [Pseudomonas fluorescens BRIP34879]	diamond	99	47.4	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas fluorescens
29650986	29650986	PRJNA658591_S_NODE_8210_length_173_cov_1.677419_g8147_i0	PRJNA658591	8210	173	1.677419	2.90193487	Methylomarinum	1221209	Bacteria	Bacteria	83.6	5.9e-17	NR	WP_031432232.1	438855	g8147	i0	74	5.30635838150289	50	13	86.7	0	165	16	291	340	WP_031432232.1 bifunctional aconitate hydratase 2/2-methylisocitrate dehydratase [Methylomarinum vadi]	diamond	918	84.3	0.991696322657177	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Methylococcales	Methylococcaceae	Methylomarinum	Methylomarinum vadi
30093381	30093381	PRJNA658591_S_NODE_612_length_484_cov_9.266667_g550_i0	PRJNA658591	612	484	9.266667	44.85066828	Pseudomonadati	3379134	Bacteria	Bacteria	152	2.66e-39	NR	HNJ38565.1	42353	g550	i0	47.7	1.93388429752066	151	79	93.6	0	481	29	800	950	HNJ38565.1 reverse transcriptase domain-containing protein [Nitrosomonas sp.]	diamond	936	153	0.993464052287582	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Nitrosomonadales	Nitrosomonadaceae	Nitrosomonas	Nitrosomonas sp.
30303007	30303007	PRJNA658591_S_NODE_6332_length_190_cov_1.106383_g6269_i0	PRJNA658591	6332	190	1.106383	2.1021277	Curvibacter sp.	1888168	Bacteria	Bacteria	120	1.1e-29	NR	RUP35422.1	1888168	g6269	i0	98.4	0.994736842105263	63	1	99.5	0	190	2	1533	1595	RUP35422.1 MAG: hypothetical protein EKK45_01130, partial [Curvibacter sp.]	diamond	189	120	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Curvibacter	Curvibacter sp.
30713250	30713250	PRJNA658591_S_NODE_1514_length_335_cov_2.150350_g1451_i0	PRJNA658591	1514	335	2.15035	7.2036725	Thiotrichales bacterium 32-46-8	1970604	Bacteria	Bacteria	163	1.53e-46	NR	OYX07600.1	1970604	g1451	i0	69.5	0.940298507462687	105	32	94	0	18	332	1	105	OYX07600.1 MAG: hypothetical protein B7Z05_01050 [Thiotrichales bacterium 32-46-8]	diamond	315	163	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Thiotrichales			Thiotrichales bacterium 32-46-8
30966220	30966220	PRJNA658591_S_NODE_5154_length_205_cov_2.089744_g5091_i0	PRJNA658591	5154	205	2.089744	4.2839752	unclassified Janthinobacterium	2610881	Bacteria	Bacteria	67.4	4.47e-11	NR	WP_183743267.1	2610881	g5091	i0	46.8	1.87317073170732	62	33	90.7	0	192	7	206	267	WP_183743267.1 MULTISPECIES: carboxypeptidase regulatory-like domain-containing protein [unclassified Janthinobacterium]	diamond	384	67.4	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Janthinobacterium
31281972	31281972	PRJNA658591_S_NODE_7315_length_180_cov_3.465649_g7252_i0	PRJNA658591	7315	180	3.465649	6.2381682	Alphaproteobacteria bacterium	1913988	Bacteria	Bacteria	56.6	1.97e-7	NR	MDA8524460.1	1913988	g7252	i0	44.8	0.966666666666667	58	32	96.7	0	179	6	288	345	MDA8524460.1 formyltransferase family protein [Alphaproteobacteria bacterium]	diamond	174	56.6	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria				Alphaproteobacteria bacterium
31851267	31851267	PRJNA658591_S_NODE_5037_length_207_cov_1.069620_g4974_i0	PRJNA658591	5037	207	1.06962	2.2141134	Betaproteobacteria bacterium	1891241	Bacteria	Bacteria	79.3	2.9e-15	NR	MBV8030929.1	1891241	g4974	i0	64.6	2.76811594202899	65	22	92.8	1	3	194	581	645	MBV8030929.1 acetyl/propionyl/methylcrotonyl-CoA carboxylase subunit alpha [Betaproteobacteria bacterium]	diamond	573	79.3	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria				Betaproteobacteria bacterium
31882957	31882957	PRJNA658591_S_NODE_3837_length_229_cov_1.972222_g3774_i0	PRJNA658591	3837	229	1.972222	4.51638838	Duganella sp. CF517	1881038	Bacteria	Bacteria	87.4	5.62e-18	NR	WP_090318457.1	1881038	g3774	i0	53.3	9.82532751091703	75	35	98.3	0	227	3	676	750	WP_090318457.1 HAD-IC family P-type ATPase [Duganella sp. CF517]	diamond	2250	87.4	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Duganella	Duganella sp. CF517
32263012	32263012	PRJNA658591_S_NODE_1858_length_307_cov_3.244186_g1795_i0	PRJNA658591	1858	307	3.244186	9.95965102	Thiotrichales bacterium 32-46-8	1970604	Bacteria	Bacteria	158	6.58e-45	NR	OYX07600.1	1970604	g1795	i0	67.6	0.996742671009772	102	33	99.7	0	2	307	217	318	OYX07600.1 MAG: hypothetical protein B7Z05_01050 [Thiotrichales bacterium 32-46-8]	diamond	306	158	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Thiotrichales			Thiotrichales bacterium 32-46-8
32306906	32306906	PRJNA658591_S_NODE_9479_length_166_cov_0.863248_g9416_i0	PRJNA658591	9479	166	0.863248	1.43299168	Pseudomonadati	3379134	Bacteria	Bacteria	42.4	0.0141	NR	WP_308953921.1	548	g9416	i0	90.5	3.03614457831325	21	2	38	0	3	65	171	191	WP_308953921.1 zinc-binding dehydrogenase, partial [Klebsiella aerogenes]	diamond	504	42.7	0.992974238875878	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella aerogenes

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