metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA560029" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA560029" 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
3095221	3095221	PRJNA560029_S_NODE_5563_length_423_cov_11.880000_g5339_i0	PRJNA560029	5563	423	11.88	50.2524	Acholeplasmataceae bacterium	1898209	Bacteria	Bacteria	167	6.2e-50	NR	MDO9629773.1	1898209	g5339	i0	72.7	2.57446808510638	121	33	85.8	0	413	51	55	175	MDO9629773.1 SIS domain-containing protein [Acholeplasmataceae bacterium]	diamond	1089	167	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Acholeplasmatales	Acholeplasmataceae		Acholeplasmataceae bacterium
6921897	6921897	PRJNA560029_S_NODE_23926_length_284_cov_3.066351_g23702_i0	PRJNA560029	23926	284	3.066351	8.70843684	Bacteria	2	Bacteria	Bacteria	130	1.58e-34	NR	WOO87324.1	3081163	g23702	i0	67	2.96830985915493	94	31	99.3	0	282	1	119	212	WOO87324.1 NAD(P)/FAD-dependent oxidoreductase [Mollicutes bacterium LVI A0039]	diamond	843	130	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes				Mollicutes bacterium LVI A0039
14573124	14573124	PRJNA560029_S_NODE_35652_length_240_cov_4.149701_g35428_i0	PRJNA560029	35652	240	4.149701	9.9592824	Bacillati	1783272	Bacteria	Bacteria	149	2.63e-41	NR	OPZ33790.1	1852921	g35428	i0	84.6	15.6625	78	12	97.5	0	236	3	88	165	OPZ33790.1 MAG: Proline--tRNA ligase [Tenericutes bacterium ADurb.BinA124]	diamond	3759	150	0.993333333333333	Bacteria	Bacillati	Mycoplasmatota					Tenericutes bacterium ADurb.BinA124
17121988	17121988	PRJNA560029_S_NODE_8314_length_384_cov_2.620579_g8090_i0	PRJNA560029	8314	384	2.620579	10.06302336	Candidatus Izemoplasmatales bacterium	3018265	Bacteria	Bacteria	70.1	1.23e-12	NR	MFA7561450.1	3018265	g8090	i0	47.2	0.5625	72	37	55.5	1	232	20	1	72	MFA7561450.1 ribonuclease P protein component [Candidatus Izemoplasmatales bacterium]	diamond	216	70.1	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales			Candidatus Izemoplasmatales bacterium
28184155	28184155	PRJNA560029_S_NODE_16626_length_320_cov_8.910931_g16402_i0	PRJNA560029	16626	320	8.910931	28.5149792	Candidatus Izemoplasmatales bacterium	3018265	Bacteria	Bacteria	89	1e-18	NR	MDY0010574.1	3018265	g16402	i0	43.4	2.90625	99	52	92.8	1	299	3	185	279	MDY0010574.1 ATP synthase F1 subunit gamma [Candidatus Izemoplasmatales bacterium]	diamond	930	89	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales			Candidatus Izemoplasmatales bacterium
28215737	28215737	PRJNA560029_S_NODE_24446_length_282_cov_2.019139_g24222_i0	PRJNA560029	24446	282	2.019139	5.69397198	Candidatus Izemoplasmataceae bacterium	3107147	Bacteria	Bacteria	63.2	2.67e-9	NR	MFP4286793.1	3107147	g24222	i0	41	0.829787234042553	78	44	80.9	2	235	8	35	112	MFP4286793.1 ribonuclease HIII [Candidatus Izemoplasmataceae bacterium]	diamond	234	63.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales	Candidatus Izemoplasmataceae		Candidatus Izemoplasmataceae bacterium
28278905	28278905	PRJNA560029_S_NODE_31946_length_251_cov_1.803371_g31722_i0	PRJNA560029	31946	251	1.803371	4.52646121	Mollicutes bacterium LVI A	37628	Bacteria	Bacteria	73.6	5.79e-13	NR	WOO87775.1	3081163	g31722	i0	69.1	1.31474103585657	55	17	65.7	0	83	247	696	750	WOO87775.1 ABC transporter substrate-binding protein/permease [Mollicutes bacterium LVI A0039]	diamond	330	73.6	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes				Mollicutes bacterium LVI A0039
29131770	29131770	PRJNA560029_S_NODE_21189_length_297_cov_1.718750_g20965_i0	PRJNA560029	21189	297	1.71875	5.1046875	Haloplasma contractile	471825	Bacteria	Bacteria	56.2	1.26e-6	NR	WP_008825686.1	471825	g20965	i0	35.9	1.32323232323232	64	41	64.6	0	194	3	5	68	WP_008825686.1 ABC transporter ATP-binding protein [Haloplasma contractile]	diamond	393	56.2	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Haloplasmatales	Haloplasmataceae	Haloplasma	Haloplasma contractile
30552763	30552763	PRJNA560029_S_NODE_1993_length_596_cov_4.319312_g1775_i0	PRJNA560029	1993	596	4.319312	25.74309952	Haloplasma contractile	471825	Bacteria	Bacteria	166	1.77e-48	NR	WP_008824991.1	471825	g1775	i0	68.1	1.6761744966443	113	34	55.9	1	3	335	68	180	WP_008824991.1 hypoxanthine phosphoribosyltransferase [Haloplasma contractile]	diamond	999	166	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Haloplasmatales	Haloplasmataceae	Haloplasma	Haloplasma contractile
30615985	30615985	PRJNA560029_S_NODE_12453_length_347_cov_4.791971_g12229_i0	PRJNA560029	12453	347	4.791971	16.62813937	Candidatus Izemoplasmatales bacterium	3018265	Bacteria	Bacteria	87	2.5e-18	NR	MDY0318158.1	3018265	g12229	i0	42.5	3.76080691642651	106	60	91.6	1	334	17	112	216	MDY0318158.1 Type 1 glutamine amidotransferase-like domain-containing protein [Candidatus Izemoplasmatales bacterium]	diamond	1305	87	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales			Candidatus Izemoplasmatales bacterium
32133903	32133903	PRJNA560029_S_NODE_4458_length_450_cov_19.824934_g4234_i0	PRJNA560029	4458	450	19.824934	89.212203	Candidatus Izemoplasmataceae bacterium	3107147	Bacteria	Bacteria	84.7	3.08e-16	NR	MFP4078343.1	3107147	g4234	i0	37.1	0.773333333333333	116	69	75.3	2	5	343	216	330	MFP4078343.1 heat-inducible transcriptional repressor HrcA [Candidatus Izemoplasmataceae bacterium]	diamond	348	84.7	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Candidatus Izemoplasmatales	Candidatus Izemoplasmataceae		Candidatus Izemoplasmataceae bacterium
32386861	32386861	PRJNA560029_S_NODE_12059_length_350_cov_3.902527_g11835_i0	PRJNA560029	12059	350	3.902527	13.6588445	Malacoplasma sp.	2791014	Bacteria	Bacteria	76.6	1.66e-13	NR	MDE5553007.1	2791014	g11835	i0	59	1.5	61	25	52.3	0	152	334	96	156	MDE5553007.1 fructose-specific PTS transporter subunit EIIC [Malacoplasma sp.]	diamond	525	76.6	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Mycoplasmoidaceae	Malacoplasma	Malacoplasma sp.
32401078	32401078	PRJNA560029_S_NODE_19079_length_307_cov_3.636752_g18855_i0	PRJNA560029	19079	307	3.636752	11.16482864	Mollicutes	31969	Bacteria	Bacteria	140	2.35e-38	NR	MBD5446146.1	2108	g18855	i0	80.2	1.74918566775244	91	16	88.9	1	280	8	124	212	MBD5446146.1 50S ribosomal protein L3 [Mycoplasma sp.]	diamond	537	140	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma sp.
32873982	32873982	PRJNA560029_S_NODE_10080_length_366_cov_4.358362_g9856_i0	PRJNA560029	10080	366	4.358362	15.95160492	Bacillati	1783272	Bacteria	Bacteria	112	1.48e-26	NR	WP_127092421.1	2138	g9856	i0	50.4	6.78688524590164	113	56	92.6	0	362	24	53	165	WP_127092421.1 FAD-dependent oxidoreductase [Spiroplasma poulsonii]	diamond	2484	112	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Entomoplasmatales	Spiroplasmataceae	Spiroplasma	Spiroplasma poulsonii

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