metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA1237888" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA1237888" 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
346563	346563	PRJNA1237888_S_NODE_841_length_433_cov_3.416667_g791_i0	PRJNA1237888	841	433	3.416667	14.79416811	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	579	1.5499999999999994e-160	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g791	i0	90.972	114.602771362587	432	36	99	3	1	431	4317542	4317113	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	49623	579	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
2325160	2325160	PRJNA1237888_S_NODE_3642_length_213_cov_2.164634_g3592_i0	PRJNA1237888	3642	213	2.164634	4.61067042	Planctomycetia	203683	Bacteria	Bacteria	285	1.7e-72	NTclustered	gi\|485099129\|ref\|NR_102524.1\|	466153	g3592	i0	90.995	141.50234741784	211	19	99	0	3	213	2080	1870	Singulisphaera acidiphila strain MOB10 23S ribosomal RNA gene, complete sequence	blastn	30140	285	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
2897503	2897503	PRJNA1237888_S_NODE_1283_length_355_cov_8.604575_g1233_i0	PRJNA1237888	1283	355	8.604575	30.54624125	Urbifossiella limnaea	2528023	Bacteria	Bacteria	353	8.22e-93	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g1233	i0	85.345	20.9633802816901	348	43	97	5	2	346	2018040	2017698	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	7442	353	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
2897507	2897507	PRJNA1237888_S_NODE_3283_length_224_cov_2.560000_g3233_i0	PRJNA1237888	3283	224	2.56	5.7344	Haloferula helveola	490095	Bacteria	Bacteria	381	2.2299999999999993e-101	NTclustered	gi\|2057479829\|gb\|MZ443971.1\|	490095	g3233	i0	97.321	100.540178571429	224	6	100	0	1	224	393	170	Haloferula helveola strain sediment_39 16S ribosomal RNA gene, partial sequence	blastn	22521	381	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula helveola
2897509	2897509	PRJNA1237888_S_NODE_4103_length_202_cov_2.052288_g4053_i0	PRJNA1237888	4103	202	2.052288	4.14562176	Aquisphaera giovannonii	406548	Bacteria	Bacteria	252	1.62e-62	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g4053	i0	89.109	136.89603960396	202	22	100	0	1	202	5180848	5181049	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	27653	252	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
4173809	4173809	PRJNA1237888_S_NODE_2864_length_239_cov_2.126316_g2814_i0	PRJNA1237888	2864	239	2.126316	5.08189524	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	259	1.18e-64	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g2814	i0	86.192	38.2803347280335	239	33	100	0	1	239	1600492	1600730	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	9149	259	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
6724500	6724500	PRJNA1237888_S_NODE_3246_length_225_cov_3.130682_g3196_i0	PRJNA1237888	3246	225	3.130682	7.0440345	Paludisphaera borealis	1387353	Bacteria	Bacteria	344	2.95e-90	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g3196	i0	94.222	181.915555555556	225	13	100	0	1	225	121260	121484	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	40931	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
8000037	8000037	PRJNA1237888_S_NODE_7387_length_162_cov_1.247788_g7337_i0	PRJNA1237888	7387	162	1.247788	2.02141656	Aquisphaera giovannonii	406548	Bacteria	Bacteria	237	3.47e-58	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g7337	i0	94.194	42.6296296296296	155	9	99	0	2	156	5179094	5179248	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	6906	237	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
8702752	8702752	PRJNA1237888_S_NODE_3407_length_220_cov_1.134503_g3357_i0	PRJNA1237888	3407	220	1.134503	2.4959066	Bacteria	2	Bacteria	Bacteria	307	3.77e-79	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g3357	i0	91.818	148.622727272727	220	18	100	0	1	220	4420618	4420399	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	32697	307	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
9274887	9274887	PRJNA1237888_S_NODE_6568_length_166_cov_1.299145_g6518_i0	PRJNA1237888	6568	166	1.299145	2.1565807	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	195	2.18e-45	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g6518	i0	91.034	70.3734939759036	145	11	87	2	1	144	4421177	4421320	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	11682	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
10550716	10550716	PRJNA1237888_S_NODE_5069_length_183_cov_2.044776_g5019_i0	PRJNA1237888	5069	183	2.044776	3.74194008	Urbifossiella limnaea	2528023	Bacteria	Bacteria	274	3.06e-69	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g5019	i0	93.956	165.48087431694	182	10	99	1	1	181	2018207	2018388	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	30283	274	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
11825421	11825421	PRJNA1237888_S_NODE_550_length_520_cov_3.318471_g501_i0	PRJNA1237888	550	520	3.318471	17.2560492	Aquisphaera giovannonii	406548	Bacteria	Bacteria	736	0	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g501	i0	93.069	142.255769230769	505	32	98	2	13	517	5178790	5179291	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	73973	736	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
14375660	14375660	PRJNA1237888_S_NODE_1932_length_295_cov_1.439024_g1882_i0	PRJNA1237888	1932	295	1.439024	4.2451208	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	523	4.829999999999998e-144	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g1882	i0	98.644	248.159322033898	295	4	100	0	1	295	3892525	3892819	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	73207	523	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15649642	15649642	PRJNA1237888_S_NODE_4953_length_185_cov_1.529412_g4903_i0	PRJNA1237888	4953	185	1.529412	2.8294122	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	331	1.81e-86	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g4903	i0	98.919	205.454054054054	185	2	100	0	1	185	913341	913157	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	38009	331	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15649662	15649662	PRJNA1237888_S_NODE_7113_length_163_cov_3.464912_g7063_i0	PRJNA1237888	7113	163	3.464912	5.64780656	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	222	9.79e-54	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g7063	i0	91.411	218.122699386503	163	12	100	2	1	163	4319720	4319880	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	35554	222	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
16352246	16352246	PRJNA1237888_S_NODE_1833_length_304_cov_1.266667_g1783_i0	PRJNA1237888	1833	304	1.266667	3.85066768	Verrucomicrobiales	48461	Bacteria	Bacteria	453	6.65e-123	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g1783	i0	93.98	241.282894736842	299	18	98	0	6	304	3412369	3412667	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	73350	453	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
18198351	18198351	PRJNA1237888_S_NODE_3215_length_226_cov_1.338983_g3165_i0	PRJNA1237888	3215	226	1.338983	3.02610158	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	313	8.36e-81	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g3165	i0	91.63	141.628318584071	227	18	100	1	1	226	4467086	4466860	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	32008	313	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
18198375	18198375	PRJNA1237888_S_NODE_95_length_954_cov_6.169061_g72_i0	PRJNA1237888	95	954	6.169061	58.85284194	Urbifossiella limnaea	2528023	Bacteria	Bacteria	1009	0	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g72	i0	86.306	515.079664570231	942	111	98	9	1	938	2018011	2018938	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	491386	1009	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
20175993	20175993	PRJNA1237888_S_NODE_4376_length_196_cov_5.938776_g4326_i0	PRJNA1237888	4376	196	5.938776	11.64000096	Planctomycetia	203683	Bacteria	Bacteria	298	1.97e-76	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g4326	i0	94.819	151.464285714286	193	6	98	4	1	192	122625	122436	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	29687	298	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
20748162	20748162	PRJNA1237888_S_NODE_3317_length_223_cov_1.603448_g3267_i0	PRJNA1237888	3317	223	1.603448	3.57568904	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	363	8.049999999999997e-96	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g3267	i0	95.964	176.690582959641	223	9	100	0	1	223	3892872	3893094	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	39402	363	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20748172	20748172	PRJNA1237888_S_NODE_4957_length_185_cov_1.463235_g4907_i0	PRJNA1237888	4957	185	1.463235	2.70698475	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	259	8.67e-65	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g4907	i0	91.892	311.935135135135	185	15	100	0	1	185	4718683	4718867	Luteolibacter sp. SL250 chromosome	blastn	57708	259	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
20748178	20748178	PRJNA1237888_S_NODE_6017_length_169_cov_1.300000_g5967_i0	PRJNA1237888	6017	169	1.3	2.197	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	292	7.64e-75	NTclustered	gi\|2874254020\|emb\|OY970345.1\|	412056	g5967	i0	98.214	111.846153846154	168	2	99	1	1	167	3894288	3894121	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04212.bin.2.122 genome assembly, chromosome: 1	blastn	18902	292	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22023446	22023446	PRJNA1237888_S_NODE_1718_length_316_cov_1.393258_g1668_i0	PRJNA1237888	1718	316	1.393258	4.40269528	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	372	1.9999999999999992e-98	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g1668	i0	89.073	41.4303797468354	302	30	96	3	1	301	5936173	5936472	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	13092	372	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
23299090	23299090	PRJNA1237888_S_NODE_4119_length_202_cov_1.215686_g4069_i0	PRJNA1237888	4119	202	1.215686	2.45568572	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	254	4.4900000000000003e-63	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g4069	i0	94.512	207.905940594059	164	9	81	0	39	202	2623042	2623205	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	41997	254	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
24572959	24572959	PRJNA1237888_S_NODE_7100_length_163_cov_5.500000_g7050_i0	PRJNA1237888	7100	163	5.5	8.965	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	134	4.72e-27	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g7050	i0	87.179	191.40490797546	117	15	74	0	4	120	4317205	4317089	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	31199	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae 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);;