metadata: contig_metadata: 32 rows where analysis = "blastn", bioproject = "PRJNA1034995" and tax

32 rows where analysis = "blastn", bioproject = "PRJNA1034995" 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
168274	168274	PRJNA1034995_S_NODE_11201_length_1093_cov_30.122857_g11178_i0	PRJNA1034995	11201	1093	30.122857	329.24282701	Mycoplasma wenyonii	65123	Bacteria	Bacteria	974	0	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g11178	i0	93.578	0.938700823421775	654	41	94	1	433	1085	634424	633771	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	1026	974	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
1443072	1443072	PRJNA1034995_S_NODE_17542_length_431_cov_9.850515_g17387_i0	PRJNA1034995	17542	431	9.850515	42.45571965	Mycoplasma wenyonii	65123	Bacteria	Bacteria	725	0	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g17387	i0	96.984	1	431	13	100	0	1	431	134389	134819	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	431	725	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
1443211	1443211	PRJNA1034995_S_NODE_34762_length_235_cov_5.510417_g34606_i0	PRJNA1034995	34762	235	5.510417	12.94947995	Mycoplasma wenyonii	65123	Bacteria	Bacteria	261	3.21e-65	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g34606	i0	86.752	2.20851063829787	234	31	99	0	1	234	251406	251173	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	519	261	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
3994915	3994915	PRJNA1034995_S_NODE_20984_length_368_cov_37.452308_g20828_i0	PRJNA1034995	20984	368	37.452308	137.82449344	Mycoplasma wenyonii	65123	Bacteria	Bacteria	680	0	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g20828	i0	100	1	368	0	100	0	1	368	205815	206182	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	368	680	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
3995097	3995097	PRJNA1034995_S_NODE_47704_length_172_cov_2.984496_g47548_i0	PRJNA1034995	47704	172	2.984496	5.13333312	Mycoplasma wenyonii	65123	Bacteria	Bacteria	261	2.2000000000000002e-65	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g47548	i0	96.795	0.906976744186046	156	5	91	0	1	156	635248	635093	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	156	261	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
5271249	5271249	PRJNA1034995_S_NODE_23305_length_337_cov_15.663265_g23149_i0	PRJNA1034995	23305	337	15.663265	52.78520305	Mycoplasma wenyonii	65123	Bacteria	Bacteria	549	9.249999999999997e-152	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g23149	i0	96.154	1.00296735905045	338	10	100	3	1	337	440583	440918	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	338	549	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
6546366	6546366	PRJNA1034995_S_NODE_15686_length_475_cov_21.810185_g15535_i0	PRJNA1034995	15686	475	21.810185	103.59837875	Mycoplasma ovis	171632	Bacteria	Bacteria	220	1.2e-52	NTclustered	gi\|566058721\|gb\|CP006935.1\|	1415773	g15535	i0	83.264	0.503157894736842	239	40	50	0	177	415	206992	207230	Mycoplasma ovis str. Michigan, complete genome	blastn	239	220	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma ovis
6546408	6546408	PRJNA1034995_S_NODE_19846_length_386_cov_24.212828_g19691_i0	PRJNA1034995	19846	386	24.212828	93.46151608	Mycoplasma wenyonii	65123	Bacteria	Bacteria	523	6.5e-144	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g19691	i0	91.579	0.984455958549223	380	31	98	1	8	386	363295	362916	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	380	523	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
6546638	6546638	PRJNA1034995_S_NODE_51386_length_160_cov_1.572650_g51230_i0	PRJNA1034995	51386	160	1.57265	2.51624	Mycoplasma wenyonii	65123	Bacteria	Bacteria	235	1.23e-57	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g51230	i0	93.168	1.00625	161	9	100	2	1	160	259832	259673	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	161	235	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
7821059	7821059	PRJNA1034995_S_NODE_26047_length_306_cov_11.338403_g25891_i0	PRJNA1034995	26047	306	11.338403	34.69551318	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	298	3.32e-76	NTclustered	gi\|2187152065\|emb\|OV788643.1\|	658143	g25891	i0	86.94	86.9183006535948	268	31	87	4	24	289	620987	620722	uncultured Tenericutes bacterium isolate min17_bin32 genome assembly, chromosome: 1	blastn	26597	298	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
9095924	9095924	PRJNA1034995_S_NODE_21628_length_359_cov_19.148734_g21472_i0	PRJNA1034995	21628	359	19.148734	68.74395506	Mycoplasma wenyonii	65123	Bacteria	Bacteria	501	2.8099999999999993e-137	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g21472	i0	93.713	1.10306406685237	334	21	93	0	1	334	324156	324489	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	396	501	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
9095977	9095977	PRJNA1034995_S_NODE_27528_length_292_cov_3.823293_g27372_i0	PRJNA1034995	27528	292	3.823293	11.16401556	Mycoplasma wenyonii	65123	Bacteria	Bacteria	479	1.0499999999999996e-130	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g27372	i0	96.233	1	292	11	100	0	1	292	81258	81549	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	292	479	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
10371542	10371542	PRJNA1034995_S_NODE_12449_length_628_cov_25.148718_g12343_i0	PRJNA1034995	12449	628	25.148718	157.93394904	Mycoplasma ovis	171632	Bacteria	Bacteria	521	3.9499999999999997e-143	NTclustered	gi\|566058721\|gb\|CP006935.1\|	1415773	g12343	i0	82.881	1.84076433121019	590	91	93	7	1	585	418707	419291	Mycoplasma ovis str. Michigan, complete genome	blastn	1156	521	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma ovis
10371551	10371551	PRJNA1034995_S_NODE_13929_length_532_cov_70.787321_g13785_i0	PRJNA1034995	13929	532	70.787321	376.58854772	Mycoplasma wenyonii	65123	Bacteria	Bacteria	863	0	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g13785	i0	96.545	0.979323308270677	521	18	98	0	11	531	503737	504257	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	521	863	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
10371649	10371649	PRJNA1034995_S_NODE_27209_length_295_cov_10.055556_g27053_i0	PRJNA1034995	27209	295	10.055556	29.6638902	Mycoplasma wenyonii	65123	Bacteria	Bacteria	244	4.21e-60	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g27053	i0	83.212	1.40338983050847	274	38	92	7	1	271	141630	141362	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	414	244	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
10371719	10371719	PRJNA1034995_S_NODE_35569_length_230_cov_3.181818_g35413_i0	PRJNA1034995	35569	230	3.181818	7.3181814	Mycoplasma wenyonii	65123	Bacteria	Bacteria	337	5.059999999999998e-88	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g35413	i0	93.043	1	230	16	100	0	1	230	146766	146537	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	230	337	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
12922096	12922096	PRJNA1034995_S_NODE_24271_length_325_cov_13.570922_g24115_i0	PRJNA1034995	24271	325	13.570922	44.1054965	Mycoplasma wenyonii	65123	Bacteria	Bacteria	237	7.860000000000001e-58	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g24115	i0	81.481	0.913846153846154	297	47	90	7	14	306	491590	491298	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	297	237	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
14197150	14197150	PRJNA1034995_S_NODE_39972_length_205_cov_3.407407_g39816_i0	PRJNA1034995	39972	205	3.407407	6.98518435	Mycoplasma wenyonii	65123	Bacteria	Bacteria	237	4.6e-58	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g39816	i0	88	0.975609756097561	200	24	98	0	3	202	345191	344992	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	200	237	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
15471158	15471158	PRJNA1034995_S_NODE_12313_length_645_cov_28.456811_g12212_i0	PRJNA1034995	12313	645	28.456811	183.54643095	Mycoplasma wenyonii	65123	Bacteria	Bacteria	1075	0	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g12212	i0	96.744	1.04496124031008	645	21	100	0	1	645	203933	204577	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	674	1075	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
15471162	15471162	PRJNA1034995_S_NODE_12613_length_612_cov_18.200351_g12500_i0	PRJNA1034995	12613	612	18.200351	111.38614812	Mycoplasma ovis	171632	Bacteria	Bacteria	593	8.039999999999997e-165	NTclustered	gi\|566058721\|gb\|CP006935.1\|	1415773	g12500	i0	84.848	2.6062091503268	594	84	96	6	23	612	432270	431679	Mycoplasma ovis str. Michigan, complete genome	blastn	1595	593	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma ovis
15471201	15471201	PRJNA1034995_S_NODE_16693_length_448_cov_41.975309_g16539_i0	PRJNA1034995	16693	448	41.975309	188.04938432	Mycoplasma wenyonii	65123	Bacteria	Bacteria	464	4.699999999999999e-126	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g16539	i0	100	1.01116071428571	251	0	100	0	1	251	368213	367963	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	453	464	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
15471375	15471375	PRJNA1034995_S_NODE_40293_length_203_cov_7.050000_g40137_i0	PRJNA1034995	40293	203	7.05	14.3115	Mycoplasma wenyonii	65123	Bacteria	Bacteria	294	2.66e-75	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g40137	i0	96.629	1.07389162561576	178	5	88	1	1	178	520513	520689	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	218	294	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
18020232	18020232	PRJNA1034995_S_NODE_21955_length_355_cov_4.086538_g21799_i0	PRJNA1034995	21955	355	4.086538	14.5072099	Mycoplasma wenyonii	65123	Bacteria	Bacteria	623	5.679999999999999e-174	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g21799	i0	98.31	1	355	6	100	0	1	355	649576	649930	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	355	623	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
18020413	18020413	PRJNA1034995_S_NODE_47135_length_174_cov_1.755725_g46979_i0	PRJNA1034995	47135	174	1.755725	3.0549615	Mycoplasma wenyonii	65123	Bacteria	Bacteria	322	1.01e-83	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g46979	i0	100	1	174	0	100	0	1	174	375864	375691	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	174	322	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
19294189	19294189	PRJNA1034995_S_NODE_23676_length_332_cov_18.411765_g23520_i0	PRJNA1034995	23676	332	18.411765	61.1270598	Mycoplasma wenyonii	65123	Bacteria	Bacteria	446	1.23e-120	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g23520	i0	94.178	0.963855421686747	292	17	88	0	1	292	49016	48725	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	320	446	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
19294214	19294214	PRJNA1034995_S_NODE_26156_length_305_cov_9.442748_g26000_i0	PRJNA1034995	26156	305	9.442748	28.8003814	Mycoplasma wenyonii	65123	Bacteria	Bacteria	263	1.21e-65	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g26000	i0	99.31	1.00327868852459	145	1	93	0	161	305	565720	565864	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	306	263	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
21845276	21845276	PRJNA1034995_S_NODE_21598_length_359_cov_34.145570_g21442_i0	PRJNA1034995	21598	359	34.14557	122.5825963	Mycoplasma wenyonii	65123	Bacteria	Bacteria	599	9.69e-167	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g21442	i0	97.971	0.96100278551532	345	7	96	0	3	347	164920	164576	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	345	599	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
21845432	21845432	PRJNA1034995_S_NODE_42078_length_195_cov_1.953947_g41922_i0	PRJNA1034995	42078	195	1.953947	3.81019665	Mycoplasma wenyonii	65123	Bacteria	Bacteria	311	2.52e-80	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g41922	i0	99.415	1.16923076923077	171	1	88	0	25	195	368914	369084	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	228	311	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
23120515	23120515	PRJNA1034995_S_NODE_13999_length_529_cov_34.674897_g13853_i0	PRJNA1034995	13999	529	34.674897	183.43020513	Mycoplasma wenyonii	65123	Bacteria	Bacteria	593	6.879999999999998e-165	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g13853	i0	93.284	0.75992438563327	402	27	76	0	1	402	175811	176212	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	402	593	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
23120595	23120595	PRJNA1034995_S_NODE_21019_length_368_cov_18.686154_g20863_i0	PRJNA1034995	21019	368	18.686154	68.76504672	Mycoplasma ovis	171632	Bacteria	Bacteria	311	5.22e-80	NTclustered	gi\|566058721\|gb\|CP006935.1\|	1415773	g20863	i0	83.003	2.27445652173913	353	50	95	5	21	368	330575	330922	Mycoplasma ovis str. Michigan, complete genome	blastn	837	311	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma ovis
23120724	23120724	PRJNA1034995_S_NODE_37479_length_218_cov_30.011429_g37323_i0	PRJNA1034995	37479	218	30.011429	65.42491522	Mycoplasma wenyonii	65123	Bacteria	Bacteria	381	2.1599999999999994e-101	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g37323	i0	98.165	1	218	4	100	0	1	218	489979	490196	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	218	381	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
24394620	24394620	PRJNA1034995_S_NODE_43620_length_188_cov_2.241379_g43464_i0	PRJNA1034995	43620	188	2.241379	4.21379252	Mycoplasma wenyonii	65123	Bacteria	Bacteria	76.8	9.56e-10	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g43464	i0	92.453	0.281914893617021	53	4	28	0	131	183	126447	126499	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	53	76.8	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);;