metadata: contig_metadata: 27 rows where bioproject = "PRJNA326068" and tax

27 rows where bioproject = "PRJNA326068" and tax_clade = "Bacteria candidate phyla"

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
389426	389426	PRJNA326068_P_NODE_14401_length_227_cov_105.055556_g13438_i0	PRJNA326068	14401	227	105.055556	238.47611212	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	394	2.92e-105	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g13438	i0	98.23	94	226	3	99	1	2	227	852625	852401	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	21338	394	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
389456	389456	PRJNA326068_P_NODE_4701_length_509_cov_99.620833_g3905_i0	PRJNA326068	4701	509	99.620833	507.07003997	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	544	6.74e-150	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g3905	i0	90.647	279.271119842829	417	28	81	11	1	413	963906	964315	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	142149	544	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
1664125	1664125	PRJNA326068_P_NODE_12422_length_262_cov_6.909871_g11459_i0	PRJNA326068	12422	262	6.909871	18.10386202	Candidatus Saccharibacteria bacterium RAAC3_TM7_1	1394711	Bacteria	Bacteria	374	4.49e-99	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g11459	i0	92.453	193.553435114504	265	15	100	5	1	262	453355	453093	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	50711	374	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
3619872	3619872	PRJNA326068_P_NODE_3623_length_582_cov_60.220615_g2910_i0	PRJNA326068	3623	582	60.220615	350.4839793	Bacteria	2	Bacteria	Bacteria	918	0	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g2910	i0	95.205	150.285223367698	584	23	100	5	1	582	852625	852045	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	87466	922	0.995661605206074	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
4216717	4216717	PRJNA326068_P_NODE_17544_length_189_cov_2.387500_g16581_i0	PRJNA326068	17544	189	2.3875	4.512375	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	279	6.83e-71	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g16581	i0	98.125	10.9100529100529	160	3	85	0	26	185	430236	430395	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	2062	279	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
6172078	6172078	PRJNA326068_P_NODE_19205_length_161_cov_8.053030_g18242_i0	PRJNA326068	19205	161	8.05303	12.9653783	Candidatus Southlakia	3350975	Bacteria	Bacteria	252	1.23e-62	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g18242	i0	95	81.9813664596273	160	8	99	0	1	160	451721	451562	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	13199	252	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
6767017	6767017	PRJNA326068_P_NODE_12366_length_263_cov_5.816239_g11403_i0	PRJNA326068	12366	263	5.816239	15.29670857	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	390	4.479999999999999e-104	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g11403	i0	93.536	80.8593155893536	263	16	99	1	1	262	140697	140959	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	21266	390	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
8042710	8042710	PRJNA326068_P_NODE_18907_length_166_cov_1.875912_g17944_i0	PRJNA326068	18907	166	1.875912	3.11401392	Candidatus Minusculum obligatum	1948790	Bacteria	Bacteria	222	1e-53	NTclustered	gi\|2862534883\|gb\|CP174360.1\|	1948790	g17944	i0	91.018	46.933734939759	167	11	100	4	1	166	190678	190515	MAG: Patescibacteria group bacterium UBA2103 chromosome, complete genome	blastn	7791	222	1	Bacteria	Bacteria candidate phyla	Minisyncoccota	Minisyncoccia	Candidatus Phycocordibacterales	Candidatus Phycocordibacteraceae	Candidatus Minusculum	Candidatus Minusculum obligatum
8721758	8721758	PRJNA326068_P_NODE_6487_length_426_cov_65.528967_g5579_i0	PRJNA326068	6487	426	65.528967	279.15339942	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	542	2e-149	NTclustered	gi\|1842055981\|gb\|CP040001.1\|	713059	g5579	i0	94.366	106.302816901408	355	16	95	3	1	354	153421	153070	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM006 chromosome, complete genome	blastn	45285	542	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
9317461	9317461	PRJNA326068_P_NODE_2748_length_663_cov_4.605678_g644_i1	PRJNA326068	2748	663	4.605678	30.53564514	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	505	4.22e-138	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g644	i1	86.164	286.666666666667	477	55	71	11	1	471	126788	126317	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	190060	505	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
10593133	10593133	PRJNA326068_P_NODE_19829_length_153_cov_2.822581_g18866_i0	PRJNA326068	19829	153	2.822581	4.31854893	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	222	9.029999999999999e-54	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g18866	i0	92.81	75.281045751634	153	11	100	0	1	153	429380	429228	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	11518	222	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
11868013	11868013	PRJNA326068_P_NODE_12470_length_261_cov_4.301724_g11507_i0	PRJNA326068	12470	261	4.301724	11.22749964	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	346	9.749999999999999e-91	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g11507	i0	91.373	206.758620689655	255	19	97	3	8	261	849865	850117	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	53964	346	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
11868041	11868041	PRJNA326068_P_NODE_19830_length_153_cov_2.669355_g18867_i0	PRJNA326068	19830	153	2.669355	4.08411315	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	250	4.14e-62	NTclustered	gi\|2258868658\|gb\|CP060229.1\|	2052152	g18867	i0	100	39.4444444444444	135	0	88	0	1	135	494496	494362	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-25 chromosome	blastn	6035	250	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
14418305	14418305	PRJNA326068_P_NODE_9432_length_331_cov_19.420530_g8476_i0	PRJNA326068	9432	331	19.42053	64.2819543	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	496	1.2e-135	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g8476	i0	94.19	254.861027190332	327	16	98	3	7	331	964231	963906	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	84359	496	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
15097015	15097015	PRJNA326068_P_NODE_11772_length_276_cov_2.526316_g10810_i0	PRJNA326068	11772	276	2.526316	6.97263216	Bacteria	2	Bacteria	Bacteria	176	1.44e-39	NTclustered	gi\|2874253892\|emb\|OY970067.1\|	991135	g10810	i0	89.362	26.5253623188406	141	13	51	2	5	144	4745675	4745814	MAG: uncultured candidate division NC10 bacterium isolate MFD01231.bin.c.1 genome assembly, chromosome: 1	blastn	7321	176	1	Bacteria	Bacteria candidate phyla	Candidatus Methylomirabilota					uncultured Methylomirabilota bacterium
16371754	16371754	PRJNA326068_P_NODE_14813_length_222_cov_4.538860_g13850_i0	PRJNA326068	14813	222	4.53886	10.0762692	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	289	1.3799999999999998e-73	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g13850	i0	90.498	257.085585585586	221	17	99	4	3	222	451031	450814	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	57073	289	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium RAAC3_TM7_1
16966818	16966818	PRJNA326068_P_NODE_8994_length_343_cov_1.824841_g8040_i0	PRJNA326068	8994	343	1.824841	6.25920463	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	499	9.64e-137	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g8040	i0	93.043	85.2448979591837	345	19	100	5	1	343	431199	431540	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	29239	499	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
18241040	18241040	PRJNA326068_P_NODE_11775_length_276_cov_2.408907_g10813_i0	PRJNA326068	11775	276	2.408907	6.64858332	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	359	1.34e-94	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g10813	i0	92.43	8.40579710144928	251	19	91	0	16	266	430449	430699	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	2320	359	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
19515278	19515278	PRJNA326068_P_NODE_11276_length_286_cov_2.731518_g10314_i0	PRJNA326068	11276	286	2.731518	7.81214148	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	377	3.84e-100	NTclustered	gi\|2258874150\|gb\|CP060230.1\|	2052152	g10314	i0	90.559	252.800699300699	286	25	99	1	3	286	383770	384055	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-34 chromosome	blastn	72301	377	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
20195262	20195262	PRJNA326068_P_NODE_3336_length_605_cov_74.116319_g2645_i0	PRJNA326068	3336	605	74.116319	448.40372995	Bacteria	2	Bacteria	Bacteria	953	0	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g2645	i0	95.074	241.373553719008	609	25	100	5	1	605	799872	800479	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	146031	953	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
20195277	20195277	PRJNA326068_P_NODE_8536_length_355_cov_2.748466_g7586_i0	PRJNA326068	8536	355	2.748466	9.7570543	Bacteria	2	Bacteria	Bacteria	219	3.13e-52	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g7586	i0	95.588	15.1521126760563	136	6	100	0	67	202	884086	883951	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	5379	220	0.995454545454545	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
22065870	22065870	PRJNA326068_P_NODE_1638_length_838_cov_46.529048_g1216_i0	PRJNA326068	1638	838	46.529048	389.91342224	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	568	6.769999999999999e-157	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g1216	i0	83.71	242.756563245823	620	82	73	15	227	838	799871	800479	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	203430	568	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
22746070	22746070	PRJNA326068_P_NODE_10418_length_306_cov_8.935018_g9458_i0	PRJNA326068	10418	306	8.935018	27.34115508	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	381	3.2e-101	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g9458	i0	89.474	63.718954248366	304	28	99	4	4	306	696519	696219	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	19498	381	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis
22746097	22746097	PRJNA326068_P_NODE_6898_length_409_cov_67.215789_g5974_i0	PRJNA326068	6898	409	67.215789	274.91257701	Bacteria	2	Bacteria	Bacteria	479	1.5199999999999996e-130	NTclustered	gi\|2874253873\|emb\|OY969928.1\|	179883	g5974	i0	91.884	93.5965770171149	345	25	84	2	7	350	597046	597388	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04212.bin.c.13 genome assembly, chromosome: 1	blastn	38281	481	0.995841995841996	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
24020966	24020966	PRJNA326068_P_NODE_10419_length_306_cov_8.054152_g9459_i0	PRJNA326068	10419	306	8.054152	24.64570512	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	486	6.599999999999999e-133	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g9459	i0	95.425	64.1013071895425	306	12	100	2	1	306	696522	696219	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	19615	486	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis
24615540	24615540	PRJNA326068_P_NODE_3080_length_628_cov_86.978297_g2430_i0	PRJNA326068	3080	628	86.978297	546.22370516	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	896	0	NTclustered	gi\|2874254031\|emb\|OY970356.1\|	179883	g2430	i0	93.677	91.0732484076433	601	34	95	3	31	628	601339	601938	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD05684.bin.c.4 genome assembly, chromosome: 1	blastn	57194	896	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
24615562	24615562	PRJNA326068_P_NODE_920_length_1059_cov_3.197087_g644_i0	PRJNA326068	920	1059	3.197087	33.85715133	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	839	0	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g644	i0	81.627	234.247403210576	1045	153	98	25	1	1034	126788	125772	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	248068	839	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria 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);;