metadata: contig_metadata: 11 rows where bioproject = "PRJNA169559", tax_clade = "PVC group" and tax

11 rows where bioproject = "PRJNA169559", tax_clade = "PVC group" and tax_phylum = "Verrucomicrobiota"

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
2915725	2915725	PRJNA169559_P_NODE_37243_length_241_cov_140.844340_g35166_i0	PRJNA169559	37243	241	140.84434	339.4348594	Luteolibacter sp. AS25	3135776	Bacteria	Bacteria	285	1.96e-72	NTclustered	gi\|2889346039\|gb\|CP151837.1\|	3135776	g35166	i0	87.967	176.107883817427	241	29	100	0	1	241	454817	454577	Luteolibacter sp. AS25 chromosome, complete genome	blastn	42442	285	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. AS25
9293053	9293053	PRJNA169559_P_NODE_23348_length_323_cov_2.942177_g21275_i0	PRJNA169559	23348	323	2.942177	9.50323171	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	71.3	8.37e-8	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g21275	i0	97.561	0.126934984520124	41	1	13	0	20	60	2899691	2899731	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	41	71.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
11258030	11258030	PRJNA169559_P_NODE_1249_length_1467_cov_2.611961_g686_i0	PRJNA169559	1249	1467	2.611961	38.31746787	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	348	1.9e-109	NR	RYD77759.1	2026800	g686	i0	54.9	1.43967280163599	357	139	72.8	2	1464	397	170	505	RYD77759.1 MAG: hypothetical protein EOP84_15150, partial [Verrucomicrobiaceae bacterium]	diamond	2112	348	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
14393939	14393939	PRJNA169559_P_NODE_10532_length_521_cov_25.491870_g8755_i0	PRJNA169559	10532	521	25.49187	132.8126427	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	758	0	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g8755	i0	93.09	258.172744721689	521	31	100	5	1	521	2467	1952	Luteolibacter sp. SL250 chromosome	blastn	134508	758	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
27471086	27471086	PRJNA169559_P_NODE_15963_length_423_cov_1.685279_g14000_i0	PRJNA169559	15963	423	1.685279	7.12873017	Pseudomonadati	3379134	Bacteria	Bacteria	94.7	9.87e-20	NR	MBS0623645.1	2026799	g14000	i0	58.2	4.14893617021277	79	32	56	1	244	8	135	212	MBS0623645.1 tryptophan--tRNA ligase [Verrucomicrobiota bacterium]	diamond	1755	94.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27471089	27471089	PRJNA169559_P_NODE_3183_length_930_cov_3.138735_g2145_i0	PRJNA169559	3183	930	3.138735	29.1902355	Pseudomonadati	3379134	Bacteria	Bacteria	55.8	1.78e-4	NR	WP_294231434.1	1965333	g2145	i0	32.3	1.52903225806452	155	87	49.7	4	139	600	2065	2202	WP_294231434.1 Calx-beta domain-containing protein [Prosthecobacter sp.]	diamond	1422	55.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
27926764	27926764	PRJNA169559_P_NODE_3945_length_845_cov_2.620098_g2781_i0	PRJNA169559	3945	845	2.620098	22.1398281	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	63.9	2.86e-7	NR	MFO1485461.1	2026800	g2781	i0	40.5	0.447337278106509	126	65	44.7	2	406	29	2265	2380	MFO1485461.1 Calx-beta domain-containing protein [Verrucomicrobiaceae bacterium]	diamond	378	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28463687	28463687	PRJNA169559_P_NODE_24266_length_311_cov_2.592199_g22190_i0	PRJNA169559	24266	311	2.592199	8.06173889	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	47.8	0.0015	NR	MCX6851244.1	2026799	g22190	i0	42.9	2.82636655948553	105	48	96.5	5	308	9	901	998	MCX6851244.1 PKD domain-containing protein [Verrucomicrobiota bacterium]	diamond	879	47.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30705722	30705722	PRJNA169559_P_NODE_5454_length_727_cov_2.169054_g4075_i0	PRJNA169559	5454	727	2.169054	15.76902258	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	63.5	6.45e-8	NR	MDF1813063.1	2026801	g4075	i0	39.2	0.495185694635488	120	61	48.7	4	486	133	110	219	MDF1813063.1 carbonic anhydrase family protein [Verrucomicrobiales bacterium]	diamond	360	63.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32255656	32255656	PRJNA169559_P_NODE_11078_length_506_cov_2.742138_g9265_i0	PRJNA169559	11078	506	2.742138	13.87521828	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	142	2.67e-36	NR	HYG84357.1	2499141	g9265	i0	53	0.99604743083004	168	72	97.2	3	504	13	115	279	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	504	142	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32350397	32350397	PRJNA169559_P_NODE_4739_length_778_cov_2.746328_g3451_i0	PRJNA169559	4739	778	2.746328	21.36643184	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	63.9	2.01e-7	NR	MFO1485461.1	2026800	g3451	i0	40.5	0.48586118251928	126	65	48.6	2	373	750	2265	2380	MFO1485461.1 Calx-beta domain-containing protein [Verrucomicrobiaceae bacterium]	diamond	378	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae 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);;