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

19 rows where bioproject = "PRJNA685060" and tax_phylum = "Basidiomycota"

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
1176003	1176003	PRJNA685060_P_NODE_10701_length_287_cov_3.359813_g10611_i0	PRJNA685060	10701	287	3.359813	9.64266331	Opisthokonta	33154	Fungi	Fungi	531	2.799999999999999e-146	NTclustered	gi\|915512607\|gb\|KP825390.1\|	76775	g10611	i0	100	100.094076655052	287	0	100	0	1	287	519	233	Malassezia restricta strain ISOSEB19F 28S ribosomal RNA gene, partial sequence	blastn	28727	531	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
1942122	1942122	PRJNA685060_P_NODE_15142_length_247_cov_0.885057_g15052_i0	PRJNA685060	15142	247	0.885057	2.18609079	Malassezia restricta	76775	Fungi	Fungi	435	1.9e-117	NTclustered	gi\|1546637903\|ref\|XM_027630593.1\|	76775	g15052	i0	98.381	1	247	4	100	0	1	247	2445	2199	Malassezia restricta phospholipid-translocating ATPase (MRET_3966), partial mRNA	blastn	247	435	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
3217011	3217011	PRJNA685060_P_NODE_13563_length_251_cov_0.865169_g13473_i0	PRJNA685060	13563	251	0.865169	2.17157419	Malassezia restricta	76775	Fungi	Fungi	353	5.569999999999998e-93	NTclustered	gi\|1546630269\|ref\|XM_027626795.1\|	76775	g13473	i0	92.063	1.78486055776892	252	19	100	1	1	251	341	592	Malassezia restricta centractin (MRET_0168), partial mRNA	blastn	448	353	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
4494032	4494032	PRJNA685060_P_NODE_11584_length_275_cov_0.881188_g11494_i0	PRJNA685060	11584	275	0.881188	2.423267	Malassezia restricta	76775	Fungi	Fungi	479	9.78e-131	NTclustered	gi\|1546635598\|ref\|XR_003525370.1\|	76775	g11494	i0	98.182	103.061818181818	275	4	100	1	1	275	1915	1642	Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA	blastn	28342	479	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
5769788	5769788	PRJNA685060_P_NODE_15185_length_247_cov_0.885057_g15095_i0	PRJNA685060	15185	247	0.885057	2.18609079	Malassezia psittaci	1821823	Fungi	Fungi	157	1.01e-44	NR	WFD42707.1	1821823	g15095	i0	82.9	1.9919028340081	82	14	99.6	0	1	246	19	100	WFD42707.1 branched-chain-amino-acid transaminase [Malassezia psittaci]	diamond	492	157	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia psittaci
8319312	8319312	PRJNA685060_P_NODE_5367_length_415_cov_1.178363_g5277_i0	PRJNA685060	5367	415	1.178363	4.89020645	Cronartium quercuum f. sp. fusiforme G11	708437	Fungi	Fungi	54.3	1.94e-5	NR	KAG0146896.1	708437	g5277	i0	37.5	0.867469879518072	120	65	86.7	4	2	361	257	366	KAG0146896.1 hypothetical protein CROQUDRAFT_656691 [Cronartium quercuum f. sp. fusiforme G11]	diamond	360	54.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Coleosporiaceae	Cronartium	Cronartium quercuum
13420162	13420162	PRJNA685060_P_NODE_6151_length_386_cov_0.984026_g6061_i0	PRJNA685060	6151	386	0.984026	3.79834036	Malassezia restricta	76775	Fungi	Fungi	641	1.72e-179	NTclustered	gi\|1546635598\|ref\|XR_003525370.1\|	76775	g6061	i0	96.658	106.813471502591	389	8	100	5	1	386	1501	1887	Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA	blastn	41230	641	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
14695125	14695125	PRJNA685060_P_NODE_16712_length_243_cov_0.905882_g16622_i0	PRJNA685060	16712	243	0.905882	2.20129326	Malassezia restricta	76775	Fungi	Fungi	431	2.4099999999999995e-116	NTclustered	gi\|1546636529\|ref\|XM_027629907.1\|	76775	g16622	i0	99.163	0.983539094650206	239	2	98	0	5	243	1	239	Malassezia restricta protoheme IX farnesyltransferase, mitochondrial (MRET_3280), partial mRNA	blastn	239	431	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
17244174	17244174	PRJNA685060_P_NODE_7714_length_343_cov_1.040741_g7624_i0	PRJNA685060	7714	343	1.040741	3.56974163	Vanrija pseudolonga	143232	Fungi	Fungi	58.4	6.97e-4	NTclustered	gi\|2669736302\|ref\|XM_062769985.1\|	143232	g7624	i0	97.059	0.551020408163265	34	1	10	0	170	203	591	624	Vanrija pseudolonga uncharacterized protein (LOC62_02G003451), partial mRNA	blastn	189	58.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Trichosporonales	Trichosporonaceae	Vanrija	Vanrija pseudolonga
18518249	18518249	PRJNA685060_P_NODE_17635_length_241_cov_0.916667_g17545_i0	PRJNA685060	17635	241	0.916667	2.20916747	Malassezia restricta	76775	Fungi	Fungi	446	8.519999999999999e-121	NTclustered	gi\|1546634612\|ref\|XM_027628966.1\|	76775	g17545	i0	100	1	241	0	100	0	1	241	320	80	Malassezia restricta KH domain protein (MRET_2339), partial mRNA	blastn	241	446	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
23618979	23618979	PRJNA685060_P_NODE_11319_length_278_cov_1.878049_g11229_i0	PRJNA685060	11319	278	1.878049	5.22097622	Malassezia restricta	76775	Fungi	Fungi	507	4.54e-139	NTclustered	gi\|1546635598\|ref\|XR_003525370.1\|	76775	g11229	i0	99.639	73.3597122302158	277	1	99	0	2	278	3285	3009	Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA	blastn	20394	507	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
23618983	23618983	PRJNA685060_P_NODE_1199_length_903_cov_9.006024_g1128_i0	PRJNA685060	1199	903	9.006024	81.32439672	Tilletiopsis washingtonensis	58919	Fungi	Fungi	388	6.119999999999998e-103	NTclustered	gi\|1423587035\|ref\|XM_025743209.1\|	58919	g1128	i0	79.815	18.6744186046512	540	103	59	6	106	642	55	591	Tilletiopsis washingtonensis putative GSP1-GTP-binding protein of the ras superfamily (FA09DRAFT_331860), mRNA	blastn	16863	388	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Entylomatales		Tilletiopsis	Tilletiopsis washingtonensis
27030519	27030519	PRJNA685060_P_NODE_11782_length_272_cov_1.261307_g11692_i0	PRJNA685060	11782	272	1.261307	3.43075504	Polyporaceae	5317	Fungi	Fungi	67.4	1.1e-10	NR	KAI0778305.1	526244	g11692	i0	33.7	4.88602941176471	89	59	98.2	0	6	272	332	420	KAI0778305.1 WD40 repeat-like protein [Trametes elegans]	diamond	1329	67.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Trametes	Trametes elegans
27651000	27651000	PRJNA685060_P_NODE_15064_length_247_cov_0.885057_g14974_i0	PRJNA685060	15064	247	0.885057	2.18609079	Malassezia cuniculi	948313	Fungi	Fungi	58.2	1.24e-7	NR	WFD33679.1	948313	g14974	i0	40	6.41295546558704	75	42	87.4	1	22	237	127	201	WFD33679.1 multicatalytic endopeptidase [Malassezia cuniculi]	diamond	1584	58.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia cuniculi
27662625	27662625	PRJNA685060_P_NODE_6724_length_367_cov_1.574830_g6634_i0	PRJNA685060	6724	367	1.57483	5.7796261	root	1	Root_unresolved	Root_unresolved	88.6	1.27e-17	NR	KAI7956600.1	168172	g6634	i0	40	2.86103542234332	120	70	97.3	2	6	362	332	450	KAI7956600.1 hypothetical protein MJO28_003695 [Puccinia striiformis f. sp. tritici]	diamond	1050	89	0.995505617977528	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Pucciniomycetes	Pucciniales	Pucciniaceae	Puccinia	Puccinia striiformis
28787338	28787338	PRJNA685060_P_NODE_14207_length_249_cov_0.875000_g14117_i0	PRJNA685060	14207	249	0.875	2.17875	Trametes polyzona	239206	Fungi	Fungi	112	1.24e-26	NR	KAI0636032.1	239206	g14117	i0	61	6.69879518072289	82	32	98.8	0	248	3	595	676	KAI0636032.1 exonuclease II [Trametes polyzona]	diamond	1668	112	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Trametes	Trametes polyzona
30019189	30019189	PRJNA685060_P_NODE_12091_length_268_cov_1.056410_g12001_i0	PRJNA685060	12091	268	1.05641	2.8311788	Mycena leptocephala	230808	Fungi	Fungi	48.5	4.72e-4	NR	KAJ7938234.1	230808	g12001	i0	48.6	0.414179104477612	37	19	41.4	0	124	234	224	260	KAJ7938234.1 DNA cross-link repair protein pso2/snm1 [Mycena leptocephala]	diamond	111	48.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena leptocephala
31547734	31547734	PRJNA685060_P_NODE_15716_length_245_cov_1.011628_g15626_i0	PRJNA685060	15716	245	1.011628	2.4784886	Fungi	4751	Fungi	Fungi	49.3	1.85e-4	NR	KAF7302313.1	658473	g15626	i0	52	1.2734693877551	50	24	61.2	0	94	243	8	57	KAF7302313.1 Carboxylic ester hydrolase [Mycena chlorophos]	diamond	312	49.7	0.991951710261569	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena chlorophos
31725635	31725635	PRJNA685060_P_NODE_14257_length_249_cov_0.875000_g14167_i0	PRJNA685060	14257	249	0.875	2.17875	Rhizoctonia solani	456999	Fungi	Fungi	167	1.05e-50	NR	CAE6486386.1	456999	g14167	i0	93.9	4	82	5	98.8	0	248	3	8	89	CAE6486386.1 unnamed protein product, partial [Rhizoctonia solani]	diamond	996	167	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Rhizoctonia	Rhizoctonia solani

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