metadata: contig_metadata: 24 rows where bioproject = "PRJNA766854" and tax

24 rows where bioproject = "PRJNA766854" and tax_clade = "PVC group"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
744974	744974	PRJNA766854_P_NODE_1141_length_392_cov_3.922865_g1018_i0	PRJNA766854	1141	392	3.922865	15.3776308	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	174	7.67e-39	NTclustered	gi\|376315520\|gb\|JQ323125.1\|	120965	g1018	i0	97.087	27.8392857142857	103	3	26	0	149	251	103	1	Uncultured planctomycete clone C3 16S ribosomal RNA gene, partial sequence	blastn	10913	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
5034289	5034289	PRJNA766854_P_NODE_684_length_478_cov_4.383073_g578_i0	PRJNA766854	684	478	4.383073	20.951088940000002	Tuwongella	2051044	Bacteria	Bacteria	174	9.52e-39	NTclustered	gi\|1804913728\|emb\|LR593887.1\|	692036	g578	i0	97.087	31.68410041841	103	3	22	0	188	290	2736584	2736482	Tuwongella immobilis isolate MBLW1 genome assembly, chromosome: 1	blastn	15145	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Tuwongella	Tuwongella immobilis
5848498	5848498	PRJNA766854_P_NODE_2045_length_298_cov_4.386617_g1919_i0	PRJNA766854	2045	298	4.386617	13.07211866	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	183	9.41e-42	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g1919	i0	94.215	46.6677852348993	121	6	40	1	179	298	5636817	5636937	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	13907	183	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
5848512	5848512	PRJNA766854_P_NODE_545_length_521_cov_2.359756_g457_i0	PRJNA766854	545	521	2.359756	12.29432876	Tuwongella immobilis	692036	Bacteria	Bacteria	91.6	1.08e-13	NTclustered	gi\|1804913728\|emb\|LR593887.1\|	692036	g457	i0	94.828	12.6295585412668	58	3	12	0	6	63	2735690	2735633	Tuwongella immobilis isolate MBLW1 genome assembly, chromosome: 1	blastn	6580	91.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Tuwongella	Tuwongella immobilis
5848519	5848519	PRJNA766854_P_NODE_85_length_947_cov_4.790850_g69_i0	PRJNA766854	85	947	4.79085	45.3693495	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	156	7.1e-33	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g69	i0	92.593	18.5670538542767	108	8	24	0	398	505	7050983	7050876	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	17583	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
6309991	6309991	PRJNA766854_P_NODE_1225_length_376_cov_10.020173_g1100_i0	PRJNA766854	1225	376	10.020173	37.67585048	Gemmata	113	Bacteria	Bacteria	239	2.5600000000000003e-58	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g1100	i0	81.073	154.672872340426	317	44	83	12	65	375	3633491	3633797	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	58157	239	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
7123707	7123707	PRJNA766854_P_NODE_66_length_1007_cov_12.182004_g53_i0	PRJNA766854	66	1007	12.182004	122.67278028	Ruficoccus sp. ZRK36	2866311	Bacteria	Bacteria	542	4.97e-149	NTclustered	gi\|2080888260\|gb\|CP080649.1\|	2866311	g53	i0	80.397	141.98311817279	755	112	73	24	126	859	381788	381049	Ruficoccus sp. ZRK36 chromosome, complete genome	blastn	142977	542	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Ruficoccus	Ruficoccus sp. ZRK36
8398148	8398148	PRJNA766854_P_NODE_1387_length_353_cov_4.058642_g1262_i0	PRJNA766854	1387	353	4.058642	14.32700626	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	139	2.49e-28	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g1262	i0	96.429	50.94050991501419	84	3	24	0	270	353	2502525	2502442	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	17982	139	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
8398176	8398176	PRJNA766854_P_NODE_667_length_484_cov_6.065934_g561_i0	PRJNA766854	667	484	6.065934	29.35912056	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	158	9.719999999999999e-34	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g561	i0	93.458	40.7954545454545	107	5	22	2	172	276	7051028	7051134	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	19745	158	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
9673422	9673422	PRJNA766854_P_NODE_2088_length_295_cov_3.338346_g1962_i0	PRJNA766854	2088	295	3.338346	9.8481207	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	183	9.309999999999998e-42	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g1962	i0	94.215	47.1423728813559	121	6	41	1	176	295	5636817	5636937	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	13907	183	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
10949095	10949095	PRJNA766854_P_NODE_429_length_555_cov_2.692015_g349_i0	PRJNA766854	429	555	2.692015	14.94068325	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	141	1.13e-28	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g349	i0	88.889	78.6450450450451	117	9	21	4	195	308	3454043	3453928	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	43648	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
11409775	11409775	PRJNA766854_P_NODE_1469_length_342_cov_3.769968_g1344_i0	PRJNA766854	1469	342	3.769968	12.89329056	Gemmataceae	1914233	Bacteria	Bacteria	121	8.74e-23	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g1344	i0	95.946	25.0146198830409	74	3	22	0	266	339	3453624	3453551	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	8555	121	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
13498699	13498699	PRJNA766854_P_NODE_1211_length_379_cov_4.037143_g1087_i0	PRJNA766854	1211	379	4.037143	15.30077197	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	174	7.39e-39	NTclustered	gi\|376315520\|gb\|JQ323125.1\|	120965	g1087	i0	97.087	29.0474934036939	103	3	27	0	136	238	103	1	Uncultured planctomycete clone C3 16S ribosomal RNA gene, partial sequence	blastn	11009	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
14773885	14773885	PRJNA766854_P_NODE_672_length_482_cov_5.951435_g566_i0	PRJNA766854	672	482	5.951435	28.6859167	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	158	9.67e-34	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g566	i0	93.458	40.7157676348548	107	5	22	2	209	313	7051134	7051028	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	19625	158	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
15234469	15234469	PRJNA766854_P_NODE_212_length_690_cov_4.921331_g167_i0	PRJNA766854	212	690	4.921331	33.9571839	Tuwongella	2051044	Bacteria	Bacteria	174	1.41e-38	NTclustered	gi\|1804913728\|emb\|LR593887.1\|	692036	g167	i0	97.087	25.2101449275362	103	3	15	0	109	211	2736482	2736584	Tuwongella immobilis isolate MBLW1 genome assembly, chromosome: 1	blastn	17395	174	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Tuwongella	Tuwongella immobilis
16047580	16047580	PRJNA766854_P_NODE_673_length_482_cov_5.834437_g567_i0	PRJNA766854	673	482	5.834437	28.12198634	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	158	9.67e-34	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g567	i0	93.458	42.2842323651452	107	5	35	2	178	282	7051028	7051134	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	20381	158	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
16508861	16508861	PRJNA766854_P_NODE_1133_length_394_cov_9.408219_g1010_i0	PRJNA766854	1133	394	9.408219	37.06838286	Gemmata	113	Bacteria	Bacteria	156	2.79e-33	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g1010	i0	76.716	67.5609137055838	335	44	84	13	65	393	3633491	3633797	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	26619	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
17323264	17323264	PRJNA766854_P_NODE_1634_length_325_cov_1.885135_g1509_i0	PRJNA766854	1634	325	1.885135	6.12668875	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	99	3.87e-16	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g1509	i0	98.214	13.5938461538462	56	1	44	0	270	325	1250723	1250778	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	4418	99	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
17323301	17323301	PRJNA766854_P_NODE_914_length_434_cov_2.550617_g802_i0	PRJNA766854	914	434	2.550617	11.06967778	planctomycete str. 139	149588	Bacteria	Bacteria	121	1.13e-22	NTclustered	gi\|12583967\|gb\|AF245371.1\|AF245371	149588	g802	i0	85	3.13824884792627	120	17	28	1	203	322	505	387	Planctomycete str. 139 23S ribosomal RNA gene, partial sequence	blastn	1362	121	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 139
21147508	21147508	PRJNA766854_P_NODE_2037_length_299_cov_3.203704_g1911_i0	PRJNA766854	2037	299	3.203704	9.57907496	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	183	9.449999999999998e-42	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g1911	i0	94.215	47.3612040133779	121	6	40	1	180	299	5636817	5636937	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	14161	183	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
22422245	22422245	PRJNA766854_P_NODE_1578_length_330_cov_3.504983_g1453_i0	PRJNA766854	1578	330	3.504983	11.5664439	Termitidicoccus mucosus	1184151	Bacteria	Bacteria	183	1.06e-41	NTclustered	gi\|2724066732\|gb\|CP109796.1\|	1184151	g1453	i0	94.215	39.1151515151515	121	6	36	1	211	330	5636817	5636937	Termitidicoccus mucosus strain TSB47 chromosome, complete genome	blastn	12908	183	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Termitidicoccus	Termitidicoccus mucosus
23697934	23697934	PRJNA766854_P_NODE_399_length_567_cov_3.347584_g322_i0	PRJNA766854	399	567	3.347584	18.98080128	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	139	4.17e-28	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g322	i0	96.429	31.7724867724868	84	3	15	0	1	84	2502442	2502525	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	18015	139	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
23697941	23697941	PRJNA766854_P_NODE_959_length_427_cov_6.007538_g844_i0	PRJNA766854	959	427	6.007538	25.65218726	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	115	5.1800000000000006e-21	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g844	i0	90	5.43559718969555	90	8	45	1	165	253	7050713	7050624	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	2321	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24971605	24971605	PRJNA766854_P_NODE_620_length_495_cov_5.907725_g523_i0	PRJNA766854	620	495	5.907725	29.24323875	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	158	9.96e-34	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g523	i0	93.458	43.4808080808081	107	5	21	2	183	287	7051028	7051134	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	21523	158	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae 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);;