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

6 rows where bioproject = "PRJNA379145", 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
6778622	6778622	PRJNA379145_P_NODE_4006_length_1466_cov_4.348918_g3495_i0	PRJNA379145	4006	1466	4.348918	63.75513788	root	1	Root_unresolved	Root_unresolved	427	1.21e-142	NR	KMQ51567.1	1008392	g3495	i0	50.3	37.6268758526603	447	205	88.4	7	1334	39	15	459	KMQ51567.1 Asparaginyl-tRNA synthetase [Chitinispirillum alkaliphilum]	diamond	55161	427	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinispirillia	Chitinispirillales	Chitinispirillaceae	Chitinispirillum	Chitinispirillum alkaliphilum
28559463	28559463	PRJNA379145_P_NODE_62127_length_181_cov_2.662162_g59973_i0	PRJNA379145	62127	181	2.662162	4.81851322	Fibrobacter sp.	35828	Bacteria	Bacteria	54.7	9.89e-7	NR	NLP04084.1	35828	g59973	i0	55.1	1.6243093922651901	49	21	81.2	1	154	8	172	219	NLP04084.1 leucyl aminopeptidase [Fibrobacter sp.]	diamond	294	54.7	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
29096209	29096209	PRJNA379145_P_NODE_9328_length_990_cov_22.252874_g8238_i0	PRJNA379145	9328	990	22.252874	220.30345260000001	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	244	4.77e-76	NR	MDB5103601.1	2052160	g8238	i0	52.7	5.60909090909091	207	98	62.7	0	649	29	69	275	MDB5103601.1 hydrolase, TatD family protein [Fibrobacterota bacterium]	diamond	5553	244	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
30706814	30706814	PRJNA379145_P_NODE_53574_length_215_cov_1.708791_g51420_i0	PRJNA379145	53574	215	1.708791	3.67390065	Fibrobacter sp.	35828	Bacteria	Bacteria	42.4	0.0342	NR	MCQ2060575.1	35828	g51420	i0	34	0.73953488372093	53	35	74	0	212	54	231	283	MCQ2060575.1 YfiM family protein [Fibrobacter sp.]	diamond	159	42.4	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
30959713	30959713	PRJNA379145_P_NODE_4714_length_1369_cov_3.875000_g4131_i0	PRJNA379145	4714	1369	3.875	53.04875	Chitinivibrionales bacterium	2663014	Bacteria	Bacteria	77.8	2.16e-11	NR	MBD3393622.1	2663014	g4131	i0	26.2	0.661796932067202	302	176	62.2	12	279	1130	54	326	MBD3393622.1 hypothetical protein [Chitinivibrionales bacterium]	diamond	906	77.8	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinivibrionia	Chitinivibrionales			Chitinivibrionales bacterium
32256632	32256632	PRJNA379145_P_NODE_11218_length_890_cov_17.959160_g9941_i0	PRJNA379145	11218	890	17.95916	159.836524	Chitinispirillaceae bacterium	2813024	Bacteria	Bacteria	64.3	2.04e-7	NR	MCX7726651.1	2813024	g9941	i0	33.3	1.04494382022472	87	57	29	1	566	823	371	457	MCX7726651.1 RICIN domain-containing protein [Chitinispirillaceae bacterium]	diamond	930	64.3	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinispirillia	Chitinispirillales	Chitinispirillaceae		Chitinispirillaceae 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);;