metadata: contig_metadata: 10 rows where bioproject = "PRJNA1011844", tax_kingdom = "Bacillati" and tax

10 rows where bioproject = "PRJNA1011844", 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
9083504	9083504	PRJNA1011844_P_NODE_127548_length_273_cov_1.265000_g118970_i0	PRJNA1011844	127548	273	1.265	3.45345	Candidatus Hepatoplasma vulgare	3132032	Bacteria	Bacteria	82.4	3.2e-11	NTclustered	gi\|2416256354\|dbj\|AP027131.1\|	3132032	g118970	i0	84.706	3.25641025641026	85	10	30	3	8	90	478388	478471	MAG: Candidatus Hepatoplasma vulgare Av-JP DNA, complete genome	blastn	889	82.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Candidatus Hepatoplasmataceae	Candidatus Hepatoplasma	Candidatus Hepatoplasma vulgare
9084066	9084066	PRJNA1011844_P_NODE_171648_length_226_cov_3.307190_g163067_i0	PRJNA1011844	171648	226	3.30719	7.4742494	Anaeroplasmataceae bacterium	2793037	Bacteria	Bacteria	92.4	2.73e-20	NR	MDE5868351.1	2793037	g163067	i0	58.3	3.71681415929204	72	29	95.6	1	11	226	58	128	MDE5868351.1 asparaginase [Anaeroplasmataceae bacterium]	diamond	840	92.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Anaeroplasmatales	Anaeroplasmataceae		Anaeroplasmataceae bacterium
21834609	21834609	PRJNA1011844_P_NODE_82418_length_389_cov_2.829114_g73880_i0	PRJNA1011844	82418	389	2.829114	11.00525346	Mesomycoplasma ovipneumoniae	29562	Bacteria	Bacteria	52.8	0.037	NTclustered	gi\|2582036355\|gb\|CP134941.1\|	29562	g73880	i0	100	0.0719794344473008	28	0	7	0	273	300	683130	683103	Mesomycoplasma ovipneumoniae strain MoG225L22A chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma ovipneumoniae
28834809	28834809	PRJNA1011844_P_NODE_141668_length_255_cov_3.318681_g133090_i0	PRJNA1011844	141668	255	3.318681	8.46263655	Candidatus Izimaplasma bacterium	N/A	Bacteria	Bacteria	57	3.84e-7	NR	MDC0558788.1	2315156	g133090	i0	42.1	2.2	76	34	77.6	1	214	17	233	308	MDC0558788.1 beta-lactamase family protein [Candidatus Izimaplasma bacterium]	diamond	561	57	1	Bacteria	Bacillati	Mycoplasmatota	Candidatus Izimaplasma				Candidatus Izimaplasma bacterium
28993005	28993005	PRJNA1011844_P_NODE_111568_length_299_cov_1.929204_g102992_i0	PRJNA1011844	111568	299	1.929204	5.76831996	Acholeplasma laidlawii	2148	Bacteria	Bacteria	73.9	8.27e-13	NR	WIF89110.1	2148	g102992	i0	43.2	0.953177257525084	95	53	94.3	1	16	297	1641	1735	WIF89110.1 InlB B-repeat-containing protein [Acholeplasma laidlawii]	diamond	285	73.9	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Acholeplasma	Acholeplasma laidlawii
29845314	29845314	PRJNA1011844_P_NODE_98931_length_330_cov_2.607004_g90365_i0	PRJNA1011844	98931	330	2.607004	8.6031132	Spiroplasma endosymbiont of Othius punctulatus	3066289	Bacteria	Bacteria	43.9	0.0391	NR	WP_338982805.1	3066289	g90365	i0	30.4	0.836363636363636	92	51	78.2	2	266	9	546	630	WP_338982805.1 ATP-dependent DNA helicase [Spiroplasma endosymbiont of Othius punctulatus]	diamond	276	43.9	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Othius punctulatus
30856257	30856257	PRJNA1011844_P_NODE_52774_length_595_cov_5.086207_g44471_i0	PRJNA1011844	52774	595	5.086207	30.26293165	Mollicutes bacterium	37628	Bacteria	Bacteria	47	0.0285	NR	MCI7058655.1	37628	g44471	i0	35.6	0.453781512605042	90	54	44.4	2	185	448	290	377	MCI7058655.1 endopeptidase La [Mollicutes bacterium]	diamond	270	47	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes				Mollicutes bacterium
31014139	31014139	PRJNA1011844_P_NODE_108535_length_306_cov_2.510730_g99962_i0	PRJNA1011844	108535	306	2.51073	7.6828338	endosymbiont GvMRE of Glomus versiforme	2039283	Bacteria	Bacteria	58.9	7.7e-8	NR	WP_147411026.1	2039283	g99962	i0	35.8	0.931372549019608	95	52	85.3	3	41	301	13	106	WP_147411026.1 DUF6940 family protein [endosymbiont GvMRE of Glomus versiforme]	diamond	285	58.9	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont GvMRE of Glomus versiforme
31077564	31077564	PRJNA1011844_P_NODE_23455_length_1137_cov_5.414474_g17765_i0	PRJNA1011844	23455	1137	5.414474	61.56256938	Malacoplasma sp.	2791014	Bacteria	Bacteria	49.3	0.0245	NR	MCF0227810.1	2791014	g17765	i0	23	0.823218997361478	183	131	46.7	6	195	725	244	422	MCF0227810.1 hypothetical protein [Malacoplasma sp.]	diamond	936	49.3	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma sp.
32311278	32311278	PRJNA1011844_P_NODE_136839_length_261_cov_1.723404_g128261_i0	PRJNA1011844	136839	261	1.723404	4.49808444	Candidatus Phytoplasma meliae	1848402	Bacteria	Bacteria	42.7	0.0453	NR	WP_203551913.1	1848402	g128261	i0	33.3	0.793103448275862	69	43	75.9	2	199	2	119	187	WP_203551913.1 AAA family ATPase [Candidatus Phytoplasma meliae]	diamond	207	42.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma meliae

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