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

5 rows where bioproject = "PRJNA944406", 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
14013290	14013290	PRJNA944406_P_NODE_113171_length_226_cov_2.013072_g112212_i0	PRJNA944406	113171	226	2.013072	4.54954272	Mycoplasma	2093	Bacteria	Bacteria	165	2.48e-36	NTclustered	gi\|2263042568\|gb\|ON907818.1\|	273136	g112212	i0	80.995	174.384955752212	221	31	97	8	6	224	402	191	Mycoplasma amphoriforme strain M5572 23S ribosomal RNA gene, partial sequence	blastn	39411	165	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma amphoriforme
20051695	20051695	PRJNA944406_P_NODE_95676_length_244_cov_0.900585_g94717_i0	PRJNA944406	95676	244	0.900585	2.1974274	Metamycoplasma alkalescens	45363	Bacteria	Bacteria	60.2	1.32e-4	NTclustered	gi\|1450418660\|emb\|LS991949.1\|	45363	g94717	i0	97.143	0.14344262295082	35	1	14	0	184	218	232355	232389	Mycoplasma alkalescens strain NCTC10135 genome assembly, chromosome: 1	blastn	35	60.2	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma alkalescens
29867421	29867421	PRJNA944406_P_NODE_85131_length_246_cov_1.248555_g84172_i0	PRJNA944406	85131	246	1.248555	3.0714453	Mycoplasmataceae bacterium	2685873	Bacteria	Bacteria	69.7	1.22e-11	NR	MCK5867627.1	2685873	g84172	i0	40.2	3.73170731707317	87	46	98.8	2	246	4	4	90	MCK5867627.1 UDP-N-acetylmuramoyl-L-alanine--D-glutamate ligase [Mycoplasmataceae bacterium]	diamond	918	69.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae		Mycoplasmataceae bacterium
30088502	30088502	PRJNA944406_P_NODE_78092_length_248_cov_0.880000_g77133_i0	PRJNA944406	78092	248	0.88	2.1824	Mollicutes bacterium	37628	Bacteria	Bacteria	121	1.9099999999999997e-30	NR	HHU54807.1	37628	g77133	i0	71.1	3.01209677419355	83	23	99.2	1	246	1	43	125	HHU54807.1 asparagine--tRNA ligase [Mollicutes bacterium]	diamond	747	121	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes				Mollicutes bacterium
30253510	30253510	PRJNA944406_P_NODE_37172_length_275_cov_1.524752_g36213_i0	PRJNA944406	37172	275	1.524752	4.193068	Bacillati	1783272	Bacteria	Bacteria	75.1	2.27e-13	NR	MCK9234802.1	1898209	g36213	i0	44.9	3.33818181818182	78	43	85.1	0	260	27	118	195	MCK9234802.1 tail fiber domain-containing protein [Acholeplasmataceae bacterium]	diamond	918	75.5	0.994701986754967	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae 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);;