metadata: contig_metadata: 8 rows where bioproject = "PRJNA760976", tax_clade = "PVC group" and tax

8 rows where bioproject = "PRJNA760976", 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
3293632	3293632	PRJNA760976_P_NODE_31363_length_297_cov_2.008929_g31042_i0	PRJNA760976	31363	297	2.008929	5.96651913	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	129	2.49e-32	NR	HEY5753501.1	2201154	g31042	i0	61.5	4.57575757575758	91	35	91.9	0	3	275	382	472	HEY5753501.1 alpha-galactosidase [Chthoniobacterales bacterium]	diamond	1359	129	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
5845986	5845986	PRJNA760976_P_NODE_52085_length_245_cov_0.877907_g51764_i0	PRJNA760976	52085	245	0.877907	2.15087215	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g51764	i0	100	202.167346938776	245	0	100	0	1	245	736722	736478	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	49531	453	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13496071	13496071	PRJNA760976_P_NODE_13571_length_399_cov_2.168712_g13251_i0	PRJNA760976	13571	399	2.168712	8.65316088	Candidatus Organicella extenuata	2841811	Bacteria	Bacteria	78.7	6.31e-10	NTclustered	gi\|2569232906\|gb\|CP128385.1\|	2841811	g13251	i0	82.222	13.4411027568922	90	16	23	0	309	398	111648	111737	MAG: Candidatus Organicella extenuata isolate MAG_Ga0307966_1000010 chromosome, complete genome	blastn	5363	78.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Candidatus Organicella	Candidatus Organicella extenuata
29526023	29526023	PRJNA760976_P_NODE_47910_length_251_cov_1.264045_g47589_i0	PRJNA760976	47910	251	1.264045	3.17275295	Pseudomonadati	3379134	Bacteria	Bacteria	102	6.989999999999999e-24	NR	MBS0634548.1	2026799	g47589	i0	61.8	3.70517928286853	76	29	90.8	0	249	22	28	103	MBS0634548.1 glycosyltransferase [Verrucomicrobiota bacterium]	diamond	930	103	0.990291262135922	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30653276	30653276	PRJNA760976_P_NODE_49273_length_248_cov_2.600000_g48952_i0	PRJNA760976	49273	248	2.6	6.448	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	45.8	7.3e-4	NR	MEI6341283.1	2026799	g48952	i0	58.1	0.375	31	13	37.5	0	105	13	4	34	MEI6341283.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	93	45.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31664863	31664863	PRJNA760976_P_NODE_51137_length_246_cov_0.890173_g50816_i0	PRJNA760976	51137	246	0.890173	2.18982558	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.4	0.0423	NR	MCX6950839.1	2026799	g50816	i0	39.3	0.682926829268293	56	33	68.3	1	62	229	106	160	MCX6950839.1 phosphatase PAP2 family protein [Verrucomicrobiota bacterium]	diamond	168	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32298122	32298122	PRJNA760976_P_NODE_39559_length_273_cov_0.950000_g39238_i0	PRJNA760976	39559	273	0.95	2.5935	Haloferula helveola	490095	Bacteria	Bacteria	56.2	9.72e-7	NR	WP_338688672.1	490095	g39238	i0	50	0.769230769230769	70	27	73.6	3	34	234	116	180	WP_338688672.1 IPT/TIG domain-containing protein [Haloferula helveola]	diamond	210	56.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula helveola
32613942	32613942	PRJNA760976_P_NODE_57040_length_239_cov_2.728916_g56719_i0	PRJNA760976	57040	239	2.728916	6.52210924	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	97.1	5.69e-22	NR	HYY13565.1	2201154	g56719	i0	60	8.56066945606694	75	30	94.1	0	230	6	28	102	HYY13565.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	2046	97.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales 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);;