metadata: contig_metadata: 8 rows where bioproject = "PRJEB28062", tax_kingdom = "Bacillati" and tax

8 rows where bioproject = "PRJEB28062", 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
5127537	5127537	PRJEB28062_P_NODE_60425_length_450_cov_7.419098_g58065_i0	PRJEB28062	60425	450	7.419098	33.385941	Spiroplasma endosymbiont of Othius punctulatus	3066289	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2706542394\|emb\|OZ026449.1\|	3066289	g58065	i0	100	0.0666666666666667	30	0	7	0	175	204	691707	691678	Spiroplasma endosymbiont of Othius punctulatus isolate 54758 genome assembly, chromosome: 1	blastn	30	56.5	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma endosymbiont of Othius punctulatus
11502892	11502892	PRJEB28062_P_NODE_47250_length_522_cov_4.418708_g44905_i0	PRJEB28062	47250	522	4.418708	23.06565576	uncultured Mycoplasmatota bacterium	658143	Bacteria	Bacteria	121	1.3800000000000001e-22	NTclustered	gi\|2187152065\|emb\|OV788643.1\|	658143	g44905	i0	94.805	1.30651340996169	77	4	15	0	306	382	955792	955716	uncultured Tenericutes bacterium isolate min17_bin32 genome assembly, chromosome: 1	blastn	682	121	1	Bacteria	Bacillati	Mycoplasmatota					uncultured Mycoplasmatota bacterium
14051909	14051909	PRJEB28062_P_NODE_117652_length_266_cov_3.051813_g115289_i0	PRJEB28062	117652	266	3.051813	8.11782258	Candidatus Phytoplasma oryzae	203274	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|2430437647\|gb\|CP116038.1\|	203274	g115289	i0	100	0.105263157894737	28	0	11	0	79	106	360852	360879	Candidatus Phytoplasma oryzae strain HN2022 chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma oryzae
14052497	14052497	PRJEB28062_P_NODE_23412_length_771_cov_9.358166_g21222_i0	PRJEB28062	23412	771	9.358166	72.15145986	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	239	1.67e-74	NR	MFA6377913.1	1898209	g21222	i0	47.6	1.06225680933852	273	118	99.2	3	1	765	2	267	MFA6377913.1 hypothetical protein [Acholeplasmataceae bacterium]	diamond	819	239	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
17565394	17565394	PRJEB28062_P_NODE_47154_length_522_cov_98.483296_g44809_i0	PRJEB28062	47154	522	98.483296	514.08280512	Malacoplasma	2791001	Bacteria	Bacteria	608	2.419999999999999e-169	NTclustered	gi\|470476279\|ref\|NR_076329.1\|	28227	g44809	i0	88.69	134.92337164751	504	49	96	8	1	500	503	4	Mycoplasma penetrans strain HF-2 23S ribosomal RNA gene, complete sequence	blastn	70430	608	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma penetrans
19149183	19149183	PRJEB28062_P_NODE_11256_length_1148_cov_11.173023_g9575_i0	PRJEB28062	11256	1148	11.173023	128.26630404	Malacoplasma muris	2119	Bacteria	Bacteria	1489	0	NTclustered	gi\|299851933\|gb\|HM135461.1\|	2119	g9575	i0	90.208	119.160278745645	1154	95	100	16	1	1148	333	1474	Mycoplasma muris strain ATCC 33757 23S ribosomal RNA gene, partial sequence	blastn	136796	1489	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma muris
27917519	27917519	PRJEB28062_P_NODE_120345_length_259_cov_34.962366_g117981_i0	PRJEB28062	120345	259	34.962366	90.55252794	Paracholeplasma manati	591373	Bacteria	Bacteria	75.1	1.77e-13	NR	WP_277617861.1	591373	g117981	i0	86.4	0.50965250965251	44	3	47.5	1	59	181	421	464	WP_277617861.1 MATE family efflux transporter [Paracholeplasma manati]	diamond	132	75.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Paracholeplasma	Paracholeplasma manati
31929701	31929701	PRJEB28062_P_NODE_60957_length_448_cov_2.410667_g58597_i0	PRJEB28062	60957	448	2.410667	10.79978816	Haloplasma contractile	471825	Bacteria	Bacteria	180	7.039999999999999e-55	NR	WP_008824991.1	471825	g58597	i0	62	1.89508928571429	142	51	95.1	1	22	447	20	158	WP_008824991.1 hypoxanthine phosphoribosyltransferase [Haloplasma contractile]	diamond	849	180	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Haloplasmatales	Haloplasmataceae	Haloplasma	Haloplasma contractile

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