metadata: contig_metadata: 12 rows where bioproject = "PRJNA1010780" and tax

12 rows where bioproject = "PRJNA1010780" 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
19280691	19280691	PRJNA1010780_S_NODE_40456_length_205_cov_1.800000_g39167_i0	PRJNA1010780	40456	205	1.8	3.69	Mycoplasmopsis columbina	114881	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|1563806405\|emb\|LR215041.1\|	114881	g39167	i0	100	0.141463414634146	29	0	14	0	163	191	376985	377013	Mycoplasma columbinum strain NCTC10178 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis columbina
26995147	26995147	PRJNA1010780_S_NODE_63422_length_150_cov_1.582609_g62133_i0	PRJNA1010780	63422	150	1.582609	2.3739135	Bacillati	1783272	Bacteria	Bacteria	59.7	1.11e-8	NR	MDV3166825.1	126585	g62133	i0	50	3.96	50	23	100	1	1	150	458	505	MDV3166825.1 isoleucine--tRNA ligase [Candidatus Phytoplasma vignae]	diamond	594	60.1	0.993344425956739	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma vignae
27129019	27129019	PRJNA1010780_S_NODE_5362_length_1164_cov_6.218778_g4772_i1	PRJNA1010780	5362	1164	6.218778	72.38657592	endosymbiont GvMRE of Glomus versiforme	2039283	Bacteria	Bacteria	99	6.63e-19	NR	WP_147410055.1	2039283	g4772	i1	48.2	0.293814432989691	114	43	28.4	2	1096	767	1	102	WP_147410055.1 molecular chaperone DnaJ [endosymbiont GvMRE of Glomus versiforme]	diamond	342	99	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont GvMRE of Glomus versiforme
27414111	27414111	PRJNA1010780_S_NODE_28963_length_274_cov_1.983264_g27674_i0	PRJNA1010780	28963	274	1.983264	5.43414336	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	60.1	4.47e-8	NR	MDO9628657.1	1898209	g27674	i0	35.6	0.952554744525547	87	55	95.3	1	4	264	203	288	MDO9628657.1 InlB B-repeat-containing protein [Acholeplasmataceae bacterium]	diamond	261	60.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
27501226	27501226	PRJNA1010780_S_NODE_51943_length_170_cov_2.333333_g50654_i0	PRJNA1010780	51943	170	2.333333	3.9666661	root	1	Root_unresolved	Root_unresolved	41.2	0.0494	NR	WIF89111.1	2148	g50654	i0	41	3.75882352941176	39	23	68.8	0	53	169	190	228	WIF89111.1 InlB B-repeat-containing protein [Acholeplasma laidlawii]	diamond	639	41.6	0.990384615384615	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Acholeplasma	Acholeplasma laidlawii
29584610	29584610	PRJNA1010780_S_NODE_34110_length_236_cov_1.462687_g32821_i0	PRJNA1010780	34110	236	1.462687	3.45194132	Bacteria	2	Bacteria	Bacteria	47.4	7.78e-4	NR	NLF48464.1	1898209	g32821	i0	57.9	2.26271186440678	38	14	48.3	1	2	115	404	439	NLF48464.1 aldehyde dehydrogenase [Acholeplasmataceae bacterium]	diamond	534	47.4	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
30097737	30097737	PRJNA1010780_S_NODE_5292_length_1174_cov_6.220369_g4772_i0	PRJNA1010780	5292	1174	6.220369	73.02713206	endosymbiont GvMRE of Glomus versiforme	2039283	Bacteria	Bacteria	99	6.89e-19	NR	WP_147410055.1	2039283	g4772	i0	48.2	0.291311754684838	114	43	28.1	2	1106	777	1	102	WP_147410055.1 molecular chaperone DnaJ [endosymbiont GvMRE of Glomus versiforme]	diamond	342	99	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			endosymbiont GvMRE of Glomus versiforme
31077388	31077388	PRJNA1010780_S_NODE_23835_length_333_cov_2.184564_g22546_i0	PRJNA1010780	23835	333	2.184564	7.27459812	Candidatus Izemoplasmatales bacterium	3018265	Bacteria	Bacteria	72	5.68e-12	NR	MFA5037269.1	3018265	g22546	i0	34.8	4.03603603603604	112	71	99.1	1	332	3	502	613	MFA5037269.1 InlB B-repeat-containing protein [Candidatus Izemoplasmatales bacterium]	diamond	1344	72	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales			Candidatus Izemoplasmatales bacterium
31614855	31614855	PRJNA1010780_S_NODE_5296_length_1173_cov_9.588752_g4776_i0	PRJNA1010780	5296	1173	9.588752	112.47606096	Tenericutes bacterium HGW-Tenericutes-1	2013844	Bacteria	Bacteria	80.9	2.22e-12	NR	PKK99934.1	2013844	g4776	i0	33.7	0.416879795396419	163	85	36.1	7	772	350	210	371	PKK99934.1 MAG: hypothetical protein CVV56_08770 [Tenericutes bacterium HGW-Tenericutes-1]	diamond	489	80.9	1	Bacteria	Bacillati	Mycoplasmatota					Tenericutes bacterium HGW-Tenericutes-1
32437650	32437650	PRJNA1010780_S_NODE_24239_length_327_cov_2.647260_g22950_i0	PRJNA1010780	24239	327	2.64726	8.6565402	Mycoplasmatota bacterium	2231116	Bacteria	Bacteria	65.9	8.38e-10	NR	QVK16776.1	2231116	g22950	i0	38.2	5.55963302752294	102	53	84.4	3	7	282	548	649	QVK16776.1 DUF5011 domain-containing protein [Mycoplasmatota bacterium]	diamond	1818	65.9	1	Bacteria	Bacillati	Mycoplasmatota					Mycoplasmatota bacterium
32500912	32500912	PRJNA1010780_S_NODE_37479_length_218_cov_1.841530_g36190_i0	PRJNA1010780	37479	218	1.84153	4.0145354	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	48.1	3.36e-4	NR	NLZ61530.1	1898209	g36190	i0	39.2	1.96788990825688	74	40	97.7	2	5	217	503	574	NLZ61530.1 hypothetical protein [Acholeplasmataceae bacterium]	diamond	429	48.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
32878787	32878787	PRJNA1010780_S_NODE_37280_length_219_cov_1.918478_g35991_i0	PRJNA1010780	37280	219	1.918478	4.20146682	Candidatus Izimaplasma bacterium HR2	1541960	Bacteria	Bacteria	47	8.82e-4	NR	KFZ26634.1	1541960	g35991	i0	42	1.68493150684932	69	36	90.4	2	217	20	759	826	KFZ26634.1 MAG: Regulator of chromosome condensation (RCC1) repeat protein [Candidatus Izimaplasma bacterium HR2]	diamond	369	47	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales	Candidatus Izemoplasmataceae	Candidatus Izemoplasma	Candidatus Izimoplasma sp. HR2

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