metadata: contig_metadata: 3 rows where bioproject = "PRJNA1010780" and tax

3 rows where bioproject = "PRJNA1010780" 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
2705312	2705312	PRJNA1010780_S_NODE_18703_length_432_cov_3.168766_g17425_i0	PRJNA1010780	18703	432	3.168766	13.68906912	Pseudomonadati	3379134	Bacteria	Bacteria	192	7.279999999999998e-55	NR	NLW31755.1	35828	g17425	i0	63.4	4.95833333333333	142	52	98.6	0	431	6	66	207	NLW31755.1 family 16 glycosylhydrolase [Fibrobacter sp.]	diamond	2142	192	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	Fibrobacter sp.
12908880	12908880	PRJNA1010780_S_NODE_4771_length_1244_cov_9.918941_g4294_i0	PRJNA1010780	4771	1244	9.918941	123.39162604	Chitinivibrionales bacterium	2663014	Bacteria	Bacteria	536	3.36e-187	NR	MBD3420666.1	2663014	g4294	i0	61.4	2.94694533762058	409	155	98.6	2	2	1228	31	436	MBD3420666.1 xylose isomerase [Chitinivibrionales bacterium]	diamond	3666	536	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinivibrionia	Chitinivibrionales			Chitinivibrionales bacterium
30382602	30382602	PRJNA1010780_S_NODE_4793_length_1241_cov_4.228856_g4315_i0	PRJNA1010780	4793	1241	4.228856	52.48010296	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	375	7.079999999999999e-118	NR	MDB5105120.1	2052160	g4315	i0	47.4	1.01047542304593	418	201	97.2	7	34	1239	419	833	MDB5105120.1 symbB [Fibrobacterota bacterium]	diamond	1254	375	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota 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);;