metadata: contig_metadata: 6 rows where bioproject = "PRJNA666695", tax_clade = "FCB group" and tax

6 rows where bioproject = "PRJNA666695", 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
26732988	26732988	PRJNA666695_S_NODE_55721_length_281_cov_3.670833_g54627_i0	PRJNA666695	55721	281	3.670833	10.31504073	Balneola sp.	2024824	Bacteria	Bacteria	116	2.97e-29	NR	MEP2448683.1	2024824	g54627	i0	58.7	3.93950177935943	92	36	96.1	1	2	271	63	154	MEP2448683.1 nucleotidyltransferase [Balneola sp.]	diamond	1107	116	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Balneola	Balneola sp.
26840745	26840745	PRJNA666695_S_NODE_88341_length_232_cov_3.528796_g87247_i0	PRJNA666695	88341	232	3.528796	8.18680672	Bacteria	2	Bacteria	Bacteria	94.4	1.47e-20	NR	MEQ9263701.1	2053516	g87247	i0	70.6	12.3620689655172	68	20	87.9	0	25	228	312	379	MEQ9263701.1 acetyl-CoA C-acyltransferase [Balneolaceae bacterium]	diamond	2868	94.4	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
27207775	27207775	PRJNA666695_S_NODE_86922_length_234_cov_2.383420_g85828_i0	PRJNA666695	86922	234	2.38342	5.5772028	Balneolaceae bacterium	2053516	Bacteria	Bacteria	42.4	0.0274	NR	MDX1586628.1	2053516	g85828	i0	35.1	0.730769230769231	57	37	73.1	0	8	178	31	87	MDX1586628.1 DUF892 family protein [Balneolaceae bacterium]	diamond	171	42.4	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
27302885	27302885	PRJNA666695_S_NODE_107183_length_212_cov_3.228070_g106089_i0	PRJNA666695	107183	212	3.22807	6.8435084	Balneolaceae bacterium	2053516	Bacteria	Bacteria	46.2	0.00149	NR	MEX1010641.1	2053516	g106089	i0	38.7	4.06132075471698	62	35	87.7	1	210	25	586	644	MEX1010641.1 DUF885 domain-containing protein [Balneolaceae bacterium]	diamond	861	46.2	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae		Balneolaceae bacterium
30618607	30618607	PRJNA666695_S_NODE_63613_length_267_cov_1.831858_g62519_i0	PRJNA666695	63613	267	1.831858	4.89106086	Balneolales bacterium	2497613	Bacteria	Bacteria	66.2	2.41e-10	NR	MCH8567190.1	2497613	g62519	i0	58.8	0.573033707865168	51	21	57.3	0	265	113	178	228	MCH8567190.1 isoaspartyl peptidase/L-asparaginase [Balneolales bacterium]	diamond	153	66.2	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales			Balneolales bacterium
31472213	31472213	PRJNA666695_S_NODE_50876_length_291_cov_6.200000_g49782_i0	PRJNA666695	50876	291	6.2	18.042	Halalkalibaculum sp. DA384	3373606	Bacteria	Bacteria	81.6	1.44e-15	NR	WP_395275366.1	3373606	g49782	i0	49.4	1.88659793814433	89	38	91.8	2	291	25	639	720	WP_395275366.1 S9 family peptidase [Halalkalibaculum sp. DA384]	diamond	549	81.6	1	Bacteria	FCB group	Pseudomonadati	Balneolota	Balneolia	Balneolales	Balneolaceae	Halalkalibaculum	Halalkalibaculum sp. DA384

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