metadata: contig_metadata: 44 rows where bioproject = "PRJNA573544" and tax

44 rows where bioproject = "PRJNA573544" 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
1136140	1136140	PRJNA573544_P_NODE_4521_length_272_cov_2.738693_g4503_i0	PRJNA573544	4521	272	2.738693	7.44924496	Sphingomonas	13687	Bacteria	Bacteria	503	5.729999999999998e-138	NTclustered	gi\|1253294515\|gb\|CP023705.1\|	152682	g4503	i0	100	218.352941176471	272	0	100	0	1	272	1201584	1201313	Sphingomonas melonis strain ZJ26 chromosome, complete genome	blastn	59392	503	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas melonis
1834883	1834883	PRJNA573544_P_NODE_7682_length_244_cov_0.912281_g7664_i0	PRJNA573544	7682	244	0.912281	2.22596564	Delftia lacustris	558537	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|1979399321\|gb\|CP069318.1\|	558537	g7664	i0	100	29.4672131147541	244	0	100	0	1	244	3757932	3757689	Delftia lacustris strain R54 chromosome, complete genome	blastn	7190	451	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Delftia	Delftia lacustris
2411559	2411559	PRJNA573544_P_NODE_4882_length_262_cov_1.333333_g4864_i0	PRJNA573544	4882	262	1.333333	3.49333246	Oxalobacteraceae	75682	Bacteria	Bacteria	411	3.419999999999999e-110	NTclustered	gi\|2415860514\|gb\|CP098244.1\|	847	g4864	i0	95.367	467.270992366412	259	11	99	1	1	259	3365	3622	Oxalobacter formigenes strain OxWR1 chromosome, complete genome	blastn	122425	412	0.997572815533981	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Oxalobacter	Oxalobacter formigenes
2411566	2411566	PRJNA573544_P_NODE_5922_length_251_cov_0.876404_g5904_i0	PRJNA573544	5922	251	0.876404	2.19977404	Sphingomonas	13687	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1253294515\|gb\|CP023705.1\|	152682	g5904	i0	100	21.8685258964143	251	0	100	0	1	251	745910	745660	Sphingomonas melonis strain ZJ26 chromosome, complete genome	blastn	5489	464	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas melonis
2411584	2411584	PRJNA573544_P_NODE_7782_length_243_cov_0.917647_g7764_i0	PRJNA573544	7782	243	0.917647	2.22988221	Sphingomonas	13687	Bacteria	Bacteria	449	6.65e-122	NTclustered	gi\|1253294515\|gb\|CP023705.1\|	152682	g7764	i0	100	40.0740740740741	243	0	100	0	1	243	3110536	3110294	Sphingomonas melonis strain ZJ26 chromosome, complete genome	blastn	9738	449	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas melonis
2411586	2411586	PRJNA573544_P_NODE_8262_length_219_cov_4.643836_g8244_i0	PRJNA573544	8262	219	4.643836	10.17000084	root	1	Root_unresolved	Root_unresolved	398	2.1599999999999995e-106	NTclustered	gi\|1772506390\|emb\|LR736028.1\|	573	g8244	i0	99.541	99.6073059360731	218	1	99	0	2	219	5477467	5477250	Klebsiella pneumoniae strain Kp_29484 genome assembly, chromosome: 1	blastn	21814	398	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Klebsiella	Klebsiella pneumoniae
3110294	3110294	PRJNA573544_P_NODE_4403_length_276_cov_1.275862_g4385_i0	PRJNA573544	4403	276	1.275862	3.52137912	Sphingopyxis granuli	267128	Bacteria	Bacteria	333	8.089999999999998e-87	NTclustered	gi\|2210030175\|gb\|CP093335.1\|	267128	g4385	i0	88.406	4.3731884057971	276	32	100	0	1	276	2278006	2278281	Sphingopyxis granuli strain A2-E30 chromosome, complete genome	blastn	1207	333	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingopyxis	Sphingopyxis granuli
3687519	3687519	PRJNA573544_P_NODE_7143_length_246_cov_0.901734_g7125_i0	PRJNA573544	7143	246	0.901734	2.21826564	Sphingomonas	13687	Bacteria	Bacteria	449	6.74e-122	NTclustered	gi\|1253294515\|gb\|CP023705.1\|	152682	g7125	i0	99.593	21.6138211382114	246	1	100	0	1	246	2963544	2963299	Sphingomonas melonis strain ZJ26 chromosome, complete genome	blastn	5317	449	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas melonis
5663116	5663116	PRJNA573544_P_NODE_4185_length_282_cov_1.282297_g4167_i0	PRJNA573544	4185	282	1.282297	3.61607754	Pseudomonas oryzihabitans	47885	Bacteria	Bacteria	444	3.6699999999999996e-120	NTclustered	gi\|1751056302\|gb\|CP044074.1\|	47885	g4167	i0	95.035	3	282	14	100	0	1	282	3732654	3732373	Pseudomonas oryzihabitans strain FDAARGOS_657 chromosome, complete genome	blastn	846	444	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas oryzihabitans
5663159	5663159	PRJNA573544_P_NODE_6085_length_250_cov_0.881356_g6067_i0	PRJNA573544	6085	250	0.881356	2.20339	Pseudomonas sp. OE 28.3	2745519	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|2063549408\|gb\|CP077082.1\|	2745519	g6067	i0	99.6	15.904	250	1	100	0	1	250	756205	755956	Pseudomonas sp. OE 28.3 chromosome, complete genome	blastn	3976	457	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas sp. OE 28.3
6239702	6239702	PRJNA573544_P_NODE_6585_length_248_cov_0.891429_g6567_i0	PRJNA573544	6585	248	0.891429	2.21074392	Brucella	234	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2293240145\|gb\|CP103345.1\|	529	g6567	i0	100	98.5403225806452	248	0	100	0	1	248	2768750	2768997	Brucella anthropi strain CGMCC 1.17299 chromosome 1, complete sequence	blastn	24438	459	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Brucellaceae	Brucella	Brucella anthropi
6239709	6239709	PRJNA573544_P_NODE_7265_length_245_cov_0.906977_g7247_i0	PRJNA573544	7265	245	0.906977	2.22209365	Delftia	80865	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1769913550\|gb\|CP045291.1\|	180282	g7247	i0	100	24.3183673469388	245	0	100	0	1	245	4870386	4870630	Delftia tsuruhatensis strain TR1180 chromosome, complete genome	blastn	5958	453	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Delftia	Delftia tsuruhatensis
7513999	7513999	PRJNA573544_P_NODE_6366_length_249_cov_0.886364_g6348_i0	PRJNA573544	6366	249	0.886364	2.20704636	Enterobacteriaceae	543	Bacteria	Bacteria	455	1.47e-123	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g6348	i0	99.598	100	249	1	100	0	1	249	2117575	2117327	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	24900	455	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
8212503	8212503	PRJNA573544_P_NODE_7527_length_244_cov_0.912281_g7509_i0	PRJNA573544	7527	244	0.912281	2.22596564	Sphingomonas sanguinis	33051	Bacteria	Bacteria	401	1.8999999999999998e-107	NTclustered	gi\|2070639042\|gb\|CP079203.1\|	33051	g7509	i0	96.311	2.68852459016393	244	9	100	0	1	244	2143029	2142786	Sphingomonas sanguinis strain NP2-R2 chromosome, complete genome	blastn	656	401	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas sanguinis
9487831	9487831	PRJNA573544_P_NODE_8088_length_242_cov_0.923077_g8070_i0	PRJNA573544	8088	242	0.923077	2.23384634	Pseudomonas sp. B19125	3235109	Bacteria	Bacteria	425	1.11e-114	NTclustered	gi\|2843781984\|gb\|CP162589.1\|	3235109	g8070	i0	98.347	75.5909090909091	242	4	100	0	1	242	3142440	3142681	Pseudomonas sp. B19125 chromosome, complete genome	blastn	18293	425	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas sp. B19125
10763747	10763747	PRJNA573544_P_NODE_7449_length_244_cov_1.485380_g7431_i0	PRJNA573544	7449	244	1.48538	3.6243272	Sphingosinithalassobacter sp. CS137	2762748	Bacteria	Bacteria	233	7.319999999999999e-57	NTclustered	gi\|1897585966\|gb\|CP060494.1\|	2762748	g7431	i0	84.615	4.04508196721311	234	36	96	0	1	234	2365583	2365816	Sphingosinithalassobacter sp. CS137 chromosome, complete genome	blastn	987	233	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingosinithalassobacter	Sphingosinithalassobacter sp. CS137
12615119	12615119	PRJNA573544_P_NODE_4910_length_261_cov_1.484043_g4892_i0	PRJNA573544	4910	261	1.484043	3.87335223	Sphingomonas	13687	Bacteria	Bacteria	483	7.12e-132	NTclustered	gi\|1253294515\|gb\|CP023705.1\|	152682	g4892	i0	100	5.51340996168582	261	0	100	0	1	261	1075175	1075435	Sphingomonas melonis strain ZJ26 chromosome, complete genome	blastn	1439	483	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas melonis
12615130	12615130	PRJNA573544_P_NODE_6770_length_247_cov_0.896552_g6752_i0	PRJNA573544	6770	247	0.896552	2.21448344	Sphingomonas	13687	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|1253294515\|gb\|CP023705.1\|	152682	g6752	i0	100	5.00404858299595	247	0	100	0	1	247	3162147	3162393	Sphingomonas melonis strain ZJ26 chromosome, complete genome	blastn	1236	457	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas melonis
13313350	13313350	PRJNA573544_P_NODE_3991_length_288_cov_1.083721_g3973_i0	PRJNA573544	3991	288	1.083721	3.12111648	Brucella anthropi	529	Bacteria	Bacteria	532	7.8e-147	NTclustered	gi\|2293240145\|gb\|CP103345.1\|	529	g3973	i0	100	23.5451388888889	288	0	100	0	1	288	2178108	2177821	Brucella anthropi strain CGMCC 1.17299 chromosome 1, complete sequence	blastn	6781	532	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Brucellaceae	Brucella	Brucella anthropi
13313378	13313378	PRJNA573544_P_NODE_5271_length_253_cov_0.866667_g5253_i0	PRJNA573544	5271	253	0.866667	2.19266751	Sphingomonas sp. NBWT7	2596913	Bacteria	Bacteria	220	5.95e-53	NTclustered	gi\|1890937050\|gb\|CP043639.1\|	2596913	g5253	i0	82.927	6.88537549407115	246	40	97	2	1	245	426154	426398	Sphingomonas sp. NBWT7 chromosome, complete genome	blastn	1742	220	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas sp. NBWT7
13313381	13313381	PRJNA573544_P_NODE_5331_length_253_cov_0.866667_g5313_i0	PRJNA573544	5331	253	0.866667	2.19266751	Massilia putida	1141883	Bacteria	Bacteria	209	1.29e-49	NTclustered	gi\|1130060873\|gb\|CP019037.1\|	1141883	g5313	i0	83.043	0.909090909090909	230	39	91	0	1	230	316179	316408	Massilia putida strain 6NM-7 plasmid unnamed2, complete sequence	blastn	230	209	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Massilia	Massilia putida
13890153	13890153	PRJNA573544_P_NODE_5291_length_253_cov_0.866667_g5273_i0	PRJNA573544	5291	253	0.866667	2.19266751	Enterobacteriaceae	543	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|2650988455\|gb\|CP142548.1\|	562	g5273	i0	100	100	253	0	100	0	1	253	1310308	1310056	Escherichia coli strain ExPEC_A382 chromosome, complete genome	blastn	25300	468	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
14588232	14588232	PRJNA573544_P_NODE_6672_length_248_cov_0.891429_g6654_i0	PRJNA573544	6672	248	0.891429	2.21074392	Sphingomonas sp. AP4-R1	2735134	Bacteria	Bacteria	204	5.849999999999999e-48	NTclustered	gi\|1842702527\|gb\|CP053346.1\|	2735134	g6654	i0	81.526	1.00403225806452	249	44	100	2	1	248	5049180	5049427	Sphingomonas sp. AP4-R1 chromosome, complete genome	blastn	249	204	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas sp. AP4-R1
15164264	15164264	PRJNA573544_P_NODE_3692_length_297_cov_1.044643_g3674_i0	PRJNA573544	3692	297	1.044643	3.10258971	Sphingomonas	13687	Bacteria	Bacteria	549	8.029999999999997e-152	NTclustered	gi\|1253294515\|gb\|CP023705.1\|	152682	g3674	i0	100	104.420875420875	297	0	100	0	1	297	1715317	1715021	Sphingomonas melonis strain ZJ26 chromosome, complete genome	blastn	31013	549	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas melonis
15164276	15164276	PRJNA573544_P_NODE_6172_length_250_cov_0.881356_g6154_i0	PRJNA573544	6172	250	0.881356	2.20339	Delftia	80865	Bacteria	Bacteria	462	8.83e-126	NTclustered	gi\|1769913550\|gb\|CP045291.1\|	180282	g6154	i0	100	99.044	250	0	100	0	1	250	4155106	4155355	Delftia tsuruhatensis strain TR1180 chromosome, complete genome	blastn	24761	462	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Delftia	Delftia tsuruhatensis
16438775	16438775	PRJNA573544_P_NODE_3253_length_312_cov_2.112971_g3235_i0	PRJNA573544	3253	312	2.112971	6.59246952	Undibacterium	401469	Bacteria	Bacteria	505	1.8599999999999995e-138	NTclustered	gi\|1538932687\|gb\|CP034464.1\|	401471	g3235	i0	95.833	454.224358974359	312	13	100	0	1	312	407998	407687	Undibacterium parvum strain DSM 23061 chromosome, complete genome	blastn	141718	510	0.990196078431373	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Oxalobacteraceae	Undibacterium	Undibacterium parvum
16438782	16438782	PRJNA573544_P_NODE_3913_length_290_cov_1.437788_g3895_i0	PRJNA573544	3913	290	1.437788	4.1695852	Escherichia	561	Bacteria	Bacteria	536	6.079999999999999e-148	NTclustered	gi\|2507144281\|gb\|CP122454.1\|	562	g3895	i0	100	100	290	0	100	0	1	290	5060474	5060185	Escherichia coli strain 82.0311 chromosome, complete genome	blastn	29000	536	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
17136985	17136985	PRJNA573544_P_NODE_1874_length_385_cov_1.294872_g1856_i0	PRJNA573544	1874	385	1.294872	4.9852572	Methylobacterium aquaticum	270351	Bacteria	Bacteria	643	4.769999999999998e-180	NTclustered	gi\|760865928\|dbj\|AP014704.1\|	270351	g1856	i0	99.715	335.680519480519	351	1	100	0	1	351	387777	388127	Methylobacterium aquaticum DNA, complete genome, strain: MA-22A	blastn	129237	643	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Hyphomicrobiales	Methylobacteriaceae	Methylobacterium	Methylobacterium aquaticum
17137066	17137066	PRJNA573544_P_NODE_5534_length_252_cov_0.871508_g5516_i0	PRJNA573544	5534	252	0.871508	2.19620016	Sphingomonas parapaucimobilis	28213	Bacteria	Bacteria	460	3.2e-125	NTclustered	gi\|2734899030\|gb\|CP155756.1\|	28213	g5516	i0	99.603	17.468253968254	252	1	100	0	1	252	152322	152573	Sphingomonas parapaucimobilis strain YK209 plasmid unnamed7, complete sequence	blastn	4402	460	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas parapaucimobilis
17714051	17714051	PRJNA573544_P_NODE_3934_length_289_cov_2.444444_g3916_i0	PRJNA573544	3934	289	2.444444	7.06444316	Sphingomonas	13687	Bacteria	Bacteria	281	3.13e-71	NTclustered	gi\|1253294515\|gb\|CP023705.1\|	152682	g3916	i0	100	3.13148788927336	152	0	100	0	1	152	636423	636272	Sphingomonas melonis strain ZJ26 chromosome, complete genome	blastn	905	281	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas melonis
18411290	18411290	PRJNA573544_P_NODE_3675_length_297_cov_1.937500_g3657_i0	PRJNA573544	3675	297	1.9375	5.754375	Aquabacterium olei	1296669	Bacteria	Bacteria	516	8.14e-142	NTclustered	gi\|1387992375\|gb\|CP029210.1\|	1296669	g3657	i0	97.98	397.198653198653	297	6	100	0	1	297	278529	278233	Aquabacterium olei strain NBRC 110486 chromosome, complete genome	blastn	117968	516	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Aquabacterium	Aquabacterium olei
18987472	18987472	PRJNA573544_P_NODE_5675_length_252_cov_0.871508_g5657_i0	PRJNA573544	5675	252	0.871508	2.19620016	Delftia	80865	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|1769913550\|gb\|CP045291.1\|	180282	g5657	i0	100	79.3611111111111	252	0	100	0	1	252	5411892	5412143	Delftia tsuruhatensis strain TR1180 chromosome, complete genome	blastn	19999	466	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales	Comamonadaceae	Delftia	Delftia tsuruhatensis
20262628	20262628	PRJNA573544_P_NODE_4356_length_277_cov_1.509804_g4338_i0	PRJNA573544	4356	277	1.509804	4.18215708	Sphingomonas	13687	Bacteria	Bacteria	512	9.73e-141	NTclustered	gi\|1253294515\|gb\|CP023705.1\|	152682	g4338	i0	100	14.1335740072202	277	0	100	0	1	277	3605659	3605935	Sphingomonas melonis strain ZJ26 chromosome, complete genome	blastn	3915	512	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas melonis
21538070	21538070	PRJNA573544_P_NODE_4117_length_284_cov_1.218009_g4099_i0	PRJNA573544	4117	284	1.218009	3.45914556	Sphingomonas	13687	Bacteria	Bacteria	520	5.98e-143	NTclustered	gi\|1253294515\|gb\|CP023705.1\|	152682	g4099	i0	99.648	3.62323943661972	284	1	100	0	1	284	1000013	1000296	Sphingomonas melonis strain ZJ26 chromosome, complete genome	blastn	1029	520	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas melonis
21538074	21538074	PRJNA573544_P_NODE_5537_length_252_cov_0.871508_g5519_i0	PRJNA573544	5537	252	0.871508	2.19620016	Sphingomonas	13687	Bacteria	Bacteria	466	6.89e-127	NTclustered	gi\|1253294515\|gb\|CP023705.1\|	152682	g5519	i0	100	3	252	0	100	0	1	252	1387930	1387679	Sphingomonas melonis strain ZJ26 chromosome, complete genome	blastn	756	466	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas melonis
22236447	22236447	PRJNA573544_P_NODE_4978_length_260_cov_1.235294_g4960_i0	PRJNA573544	4978	260	1.235294	3.2117644	Aquabacterium sp. J223	2898431	Bacteria	Bacteria	481	2.55e-131	NTclustered	gi\|2285501637\|gb\|CP088297.1\|	2898431	g4960	i0	100	332.688461538462	260	0	100	0	1	260	848547	848806	Aquabacterium sp. J223 chromosome	blastn	86499	481	1	Bacteria	Pseudomonadati	Pseudomonadota	Betaproteobacteria	Burkholderiales		Aquabacterium	Aquabacterium sp. J223
22813341	22813341	PRJNA573544_P_NODE_4358_length_277_cov_1.450980_g4340_i0	PRJNA573544	4358	277	1.45098	4.0192146	Sphingomonas	13687	Bacteria	Bacteria	512	9.73e-141	NTclustered	gi\|1253294515\|gb\|CP023705.1\|	152682	g4340	i0	100	9.85198555956679	277	0	100	0	1	277	371153	371429	Sphingomonas melonis strain ZJ26 chromosome, complete genome	blastn	2729	512	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas melonis
22813357	22813357	PRJNA573544_P_NODE_5918_length_251_cov_0.876404_g5900_i0	PRJNA573544	5918	251	0.876404	2.19977404	Enterobacteriaceae	543	Bacteria	Bacteria	464	2.47e-126	NTclustered	gi\|1492010540\|gb\|CP012781.1\|	562	g5900	i0	100	100	251	0	100	0	1	251	1168949	1169199	Escherichia coli strain A18 chromosome	blastn	25100	464	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Enterobacterales	Enterobacteriaceae	Escherichia	Escherichia coli
24088071	24088071	PRJNA573544_P_NODE_4619_length_270_cov_1.406091_g4601_i0	PRJNA573544	4619	270	1.406091	3.7964457	Sphingomonas	13687	Bacteria	Bacteria	499	7.349999999999998e-137	NTclustered	gi\|1253294515\|gb\|CP023705.1\|	152682	g4601	i0	100	98.7222222222222	270	0	100	0	1	270	1917460	1917729	Sphingomonas melonis strain ZJ26 chromosome, complete genome	blastn	26655	499	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas melonis
25362492	25362492	PRJNA573544_P_NODE_6620_length_248_cov_0.891429_g6602_i0	PRJNA573544	6620	248	0.891429	2.21074392	Pseudomonas	286	Bacteria	Bacteria	459	1.13e-124	NTclustered	gi\|2634180903\|gb\|CP133780.1\|	3048613	g6602	i0	100	74.4838709677419	248	0	100	0	1	248	586134	586381	Pseudomonas sp. CCI1.1 chromosome	blastn	18472	459	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Pseudomonadales	Pseudomonadaceae	Pseudomonas	Pseudomonas sp. CCI1.1
26649758	26649758	PRJNA573544_P_NODE_6061_length_250_cov_0.881356_g6043_i0	PRJNA573544	6061	250	0.881356	2.20339	Tahibacter	1453544	Bacteria	Bacteria	132	1.2699999999999998e-35	NR	HVH33847.1	2056211	g6043	i0	79.5	2.988	83	17	99.6	0	2	250	163	245	HVH33847.1 ABC transporter permease [Tahibacter sp.]	diamond	747	132	1	Bacteria	Pseudomonadati	Pseudomonadota	Gammaproteobacteria	Lysobacterales	Rhodanobacteraceae	Tahibacter	Tahibacter sp.
27661939	27661939	PRJNA573544_P_NODE_6144_length_250_cov_0.881356_g6126_i0	PRJNA573544	6144	250	0.881356	2.20339	Sphingomonadaceae	41297	Bacteria	Bacteria	163	1.58e-44	NR	WP_062126125.1	152682	g6126	i0	100	1.92	80	0	96	0	248	9	782	861	WP_062126125.1 type IV secretion system protein TraC [Sphingomonas melonis]	diamond	480	163	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas melonis
28406008	28406008	PRJNA573544_P_NODE_5406_length_253_cov_0.866667_g5388_i0	PRJNA573544	5406	253	0.866667	2.19266751	Sphingomonas sp. TX	28214	Bacteria	Bacteria	171	5.58e-48	NR	WP_198356560.1	2479205	g5388	i0	100	0.99604743083004	84	0	99.6	0	252	1	81	164	WP_198356560.1 phage terminase large subunit family protein, partial [Sphingomonas sp. TX0522]	diamond	252	171	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas	Sphingomonas sp. TX0522
31501819	31501819	PRJNA573544_P_NODE_7236_length_245_cov_0.906977_g7218_i0	PRJNA573544	7236	245	0.906977	2.22209365	Sphingomonas	13687	Bacteria	Bacteria	129	1.87e-36	NR	WP_203309122.1	13687	g7218	i0	100	0.808163265306122	66	0	80.8	0	243	46	57	122	WP_203309122.1 MULTISPECIES: hypothetical protein [Sphingomonas]	diamond	198	129	1	Bacteria	Pseudomonadati	Pseudomonadota	Alphaproteobacteria	Sphingomonadales	Sphingomonadaceae	Sphingomonas

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