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

32 rows where analysis = "blastn", bioproject = "PRJNA937226" 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
2187253	2187253	PRJNA937226_S_NODE_13842_length_215_cov_1.493976_g13715_i0	PRJNA937226	13842	215	1.493976	3.2120484	Mycoplasma wenyonii	65123	Bacteria	Bacteria	375	9.899999999999998e-100	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g13715	i0	98.14	1	215	4	100	0	1	215	537149	537363	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	215	375	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
2187295	2187295	PRJNA937226_S_NODE_24282_length_171_cov_3.295082_g24155_i0	PRJNA937226	24282	171	3.295082	5.63459022	Mycoplasma wenyonii	65123	Bacteria	Bacteria	161	2.28e-35	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g24155	i0	88.636	0.771929824561403	132	15	77	0	40	171	393209	393340	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	132	161	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
3462836	3462836	PRJNA937226_S_NODE_7283_length_271_cov_2.459459_g7156_i0	PRJNA937226	7283	271	2.459459	6.66513389	Mycoplasma wenyonii	65123	Bacteria	Bacteria	451	2.0999999999999997e-122	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g7156	i0	96.691	1.00369003690037	272	7	100	2	1	271	128183	127913	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	272	451	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
4740256	4740256	PRJNA937226_S_NODE_19224_length_188_cov_5.719424_g19097_i0	PRJNA937226	19224	188	5.719424	10.75251712	Mycoplasma wenyonii	65123	Bacteria	Bacteria	255	1.14e-63	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g19097	i0	90.863	1.04787234042553	197	9	100	1	1	188	318558	318362	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	197	255	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
6015130	6015130	PRJNA937226_S_NODE_14325_length_212_cov_1.595092_g14198_i0	PRJNA937226	14325	212	1.595092	3.38159504	Mycoplasma wenyonii	65123	Bacteria	Bacteria	370	4.53e-98	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g14198	i0	98.113	1	212	4	100	0	1	212	96638	96849	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	212	370	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
6015135	6015135	PRJNA937226_S_NODE_15245_length_207_cov_1.613924_g15118_i0	PRJNA937226	15245	207	1.613924	3.34082268	Mycoplasma wenyonii	65123	Bacteria	Bacteria	291	3.5299999999999993e-74	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g15118	i0	92.195	1.88405797101449	205	16	100	0	3	207	463529	463733	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	390	291	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
6015194	6015194	PRJNA937226_S_NODE_3625_length_342_cov_1.938567_g3498_i0	PRJNA937226	3625	342	1.938567	6.62989914	Mycoplasma wenyonii	65123	Bacteria	Bacteria	590	5.5399999999999984e-164	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g3498	i0	97.941	0.994152046783626	340	7	99	0	3	342	644077	644416	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	340	590	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
9839879	9839879	PRJNA937226_S_NODE_17688_length_195_cov_2.712329_g17561_i0	PRJNA937226	17688	195	2.712329	5.28904155	Mycoplasma wenyonii	65123	Bacteria	Bacteria	169	1.6e-37	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g17561	i0	83.077	1	195	24	100	5	1	195	522556	522741	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	195	169	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
9839899	9839899	PRJNA937226_S_NODE_22748_length_176_cov_1.637795_g22621_i0	PRJNA937226	22748	176	1.637795	2.8825192	Mycoplasma wenyonii	65123	Bacteria	Bacteria	281	1.74e-71	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g22621	i0	95.455	1	176	8	100	0	1	176	557305	557130	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	176	281	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
9839951	9839951	PRJNA937226_S_NODE_8988_length_252_cov_2.305419_g8861_i0	PRJNA937226	8988	252	2.305419	5.80965588	Mycoplasma wenyonii	65123	Bacteria	Bacteria	433	6.98e-117	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g8861	i0	97.619	1	252	6	100	0	1	252	508210	507959	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	252	433	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
10184439	10184439	PRJNA937226_S_NODE_13428_length_217_cov_3.315476_g13301_i0	PRJNA937226	13428	217	3.315476	7.19458292	Mycoplasma	2093	Bacteria	Bacteria	401	1.6499999999999994e-107	NTclustered	gi\|2789032764\|gb\|PQ202032.1\|	2108	g13301	i0	100	99.963133640553	217	0	100	0	1	217	252	36	Mycoplasma sp. isolate Ll 10 16S ribosomal RNA gene, partial sequence	blastn	21692	401	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma sp.
11115497	11115497	PRJNA937226_S_NODE_11349_length_232_cov_2.601093_g11222_i0	PRJNA937226	11349	232	2.601093	6.03453576	Mycoplasma wenyonii	65123	Bacteria	Bacteria	407	3.84e-109	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g11222	i0	98.276	1	232	4	100	0	1	232	185151	184920	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	232	407	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
11115501	11115501	PRJNA937226_S_NODE_12049_length_227_cov_1.168539_g11922_i0	PRJNA937226	12049	227	1.168539	2.65258353	Mycoplasma wenyonii	65123	Bacteria	Bacteria	392	1.0499999999999997e-104	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g11922	i0	97.797	1	227	5	100	0	1	227	204274	204500	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	227	392	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
11115539	11115539	PRJNA937226_S_NODE_21229_length_181_cov_1.946970_g21102_i0	PRJNA937226	21229	181	1.94697	3.5240157	Mycoplasma wenyonii	65123	Bacteria	Bacteria	235	1.42e-57	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g21102	i0	90.055	3.60220994475138	181	18	100	0	1	181	644778	644958	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	652	235	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
11115553	11115553	PRJNA937226_S_NODE_25629_length_168_cov_1.310924_g25502_i0	PRJNA937226	25629	168	1.310924	2.20235232	Mycoplasma wenyonii	65123	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g25502	i0	100	1	168	0	100	0	1	168	373658	373825	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	168	311	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
11115595	11115595	PRJNA937226_S_NODE_7429_length_269_cov_3.377273_g7302_i0	PRJNA937226	7429	269	3.377273	9.08486437	Mycoplasma wenyonii	65123	Bacteria	Bacteria	451	2.08e-122	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g7302	i0	97.026	1	269	7	100	1	1	269	147474	147207	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	269	451	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
12391029	12391029	PRJNA937226_S_NODE_16970_length_198_cov_4.322148_g16843_i0	PRJNA937226	16970	198	4.322148	8.55785304	Mycoplasma wenyonii	65123	Bacteria	Bacteria	333	5.469999999999998e-87	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g16843	i0	96.97	1	198	6	100	0	1	198	541998	541801	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	198	333	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
13665552	13665552	PRJNA937226_S_NODE_9971_length_243_cov_3.335052_g9844_i0	PRJNA937226	9971	243	3.335052	8.10417636	Mycoplasma wenyonii	65123	Bacteria	Bacteria	438	1.4399999999999996e-118	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g9844	i0	99.177	1.53497942386831	243	2	100	0	1	243	333739	333497	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	373	438	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
16214859	16214859	PRJNA937226_S_NODE_12313_length_225_cov_1.698864_g12186_i0	PRJNA937226	12313	225	1.698864	3.822444	Mycoplasma wenyonii	65123	Bacteria	Bacteria	150	6.899999999999999e-32	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g12186	i0	79.018	0.995555555555556	224	43	99	4	4	225	157479	157258	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	224	150	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
16214881	16214881	PRJNA937226_S_NODE_15413_length_206_cov_2.318471_g15286_i0	PRJNA937226	15413	206	2.318471	4.77605026	Mycoplasma wenyonii	65123	Bacteria	Bacteria	370	4.38e-98	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g15286	i0	99.029	1	206	2	100	0	1	206	561026	561231	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	206	370	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
16214890	16214890	PRJNA937226_S_NODE_16493_length_201_cov_1.026316_g16366_i0	PRJNA937226	16493	201	1.026316	2.06289516	Mycoplasma ovis	171632	Bacteria	Bacteria	217	5.86e-52	NTclustered	gi\|566058721\|gb\|CP006935.1\|	1415773	g16366	i0	86.07	1	201	28	100	0	1	201	21097	21297	Mycoplasma ovis str. Michigan, complete genome	blastn	201	217	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma ovis
16214959	16214959	PRJNA937226_S_NODE_9953_length_243_cov_5.262887_g9826_i0	PRJNA937226	9953	243	5.262887	12.78881541	Mycoplasma wenyonii	65123	Bacteria	Bacteria	427	3.11e-115	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g9826	i0	98.354	1	243	4	100	0	1	243	386739	386497	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	243	427	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
18763552	18763552	PRJNA937226_S_NODE_11215_length_233_cov_2.728261_g11088_i0	PRJNA937226	11215	233	2.728261	6.35684813	Mycoplasma wenyonii	65123	Bacteria	Bacteria	239	1.49e-58	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g11088	i0	86.222	0.965665236051502	225	25	95	4	12	233	247932	247711	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	225	239	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
18763553	18763553	PRJNA937226_S_NODE_11375_length_232_cov_1.420765_g11248_i0	PRJNA937226	11375	232	1.420765	3.2961748	Mycoplasma ovis	171632	Bacteria	Bacteria	224	4.149999999999999e-54	NTclustered	gi\|566058721\|gb\|CP006935.1\|	1415773	g11248	i0	84.052	1	232	37	100	0	1	232	425632	425401	Mycoplasma ovis str. Michigan, complete genome	blastn	232	224	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma ovis
18763579	18763579	PRJNA937226_S_NODE_16435_length_201_cov_2.052632_g16308_i0	PRJNA937226	16435	201	2.052632	4.12579032	Mycoplasma wenyonii	65123	Bacteria	Bacteria	339	1.1999999999999998e-88	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g16308	i0	97.015	1	201	6	100	0	1	201	311983	312183	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	201	339	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
18763646	18763646	PRJNA937226_S_NODE_7755_length_265_cov_3.018519_g7628_i0	PRJNA937226	7755	265	3.018519	7.99907535	Mycoplasma wenyonii	65123	Bacteria	Bacteria	329	9.99e-86	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g7628	i0	89.057	1	265	29	100	0	1	265	53558	53294	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	265	329	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
21313943	21313943	PRJNA937226_S_NODE_18837_length_190_cov_2.468085_g18710_i0	PRJNA937226	18837	190	2.468085	4.6893615	Mycoplasma wenyonii	65123	Bacteria	Bacteria	318	1.46e-82	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g18710	i0	96.842	1	190	6	100	0	1	190	325529	325718	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	190	318	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
21313998	21313998	PRJNA937226_S_NODE_7597_length_267_cov_1.908257_g7470_i0	PRJNA937226	7597	267	1.908257	5.09504619	Mycoplasma wenyonii	65123	Bacteria	Bacteria	287	6.15e-73	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g7470	i0	86.142	1.98876404494382	267	36	100	1	1	267	604196	604461	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	531	287	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
22588884	22588884	PRJNA937226_S_NODE_13158_length_219_cov_2.141176_g13031_i0	PRJNA937226	13158	219	2.141176	4.68917544	Mycoplasma wenyonii	65123	Bacteria	Bacteria	377	2.81e-100	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g13031	i0	97.717	1.73059360730594	219	5	100	0	1	219	549064	548846	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	379	377	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
23864175	23864175	PRJNA937226_S_NODE_15159_length_207_cov_4.632911_g15032_i0	PRJNA937226	15159	207	4.632911	9.59012577	Mycoplasma wenyonii	65123	Bacteria	Bacteria	372	1.2199999999999997e-98	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g15032	i0	99.034	1	207	2	100	0	1	207	390686	390892	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	207	372	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
24207342	24207342	PRJNA937226_S_NODE_12019_length_227_cov_2.213483_g11892_i0	PRJNA937226	12019	227	2.213483	5.02460641	Mycoplasma	2093	Bacteria	Bacteria	335	1.7899999999999995e-87	NTclustered	gi\|334192594\|gb\|CP002808.1\|	859194	g11892	i0	97.449	81.0925110132159	196	5	86	0	1	196	113491	113296	Mycoplasma haemofelis Ohio2, complete genome	blastn	18408	335	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma haemofelis
25138082	25138082	PRJNA937226_S_NODE_27980_length_163_cov_0.912281_g27853_i0	PRJNA937226	27980	163	0.912281	1.48701803	Mycoplasma wenyonii	65123	Bacteria	Bacteria	291	2.64e-74	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g27853	i0	98.773	1	163	2	100	0	1	163	486418	486580	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	163	291	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);;