metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA577580" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA577580" 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
1839532	1839532	PRJNA577580_P_NODE_4722_length_412_cov_2.463127_g4644_i0	PRJNA577580	4722	412	2.463127	10.14808324	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	534	3.22e-147	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g4644	i0	90.097	108.296116504854	414	37	99	4	1	410	657252	656839	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	44618	534	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
1839585	1839585	PRJNA577580_P_NODE_9702_length_293_cov_3.290909_g9624_i0	PRJNA577580	9702	293	3.290909	9.64236337	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	276	1.48e-69	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g9624	i0	84.407	106.37542662116	295	31	98	14	1	287	1316336	1316623	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	31168	276	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
3114891	3114891	PRJNA577580_P_NODE_10603_length_282_cov_1.545455_g10525_i0	PRJNA577580	10603	282	1.545455	4.3581831	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	379	1.05e-100	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g10525	i0	91.103	93.3794326241135	281	24	99	1	2	282	1315200	1314921	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	26333	379	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4391568	4391568	PRJNA577580_P_NODE_9484_length_296_cov_3.143498_g9406_i0	PRJNA577580	9484	296	3.143498	9.30475408	Fontisphaera persica	2974023	Bacteria	Bacteria	361	4.02e-95	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g9406	i0	88.487	167.932432432432	304	27	100	2	1	296	3862987	3862684	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	49708	361	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
5667716	5667716	PRJNA577580_P_NODE_13925_length_251_cov_1.752809_g13847_i0	PRJNA577580	13925	251	1.752809	4.39955059	Rohdeia mirabilis	2528008	Bacteria	Bacteria	202	2.13e-47	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g13847	i0	81.323	271.462151394422	257	40	99	6	2	251	3894538	3894793	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	68137	202	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
5667726	5667726	PRJNA577580_P_NODE_15145_length_246_cov_3.560694_g15067_i0	PRJNA577580	15145	246	3.560694	8.75930724	Rohdeia mirabilis	2528008	Bacteria	Bacteria	211	3.46e-50	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g15067	i0	85.572	5.74390243902439	201	29	82	0	1	201	3894812	3895012	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	1413	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
6942204	6942204	PRJNA577580_P_NODE_16806_length_234_cov_2.869565_g16728_i0	PRJNA577580	16806	234	2.869565	6.7147821	Fontisphaera persica	2974023	Bacteria	Bacteria	137	5.62e-28	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g16728	i0	78.059	35.7051282051282	237	38	98	11	5	234	3862460	3862689	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	8355	137	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
9492375	9492375	PRJNA577580_P_NODE_1028_length_874_cov_4.686642_g963_i0	PRJNA577580	1028	874	4.686642	40.96125108	Methylacidiphilum caldifontis	2795386	Bacteria	Bacteria	54.7	0.025	NTclustered	gi\|1999107441\|gb\|CP065957.1\|	2795386	g963	i0	100	0.0331807780320366	29	0	3	0	458	486	88122	88150	Methylacidiphilum caldifontis strain IT6 chromosome, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales	Methylacidiphilaceae	Methylacidiphilum (ex Ratnadevi et al. 2023)	Methylacidiphilum caldifontis
9492479	9492479	PRJNA577580_P_NODE_6168_length_362_cov_1.328720_g6090_i0	PRJNA577580	6168	362	1.32872	4.8099664	Saltatorellus ferox	2528018	Bacteria	Bacteria	226	1.91e-54	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g6090	i0	83.004	242.914364640884	253	39	69	4	2	252	2930756	2931006	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	87935	226	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox
12043168	12043168	PRJNA577580_P_NODE_790_length_985_cov_3.639254_g734_i0	PRJNA577580	790	985	3.639254	35.8466519	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1447	0	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g734	i0	93.219	243.881218274112	988	60	99	7	4	985	1316328	1315342	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	240223	1447	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13317976	13317976	PRJNA577580_P_NODE_11451_length_272_cov_3.125628_g11373_i0	PRJNA577580	11451	272	3.125628	8.50170816	Stieleria maiorica	2795974	Bacteria	Bacteria	71.3	6.89e-8	NTclustered	gi\|1726207917\|gb\|CP036264.1\|	2795974	g11373	i0	97.561	5.30882352941176	41	1	15	0	105	145	8440264	8440304	Stieleria maiorica strain Mal15 chromosome	blastn	1444	71.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria maiorica
16440810	16440810	PRJNA577580_P_NODE_14153_length_250_cov_2.316384_g14075_i0	PRJNA577580	14153	250	2.316384	5.79096	Bacteria	2	Bacteria	Bacteria	351	1.99e-92	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g14075	i0	93.033	187.908	244	12	97	3	9	250	654422	654662	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	46977	351	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
17141708	17141708	PRJNA577580_P_NODE_6354_length_356_cov_2.530035_g6276_i0	PRJNA577580	6354	356	2.530035	9.0069246	Planctomycetota bacterium	2026780	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|2107958177\|gb\|CP070790.1\|	2026780	g6276	i0	100	0.0842696629213483	30	0	8	0	321	350	338829	338858	MAG: Planctomycetota bacterium isolate bin1449 chromosome	blastn	30	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
20966160	20966160	PRJNA577580_P_NODE_10257_length_286_cov_3.267606_g10179_i0	PRJNA577580	10257	286	3.267606	9.34535316	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	339	1.8099999999999997e-88	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g10179	i0	89.011	161.405594405594	273	30	100	0	13	285	2060075	2059803	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	46162	339	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
21540078	21540078	PRJNA577580_P_NODE_8337_length_314_cov_1.153527_g8259_i0	PRJNA577580	8337	314	1.153527	3.62207478	Engelhardtia	139931	Bacteria	Bacteria	416	9.039999999999999e-112	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g8259	i0	90.764	216.445859872611	314	25	99	4	3	314	5248522	5248211	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	67964	416	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
22241103	22241103	PRJNA577580_P_NODE_1218_length_812_cov_4.719892_g1151_i0	PRJNA577580	1218	812	4.719892	38.32552304	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	981	0	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g1151	i0	88.93	192.454433497537	804	78	98	11	1	796	654603	655403	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	156273	981	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
23516465	23516465	PRJNA577580_P_NODE_3639_length_472_cov_2.862155_g3561_i0	PRJNA577580	3639	472	2.862155	13.5093716	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	359	2.42e-94	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g3561	i0	87.5	148.845338983051	312	38	66	1	7	317	1315231	1314920	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	70255	359	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
24790192	24790192	PRJNA577580_P_NODE_3860_length_458_cov_1.750649_g3782_i0	PRJNA577580	3860	458	1.750649	8.01797242	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	569	9.919999999999996e-158	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g3782	i0	89.254	67.410480349345	456	48	99	1	1	455	1316065	1316520	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	30874	569	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae 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);;