metadata: contig_metadata: 33 rows where analysis = "blastn", bioproject = "PRJNA561138" and tax

33 rows where analysis = "blastn", bioproject = "PRJNA561138" 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
545130	545130	PRJNA561138_P_NODE_5901_length_510_cov_1.409611_g5707_i0	PRJNA561138	5901	510	1.409611	7.1890161	Rohdeia mirabilis	2528008	Bacteria	Bacteria	372	3.37e-98	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g5707	i0	83.014	12.5823529411765	418	63	81	8	52	465	3743823	3744236	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	6417	372	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
1820689	1820689	PRJNA561138_P_NODE_19042_length_298_cov_1.026667_g18847_i0	PRJNA561138	19042	298	1.026667	3.05946766	Saltatorellus ferox	2528018	Bacteria	Bacteria	268	2.53e-67	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g18847	i0	84.559	92.741610738255	272	40	91	2	5	275	2721559	2721829	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	27637	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox
3095938	3095938	PRJNA561138_P_NODE_14443_length_345_cov_0.709559_g14248_i0	PRJNA561138	14443	345	0.709559	2.44797855	Isosphaera pallida	128	Bacteria	Bacteria	75	6.97e-9	NTclustered	gi\|319748837\|gb\|CP002353.1\|	575540	g14248	i0	92.453	0.739130434782609	53	2	15	2	32	83	4741949	4741898	Isosphaera pallida ATCC 43644, complete genome	blastn	255	75	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida
5649013	5649013	PRJNA561138_P_NODE_7585_length_452_cov_1.625330_g7390_i0	PRJNA561138	7585	452	1.62533	7.3464916	Rohdeia mirabilis	2528008	Bacteria	Bacteria	348	4.99e-91	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g7390	i0	82.439	0.907079646017699	410	60	89	10	1	404	972149	971746	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	410	348	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
6234194	6234194	PRJNA561138_P_NODE_16205_length_326_cov_1.217391_g16010_i0	PRJNA561138	16205	326	1.217391	3.96869466	Engelhardtia	139931	Bacteria	Bacteria	278	4.64e-70	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g16010	i0	82.298	16.558282208589	322	55	98	2	1	321	5225731	5226051	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	5398	278	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
6922939	6922939	PRJNA561138_P_NODE_10446_length_398_cov_0.923077_g10251_i0	PRJNA561138	10446	398	0.923077	3.67384646	Rohdeia mirabilis	2528008	Bacteria	Bacteria	272	2.69e-68	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g10251	i0	80.108	0.934673366834171	372	68	93	5	1	369	2646408	2646040	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	372	272	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
6923216	6923216	PRJNA561138_P_NODE_7546_length_453_cov_1.455263_g7351_i0	PRJNA561138	7546	453	1.455263	6.59234139	Rohdeia mirabilis	2528008	Bacteria	Bacteria	289	3.07e-73	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g7351	i0	79.851	23.4061810154525	402	75	88	6	55	453	1992586	1992984	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	10603	289	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
6923234	6923234	PRJNA561138_P_NODE_9406_length_413_cov_1.547059_g9211_i0	PRJNA561138	9406	413	1.547059	6.38935367	Rohdeia mirabilis	2528008	Bacteria	Bacteria	315	4.589999999999998e-81	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g9211	i0	80.732	12.2493946731235	410	73	99	6	2	408	277864	278270	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	5059	315	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
8197884	8197884	PRJNA561138_P_NODE_12987_length_363_cov_1.034483_g12792_i0	PRJNA561138	12987	363	1.034483	3.75517329	Rohdeia mirabilis	2528008	Bacteria	Bacteria	472	2.23e-128	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g12792	i0	91.117	101.258953168044	349	29	96	2	3	350	3447027	3446680	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	36757	472	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
8198134	8198134	PRJNA561138_P_NODE_9547_length_411_cov_1.139053_g9352_i0	PRJNA561138	9547	411	1.139053	4.68150783	Rohdeia mirabilis	2528008	Bacteria	Bacteria	342	2.0899999999999994e-89	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g9352	i0	83.733	47.2165450121654	375	48	90	13	29	396	3798453	3798085	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	19406	342	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
8783572	8783572	PRJNA561138_P_NODE_27407_length_246_cov_0.890173_g27212_i0	PRJNA561138	27407	246	0.890173	2.18982558	Engelhardtia	139931	Bacteria	Bacteria	233	7.39e-57	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g27212	i0	84.681	6.1260162601626	235	34	95	2	9	242	2386071	2386304	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	1507	233	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
10749515	10749515	PRJNA561138_P_NODE_7949_length_443_cov_0.827027_g7754_i0	PRJNA561138	7949	443	0.827027	3.66372961	Rohdeia mirabilis	2528008	Bacteria	Bacteria	207	8.64e-49	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g7754	i0	81.154	2.16930022573363	260	47	58	2	185	443	3239941	3240199	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	961	207	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
12024056	12024056	PRJNA561138_P_NODE_13050_length_362_cov_1.065744_g12855_i0	PRJNA561138	13050	362	1.065744	3.85799328	Planctomycetota bacterium	2026780	Bacteria	Bacteria	176	1.95e-39	NTclustered	gi\|1850852299\|gb\|CP053450.1\|	2026780	g12855	i0	78.125	3.54972375690608	288	55	78	7	12	292	3679248	3678962	MAG: Planctomycetota bacterium isolate PNC22 chromosome	blastn	1285	176	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
12024302	12024302	PRJNA561138_P_NODE_9210_length_417_cov_0.895349_g9015_i0	PRJNA561138	9210	417	0.895349	3.73360533	Saltatorellus ferox	2528018	Bacteria	Bacteria	344	5.91e-90	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g9015	i0	82.039	31.7937649880096	412	66	98	8	1	408	95452	95045	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	13258	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox
13299234	13299234	PRJNA561138_P_NODE_29851_length_241_cov_0.916667_g29656_i0	PRJNA561138	29851	241	0.916667	2.20916747	Rohdeia mirabilis	2528008	Bacteria	Bacteria	241	4.310000000000001e-59	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g29656	i0	84.774	4.68464730290456	243	33	100	3	1	241	3838545	3838785	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	1129	241	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
13299290	13299290	PRJNA561138_P_NODE_9891_length_406_cov_0.957958_g9696_i0	PRJNA561138	9891	406	0.957958	3.88930948	Rohdeia mirabilis	2528008	Bacteria	Bacteria	209	2.18e-49	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g9696	i0	76.642	1.33497536945813	411	76	99	20	6	406	2989379	2988979	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	542	209	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
14573936	14573936	PRJNA561138_P_NODE_13052_length_362_cov_1.065744_g12857_i0	PRJNA561138	13052	362	1.065744	3.85799328	Rohdeia mirabilis	2528008	Bacteria	Bacteria	202	3.22e-47	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g12857	i0	82.819	37.8342541436464	227	37	62	2	137	362	3050626	3050401	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	13696	202	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
14574088	14574088	PRJNA561138_P_NODE_25932_length_249_cov_0.875000_g25737_i0	PRJNA561138	25932	249	0.875	2.17875	Rohdeia mirabilis	2528008	Bacteria	Bacteria	261	3.44e-65	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g25737	i0	85.6	78.289156626506	250	34	100	2	1	249	4349770	4349522	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	19494	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
14574184	14574184	PRJNA561138_P_NODE_8892_length_422_cov_1.765043_g8697_i0	PRJNA561138	8892	422	1.765043	7.44848146	Rohdeia mirabilis	2528008	Bacteria	Bacteria	433	1.2399999999999998e-116	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g8697	i0	86.064	45.5023696682464	409	49	96	6	18	422	964	1368	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	19202	433	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
15158717	15158717	PRJNA561138_P_NODE_7752_length_448_cov_1.026667_g7557_i0	PRJNA561138	7752	448	1.026667	4.59946816	Engelhardtia	139931	Bacteria	Bacteria	414	4.799999999999999e-111	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g7557	i0	83.519	54.0870535714286	449	68	99	6	3	448	3230131	3230576	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	24231	414	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
15847971	15847971	PRJNA561138_P_NODE_26553_length_248_cov_0.880000_g26358_i0	PRJNA561138	26553	248	0.88	2.1824	Rohdeia mirabilis	2528008	Bacteria	Bacteria	204	5.849999999999999e-48	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g26358	i0	84.878	138.754032258065	205	27	82	4	1	203	587779	587981	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	34411	204	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
15848042	15848042	PRJNA561138_P_NODE_4733_length_569_cov_1.062500_g4543_i0	PRJNA561138	4733	569	1.0625	6.045625	Rohdeia mirabilis	2528008	Bacteria	Bacteria	399	1.7399999999999996e-106	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g4543	i0	79.859	5.71001757469244	566	98	98	15	1	558	4390146	4389589	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	3249	399	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
16433312	16433312	PRJNA561138_P_NODE_16993_length_318_cov_0.942857_g16798_i0	PRJNA561138	16993	318	0.942857	2.99828526	Engelhardtia	139931	Bacteria	Bacteria	274	5.84e-69	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g16798	i0	87.66	5.09748427672956	235	29	74	0	1	235	1165738	1165972	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	1621	274	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
16433325	16433325	PRJNA561138_P_NODE_21613_length_276_cov_1.137931_g21418_i0	PRJNA561138	21613	276	1.137931	3.14068956	Engelhardtia	139931	Bacteria	Bacteria	244	3.9e-60	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g21418	i0	83.099	3.88768115942029	284	32	100	12	1	276	2153508	2153783	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	1073	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
17122638	17122638	PRJNA561138_P_NODE_10094_length_403_cov_0.933333_g9899_i0	PRJNA561138	10094	403	0.933333	3.76133199	Rohdeia mirabilis	2528008	Bacteria	Bacteria	446	1.52e-120	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g9899	i0	86.634	22.5111662531017	404	52	100	2	1	403	3834089	3834491	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	9072	446	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
17122643	17122643	PRJNA561138_P_NODE_10874_length_391_cov_0.968553_g10679_i0	PRJNA561138	10874	391	0.968553	3.78704223	Rohdeia mirabilis	2528008	Bacteria	Bacteria	291	7.28e-74	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g10679	i0	86.466	72.1329923273657	266	34	68	2	1	265	3981336	3981600	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	28204	291	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
18396914	18396914	PRJNA561138_P_NODE_19475_length_294_cov_1.045249_g19280_i0	PRJNA561138	19475	294	1.045249	3.07303206	Rohdeia mirabilis	2528008	Bacteria	Bacteria	89.8	2.08e-13	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g19280	i0	83.871	0.316326530612245	93	15	32	0	151	243	230547	230639	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	93	89.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
19671448	19671448	PRJNA561138_P_NODE_11716_length_379_cov_1.006536_g11521_i0	PRJNA561138	11716	379	1.006536	3.81477144	Phycisphaeraceae bacterium D3-23	3004190	Bacteria	Bacteria	169	3.4399999999999997e-37	NTclustered	gi\|2727577647\|gb\|CP114179.1\|	3004190	g11521	i0	80.258	49.6437994722955	233	39	60	6	147	374	4192287	4192517	Phycisphaeraceae bacterium D3-23 chromosome, complete genome	blastn	18815	169	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium D3-23
22222024	22222024	PRJNA561138_P_NODE_11118_length_387_cov_1.114650_g10923_i0	PRJNA561138	11118	387	1.11465	4.3136955	Rohdeia mirabilis	2528008	Bacteria	Bacteria	139	2.76e-28	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g10923	i0	100	39.405684754522	75	0	19	0	119	193	1579168	1579242	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	15250	139	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
22222195	22222195	PRJNA561138_P_NODE_26718_length_247_cov_0.885057_g26523_i0	PRJNA561138	26718	247	0.885057	2.18609079	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	63.9	1.03e-5	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g26523	i0	100	11.8259109311741	34	0	15	0	143	176	182369	182402	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	2921	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
22807733	22807733	PRJNA561138_P_NODE_10198_length_401_cov_1.384146_g10003_i0	PRJNA561138	10198	401	1.384146	5.55042546	Engelhardtia	139931	Bacteria	Bacteria	187	1.0099999999999999e-42	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g10003	i0	86.471	12.1221945137157	170	23	42	0	24	193	2154061	2154230	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	4861	187	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
24082574	24082574	PRJNA561138_P_NODE_25099_length_250_cov_0.870056_g24904_i0	PRJNA561138	25099	250	0.870056	2.17514	Engelhardtia	139931	Bacteria	Bacteria	213	9.81e-51	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g24904	i0	82.072	6.056	251	43	100	2	1	250	4946362	4946611	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	1514	213	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
24771455	24771455	PRJNA561138_P_NODE_7480_length_455_cov_1.154450_g7285_i0	PRJNA561138	7480	455	1.15445	5.2527475	Saltatorellus ferox	2528018	Bacteria	Bacteria	189	3.2199999999999993e-43	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g7285	i0	78.689	3.1516483516483502	305	50	65	11	8	303	4681545	4681247	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	1434	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox

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