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

4 rows where analysis = "diamond", bioproject = "PRJNA306153" 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
20777885	20777885	PRJNA306153_S_NODE_137_length_532_cov_6.689861_g127_i0	PRJNA306153	137	532	6.689861	35.59006052	Flavobacteriia bacterium	2044941	Bacteria	Bacteria	210	3.0500000000000005e-64	NR	NBO60432.1	2044941	g127	i0	63.9	1.90601503759399	169	57	94.7	3	531	28	154	319	NBO60432.1 hypothetical protein [Flavobacteriia bacterium]	diamond	1014	210	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia				Flavobacteriia bacterium
26884559	26884559	PRJNA306153_S_NODE_141_length_524_cov_12.321212_g131_i0	PRJNA306153	141	524	12.321212	64.56315088	Phocaeicola vulgatus	821	Bacteria	Bacteria	125	1.19e-33	NR	WP_050229787.1	821	g131	i0	95.2	0.721374045801527	126	6	72.1	0	97	474	1	126	WP_050229787.1 hypothetical protein [Phocaeicola vulgatus]	diamond	378	125	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Bacteroidia	Bacteroidales	Bacteroidaceae	Phocaeicola	Phocaeicola vulgatus
27168830	27168830	PRJNA306153_S_NODE_1962_length_177_cov_4.000000_g1949_i0	PRJNA306153	1962	177	4	7.08	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	41.2	0.0488	NR	HET7425640.1	2448054	g1949	i0	56.3	0.542372881355932	32	12	54.2	1	70	165	166	195	HET7425640.1 hemolysin III family protein [Gemmatimonadales bacterium]	diamond	96	41.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
29997189	29997189	PRJNA306153_S_NODE_1671_length_190_cov_2.223602_g1658_i0	PRJNA306153	1671	190	2.223602	4.2248438	root	1	Root_unresolved	Root_unresolved	42.4	0.0259	NR	MCL2207105.1	2604144	g1658	i0	33.3	1.64210526315789	60	40	94.7	0	10	189	288	347	MCL2207105.1 methyl-accepting chemotaxis protein [Candidatus Fibrimonadales bacterium]	diamond	312	42.7	0.992974238875878	Bacteria	FCB group	Pseudomonadati	Fibrobacterota	Fibrobacteria	Candidatus Fibrimonadales			Candidatus Fibrimonadales 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);;