metadata: contig_metadata: 10 rows where bioproject = "PRJNA1215813", tax_clade = "PVC group" and tax

10 rows where bioproject = "PRJNA1215813", 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
27628799	27628799	PRJNA1215813_P_NODE_6184_length_314_cov_0.970954_g6104_i0	PRJNA1215813	6184	314	0.970954	3.04879556	Luteolibacter	518753	Bacteria	Bacteria	137	8.84e-37	NR	MEK6230939.1	1962973	g6104	i0	56.4	8.58917197452229	101	44	96.5	0	305	3	1	101	MEK6230939.1 NAD(P)-dependent alcohol dehydrogenase [Luteolibacter sp.]	diamond	2697	137	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
27641576	27641576	PRJNA1215813_P_NODE_4484_length_362_cov_1.391003_g4404_i0	PRJNA1215813	4484	362	1.391003	5.03543086	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	72	8.38e-12	NR	WP_338285951.1	2819286	g4404	i0	42.2	2.89226519337017	109	59	89.5	3	39	362	1417	1522	WP_338285951.1 LamG-like jellyroll fold domain-containing protein [Luteolibacter sp. LG18]	diamond	1047	72	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
27957141	27957141	PRJNA1215813_P_NODE_4845_length_349_cov_1.391304_g4765_i0	PRJNA1215813	4845	349	1.391304	4.85565096	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	105	3.28e-24	NR	RYD71398.1	2026800	g4765	i0	51.4	0.902578796561605	105	50	89.4	1	3	314	257	361	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	315	105	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28209515	28209515	PRJNA1215813_P_NODE_4266_length_370_cov_1.973064_g4186_i0	PRJNA1215813	4266	370	1.973064	7.3003368	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	195	3.84e-59	NR	RYD81270.1	2026800	g4186	i0	73.6	0.981081081081081	121	32	98.1	0	2	364	128	248	RYD81270.1 MAG: hypothetical protein EOP84_11265, partial [Verrucomicrobiaceae bacterium]	diamond	363	195	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28651715	28651715	PRJNA1215813_P_NODE_10727_length_248_cov_0.891429_g10647_i0	PRJNA1215813	10727	248	0.891429	2.21074392	Spartobacteria bacterium	2052183	Bacteria	Bacteria	127	1.11e-32	NR	MEP6603974.1	2052183	g10647	i0	76.3	3.89516129032258	80	19	96.8	0	245	6	352	431	MEP6603974.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Spartobacteria bacterium]	diamond	966	127	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria				Spartobacteria bacterium
28999398	28999398	PRJNA1215813_P_NODE_3568_length_402_cov_2.224924_g3488_i0	PRJNA1215813	3568	402	2.224924	8.94419448	Chthoniobacter sp.	2510640	Bacteria	Bacteria	48.5	0.00212	NR	MDR3402202.1	2510640	g3488	i0	38.1	0.723880597014925	97	52	71.6	3	312	25	51	140	MDR3402202.1 autotransporter domain-containing protein [Chthoniobacter sp.]	diamond	291	48.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
30628400	30628400	PRJNA1215813_P_NODE_11513_length_245_cov_1.668605_g11433_i0	PRJNA1215813	11513	245	1.668605	4.08808225	PVC group	1783257	Bacteria	Bacteria	50.4	7.19e-5	NR	MBA4148241.1	2026799	g11433	i0	50	2.95102040816327	50	25	61.2	0	52	201	84	133	MBA4148241.1 tail fiber domain-containing protein [Verrucomicrobiota bacterium]	diamond	723	50.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31273402	31273402	PRJNA1215813_P_NODE_9195_length_254_cov_1.723757_g9115_i0	PRJNA1215813	9195	254	1.723757	4.37834278	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	58.2	1.62e-7	NR	MES2572115.1	2026799	g9115	i0	43.9	0.968503937007874	82	43	95.7	3	4	246	127	206	MES2572115.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	246	58.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32190878	32190878	PRJNA1215813_P_NODE_9558_length_252_cov_0.871508_g9478_i0	PRJNA1215813	9558	252	0.871508	2.19620016	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	42.7	0.0411	NR	MDF1741375.1	2026801	g9478	i0	33.8	0.773809523809524	65	42	77.4	1	16	210	75	138	MDF1741375.1 aminotransferase class V-fold PLP-dependent enzyme [Verrucomicrobiales bacterium]	diamond	195	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32570718	32570718	PRJNA1215813_P_NODE_439_length_1002_cov_3.046286_g389_i0	PRJNA1215813	439	1002	3.046286	30.52378572	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	425	3.6999999999999985e-146	NR	RYD65414.1	2026800	g389	i0	76.2	0.82934131736527	277	64	82.9	1	1	831	62	336	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	831	425	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);;