metadata: contig_metadata: 17 rows where bioproject = "PRJNA540466" and tax

17 rows where bioproject = "PRJNA540466" 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
3059101	3059101	PRJNA540466_S_NODE_56343_length_252_cov_0.905028_g55794_i0	PRJNA540466	56343	252	0.905028	2.28067056	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	110	1.34e-19	NTclustered	gi\|1958123529\|gb\|CP065016.1\|	2026720	g55794	i0	98.413	5.11507936507936	63	0	25	1	23	84	465458	465396	Candidatus Saccharibacteria bacterium isolate Vibo_18-Q3-R45-57_BAT3C.117_fly chromosome, complete genome	blastn	1289	110	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
10712209	10712209	PRJNA540466_S_NODE_47129_length_270_cov_5.598985_g46580_i0	PRJNA540466	47129	270	5.598985	15.1172595	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	300	8e-77	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g46580	i0	92.788	168.02962962963	208	14	77	1	41	248	220099	219893	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	45368	300	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
21520543	21520543	PRJNA540466_S_NODE_65497_length_236_cov_2.386503_g64948_i0	PRJNA540466	65497	236	2.386503	5.63214708	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	198	2.57e-46	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g64948	i0	92.143	36.2415254237288	140	11	59	0	97	236	694916	694777	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	8553	198	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis
27330806	27330806	PRJNA540466_S_NODE_21183_length_385_cov_3.144231_g20634_i0	PRJNA540466	21183	385	3.144231	12.10528935	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	167	7.22e-50	NR	TAH34051.1	2026720	g20634	i0	82.3	0.966233766233766	124	22	96.6	0	383	12	83	206	TAH34051.1 MAG: hypothetical protein EYC59_03580 [Candidatus Saccharibacteria bacterium]	diamond	372	167	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27710090	27710090	PRJNA540466_S_NODE_14224_length_461_cov_2.822165_g13677_i0	PRJNA540466	14224	461	2.822165	13.01018065	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	124	2.45e-33	NR	HEV2403706.1	2973664	g13677	i0	60.2	0.637744034707158	98	39	63.8	0	150	443	23	120	HEV2403706.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	294	124	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
28025461	28025461	PRJNA540466_S_NODE_48605_length_267_cov_2.381443_g48056_i0	PRJNA540466	48605	267	2.381443	6.35845281	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	137	1.12e-37	NR	TAH31809.1	2026720	g48056	i0	80.7	1.97752808988764	88	17	98.9	0	1	264	205	292	TAH31809.1 MAG: 16S rRNA (cytosine(1402)-N(4))-methyltransferase RsmH [Candidatus Saccharibacteria bacterium]	diamond	528	137	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28277820	28277820	PRJNA540466_S_NODE_48806_length_267_cov_1.195876_g48257_i0	PRJNA540466	48806	267	1.195876	3.19298892	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	92.4	5.55e-20	NR	NCU38075.1	2026720	g48257	i0	69.7	1.49438202247191	66	20	74.2	0	264	67	274	339	NCU38075.1 YvcK family protein [Candidatus Saccharibacteria bacterium]	diamond	399	92.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29635287	29635287	PRJNA540466_S_NODE_28290_length_337_cov_2.034091_g27741_i0	PRJNA540466	28290	337	2.034091	6.85488667	Candidatus Saccharibacteria bacterium 49-2	1895829	Bacteria	Bacteria	188	4.5899999999999994e-57	NR	OJU87866.1	1895829	g27741	i0	95	0.899109792284866	101	5	89.9	0	24	326	195	295	OJU87866.1 MAG: 16S rRNA (cytosine(1402)-N(4))-methyltransferase [Candidatus Saccharibacteria bacterium 49-20]	diamond	303	188	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 49-20
30250987	30250987	PRJNA540466_S_NODE_55852_length_252_cov_7.212291_g55303_i0	PRJNA540466	55852	252	7.212291	18.17497332	Bacteria	2	Bacteria	Bacteria	79.7	3.96e-15	NR	MDB5161849.1	2026720	g55303	i0	90.9	7.27380952380952	44	4	52.4	0	19	150	24	67	MDB5161849.1 rane protein of unknown function [Candidatus Saccharibacteria bacterium]	diamond	1833	79.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30583149	30583149	PRJNA540466_S_NODE_27013_length_344_cov_1.845018_g26464_i0	PRJNA540466	27013	344	1.845018	6.34686192	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	75.1	2.2e-15	NR	MEO8691626.1	1917697	g26464	i0	53.4	0.505813953488372	58	27	50.6	0	252	79	1	58	MEO8691626.1 hypothetical protein [Candidatus Saccharimonas sp.]	diamond	174	75.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
30994178	30994178	PRJNA540466_S_NODE_64454_length_239_cov_3.337349_g63905_i0	PRJNA540466	64454	239	3.337349	7.97626411	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	51.2	9.32e-6	NR	HEY5267673.1	2973664	g63905	i0	44.8	1.33054393305439	58	31	72.8	1	21	194	82	138	HEY5267673.1 HNH endonuclease [Candidatus Saccharimonadales bacterium]	diamond	318	51.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
31120154	31120154	PRJNA540466_S_NODE_21115_length_386_cov_1.431310_g20566_i0	PRJNA540466	21115	386	1.43131	5.5248566	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	178	7.37e-52	NR	TAH32542.1	2026720	g20566	i0	85.6	0.917098445595855	118	17	91.7	0	366	13	59	176	TAH32542.1 MAG: hypothetical protein EYC58_02710 [Candidatus Saccharibacteria bacterium]	diamond	354	178	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31246858	31246858	PRJNA540466_S_NODE_38195_length_296_cov_1.282511_g37646_i0	PRJNA540466	38195	296	1.282511	3.79623256	Candidatus Saccharibacteria bacterium 32-5	1970480	Bacteria	Bacteria	60.1	3.99e-9	NR	OYX37813.1	1970480	g37646	i0	51.9	1.60135135135135	52	25	52.7	0	282	127	39	90	OYX37813.1 MAG: RNA-binding protein [Candidatus Saccharibacteria bacterium 32-50-10]	diamond	474	60.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 32-50-10
31721328	31721328	PRJNA540466_S_NODE_19117_length_404_cov_2.752266_g18568_i0	PRJNA540466	19117	404	2.752266	11.11915464	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	188	2.85e-58	NR	HET9411562.1	2973664	g18568	i0	78.7	3.62376237623762	122	26	90.6	0	389	24	1	122	HET9411562.1 uridylate kinase [Candidatus Saccharimonadales bacterium]	diamond	1464	188	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
32006129	32006129	PRJNA540466_S_NODE_43298_length_280_cov_3.512077_g42749_i0	PRJNA540466	43298	280	3.512077	9.8338156	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	81.6	4.36e-16	NR	TAH31809.1	2026720	g42749	i0	78.2	1.15714285714286	55	12	58.9	0	19	183	243	297	TAH31809.1 MAG: 16S rRNA (cytosine(1402)-N(4))-methyltransferase RsmH [Candidatus Saccharibacteria bacterium]	diamond	324	81.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
32242799	32242799	PRJNA540466_S_NODE_65698_length_235_cov_3.672840_g65149_i0	PRJNA540466	65698	235	3.67284	8.631174	Bacteria	2	Bacteria	Bacteria	122	1.09e-32	NR	OYW41872.1	1970477	g65149	i0	84.5	3.62553191489362	71	11	90.6	0	3	215	155	225	OYW41872.1 MAG: 16S rRNA (cytosine(1402)-N(4))-methyltransferase, partial [Candidatus Saccharibacteria bacterium 32-45-3]	diamond	852	123	0.991869918699187	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 32-45-3
32306043	32306043	PRJNA540466_S_NODE_28079_length_338_cov_2.550943_g27530_i0	PRJNA540466	28079	338	2.550943	8.62218734	Bacteria	2	Bacteria	Bacteria	176	2.07e-51	NR	HRF28803.1	2026720	g27530	i0	83.2	8.36094674556213	95	16	84.3	0	23	307	15	109	HRF28803.1 M50 family metallopeptidase [Candidatus Saccharibacteria bacterium]	diamond	2826	176	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);;