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

15 rows where bioproject = "PRJNA1108009", tax_clade = "PVC group" and tax_phylum = "Lentisphaerota"

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
1487870	1487870	PRJNA1108009_P_NODE_31442_length_241_cov_0.916667_g31124_i0	PRJNA1108009	31442	241	0.916667	2.20916747	Victivallaceae bacterium	2793042	Bacteria	Bacteria	198	2.63e-46	NTclustered	gi\|2621704067\|emb\|OY761536.1\|	2793042	g31124	i0	82.128	61.1120331950208	235	39	97	3	9	241	1447136	1447369	MAG: Victivallaceae bacterium isolate e353ef71-700a-4510-b67c-5bed4426050c genome assembly, chromosome: 1	blastn	14728	198	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae		Victivallaceae bacterium
5316034	5316034	PRJNA1108009_P_NODE_28425_length_246_cov_0.890173_g28107_i0	PRJNA1108009	28425	246	0.890173	2.18982558	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	154	2.4699999999999998e-42	NR	MBO7328531.1	2053569	g28107	i0	89	1	82	9	100	0	1	246	410	491	MBO7328531.1 DEAD/DEAH box helicase [Lentisphaeria bacterium]	diamond	246	154	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
14241915	14241915	PRJNA1108009_P_NODE_27412_length_247_cov_0.885057_g27094_i0	PRJNA1108009	27412	247	0.885057	2.18609079	Lentisphaerota	256845	Bacteria	Bacteria	63.2	2.47e-9	NR	WP_307259964.1	760260	g27094	i0	44.6	2.87854251012146	74	41	89.9	0	245	24	836	909	WP_307259964.1 response regulator [Oligosphaera ethanolica]	diamond	711	63.5	0.995275590551181	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Oligosphaeria	Oligosphaerales	Oligosphaeraceae	Oligosphaera	Oligosphaera ethanolica
26655960	26655960	PRJNA1108009_P_NODE_22781_length_265_cov_1.572917_g22463_i0	PRJNA1108009	22781	265	1.572917	4.16823005	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	163	2.39e-44	NR	MBR2910011.1	2053569	g22463	i0	91.5	0.928301886792453	82	7	92.8	0	1	246	914	995	MBR2910011.1 DUF4838 domain-containing protein [Lentisphaeria bacterium]	diamond	246	163	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
26719153	26719153	PRJNA1108009_P_NODE_27821_length_247_cov_0.885057_g27503_i0	PRJNA1108009	27821	247	0.885057	2.18609079	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	165	6.03e-49	NR	MBR2433982.1	2053569	g27503	i0	100	0.995951417004049	82	0	99.6	0	2	247	14	95	MBR2433982.1 hypothetical protein [Lentisphaeria bacterium]	diamond	246	165	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
27762958	27762958	PRJNA1108009_P_NODE_31844_length_241_cov_0.916667_g31526_i0	PRJNA1108009	31844	241	0.916667	2.20916747	uncultured Victivallis sp.	354118	Bacteria	Bacteria	66.6	9.43e-11	NR	WP_294506809.1	354118	g31526	i0	78	1.13278008298755	41	9	51	0	117	239	48	88	WP_294506809.1 zinc-ribbon domain and TM2 domain-containing protein [uncultured Victivallis sp.]	diamond	273	66.6	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae	Victivallis	uncultured Victivallis sp.
27943518	27943518	PRJNA1108009_P_NODE_28745_length_245_cov_0.895349_g28427_i0	PRJNA1108009	28745	245	0.895349	2.19360505	Bacteria	2	Bacteria	Bacteria	164	2.0399999999999998e-47	NR	MBE6384085.1	1932692	g28427	i0	92.6	1.98367346938776	81	6	99.2	0	3	245	201	281	MBE6384085.1 GntR family transcriptional regulator [Lentisphaerota bacterium]	diamond	486	164	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
27952164	27952164	PRJNA1108009_P_NODE_25685_length_250_cov_0.870056_g25367_i0	PRJNA1108009	25685	250	0.870056	2.17514	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	127	6.8e-33	NR	MBE6397330.1	1932692	g25367	i0	73.2	1.968	82	22	98.4	0	5	250	100	181	MBE6397330.1 metallophosphoesterase [Lentisphaerota bacterium]	diamond	492	127	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
28394092	28394092	PRJNA1108009_P_NODE_30166_length_243_cov_0.905882_g29848_i0	PRJNA1108009	30166	243	0.905882	2.20129326	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	141	5.77e-38	NR	MBE6369335.1	1932692	g29848	i0	87.5	0.987654320987654	80	10	98.8	0	2	241	202	281	MBE6369335.1 GAF domain-containing protein [Lentisphaerota bacterium]	diamond	240	141	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
28552187	28552187	PRJNA1108009_P_NODE_29407_length_244_cov_0.900585_g29089_i0	PRJNA1108009	29407	244	0.900585	2.1974274	Victivallales bacterium	2212475	Bacteria	Bacteria	153	5.89e-41	NR	MBP5670770.1	2212475	g29089	i0	90.1	3.98360655737705	81	8	99.6	0	2	244	695	775	MBP5670770.1 carboxypeptidase regulatory-like domain-containing protein [Victivallales bacterium]	diamond	972	153	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales			Victivallales bacterium
28646864	28646864	PRJNA1108009_P_NODE_30547_length_243_cov_0.905882_g30229_i0	PRJNA1108009	30547	243	0.905882	2.20129326	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	151	1.2199999999999999e-42	NR	MBQ9787842.1	2053569	g30229	i0	90.1	1	81	8	100	0	243	1	202	282	MBQ9787842.1 IS110 family transposase [Lentisphaeria bacterium]	diamond	243	151	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
31078912	31078912	PRJNA1108009_P_NODE_27375_length_247_cov_0.885057_g27057_i0	PRJNA1108009	27375	247	0.885057	2.18609079	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	126	2.15e-34	NR	MBE6406137.1	1932692	g27057	i0	98.5	0.789473684210526	65	1	78.9	0	196	2	1	65	MBE6406137.1 DUF1425 domain-containing protein [Lentisphaerota bacterium]	diamond	195	126	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
31141589	31141589	PRJNA1108009_P_NODE_23035_length_263_cov_1.589474_g22717_i0	PRJNA1108009	23035	263	1.589474	4.18031662	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	119	9.3e-31	NR	MBO5681863.1	2053569	g22717	i0	92.1	0.718631178707224	63	5	71.9	0	3	191	217	279	MBO5681863.1 ATP-binding protein [Lentisphaeria bacterium]	diamond	189	119	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
31616306	31616306	PRJNA1108009_P_NODE_28216_length_246_cov_0.890173_g27898_i0	PRJNA1108009	28216	246	0.890173	2.18982558	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	120	9.74e-31	NR	MBO5792019.1	2053569	g27898	i0	78.7	1.82926829268293	75	16	91.5	0	22	246	1	75	MBO5792019.1 peptide chain release factor 2 [Lentisphaeria bacterium]	diamond	450	120	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
32722948	32722948	PRJNA1108009_P_NODE_25780_length_250_cov_0.870056_g25462_i0	PRJNA1108009	25780	250	0.870056	2.17514	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	96.3	5.08e-21	NR	HCN09085.1	2053569	g25462	i0	53.2	2.844	79	37	94.8	0	242	6	371	449	HCN09085.1 hypothetical protein [Lentisphaeria bacterium]	diamond	711	96.3	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria 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);;