metadata: contig_metadata: 29 rows where analysis = "blastn", bioproject = "PRJNA1146029" and tax

29 rows where analysis = "blastn", bioproject = "PRJNA1146029" 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
289933	289933	PRJNA1146029_P_NODE_1001_length_897_cov_1.248786_g785_i0	PRJNA1146029	1001	897	1.248786	11.20161042	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	1013	0	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g785	i0	87.188	118.419175027871	921	81	100	28	1	897	1844020	1844927	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	106222	1013	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia
2840763	2840763	PRJNA1146029_P_NODE_10083_length_289_cov_3.541667_g9802_i0	PRJNA1146029	10083	289	3.541667	10.23541763	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	481	2.88e-131	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g9802	i0	96.564	119.750865051903	291	8	100	1	1	289	7629231	7629521	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	34608	481	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
5393241	5393241	PRJNA1146029_P_NODE_13725_length_266_cov_2.393782_g13444_i0	PRJNA1146029	13725	266	2.393782	6.36746012	Caulifigura coniformis	2527983	Bacteria	Bacteria	486	5.629999999999999e-133	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g13444	i0	99.624	117.417293233083	266	1	100	0	1	266	2927268	2927533	Caulifigura coniformis strain Pan44 chromosome	blastn	31233	486	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
6136454	6136454	PRJNA1146029_P_NODE_1385_length_756_cov_2.212299_g1137_i0	PRJNA1146029	1385	756	2.212299	16.72498044	Lacipirellula	2691417	Bacteria	Bacteria	1308	0	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g1137	i0	97.884	117.560846560847	756	16	100	0	1	756	5171211	5170456	Lacipirellula limnantheis strain I41 chromosome	blastn	88876	1321	0.990158970476911	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
6668130	6668130	PRJNA1146029_P_NODE_6726_length_342_cov_1.386617_g6448_i0	PRJNA1146029	6726	342	1.386617	4.74223014	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	623	5.459999999999999e-174	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g6448	i0	99.419	124.833333333333	344	0	100	1	1	342	7630099	7629756	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	42693	623	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
7943150	7943150	PRJNA1146029_P_NODE_1607_length_689_cov_2.152597_g1346_i0	PRJNA1146029	1607	689	2.152597	14.83139333	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	1173	0	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g1346	i0	97.522	138.44557329463	686	17	99	0	1	686	7630061	7630746	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	95389	1173	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
7943302	7943302	PRJNA1146029_P_NODE_5047_length_386_cov_0.923323_g4769_i0	PRJNA1146029	5047	386	0.923323	3.56402678	Alienimonas californiensis	2527989	Bacteria	Bacteria	75	7.87e-9	NTclustered	gi\|1712468061\|gb\|CP036265.1\|	2527989	g4769	i0	90.909	0.515544041450777	55	5	14	0	10	64	1758180	1758234	Alienimonas californiensis strain CA12 chromosome	blastn	199	75	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Alienimonas	Alienimonas californiensis
8686729	8686729	PRJNA1146029_P_NODE_12847_length_273_cov_0.995000_g12566_i0	PRJNA1146029	12847	273	0.995	2.71635	Gemmata	113	Bacteria	Bacteria	398	2.7899999999999995e-106	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g12566	i0	93.04	181.747252747253	273	17	100	2	1	273	1821	1551	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	49617	398	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
9218187	9218187	PRJNA1146029_P_NODE_2748_length_515_cov_2.384615_g2471_i0	PRJNA1146029	2748	515	2.384615	12.28076725	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	621	3.0699999999999998e-173	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g2471	i0	88.61	116.116504854369	518	50	100	8	1	515	1831812	1831301	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	59800	621	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
9218304	9218304	PRJNA1146029_P_NODE_9348_length_298_cov_1.195556_g9067_i0	PRJNA1146029	9348	298	1.195556	3.56275688	Urbifossiella limnaea	2528023	Bacteria	Bacteria	239	1.98e-58	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g9067	i0	81.395	59.2751677852349	301	49	100	7	1	298	4212126	4212422	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	17664	239	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
9961784	9961784	PRJNA1146029_P_NODE_4468_length_408_cov_4.382090_g4190_i0	PRJNA1146029	4468	408	4.38209	17.8789272	Botrimarina	2795782	Bacteria	Bacteria	726	0	NTclustered	gi\|1712768844\|gb\|CP036350.1\|	2527962	g4190	i0	98.775	139.632352941176	408	5	100	0	1	408	4247538	4247131	Planctomycetes bacterium K2D chromosome, complete genome	blastn	56970	726	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium K2D
10493748	10493748	PRJNA1146029_P_NODE_17889_length_248_cov_0.880000_g17608_i0	PRJNA1146029	17889	248	0.88	2.1824	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	281	2.63e-71	NTclustered	gi\|2921913114\|gb\|CP182803.1\|	2026777	g17608	i0	87.149	176.040322580645	249	31	100	1	1	248	1301544	1301296	MAG: Phycisphaeraceae bacterium isolate amkv24 chromosome, complete genome	blastn	43658	281	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
11768657	11768657	PRJNA1146029_P_NODE_11970_length_278_cov_1.502439_g11689_i0	PRJNA1146029	11970	278	1.502439	4.17678042	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	189	1.87e-43	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g11689	i0	85.714	2.09352517985611	182	22	65	3	28	207	652907	652728	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	582	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
11768859	11768859	PRJNA1146029_P_NODE_3970_length_429_cov_1.946629_g3692_i0	PRJNA1146029	3970	429	1.946629	8.35103841	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	604	2.529999999999999e-168	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g3692	i0	92.093	98.04662004662	430	32	100	2	1	429	1831796	1832224	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	42062	604	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
11768861	11768861	PRJNA1146029_P_NODE_4090_length_423_cov_3.397143_g3812_i0	PRJNA1146029	4090	423	3.397143	14.36991489	Caulifigura coniformis	2527983	Bacteria	Bacteria	765	0	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g3812	i0	99.291	138.723404255319	423	3	100	0	1	423	2925875	2925453	Caulifigura coniformis strain Pan44 chromosome	blastn	58680	765	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
13043829	13043829	PRJNA1146029_P_NODE_21831_length_241_cov_1.642857_g21550_i0	PRJNA1146029	21831	241	1.642857	3.95928537	Lacipirellula parvula	2650471	Bacteria	Bacteria	424	3.99e-114	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g21550	i0	98.34	157.925311203319	241	4	100	0	1	241	5163498	5163738	Lacipirellula parvula PX69 DNA, complete genome	blastn	38060	424	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
13043851	13043851	PRJNA1146029_P_NODE_331_length_1458_cov_3.409386_g219_i0	PRJNA1146029	331	1458	3.409386	49.70884788	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	1808	0	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g219	i0	89.261	433.324417009602	1462	133	99	22	8	1458	1831291	1829843	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	631787	1808	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
15061368	15061368	PRJNA1146029_P_NODE_1732_length_664_cov_2.133672_g1470_i0	PRJNA1146029	1732	664	2.133672	14.16758208	Gemmata	113	Bacteria	Bacteria	1035	0	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g1470	i0	94.872	484.030120481928	663	33	99	1	1	663	3634688	3634027	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	321396	1040	0.995192307692308	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
15592950	15592950	PRJNA1146029_P_NODE_16053_length_251_cov_0.865169_g15772_i0	PRJNA1146029	16053	251	0.865169	2.17157419	Limnoglobus roseus	2598579	Bacteria	Bacteria	76.8	1.35e-9	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g15772	i0	91.071	0.338645418326693	56	5	22	0	173	228	75871	75926	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	85	76.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
16867261	16867261	PRJNA1146029_P_NODE_20134_length_244_cov_0.900585_g19853_i0	PRJNA1146029	20134	244	0.900585	2.1974274	Planctomycetota bacterium	2026780	Bacteria	Bacteria	370	5.35e-98	NTclustered	gi\|1850852299\|gb\|CP053450.1\|	2026780	g19853	i0	94.239	393.688524590164	243	13	99	1	2	244	721217	721458	MAG: Planctomycetota bacterium isolate PNC22 chromosome	blastn	96060	370	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
16867272	16867272	PRJNA1146029_P_NODE_20754_length_243_cov_0.905882_g20473_i0	PRJNA1146029	20754	243	0.905882	2.20129326	Limnoglobus roseus	2598579	Bacteria	Bacteria	150	7.55e-32	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g20473	i0	80.808	2.1358024691358	198	32	80	4	1	195	5218641	5218447	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	519	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
16867349	16867349	PRJNA1146029_P_NODE_634_length_1144_cov_4.171802_g461_i0	PRJNA1146029	634	1144	4.171802	47.72541488	Lacipirellula parvula	2650471	Bacteria	Bacteria	1746	0	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g461	i0	94.107	166.187937062937	1154	58	100	4	1	1144	5163063	5164216	Lacipirellula parvula PX69 DNA, complete genome	blastn	190119	1746	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
18141754	18141754	PRJNA1146029_P_NODE_14675_length_260_cov_1.144385_g14394_i0	PRJNA1146029	14675	260	1.144385	2.975401	Caulifigura coniformis	2527983	Bacteria	Bacteria	453	5.5600000000000005e-123	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g14394	i0	98.077	117.003846153846	260	5	100	0	1	260	2926540	2926281	Caulifigura coniformis strain Pan44 chromosome	blastn	30421	453	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
18141826	18141826	PRJNA1146029_P_NODE_1875_length_637_cov_1.343972_g1605_i0	PRJNA1146029	1875	637	1.343972	8.56110164	Planctomycetota bacterium	2026780	Bacteria	Bacteria	673	0	NTclustered	gi\|1850852299\|gb\|CP053450.1\|	2026780	g1605	i0	85.848	508.031397174254	643	79	100	12	1	637	720369	721005	MAG: Planctomycetota bacterium isolate PNC22 chromosome	blastn	323616	673	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
18885206	18885206	PRJNA1146029_P_NODE_4795_length_395_cov_1.102484_g4517_i0	PRJNA1146029	4795	395	1.102484	4.3548118	Gemmata	113	Bacteria	Bacteria	658	0	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g4517	i0	96.709	67.8810126582278	395	13	100	0	1	395	2666370	2666764	Gemmata sp. SH-PL17, complete genome	blastn	26813	658	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
20160040	20160040	PRJNA1146029_P_NODE_8196_length_316_cov_1.267490_g7916_i0	PRJNA1146029	8196	316	1.26749	4.0052684	Stieleria	2795973	Bacteria	Bacteria	281	3.47e-71	NTclustered	gi\|1712780605\|gb\|CP036432.1\|	2527963	g7916	i0	85.507	88.4525316455696	276	33	86	6	1	273	3122409	3122680	Planctomycetes bacterium TBK1r chromosome	blastn	27951	281	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria magnilauensis
23242351	23242351	PRJNA1146029_P_NODE_10699_length_286_cov_1.446009_g10418_i0	PRJNA1146029	10699	286	1.446009	4.13558574	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	318	2.36e-82	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g10418	i0	86.851	189.842657342657	289	32	99	5	1	285	2001743	2002029	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	54295	318	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
23242453	23242453	PRJNA1146029_P_NODE_17219_length_249_cov_0.875000_g16938_i0	PRJNA1146029	17219	249	0.875	2.17875	Gemmataceae bacterium	2052164	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g16938	i0	100	48.3815261044177	249	0	100	0	1	249	318027	317779	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	12047	460	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
23242529	23242529	PRJNA1146029_P_NODE_21459_length_242_cov_0.911243_g21178_i0	PRJNA1146029	21459	242	0.911243	2.20520806	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	222	1.57e-53	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g21178	i0	84.444	0.929752066115702	225	35	93	0	5	229	6882218	6881994	Tautonia plasticadhaerens strain ElP chromosome	blastn	225	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens

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