metadata: contig_metadata: 11 rows where bioproject = "PRJNA799842", tax_clade = "Bacteria candidate phyla" and tax

11 rows where bioproject = "PRJNA799842", 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
14821878	14821878	PRJNA799842_P_NODE_143452_length_250_cov_0.870056_g141879_i0	PRJNA799842	143452	250	0.870056	2.17514	Candidatus Minimicrobia vallesae	2841264	Bacteria	Bacteria	383	7.07e-102	NTclustered	gi\|2052594292\|gb\|CP076459.1\|	2841264	g141879	i0	94.378	7.96	249	14	99	0	1	249	648893	648645	Candidatus Minimicrobia vallesae isolate IHU2 chromosome, complete genome	blastn	1990	383	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia vallesae
16521755	16521755	PRJNA799842_P_NODE_166733_length_245_cov_0.895349_g165160_i0	PRJNA799842	166733	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	102	2.85e-23	NR	MDB5181828.1	2026720	g165160	i0	98.1	15.9183673469388	52	1	63.7	0	3	158	308	359	MDB5181828.1 rny [Candidatus Saccharibacteria bacterium]	diamond	3900	102	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28601570	28601570	PRJNA799842_P_NODE_137607_length_251_cov_0.865169_g136034_i0	PRJNA799842	137607	251	0.865169	2.17157419	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	152	4.3e-41	NR	TAH33246.1	2026720	g136034	i0	100	0.99203187250996006	83	0	99.2	0	1	249	259	341	TAH33246.1 MAG: hypothetical protein EYC58_01295 [Candidatus Saccharibacteria bacterium]	diamond	249	152	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28696404	28696404	PRJNA799842_P_NODE_173687_length_244_cov_0.900585_g172114_i0	PRJNA799842	173687	244	0.900585	2.1974274	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	67.4	8.03e-11	NR	HSW48412.1	2973664	g172114	i0	69.8	0.651639344262295	53	16	65.2	0	85	243	111	163	HSW48412.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	159	67.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
30622561	30622561	PRJNA799842_P_NODE_13833_length_837_cov_1.795812_g12510_i0	PRJNA799842	13833	837	1.795812	15.03094644	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	115	1.13e-28	NR	HSW92233.1	2973664	g12510	i0	68.4	0.584229390681004	79	25	28.3	0	359	123	1	79	HSW92233.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	489	115	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
30907339	30907339	PRJNA799842_P_NODE_85074_length_313_cov_1.604167_g83501_i0	PRJNA799842	85074	313	1.604167	5.02104271	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	79	7.19e-15	NR	HSW92234.1	2973664	g83501	i0	37.4	0.87220447284345	91	57	87.2	0	274	2	1	91	HSW92234.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	273	79	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
31507912	31507912	PRJNA799842_P_NODE_157496_length_247_cov_0.885057_g155923_i0	PRJNA799842	157496	247	0.885057	2.18609079	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	148	1.9799999999999994e-42	NR	HSX80673.1	2890869	g155923	i0	92.6	0.983805668016194	81	6	98.4	0	247	5	143	223	HSX80673.1 CUAEP/CCAEP-tail radical SAM protein [Candidatus Saccharimonadia bacterium]	diamond	243	148	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia				Candidatus Saccharimonadia bacterium
31602763	31602763	PRJNA799842_P_NODE_149036_length_249_cov_0.875000_g147463_i0	PRJNA799842	149036	249	0.875	2.17875	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	86.7	2.33e-18	NR	HSW96610.1	2973664	g147463	i0	51.4	0.867469879518072	72	35	86.7	0	33	248	121	192	HSW96610.1 aminotransferase class IV [Candidatus Saccharimonadales bacterium]	diamond	216	86.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
32330608	32330608	PRJNA799842_P_NODE_136339_length_251_cov_0.865169_g134766_i0	PRJNA799842	136339	251	0.865169	2.17157419	Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1	1986206	Bacteria	Bacteria	67.8	1.86e-12	NR	WP_244596211.1	1986206	g134766	i0	49.4	0.944223107569721	79	34	93.2	3	2	235	14	87	WP_244596211.1 STAS-like domain-containing protein [Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1]	diamond	237	67.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Nanosynsacchari	Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1
32434487	32434487	PRJNA799842_P_NODE_189219_length_241_cov_0.916667_g187646_i0	PRJNA799842	189219	241	0.916667	2.20916747	Bacteria	2	Bacteria	Bacteria	55.5	7.51e-7	NR	MBX4190511.1	2026720	g187646	i0	48	1.25726141078838	50	26	62.2	0	88	237	127	176	MBX4190511.1 FAD:protein FMN transferase [Candidatus Saccharibacteria bacterium]	diamond	303	55.8	0.99462365591397806	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
32740900	32740900	PRJNA799842_P_NODE_163260_length_246_cov_0.890173_g161687_i0	PRJNA799842	163260	246	0.890173	2.18982558	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	160	3.45e-46	NR	TAH31781.1	2026720	g161687	i0	96.3	0.98780487804878	81	3	98.8	0	3	245	1	81	TAH31781.1 MAG: hypothetical protein EYC58_03840 [Candidatus Saccharibacteria bacterium]	diamond	243	160	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota 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);;