metadata: contig_metadata: 47 rows where analysis = "blastn", bioproject = "PRJNA382357" and tax

47 rows where analysis = "blastn", bioproject = "PRJNA382357" 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
403687	403687	PRJNA382357_P_NODE_3641_length_999_cov_9931.280384_g3085_i0	PRJNA382357	3641	999	9931.280384	99213.49103616	endosymbiont DhMRE of Dentiscutata heterogama	1609546	Bacteria	Bacteria	366	3.179999999999999e-96	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g3085	i0	81.941	103.778778778779	443	70	70	9	102	540	618280	618716	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	103675	366	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
404315	404315	PRJNA382357_P_NODE_7321_length_751_cov_8976.556522_g6657_i0	PRJNA382357	7321	751	8976.556522	67413.93948022	endosymbiont DhMRE of Dentiscutata heterogama	1609546	Bacteria	Bacteria	396	3.02e-105	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g6657	i0	81.818	46.8828229027963	484	76	79	11	102	580	618280	618756	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	35209	396	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
404700	404700	PRJNA382357_P_NODE_96221_length_246_cov_2.108108_g95482_i0	PRJNA382357	96221	246	2.108108	5.18594568	uncultured Mycoplasma sp.	167967	Bacteria	Bacteria	342	1.1799999999999997e-89	NTclustered	gi\|156530449\|gb\|EU082027.1\|	167967	g95482	i0	100	0.752032520325203	185	0	75	0	1	185	132	316	Uncultured Mycoplasma sp. clone EH-SH-02 glycogen synthase gene, partial cds	blastn	185	342	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	uncultured Mycoplasma sp.
1075564	1075564	PRJNA382357_P_NODE_941_length_1684_cov_9917.224892_g575_i0	PRJNA382357	941	1684	9917.224892	167006.06718128	Bacteria	2	Bacteria	Bacteria	654	0	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g575	i0	82.592	141.300475059382	764	112	88	17	829	1583	619031	618280	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	237950	654	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
1677546	1677546	PRJNA382357_P_NODE_1322_length_1457_cov_6685.550860_g917_i0	PRJNA382357	1322	1457	6685.55086	97408.4760302	endosymbiont DhMRE of Dentiscutata heterogama	1609546	Bacteria	Bacteria	436	3.53e-117	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g917	i0	82.609	27.334248455731	506	76	60	11	102	602	618280	618778	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	39826	436	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
2953672	2953672	PRJNA382357_P_NODE_1503_length_1393_cov_3806.051802_g1082_i0	PRJNA382357	1503	1393	3806.051802	53018.30160186	endosymbiont DhMRE of Dentiscutata heterogama	1609546	Bacteria	Bacteria	217	4.78e-51	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g1082	i0	88.172	17.3244795405599	186	17	18	3	538	723	617558	617738	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	24133	217	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
2954297	2954297	PRJNA382357_P_NODE_3283_length_1041_cov_5668.815306_g2742_i0	PRJNA382357	3283	1041	5668.815306	59012.36733546	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	241	2.1e-58	NTclustered	gi\|2579242005\|gb\|CP125275.1\|	2685873	g2742	i0	80.435	109.672430355427	322	58	60	5	207	526	541524	541842	MAG: Mycoplasmataceae bacterium isolate AD185 chromosome, complete genome	blastn	114169	241	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
2955316	2955316	PRJNA382357_P_NODE_9483_length_672_cov_7101.499182_g8786_i0	PRJNA382357	9483	672	7101.499182	47722.07450304	endosymbiont DhMRE of Dentiscutata heterogama	1609546	Bacteria	Bacteria	435	5.69e-117	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g8786	i0	83.231	95.2291666666667	489	66	81	13	189	669	618456	618936	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	63994	435	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
4230551	4230551	PRJNA382357_P_NODE_170624_length_170_cov_8.027523_g169885_i0	PRJNA382357	170624	170	8.027523	13.6467891	Candidatus Hepatoplasma vulgare	3132032	Bacteria	Bacteria	58.4	3.06e-4	NTclustered	gi\|2416256354\|dbj\|AP027131.1\|	3132032	g169885	i0	100	0.182352941176471	31	0	18	0	29	59	629388	629358	MAG: Candidatus Hepatoplasma vulgare Av-JP DNA, complete genome	blastn	31	58.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Candidatus Hepatoplasmataceae	Candidatus Hepatoplasma	Candidatus Hepatoplasma vulgare
4903006	4903006	PRJNA382357_P_NODE_27204_length_431_cov_1.135135_g26466_i0	PRJNA382357	27204	431	1.135135	4.89243185	Spiroplasma	2132	Bacteria	Bacteria	52.8	0.042	NTclustered	gi\|2802839268\|emb\|OZ181653.1\|	3066280	g26466	i0	100	0.129930394431555	28	0	6	0	20	47	1047286	1047313	Spiroplasma endosymbiont of Rhagonycha fulva isolate 54749 genome assembly, chromosome: 1	blastn	56	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Rhagonycha fulva
6781531	6781531	PRJNA382357_P_NODE_4426_length_925_cov_10459.234954_g3832_i0	PRJNA382357	4426	925	10459.234954	96747.9233245	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	320	2.32e-82	NTclustered	gi\|2579241394\|gb\|CP125274.1\|	2685873	g3832	i0	82.4	53.0767567567568	375	58	40	6	103	473	238099	237729	MAG: Mycoplasmataceae bacterium isolate MRE chromosome, complete genome	blastn	49096	320	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
6782181	6782181	PRJNA382357_P_NODE_8186_length_716_cov_3331.395420_g7510_i0	PRJNA382357	8186	716	3331.39542	23852.7912072	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	104	1.95e-17	NTclustered	gi\|2579243139\|gb\|CP125277.1\|	2685873	g7510	i0	75.221	47.0977653631285	226	53	31	3	287	510	120083	119859	MAG: Mycoplasmataceae bacterium isolate AD073 chromosome, complete genome	blastn	33722	104	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
8056149	8056149	PRJNA382357_P_NODE_142687_length_207_cov_3.952055_g141948_i0	PRJNA382357	142687	207	3.952055	8.18075385	uncultured Mycoplasma sp.	167967	Bacteria	Bacteria	165	2.23e-36	NTclustered	gi\|156530449\|gb\|EU082027.1\|	167967	g141948	i0	100	24.2270531400966	89	0	43	0	119	207	1	89	Uncultured Mycoplasma sp. clone EH-SH-02 glycogen synthase gene, partial cds	blastn	5015	165	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	uncultured Mycoplasma sp.
8057741	8057741	PRJNA382357_P_NODE_827_length_1770_cov_2723.208894_g485_i0	PRJNA382357	827	1770	2723.208894	48200.7974238	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	453	4.28e-122	NTclustered	gi\|2579241394\|gb\|CP125274.1\|	2685873	g485	i0	81.167	16.4457627118644	600	81	33	22	800	1388	238736	238158	MAG: Mycoplasmataceae bacterium isolate MRE chromosome, complete genome	blastn	29109	453	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
8727911	8727911	PRJNA382357_P_NODE_4427_length_925_cov_6085.851852_g3833_i0	PRJNA382357	4427	925	6085.851852	56294.129631	Bacteria	2	Bacteria	Bacteria	313	3.88e-80	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g3833	i0	81.203	27.8475675675676	399	65	59	10	150	544	618672	618280	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	25759	316	0.990506329113924	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
9332318	9332318	PRJNA382357_P_NODE_6668_length_778_cov_4335.849372_g6014_i0	PRJNA382357	6668	778	4335.849372	33732.90811416	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	195	1.22e-44	NTclustered	gi\|2579242005\|gb\|CP125275.1\|	2685873	g6014	i0	79.57	46.0359897172237	279	52	54	5	296	572	541799	541524	MAG: Mycoplasmataceae bacterium isolate AD185 chromosome, complete genome	blastn	35816	195	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
10608242	10608242	PRJNA382357_P_NODE_7929_length_725_cov_9075.459337_g7255_i0	PRJNA382357	7929	725	9075.459337	65797.08019325	endosymbiont DhMRE of Dentiscutata heterogama	1609546	Bacteria	Bacteria	436	1.71e-117	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g7255	i0	82.609	119.355862068966	506	76	69	11	102	602	618280	618778	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	86533	436	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
11882060	11882060	PRJNA382357_P_NODE_1770_length_1306_cov_9191.294779_g1334_i0	PRJNA382357	1770	1306	9191.294779	120038.30981374	endosymbiont DhMRE of Dentiscutata heterogama	1609546	Bacteria	Bacteria	582	3.829999999999999e-161	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g1334	i0	82.482	97.9280245022971	685	100	89	17	531	1205	618954	618280	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	127894	582	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
11882345	11882345	PRJNA382357_P_NODE_34110_length_389_cov_1.125000_g33371_i0	PRJNA382357	34110	389	1.125	4.37625	Spiroplasma phoeniceum	47835	Bacteria	Bacteria	52.8	0.037	NTclustered	gi\|1434284537\|gb\|CP031088.1\|	1276259	g33371	i0	100	0.287917737789203	28	0	7	0	137	164	257500	257473	Spiroplasma phoeniceum P40 chromosome, complete genome	blastn	112	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma phoeniceum
11882365	11882365	PRJNA382357_P_NODE_3510_length_1013_cov_9197.072479_g2959_i0	PRJNA382357	3510	1013	9197.072479	93166.34421227	endosymbiont DhMRE of Dentiscutata heterogama	1609546	Bacteria	Bacteria	520	2.34e-142	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g2959	i0	83.219	72.0700888450148	584	81	57	14	435	1010	618362	618936	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	73007	520	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
13156465	13156465	PRJNA382357_P_NODE_1291_length_1476_cov_8171.487633_g887_i0	PRJNA382357	1291	1476	8171.487633	120611.15746308	endosymbiont DhMRE of Dentiscutata heterogama	1609546	Bacteria	Bacteria	582	4.34e-161	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g887	i0	82.456	52.4288617886179	684	102	46	15	102	776	618280	618954	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	77385	582	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
13157288	13157288	PRJNA382357_P_NODE_2651_length_1130_cov_4439.544434_g2151_i0	PRJNA382357	2651	1130	4439.544434	50166.8521042	endosymbiont DhMRE of Dentiscutata heterogama	1609546	Bacteria	Bacteria	233	3.83e-56	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g2151	i0	78.684	20.3734513274336	380	60	49	15	318	692	617685	618048	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	23022	233	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
15102414	15102414	PRJNA382357_P_NODE_135592_length_211_cov_0.866667_g134853_i0	PRJNA382357	135592	211	0.866667	1.82866737	Spiroplasma	2132	Bacteria	Bacteria	333	5.91e-87	NTclustered	gi\|2444111447\|gb\|CP117528.1\|	614643	g134853	i0	100	25.3981042654028	180	0	100	0	32	211	227283	227104	MAG: Spiroplasma endosymbiont of Drosophila atripex isolate sAtri chromosome, complete genome	blastn	5359	335	0.994029850746269	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Drosophila atripex
15102970	15102970	PRJNA382357_P_NODE_4012_length_962_cov_6211.379578_g3432_i0	PRJNA382357	4012	962	6211.379578	59753.47154036	Bacteria	2	Bacteria	Bacteria	340	1.86e-88	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g3432	i0	81.455	82.8991683991684	426	69	44	9	440	861	618699	618280	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	79749	340	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
15706171	15706171	PRJNA382357_P_NODE_1993_length_1249_cov_4571.131313_g1535_i0	PRJNA382357	1993	1249	4571.131313	57093.43009937	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	412	5.079999999999999e-110	NTclustered	gi\|2579241394\|gb\|CP125274.1\|	2685873	g1535	i0	82.376	22.9055244195356	505	60	62	19	535	1029	238711	238226	MAG: Mycoplasmataceae bacterium isolate MRE chromosome, complete genome	blastn	28609	412	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
15706941	15706941	PRJNA382357_P_NODE_673_length_1906_cov_4555.336585_g354_i0	PRJNA382357	673	1906	4555.336585	86824.7153101	endosymbiont DhMRE of Dentiscutata heterogama	1609546	Bacteria	Bacteria	226	1.09e-53	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g354	i0	79.037	15.197796432319	353	56	18	14	1121	1468	617709	618048	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	28967	226	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
15706977	15706977	PRJNA382357_P_NODE_693_length_1890_cov_4558.758338_g369_i0	PRJNA382357	693	1890	4558.758338	86160.5325882	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	331	2.24e-85	NTclustered	gi\|2579241394\|gb\|CP125274.1\|	2685873	g369	i0	81.364	20.9518518518519	440	53	37	19	927	1356	238291	238711	MAG: Mycoplasmataceae bacterium isolate MRE chromosome, complete genome	blastn	39599	331	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
15707139	15707139	PRJNA382357_P_NODE_793_length_1792_cov_5351.017909_g457_i0	PRJNA382357	793	1792	5351.017909	95890.24092928	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	433	5.639999999999998e-116	NTclustered	gi\|2579242005\|gb\|CP125275.1\|	2685873	g457	i0	81.086	66.1422991071429	571	83	63	20	383	945	542282	541729	MAG: Mycoplasmataceae bacterium isolate AD185 chromosome, complete genome	blastn	118527	433	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
16980807	16980807	PRJNA382357_P_NODE_2154_length_1215_cov_6891.418544_g1683_i0	PRJNA382357	2154	1215	6891.418544	83730.7353096	endosymbiont DhMRE of Dentiscutata heterogama	1609546	Bacteria	Bacteria	484	1.03e-131	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g1683	i0	82.74	43.877366255144	562	80	46	14	4	557	618936	618384	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	53311	484	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
16981083	16981083	PRJNA382357_P_NODE_3754_length_986_cov_5468.207568_g3188_i0	PRJNA382357	3754	986	5468.207568	53916.52662048	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	215	1.2e-50	NTclustered	gi\|2579242005\|gb\|CP125275.1\|	2685873	g3188	i0	80.068	153.786004056795	296	54	58	5	207	500	541524	541816	MAG: Mycoplasmataceae bacterium isolate AD185 chromosome, complete genome	blastn	151633	215	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
16981087	16981087	PRJNA382357_P_NODE_3774_length_984_cov_10482.749729_g3208_i0	PRJNA382357	3774	984	10482.749729	103150.25733336	endosymbiont DhMRE of Dentiscutata heterogama	1609546	Bacteria	Bacteria	361	1.46e-94	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g3208	i0	81.818	91.2164634146341	440	70	44	9	102	537	618280	618713	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	89757	361	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
16981861	16981861	PRJNA382357_P_NODE_834_length_1765_cov_4530.755282_g491_i0	PRJNA382357	834	1765	4530.755282	79967.8307273	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	412	7.239999999999999e-110	NTclustered	gi\|2579241394\|gb\|CP125274.1\|	2685873	g491	i0	82.376	16.2033994334278	505	60	44	19	535	1029	238711	238226	MAG: Mycoplasmataceae bacterium isolate MRE chromosome, complete genome	blastn	28599	412	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
18254574	18254574	PRJNA382357_P_NODE_1455_length_1411_cov_9112.591852_g1038_i0	PRJNA382357	1455	1411	9112.591852	128578.67103172	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	776	0	NTclustered	gi\|2579241394\|gb\|CP125274.1\|	2685873	g1038	i0	80.556	111.513111268604	1044	174	73	22	28	1061	237075	238099	MAG: Mycoplasmataceae bacterium isolate MRE chromosome, complete genome	blastn	157345	776	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
18255137	18255137	PRJNA382357_P_NODE_2735_length_1118_cov_5705.917692_g2229_i0	PRJNA382357	2735	1118	5705.917692	63792.15979656	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	311	1.7e-79	NTclustered	gi\|2579242005\|gb\|CP125275.1\|	2685873	g2229	i0	80.941	105.691413237925	404	67	63	7	512	912	541920	541524	MAG: Mycoplasmataceae bacterium isolate AD185 chromosome, complete genome	blastn	118163	311	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
19530367	19530367	PRJNA382357_P_NODE_8536_length_703_cov_8269.875389_g7856_i0	PRJNA382357	8536	703	8269.875389	58137.22398467	endosymbiont DhMRE of Dentiscutata heterogama	1609546	Bacteria	Bacteria	418	6.009999999999999e-112	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g7856	i0	83.227	74.2005689900427	471	64	66	12	238	700	618473	618936	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	52163	418	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
20804247	20804247	PRJNA382357_P_NODE_1297_length_1474_cov_4844.323425_g893_i0	PRJNA382357	1297	1474	4844.323425	71405.3272845	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	359	7.96e-94	NTclustered	gi\|2579241394\|gb\|CP125274.1\|	2685873	g893	i0	81.435	16.3962008141113	474	57	50	21	477	940	238259	238711	MAG: Mycoplasmataceae bacterium isolate MRE chromosome, complete genome	blastn	24168	359	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
21476507	21476507	PRJNA382357_P_NODE_162577_length_190_cov_1088.240310_g161838_i0	PRJNA382357	162577	190	1088.24031	2067.656589	Bacillati	1783272	Bacteria	Bacteria	84.2	5.79e-12	NTclustered	gi\|2579242005\|gb\|CP125275.1\|	2685873	g161838	i0	96.078	73.3842105263158	51	2	27	0	140	190	542661	542711	MAG: Mycoplasmataceae bacterium isolate AD185 chromosome, complete genome	blastn	13943	84.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
21476713	21476713	PRJNA382357_P_NODE_2497_length_1153_cov_9321.978022_g2002_i0	PRJNA382357	2497	1153	9321.978022	107482.40659366	Bacteria	2	Bacteria	Bacteria	571	7.289999999999997e-158	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g2002	i0	82.583	106.68777103209	666	98	91	15	494	1150	618280	618936	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	123011	571	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
21476829	21476829	PRJNA382357_P_NODE_3717_length_990_cov_8351.747040_g3156_i0	PRJNA382357	3717	990	8351.74704	82682.295696	Bacteria	2	Bacteria	Bacteria	571	6.229999999999998e-158	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g3156	i0	82.583	94.2171717171717	666	98	79	15	331	987	618280	618936	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	93275	571	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
21477053	21477053	PRJNA382357_P_NODE_637_length_1966_cov_8118.553806_g324_i0	PRJNA382357	637	1966	8118.553806	159610.76782596	Bacteria	2	Bacteria	Bacteria	571	1.2599999999999999e-157	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g324	i0	82.583	115.31993896236	666	98	68	15	4	660	618936	618280	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	226719	571	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
22079014	22079014	PRJNA382357_P_NODE_1138_length_1561_cov_7589.124000_g751_i0	PRJNA382357	1138	1561	7589.124	118466.22564	endosymbiont DhMRE of Dentiscutata heterogama	1609546	Bacteria	Bacteria	710	0	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g751	i0	81.944	90.955797565663	864	133	55	19	607	1460	619130	618280	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	141982	710	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
22079926	22079926	PRJNA382357_P_NODE_1938_length_1262_cov_9396.577852_g1484_i0	PRJNA382357	1938	1262	9396.577852	118584.81249224	endosymbiont DhMRE of Dentiscutata heterogama	1609546	Bacteria	Bacteria	582	3.7e-161	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g1484	i0	82.456	53.8185419968304	684	102	53	15	11	685	618954	618280	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	67919	582	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
22752436	22752436	PRJNA382357_P_NODE_898_length_1714_cov_7247.596491_g544_i0	PRJNA382357	898	1714	7247.596491	124223.80385574	Bacteria	2	Bacteria	Bacteria	571	1.0999999999999999e-157	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g544	i0	82.583	54.3191365227538	666	98	38	15	4	660	618936	618280	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	93103	571	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
23356296	23356296	PRJNA382357_P_NODE_64899_length_292_cov_706.878788_g64160_i0	PRJNA382357	64899	292	706.878788	2064.08606096	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	106	2.05e-18	NTclustered	gi\|2579242005\|gb\|CP125275.1\|	2685873	g64160	i0	85.714	90.263698630137	105	10	83	4	64	166	542711	542610	MAG: Mycoplasmataceae bacterium isolate AD185 chromosome, complete genome	blastn	26357	106	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
23356711	23356711	PRJNA382357_P_NODE_899_length_1714_cov_2815.598306_g545_i0	PRJNA382357	899	1714	2815.598306	48259.35496484	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	453	4.14e-122	NTclustered	gi\|2579241394\|gb\|CP125274.1\|	2685873	g545	i0	81.167	16.9830805134189	600	81	34	22	383	971	238158	238736	MAG: Mycoplasmataceae bacterium isolate MRE chromosome, complete genome	blastn	29109	453	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
24027399	24027399	PRJNA382357_P_NODE_999_length_1638_cov_4633.129360_g626_i0	PRJNA382357	999	1638	4633.12936	75890.6589168	Bacteria	2	Bacteria	Bacteria	217	5.65e-51	NTclustered	gi\|820946451\|emb\|LN828718.1\|	1609546	g626	i0	88.172	26.5567765567766	186	17	11	3	538	723	617558	617738	endosymbiont DhMRE of Dentiscutata heterogama genome assembly DhMREa, chromosome : 1	blastn	43500	219	0.990867579908676	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont DhMRE of Dentiscutata heterogama
24630785	24630785	PRJNA382357_P_NODE_78120_length_269_cov_5669.947115_g77381_i0	PRJNA382357	78120	269	5669.947115	15252.15773935	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	102	2.41e-17	NTclustered	gi\|2579242005\|gb\|CP125275.1\|	2685873	g77381	i0	91.781	121.970260223048	73	6	74	0	1	73	541744	541816	MAG: Mycoplasmataceae bacterium isolate AD185 chromosome, complete genome	blastn	32810	102	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium

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