metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA493244" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA493244" 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
1732141	1732141	PRJNA493244_P_NODE_682142_length_580_cov_19.289017_g659972_i0	PRJNA493244	682142	580	19.289017	111.8762986	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	1044	0	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g659972	i0	99.138	33.1155172413793	580	5	100	0	1	580	319020	319599	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	19207	1044	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
3005507	3005507	PRJNA493244_P_NODE_1039483_length_390_cov_1.583587_g1016372_i0	PRJNA493244	1039483	390	1.583587	6.1759893	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	688	0	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g1016372	i0	98.462	1	390	6	100	0	1	390	306216	305827	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	390	688	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
3006797	3006797	PRJNA493244_P_NODE_1567163_length_227_cov_5.524096_g1544038_i0	PRJNA493244	1567163	227	5.524096	12.53969792	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	257	3.99e-64	NTclustered	gi\|1958075319\|gb\|CP064995.1\|	2026720	g1544038	i0	89.268	270.607929515419	205	22	90	0	23	227	695461	695257	Candidatus Saccharibacteria bacterium isolate Hjor_18-Q3-R7-51_MAXAC.102_uni chromosome, complete genome	blastn	61428	257	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
3006798	3006798	PRJNA493244_P_NODE_1567363_length_227_cov_3.626506_g1544238_i0	PRJNA493244	1567363	227	3.626506	8.23216862	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	296	8.46e-76	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g1544238	i0	92.718	132.933920704846	206	13	90	2	1	205	668138	668342	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	30176	296	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
4282267	4282267	PRJNA493244_P_NODE_1271404_length_305_cov_7.446721_g1248280_i0	PRJNA493244	1271404	305	7.446721	22.71249905	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	494	3.93e-135	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g1248280	i0	98.227	0.924590163934426	282	5	92	0	1	282	126301	126582	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	282	494	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
4928225	4928225	PRJNA493244_P_NODE_639964_length_610_cov_5.520947_g618079_i0	PRJNA493244	639964	610	5.520947	33.6777767	root	1	Root_unresolved	Root_unresolved	60.2	3.61e-4	NTclustered	gi\|2070578010\|gb\|CP076102.2\|	2725942	g618079	i0	92.857	0.186885245901639	42	1	7	2	445	484	345040	344999	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_28_bin.11 chromosome, complete genome	blastn	114	60.2	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
5559437	5559437	PRJNA493244_P_NODE_1523105_length_237_cov_6.460227_g1499980_i0	PRJNA493244	1523105	237	6.460227	15.31073799	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	355	1.45e-93	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g1499980	i0	96.296	48.2278481012658	216	8	91	0	22	237	964849	964634	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	11430	355	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
5559678	5559678	PRJNA493244_P_NODE_1618085_length_216_cov_5.780645_g1594960_i0	PRJNA493244	1618085	216	5.780645	12.4861932	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	246	8.149999999999999e-61	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g1594960	i0	89.744	53.3425925925926	195	17	89	2	24	216	849845	850038	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	11522	246	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
6203011	6203011	PRJNA493244_P_NODE_1527365_length_236_cov_7.628571_g1504240_i0	PRJNA493244	1527365	236	7.628571	18.00342756	Bacteria	2	Bacteria	Bacteria	311	3.16e-80	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g1504240	i0	93.78	80.228813559322	209	9	88	4	23	230	849846	850051	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	18934	311	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
7477732	7477732	PRJNA493244_P_NODE_1334506_length_286_cov_13.720000_g1311382_i0	PRJNA493244	1334506	286	13.72	39.2392	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	486	6.1099999999999986e-133	NTclustered	gi\|1842054184\|gb\|CP039999.1\|	713059	g1311382	i0	100	185.059440559441	263	0	92	0	24	286	142203	142465	Candidatus Saccharibacteria bacterium oral taxon 488 strain CM001 chromosome, complete genome	blastn	52927	486	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 488
9382783	9382783	PRJNA493244_P_NODE_1088008_length_370_cov_2.035599_g1064887_i0	PRJNA493244	1088008	370	2.035599	7.5317163	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	174	7.19e-39	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g1064887	i0	78.909	31.8513513513514	275	44	73	11	38	306	818821	818555	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	11785	174	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
10659647	10659647	PRJNA493244_P_NODE_1527449_length_236_cov_5.120000_g1504324_i0	PRJNA493244	1527449	236	5.12	12.0832	Candidatus Chromulinivorax destructor	2066483	Bacteria	Bacteria	243	1.17e-59	NTclustered	gi\|1443103054\|gb\|CP025544.1\|	2066483	g1504324	i0	87.037	299.652542372881	216	26	91	2	22	236	662988	663202	Candidatus Chromulinivorax destructor strain SeV1 chromosome, complete genome	blastn	70718	243	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Chromulinivoraceae	Candidatus Chromulinivorax	Candidatus Chromulinivorax destructor
10661023	10661023	PRJNA493244_P_NODE_614929_length_629_cov_4.507042_g593260_i0	PRJNA493244	614929	629	4.507042	28.34929418	Candidatus Nanosynbacter sp. HMT-352	2899133	Bacteria	Bacteria	217	2.09e-51	NTclustered	gi\|2166692445\|gb\|CP089520.1\|	2899133	g593260	i0	89.881	0.267090620031797	168	17	27	0	26	193	292720	292887	Candidatus Nanosynbacter sp. HMT-352 strain KC1 chromosome, complete genome	blastn	168	217	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
13209472	13209472	PRJNA493244_P_NODE_1467871_length_250_cov_23.576720_g1444746_i0	PRJNA493244	1467871	250	23.57672	58.9418	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	387	5.459999999999998e-103	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g1444746	i0	97.778	0.9	225	3	90	1	22	246	218878	219100	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	225	387	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium Aalborg_AAW-1
14484922	14484922	PRJNA493244_P_NODE_1660152_length_208_cov_3.931973_g1637027_i0	PRJNA493244	1660152	208	3.931973	8.17850384	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	178	2.88e-40	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g1637027	i0	83.957	97.6682692307692	187	28	89	2	1	186	136330	136145	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	20315	178	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
17033563	17033563	PRJNA493244_P_NODE_1667614_length_208_cov_0.870748_g1644489_i0	PRJNA493244	1667614	208	0.870748	1.81115584	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	379	7.359999999999998e-101	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g1644489	i0	99.519	1	208	1	100	0	1	208	740339	740546	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	208	379	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
20857517	20857517	PRJNA493244_P_NODE_1522997_length_237_cov_29.505682_g1499872_i0	PRJNA493244	1522997	237	29.505682	69.92846634	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	311	3.18e-80	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g1499872	i0	93.78	92.3122362869198	209	9	87	4	8	214	220100	219894	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	21878	311	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
20858403	20858403	PRJNA493244_P_NODE_276057_length_1021_cov_3.447917_g261436_i0	PRJNA493244	276057	1021	3.447917	35.20323257	Candidatus Moraniibacteriota bacterium	2045217	Bacteria	Bacteria	169	9.86e-37	NTclustered	gi\|1958029560\|gb\|CP064974.1\|	2045217	g261436	i0	88.276	0.430950048971596	145	12	14	4	879	1021	946311	946452	MAG: Candidatus Moraniibacteriota bacterium isolate EsbW_18-Q3-R4-48_MAXAC.267_cln chromosome, complete genome	blastn	440	169	1	Bacteria	Bacteria candidate phyla	Candidatus Moraniibacteriota					Candidatus Moraniibacteriota bacterium
20859194	20859194	PRJNA493244_P_NODE_770257_length_524_cov_3.205184_g747679_i0	PRJNA493244	770257	524	3.205184	16.79516416	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	883	0	NTclustered	gi\|2877945256\|gb\|CP127222.1\|	2572087	g747679	i0	98.41	5.62404580152672	503	7	96	1	1	502	114885	114383	Candidatus Saccharibacteria bacterium oral taxon 955 strain 103.1.1 chromosome, complete genome	blastn	2947	883	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
22132340	22132340	PRJNA493244_P_NODE_1518678_length_238_cov_9.655367_g1495553_i0	PRJNA493244	1518678	238	9.655367	22.97977346	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	315	2.47e-81	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g1495553	i0	93.056	111.441176470588	216	14	91	1	23	238	219893	220107	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	26523	315	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
23407650	23407650	PRJNA493244_P_NODE_1338319_length_285_cov_4.571429_g1315195_i0	PRJNA493244	1338319	285	4.571429	13.02857265	Candidatus Nanosynbacter featherlites	2572088	Bacteria	Bacteria	294	3.96e-75	NTclustered	gi\|1663054866\|gb\|CP040004.1\|	2572088	g1315195	i0	85.87	0.968421052631579	276	39	97	0	10	285	763318	763043	Candidatus Nanosynbacter featherlites strain BB001 chromosome, complete genome	blastn	276	294	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter featherlites
23407842	23407842	PRJNA493244_P_NODE_1410079_length_265_cov_6.901961_g1386954_i0	PRJNA493244	1410079	265	6.901961	18.29019665	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	202	2.27e-47	NTclustered	gi\|2874253967\|emb\|OY970292.1\|	2052151	g1386954	i0	84.507	182.37358490566	213	24	79	8	36	245	719435	719229	MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1	blastn	48329	202	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota					Candidatus Levyibacteriota bacterium
23408193	23408193	PRJNA493244_P_NODE_1549219_length_231_cov_20.635294_g1526094_i0	PRJNA493244	1549219	231	20.635294	47.66752914	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	324	3.96e-84	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g1526094	i0	94.712	72.987012987013	208	11	90	0	1	208	964641	964848	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	16860	324	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
24683380	24683380	PRJNA493244_P_NODE_710740_length_561_cov_8.618000_g688414_i0	PRJNA493244	710740	561	8.618	48.34698	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	955	0	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g688414	i0	98.699	304.645276292335	538	7	96	0	1	538	798723	799260	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	170906	955	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);;