metadata: contig_metadata: 18 rows where bioproject = "PRJNA758398", tax_clade = "PVC group" and tax

18 rows where bioproject = "PRJNA758398", 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
3291278	3291278	PRJNA758398_S_NODE_623_length_1051_cov_7.841317_g561_i0	PRJNA758398	623	1051	7.841317	82.41224167	Chthoniobacter sp.	2510640	Bacteria	Bacteria	562	6.780000000000001e-198	NR	MDR3405335.1	2510640	g561	i0	84.9	0.887725975261656	311	47	88.8	0	2	934	154	464	MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.]	diamond	933	562	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
8857472	8857472	PRJNA758398_S_NODE_49547_length_163_cov_1.070175_g49406_i0	PRJNA758398	49547	163	1.070175	1.74438525	Pseudomonadati	3379134	Bacteria	Bacteria	85.5	4.6e-18	NR	WP_105042398.1	1658618	g49406	i0	70.9	15.0552147239264	55	15	99.4	1	163	2	151	205	WP_105042398.1 NADPH-dependent aldehyde reductase Ahr [Rubritalea profundi]	diamond	2454	86.3	0.990730011587486	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Rubritaleaceae	Rubritalea	Rubritalea profundi
12219649	12219649	PRJNA758398_S_NODE_54070_length_161_cov_0.910714_g53929_i0	PRJNA758398	54070	161	0.910714	1.46624954	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g53929	i0	100	0.53416149068323	30	0	19	0	18	47	4786616	4786645	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	86	56.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
19866565	19866565	PRJNA758398_S_NODE_25536_length_207_cov_0.968354_g25395_i0	PRJNA758398	25536	207	0.968354	2.00449278	Pseudomonadati	3379134	Bacteria	Bacteria	82	3.29e-16	NR	PYK95879.1	2026799	g25395	i0	59.4	3.98550724637681	69	26	97.1	1	203	3	143	211	PYK95879.1 MAG: hypothetical protein DME36_00335, partial [Verrucomicrobiota bacterium]	diamond	825	82.8	0.990338164251208	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
21142538	21142538	PRJNA758398_S_NODE_53317_length_161_cov_1.285714_g53176_i0	PRJNA758398	53317	161	1.285714	2.06999954	Intestinicryptomonas porci	2926320	Bacteria	Bacteria	99.8	9.9e-23	NR	WP_370397429.1	2926320	g53176	i0	83	0.987577639751553	53	9	98.8	0	159	1	312	364	WP_370397429.1 phosphoenolpyruvate carboxykinase (GTP) [Intestinicryptomonas porci]	diamond	159	99.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Intestinicryptomonaceae	Intestinicryptomonas	Intestinicryptomonas porci
26831552	26831552	PRJNA758398_S_NODE_16681_length_244_cov_2.353846_g16540_i0	PRJNA758398	16681	244	2.353846	5.74338424	Haloferula sp. A5	2497595	Bacteria	Bacteria	55.5	1.24e-6	NR	WP_396261396.1	3373601	g16540	i0	46.6	0.897540983606557	73	33	86.1	2	244	35	255	324	WP_396261396.1 REJ domain-containing protein [Haloferula sp. A504]	diamond	219	55.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula sp. A504
27274373	27274373	PRJNA758398_S_NODE_52303_length_162_cov_0.902655_g52162_i0	PRJNA758398	52303	162	0.902655	1.4623011	Roseibacillus sp.	2024856	Bacteria	Bacteria	51.6	9.54e-6	NR	MDE0594669.1	2024856	g52162	i0	53.8	0.722222222222222	39	18	72.2	0	162	46	1639	1677	MDE0594669.1 hypothetical protein [Roseibacillus sp.]	diamond	117	51.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseibacillus	Roseibacillus sp.
27758078	27758078	PRJNA758398_S_NODE_26944_length_202_cov_1.830065_g26803_i0	PRJNA758398	26944	202	1.830065	3.6967313	Verrucomicrobiales	48461	Bacteria	Bacteria	45.1	0.00325	NR	WP_409218333.1	1965333	g26803	i0	56.3	3.9950495049505	32	14	47.5	0	176	81	391	422	WP_409218333.1 tail fiber domain-containing protein [Prosthecobacter sp.]	diamond	807	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
27969006	27969006	PRJNA758398_S_NODE_2685_length_570_cov_2.715931_g2549_i0	PRJNA758398	2685	570	2.715931	15.4808067	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	126	8.299999999999999e-32	NR	HYY13131.1	2201154	g2549	i0	35.4	3.02105263157895	189	121	99.5	1	1	567	7	194	HYY13131.1 prohibitin family protein [Chthoniobacterales bacterium]	diamond	1722	126	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
29895236	29895236	PRJNA758398_S_NODE_51611_length_162_cov_0.902655_g51470_i0	PRJNA758398	51611	162	0.902655	1.4623011	Candidatus Udaeobacter sp.	2665650	Bacteria	Bacteria	77.4	4.21e-15	NR	MEP6585888.1	2665650	g51470	i0	73.6	5.88888888888889	53	14	98.1	0	2	160	230	282	MEP6585888.1 2-hydroxyacid dehydrogenase [Candidatus Udaeobacter sp.]	diamond	954	77.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Candidatus Udaeobacter	Candidatus Udaeobacter sp.
31001046	31001046	PRJNA758398_S_NODE_53434_length_161_cov_0.910714_g53293_i0	PRJNA758398	53434	161	0.910714	1.46624954	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	74.7	6.44e-14	NR	MDZ4742534.1	2026799	g53293	i0	66	1.97515527950311	53	18	98.8	0	2	160	114	166	MDZ4742534.1 thiamine pyrophosphate-binding protein [Verrucomicrobiota bacterium]	diamond	318	74.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31380375	31380375	PRJNA758398_S_NODE_23956_length_212_cov_1.177914_g23815_i0	PRJNA758398	23956	212	1.177914	2.49717768	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	45.1	0.00312	NR	MBA3963317.1	2201154	g23815	i0	40.3	0.94811320754717	67	34	94.8	2	201	1	118	178	MBA3963317.1 CAP domain-containing protein [Chthoniobacterales bacterium]	diamond	201	45.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
31886251	31886251	PRJNA758398_S_NODE_26217_length_205_cov_0.852564_g26076_i0	PRJNA758398	26217	205	0.852564	1.7477562	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	47	5.43e-4	NR	MFL6516254.1	2201154	g26076	i0	39	4.41951219512195	59	30	86.3	2	24	200	117	169	MFL6516254.1 CAP domain-containing protein [Chthoniobacterales bacterium]	diamond	906	47	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
31896033	31896033	PRJNA758398_S_NODE_27137_length_202_cov_1.117647_g26996_i0	PRJNA758398	27137	202	1.117647	2.25764694	Pseudomonadati	3379134	Bacteria	Bacteria	73.9	2.13e-13	NR	WP_290503119.1	1872421	g26996	i0	61.1	15.4455445544554	54	21	80.2	0	180	19	300	353	WP_290503119.1 glutamine synthetase III, partial [Akkermansia sp.]	diamond	3120	73.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp.
32044558	32044558	PRJNA758398_S_NODE_27118_length_202_cov_1.274510_g26977_i0	PRJNA758398	27118	202	1.27451	2.5745102	Haloferula sargassicola	490096	Bacteria	Bacteria	72.8	5.55e-13	NR	WP_353565328.1	490096	g26977	i0	59.1	0.98019801980198	66	19	98	2	201	4	113	170	WP_353565328.1 FAD-dependent oxidoreductase [Haloferula sargassicola]	diamond	198	72.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula sargassicola
32234666	32234666	PRJNA758398_S_NODE_16938_length_243_cov_1.314433_g16797_i0	PRJNA758398	16938	243	1.314433	3.19407219	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	51.2	9.5e-6	NR	MCD7799200.1	2562705	g16797	i0	55.6	0.444444444444444	36	16	44.4	0	6	113	10	45	MCD7799200.1 sel1 repeat family protein [Akkermansiaceae bacterium]	diamond	108	51.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
32361232	32361232	PRJNA758398_S_NODE_53439_length_161_cov_0.910714_g53298_i0	PRJNA758398	53439	161	0.910714	1.46624954	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	47.4	2.89e-4	NR	MEW6156130.1	2026799	g53298	i0	60	0.838509316770186	45	17	83.9	1	159	25	8208	8251	MEW6156130.1 Ig-like domain-containing protein [Verrucomicrobiota bacterium]	diamond	135	47.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32771187	32771187	PRJNA758398_S_NODE_54220_length_161_cov_0.910714_g54079_i0	PRJNA758398	54220	161	0.910714	1.46624954	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	69.3	5.12e-12	NR	MBS0637429.1	2026799	g54079	i0	72.1	1.60248447204969	43	12	80.1	0	159	31	168	210	MBS0637429.1 isoleucine--tRNA ligase [Verrucomicrobiota bacterium]	diamond	258	69.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;