metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA1247234" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA1247234" and tax_clade = "Bacteria candidate phyla"

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
351321	351321	PRJNA1247234_P_NODE_23781_length_248_cov_0.891429_g23625_i0	PRJNA1247234	23781	248	0.891429	2.21074392	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	155	4.719999999999999e-43	NR	HRQ86572.1	2026720	g23625	i0	86.6	0.991935483870968	82	11	99.2	0	2	247	325	406	HRQ86572.1 DNA polymerase III subunit alpha [Candidatus Saccharibacteria bacterium]	diamond	246	155	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28241977	28241977	PRJNA1247234_P_NODE_27686_length_242_cov_0.923077_g27530_i0	PRJNA1247234	27686	242	0.923077	2.23384634	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	110	7.4e-27	NR	MBR3319460.1	2026720	g27530	i0	71.4	1.04132231404959	84	20	99.2	1	241	2	150	233	MBR3319460.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	252	110	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28336890	28336890	PRJNA1247234_P_NODE_23866_length_248_cov_0.891429_g23710_i0	PRJNA1247234	23866	248	0.891429	2.21074392	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	92.8	4.81e-20	NR	MBI5155080.1	2026781	g23710	i0	62.2	0.895161290322581	74	26	89.5	1	222	1	53	124	MBI5155080.1 trypsin-like peptidase domain-containing protein [Candidatus Poribacteria bacterium]	diamond	222	92.8	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria					Candidatus Poribacteria bacterium
29378844	29378844	PRJNA1247234_P_NODE_25889_length_245_cov_0.906977_g25733_i0	PRJNA1247234	25889	245	0.906977	2.22209365	Candidatus Methylomirabilis sp.	2032687	Bacteria	Bacteria	76.6	9.24e-15	NR	HEY7676127.1	2032687	g25733	i0	51.8	2.08163265306122	83	35	96.7	2	239	3	33	114	HEY7676127.1 transglycosylase SLT domain-containing protein [Candidatus Methylomirabilis sp.]	diamond	510	76.6	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota	Candidatus Methylomirabilia	Candidatus Methylomirabilales	Candidatus Methylomirabilaceae	Candidatus Methylomirabilis	Candidatus Methylomirabilis sp.
30010563	30010563	PRJNA1247234_P_NODE_24531_length_247_cov_0.896552_g24375_i0	PRJNA1247234	24531	247	0.896552	2.21448344	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	113	6.3200000000000006e-27	NR	MBR2544287.1	2026720	g24375	i0	96.6	0.716599190283401	59	2	71.7	0	179	3	1	59	MBR2544287.1 MBL fold metallo-hydrolase [Candidatus Saccharibacteria bacterium]	diamond	177	113	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30168220	30168220	PRJNA1247234_P_NODE_25492_length_245_cov_0.906977_g25336_i0	PRJNA1247234	25492	245	0.906977	2.22209365	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	86.7	1.32e-17	NR	MCA9330858.1	2026720	g25336	i0	52	2.75510204081633	75	36	91.8	0	10	234	33	107	MCA9330858.1 ATP-dependent zinc metalloprotease FtsH [Candidatus Saccharibacteria bacterium]	diamond	675	86.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30231562	30231562	PRJNA1247234_P_NODE_26212_length_244_cov_0.912281_g26056_i0	PRJNA1247234	26212	244	0.912281	2.22596564	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	137	1.35e-35	NR	MDE2233730.1	2052139	g26056	i0	80.2	1.99180327868852	81	16	99.6	0	1	243	245	325	MDE2233730.1 site-specific DNA-methyltransferase [Patescibacteria group bacterium]	diamond	486	137	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
30831816	30831816	PRJNA1247234_P_NODE_22354_length_250_cov_0.881356_g22198_i0	PRJNA1247234	22354	250	0.881356	2.20339	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	94.4	9.54e-22	NR	MBQ3293226.1	2026720	g22198	i0	52.4	2.028	84	39	99.6	1	2	250	77	160	MBQ3293226.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	507	94.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31464295	31464295	PRJNA1247234_P_NODE_23456_length_248_cov_0.891429_g23300_i0	PRJNA1247234	23456	248	0.891429	2.21074392	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	93.6	6.03e-21	NR	MBQ6313623.1	2026720	g23300	i0	64.2	4.25806451612903	67	24	81	0	248	48	191	257	MBQ6313623.1 polysaccharide deacetylase family protein [Candidatus Saccharibacteria bacterium]	diamond	1056	93.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
32255297	32255297	PRJNA1247234_P_NODE_23178_length_249_cov_0.886364_g23022_i0	PRJNA1247234	23178	249	0.886364	2.20704636	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	112	1.04e-29	NR	HET8884524.1	2973664	g23022	i0	60.2	1	83	33	100	0	1	249	12	94	HET8884524.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	249	112	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
32445027	32445027	PRJNA1247234_P_NODE_20439_length_253_cov_0.866667_g20283_i0	PRJNA1247234	20439	253	0.866667	2.19266751	Candidatus Nanosynbacter sp.	2725945	Bacteria	Bacteria	67.8	5.59e-11	NR	MBF1039893.1	2725945	g20283	i0	82.9	0.972332015810277	41	7	48.6	0	3	125	69	109	MBF1039893.1 hypothetical protein [Candidatus Nanosynbacter sp.]	diamond	246	67.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp.

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