metadata: contig_metadata: 54 rows where analysis = "blastn", bioproject = "PRJEB25583" and tax

54 rows where analysis = "blastn", bioproject = "PRJEB25583" 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
2261731	2261731	PRJEB25583_P_NODE_2902_length_238_cov_1.870647_g2725_i0	PRJEB25583	2902	238	1.870647	4.45213986	Xanthomonas	338	Bacteria	Bacteria	67.6	7.63e-7	NTclustered	gi\|2273560659\|gb\|CP101174.1\|	340	g2725	i0	84.058	0.869747899159664	69	11	29	0	154	222	4514099	4514167	Xanthomonas campestris pv. campestris strain CN07 chromosome, complete genome	blastn	207	67.6	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Xanthomonas	Xanthomonas campestris
2261758	2261758	PRJEB25583_P_NODE_5322_length_178_cov_4.666667_g5145_i0	PRJEB25583	5322	178	4.666667	8.30666726	Rhizobiaceae	82115	Bacteria	Bacteria	159	8.629999999999998e-35	NTclustered	gi\|1867905451\|dbj\|AP023269.1\|	373	g5145	i0	97.826	98.7696629213483	92	2	52	0	87	178	221634	221725	Agrobacterium vitis VAR03-1 DNA, chromosome 2, complete sequence	blastn	17581	159	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Rhizobiaceae	Agrobacterium	Agrobacterium vitis
2261764	2261764	PRJEB25583_P_NODE_5682_length_174_cov_1.116788_g5505_i0	PRJEB25583	5682	174	1.116788	1.94321112	Methylorubrum	2282523	Bacteria	Bacteria	224	2.93e-54	NTclustered	gi\|1315671047\|emb\|LT962688.1\|	408	g5505	i0	93.377	10.2931034482759	151	10	87	0	20	170	2508746	2508596	Methylobacterium extorquens strain TK 0001, genome assembly, chromosome: TK0001	blastn	1791	224	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae	Methylorubrum	Methylorubrum extorquens
2572863	2572863	PRJEB25583_P_NODE_2643_length_251_cov_1.616822_g2466_i0	PRJEB25583	2643	251	1.616822	4.05822322	Acinetobacter johnsonii	40214	Bacteria	Bacteria	459	1.1499999999999996e-124	NTclustered	gi\|1958298831\|gb\|CP068187.1\|	40214	g2466	i0	99.602	179.243027888446	251	1	100	0	1	251	2004190	2003940	Acinetobacter johnsonii strain FDAARGOS_1094 chromosome, complete genome	blastn	44990	459	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter johnsonii
3536990	3536990	PRJEB25583_P_NODE_3543_length_215_cov_1.421348_g3366_i0	PRJEB25583	3543	215	1.421348	3.0558982	Enterobacteriaceae	543	Bacteria	Bacteria	398	2.1099999999999997e-106	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g3366	i0	100	101	215	0	100	0	1	215	3689457	3689243	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	21715	398	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
4814233	4814233	PRJEB25583_P_NODE_1604_length_338_cov_8.903654_g1427_i0	PRJEB25583	1604	338	8.903654	30.09435052	Enterobacteriaceae	543	Bacteria	Bacteria	619	6.969999999999999e-173	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g1427	i0	99.704	690.112426035503	338	1	100	0	1	338	188540	188203	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	233258	625	0.9904	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
4814291	4814291	PRJEB25583_P_NODE_6904_length_161_cov_1.096774_g6727_i0	PRJEB25583	6904	161	1.096774	1.76580614	Cupriavidus	106589	Bacteria	Bacteria	126	7.77e-25	NTclustered	gi\|1780515536\|gb\|CP046331.1\|	119219	g6727	i0	89.796	4.93167701863354	98	10	61	0	64	161	1793478	1793575	Cupriavidus metallidurans strain FDAARGOS_675 chromosome, complete genome	blastn	794	126	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Cupriavidus	Cupriavidus metallidurans
6089582	6089582	PRJEB25583_P_NODE_905_length_498_cov_16.683297_g733_i0	PRJEB25583	905	498	16.683297	83.08281906	Roseateles	93681	Bacteria	Bacteria	756	0	NTclustered	gi\|1033652334\|gb\|CP011514.1\|	1658665	g733	i0	95.218	258.708835341365	481	18	96	5	21	498	5819191	5819669	Mitsuaria sp. 7, complete genome	blastn	128837	761	0.993429697766097	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Roseateles	Mitsuaria sp. 7
6401141	6401141	PRJEB25583_P_NODE_6906_length_161_cov_1.080645_g6729_i0	PRJEB25583	6906	161	1.080645	1.73983845	Ectopseudomonas chengduensis	489632	Bacteria	Bacteria	276	7.29e-70	NTclustered	gi\|2536885667\|gb\|CP129400.1\|	489632	g6729	i0	97.516	99.1925465838509	161	4	100	0	1	161	3151012	3150852	Ectopseudomonas chengduensis strain WD211 chromosome, complete genome	blastn	15970	276	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Ectopseudomonas	Ectopseudomonas chengduensis
6401143	6401143	PRJEB25583_P_NODE_7006_length_160_cov_1.260163_g6829_i0	PRJEB25583	7006	160	1.260163	2.0162608	Pseudomonas fluorescens	294	Bacteria	Bacteria	274	2.5999999999999997e-69	NTclustered	gi\|1403366562\|emb\|LS483372.1\|	294	g6829	i0	97.5	3.3	160	4	100	0	1	160	1782510	1782351	Pseudomonas fluorescens strain NCTC10038 genome assembly, chromosome: 1	blastn	528	274	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas fluorescens
6401145	6401145	PRJEB25583_P_NODE_7546_length_156_cov_0.974790_g7369_i0	PRJEB25583	7546	156	0.97479	1.5206724	Pseudomonas fluorescens	294	Bacteria	Bacteria	283	4.1899999999999994e-72	NTclustered	gi\|1403366562\|emb\|LS483372.1\|	294	g7369	i0	99.359	99.7564102564103	156	1	100	0	1	156	562688	562533	Pseudomonas fluorescens strain NCTC10038 genome assembly, chromosome: 1	blastn	15562	283	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas fluorescens
7364099	7364099	PRJEB25583_P_NODE_1006_length_463_cov_24.260563_g831_i0	PRJEB25583	1006	463	24.260563	112.32640669	Roseateles	93681	Bacteria	Bacteria	787	0	NTclustered	gi\|1033652334\|gb\|CP011514.1\|	1658665	g831	i0	99.089	246.976241900648	439	3	95	1	21	458	5819191	5819629	Mitsuaria sp. 7, complete genome	blastn	114350	787	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Roseateles	Mitsuaria sp. 7
7364136	7364136	PRJEB25583_P_NODE_5246_length_180_cov_0.986014_g5069_i0	PRJEB25583	5246	180	0.986014	1.7748252	Enterobacteriaceae	543	Bacteria	Bacteria	333	4.87e-87	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g5069	i0	100	100	180	0	100	0	1	180	3224828	3225007	Escherichia coli strain Case 2 chromosome, complete genome	blastn	18000	333	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
7675273	7675273	PRJEB25583_P_NODE_6267_length_167_cov_1.184615_g6090_i0	PRJEB25583	6267	167	1.184615	1.97830705	Ectopseudomonas chengduensis	489632	Bacteria	Bacteria	309	7.53e-80	NTclustered	gi\|2536885667\|gb\|CP129400.1\|	489632	g6090	i0	100	25.9101796407186	167	0	100	0	1	167	3761573	3761739	Ectopseudomonas chengduensis strain WD211 chromosome, complete genome	blastn	4327	309	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Ectopseudomonas	Ectopseudomonas chengduensis
8639523	8639523	PRJEB25583_P_NODE_5247_length_180_cov_0.951049_g5070_i0	PRJEB25583	5247	180	0.951049	1.7118882	Bacteria	2	Bacteria	Bacteria	226	8.5e-55	NTclustered	gi\|2315134744\|gb\|CP106759.1\|	40324	g5070	i0	95.714	241.555555555556	140	6	78	0	1	140	329990	330129	Stenotrophomonas maltophilia strain SG.Y2 chromosome, complete genome	blastn	43480	228	0.991228070175439	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Lysobacteraceae	Stenotrophomonas	Stenotrophomonas maltophilia
8639536	8639536	PRJEB25583_P_NODE_6447_length_165_cov_1.375000_g6270_i0	PRJEB25583	6447	165	1.375	2.26875	Escherichia	561	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2841922414\|gb\|CP163901.1\|	562	g6270	i0	100	101	165	0	100	0	1	165	4053568	4053404	Escherichia coli strain OXEC-129 chromosome, complete genome	blastn	16665	305	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
8639552	8639552	PRJEB25583_P_NODE_7527_length_156_cov_1.243697_g7350_i0	PRJEB25583	7527	156	1.243697	1.94016732	Oxalobacteraceae	75682	Bacteria	Bacteria	207	2.59e-49	NTclustered	gi\|2293293099\|gb\|CP103371.1\|	2970464	g7350	i0	90.909	94.3141025641026	154	14	99	0	3	156	635213	635366	Massilia sp. H6 chromosome, complete genome	blastn	14713	207	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Massilia	Massilia sp. H6
8639559	8639559	PRJEB25583_P_NODE_887_length_504_cov_56.899358_g715_i0	PRJEB25583	887	504	56.899358	286.77276432	Enterobacteriaceae	543	Bacteria	Bacteria	883	0	NTclustered	gi\|2618357005\|gb\|CP137721.1\|	562	g715	i0	99.793	656.734126984127	482	0	95	1	3	483	5149492	5149973	Escherichia coli strain HNTH2207 chromosome	blastn	330994	883	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
9914547	9914547	PRJEB25583_P_NODE_2708_length_247_cov_1.285714_g2531_i0	PRJEB25583	2708	247	1.285714	3.17571358	Enterobacteriaceae	543	Bacteria	Bacteria	418	1.9099999999999998e-112	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g2531	i0	100	91.497975708502	226	0	91	0	22	247	541073	540848	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	22600	418	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
9914576	9914576	PRJEB25583_P_NODE_4888_length_185_cov_2.952703_g4711_i0	PRJEB25583	4888	185	2.952703	5.46250055	Haemophilus	724	Bacteria	Bacteria	337	3.89e-88	NTclustered	gi\|1919208202\|gb\|CP063113.1\|	729	g4711	i0	99.459	555.048648648649	185	1	100	0	1	185	408148	408332	Haemophilus parainfluenzae strain M1C147_1 chromosome, complete genome	blastn	102684	337	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	Haemophilus parainfluenzae
9914581	9914581	PRJEB25583_P_NODE_5348_length_178_cov_1.879433_g5171_i0	PRJEB25583	5348	178	1.879433	3.34539074	Neisseria	482	Bacteria	Bacteria	329	6.21e-86	NTclustered	gi\|1633799129\|gb\|CP039886.1\|	484	g5171	i0	100	351.016853932584	178	0	100	0	1	178	126953	126776	Neisseria flavescens strain ATCC 13120 chromosome, complete genome	blastn	62481	329	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Neisseriaceae	Neisseria	Neisseria flavescens
11189757	11189757	PRJEB25583_P_NODE_3349_length_221_cov_1.429348_g3172_i0	PRJEB25583	3349	221	1.429348	3.15885908	Gammaproteobacteria	1236	Bacteria	Bacteria	409	1.0100000000000001e-109	NTclustered	gi\|2890464394\|gb\|CP177216.1\|	562	g3172	i0	100	855.085972850679	221	0	100	0	1	221	227323	227103	Escherichia coli strain ECDA0423 chromosome, complete genome	blastn	188974	409	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
11189785	11189785	PRJEB25583_P_NODE_6429_length_165_cov_1.742188_g6252_i0	PRJEB25583	6429	165	1.742188	2.8746102	Enterobacteriaceae	543	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g6252	i0	100	100	165	0	100	0	1	165	4593252	4593088	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	16500	305	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
12465554	12465554	PRJEB25583_P_NODE_3830_length_207_cov_1.717647_g3653_i0	PRJEB25583	3830	207	1.717647	3.55552929	Escherichia	561	Bacteria	Bacteria	383	5.65e-102	NTclustered	gi\|2577445669\|gb\|CP115178.1\|	562	g3653	i0	100	83.0048309178744	207	0	100	0	1	207	2132749	2132955	Escherichia coli strain B chromosome, complete genome	blastn	17182	383	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
13739912	13739912	PRJEB25583_P_NODE_6011_length_170_cov_1.157895_g5834_i0	PRJEB25583	6011	170	1.157895	1.9684215	Pseudomonadaceae	135621	Bacteria	Bacteria	315	1.64e-81	NTclustered	gi\|2536885667\|gb\|CP129400.1\|	489632	g5834	i0	100	93.6058823529412	170	0	100	0	1	170	2334648	2334817	Ectopseudomonas chengduensis strain WD211 chromosome, complete genome	blastn	15913	315	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Ectopseudomonas	Ectopseudomonas chengduensis
13739922	13739922	PRJEB25583_P_NODE_6431_length_165_cov_1.648438_g6254_i0	PRJEB25583	6431	165	1.648438	2.7199227	Enterobacteriaceae	543	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2211724983\|gb\|CP066839.1\|	562	g6254	i0	100	100	165	0	100	0	1	165	768565	768729	Escherichia coli strain Ec-RL2-1X chromosome, complete genome	blastn	16500	305	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
13739931	13739931	PRJEB25583_P_NODE_7011_length_160_cov_1.252033_g6834_i0	PRJEB25583	7011	160	1.252033	2.0032528	Legionella	445	Bacteria	Bacteria	296	5.55e-76	NTclustered	gi\|1073872134\|gb\|CP015928.1\|	446	g6834	i0	100	271	160	0	100	0	1	160	362277	362436	Legionella pneumophila strain Philadelphia_1_CDC, complete genome	blastn	43360	296	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Legionellales	Legionellaceae	Legionella	Legionella pneumophila
15014340	15014340	PRJEB25583_P_NODE_5752_length_173_cov_1.139706_g5575_i0	PRJEB25583	5752	173	1.139706	1.97169138	Enterobacteriaceae	543	Bacteria	Bacteria	320	3.61e-83	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g5575	i0	100	107.364161849711	173	0	100	0	1	173	1813663	1813491	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	18574	320	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
15014350	15014350	PRJEB25583_P_NODE_6472_length_165_cov_1.132812_g6295_i0	PRJEB25583	6472	165	1.132812	1.8691398	Enterobacteriaceae	543	Bacteria	Bacteria	294	2.08e-75	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g6295	i0	98.788	193.333333333333	165	2	100	0	1	165	788886	789050	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	31900	294	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
15014378	15014378	PRJEB25583_P_NODE_8492_length_150_cov_1.017699_g8315_i0	PRJEB25583	8492	150	1.017699	1.5265485	Enterobacteriaceae	543	Bacteria	Bacteria	278	1.85e-70	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g8315	i0	100	100	150	0	100	0	1	150	4108121	4107972	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	15000	278	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
16289125	16289125	PRJEB25583_P_NODE_4013_length_203_cov_0.927711_g3836_i0	PRJEB25583	4013	203	0.927711	1.88325333	Bacteria	2	Bacteria	Bacteria	156	1.31e-33	NTclustered	gi\|857118485\|gb\|CP011223.1\|	730	g3836	i0	80.597	5.96059113300493	201	39	99	0	1	201	1763299	1763499	[Haemophilus] ducreyi strain 6644 chromosome	blastn	1210	156	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	[Haemophilus] ducreyi
16289168	16289168	PRJEB25583_P_NODE_7773_length_154_cov_1.641026_g7596_i0	PRJEB25583	7773	154	1.641026	2.52718004	Escherichia	561	Bacteria	Bacteria	285	1.14e-72	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g7596	i0	100	192.331168831169	154	0	100	0	1	154	4453977	4454130	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	29619	285	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
17564252	17564252	PRJEB25583_P_NODE_1994_length_297_cov_1.565385_g1817_i0	PRJEB25583	1994	297	1.565385	4.64919345	Enterobacteriaceae	543	Bacteria	Bacteria	549	8.029999999999997e-152	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g1817	i0	100	169.69696969697	297	0	100	0	1	297	227176	226880	Escherichia coli strain Case 2 chromosome, complete genome	blastn	50400	549	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
18838255	18838255	PRJEB25583_P_NODE_4795_length_187_cov_1.706667_g4618_i0	PRJEB25583	4795	187	1.706667	3.19146729	Aeromonas	642	Bacteria	Bacteria	346	6.56e-91	NTclustered	gi\|2209819103\|gb\|CP093309.1\|	644	g4618	i0	100	941.96256684492	187	0	100	0	1	187	298735	298549	Aeromonas hydrophila strain AC133 chromosome, complete genome	blastn	176147	346	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Aeromonadales	Aeromonadaceae	Aeromonas	Aeromonas hydrophila
19148496	19148496	PRJEB25583_P_NODE_916_length_493_cov_9.936404_g744_i0	PRJEB25583	916	493	9.936404	48.98647172	Vogesella sp. XCS3	2877939	Bacteria	Bacteria	785	0	NTclustered	gi\|2124242701\|gb\|CP085530.1\|	2877939	g744	i0	96.632	428.257606490872	475	12	96	4	21	493	1283465	1282993	Vogesella sp. XCS3 chromosome, complete genome	blastn	211131	785	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Neisseriales	Chromobacteriaceae	Vogesella	Vogesella sp. XCS3
20112987	20112987	PRJEB25583_P_NODE_6096_length_169_cov_1.106061_g5919_i0	PRJEB25583	6096	169	1.106061	1.86924309	Enterobacteriaceae	543	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|2211724983\|gb\|CP066839.1\|	562	g5919	i0	100	100	169	0	100	0	1	169	3672423	3672591	Escherichia coli strain Ec-RL2-1X chromosome, complete genome	blastn	16900	313	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
20112994	20112994	PRJEB25583_P_NODE_6656_length_163_cov_1.301587_g6479_i0	PRJEB25583	6656	163	1.301587	2.12158681	Enterobacteriaceae	543	Bacteria	Bacteria	302	1.22e-77	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g6479	i0	100	100	163	0	100	0	1	163	678160	677998	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	16300	302	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
20113004	20113004	PRJEB25583_P_NODE_7416_length_157_cov_1.133333_g7239_i0	PRJEB25583	7416	157	1.133333	1.77933281	Gammaproteobacteria	1236	Bacteria	Bacteria	291	2.52e-74	NTclustered	gi\|1384513437\|gb\|CP029148.1\|	287	g7239	i0	100	100	157	0	100	0	1	157	2437400	2437556	Pseudomonas aeruginosa strain AR_0440 chromosome	blastn	15700	291	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas aeruginosa
21388507	21388507	PRJEB25583_P_NODE_1857_length_309_cov_6.191176_g1680_i0	PRJEB25583	1857	309	6.191176	19.13073384	Enterobacteriaceae	543	Bacteria	Bacteria	532	8.45e-147	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g1680	i0	100	93.2038834951456	288	0	93	0	1	288	1033727	1033440	Escherichia coli strain Case 2 chromosome, complete genome	blastn	28800	532	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
21388533	21388533	PRJEB25583_P_NODE_4097_length_201_cov_1.420732_g3920_i0	PRJEB25583	4097	201	1.420732	2.85567132	Escherichia	561	Bacteria	Bacteria	372	1.18e-98	NTclustered	gi\|2577445669\|gb\|CP115178.1\|	562	g3920	i0	100	95.9950248756219	201	0	100	0	1	201	2132665	2132465	Escherichia coli strain B chromosome, complete genome	blastn	19295	372	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
21388585	21388585	PRJEB25583_P_NODE_8237_length_151_cov_1.526316_g8060_i0	PRJEB25583	8237	151	1.526316	2.30473716	Enterobacteriaceae	543	Bacteria	Bacteria	279	5.19e-71	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g8060	i0	100	100	151	0	100	0	1	151	1523303	1523153	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	15100	279	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
21699694	21699694	PRJEB25583_P_NODE_1918_length_304_cov_2.000000_g1741_i0	PRJEB25583	1918	304	2	6.08	Roseateles amylovorans	2978473	Bacteria	Bacteria	501	2.34e-137	NTclustered	gi\|2327629256\|gb\|CP104562.2\|	2978473	g1741	i0	96.393	384.608552631579	305	9	100	2	1	304	1744443	1744746	Roseateles amylovorans strain BIM B-1768 chromosome, complete genome	blastn	116921	501	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Sphaerotilaceae	Roseateles	Roseateles amylovorans
22663352	22663352	PRJEB25583_P_NODE_1678_length_330_cov_2.088737_g1501_i0	PRJEB25583	1678	330	2.088737	6.8928321	Acinetobacter	469	Bacteria	Bacteria	593	4.119999999999999e-165	NTclustered	gi\|1751391443\|gb\|CP019143.2\|	28090	g1501	i0	99.091	646.733333333333	330	3	100	0	1	330	28301	28630	Acinetobacter lwoffii strain ZS207 chromosome, complete genome	blastn	213422	593	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter lwoffii
22663393	22663393	PRJEB25583_P_NODE_5298_length_179_cov_1.232394_g5121_i0	PRJEB25583	5298	179	1.232394	2.20598526	Escherichia	561	Bacteria	Bacteria	331	1.74e-86	NTclustered	gi\|2507144281\|gb\|CP122454.1\|	562	g5121	i0	100	100	179	0	100	0	1	179	2362920	2363098	Escherichia coli strain 82.0311 chromosome, complete genome	blastn	17900	331	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
22663416	22663416	PRJEB25583_P_NODE_7118_length_159_cov_1.270492_g6941_i0	PRJEB25583	7118	159	1.270492	2.02008228	Gammaproteobacteria	1236	Bacteria	Bacteria	224	2.64e-54	NTclustered	gi\|1985959268\|gb\|CP069437.1\|	34062	g6941	i0	98.438	338.88050314465403	128	1	100	1	30	156	1497104	1497231	Moraxella osloensis strain FDAARGOS_1202 chromosome, complete genome	blastn	53882	226	0.991150442477876	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
22974952	22974952	PRJEB25583_P_NODE_2419_length_264_cov_1.185022_g2242_i0	PRJEB25583	2419	264	1.185022	3.12845808	Undibacterium sp. YM2	2058625	Bacteria	Bacteria	250	7.97e-62	NTclustered	gi\|1798099803\|dbj\|AP018441.1\|	2058625	g2242	i0	83.774	9.74621212121212	265	41	100	2	1	264	448974	448711	Undibacterium sp. YM2 DNA, complete genome	blastn	2573	250	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium sp. YM2
22974954	22974954	PRJEB25583_P_NODE_2539_length_256_cov_3.493151_g2362_i0	PRJEB25583	2539	256	3.493151	8.94246656	[Haemophilus] ducreyi	730	Bacteria	Bacteria	429	9.2e-116	NTclustered	gi\|857120193\|gb\|CP011224.1\|	730	g2362	i0	96.899	355.4765625	258	5	100	3	1	256	1680640	1680384	[Haemophilus] ducreyi strain HD183 chromosome	blastn	91002	429	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Haemophilus	[Haemophilus] ducreyi
23938766	23938766	PRJEB25583_P_NODE_3999_length_203_cov_1.500000_g3822_i0	PRJEB25583	3999	203	1.5	3.045	root	1	Root_unresolved	Root_unresolved	359	9.31e-95	NTclustered	gi\|2577445669\|gb\|CP115178.1\|	562	g3822	i0	98.522	141.990147783251	203	3	100	0	1	203	900946	901148	Escherichia coli strain B chromosome, complete genome	blastn	28824	359	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
23938773	23938773	PRJEB25583_P_NODE_4579_length_191_cov_1.941558_g4402_i0	PRJEB25583	4579	191	1.941558	3.70837578	Escherichia	561	Bacteria	Bacteria	322	1.13e-83	NTclustered	gi\|2703029942\|gb\|CP148416.1\|	562	g4402	i0	100	91.2356020942408	174	0	91	0	18	191	1255645	1255818	Escherichia coli strain Z1323CEC0016 chromosome, complete genome	blastn	17426	322	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
23938819	23938819	PRJEB25583_P_NODE_8499_length_150_cov_0.929204_g8322_i0	PRJEB25583	8499	150	0.929204	1.393806	Enterobacteriaceae	543	Bacteria	Bacteria	278	1.85e-70	NTclustered	gi\|2294768425\|gb\|CP103666.1\|	548	g8322	i0	100	16	150	0	100	0	1	150	251814	251665	Klebsiella aerogenes strain 4417 plasmid pMB5632_2, complete sequence	blastn	2400	278	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella aerogenes
24248806	24248806	PRJEB25583_P_NODE_2420_length_263_cov_23.805310_g2243_i0	PRJEB25583	2420	263	23.80531	62.6079653	Vibrio algicola	2662262	Bacteria	Bacteria	481	2.58e-131	NTclustered	gi\|1772817214\|gb\|CP045699.1\|	2662262	g2243	i0	99.62	890.049429657795	263	1	100	0	1	263	57535	57797	Vibrio algicola strain SM1977 chromosome 1, complete sequence	blastn	234083	481	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio algicola
24248825	24248825	PRJEB25583_P_NODE_5060_length_183_cov_1.041096_g4883_i0	PRJEB25583	5060	183	1.041096	1.90520568	Pseudomonas fluorescens	294	Bacteria	Bacteria	339	1.07e-88	NTclustered	gi\|1403366562\|emb\|LS483372.1\|	294	g4883	i0	100	92.5573770491803	183	0	100	0	1	183	2164881	2164699	Pseudomonas fluorescens strain NCTC10038 genome assembly, chromosome: 1	blastn	16938	339	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas fluorescens
24248848	24248848	PRJEB25583_P_NODE_960_length_478_cov_33.195011_g787_i0	PRJEB25583	960	478	33.195011	158.67215258	Acinetobacter lanii	2715163	Bacteria	Bacteria	773	0	NTclustered	gi\|1822446246\|gb\|CP049916.1\|	2715163	g787	i0	96.957	667.995815899582	460	14	96	0	19	478	26863	27322	Acinetobacter lanii strain 185 chromosome, complete genome	blastn	319302	773	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter lanii
25212556	25212556	PRJEB25583_P_NODE_6060_length_169_cov_1.734848_g5883_i0	PRJEB25583	6060	169	1.734848	2.93189312	Enterobacteriaceae	543	Bacteria	Bacteria	313	5.859999999999999e-81	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g5883	i0	100	100	169	0	100	0	1	169	1310662	1310494	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	16900	313	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli

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