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

25 rows where analysis = "blastn", bioproject = "PRJNA635874" 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
607517	607517	PRJNA635874_P_NODE_41081_length_266_cov_0.963731_g40934_i0	PRJNA635874	41081	266	0.963731	2.56352446	Gemmataceae bacterium	2052164	Bacteria	Bacteria	357	4.6e-94	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g40934	i0	90.977	10.3045112781955	266	22	99	2	1	265	4327435	4327171	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	2741	357	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
607702	607702	PRJNA635874_P_NODE_47741_length_251_cov_0.865169_g47594_i0	PRJNA635874	47741	251	0.865169	2.17157419	Planctomycetes bacterium MalM25	2527998	Bacteria	Bacteria	99	2.88e-16	NTclustered	gi\|1712524857\|gb\|CP036424.1\|	2527998	g47594	i0	87.952	12.9721115537849	83	10	33	0	162	244	498470	498552	Planctomycetes bacterium MalM25 chromosome	blastn	3256	99	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium MalM25
1884435	1884435	PRJNA635874_P_NODE_70202_length_242_cov_0.911243_g70055_i0	PRJNA635874	70202	242	0.911243	2.20520806	Gemmataceae bacterium	2052164	Bacteria	Bacteria	156	1.6200000000000002e-33	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g70055	i0	90.598	0.483471074380165	117	11	48	0	1	117	6604499	6604615	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	117	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
3157879	3157879	PRJNA635874_P_NODE_21583_length_343_cov_0.855556_g21436_i0	PRJNA635874	21583	343	0.855556	2.93455708	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	263	1.3800000000000001e-65	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g21436	i0	82.781	0.880466472303207	302	44	87	8	46	343	485341	485638	Luteolibacter sp. SL250 chromosome	blastn	302	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
3158908	3158908	PRJNA635874_P_NODE_60643_length_246_cov_0.890173_g60496_i0	PRJNA635874	60643	246	0.890173	2.18982558	Gemmataceae bacterium	2052164	Bacteria	Bacteria	350	7.04e-92	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g60496	i0	92.276	1	246	19	100	0	1	246	4302093	4301848	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	246	350	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
3159115	3159115	PRJNA635874_P_NODE_68623_length_243_cov_0.864706_g68476_i0	PRJNA635874	68623	243	0.864706	2.10123558	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	250	7.2399999999999995e-62	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g68476	i0	85.185	1.76543209876543	243	36	100	0	1	243	2500034	2500276	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	429	250	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
3159214	3159214	PRJNA635874_P_NODE_72443_length_241_cov_0.916667_g72296_i0	PRJNA635874	72443	241	0.916667	2.20916747	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	407	4.0199999999999995e-109	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g72296	i0	97.095	1	241	7	100	0	1	241	5778811	5778571	Planctomyces sp. SH-PL14, complete genome	blastn	241	407	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
5711593	5711593	PRJNA635874_P_NODE_56565_length_247_cov_0.885057_g56418_i0	PRJNA635874	56565	247	0.885057	2.18609079	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	374	4.189999999999998e-99	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g56418	i0	93.927	91.6761133603239	247	15	100	0	1	247	2448460	2448706	Luteolibacter sp. SL250 chromosome	blastn	22644	374	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
8260774	8260774	PRJNA635874_P_NODE_41547_length_264_cov_1.549738_g41400_i0	PRJNA635874	41547	264	1.549738	4.0913083200000004	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	207	4.86e-49	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g41400	i0	81.226	0.988636363636364	261	45	98	3	1	259	4498856	4499114	Luteolibacter sp. SL250 chromosome	blastn	261	207	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
8261409	8261409	PRJNA635874_P_NODE_67867_length_243_cov_0.905882_g67720_i0	PRJNA635874	67867	243	0.905882	2.20129326	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	300	7.08e-77	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g67720	i0	88.98	1.16049382716049	245	23	100	4	1	243	672582	672824	Luteolibacter sp. SL250 chromosome	blastn	282	300	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
10812024	10812024	PRJNA635874_P_NODE_51269_length_249_cov_0.875000_g51122_i0	PRJNA635874	51269	249	0.875	2.17875	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	379	9.1e-101	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g51122	i0	94.672	0.979919678714859	244	13	98	0	6	249	2583217	2583460	Luteolibacter sp. SL250 chromosome	blastn	244	379	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
10812348	10812348	PRJNA635874_P_NODE_65449_length_244_cov_0.900585_g65302_i0	PRJNA635874	65449	244	0.900585	2.1974274	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	451	1.86e-122	NTclustered	gi\|391225846\|gb\|JQ861342.1\|	120965	g65302	i0	100	95.5450819672131	244	0	100	0	1	244	1510	1267	Uncultured planctomycete clone JZ44 16S ribosomal RNA gene, partial sequence	blastn	23313	451	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
10812381	10812381	PRJNA635874_P_NODE_67029_length_243_cov_0.905882_g66882_i0	PRJNA635874	67029	243	0.905882	2.20129326	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	322	1.51e-83	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g66882	i0	90.535	40.4485596707819	243	23	100	0	1	243	1317258	1317016	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	9829	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13361895	13361895	PRJNA635874_P_NODE_48411_length_250_cov_1.644068_g48264_i0	PRJNA635874	48411	250	1.644068	4.11017	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	252	2.08e-62	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g48264	i0	84.8	1	250	38	100	0	1	250	1755538	1755289	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	250	252	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
13362188	13362188	PRJNA635874_P_NODE_61471_length_245_cov_0.895349_g61324_i0	PRJNA635874	61471	245	0.895349	2.19360505	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	250	7.31e-62	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g61324	i0	85.714	0.971428571428571	238	32	97	2	9	245	2302924	2303160	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	238	250	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
13362233	13362233	PRJNA635874_P_NODE_63271_length_245_cov_0.889535_g63124_i0	PRJNA635874	63271	245	0.889535	2.17936075	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	95.3	3.62e-15	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g63124	i0	89.474	0.310204081632653	76	6	31	2	23	97	1085158	1085084	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	76	95.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
17185614	17185614	PRJNA635874_P_NODE_44674_length_255_cov_1.373626_g44527_i0	PRJNA635874	44674	255	1.373626	3.5027463	Gemmataceae bacterium	2052164	Bacteria	Bacteria	196	1.01e-45	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g44527	i0	95.161	1.29019607843137	124	6	49	0	2	125	1491265	1491388	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	329	196	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
17185743	17185743	PRJNA635874_P_NODE_50634_length_250_cov_0.864407_g50487_i0	PRJNA635874	50634	250	0.864407	2.1610175	Gemmataceae bacterium	2052164	Bacteria	Bacteria	163	1e-35	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g50487	i0	89.922	1.284	129	9	52	4	118	246	6021263	6021387	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	321	163	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
17185830	17185830	PRJNA635874_P_NODE_54494_length_248_cov_0.880000_g54347_i0	PRJNA635874	54494	248	0.88	2.1824	Candidatus Uabimicrobium helgolandensis	3095367	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2793194503\|gb\|CP165719.1\|	3095367	g54347	i0	94.444	0.145161290322581	36	1	15	1	189	224	4440646	4440612	Candidatus Uabimicrobium helgolandensis strain HlEnr_7 chromosome	blastn	36	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Uabimicrobiia	Candidatus Uabimicrobiales	Candidatus Uabimicrobiaceae	Candidatus Uabimicrobium	Candidatus Uabimicrobium helgolandensis
19734726	19734726	PRJNA635874_P_NODE_60876_length_245_cov_2.325581_g60729_i0	PRJNA635874	60876	245	2.325581	5.69767345	Gemmataceae bacterium	2052164	Bacteria	Bacteria	206	1.6e-48	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g60729	i0	96.748	27.7836734693878	123	4	50	0	123	245	6413481	6413603	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	6807	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
21009755	21009755	PRJNA635874_P_NODE_35777_length_282_cov_1.368421_g35630_i0	PRJNA635874	35777	282	1.368421	3.85894722	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	322	1.8e-83	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g35630	i0	90.535	1.62765957446809	243	23	86	0	39	281	37929	38171	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	459	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
21010344	21010344	PRJNA635874_P_NODE_57737_length_247_cov_0.885057_g57590_i0	PRJNA635874	57737	247	0.885057	2.18609079	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	350	7.07e-92	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g57590	i0	92.276	71.0404858299595	246	19	99	0	1	246	4573390	4573635	Luteolibacter sp. SL250 chromosome	blastn	17547	350	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
22284978	22284978	PRJNA635874_P_NODE_55718_length_248_cov_0.874286_g55571_i0	PRJNA635874	55718	248	0.874286	2.16822928	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	337	5.53e-88	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g55571	i0	91.429	1.12903225806452	245	21	99	0	4	248	1086390	1086146	Luteolibacter sp. SL250 chromosome	blastn	280	337	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
22285150	22285150	PRJNA635874_P_NODE_63178_length_245_cov_0.895349_g63031_i0	PRJNA635874	63178	245	0.895349	2.19360505	Kolteria novifilia	2527975	Bacteria	Bacteria	93.5	1.3e-14	NTclustered	gi\|1712629967\|gb\|CP036279.1\|	2527975	g63031	i0	88.312	24.9714285714286	77	9	31	0	135	211	6301152	6301228	Planctomycetes bacterium Pan216 chromosome, complete genome	blastn	6118	93.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Kolteriales	Kolteriaceae	Kolteria	Kolteria novifilia
23560836	23560836	PRJNA635874_P_NODE_69639_length_242_cov_0.911243_g69492_i0	PRJNA635874	69639	242	0.911243	2.20520806	Gemmataceae bacterium	2052164	Bacteria	Bacteria	233	7.25e-57	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g69492	i0	96.454	26.797520661157	141	5	58	0	102	242	7586521	7586661	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	6485	233	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae 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);;