metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA792582" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA792582" and tax_phylum = "Mucoromycota"

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
25003615	25003615	PRJNA792582_P_NODE_54500_length_246_cov_0.890173_g53686_i0	PRJNA792582	54500	246	0.890173	2.18982558	Mucoromycota	1913637	Fungi	Fungi	122	3.4499999999999996e-30	NR	KAI9306379.1	76405	g53686	i0	73.4	7.70731707317073	79	21	96.3	0	238	2	112	190	KAI9306379.1 fimbrin [Cunninghamella echinulata]	diamond	1896	122	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Cunninghamella	Cunninghamella echinulata
27116766	27116766	PRJNA792582_P_NODE_9842_length_540_cov_2.526767_g9039_i0	PRJNA792582	9842	540	2.526767	13.6445418	Lichtheimia ornata	688661	Fungi	Fungi	47.4	0.0151	NR	XP_058342474.1	688661	g9039	i0	26.7	0.561111111111111	101	67	56.1	2	1	303	232	325	XP_058342474.1 uncharacterized protein O0I10_006625 [Lichtheimia ornata]	diamond	303	47.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Lichtheimia	Lichtheimia ornata
27780445	27780445	PRJNA792582_P_NODE_22144_length_366_cov_1.542662_g21330_i0	PRJNA792582	22144	366	1.542662	5.64614292	Gigaspora margarita	4874	Fungi	Fungi	66.6	4.81e-10	NR	CAG8828982.1	4874	g21330	i0	37.1	1.59016393442623	97	61	79.5	0	298	8	229	325	CAG8828982.1 42215_t:CDS:2, partial [Gigaspora margarita]	diamond	582	66.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Gigaspora	Gigaspora margarita
31548562	31548562	PRJNA792582_P_NODE_50876_length_250_cov_0.870056_g50062_i0	PRJNA792582	50876	250	0.870056	2.17514	Opisthokonta	33154	Fungi	Fungi	50.8	2.96e-5	NR	CAG8721565.1	144679	g50062	i0	70.4	5.256	27	8	32.4	0	93	13	155	181	CAG8721565.1 8956_t:CDS:1, partial [Ambispora leptoticha]	diamond	1314	50.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Archaeosporales	Ambisporaceae	Ambispora	Ambispora leptoticha
32456778	32456778	PRJNA792582_P_NODE_48999_length_252_cov_2.821229_g48185_i0	PRJNA792582	48999	252	2.821229	7.10949708	Bifiguratus adelaidae	1938954	Fungi	Fungi	78.6	9.82e-15	NR	OZJ05620.1	1938954	g48185	i0	47.3	0.880952380952381	74	39	88.1	0	3	224	448	521	OZJ05620.1 hypothetical protein BZG36_01505 [Bifiguratus adelaidae]	diamond	222	78.6	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Endogonomycetes	Endogonales		Bifiguratus	Bifiguratus adelaidae

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