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

6 rows where bioproject = "PRJNA867519", tax_clade = "FCB group" and tax_phylum = "Fibrobacterota"

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
27758560	27758560	PRJNA867519_P_NODE_28964_length_247_cov_0.885057_g28810_i0	PRJNA867519	28964	247	0.885057	2.18609079	root	1	Root_unresolved	Root_unresolved	45.8	0.00291	NR	NLW33830.1	35828	g28810	i0	40.4	2.51417004048583	57	33	68	1	28	195	207	263	NLW33830.1 aldo/keto reductase [Fibrobacter sp.]	diamond	621	45.8	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
27876360	27876360	PRJNA867519_P_NODE_24365_length_256_cov_1.131148_g24211_i0	PRJNA867519	24365	256	1.131148	2.89573888	Candidatus Fibrimonadaceae bacterium	2872174	Bacteria	Bacteria	47	0.00148	NR	MDR3000665.1	2872174	g24211	i0	34.5	0.984375	84	51	98.4	1	2	253	2183	2262	MDR3000665.1 hypothetical protein [Candidatus Fibrimonadaceae bacterium]	diamond	252	47	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Candidatus Fibrimonadales	Candidatus Fibrimonadaceae		Candidatus Fibrimonadaceae bacterium
28665870	28665870	PRJNA867519_P_NODE_10607_length_350_cov_3.227437_g10453_i0	PRJNA867519	10607	350	3.227437	11.2960295	Chitinispirillaceae bacterium	2813024	Bacteria	Bacteria	45.4	0.013	NR	MFP4415963.1	2813024	g10453	i0	31.8	0.754285714285714	88	53	69.4	2	46	288	277	364	MFP4415963.1 aminopeptidase [Chitinispirillaceae bacterium]	diamond	264	45.4	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinispirillia	Chitinispirillales	Chitinispirillaceae		Chitinispirillaceae bacterium
29897290	29897290	PRJNA867519_P_NODE_15631_length_299_cov_1.022124_g15477_i0	PRJNA867519	15631	299	1.022124	3.05615076	Fibrobacteria bacterium	2725311	Bacteria	Bacteria	97.1	6.02e-21	NR	HXP90198.1	2725311	g15477	i0	73	2.63879598662207	63	17	63.2	0	299	111	583	645	HXP90198.1 acetate--CoA ligase [Fibrobacteria bacterium]	diamond	789	97.1	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria				Fibrobacteria bacterium
30181457	30181457	PRJNA867519_P_NODE_22772_length_263_cov_1.621053_g22618_i0	PRJNA867519	22772	263	1.621053	4.26336939	Chitinispirillales bacterium	2872172	Bacteria	Bacteria	44.7	0.0101	NR	MDR0304468.1	2872172	g22618	i0	41	2.25855513307985	61	34	68.4	2	1	180	455	514	MDR0304468.1 cellulase family glycosylhydrolase [Chitinispirillales bacterium]	diamond	594	44.7	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinispirillia	Chitinispirillales			Chitinispirillales bacterium
31319018	31319018	PRJNA867519_P_NODE_11395_length_341_cov_1.294776_g11241_i0	PRJNA867519	11395	341	1.294776	4.41518616	Chitinivibrionales bacterium	2663014	Bacteria	Bacteria	54.7	7.51e-6	NR	MBD3322456.1	2663014	g11241	i0	41.1	2.26099706744868	73	41	64.2	2	240	22	14	84	MBD3322456.1 hypothetical protein [Chitinivibrionales bacterium]	diamond	771	54.7	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinivibrionia	Chitinivibrionales			Chitinivibrionales 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);;