metadata: contig_metadata: 20 rows where bioproject = "PRJNA832865" and tax

20 rows where bioproject = "PRJNA832865" 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
823800	823800	PRJNA832865_S_NODE_82421_length_270_cov_1.253807_g77335_i0	PRJNA832865	82421	270	1.253807	3.3852789	Candidatus Chlamydia sanziniae	1806891	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|1033686309\|gb\|CP014639.1\|	1806891	g77335	i0	100	0.103703703703704	28	0	10	0	190	217	654917	654944	Candidatus Chlamydia sanziniae strain 2742-308 chromosome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Candidatus Chlamydia sanziniae
3372959	3372959	PRJNA832865_S_NODE_10423_length_1428_cov_8.787454_g7545_i0	PRJNA832865	10423	1428	8.787454	125.48484312	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	56.5	0.011	NTclustered	gi\|2874254045\|emb\|OY970369.1\|	305355	g7545	i0	100	0.061624649859944	30	0	2	0	54	83	1852363	1852334	MAG: uncultured Chlamydiae bacterium isolate MFD06092.bin.1.176 genome assembly, chromosome: 1	blastn	88	56.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
27022931	27022931	PRJNA832865_S_NODE_14642_length_1070_cov_30.954865_g8286_i2	PRJNA832865	14642	1070	30.954865	331.2170555	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	81.3	5.93e-14	NR	MFH0952965.1	2026799	g8286	i2	42.4	0.698130841121495	85	48	23.8	1	708	454	118	201	MFH0952965.1 ATP-dependent Clp endopeptidase proteolytic subunit ClpP [Verrucomicrobiota bacterium]	diamond	747	81.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27180792	27180792	PRJNA832865_S_NODE_49482_length_361_cov_1.829861_g44396_i0	PRJNA832865	49482	361	1.829861	6.60579821	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	48.5	0.00133	NR	HEU5068864.1	2499141	g44396	i0	37.7	0.506925207756233	61	29	44	3	229	71	517	576	HEU5068864.1 MFS transporter [Verrucomicrobiia bacterium]	diamond	183	48.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27180810	27180810	PRJNA832865_S_NODE_87762_length_261_cov_0.819149_g82676_i0	PRJNA832865	87762	261	0.819149	2.13797889	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	68.9	4.24e-12	NR	MBT3191068.1	2026799	g82676	i0	38.4	8.45977011494253	86	52	98.9	1	259	2	101	185	MBT3191068.1 ATP-dependent Clp protease proteolytic subunit [Verrucomicrobiota bacterium]	diamond	2208	68.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27339206	27339206	PRJNA832865_S_NODE_64763_length_308_cov_1.072340_g59677_i0	PRJNA832865	64763	308	1.07234	3.3028072	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	43.9	0.0288	NR	MEX0741905.1	2026777	g59677	i0	32.4	0.720779220779221	74	48	72.1	1	280	59	7	78	MEX0741905.1 carbon-nitrogen hydrolase family protein [Phycisphaeraceae bacterium]	diamond	222	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
27718383	27718383	PRJNA832865_S_NODE_11364_length_1334_cov_34.475813_g8286_i0	PRJNA832865	11364	1334	34.475813	459.90734542	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	99.4	4.32e-20	NR	MFH0952965.1	2026799	g8286	i0	44.4	0.22263868065967	99	54	22.3	1	585	881	104	201	MFH0952965.1 ATP-dependent Clp endopeptidase proteolytic subunit ClpP [Verrucomicrobiota bacterium]	diamond	297	99.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27939118	27939118	PRJNA832865_S_NODE_35405_length_463_cov_1.753846_g30323_i0	PRJNA832865	35405	463	1.753846	8.12030698	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	68.9	3.35e-11	NR	HET6328477.1	2026779	g30323	i0	31.4	0.764578833693304	118	74	75.2	3	94	441	36	148	HET6328477.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	354	68.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
28010932	28010932	PRJNA832865_S_NODE_11365_length_1334_cov_29.375099_g8286_i1	PRJNA832865	11365	1334	29.375099	391.86382066	Pseudomonadati	3379134	Bacteria	Bacteria	89.7	8.39e-17	NR	HLX63275.1	2026780	g8286	i1	46.2	1.47976011994003	93	49	20.9	1	585	863	99	190	HLX63275.1 ATP-dependent Clp protease proteolytic subunit [Planctomycetota bacterium]	diamond	1974	89.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
28507436	28507436	PRJNA832865_S_NODE_76627_length_281_cov_1.120192_g71541_i0	PRJNA832865	76627	281	1.120192	3.14773952	Aquisphaera insulae	2712864	Bacteria	Bacteria	42	0.0443	NR	WP_165228110.1	2712864	g71541	i0	31.6	0.843416370106762	79	53	84.3	1	21	257	6	83	WP_165228110.1 hypothetical protein [Aquisphaera insulae]	diamond	237	42	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera insulae
28822831	28822831	PRJNA832865_S_NODE_83828_length_267_cov_1.907216_g78742_i0	PRJNA832865	83828	267	1.907216	5.09226672	Candidatus Scalindua sp.	2268189	Bacteria	Bacteria	43.1	0.0332	NR	MCP4254340.1	2268189	g78742	i0	30	0.898876404494382	80	44	76.4	3	208	5	56	135	MCP4254340.1 hypothetical protein [Candidatus Scalindua sp.]	diamond	240	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Scalinduaceae	Candidatus Scalindua	Candidatus Scalindua sp.
28917549	28917549	PRJNA832865_S_NODE_106968_length_243_cov_0.941176_g101882_i0	PRJNA832865	106968	243	0.941176	2.28705768	Planctomycetia bacterium	2052181	Bacteria	Bacteria	43.5	0.0204	NR	MDO5554654.1	2052181	g101882	i0	35.2	0.666666666666667	54	35	66.7	0	28	189	375	428	MDO5554654.1 glycoside hydrolase family 97 N-terminal domain-containing protein [Planctomycetia bacterium]	diamond	162	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
30117657	30117657	PRJNA832865_S_NODE_47472_length_371_cov_1.419463_g42386_i0	PRJNA832865	47472	371	1.419463	5.26620773	Opitutales bacterium	2026772	Bacteria	Bacteria	44.3	0.0403	NR	MEL0005672.1	2026772	g42386	i0	44.1	0.549865229110512	68	32	51.8	4	300	109	111	176	MEL0005672.1 substrate-binding domain-containing protein [Opitutales bacterium]	diamond	204	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
30276041	30276041	PRJNA832865_S_NODE_37712_length_439_cov_1.756831_g32627_i0	PRJNA832865	37712	439	1.756831	7.71248809	Planctomycetota bacterium	2026780	Bacteria	Bacteria	80.5	9.36e-15	NR	HEY3226600.1	2026780	g32627	i0	45.1	6.10250569476082	102	46	68.3	3	8	307	165	258	HEY3226600.1 serine/threonine-protein kinase [Planctomycetota bacterium]	diamond	2679	80.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31065881	31065881	PRJNA832865_S_NODE_64655_length_308_cov_1.348936_g59569_i0	PRJNA832865	64655	308	1.348936	4.15472288	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	90.5	1.27e-18	NR	MCG8432081.1	2035772	g59569	i0	41	10.5194805194805	100	59	97.4	0	307	8	138	237	MCG8432081.1 reverse transcriptase family protein [Candidatus Omnitrophota bacterium]	diamond	3240	90.5	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
32014441	32014441	PRJNA832865_S_NODE_73938_length_286_cov_2.276995_g68852_i0	PRJNA832865	73938	286	2.276995	6.5122057	Pirellulales bacterium	2715253	Bacteria	Bacteria	43.1	0.0388	NR	MDX1963016.1	2715253	g68852	i0	34.8	0.723776223776224	69	41	68.2	2	75	269	115	183	MDX1963016.1 hypothetical protein [Pirellulales bacterium]	diamond	207	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
32046178	32046178	PRJNA832865_S_NODE_80198_length_274_cov_1.452736_g75112_i0	PRJNA832865	80198	274	1.452736	3.98049664	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	42.7	0.0472	NR	MBE6399572.1	1932692	g75112	i0	42.9	0.45985401459854	42	23	44.9	1	206	84	193	234	MBE6399572.1 FtsQ-type POTRA domain-containing protein [Lentisphaerota bacterium]	diamond	126	42.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
32109382	32109382	PRJNA832865_S_NODE_74198_length_286_cov_1.112676_g69112_i0	PRJNA832865	74198	286	1.112676	3.18225336	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	42.7	0.0257	NR	MEI6535485.1	2026800	g69112	i0	38.2	0.576923076923077	55	32	57.7	1	237	73	21	73	MEI6535485.1 hypothetical protein [Verrucomicrobiaceae bacterium]	diamond	165	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32457566	32457566	PRJNA832865_S_NODE_104279_length_245_cov_0.895349_g99193_i0	PRJNA832865	104279	245	0.895349	2.19360505	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	60.5	1.59e-8	NR	MBV8129076.1	2026779	g99193	i0	66.7	0.514285714285714	42	14	51.4	0	118	243	1	42	MBV8129076.1 ABC transporter permease [Planctomycetaceae bacterium]	diamond	126	60.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
32457583	32457583	PRJNA832865_S_NODE_34699_length_471_cov_1.092965_g29618_i0	PRJNA832865	34699	471	1.092965	5.14786515	Candidatus Scalindua sp.	2268189	Bacteria	Bacteria	145	4.359999999999999e-37	NR	MCP4255696.1	2268189	g29618	i0	44.9	1.72611464968153	158	81	96.8	1	1	456	627	784	MCP4255696.1 hypothetical protein [Candidatus Scalindua sp.]	diamond	813	145	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Scalinduaceae	Candidatus Scalindua	Candidatus Scalindua sp.

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