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

8 rows where bioproject = "PRJNA312899", 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
10583353	10583353	PRJNA312899_P_NODE_36489_length_299_cov_3.672000_g36047_i0	PRJNA312899	36489	299	3.672	10.97928	Mycoplasma sp. ATU-Cv-7	2108	Bacteria	Bacteria	88.6	1.46e-18	NR	WP_161565545.1	2498595	g36047	i0	45.8	0.963210702341137	96	52	96.3	0	2	289	22	117	WP_161565545.1 glycosyltransferase [Mycoplasma sp. ATU-Cv-703]	diamond	288	88.6	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma sp. ATU-Cv-703
14408411	14408411	PRJNA312899_P_NODE_38932_length_287_cov_3.605042_g38490_i0	PRJNA312899	38932	287	3.605042	10.34647054	Haploplasma axanthum	29552	Bacteria	Bacteria	276	1.45e-69	NTclustered	gi\|1563809587\|emb\|LR215048.1\|	29552	g38490	i0	84.806	121.313588850174	283	34	99	8	1	277	56952	57231	Acholeplasma axanthum strain NCTC10138 genome assembly, chromosome: 1	blastn	34817	276	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Haploplasma	Haploplasma axanthum
14408953	14408953	PRJNA312899_P_NODE_69252_length_195_cov_2.082192_g68810_i0	PRJNA312899	69252	195	2.082192	4.0602744	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	231	2.02e-56	NTclustered	gi\|2621717558\|emb\|OY775910.1\|	1898209	g68810	i0	88.542	38.6923076923077	192	20	98	2	1	192	768821	768632	MAG: Acholeplasmataceae bacterium isolate 79d77305-d387-4e48-9b67-53dfc1ec32a7 genome assembly, chromosome: 1	blastn	7545	231	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
25290870	25290870	PRJNA312899_P_NODE_53980_length_234_cov_4.410811_g53538_i0	PRJNA312899	53980	234	4.410811	10.32129774	Ureaplasma	2129	Bacteria	Bacteria	431	2.3e-116	NTclustered	gi\|1493548740\|dbj\|AP018561.1\|	38504	g53538	i0	100	13.9401709401709	233	0	99	0	2	234	361194	361426	Ureaplasma parvum serovar 3 OMC-P162 DNA, complete genome	blastn	3262	431	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Ureaplasma	Ureaplasma parvum
30706090	30706090	PRJNA312899_P_NODE_73834_length_187_cov_1.891304_g73392_i0	PRJNA312899	73834	187	1.891304	3.53673848	Acholeplasma sp.	33015	Bacteria	Bacteria	82	2.45e-16	NR	HEY8405251.1	33015	g73392	i0	75	0.898395721925134	56	14	89.8	0	3	170	252	307	HEY8405251.1 hypothetical protein [Acholeplasma sp.]	diamond	168	82	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Acholeplasma	Acholeplasma sp.
31085383	31085383	PRJNA312899_P_NODE_51635_length_241_cov_2.125000_g51193_i0	PRJNA312899	51635	241	2.125	5.12125	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	99.8	2.45e-24	NR	MCK9235887.1	1898209	g51193	i0	62.1	1.08298755186722	87	26	99.6	2	2	241	5	91	MCK9235887.1 hypothetical protein [Acholeplasmataceae bacterium]	diamond	261	99.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
32589678	32589678	PRJNA312899_P_NODE_73079_length_188_cov_1.467626_g72637_i0	PRJNA312899	73079	188	1.467626	2.75913688	Bacillati	1783272	Bacteria	Bacteria	99.8	1.1e-22	NR	WP_035368026.1	264636	g72637	i0	72.6	2.96808510638298	62	17	98.9	0	188	3	194	255	WP_035368026.1 ATP-dependent nuclease [Acholeplasma hippikon]	diamond	558	100	0.998	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Acholeplasma	Acholeplasma hippikon
32792221	32792221	PRJNA312899_P_NODE_86480_length_167_cov_0.864407_g86038_i0	PRJNA312899	86480	167	0.864407	1.44355969	Candidatus Izemoplasmatales bacterium	3018265	Bacteria	Bacteria	49.3	2.78e-5	NR	MFA5068151.1	3018265	g86038	i0	50	2.78443113772455	52	25	91.6	1	165	13	71	122	MFA5068151.1 PcfJ domain-containing protein [Candidatus Izemoplasmatales bacterium]	diamond	465	49.3	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales			Candidatus Izemoplasmatales 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);;