metadata: contig_metadata: 16 rows where bioproject = "PRJNA345071" and tax

16 rows where bioproject = "PRJNA345071" 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
2943962	2943962	PRJNA345071_P_NODE_2523_length_367_cov_1.326531_g2483_i0	PRJNA345071	2523	367	1.326531	4.86836877	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	162	5.67e-46	NR	MBL9145181.1	2026800	g2483	i0	66.4	3.85013623978202	119	40	97.3	0	358	2	219	337	MBL9145181.1 alkene reductase [Verrucomicrobiaceae bacterium]	diamond	1413	162	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
11273584	11273584	PRJNA345071_P_NODE_2129_length_390_cov_1.684543_g2089_i0	PRJNA345071	2129	390	1.684543	6.5697177	Planctomycetia	203683	Bacteria	Bacteria	160	4.54e-44	NR	WP_075092413.1	1632864	g2089	i0	58.1	13.9	129	53	99.2	1	3	389	230	357	WP_075092413.1 aldehyde dehydrogenase family protein [Planctomyces sp. SH-PL14]	diamond	5421	161	0.993788819875776	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
18245033	18245033	PRJNA345071_P_NODE_8955_length_248_cov_0.891429_g8915_i0	PRJNA345071	8955	248	0.891429	2.21074392	Bacteria	2	Bacteria	Bacteria	161	1.05e-46	NR	TMQ35404.1	2026780	g8915	i0	91.5	6.93145161290323	82	7	99.2	0	247	2	34	115	TMQ35404.1 MAG: mandelate racemase/muconate lactonizing enzyme family protein [Planctomycetota bacterium]	diamond	1719	161	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27060348	27060348	PRJNA345071_P_NODE_3442_length_330_cov_1.194553_g3402_i0	PRJNA345071	3442	330	1.194553	3.9420249	Pseudomonadati	3379134	Bacteria	Bacteria	113	5.08e-27	NR	MFT7518666.1	2212473	g3402	i0	60.6	3.60909090909091	109	39	99.1	2	2	328	43	147	MFT7518666.1 acetyl-CoA acyltransferase [Kiritimatiellia bacterium]	diamond	1191	114	0.991228070175439	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
27106206	27106206	PRJNA345071_P_NODE_9262_length_247_cov_0.896552_g9222_i0	PRJNA345071	9262	247	0.896552	2.21448344	Planctomycetota bacterium	2026780	Bacteria	Bacteria	87	7.76e-18	NR	MBA3699814.1	2026780	g9222	i0	56	1.02024291497976	84	33	97.2	2	245	6	343	426	MBA3699814.1 metallophosphoesterase family protein [Planctomycetota bacterium]	diamond	252	87	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
27959144	27959144	PRJNA345071_P_NODE_7005_length_260_cov_1.545455_g6965_i0	PRJNA345071	7005	260	1.545455	4.018183	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	51.2	4.78e-5	NR	MFA5042876.1	2212473	g6965	i0	48.1	0.623076923076923	54	28	62.3	0	89	250	249	302	MFA5042876.1 ATP-binding protein [Kiritimatiellia bacterium]	diamond	162	51.2	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
29064395	29064395	PRJNA345071_P_NODE_6548_length_266_cov_1.492228_g6508_i0	PRJNA345071	6548	266	1.492228	3.96932648	Planctomycetota bacterium	2026780	Bacteria	Bacteria	86.3	3.69e-18	NR	MEO0652808.1	2026780	g6508	i0	71.7	1.19548872180451	53	15	59.8	0	2	160	206	258	MEO0652808.1 3-hydroxyacyl-CoA dehydrogenase NAD-binding domain-containing protein [Planctomycetota bacterium]	diamond	318	86.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29506203	29506203	PRJNA345071_P_NODE_4670_length_296_cov_1.399103_g4630_i0	PRJNA345071	4670	296	1.399103	4.14134488	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	45.8	0.00537	NR	MCD8535897.1	2026799	g4630	i0	37.8	2.56418918918919	74	42	74	3	292	74	143	213	MCD8535897.1 inorganic phosphate transporter [Verrucomicrobiota bacterium]	diamond	759	45.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30218267	30218267	PRJNA345071_P_NODE_10412_length_243_cov_0.917647_g10372_i0	PRJNA345071	10412	243	0.917647	2.22988221	Pseudomonadati	3379134	Bacteria	Bacteria	113	6.080000000000001e-27	NR	MBL4848360.1	2026780	g10372	i0	73.1	8.64197530864197	78	21	96.3	0	238	5	468	545	MBL4848360.1 hypothetical protein [Planctomycetota bacterium]	diamond	2100	114	0.991228070175439	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30565541	30565541	PRJNA345071_P_NODE_9573_length_246_cov_0.901734_g9533_i0	PRJNA345071	9573	246	0.901734	2.21826564	PVC group	1783257	Bacteria	Bacteria	129	2.77e-35	NR	MEY4690911.1	2026799	g9533	i0	78.5	9.86585365853658	79	17	96.3	0	243	7	12	90	MEY4690911.1 protein chain initiation factor [Verrucomicrobiota bacterium]	diamond	2427	130	0.992307692307692	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30611736	30611736	PRJNA345071_P_NODE_8693_length_249_cov_0.886364_g8653_i0	PRJNA345071	8693	249	0.886364	2.20704636	Schlesneria paludicola	360056	Bacteria	Bacteria	46.2	0.00251	NR	WP_010586447.1	360056	g8653	i0	44.2	0.518072289156627	43	23	50.6	1	4	129	85	127	WP_010586447.1 YCF48-related protein [Schlesneria paludicola]	diamond	129	46.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Schlesneria	Schlesneria paludicola
30864538	30864538	PRJNA345071_P_NODE_2014_length_399_cov_2.969325_g1974_i0	PRJNA345071	2014	399	2.969325	11.84760675	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	110	1.3800000000000002e-27	NR	MBE2204437.1	2201154	g1974	i0	48.3	0.87218045112781994	116	48	82	2	397	71	52	162	MBE2204437.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	348	110	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
30864541	30864541	PRJNA345071_P_NODE_8434_length_250_cov_0.881356_g8394_i0	PRJNA345071	8434	250	0.881356	2.20339	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	159	1.12e-45	NR	MDB6032081.1	2026801	g8394	i0	84.3	0.996	83	13	99.6	0	249	1	262	344	MDB6032081.1 prepilin-type N-terminal cleavage/methylation domain [Verrucomicrobiales bacterium]	diamond	249	159	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
31781366	31781366	PRJNA345071_P_NODE_2957_length_347_cov_1.562044_g2917_i0	PRJNA345071	2957	347	1.562044	5.42029268	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	135	5.15e-35	NR	HEY5895444.1	2201154	g2917	i0	56.4	5.67146974063401	110	48	95.1	0	347	18	300	409	HEY5895444.1 aldehyde dehydrogenase family protein [Chthoniobacterales bacterium]	diamond	1968	135	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
31813168	31813168	PRJNA345071_P_NODE_4737_length_295_cov_1.405405_g4697_i0	PRJNA345071	4737	295	1.405405	4.14594475	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	43.5	0.0138	NR	MDF1850130.1	2026801	g4697	i0	37	0.935593220338983	92	47	93.6	2	15	290	19	99	MDF1850130.1 EF-hand domain-containing protein [Verrucomicrobiales bacterium]	diamond	276	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32792638	32792638	PRJNA345071_P_NODE_1860_length_411_cov_3.142012_g1820_i0	PRJNA345071	1860	411	3.142012	12.91366932	Planctomycetota bacterium	2026780	Bacteria	Bacteria	167	2.52e-48	NR	NOT29227.1	2026780	g1820	i0	59.7	3.90510948905109	134	54	97.8	0	407	6	89	222	NOT29227.1 3-hydroxybutyryl-CoA dehydrogenase [Planctomycetota bacterium]	diamond	1605	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota 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);;