metadata: contig_metadata: 9 rows where bioproject = "PRJNA773778", tax_clade = "PVC group" and tax

9 rows where bioproject = "PRJNA773778", tax_clade = "PVC group" and tax_phylum = "Planctomycetota"

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
2026876	2026876	PRJNA773778_S_NODE_22662_length_314_cov_2.875519_g22512_i0	PRJNA773778	22662	314	2.875519	9.02912966	Tepidisphaerales bacterium	2795155	Bacteria	Bacteria	87.8	1.31e-17	NR	MFN4243764.1	2795155	g22512	i0	66.1	0.563694267515924	59	20	56.4	0	191	15	204	262	MFN4243764.1 hypothetical protein [Tepidisphaerales bacterium]	diamond	177	87.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales			Tepidisphaerales bacterium
9679200	9679200	PRJNA773778_S_NODE_11148_length_412_cov_7.206490_g10998_i0	PRJNA773778	11148	412	7.20649	29.6907388	uncultured Planctomycetales bacterium	100371	Bacteria	Bacteria	723	0	NTclustered	gi\|383502255\|gb\|JQ860982.1\|	100371	g10998	i0	99.746	94.0849514563107	394	1	96	0	1	394	61	454	Uncultured Planctomycetales bacterium clone 14 15th day 16S ribosomal RNA gene, partial sequence	blastn	38763	723	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			uncultured Planctomycetales bacterium
12686954	12686954	PRJNA773778_S_NODE_49690_length_226_cov_4.111111_g49540_i0	PRJNA773778	49690	226	4.111111	9.29111086	Lacipirellulaceae bacterium	2691534	Bacteria	Bacteria	119	3.53e-30	NR	HEX4412903.1	2691534	g49540	i0	77.5	0.942477876106195	71	16	94.2	0	2	214	222	292	HEX4412903.1 alpha-amylase family glycosyl hydrolase [Lacipirellulaceae bacterium]	diamond	213	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae		Lacipirellulaceae bacterium
28064017	28064017	PRJNA773778_S_NODE_37885_length_257_cov_2.510870_g37735_i0	PRJNA773778	37885	257	2.51087	6.4529359	Planctomycetota bacterium	2026780	Bacteria	Bacteria	101	2.76e-25	NR	MFN6128411.1	2026780	g37735	i0	66.7	2.52140077821012	72	24	84	0	23	238	61	132	MFN6128411.1 hypothetical protein [Planctomycetota bacterium]	diamond	648	101	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29905058	29905058	PRJNA773778_S_NODE_38911_length_254_cov_2.552486_g38761_i0	PRJNA773778	38911	254	2.552486	6.48331444	Bacteria	2	Bacteria	Bacteria	99.4	1.49e-22	NR	MCX7407258.1	2053591	g38761	i0	53.6	4.7244094488189	84	37	99.2	1	1	252	222	303	MCX7407258.1 type III polyketide synthase [Planctomycetales bacterium]	diamond	1200	100	0.994	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
30179581	30179581	PRJNA773778_S_NODE_31832_length_276_cov_6.305419_g31682_i0	PRJNA773778	31832	276	6.305419	17.40295644	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	68.9	8.27e-13	NR	HEX8341348.1	2876886	g31682	i0	78.4	0.402173913043478	37	8	40.2	0	276	166	65	101	HEX8341348.1 hypothetical protein [Tepidisphaeraceae bacterium]	diamond	111	68.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
30211125	30211125	PRJNA773778_S_NODE_13312_length_385_cov_4.682692_g13162_i0	PRJNA773778	13312	385	4.682692	18.0283642	Pirellula sp.	117	Bacteria	Bacteria	57	1.06e-7	NR	MBA4105996.1	117	g13162	i0	64.9	0.584415584415584	37	13	28.8	0	76	186	1	37	MBA4105996.1 hypothetical protein [Pirellula sp.]	diamond	225	57	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp.
30274786	30274786	PRJNA773778_S_NODE_40532_length_251_cov_0.865169_g40382_i0	PRJNA773778	40532	251	0.865169	2.17157419	Thermoguttaceae bacterium	2691551	Bacteria	Bacteria	138	5.87e-41	NR	MDY0169834.1	2691551	g40382	i0	98.5	0.776892430278884	65	1	77.7	0	243	49	1	65	MDY0169834.1 hypothetical protein [Thermoguttaceae bacterium]	diamond	195	138	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae		Thermoguttaceae bacterium
30969796	30969796	PRJNA773778_S_NODE_20434_length_326_cov_8.411067_g20284_i0	PRJNA773778	20434	326	8.411067	27.42007842	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	72	4.54e-12	NR	MDB5328349.1	2052180	g20284	i0	72.9	0.441717791411043	48	13	44.2	0	322	179	358	405	MDB5328349.1 putative transporter ATP-binding protein [Phycisphaerales bacterium]	diamond	144	72	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales 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);;