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

4 rows where analysis = "diamond", bioproject = "PRJNA438687" 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
27581451	27581451	PRJNA438687_S_NODE_5864_length_182_cov_2.557823_g5774_i0	PRJNA438687	5864	182	2.557823	4.65523786	Malassezia arunalokei	1514897	Fungi	Fungi	71.6	1.07e-12	NR	WFD16437.1	1514897	g5774	i0	69.4	1.02197802197802	62	7	82.4	1	182	33	952	1013	WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei]	diamond	186	71.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia arunalokei
27644891	27644891	PRJNA438687_S_NODE_4104_length_219_cov_2.793478_g4014_i0	PRJNA438687	4104	219	2.793478	6.11771682	Gelatoporia subvermispora B	914234	Fungi	Fungi	47.8	1.41e-4	NR	EMD30441.1	914234	g4014	i0	48.5	1.80821917808219	66	33	90.4	1	219	22	60	124	EMD30441.1 hypothetical protein CERSUDRAFT_163835, partial [Gelatoporia subvermispora B]	diamond	396	47.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Gelatoporiaceae	Gelatoporia	Gelatoporia subvermispora
29349752	29349752	PRJNA438687_S_NODE_5809_length_183_cov_2.459459_g5719_i0	PRJNA438687	5809	183	2.459459	4.50080997	Malassezia arunalokei	1514897	Fungi	Fungi	50.1	4.27e-5	NR	WFD16025.1	1514897	g5719	i0	60.7	1.81967213114754	56	16	88.5	3	179	18	33	84	WFD16025.1 hypothetical protein MARU1_002059 [Malassezia arunalokei]	diamond	333	50.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia arunalokei
30882130	30882130	PRJNA438687_S_NODE_5654_length_186_cov_1.046358_g5564_i0	PRJNA438687	5654	186	1.046358	1.94622588	Malassezia	55193	Fungi	Fungi	48.5	1.57e-4	NR	AYO43640.1	425264	g5564	i0	77.8	1.16129032258065	36	3	58.1	2	151	44	121	151	AYO43640.1 hypothetical protein DNF11_2690 [Malassezia restricta CBS 7877]	diamond	216	48.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);;