metadata: contig_metadata: 5 rows where bioproject = "PRJNA637328", tax_clade = "PVC group" and tax

5 rows where bioproject = "PRJNA637328", 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_species
3159934	3159934	PRJNA637328_P_NODE_16583_length_251_cov_4.024752_g16106_i0	PRJNA637328	16583	251	4.024752	10.10212752	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	250	7.52e-62	NTclustered	gi\|226525261\|gb\|FJ872372.1\|	156588	g16106	i0	85.366	205.179282868526	246	31	97	5	3	245	11978	11735	Uncultured Verrucomicrobia bacterium clone 106 genomic sequence	blastn	51500	250	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota			uncultured Verrucomicrobiota bacterium
4983402	4983402	PRJNA637328_S_NODE_3944_length_157_cov_0.975000_g3867_i0	PRJNA637328	3944	157	0.975	1.53075	Verrucomicrobiota	74201	Bacteria	Bacteria	276	7.06e-70	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g3867	i0	98.71	174.191082802548	155	2	99	0	1	155	5154276	5154430	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	27348	276	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia		uncultured Verrucomicrobiae bacterium
27744663	27744663	PRJNA637328_S_NODE_3984_length_156_cov_1.033613_g3907_i0	PRJNA637328	3984	156	1.033613	1.61243628	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	40.8	0.0439	NR	GIT06037.1	2026799	g3907	i0	50	0.769230769230769	40	18	76.9	1	19	138	29	66	GIT06037.1 MAG: hypothetical protein CM1200mP29_14480 [Verrucomicrobiota bacterium]	diamond	120	40.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota			Verrucomicrobiota bacterium
27870572	27870572	PRJNA637328_P_NODE_13505_length_266_cov_3.580645_g13029_i0	PRJNA637328	13505	266	3.580645	9.5245157	Opitutia bacterium	2026771	Bacteria	Bacteria	119	3.71e-32	NR	MEL0099990.1	2026771	g13029	i0	62.5	1.98496240601504	88	33	99.2	0	266	3	14	101	MEL0099990.1 hypothetical protein [Opitutia bacterium]	diamond	528	119	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia		Opitutia bacterium
30365777	30365777	PRJNA637328_P_NODE_7112_length_334_cov_1.224561_g6637_i0	PRJNA637328	7112	334	1.224561	4.09003374	Opitutales bacterium	2026772	Bacteria	Bacteria	44.7	0.0194	NR	HNX04777.1	2026772	g6637	i0	42.6	0.94311377245509	54	20	45.8	2	57	209	14	59	HNX04777.1 prepilin peptidase [Opitutales bacterium]	diamond	315	44.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutales 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);;