metadata: contig_metadata: 4 rows where bioproject = "PRJNA681822", tax_clade = "FCB group" and tax

4 rows where bioproject = "PRJNA681822", tax_clade = "FCB group" and tax_phylum = "Balneolota"

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
27018760	27018760	PRJNA681822_P_NODE_471502_length_242_cov_0.911243_g470012_i0	PRJNA681822	471502	242	0.911243	2.20520806	Halalkalibaculum roseum	2709311	Bacteria	Bacteria	48.9	2.18e-4	NR	WP_165139748.1	2709311	g470012	i0	34.7	0.892561983471074	72	47	89.3	0	27	242	183	254	WP_165139748.1 alpha/beta fold hydrolase [Halalkalibaculum roseum]	diamond	216	48.9	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Halalkalibaculum	Halalkalibaculum roseum
27599471	27599471	PRJNA681822_P_NODE_345944_length_261_cov_3.579787_g344455_i0	PRJNA681822	345944	261	3.579787	9.34324407	Bacteria	2	Bacteria	Bacteria	85.5	4.02e-17	NR	MTI86996.1	2053516	g344455	i0	60.3	1.63218390804598	68	27	78.2	0	261	58	427	494	MTI86996.1 insulinase family protein [Balneolaceae bacterium]	diamond	426	85.5	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
31061735	31061735	PRJNA681822_P_NODE_351455_length_260_cov_1.497326_g349966_i0	PRJNA681822	351455	260	1.497326	3.8930476	Rhodohalobacter sp. 8-1	3131972	Bacteria	Bacteria	99	6.29e-22	NR	WP_340106210.1	3131972	g349966	i0	54.2	1.91538461538462	83	38	95.8	0	10	258	247	329	WP_340106210.1 pitrilysin family protein [Rhodohalobacter sp. 8-1]	diamond	498	99	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Rhodohalobacter	Rhodohalobacter sp. 8-1
31831966	31831966	PRJNA681822_P_NODE_209777_length_302_cov_2.362445_g208289_i0	PRJNA681822	209777	302	2.362445	7.1345839	Balneola	455358	Bacteria	Bacteria	45.8	0.00596	NR	WP_066223528.1	1849360	g208289	i0	34.4	1.8476821192053	93	57	88.4	2	17	283	55	147	WP_066223528.1 sensor histidine kinase [Balneola sp. EhC07]	diamond	558	45.8	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneola	Balneola sp. EhC07

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);;