metadata: contig_metadata: 4 rows where bioproject = "PRJNA594101" and tax

4 rows where bioproject = "PRJNA594101" 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
27837690	27837690	PRJNA594101_S_NODE_33164_length_299_cov_1.491150_g32862_i0	PRJNA594101	33164	299	1.49115	4.4585385	Fibrobacterota bacterium	2052160	Bacteria	Bacteria	162	3.1e-45	NR	MBK8804310.1	2052160	g32862	i0	71.4	10.7959866220736	98	28	98.3	0	295	2	356	453	MBK8804310.1 glycoside hydrolase family 130 protein [Fibrobacterota bacterium]	diamond	3228	162	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota					Fibrobacterota bacterium
28103705	28103705	PRJNA594101_S_NODE_55425_length_243_cov_1.358824_g55123_i0	PRJNA594101	55425	243	1.358824	3.30194232	Bacteria	2	Bacteria	Bacteria	61.6	8.16e-9	NR	WP_295072328.1	261512	g55123	i0	38	7.16049382716049	79	41	97.5	1	2	238	248	318	WP_295072328.1 DUF4419 domain-containing protein [uncultured Fibrobacter sp.]	diamond	1740	61.6	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Fibrobacterales	Fibrobacteraceae	Fibrobacter	uncultured Fibrobacter sp.
31388915	31388915	PRJNA594101_S_NODE_35936_length_289_cov_1.069444_g35634_i0	PRJNA594101	35936	289	1.069444	3.09069316	Pseudomonadati	3379134	Bacteria	Bacteria	43.5	0.0361	NR	MBD3422077.1	2663014	g35634	i0	33.3	2.35640138408304	87	47	83	4	16	255	258	340	MBD3422077.1 VWA domain-containing protein [Chitinivibrionales bacterium]	diamond	681	43.5	1	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Chitinivibrionia	Chitinivibrionales			Chitinivibrionales bacterium
32261390	32261390	PRJNA594101_S_NODE_18978_length_383_cov_5.067742_g18676_i0	PRJNA594101	18978	383	5.067742	19.40945186	Chitinispirillaceae bacterium	2813024	Bacteria	Bacteria	45.4	0.0177	NR	MFP4415963.1	2813024	g18676	i0	31.8	0.689295039164491	88	53	63.4	2	340	98	277	364	MFP4415963.1 aminopeptidase [Chitinispirillaceae bacterium]	diamond	264	45.4	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);;