metadata: contig_metadata: 7 rows where bioproject = "PRJNA896758", tax_clade = "PVC group" and tax

7 rows where bioproject = "PRJNA896758", 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
14900701	14900701	PRJNA896758_P_NODE_11132_length_344_cov_1.309963_g10742_i0	PRJNA896758	11132	344	1.309963	4.50627272	Chthoniobacter flavus	191863	Bacteria	Bacteria	514	3.45e-141	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g10742	i0	93.66	265.470930232558	347	16	100	6	1	344	2341	1998	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	91322	514	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
14900809	14900809	PRJNA896758_P_NODE_25632_length_243_cov_0.905882_g25242_i0	PRJNA896758	25632	243	0.905882	2.20129326	Ereboglobus luteus	1796921	Bacteria	Bacteria	130	9.84e-26	NTclustered	gi\|1387286769\|gb\|CP023004.1\|	1796921	g25242	i0	78.713	1.52263374485597	202	38	83	3	15	215	1639177	1638980	Ereboglobus luteus strain Ho45, complete genome	blastn	370	130	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Ereboglobus	Ereboglobus luteus
28413815	28413815	PRJNA896758_P_NODE_17006_length_280_cov_1.743961_g16616_i0	PRJNA896758	17006	280	1.743961	4.8830908	Opitutaceae bacterium	2006848	Bacteria	Bacteria	112	2.66e-26	NR	MCU0791279.1	2006848	g16616	i0	60	0.964285714285714	90	36	96.4	0	11	280	717	806	MCU0791279.1 translocation/assembly module TamB [Opitutaceae bacterium]	diamond	270	112	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
29013944	29013944	PRJNA896758_P_NODE_13028_length_319_cov_0.841463_g12638_i0	PRJNA896758	13028	319	0.841463	2.68426697	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.5	0.0314	NR	MEI6341235.1	2026799	g12638	i0	33.7	0.780564263322884	83	46	69.6	2	58	279	84	166	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	249	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29297837	29297837	PRJNA896758_P_NODE_19949_length_260_cov_1.256684_g19559_i0	PRJNA896758	19949	260	1.256684	3.2673784	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	46.2	0.00173	NR	MEI6341235.1	2026799	g19559	i0	36.8	0.876923076923077	76	39	77.3	2	218	18	84	159	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	228	46.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29329320	29329320	PRJNA896758_P_NODE_17189_length_279_cov_1.470874_g16799_i0	PRJNA896758	17189	279	1.470874	4.10373846	Luteolibacter luteus	2728835	Bacteria	Bacteria	140	1.94e-36	NR	WP_169455091.1	2728835	g16799	i0	67.7	1	93	29	100	1	279	1	555	646	WP_169455091.1 multicopper oxidase domain-containing protein [Luteolibacter luteus]	diamond	279	140	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
30750872	30750872	PRJNA896758_P_NODE_23314_length_247_cov_0.885057_g22924_i0	PRJNA896758	23314	247	0.885057	2.18609079	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	111	2.39e-29	NR	HEU5071473.1	2499141	g22924	i0	76.4	0.874493927125506	72	17	87.4	0	247	32	57	128	HEU5071473.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	216	111	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia 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);;