metadata: contig_metadata: 28 rows where bioproject = "PRJNA506002" and tax

28 rows where bioproject = "PRJNA506002" 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
3661803	3661803	PRJNA506002_S_NODE_58703_length_248_cov_1.897143_g58457_i0	PRJNA506002	58703	248	1.897143	4.70491464	Sarocladium implicatum	1610689	Fungi	Fungi	113	3.2900000000000004e-27	NR	KAH8171824.1	1610689	g58457	i0	87.3	0.762096774193548	63	8	76.2	0	3	191	480	542	KAH8171824.1 malate synthase domain-containing protein [Sarocladium implicatum]	diamond	189	113	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium implicatum
4310993	4310993	PRJNA506002_S_NODE_51744_length_258_cov_1.643243_g51498_i0	PRJNA506002	51744	258	1.643243	4.23956694	Beauveria bassiana	176275	Fungi	Fungi	124	4.91e-24	NTclustered	gi\|667652736\|ref\|XM_008599978.1\|	655819	g51498	i0	90.426	0.364341085271318	94	9	36	0	4	97	960	1053	Beauveria bassiana ARSEF 2860 60S ribosomal protein L4 (BBA_04881), partial mRNA	blastn	94	124	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Cordycipitaceae	Beauveria	Beauveria bassiana
5587527	5587527	PRJNA506002_S_NODE_18645_length_352_cov_1.197133_g18399_i0	PRJNA506002	18645	352	1.197133	4.21390816	Gaeumannomyces tritici	36779	Fungi	Fungi	171	8.799999999999999e-38	NTclustered	gi\|685395220\|ref\|XM_009218209.1\|	644352	g18399	i0	79.747	4.84659090909091	237	46	67	2	74	309	24	259	Gaeumannomyces tritici R3-111a-1 hypothetical protein mRNA	blastn	1706	171	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Magnaporthales	Magnaporthaceae	Gaeumannomyces	Gaeumannomyces tritici
6861957	6861957	PRJNA506002_S_NODE_6046_length_458_cov_4.285714_g5801_i0	PRJNA506002	6046	458	4.285714	19.62857012	Cyphellophora europaea	293227	Fungi	Fungi	217	1.49e-51	NTclustered	gi\|671149948\|ref\|XM_008715760.1\|	1220924	g5801	i0	81.091	28.4235807860262	275	48	60	3	3	275	1222	1494	Cyphellophora europaea CBS 101466 pyruvate dehydrogenase complex dihydrolipoamide acetyltransferase (HMPREF1541_11091), partial mRNA	blastn	13018	217	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Cyphellophoraceae	Cyphellophora	Cyphellophora europaea
9411891	9411891	PRJNA506002_S_NODE_20308_length_344_cov_1.136531_g20062_i0	PRJNA506002	20308	344	1.136531	3.90966664	Purpureocillium takamizusanense	2060973	Fungi	Fungi	150	1.12e-31	NTclustered	gi\|2234672475\|ref\|XM_047988440.1\|	2060973	g20062	i0	86.897	15.3255813953488	145	6	42	6	126	269	550	418	Purpureocillium takamizusanense 60S acidic ribosomal protein P1 (ALTA12), mRNA	blastn	5272	150	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Ophiocordycipitaceae	Purpureocillium	Purpureocillium takamizusanense
9411953	9411953	PRJNA506002_S_NODE_28668_length_312_cov_1.610879_g28422_i0	PRJNA506002	28668	312	1.610879	5.02594248	Ascochyta rabiei	5454	Fungi	Fungi	322	2.01e-83	NTclustered	gi\|2579372398\|ref\|XM_038940439.2\|	5454	g28422	i0	93.519	5.76923076923077	216	14	69	0	97	312	651	436	Ascochyta rabiei uncharacterized protein (EKO05_0006420), partial mRNA	blastn	1800	322	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Didymellaceae	Ascochyta	Ascochyta rabiei
10687730	10687730	PRJNA506002_S_NODE_39489_length_283_cov_1.833333_g39243_i0	PRJNA506002	39489	283	1.833333	5.18833239	Sarocladium strictum	5046	Fungi	Fungi	83.2	3.96e-18	NR	KAL2212624.1	5046	g39243	i0	88.4	0.45583038869258	43	5	45.6	0	2	130	62	104	KAL2212624.1 UPF0041-domain-containing protein [Sarocladium strictum]	diamond	129	83.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
11962762	11962762	PRJNA506002_S_NODE_45630_length_270_cov_1.172589_g45384_i0	PRJNA506002	45630	270	1.172589	3.1659903	Sarocladium strictum	5046	Fungi	Fungi	133	1.51e-35	NR	KAL2204586.1	5046	g45384	i0	76.4	0.8	72	17	80	0	216	1	85	156	KAL2204586.1 hypothetical protein CC79DRAFT_1350969 [Sarocladium strictum]	diamond	216	133	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
11962921	11962921	PRJNA506002_S_NODE_66790_length_236_cov_2.490798_g66544_i0	PRJNA506002	66790	236	2.490798	5.87828328	Akanthomyces muscarius	2231603	Fungi	Fungi	169	2.01e-37	NTclustered	gi\|2507654566\|ref\|XM_056200535.1\|	2231603	g66544	i0	86.928	4.4364406779661	153	16	64	4	1	151	639	789	Akanthomyces muscarius uncharacterized protein (LMH87_011400), partial mRNA	blastn	1047	169	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Cordycipitaceae	Akanthomyces	Akanthomyces muscarius
13237682	13237682	PRJNA506002_S_NODE_18031_length_355_cov_1.365248_g17785_i0	PRJNA506002	18031	355	1.365248	4.8466304	Pochonia chlamydosporia	280754	Fungi	Fungi	228	5.2e-55	NTclustered	gi\|1069538784\|ref\|XM_018281777.1\|	1380566	g17785	i0	85.455	3.33239436619718	220	30	62	2	128	346	1464	1246	Pochonia chlamydosporia 170 aldehyde dehydrogenase (VFPPC_02061), partial mRNA	blastn	1183	228	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Clavicipitaceae	Pochonia	Pochonia chlamydosporia
13237980	13237980	PRJNA506002_S_NODE_49171_length_263_cov_1.215789_g48925_i0	PRJNA506002	49171	263	1.215789	3.19752507	Paraphaeosphaeria sporulosa	1460663	Fungi	Fungi	401	2.0699999999999994e-107	NTclustered	gi\|1066288378\|ref\|XM_018178813.1\|	1460663	g48925	i0	96.694	22.6692015209125	242	7	92	1	23	263	659	418	Paraphaeosphaeria sporulosa 60S ribosomal protein L42 (CC84DRAFT_1165859), mRNA	blastn	5962	401	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Didymosphaeriaceae	Paraphaeosphaeria	Paraphaeosphaeria sporulosa
13238021	13238021	PRJNA506002_S_NODE_54691_length_253_cov_1.283333_g54445_i0	PRJNA506002	54691	253	1.283333	3.24683249	Penicillium coprophilum	36646	Fungi	Fungi	87.9	6.29e-13	NTclustered	gi\|2513119577\|ref\|XM_056682061.1\|	36646	g54445	i0	85.057	1.4901185770751	87	11	34	2	168	253	1188	1103	Penicillium coprophilum uncharacterized protein (N7500_010923), partial mRNA	blastn	377	87.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium coprophilum
14512998	14512998	PRJNA506002_S_NODE_53352_length_255_cov_2.115385_g53106_i0	PRJNA506002	53352	255	2.115385	5.39423175	Saccharomyces eubayanus	1080349	Fungi	Fungi	91.6	4.91e-14	NTclustered	gi\|1069852200\|ref\|XM_018366498.1\|	1080349	g53106	i0	84.211	9.34901960784314	95	13	37	2	153	246	1159	1066	Saccharomyces eubayanus translation initiation factor eIF4A (DI49_3430), partial mRNA	blastn	2384	91.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Saccharomyces	Saccharomyces eubayanus
17061459	17061459	PRJNA506002_S_NODE_59774_length_247_cov_1.770115_g59528_i0	PRJNA506002	59774	247	1.770115	4.37218405	Penicillium mononematosum	268346	Fungi	Fungi	435	1.9e-117	NTclustered	gi\|2517906493\|ref\|XM_057292147.1\|	268346	g59528	i0	98.381	15.7449392712551	247	4	100	0	1	247	1667	1421	Penicillium mononematosum uncharacterized protein (N7519_005371), partial mRNA	blastn	3889	435	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium mononematosum
18335604	18335604	PRJNA506002_S_NODE_33735_length_297_cov_3.062500_g33489_i0	PRJNA506002	33735	297	3.0625	9.095625	Purpureocillium takamizusanense	2060973	Fungi	Fungi	233	9.180000000000001e-57	NTclustered	gi\|2234647057\|ref\|XM_047981812.1\|	2060973	g33489	i0	90	15.3771043771044	180	18	61	0	118	297	406	227	Purpureocillium takamizusanense 60S ribosomal protein L43 (RPL43), mRNA	blastn	4567	233	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Ophiocordycipitaceae	Purpureocillium	Purpureocillium takamizusanense
20237007	20237007	PRJNA506002_S_NODE_53656_length_255_cov_1.181319_g53410_i0	PRJNA506002	53656	255	1.181319	3.01236345	Aspergillus	5052	Fungi	Fungi	178	3.66e-40	NTclustered	gi\|1422894546\|ref\|XM_025702873.1\|	1448311	g53410	i0	82.126	9.33333333333333	207	37	81	0	34	240	749	543	Aspergillus vadensis CBS 113365 dienelactone hydrolase family protein (BO88DRAFT_335871), partial mRNA	blastn	2380	178	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus vadensis
20885815	20885815	PRJNA506002_S_NODE_16677_length_362_cov_1.913495_g16431_i0	PRJNA506002	16677	362	1.913495	6.9268519	Daldinia decipiens	326647	Fungi	Fungi	189	2.51e-43	NTclustered	gi\|2272166360\|ref\|XM_049240133.1\|	326647	g16431	i0	81.579	1.82044198895028	228	42	63	0	115	342	992	765	Daldinia decipiens ribulose-phosphate 3-epimerase (F4813DRAFT_249606), mRNA	blastn	659	189	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Xylariales	Hypoxylaceae	Daldinia	Daldinia decipiens
22160537	22160537	PRJNA506002_S_NODE_22618_length_334_cov_0.885057_g22372_i0	PRJNA506002	22618	334	0.885057	2.95609038	Scheffersomyces amazonensis	1078765	Fungi	Fungi	78.7	5.19e-10	NTclustered	gi\|2725044944\|ref\|XM_064881648.1\|	1078765	g22372	i0	92.727	2.17365269461078	55	3	16	1	126	179	91	145	Scheffersomyces amazonensis uncharacterized protein (RJT21DRAFT_120199), partial mRNA	blastn	726	78.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Scheffersomyces	Scheffersomyces amazonensis
24709930	24709930	PRJNA506002_S_NODE_40260_length_281_cov_3.139423_g40014_i0	PRJNA506002	40260	281	3.139423	8.82177863	Hirsutella rhossiliensis	111463	Fungi	Fungi	274	5.08e-69	NTclustered	gi\|2124713977\|ref\|XM_044859486.1\|	111463	g40014	i0	88.21	6.48398576512456	229	27	81	0	24	252	530	302	Hirsutella rhossiliensis amino acid permease domain-containing protein (HRG_01015), partial mRNA	blastn	1822	274	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Ophiocordycipitaceae	Hirsutella	Hirsutella rhossiliensis
27203285	27203285	PRJNA506002_S_NODE_64002_length_243_cov_1.811765_g63756_i0	PRJNA506002	64002	243	1.811765	4.40258895	Sarocladium implicatum	1610689	Fungi	Fungi	78.6	8.32e-15	NR	KAH8174025.1	1610689	g63756	i0	94.7	0.469135802469136	38	2	46.9	0	243	130	403	440	KAH8174025.1 aminomethyltransferase folate-binding domain-containing protein [Sarocladium implicatum]	diamond	114	78.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium implicatum
27424976	27424976	PRJNA506002_S_NODE_14443_length_375_cov_2.728477_g14197_i0	PRJNA506002	14443	375	2.728477	10.23178875	Rhinocladiella mackenziei CBS 65	86056	Fungi	Fungi	64.7	3.41e-10	NR	XP_013277619.1	1442369	g14197	i0	75	0.96	40	10	32	0	365	246	88	127	XP_013277619.1 uncharacterized protein Z518_01566 [Rhinocladiella mackenziei CBS 650.93]	diamond	360	64.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Herpotrichiellaceae	Rhinocladiella	Rhinocladiella mackenziei
27582532	27582532	PRJNA506002_S_NODE_52124_length_257_cov_2.951087_g51878_i0	PRJNA506002	52124	257	2.951087	7.58429359	Sarocladium strictum	5046	Fungi	Fungi	45.1	0.0064	NR	KAK0385706.1	5046	g51878	i0	73.2	0.478599221789883	41	7	44.4	2	2	115	299	338	KAK0385706.1 hypothetical protein NLU13_6883 [Sarocladium strictum]	diamond	123	45.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
28213840	28213840	PRJNA506002_S_NODE_44746_length_272_cov_1.070352_g44500_i0	PRJNA506002	44746	272	1.070352	2.91135744	Sarocladium strictum	5046	Fungi	Fungi	89	5.22e-20	NR	KAK0386860.1	5046	g44500	i0	84.7	0.650735294117647	59	9	65.1	0	267	91	107	165	KAK0386860.1 hypothetical protein NLU13_5173 [Sarocladium strictum]	diamond	177	89	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
28245432	28245432	PRJNA506002_S_NODE_49906_length_261_cov_3.191489_g49660_i0	PRJNA506002	49906	261	3.191489	8.32978629	Sarocladium strictum	5046	Fungi	Fungi	94.4	3.27e-20	NR	KAK0387532.1	5046	g49660	i0	92.2	1.18390804597701	51	4	58.6	0	1	153	553	603	KAK0387532.1 hypothetical protein NLU13_3778 [Sarocladium strictum]	diamond	309	94.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
28813723	28813723	PRJNA506002_S_NODE_20028_length_345_cov_1.801471_g19782_i0	PRJNA506002	20028	345	1.801471	6.21507495	Xanthoria steineri	2905939	Fungi	Fungi	86.7	4.89e-17	NR	KAI4222665.1	2905939	g19782	i0	88	0.434782608695652	50	6	43.5	0	280	131	406	455	KAI4222665.1 MAG: hypothetical protein L6R36_005973 [Xanthoria steineri]	diamond	150	86.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Teloschistales	Teloschistaceae	Xanthoria	Xanthoria steineri
28971948	28971948	PRJNA506002_S_NODE_26748_length_318_cov_1.885714_g26502_i0	PRJNA506002	26748	318	1.885714	5.99657052	Aspergillus cristatus	573508	Fungi	Fungi	43.9	0.0311	NR	ODM23100.1	573508	g26502	i0	48.8	0.405660377358491	43	22	40.6	0	311	183	274	316	ODM23100.1 hypothetical protein SI65_00689 [Aspergillus cristatus]	diamond	129	43.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus cristatus
30993433	30993433	PRJNA506002_S_NODE_59414_length_248_cov_0.880000_g59168_i0	PRJNA506002	59414	248	0.88	2.1824	Phialemonium thermophilum	223376	Fungi	Fungi	78.2	2.77e-16	NR	KAL1864071.1	223376	g59168	i0	56.9	0.701612903225806	58	17	70.2	1	247	74	82	131	KAL1864071.1 hypothetical protein VTK73DRAFT_6161 [Phialemonium thermophilum]	diamond	174	78.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Cephalothecales	Cephalothecaceae	Phialemonium	Phialemonium thermophilum
31815466	31815466	PRJNA506002_S_NODE_53317_length_255_cov_2.401099_g53071_i0	PRJNA506002	53317	255	2.401099	6.12280245	Sarocladium strictum	5046	Fungi	Fungi	159	2.97e-44	NR	KAK0389832.1	5046	g53071	i0	94.1	1	85	5	100	0	1	255	97	181	KAK0389832.1 hypothetical protein NLU13_3405 [Sarocladium strictum]	diamond	255	159	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum

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