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

5 rows where analysis = "diamond", bioproject = "PRJNA399133" 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
29365854	29365854	PRJNA399133_P_NODE_5069_length_229_cov_1.953608_g4981_i0	PRJNA399133	5069	229	1.953608	4.47376232	Malassezia	55193	Fungi	Fungi	47.4	7.32e-4	NR	WFD04011.1	76774	g4981	i0	38.7	1.95196506550218	75	37	98.3	1	228	4	402	467	WFD04011.1 hypothetical protein MOBT1_002708 [Malassezia obtusa]	diamond	447	47.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia obtusa
30123563	30123563	PRJNA399133_P_NODE_8432_length_180_cov_3.124138_g8344_i0	PRJNA399133	8432	180	3.124138	5.6234484	Malassezia	55193	Fungi	Fungi	42.4	0.00638	NR	XP_027484461.1	76775	g8344	i0	95.8	0.8	24	1	40	0	179	108	7	30	XP_027484461.1 uncharacterized protein MRET_1845 [Malassezia restricta]	diamond	144	42.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
30297060	30297060	PRJNA399133_P_NODE_5292_length_229_cov_1.711340_g5204_i0	PRJNA399133	5292	229	1.71134	3.9189686	Malassezia cuniculi	948313	Fungi	Fungi	49.7	1.1e-4	NR	WFD34210.1	948313	g5204	i0	91.7	0.314410480349345	24	2	31.4	0	157	228	371	394	WFD34210.1 dihydrolipoyllysine-residue succinyltransferase [Malassezia cuniculi]	diamond	72	49.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia cuniculi
30802035	30802035	PRJNA399133_P_NODE_8514_length_180_cov_1.103448_g8426_i0	PRJNA399133	8514	180	1.103448	1.9862064	Naganishia liquefaciens	104408	Fungi	Fungi	62.4	1.83e-9	NR	GHJ89788.1	104408	g8426	i0	100	0.55	33	0	55	0	178	80	583	615	GHJ89788.1 hypothetical protein NliqN6_6190 [Naganishia liquefaciens]	diamond	99	62.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Naganishia	Naganishia liquefaciens
32573403	32573403	PRJNA399133_P_NODE_5159_length_229_cov_1.850515_g5071_i0	PRJNA399133	5159	229	1.850515	4.23767935	Malassezia restricta CBS 7877	425264	Fungi	Fungi	51.6	2.31e-5	NR	AYO44189.1	425264	g5071	i0	88	0.327510917030568	25	3	32.8	0	228	154	313	337	AYO44189.1 25S rRNA (adenine(645)-N(1))-methyltransferase [Malassezia restricta CBS 7877]	diamond	75	51.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta

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