metadata: contig_metadata: 69 rows where analysis = "blastn", bioproject = "PRJNA798511" and tax

69 rows where analysis = "blastn", bioproject = "PRJNA798511" 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
790036	790036	PRJNA798511_P_NODE_21201_length_756_cov_2.303075_g17163_i0	PRJNA798511	21201	756	2.303075	17.411247	Vibrio breoganii	553239	Bacteria	Bacteria	54.7	0.021	NTclustered	gi\|1041052959\|gb\|CP016178.1\|	553239	g17163	i0	100	0.0383597883597884	29	0	4	0	74	102	968221	968193	Vibrio breoganii strain FF50 chromosome 2, complete sequence	blastn	29	54.7	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio breoganii
1217657	1217657	PRJNA798511_P_NODE_64581_length_304_cov_0.978355_g60315_i0	PRJNA798511	64581	304	0.978355	2.9741992	Enterobacteriaceae	543	Bacteria	Bacteria	558	1.37e-154	NTclustered	gi\|2211724983\|gb\|CP066839.1\|	562	g60315	i0	100	99.3421052631579	302	0	99	0	1	302	1716836	1716535	Escherichia coli strain Ec-RL2-1X chromosome, complete genome	blastn	30200	558	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
2065334	2065334	PRJNA798511_P_NODE_100242_length_243_cov_0.905882_g95976_i0	PRJNA798511	100242	243	0.905882	2.20129326	Ralstonia sp. CP	3231757	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|2770908261\|gb\|CP160434.1\|	3231757	g95976	i0	100	12.9835390946502	243	0	100	0	1	243	215501	215259	Ralstonia sp. CP chromosome 2, complete sequence	blastn	3155	449	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Burkholderiaceae	Ralstonia	Ralstonia sp. CP
2066935	2066935	PRJNA798511_P_NODE_84322_length_258_cov_1.248649_g80056_i0	PRJNA798511	84322	258	1.248649	3.22151442	Candidatus Stammera capleta	2608262	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2676815311\|gb\|CP144782.1\|	2608262	g80056	i0	100	0.112403100775194	29	0	11	0	193	221	225895	225923	MAG: Candidatus Stammera capleta isolate GKJPGKMO chromosome	blastn	29	54.7	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Stammera	Candidatus Stammera capleta
2066946	2066946	PRJNA798511_P_NODE_84842_length_257_cov_1.244565_g80576_i0	PRJNA798511	84842	257	1.244565	3.19853205	Acinetobacter corruptisaponis	3045147	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2508164530\|gb\|CP125669.1\|	3045147	g80576	i0	100	0.108949416342412	28	0	11	0	227	254	219618	219591	Acinetobacter corruptisaponis strain KCTC 92772 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter corruptisaponis
2067136	2067136	PRJNA798511_P_NODE_99042_length_243_cov_2.264706_g94776_i0	PRJNA798511	99042	243	2.264706	5.50323558	Candidatus Purcelliella pentastirinorum	472834	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2449377876\|gb\|CP110497.1\|	472834	g94776	i0	100	0.230452674897119	28	0	12	0	79	106	325357	325330	Candidatus Purcelliella pentastirinorum isolate OPOL1 chromosome, complete genome	blastn	56	52.8	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Purcelliella	Candidatus Purcelliella pentastirinorum
2493197	2493197	PRJNA798511_P_NODE_60422_length_316_cov_1.679012_g56156_i0	PRJNA798511	60422	316	1.679012	5.30567792	Acinetobacter	469	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|902756494\|emb\|LN868200.1\|	470	g56156	i0	100	0.265822784810127	28	0	9	0	289	316	738306	738333	Acinetobacter baumannii genome assembly R2090, chromosome : I	blastn	84	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii
2493204	2493204	PRJNA798511_P_NODE_76342_length_275_cov_0.841584_g72076_i0	PRJNA798511	76342	275	0.841584	2.314356	Escherichia	561	Bacteria	Bacteria	508	1.2499999999999999e-139	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g72076	i0	100	100	275	0	100	0	1	275	815756	816030	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	27500	508	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
3341792	3341792	PRJNA798511_P_NODE_58463_length_323_cov_0.944000_g54197_i0	PRJNA798511	58463	323	0.944	3.04912	Eleftheria terrae	1597781	Bacteria	Bacteria	472	1.96e-128	NTclustered	gi\|2533425405\|gb\|CP106951.1\|	1597781	g54197	i0	93.168	238.43653250774	322	20	99	2	2	323	360039	359720	Eleftheria terrae strain P9846-PB chromosome, complete genome	blastn	77015	472	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Eleftheria	Eleftheria terrae
3342230	3342230	PRJNA798511_P_NODE_88863_length_251_cov_0.865169_g84597_i0	PRJNA798511	88863	251	0.865169	2.17157419	Herbaspirillum huttiense	863372	Bacteria	Bacteria	442	1.1599999999999995e-119	NTclustered	gi\|2735198065\|gb\|CP156025.1\|	863372	g84597	i0	98.406	76.9880478087649	251	4	100	0	1	251	2613722	2613472	Herbaspirillum huttiense strain CLJ01 chromosome, complete genome	blastn	19324	442	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Herbaspirillum	Herbaspirillum huttiense
3769446	3769446	PRJNA798511_P_NODE_68943_length_292_cov_1.242009_g64677_i0	PRJNA798511	68943	292	1.242009	3.62666628	Rhizobium	379	Bacteria	Bacteria	60.2	1.62e-4	NTclustered	gi\|209533368\|gb\|CP001191.1\|	395492	g64677	i0	92.683	0.48972602739726	41	3	14	0	34	74	65004	65044	Rhizobium leguminosarum bv. trifolii WSM2304 chromosome, complete genome	blastn	143	60.2	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Rhizobiaceae	Rhizobium	Rhizobium leguminosarum
3769457	3769457	PRJNA798511_P_NODE_81343_length_264_cov_1.209424_g77077_i0	PRJNA798511	81343	264	1.209424	3.19287936	Escherichia	561	Bacteria	Bacteria	483	7.219999999999998e-132	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g77077	i0	99.621	100	264	1	100	0	1	264	2557801	2557538	Escherichia coli strain Case 2 chromosome, complete genome	blastn	26400	483	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
4619681	4619681	PRJNA798511_P_NODE_98344_length_244_cov_0.900585_g94078_i0	PRJNA798511	98344	244	0.900585	2.1974274	Aggregatibacter sp. HMT-949	3235088	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2797270348\|gb\|CP162010.1\|	3235088	g94078	i0	100	0.114754098360656	28	0	11	0	57	84	62192	62165	Aggregatibacter sp. HMT-949 strain W10649 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Aggregatibacter	Aggregatibacter sp. HMT-949
5045853	5045853	PRJNA798511_P_NODE_33584_length_488_cov_1.277108_g29326_i0	PRJNA798511	33584	488	1.277108	6.23228704	Providencia	586	Bacteria	Bacteria	80.5	2.18e-10	NTclustered	gi\|1874486235\|gb\|CP058958.1\|	587	g29326	i0	92.727	5.07581967213115	55	4	11	0	362	416	1311335	1311389	Providencia rettgeri strain G0519 chromosome, complete genome	blastn	2477	80.5	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Morganellaceae	Providencia	Providencia rettgeri
5045869	5045869	PRJNA798511_P_NODE_64184_length_305_cov_0.995690_g59918_i0	PRJNA798511	64184	305	0.99569	3.0368545	Enterobacteriaceae	543	Bacteria	Bacteria	564	2.95e-156	NTclustered	gi\|2094796158\|gb\|CP081706.1\|	562	g59918	i0	100	100	305	0	100	0	1	305	3444438	3444742	Escherichia coli strain AH04 chromosome, complete genome	blastn	30500	564	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
5894392	5894392	PRJNA798511_P_NODE_66585_length_298_cov_1.293333_g62319_i0	PRJNA798511	66585	298	1.293333	3.85413234	Acinetobacter baumannii	470	Bacteria	Bacteria	52.8	0.028	NTclustered	gi\|2823545944\|gb\|CP134594.1\|	470	g62319	i0	100	0.0939597315436242	28	0	9	0	138	165	107843	107870	Acinetobacter baumannii strain XH1019 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii
6321778	6321778	PRJNA798511_P_NODE_82065_length_262_cov_1.629630_g77799_i0	PRJNA798511	82065	262	1.62963	4.2696306	Acinetobacter	469	Bacteria	Bacteria	479	9.249999999999999e-131	NTclustered	gi\|1943168292\|gb\|CP065666.1\|	40214	g77799	i0	99.618	42.4885496183206	262	1	100	0	1	262	2304116	2304377	Acinetobacter johnsonii strain FDAARGOS_910 chromosome, complete genome	blastn	11132	479	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter johnsonii
7168998	7168998	PRJNA798511_P_NODE_53826_length_340_cov_0.850187_g49560_i0	PRJNA798511	53826	340	0.850187	2.8906358	Gilliamella apis	1970738	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|2563316466\|gb\|CP132382.1\|	1970738	g49560	i0	100	0.0823529411764706	28	0	8	0	148	175	1053737	1053764	Gilliamella apis strain ESL0169 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Orbales	Orbaceae	Gilliamella	Gilliamella apis
7169041	7169041	PRJNA798511_P_NODE_56566_length_329_cov_2.367188_g52300_i0	PRJNA798511	56566	329	2.367188	7.78804852	Thalassotalea psychrophila	3065647	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|2578649588\|gb\|CP134145.1\|	3065647	g52300	i0	100	0.0851063829787234	28	0	9	0	36	63	660920	660947	Thalassotalea psychrophila strain SQ149 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Colwelliaceae	Thalassotalea	Thalassotalea psychrophila
7169378	7169378	PRJNA798511_P_NODE_80826_length_265_cov_1.203125_g76560_i0	PRJNA798511	80826	265	1.203125	3.18828125	alpha proteobacterium HIMB5	859653	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|406651373\|gb\|CP003809.1\|	859653	g76560	i0	100	0.105660377358491	28	0	11	0	100	127	613049	613076	Alpha proteobacterium HIMB5 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Candidatus Pelagibacterales	Candidatus Pelagibacteraceae		alpha proteobacterium HIMB5
7169388	7169388	PRJNA798511_P_NODE_81266_length_264_cov_1.298429_g77000_i0	PRJNA798511	81266	264	1.298429	3.42785256	Pelagibacterales bacterium CODY6	3079881	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2592542485\|gb\|CP136340.1\|	3079881	g77000	i0	100	0.109848484848485	29	0	11	0	160	188	317167	317195	Pelagibacterales bacterium CODY6 chromosome	blastn	29	54.7	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Candidatus Pelagibacterales			Pelagibacterales bacterium CODY6
7595888	7595888	PRJNA798511_P_NODE_94166_length_247_cov_0.885057_g89900_i0	PRJNA798511	94166	247	0.885057	2.18609079	Enterobacteriaceae	543	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1880730616\|gb\|CP056821.1\|	562	g89900	i0	100	100	247	0	100	0	1	247	419117	418871	Escherichia coli strain RHBSTW-00139 chromosome, complete genome	blastn	24700	457	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
8442637	8442637	PRJNA798511_P_NODE_102987_length_241_cov_0.916667_g98721_i0	PRJNA798511	102987	241	0.916667	2.20916747	Pararoseomonas sp. SCSIO 73927	3114537	Bacteria	Bacteria	150	7.48e-32	NTclustered	gi\|2693424943\|gb\|CP146232.1\|	3114537	g98721	i0	89.744	9.47302904564315	117	12	49	0	12	128	697871	697987	Pararoseomonas sp. SCSIO 73927 chromosome, complete genome	blastn	2283	150	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Acetobacterales	Acetobacteraceae	Pararoseomonas	Pararoseomonas sp. SCSIO 73927
8443717	8443717	PRJNA798511_P_NODE_54107_length_338_cov_4.343396_g49841_i0	PRJNA798511	54107	338	4.343396	14.68067848	Buchnera aphidicola	9	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|1584372640\|emb\|LR217707.1\|	2518976	g49841	i0	100	0.0828402366863905	28	0	8	0	171	198	231256	231229	Buchnera aphidicola (Cinara kochiana kochiana) strain BuCikochiana genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Erwiniaceae	Buchnera	Buchnera aphidicola
8870939	8870939	PRJNA798511_P_NODE_34867_length_473_cov_1.110000_g30608_i0	PRJNA798511	34867	473	1.11	5.2503	Serratia	613	Bacteria	Bacteria	52.8	0.046	NTclustered	gi\|2273374106\|gb\|CP100764.1\|	82996	g30608	i0	100	0.236786469344609	28	0	6	0	46	73	1429812	1429785	Serratia plymuthica strain SASK2000 chromosome, complete genome	blastn	112	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Yersiniaceae	Serratia	Serratia plymuthica
8870962	8870962	PRJNA798511_P_NODE_97407_length_245_cov_0.895349_g93141_i0	PRJNA798511	97407	245	0.895349	2.19360505	Enterobacteriaceae	543	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g93141	i0	100	100	245	0	100	0	1	245	4722124	4722368	Escherichia coli strain Case 2 chromosome, complete genome	blastn	24500	453	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
9718475	9718475	PRJNA798511_P_NODE_35208_length_469_cov_0.868687_g30949_i0	PRJNA798511	35208	469	0.868687	4.07414203	Teredinibacter turnerae	2426	Bacteria	Bacteria	52.8	0.046	NTclustered	gi\|2707054170\|gb\|CP149818.1\|	2426	g30949	i0	100	0.0597014925373134	28	0	6	0	331	358	3562475	3562448	Teredinibacter turnerae strain SR01903 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Cellvibrionales	Cellvibrionaceae	Teredinibacter	Teredinibacter turnerae
9718524	9718524	PRJNA798511_P_NODE_37848_length_440_cov_1.871935_g33588_i0	PRJNA798511	37848	440	1.871935	8.236514	Allofrancisella frigidaquae	1085644	Bacteria	Bacteria	52.8	0.043	NTclustered	gi\|1829555750\|gb\|CP038017.1\|	1085644	g33588	i0	100	0.0636363636363636	28	0	6	0	3	30	337325	337298	Allofrancisella frigidaquae strain SYSU 10HL1970 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Thiotrichales	Francisellaceae	Allofrancisella	Allofrancisella frigidaquae
9719111	9719111	PRJNA798511_P_NODE_73628_length_280_cov_2.913043_g69362_i0	PRJNA798511	73628	280	2.913043	8.1565204	Candidatus Stammera capleta	2608262	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2676815342\|gb\|CP144817.1\|	2608262	g69362	i0	100	0.1	28	0	10	0	14	41	102630	102657	MAG: Candidatus Stammera capleta isolate HMMJOMFK chromosome	blastn	28	52.8	1	Bacteria	ant, tsetse, mealybug, aphid, etc. endosymbionts	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Stammera	Candidatus Stammera capleta
10146262	10146262	PRJNA798511_P_NODE_62428_length_310_cov_1.299578_g58162_i0	PRJNA798511	62428	310	1.299578	4.0286918	Pseudomonas	286	Bacteria	Bacteria	573	4.999999999999998e-159	NTclustered	gi\|2668351754\|gb\|CP143576.1\|	515393	g58162	i0	100	99.941935483871	310	0	100	0	1	310	65895	65586	Pseudomonas yamanorum strain SFB8.6 chromosome, complete genome	blastn	30982	573	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas yamanorum
10146273	10146273	PRJNA798511_P_NODE_89648_length_250_cov_0.870056_g85382_i0	PRJNA798511	89648	250	0.870056	2.17514	root	1	Root_unresolved	Root_unresolved	457	4.1099999999999985e-124	NTclustered	gi\|2103607268\|gb\|CP083989.1\|	106649	g85382	i0	99.6	5	250	1	100	0	1	250	1665830	1665581	Acinetobacter guillouiae strain PgBE136 chromosome	blastn	1250	457	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter guillouiae
10146274	10146274	PRJNA798511_P_NODE_92128_length_248_cov_1.314286_g87862_i0	PRJNA798511	92128	248	1.314286	3.25942928	Escherichia	561	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g87862	i0	100	100	248	0	100	0	1	248	4382981	4382734	Escherichia coli strain Case 2 chromosome, complete genome	blastn	24800	459	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
10993510	10993510	PRJNA798511_P_NODE_101829_length_242_cov_0.911243_g97563_i0	PRJNA798511	101829	242	0.911243	2.20520806	Candidatus Profftia lariciata	1987921	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2119947790\|gb\|CP045925.1\|	1987921	g97563	i0	100	0.115702479338843	28	0	12	0	52	79	812590	812617	Candidatus Profftia lariciata isolate Ad13-081 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Candidatus Profftia	Candidatus Profftia lariciata
11421613	11421613	PRJNA798511_P_NODE_92869_length_248_cov_0.880000_g88603_i0	PRJNA798511	92869	248	0.88	2.1824	Enterobacteriaceae	543	Bacteria	Bacteria	448	2.4499999999999996e-121	NTclustered	gi\|2241514032\|gb\|CP080080.1\|	562	g88603	i0	99.194	101	248	2	100	0	1	248	1000613	1000366	Escherichia coli strain 19SZHZ886Rt chromosome, complete genome	blastn	25048	448	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
12269799	12269799	PRJNA798511_P_NODE_37270_length_446_cov_2.053619_g33011_i0	PRJNA798511	37270	446	2.053619	9.15914074	Colwellia sp. M166	2583805	Bacteria	Bacteria	52.8	0.043	NTclustered	gi\|2283119412\|gb\|CP040755.1\|	2583805	g33011	i0	100	0.062780269058296	28	0	6	0	190	217	820991	820964	Colwellia sp. M166 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Alteromonadales	Colwelliaceae	Colwellia	Colwellia sp. M166
12269850	12269850	PRJNA798511_P_NODE_39850_length_422_cov_2.065903_g35587_i0	PRJNA798511	39850	422	2.065903	8.71811066	Acinetobacter bouvetii	202951	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2029122949\|dbj\|AP024595.1\|	202951	g35587	i0	100	0.0710900473933649	30	0	7	0	149	178	1808503	1808532	Acinetobacter bouvetii JCM 18991 DNA, complete genome	blastn	30	56.5	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter bouvetii
12269953	12269953	PRJNA798511_P_NODE_46170_length_378_cov_0.957377_g41905_i0	PRJNA798511	46170	378	0.957377	3.61888506	Enterobacteriaceae endosymbiont of Donacia simplex	2675784	Bacteria	Bacteria	52.8	0.036	NTclustered	gi\|1833265032\|gb\|CP046192.1\|	2675784	g41905	i0	100	0.0740740740740741	28	0	7	0	193	220	356825	356852	Enterobacteriaceae endosymbiont of Donacia simplex isolate DsimSym chromosome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae		Enterobacteriaceae endosymbiont of Donacia simplex
12697329	12697329	PRJNA798511_P_NODE_95370_length_246_cov_0.890173_g91104_i0	PRJNA798511	95370	246	0.890173	2.18982558	Escherichia	561	Bacteria	Bacteria	455	1.4500000000000002e-123	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g91104	i0	100	100	246	0	100	0	1	246	1065932	1066177	Escherichia coli strain Case 2 chromosome, complete genome	blastn	24600	455	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
12697331	12697331	PRJNA798511_P_NODE_98270_length_244_cov_0.900585_g94004_i0	PRJNA798511	98270	244	0.900585	2.1974274	Vibrio	662	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1858855023\|gb\|CP053808.1\|	666	g94004	i0	100	100	244	0	100	0	1	244	28326	28083	Vibrio cholerae strain SP7G chromosome 1, complete sequence	blastn	24400	451	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Vibrio	Vibrio cholerae
13543843	13543843	PRJNA798511_P_NODE_3171_length_3085_cov_6.445551_g2404_i0	PRJNA798511	3171	3085	6.445551	198.84524835	Wolbachia endosymbiont (group A) of Clivina fossor	3066133	Bacteria	Bacteria	289	2.25e-72	NTclustered	gi\|2718027859\|emb\|OZ034707.1\|	3066133	g2404	i0	78.475	7.83435980551053	446	92	14	4	908	1351	764715	764272	Wolbachia endosymbiont (group A) of Clivina fossor isolate 54599 genome assembly, chromosome: 1	blastn	24169	289	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Anaplasmataceae	Wolbachia	Wolbachia endosymbiont (group A) of Clivina fossor
13544800	13544800	PRJNA798511_P_NODE_92351_length_248_cov_0.880000_g88085_i0	PRJNA798511	92351	248	0.88	2.1824	Buchnera aphidicola	9	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|116256804\|gb\|CP000263.1\|	372461	g88085	i0	100	0.112903225806452	28	0	11	0	151	178	29411	29384	Buchnera aphidicola BCc, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Erwiniaceae	Buchnera	Buchnera aphidicola
13544881	13544881	PRJNA798511_P_NODE_98491_length_244_cov_0.900585_g94225_i0	PRJNA798511	98491	244	0.900585	2.1974274	Photobacterium damselae	38293	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2186424240\|gb\|CP090485.1\|	85581	g94225	i0	100	0.114754098360656	28	0	11	0	78	105	2812115	2812088	Photobacterium damselae subsp. damselae strain AS-16-0963-1 chromosome 1, complete sequence	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Vibrionales	Vibrionaceae	Photobacterium	Photobacterium damselae
14819626	14819626	PRJNA798511_P_NODE_94432_length_247_cov_0.885057_g90166_i0	PRJNA798511	94432	247	0.885057	2.18609079	Pseudomonas yamanorum	515393	Bacteria	Bacteria	440	4.079999999999999e-119	NTclustered	gi\|1374529460\|gb\|CP012400.2\|	515393	g90166	i0	98.785	93.3198380566802	247	3	100	0	1	247	5466707	5466953	Pseudomonas yamanorum strain LBUM636 chromosome, complete genome	blastn	23050	440	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas yamanorum
16093381	16093381	PRJNA798511_P_NODE_62013_length_311_cov_1.932773_g57747_i0	PRJNA798511	62013	311	1.932773	6.01092403	Candidatus Megaera polyxenophila	988779	Bacteria	Bacteria	67.6	1.04e-6	NTclustered	gi\|2634277034\|gb\|CP113867.1\|	988779	g57747	i0	97.436	0.12540192926045	39	1	13	0	108	146	1262475	1262513	Candidatus Megaera polyxenophila strain NDG2 chromosome, complete genome	blastn	39	67.6	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Rickettsiales	Rickettsiaceae	Candidatus Megaera	Candidatus Megaera polyxenophila
16520664	16520664	PRJNA798511_P_NODE_93133_length_248_cov_0.868571_g88867_i0	PRJNA798511	93133	248	0.868571	2.15405608	Acinetobacter	469	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|2264029138\|gb\|CP076817.1\|	470	g88867	i0	99.597	33.4717741935484	248	1	100	0	1	248	3336024	3335777	Acinetobacter baumannii strain UC24137 chromosome, complete genome	blastn	8301	453	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter baumannii
16520668	16520668	PRJNA798511_P_NODE_98593_length_244_cov_0.900585_g94327_i0	PRJNA798511	98593	244	0.900585	2.1974274	Ottowia	219181	Bacteria	Bacteria	435	1.87e-117	NTclustered	gi\|1364834306\|gb\|CP027666.1\|	2109914	g94327	i0	98.776	407.729508196721	245	2	100	1	1	244	1412429	1412185	Ottowia oryzae strain KADR8-3 chromosome, complete genome	blastn	99486	435	1	Bacteria		Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Ottowia	Ottowia oryzae
17368738	17368738	PRJNA798511_P_NODE_33674_length_487_cov_1.234300_g29416_i0	PRJNA798511	33674	487	1.2343	6.011041	Citrobacter freundii	546	Bacteria	Bacteria	52.8	0.047	NTclustered	gi\|1561314388\|gb\|CP035276.1\|	546	g29416	i0	100	0.0574948665297741	28	0	6	0	381	408	2133645	2133672	Citrobacter freundii strain R17 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Citrobacter	Citrobacter freundii
17368932	17368932	PRJNA798511_P_NODE_43434_length_395_cov_1.142857_g39170_i0	PRJNA798511	43434	395	1.142857	4.51428515	Avibacterium sp. 20-132	2911526	Bacteria	Bacteria	52.8	0.038	NTclustered	gi\|2246631673\|gb\|CP091456.1\|	2911526	g39170	i0	100	0.0708860759493671	28	0	7	0	144	171	2478910	2478937	Avibacterium sp. 20-132 chromosome, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Avibacterium	Avibacterium sp. 20-132
17369547	17369547	PRJNA798511_P_NODE_85794_length_255_cov_1.412088_g81528_i0	PRJNA798511	85794	255	1.412088	3.6008244	Brucella anthropi	529	Bacteria	Bacteria	460	3.25e-125	NTclustered	gi\|2164153709\|gb\|CP088965.1\|	529	g81528	i0	99.216	92.8352941176471	255	2	100	0	1	255	859259	859005	Brucella anthropi strain T210003 chromosome 2, complete sequence	blastn	23673	460	1	Bacteria		Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Brucellaceae	Brucella	Brucella anthropi
17795450	17795450	PRJNA798511_P_NODE_88194_length_251_cov_0.865169_g83928_i0	PRJNA798511	88194	251	0.865169	2.17157419	Enterobacteriaceae	543	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g83928	i0	100	100	251	0	100	0	1	251	535467	535217	Escherichia coli strain Case 2 chromosome, complete genome	blastn	25100	464	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
17795453	17795453	PRJNA798511_P_NODE_96034_length_246_cov_0.861272_g91768_i0	PRJNA798511	96034	246	0.861272	2.11872912	Escherichia	561	Bacteria	Bacteria	427	3.16e-115	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g91768	i0	97.967	100	246	5	100	0	1	246	604929	604684	Escherichia coli strain Case 2 chromosome, complete genome	blastn	24600	427	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
19069458	19069458	PRJNA798511_P_NODE_102755_length_241_cov_0.916667_g98489_i0	PRJNA798511	102755	241	0.916667	2.20916747	Escherichia	561	Bacteria	Bacteria	446	8.519999999999999e-121	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g98489	i0	100	100	241	0	100	0	1	241	1429139	1429379	Escherichia coli strain Case 2 chromosome, complete genome	blastn	24100	446	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
19069473	19069473	PRJNA798511_P_NODE_50835_length_353_cov_1.346429_g46569_i0	PRJNA798511	50835	353	1.346429	4.75289437	Escherichia	561	Bacteria	Bacteria	647	0	NTclustered	gi\|1785206035\|gb\|CP044291.1\|	562	g46569	i0	99.717	100	353	1	100	0	1	353	845945	845593	Escherichia coli strain P43A chromosome, complete genome	blastn	35300	647	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
19069482	19069482	PRJNA798511_P_NODE_58955_length_321_cov_1.270161_g54689_i0	PRJNA798511	58955	321	1.270161	4.07721681	Enterobacteriaceae	543	Bacteria	Bacteria	593	3.9899999999999986e-165	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g54689	i0	100	100	321	0	100	0	1	321	3245878	3246198	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	32100	593	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
19916390	19916390	PRJNA798511_P_NODE_100096_length_243_cov_0.905882_g95830_i0	PRJNA798511	100096	243	0.905882	2.20129326	Psychrobacter sp. P11G5	1699624	Bacteria	Bacteria	58.4	4.71e-4	NTclustered	gi\|1002776240\|gb\|CP012533.1\|	1699624	g95830	i0	100	0.378600823045267	31	0	13	0	98	128	742449	742419	Psychrobacter sp. P11G5, complete genome	blastn	92	58.4	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Psychrobacter	Psychrobacter sp. P11G5
19918111	19918111	PRJNA798511_P_NODE_98716_length_244_cov_0.900585_g94450_i0	PRJNA798511	98716	244	0.900585	2.1974274	Enterobacteriaceae endosymbiont of Donacia bicoloricornis	2675772	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1833266299\|gb\|CP046186.1\|	2675772	g94450	i0	100	0.114754098360656	28	0	11	0	165	192	97776	97749	Enterobacteriaceae endosymbiont of Donacia bicoloricornis isolate DbicSym chromosome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae		Enterobacteriaceae endosymbiont of Donacia bicoloricornis
20344195	20344195	PRJNA798511_P_NODE_70136_length_289_cov_1.143519_g65870_i0	PRJNA798511	70136	289	1.143519	3.30476991	Enterobacteriaceae	543	Bacteria	Bacteria	534	2.18e-147	NTclustered	gi\|2737310786\|gb\|CP157132.1\|	562	g65870	i0	100	100	289	0	100	0	1	289	1656066	1656354	Escherichia coli strain UTAK-18 chromosome, complete genome	blastn	28900	534	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
20344199	20344199	PRJNA798511_P_NODE_84176_length_258_cov_1.475676_g79910_i0	PRJNA798511	84176	258	1.475676	3.80724408	Enterobacteriaceae	543	Bacteria	Bacteria	477	3.2699999999999985e-130	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g79910	i0	100	100	258	0	100	0	1	258	1883683	1883940	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	25800	477	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
21619866	21619866	PRJNA798511_P_NODE_69637_length_290_cov_1.419355_g65371_i0	PRJNA798511	69637	290	1.419355	4.1161295	Lonepinella	53416	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2812725155\|gb\|CP170386.1\|	3003617	g65371	i0	100	0.386206896551724	28	0	10	0	60	87	1610948	1610921	Lonepinella sp. MS14434 chromosome, complete genome	blastn	112	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pasteurellales	Pasteurellaceae	Lonepinella	Lonepinella sp. MS14434
21619876	21619876	PRJNA798511_P_NODE_87277_length_252_cov_1.709497_g83011_i0	PRJNA798511	87277	252	1.709497	4.30793244	Enterobacteriaceae	543	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g83011	i0	100	100	252	0	100	0	1	252	2283864	2283613	Escherichia coli strain Case 2 chromosome, complete genome	blastn	25200	466	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
21619877	21619877	PRJNA798511_P_NODE_92217_length_248_cov_1.097143_g87951_i0	PRJNA798511	92217	248	1.097143	2.72091464	Escherichia	561	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g87951	i0	99.597	100	248	1	100	0	1	248	4036572	4036819	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	24800	453	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
22467707	22467707	PRJNA798511_P_NODE_51558_length_350_cov_0.819495_g47292_i0	PRJNA798511	51558	350	0.819495	2.8682325	Arsenophonus endosymbiont of Ceratovacuna japonica	2950565	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|2257912045\|dbj\|AP026064.1\|	2950565	g47292	i0	100	0.08	28	0	8	0	104	131	571792	571819	MAG: Arsenophonus endosymbiont of Ceratovacuna japonica CjNOSY1 DNA, complete genome	blastn	28	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Morganellaceae	Arsenophonus	Arsenophonus endosymbiont of Ceratovacuna japonica
22895322	22895322	PRJNA798511_P_NODE_86518_length_254_cov_1.093923_g82252_i0	PRJNA798511	86518	254	1.093923	2.77856442	Enterobacteriaceae	543	Bacteria	Bacteria	470	5.37e-128	NTclustered	gi\|2653344983\|gb\|CP142438.1\|	562	g82252	i0	100	100	254	0	100	0	1	254	2065139	2065392	Escherichia coli strain Case 2 chromosome, complete genome	blastn	25400	470	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
25016046	25016046	PRJNA798511_P_NODE_102760_length_241_cov_0.916667_g98494_i0	PRJNA798511	102760	241	0.916667	2.20916747	Moraxella sp. K02	3149046	Bacteria	Bacteria	429	8.58e-116	NTclustered	gi\|2740866591\|dbj\|AP031590.1\|	3149046	g98494	i0	98.755	14	241	3	100	0	1	241	176871	176631	Moraxella sp. K02 DNA, complete genome	blastn	3374	429	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Moraxella	Moraxella sp. K02
25017350	25017350	PRJNA798511_P_NODE_67960_length_294_cov_1.755656_g63694_i0	PRJNA798511	67960	294	1.755656	5.16162864	Faucicola osloensis	34062	Bacteria	Bacteria	67.6	9.74e-7	NTclustered	gi\|1943280950\|gb\|CP065751.1\|	34062	g63694	i0	88.136	1.24829931972789	59	3	26	3	80	138	176079	176133	Moraxella osloensis strain FDAARGOS_870 chromosome, complete genome	blastn	367	67.6	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Faucicola	Faucicola osloensis
25444479	25444479	PRJNA798511_P_NODE_101940_length_242_cov_0.875740_g97674_i0	PRJNA798511	101940	242	0.87574	2.1192908	Enterobacteriaceae	543	Bacteria	Bacteria	436	5.1499999999999985e-118	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g97674	i0	99.174	101	242	2	100	0	1	242	4357150	4357391	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	24442	436	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
25444496	25444496	PRJNA798511_P_NODE_45920_length_379_cov_1.669935_g41655_i0	PRJNA798511	45920	379	1.669935	6.32905365	Enterobacteriaceae	543	Bacteria	Bacteria	673	0	NTclustered	gi\|2206249862\|gb\|CP091927.1\|	562	g41655	i0	98.681	100	379	5	100	0	1	379	75086	75464	Escherichia coli strain JNQH497 plasmid pJNQH497-2, complete sequence	blastn	37900	673	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
25444511	25444511	PRJNA798511_P_NODE_81580_length_263_cov_1.668421_g77314_i0	PRJNA798511	81580	263	1.668421	4.38794723	Gammaproteobacteria	1236	Bacteria	Bacteria	475	1.2e-129	NTclustered	gi\|2890464394\|gb\|CP177216.1\|	562	g77314	i0	99.24	796.908745247148	263	2	100	0	1	263	3424276	3424014	Escherichia coli strain ECDA0423 chromosome, complete genome	blastn	209587	475	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
25444512	25444512	PRJNA798511_P_NODE_87200_length_252_cov_2.055866_g82934_i0	PRJNA798511	87200	252	2.055866	5.18078232	Acinetobacter	469	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|1001859693\|gb\|CP014477.1\|	48296	g82934	i0	100	0.333333333333333	28	0	11	0	43	70	2306234	2306207	Acinetobacter pittii strain AP_882, complete genome	blastn	84	52.8	1	Bacteria		Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Moraxellales	Moraxellaceae	Acinetobacter	Acinetobacter pittii

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