metadata: contig_metadata: 15 rows where bioproject = "PRJNA1123309", tax_clade = "Bacteria candidate phyla" and tax

15 rows where bioproject = "PRJNA1123309", 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
2304333	2304333	PRJNA1123309_P_NODE_44102_length_260_cov_1.561497_g43722_i0	PRJNA1123309	44102	260	1.561497	4.0598922	Candidatus Minimicrobia	2905967	Bacteria	Bacteria	396	9.5e-106	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g43722	i0	97.034	276.223076923077	236	6	90	1	26	260	80941	80706	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	71818	396	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
6131972	6131972	PRJNA1123309_P_NODE_63025_length_244_cov_0.912281_g62645_i0	PRJNA1123309	63025	244	0.912281	2.22596564	Candidatus Minimicrobia	2905967	Bacteria	Bacteria	311	3.29e-80	NTclustered	gi\|2052594292\|gb\|CP076459.1\|	2841264	g62645	i0	91.228	8.44262295081967	228	20	93	0	3	230	22140	21913	Candidatus Minimicrobia vallesae isolate IHU2 chromosome, complete genome	blastn	2060	311	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia vallesae
10481965	10481965	PRJNA1123309_P_NODE_40849_length_268_cov_2.194872_g40469_i0	PRJNA1123309	40849	268	2.194872	5.88225696	Candidatus Nanosynbacter featherlites	2572088	Bacteria	Bacteria	370	5.96e-98	NTclustered	gi\|1663054866\|gb\|CP040004.1\|	2572088	g40469	i0	92.308	18.0932835820896	260	20	97	0	9	268	704155	703896	Candidatus Nanosynbacter featherlites strain BB001 chromosome, complete genome	blastn	4849	370	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter featherlites
11757079	11757079	PRJNA1123309_P_NODE_60610_length_245_cov_0.906977_g60230_i0	PRJNA1123309	60610	245	0.906977	2.22209365	Candidatus Minimicrobia vallesae	2841264	Bacteria	Bacteria	388	1.48e-103	NTclustered	gi\|2052594292\|gb\|CP076459.1\|	2841264	g60230	i0	95.851	8.7877551020408209	241	8	98	2	1	239	280735	280495	Candidatus Minimicrobia vallesae isolate IHU2 chromosome, complete genome	blastn	2153	388	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Minimicrobia	Candidatus Minimicrobia vallesae
11757129	11757129	PRJNA1123309_P_NODE_66170_length_242_cov_0.923077_g65790_i0	PRJNA1123309	66170	242	0.923077	2.23384634	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	385	1.89e-102	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g65790	i0	96.957	0.950413223140496	230	6	95	1	12	240	556316	556087	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	230	385	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
19404408	19404408	PRJNA1123309_P_NODE_57316_length_247_cov_0.896552_g56936_i0	PRJNA1123309	57316	247	0.896552	2.21448344	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	436	5.279999999999999e-118	NTclustered	gi\|2166692445\|gb\|CP089520.1\|	2899133	g56936	i0	100	7.68016194331984	236	0	96	0	1	236	169906	170141	Candidatus Nanosynbacter sp. HMT-352 strain KC1 chromosome, complete genome	blastn	1897	436	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
20679794	20679794	PRJNA1123309_P_NODE_39437_length_272_cov_1.296482_g39057_i0	PRJNA1123309	39437	272	1.296482	3.52643104	Bacteria	2	Bacteria	Bacteria	185	4.42e-57	NR	OJU87738.1	1895829	g39057	i0	95.6	5.95588235294118	90	4	99.3	0	1	270	82	171	OJU87738.1 MAG: deoxycytidine triphosphate deaminase [Candidatus Saccharibacteria bacterium 49-20]	diamond	1620	186	0.99462365591397806	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 49-20
26785559	26785559	PRJNA1123309_P_NODE_64141_length_243_cov_0.917647_g63761_i0	PRJNA1123309	64141	243	0.917647	2.22988221	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	89	1.67e-19	NR	HET8690147.1	2973664	g63761	i0	55.4	0.91358024691358	74	32	90.1	1	24	242	1	74	HET8690147.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	222	89	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
27101738	27101738	PRJNA1123309_P_NODE_66882_length_242_cov_0.911243_g66502_i0	PRJNA1123309	66882	242	0.911243	2.20520806	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	68.9	1.39e-11	NR	MCG5105437.1	2026720	g66502	i0	49.1	0.65702479338843	53	27	65.7	0	82	240	1	53	MCG5105437.1 metallophosphoesterase [Candidatus Saccharibacteria bacterium]	diamond	159	68.9	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27607440	27607440	PRJNA1123309_P_NODE_66324_length_242_cov_0.923077_g65944_i0	PRJNA1123309	66324	242	0.923077	2.23384634	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	152	6.09e-41	NR	MCA9345116.1	2026720	g65944	i0	88.5	6.71900826446281	78	9	96.7	0	240	7	542	619	MCA9345116.1 phosphoenolpyruvate synthase [Candidatus Saccharibacteria bacterium]	diamond	1626	152	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28112358	28112358	PRJNA1123309_P_NODE_51885_length_250_cov_1.316384_g51505_i0	PRJNA1123309	51885	250	1.316384	3.29096	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	48.1	3.36e-4	NR	HET8671483.1	2973664	g51505	i0	50.9	0.66	55	26	64.8	1	166	5	95	149	HET8671483.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	165	48.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
28459975	28459975	PRJNA1123309_P_NODE_63226_length_244_cov_0.912281_g62846_i0	PRJNA1123309	63226	244	0.912281	2.22596564	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	134	2.74e-38	NR	MDO4780871.1	2026720	g62846	i0	89.2	0.909836065573771	74	8	91	0	22	243	1	74	MDO4780871.1 30S ribosomal protein S9 [Candidatus Saccharibacteria bacterium]	diamond	222	134	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28554686	28554686	PRJNA1123309_P_NODE_47487_length_253_cov_0.866667_g47107_i0	PRJNA1123309	47487	253	0.866667	2.19266751	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	62	6.79e-9	NR	MCG5105720.1	2026720	g47107	i0	50.9	0.652173913043478	55	27	65.2	0	2	166	155	209	MCG5105720.1 phage tail tip lysozyme [Candidatus Saccharibacteria bacterium]	diamond	165	62	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29280558	29280558	PRJNA1123309_P_NODE_52709_length_250_cov_0.881356_g52329_i0	PRJNA1123309	52709	250	0.881356	2.20339	Candidatus Nanosynbacter sp.	2725945	Bacteria	Bacteria	166	3.47e-49	NR	MBF1032545.1	2725945	g52329	i0	94	0.996	83	5	99.6	0	249	1	5	87	MBF1032545.1 prepilin peptidase [Candidatus Nanosynbacter sp.]	diamond	249	166	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp.
29564817	29564817	PRJNA1123309_P_NODE_56170_length_248_cov_0.891429_g55790_i0	PRJNA1123309	56170	248	0.891429	2.21074392	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	156	1.2999999999999996e-43	NR	MBB1567568.1	2026720	g55790	i0	93.8	0.967741935483871	80	5	96.8	0	241	2	357	436	MBB1567568.1 UDP-N-acetylmuramoyl-L-alanyl-D-glutamate--2,6-diaminopimelate ligase [Candidatus Saccharibacteria bacterium]	diamond	240	156	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);;