metadata: contig_metadata: 12 rows where bioproject = "PRJNA800090", tax_clade = "PVC group" and tax

12 rows where bioproject = "PRJNA800090", 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
14826479	14826479	PRJNA800090_P_NODE_176912_length_234_cov_0.884848_g174727_i0	PRJNA800090	176912	234	0.884848	2.07054432	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	137	7.4e-40	NR	HBJ84963.1	2026801	g174727	i0	83.1	16.3846153846154	77	13	98.7	0	2	232	44	120	HBJ84963.1 adenosylhomocysteinase [Verrucomicrobiales bacterium]	diamond	3834	137	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
27054177	27054177	PRJNA800090_P_NODE_193022_length_228_cov_0.905660_g190837_i0	PRJNA800090	193022	228	0.90566	2.0649048	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	57	2.82e-7	NR	RYD77759.1	2026800	g190837	i0	42.1	1	76	43	98.7	1	226	2	476	551	RYD77759.1 MAG: hypothetical protein EOP84_15150, partial [Verrucomicrobiaceae bacterium]	diamond	228	57	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
27085813	27085813	PRJNA800090_P_NODE_782_length_2967_cov_6.441339_g668_i0	PRJNA800090	782	2967	6.441339	191.11452813	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	53.9	0.00606	NR	MBL9145035.1	2026800	g668	i0	32	1.49544994944388	272	147	25.8	12	1040	1804	1328	1578	MBL9145035.1 autotransporter-associated beta strand repeat-containing protein [Verrucomicrobiaceae bacterium]	diamond	4437	53.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28317434	28317434	PRJNA800090_P_NODE_182086_length_232_cov_0.895706_g179901_i0	PRJNA800090	182086	232	0.895706	2.07803792	Pedosphaera sp.	2024890	Bacteria	Bacteria	42.4	0.0466	NR	MDB6125895.1	2024890	g179901	i0	37.8	0.956896551724138	74	35	95.7	2	231	10	2146	2208	MDB6125895.1 hypothetical protein [Pedosphaera sp.]	diamond	222	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp.
28443873	28443873	PRJNA800090_P_NODE_172186_length_236_cov_1.718563_g170001_i0	PRJNA800090	172186	236	1.718563	4.05580868	Fontisphaera persica	2974023	Bacteria	Bacteria	98.2	1.05e-21	NR	WP_283847491.1	2974023	g170001	i0	57.1	1.95762711864407	77	32	97.9	1	231	1	891	966	WP_283847491.1 prolyl oligopeptidase family serine peptidase [Fontisphaera persica]	diamond	462	98.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
28885632	28885632	PRJNA800090_P_NODE_149088_length_257_cov_1.473404_g146903_i0	PRJNA800090	149088	257	1.473404	3.78664828	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	67	1.18e-10	NR	HEY3856761.1	2499141	g146903	i0	44.7	3.31517509727626	85	41	99.2	1	2	256	221	299	HEY3856761.1 flagellar assembly protein FliW [Verrucomicrobiia bacterium]	diamond	852	67	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
29526216	29526216	PRJNA800090_P_NODE_116710_length_297_cov_1.263158_g114525_i0	PRJNA800090	116710	297	1.263158	3.75157926	Pseudomonadati	3379134	Bacteria	Bacteria	51.6	5.5e-5	NR	HXB01788.1	2006848	g114525	i0	38.4	3.51515151515152	73	43	71.7	1	253	41	604	676	HXB01788.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Opitutaceae bacterium]	diamond	1044	51.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
31127980	31127980	PRJNA800090_P_NODE_160315_length_246_cov_2.231638_g158130_i0	PRJNA800090	160315	246	2.231638	5.48982948	Candidatus Methylacidiphilales bacterium	2720631	Bacteria	Bacteria	42.7	0.0347	NR	MEZ0297522.1	2720631	g158130	i0	46.5	0.524390243902439	43	22	51.2	1	18	143	122	164	MEZ0297522.1 hypothetical protein [Candidatus Methylacidiphilales bacterium]	diamond	129	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Methylacidiphilae	Methylacidiphilales			Candidatus Methylacidiphilales bacterium
31381469	31381469	PRJNA800090_P_NODE_190036_length_229_cov_0.912500_g187851_i0	PRJNA800090	190036	229	0.9125	2.089625	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	79	4.06e-15	NR	MEY2551633.1	2026799	g187851	i0	64.2	4.33624454148472	53	19	69.4	0	69	227	1	53	MEY2551633.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	993	79	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31950562	31950562	PRJNA800090_P_NODE_140297_length_266_cov_1.263959_g138112_i0	PRJNA800090	140297	266	1.263959	3.36213094	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	43.1	0.0347	NR	MFL6529243.1	2201154	g138112	i0	41.5	0.462406015037594	41	24	46.2	0	82	204	196	236	MFL6529243.1 chromate efflux transporter [Chthoniobacterales bacterium]	diamond	123	43.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
32108889	32108889	PRJNA800090_P_NODE_3538_length_1923_cov_2.515102_g3069_i0	PRJNA800090	3538	1923	2.515102	48.36541146	Rubritalea marina	361055	Bacteria	Bacteria	62.4	1.25e-6	NR	WP_018970839.1	361055	g3069	i0	31.9	0.622464898595944	116	76	17.9	2	77	421	22	135	WP_018970839.1 PEP-CTERM sorting domain-containing protein [Rubritalea marina]	diamond	1197	62.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Rubritaleaceae	Rubritalea	Rubritalea marina
32307957	32307957	PRJNA800090_P_NODE_50339_length_504_cov_2.006897_g48158_i0	PRJNA800090	50339	504	2.006897	10.11476088	Pseudomonadati	3379134	Bacteria	Bacteria	130	2.1e-31	NR	MDW8349745.1	2499141	g48158	i0	45	3.03571428571429	169	85	98.8	5	5	502	491	654	MDW8349745.1 S8 family serine peptidase [Verrucomicrobiia bacterium]	diamond	1530	130	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);;