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

22 rows where bioproject = "PRJNA493828", 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
474980	474980	PRJNA493828_P_NODE_44521_length_223_cov_4.973333_g44102_i0	PRJNA493828	44521	223	4.973333	11.09053259	Candidatus Saccharimonadia bacterium	2890869	Bacteria	Bacteria	311	2.9600000000000003e-80	NTclustered	gi\|2874254002\|emb\|OY970327.1\|	2890869	g44102	i0	92.593	67.5605381165919	216	16	97	0	8	223	678170	678385	MAG: Candidatus Saccharimonadia bacterium isolate MFD01275.bin.c.7 genome assembly, chromosome: 1	blastn	15066	311	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia				Candidatus Saccharimonadia bacterium
1106386	1106386	PRJNA493828_P_NODE_23441_length_275_cov_7.430693_g23022_i0	PRJNA493828	23441	275	7.430693	20.43440575	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	436	5.969999999999999e-118	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g23022	i0	95.62	82.9454545454546	274	9	99	3	1	272	694966	694694	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	22810	436	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis
5578321	5578321	PRJNA493828_P_NODE_31485_length_252_cov_1.720670_g31066_i0	PRJNA493828	31485	252	1.72067	4.3360884	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	342	1.21e-89	NTclustered	gi\|2874254031\|emb\|OY970356.1\|	179883	g31066	i0	92.5	85.2738095238095	240	17	95	1	9	248	599309	599547	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05684.bin.c.4 genome assembly, chromosome: 1	blastn	21489	342	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
6852535	6852535	PRJNA493828_P_NODE_41226_length_236_cov_3.049080_g40807_i0	PRJNA493828	41226	236	3.04908	7.1958288	Candidatus Saccharibacteria bacterium oral taxon 488	713059	Bacteria	Bacteria	348	2.41e-91	NTclustered	gi\|1842065531\|gb\|CP040002.1\|	713059	g40807	i0	93.562	330.733050847458	233	15	99	0	4	236	150746	150978	Candidatus Saccharibacteria bacterium oral taxon 488 strain AC002 chromosome, complete genome	blastn	78053	348	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
8759697	8759697	PRJNA493828_P_NODE_48227_length_198_cov_6.656000_g47808_i0	PRJNA493828	48227	198	6.656	13.17888	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	324	3.29e-84	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g47808	i0	98.895	327.166666666667	181	2	91	0	4	184	144166	144346	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	64779	324	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
10034908	10034908	PRJNA493828_P_NODE_19408_length_289_cov_6.435185_g18989_i0	PRJNA493828	19408	289	6.435185	18.59768465	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	490	4.78e-134	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g18989	i0	97.232	137.017301038062	289	8	100	0	1	289	140124	139836	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	39598	490	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
11953395	11953395	PRJNA493828_P_NODE_26830_length_265_cov_1.463542_g26411_i0	PRJNA493828	26830	265	1.463542	3.8783863	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	372	1.64e-98	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g26411	i0	92.636	61.411320754717	258	19	97	0	5	262	799583	799840	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	16274	372	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
13228729	13228729	PRJNA493828_P_NODE_4251_length_527_cov_3.792952_g3865_i0	PRJNA493828	4251	527	3.792952	19.98885704	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	832	0	NTclustered	gi\|1958075319\|gb\|CP064995.1\|	2026720	g3865	i0	96.614	76.753320683112	502	16	95	1	25	525	693970	693469	Candidatus Saccharibacteria bacterium isolate Hjor_18-Q3-R7-51_MAXAC.102_uni chromosome, complete genome	blastn	40449	832	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
17052282	17052282	PRJNA493828_P_NODE_46914_length_205_cov_5.227273_g46495_i0	PRJNA493828	46914	205	5.227273	10.71590965	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	233	5.96e-57	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g46495	i0	89.418	81.8390243902439	189	15	91	5	6	191	850728	850542	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	16777	233	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
23427309	23427309	PRJNA493828_P_NODE_40499_length_239_cov_2.120482_g40080_i0	PRJNA493828	40499	239	2.120482	5.06795198	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	298	2.5e-76	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g40080	i0	91.031	5.60251046025105	223	17	92	2	2	221	798406	798184	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	1339	298	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
23427358	23427358	PRJNA493828_P_NODE_44119_length_226_cov_2.836601_g43700_i0	PRJNA493828	44119	226	2.836601	6.41071826	Candidatus Saccharibacteria bacterium RAAC3_TM7_1	1394711	Bacteria	Bacteria	110	1.18e-19	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g43700	i0	76.415	4.16814159292035	212	44	92	4	1	209	450589	450797	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	942	110	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
24058510	24058510	PRJNA493828_P_NODE_3859_length_550_cov_3.813417_g3481_i0	PRJNA493828	3859	550	3.813417	20.9737935	Candidatus Saccharimonadia	2093818	Bacteria	Bacteria	881	0	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g3481	i0	95.956	98.6454545454545	544	21	99	1	8	550	692525	691982	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	54255	881	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis
27393105	27393105	PRJNA493828_P_NODE_12263_length_331_cov_4.689922_g11844_i0	PRJNA493828	12263	331	4.689922	15.52364182	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	49.3	4.83e-4	NR	MCG5105720.1	2026720	g11844	i0	39.7	0.706948640483384	78	45	69.8	2	254	24	14	90	MCG5105720.1 phage tail tip lysozyme [Candidatus Saccharibacteria bacterium]	diamond	234	49.3	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27456310	27456310	PRJNA493828_P_NODE_38623_length_242_cov_1.763314_g38204_i0	PRJNA493828	38623	242	1.763314	4.26721988	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	166	1.89e-50	NR	MBN9398527.1	2026720	g38204	i0	96.3	0.991735537190083	80	3	99.2	0	2	241	95	174	MBN9398527.1 NUDIX hydrolase [Candidatus Saccharibacteria bacterium]	diamond	240	166	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27582333	27582333	PRJNA493828_P_NODE_31764_length_251_cov_2.679775_g31345_i0	PRJNA493828	31764	251	2.679775	6.72623525	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	119	1.02e-30	NR	MBC7546575.1	2026720	g31345	i0	71.1	0.99203187250996006	83	24	99.2	0	1	249	123	205	MBC7546575.1 M15 family metallopeptidase [Candidatus Saccharibacteria bacterium]	diamond	249	119	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
27913579	27913579	PRJNA493828_P_NODE_27745_length_262_cov_2.222222_g27326_i0	PRJNA493828	27745	262	2.222222	5.82222164	Bacteria	2	Bacteria	Bacteria	124	2.62e-32	NR	OGL22419.1	1802132	g27326	i0	69.4	5.95419847328244	85	26	97.3	0	2	256	229	313	OGL22419.1 MAG: hypothetical protein A2707_03795 [Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_01_FULL_45_15]	diamond	1560	124	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RIFCSPHIGHO2_01_FULL_45_15
28213616	28213616	PRJNA493828_P_NODE_28806_length_259_cov_2.311828_g28387_i0	PRJNA493828	28806	259	2.311828	5.98763452	Candidatus Saccharimonadales bacterium	2973664	Bacteria	Bacteria	90.9	2.69e-21	NR	HSX29533.1	2973664	g28387	i0	51.9	0.891891891891892	77	37	89.2	0	233	3	7	83	HSX29533.1 hypothetical protein [Candidatus Saccharimonadales bacterium]	diamond	231	90.9	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales			Candidatus Saccharimonadales bacterium
28955918	28955918	PRJNA493828_P_NODE_27668_length_262_cov_2.978836_g27249_i0	PRJNA493828	27668	262	2.978836	7.80455032	Candidatus Saccharimonadaceae	2171986	Bacteria	Bacteria	178	3.2599999999999998e-52	NR	RKV95619.1	1917697	g27249	i0	98.8	2.95419847328244	86	1	98.5	0	260	3	42	127	RKV95619.1 MAG: hypothetical protein D8G53_08520, partial [Candidatus Saccharimonas sp.]	diamond	774	178	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
29098055	29098055	PRJNA493828_P_NODE_20548_length_285_cov_3.900943_g20129_i0	PRJNA493828	20548	285	3.900943	11.11768755	Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1	1986206	Bacteria	Bacteria	173	4.749999999999999e-52	NR	WP_129693356.1	1986206	g20129	i0	93.7	1	95	6	100	0	285	1	59	153	WP_129693356.1 TrmB family transcriptional regulator [Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1]	diamond	285	173	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Nanosynsacchari	Candidatus Nanosynsacchari sp. TM7_ANC_38.39_G1_1
30471774	30471774	PRJNA493828_P_NODE_28573_length_260_cov_1.304813_g28154_i0	PRJNA493828	28573	260	1.304813	3.3925138	Bacteria	2	Bacteria	Bacteria	143	1.77e-39	NR	MBN9397617.1	2026720	g28154	i0	72.1	2.97692307692308	86	24	99.2	0	258	1	177	262	MBN9397617.1 DUF916 domain-containing protein [Candidatus Saccharibacteria bacterium]	diamond	774	144	0.993055555555556	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31213874	31213874	PRJNA493828_P_NODE_19815_length_288_cov_2.041860_g19396_i0	PRJNA493828	19815	288	2.04186	5.8805568	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	181	1.01e-51	NR	MCA9335546.1	2026720	g19396	i0	97.9	1	96	2	100	0	1	288	355	450	MCA9335546.1 recombinase family protein [Candidatus Saccharibacteria bacterium]	diamond	288	181	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
31293125	31293125	PRJNA493828_P_NODE_44095_length_226_cov_3.013072_g43676_i0	PRJNA493828	44095	226	3.013072	6.80954272	Bacteria	2	Bacteria	Bacteria	106	2.4e-25	NR	MBC7868793.1	2026720	g43676	i0	68	2.98672566371681	75	24	99.6	0	226	2	73	147	MBC7868793.1 glycosyltransferase [Candidatus Saccharibacteria bacterium]	diamond	675	106	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);;