metadata: contig_metadata: 16 rows where bioproject = "PRJNA1199330", tax_clade = "PVC group" and tax

16 rows where bioproject = "PRJNA1199330", 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
6147213	6147213	PRJNA1199330_P_NODE_54365_length_297_cov_3.165179_g53666_i0	PRJNA1199330	54365	297	3.165179	9.40058163	Verrucomicrobiota	74201	Bacteria	Bacteria	86.1	2.72e-12	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g53666	i0	85.366	0.552188552188552	82	12	28	0	31	112	5154017	5153936	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	164	86.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
24551163	24551163	PRJNA1199330_P_NODE_114740_length_243_cov_0.917647_g114041_i0	PRJNA1199330	114740	243	0.917647	2.22988221	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	82.8	5.3e-17	NR	QTN31272.1	2562705	g114041	i0	56.7	1.58024691358025	67	29	82.7	0	230	30	7	73	QTN31272.1 glucosamine-6-phosphate deaminase [Akkermansiaceae bacterium]	diamond	384	82.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
27103998	27103998	PRJNA1199330_P_NODE_58882_length_291_cov_2.779817_g58183_i0	PRJNA1199330	58882	291	2.779817	8.08926747	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	64.3	1.02e-9	NR	MDB6056527.1	2026801	g58183	i0	47.6	0.845360824742268	82	42	83.5	1	45	287	59	140	MDB6056527.1 serine/threonine-protein phosphatase 6 regulatory ankyrin repeat subunit A-like isoform [Verrucomicrobiales bacterium]	diamond	246	64.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
29346303	29346303	PRJNA1199330_P_NODE_53489_length_299_cov_1.371681_g52790_i0	PRJNA1199330	53489	299	1.371681	4.10132619	Opitutales bacterium	2026772	Bacteria	Bacteria	56.6	7.51e-7	NR	MCH8475895.1	2026772	g52790	i0	52.7	0.551839464882943	55	17	55.2	1	219	55	209	254	MCH8475895.1 LamG domain-containing protein [Opitutales bacterium]	diamond	165	56.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
29756524	29756524	PRJNA1199330_P_NODE_106931_length_248_cov_2.645714_g106232_i0	PRJNA1199330	106931	248	2.645714	6.56137072	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	42.4	0.0474	NR	HEV7406036.1	2811408	g106232	i0	43.2	0.44758064516129	37	21	44.8	0	247	137	100	136	HEV7406036.1 ankyrin repeat domain-containing protein [Chthoniobacteraceae bacterium]	diamond	111	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
29933658	29933658	PRJNA1199330_P_NODE_117151_length_240_cov_2.730539_g116452_i0	PRJNA1199330	117151	240	2.730539	6.5532936	Opitutaceae	134623	Bacteria	Bacteria	42.7	0.0346	NR	MEX2043917.1	1913982	g116452	i0	40.8	3.0875	49	24	61.3	1	85	231	13	56	MEX2043917.1 prepilin peptidase [Opitutus sp.]	diamond	741	43.1	0.990719257540603	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
29933661	29933661	PRJNA1199330_P_NODE_52531_length_300_cov_3.132159_g51832_i0	PRJNA1199330	52531	300	3.132159	9.396477	Bacteria	2	Bacteria	Bacteria	49.3	3.45e-4	NR	HUB66694.1	2720631	g51832	i0	46.7	2.13	60	32	60	0	185	6	52	111	HUB66694.1 ankyrin repeat domain-containing protein [Candidatus Methylacidiphilales bacterium]	diamond	639	49.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales			Candidatus Methylacidiphilales bacterium
29946290	29946290	PRJNA1199330_P_NODE_64771_length_286_cov_2.361502_g64072_i0	PRJNA1199330	64771	286	2.361502	6.75389572	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	47.4	3.12e-4	NR	MBV8416944.1	2026799	g64072	i0	34.7	2.16083916083916	72	47	75.5	0	234	19	39	110	MBV8416944.1 tetratricopeptide repeat protein [Verrucomicrobiota bacterium]	diamond	618	47.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30546502	30546502	PRJNA1199330_P_NODE_68553_length_283_cov_1.485714_g67854_i0	PRJNA1199330	68553	283	1.485714	4.20457062	Prosthecobacter sp.	1965333	Bacteria	Bacteria	43.9	0.0197	NR	MCA1962363.1	1965333	g67854	i0	34.4	0.646643109540636	61	40	64.7	0	90	272	107	167	MCA1962363.1 hypothetical protein [Prosthecobacter sp.]	diamond	183	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
30641096	30641096	PRJNA1199330_P_NODE_118793_length_236_cov_3.355828_g118094_i0	PRJNA1199330	118793	236	3.355828	7.91975408	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	67.8	4.97e-11	NR	HEY3915274.1	2499141	g118094	i0	46.4	3.53389830508475	69	37	87.7	0	28	234	303	371	HEY3915274.1 DUF4982 domain-containing protein [Verrucomicrobiia bacterium]	diamond	834	67.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
30672737	30672737	PRJNA1199330_P_NODE_57153_length_293_cov_1.931818_g56454_i0	PRJNA1199330	57153	293	1.931818	5.66022674	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	75.9	1.14e-14	NR	MCX6913889.1	2026799	g56454	i0	47.2	0.737201365187713	72	38	73.7	0	76	291	52	123	MCX6913889.1 PA14 domain-containing protein [Verrucomicrobiota bacterium]	diamond	216	75.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31640005	31640005	PRJNA1199330_P_NODE_16136_length_509_cov_3.052752_g15446_i0	PRJNA1199330	16136	509	3.052752	15.53850768	Pseudomonadati	3379134	Bacteria	Bacteria	107	1.0699999999999997e-23	NR	AKC83384.1	1637999	g15446	i0	46.6	2.30451866404715	118	55	64.8	2	384	55	30	147	AKC83384.1 hypothetical protein IMCC26134_12420 [Verrucomicrobia bacterium IMCC26134]	diamond	1173	107	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
32051339	32051339	PRJNA1199330_P_NODE_94418_length_259_cov_1.408602_g93719_i0	PRJNA1199330	94418	259	1.408602	3.64827918	PVC group	1783257	Bacteria	Bacteria	50.4	8.53e-5	NR	MBP9902046.1	2026799	g93719	i0	36.9	2.86100386100386	84	52	97.3	1	3	254	243	325	MBP9902046.1 serine/threonine protein kinase [Verrucomicrobiota bacterium]	diamond	741	50.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32664555	32664555	PRJNA1199330_P_NODE_24340_length_416_cov_2.655977_g23644_i0	PRJNA1199330	24340	416	2.655977	11.04886432	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	64.3	6.38e-9	NR	MEY4917918.1	2026799	g23644	i0	32.1	1.96875	140	74	92.3	6	399	16	78	208	MEY4917918.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	819	64.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32790496	32790496	PRJNA1199330_P_NODE_86800_length_266_cov_2.056995_g86101_i0	PRJNA1199330	86800	266	2.056995	5.4716067	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	68.2	4.14e-11	NR	MEI7955772.1	2026799	g86101	i0	36.6	4.6015037593985	82	39	92.5	2	7	252	209	277	MEI7955772.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	1224	68.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32822166	32822166	PRJNA1199330_P_NODE_36140_length_344_cov_2.276753_g35441_i0	PRJNA1199330	36140	344	2.276753	7.83203032	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	77.4	8.22e-14	NR	HXI84029.1	2499141	g35441	i0	63.6	0.575581395348837	66	22	57.6	2	299	102	227	290	HXI84029.1 NF038122 family metalloprotease [Verrucomicrobiia bacterium]	diamond	198	77.4	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);;