metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA1104180" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA1104180" 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
212484	212484	PRJNA1104180_P_NODE_5481_length_399_cov_1.871166_g5339_i0	PRJNA1104180	5481	399	1.871166	7.46595234	Caulifigura coniformis	2527983	Bacteria	Bacteria	719	0	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g5339	i0	99.246	111.809523809524	398	3	99	0	1	398	2926754	2927151	Caulifigura coniformis strain Pan44 chromosome	blastn	44612	719	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
1487099	1487099	PRJNA1104180_P_NODE_25522_length_242_cov_1.455621_g25379_i0	PRJNA1104180	25522	242	1.455621	3.52260282	Planctomycetes bacterium MalM25	2527998	Bacteria	Bacteria	148	2.6999999999999997e-31	NTclustered	gi\|1712524857\|gb\|CP036424.1\|	2527998	g25379	i0	85.034	60.896694214876	147	20	60	2	2	147	4653267	4653412	Planctomycetes bacterium MalM25 chromosome	blastn	14737	148	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium MalM25
1487161	1487161	PRJNA1104180_P_NODE_4902_length_417_cov_2.523256_g4760_i0	PRJNA1104180	4902	417	2.523256	10.52197752	Urbifossiella limnaea	2528023	Bacteria	Bacteria	704	0	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g4760	i0	97.129	399.817745803357	418	11	100	1	1	417	2018303	2018720	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	166724	704	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
4038991	4038991	PRJNA1104180_P_NODE_12044_length_296_cov_4.035874_g11902_i0	PRJNA1104180	12044	296	4.035874	11.94618704	Caulifigura coniformis	2527983	Bacteria	Bacteria	520	6.2699999999999985e-143	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g11902	i0	98.316	79.9898648648649	297	4	100	1	1	296	2925303	2925007	Caulifigura coniformis strain Pan44 chromosome	blastn	23677	520	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
8673499	8673499	PRJNA1104180_P_NODE_2047_length_607_cov_1.986891_g1906_i0	PRJNA1104180	2047	607	1.986891	12.06042837	Candidatus Xiphinematobacter	134550	Bacteria	Bacteria	664	0	NTclustered	gi\|939198278\|gb\|CP012665.1\|	1704307	g1906	i0	89.827	134.505766062603	521	48	85	5	90	607	15161	15679	Candidatus Xiphinematobacter sp. Idaho Grape, complete genome	blastn	81645	665	0.998496240601504	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria			Candidatus Xiphinematobacter	Candidatus Xiphinematobacter sp. Idaho Grape
9139903	9139903	PRJNA1104180_P_NODE_17988_length_261_cov_1.648936_g17846_i0	PRJNA1104180	17988	261	1.648936	4.30372296	planctomycete str. 658	149590	Bacteria	Bacteria	189	1.7399999999999999e-43	NTclustered	gi\|12583971\|gb\|AF245375.1\|AF245375	149590	g17846	i0	90.278	12.3984674329502	144	14	55	0	1	144	1275	1418	Planctomycete str. 658 23S ribosomal RNA gene, partial sequence	blastn	3236	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 658
9139977	9139977	PRJNA1104180_P_NODE_22788_length_247_cov_0.885057_g22645_i0	PRJNA1104180	22788	247	0.885057	2.18609079	Humisphaera borealis	2807512	Bacteria	Bacteria	379	9.02e-101	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g22645	i0	95.021	5.51012145748988	241	12	99	0	2	242	5063481	5063721	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	1361	379	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
9948478	9948478	PRJNA1104180_P_NODE_2308_length_576_cov_4.892644_g2167_i0	PRJNA1104180	2308	576	4.892644	28.18162944	Planctomycetaceae	126	Bacteria	Bacteria	472	3.68e-128	NTclustered	gi\|1712468061\|gb\|CP036265.1\|	2527989	g2167	i0	82.021	126.210069444444	584	78	100	24	1	576	373380	373944	Alienimonas californiensis strain CA12 chromosome	blastn	72697	473	0.997885835095137	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Alienimonas	Alienimonas californiensis
10415624	10415624	PRJNA1104180_P_NODE_1049_length_848_cov_2.581935_g916_i0	PRJNA1104180	1049	848	2.581935	21.8948088	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	758	0	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g916	i0	87.24	109.390330188679	674	74	98	10	179	848	4422192	4421527	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	92763	758	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
11691074	11691074	PRJNA1104180_P_NODE_23130_length_246_cov_0.890173_g22987_i0	PRJNA1104180	23130	246	0.890173	2.18982558	Aquisphaera giovannonii	406548	Bacteria	Bacteria	394	3.2e-105	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g22987	i0	95.528	74.0121951219512	246	11	100	0	1	246	5179264	5179019	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	18207	394	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
11691158	11691158	PRJNA1104180_P_NODE_3150_length_501_cov_4.046729_g3009_i0	PRJNA1104180	3150	501	4.046729	20.27411229	Stratiformator vulcanicus	2527980	Bacteria	Bacteria	634	3.8199999999999996e-177	NTclustered	gi\|1712491480\|gb\|CP036268.1\|	2527980	g3009	i0	91.064	130.500998003992	470	41	94	1	32	501	3082732	3082264	Stratiformator vulcanicus strain Pan189 chromosome	blastn	65381	634	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus
12966314	12966314	PRJNA1104180_P_NODE_4311_length_441_cov_3.331522_g4169_i0	PRJNA1104180	4311	441	3.331522	14.69201202	Urbifossiella limnaea	2528023	Bacteria	Bacteria	706	0	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g4169	i0	95.485	136.473922902494	443	18	100	1	1	441	2018784	2019226	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	60185	706	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
14241192	14241192	PRJNA1104180_P_NODE_23192_length_246_cov_0.890173_g23049_i0	PRJNA1104180	23192	246	0.890173	2.18982558	Lacipirellula parvula	2650471	Bacteria	Bacteria	357	4.1999999999999997e-94	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g23049	i0	93.061	109.723577235772	245	16	99	1	1	245	5161323	5161566	Lacipirellula parvula PX69 DNA, complete genome	blastn	26992	357	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
15514877	15514877	PRJNA1104180_P_NODE_14013_length_283_cov_1.466667_g13871_i0	PRJNA1104180	14013	283	1.466667	4.15066761	Singulisphaera acidiphila	466153	Bacteria	Bacteria	281	3.06e-71	NTclustered	gi\|430012750\|gb\|CP003364.1\|	886293	g13871	i0	85.56	43.2932862190813	277	31	96	8	8	278	8381442	8381715	Singulisphaera acidiphila DSM 18658, complete genome	blastn	12252	281	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
16789556	16789556	PRJNA1104180_P_NODE_254_length_1530_cov_5.492107_g212_i0	PRJNA1104180	254	1530	5.492107	84.0292371	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	1954	0	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g212	i0	89.754	168.875163398693	1542	139	100	18	1	1530	2001641	2003175	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	258379	1954	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
18064202	18064202	PRJNA1104180_P_NODE_8155_length_342_cov_2.148699_g8013_i0	PRJNA1104180	8155	342	2.148699	7.34855058	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	438	2.1199999999999993e-118	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g8013	i0	91.277	132.175438596491	321	28	94	0	19	339	7629029	7628709	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	45204	438	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
18064206	18064206	PRJNA1104180_P_NODE_8515_length_337_cov_1.166667_g8373_i0	PRJNA1104180	8515	337	1.166667	3.93166779	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	388	2.13e-103	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g8373	i0	87.611	113.362017804154	339	36	99	6	3	337	1599567	1599231	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	38203	388	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
20613613	20613613	PRJNA1104180_P_NODE_28237_length_213_cov_5.142857_g28094_i0	PRJNA1104180	28237	213	5.142857	10.95428541	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	248	2.23e-61	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g28094	i0	87.85	6.75117370892019	214	22	99	4	1	212	2502856	2503067	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	1438	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
21422322	21422322	PRJNA1104180_P_NODE_2517_length_555_cov_2.417012_g2376_i0	PRJNA1104180	2517	555	2.417012	13.4144166	Planctomycetaceae	126	Bacteria	Bacteria	473	9.84e-129	NTclustered	gi\|1712491480\|gb\|CP036268.1\|	2527980	g2376	i0	84.139	75.5585585585586	517	52	93	12	2	517	3082268	3081781	Stratiformator vulcanicus strain Pan189 chromosome	blastn	41935	475	0.995789473684211	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus
21889054	21889054	PRJNA1104180_P_NODE_14998_length_277_cov_1.995098_g14856_i0	PRJNA1104180	14998	277	1.995098	5.52642146	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	409	1.31e-109	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g14856	i0	93.478	351.830324909747	276	17	99	1	2	277	1600411	1600137	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	97457	409	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
24438383	24438383	PRJNA1104180_P_NODE_3840_length_463_cov_4.564103_g3698_i0	PRJNA1104180	3840	463	4.564103	21.13179689	Urbifossiella limnaea	2528023	Bacteria	Bacteria	776	0	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g3698	i0	96.983	222.123110151188	464	10	99	4	1	462	4212081	4212542	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	102843	776	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea

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