metadata: contig_metadata: 35 rows where bioproject = "PRJNA1199330" and tax

35 rows where bioproject = "PRJNA1199330" 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
6147213	6147213	PRJNA1199330_P_NODE_54365_length_297_cov_3.165179_g53666_i0	PRJNA1199330	54365	297	3.165179	9.40058163	Verrucomicrobiota	74201	Bacteria	Bacteria	86.1	2.72e-12	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g53666	i0	85.366	0.552188552188552	82	12	28	0	31	112	5154017	5153936	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	164	86.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
6703317	6703317	PRJNA1199330_P_NODE_35306_length_348_cov_3.072727_g34607_i0	PRJNA1199330	35306	348	3.072727	10.69308996	Stieleria bergensis	2528025	Bacteria	Bacteria	93.5	1.94e-14	NTclustered	gi\|1712514661\|gb\|CP036272.1\|	2528025	g34607	i0	86.517	74.448275862069	89	7	24	4	195	279	3877843	3877756	Planctomycetes bacterium SV_7m_r chromosome	blastn	25908	93.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria bergensis
9253644	9253644	PRJNA1199330_P_NODE_48328_length_309_cov_1.906780_g47629_i0	PRJNA1199330	48328	309	1.90678	5.8919502	Aureliella helgolandensis	2527968	Bacteria	Bacteria	460	4.05e-125	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g47629	i0	93.811	151.608414239482	307	17	99	2	4	309	6999341	6999036	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	46847	460	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
15627836	15627836	PRJNA1199330_P_NODE_11593_length_608_cov_2.428037_g10920_i0	PRJNA1199330	11593	608	2.428037	14.76246496	Aureliella helgolandensis	2527968	Bacteria	Bacteria	918	0	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g10920	i0	95.377	112.524671052632	584	15	94	6	1	573	7000096	6999514	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	68415	918	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
18176644	18176644	PRJNA1199330_P_NODE_113395_length_244_cov_0.912281_g112696_i0	PRJNA1199330	113395	244	0.912281	2.22596564	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	351	1.9399999999999998e-92	NTclustered	gi\|576901465\|gb\|KF827058.1\|	120965	g112696	i0	100	90.7581967213115	190	0	78	0	55	244	1400	1211	Uncultured planctomycete clone B-30-43 16S ribosomal RNA gene, partial sequence	blastn	22145	351	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
24551163	24551163	PRJNA1199330_P_NODE_114740_length_243_cov_0.917647_g114041_i0	PRJNA1199330	114740	243	0.917647	2.22988221	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	82.8	5.3e-17	NR	QTN31272.1	2562705	g114041	i0	56.7	1.58024691358025	67	29	82.7	0	230	30	7	73	QTN31272.1 glucosamine-6-phosphate deaminase [Akkermansiaceae bacterium]	diamond	384	82.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
26787850	26787850	PRJNA1199330_P_NODE_22461_length_432_cov_2.164345_g21767_i0	PRJNA1199330	22461	432	2.164345	9.3499704	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.9	0.038	NR	MFQ5655667.1	2026780	g21767	i0	44.1	0.472222222222222	68	29	42.4	3	325	143	63	128	MFQ5655667.1 hypothetical protein [Planctomycetota bacterium]	diamond	204	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27103998	27103998	PRJNA1199330_P_NODE_58882_length_291_cov_2.779817_g58183_i0	PRJNA1199330	58882	291	2.779817	8.08926747	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	64.3	1.02e-9	NR	MDB6056527.1	2026801	g58183	i0	47.6	0.845360824742268	82	42	83.5	1	45	287	59	140	MDB6056527.1 serine/threonine-protein phosphatase 6 regulatory ankyrin repeat subunit A-like isoform [Verrucomicrobiales bacterium]	diamond	246	64.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
27514934	27514934	PRJNA1199330_P_NODE_66363_length_285_cov_1.471698_g65664_i0	PRJNA1199330	66363	285	1.471698	4.1943393	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	77.4	3.75e-14	NR	HEY7091130.1	2876886	g65664	i0	44	0.884210526315789	84	43	87.4	2	1	249	367	447	HEY7091130.1 glycoside hydrolase family 28 protein [Tepidisphaeraceae bacterium]	diamond	252	77.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
27546498	27546498	PRJNA1199330_P_NODE_24204_length_417_cov_3.133721_g23509_i0	PRJNA1199330	24204	417	3.133721	13.06761657	Pirellula sp.	117	Bacteria	Bacteria	152	4.469999999999999e-43	NR	MFN7731089.1	117	g23509	i0	68.3	0.726618705035971	101	28	69.8	1	294	4	47	147	MFN7731089.1 platelet-activating factor acetylhydrolase IB subunit [Pirellula sp.]	diamond	303	152	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
27546502	27546502	PRJNA1199330_P_NODE_34284_length_353_cov_3.835714_g33585_i0	PRJNA1199330	34284	353	3.835714	13.54007042	Planctomycetota bacterium	2026780	Bacteria	Bacteria	98.6	2.3400000000000003e-21	NR	MCX8229914.1	2026780	g33585	i0	65.7	0.594900849858357	70	24	59.5	0	143	352	1	70	MCX8229914.1 tryptophanase [Planctomycetota bacterium]	diamond	210	98.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28051669	28051669	PRJNA1199330_P_NODE_66325_length_285_cov_1.471698_g65626_i0	PRJNA1199330	66325	285	1.471698	4.1943393	Planctomycetota bacterium	2026780	Bacteria	Bacteria	47.8	0.00104	NR	NRA95524.1	2026780	g65626	i0	41.9	0.652631578947368	62	33	62.1	2	178	2	423	484	NRA95524.1 hypothetical protein [Planctomycetota bacterium]	diamond	186	47.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28765080	28765080	PRJNA1199330_P_NODE_106847_length_248_cov_3.005714_g106148_i0	PRJNA1199330	106847	248	3.005714	7.45417072	Planctomycetia	203683	Bacteria	Bacteria	116	1.17e-28	NR	MFK8113894.1	1973111	g106148	i0	70.8	2.58870967741935	72	21	87.1	0	29	244	1	72	MFK8113894.1 enolase C-terminal domain-like protein [Rubripirellula sp.]	diamond	642	117	0.991452991452991	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Rubripirellula	Rubripirellula sp.
29346303	29346303	PRJNA1199330_P_NODE_53489_length_299_cov_1.371681_g52790_i0	PRJNA1199330	53489	299	1.371681	4.10132619	Opitutales bacterium	2026772	Bacteria	Bacteria	56.6	7.51e-7	NR	MCH8475895.1	2026772	g52790	i0	52.7	0.551839464882943	55	17	55.2	1	219	55	209	254	MCH8475895.1 LamG domain-containing protein [Opitutales bacterium]	diamond	165	56.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
29396673	29396673	PRJNA1199330_P_NODE_88069_length_265_cov_1.625000_g87370_i0	PRJNA1199330	88069	265	1.625	4.30625	Bacteria	2	Bacteria	Bacteria	97.8	1.59e-21	NR	HUO10813.1	2026778	g87370	i0	55.2	1.94716981132075	87	39	98.5	0	3	263	330	416	HUO10813.1 glycoside hydrolase family 28 protein [Phycisphaerae bacterium]	diamond	516	97.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
29409302	29409302	PRJNA1199330_P_NODE_71049_length_281_cov_1.341346_g70350_i0	PRJNA1199330	71049	281	1.341346	3.76918226	Thermoguttaceae bacterium	2691551	Bacteria	Bacteria	46.2	0.00364	NR	MBR0226434.1	2691551	g70350	i0	40.3	0.715302491103203	67	35	71.5	2	58	258	938	999	MBR0226434.1 hypothetical protein [Thermoguttaceae bacterium]	diamond	201	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae		Thermoguttaceae bacterium
29756524	29756524	PRJNA1199330_P_NODE_106931_length_248_cov_2.645714_g106232_i0	PRJNA1199330	106931	248	2.645714	6.56137072	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	42.4	0.0474	NR	HEV7406036.1	2811408	g106232	i0	43.2	0.44758064516129	37	21	44.8	0	247	137	100	136	HEV7406036.1 ankyrin repeat domain-containing protein [Chthoniobacteraceae bacterium]	diamond	111	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
29883206	29883206	PRJNA1199330_P_NODE_97291_length_256_cov_1.306011_g96592_i0	PRJNA1199330	97291	256	1.306011	3.34338816	Pirellula sp.	117	Bacteria	Bacteria	117	3.3e-30	NR	MFN7731089.1	117	g96592	i0	65.5	1.96875	84	29	98.4	0	254	3	132	215	MFN7731089.1 platelet-activating factor acetylhydrolase IB subunit [Pirellula sp.]	diamond	504	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
29933658	29933658	PRJNA1199330_P_NODE_117151_length_240_cov_2.730539_g116452_i0	PRJNA1199330	117151	240	2.730539	6.5532936	Opitutaceae	134623	Bacteria	Bacteria	42.7	0.0346	NR	MEX2043917.1	1913982	g116452	i0	40.8	3.0875	49	24	61.3	1	85	231	13	56	MEX2043917.1 prepilin peptidase [Opitutus sp.]	diamond	741	43.1	0.990719257540603	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
29933661	29933661	PRJNA1199330_P_NODE_52531_length_300_cov_3.132159_g51832_i0	PRJNA1199330	52531	300	3.132159	9.396477	Bacteria	2	Bacteria	Bacteria	49.3	3.45e-4	NR	HUB66694.1	2720631	g51832	i0	46.7	2.13	60	32	60	0	185	6	52	111	HUB66694.1 ankyrin repeat domain-containing protein [Candidatus Methylacidiphilales bacterium]	diamond	639	49.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales			Candidatus Methylacidiphilales bacterium
29946290	29946290	PRJNA1199330_P_NODE_64771_length_286_cov_2.361502_g64072_i0	PRJNA1199330	64771	286	2.361502	6.75389572	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	47.4	3.12e-4	NR	MBV8416944.1	2026799	g64072	i0	34.7	2.16083916083916	72	47	75.5	0	234	19	39	110	MBV8416944.1 tetratricopeptide repeat protein [Verrucomicrobiota bacterium]	diamond	618	47.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30502200	30502200	PRJNA1199330_P_NODE_87773_length_265_cov_2.197917_g87074_i0	PRJNA1199330	87773	265	2.197917	5.82448005	Gemmata	113	Bacteria	Bacteria	88.2	1.7e-19	NR	MCS6863682.1	1914242	g87074	i0	49.4	1.96981132075472	87	44	98.5	0	263	3	81	167	MCS6863682.1 protoglobin family protein [Gemmata sp.]	diamond	522	89	0.991011235955056	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp.
30546502	30546502	PRJNA1199330_P_NODE_68553_length_283_cov_1.485714_g67854_i0	PRJNA1199330	68553	283	1.485714	4.20457062	Prosthecobacter sp.	1965333	Bacteria	Bacteria	43.9	0.0197	NR	MCA1962363.1	1965333	g67854	i0	34.4	0.646643109540636	61	40	64.7	0	90	272	107	167	MCA1962363.1 hypothetical protein [Prosthecobacter sp.]	diamond	183	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
30641096	30641096	PRJNA1199330_P_NODE_118793_length_236_cov_3.355828_g118094_i0	PRJNA1199330	118793	236	3.355828	7.91975408	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	67.8	4.97e-11	NR	HEY3915274.1	2499141	g118094	i0	46.4	3.53389830508475	69	37	87.7	0	28	234	303	371	HEY3915274.1 DUF4982 domain-containing protein [Verrucomicrobiia bacterium]	diamond	834	67.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30672737	30672737	PRJNA1199330_P_NODE_57153_length_293_cov_1.931818_g56454_i0	PRJNA1199330	57153	293	1.931818	5.66022674	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	75.9	1.14e-14	NR	MCX6913889.1	2026799	g56454	i0	47.2	0.737201365187713	72	38	73.7	0	76	291	52	123	MCX6913889.1 PA14 domain-containing protein [Verrucomicrobiota bacterium]	diamond	216	75.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31273267	31273267	PRJNA1199330_P_NODE_77715_length_275_cov_1.237624_g77016_i0	PRJNA1199330	77715	275	1.237624	3.403466	Planctomycetia bacterium	2052181	Bacteria	Bacteria	42.7	0.0385	NR	MDZ4781812.1	2052181	g77016	i0	53.1	0.349090909090909	32	15	34.9	0	177	82	93	124	MDZ4781812.1 signal peptidase II [Planctomycetia bacterium]	diamond	96	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
31640005	31640005	PRJNA1199330_P_NODE_16136_length_509_cov_3.052752_g15446_i0	PRJNA1199330	16136	509	3.052752	15.53850768	Pseudomonadati	3379134	Bacteria	Bacteria	107	1.0699999999999997e-23	NR	AKC83384.1	1637999	g15446	i0	46.6	2.30451866404715	118	55	64.8	2	384	55	30	147	AKC83384.1 hypothetical protein IMCC26134_12420 [Verrucomicrobia bacterium IMCC26134]	diamond	1173	107	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
31969050	31969050	PRJNA1199330_P_NODE_33538_length_357_cov_2.880282_g32840_i0	PRJNA1199330	33538	357	2.880282	10.28260674	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	70.9	1.44e-11	NR	HBJ95380.1	2053569	g32840	i0	66	1.65546218487395	50	17	42	0	356	207	257	306	HBJ95380.1 hydroxyacid dehydrogenase [Lentisphaeria bacterium]	diamond	591	70.9	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
32051339	32051339	PRJNA1199330_P_NODE_94418_length_259_cov_1.408602_g93719_i0	PRJNA1199330	94418	259	1.408602	3.64827918	PVC group	1783257	Bacteria	Bacteria	50.4	8.53e-5	NR	MBP9902046.1	2026799	g93719	i0	36.9	2.86100386100386	84	52	97.3	1	3	254	243	325	MBP9902046.1 serine/threonine protein kinase [Verrucomicrobiota bacterium]	diamond	741	50.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32620562	32620562	PRJNA1199330_P_NODE_31680_length_367_cov_5.295918_g30984_i0	PRJNA1199330	31680	367	5.295918	19.43601906	Bacteria	2	Bacteria	Bacteria	62.8	1.26e-8	NR	MDJ0520714.1	2026780	g30984	i0	45.7	1.72479564032698	70	37	57.2	1	4	213	291	359	MDJ0520714.1 acyl-CoA desaturase [Planctomycetota bacterium]	diamond	633	62.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
32664555	32664555	PRJNA1199330_P_NODE_24340_length_416_cov_2.655977_g23644_i0	PRJNA1199330	24340	416	2.655977	11.04886432	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	64.3	6.38e-9	NR	MEY4917918.1	2026799	g23644	i0	32.1	1.96875	140	74	92.3	6	399	16	78	208	MEY4917918.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	819	64.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32727791	32727791	PRJNA1199330_P_NODE_28780_length_385_cov_0.996795_g28084_i0	PRJNA1199330	28780	385	0.996795	3.83766075	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	102	2.86e-22	NR	MBL9121300.1	2026778	g28084	i0	53.1	2.24415584415584	98	46	76.4	0	3	296	92	189	MBL9121300.1 cation:proton antiporter [Phycisphaerae bacterium]	diamond	864	102	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
32790496	32790496	PRJNA1199330_P_NODE_86800_length_266_cov_2.056995_g86101_i0	PRJNA1199330	86800	266	2.056995	5.4716067	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	68.2	4.14e-11	NR	MEI7955772.1	2026799	g86101	i0	36.6	4.6015037593985	82	39	92.5	2	7	252	209	277	MEI7955772.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	1224	68.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32822166	32822166	PRJNA1199330_P_NODE_36140_length_344_cov_2.276753_g35441_i0	PRJNA1199330	36140	344	2.276753	7.83203032	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	77.4	8.22e-14	NR	HXI84029.1	2499141	g35441	i0	63.6	0.575581395348837	66	22	57.6	2	299	102	227	290	HXI84029.1 NF038122 family metalloprotease [Verrucomicrobiia bacterium]	diamond	198	77.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32822178	32822178	PRJNA1199330_P_NODE_60560_length_290_cov_1.603687_g59861_i0	PRJNA1199330	60560	290	1.603687	4.6506923	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	87.8	3.41e-18	NR	MCP4194714.1	2026779	g59861	i0	50.6	0.817241379310345	79	39	81.7	0	288	52	249	327	MCP4194714.1 DNA (cytosine-5-)-methyltransferase [Planctomycetaceae bacterium]	diamond	237	87.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae 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);;