metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJDB14275" and tax

6 rows where analysis = "diamond", bioproject = "PRJDB14275" 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
26652285	26652285	PRJDB14275_P_NODE_5641_length_201_cov_3.265432_g5582_i0	PRJDB14275	5641	201	3.265432	6.56351832	Malassezia arunalokei	1514897	Fungi	Fungi	119	3.33e-29	NR	WFD16437.1	1514897	g5582	i0	98.5	1	67	1	100	0	201	1	2643	2709	WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei]	diamond	201	119	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia arunalokei
26937356	26937356	PRJDB14275_P_NODE_3342_length_324_cov_2.505263_g3283_i0	PRJDB14275	3342	324	2.505263	8.11705212	Malassezia restricta CBS 7877	425264	Fungi	Fungi	191	5.78e-61	NR	AYO44923.1	425264	g3283	i0	97.8	0.833333333333333	90	2	83.3	0	292	23	1	90	AYO44923.1 hypothetical protein DNF11_3973 [Malassezia restricta CBS 7877]	diamond	270	191	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
27506610	27506610	PRJDB14275_P_NODE_6083_length_189_cov_2.166667_g6024_i0	PRJDB14275	6083	189	2.166667	4.09500063	Malassezia restricta CBS 7877	425264	Fungi	Fungi	124	1.92e-32	NR	AYO43741.1	425264	g6024	i0	100	1	63	0	100	0	1	189	158	220	AYO43741.1 Protein TOXD [Malassezia restricta CBS 7877]	diamond	189	124	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
30626717	30626717	PRJDB14275_P_NODE_4593_length_244_cov_0.995122_g4534_i0	PRJDB14275	4593	244	0.995122	2.42809768	Malassezia	55193	Fungi	Fungi	104	1.3e-27	NR	XP_001731430.1	425265	g4534	i0	77	2.96311475409836	61	13	73.8	1	43	222	1	61	XP_001731430.1 uncharacterized protein MGL_1613 [Malassezia globosa CBS 7966]	diamond	723	104	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia globosa
31992224	31992224	PRJDB14275_P_NODE_8038_length_155_cov_1.060345_g7979_i0	PRJDB14275	8038	155	1.060345	1.64353475	Malassezia equina	1381935	Fungi	Fungi	49.3	3.29e-5	NR	WFD23909.1	1381935	g7979	i0	54.3	0.890322580645161	46	19	89	1	7	144	70	113	WFD23909.1 hypothetical protein MEQU1_002603 [Malassezia equina]	diamond	138	49.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia equina
32397839	32397839	PRJDB14275_P_NODE_6199_length_186_cov_4.183673_g6140_i0	PRJDB14275	6199	186	4.183673	7.78163178	Malassezia	55193	Fungi	Fungi	85.5	1.47e-17	NR	AYO43640.1	425264	g6140	i0	95.8	1.54838709677419	48	2	77.4	0	181	38	500	547	AYO43640.1 hypothetical protein DNF11_2690 [Malassezia restricta CBS 7877]	diamond	288	85.5	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);;