metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA390533" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA390533" and tax_phylum = "Planctomycetota"

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
409758	409758	PRJNA390533_P_NODE_3561_length_992_cov_7.568730_g3053_i0	PRJNA390533	3561	992	7.56873	75.0818016	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	870	0	NTclustered	gi\|1938775668\|gb\|CP054178.1\|	2026777	g3053	i0	82.934	356.434475806452	1002	135	99	31	2	992	194594	193618	MAG: Phycisphaeraceae bacterium isolate H1_PLA4 chromosome, complete genome	blastn	353583	870	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
409872	409872	PRJNA390533_P_NODE_48801_length_153_cov_2.140351_g47774_i0	PRJNA390533	48801	153	2.140351	3.27473703	Urbifossiella limnaea	2528023	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g47774	i0	100	0.784313725490196	30	0	20	0	122	151	1059610	1059639	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	120	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
1684374	1684374	PRJNA390533_P_NODE_13082_length_529_cov_2.332653_g12122_i0	PRJNA390533	13082	529	2.332653	12.33973437	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	514	5.51e-141	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g12122	i0	84.411	226.926275992439	526	58	98	15	1	516	7051294	7051805	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	120044	514	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
1684534	1684534	PRJNA390533_P_NODE_25042_length_316_cov_1.205776_g24015_i0	PRJNA390533	25042	316	1.205776	3.81025216	Poriferisphaera corsica	2528020	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1712598971\|gb\|CP036425.1\|	2528020	g24015	i0	94.444	0.113924050632911	36	2	11	0	36	71	1444124	1444159	Poriferisphaera corsica strain KS4 chromosome, complete genome	blastn	36	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Poriferisphaera	Poriferisphaera corsica
1684539	1684539	PRJNA390533_P_NODE_25322_length_316_cov_1.046931_g24295_i0	PRJNA390533	25322	316	1.046931	3.30830196	Aquisphaera giovannonii	406548	Bacteria	Bacteria	67.6	1.06e-6	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g24295	i0	85.075	0.395569620253165	67	8	21	2	237	302	1427050	1427115	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	125	67.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
1684629	1684629	PRJNA390533_P_NODE_33542_length_218_cov_8.642458_g32515_i0	PRJNA390533	33542	218	8.642458	18.84055844	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	195	3.0299999999999997e-45	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g32515	i0	86.17	4.62844036697248	188	16	85	7	13	197	2502561	2502741	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	1009	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
1684734	1684734	PRJNA390533_P_NODE_44002_length_166_cov_1.259843_g42975_i0	PRJNA390533	44002	166	1.259843	2.09133938	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	115	1.75e-21	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g42975	i0	82.443	6.24096385542169	131	23	79	0	8	138	3567903	3568033	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	1036	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
4236585	4236585	PRJNA390533_P_NODE_14724_length_487_cov_2.330357_g13733_i0	PRJNA390533	14724	487	2.330357	11.34883859	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	176	2.7e-39	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g13733	i0	82.828	22.2156057494867	198	32	40	2	267	463	1192434	1192630	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	10819	176	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
4906228	4906228	PRJNA390533_P_NODE_8804_length_662_cov_4.884430_g7989_i0	PRJNA390533	8804	662	4.88443	32.3349266	Engelhardtia	139931	Bacteria	Bacteria	215	7.940000000000002e-51	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g7989	i0	75.238	45.3187311178248	525	93	77	31	141	653	5249178	5248679	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	30001	215	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
5513475	5513475	PRJNA390533_P_NODE_31105_length_240_cov_2.810945_g30078_i0	PRJNA390533	31105	240	2.810945	6.746268	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	303	5.4e-78	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g30078	i0	90.517	278.570833333333	232	18	95	3	12	240	7051100	7051330	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	66857	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
13163297	13163297	PRJNA390533_P_NODE_17171_length_434_cov_5.417722_g16156_i0	PRJNA390533	17171	434	5.417722	23.51291348	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	182	5.12e-41	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g16156	i0	84.103	56.5	195	24	46	7	201	392	1296822	1297012	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	24521	182	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
14438324	14438324	PRJNA390533_P_NODE_12212_length_553_cov_4.344358_g11272_i0	PRJNA390533	12212	553	4.344358	24.02429974	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	689	0	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g11272	i0	92.723	144.260397830018	481	30	86	5	77	553	7051408	7050929	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	79776	689	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
14438453	14438453	PRJNA390533_P_NODE_21152_length_367_cov_3.146341_g20128_i0	PRJNA390533	21152	367	3.146341	11.54707147	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	268	3.1799999999999996e-67	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g20128	i0	98.675	89.5231607629428	151	2	66	0	217	367	7050929	7051079	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	32855	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
14438549	14438549	PRJNA390533_P_NODE_28692_length_268_cov_1.393013_g27665_i0	PRJNA390533	28692	268	1.393013	3.73327484	Urbifossiella limnaea	2528023	Bacteria	Bacteria	110	1.44e-19	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g27665	i0	79.245	22.8283582089552	159	31	59	2	4	161	3743512	3743355	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	6118	110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
14438764	14438764	PRJNA390533_P_NODE_5112_length_853_cov_2.415233_g4487_i0	PRJNA390533	5112	853	2.415233	20.60193749	Humisphaera borealis	2807512	Bacteria	Bacteria	457	1.56e-123	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g4487	i0	85.747	70.0269636576788	435	50	89	6	21	453	5063293	5063717	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	59733	457	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
15105932	15105932	PRJNA390533_P_NODE_42532_length_170_cov_10.580153_g41505_i0	PRJNA390533	42532	170	10.580153	17.9862601	Gemmata	113	Bacteria	Bacteria	206	1.03e-48	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g41505	i0	91.837	57.5352941176471	147	12	86	0	24	170	3633355	3633501	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	9781	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
15712140	15712140	PRJNA390533_P_NODE_10553_length_601_cov_4.058719_g9661_i0	PRJNA390533	10553	601	4.058719	24.39290119	Limnoglobus roseus	2598579	Bacteria	Bacteria	798	0	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g9661	i0	90.744	135.103161397671	605	47	99	9	1	599	2957402	2956801	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	81197	798	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
18929710	18929710	PRJNA390533_P_NODE_6375_length_775_cov_3.819293_g5675_i0	PRJNA390533	6375	775	3.819293	29.59952075	Frigoriglobus	2774146	Bacteria	Bacteria	1038	0	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g5675	i0	90.886	126.175483870968	779	63	99	8	3	775	2002300	2003076	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	97786	1038	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
19535576	19535576	PRJNA390533_P_NODE_35836_length_202_cov_5.687117_g34809_i0	PRJNA390533	35836	202	5.687117	11.48797634	Aureliella helgolandensis	2527968	Bacteria	Bacteria	224	3.52e-54	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g34809	i0	89.385	89.0940594059406	179	18	89	1	3	181	6998995	6998818	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	17997	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
20811120	20811120	PRJNA390533_P_NODE_12757_length_538_cov_2.084168_g11810_i0	PRJNA390533	12757	538	2.084168	11.21282384	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	560	7.1e-155	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g11810	i0	86.142	234.472118959108	534	57	96	14	1	518	7050946	7050414	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	126146	560	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
20811291	20811291	PRJNA390533_P_NODE_24737_length_316_cov_1.447653_g23710_i0	PRJNA390533	24737	316	1.447653	4.57458348	Rohdeia mirabilis	2528008	Bacteria	Bacteria	63.9	1.37e-5	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g23710	i0	95.122	0.382911392405063	41	0	13	2	268	307	3589787	3589748	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	121	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
20811316	20811316	PRJNA390533_P_NODE_26417_length_301_cov_1.667939_g25390_i0	PRJNA390533	26417	301	1.667939	5.02049639	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	128	4.52e-25	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g25390	i0	84.921	0.813953488372093	126	19	42	0	158	283	470640	470515	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	245	128	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
22085968	22085968	PRJNA390533_P_NODE_1538_length_1338_cov_4.700539_g159_i1	PRJNA390533	1538	1338	4.700539	62.89321182	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	1491	0	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g159	i1	87.027	159.425261584454	1349	142	99	19	2	1319	1600500	1599154	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	213311	1491	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
23361793	23361793	PRJNA390533_P_NODE_26359_length_302_cov_1.467681_g25332_i0	PRJNA390533	26359	302	1.467681	4.43239662	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	211	4.38e-50	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g25332	i0	80.586	65.3774834437086	273	53	90	0	27	299	6859510	6859238	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	19744	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
23361866	23361866	PRJNA390533_P_NODE_34439_length_212_cov_2.121387_g33412_i0	PRJNA390533	34439	212	2.121387	4.49734044	Aquisphaera giovannonii	406548	Bacteria	Bacteria	333	5.939999999999998e-87	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g33412	i0	95.261	77.1367924528302	211	8	99	2	2	212	5178878	5179086	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	16353	333	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
24635900	24635900	PRJNA390533_P_NODE_12480_length_545_cov_5.428854_g11538_i0	PRJNA390533	12480	545	5.428854	29.5872543	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	928	0	NTclustered	gi\|218533792\|gb\|FJ490306.1\|	120965	g11538	i0	98.846	92.7651376146789	520	6	95	0	21	540	2	521	Uncultured planctomycete clone E_29 16S ribosomal RNA gene, partial sequence	blastn	50557	928	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
24636063	24636063	PRJNA390533_P_NODE_25060_length_316_cov_1.194946_g24033_i0	PRJNA390533	25060	316	1.194946	3.77602936	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	67.6	1.06e-6	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g24033	i0	97.436	2.71518987341772	39	1	12	0	28	66	7815453	7815491	Tautonia plasticadhaerens strain ElP chromosome	blastn	858	67.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
24636170	24636170	PRJNA390533_P_NODE_35900_length_202_cov_1.993865_g34873_i0	PRJNA390533	35900	202	1.993865	4.0276073	Aureliella helgolandensis	2527968	Bacteria	Bacteria	268	1.5999999999999998e-67	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g34873	i0	92.935	15.4108910891089	184	13	91	0	19	202	6998803	6998986	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	3113	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis

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);;