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

4 rows where analysis = "diamond", bioproject = "PRJNA438687" and tax_phylum = "Ascomycota"

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
27549841	27549841	PRJNA438687_S_NODE_8164_length_151_cov_1.017241_g8074_i0	PRJNA438687	8164	151	1.017241	1.53603391	Glonium stellatum	574774	Fungi	Fungi	42	0.0024	NR	OCL14487.1	574774	g8074	i0	51.1	1.78807947019868	47	13	85.4	2	6	134	17	57	OCL14487.1 hypothetical protein AOQ84DRAFT_280950, partial [Glonium stellatum]	diamond	270	42	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Gloniales	Gloniaceae	Glonium	Glonium stellatum
27676500	27676500	PRJNA438687_S_NODE_8044_length_152_cov_1.735043_g7954_i0	PRJNA438687	8044	152	1.735043	2.63726536	Penicillium malachiteum	1324776	Fungi	Fungi	45.4	6.46e-4	NR	KAJ5710222.1	1324776	g7954	i0	65.5	1.125	29	10	57.2	0	96	10	97	125	KAJ5710222.1 hypothetical protein N7493_009389 [Penicillium malachiteum]	diamond	171	45.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium malachiteum
29791531	29791531	PRJNA438687_S_NODE_6191_length_176_cov_12.978723_g6101_i0	PRJNA438687	6191	176	12.978723	22.84255248	Aspergillus heteromorphus CBS 117.55	1448321	Fungi	Fungi	42.7	0.0113	NR	PWY62586.1	1448321	g6101	i0	68	2.98295454545455	25	8	42.6	0	76	2	51	75	PWY62586.1 hypothetical protein BO70DRAFT_375471 [Aspergillus heteromorphus CBS 117.55]	diamond	525	42.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus heteromorphus
29823052	29823052	PRJNA438687_S_NODE_6511_length_171_cov_3.875000_g6421_i0	PRJNA438687	6511	171	3.875	6.62625	Microthyrium microscopicum	703497	Fungi	Fungi	39.3	0.0219	NR	KAF2663089.1	703497	g6421	i0	58.6	0.508771929824561	29	12	50.9	0	34	120	1	29	KAF2663089.1 hypothetical protein BT63DRAFT_380561, partial [Microthyrium microscopicum]	diamond	87	39.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Microthyriales	Microthyriaceae	Microthyrium	Microthyrium microscopicum

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