metadata: contig_metadata: 51 rows where analysis = "blastn", bioproject = "PRJNA870096" and tax

51 rows where analysis = "blastn", bioproject = "PRJNA870096" 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
849232	849232	PRJNA870096_S_NODE_101941_length_175_cov_1.439394_g100277_i0	PRJNA870096	101941	175	1.439394	2.5189395	Mycoplasma yeatsii	51365	Bacteria	Bacteria	289	1.0299999999999998e-73	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g100277	i0	96.552	52.6628571428571	174	6	99	0	2	175	25839	25666	Mycoplasma yeatsii GM274B	blastn	9216	289	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
850607	850607	PRJNA870096_S_NODE_79821_length_196_cov_1.928105_g78157_i0	PRJNA870096	79821	196	1.928105	3.7790858	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	344	2.4999999999999992e-90	NTclustered	gi\|2668342370\|gb\|CP143577.1\|	2094	g78157	i0	99.471	145.295918367347	189	1	96	0	8	196	439840	439652	Mycoplasmopsis arginini strain NCTC 10129 chromosome, complete genome	blastn	28478	344	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
1237410	1237410	PRJNA870096_S_NODE_99721_length_177_cov_1.141791_g98057_i0	PRJNA870096	99721	177	1.141791	2.02097007	Mesomycoplasma	2923352	Bacteria	Bacteria	305	1.04e-78	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g98057	i0	99.405	15.1864406779661	168	1	95	0	1	168	671198	671031	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	2688	305	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
2126020	2126020	PRJNA870096_S_NODE_87062_length_188_cov_1.965517_g85398_i0	PRJNA870096	87062	188	1.965517	3.69517196	Mycoplasma yeatsii	51365	Bacteria	Bacteria	337	3.97e-88	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g85398	i0	98.936	63.3085106382979	188	2	100	0	1	188	529838	530025	Mycoplasma yeatsii GM274B	blastn	11902	337	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
2512860	2512860	PRJNA870096_S_NODE_41922_length_274_cov_1.246753_g40258_i0	PRJNA870096	41922	274	1.246753	3.41610322	Mesomycoplasma	2923352	Bacteria	Bacteria	507	4.47e-139	NTclustered	gi\|2065475\|gb\|U35016.1\|MHU35016	2100	g40258	i0	100	38.6605839416058	274	0	100	0	1	274	543	270	Mycoplasma hyorhinis VlpD prolipoprotein (vlpD), VlpE prolipoprotein (vlpE), VlpF prolipoprotein (vlpF) genes, complete cds	blastn	10593	507	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
3400854	3400854	PRJNA870096_S_NODE_39863_length_281_cov_2.794118_g38199_i0	PRJNA870096	39863	281	2.794118	7.85147158	Mycoplasma yeatsii	51365	Bacteria	Bacteria	481	2.79e-131	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g38199	i0	97.509	5.97864768683274	281	7	100	0	1	281	529186	528906	Mycoplasma yeatsii GM274B	blastn	1680	481	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
3401131	3401131	PRJNA870096_S_NODE_64623_length_218_cov_1.371429_g62959_i0	PRJNA870096	64623	218	1.371429	2.98971522	Mycoplasma yeatsii	51365	Bacteria	Bacteria	255	1.37e-63	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g62959	i0	88.263	3.44954128440367	213	25	98	0	1	213	696380	696168	Mycoplasma yeatsii GM274B	blastn	752	255	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
3401281	3401281	PRJNA870096_S_NODE_76743_length_200_cov_1.490446_g75079_i0	PRJNA870096	76743	200	1.490446	2.980892	Mycoplasma yeatsii	51365	Bacteria	Bacteria	353	4.25e-93	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g75079	i0	98.5	1	200	3	100	0	1	200	82021	81822	Mycoplasma yeatsii GM274B	blastn	200	353	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
3789315	3789315	PRJNA870096_S_NODE_98743_length_178_cov_1.000000_g97079_i0	PRJNA870096	98743	178	1	1.78	Mesomycoplasma	2923352	Bacteria	Bacteria	324	2.89e-84	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g97079	i0	99.438	15.5730337078652	178	1	100	0	1	178	840529	840352	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	2772	324	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
5953113	5953113	PRJNA870096_S_NODE_145305_length_150_cov_1.345794_g143641_i0	PRJNA870096	145305	150	1.345794	2.018691	Mycoplasma wenyonii	65123	Bacteria	Bacteria	270	3.1e-68	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g143641	i0	99.329	0.993333333333333	149	1	99	0	1	149	288197	288049	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	149	270	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
5953477	5953477	PRJNA870096_S_NODE_47485_length_256_cov_1.802817_g45821_i0	PRJNA870096	47485	256	1.802817	4.61521152	Spiroplasma endosymbiont of Atherix ibis	3066291	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2706542420\|emb\|OZ026474.1\|	3066291	g45821	i0	100	0.109375	28	0	11	0	210	237	237507	237480	Spiroplasma endosymbiont of Atherix ibis isolate 54761 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Atherix ibis
6341169	6341169	PRJNA870096_S_NODE_133325_length_154_cov_4.882883_g131661_i0	PRJNA870096	133325	154	4.882883	7.51963982	Mesomycoplasma	2923352	Bacteria	Bacteria	285	1.14e-72	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g131661	i0	100	59.9480519480519	154	0	100	0	1	154	704507	704660	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	9232	285	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
6341289	6341289	PRJNA870096_S_NODE_64485_length_218_cov_1.697143_g62821_i0	PRJNA870096	64485	218	1.697143	3.69977174	Mesomycoplasma	2923352	Bacteria	Bacteria	403	4.62e-108	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g62821	i0	100	17.7201834862385	218	0	100	0	1	218	262825	263042	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	3863	403	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
7227982	7227982	PRJNA870096_S_NODE_144766_length_150_cov_1.794393_g143102_i0	PRJNA870096	144766	150	1.794393	2.6915895	Mycoplasma wenyonii	65123	Bacteria	Bacteria	189	8.92e-44	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g143102	i0	90.909	0.953333333333333	143	9	95	2	1	142	262637	262498	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	143	189	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
7228028	7228028	PRJNA870096_S_NODE_16626_length_448_cov_2.108642_g14980_i0	PRJNA870096	16626	448	2.108642	9.44671616	Malacoplasma muris	2119	Bacteria	Bacteria	654	0	NTclustered	gi\|299851933\|gb\|HM135461.1\|	2119	g14980	i0	93.08	118.950892857143	448	30	100	1	1	448	825	379	Mycoplasma muris strain ATCC 33757 23S ribosomal RNA gene, partial sequence	blastn	53290	654	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma muris
7228576	7228576	PRJNA870096_S_NODE_67226_length_214_cov_1.111111_g65562_i0	PRJNA870096	67226	214	1.111111	2.37777754	Mycoplasma yeatsii	51365	Bacteria	Bacteria	372	1.27e-98	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g65562	i0	98.122	7.86448598130841	213	4	99	0	2	214	526892	526680	Mycoplasma yeatsii GM274B	blastn	1683	372	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
8502319	8502319	PRJNA870096_S_NODE_114267_length_166_cov_1.560976_g112603_i0	PRJNA870096	114267	166	1.560976	2.59122016	Metamycoplasma alkalescens	45363	Bacteria	Bacteria	291	2.7099999999999998e-74	NTclustered	gi\|1450418660\|emb\|LS991949.1\|	45363	g112603	i0	98.193	2.73493975903614	166	3	100	0	1	166	458613	458448	Mycoplasma alkalescens strain NCTC10135 genome assembly, chromosome: 1	blastn	454	291	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma alkalescens
8503682	8503682	PRJNA870096_S_NODE_90487_length_185_cov_1.352113_g88823_i0	PRJNA870096	90487	185	1.352113	2.50140905	Mycoplasma yeatsii	51365	Bacteria	Bacteria	294	2.38e-75	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g88823	i0	96.61	44.1621621621622	177	6	96	0	9	185	672857	672681	Mycoplasma yeatsii GM274B	blastn	8170	294	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
8890297	8890297	PRJNA870096_S_NODE_55247_length_236_cov_2.077720_g53583_i0	PRJNA870096	55247	236	2.07772	4.9034192	Mesomycoplasma	2923352	Bacteria	Bacteria	390	3.9499999999999996e-104	NTclustered	gi\|1563681465\|emb\|LR214949.1\|	2100	g53583	i0	98.643	65.4025423728814	221	2	93	1	17	236	303639	303859	Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 3	blastn	15435	390	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
9778613	9778613	PRJNA870096_S_NODE_90288_length_185_cov_1.690141_g88624_i0	PRJNA870096	90288	185	1.690141	3.12676085	Mycoplasma yeatsii	51365	Bacteria	Bacteria	305	1.1e-78	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g88624	i0	96.721	16.4648648648649	183	6	99	0	3	185	523376	523558	Mycoplasma yeatsii GM274B	blastn	3046	305	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
10165763	10165763	PRJNA870096_S_NODE_114748_length_166_cov_1.170732_g113084_i0	PRJNA870096	114748	166	1.170732	1.94341512	Mesomycoplasma	2923352	Bacteria	Bacteria	307	2.69e-79	NTclustered	gi\|1563681465\|emb\|LR214949.1\|	2100	g113084	i0	100	16	166	0	100	0	1	166	300128	300293	Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 3	blastn	2656	307	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
10165913	10165913	PRJNA870096_S_NODE_64488_length_218_cov_1.680000_g62824_i0	PRJNA870096	64488	218	1.68	3.6624	Metamycoplasmataceae	2895623	Bacteria	Bacteria	331	2.21e-86	NTclustered	gi\|2668342370\|gb\|CP143577.1\|	2094	g62824	i0	94.037	152.55504587156	218	13	100	0	1	218	372218	372435	Mycoplasmopsis arginini strain NCTC 10129 chromosome, complete genome	blastn	33257	331	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
10165916	10165916	PRJNA870096_S_NODE_65248_length_217_cov_1.327586_g63584_i0	PRJNA870096	65248	217	1.327586	2.88086162	Mesomycoplasma	2923352	Bacteria	Bacteria	401	1.6499999999999994e-107	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g63584	i0	100	16	217	0	100	0	1	217	1655	1439	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	3472	401	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
13603864	13603864	PRJNA870096_S_NODE_48431_length_253_cov_2.804762_g46767_i0	PRJNA870096	48431	253	2.804762	7.09604786	Mycoplasma yeatsii	51365	Bacteria	Bacteria	435	1.95e-117	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g46767	i0	97.628	95.6363636363636	253	6	100	0	1	253	443717	443969	Mycoplasma yeatsii GM274B	blastn	24196	435	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
13603879	13603879	PRJNA870096_S_NODE_49591_length_250_cov_1.772947_g47927_i0	PRJNA870096	49591	250	1.772947	4.4323675	Mycoplasma yeatsii	51365	Bacteria	Bacteria	446	8.89e-121	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g47927	i0	98.8	98.476	250	3	100	0	1	250	529569	529320	Mycoplasma yeatsii GM274B	blastn	24619	446	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
13604339	13604339	PRJNA870096_S_NODE_85751_length_190_cov_0.979592_g84087_i0	PRJNA870096	85751	190	0.979592	1.8612248	Mycoplasma yeatsii	51365	Bacteria	Bacteria	279	6.88e-71	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g84087	i0	93.158	100	190	13	100	0	1	190	840638	840827	Mycoplasma yeatsii GM274B	blastn	19000	279	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
13991109	13991109	PRJNA870096_S_NODE_130631_length_156_cov_1.274336_g128967_i0	PRJNA870096	130631	156	1.274336	1.98796416	Mesomycoplasma	2923352	Bacteria	Bacteria	289	9e-74	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g128967	i0	100	16	156	0	100	0	1	156	548014	548169	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	2496	289	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
13991135	13991135	PRJNA870096_S_NODE_137811_length_153_cov_0.872727_g136147_i0	PRJNA870096	137811	153	0.872727	1.33527231	Mesomycoplasma	2923352	Bacteria	Bacteria	278	1.9e-70	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g136147	i0	99.346	16.4248366013072	153	1	100	0	1	153	797269	797117	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	2513	278	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
13991182	13991182	PRJNA870096_S_NODE_37611_length_290_cov_2.643725_g35947_i0	PRJNA870096	37611	290	2.643725	7.6668025	Mycoplasmoidales	2790996	Bacteria	Bacteria	374	5.0499999999999986e-99	NTclustered	gi\|1563789200\|emb\|LR214962.1\|	2115	g35947	i0	90.068	111.393103448276	292	24	100	5	1	290	356924	357212	Mycoplasma fermentans strain NCTC10117 genome assembly, chromosome: 8	blastn	32304	374	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis fermentans
14877443	14877443	PRJNA870096_S_NODE_118612_length_163_cov_2.000000_g116948_i0	PRJNA870096	118612	163	2	3.26	Mycoplasma yeatsii	51365	Bacteria	Bacteria	257	2.68e-64	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g116948	i0	95.092	1	163	8	100	0	1	163	489282	489120	Mycoplasma yeatsii GM274B	blastn	163	257	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
15265117	15265117	PRJNA870096_S_NODE_102272_length_175_cov_1.090909_g100608_i0	PRJNA870096	102272	175	1.090909	1.90909075	Mesomycoplasma	2923352	Bacteria	Bacteria	324	2.83e-84	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g100608	i0	100	27	175	0	100	0	1	175	780371	780545	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	4725	324	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
16152671	16152671	PRJNA870096_S_NODE_34073_length_306_cov_2.174905_g32409_i0	PRJNA870096	34073	306	2.174905	6.6552093	Metamycoplasma alkalescens	45363	Bacteria	Bacteria	544	3.86e-150	NTclustered	gi\|1450418660\|emb\|LS991949.1\|	45363	g32409	i0	99.01	0.990196078431373	303	3	99	0	4	306	458381	458079	Mycoplasma alkalescens strain NCTC10135 genome assembly, chromosome: 1	blastn	303	544	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma alkalescens
17428951	17428951	PRJNA870096_S_NODE_92954_length_183_cov_1.028571_g91290_i0	PRJNA870096	92954	183	1.028571	1.88228493	Mycoplasma cottewii	51364	Bacteria	Bacteria	154	4.15e-33	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g91290	i0	82.857	0.956284153005464	175	26	95	4	5	177	638047	637875	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	175	154	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
18702152	18702152	PRJNA870096_S_NODE_93035_length_183_cov_0.928571_g91371_i0	PRJNA870096	93035	183	0.928571	1.69928493	Mycoplasma cottewii	51364	Bacteria	Bacteria	300	5.040000000000001e-77	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g91371	i0	96.175	2.00546448087432	183	7	100	0	1	183	662926	662744	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	367	300	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
18702180	18702180	PRJNA870096_S_NODE_94535_length_181_cov_1.739130_g92871_i0	PRJNA870096	94535	181	1.73913	3.1478253	Mycoplasma wenyonii	65123	Bacteria	Bacteria	335	1.36e-87	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g92871	i0	100	1	181	0	100	0	1	181	327221	327041	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	181	335	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
19088762	19088762	PRJNA870096_S_NODE_146515_length_150_cov_0.897196_g144851_i0	PRJNA870096	146515	150	0.897196	1.345794	Mycoplasma	2093	Bacteria	Bacteria	267	4.009999999999999e-67	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g144851	i0	98.667	84.8933333333333	150	2	100	0	1	150	904787	904638	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	12734	267	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
20363676	20363676	PRJNA870096_S_NODE_43476_length_268_cov_4.946667_g41812_i0	PRJNA870096	43476	268	4.946667	13.25706756	Mycoplasma	2093	Bacteria	Bacteria	479	9.499999999999996e-131	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g41812	i0	98.881	98.6940298507463	268	3	100	0	1	268	73187	73454	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	26450	479	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
21251983	21251983	PRJNA870096_S_NODE_17617_length_434_cov_1.309463_g15969_i0	PRJNA870096	17617	434	1.309463	5.68306942	Mycoplasma yeatsii	51365	Bacteria	Bacteria	725	0	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g15969	i0	96.774	89.13133640553	434	14	100	0	1	434	527760	528193	Mycoplasma yeatsii GM274B	blastn	38683	725	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
21639276	21639276	PRJNA870096_S_NODE_122177_length_161_cov_1.398305_g120513_i0	PRJNA870096	122177	161	1.398305	2.25127105	Mycoplasmopsis	2767358	Bacteria	Bacteria	281	1.57e-71	NTclustered	gi\|2496025365\|gb\|CP123300.1\|	28903	g120513	i0	100	178.434782608696	152	0	94	0	1	152	483042	483193	Mycoplasmopsis bovis strain 15DD0238 chromosome, complete genome	blastn	28728	281	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis bovis
21639476	21639476	PRJNA870096_S_NODE_90537_length_185_cov_1.288732_g88873_i0	PRJNA870096	90537	185	1.288732	2.3841542	Mesomycoplasma	2923352	Bacteria	Bacteria	342	8.369999999999999e-90	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g88873	i0	100	19.9243243243243	185	0	100	0	1	185	401371	401187	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	3686	342	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
22526752	22526752	PRJNA870096_S_NODE_32138_length_316_cov_1.054945_g30474_i0	PRJNA870096	32138	316	1.054945	3.3336262	Mycoplasma yeatsii	51365	Bacteria	Bacteria	540	5.18e-149	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g30474	i0	97.468	31.503164556962	316	8	100	0	1	316	523295	522980	Mycoplasma yeatsii GM274B	blastn	9955	540	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
22526791	22526791	PRJNA870096_S_NODE_35338_length_300_cov_1.867704_g33674_i0	PRJNA870096	35338	300	1.867704	5.603112	Mycoplasma yeatsii	51365	Bacteria	Bacteria	549	8.119999999999997e-152	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g33674	i0	99.667	98.3033333333333	300	1	100	0	1	300	528311	528610	Mycoplasma yeatsii GM274B	blastn	29491	549	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
22915012	22915012	PRJNA870096_S_NODE_59938_length_226_cov_23.049180_g58274_i0	PRJNA870096	59938	226	23.04918	52.0911468	Mycoplasma	2093	Bacteria	Bacteria	387	4.849999999999998e-103	NTclustered	gi\|365822471\|gb\|JN935874.1\|	51364	g58274	i0	98.624	164.920353982301	218	3	96	0	1	218	1250	1467	Mycoplasma cottewii strain VIS 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	37272	387	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
23801757	23801757	PRJNA870096_S_NODE_123979_length_160_cov_1.230769_g122315_i0	PRJNA870096	123979	160	1.230769	1.9692304	Mycoplasma yeatsii	51365	Bacteria	Bacteria	246	5.67e-61	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g122315	i0	94.375	1	160	9	100	0	1	160	532234	532075	Mycoplasma yeatsii GM274B	blastn	160	246	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
23802785	23802785	PRJNA870096_S_NODE_81559_length_194_cov_2.013245_g79895_i0	PRJNA870096	81559	194	2.013245	3.9056953	Mycoplasma yeatsii	51365	Bacteria	Bacteria	331	1.92e-86	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g79895	i0	97.423	99.201030927835	194	5	100	0	1	194	588938	589131	Mycoplasma yeatsii GM274B	blastn	19245	331	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
23803009	23803009	PRJNA870096_S_NODE_98339_length_178_cov_1.355556_g96675_i0	PRJNA870096	98339	178	1.355556	2.41288968	Mycoplasma yeatsii	51365	Bacteria	Bacteria	302	1.35e-77	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g96675	i0	97.191	98.9213483146067	178	5	100	0	1	178	81620	81797	Mycoplasma yeatsii GM274B	blastn	17608	302	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
23803031	23803031	PRJNA870096_S_NODE_99379_length_177_cov_1.470149_g97715_i0	PRJNA870096	99379	177	1.470149	2.60216373	Mycoplasma yeatsii	51365	Bacteria	Bacteria	322	1.03e-83	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g97715	i0	99.435	59.4689265536723	177	1	100	0	1	177	81412	81236	Mycoplasma yeatsii GM274B	blastn	10526	322	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
25075386	25075386	PRJNA870096_S_NODE_104180_length_173_cov_2.215385_g102516_i0	PRJNA870096	104180	173	2.215385	3.83261605	Mycoplasma yeatsii	51365	Bacteria	Bacteria	291	2.8299999999999998e-74	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g102516	i0	97.093	0.994219653179191	172	5	99	0	2	173	81699	81528	Mycoplasma yeatsii GM274B	blastn	172	291	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
25076732	25076732	PRJNA870096_S_NODE_86460_length_189_cov_1.280822_g84796_i0	PRJNA870096	86460	189	1.280822	2.42075358	Mycoplasma yeatsii	51365	Bacteria	Bacteria	113	7.33e-21	NTclustered	gi\|756767228\|gb\|CP007520.1\|	743967	g84796	i0	93.421	0.804232804232804	76	5	40	0	1	76	696787	696862	Mycoplasma yeatsii GM274B	blastn	152	113	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma yeatsii
25463879	25463879	PRJNA870096_S_NODE_116160_length_165_cov_1.180328_g114496_i0	PRJNA870096	116160	165	1.180328	1.9475412	Mesomycoplasma	2923352	Bacteria	Bacteria	305	9.59e-79	NTclustered	gi\|2713084492\|gb\|CP150431.1\|	2100	g114496	i0	100	15.6848484848485	165	0	100	0	1	165	36242	36078	Mesomycoplasma hyorhinis strain Nahrain chromosome	blastn	2588	305	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
25463915	25463915	PRJNA870096_S_NODE_134440_length_154_cov_1.243243_g132776_i0	PRJNA870096	134440	154	1.243243	1.91459422	Mycoplasma	2093	Bacteria	Bacteria	246	5.4e-61	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g132776	i0	96.026	5.27272727272727	151	6	98	0	1	151	608161	608311	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	812	246	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii

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