metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA738523" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA738523" and tax_clade = "PVC group"

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
21599931	21599931	PRJNA738523_P_NODE_7777_length_276_cov_1.517241_g7706_i0	PRJNA738523	7777	276	1.517241	4.18758516	Planctomycetia bacterium	2052181	Bacteria	Bacteria	166	4.18e-51	NR	MFN7811535.1	2052181	g7706	i0	87.9	26.3586956521739	91	10	98.9	1	274	2	11	100	MFN7811535.1 peptidylprolyl isomerase [Planctomycetia bacterium]	diamond	7275	166	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
26841345	26841345	PRJNA738523_P_NODE_15461_length_242_cov_0.911243_g15390_i0	PRJNA738523	15461	242	0.911243	2.20520806	root	1	Root_unresolved	Root_unresolved	123	6.57e-32	NR	MBA4067446.1	41672	g15390	i0	68.8	12.8429752066116	80	25	99.2	0	241	2	56	135	MBA4067446.1 hypothetical protein [Isosphaera sp.]	diamond	3108	123	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera sp.
26925910	26925910	PRJNA738523_P_NODE_12482_length_248_cov_0.880000_g12411_i0	PRJNA738523	12482	248	0.88	2.1824	Victivallis sp. Marseille-Q1	2049020	Bacteria	Bacteria	42.7	0.0408	NR	WP_176013793.1	2717288	g12411	i0	32.9	0.919354838709677	76	48	91.9	2	11	238	1426	1498	WP_176013793.1 beta-galactosidase [Victivallis sp. Marseille-Q1083]	diamond	228	42.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae	Victivallis	Victivallis sp. Marseille-Q1083
27526431	27526431	PRJNA738523_P_NODE_6163_length_294_cov_1.393665_g6092_i0	PRJNA738523	6163	294	1.393665	4.0973751	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	42	0.0479	NR	MFC1807255.1	2035772	g6092	i0	41.8	0.561224489795918	55	25	56.1	1	237	73	79	126	MFC1807255.1 hypothetical protein [Candidatus Omnitrophota bacterium]	diamond	165	42	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
28189235	28189235	PRJNA738523_P_NODE_15186_length_243_cov_0.905882_g15115_i0	PRJNA738523	15186	243	0.905882	2.20129326	Victivallales bacterium	2212475	Bacteria	Bacteria	47	0.00114	NR	MBT7302852.1	2212475	g15115	i0	42.9	1.38271604938272	56	32	69.1	0	20	187	361	416	MBT7302852.1 hypothetical protein [Victivallales bacterium]	diamond	336	47	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales			Victivallales bacterium
28315870	28315870	PRJNA738523_P_NODE_8126_length_273_cov_1.200000_g8055_i0	PRJNA738523	8126	273	1.2	3.276	Planctomycetia bacterium TMED53	1986839	Bacteria	Bacteria	69.7	2.78e-12	NR	OUU20198.1	1986839	g8055	i0	46.2	1.02197802197802	93	40	91.2	3	267	19	47	139	OUU20198.1 MAG: hypothetical protein CBC13_11030 [Planctomycetia bacterium TMED53]	diamond	279	69.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium TMED53
29168487	29168487	PRJNA738523_P_NODE_8169_length_272_cov_1.547739_g8098_i0	PRJNA738523	8169	272	1.547739	4.20985008	Planctomycetota bacterium	2026780	Bacteria	Bacteria	117	1.74e-29	NR	MDJ0521746.1	2026780	g8098	i0	63.8	2.98897058823529	94	30	99.3	1	271	2	172	265	MDJ0521746.1 aldo/keto reductase [Planctomycetota bacterium]	diamond	813	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29262793	29262793	PRJNA738523_P_NODE_15029_length_243_cov_0.905882_g14958_i0	PRJNA738523	15029	243	0.905882	2.20129326	Planctomycetota bacterium	2026780	Bacteria	Bacteria	61.6	8.07e-9	NR	MEM9410382.1	2026780	g14958	i0	43.2	1.76543209876543	74	40	91.4	1	2	223	121	192	MEM9410382.1 glycoside hydrolase family 2 TIM barrel-domain containing protein [Planctomycetota bacterium]	diamond	429	61.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30937299	30937299	PRJNA738523_P_NODE_13814_length_245_cov_0.895349_g13743_i0	PRJNA738523	13814	245	0.895349	2.19360505	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	84.3	8.73e-17	NR	HEY8902023.1	2201154	g13743	i0	58.1	0.906122448979592	74	29	90.6	1	2	223	858	929	HEY8902023.1 ATP-binding protein [Chthoniobacterales bacterium]	diamond	222	84.3	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
31221291	31221291	PRJNA738523_P_NODE_12595_length_247_cov_1.431034_g12524_i0	PRJNA738523	12595	247	1.431034	3.53465398	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	94.4	5.38e-23	NR	MDO8629942.1	2052180	g12524	i0	69.2	0.789473684210526	65	20	78.9	0	197	3	24	88	MDO8629942.1 hypothetical protein [Phycisphaerales bacterium]	diamond	195	94.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
31348164	31348164	PRJNA738523_P_NODE_16496_length_232_cov_2.930818_g16425_i0	PRJNA738523	16496	232	2.930818	6.79949776	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	43.9	0.00902	NR	MEI6341235.1	2026799	g16425	i0	36	0.969827586206897	75	39	85.3	2	10	207	84	158	MEI6341235.1 permease prefix domain 1-containing protein [Verrucomicrobiota bacterium]	diamond	225	43.9	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);;