metadata: contig_metadata: 7 rows where bioproject = "PRJNA293022", tax_kingdom = "Bacillati" and tax

7 rows where bioproject = "PRJNA293022", 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
7437603	7437603	PRJNA293022_P_NODE_26706_length_273_cov_1.218750_g25969_i0	PRJNA293022	26706	273	1.21875	3.3271875	Candidatus Phytoplasma	33926	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|171853496\|emb\|AM422018.1\|	59748	g25969	i0	96.774	0.227106227106227	31	1	11	0	48	78	524783	524753	Candidatus Phytoplasma australiense complete genome	blastn	62	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae	Candidatus Phytoplasma	Candidatus Phytoplasma australiense
11262792	11262792	PRJNA293022_P_NODE_18089_length_335_cov_15.758741_g17352_i0	PRJNA293022	18089	335	15.758741	52.79178235	Mycoplasma	2093	Bacteria	Bacteria	169	3.01e-37	NTclustered	gi\|323574443\|emb\|FQ790233.1\|	708248	g17352	i0	80.738	32.755223880597	244	23	68	19	28	254	312508	312272	Mycoplasma suis KI3806 complete genome	blastn	10973	169	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma suis
12538290	12538290	PRJNA293022_P_NODE_74890_length_164_cov_2.113043_g74153_i0	PRJNA293022	74890	164	2.113043	3.46539052	Mycoplasma	2093	Bacteria	Bacteria	91.6	2.9e-14	NTclustered	gi\|335353881\|dbj\|AB638408.1\|	29501	g74153	i0	100	23.6829268292683	49	0	30	0	114	162	72	24	Mycoplasma haemofelis DNA, 16S-23S rRNA internal transcribed spacer, complete sequence, strain: Gandai2	blastn	3884	91.6	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma haemofelis
16950783	16950783	PRJNA293022_P_NODE_67454_length_169_cov_0.866667_g66717_i0	PRJNA293022	67454	169	0.866667	1.46466723	Metamycoplasma faucium	56142	Bacteria	Bacteria	265	1.66e-66	NTclustered	gi\|2708452869\|gb\|CP088155.1\|	56142	g66717	i0	95.21	1.97633136094675	167	8	99	0	3	169	344106	344272	Metamycoplasma faucium strain UMCG-MFM1 chromosome, complete genome	blastn	334	265	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Metamycoplasma	Metamycoplasma faucium
18911122	18911122	PRJNA293022_P_NODE_34295_length_239_cov_1.084211_g33558_i0	PRJNA293022	34295	239	1.084211	2.59126429	Mycoplasma	2093	Bacteria	Bacteria	137	8.78e-36	NR	WP_015726045.1	29501	g33558	i0	89.9	9.85355648535565	79	8	99.2	0	237	1	315	393	WP_015726045.1 molecular chaperone DnaK [Mycoplasma haemofelis]	diamond	2355	137	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma haemofelis
28842532	28842532	PRJNA293022_P_NODE_57968_length_183_cov_1.007463_g57231_i0	PRJNA293022	57968	183	1.007463	1.84365729	Candidatus Mycoplasma haematohominis	1494318	Bacteria	Bacteria	68.9	8.54e-12	NR	WP_216082890.1	1494318	g57231	i0	57.6	1.91803278688525	59	24	95.1	1	178	5	160	218	WP_216082890.1 HD domain-containing protein [Candidatus Mycoplasma haematohominis]	diamond	351	68.9	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematohominis
30295795	30295795	PRJNA293022_P_NODE_43032_length_213_cov_0.823171_g42295_i0	PRJNA293022	43032	213	0.823171	1.75335423	Candidatus Mycoplasma haematohominis	1494318	Bacteria	Bacteria	97.8	1.2799999999999999e-23	NR	WP_216083123.1	1494318	g42295	i0	65.7	1.95774647887324	70	24	98.6	0	211	2	33	102	WP_216083123.1 50S ribosomal protein L6 [Candidatus Mycoplasma haematohominis]	diamond	417	97.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Candidatus Mycoplasma haematohominis

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