metadata: contig_metadata: 17 rows where bioproject = "PRJNA520845", tax_clade = "Bacteria candidate phyla" and tax

17 rows where bioproject = "PRJNA520845", 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
1764420	1764420	PRJNA520845_P_NODE_174342_length_282_cov_1.473684_g172843_i0	PRJNA520845	174342	282	1.473684	4.15578888	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	494	3.6e-135	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g172843	i0	98.227	1	282	5	100	0	1	282	246319	246600	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	282	494	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
8143060	8143060	PRJNA520845_P_NODE_204927_length_257_cov_2.445652_g203428_i0	PRJNA520845	204927	257	2.445652	6.28532564	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	171	6.189999999999999e-38	NTclustered	gi\|1958075319\|gb\|CP064995.1\|	2026720	g203428	i0	78.74	0.988326848249027	254	54	99	0	2	255	670062	669809	Candidatus Saccharibacteria bacterium isolate Hjor_18-Q3-R7-51_MAXAC.102_uni chromosome, complete genome	blastn	254	171	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
26665501	26665501	PRJNA520845_P_NODE_220361_length_250_cov_0.870056_g218862_i0	PRJNA520845	220361	250	0.870056	2.17514	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	136	1.6499999999999998e-35	NR	HEX7484404.1	2973664	g218862	i0	69.9	0.996	83	25	99.6	0	2	250	60	142	HEX7484404.1 serine hydrolase [Candidatus Saccharimonadales bacterium]	diamond	249	136	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
27614555	27614555	PRJNA520845_P_NODE_263484_length_241_cov_1.470238_g261985_i0	PRJNA520845	263484	241	1.470238	3.54327358	Candidatus Saccharibacteria bacterium 49-2	1895829	Bacteria	Bacteria	110	3.06e-26	NR	OJU87965.1	1895829	g261985	i0	94.9	0.734439834024896	59	3	73.4	0	241	65	370	428	OJU87965.1 MAG: single-stranded DNA exonuclease RecJ [Candidatus Saccharibacteria bacterium 49-20]	diamond	177	110	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 49-20
28182386	28182386	PRJNA520845_P_NODE_109426_length_356_cov_1.063604_g107927_i0	PRJNA520845	109426	356	1.063604	3.78643024	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	58.9	2.39e-7	NR	MFO0862527.1	2026720	g107927	i0	72.7	1.26404494382022	33	9	27.8	0	257	355	5	37	MFO0862527.1 dihydrofolate reductase [Candidatus Saccharibacteria bacterium]	diamond	450	58.9	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28340572	28340572	PRJNA520845_P_NODE_223806_length_249_cov_0.875000_g222307_i0	PRJNA520845	223806	249	0.875	2.17875	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	115	1.03e-28	NR	MBN9397613.1	2026720	g222307	i0	72.6	2.63855421686747	73	20	88	0	245	27	287	359	MBN9397613.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	657	115	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28498606	28498606	PRJNA520845_P_NODE_215267_length_251_cov_0.865169_g213768_i0	PRJNA520845	215267	251	0.865169	2.17157419	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	46.2	0.00214	NR	MCA9324640.1	2026720	g213768	i0	33.7	0.99203187250996006	83	52	95.6	2	241	2	52	134	MCA9324640.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	249	46.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28624933	28624933	PRJNA520845_P_NODE_214107_length_251_cov_0.865169_g212608_i0	PRJNA520845	214107	251	0.865169	2.17157419	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	50.1	1.09e-4	NR	MDB5186846.1	2026720	g212608	i0	42.5	1.79282868525896	73	41	86.1	1	28	243	635	707	MDB5186846.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	450	50.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29193209	29193209	PRJNA520845_P_NODE_185709_length_273_cov_1.540000_g184210_i0	PRJNA520845	185709	273	1.54	4.2042	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	145	4.1199999999999997e-38	NR	MDB5179892.1	2026720	g184210	i0	80	0.989010989010989	90	18	98.9	0	272	3	172	261	MDB5179892.1 rane protein of unknown function [Candidatus Saccharibacteria bacterium]	diamond	270	145	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29445427	29445427	PRJNA520845_P_NODE_173010_length_283_cov_1.466667_g171511_i0	PRJNA520845	173010	283	1.466667	4.15066761	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	56.6	2.24e-7	NR	MBN9398120.1	2026720	g171511	i0	38.3	0.858657243816254	81	48	83.7	1	39	275	26	106	MBN9398120.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	243	56.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29634736	29634736	PRJNA520845_P_NODE_232530_length_248_cov_0.880000_g231031_i0	PRJNA520845	232530	248	0.88	2.1824	Candidatus Saccharibacteria bacterium 49-2	1895829	Bacteria	Bacteria	45.4	0.00434	NR	OJU87768.1	1895829	g231031	i0	63.6	0.399193548387097	33	12	39.9	0	101	3	84	116	OJU87768.1 MAG: cardiolipin synthase [Candidatus Saccharibacteria bacterium 49-20]	diamond	99	45.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 49-20
29792778	29792778	PRJNA520845_P_NODE_164551_length_290_cov_1.253456_g163052_i0	PRJNA520845	164551	290	1.253456	3.6350224	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	72.8	1.95e-13	NR	MCA9309021.1	2026720	g163052	i0	46.9	0.837931034482759	81	33	83.8	2	47	289	4	74	MCA9309021.1 ferritin-like domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	243	72.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30582595	30582595	PRJNA520845_P_NODE_230973_length_248_cov_0.880000_g229474_i0	PRJNA520845	230973	248	0.88	2.1824	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	155	2.49e-44	NR	MBN9398111.1	2026720	g229474	i0	82.9	0.991935483870968	82	14	99.2	0	247	2	226	307	MBN9398111.1 LLM class flavin-dependent oxidoreductase [Candidatus Saccharibacteria bacterium]	diamond	246	155	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30930360	30930360	PRJNA520845_P_NODE_199154_length_262_cov_1.629630_g197655_i0	PRJNA520845	199154	262	1.62963	4.2696306	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	120	2.94e-29	NR	MCD1275669.1	2725942	g197655	i0	65.5	0.99618320610687	87	30	99.6	0	262	2	119	205	MCD1275669.1 glycosyltransferase [Candidatus Nanogingivalaceae bacterium]	diamond	261	120	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
31735932	31735932	PRJNA520845_P_NODE_166397_length_288_cov_2.451163_g164898_i0	PRJNA520845	166397	288	2.451163	7.05934944	Bacteria	2	Bacteria	Bacteria	68.6	5.48e-12	NR	AKM80661.1	1619070	g164898	i0	69.4	3.60416666666667	49	15	51	0	140	286	2	50	AKM80661.1 MAG: pilin domain-containing protein [Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17]	diamond	1038	68.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
32100425	32100425	PRJNA520845_P_NODE_254058_length_243_cov_1.347059_g252559_i0	PRJNA520845	254058	243	1.347059	3.27335337	Candidatus Microsaccharimonas sp.	3069365	Bacteria	Bacteria	127	5.83e-34	NR	HEY8886330.1	3069365	g252559	i0	77.2	4.87654320987654	79	18	97.5	0	238	2	130	208	HEY8886330.1 hypothetical protein [Candidatus Microsaccharimonas sp.]	diamond	1185	127	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Microsaccharimonas	Candidatus Microsaccharimonas sp.
32195392	32195392	PRJNA520845_P_NODE_227518_length_249_cov_0.875000_g226019_i0	PRJNA520845	227518	249	0.875	2.17875	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	47.4	9.31e-4	NR	NCO10692.1	2026720	g226019	i0	35.5	1.86746987951807	76	44	86.7	2	9	224	270	344	NCO10692.1 prepilin-type N-terminal cleavage/methylation domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	465	47.4	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);;