metadata: contig_metadata: 26 rows where bioproject = "PRJNA408129" and tax

26 rows where bioproject = "PRJNA408129" 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
418304	418304	PRJNA408129_S_NODE_14281_length_198_cov_7.875776_g14263_i0	PRJNA408129	14281	198	7.875776	15.59403648	Blastopirellula sp. J2-11	2943192	Bacteria	Bacteria	196	7.49e-46	NTclustered	gi\|2283101653\|gb\|CP097384.1\|	2943192	g14263	i0	86.592	83.8232323232323	179	23	90	1	1	179	2919618	2919795	Blastopirellula sp. J2-11 chromosome	blastn	16597	196	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula sp. J2-11
418417	418417	PRJNA408129_S_NODE_25001_length_167_cov_2.076923_g24983_i0	PRJNA408129	25001	167	2.076923	3.46846141	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	182	1.71e-41	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g24983	i0	88.235	2.4311377245509	153	17	92	1	15	167	4422876	4422725	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	406	182	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
4910748	4910748	PRJNA408129_S_NODE_28564_length_160_cov_5.024390_g28546_i0	PRJNA408129	28564	160	5.02439	8.039024	Singulisphaera	466152	Bacteria	Bacteria	237	3.4100000000000004e-58	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g28546	i0	95.918	118.375	147	5	91	1	8	153	2272039	2271893	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	18940	237	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
6796351	6796351	PRJNA408129_S_NODE_9846_length_222_cov_8.356757_g9828_i0	PRJNA408129	9846	222	8.356757	18.55200054	Aureliella helgolandensis	2527968	Bacteria	Bacteria	254	5.03e-63	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g9828	i0	89.848	13.1621621621622	197	20	89	0	14	210	6999007	6998811	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	2922	254	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
7460670	7460670	PRJNA408129_S_NODE_26286_length_164_cov_4.716535_g26268_i0	PRJNA408129	26286	164	4.716535	7.7351174	Frigoriglobus	2774146	Bacteria	Bacteria	217	4.589999999999999e-52	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g26268	i0	92.157	28.3170731707317	153	12	93	0	5	157	2001782	2001630	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	4644	217	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
8071674	8071674	PRJNA408129_S_NODE_21007_length_176_cov_2.712230_g20989_i0	PRJNA408129	21007	176	2.71223	4.7735248	Pirellulimonas nuda	2528009	Bacteria	Bacteria	150	5.12e-32	NTclustered	gi\|1712662089\|gb\|CP036291.1\|	2528009	g20989	i0	83.234	3.60795454545455	167	24	94	4	5	169	4534752	4534916	Pirellulimonas nuda strain Pla175 chromosome, complete genome	blastn	635	150	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Pirellulimonas	Pirellulimonas nuda
10622361	10622361	PRJNA408129_S_NODE_3029_length_303_cov_21289.229323_g3011_i0	PRJNA408129	3029	303	21289.229323	64506.36484869	Lacipirellula parvula	2650471	Bacteria	Bacteria	268	2.57e-67	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g3011	i0	90.64	36.1980198019802	203	18	67	1	14	215	5164240	5164038	Lacipirellula parvula PX69 DNA, complete genome	blastn	10968	268	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
11897366	11897366	PRJNA408129_S_NODE_4130_length_281_cov_4.659836_g4112_i0	PRJNA408129	4130	281	4.659836	13.09413916	Pseudomonadati	3379134	Bacteria	Bacteria	100	2.15e-22	NR	MFP4070214.1	2026772	g4112	i0	83.9	2.41281138790036	56	9	59.8	0	280	113	692	747	MFP4070214.1 catalase/peroxidase HPI [Opitutales bacterium]	diamond	678	100	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
13172014	13172014	PRJNA408129_S_NODE_10651_length_217_cov_54.522222_g10633_i0	PRJNA408129	10651	217	54.522222	118.31322174	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	237	4.93e-58	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g10633	i0	89.73	6.29953917050691	185	19	85	0	15	199	7050393	7050209	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	1367	237	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
14447294	14447294	PRJNA408129_S_NODE_20812_length_176_cov_13.028777_g20794_i0	PRJNA408129	20812	176	13.028777	22.93064752	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	196	6.479999999999999e-46	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g20794	i0	88.024	5.02840909090909	167	18	94	2	11	176	7631081	7630916	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	885	196	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
18270050	18270050	PRJNA408129_S_NODE_25195_length_166_cov_6.930233_g25177_i0	PRJNA408129	25195	166	6.930233	11.50418678	Polystyrenella longa	2528007	Bacteria	Bacteria	145	2.23e-30	NTclustered	gi\|1712652806\|gb\|CP036281.1\|	2528007	g25177	i0	90.09	88.2228915662651	111	11	67	0	11	121	1415482	1415592	Polystyrenella longa strain Pla110 chromosome, complete genome	blastn	14645	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Polystyrenella	Polystyrenella longa
19544292	19544292	PRJNA408129_S_NODE_31276_length_156_cov_2.655462_g31258_i0	PRJNA408129	31276	156	2.655462	4.14252072	Lacipirellula parvula	2650471	Bacteria	Bacteria	105	3.63e-25	NR	WP_152100837.1	2650471	g31258	i0	98	0.980769230769231	51	1	98.1	0	155	3	98	148	WP_152100837.1 hypothetical protein [Lacipirellula parvula]	diamond	153	105	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
26648842	26648842	PRJNA408129_S_NODE_7581_length_239_cov_6.257426_g7563_i0	PRJNA408129	7581	239	6.257426	14.95524814	Paludisphaera	1763521	Bacteria	Bacteria	51.6	2.62e-5	NR	WP_277862173.1	3030827	g7563	i0	48.9	1.09205020920502	45	23	56.5	0	187	53	515	559	WP_277862173.1 Ig-like domain repeat protein [Paludisphaera mucosa]	diamond	261	52	0.992307692307692	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera mucosa
27360155	27360155	PRJNA408129_S_NODE_23643_length_170_cov_1.571429_g23625_i0	PRJNA408129	23643	170	1.571429	2.6714293	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	91.3	1.11e-19	NR	MES2920926.1	2026799	g23625	i0	83.6	0.970588235294118	55	9	97.1	0	170	6	170	224	MES2920926.1 carboxy terminal-processing peptidase [Verrucomicrobiota bacterium]	diamond	165	91.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28149497	28149497	PRJNA408129_S_NODE_28085_length_161_cov_3.524194_g28067_i0	PRJNA408129	28085	161	3.524194	5.67395234	Planctomycetota bacterium	2026780	Bacteria	Bacteria	41.6	0.0147	NR	MEQ8765592.1	2026780	g28067	i0	40	0.838509316770186	45	27	83.9	0	9	143	35	79	MEQ8765592.1 DUF4405 domain-containing protein [Planctomycetota bacterium]	diamond	135	41.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28623143	28623143	PRJNA408129_S_NODE_27047_length_163_cov_2.388889_g27029_i0	PRJNA408129	27047	163	2.388889	3.89388907	Paludisphaera borealis	1387353	Bacteria	Bacteria	66.6	4.54e-11	NR	WP_083713394.1	1387353	g27029	i0	82.5	2.5398773006135	40	7	73.6	0	39	158	23	62	WP_083713394.1 amidohydrolase [Paludisphaera borealis]	diamond	414	66.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
28970364	28970364	PRJNA408129_S_NODE_33508_length_153_cov_2.517241_g33490_i0	PRJNA408129	33508	153	2.517241	3.85137873	Neochlamydia sp. S13	1353976	Bacteria	Bacteria	75.1	2.25e-14	NR	WP_042241681.1	1353976	g33490	i0	66	0.980392156862745	50	17	98	0	153	4	110	159	WP_042241681.1 archaetidylserine decarboxylase [Neochlamydia sp. S13]	diamond	150	75.1	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. S13
29727807	29727807	PRJNA408129_S_NODE_33970_length_152_cov_5.626087_g33952_i0	PRJNA408129	33970	152	5.626087	8.55165224	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	74.7	5.64e-14	NR	MFP6764688.1	2026779	g33952	i0	73.3	6.21710526315789	45	12	88.8	0	2	136	271	315	MFP6764688.1 AAA family ATPase [Planctomycetaceae bacterium]	diamond	945	74.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
30517871	30517871	PRJNA408129_S_NODE_11013_length_215_cov_6.825843_g10995_i0	PRJNA408129	11013	215	6.825843	14.67556245	Chlamydia ibidis	1405396	Bacteria	Bacteria	50.4	3.76e-6	NR	EPP34943.1	1405396	g10995	i0	88.5	0.362790697674419	26	3	36.3	0	209	132	40	65	EPP34943.1 hypothetical protein CP10139811_1560, partial [Chlamydia ibidis]	diamond	78	50.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia ibidis
30770801	30770801	PRJNA408129_S_NODE_20314_length_178_cov_2.226950_g20296_i0	PRJNA408129	20314	178	2.22695	3.963971	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.5	0.0084	NR	MEC8651550.1	2026780	g20296	i0	38	0.842696629213483	50	31	84.3	0	7	156	182	231	MEC8651550.1 hypothetical protein [Planctomycetota bacterium]	diamond	150	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31845449	31845449	PRJNA408129_S_NODE_31637_length_155_cov_10.423729_g31619_i0	PRJNA408129	31637	155	10.423729	16.15677995	Planctomycetota bacterium	2026780	Bacteria	Bacteria	45.8	7.27e-4	NR	HZV01369.1	2026780	g31619	i0	53.8	0.754838709677419	39	18	75.5	0	149	33	170	208	HZV01369.1 hypothetical protein [Planctomycetota bacterium]	diamond	117	45.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31893841	31893841	PRJNA408129_S_NODE_14197_length_199_cov_2.549383_g14179_i0	PRJNA408129	14197	199	2.549383	5.07327217	Planctomycetia	203683	Bacteria	Bacteria	102	1.1199999999999999e-23	NR	WP_148074061.1	1400387	g14179	i0	74.2	9.30150753768844	62	16	93.5	0	6	191	376	437	WP_148074061.1 sodium-dependent transporter [Bythopirellula goksoeyrii]	diamond	1851	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Bythopirellula	Bythopirellula goksoeyrii
32003836	32003836	PRJNA408129_S_NODE_14318_length_198_cov_5.062112_g14300_i0	PRJNA408129	14318	198	5.062112	10.02298176	Pirellulales bacterium	2715253	Bacteria	Bacteria	63.9	6.88e-10	NR	HZZ28781.1	2715253	g14300	i0	60	0.909090909090909	60	24	90.9	0	197	18	269	328	HZZ28781.1 autotransporter-associated beta strand repeat-containing protein [Pirellulales bacterium]	diamond	180	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
32415233	32415233	PRJNA408129_S_NODE_26559_length_164_cov_2.094488_g26541_i0	PRJNA408129	26559	164	2.094488	3.43496032	Planctomycetia bacterium	2052181	Bacteria	Bacteria	42.7	0.00378	NR	MBI2481475.1	2052181	g26541	i0	50	0.658536585365854	36	18	65.9	0	116	9	7	42	MBI2481475.1 hypothetical protein [Planctomycetia bacterium]	diamond	108	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
32431867	32431867	PRJNA408129_S_NODE_18459_length_183_cov_3.143836_g18441_i0	PRJNA408129	18459	183	3.143836	5.75321988	PVC group	1783257	Bacteria	Bacteria	51.6	1.29e-5	NR	HMC66185.1	2052164	g18441	i0	100	6.95081967213115	25	0	41	0	174	100	457	481	HMC66185.1 DNA-directed RNA polymerase subunit beta' [Gemmataceae bacterium]	diamond	1272	51.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32715810	32715810	PRJNA408129_S_NODE_29160_length_159_cov_5.122951_g29142_i0	PRJNA408129	29160	159	5.122951	8.14549209	Pseudomonadati	3379134	Bacteria	Bacteria	90.9	1.83e-20	NR	MBV8226507.1	2026799	g29142	i0	78.8	3.84905660377358	52	11	98.1	0	157	2	91	142	MBV8226507.1 cysteine hydrolase [Verrucomicrobiota bacterium]	diamond	612	90.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;