metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA922890" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA922890" 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
898492	898492	PRJNA922890_P_NODE_68641_length_235_cov_1.614458_g68231_i0	PRJNA922890	68641	235	1.614458	3.7939763	Elizabethkingia	308865	Bacteria	Bacteria	155	9.16e-42	NR	WP_059154363.1	172045	g68231	i0	100	1.99148936170213	78	0	99.6	0	1	234	632	709	WP_059154363.1 hypothetical protein [Elizabethkingia miricola]	diamond	468	155	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Weeksellaceae	Elizabethkingia	Elizabethkingia miricola
27782989	27782989	PRJNA922890_P_NODE_72764_length_233_cov_0.890244_g72354_i0	PRJNA922890	72764	233	0.890244	2.07426852	Flammeovirgaceae bacterium	2026740	Bacteria	Bacteria	84	8.53e-17	NR	MFM7854740.1	2026740	g72354	i0	51.5	0.875536480686695	68	33	87.6	0	27	230	130	197	MFM7854740.1 carbonic anhydrase family protein [Flammeovirgaceae bacterium]	diamond	204	84	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Flammeovirgaceae		Flammeovirgaceae bacterium
29235312	29235312	PRJNA922890_P_NODE_34729_length_326_cov_1.140078_g34319_i0	PRJNA922890	34729	326	1.140078	3.71665428	Spirosomataceae bacterium	2902720	Bacteria	Bacteria	44.7	0.0168	NR	MFN3782593.1	2902720	g34319	i0	47.9	0.441717791411043	48	21	41.4	2	59	193	57	103	MFN3782593.1 class I SAM-dependent methyltransferase [Spirosomataceae bacterium]	diamond	144	44.7	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Cytophagia	Cytophagales	Spirosomataceae		Spirosomataceae bacterium
29361576	29361576	PRJNA922890_P_NODE_51529_length_272_cov_1.172414_g51119_i0	PRJNA922890	51529	272	1.172414	3.18896608	Flavobacterium sp.	239	Bacteria	Bacteria	162	6.86e-44	NR	WP_291275852.1	239	g51119	i0	95.6	0.992647058823529	90	4	99.3	0	2	271	565	654	WP_291275852.1 beta strand repeat-containing protein, partial [Flavobacterium sp.]	diamond	270	162	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Flavobacteriia	Flavobacteriales	Flavobacteriaceae	Flavobacterium	Flavobacterium sp.
29519365	29519365	PRJNA922890_P_NODE_58190_length_256_cov_1.540107_g57780_i0	PRJNA922890	58190	256	1.540107	3.94267392	Chitinophagaceae bacterium	1869212	Bacteria	Bacteria	70.1	1.05e-11	NR	MCA6491979.1	1869212	g57780	i0	44.7	0.99609375	85	47	99.6	0	255	1	562	646	MCA6491979.1 ABC transporter permease [Chitinophagaceae bacterium]	diamond	255	70.1	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae		Chitinophagaceae bacterium
32047833	32047833	PRJNA922890_P_NODE_73378_length_233_cov_0.890244_g72968_i0	PRJNA922890	73378	233	0.890244	2.07426852	Niastella populi	550983	Bacteria	Bacteria	107	5.5700000000000006e-27	NR	WP_081164353.1	550983	g72968	i0	67.5	2.93562231759657	77	25	99.1	0	2	232	94	170	WP_081164353.1 TIGR04282 family arsenosugar biosynthesis glycosyltransferase [Niastella populi]	diamond	684	107	1	Bacteria	FCB group	Pseudomonadati	Bacteroidota	Chitinophagia	Chitinophagales	Chitinophagaceae	Niastella	Niastella populi

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