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

5 rows where analysis = "diamond", bioproject = "PRJNA680334" 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
28672871	28672871	PRJNA680334_S_NODE_54447_length_187_cov_1.376623_g53961_i0	PRJNA680334	54447	187	1.376623	2.57428501	Mucorales	4827	Fungi	Fungi	60.5	1.27e-9	NR	RCH79727.1	4846	g53961	i0	75	13.8609625668449	32	8	51.3	0	3	98	79	110	RCH79727.1 hypothetical protein CU098_002778, partial [Rhizopus stolonifer]	diamond	2592	60.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Rhizopodaceae	Rhizopus	Rhizopus stolonifer
29418622	29418622	PRJNA680334_S_NODE_78949_length_166_cov_1.383459_g78463_i0	PRJNA680334	78949	166	1.383459	2.29654194	Diversispora eburnea	1213867	Fungi	Fungi	55.8	3.12e-7	NR	CAG8515909.1	1213867	g78463	i0	56.3	1.73493975903614	48	18	84.9	2	7	147	184	229	CAG8515909.1 2445_t:CDS:2 [Diversispora eburnea]	diamond	288	55.8	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Glomeromycetes	Diversisporales	Diversisporaceae	Diversispora	Diversispora eburnea
32010226	32010226	PRJNA680334_S_NODE_85898_length_161_cov_3.468750_g85412_i0	PRJNA680334	85898	161	3.46875	5.5846875	Absidia glauca	4829	Fungi	Fungi	43.1	0.00906	NR	SAM06209.1	4829	g85412	i0	57.1	0.652173913043478	35	13	61.5	1	61	159	72	106	SAM06209.1 hypothetical protein [Absidia glauca]	diamond	105	43.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Absidia	Absidia glauca
32073510	32073510	PRJNA680334_S_NODE_13878_length_284_cov_5.362550_g13392_i0	PRJNA680334	13878	284	5.36255	15.229642	Halteromyces radiatus	101107	Fungi	Fungi	59.7	1.71e-8	NR	XP_051397544.1	101107	g13392	i0	62.2	1.94366197183099	45	17	47.5	0	280	146	112	156	XP_051397544.1 TB2/DP1, HVA22 family-domain-containing protein [Halteromyces radiatus]	diamond	552	59.7	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Cunninghamellaceae	Halteromyces	Halteromyces radiatus
32085208	32085208	PRJNA680334_S_NODE_84258_length_162_cov_3.542636_g83772_i0	PRJNA680334	84258	162	3.542636	5.73907032	Mucorales	4827	Fungi	Fungi	57	1.17e-7	NR	KAI9311233.1	101130	g83772	i0	79.4	3.77777777777778	34	7	63	0	162	61	436	469	KAI9311233.1 citrate synthase [Dichotomocladium elegans]	diamond	612	57	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Lichtheimiaceae	Dichotomocladium	Dichotomocladium elegans

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