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

9 rows where bioproject = "PRJNA429937", 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
425811	425811	PRJNA429937_P_NODE_126441_length_233_cov_2.049020_g103814_i0	PRJNA429937	126441	233	2.04902	4.7742166	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	183	7.089999999999998e-42	NTclustered	gi\|2261461934\|gb\|ON890823.1\|	2094	g103814	i0	99.02	65.6051502145923	102	1	72	0	1	102	282	181	Mycoplasmopsis arginini strain 11041 LH 16S ribosomal RNA gene, partial sequence	blastn	15286	183	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
1700549	1700549	PRJNA429937_P_NODE_114802_length_262_cov_1.669528_g92177_i0	PRJNA429937	114802	262	1.669528	4.37416336	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	276	1.2999999999999998e-69	NTclustered	gi\|761597645\|dbj\|AP014657.1\|	2094	g92177	i0	98.71	3.66412213740458	155	2	77	0	108	262	156911	156757	Mycoplasma arginini DNA, complete genome, strain: HAZ145_1	blastn	960	276	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
2977630	2977630	PRJNA429937_P_NODE_52843_length_485_cov_1.710526_g34826_i0	PRJNA429937	52843	485	1.710526	8.2960511	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	183	1.6099999999999996e-41	NTclustered	gi\|2261461934\|gb\|ON890823.1\|	2094	g34826	i0	99.02	69.7051546391753	102	1	77	0	200	301	282	181	Mycoplasmopsis arginini strain 11041 LH 16S ribosomal RNA gene, partial sequence	blastn	33807	183	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
2978114	2978114	PRJNA429937_P_NODE_79203_length_369_cov_1.841176_g56859_i0	PRJNA429937	79203	369	1.841176	6.79393944	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	368	3.07e-97	NTclustered	gi\|761597645\|dbj\|AP014657.1\|	2094	g56859	i0	100	4.11924119241192	199	0	88	0	100	298	257660	257462	Mycoplasma arginini DNA, complete genome, strain: HAZ145_1	blastn	1520	368	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
2978314	2978314	PRJNA429937_P_NODE_91363_length_329_cov_1.520000_g68779_i0	PRJNA429937	91363	329	1.52	5.0008	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	228	4.7899999999999985e-55	NTclustered	gi\|2668342370\|gb\|CP143577.1\|	2094	g68779	i0	98.462	32.6382978723404	130	0	68	2	1	128	123399	123270	Mycoplasmopsis arginini strain NCTC 10129 chromosome, complete genome	blastn	10738	228	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
15728357	15728357	PRJNA429937_P_NODE_119393_length_250_cov_2.176471_g96767_i0	PRJNA429937	119393	250	2.176471	5.4411775	Mycoplasmopsis arginini	2094	Bacteria	Bacteria	239	1.62e-58	NTclustered	gi\|761597645\|dbj\|AP014657.1\|	2094	g96767	i0	99.248	5.752	133	0	96	1	119	250	73336	73468	Mycoplasma arginini DNA, complete genome, strain: HAZ145_1	blastn	1438	239	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
16390283	16390283	PRJNA429937_P_NODE_86193_length_346_cov_1.835962_g63648_i0	PRJNA429937	86193	346	1.835962	6.35242852	Spiroplasma	2132	Bacteria	Bacteria	193	1.85e-44	NTclustered	gi\|2719904879\|emb\|OZ034992.1\|	3066293	g63648	i0	100	269.921965317919	104	0	73	0	21	124	1961621	1961518	Spiroplasma endosymbiont of Villa modesta isolate 54763 genome assembly, chromosome: 1	blastn	93393	193	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Villa modesta
25313921	25313921	PRJNA429937_P_NODE_83480_length_355_cov_1.401840_g60989_i0	PRJNA429937	83480	355	1.40184	4.976532	Metamycoplasmataceae	2895623	Bacteria	Bacteria	126	1.95e-24	NTclustered	gi\|761597645\|dbj\|AP014657.1\|	2094	g60989	i0	100	3.31267605633803	68	0	68	0	215	282	73401	73468	Mycoplasma arginini DNA, complete genome, strain: HAZ145_1	blastn	1176	126	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mycoplasmopsis	Mycoplasmopsis arginini
30201851	30201851	PRJNA429937_P_NODE_43632_length_542_cov_5.666667_g27907_i0	PRJNA429937	43632	542	5.666667	30.71333514	Mycoplasmatales bacterium	2023991	Bacteria	Bacteria	110	1.42e-24	NR	HXN54441.1	2023991	g27907	i0	39.4	0.885608856088561	160	83	80.8	3	31	468	401	560	HXN54441.1 reverse transcriptase family protein [Mycoplasmatales bacterium]	diamond	480	110	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales			Mycoplasmatales 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);;