metadata: contig_metadata: 7 rows where bioproject = "PRJNA437204" and tax

7 rows where bioproject = "PRJNA437204" 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
2365750	2365750	PRJNA437204_P_NODE_96062_length_248_cov_0.880000_g95763_i0	PRJNA437204	96062	248	0.88	2.1824	Mesomycoplasma	2923352	Bacteria	Bacteria	453	5.2600000000000005e-123	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g95763	i0	99.597	15.8104838709677	248	1	100	0	1	248	759472	759225	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	3921	453	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
4918188	4918188	PRJNA437204_P_NODE_63804_length_275_cov_0.866337_g63505_i0	PRJNA437204	63804	275	0.866337	2.38242675	Spiroplasma	2132	Bacteria	Bacteria	176	1.44e-39	NTclustered	gi\|526641988\|ref\|NR_103985.1\|	216933	g63505	i0	79.137	170.752727272727	278	41	99	14	5	275	586	853	Spiroplasma chrysopicola strain DF-1 23S ribosomal RNA gene, complete sequence	blastn	46957	176	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma chrysopicola
5537144	5537144	PRJNA437204_P_NODE_85705_length_250_cov_0.870056_g85406_i0	PRJNA437204	85705	250	0.870056	2.17514	uncultured Mycoplasma sp.	167967	Bacteria	Bacteria	154	6.03e-33	NTclustered	gi\|2634042117\|gb\|OR946440.1\|	167967	g85406	i0	83.529	22.628	170	23	67	4	35	201	439	606	Uncultured Mycoplasma sp. clone THMon20-211 23S ribosomal RNA gene, partial sequence	blastn	5657	154	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	uncultured Mycoplasma sp.
14461576	14461576	PRJNA437204_P_NODE_53312_length_293_cov_1.750000_g53013_i0	PRJNA437204	53312	293	1.75	5.1275	Bacteria	2	Bacteria	Bacteria	78.2	9.22e-15	NR	WP_025208751.1	295596	g53013	i0	59.1	4.79180887372014	66	23	67.6	1	206	9	8	69	WP_025208751.1 DnaJ C-terminal domain-containing protein [Candidatus Hepatoplasma crinochetorum]	diamond	1404	78.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Candidatus Hepatoplasmataceae	Candidatus Hepatoplasma	Candidatus Hepatoplasma crinochetorum
21491073	21491073	PRJNA437204_P_NODE_107917_length_245_cov_0.895349_g107618_i0	PRJNA437204	107917	245	0.895349	2.19360505	Mesomycoplasma	2923352	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g107618	i0	100	16.530612244898	245	0	100	0	1	245	751824	752068	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	4050	453	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
24659771	24659771	PRJNA437204_P_NODE_88780_length_249_cov_0.875000_g88481_i0	PRJNA437204	88780	249	0.875	2.17875	Mollicutes bacterium	37628	Bacteria	Bacteria	52.8	0.023	NTclustered	gi\|2508193988\|gb\|CP125803.1\|	37628	g88481	i0	96.875	0.1285140562249	32	0	12	1	93	123	237778	237809	MAG: Mollicutes bacterium isolate 16661_lib_A chromosome	blastn	32	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes				Mollicutes bacterium
32856969	32856969	PRJNA437204_P_NODE_62320_length_277_cov_1.352941_g62021_i0	PRJNA437204	62320	277	1.352941	3.74764657	Mesoplasma photuris	217731	Bacteria	Bacteria	45.8	0.00441	NR	WP_031542597.1	217731	g62021	i0	51.1	0.509025270758123	47	21	50.9	1	32	172	121	165	WP_031542597.1 alpha/beta hydrolase family protein [Mesoplasma photuris]	diamond	141	45.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Entomoplasmataceae	Mesoplasma	Mesoplasma photuris

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