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

4 rows where analysis = "diamond", bioproject = "PRJNA981359" and tax_phylum = "Basidiomycota"

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
26773132	26773132	PRJNA981359_S_NODE_76941_length_223_cov_5.366667_g76841_i0	PRJNA981359	76941	223	5.366667	11.96766741	Pleurotus djamor	34470	Fungi	Fungi	42.7	0.0191	NR	KAJ8501405.1	34470	g76841	i0	43.3	1.5067264573991	60	31	80.7	1	181	2	24	80	KAJ8501405.1 hypothetical protein ONZ45_g12158 [Pleurotus djamor]	diamond	336	42.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pleurotaceae	Pleurotus	Pleurotus djamor
27601259	27601259	PRJNA981359_S_NODE_24284_length_345_cov_1.147059_g24184_i0	PRJNA981359	24284	345	1.147059	3.95735355	Basidiomycota	5204	Fungi	Fungi	149	6.57e-41	NR	CEQ40168.1	5005	g24184	i0	67.6	2.66086956521739	102	31	88.7	1	1	306	302	401	CEQ40168.1 SPOSA6832_01756, partial [Sporobolomyces salmonicolor]	diamond	918	149	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Sporobolomyces	Sporobolomyces salmonicolor
29142380	29142380	PRJNA981359_S_NODE_49149_length_282_cov_3.358852_g49049_i0	PRJNA981359	49149	282	3.358852	9.47196264	Malassezia restricta	76775	Fungi	Fungi	89.7	3.08e-21	NR	XP_027484810.1	76775	g49049	i0	66	1.07446808510638	47	16	50	0	22	162	33	79	XP_027484810.1 uncharacterized protein MRET_2819 [Malassezia restricta]	diamond	303	89.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
32901915	32901915	PRJNA981359_S_NODE_7280_length_453_cov_1.247368_g7181_i0	PRJNA981359	7280	453	1.247368	5.65057704	Thecaphora frezii	1269715	Fungi	Fungi	47	7.66e-4	NR	UOP57098.1	1269715	g7181	i0	47.7	0.291390728476821	44	23	29.1	0	301	170	31	74	UOP57098.1 hypothetical protein [Thecaphora frezii]	diamond	132	47	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Urocystidales	Glomosporiaceae	Thecaphora	Thecaphora frezii

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