metadata: contig_metadata: 5 rows where bioproject = "PRJNA1041773", tax_kingdom = "Bacillati" and tax

5 rows where bioproject = "PRJNA1041773", 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
1008621	1008621	PRJNA1041773_P_NODE_72461_length_258_cov_1.654054_g72128_i0	PRJNA1041773	72461	258	1.654054	4.26745932	Mesomycoplasma	2923352	Bacteria	Bacteria	425	1.2e-114	NTclustered	gi\|1720621726\|gb\|CP035041.1\|	2100	g72128	i0	98.347	14.0697674418605	242	4	94	0	1	242	606576	606817	Mesomycoplasma hyorhinis strain JF5820 chromosome, complete genome	blastn	3630	425	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
4836755	4836755	PRJNA1041773_P_NODE_85104_length_248_cov_0.880000_g84771_i0	PRJNA1041773	85104	248	0.88	2.1824	Spiroplasma	2132	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2719904879\|emb\|OZ034992.1\|	3066293	g84771	i0	96.97	0.665322580645161	33	0	13	1	184	216	396854	396885	Spiroplasma endosymbiont of Villa modesta isolate 54763 genome assembly, chromosome: 1	blastn	165	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Villa modesta
10373285	10373285	PRJNA1041773_P_NODE_25709_length_410_cov_2.228487_g25378_i0	PRJNA1041773	25709	410	2.228487	9.1367967	Spiroplasma endosymbiont of Antitype chi	3066308	Bacteria	Bacteria	52.8	0.039	NTclustered	gi\|2706542423\|emb\|OZ026467.1\|	3066308	g25378	i0	96.875	0.0780487804878049	32	0	8	1	347	378	1586741	1586771	Spiroplasma endosymbiont of Antitype chi isolate 54779 genome assembly, chromosome: 1	blastn	32	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Antitype chi
19296757	19296757	PRJNA1041773_P_NODE_86156_length_247_cov_1.327586_g85823_i0	PRJNA1041773	86156	247	1.327586	3.27913742	Mycoplasma nasistruthionis	353852	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1680402357\|gb\|CP040825.1\|	353852	g85823	i0	96.97	0.133603238866397	33	0	13	1	194	225	776113	776081	Mycoplasma nasistruthionis strain 2F1A chromosome, complete genome	blastn	33	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma nasistruthionis
23123332	23123332	PRJNA1041773_P_NODE_94599_length_244_cov_0.900585_g94266_i0	PRJNA1041773	94599	244	0.900585	2.1974274	Candidatus Hepatoplasma scabrum	3132033	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2416257524\|dbj\|AP027133.1\|	3132033	g94266	i0	96.875	0.131147540983607	32	1	13	0	36	67	178695	178664	MAG: Candidatus Hepatoplasma scabrum Ps-JP DNA, complete genome	blastn	32	54.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Candidatus Hepatoplasmataceae	Candidatus Hepatoplasma	Candidatus Hepatoplasma scabrum

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