metadata: contig_metadata: 10 rows where bioproject = "PRJNA669701", tax_clade = "Bacteria candidate phyla" and tax

10 rows where bioproject = "PRJNA669701", 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_species
3185960	3185960	PRJNA669701_P_NODE_115083_length_249_cov_0.875000_g114688_i0	PRJNA669701	115083	249	0.875	2.17875	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	145	7.68e-41	NR	HSX02520.1	2890869	g114688	i0	87.8	0.987951807228916	82	10	98.8	0	2	247	61	142	HSX02520.1 50S ribosomal protein L2 [Candidatus Saccharimonadia bacterium]	diamond	246	145	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia		Candidatus Saccharimonadia bacterium
3716453	3716453	PRJNA669701_P_NODE_87103_length_273_cov_2.670000_g86708_i0	PRJNA669701	87103	273	2.67	7.2891	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	438	1.6499999999999995e-118	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g86708	i0	95.652	113.739926739927	276	7	100	5	1	273	80247	80520	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	31051	438	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
22313474	22313474	PRJNA669701_P_NODE_70698_length_294_cov_1.769231_g70303_i0	PRJNA669701	70698	294	1.769231	5.20153914	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	473	4.909999999999999e-129	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g70303	i0	95.608	215.598639455782	296	11	100	2	1	294	850903	851198	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	63386	473	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
26892025	26892025	PRJNA669701_P_NODE_75901_length_287_cov_1.299065_g75506_i0	PRJNA669701	75901	287	1.299065	3.72831655	Candidatus Saccharibacteria bacterium 49-2	1895829	Bacteria	Bacteria	154	5.0799999999999996e-42	NR	OJU87995.1	1895829	g75506	i0	87.8	1.8815331010453	90	11	94.1	0	270	1	1	90	OJU87995.1 MAG: hypothetical protein BGO17_03375 [Candidatus Saccharibacteria bacterium 49-20]	diamond	540	154	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharibacteria bacterium 49-20
28502808	28502808	PRJNA669701_P_NODE_124387_length_246_cov_0.890173_g123992_i0	PRJNA669701	124387	246	0.890173	2.18982558	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	103	1.07e-24	NR	MBN9397603.1	2026720	g123992	i0	83.1	1.73170731707317	71	12	86.6	0	3	215	218	288	MBN9397603.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	426	103	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
28976569	28976569	PRJNA669701_P_NODE_96868_length_262_cov_2.312169_g96473_i0	PRJNA669701	96868	262	2.312169	6.05788278	Candidatus Saccharibacteria bacterium 32-5	1970480	Bacteria	Bacteria	88.6	1.94e-18	NR	OYX39817.1	1970480	g96473	i0	100	0.515267175572519	45	0	51.5	0	261	127	206	250	OYX39817.1 MAG: hypothetical protein B7Z00_00120 [Candidatus Saccharibacteria bacterium 32-50-10]	diamond	135	88.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharibacteria bacterium 32-50-10
29335769	29335769	PRJNA669701_P_NODE_95909_length_263_cov_2.400000_g95514_i0	PRJNA669701	95909	263	2.4	6.312	Bacteria	2	Bacteria	Bacteria	47.4	5.99e-4	NR	MBN9398151.1	2026720	g95514	i0	100	0.91254752851711	23	0	26.2	0	71	3	136	158	MBN9398151.1 F0F1 ATP synthase subunit B [Candidatus Saccharibacteria bacterium]	diamond	240	47.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
29872553	29872553	PRJNA669701_P_NODE_103251_length_255_cov_2.087912_g102856_i0	PRJNA669701	103251	255	2.087912	5.3241756	Bacteria	2	Bacteria	Bacteria	159	4.789999999999999e-48	NR	HRF28265.1	2026720	g102856	i0	86.9	1.97647058823529	84	11	98.8	0	3	254	26	109	HRF28265.1 peroxiredoxin [Candidatus Saccharibacteria bacterium]	diamond	504	159	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharimonadota bacterium
30587015	30587015	PRJNA669701_P_NODE_94493_length_265_cov_1.427083_g94098_i0	PRJNA669701	94493	265	1.427083	3.78176995	Candidatus Saccharibacteria bacterium 49-2	1895829	Bacteria	Bacteria	63.2	3.12e-9	NR	OJU88075.1	1895829	g94098	i0	39.3	0.950943396226415	84	49	92.8	1	18	263	71	154	OJU88075.1 MAG: hypothetical protein BGO17_03815 [Candidatus Saccharibacteria bacterium 49-20]	diamond	252	63.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota			Candidatus Saccharibacteria bacterium 49-20
31819948	31819948	PRJNA669701_P_NODE_98497_length_260_cov_4.422460_g98102_i0	PRJNA669701	98497	260	4.42246	11.498396	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	144	1.86e-42	NR	HYF99401.1	2973664	g98102	i0	86	0.992307692307692	86	12	99.2	0	258	1	2	87	HYF99401.1 antibiotic biosynthesis monooxygenase [Candidatus Saccharimonadales bacterium]	diamond	258	144	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);;