metadata: contig_metadata: 15 rows where bioproject = "PRJNA526367", tax_clade = "PVC group" and tax

15 rows where bioproject = "PRJNA526367", 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
4322738	4322738	PRJNA526367_P_NODE_26344_length_324_cov_1.898182_g26135_i0	PRJNA526367	26344	324	1.898182	6.15010968	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	82.4	3.88e-11	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g26135	i0	91.525	0.182098765432099	59	5	18	0	8	66	914841	914899	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	59	82.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
4323232	4323232	PRJNA526367_P_NODE_62264_length_155_cov_4.792453_g62054_i0	PRJNA526367	62264	155	4.792453	7.42830215	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	73.2	1.75e-13	NR	MCE2684212.1	2499141	g62054	i0	92.3	0.754838709677419	39	3	75.5	0	144	28	339	377	MCE2684212.1 mechanosensitive ion channel family protein [Verrucomicrobiia bacterium]	diamond	117	73.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
8149107	8149107	PRJNA526367_P_NODE_44087_length_176_cov_3.157480_g43877_i0	PRJNA526367	44087	176	3.15748	5.5571648	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	111	5.61e-27	NR	MEY4854465.1	2026799	g43877	i0	100	1.90909090909091	56	0	95.5	0	175	8	344	399	MEY4854465.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	336	111	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
13250258	13250258	PRJNA526367_P_NODE_8411_length_324_cov_4.040000_g8202_i0	PRJNA526367	8411	324	4.04	13.0896	Luteolibacter luteus	2728835	Bacteria	Bacteria	119	2.96e-22	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g8202	i0	90.11	0.280864197530864	91	9	28	0	232	322	1705622	1705532	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	91	119	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
22172741	22172741	PRJNA526367_P_NODE_38178_length_186_cov_3.700730_g37968_i0	PRJNA526367	38178	186	3.70073	6.8833578	Bacteria	2	Bacteria	Bacteria	101	1.9099999999999994e-24	NR	WP_035604128.1	1396141	g37968	i0	70.2	4.56451612903226	57	17	91.9	0	184	14	115	171	WP_035604128.1 glycoside hydrolase family 16 protein [Haloferula sp. BvORR071]	diamond	849	102	0.990196078431373	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula sp. BvORR071
23448460	23448460	PRJNA526367_P_NODE_44719_length_175_cov_3.015873_g44509_i0	PRJNA526367	44719	175	3.015873	5.27777775	Bacteria	2	Bacteria	Bacteria	99.8	8.89e-23	NR	MBN8459424.1	2026799	g44509	i0	89.1	7.54285714285714	55	6	94.3	0	9	173	260	314	MBN8459424.1 phage portal protein [Verrucomicrobiota bacterium]	diamond	1320	100	0.998	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28056385	28056385	PRJNA526367_P_NODE_43225_length_177_cov_5.500000_g43015_i0	PRJNA526367	43225	177	5.5	9.735	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	108	1.41e-28	NR	MEY4815829.1	2026799	g43015	i0	94.5	0.932203389830508	55	3	93.2	0	9	173	90	144	MEY4815829.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	165	108	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28498721	28498721	PRJNA526367_P_NODE_60027_length_158_cov_4.486239_g59817_i0	PRJNA526367	60027	158	4.486239	7.08825762	Opitutales bacterium	2026772	Bacteria	Bacteria	97.4	2.39e-22	NR	MCF7709931.1	2026772	g59817	i0	92	1.89873417721519	50	4	94.9	0	7	156	284	333	MCF7709931.1 23S rRNA (adenine(2503)-C(2))-methyltransferase RlmN [Opitutales bacterium]	diamond	300	97.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
28892492	28892492	PRJNA526367_P_NODE_54588_length_163_cov_6.771930_g54378_i0	PRJNA526367	54588	163	6.77193	11.0382459	Pseudomonadati	3379134	Bacteria	Bacteria	72.4	4.39e-13	NR	MDQ6654929.1	2026799	g54378	i0	73.3	1.73006134969325	45	12	82.8	0	8	142	561	605	MDQ6654929.1 dockerin type I repeat-containing protein [Verrucomicrobiota bacterium]	diamond	282	72.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
28987618	28987618	PRJNA526367_P_NODE_54968_length_163_cov_3.385965_g54758_i0	PRJNA526367	54968	163	3.385965	5.51912295	Verrucomicrobiota	74201	Bacteria	Bacteria	98.6	1.62e-24	NR	PAZ03298.1	1982317	g54758	i0	94.1	3.75460122699387	51	3	93.9	0	6	158	59	109	PAZ03298.1 MAG: hypothetical protein CAK89_02080, partial [Opitutia bacterium AMD-G3]	diamond	612	98.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium AMD-G3
29919547	29919547	PRJNA526367_P_NODE_20911_length_324_cov_2.360000_g20702_i0	PRJNA526367	20911	324	2.36	7.6464	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	49.7	3.57e-4	NR	MFM1769552.1	2026799	g20702	i0	70	0.537037037037037	30	9	27.8	0	98	9	62	91	MFM1769552.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	174	49.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30835661	30835661	PRJNA526367_P_NODE_64694_length_152_cov_5.330097_g64484_i0	PRJNA526367	64694	152	5.330097	8.10174744	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	92.8	2.2e-20	NR	NBS05292.1	2026799	g64484	i0	93.8	1.89473684210526	48	3	94.7	0	3	146	294	341	NBS05292.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	288	92.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31499644	31499644	PRJNA526367_P_NODE_63796_length_153_cov_5.480769_g63586_i0	PRJNA526367	63796	153	5.480769	8.38557657	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	97.8	5.61e-23	NR	MDF1737661.1	2026801	g63586	i0	89.6	0.941176470588235	48	5	94.1	0	9	152	96	143	MDF1737661.1 alpha/beta hydrolase-fold protein [Verrucomicrobiales bacterium]	diamond	144	97.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32480430	32480430	PRJNA526367_P_NODE_8979_length_324_cov_3.858182_g8770_i0	PRJNA526367	8979	324	3.858182	12.50050968	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	65.9	7.35e-10	NR	MCX6937266.1	2026799	g8770	i0	96.7	0.583333333333333	30	1	27.8	0	98	9	631	660	MCX6937266.1 VWA domain-containing protein [Verrucomicrobiota bacterium]	diamond	189	65.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32621758	32621758	PRJNA526367_P_NODE_38980_length_184_cov_12.237037_g38770_i0	PRJNA526367	38980	184	12.237037	22.51614808	Prosthecobacter	48463	Bacteria	Bacteria	73.6	2.32e-13	NR	WP_294227521.1	1965333	g38770	i0	59.4	7.30434782608696	64	21	96.2	1	1	177	124	187	WP_294227521.1 YHYH protein [Prosthecobacter sp.]	diamond	1344	73.9	0.995940460081191	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.

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