metadata: contig_metadata: 15 rows where bioproject = "PRJNA773778" and tax

15 rows where bioproject = "PRJNA773778" 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
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
14779631	14779631	PRJNA773778_S_NODE_17552_length_345_cov_4.529412_g17402_i0	PRJNA773778	17552	345	4.529412	15.6264714	Verrucomicrobium sp. GAS474	1882831	Bacteria	Bacteria	160	6.229999999999999e-45	NR	WP_093287198.1	1882831	g17402	i0	80.6	0.808695652173913	93	18	80.9	0	344	66	342	434	WP_093287198.1 adenosylhomocysteinase [Verrucomicrobium sp. GAS474]	diamond	279	160	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium sp. GAS474
27811684	27811684	PRJNA773778_S_NODE_36164_length_262_cov_6.613757_g36014_i0	PRJNA773778	36164	262	6.613757	17.32804334	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	57.8	1.22e-8	NR	RYD84282.1	2026800	g36014	i0	48.5	0.755725190839695	66	34	75.6	0	44	241	1	66	RYD84282.1 MAG: hypothetical protein EOP84_05925, partial [Verrucomicrobiaceae bacterium]	diamond	198	57.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae 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
28411495	28411495	PRJNA773778_S_NODE_43986_length_246_cov_1.335260_g43836_i0	PRJNA773778	43986	246	1.33526	3.2847396	Candidatus Protochlamydia amoebophila	362787	Bacteria	Bacteria	44.3	6.86e-4	NR	MBS4163025.1	362787	g43836	i0	60	0.426829268292683	35	14	42.7	0	195	91	6	40	MBS4163025.1 hypothetical protein [Candidatus Protochlamydia amoebophila]	diamond	105	44.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
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
30495820	30495820	PRJNA773778_S_NODE_44553_length_246_cov_0.867052_g44403_i0	PRJNA773778	44553	246	0.867052	2.13294792	Chlamydia psittaci	83554	Bacteria	Bacteria	62.4	5.93e-11	NR	EPJ19409.1	1112257	g44403	i0	66.7	0.548780487804878	45	15	54.9	0	42	176	5	49	EPJ19409.1 hypothetical protein CP02DC21_1087, partial [Chlamydia psittaci 02DC21]	diamond	135	62.4	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
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
31253987	31253987	PRJNA773778_S_NODE_26375_length_297_cov_2.718750_g26225_i0	PRJNA773778	26375	297	2.71875	8.0746875	Kiritimatiellota bacterium	2599938	Bacteria	Bacteria	42	0.0352	NR	MCX7006478.1	2599938	g26225	i0	40.9	0.444444444444444	44	26	44.4	0	157	288	54	97	MCX7006478.1 hypothetical protein [Kiritimatiellota bacterium]	diamond	132	42	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota					Kiritimatiellota bacterium
32434324	32434324	PRJNA773778_S_NODE_47379_length_242_cov_1.005917_g47229_i0	PRJNA773778	47379	242	1.005917	2.43431914	Chlamydia	810	Bacteria	Bacteria	70.5	3.63e-14	NR	EPJ19409.1	1112257	g47229	i0	75	1.06611570247934	44	11	54.5	0	180	49	7	50	EPJ19409.1 hypothetical protein CP02DC21_1087, partial [Chlamydia psittaci 02DC21]	diamond	258	71.2	0.990168539325843	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci

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