metadata: contig_metadata: 11 rows where bioproject = "PRJEB20058", tax_clade = "PVC group" and tax

11 rows where bioproject = "PRJEB20058", 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
25793809	25793809	PRJEB20058_P_NODE_77555_length_471_cov_2.653659_g74775_i0	PRJEB20058	77555	471	2.653659	12.49873389	Victivallis lenta	2606640	Bacteria	Bacteria	206	1.55e-58	NR	WP_206213243.1	2606640	g74775	i0	68.8	1.8343949044586	144	45	91.7	0	455	24	612	755	WP_206213243.1 glycoside hydrolase family 2 TIM barrel-domain containing protein [Victivallis lenta]	diamond	864	206	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae	Victivallis	Victivallis lenta
26021343	26021343	PRJEB20058_P_NODE_173020_length_284_cov_1.219731_g170197_i0	PRJEB20058	173020	284	1.219731	3.46403604	Pseudomonadati	3379134	Bacteria	Bacteria	117	2.02e-30	NR	MBT3377565.1	1932692	g170197	i0	63.8	1.98591549295775	94	34	99.3	0	1	282	96	189	MBT3377565.1 ABC transporter ATP-binding protein [Lentisphaerota bacterium]	diamond	564	117	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
32927636	32927636	PRJEB20058_P_NODE_12489_length_1175_cov_14.113106_g10851_i0	PRJEB20058	12489	1175	14.113106	165.8289955	Victivallales bacterium	2212475	Bacteria	Bacteria	125	1.48e-29	NR	HJO91783.1	2212475	g10851	i0	36	0.454468085106383	178	113	45.2	1	1099	569	74	251	HJO91783.1 methionine biosynthesis protein MetW [Victivallales bacterium]	diamond	534	125	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales			Victivallales bacterium
32940009	32940009	PRJEB20058_P_NODE_172353_length_284_cov_20.479821_g169530_i0	PRJEB20058	172353	284	20.479821	58.16269164	Pseudomonadati	3379134	Bacteria	Bacteria	179	1.53e-51	NR	MDD2404534.1	2793042	g169530	i0	100	1.8169014084507	86	0	90.8	0	259	2	328	413	MDD2404534.1 DUF262 domain-containing protein [Victivallaceae bacterium]	diamond	516	179	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae		Victivallaceae bacterium
32962389	32962389	PRJEB20058_P_NODE_184898_length_270_cov_9.870813_g182075_i0	PRJEB20058	184898	270	9.870813	26.6511951	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	73.2	1.03e-12	NR	MBN2449418.1	2053569	g182075	i0	53	0.733333333333333	66	31	73.3	0	23	220	647	712	MBN2449418.1 laminin G domain-containing protein [Lentisphaeria bacterium]	diamond	198	73.2	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
32979823	32979823	PRJEB20058_P_NODE_31091_length_752_cov_16.131693_g28600_i0	PRJEB20058	31091	752	16.131693	121.31033136	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	154	2.9699999999999993e-43	NR	MCE9612928.1	1932692	g28600	i0	66.7	0.430851063829787	108	36	43.1	0	346	23	1	108	MCE9612928.1 thermonuclease family protein [Lentisphaerota bacterium]	diamond	324	154	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
33008446	33008446	PRJEB20058_P_NODE_85979_length_444_cov_20.553525_g83190_i0	PRJEB20058	85979	444	20.553525	91.257651	Bacteria	2	Bacteria	Bacteria	174	1.16e-52	NR	WP_307259977.1	760260	g83190	i0	71.2	6.78378378378378	125	36	84.5	0	39	413	1	125	WP_307259977.1 rubrerythrin [Oligosphaera ethanolica]	diamond	3012	174	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Oligosphaeria	Oligosphaerales	Oligosphaeraceae	Oligosphaera	Oligosphaera ethanolica
33093833	33093833	PRJEB20058_P_NODE_69678_length_499_cov_9.118721_g66907_i0	PRJEB20058	69678	499	9.118721	45.50241779	Bacteria	2	Bacteria	Bacteria	140	3.72e-38	NR	NLN03061.1	1932692	g66907	i0	66	3.85971943887776	106	36	63.7	0	26	343	45	150	NLN03061.1 hypothetical protein [Lentisphaerota bacterium]	diamond	1926	140	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
33098872	33098872	PRJEB20058_P_NODE_212142_length_248_cov_0.951872_g209318_i0	PRJEB20058	212142	248	0.951872	2.36064256	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	124	3.3799999999999995e-31	NR	MDY0176708.1	2053569	g209318	i0	70.4	0.979838709677419	81	24	98	0	248	6	325	405	MDY0176708.1 phage terminase large subunit [Lentisphaeria bacterium]	diamond	243	124	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
33110670	33110670	PRJEB20058_P_NODE_179062_length_277_cov_2.018519_g176239_i0	PRJEB20058	179062	277	2.018519	5.59129763	Bacteria	2	Bacteria	Bacteria	116	4.26e-28	NR	MFH0878443.1	1932692	g176239	i0	66.3	7.71119133574007	89	30	96.4	0	276	10	26	114	MFH0878443.1 IS21 family transposase [Lentisphaerota bacterium]	diamond	2136	116	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
33115244	33115244	PRJEB20058_P_NODE_102167_length_402_cov_4.395894_g99360_i0	PRJEB20058	102167	402	4.395894	17.67149388	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	87	4.07e-17	NR	MEI6420604.1	1932692	g99360	i0	42.5	4.02238805970149	134	65	95.5	7	2	385	195	322	MEI6420604.1 hypothetical protein [Lentisphaerota bacterium]	diamond	1617	87	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);;