metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA981359" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA981359" 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
963363	963363	PRJNA981359_S_NODE_70301_length_245_cov_3.593023_g70201_i0	PRJNA981359	70301	245	3.593023	8.80290635	Mycoplasma wenyonii	65123	Bacteria	Bacteria	340	4.209999999999999e-89	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g70201	i0	93.103	5.49795918367347	232	16	95	0	14	245	644879	645110	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	1347	340	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
2237626	2237626	PRJNA981359_S_NODE_32662_length_320_cov_2.842105_g32562_i0	PRJNA981359	32662	320	2.842105	9.094736	Mesomycoplasma conjunctivae	45361	Bacteria	Bacteria	52.8	0.03	NTclustered	gi\|239984707\|emb\|FM864216.2\|	45361	g32562	i0	100	0.175	28	0	9	0	183	210	21023	20996	Mycoplasma conjunctivae HRC/581T complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma conjunctivae
3512590	3512590	PRJNA981359_S_NODE_22563_length_351_cov_1.384892_g22463_i0	PRJNA981359	22563	351	1.384892	4.86097092	Mycoplasma ovis	171632	Bacteria	Bacteria	409	1.7099999999999998e-109	NTclustered	gi\|566058721\|gb\|CP006935.1\|	1415773	g22463	i0	87.714	5.48717948717949	350	43	99	0	1	350	16146	16495	Mycoplasma ovis str. Michigan, complete genome	blastn	1926	409	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma ovis
3513229	3513229	PRJNA981359_S_NODE_46243_length_288_cov_3.655814_g46143_i0	PRJNA981359	46243	288	3.655814	10.52874432	Mycoplasma wenyonii	65123	Bacteria	Bacteria	307	5.15e-79	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g46143	i0	95.337	1.03125	193	9	67	0	9	201	315160	315352	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	297	307	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
3513475	3513475	PRJNA981359_S_NODE_54683_length_271_cov_2.363636_g54583_i0	PRJNA981359	54683	271	2.363636	6.40545356	Candidatus Phytoplasma solani	69896	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2741905208\|gb\|CP155828.1\|	69896	g54583	i0	100	0.107011070110701	29	0	11	0	99	127	556763	556791	Candidatus Phytoplasma solani strain GOE chromosome, complete genome	blastn	29	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma solani
3822752	3822752	PRJNA981359_S_NODE_20803_length_357_cov_2.739437_g20703_i0	PRJNA981359	20803	357	2.739437	9.77979009	root	1	Root_unresolved	Root_unresolved	52.8	0.034	NTclustered	gi\|1417668539\|gb\|CP030140.1\|	92400	g20703	i0	94.286	0.176470588235294	35	1	10	1	306	339	29901	29867	[Mycoplasma] anseris strain ATCC 49234 chromosome, complete genome	blastn	63	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	[Mycoplasma] anseris
9890112	9890112	PRJNA981359_S_NODE_23248_length_348_cov_3.025455_g23148_i0	PRJNA981359	23248	348	3.025455	10.5285834	Mycoplasma wenyonii	65123	Bacteria	Bacteria	257	6.51e-64	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g23148	i0	83.158	0.818965517241379	285	44	81	4	66	347	189171	189454	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	285	257	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
9890979	9890979	PRJNA981359_S_NODE_53068_length_274_cov_3.104478_g52968_i0	PRJNA981359	53068	274	3.104478	8.50626972	Mycoplasma wenyonii	65123	Bacteria	Bacteria	479	9.74e-131	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g52968	i0	98.175	1	274	5	100	0	1	274	99576	99303	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	274	479	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
10199469	10199469	PRJNA981359_S_NODE_65768_length_251_cov_1.803371_g65668_i0	PRJNA981359	65768	251	1.803371	4.52646121	Mycoplasma	2093	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2294785939\|gb\|CP103424.1\|	51364	g65668	i0	100	0.223107569721116	28	0	11	0	92	119	1016202	1016175	Mycoplasma cottewii strain VIS chromosome, complete genome	blastn	56	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma cottewii
11474546	11474546	PRJNA981359_S_NODE_50209_length_280_cov_2.212560_g50109_i0	PRJNA981359	50209	280	2.21256	6.195168	Spiroplasma	2132	Bacteria	Bacteria	54.7	0.007	NTclustered	gi\|2802839268\|emb\|OZ181653.1\|	3066280	g50109	i0	96.97	0.246428571428571	33	0	11	1	37	68	1003883	1003915	Spiroplasma endosymbiont of Rhagonycha fulva isolate 54749 genome assembly, chromosome: 1	blastn	69	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Rhagonycha fulva
13715885	13715885	PRJNA981359_S_NODE_29451_length_329_cov_1.914062_g29351_i0	PRJNA981359	29451	329	1.914062	6.29726398	Mycoplasma haemocanis	136241	Bacteria	Bacteria	198	3.76e-46	NTclustered	gi\|363988676\|gb\|CP003199.1\|	1111676	g29351	i0	77.976	3.00607902735562	336	60	100	11	1	329	186282	185954	Mycoplasma haemocanis str. Illinois, complete genome	blastn	989	198	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma haemocanis
13715932	13715932	PRJNA981359_S_NODE_31211_length_324_cov_2.474104_g31111_i0	PRJNA981359	31211	324	2.474104	8.01609696	Mycoplasma wenyonii	65123	Bacteria	Bacteria	416	9.37e-112	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g31111	i0	89.815	1	324	33	100	0	1	324	386797	386474	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	324	416	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
16265866	16265866	PRJNA981359_S_NODE_56413_length_268_cov_1.200000_g56313_i0	PRJNA981359	56413	268	1.2	3.216	Mycoplasma wenyonii	65123	Bacteria	Bacteria	141	5.09e-29	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g56313	i0	88.136	0.440298507462687	118	14	44	0	112	229	292329	292212	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	118	141	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
20088839	20088839	PRJNA981359_S_NODE_34096_length_316_cov_4.399177_g33996_i0	PRJNA981359	34096	316	4.399177	13.90139932	Mycoplasma wenyonii	65123	Bacteria	Bacteria	196	1.29e-45	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g33996	i0	80	0.870253164556962	275	48	86	6	42	314	520206	519937	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	275	196	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
22640264	22640264	PRJNA981359_S_NODE_64498_length_253_cov_0.866667_g64398_i0	PRJNA981359	64498	253	0.866667	2.19266751	Mycoplasma wenyonii	65123	Bacteria	Bacteria	446	9.01e-121	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g64398	i0	98.419	3.26877470355731	253	4	100	0	1	253	331170	330918	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	827	446	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
23914444	23914444	PRJNA981359_S_NODE_16939_length_374_cov_1.860465_g16839_i0	PRJNA981359	16939	374	1.860465	6.9581391	Mycoplasma wenyonii	65123	Bacteria	Bacteria	610	4.68e-170	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g16839	i0	96.477	0.986631016042781	369	13	99	0	6	374	397449	397081	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	369	610	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
23915463	23915463	PRJNA981359_S_NODE_51179_length_278_cov_2.282927_g51079_i0	PRJNA981359	51179	278	2.282927	6.34653706	Mycoplasma wenyonii	65123	Bacteria	Bacteria	381	2.869999999999999e-101	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g51079	i0	91.398	1.00359712230216	279	22	100	2	1	278	635332	635055	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	279	381	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
25187964	25187964	PRJNA981359_S_NODE_15360_length_382_cov_3.475728_g15260_i0	PRJNA981359	15360	382	3.475728	13.27728096	Mycoplasma wenyonii	65123	Bacteria	Bacteria	651	0	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g15260	i0	97.382	1	382	10	100	0	1	382	82638	83019	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	382	651	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);;