metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA473641" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA473641" and tax_clade = "FCB group"

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
4272133	4272133	PRJNA473641_P_NODE_25044_length_242_cov_0.911243_g24961_i0	PRJNA473641	25044	242	0.911243	2.20520806	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	162	4.9699999999999994e-48	NR	MCA6440232.1	1869212	g24961	i0	100	0.991735537190083	80	0	99.2	0	1	240	109	188	MCA6440232.1 MBL fold metallo-hydrolase [Chitinophagaceae bacterium]	diamond	240	162	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
27550022	27550022	PRJNA473641_P_NODE_21704_length_246_cov_0.890173_g21621_i0	PRJNA473641	21704	246	0.890173	2.18982558	Bacteroidota bacterium	1898104	Bacteria	Bacteria	40.8	0.0479	NR	MEE2920024.1	1898104	g21621	i0	37.5	0.682926829268293	56	33	68.3	1	39	206	6	59	MEE2920024.1 MbnP family protein [Bacteroidota bacterium]	diamond	168	40.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
27834190	27834190	PRJNA473641_P_NODE_19944_length_248_cov_0.880000_g19861_i0	PRJNA473641	19944	248	0.88	2.1824	Sphingobacteriales bacterium	2044944	Bacteria	Bacteria	162	5.71e-47	NR	MBN8851659.1	2044944	g19861	i0	98.8	0.991935483870968	82	1	99.2	0	1	246	226	307	MBN8851659.1 M56 family metallopeptidase [Sphingobacteriales bacterium]	diamond	246	162	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Sphingobacteriia	Sphingobacteriales			Sphingobacteriales bacterium
28023820	28023820	PRJNA473641_P_NODE_1945_length_596_cov_3.235182_g1863_i0	PRJNA473641	1945	596	3.235182	19.28168472	Bacteroidota bacterium	1898104	Bacteria	Bacteria	67.8	2.48e-9	NR	MEM1054794.1	1898104	g1863	i0	31	0.780201342281879	155	95	78	4	32	496	9	151	MEM1054794.1 lectin-like protein [Bacteroidota bacterium]	diamond	465	67.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota					Bacteroidota bacterium
28844471	28844471	PRJNA473641_P_NODE_23188_length_244_cov_0.900585_g23105_i0	PRJNA473641	23188	244	0.900585	2.1974274	FCB group bacterium	2599937	Bacteria	Bacteria	42.7	0.015	NR	MCP4569941.1	2599937	g23105	i0	38.2	0.676229508196721	55	30	62.7	1	2	154	6	60	MCP4569941.1 VOC family protein [FCB group bacterium]	diamond	165	42.7	1	Bacteria	FCB group	Pseudomonadati						FCB group bacterium
29254876	29254876	PRJNA473641_P_NODE_18269_length_250_cov_0.870056_g18186_i0	PRJNA473641	18269	250	0.870056	2.17514	Flavobacteriaceae bacterium	1871037	Bacteria	Bacteria	55.8	9.13e-7	NR	MDH3796532.1	1871037	g18186	i0	47.5	0.708	59	29	70.8	2	179	3	268	324	MDH3796532.1 hypothetical protein [Flavobacteriaceae bacterium]	diamond	177	55.8	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae		Flavobacteriaceae bacterium
29286578	29286578	PRJNA473641_P_NODE_15129_length_267_cov_0.804124_g15046_i0	PRJNA473641	15129	267	0.804124	2.14701108	Saprospiraceae bacterium	2202734	Bacteria	Bacteria	65.5	4.13e-10	NR	NNE15225.1	2202734	g15046	i0	46.5	2.56179775280899	71	36	79.8	1	47	259	15	83	NNE15225.1 catalase family protein [Saprospiraceae bacterium]	diamond	684	65.5	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Saprospiria	Saprospirales	Saprospiraceae		Saprospiraceae bacterium
29523915	29523915	PRJNA473641_P_NODE_8290_length_337_cov_1.166667_g8207_i0	PRJNA473641	8290	337	1.166667	3.93166779	Bacteria	2	Bacteria	Bacteria	77.4	7.25e-14	NR	WP_239864231.1	556529	g8207	i0	43.6	4.89614243323442	110	46	96.1	5	327	4	193	288	WP_239864231.1 family 43 glycosylhydrolase [Flavobacterium algicola]	diamond	1650	77.4	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium algicola

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