metadata: contig_metadata: 4 rows where bioproject = "PRJNA520845", tax_clade = "PVC group" and tax

4 rows where bioproject = "PRJNA520845", tax_clade = "PVC group" and tax_phylum = "Candidatus Omnitrophota"

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_genus	tax_species
19617030	19617030	PRJNA520845_P_NODE_241896_length_246_cov_0.890173_g240397_i0	PRJNA520845	241896	246	0.890173	2.18982558	Candidatus Omnitrophica bacterium CG11_big_fil_rev_8_21_14_	2035772	Bacteria	Bacteria	85.9	1.69e-18	NR	PIQ85924.1	1974748	g240397	i0	72.2	1.97560975609756	54	15	65.9	0	162	1	1	54	PIQ85924.1 MAG: peroxiredoxin [Candidatus Omnitrophica bacterium CG11_big_fil_rev_8_21_14_0_20_45_26]	diamond	486	85.9	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Abzuiibacterium	Candidatus Abzuiibacterium crystallinum
26776284	26776284	PRJNA520845_P_NODE_28701_length_714_cov_1.861154_g27286_i0	PRJNA520845	28701	714	1.861154	13.28863956	Bacteria	2	Bacteria	Bacteria	47.8	0.0173	NR	MDO8580234.1	2035772	g27286	i0	33.1	1.6218487394958	127	72	48.7	4	174	521	67	191	MDO8580234.1 30S ribosomal protein S2 [Candidatus Omnitrophota bacterium]	diamond	1158	47.8	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota		Candidatus Omnitrophota bacterium
28940706	28940706	PRJNA520845_P_NODE_261988_length_242_cov_0.911243_g260489_i0	PRJNA520845	261988	242	0.911243	2.20520806	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	88.6	2.69e-18	NR	MBF0569577.1	2035772	g260489	i0	65.6	2.25619834710744	61	21	75.6	0	242	60	632	692	MBF0569577.1 phosphoenolpyruvate carboxykinase (ATP) [Candidatus Omnitrophota bacterium]	diamond	546	88.6	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota		Candidatus Omnitrophota bacterium
29571796	29571796	PRJNA520845_P_NODE_187890_length_271_cov_1.944444_g186391_i0	PRJNA520845	187890	271	1.944444	5.26944324	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	94.7	2.79e-20	NR	MFC1703536.1	2035772	g186391	i0	49.5	1.00738007380074	91	44	98.5	1	3	269	878	968	MFC1703536.1 proline dehydrogenase family protein [Candidatus Omnitrophota bacterium]	diamond	273	94.7	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota		Candidatus Omnitrophota 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);;