metadata: contig_metadata: 9 rows where bioproject = "PRJNA1008624" and tax

9 rows where bioproject = "PRJNA1008624" 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
15457001	15457001	PRJNA1008624_P_NODE_29273_length_167_cov_1.737288_g29085_i0	PRJNA1008624	29273	167	1.737288	2.90127096	Cercospora beticola	122368	Fungi	Fungi	52.8	0.014	NTclustered	gi\|2741394181\|ref\|XM_065602644.1\|	122368	g29085	i0	100	0.167664670658683	28	0	17	0	71	98	823	796	Cercospora beticola Acetyl-CoA hydrolase (ACU8), partial mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Mycosphaerellaceae	Cercospora	Cercospora beticola
21831152	21831152	PRJNA1008624_P_NODE_27778_length_169_cov_0.866667_g27590_i0	PRJNA1008624	27778	169	0.866667	1.46466723	Alternaria arborescens	156630	Fungi	Fungi	296	5.9e-76	NTclustered	gi\|1607835781\|ref\|XM_028643862.1\|	156630	g27590	i0	98.795	3.92899408284024	166	2	98	0	1	166	1751	1586	Alternaria arborescens Phospholipase (AA0111_g10145), partial mRNA	blastn	664	296	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Pleosporaceae	Alternaria	Alternaria arborescens
26971075	26971075	PRJNA1008624_P_NODE_29882_length_167_cov_0.881356_g29694_i0	PRJNA1008624	29882	167	0.881356	1.47186452	Phialemonium thermophilum	223376	Fungi	Fungi	50.8	1.86e-5	NR	KAL1884135.1	223376	g29694	i0	51.1	0.844311377245509	47	23	84.4	0	26	166	1292	1338	KAL1884135.1 hypothetical protein VTK73DRAFT_6804 [Phialemonium thermophilum]	diamond	141	50.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Cephalothecales	Cephalothecaceae	Phialemonium	Phialemonium thermophilum
27034474	27034474	PRJNA1008624_P_NODE_17022_length_206_cov_1.560510_g16834_i0	PRJNA1008624	17022	206	1.56051	3.2146506	Aplosporella prunicola CBS 121167	1176127	Fungi	Fungi	42.4	0.0322	NR	XP_033402087.1	1176127	g16834	i0	43.4	0.771844660194175	53	27	72.8	1	157	8	482	534	XP_033402087.1 uncharacterized protein K452DRAFT_294938 [Aplosporella prunicola CBS 121167]	diamond	159	42.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Botryosphaeriales	Aplosporellaceae	Aplosporella	Aplosporella prunicola
27603420	27603420	PRJNA1008624_P_NODE_31144_length_166_cov_0.888889_g30956_i0	PRJNA1008624	31144	166	0.888889	1.47555574	Exophiala aquamarina CBS 119918	1182545	Fungi	Fungi	51.6	9.86e-6	NR	XP_013259299.1	1182545	g30956	i0	57.4	0.849397590361446	47	16	84.9	1	1	141	13	55	XP_013259299.1 triacylglycerol lipase [Exophiala aquamarina CBS 119918]	diamond	141	51.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Herpotrichiellaceae	Exophiala	Exophiala aquamarina
30287660	30287660	PRJNA1008624_P_NODE_28892_length_168_cov_0.873950_g28704_i0	PRJNA1008624	28892	168	0.87395	1.468236	Podospora comata	48703	Fungi	Fungi	41.2	0.0477	NR	VBB81160.1	48703	g28704	i0	42	0.892857142857143	50	24	80.4	1	136	2	860	909	VBB81160.1 Putative protein of unknown function [Podospora comata]	diamond	150	41.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Sordariales	Podosporaceae	Podospora	Podospora comata
30532511	30532511	PRJNA1008624_P_NODE_29053_length_168_cov_0.873950_g28865_i0	PRJNA1008624	29053	168	0.87395	1.468236	Cadophora	210567	Fungi	Fungi	42	0.0251	NR	XP_058359988.1	51156	g28865	i0	47.5	5.71428571428571	40	21	71.4	0	166	47	106	145	XP_058359988.1 uncharacterized protein ONS95_009718 [Cadophora gregata]	diamond	960	42.4	0.990566037735849	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Ploettnerulaceae	Cadophora	Cadophora gregata
31519985	31519985	PRJNA1008624_P_NODE_27576_length_169_cov_0.866667_g27388_i0	PRJNA1008624	27576	169	0.866667	1.46466723	Dactylonectria macrodidyma	307937	Fungi	Fungi	72.4	3.86e-13	NR	KAH7121494.1	307937	g27388	i0	85.7	2.16568047337278	42	6	74.6	0	44	169	168	209	KAH7121494.1 phosphorylcholine phosphatase [Dactylonectria macrodidyma]	diamond	366	72.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Dactylonectria	Dactylonectria macrodidyma
32815714	32815714	PRJNA1008624_P_NODE_16540_length_209_cov_1.062500_g16352_i0	PRJNA1008624	16540	209	1.0625	2.220625	Trichoderma harzianum CBS 226.95	983964	Fungi	Fungi	42.7	0.00476	NR	XP_024780201.1	983964	g16352	i0	54.5	0.861244019138756	33	13	47.4	1	1	99	50	80	XP_024780201.1 hypothetical protein M431DRAFT_131280, partial [Trichoderma harzianum CBS 226.95]	diamond	180	42.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Hypocreaceae	Trichoderma	Trichoderma harzianum

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