metadata: contig_metadata: 9 rows where bioproject = "PRJNA560932", tax_kingdom = "Bacillati" and tax

9 rows where bioproject = "PRJNA560932", tax_kingdom = "Bacillati" 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
8197660	8197660	PRJNA560932_P_NODE_44327_length_274_cov_3.064677_g43971_i0	PRJNA560932	44327	274	3.064677	8.39721498	Haploplasma axanthum	29552	Bacteria	Bacteria	176	1.43e-39	NTclustered	gi\|1563809587\|emb\|LR215048.1\|	29552	g43971	i0	79.435	76.2189781021898	248	51	91	0	26	273	986914	986667	Acholeplasma axanthum strain NCTC10138 genome assembly, chromosome: 1	blastn	20884	176	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Haploplasma	Haploplasma axanthum
15847292	15847292	PRJNA560932_P_NODE_13793_length_471_cov_1.547739_g13438_i0	PRJNA560932	13793	471	1.547739	7.28985069	'Candidatus Bacilliplasma' mollicute	467748	Bacteria	Bacteria	220	1.19e-52	NTclustered	gi\|94482888\|gb\|DQ485976.1\|	467748	g13438	i0	85.514	49.4946921443737	214	27	45	2	4	213	975	762	'Candidatus Bacilloplasma' mollicute clone P10 16S ribosomal RNA gene, partial sequence	blastn	23312	220	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes			Candidatus Bacilliplasma	'Candidatus Bacilliplasma' mollicute
18396732	18396732	PRJNA560932_P_NODE_59915_length_246_cov_0.890173_g59559_i0	PRJNA560932	59915	246	0.890173	2.18982558	Candidatus Phytoplasma fraxini	35780	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2714275034\|gb\|CP146843.1\|	35780	g59559	i0	100	0.113821138211382	28	0	11	0	177	204	63709	63682	Candidatus Phytoplasma fraxini isolate AshY1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma fraxini
23497196	23497196	PRJNA560932_P_NODE_61219_length_245_cov_0.895349_g60863_i0	PRJNA560932	61219	245	0.895349	2.19360505	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	58.4	4.75e-4	NTclustered	gi\|2621784632\|emb\|OY781090.1\|	1898209	g60863	i0	97.059	0.138775510204082	34	1	14	0	33	66	1219320	1219353	MAG: Acholeplasmataceae bacterium isolate ac846720-52a4-4ed8-8e7a-77cd78ec885f genome assembly, chromosome: 1	blastn	34	58.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
26635770	26635770	PRJNA560932_P_NODE_35021_length_307_cov_1.307692_g34665_i0	PRJNA560932	35021	307	1.307692	4.01461444	Candidatus Izemoplasmatales bacterium	3018265	Bacteria	Bacteria	44.3	0.0233	NR	MDY0138956.1	3018265	g34665	i0	33	1.00651465798046	103	60	94.8	3	295	5	502	601	MDY0138956.1 hypothetical protein [Candidatus Izemoplasmatales bacterium]	diamond	309	44.3	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales			Candidatus Izemoplasmatales bacterium
29384372	29384372	PRJNA560932_P_NODE_45309_length_271_cov_2.308081_g44953_i0	PRJNA560932	45309	271	2.308081	6.25489951	Candidatus Izemoplasmatales bacterium	3018265	Bacteria	Bacteria	70.1	4.88e-13	NR	MDD3957950.1	3018265	g44953	i0	41.4	0.96309963099631	87	51	96.3	0	10	270	21	107	MDD3957950.1 glycine cleavage system protein GcvH [Candidatus Izemoplasmatales bacterium]	diamond	261	70.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales			Candidatus Izemoplasmatales bacterium
29682072	29682072	PRJNA560932_P_NODE_36390_length_301_cov_1.701754_g36034_i0	PRJNA560932	36390	301	1.701754	5.12227954	root	1	Root_unresolved	Root_unresolved	44.3	0.02	NR	WP_381415428.1	2967972	g36034	i0	32.6	1.56478405315615	86	40	85.7	3	268	11	69	136	WP_381415428.1 DNA polymerase III subunit beta [Spiroplasma endosymbiont of Anurida maritima]	diamond	471	44.3	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Anurida maritima
31483702	31483702	PRJNA560932_P_NODE_35616_length_304_cov_3.043290_g35260_i0	PRJNA560932	35616	304	3.04329	9.2516016	root	1	Root_unresolved	Root_unresolved	48.5	6.07e-4	NR	MDR1670374.1	2872178	g35260	i0	34.9	1.07565789473684	63	39	60.2	1	202	20	2	64	MDR1670374.1 DnaJ domain-containing protein [Spiroplasmataceae bacterium]	diamond	327	48.9	0.991820040899796	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae		Spiroplasmataceae bacterium
32639475	32639475	PRJNA560932_P_NODE_65200_length_242_cov_0.911243_g64844_i0	PRJNA560932	65200	242	0.911243	2.20520806	Liberiplasma polymorphum	3374570	Bacteria	Bacteria	48.5	3.26e-4	NR	MFH5881724.1	3374570	g64844	i0	44.4	0.669421487603306	54	30	66.9	0	224	63	81	134	MFH5881724.1 RCC1 domain-containing protein [Candidatus Izemoplasmataceae bacterium C05PYG]	diamond	162	48.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Liberiplasmatales	Liberiplasmataceae	Liberiplasma	Liberiplasma polymorphum

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