metadata: contig_metadata: 6 rows where bioproject = "PRJEB14664", tax_clade = "PVC group" and tax

6 rows where bioproject = "PRJEB14664", 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
15323462	15323462	PRJEB14664_P_NODE_7693_length_289_cov_1.795276_g7563_i0	PRJEB14664	7693	289	1.795276	5.18834764	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	145	2.6e-41	NR	MCX6845248.1	2026799	g7563	i0	69.8	3.95501730103806	96	29	99.7	0	288	1	133	228	MCX6845248.1 group II intron reverse transcriptase/maturase [Verrucomicrobiota bacterium]	diamond	1143	145	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
21697878	21697878	PRJEB14664_P_NODE_14118_length_191_cov_1.076923_g13988_i0	PRJEB14664	14118	191	1.076923	2.05692293	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	263	6.97e-66	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g13988	i0	91.579	30.2198952879581	190	16	99	0	1	190	3990517	3990328	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	5772	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
26709806	26709806	PRJEB14664_P_NODE_17401_length_165_cov_1.400000_g17271_i0	PRJEB14664	17401	165	1.4	2.31	Pseudomonadati	3379134	Bacteria	Bacteria	53.5	1.99e-6	NR	WP_309386201.1	490090	g17271	i0	58.8	1.29090909090909	34	14	61.8	0	103	2	2744	2777	WP_309386201.1 DUF6531 domain-containing protein [Cerasicoccus frondis]	diamond	213	53.9	0.992578849721707	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Cerasicoccus	Cerasicoccus frondis
26875151	26875151	PRJEB14664_P_NODE_12901_length_202_cov_2.395210_g12771_i0	PRJEB14664	12901	202	2.39521	4.8383242	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.5	0.0118	NR	MEP7015139.1	2026799	g12771	i0	36	1.76732673267327	50	32	74.3	0	150	1	220	269	MEP7015139.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	357	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29590579	29590579	PRJEB14664_P_NODE_10890_length_228_cov_1.186528_g10760_i0	PRJEB14664	10890	228	1.186528	2.70528384	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	43.5	0.0167	NR	HPA20325.1	2499141	g10760	i0	40.7	0.710526315789474	54	22	57.9	1	189	58	425	478	HPA20325.1 sulfatase-like hydrolase/transferase [Verrucomicrobiia bacterium]	diamond	162	43.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32087785	32087785	PRJEB14664_P_NODE_12958_length_202_cov_1.197605_g12828_i0	PRJEB14664	12958	202	1.197605	2.4191621	Spartobacteria bacterium LR76	2161866	Bacteria	Bacteria	61.6	4.48e-9	NR	PTX96103.1	2161866	g12828	i0	51.5	0.98019801980198	66	32	98	0	3	200	255	320	PTX96103.1 hypothetical protein DB345_09910 [Spartobacteria bacterium LR76]	diamond	198	61.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria				Spartobacteria bacterium LR76

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