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

9 rows where bioproject = "PRJNA908278", 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
14918426	14918426	PRJNA908278_P_NODE_5652_length_492_cov_1.224344_g5549_i0	PRJNA908278	5652	492	1.224344	6.02377248	Metamycoplasma hominis	2098	Bacteria	Bacteria	52.8	0.048	NTclustered	gi\|1495885541\|gb\|CP033021.1\|	2098	g5549	i0	100	0.0569105691056911	28	0	6	0	109	136	744265	744238	Metamycoplasma hominis strain TO0613 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma hominis
20016703	20016703	PRJNA908278_P_NODE_11156_length_366_cov_2.180887_g11053_i0	PRJNA908278	11156	366	2.180887	7.98204642	Mycoplasma nasistruthionis	353852	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|1694400991\|gb\|CP041147.1\|	353852	g11053	i0	100	0.0792349726775956	29	0	8	0	165	193	437666	437694	Mycoplasma nasistruthionis strain Ms03 chromosome	blastn	29	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma nasistruthionis
24200604	24200604	PRJNA908278_P_NODE_22099_length_276_cov_1.369458_g21996_i0	PRJNA908278	22099	276	1.369458	3.77970408	Bacillati	1783272	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2717001287\|gb\|CP146011.1\|	29562	g21996	i0	100	0.507246376811594	28	0	10	0	131	158	115384	115411	Mesomycoplasma ovipneumoniae strain OCAWY_21255 chromosome, complete genome	blastn	140	52.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma ovipneumoniae
26707511	26707511	PRJNA908278_P_NODE_17421_length_305_cov_1.991379_g17318_i0	PRJNA908278	17421	305	1.991379	6.07370595	Candidatus Moeniiplasma glomeromycotorum	1822367	Bacteria	Bacteria	73.2	1.66e-13	NR	MCE8162780.1	1822367	g17318	i0	49.2	0.580327868852459	59	29	57	1	226	53	82	140	MCE8162780.1 hypothetical protein [Candidatus Moeniiplasma glomeromycotorum]	diamond	177	73.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Candidatus Moeniiplasma	Candidatus Moeniiplasma glomeromycotorum
27593265	27593265	PRJNA908278_P_NODE_15464_length_321_cov_1.241935_g15361_i0	PRJNA908278	15464	321	1.241935	3.98661135	Spiroplasma endosymbiont of Anurida maritima	2967972	Bacteria	Bacteria	42	0.0332	NR	WP_381415077.1	2967972	g15361	i0	27.7	0.607476635514019	65	39	53.3	2	139	309	8	72	WP_381415077.1 HNH endonuclease [Spiroplasma endosymbiont of Anurida maritima]	diamond	195	42	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Anurida maritima
29431606	29431606	PRJNA908278_P_NODE_19989_length_288_cov_0.976744_g19886_i0	PRJNA908278	19989	288	0.976744	2.81302272	Bacteria	2	Bacteria	Bacteria	45.8	0.0048	NR	WP_012498435.1	2111	g19886	i0	46.8	2.625	62	30	61.5	1	275	99	13	74	WP_012498435.1 serine/threonine-protein kinase [Metamycoplasma arthritidis]	diamond	756	45.8	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma arthritidis
32395605	32395605	PRJNA908278_P_NODE_10659_length_373_cov_1.026667_g10556_i0	PRJNA908278	10659	373	1.026667	3.82946791	Acholeplasmatales bacterium	2053494	Bacteria	Bacteria	135	2.62e-34	NR	MBR4496047.1	2053494	g10556	i0	55.2	0.932975871313673	116	52	93.3	0	373	26	497	612	MBR4496047.1 AAA family ATPase [Acholeplasmatales bacterium]	diamond	348	135	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales			Acholeplasmatales bacterium
32522418	32522418	PRJNA908278_P_NODE_9179_length_396_cov_1.328173_g9076_i0	PRJNA908278	9179	396	1.328173	5.25956508	Acholeplasmatales bacterium	2053494	Bacteria	Bacteria	62.8	1.91e-8	NR	MBR4496240.1	2053494	g9076	i0	58.3	1.53787878787879	48	20	36.4	0	396	253	199	246	MBR4496240.1 hypothetical protein [Acholeplasmatales bacterium]	diamond	609	62.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales			Acholeplasmatales bacterium
32805633	32805633	PRJNA908278_P_NODE_19980_length_288_cov_1.074419_g19877_i0	PRJNA908278	19980	288	1.074419	3.09432672	Acholeplasmatales bacterium	2053494	Bacteria	Bacteria	101	3.179999999999999e-23	NR	MBR4496985.1	2053494	g19877	i0	52.1	1	96	46	100	0	288	1	227	322	MBR4496985.1 annexin [Acholeplasmatales bacterium]	diamond	288	101	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales			Acholeplasmatales bacterium

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