metadata: contig_metadata: 10 rows where bioproject = "PRJNA849646", tax_clade = "PVC group" and tax

10 rows where bioproject = "PRJNA849646", 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
18689454	18689454	PRJNA849646_P_NODE_20735_length_267_cov_1.587629_g20617_i0	PRJNA849646	20735	267	1.587629	4.23896943	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	165	3.01e-36	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g20617	i0	100	16.936329588015	89	0	33	0	104	192	3104641	3104729	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	4522	165	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
26801628	26801628	PRJNA849646_P_NODE_34781_length_245_cov_1.465116_g34663_i0	PRJNA849646	34781	245	1.465116	3.5895342	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	59.3	5.47e-8	NR	MFN0127071.1	2026801	g34663	i0	66	0.612244897959184	50	17	61.2	0	2	151	562	611	MFN0127071.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	150	59.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
27813254	27813254	PRJNA849646_P_NODE_41424_length_229_cov_2.846154_g41306_i0	PRJNA849646	41424	229	2.846154	6.51769266	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	125	6.51e-34	NR	HEX2747241.1	2026801	g41306	i0	85.5	1.99126637554585	76	11	99.6	0	229	2	88	163	HEX2747241.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	456	125	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
28097152	28097152	PRJNA849646_P_NODE_31165_length_249_cov_0.875000_g31047_i0	PRJNA849646	31165	249	0.875	2.17875	Opitutaceae bacterium	2006848	Bacteria	Bacteria	151	1.3099999999999999e-42	NR	MBL9217340.1	2006848	g31047	i0	85.5	1	83	12	100	0	1	249	182	264	MBL9217340.1 S9 family peptidase [Opitutaceae bacterium]	diamond	249	151	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
29991762	29991762	PRJNA849646_P_NODE_19471_length_269_cov_2.571429_g19353_i0	PRJNA849646	19471	269	2.571429	6.91714401	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	113	2.9400000000000004e-27	NR	MFH1499368.1	2026799	g19353	i0	65.2	2.97769516728625	89	28	99.3	1	2	268	28	113	MFH1499368.1 efflux transporter outer membrane subunit [Verrucomicrobiota bacterium]	diamond	801	113	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30560175	30560175	PRJNA849646_P_NODE_31753_length_248_cov_2.268571_g31635_i0	PRJNA849646	31753	248	2.268571	5.62605608	Luteolibacter rhizosphaerae	2989719	Bacteria	Bacteria	163	7.15e-46	NR	WP_264513820.1	2989719	g31635	i0	95.1	0.991935483870968	82	4	99.2	0	248	3	349	430	WP_264513820.1 hypothetical protein [Luteolibacter rhizosphaerae]	diamond	246	163	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter rhizosphaerae
30750043	30750043	PRJNA849646_P_NODE_41694_length_228_cov_2.554839_g41576_i0	PRJNA849646	41694	228	2.554839	5.82503292	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	145	3.82e-42	NR	MEO6181529.1	2026799	g41576	i0	93.3	1.97368421052632	75	5	98.7	0	2	226	22	96	MEO6181529.1 ribosome recycling factor [Verrucomicrobiota bacterium]	diamond	450	145	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31002845	31002845	PRJNA849646_P_NODE_4414_length_310_cov_3.784810_g4296_i0	PRJNA849646	4414	310	3.78481	11.732911	Lacunisphaera sp.	1961806	Bacteria	Bacteria	53.5	1.34e-5	NR	HEY4246383.1	1961806	g4296	i0	44.4	0.958064516129032	99	41	83.2	3	309	52	236	333	HEY4246383.1 hypothetical protein [Lacunisphaera sp.]	diamond	297	53.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
31390547	31390547	PRJNA849646_P_NODE_24676_length_259_cov_3.161290_g24558_i0	PRJNA849646	24676	259	3.16129	8.1877411	Luteolibacter	518753	Bacteria	Bacteria	104	4.54e-24	NR	MFT3992151.1	1962973	g24558	i0	48.8	2.98841698841699	86	44	99.6	0	1	258	38	123	MFT3992151.1 phage portal protein [Luteolibacter sp.]	diamond	774	104	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
32678390	32678390	PRJNA849646_P_NODE_39440_length_238_cov_2.200000_g39322_i0	PRJNA849646	39440	238	2.2	5.236	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	114	7.37e-29	NR	HEX8313130.1	2811408	g39322	i0	64.1	3.5546218487395	78	28	98.3	0	235	2	131	208	HEX8313130.1 hypothetical protein [Chthoniobacteraceae bacterium]	diamond	846	114	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae 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);;