metadata: contig_metadata: 26 rows where bioproject = "PRJNA814235", tax_clade = "Bacteria candidate phyla" and tax

26 rows where bioproject = "PRJNA814235", 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
4643797	4643797	PRJNA814235_P_NODE_113024_length_203_cov_1.993976_g111629_i0	PRJNA814235	113024	203	1.993976	4.04777128	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	100	6.23e-17	NTclustered	gi\|2874254031\|emb\|OY970356.1\|	179883	g111629	i0	90.667	0.369458128078818	75	7	37	0	128	202	367273	367347	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05684.bin.c.4 genome assembly, chromosome: 1	blastn	75	100	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
4645760	4645760	PRJNA814235_P_NODE_24684_length_384_cov_45.242075_g23314_i0	PRJNA814235	24684	384	45.242075	173.729568	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	632	1.0299999999999998e-176	NTclustered	gi\|1958122490\|gb\|CP065015.1\|	2026720	g23314	i0	96.354	140.473958333333	384	14	100	0	1	384	511198	511581	Candidatus Saccharibacteria bacterium isolate Skiv_18-Q3-R9-52_BAT3C.188_fly chromosome, complete genome	blastn	53942	632	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
7195683	7195683	PRJNA814235_P_NODE_31906_length_338_cov_9.235880_g30520_i0	PRJNA814235	31906	338	9.23588	31.2172744	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	442	1.6199999999999995e-119	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g30520	i0	90.294	69.0798816568047	340	30	100	3	1	338	666709	667047	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	23349	442	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
12295845	12295845	PRJNA814235_P_NODE_174070_length_156_cov_2.453782_g172675_i0	PRJNA814235	174070	156	2.453782	3.82789992	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	250	4.25e-62	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g172675	i0	95.513	64.0448717948718	156	7	100	0	1	156	139585	139430	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	9991	250	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
12295985	12295985	PRJNA814235_P_NODE_180850_length_152_cov_2.808696_g179455_i0	PRJNA814235	180850	152	2.808696	4.26921792	Bacteria	2	Bacteria	Bacteria	103	2.9299999999999998e-24	NR	AKM80527.1	1619070	g179455	i0	100	2.96052631578947	50	0	98.7	0	150	1	576	625	AKM80527.1 MAG: ATP-dependent chaperone ClpB, ATP-dependent Clp protease ATP-binding subunit ClpB [Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17]	diamond	450	103	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
27180636	27180636	PRJNA814235_P_NODE_94642_length_203_cov_2.789157_g93247_i0	PRJNA814235	94642	203	2.789157	5.66198871	Candidatus Saccharibacteria bacterium 32-49-1	1970478	Bacteria	Bacteria	50.4	1.92e-5	NR	OYW85676.1	1970478	g93247	i0	100	0.354679802955665	24	0	35.5	0	1	72	96	119	OYW85676.1 MAG: ketose-bisphosphate aldolase, partial [Candidatus Saccharibacteria bacterium 32-49-10]	diamond	72	50.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 32-49-10
27189410	27189410	PRJNA814235_P_NODE_106902_length_203_cov_2.162651_g105507_i0	PRJNA814235	106902	203	2.162651	4.3901815300000004	Candidatus Microsaccharimonas	2959523	Bacteria	Bacteria	54.3	5.08e-7	NR	MDB5179716.1	2026720	g105507	i0	100	1.10837438423645	25	0	36.9	0	203	129	43	67	MDB5179716.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	225	54.3	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27338964	27338964	PRJNA814235_P_NODE_115203_length_203_cov_1.933735_g113808_i0	PRJNA814235	115203	203	1.933735	3.92548205	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	47	6.83e-4	NR	MCA9347813.1	2026720	g113808	i0	91.7	0.354679802955665	24	2	35.5	0	199	128	21	44	MCA9347813.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	72	47	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27821408	27821408	PRJNA814235_P_NODE_94764_length_203_cov_2.777108_g93369_i0	PRJNA814235	94764	203	2.777108	5.63752924	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	55.1	9.83e-7	NR	MDO4684769.1	2026720	g93369	i0	100	0.738916256157635	25	0	36.9	0	129	203	103	127	MDO4684769.1 DNA gyrase subunit A [Candidatus Saccharibacteria bacterium]	diamond	150	55.1	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27970299	27970299	PRJNA814235_P_NODE_116785_length_203_cov_1.885542_g115390_i0	PRJNA814235	116785	203	1.885542	3.82765026	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	48.9	1.44e-4	NR	MBC7565309.1	2026720	g115390	i0	92	0.369458128078818	25	2	36.9	0	201	127	102	126	MBC7565309.1 UDP-N-acetylmuramoyl-L-alanine--D-glutamate ligase [Candidatus Saccharibacteria bacterium]	diamond	75	48.9	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
28105250	28105250	PRJNA814235_P_NODE_119825_length_203_cov_1.740964_g118430_i0	PRJNA814235	119825	203	1.740964	3.53415692	Pseudomonadati	3379134	Bacteria	Bacteria	52.8	5.88e-6	NR	OJU87604.1	1895829	g118430	i0	100	2.95566502463054	25	0	36.9	0	202	128	9	33	OJU87604.1 MAG: ketose-bisphosphate aldolase [Candidatus Saccharibacteria bacterium 49-20]	diamond	600	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 49-20
28444152	28444152	PRJNA814235_P_NODE_199846_length_150_cov_3.044248_g198451_i0	PRJNA814235	199846	150	3.044248	4.566372	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	73.6	1.04e-13	NR	HEX5797430.1	2973664	g198451	i0	65.3	2.94	49	17	98	0	149	3	55	103	HEX5797430.1 bifunctional phosphoglucose/phosphomannose isomerase [Candidatus Saccharimonadales bacterium]	diamond	441	73.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
29075658	29075658	PRJNA814235_P_NODE_180128_length_152_cov_4.634783_g178733_i0	PRJNA814235	180128	152	4.634783	7.04487016	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	89.7	1.69e-19	NR	MBA2279206.1	2026720	g178733	i0	72.1	1.20394736842105	61	5	96.7	1	149	3	229	289	MBA2279206.1 LysM peptidoglycan-binding domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	183	89.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29170300	29170300	PRJNA814235_P_NODE_106069_length_203_cov_2.192771_g104674_i0	PRJNA814235	106069	203	2.192771	4.45132513	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	60.5	7.84e-9	NR	MBH1980582.1	2026720	g104674	i0	51.9	1.13793103448276	77	27	99	1	203	3	54	130	MBH1980582.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	231	60.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29170352	29170352	PRJNA814235_P_NODE_184229_length_151_cov_4.210526_g182834_i0	PRJNA814235	184229	151	4.210526	6.35789426	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	41.6	0.0266	NR	MBA2279203.1	2026720	g182834	i0	90.9	0.437086092715232	22	2	43.7	0	149	84	77	98	MBA2279203.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	66	41.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29422536	29422536	PRJNA814235_P_NODE_120369_length_203_cov_1.692771_g118974_i0	PRJNA814235	120369	203	1.692771	3.43632513	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	45.8	0.00179	NR	MDB5183554.1	2026720	g118974	i0	76	0.369458128078818	25	6	36.9	0	202	128	460	484	MDB5183554.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	75	45.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29738233	29738233	PRJNA814235_P_NODE_108370_length_203_cov_2.114458_g106975_i0	PRJNA814235	108370	203	2.114458	4.29234974	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	42.4	0.0184	NR	RTK93550.1	2026720	g106975	i0	78.3	0.339901477832512	23	5	34	0	71	3	2	24	RTK93550.1 MAG: hypothetical protein EKI60_05710 [Candidatus Saccharibacteria bacterium]	diamond	69	42.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29738304	29738304	PRJNA814235_P_NODE_57010_length_252_cov_2.269767_g55616_i0	PRJNA814235	57010	252	2.269767	5.71981284	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	58.9	3.96e-8	NR	HMR73148.1	2026720	g55616	i0	58.5	1.46428571428571	41	17	48.8	0	251	129	129	169	HMR73148.1 polysaccharide deacetylase family protein [Candidatus Saccharibacteria bacterium]	diamond	369	58.9	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29959584	29959584	PRJNA814235_P_NODE_180191_length_152_cov_4.269565_g178796_i0	PRJNA814235	180191	152	4.269565	6.4897388	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	43.5	0.00574	NR	MCA9331806.1	2026720	g178796	i0	73.9	0.453947368421053	23	6	45.4	0	78	10	120	142	MCA9331806.1 glycosyltransferase family 4 protein [Candidatus Saccharibacteria bacterium]	diamond	69	43.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30559646	30559646	PRJNA814235_P_NODE_111213_length_203_cov_2.036145_g109818_i0	PRJNA814235	111213	203	2.036145	4.13337435	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	62.4	1.62e-9	NR	HEY5695784.1	2973664	g109818	i0	44.8	4.95073891625616	67	22	99	1	203	3	85	136	HEY5695784.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	1005	62.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
30686167	30686167	PRJNA814235_P_NODE_197833_length_150_cov_3.734513_g196438_i0	PRJNA814235	197833	150	3.734513	5.6017695	Candidatus Nanosynbacter lyticus	2093824	Bacteria	Bacteria	73.9	9.94e-14	NR	WP_039327669.1	2093824	g196438	i0	48.3	3.56	89	6	98	1	149	3	287	375	WP_039327669.1 exodeoxyribonuclease I [Candidatus Nanosynbacter lyticus]	diamond	534	73.9	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter lyticus
30717765	30717765	PRJNA814235_P_NODE_105374_length_203_cov_2.216867_g103979_i0	PRJNA814235	105374	203	2.216867	4.50024001	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	55.8	5.14e-7	NR	MBC7512474.1	2026720	g103979	i0	100	0.738916256157635	25	0	36.9	0	75	1	264	288	MBC7512474.1 serine hydroxymethyltransferase [Candidatus Saccharibacteria bacterium]	diamond	150	55.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30852949	30852949	PRJNA814235_P_NODE_122174_length_202_cov_2.884848_g120779_i0	PRJNA814235	122174	202	2.884848	5.82739296	Bacteria	2	Bacteria	Bacteria	52.4	8.64e-6	NR	OJU87457.1	1895829	g120779	i0	100	6.31188118811881	25	0	37.1	0	128	202	307	331	OJU87457.1 MAG: pyruvate kinase [Candidatus Saccharibacteria bacterium 49-20]	diamond	1275	52.4	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 49-20
30875888	30875888	PRJNA814235_P_NODE_193454_length_151_cov_2.675439_g192059_i0	PRJNA814235	193454	151	2.675439	4.03991289	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	52.8	3.09e-6	NR	MBR3169301.1	2026720	g192059	i0	92.3	2.56291390728477	26	2	51.7	0	2	79	269	294	MBR3169301.1 polysaccharide biosynthesis C-terminal domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	387	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31508248	31508248	PRJNA814235_P_NODE_115076_length_203_cov_1.933735_g113681_i0	PRJNA814235	115076	203	1.933735	3.92548205	Candidatus Nanosyncoccus sp.	3048693	Bacteria	Bacteria	51.2	1.39e-5	NR	MFC2702669.1	3048693	g113681	i0	38.4	1.46305418719212	99	29	99	1	201	1	51	149	MFC2702669.1 HdeD family acid-resistance protein [Candidatus Nanosyncoccus sp.]	diamond	297	51.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanosyncoccales	Candidatus Nanosyncoccaceae	Candidatus Nanosyncoccus	Candidatus Nanosyncoccus sp.
31982454	31982454	PRJNA814235_P_NODE_11198_length_566_cov_3.638941_g10000_i0	PRJNA814235	11198	566	3.638941	20.59640606	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	49.3	0.00432	NR	HSW87828.1	2973664	g10000	i0	36.2	0.826855123674912	69	44	36.6	0	319	113	1920	1988	HSW87828.1 FG-GAP-like repeat-containing protein [Candidatus Saccharimonadales bacterium]	diamond	468	49.3	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);;