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

5 rows where analysis = "diamond", bioproject = "PRJEB6055" 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
5228093	5228093	PRJEB6055_S_NODE_265_length_402_cov_10006.141689_g241_i0	PRJEB6055	265	402	10006.141689	40224.68958978	Fungi	4751	Fungi	Fungi	126	7.049999999999999e-35	NR	XP_054124123.1	37727	g241	i0	66.7	8.19402985074627	93	30	69.4	1	388	110	1	92	XP_054124123.1 uncharacterized protein EYB26_008897 [Talaromyces marneffei]	diamond	3294	126	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Trichocomaceae	Talaromyces	Talaromyces marneffei
30943228	30943228	PRJEB6055_S_NODE_3994_length_174_cov_1.438849_g3970_i0	PRJEB6055	3994	174	1.438849	2.50359726	root	1	Root_unresolved	Root_unresolved	41.6	0.00519	NR	XP_019038176.1	683960	g3970	i0	60	1.06896551724138	30	11	51.7	1	171	82	29	57	XP_019038176.1 uncharacterized protein WICANDRAFT_63473 [Wickerhamomyces anomalus NRRL Y-366-8]	diamond	186	41.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Phaffomycetales	Wickerhamomycetaceae	Wickerhamomyces	Wickerhamomyces anomalus
31487546	31487546	PRJEB6055_S_NODE_976_length_278_cov_9.740741_g952_i0	PRJEB6055	976	278	9.740741	27.07925998	Yarrowia lipolytica	4952	Fungi	Fungi	41.6	0.0271	NR	KAE8168712.1	4952	g952	i0	78.3	0.485611510791367	23	5	24.8	0	223	155	31	53	KAE8168712.1 hypothetical protein BKA90DRAFT_10915 [Yarrowia lipolytica]	diamond	135	41.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dipodascomycetes	Dipodascales		Yarrowia	Yarrowia lipolytica
32499923	32499923	PRJEB6055_S_NODE_2399_length_206_cov_3.403509_g2375_i0	PRJEB6055	2399	206	3.403509	7.01122854	Byssothecium circinans	147558	Fungi	Fungi	45.4	2.35e-4	NR	KAF1948084.1	147558	g2375	i0	59.5	1.09223300970874	37	15	53.9	0	90	200	9	45	KAF1948084.1 hypothetical protein CC80DRAFT_57283 [Byssothecium circinans]	diamond	225	45.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Massarinaceae	Byssothecium	Byssothecium circinans
32745242	32745242	PRJEB6055_S_NODE_1880_length_223_cov_5.643617_g1856_i0	PRJEB6055	1880	223	5.643617	12.58526591	Saccharomycetaceae	4893	Fungi	Fungi	54.3	6.08e-7	NR	KAF4001137.1	4932	g1856	i0	52.5	4.0762331838565	61	19	82.1	1	12	194	56	106	KAF4001137.1 Protein TAR1 domain protein [Saccharomyces cerevisiae]	diamond	909	54.7	0.992687385740402	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Saccharomyces	Saccharomyces cerevisiae

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