metadata: contig_metadata: 22 rows where bioproject = "PRJNA1143173", tax_clade = "Bacteria candidate phyla" and tax

22 rows where bioproject = "PRJNA1143173", 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
4860852	4860852	PRJNA1143173_P_NODE_30804_length_255_cov_6.346154_g30778_i0	PRJNA1143173	30804	255	6.346154	16.1826927	Candidatus Nanosynsacchari	2789662	Bacteria	Bacteria	167	2.95e-46	NR	WP_129693694.1	1986206	g30778	i0	100	3	85	0	100	0	255	1	274	358	WP_129693694.1 type I DNA topoisomerase [Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1]	diamond	765	167	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Nanosynsacchari	Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1
6135729	6135729	PRJNA1143173_P_NODE_43565_length_205_cov_4.356061_g43539_i0	PRJNA1143173	43565	205	4.356061	8.92992505	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	117	1.54e-29	NR	HVP38869.1	2973664	g43539	i0	90.8	1.94634146341463	65	6	95.1	0	205	11	283	347	HVP38869.1 NADH:flavin oxidoreductase/NADH oxidase [Candidatus Saccharimonadales bacterium]	diamond	399	117	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
16863386	16863386	PRJNA1143173_P_NODE_28754_length_261_cov_4.787234_g28728_i0	PRJNA1143173	28754	261	4.787234	12.49468074	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	470	5.539999999999998e-128	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g28728	i0	99.234	92.8850574712644	261	1	100	1	1	261	665730	665471	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	24243	470	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
19412446	19412446	PRJNA1143173_P_NODE_35976_length_240_cov_7.491018_g35950_i0	PRJNA1143173	35976	240	7.491018	17.9784432	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	137	2.26e-38	NR	MBB1567613.1	2026720	g35950	i0	95	1	80	4	100	0	1	240	28	107	MBB1567613.1 A/G-specific adenine glycosylase [Candidatus Saccharibacteria bacterium]	diamond	240	137	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
26880754	26880754	PRJNA1143173_P_NODE_44021_length_201_cov_9.906250_g43995_i0	PRJNA1143173	44021	201	9.90625	19.9115625	Candidatus Chaera renei	2506947	Bacteria	Bacteria	101	3.88e-23	NR	RWZ79406.1	2506947	g43995	i0	83.6	1	67	11	100	0	1	201	564	630	RWZ79406.1 MAG: cation-translocating P-type ATPase [Candidatus Chaera renei]	diamond	201	101	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Chaera	Candidatus Chaera renei
28712686	28712686	PRJNA1143173_P_NODE_36527_length_239_cov_2.138554_g36501_i0	PRJNA1143173	36527	239	2.138554	5.11114406	Candidatus Saccharibacteria bacterium 49-2	1895829	Bacteria	Bacteria	145	1.34e-38	NR	OJU88067.1	1895829	g36501	i0	91.1	0.99163179916318	79	7	99.2	0	3	239	594	672	OJU88067.1 MAG: polyribonucleotide nucleotidyltransferase [Candidatus Saccharibacteria bacterium 49-20]	diamond	237	145	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 49-20
29112224	29112224	PRJNA1143173_P_NODE_38708_length_231_cov_2.911392_g38682_i0	PRJNA1143173	38708	231	2.911392	6.72531552	Bacteria	2	Bacteria	Bacteria	132	3.23e-36	NR	MDB5165764.1	2026720	g38682	i0	85.1	4.80519480519481	74	11	96.1	0	2	223	1	74	MDB5165764.1 putative Ribosomal small subunit methyltransferase [Candidatus Saccharibacteria bacterium]	diamond	1110	132	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
29249227	29249227	PRJNA1143173_P_NODE_22229_length_280_cov_5.130435_g22203_i0	PRJNA1143173	22229	280	5.130435	14.365218	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	153	8.11e-43	NR	HYH36161.1	2973664	g22203	i0	76.3	2.98928571428571	93	22	99.6	0	279	1	36	128	HYH36161.1 PAS domain-containing sensor histidine kinase [Candidatus Saccharimonadales bacterium]	diamond	837	153	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
29280785	29280785	PRJNA1143173_P_NODE_9469_length_310_cov_4.987342_g9443_i0	PRJNA1143173	9469	310	4.987342	15.4607602	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	68.6	3.44e-11	NR	MCA9325828.1	2026720	g9443	i0	43.2	1.55806451612903	81	43	78.4	1	66	308	136	213	MCA9325828.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	483	68.6	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
30281035	30281035	PRJNA1143173_P_NODE_30952_length_255_cov_3.038462_g30926_i0	PRJNA1143173	30952	255	3.038462	7.7480781	Bacteria	2	Bacteria	Bacteria	89.7	1.2e-18	NR	OJU87935.1	1895829	g30926	i0	70.3	2.69411764705882	74	22	87.1	0	253	32	37	110	OJU87935.1 MAG: hypothetical protein BGO17_03035 [Candidatus Saccharibacteria bacterium 49-20]	diamond	687	89.7	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 49-20
30501789	30501789	PRJNA1143173_P_NODE_26473_length_268_cov_3.000000_g26447_i0	PRJNA1143173	26473	268	3	8.04	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	75.9	1.12e-14	NR	RKW02559.1	1917697	g26447	i0	100	0.850746268656716	38	0	42.5	0	114	1	124	161	RKW02559.1 MAG: hypothetical protein D8B38_02965, partial [Candidatus Saccharimonas sp.]	diamond	228	75.9	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
30512717	30512717	PRJNA1143173_P_NODE_35233_length_243_cov_1.388235_g35207_i0	PRJNA1143173	35233	243	1.388235	3.37341105	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	80.5	1.97e-15	NR	HSX07903.1	2973664	g35207	i0	60.7	0.691358024691358	56	22	69.1	0	28	195	10	65	HSX07903.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	168	80.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
30659733	30659733	PRJNA1143173_P_NODE_33873_length_247_cov_0.885057_g33847_i0	PRJNA1143173	33873	247	0.885057	2.18609079	Bacteria	2	Bacteria	Bacteria	145	4.759999999999998e-42	NR	OYX37775.1	1970480	g33847	i0	82.5	5.82995951417004	80	14	97.2	0	245	6	128	207	OYX37775.1 MAG: hypothetical protein B7Z00_02970 [Candidatus Saccharibacteria bacterium 32-50-10]	diamond	1440	146	0.993150684931507	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 32-50-10
30955311	30955311	PRJNA1143173_P_NODE_12174_length_309_cov_6.559322_g12148_i0	PRJNA1143173	12174	309	6.559322	20.26830498	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	46.2	0.00481	NR	TAH35724.1	2026720	g12148	i0	57.8	0.436893203883495	45	17	41.7	1	289	161	237	281	TAH35724.1 MAG: hypothetical protein EYC59_02060 [Candidatus Saccharibacteria bacterium]	diamond	135	46.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31018338	31018338	PRJNA1143173_P_NODE_22575_length_279_cov_4.878641_g22549_i0	PRJNA1143173	22575	279	4.878641	13.61140839	Candidatus Nanoperiomorbus periodonticus	2171989	Bacteria	Bacteria	145	7.64e-39	NR	WP_129620707.1	2171989	g22549	i0	93.4	0.817204301075269	76	5	81.7	0	228	1	1	76	WP_129620707.1 RelA/SpoT family protein [Candidatus Nanoperiomorbus periodonticus]	diamond	228	145	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanoperiomorbia	Candidatus Nanoperiomorbales	Candidatus Nanoperiomorbaceae	Candidatus Nanoperiomorbus	Candidatus Nanoperiomorbus periodonticus
31650490	31650490	PRJNA1143173_P_NODE_8557_length_310_cov_6.459916_g8531_i0	PRJNA1143173	8557	310	6.459916	20.0257396	Candidatus Saccharibacteria bacterium	2026720	Bacteria	Bacteria	64.3	1.8e-9	NR	PID29522.1	2026720	g8531	i0	51	0.474193548387097	49	24	47.4	0	162	308	289	337	PID29522.1 MAG: hypothetical protein CR983_03855 [Candidatus Saccharibacteria bacterium]	diamond	147	64.3	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31808831	31808831	PRJNA1143173_P_NODE_35477_length_242_cov_3.514793_g35451_i0	PRJNA1143173	35477	242	3.514793	8.50579906	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	161	2.11e-48	NR	MBB1579691.1	2026720	g35451	i0	100	1.98347107438017	80	0	99.2	0	1	240	22	101	MBB1579691.1 redox-regulated ATPase YchF [Candidatus Saccharibacteria bacterium]	diamond	480	161	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31903656	31903656	PRJNA1143173_P_NODE_44817_length_196_cov_6.300813_g44791_i0	PRJNA1143173	44817	196	6.300813	12.34959348	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	116	7.79e-29	NR	HMH70079.1	2973664	g44791	i0	83.1	1.98979591836735	65	11	99.5	0	2	196	242	306	HMH70079.1 tryptophanase [Candidatus Saccharimonadales bacterium]	diamond	390	116	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
32252075	32252075	PRJNA1143173_P_NODE_18598_length_291_cov_3.922018_g18572_i0	PRJNA1143173	18598	291	3.922018	11.41307238	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	107	1.69e-24	NR	MDO4684606.1	2026720	g18572	i0	51.9	1.07216494845361	104	39	95.9	1	289	11	586	689	MDO4684606.1 hypothetical protein [Candidatus Saccharibacteria bacterium]	diamond	312	107	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
32315407	32315407	PRJNA1143173_P_NODE_41939_length_215_cov_4.640845_g41913_i0	PRJNA1143173	41939	215	4.640845	9.97781675	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	119	6.62e-30	NR	HEU4715355.1	2973664	g41913	i0	77.1	2.94418604651163	70	16	97.7	0	214	5	255	324	HEU4715355.1 Asp-tRNA(Asn)/Glu-tRNA(Gln) amidotransferase subunit GatA [Candidatus Saccharimonadales bacterium]	diamond	633	119	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
32441912	32441912	PRJNA1143173_P_NODE_20939_length_284_cov_4.464455_g20913_i0	PRJNA1143173	20939	284	4.464455	12.6790522	Candidatus Saccharibacteria bacterium 49-2	1895829	Bacteria	Bacteria	156	1.7500000000000001e-44	NR	OJU87444.1	1895829	g20913	i0	84	0.992957746478873	94	15	99.3	0	1	282	59	152	OJU87444.1 MAG: hypothetical protein BGO17_00360 [Candidatus Saccharibacteria bacterium 49-20]	diamond	282	156	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium 49-20
32536743	32536743	PRJNA1143173_P_NODE_34239_length_245_cov_9.668605_g34213_i0	PRJNA1143173	34239	245	9.668605	23.68808225	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	99.8	1.2799999999999999e-23	NR	MDO4684306.1	2026720	g34213	i0	69.7	1.55510204081633	66	20	80.8	0	243	46	70	135	MDO4684306.1 excalibur calcium-binding domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	381	99.8	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);;