metadata: contig_metadata: 14 rows where bioproject = "PRJNA853203", tax_clade = "Bacteria candidate phyla" and tax

14 rows where bioproject = "PRJNA853203", 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
841495	841495	PRJNA853203_P_NODE_38941_length_246_cov_1.705202_g38792_i0	PRJNA853203	38941	246	1.705202	4.19479692	Bacteria	2	Bacteria	Bacteria	150	6.71e-45	NR	OYX53491.1	1970481	g38792	i0	85.4	10	82	12	100	0	1	246	17	98	OYX53491.1 MAG: 30S ribosomal protein S16 [Candidatus Saccharibacteria bacterium 32-50-13]	diamond	2460	150	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 32-50-13
12320836	12320836	PRJNA853203_P_NODE_9330_length_291_cov_1.041284_g9181_i0	PRJNA853203	9330	291	1.041284	3.03013644	Candidatus Saccharibacteria bacterium YM_S32_TM7_50_20	2056494	Bacteria	Bacteria	187	7.0799999999999984e-43	NTclustered	gi\|1340357306\|gb\|CP025011.1\|	2056494	g9181	i0	79.323	0.914089347079038	266	55	91	0	18	283	811222	810957	Candidatus Saccharibacteria bacterium YM_S32_TM7_50_20 chromosome, complete genome	blastn	266	187	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium YM_S32_TM7_50_20
26896996	26896996	PRJNA853203_P_NODE_33821_length_249_cov_0.886364_g33672_i0	PRJNA853203	33821	249	0.886364	2.20704636	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	160	3.38e-45	NR	TAH32435.1	2026720	g33672	i0	98.8	0.987951807228916	82	1	98.8	0	2	247	183	264	TAH32435.1 MAG: trehalose-6-phosphate synthase [Candidatus Saccharibacteria bacterium]	diamond	246	160	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27181273	27181273	PRJNA853203_P_NODE_20362_length_265_cov_2.046875_g20213_i0	PRJNA853203	20362	265	2.046875	5.42421875	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	163	1.99e-46	NR	MBC7512274.1	2026720	g20213	i0	87.5	1.99245283018868	88	11	99.6	0	1	264	50	137	MBC7512274.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	528	163	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27970959	27970959	PRJNA853203_P_NODE_12405_length_283_cov_1.433333_g12256_i0	PRJNA853203	12405	283	1.433333	4.05633239	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	162	2.26e-46	NR	MBC7764540.1	2026720	g12256	i0	84.9	1.97173144876325	93	14	98.6	0	3	281	146	238	MBC7764540.1 DNA polymerase III subunit beta [Candidatus Saccharibacteria bacterium]	diamond	558	162	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28034328	28034328	PRJNA853203_P_NODE_42185_length_245_cov_0.906977_g42036_i0	PRJNA853203	42185	245	0.906977	2.22209365	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	120	2.92e-30	NR	MBN9397636.1	2026720	g42036	i0	65.4	0.991836734693878	81	28	99.2	0	3	245	215	295	MBN9397636.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	243	120	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29360332	29360332	PRJNA853203_P_NODE_31109_length_251_cov_0.876404_g30960_i0	PRJNA853203	31109	251	0.876404	2.19977404	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	109	7.5e-27	NR	MBM3209963.1	2026720	g30960	i0	69.9	0.99203187250996006	83	25	99.2	0	249	1	209	291	MBM3209963.1 NAD(P)/FAD-dependent oxidoreductase [Candidatus Saccharibacteria bacterium]	diamond	249	109	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29462840	29462840	PRJNA853203_P_NODE_49490_length_231_cov_2.316456_g49341_i0	PRJNA853203	49490	231	2.316456	5.35101336	Bacteria	2	Bacteria	Bacteria	69.3	1.32e-11	NR	OYX37945.1	1970480	g49341	i0	73.3	1.75324675324675	45	12	58.4	0	3	137	466	510	OYX37945.1 MAG: F0F1 ATP synthase subunit alpha [Candidatus Saccharibacteria bacterium 32-50-10]	diamond	405	69.3	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 32-50-10
30339916	30339916	PRJNA853203_P_NODE_29212_length_252_cov_0.871508_g29063_i0	PRJNA853203	29212	252	0.871508	2.19620016	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	48.1	3.73e-4	NR	MCA9330984.1	2026720	g29063	i0	87	0.273809523809524	23	3	27.4	0	183	251	1	23	MCA9330984.1 ATP-binding protein [Candidatus Saccharibacteria bacterium]	diamond	69	48.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30718448	30718448	PRJNA853203_P_NODE_38474_length_247_cov_0.896552_g38325_i0	PRJNA853203	38474	247	0.896552	2.21448344	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	70.1	2.45e-13	NR	MBC7512712.1	2026720	g38325	i0	73.2	1.0080971659919	41	11	49.8	0	2	124	65	105	MBC7512712.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	249	70.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31477301	31477301	PRJNA853203_P_NODE_21536_length_263_cov_1.310526_g21387_i0	PRJNA853203	21536	263	1.310526	3.44668338	Candidatus Saccharimonadaceae bacterium	2830836	Bacteria	Bacteria	78.6	3.73e-15	NR	HJM04601.1	2830836	g21387	i0	72.7	0.627376425855513	55	15	62.7	0	2	166	223	277	HJM04601.1 tRNA lysidine(34) synthetase TilS [Candidatus Saccharimonadaceae bacterium]	diamond	165	78.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae		Candidatus Saccharimonadaceae bacterium
31761756	31761756	PRJNA853203_P_NODE_17857_length_271_cov_1.181818_g17708_i0	PRJNA853203	17857	271	1.181818	3.20272678	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	65.5	5.14e-10	NR	MBQ3293807.1	2026720	g17708	i0	40	0.885608856088561	80	47	88.6	1	11	250	150	228	MBQ3293807.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	240	65.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
32331667	32331667	PRJNA853203_P_NODE_27299_length_253_cov_0.866667_g27150_i0	PRJNA853203	27299	253	0.866667	2.19266751	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	144	1.61e-39	NR	HEV7952213.1	2973664	g27150	i0	84.3	2.94071146245059	83	13	98.4	0	251	3	74	156	HEV7952213.1 RluA family pseudouridine synthase [Candidatus Saccharimonadales bacterium]	diamond	744	144	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
32584536	32584536	PRJNA853203_P_NODE_46239_length_243_cov_0.917647_g46090_i0	PRJNA853203	46239	243	0.917647	2.22988221	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	141	8.17e-37	NR	MBP6038294.1	1917697	g46090	i0	82.5	0.987654320987654	80	14	98.8	0	4	243	571	650	MBP6038294.1 transglycosylase domain-containing protein [Candidatus Saccharimonas sp.]	diamond	240	141	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas 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);;