metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1218816" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1218816" 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
18184957	18184957	PRJNA1218816_P_NODE_44855_length_284_cov_1.246445_g44422_i0	PRJNA1218816	44855	284	1.246445	3.5399038	Fungi	4751	Fungi	Fungi	120	3.95e-29	NR	CAI7483938.1	4932	g44422	i0	61.7	18.6338028169014	94	36	99.3	0	3	284	567	660	CAI7483938.1 BAD_collapsed_G0055650.mRNA.1.CDS.1 [Saccharomyces cerevisiae]	diamond	5292	120	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Saccharomyces	Saccharomyces cerevisiae
20734846	20734846	PRJNA1218816_P_NODE_43817_length_288_cov_1.669767_g43384_i0	PRJNA1218816	43817	288	1.669767	4.80892896	Dothistroma septosporum NZE1	64363	Fungi	Fungi	139	1.2e-37	NR	EME43633.1	675120	g43384	i0	79.8	4.375	84	17	87.5	0	252	1	1	84	EME43633.1 hypothetical protein DOTSEDRAFT_72860 [Dothistroma septosporum NZE10]	diamond	1260	139	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Mycosphaerellaceae	Dothistroma	Dothistroma septosporum
26883041	26883041	PRJNA1218816_P_NODE_56321_length_248_cov_1.062857_g55888_i0	PRJNA1218816	56321	248	1.062857	2.63588536	Magnaporthiopsis poae ATCC 64411	644358	Fungi	Fungi	42.7	0.0373	NR	KLU90902.1	644358	g55888	i0	44.7	0.459677419354839	38	21	46	0	17	130	254	291	KLU90902.1 hypothetical protein MAPG_09427 [Magnaporthiopsis poae ATCC 64411]	diamond	114	42.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Magnaporthales	Magnaporthaceae	Magnaporthiopsis	Magnaporthiopsis poae
29965180	29965180	PRJNA1218816_P_NODE_44831_length_284_cov_1.440758_g44398_i0	PRJNA1218816	44831	284	1.440758	4.09175272	Fungi	4751	Fungi	Fungi	107	2.38e-28	NR	KAK9314725.1	29829	g44398	i0	78.6	4.13028169014085	56	12	59.2	0	267	100	1	56	KAK9314725.1 ribosomal protein S14p/S29e-domain-containing protein [Lipomyces starkeyi]	diamond	1173	108	0.990740740740741	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lipomycetes	Lipomycetales	Lipomycetaceae	Lipomyces	Lipomyces starkeyi
30167343	30167343	PRJNA1218816_P_NODE_57012_length_247_cov_2.045977_g56579_i0	PRJNA1218816	57012	247	2.045977	5.05356319	Penicillium desertorum	1303715	Fungi	Fungi	80.5	1.99e-15	NR	KAJ5486468.1	1303715	g56579	i0	58.5	0.789473684210526	65	27	78.9	0	53	247	61	125	KAJ5486468.1 hypothetical protein N7530_000768 [Penicillium desertorum]	diamond	195	80.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium desertorum
30249729	30249729	PRJNA1218816_P_NODE_28232_length_384_cov_1.038585_g27799_i0	PRJNA1218816	28232	384	1.038585	3.9881664	Ascomycota	4890	Fungi	Fungi	52.8	5.17e-5	NR	KAF3906510.1	47266	g27799	i0	40.7	8.078125	86	38	64.8	4	384	136	25	100	KAF3906510.1 hypothetical protein ABW20_dc0107127 [Dactylellina cionopaga]	diamond	3102	53.1	0.994350282485876	Eukaryota	Opisthokonta	Fungi	Ascomycota	Orbiliomycetes	Orbiliales	Orbiliaceae	Dactylellina	Dactylellina cionopaga
30483510	30483510	PRJNA1218816_P_NODE_55013_length_250_cov_0.870056_g54580_i0	PRJNA1218816	55013	250	0.870056	2.17514	Sarocladium strictum	5046	Fungi	Fungi	112	1.28e-26	NR	KAK0386310.1	5046	g54580	i0	82.8	0.768	64	11	76.8	0	249	58	109	172	KAK0386310.1 hypothetical protein NLU13_6147 [Sarocladium strictum]	diamond	192	112	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
30862567	30862567	PRJNA1218816_P_NODE_60594_length_243_cov_1.811765_g60161_i0	PRJNA1218816	60594	243	1.811765	4.40258895	Hapsidospora chrysogenum ATCC 1155	5044	Fungi	Fungi	147	5.16e-40	NR	KFH42568.1	857340	g60161	i0	85.2	8	81	12	100	0	243	1	337	417	KFH42568.1 High-affinity nicotinic acid transporter-like protein [Hapsidospora chrysogenum ATCC 11550]	diamond	1944	147	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Bionectriaceae	Hapsidospora	Hapsidospora chrysogena
31747765	31747765	PRJNA1218816_P_NODE_34817_length_333_cov_2.723077_g34384_i0	PRJNA1218816	34817	333	2.723077	9.06784641	Ascobolus immersus RN42	1160509	Fungi	Fungi	51.6	8.37e-5	NR	RPA76764.1	1160509	g34384	i0	56.8	0.333333333333333	37	16	33.3	0	331	221	685	721	RPA76764.1 ankyrin [Ascobolus immersus RN42]	diamond	111	51.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pezizomycetes	Pezizales	Ascobolaceae	Ascobolus	Ascobolus immersus

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