metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA611476" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA611476" 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
588954	588954	PRJNA611476_P_NODE_110541_length_243_cov_0.905882_g109750_i0	PRJNA611476	110541	243	0.905882	2.20129326	Urbifossiella limnaea	2528023	Bacteria	Bacteria	193	1.24e-44	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g109750	i0	84.158	0.831275720164609	202	28	82	3	1	199	2802033	2801833	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	202	193	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
1865971	1865971	PRJNA611476_P_NODE_82942_length_250_cov_0.870056_g82151_i0	PRJNA611476	82942	250	0.870056	2.17514	Stieleria bergensis	2528025	Bacteria	Bacteria	82.4	2.89e-11	NTclustered	gi\|1712514661\|gb\|CP036272.1\|	2528025	g82151	i0	93.103	21.4	58	1	23	3	190	247	3877810	3877864	Planctomycetes bacterium SV_7m_r chromosome	blastn	5350	82.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria bergensis
3139718	3139718	PRJNA611476_P_NODE_103983_length_244_cov_1.479532_g103192_i0	PRJNA611476	103983	244	1.479532	3.61005808	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	372	1.49e-98	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g103192	i0	94.937	101.319672131148	237	12	97	0	1	237	2003882	2003646	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	24722	372	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
3140510	3140510	PRJNA611476_P_NODE_50683_length_306_cov_1.317597_g49892_i0	PRJNA611476	50683	306	1.317597	4.03184682	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	383	8.91e-102	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g49892	i0	89.735	342.205882352941	302	27	98	4	1	300	7053125	7053424	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	104715	383	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
4416542	4416542	PRJNA611476_P_NODE_115444_length_241_cov_0.916667_g114653_i0	PRJNA611476	115444	241	0.916667	2.20916747	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	440	3.959999999999999e-119	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g114653	i0	99.585	1	241	1	100	0	1	241	4807538	4807298	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	241	440	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
5693254	5693254	PRJNA611476_P_NODE_55005_length_295_cov_1.202703_g54214_i0	PRJNA611476	55005	295	1.202703	3.54797385	Paludisphaera borealis	1387353	Bacteria	Bacteria	398	3.0499999999999995e-106	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g54214	i0	91.667	49.9830508474576	288	23	98	1	1	288	123060	123346	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	14745	398	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
6968096	6968096	PRJNA611476_P_NODE_61566_length_282_cov_1.425837_g60775_i0	PRJNA611476	61566	282	1.425837	4.02086034	Planctomycetia bacterium	2052181	Bacteria	Bacteria	231	3.11e-56	NTclustered	gi\|1938772707\|gb\|CP054190.1\|	2052181	g60775	i0	81.69	55.2056737588652	284	47	100	4	1	282	790753	790473	MAG: Planctomycetia bacterium isolate H1_PLA3 chromosome, complete genome	blastn	15568	231	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
7526162	7526162	PRJNA611476_P_NODE_9806_length_622_cov_1.597450_g9022_i0	PRJNA611476	9806	622	1.59745	9.936139	Bacteria	2	Bacteria	Bacteria	54.7	0.017	NTclustered	gi\|2916408352\|gb\|CP170455.1\|	2052180	g9022	i0	92.5	0.128617363344051	40	0	6	2	382	421	235684	235648	MAG: Phycisphaerales bacterium isolate tig00000072 chromosome, complete genome	blastn	80	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
9517534	9517534	PRJNA611476_P_NODE_21508_length_431_cov_1.541899_g20717_i0	PRJNA611476	21508	431	1.541899	6.64558469	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	401	3.579999999999999e-107	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g20717	i0	83.521	162.679814385151	443	59	100	11	1	431	7050393	7050833	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	70115	401	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
10793085	10793085	PRJNA611476_P_NODE_105709_length_244_cov_0.900585_g104918_i0	PRJNA611476	105709	244	0.900585	2.1974274	Mucisphaera calidilacus	2527982	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1712644202\|gb\|CP036280.1\|	2527982	g104918	i0	85.455	0.225409836065574	55	4	22	4	27	79	1896244	1896296	Mucisphaera calidilacus strain Pan265 chromosome, complete genome	blastn	55	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Mucisphaera	Mucisphaera calidilacus
12068598	12068598	PRJNA611476_P_NODE_23190_length_417_cov_1.848837_g22399_i0	PRJNA611476	23190	417	1.848837	7.70965029	Lignipirellula cremea	2528010	Bacteria	Bacteria	106	3.04e-18	NTclustered	gi\|1712668320\|gb\|CP036433.1\|	2528010	g22399	i0	79.375	1.4220623501199	160	25	37	7	3	158	3828233	3828388	Lignipirellula cremea strain Pla85_3_4 chromosome, complete genome	blastn	593	106	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Lignipirellula	Lignipirellula cremea
12068790	12068790	PRJNA611476_P_NODE_37990_length_343_cov_4.359259_g37199_i0	PRJNA611476	37990	343	4.359259	14.95225837	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	508	1.6e-139	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g37199	i0	93.353	155.615160349854	346	19	100	3	1	343	5935792	5936136	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	53376	508	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
15892022	15892022	PRJNA611476_P_NODE_119193_length_220_cov_4.142857_g118402_i0	PRJNA611476	119193	220	4.142857	9.1142854	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	294	2.93e-75	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g118402	i0	91.549	153.968181818182	213	18	97	0	2	214	1156174	1156386	Planctomyces sp. SH-PL62, complete genome	blastn	33873	294	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
15892302	15892302	PRJNA611476_P_NODE_32773_length_363_cov_1.717241_g31982_i0	PRJNA611476	32773	363	1.717241	6.23358483	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2108282846\|gb\|CP070678.1\|	2052180	g31982	i0	92.308	0.107438016528926	39	3	11	0	263	301	661982	661944	MAG: Phycisphaerales bacterium isolate bin7 chromosome	blastn	39	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
15892377	15892377	PRJNA611476_P_NODE_37613_length_345_cov_1.132353_g36822_i0	PRJNA611476	37613	345	1.132353	3.90661785	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	279	1.38e-70	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g36822	i0	82.405	86.7217391304348	341	41	96	16	12	343	4496267	4495937	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	29919	279	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
17167927	17167927	PRJNA611476_P_NODE_85434_length_249_cov_1.539773_g84643_i0	PRJNA611476	85434	249	1.539773	3.83403477	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	351	1.98e-92	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g84643	i0	92.369	275.923694779116	249	15	99	4	2	249	1600267	1600022	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	68705	351	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
18441476	18441476	PRJNA611476_P_NODE_3935_length_981_cov_7.343612_g3258_i0	PRJNA611476	3935	981	7.343612	72.04083372	Limnoglobus roseus	2598579	Bacteria	Bacteria	58.4	0.002	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g3258	i0	100	0.0316004077471967	31	0	3	0	72	102	7374518	7374488	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	31	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
18999254	18999254	PRJNA611476_P_NODE_31095_length_371_cov_0.902685_g30304_i0	PRJNA611476	31095	371	0.902685	3.34896135	Pseudomonadati	3379134	Bacteria	Bacteria	54.7	0.01	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g30304	i0	92.105	0.76010781671159	38	3	10	0	118	155	2570967	2571004	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	282	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
19716578	19716578	PRJNA611476_P_NODE_8396_length_669_cov_2.068792_g7621_i0	PRJNA611476	8396	669	2.068792	13.84021848	Aquisphaera giovannonii	406548	Bacteria	Bacteria	893	0	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g7621	i0	90.896	151.77130044843	670	53	100	7	1	669	9144306	9143644	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	101535	893	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
19716613	19716613	PRJNA611476_P_NODE_86676_length_249_cov_0.875000_g85885_i0	PRJNA611476	86676	249	0.875	2.17875	Lacipirellula parvula	2650471	Bacteria	Bacteria	296	9.429999999999999e-76	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g85885	i0	88.259	1.99196787148594	247	29	99	0	1	247	5025566	5025320	Lacipirellula parvula PX69 DNA, complete genome	blastn	496	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
20992193	20992193	PRJNA611476_P_NODE_72477_length_262_cov_0.925926_g71686_i0	PRJNA611476	72477	262	0.925926	2.42592612	Stieleria maiorica	2795974	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1726207917\|gb\|CP036264.1\|	2795974	g71686	i0	96.875	0.122137404580153	32	0	12	1	183	214	5809862	5809892	Stieleria maiorica strain Mal15 chromosome	blastn	32	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria maiorica
21550155	21550155	PRJNA611476_P_NODE_79817_length_251_cov_0.865169_g79026_i0	PRJNA611476	79817	251	0.865169	2.17157419	PVC group	1783257	Bacteria	Bacteria	248	2.7e-61	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g79026	i0	85.477	94.1513944223108	241	31	95	3	4	242	7967433	7967671	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	23632	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
22266060	22266060	PRJNA611476_P_NODE_110838_length_243_cov_0.905882_g110047_i0	PRJNA611476	110838	243	0.905882	2.20129326	Lacipirellula parvula	2650471	Bacteria	Bacteria	178	3.4599999999999993e-40	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g110047	i0	83.333	0.790123456790123	192	32	79	0	1	192	558165	558356	Lacipirellula parvula PX69 DNA, complete genome	blastn	192	178	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
23542118	23542118	PRJNA611476_P_NODE_55179_length_295_cov_0.801802_g54388_i0	PRJNA611476	55179	295	0.801802	2.3653159	Humisphaera borealis	2807512	Bacteria	Bacteria	333	8.729999999999999e-87	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g54388	i0	88.406	110.908474576271	276	32	94	0	2	277	5063593	5063868	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	32718	333	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
23542315	23542315	PRJNA611476_P_NODE_70179_length_266_cov_1.409326_g69388_i0	PRJNA611476	70179	266	1.409326	3.74880716	Humisphaera borealis	2807512	Bacteria	Bacteria	311	3.63e-80	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g69388	i0	87.879	0.992481203007519	264	32	99	0	1	264	5557480	5557743	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	264	311	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
24815415	24815415	PRJNA611476_P_NODE_17800_length_469_cov_1.522727_g17010_i0	PRJNA611476	17800	469	1.522727	7.14158963	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	542	2.22e-149	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g17010	i0	87.846	196.586353944563	469	48	99	8	1	468	1155757	1156217	Planctomyces sp. SH-PL62, complete genome	blastn	92199	542	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
24816103	24816103	PRJNA611476_P_NODE_67800_length_271_cov_1.166667_g67009_i0	PRJNA611476	67800	271	1.166667	3.16166757	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	213	1.08e-50	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g67009	i0	82.072	6.45756457564576	251	43	92	2	4	253	5593871	5593622	Tautonia plasticadhaerens strain ElP chromosome	blastn	1750	213	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);;