metadata: contig_metadata: 19 rows where bioproject = "PRJNA727760" and tax

19 rows where bioproject = "PRJNA727760" and tax_kingdom = "Fungi"

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
712648	712648	PRJNA727760_S_NODE_2721_length_277_cov_1.911765_g2693_i0	PRJNA727760	2721	277	1.911765	5.29558905	Malassezia globosa	76773	Fungi	Fungi	496	9.8e-136	NTclustered	gi\|164656572\|ref\|XM_001729362.1\|	425265	g2693	i0	98.917	1	277	3	100	0	1	277	597	873	Malassezia globosa CBS 7966 uncharacterized protein (MGL_3449), partial mRNA	blastn	277	496	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia globosa
1988714	1988714	PRJNA727760_S_NODE_2322_length_297_cov_2.089286_g2294_i0	PRJNA727760	2322	297	2.089286	6.20517942	Purpureocillium lilacinum	33203	Fungi	Fungi	544	3.7299999999999996e-150	NTclustered	gi\|2741354647\|ref\|XM_065601239.1\|	33203	g2294	i0	99.663	1	297	1	100	0	1	297	795	499	Purpureocillium lilacinum uncharacterized protein (PLICBS_007754), partial mRNA	blastn	297	544	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Ophiocordycipitaceae	Purpureocillium	Purpureocillium lilacinum
3263976	3263976	PRJNA727760_S_NODE_1663_length_357_cov_1.373239_g1635_i0	PRJNA727760	1663	357	1.373239	4.90246323	Pseudogymnoascus destructans	655981	Fungi	Fungi	108	7.11e-19	NTclustered	gi\|1370889069\|ref\|XM_024471176.1\|	655981	g1635	i0	82.258	0.34733893557423	124	22	35	0	232	355	799	676	Pseudogymnoascus destructans uncharacterized protein (VC83_07609), mRNA	blastn	124	108	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Thelebolales	Thelebolaceae	Pseudogymnoascus	Pseudogymnoascus destructans
5816325	5816325	PRJNA727760_S_NODE_1205_length_425_cov_1.551136_g1177_i0	PRJNA727760	1205	425	1.551136	6.592328	Metarhizium acridum	92637	Fungi	Fungi	364	4.629999999999998e-96	NTclustered	gi\|2749718875\|ref\|XM_066119671.1\|	92637	g1177	i0	98.086	48.9364705882353	209	4	49	0	217	425	1388	1180	Metarhizium acridum translation elongation factor EF-1 alpha (TEF1_1), partial mRNA	blastn	20798	364	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Clavicipitaceae	Metarhizium	Metarhizium acridum
10916745	10916745	PRJNA727760_S_NODE_2789_length_274_cov_1.164179_g2761_i0	PRJNA727760	2789	274	1.164179	3.18985046	Malassezia restricta	76775	Fungi	Fungi	350	7.97e-92	NTclustered	gi\|1546631199\|ref\|XM_027627260.1\|	76775	g2761	i0	100	48.8284671532847	189	0	69	0	86	274	387	199	Malassezia restricta large subunit ribosomal protein L40e (MRET_0633), partial mRNA	blastn	13379	350	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
12674369	12674369	PRJNA727760_S_NODE_2270_length_301_cov_1.561404_g2242_i0	PRJNA727760	2270	301	1.561404	4.69982604	Ascomycota	4890	Fungi	Fungi	556	4.87e-154	NTclustered	gi\|1473258532\|gb\|MH871476.1\|	5046	g2242	i0	100	100.013289036545	301	0	100	0	1	301	307	7	Sarocladium strictum culture CBS:376.70M strain CBS 376.70M large subunit ribosomal RNA gene, partial sequence	blastn	30104	556	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
14741723	14741723	PRJNA727760_S_NODE_3892_length_235_cov_2.888889_g3864_i0	PRJNA727760	3892	235	2.888889	6.78888915	Diaporthe batatas	748121	Fungi	Fungi	139	1.57e-28	NTclustered	gi\|2124358414\|ref\|XM_044782441.1\|	748121	g3864	i0	100	32.6255319148936	75	0	32	0	1	75	1004	1078	Diaporthe batatas guanine nucleotide-binding protein subunit beta (KVR01_001289), mRNA	blastn	7667	139	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Diaporthales	Diaporthaceae	Diaporthe	Diaporthe batatas
16015182	16015182	PRJNA727760_S_NODE_1413_length_388_cov_1.234921_g1385_i0	PRJNA727760	1413	388	1.234921	4.79149348	Colletotrichum destructivum	34406	Fungi	Fungi	370	9.01e-98	NTclustered	gi\|2670800169\|ref\|XM_062922625.1\|	34406	g1385	i0	90.034	61.6520618556701	291	21	75	8	25	315	240	522	Colletotrichum destructivum Putative cytochrome c, class IA/ IB, cytochrome c-like domain superfamily (CDEST_06466), mRNA	blastn	23921	370	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Glomerellales	Glomerellaceae	Colletotrichum	Colletotrichum destructivum
24939120	24939120	PRJNA727760_S_NODE_2600_length_282_cov_1.492823_g2572_i0	PRJNA727760	2600	282	1.492823	4.20976086	Malassezia globosa	76773	Fungi	Fungi	448	2.84e-121	NTclustered	gi\|164654895\|ref\|XM_001728534.1\|	425265	g2572	i0	95.374	4.49645390070922	281	13	99	0	2	282	618	338	Malassezia globosa CBS 7966 uncharacterized protein (MGL_4275), partial mRNA	blastn	1268	448	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia globosa
25421379	25421379	PRJNA727760_S_NODE_3220_length_257_cov_1.695652_g3192_i0	PRJNA727760	3220	257	1.695652	4.35782564	Pyricularia	48558	Fungi	Fungi	132	2.9200000000000003e-26	NTclustered	gi\|389639323\|ref\|XM_003717247.1\|	242507	g3192	i0	95.181	13.5525291828794	83	4	32	0	1	83	443	525	Pyricularia oryzae 70-15 histone H4 (MGG_06293), mRNA	blastn	3483	132	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Magnaporthales	Pyriculariaceae	Pyricularia	Pyricularia oryzae
27716103	27716103	PRJNA727760_S_NODE_2544_length_285_cov_1.561321_g2516_i0	PRJNA727760	2544	285	1.561321	4.44976485	Malassezia restricta CBS 7877	425264	Fungi	Fungi	118	6.229999999999999e-31	NR	AYO44820.1	425264	g2516	i0	71.1	0.947368421052632	90	26	94.7	0	283	14	61	150	AYO44820.1 heat shock protein GrpE [Malassezia restricta CBS 7877]	diamond	270	118	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
28104746	28104746	PRJNA727760_S_NODE_2505_length_288_cov_0.934884_g2477_i0	PRJNA727760	2505	288	0.934884	2.69246592	Microbotryomycetes	162481	Fungi	Fungi	60.5	6.06e-9	NR	GAA5898551.1	183962	g2477	i0	75.5	2.86458333333333	49	4	44.8	3	286	158	110	156	GAA5898551.1 hypothetical protein JCM6883_003349 [Sporobolomyces salmoneus]	diamond	825	60.8	0.995065789473684	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Sporobolomyces	Sporobolomyces salmoneus
29262618	29262618	PRJNA727760_S_NODE_2669_length_279_cov_1.893204_g2641_i0	PRJNA727760	2669	279	1.893204	5.28203916	Sarocladium strictum	5046	Fungi	Fungi	58.9	1.08e-7	NR	KAL2213322.1	5046	g2641	i0	47.8	0.741935483870968	69	25	67.7	2	12	200	325	388	KAL2213322.1 concanavalin A-like lectin/glucanase [Sarocladium strictum]	diamond	207	58.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
29767924	29767924	PRJNA727760_S_NODE_2491_length_288_cov_1.813953_g2463_i0	PRJNA727760	2491	288	1.813953	5.22418464	Knufia fluminis	191047	Fungi	Fungi	80.1	7.77e-17	NR	KAK5953335.1	191047	g2463	i0	62.8	0.8125	78	21	72.9	1	287	78	53	130	KAK5953335.1 hypothetical protein OHC33_005903 [Knufia fluminis]	diamond	234	80.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Trichomeriaceae	Knufia	Knufia fluminis
29926095	29926095	PRJNA727760_S_NODE_1631_length_361_cov_1.083333_g1603_i0	PRJNA727760	1631	361	1.083333	3.91083213	Purpureocillium lilacinum	33203	Fungi	Fungi	68.9	9.7e-11	NR	XP_018181215.1	33203	g1603	i0	89.1	0.914127423822715	55	6	45.7	0	361	197	813	867	XP_018181215.1 translation initiation factor 3 subunit c [Purpureocillium lilacinum]	diamond	330	68.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Ophiocordycipitaceae	Purpureocillium	Purpureocillium lilacinum
30431873	30431873	PRJNA727760_S_NODE_1193_length_429_cov_1.558989_g1165_i0	PRJNA727760	1193	429	1.558989	6.68806281	Sarocladium strictum	5046	Fungi	Fungi	137	6.74e-39	NR	KAK0385092.1	5046	g1165	i0	95.3	0.741258741258741	106	2	72	1	429	121	17	122	KAK0385092.1 hypothetical protein NLU13_7570 [Sarocladium strictum]	diamond	318	137	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
31157796	31157796	PRJNA727760_S_NODE_3375_length_252_cov_1.284916_g3347_i0	PRJNA727760	3375	252	1.284916	3.23798832	Talaromyces marneffei	37727	Fungi	Fungi	57	1.65e-8	NR	XP_054121538.1	37727	g3347	i0	46.4	0.821428571428571	69	34	82.1	1	252	46	8	73	XP_054121538.1 uncharacterized protein EYB26_006287 [Talaromyces marneffei]	diamond	207	57	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Trichocomaceae	Talaromyces	Talaromyces marneffei
31664041	31664041	PRJNA727760_S_NODE_3637_length_246_cov_0.901734_g3609_i0	PRJNA727760	3637	246	0.901734	2.21826564	Malassezia psittaci	1821823	Fungi	Fungi	60.5	7.19e-9	NR	WFD42247.1	1821823	g3609	i0	43	0.963414634146341	79	32	80.5	2	5	202	119	197	WFD42247.1 hypothetical protein MPSI1_000888 [Malassezia psittaci]	diamond	237	60.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia psittaci
31822168	31822168	PRJNA727760_S_NODE_2557_length_284_cov_3.322275_g2529_i0	PRJNA727760	2557	284	3.322275	9.435261	Sarocladium strictum	5046	Fungi	Fungi	92	3.8e-21	NR	KAK0386860.1	5046	g2529	i0	86.4	0.623239436619718	59	8	62.3	0	280	104	107	165	KAK0386860.1 hypothetical protein NLU13_5173 [Sarocladium strictum]	diamond	177	92	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);;