metadata: contig_metadata: 19 rows where bioproject = "PRJNA1008624", tax_clade = "PVC group" and tax

19 rows where bioproject = "PRJNA1008624", 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
2704629	2704629	PRJNA1008624_P_NODE_29563_length_167_cov_0.881356_g29375_i0	PRJNA1008624	29563	167	0.881356	1.47186452	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	117	6.83e-29	NR	MDH4476474.1	2026800	g29375	i0	100	0.970059880239521	54	0	97	0	2	163	716	769	MDH4476474.1 DEAD/DEAH box helicase [Verrucomicrobiaceae bacterium]	diamond	162	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
10357519	10357519	PRJNA1008624_P_NODE_30189_length_167_cov_0.881356_g30001_i0	PRJNA1008624	30189	167	0.881356	1.47186452	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	101	3.4e-26	NR	MDA0814886.1	2026799	g30001	i0	100	1.8502994011976	49	0	88	0	2	148	68	116	MDA0814886.1 DNA methyltransferase [Verrucomicrobiota bacterium]	diamond	309	101	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
26591017	26591017	PRJNA1008624_P_NODE_12621_length_236_cov_0.994652_g12433_i0	PRJNA1008624	12621	236	0.994652	2.34737872	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	85.1	1.09e-18	NR	MEI7534237.1	2499141	g12433	i0	64.4	0.75	59	21	75	0	5	181	92	150	MEI7534237.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	177	85.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27571623	27571623	PRJNA1008624_P_NODE_35144_length_163_cov_0.912281_g34956_i0	PRJNA1008624	35144	163	0.912281	1.48701803	Prosthecobacter debontii	48467	Bacteria	Bacteria	77.8	5.32e-15	NR	WP_139373074.1	48467	g34956	i0	63.5	0.957055214723926	52	19	95.7	0	161	6	477	528	WP_139373074.1 DNA methyltransferase [Prosthecobacter debontii]	diamond	156	77.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter debontii
27603422	27603422	PRJNA1008624_P_NODE_33644_length_164_cov_0.904348_g33456_i0	PRJNA1008624	33644	164	0.904348	1.48313072	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	67	3.47e-11	NR	MEI7912756.1	2026799	g33456	i0	62.5	1.82926829268293	48	18	87.8	0	148	5	299	346	MEI7912756.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	300	67	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27761380	27761380	PRJNA1008624_P_NODE_28824_length_168_cov_0.873950_g28636_i0	PRJNA1008624	28824	168	0.87395	1.468236	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	111	1.03e-26	NR	MEN9675717.1	2026799	g28636	i0	96.4	0.982142857142857	55	2	98.2	0	1	165	595	649	MEN9675717.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	165	111	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28266040	28266040	PRJNA1008624_P_NODE_25386_length_174_cov_1.192000_g25198_i0	PRJNA1008624	25386	174	1.192	2.07408	Luteolibacter pohnpeiensis	454153	Bacteria	Bacteria	81.3	9.92e-17	NR	WP_200273539.1	454153	g25198	i0	61.4	0.982758620689655	57	22	98.3	0	172	2	81	137	WP_200273539.1 phage protease [Luteolibacter pohnpeiensis]	diamond	171	81.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter pohnpeiensis
29623445	29623445	PRJNA1008624_P_NODE_34750_length_163_cov_1.350877_g34562_i0	PRJNA1008624	34750	163	1.350877	2.20192951	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	67.4	2.54e-11	NR	MBP7950373.1	2026801	g34562	i0	58.5	0.975460122699387	53	22	97.5	0	2	160	213	265	MBP7950373.1 hypothetical protein [Verrucomicrobiales bacterium]	diamond	159	67.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
29686805	29686805	PRJNA1008624_P_NODE_33730_length_164_cov_0.904348_g33542_i0	PRJNA1008624	33730	164	0.904348	1.48313072	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	77.4	6.74e-15	NR	HOX60287.1	2026799	g33542	i0	64.7	0.932926829268293	51	18	93.3	0	155	3	199	249	HOX60287.1 helicase-related protein [Verrucomicrobiota bacterium]	diamond	153	77.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30027166	30027166	PRJNA1008624_P_NODE_24731_length_176_cov_1.220472_g24543_i0	PRJNA1008624	24731	176	1.220472	2.14803072	Pseudomonadati	3379134	Bacteria	Bacteria	98.6	2.32e-22	NR	MEI6590165.1	2026799	g24543	i0	73.7	7.70454545454545	57	15	97.2	0	5	175	36	92	MEI6590165.1 terminase family protein [Verrucomicrobiota bacterium]	diamond	1356	99.4	0.991951710261569	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30382475	30382475	PRJNA1008624_P_NODE_14493_length_221_cov_2.040698_g14305_i0	PRJNA1008624	14493	221	2.040698	4.50994258	Pedosphaera sp.	2024890	Bacteria	Bacteria	42.4	0.0268	NR	MSR66356.1	2024890	g14305	i0	47.6	0.570135746606335	42	22	57	0	201	76	110	151	MSR66356.1 50S ribosomal protein L5 [Pedosphaera sp.]	diamond	126	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp.
30880070	30880070	PRJNA1008624_P_NODE_27294_length_169_cov_0.866667_g27106_i0	PRJNA1008624	27294	169	0.866667	1.46466723	PVC group	1783257	Bacteria	Bacteria	61.6	2.08e-9	NR	NDA10765.1	2026799	g27106	i0	44.2	3.69230769230769	52	29	92.3	0	161	6	142	193	NDA10765.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	624	61.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30887588	30887588	PRJNA1008624_P_NODE_34234_length_164_cov_0.904348_g34046_i0	PRJNA1008624	34234	164	0.904348	1.48313072	Opitutus sp.	1913982	Bacteria	Bacteria	51.2	4.51e-6	NR	MCR6655395.1	1913982	g34046	i0	44.2	1.90243902439024	52	29	95.1	0	6	161	57	108	MCR6655395.1 hypothetical protein [Opitutus sp.]	diamond	312	51.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
31013941	31013941	PRJNA1008624_P_NODE_23695_length_179_cov_1.576923_g23507_i0	PRJNA1008624	23695	179	1.576923	2.82269217	Luteolibacter marinus	2776705	Bacteria	Bacteria	54.7	9.57e-7	NR	WP_226895735.1	2776705	g23507	i0	65.2	0.770949720670391	46	14	73.7	1	44	175	2	47	WP_226895735.1 phage portal protein family protein [Luteolibacter marinus]	diamond	138	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter marinus
31013944	31013944	PRJNA1008624_P_NODE_31555_length_166_cov_0.888889_g31367_i0	PRJNA1008624	31555	166	0.888889	1.47555574	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	80.1	3.54e-16	NR	MEI6605146.1	2026799	g31367	i0	64.8	1.87951807228916	54	19	97.6	0	164	3	123	176	MEI6605146.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	312	80.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31361855	31361855	PRJNA1008624_P_NODE_35356_length_163_cov_0.912281_g35168_i0	PRJNA1008624	35356	163	0.912281	1.48701803	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	44.3	0.00362	NR	MCD6048717.1	2026799	g35168	i0	42	0.920245398773006	50	29	92	0	13	162	236	285	MCD6048717.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	150	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32089246	32089246	PRJNA1008624_P_NODE_27178_length_169_cov_0.866667_g26990_i0	PRJNA1008624	27178	169	0.866667	1.46466723	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	47.4	1.91e-4	NR	NBR96056.1	2026799	g26990	i0	42.2	0.798816568047337	45	26	79.9	0	143	9	56	100	NBR96056.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	135	47.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32721327	32721327	PRJNA1008624_P_NODE_30160_length_167_cov_0.881356_g29972_i0	PRJNA1008624	30160	167	0.881356	1.47186452	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	42	0.0248	NR	HZI57841.1	2499141	g29972	i0	39.2	0.916167664670659	51	28	88	2	1	147	149	198	HZI57841.1 alpha/beta hydrolase [Verrucomicrobiia bacterium]	diamond	153	42	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32721331	32721331	PRJNA1008624_P_NODE_35360_length_163_cov_0.912281_g35172_i0	PRJNA1008624	35360	163	0.912281	1.48701803	Opitutus sp. ER46	2161864	Bacteria	Bacteria	62.4	4.99e-10	NR	WP_107835476.1	2161864	g35172	i0	65.4	0.957055214723926	52	18	95.7	0	159	4	138	189	WP_107835476.1 hypothetical protein [Opitutus sp. ER46]	diamond	156	62.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. ER46

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