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

5 rows where analysis = "diamond", bioproject = "PRJNA1044115" 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
27090469	27090469	PRJNA1044115_P_NODE_32482_length_258_cov_2.183784_g32298_i0	PRJNA1044115	32482	258	2.183784	5.63416272	Candida	5475	Fungi	Fungi	78.6	3.33e-17	NR	KHC45672.1	1094986	g32298	i0	66.7	1.19767441860465	66	13	76.7	2	19	216	1	57	KHC45672.1 hypothetical protein MEW_05321, partial [Candida albicans P60002]	diamond	309	78.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Candida	Candida albicans
27509363	27509363	PRJNA1044115_P_NODE_35643_length_251_cov_0.876404_g35459_i0	PRJNA1044115	35643	251	0.876404	2.19977404	Poronia punctata	101475	Fungi	Fungi	43.1	0.0293	NR	KAI1813744.1	101475	g35459	i0	36	0.597609561752988	50	32	59.8	0	225	76	161	210	KAI1813744.1 DUF1766-domain-containing protein [Poronia punctata]	diamond	150	43.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Xylariales	Xylariaceae	Poronia	Poronia punctata
29277170	29277170	PRJNA1044115_P_NODE_21789_length_311_cov_18.718487_g21605_i0	PRJNA1044115	21789	311	18.718487	58.21449457	Zygosaccharomyces bailii ISA13	4954	Fungi	Fungi	61.6	1.06e-9	NR	CDH16361.1	1355161	g21605	i0	51.4	2.02572347266881	70	24	67.5	1	310	101	7	66	CDH16361.1 probable protein TAR1 [Zygosaccharomyces bailii ISA1307]	diamond	630	61.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Zygosaccharomyces	Zygosaccharomyces bailii
31584017	31584017	PRJNA1044115_P_NODE_37836_length_247_cov_2.367816_g37652_i0	PRJNA1044115	37836	247	2.367816	5.84850552	Candida albicans SC5314	237561	Fungi	Fungi	167	1.55e-51	NR	KHC78117.1	237561	g37652	i0	100	0.935222672064777	77	0	93.5	0	17	247	1	77	KHC78117.1 hypothetical protein W5Q_03473 [Candida albicans SC5314]	diamond	231	167	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Candida	Candida albicans
32343368	32343368	PRJNA1044115_P_NODE_40279_length_244_cov_0.912281_g40095_i0	PRJNA1044115	40279	244	0.912281	2.22596564	Watsoniomyces obsoletus	2796175	Fungi	Fungi	42.7	0.0365	NR	KAI9887890.1	2796175	g40095	i0	42	0.614754098360656	50	26	61.5	1	3	152	82	128	KAI9887890.1 MAG: hypothetical protein M1823_000278 [Watsoniomyces obsoletus]	diamond	150	42.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lichinomycetes	Lichinales	Porocyphaceae	Watsoniomyces	Watsoniomyces obsoletus

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