metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA1092581" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA1092581" 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
2746548	2746548	PRJNA1092581_P_NODE_114883_length_232_cov_2.905660_g114350_i0	PRJNA1092581	114883	232	2.90566	6.7411312	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	418	1.7799999999999995e-112	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g114350	i0	99.138	137.918103448276	232	2	100	0	1	232	222240	222009	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	31997	418	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
2747766	2747766	PRJNA1092581_P_NODE_46603_length_396_cov_2.693498_g46070_i0	PRJNA1092581	46603	396	2.693498	10.66625208	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	165	4.67e-36	NTclustered	gi\|1958123529\|gb\|CP065016.1\|	2026720	g46070	i0	93.75	35.5883838383838	112	3	28	4	272	381	806063	805954	Candidatus Saccharibacteria bacterium isolate Vibo_18-Q3-R45-57_BAT3C.117_fly chromosome, complete genome	blastn	14093	165	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
2748612	2748612	PRJNA1092581_P_NODE_79703_length_290_cov_1.751152_g79170_i0	PRJNA1092581	79703	290	1.751152	5.0783408	Candidatus Gracilibacteria bacterium HOT-871	1540872	Bacteria	Bacteria	525	1.32e-144	NTclustered	gi\|1275383184\|gb\|CP017714.1\|	1540872	g79170	i0	99.31	1	290	2	100	0	1	290	1092233	1091944	Candidatus Gracilibacteria bacterium HOT-871, complete genome	blastn	290	525	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium HOT-871
3569155	3569155	PRJNA1092581_P_NODE_703_length_1897_cov_4.998904_g642_i0	PRJNA1092581	703	1897	4.998904	94.82920888	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	148	2.43e-30	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g642	i0	89.344	4.00421718502899	122	8	6	5	1239	1358	419384	419266	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	7596	148	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
4023188	4023188	PRJNA1092581_P_NODE_29724_length_508_cov_7.331034_g29192_i0	PRJNA1092581	29724	508	7.331034	37.24165272	Candidatus Saccharibacteria bacterium oral taxon 955	2572087	Bacteria	Bacteria	704	0	NTclustered	gi\|1663049602\|gb\|CP040008.1\|	2572087	g29192	i0	92.555	106.755905511811	497	27	97	7	1	495	139001	139489	Candidatus Saccharibacteria bacterium oral taxon 955 strain PM004 chromosome, complete genome	blastn	54232	704	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium oral taxon 955
6121267	6121267	PRJNA1092581_P_NODE_2865_length_1338_cov_32.371542_g2654_i0	PRJNA1092581	2865	1338	32.371542	433.13123196	Bacillati	1783272	Bacteria	Bacteria	115	1.72e-20	NTclustered	gi\|1958006436\|gb\|CP064962.1\|	2030811	g2654	i0	93.506	7.29297458893871	77	5	6	0	113	189	224565	224489	MAG: Candidatus Peregrinibacteria bacterium isolate Aved_18-Q3-R54-62_BAT3C.344 chromosome, complete genome	blastn	9758	115	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota					Candidatus Peregrinibacteria bacterium
6121873	6121873	PRJNA1092581_P_NODE_83865_length_281_cov_2.836538_g83332_i0	PRJNA1092581	83865	281	2.836538	7.97067178	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	209	1.45e-49	NTclustered	gi\|2218409032\|gb\|CP089290.1\|	2899133	g83332	i0	81.022	5.88967971530249	274	42	96	9	1	269	26420	26688	Candidatus Nanosynbacter sp. HMT-352 strain TM7-001 chromosome	blastn	1655	209	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-352
8671350	8671350	PRJNA1092581_P_NODE_26087_length_544_cov_7.723992_g25557_i0	PRJNA1092581	26087	544	7.723992	42.01851648	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	708	0	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g25557	i0	93.182	78.3897058823529	484	30	89	3	56	537	692615	692133	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	42644	708	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis
10399255	10399255	PRJNA1092581_P_NODE_120749_length_219_cov_26.109589_g120216_i0	PRJNA1092581	120749	219	26.109589	57.17999991	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	244	2.98e-60	NTclustered	gi\|1958075319\|gb\|CP064995.1\|	2026720	g120216	i0	88.35	46.5114155251142	206	20	94	4	1	205	693780	693578	Candidatus Saccharibacteria bacterium isolate Hjor_18-Q3-R7-51_MAXAC.102_uni chromosome, complete genome	blastn	10186	244	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
11676457	11676457	PRJNA1092581_P_NODE_7790_length_948_cov_8.115429_g7404_i0	PRJNA1092581	7790	948	8.115429	76.93426692	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	797	0	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g7404	i0	83.053	13.6677215189873	891	137	93	13	23	906	472492	473375	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	12957	797	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
12496656	12496656	PRJNA1092581_P_NODE_112690_length_235_cov_11.191358_g112157_i0	PRJNA1092581	112690	235	11.191358	26.2996913	Candidatus Saccharimonadota	95818	Bacteria	Bacteria	278	3.19e-70	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g112157	i0	90.323	72.9957446808511	217	14	91	6	22	235	115255	115467	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	17154	278	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
12950536	12950536	PRJNA1092581_P_NODE_39171_length_437_cov_5.846154_g38638_i0	PRJNA1092581	39171	437	5.846154	25.54769298	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	477	5.879999999999999e-130	NTclustered	gi\|2258874150\|gb\|CP060230.1\|	2052152	g38638	i0	88.119	387.720823798627	404	45	92	3	16	417	383419	383821	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-34 chromosome	blastn	169434	477	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
15498159	15498159	PRJNA1092581_P_NODE_102173_length_250_cov_1.548023_g101640_i0	PRJNA1092581	102173	250	1.548023	3.8700575	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	171	5.99e-38	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g101640	i0	80.335	4.676	239	35	94	8	2	237	159579	159350	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	1169	171	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
16774177	16774177	PRJNA1092581_P_NODE_4874_length_1125_cov_15.014259_g4597_i0	PRJNA1092581	4874	1125	15.014259	168.91041375	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	813	0	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g4597	i0	82.788	192.424888888889	947	128	83	33	43	972	126700	125772	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	216478	813	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
18047777	18047777	PRJNA1092581_P_NODE_128215_length_197_cov_4.411290_g127682_i0	PRJNA1092581	128215	197	4.41129	8.6902413	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	239	1.22e-58	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g127682	i0	93.21	6.10152284263959	162	11	82	0	22	183	799861	799700	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	1202	239	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
18048036	18048036	PRJNA1092581_P_NODE_21815_length_595_cov_12.285441_g21293_i0	PRJNA1092581	21815	595	12.285441	73.09837395	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	857	0	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g21293	i0	93.728	431.660504201681	574	32	96	4	1	571	800271	800843	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	256838	857	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
18049648	18049648	PRJNA1092581_P_NODE_83975_length_281_cov_1.913462_g83442_i0	PRJNA1092581	83975	281	1.913462	5.37682822	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	189	1.8899999999999993e-43	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g83442	i0	80.556	1.88612099644128	252	44	89	3	31	281	159781	159534	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	530	189	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
21872843	21872843	PRJNA1092581_P_NODE_124558_length_208_cov_5.703704_g124025_i0	PRJNA1092581	124558	208	5.703704	11.86370432	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	307	3.52e-79	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g124025	i0	99.408	0.8125	169	1	81	0	22	190	800676	800508	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	169	307	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
23147917	23147917	PRJNA1092581_P_NODE_109779_length_240_cov_9.299401_g109246_i0	PRJNA1092581	109779	240	9.299401	22.3185624	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	292	1.17e-74	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g109246	i0	92.233	50.1083333333333	206	16	86	0	15	220	799700	799905	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	12026	292	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
23147954	23147954	PRJNA1092581_P_NODE_111399_length_237_cov_118.835366_g110866_i0	PRJNA1092581	111399	237	118.835366	281.63981742	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	300	6.88e-77	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g110866	i0	91.667	29.7974683544304	216	18	91	0	22	237	964849	964634	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	7062	300	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
24421499	24421499	PRJNA1092581_P_NODE_106000_length_245_cov_2.389535_g105467_i0	PRJNA1092581	106000	245	2.389535	5.85436075	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	278	3.35e-70	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g105467	i0	95.906	117.069387755102	171	7	70	0	1	171	883922	884092	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	28682	278	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);;