metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA560932" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA560932" 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
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);;