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

28 rows where analysis = "blastn", bioproject = "PRJNA505329" 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
483357	483357	PRJNA505329_P_NODE_32681_length_183_cov_2.291045_g32210_i0	PRJNA505329	32681	183	2.291045	4.19261235	Isosphaera sp. Io3-6	886834	Bacteria	Bacteria	316	5.009999999999999e-82	NTclustered	gi\|307591270\|gb\|GQ889467.1\|	886834	g32210	i0	98.333	89.1639344262295	180	3	98	0	1	180	293	114	Isosphaera sp. Io3-6 16S ribosomal RNA gene, partial sequence	blastn	16317	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera sp. Io3-6
1758347	1758347	PRJNA505329_P_NODE_17942_length_215_cov_2.728916_g17471_i0	PRJNA505329	17942	215	2.728916	5.8671694	Humisphaera borealis	2807512	Bacteria	Bacteria	259	1.04e-64	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g17471	i0	90.5	22.7674418604651	200	14	92	4	19	215	5064487	5064290	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	4895	259	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
1758588	1758588	PRJNA505329_P_NODE_38062_length_175_cov_1.626984_g37591_i0	PRJNA505329	38062	175	1.626984	2.847222	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	244	2.2699999999999998e-60	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g37591	i0	92.941	242.782857142857	170	9	96	3	7	174	3097347	3097179	Pirellula sp. SH-Sr6A, complete genome	blastn	42487	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
3034691	3034691	PRJNA505329_P_NODE_4923_length_350_cov_3.368771_g4453_i0	PRJNA505329	4923	350	3.368771	11.7906985	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	189	2.4199999999999992e-43	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g4453	i0	97.297	67.7285714285714	111	3	88	0	120	230	4959767	4959657	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	23705	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
5587261	5587261	PRJNA505329_P_NODE_43645_length_167_cov_3.457627_g43174_i0	PRJNA505329	43645	167	3.457627	5.77423709	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	228	2.1699999999999995e-55	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g43174	i0	91.566	19.2874251497006	166	12	99	2	3	167	2503557	2503393	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	3221	228	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
6861181	6861181	PRJNA505329_P_NODE_30346_length_187_cov_0.847826_g29875_i0	PRJNA505329	30346	187	0.847826	1.58543462	Paludisphaera borealis	1387353	Bacteria	Bacteria	244	2.4599999999999999e-60	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g29875	i0	91.62	59.2406417112299	179	11	94	4	3	178	121944	122121	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	11078	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
7488271	7488271	PRJNA505329_P_NODE_11386_length_233_cov_3.483696_g10915_i0	PRJNA505329	11386	233	3.483696	8.11701168	Isosphaeraceae	1763524	Bacteria	Bacteria	159	1.19e-34	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g10915	i0	95.05	198.012875536481	101	5	43	0	133	233	5179328	5179228	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	46137	159	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
9411384	9411384	PRJNA505329_P_NODE_24488_length_195_cov_4.458904_g24017_i0	PRJNA505329	24488	195	4.458904	8.6948628	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	263	7.15e-66	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g24017	i0	94.706	145.794871794872	170	8	87	1	12	181	1831089	1831257	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	28430	263	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
10687049	10687049	PRJNA505329_P_NODE_24909_length_194_cov_4.096552_g24438_i0	PRJNA505329	24909	194	4.096552	7.94731088	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	165	2.06e-36	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g24438	i0	96.04	61.0103092783505	101	4	94	0	4	104	265477	265577	Tautonia plasticadhaerens strain ElP chromosome	blastn	11836	165	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
11962399	11962399	PRJNA505329_P_NODE_5550_length_322_cov_3.989011_g5079_i0	PRJNA505329	5550	322	3.989011	12.84461542	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	287	7.610000000000001e-73	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g5079	i0	94.595	57.027950310559	185	10	57	0	136	320	2002609	2002425	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	18363	287	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
13237213	13237213	PRJNA505329_P_NODE_28991_length_189_cov_1.028571_g28520_i0	PRJNA505329	28991	189	1.028571	1.94399919	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	150	5.59e-32	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g28520	i0	81.522	5.35978835978836	184	32	97	2	7	189	3857671	3857489	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	1013	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
14512484	14512484	PRJNA505329_P_NODE_45392_length_166_cov_0.888889_g44921_i0	PRJNA505329	45392	166	0.888889	1.47555574	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	165	1.7100000000000002e-36	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g44921	i0	85.535	0.957831325301205	159	21	95	2	3	160	4786177	4786334	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	159	165	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
15786065	15786065	PRJNA505329_P_NODE_30613_length_186_cov_2.248175_g30142_i0	PRJNA505329	30613	186	2.248175	4.1816055	Rosistilla ulvae	1930277	Bacteria	Bacteria	178	2.5099999999999993e-40	NTclustered	gi\|1712438206\|gb\|CP036261.1\|	1930277	g30142	i0	87.342	82.3279569892473	158	17	84	3	2	157	975913	976069	Rosistilla ulvae strain EC9 chromosome	blastn	15313	178	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rosistilla	Rosistilla ulvae
15786102	15786102	PRJNA505329_P_NODE_33593_length_182_cov_1.541353_g33122_i0	PRJNA505329	33593	182	1.541353	2.80526246	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	244	2.38e-60	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g33122	i0	91.954	152.142857142857	174	14	96	0	2	175	2582579	2582752	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	27690	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
17060611	17060611	PRJNA505329_P_NODE_21134_length_201_cov_3.289474_g20663_i0	PRJNA505329	21134	201	3.289474	6.61184274	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	141	3.63e-29	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g20663	i0	91.262	85.7860696517413	103	9	51	0	99	201	2001969	2002071	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	17243	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
17060618	17060618	PRJNA505329_P_NODE_22094_length_200_cov_4.046358_g21623_i0	PRJNA505329	22094	200	4.046358	8.092716	Mucisphaera calidilacus	2527982	Bacteria	Bacteria	100	6.12e-17	NTclustered	gi\|1712644202\|gb\|CP036280.1\|	2527982	g21623	i0	91.781	2.09	73	5	36	1	98	169	831366	831438	Mucisphaera calidilacus strain Pan265 chromosome, complete genome	blastn	418	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Mucisphaera	Mucisphaera calidilacus
18334920	18334920	PRJNA505329_P_NODE_21595_length_201_cov_3.052632_g21124_i0	PRJNA505329	21595	201	3.052632	6.13579032	uncultured Planctomyces sp.	179110	Bacteria	Bacteria	278	2.65e-70	NTclustered	gi\|507528258\|gb\|KC295311.1\|	179110	g21124	i0	91.919	99.6965174129353	198	16	99	0	4	201	663	860	Uncultured Planctomyces sp. clone AC400D08 16S ribosomal RNA gene, partial sequence	blastn	20039	278	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	uncultured Planctomyces sp.
18334978	18334978	PRJNA505329_P_NODE_26295_length_192_cov_2.867133_g25824_i0	PRJNA505329	26295	192	2.867133	5.50489536	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	287	4.16e-73	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g25824	i0	96.552	250.927083333333	174	4	90	2	4	175	4421110	4420937	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	48178	287	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
18335274	18335274	PRJNA505329_P_NODE_49115_length_163_cov_0.868421_g48644_i0	PRJNA505329	49115	163	0.868421	1.41552623	Rubinisphaera brasiliensis	119	Bacteria	Bacteria	159	7.779999999999998e-35	NTclustered	gi\|324966854\|gb\|CP002546.1\|	756272	g48644	i0	85.526	3.95092024539877	152	22	93	0	9	160	607946	608097	Rubinisphaera brasiliensis DSM 5305 chromosome, complete genome	blastn	644	159	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Rubinisphaera	Rubinisphaera brasiliensis
20236652	20236652	PRJNA505329_P_NODE_16076_length_233_cov_2.489130_g15605_i0	PRJNA505329	16076	233	2.48913	5.7996729	Bacteria	2	Bacteria	Bacteria	119	2.03e-22	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g15605	i0	88.776	40.3648068669528	98	9	42	2	133	230	2583880	2583975	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	9405	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
20236658	20236658	PRJNA505329_P_NODE_16796_length_231_cov_2.181319_g16325_i0	PRJNA505329	16796	231	2.181319	5.03884689	Planctomycetia	203683	Bacteria	Bacteria	348	2.3500000000000006e-91	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g16325	i0	95.833	196.437229437229	216	8	94	1	13	228	122458	122672	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	45377	348	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
20885718	20885718	PRJNA505329_P_NODE_8757_length_244_cov_3.456410_g8286_i0	PRJNA505329	8757	244	3.45641	8.4336404	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	209	1.23e-49	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g8286	i0	82.16	74.655737704918	213	34	87	3	14	225	2583530	2583321	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	18216	209	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
21512301	21512301	PRJNA505329_P_NODE_37177_length_176_cov_2.417323_g36706_i0	PRJNA505329	37177	176	2.417323	4.25448848	Planctomycetia	203683	Bacteria	Bacteria	215	1.79e-51	NTclustered	gi\|470485626\|ref\|NR_076710.1\|	125	g36706	i0	93.151	102.164772727273	146	10	83	0	15	160	1195	1050	Pirellula staleyi strain DSM 6068 23S ribosomal RNA gene, complete sequence	blastn	17981	215	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula staleyi
23435923	23435923	PRJNA505329_P_NODE_39699_length_172_cov_2.495935_g39228_i0	PRJNA505329	39699	172	2.495935	4.2930082	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	145	2.31e-30	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g39228	i0	84.932	5.67441860465116	146	19	84	3	2	145	7051856	7051712	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	976	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
23435978	23435978	PRJNA505329_P_NODE_44579_length_167_cov_0.881356_g44108_i0	PRJNA505329	44579	167	0.881356	1.47186452	Pirellulimonas nuda	2528009	Bacteria	Bacteria	106	1.06e-18	NTclustered	gi\|1712662089\|gb\|CP036291.1\|	2528009	g44108	i0	83.051	4.33532934131737	118	18	70	2	3	119	117145	117261	Pirellulimonas nuda strain Pla175 chromosome, complete genome	blastn	724	106	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Pirellulimonas	Pirellulimonas nuda
24062263	24062263	PRJNA505329_P_NODE_33839_length_181_cov_2.772727_g33368_i0	PRJNA505329	33839	181	2.772727	5.01863587	Gemmataceae	1914233	Bacteria	Bacteria	230	6.62e-56	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g33368	i0	90	200.812154696133	180	15	98	3	1	178	3634137	3633959	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	36347	230	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
24062281	24062281	PRJNA505329_P_NODE_3639_length_445_cov_4.573232_g3181_i0	PRJNA505329	3639	445	4.573232	20.3508824	Tuwongella	2051044	Bacteria	Bacteria	387	1.04e-102	NTclustered	gi\|1804913728\|emb\|LR593887.1\|	692036	g3181	i0	88.166	111.07191011236	338	22	75	13	113	445	2736634	2736310	Tuwongella immobilis isolate MBLW1 genome assembly, chromosome: 1	blastn	49427	388	0.997422680412371	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Tuwongella	Tuwongella immobilis
24709343	24709343	PRJNA505329_P_NODE_32760_length_183_cov_2.089552_g32289_i0	PRJNA505329	32760	183	2.089552	3.82388016	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	233	5.19e-57	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g32289	i0	91.279	198.136612021858	172	13	93	2	10	180	1831027	1830857	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	36259	233	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales 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);;