metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJNA633835" and tax

4 rows where analysis = "diamond", bioproject = "PRJNA633835" 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
5707442	5707442	PRJNA633835_S_NODE_5825_length_295_cov_2.819820_g5757_i0	PRJNA633835	5825	295	2.81982	8.318469	Adhaeribacter swui	2086471	Bacteria	Bacteria	150	3.3499999999999995e-43	NR	WP_185270738.1	2086471	g5757	i0	88.9	0.915254237288136	90	10	91.5	0	270	1	135	224	WP_185270738.1 ferritin-like domain-containing protein [Adhaeribacter swui]	diamond	270	150	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Hymenobacteraceae	Adhaeribacter	Adhaeribacter swui
26637683	26637683	PRJNA633835_S_NODE_2261_length_399_cov_1.131902_g2193_i0	PRJNA633835	2261	399	1.131902	4.51628898	Myroides odoratimimus	76832	Bacteria	Bacteria	171	5.219999999999999e-52	NR	WP_286468238.1	76832	g2193	i0	94.4	0.676691729323308	90	5	67.7	0	49	318	1	90	WP_286468238.1 hypothetical protein, partial [Myroides odoratimimus]	diamond	270	171	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Myroides	Myroides odoratimimus
27870482	27870482	PRJNA633835_S_NODE_7785_length_270_cov_1.020305_g7717_i0	PRJNA633835	7785	270	1.020305	2.7548235	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	42	0.0334	NR	MCH8287537.1	2026760	g7717	i0	27.9	0.677777777777778	61	41	67.8	1	50	232	25	82	MCH8287537.1 hypothetical protein [Fidelibacterota bacterium]	diamond	183	42	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota					Fidelibacterota bacterium
29575370	29575370	PRJNA633835_S_NODE_11890_length_242_cov_0.911243_g11822_i0	PRJNA633835	11890	242	0.911243	2.20520806	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	43.5	0.0202	NR	MCY3761874.1	2026742	g11822	i0	36.5	0.644628099173554	52	29	64.5	1	199	44	594	641	MCY3761874.1 C25 family cysteine peptidase [Gemmatimonadota bacterium]	diamond	156	43.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota 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);;