metadata: contig_metadata: 5 rows where bioproject = "PRJNA1122875", tax_clade = "FCB group" and tax

5 rows where bioproject = "PRJNA1122875", 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
15580375	15580375	PRJNA1122875_P_NODE_22373_length_351_cov_0.935252_g22149_i0	PRJNA1122875	22373	351	0.935252	3.28273452	Balneolaceae bacterium	2053516	Bacteria	Bacteria	160	6.91e-45	NR	MEX0719798.1	2053516	g22149	i0	64.7	4.95726495726496	116	41	99.1	0	2	349	260	375	MEX0719798.1 fumarylacetoacetase [Balneolaceae bacterium]	diamond	1740	160	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
27859709	27859709	PRJNA1122875_P_NODE_50245_length_244_cov_1.350877_g50021_i0	PRJNA1122875	50245	244	1.350877	3.29613988	Halalkalibaculum roseum	2709311	Bacteria	Bacteria	90.1	8.07e-19	NR	WP_165142256.1	2709311	g50021	i0	52.4	6.07377049180328	82	37	98.4	1	4	243	643	724	WP_165142256.1 S9 family peptidase [Halalkalibaculum roseum]	diamond	1482	90.1	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Halalkalibaculum	Halalkalibaculum roseum
30607136	30607136	PRJNA1122875_P_NODE_19413_length_378_cov_2.390164_g19189_i0	PRJNA1122875	19413	378	2.390164	9.03481992	unclassified Halalkalibaculum	2964617	Bacteria	Bacteria	96.3	1.74e-22	NR	WP_395260988.1	2964617	g19189	i0	36.1	2.93650793650794	122	76	95.2	1	365	6	26	147	WP_395260988.1 CBS domain-containing protein [Halalkalibaculum sp. DA3122]	diamond	1110	96.3	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Halalkalibaculum
31333978	31333978	PRJNA1122875_P_NODE_41536_length_256_cov_1.683060_g41312_i0	PRJNA1122875	41536	256	1.68306	4.3086336	Balneolaceae bacterium	2053516	Bacteria	Bacteria	64.7	2.18e-10	NR	MCC5907222.1	2053516	g41312	i0	41.2	2.98828125	85	23	99.6	2	255	1	100	157	MCC5907222.1 superoxide dismutase [Balneolaceae bacterium]	diamond	765	64.7	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
32145831	32145831	PRJNA1122875_P_NODE_7198_length_600_cov_4.981025_g6981_i0	PRJNA1122875	7198	600	4.981025	29.88615	Rhodohalobacter	1974209	Bacteria	Bacteria	94.4	1.05e-20	NR	WP_101071284.1	2053187	g6981	i0	39.6	3.555	101	61	50.5	0	305	3	45	145	WP_101071284.1 Hsp20/alpha crystallin family protein [Rhodohalobacter barkolensis]	diamond	2133	94.7	0.996832101372756	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Rhodohalobacter	Rhodohalobacter barkolensis

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