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

8 rows where bioproject = "PRJNA638138", 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
26891408	26891408	PRJNA638138_P_NODE_24081_length_248_cov_0.880000_g23866_i0	PRJNA638138	24081	248	0.88	2.1824	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	91.7	2.5e-19	NR	HTL46626.1	2499141	g23866	i0	58.5	0.991935483870968	82	33	98	1	2	244	1655	1736	HTL46626.1 FHA domain-containing protein [Verrucomicrobiia bacterium]	diamond	246	91.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27207190	27207190	PRJNA638138_P_NODE_27082_length_246_cov_0.890173_g26867_i0	PRJNA638138	27082	246	0.890173	2.18982558	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	107	7.6299999999999995e-25	NR	MBL9168996.1	2026801	g26867	i0	57.3	7	82	35	100	0	1	246	361	442	MBL9168996.1 sigma 54-interacting transcriptional regulator [Verrucomicrobiales bacterium]	diamond	1722	107	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28230180	28230180	PRJNA638138_P_NODE_23926_length_248_cov_0.880000_g23711_i0	PRJNA638138	23926	248	0.88	2.1824	Bacteria	2	Bacteria	Bacteria	119	1.02e-29	NR	MDX1951286.1	2026799	g23711	i0	70.7	2.9758064516129	82	24	99.2	0	1	246	4	85	MDX1951286.1 response regulator [Verrucomicrobiota bacterium]	diamond	738	119	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28375793	28375793	PRJNA638138_P_NODE_18586_length_255_cov_0.967033_g18371_i0	PRJNA638138	18586	255	0.967033	2.46593415	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.1	0.0294	NR	MEY4379496.1	2026799	g18371	i0	39.7	2.22352941176471	63	34	69.4	1	238	62	26	88	MEY4379496.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	567	43.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31692850	31692850	PRJNA638138_P_NODE_28777_length_245_cov_0.895349_g28562_i0	PRJNA638138	28777	245	0.895349	2.19360505	Opitutaceae bacterium	2006848	Bacteria	Bacteria	43.9	0.0145	NR	MBE7538573.1	2006848	g28562	i0	42.1	0.930612244897959	76	36	83.3	2	31	234	311	386	MBE7538573.1 MFS transporter [Opitutaceae bacterium]	diamond	228	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31787598	31787598	PRJNA638138_P_NODE_27137_length_246_cov_0.890173_g26922_i0	PRJNA638138	27137	246	0.890173	2.18982558	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	124	1.04e-30	NR	WP_166647267.1	48464	g26922	i0	79	0.98780487804878	81	17	98.8	0	2	244	637	717	WP_166647267.1 tetratricopeptide repeat protein [Prosthecobacter fusiformis]	diamond	243	124	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
32483981	32483981	PRJNA638138_P_NODE_26939_length_246_cov_0.890173_g26724_i0	PRJNA638138	26939	246	0.890173	2.18982558	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	128	2.53e-32	NR	MDB6038781.1	2026801	g26724	i0	71.3	0.975609756097561	80	23	97.6	0	3	242	613	692	MDB6038781.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	240	128	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32578909	32578909	PRJNA638138_P_NODE_31199_length_244_cov_0.900585_g30984_i0	PRJNA638138	31199	244	0.900585	2.1974274	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	129	9.999999999999999e-33	NR	HEY6225739.1	2499141	g30984	i0	73.8	0.983606557377049	80	20	97.1	1	5	241	1103	1182	HEY6225739.1 sugar-binding protein [Verrucomicrobiia bacterium]	diamond	240	129	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);;