metadata: contig_metadata: 56 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax

56 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax_phylum = "Mycoplasmatota"

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
291611	291611	PRJNA1148190_P_NODE_169481_length_405_cov_1.391566_g158312_i0	PRJNA1148190	169481	405	1.391566	5.6358423	Mycoplasma phocoeninasale	2726117	Bacteria	Bacteria	52.8	0.039	NTclustered	gi\|1836057661\|gb\|CP051480.1\|	2726117	g158312	i0	100	0.0691358024691358	28	0	7	0	203	230	395941	395968	Mycoplasma phocoeninasale strain C264-NAS chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma phocoeninasale
1567565	1567565	PRJNA1148190_P_NODE_253942_length_341_cov_1.667910_g242772_i0	PRJNA1148190	253942	341	1.66791	5.6875731	Mesomycoplasma moatsii	171287	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2860287645\|gb\|CP174166.1\|	171287	g242772	i0	97.059	0.715542521994135	34	0	10	1	20	53	290200	290232	Mesomycoplasma moatsii strain MK 405 chromosome, complete genome	blastn	244	56.5	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma moatsii
1571225	1571225	PRJNA1148190_P_NODE_508882_length_265_cov_1.234375_g497709_i0	PRJNA1148190	508882	265	1.234375	3.27109375	Mycoplasmopsis maculosa	114885	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1563804680\|emb\|LR215037.1\|	114885	g497709	i0	100	0.105660377358491	28	0	11	0	112	139	457835	457808	Mycoplasma maculosum strain NCTC10168 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis maculosa
2309624	2309624	PRJNA1148190_P_NODE_224282_length_359_cov_0.944056_g213112_i0	PRJNA1148190	224282	359	0.944056	3.38916104	Spiroplasma	2132	Bacteria	Bacteria	58.4	7.31e-4	NTclustered	gi\|110005436\|emb\|AM285321.1\|	2133	g213112	i0	100	0.949860724233983	31	0	9	0	320	350	44605	44575	Spiroplasma citri GII3-3X chromosome, contig Contig20	blastn	341	58.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma citri
2844521	2844521	PRJNA1148190_P_NODE_294003_length_322_cov_1.751004_g282830_i0	PRJNA1148190	294003	322	1.751004	5.63823288	Mycoplasmatota bacterium	2231116	Bacteria	Bacteria	80.5	1.39e-10	NTclustered	gi\|2047333279\|gb\|CP076020.1\|	2231116	g282830	i0	88.406	1.16459627329193	69	5	20	2	175	240	593801	593733	Tenericutes bacterium strain zrk2 chromosome, complete genome	blastn	375	80.5	1	Bacteria	Bacillati	Mycoplasmatota					Mycoplasmatota bacterium
2846174	2846174	PRJNA1148190_P_NODE_410043_length_284_cov_1.478673_g398870_i0	PRJNA1148190	410043	284	1.478673	4.19943132	Spiroplasma endosymbiont of Dilophus febrilis	3066292	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2719437752\|emb\|OZ034912.1\|	3066292	g398870	i0	100	0.200704225352113	29	0	10	0	4	32	58296	58268	Spiroplasma endosymbiont of Dilophus febrilis isolate 54762 genome assembly, chromosome: 1	blastn	57	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Dilophus febrilis
3584183	3584183	PRJNA1148190_P_NODE_107803_length_512_cov_1.578588_g96644_i0	PRJNA1148190	107803	512	1.578588	8.08237056	root	1	Root_unresolved	Root_unresolved	60.2	3e-4	NTclustered	gi\|2678327680\|gb\|CP145106.1\|	2097	g96644	i0	94.872	7.623046875	39	1	8	1	242	280	448677	448714	Mycoplasmoides genitalium strain 73697 chromosome	blastn	3903	60.2	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Mycoplasmoides	Mycoplasmoides genitalium
4126170	4126170	PRJNA1148190_P_NODE_709564_length_245_cov_0.895349_g698391_i0	PRJNA1148190	709564	245	0.895349	2.19360505	Spiroplasma endosymbiont of Poecilobothrus nobilitatus	1209220	Bacteria	Bacteria	58.4	4.75e-4	NTclustered	gi\|2719437756\|emb\|OZ034915.1\|	1209220	g698391	i0	94.737	0.155102040816327	38	1	16	1	175	212	1123983	1123947	Spiroplasma endosymbiont of Poecilobothrus nobilitatus isolate 54766 genome assembly, chromosome: 1	blastn	38	58.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Poecilobothrus nobilitatus
4864359	4864359	PRJNA1148190_P_NODE_758624_length_242_cov_0.911243_g747451_i0	PRJNA1148190	758624	242	0.911243	2.20520806	Spiroplasma	2132	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2706542390\|emb\|OZ026447.1\|	3066299	g747451	i0	100	0.838842975206612	29	0	12	0	56	84	48706	48734	Spiroplasma endosymbiont of Dasysyrphus albostriatus isolate 54770 genome assembly, chromosome: 1	blastn	203	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Dasysyrphus albostriatus
5398667	5398667	PRJNA1148190_P_NODE_426825_length_281_cov_1.259615_g415652_i0	PRJNA1148190	426825	281	1.259615	3.53951815	Candidatus Phytoplasma luffae	35773	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2026792265\|gb\|CP054393.1\|	35773	g415652	i0	96.97	0.117437722419929	33	1	12	0	111	143	191253	191285	Candidatus Phytoplasma luffae isolate NCHU2019 chromosome, complete genome	blastn	33	56.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma luffae
5402024	5402024	PRJNA1148190_P_NODE_683425_length_246_cov_0.890173_g672252_i0	PRJNA1148190	683425	246	0.890173	2.18982558	Mesomycoplasma molare	171288	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2294779286\|gb\|CP103423.1\|	171288	g672252	i0	100	0.113821138211382	28	0	11	0	213	240	498491	498518	Mesomycoplasma molare strain H 542 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma molare
7412808	7412808	PRJNA1148190_P_NODE_347486_length_301_cov_1.815789_g336313_i0	PRJNA1148190	347486	301	1.815789	5.46552489	root	1	Root_unresolved	Root_unresolved	108	5.89e-19	NTclustered	gi\|1572559275\|emb\|LS483518.1\|	40477	g336313	i0	84.071	22.8637873754153	113	16	37	2	190	301	105123	105012	Mycoplasma mycoides subsp. capri strain GM12 genome assembly, chromosome: omosome	blastn	6882	108	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma mycoides
7945850	7945850	PRJNA1148190_P_NODE_241807_length_348_cov_1.120000_g230637_i0	PRJNA1148190	241807	348	1.12	3.8976	Malacoplasma muris	2119	Bacteria	Bacteria	58.4	7.08e-4	NTclustered	gi\|2890642799\|gb\|CP177248.1\|	2119	g230637	i0	97.059	0.0977011494252874	34	1	10	0	295	328	279304	279271	Malacoplasma muris strain RIII-4 chromosome, complete genome	blastn	34	58.4	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma muris
7949204	7949204	PRJNA1148190_P_NODE_472067_length_272_cov_1.346734_g460894_i0	PRJNA1148190	472067	272	1.346734	3.66311648	Metamycoplasma hominis	2098	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|45822226\|emb\|AJ629113.1\|	2098	g460894	i0	100	0.308823529411765	28	0	10	0	66	93	5854	5881	Mycoplasma hominis vmp gene, vaa gene (partial), hitL gene (partial) and tRNA-His gene, isolate 4195	blastn	84	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma hominis
7950346	7950346	PRJNA1148190_P_NODE_558007_length_255_cov_1.813187_g546834_i0	PRJNA1148190	558007	255	1.813187	4.62362685	Metamycoplasma hominis	2098	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1775855902\|gb\|CP035543.1\|	2098	g546834	i0	94.595	0.286274509803922	37	1	15	1	103	139	312663	312628	Metamycoplasma hominis strain 35 chromosome	blastn	73	56.5	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma hominis
9222857	9222857	PRJNA1148190_P_NODE_374648_length_292_cov_1.054795_g363475_i0	PRJNA1148190	374648	292	1.054795	3.0800014	Mycoplasmopsis felis	33923	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2695677594\|gb\|CP141029.2\|	33923	g363475	i0	100	1.98630136986301	29	0	10	0	39	67	466468	466440	Mycoplasmopsis felis strain 11534 chromosome	blastn	580	54.7	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis felis
9222880	9222880	PRJNA1148190_P_NODE_376648_length_291_cov_1.412844_g365475_i0	PRJNA1148190	376648	291	1.412844	4.11137604	Metamycoplasma sualvi	2125	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2860288300\|gb\|CP174167.1\|	2125	g365475	i0	100	0.0962199312714777	28	0	10	0	253	280	170570	170543	Metamycoplasma sualvi strain Mayfield chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma sualvi
9223507	9223507	PRJNA1148190_P_NODE_420968_length_282_cov_1.392344_g409795_i0	PRJNA1148190	420968	282	1.392344	3.92641008	Mycoplasmoides fastidiosum	92758	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2279714125\|gb\|CP101809.1\|	92758	g409795	i0	100	0.106382978723404	30	0	11	0	191	220	14209	14238	Mycoplasmoides fastidiosum strain 4822 chromosome, complete genome	blastn	30	56.5	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Mycoplasmoides	Mycoplasmoides fastidiosum
9223624	9223624	PRJNA1148190_P_NODE_429128_length_280_cov_2.144928_g417955_i0	PRJNA1148190	429128	280	2.144928	6.0057984	Spiroplasma endosymbiont of Cantharis nigra	3066278	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2706542411\|emb\|OZ026470.1\|	3066278	g417955	i0	92.308	0.139285714285714	39	1	14	2	226	264	351958	351922	Spiroplasma endosymbiont of Cantharis nigra isolate 54809 genome assembly, chromosome: 1	blastn	39	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Cantharis nigra
9223812	9223812	PRJNA1148190_P_NODE_443068_length_278_cov_1.126829_g431895_i0	PRJNA1148190	443068	278	1.126829	3.13258462	Mycoplasma bradburyae	2963128	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2274227855\|gb\|CP101415.1\|	2963128	g431895	i0	96.875	0.23021582733813	32	1	12	0	161	192	413157	413188	Mycoplasma bradburyae strain IZSV97/66 chromosome, complete genome	blastn	64	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma bradburyae
9962774	9962774	PRJNA1148190_P_NODE_285408_length_326_cov_1.284585_g274237_i0	PRJNA1148190	285408	326	1.284585	4.1877471	Spiroplasma	2132	Bacteria	Bacteria	60.2	1.83e-4	NTclustered	gi\|835320153\|gb\|CP011856.1\|	315358	g274237	i0	89.796	0.469325153374233	49	1	14	4	41	86	1093672	1093625	Spiroplasma eriocheiris strain DSM 21848, complete genome	blastn	153	60.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma eriocheiris
10494697	10494697	PRJNA1148190_P_NODE_137949_length_448_cov_1.285333_g126784_i0	PRJNA1148190	137949	448	1.285333	5.75829184	[Mycoplasma] cavipharyngis	92757	Bacteria	Bacteria	52.8	0.043	NTclustered	gi\|2735171757\|gb\|CP155569.1\|	92757	g126784	i0	100	0.0625	28	0	6	0	118	145	446650	446677	[Mycoplasma] cavipharyngis strain 117C chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Mycoplasmoides	[Mycoplasma] cavipharyngis
10499122	10499122	PRJNA1148190_P_NODE_419989_length_282_cov_1.502392_g408816_i0	PRJNA1148190	419989	282	1.502392	4.23674544	Mesomycoplasma moatsii	171287	Bacteria	Bacteria	113	1.18e-20	NTclustered	gi\|2860287645\|gb\|CP174166.1\|	171287	g408816	i0	85.981	6.33687943262411	107	14	38	1	176	281	524737	524631	Mesomycoplasma moatsii strain MK 405 chromosome, complete genome	blastn	1787	113	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma moatsii
10501797	10501797	PRJNA1148190_P_NODE_609829_length_250_cov_0.870056_g598656_i0	PRJNA1148190	609829	250	0.870056	2.17514	[Mycoplasma] cavipharyngis	92757	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2735171757\|gb\|CP155569.1\|	92757	g598656	i0	87.5	0.384	48	3	18	2	157	202	507595	507641	[Mycoplasma] cavipharyngis strain 117C chromosome, complete genome	blastn	96	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Mycoplasmoides	[Mycoplasma] cavipharyngis
11237695	11237695	PRJNA1148190_P_NODE_241469_length_348_cov_1.414545_g230299_i0	PRJNA1148190	241469	348	1.414545	4.9226166	Candidatus Hepatoplasma	295595	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|2416256950\|dbj\|AP027132.1\|	295596	g230299	i0	96.875	0.183908045977011	32	0	9	1	126	156	89943	89912	MAG: Candidatus Hepatoplasma crinochetorum Tokyo2021 DNA, complete genome	blastn	64	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Candidatus Hepatoplasmataceae	Candidatus Hepatoplasma	Candidatus Hepatoplasma crinochetorum
11774083	11774083	PRJNA1148190_P_NODE_418030_length_283_cov_1.100000_g406857_i0	PRJNA1148190	418030	283	1.1	3.113	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2579241394\|gb\|CP125274.1\|	2685873	g406857	i0	100	0.0989399293286219	28	0	10	0	169	196	279638	279665	MAG: Mycoplasmataceae bacterium isolate MRE chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
13048245	13048245	PRJNA1148190_P_NODE_363211_length_296_cov_1.035874_g352038_i0	PRJNA1148190	363211	296	1.035874	3.06618704	Metamycoplasma buccale	55602	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2890643647\|gb\|CP177249.1\|	55602	g352038	i0	96.875	0.108108108108108	32	1	11	0	237	268	542821	542852	Metamycoplasma buccale strain CH20247 chromosome, complete genome	blastn	32	54.7	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma buccale
13052427	13052427	PRJNA1148190_P_NODE_672171_length_247_cov_0.885057_g660998_i0	PRJNA1148190	672171	247	0.885057	2.18609079	Mycoplasma tauri	547987	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1993604791\|gb\|CP070479.1\|	547987	g660998	i0	100	0.11336032388664	28	0	11	0	120	147	389627	389600	Mycoplasma tauri strain Zaradi2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma tauri
14322344	14322344	PRJNA1148190_P_NODE_283092_length_327_cov_1.460630_g271921_i0	PRJNA1148190	283092	327	1.46063	4.7762601	Spiroplasma litorale	216942	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|915477727\|gb\|CP012357.1\|	216942	g271921	i0	100	0.0856269113149847	28	0	9	0	285	312	221201	221174	Spiroplasma litorale strain TN-1, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma litorale
14323581	14323581	PRJNA1148190_P_NODE_367632_length_294_cov_1.393665_g356459_i0	PRJNA1148190	367632	294	1.393665	4.0973751	Mycoplasma crocodyli	50052	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|291599850\|gb\|CP001991.1\|	512564	g356459	i0	100	0.0952380952380952	28	0	10	0	132	159	821679	821652	Mycoplasma crocodyli MP145, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma crocodyli
15061790	15061790	PRJNA1148190_P_NODE_16912_length_2123_cov_2.964878_g9666_i0	PRJNA1148190	16912	2123	2.964878	62.94435994	Spiroplasma	2132	Bacteria	Bacteria	93.5	1.29e-13	NTclustered	gi\|835318765\|gb\|CP011855.1\|	2144	g9666	i0	93.548	2.27319830428639	62	4	3	0	1103	1164	667460	667521	Spiroplasma atrichopogonis strain GNAT3597, complete genome	blastn	4826	93.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma mirum
15595479	15595479	PRJNA1148190_P_NODE_231733_length_354_cov_1.096085_g220563_i0	PRJNA1148190	231733	354	1.096085	3.8801409	Spiroplasma litorale	216942	Bacteria	Bacteria	58.4	7.2e-4	NTclustered	gi\|915477727\|gb\|CP012357.1\|	216942	g220563	i0	92.683	0.200564971751412	41	2	11	1	136	175	1096815	1096775	Spiroplasma litorale strain TN-1, complete genome	blastn	71	58.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma litorale
15600448	15600448	PRJNA1148190_P_NODE_576993_length_252_cov_1.290503_g565820_i0	PRJNA1148190	576993	252	1.290503	3.25206756	Spiroplasma endosymbiont of Notiophilus biguttatus	3066285	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2719904880\|emb\|OZ034993.1\|	3066285	g565820	i0	100	0.119047619047619	30	0	12	0	11	40	464964	464935	Spiroplasma endosymbiont of Notiophilus biguttatus isolate 54805 genome assembly, chromosome: 1	blastn	30	56.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Notiophilus biguttatus
16870239	16870239	PRJNA1148190_P_NODE_267134_length_335_cov_0.881679_g255963_i0	PRJNA1148190	267134	335	0.881679	2.95362465	Mesoplasma melaleucae	81459	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|1285334491\|gb\|CP024964.1\|	81459	g255963	i0	100	0.0835820895522388	28	0	8	0	264	291	3513	3486	Mesoplasma melaleucae strain M1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Entomoplasmataceae	Mesoplasma	Mesoplasma melaleucae
18145153	18145153	PRJNA1148190_P_NODE_283015_length_327_cov_1.515748_g271844_i0	PRJNA1148190	283015	327	1.515748	4.95649596	Candidatus Mycoplasma haematolamae	141391	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|397328574\|gb\|CP003731.1\|	1212765	g271844	i0	100	0.0856269113149847	28	0	9	0	24	51	73248	73221	Candidatus Mycoplasma haemolamae str. Purdue, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematolamae
18151347	18151347	PRJNA1148190_P_NODE_741635_length_243_cov_0.905882_g730462_i0	PRJNA1148190	741635	243	0.905882	2.20129326	Candidatus Phytoplasma oryzae	203274	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2430437647\|gb\|CP116038.1\|	203274	g730462	i0	100	0.11522633744856	28	0	12	0	151	178	240671	240644	Candidatus Phytoplasma oryzae strain HN2022 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma oryzae
18885624	18885624	PRJNA1148190_P_NODE_171315_length_403_cov_1.427273_g160146_i0	PRJNA1148190	171315	403	1.427273	5.75191019	Ureaplasma	2129	Bacteria	Bacteria	52.8	0.039	NTclustered	gi\|1493548740\|dbj\|AP018561.1\|	38504	g160146	i0	100	0.764267990074442	28	0	7	0	63	90	582443	582416	Ureaplasma parvum serovar 3 OMC-P162 DNA, complete genome	blastn	308	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma parvum
19422954	19422954	PRJNA1148190_P_NODE_518616_length_263_cov_1.310526_g507443_i0	PRJNA1148190	518616	263	1.310526	3.44668338	Metamycoplasma alkalescens	45363	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1450418660\|emb\|LS991949.1\|	45363	g507443	i0	100	0.106463878326996	28	0	11	0	91	118	233331	233358	Mycoplasma alkalescens strain NCTC10135 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma alkalescens
19423904	19423904	PRJNA1148190_P_NODE_588736_length_251_cov_0.865169_g577563_i0	PRJNA1148190	588736	251	0.865169	2.17157419	Spiroplasma phoeniceum	47835	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2331042467\|gb\|CP110830.1\|	47835	g577563	i0	100	0.231075697211155	29	0	12	0	39	67	885672	885700	MAG: Spiroplasma phoeniceum isolate PmM2021_Spiro chromosome, complete genome	blastn	58	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma phoeniceum
19424558	19424558	PRJNA1148190_P_NODE_639636_length_248_cov_1.262857_g628463_i0	PRJNA1148190	639636	248	1.262857	3.13188536	Mycoplasmopsis gallinacea	29556	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1829611636\|gb\|CP047225.1\|	29556	g628463	i0	100	0.116935483870968	29	0	12	0	84	112	171069	171097	Mycoplasmopsis gallinacea strain Peacock20181011 chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis gallinacea
20160183	20160183	PRJNA1148190_P_NODE_128076_length_466_cov_0.979644_g116913_i0	PRJNA1148190	128076	466	0.979644	4.56514104	root	1	Root_unresolved	Root_unresolved	52.8	0.045	NTclustered	gi\|2410841577\|gb\|CP110272.1\|	171284	g116913	i0	90.476	0.150214592274678	42	1	8	2	214	252	15350	15309	Mycoplasmopsis cynos strain 16-078726-2 chromosome	blastn	70	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis cynos
20692986	20692986	PRJNA1148190_P_NODE_164497_length_411_cov_0.911243_g153329_i0	PRJNA1148190	164497	411	0.911243	3.74520873	Mycoplasma sp. 1654_15	2725994	Bacteria	Bacteria	52.8	0.039	NTclustered	gi\|1832581539\|gb\|CP051214.1\|	2725994	g153329	i0	100	0.0681265206812652	28	0	7	0	163	190	838124	838151	Mycoplasma sp. 1654_15 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma sp. 1654_15
20694644	20694644	PRJNA1148190_P_NODE_268057_length_334_cov_1.555556_g256886_i0	PRJNA1148190	268057	334	1.555556	5.19555704	Mycoplasmopsis felis	33923	Bacteria	Bacteria	54.7	0.009	NTclustered	gi\|2695677594\|gb\|CP141029.2\|	33923	g256886	i0	96.875	2.49101796407186	32	1	10	0	26	57	388499	388468	Mycoplasmopsis felis strain 11534 chromosome	blastn	832	54.7	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis felis
20697782	20697782	PRJNA1148190_P_NODE_482437_length_270_cov_1.329949_g471264_i0	PRJNA1148190	482437	270	1.329949	3.5908623	Candidatus Mycoplasma mahonii	3004105	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2554183568\|gb\|CP114583.1\|	3004105	g471264	i0	92.5	0.148148148148148	40	2	15	1	2	41	539573	539611	Candidatus Mycoplasma mahonii isolate OP267 chromosome, complete genome	blastn	40	56.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma mahonii
21435815	21435815	PRJNA1148190_P_NODE_143417_length_439_cov_1.467213_g132252_i0	PRJNA1148190	143417	439	1.467213	6.44106507	root	1	Root_unresolved	Root_unresolved	52.8	0.042	NTclustered	gi\|2040369058\|gb\|CP065588.1\|	40477	g132252	i0	100	2.16856492027335	28	0	6	0	356	383	140225	140198	Mycoplasma mycoides subsp. capri strain M-5 chromosome, complete genome	blastn	952	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma mycoides
21435969	21435969	PRJNA1148190_P_NODE_172277_length_402_cov_1.404255_g161108_i0	PRJNA1148190	172277	402	1.404255	5.6451051	root	1	Root_unresolved	Root_unresolved	54.7	0.011	NTclustered	gi\|2643571037\|gb\|CP131022.1\|	2155	g161108	i0	100	0.154228855721393	29	0	7	0	152	180	13744	13716	MAG: Phytoplasma sp. isolate ArAWB-2021 chromosome, complete genome	blastn	62	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Phytoplasma sp.
22711489	22711489	PRJNA1148190_P_NODE_277738_length_330_cov_0.898833_g266567_i0	PRJNA1148190	277738	330	0.898833	2.9661489	Spiroplasma	2132	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|2677441109\|dbj\|AP029039.1\|	3050081	g266567	i0	97.059	0.206060606060606	34	0	10	1	79	112	882448	882416	MAG: Spiroplasma endosymbiont of Nesidiocoris tenuis sNten DNA, complete genome	blastn	68	56.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Nesidiocoris tenuis
22712350	22712350	PRJNA1148190_P_NODE_492858_length_268_cov_1.328205_g481685_i0	PRJNA1148190	492858	268	1.328205	3.5595894	Metamycoplasma	2895509	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1495885541\|gb\|CP033021.1\|	2098	g481685	i0	100	2.46268656716418	30	0	11	0	146	175	563085	563056	Metamycoplasma hominis strain TO0613 chromosome, complete genome	blastn	660	56.5	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma hominis
23244727	23244727	PRJNA1148190_P_NODE_220959_length_361_cov_1.152778_g209789_i0	PRJNA1148190	220959	361	1.152778	4.16152858	Spiroplasma endosymbiont of Dasysyrphus albostriatus	3066299	Bacteria	Bacteria	62.1	5.69e-5	NTclustered	gi\|2706542390\|emb\|OZ026447.1\|	3066299	g209789	i0	95	0.110803324099723	40	0	11	2	161	199	1518628	1518590	Spiroplasma endosymbiont of Dasysyrphus albostriatus isolate 54770 genome assembly, chromosome: 1	blastn	40	62.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Dasysyrphus albostriatus
23251399	23251399	PRJNA1148190_P_NODE_703279_length_245_cov_0.895349_g692106_i0	PRJNA1148190	703279	245	0.895349	2.19360505	Spiroplasma endosymbiont of Antitype chi	3066308	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2706542423\|emb\|OZ026467.1\|	3066308	g692106	i0	100	0.118367346938776	29	0	12	0	198	226	2275083	2275055	Spiroplasma endosymbiont of Antitype chi isolate 54779 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Antitype chi
24516955	24516955	PRJNA1148190_P_NODE_138720_length_446_cov_3.069705_g127555_i0	PRJNA1148190	138720	446	3.069705	13.6908843	Spiroplasma taiwanense	2145	Bacteria	Bacteria	54.7	0.012	NTclustered	gi\|525040344\|gb\|CP005074.1\|	1276220	g127555	i0	100	0.0650224215246637	29	0	7	0	49	77	521291	521319	Spiroplasma taiwanense CT-1, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma taiwanense
24521416	24521416	PRJNA1148190_P_NODE_422800_length_282_cov_1.105263_g411627_i0	PRJNA1148190	422800	282	1.105263	3.11684166	Mycoplasma mycoides	2102	Bacteria	Bacteria	58.4	5.59e-4	NTclustered	gi\|2040374890\|gb\|CP065583.1\|	40477	g411627	i0	94.737	5.66666666666667	38	1	13	1	77	114	194197	194161	Mycoplasma mycoides subsp. capri strain 80/93 chromosome, complete genome	blastn	1598	58.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma mycoides
24521613	24521613	PRJNA1148190_P_NODE_436620_length_279_cov_1.300971_g425447_i0	PRJNA1148190	436620	279	1.300971	3.62970909	Spiroplasma citri	2133	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|239840112\|gb\|GQ152124.1\|	2133	g425447	i0	100	0.401433691756272	28	0	10	0	231	258	49	22	Spiroplasma citri isolate 26 I2 short sequence repeat	blastn	112	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma citri
24526367	24526367	PRJNA1148190_P_NODE_806340_length_226_cov_3.039216_g795167_i0	PRJNA1148190	806340	226	3.039216	6.86862816	Mycoplasma feriruminatoris	1179777	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|2737265421\|gb\|CP142077.1\|	1179777	g795167	i0	100	0.867256637168142	28	0	12	0	5	32	312261	312288	Mycoplasma feriruminatoris strain 0535deltaMIBMIP chromosome, complete genome	blastn	196	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma feriruminatoris
25261011	25261011	PRJNA1148190_P_NODE_304220_length_318_cov_1.257143_g293047_i0	PRJNA1148190	304220	318	1.257143	3.99771474	Spiroplasma	2132	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|2802839268\|emb\|OZ181653.1\|	3066280	g293047	i0	100	0.182389937106918	29	0	9	0	61	89	425684	425712	Spiroplasma endosymbiont of Rhagonycha fulva isolate 54749 genome assembly, chromosome: 1	blastn	58	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Rhagonycha fulva
25262091	25262091	PRJNA1148190_P_NODE_60400_length_738_cov_1.542857_g49409_i0	PRJNA1148190	60400	738	1.542857	11.38628466	Mycoplasma	2093	Bacteria	Bacteria	82.4	9.43e-11	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g49409	i0	84.884	1.42547425474255	86	8	11	4	440	522	19011	18928	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	1052	82.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii

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