metadata: contig_metadata: 13 rows where bioproject = "PRJEB11748", tax_clade = "PVC group" and tax

13 rows where bioproject = "PRJEB11748", 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_species
5121005	5121005	PRJEB11748_P_NODE_349465_length_198_cov_3.781022_g347282_i0	PRJEB11748	349465	198	3.781022	7.48642356	Victivallaceae bacterium	2793042	Bacteria	Bacteria	128	2.77e-25	NTclustered	gi\|2621704067\|emb\|OY761536.1\|	2793042	g347282	i0	79.775	90.2979797979798	178	34	89	2	1	177	1447425	1447249	MAG: Victivallaceae bacterium isolate e353ef71-700a-4510-b67c-5bed4426050c genome assembly, chromosome: 1	blastn	17879	128	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae	Victivallaceae bacterium
27095899	27095899	PRJEB11748_P_NODE_116122_length_385_cov_11.299383_g113948_i0	PRJEB11748	116122	385	11.299383	43.50262455	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	199	1.8999999999999996e-56	NR	MCP4102568.1	1932692	g113948	i0	82.1	0.911688311688312	117	21	91.2	0	4	354	757	873	MCP4102568.1 hypothetical protein [Lentisphaerota bacterium]	diamond	351	199	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerota bacterium
27317599	27317599	PRJEB11748_P_NODE_373903_length_184_cov_8.235772_g371720_i0	PRJEB11748	373903	184	8.235772	15.15382048	Lentisphaeraceae bacterium	2461380	Bacteria	Bacteria	61.2	5.12e-9	NR	NQZ58730.1	2461380	g371720	i0	84.8	1.85869565217391	33	5	53.8	0	13	111	10	42	NQZ58730.1 DUF1080 domain-containing protein [Lentisphaeraceae bacterium]	diamond	342	61.2	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaerales	Lentisphaeraceae	Lentisphaeraceae bacterium
28327576	28327576	PRJEB11748_P_NODE_161806_length_321_cov_4.323077_g159623_i0	PRJEB11748	161806	321	4.323077	13.87707717	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	149	3.64e-39	NR	HAR64701.1	2053569	g159623	i0	72.5	5.7196261682243	102	27	95.3	1	313	8	689	789	HAR64701.1 bifunctional fucokinase/L-fucose-1-P-guanylyltransferase [Lentisphaeria bacterium]	diamond	1836	149	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria			Lentisphaeria bacterium
28738209	28738209	PRJEB11748_P_NODE_184207_length_298_cov_2.194093_g182024_i0	PRJEB11748	184207	298	2.194093	6.53839714	Lentisphaerae bacterium RIFOXYB12_FULL_65_16	1798581	Bacteria	Bacteria	81.6	1.52e-15	NR	OGV90287.1	1798581	g182024	i0	40.4	0.996644295302013	99	55	96.6	2	296	9	675	772	OGV90287.1 MAG: hypothetical protein A3K19_23265 [Lentisphaerae bacterium RIFOXYB12_FULL_65_16]	diamond	297	81.6	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerae bacterium RIFOXYB12_FULL_65_16
29022708	29022708	PRJEB11748_P_NODE_144328_length_342_cov_11.053381_g142149_i0	PRJEB11748	144328	342	11.053381	37.80256302	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	77	1.2e-13	NR	MBN2449418.1	2053569	g142149	i0	64.9	1.01754385964912	57	20	50	0	318	148	801	857	MBN2449418.1 laminin G domain-containing protein [Lentisphaeria bacterium]	diamond	348	77	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria			Lentisphaeria bacterium
29085666	29085666	PRJEB11748_P_NODE_213648_length_272_cov_6.298578_g211465_i0	PRJEB11748	213648	272	6.298578	17.13213216	Victivallales bacterium	2212475	Bacteria	Bacteria	52.4	1.63e-5	NR	MDD3118368.1	2212475	g211465	i0	55.3	0.419117647058824	38	17	41.9	0	56	169	215	252	MDD3118368.1 C1 family peptidase [Victivallales bacterium]	diamond	114	52.4	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales		Victivallales bacterium
29395118	29395118	PRJEB11748_P_NODE_205029_length_279_cov_10.880734_g202846_i0	PRJEB11748	205029	279	10.880734	30.35724786	Pseudomonadati	3379134	Bacteria	Bacteria	123	2.26e-30	NR	NLN00434.1	1932692	g202846	i0	69.3	4.53763440860215	75	23	80.6	0	48	272	438	512	NLN00434.1 class I SAM-dependent DNA methyltransferase [Lentisphaerota bacterium]	diamond	1266	123	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerota bacterium
29432547	29432547	PRJEB11748_P_NODE_237510_length_255_cov_2.030928_g235327_i0	PRJEB11748	237510	255	2.030928	5.1788664	Victivallales bacterium	2212475	Bacteria	Bacteria	67	3.18e-12	NR	HOK03733.1	2212475	g235327	i0	58.6	1.36470588235294	58	21	65.9	2	190	23	1	57	HOK03733.1 co-chaperone GroES [Victivallales bacterium]	diamond	348	67	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales		Victivallales bacterium
29521352	29521352	PRJEB11748_P_NODE_230990_length_259_cov_7.681818_g228807_i0	PRJEB11748	230990	259	7.681818	19.89590862	Pseudomonadati	3379134	Bacteria	Bacteria	113	1.57e-27	NR	MBR5079074.1	2212475	g228807	i0	73.4	1.43629343629344	64	17	74.1	0	258	67	284	347	MBR5079074.1 DNA cytosine methyltransferase [Victivallales bacterium]	diamond	372	114	0.991228070175439	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales		Victivallales bacterium
29805448	29805448	PRJEB11748_P_NODE_212931_length_273_cov_2.273585_g210748_i0	PRJEB11748	212931	273	2.273585	6.20688705	Pseudomonadati	3379134	Bacteria	Bacteria	144	6.909999999999999e-38	NR	MBT4815076.1	1932692	g210748	i0	89.5	7.61538461538461	76	8	83.5	0	250	23	145	220	MBT4815076.1 type I restriction endonuclease subunit R [Lentisphaerota bacterium]	diamond	2079	144	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerota bacterium
31518304	31518304	PRJEB11748_P_NODE_238796_length_254_cov_2.792746_g236613_i0	PRJEB11748	238796	254	2.792746	7.09357484	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	77	2.37e-14	NR	MCK5805031.1	2053569	g236613	i0	61.4	1.2992125984252	57	22	67.3	0	82	252	10	66	MCK5805031.1 hypothetical protein [Lentisphaeria bacterium]	diamond	330	77	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria			Lentisphaeria bacterium
32814148	32814148	PRJEB11748_P_NODE_316220_length_212_cov_2.046358_g314037_i0	PRJEB11748	316220	212	2.046358	4.33827896	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	112	9.65e-29	NR	NLF17425.1	1932692	g314037	i0	85.5	1.7688679245283	62	9	87.7	0	189	4	169	230	NLF17425.1 3-ketoacyl-ACP reductase [Lentisphaerota bacterium]	diamond	375	112	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota				Lentisphaerota 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);;