metadata: contig_metadata: 11 rows where bioproject = "PRJNA1164198" and tax

11 rows where bioproject = "PRJNA1164198" 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
2314770	2314770	PRJNA1164198_P_NODE_1622_length_959_cov_5.329571_g1453_i0	PRJNA1164198	1622	959	5.329571	51.11058589	Ureaplasma	2129	Bacteria	Bacteria	1260	0	NTclustered	gi\|2177595200\|gb\|CP086123.1\|	2130	g1453	i0	90.501	147.914494264859	958	85	99	6	1	954	343718	344673	Ureaplasma urealyticum strain MIN-201 chromosome, complete genome	blastn	141850	1260	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma urealyticum
2862885	2862885	PRJNA1164198_P_NODE_9023_length_414_cov_5.416422_g8758_i0	PRJNA1164198	9023	414	5.416422	22.42398708	uncultured Ureaplasma sp.	293430	Bacteria	Bacteria	675	0	NTclustered	gi\|1899225129\|gb\|MT967601.1\|	293430	g8758	i0	96.135	106.070048309179	414	15	100	1	1	414	1457	1045	Uncultured Ureaplasma sp. clone asv_100_2225 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	43913	675	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	uncultured Ureaplasma sp.
4867544	4867544	PRJNA1164198_P_NODE_16904_length_300_cov_2.625551_g16635_i0	PRJNA1164198	16904	300	2.625551	7.876653	Mycoplasmoidaceae	2790998	Bacteria	Bacteria	490	4.99e-134	NTclustered	gi\|119369652\|gb\|EF061769.1\|	2097	g16635	i0	96.333	107.613333333333	300	8	99	2	1	298	24	322	Mycoplasma genitalium strain ATCC 33530 23S ribosomal RNA gene, partial sequence	blastn	32284	490	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Mycoplasmoides	Mycoplasmoides genitalium
6142339	6142339	PRJNA1164198_P_NODE_15505_length_314_cov_2.070539_g15236_i0	PRJNA1164198	15505	314	2.070539	6.50149246	Malacoplasma	2791001	Bacteria	Bacteria	512	1.12e-140	NTclustered	gi\|470476279\|ref\|NR_076329.1\|	28227	g15236	i0	96.178	135.496815286624	314	11	100	1	1	314	1774	2086	Mycoplasma penetrans strain HF-2 23S ribosomal RNA gene, complete sequence	blastn	42546	512	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma penetrans
13065558	13065558	PRJNA1164198_P_NODE_23591_length_255_cov_2.032967_g23322_i0	PRJNA1164198	23591	255	2.032967	5.18406585	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	217	7.76e-52	NTclustered	gi\|2187163482\|emb\|OV788640.1\|	658143	g23322	i0	82.283	402.243137254902	254	42	99	3	1	253	373743	373492	uncultured Tenericutes bacterium isolate min17_bin11 genome assembly, chromosome: 1	blastn	102572	217	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
15614733	15614733	PRJNA1164198_P_NODE_11393_length_368_cov_2.281356_g11125_i0	PRJNA1164198	11393	368	2.281356	8.39539008	uncultured Mycoplasma sp.	167967	Bacteria	Bacteria	616	9.88e-172	NTclustered	gi\|1328205649\|gb\|MG786619.1\|	167967	g11125	i0	100	100.942934782609	333	0	90	0	36	368	1	333	Uncultured Mycoplasma sp. clone 1 16S ribosomal RNA gene, partial sequence	blastn	37147	616	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	uncultured Mycoplasma sp.
16889126	16889126	PRJNA1164198_P_NODE_5294_length_547_cov_5.873418_g5041_i0	PRJNA1164198	5294	547	5.873418	32.12759646	uncultured Ureaplasma sp.	293430	Bacteria	Bacteria	689	0	NTclustered	gi\|1899225129\|gb\|MT967601.1\|	293430	g5041	i0	93.39	112.899451553931	469	25	85	5	83	547	2225	1759	Uncultured Ureaplasma sp. clone asv_100_2225 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	61756	689	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	uncultured Ureaplasma sp.
20165832	20165832	PRJNA1164198_P_NODE_11096_length_373_cov_2.286667_g10828_i0	PRJNA1164198	11096	373	2.286667	8.52926791	Malacoplasma	2791001	Bacteria	Bacteria	529	1.3399999999999997e-145	NTclustered	gi\|470476279\|ref\|NR_076329.1\|	28227	g10828	i0	92.267	117.983914209115	375	25	100	4	1	373	138	510	Mycoplasma penetrans strain HF-2 23S ribosomal RNA gene, complete sequence	blastn	44008	529	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma penetrans
20165866	20165866	PRJNA1164198_P_NODE_3236_length_701_cov_4.184713_g3002_i0	PRJNA1164198	3236	701	4.184713	29.33483813	Ureaplasma	2129	Bacteria	Bacteria	1068	0	NTclustered	gi\|1699403359\|gb\|CP041200.1\|	2130	g3002	i0	94.388	150.895863052782	695	39	99	0	2	696	151485	152179	Ureaplasma urealyticum strain 132 chromosome, complete genome	blastn	105778	1068	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma urealyticum
25265802	25265802	PRJNA1164198_P_NODE_2680_length_761_cov_3.465116_g2467_i0	PRJNA1164198	2680	761	3.465116	26.36953276	Malacoplasma	2791001	Bacteria	Bacteria	1081	0	NTclustered	gi\|470476279\|ref\|NR_076329.1\|	28227	g2467	i0	92.563	146.065703022339	753	56	99	0	9	761	2779	2027	Mycoplasma penetrans strain HF-2 23S ribosomal RNA gene, complete sequence	blastn	111156	1081	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma penetrans
31051779	31051779	PRJNA1164198_P_NODE_26595_length_249_cov_0.886364_g26326_i0	PRJNA1164198	26595	249	0.886364	2.20704636	Candidatus Ureaplasma intestinipullorum	2838770	Bacteria	Bacteria	73.6	3.18e-13	NR	MBU3830819.1	2838770	g26326	i0	68.5	0.650602409638554	54	17	65.1	0	162	1	1	54	MBU3830819.1 ECF transporter S component [Candidatus Ureaplasma intestinipullorum]	diamond	162	73.6	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Candidatus Ureaplasma intestinipullorum

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