metadata: contig_metadata: 12 rows where bioproject = "PRJNA608660", tax_clade = "Bacteria candidate phyla" and tax

12 rows where bioproject = "PRJNA608660", tax_clade = "Bacteria candidate phyla" and tax_phylum = "Candidatus Saccharimonadota"

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_clade	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
1860428	1860428	PRJNA608660_P_NODE_12062_length_427_cov_5.410053_g11715_i0	PRJNA608660	12062	427	5.410053	23.10092631	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	383	1.2899999999999998e-101	NTclustered	gi\|1958071672\|gb\|CP064992.1\|	2026720	g11715	i0	83.452	201.814988290398	423	58	98	12	11	427	638005	638421	Candidatus Saccharibacteria bacterium isolate Hirt_18-Q3-R61-65_BATAC.98_uni chromosome, complete genome	blastn	86175	383	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
18436923	18436923	PRJNA608660_P_NODE_5515_length_622_cov_2.879581_g5209_i0	PRJNA608660	5515	622	2.879581	17.91099382	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	150	2.13e-31	NTclustered	gi\|1958075319\|gb\|CP064995.1\|	2026720	g5209	i0	76.393	6.45980707395498	305	57	94	11	325	621	396156	396453	Candidatus Saccharibacteria bacterium isolate Hjor_18-Q3-R7-51_MAXAC.102_uni chromosome, complete genome	blastn	4018	150	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
19711408	19711408	PRJNA608660_P_NODE_47496_length_166_cov_0.888889_g47139_i0	PRJNA608660	47496	166	0.888889	1.47555574	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	75.5	1.41e-16	NR	MCA9339740.1	2026720	g47139	i0	76.1	0.831325301204819	46	11	83.1	0	162	25	4	49	MCA9339740.1 GTP cyclohydrolase I [Candidatus Saccharibacteria bacterium]	diamond	138	75.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
26858964	26858964	PRJNA608660_P_NODE_8181_length_522_cov_1.682875_g7846_i0	PRJNA608660	8181	522	1.682875	8.7846075	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	60.5	2.55e-8	NR	HSX79693.1	2890869	g7846	i0	74.3	0.649425287356322	113	28	64.4	1	186	521	1	113	HSX79693.1 hypothetical protein [Candidatus Saccharimonadia bacterium]	diamond	339	60.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia				Candidatus Saccharimonadia bacterium
27364888	27364888	PRJNA608660_P_NODE_1003_length_1120_cov_10.024276_g868_i0	PRJNA608660	1003	1120	10.024276	112.2718912	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	409	9.05e-138	NR	HSX81527.1	2890869	g868	i0	88.1	0.632142857142857	236	28	63.2	0	412	1119	19	254	HSX81527.1 D-alanyl-D-alanine carboxypeptidase [Candidatus Saccharimonadia bacterium]	diamond	708	409	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia				Candidatus Saccharimonadia bacterium
27964451	27964451	PRJNA608660_P_NODE_34465_length_211_cov_18.012346_g34109_i0	PRJNA608660	34465	211	18.012346	38.00605006	Candidatus Nanosynbacter sp.	2725945	Bacteria	Bacteria	102	1.74e-23	NR	MBF1037723.1	2725945	g34109	i0	96.1	0.725118483412322	51	2	72.5	0	165	13	12	62	MBF1037723.1 primosomal protein N' [Candidatus Nanosynbacter sp.]	diamond	153	102	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp.
28311891	28311891	PRJNA608660_P_NODE_41266_length_183_cov_3.164179_g40909_i0	PRJNA608660	41266	183	3.164179	5.79044757	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	60.1	1.21e-9	NR	RTK94802.1	2026720	g40909	i0	96.8	1.01639344262295	31	1	50.8	0	90	182	1	31	RTK94802.1 MAG: 50S ribosomal protein L7/L12 [Candidatus Saccharibacteria bacterium]	diamond	186	60.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29069771	29069771	PRJNA608660_P_NODE_30348_length_233_cov_8.913043_g29992_i0	PRJNA608660	30348	233	8.913043	20.76739019	Candidatus Saccharibacteria bacterium 32-49-1	1970478	Bacteria	Bacteria	55.5	9.87e-8	NR	OYW84148.1	1970478	g29992	i0	44.9	0.630901287553648	49	27	63.1	0	14	160	54	102	OYW84148.1 MAG: hypothetical protein B7Z17_04555 [Candidatus Saccharibacteria bacterium 32-49-10]	diamond	147	55.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 32-49-10
29448227	29448227	PRJNA608660_P_NODE_1910_length_918_cov_13.132336_g1725_i0	PRJNA608660	1910	918	13.132336	120.55484448	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	192	6.0500000000000006e-58	NR	MBI3889194.1	2026720	g1725	i0	75.4	0.372549019607843	114	28	37.3	0	769	428	1	114	MBI3889194.1 TIGR02611 family protein [Candidatus Saccharibacteria bacterium]	diamond	342	192	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29858902	29858902	PRJNA608660_P_NODE_29791_length_237_cov_1.106383_g29435_i0	PRJNA608660	29791	237	1.106383	2.62212771	Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1	1986206	Bacteria	Bacteria	66.6	3.14e-11	NR	WP_195157085.1	1986206	g29435	i0	88.2	0.430379746835443	34	4	43	0	230	129	111	144	WP_195157085.1 DUF5684 domain-containing protein [Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1]	diamond	102	66.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Nanosynsacchari	Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1
30901670	30901670	PRJNA608660_P_NODE_31594_length_226_cov_2.440678_g31238_i0	PRJNA608660	31594	226	2.440678	5.51593228	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	78.6	1.89e-15	NR	HSX78728.1	2890869	g31238	i0	83.7	0.650442477876106	49	8	65	0	43	189	79	127	HSX78728.1 hypothetical protein [Candidatus Saccharimonadia bacterium]	diamond	147	78.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia				Candidatus Saccharimonadia bacterium
32483106	32483106	PRJNA608660_P_NODE_3939_length_713_cov_6.025602_g3676_i0	PRJNA608660	3939	713	6.025602	42.96254226	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	62.8	2.81e-7	NR	HJQ08283.1	2973664	g3676	i0	36.4	1.03506311360449	121	68	50.9	3	701	339	452	563	HJQ08283.1 RHS repeat-associated core domain-containing protein [Candidatus Saccharimonadales bacterium]	diamond	738	62.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales 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);;