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

4 rows where analysis = "diamond", bioproject = "PRJNA1151638" 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
29787433	29787433	PRJNA1151638_P_NODE_6191_length_245_cov_0.901163_g6124_i0	PRJNA1151638	6191	245	0.901163	2.20784935	Cladosporium halotolerans	1052096	Fungi	Fungi	61.2	1.12e-8	NR	XP_069227350.1	1052096	g6124	i0	96.7	0.36734693877551	30	1	36.7	0	244	155	52	81	XP_069227350.1 uncharacterized protein WHR41_06762 [Cladosporium halotolerans]	diamond	90	61.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
30798492	30798492	PRJNA1151638_P_NODE_4754_length_253_cov_0.866667_g4687_i0	PRJNA1151638	4754	253	0.866667	2.19266751	Scheffersomyces xylosifermentans	1304137	Fungi	Fungi	78.6	1.06e-14	NR	XP_064776746.1	1304137	g4687	i0	45.3	1.0197628458498	86	43	97.2	2	253	8	1079	1164	XP_064776746.1 SAC3/GANP/Nin1/mts3/eIF-3 p25 family-domain-containing protein [Scheffersomyces xylosifermentans]	diamond	258	78.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Scheffersomyces	Scheffersomyces xylosifermentans
31430671	31430671	PRJNA1151638_P_NODE_4876_length_252_cov_1.329609_g4809_i0	PRJNA1151638	4876	252	1.329609	3.35061468	Zasmidium cellare	395010	Fungi	Fungi	119	6.78e-29	NR	KAK4507054.1	395010	g4809	i0	66.7	1	84	26	100	1	1	252	840	921	KAK4507054.1 hypothetical protein PRZ48_000788 [Zasmidium cellare]	diamond	252	119	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Mycosphaerellaceae	Zasmidium	Zasmidium cellare
32840737	32840737	PRJNA1151638_P_NODE_6540_length_243_cov_0.917647_g6473_i0	PRJNA1151638	6540	243	0.917647	2.22988221	Penicillium	5073	Fungi	Fungi	136	4.3999999999999996e-38	NR	XP_065958079.1	36651	g6473	i0	76.5	6	81	19	100	0	243	1	79	159	XP_065958079.1 AIG2-like [Penicillium digitatum]	diamond	1458	136	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium digitatum

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