metadata: contig_metadata: 20 rows where bioproject = "PRJNA975724", tax_clade = "PVC group" and tax

20 rows where bioproject = "PRJNA975724", 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
5095128	5095128	PRJNA975724_S_NODE_5064_length_521_cov_2.537946_g4885_i0	PRJNA975724	5064	521	2.537946	13.22269866	Pseudomonadati	3379134	Bacteria	Bacteria	669	0	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g4885	i0	91.111	118.268714011516	495	43	95	1	27	520	1728837	1728343	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	61618	669	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8599177	8599177	PRJNA975724_S_NODE_44947_length_308_cov_1.374468_g44766_i0	PRJNA975724	44947	308	1.374468	4.23336144	Pseudomonadati	3379134	Bacteria	Bacteria	112	1e-27	NR	HUE54870.1	2665650	g44766	i0	72.9	2.73701298701299	70	19	68.2	0	307	98	202	271	HUE54870.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Candidatus Udaeobacter sp.]	diamond	843	112	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Candidatus Udaeobacter	Candidatus Udaeobacter sp.
9874489	9874489	PRJNA975724_S_NODE_47828_length_302_cov_1.008734_g47647_i0	PRJNA975724	47828	302	1.008734	3.04637668	Horticoccus luteus	2862869	Bacteria	Bacteria	73.1	2.16e-8	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g47647	i0	92.157	0.311258278145695	51	4	17	0	15	65	1994866	1994916	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	94	73.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
17523498	17523498	PRJNA975724_S_NODE_15654_length_409_cov_2.327381_g15473_i0	PRJNA975724	15654	409	2.327381	9.51898829	PVC group	1783257	Bacteria	Bacteria	203	2.55e-58	NR	RYD31433.1	2026800	g15473	i0	75.2	12.2053789731051	133	31	97.6	1	10	408	635	765	RYD31433.1 MAG: ATP-dependent chaperone ClpB, partial [Verrucomicrobiaceae bacterium]	diamond	4992	203	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
21347933	21347933	PRJNA975724_S_NODE_3057_length_589_cov_10.389535_g2884_i0	PRJNA975724	3057	589	10.389535	61.19436115	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	157	2.2e-41	NR	HTL48698.1	2499141	g2884	i0	60.3	2.55178268251273	131	50	66.2	2	2	391	409	538	HTL48698.1 malate synthase A [Verrucomicrobiia bacterium]	diamond	1503	157	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
21349190	21349190	PRJNA975724_S_NODE_77_length_1765_cov_69.332151_g69_i0	PRJNA975724	77	1765	69.332151	1223.71246515	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	2403	0	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g69	i0	91.487	181.873654390935	1762	128	99	17	3	1756	1728992	1727245	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	321007	2403	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
26620689	26620689	PRJNA975724_S_NODE_42501_length_314_cov_1.190871_g42320_i0	PRJNA975724	42501	314	1.190871	3.73933494	Pseudomonadati	3379134	Bacteria	Bacteria	81.3	2.06e-15	NR	MBI5382896.1	2026771	g42320	i0	52.8	9.64012738853503	72	34	68.8	0	4	219	346	417	MBI5382896.1 nucleoside monophosphate kinase [Opitutia bacterium]	diamond	3027	81.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
26772840	26772840	PRJNA975724_S_NODE_83921_length_247_cov_0.885057_g83740_i0	PRJNA975724	83921	247	0.885057	2.18609079	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.9	0.0147	NR	MEY4244725.1	2026799	g83740	i0	29.2	0.874493927125506	72	49	85	2	16	225	145	216	MEY4244725.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	216	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
26779142	26779142	PRJNA975724_S_NODE_74981_length_255_cov_2.961538_g74800_i0	PRJNA975724	74981	255	2.961538	7.5519219	Bacteria	2	Bacteria	Bacteria	44.3	0.012	NR	NDA67705.1	2026799	g74800	i0	34.3	2.43529411764706	67	38	77.6	2	16	213	272	333	NDA67705.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	621	44.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
26836289	26836289	PRJNA975724_S_NODE_3341_length_576_cov_5.172962_g3165_i0	PRJNA975724	3341	576	5.172962	29.79626112	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	85.1	2.04e-15	NR	HZT22114.1	2499141	g3165	i0	74.1	0.28125	54	13	28.1	1	573	412	506	558	HZT22114.1 TIM-barrel domain-containing protein [Verrucomicrobiia bacterium]	diamond	162	85.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
27373976	27373976	PRJNA975724_S_NODE_51103_length_295_cov_1.495495_g50922_i0	PRJNA975724	51103	295	1.495495	4.41171025	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	50.1	1.75e-4	NR	MCD8482383.1	2026799	g50922	i0	46.8	0.477966101694915	47	25	47.8	0	1	141	147	193	MCD8482383.1 adenylate kinase [Verrucomicrobiota bacterium]	diamond	141	50.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27784374	27784374	PRJNA975724_S_NODE_10084_length_449_cov_7.242021_g9903_i0	PRJNA975724	10084	449	7.242021	32.51667429	Prosthecobacter sp.	1965333	Bacteria	Bacteria	123	5.309999999999999e-31	NR	HYF35647.1	1965333	g9903	i0	55.6	0.661469933184855	99	44	66.1	0	5	301	61	159	HYF35647.1 M15 family metallopeptidase [Prosthecobacter sp.]	diamond	297	123	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
28320863	28320863	PRJNA975724_S_NODE_37146_length_327_cov_1.515748_g36965_i0	PRJNA975724	37146	327	1.515748	4.95649596	Akkermansia sp.	1872421	Bacteria	Bacteria	57.8	5.4e-7	NR	MDO5472978.1	1872421	g36965	i0	33	0.834862385321101	91	57	83.5	1	3	275	1184	1270	MDO5472978.1 ankyrin repeat domain-containing protein [Akkermansia sp.]	diamond	273	57.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp.
28643060	28643060	PRJNA975724_S_NODE_13687_length_421_cov_2.770115_g13506_i0	PRJNA975724	13687	421	2.770115	11.66218415	Pseudomonadati	3379134	Bacteria	Bacteria	61.6	6.24e-8	NR	MBQ4594403.1	1872421	g13506	i0	48.8	1.18289786223278	80	37	57	1	2	241	423	498	MBQ4594403.1 TMEM43 family protein [Akkermansia sp.]	diamond	498	61.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp.
29053485	29053485	PRJNA975724_S_NODE_69028_length_264_cov_1.308901_g68847_i0	PRJNA975724	69028	264	1.308901	3.45549864	Bacteria	2	Bacteria	Bacteria	61.6	7.43e-9	NR	HVU36819.1	2026772	g68847	i0	44.6	4	92	45	98.9	4	2	262	172	262	HVU36819.1 hypothetical protein [Opitutales bacterium]	diamond	1056	61.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
29331259	29331259	PRJNA975724_S_NODE_21389_length_380_cov_1.902280_g21208_i0	PRJNA975724	21389	380	1.90228	7.228664	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	107	4.67e-25	NR	MFM7817995.1	2026799	g21208	i0	62.5	3.52894736842105	88	25	69.5	1	27	290	221	300	MFM7817995.1 SMP-30/gluconolactonase/LRE family protein [Verrucomicrobiota bacterium]	diamond	1341	107	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29362957	29362957	PRJNA975724_S_NODE_81509_length_249_cov_0.869318_g81328_i0	PRJNA975724	81509	249	0.869318	2.16460182	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	94.7	1.97e-20	NR	RYD77759.1	2026800	g81328	i0	63.3	0.951807228915663	79	27	95.2	1	11	247	160	236	RYD77759.1 MAG: hypothetical protein EOP84_15150, partial [Verrucomicrobiaceae bacterium]	diamond	237	94.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
29615119	29615119	PRJNA975724_S_NODE_41490_length_316_cov_1.901235_g41309_i0	PRJNA975724	41490	316	1.901235	6.0079026	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	71.6	5.59e-12	NR	HLX96498.1	2499141	g41309	i0	34.6	1.01582278481013	107	57	97.8	4	315	7	306	403	HLX96498.1 FkbM family methyltransferase [Verrucomicrobiia bacterium]	diamond	321	71.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
31327743	31327743	PRJNA975724_S_NODE_79135_length_250_cov_2.610169_g78954_i0	PRJNA975724	79135	250	2.610169	6.5254225	Bacteria	2	Bacteria	Bacteria	52.4	1.68e-5	NR	HWZ95557.1	2006848	g78954	i0	57.9	4.284	38	16	45.6	0	1	114	352	389	HWZ95557.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Opitutaceae bacterium]	diamond	1071	52.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
32807275	32807275	PRJNA975724_S_NODE_920_length_826_cov_5.946879_g783_i0	PRJNA975724	920	826	5.946879	49.12122054	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	98.2	1.09e-19	NR	HUJ12053.1	2499141	g783	i0	60.3	1.07142857142857	73	29	26.5	0	825	607	268	340	HUJ12053.1 copper-containing nitrite reductase [Verrucomicrobiia bacterium]	diamond	885	98.2	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);;