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

4 rows where analysis = "diamond", bioproject = "PRJNA814235" 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
27284380	27284380	PRJNA814235_P_NODE_88883_length_203_cov_3.734940_g87488_i0	PRJNA814235	88883	203	3.73494	7.5819282	root	1	Root_unresolved	Root_unresolved	47.4	5.16e-4	NR	CAG8742107.1	4874	g87488	i0	96	10.7142857142857	25	1	36.9	0	2	76	169	193	CAG8742107.1 38364_t:CDS:2 [Gigaspora margarita]	diamond	2175	47.4	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Gigaspora	Gigaspora margarita
28065070	28065070	PRJNA814235_P_NODE_119585_length_203_cov_1.759036_g118190_i0	PRJNA814235	119585	203	1.759036	3.57084308	Entomortierella parvispora	205924	Fungi	Fungi	44.7	0.00471	NR	GJJ75502.1	205924	g118190	i0	37.3	0.990147783251232	67	36	99	1	203	3	905	965	GJJ75502.1 hypothetical protein EMPS_07860 [Entomortierella parvispora]	diamond	201	44.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Entomortierella	Entomortierella parvispora
30852959	30852959	PRJNA814235_P_NODE_179214_length_153_cov_2.017241_g177819_i0	PRJNA814235	179214	153	2.017241	3.08637873	root	1	Root_unresolved	Root_unresolved	62	1.68e-9	NR	KAI8062524.1	101105	g177819	i0	64.6	3.76470588235294	48	17	94.1	0	3	146	51	98	KAI8062524.1 hypothetical protein BC940DRAFT_308462 [Gongronella butleri]	diamond	576	62	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Gongronella	Gongronella butleri
32772507	32772507	PRJNA814235_P_NODE_192440_length_151_cov_2.798246_g191045_i0	PRJNA814235	192440	151	2.798246	4.22535146	Dentiscutata heterogama	1316150	Fungi	Fungi	40.8	0.00523	NR	CAG8655636.1	1316150	g191045	i0	33.3	0.834437086092715	42	28	83.4	0	138	13	3	44	CAG8655636.1 13679_t:CDS:1, partial [Dentiscutata heterogama]	diamond	126	40.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Gigasporaceae	Dentiscutata	Dentiscutata heterogama

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