metadata: contig_metadata: 5 rows where bioproject = "PRJNA911178", tax_clade = "PVC group" and tax

5 rows where bioproject = "PRJNA911178", 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
22569401	22569401	PRJNA911178_P_NODE_227518_length_257_cov_1.625000_g225044_i0	PRJNA911178	227518	257	1.625	4.17625	uncultured Lentisphaera sp.	402590	Bacteria	Bacteria	370	5.68e-98	NTclustered	gi\|451919142\|gb\|KC453006.1\|	402590	g225044	i0	94.606	92.1945525291829	241	9	93	4	19	257	1	239	Uncultured Lentisphaera sp. clone RLBp4508 16S ribosomal RNA gene, partial sequence	blastn	23694	370	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaerales	Lentisphaeraceae	Lentisphaera	uncultured Lentisphaera sp.
26651732	26651732	PRJNA911178_P_NODE_70881_length_419_cov_1.268786_g68419_i0	PRJNA911178	70881	419	1.268786	5.31621334	Bacteria	2	Bacteria	Bacteria	134	2.7899999999999993e-34	NR	MCE9614942.1	1932692	g68419	i0	47.8	6.81622911694511	136	61	97.4	3	412	5	104	229	MCE9614942.1 beta-glucosidase [Lentisphaerota bacterium]	diamond	2856	134	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
27309152	27309152	PRJNA911178_P_NODE_280663_length_243_cov_1.382353_g278189_i0	PRJNA911178	280663	243	1.382353	3.35911779	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	44.7	0.00713	NR	MBM4155799.1	1932692	g278189	i0	41.3	0.567901234567901	46	27	56.8	0	205	68	237	282	MBM4155799.1 5'-3' exonuclease [Lentisphaerota bacterium]	diamond	138	44.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerota bacterium
28263471	28263471	PRJNA911178_P_NODE_279546_length_243_cov_2.170588_g277072_i0	PRJNA911178	279546	243	2.170588	5.27452884	Bacteria	2	Bacteria	Bacteria	87.4	6.76e-18	NR	OGV34072.1	1798572	g277072	i0	51.3	19.9012345679012	78	36	93.8	1	229	2	505	582	OGV34072.1 MAG: phosphoenolpyruvate carboxykinase [Lentisphaerae bacterium GWF2_45_14]	diamond	4836	87.4	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium GWF2_45_14
32023382	32023382	PRJNA911178_P_NODE_18078_length_789_cov_2.289106_g15990_i0	PRJNA911178	18078	789	2.289106	18.06104634	PVC group	1783257	Bacteria	Bacteria	111	3.05e-25	NR	MBN1865604.1	2212475	g15990	i0	33	2.16730038022814	227	131	84.4	5	73	738	31	241	MBN1865604.1 methyltransferase domain-containing protein [Victivallales bacterium]	diamond	1710	111	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales			Victivallales 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);;