metadata: contig_metadata: 27 rows where bioproject = "PRJNA1192965" and tax

27 rows where bioproject = "PRJNA1192965" 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
2317738	2317738	PRJNA1192965_P_NODE_2162_length_291_cov_1.944954_g2143_i0	PRJNA1192965	2162	291	1.944954	5.65981614	Basidiomycota	5204	Fungi	Fungi	538	1.6999999999999994e-148	NTclustered	gi\|915512619\|gb\|KP825402.1\|	76775	g2143	i0	100	99.7766323024055	291	0	100	0	1	291	321	31	Malassezia restricta strain ISOSEB46F 28S ribosomal RNA gene, partial sequence	blastn	29035	538	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
2317741	2317741	PRJNA1192965_P_NODE_4122_length_246_cov_1.433526_g4103_i0	PRJNA1192965	4122	246	1.433526	3.52647396	Fungi	4751	Fungi	Fungi	324	4.26e-84	NTclustered	gi\|1546635598\|ref\|XR_003525370.1\|	76775	g4103	i0	99.438	96.3821138211382	178	1	100	0	1	178	3188	3011	Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA	blastn	23710	324	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
6698385	6698385	PRJNA1192965_P_NODE_686_length_451_cov_4.605820_g667_i0	PRJNA1192965	686	451	4.60582	20.7722482	uncultured Filobasidiella	1503101	Fungi	Fungi	734	0	NTclustered	gi\|387156411\|emb\|HE806144.1\|	1503101	g667	i0	96.009	150.055432372506	451	18	100	0	1	451	1870	1420	Uncultured Filobasidiella partial 26S rRNA gene, clone Ao0Yyyy6	blastn	67675	734	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Tremellaceae		uncultured Filobasidiella
7420279	7420279	PRJNA1192965_P_NODE_2466_length_279_cov_1.800971_g2447_i0	PRJNA1192965	2466	279	1.800971	5.02470909	Naganishia	1851509	Fungi	Fungi	516	7.58e-142	NTclustered	gi\|2075621922\|gb\|MZ686247.1\|	92953	g2447	i0	100	99.9784946236559	279	0	100	0	1	279	320	598	Naganishia albidosimilis strain CPCC 300377 large subunit ribosomal RNA gene, partial sequence	blastn	27894	516	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Naganishia	Naganishia albidosimilis
11245694	11245694	PRJNA1192965_P_NODE_5329_length_226_cov_3.725490_g5310_i0	PRJNA1192965	5329	226	3.72549	8.4196074	Agaricomycetes	155619	Fungi	Fungi	263	8.54e-66	NTclustered	gi\|1866609494\|gb\|MT732083.1\|	281719	g5310	i0	87.665	142.712389380531	227	26	99	2	2	226	681	455	Polyozellus multiplex voucher TU115322 large subunit ribosomal RNA gene, partial sequence	blastn	32253	263	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Thelephorales	Thelephoraceae	Polyozellus	Polyozellus multiplex
11799085	11799085	PRJNA1192965_P_NODE_4050_length_247_cov_0.885057_g4031_i0	PRJNA1192965	4050	247	0.885057	2.18609079	Malassezia restricta	76775	Fungi	Fungi	451	1.88e-122	NTclustered	gi\|1546637617\|ref\|XM_027630450.1\|	76775	g4031	i0	99.595	1	247	1	100	0	1	247	460	706	Malassezia restricta peroxin-16 (MRET_3823), partial mRNA	blastn	247	451	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
11799101	11799101	PRJNA1192965_P_NODE_990_length_391_cov_1.610063_g971_i0	PRJNA1192965	990	391	1.610063	6.29534633	Malassezia restricta	76775	Fungi	Fungi	717	0	NTclustered	gi\|1546635598\|ref\|XR_003525370.1\|	76775	g971	i0	99.745	106.757033248082	392	0	100	1	1	391	1872	1481	Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA	blastn	41742	717	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
15623294	15623294	PRJNA1192965_P_NODE_3593_length_250_cov_0.870056_g3574_i0	PRJNA1192965	3593	250	0.870056	2.17514	Lactarius vividus	1740625	Fungi	Fungi	117	5.85e-31	NR	KAH9067916.1	1740625	g3574	i0	74.7	2.556	79	20	94.8	0	237	1	15	93	KAH9067916.1 ribosomal protein S11-domain-containing protein [Lactarius vividus]	diamond	639	117	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Russulaceae	Lactarius	Lactarius vividus
18893842	18893842	PRJNA1192965_P_NODE_1615_length_324_cov_3.027888_g1596_i0	PRJNA1192965	1615	324	3.027888	9.81035712	Naganishia	1851509	Fungi	Fungi	599	8.67e-167	NTclustered	gi\|2715816871\|dbj\|LC810246.1\|	92952	g1596	i0	100	98.6697530864197	324	0	100	0	1	324	908	585	Naganishia adeliensis NIPR-00477 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2 and 28S rRNA, partial and complete sequence	blastn	31969	599	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Naganishia	Naganishia adeliensis
19446552	19446552	PRJNA1192965_P_NODE_4316_length_245_cov_0.895349_g4297_i0	PRJNA1192965	4316	245	0.895349	2.19360505	Malassezia restricta	76775	Fungi	Fungi	453	5.1900000000000006e-123	NTclustered	gi\|1546632854\|ref\|XM_027628087.1\|	76775	g4297	i0	100	1	245	0	100	0	1	245	852	1096	Malassezia restricta AHNAK nucleoprotein (MRET_1460), partial mRNA	blastn	245	453	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
19446555	19446555	PRJNA1192965_P_NODE_4936_length_242_cov_0.911243_g4917_i0	PRJNA1192965	4936	242	0.911243	2.20520806	Pseudozyma hubeiensis	327079	Fungi	Fungi	124	4.55e-24	NTclustered	gi\|808369283\|ref\|XM_012334538.1\|	1305764	g4917	i0	92.045	29.095041322314	88	7	36	0	155	242	444	357	Pseudozyma hubeiensis SY62 LSU ribosomal protein L19E partial mRNA	blastn	7041	124	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Ustilaginales	Ustilaginaceae	Pseudozyma	Pseudozyma hubeiensis
20168656	20168656	PRJNA1192965_P_NODE_2576_length_275_cov_1.232673_g2557_i0	PRJNA1192965	2576	275	1.232673	3.38985075	Opisthokonta	33154	Fungi	Fungi	492	1.26e-134	NTclustered	gi\|1546635598\|ref\|XR_003525370.1\|	76775	g2557	i0	98.909	92.3854545454546	275	3	100	0	1	275	425	699	Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA	blastn	25406	492	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
20721875	20721875	PRJNA1192965_P_NODE_3697_length_249_cov_0.875000_g3678_i0	PRJNA1192965	3697	249	0.875	2.17875	Cryptococcus neoformans	5207	Fungi	Fungi	460	3.16e-125	NTclustered	gi\|799327353\|ref\|XM_012193879.1\|	235443	g3678	i0	100	11.9598393574297	249	0	100	0	1	249	520	272	Cryptococcus neoformans var. grubii H99 hypothetical protein (CNAG_01031), mRNA	blastn	2978	460	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Cryptococcus	Cryptococcus neoformans
21997223	21997223	PRJNA1192965_P_NODE_2058_length_297_cov_2.062500_g2039_i0	PRJNA1192965	2058	297	2.0625	6.125625	Cryptococcus neoformans	5207	Fungi	Fungi	296	1.15e-75	NTclustered	gi\|799318120\|ref\|XM_012191959.1\|	235443	g2039	i0	84.797	97.4680134680135	296	43	99	2	3	297	486	192	Cryptococcus neoformans var. grubii H99 peptidyl-prolyl cis-trans isomerase (CNAG_03627), mRNA	blastn	28948	296	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Cryptococcus	Cryptococcus neoformans
23994514	23994514	PRJNA1192965_P_NODE_3999_length_247_cov_0.885057_g3980_i0	PRJNA1192965	3999	247	0.885057	2.18609079	Malassezia	55193	Fungi	Fungi	457	4.05e-124	NTclustered	gi\|1321659621\|gb\|KY911094.1\|	76775	g3980	i0	100	64.7044534412955	247	0	100	0	1	247	33516	33270	Malassezia restricta mitochondrion, complete genome	blastn	15982	457	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
27281153	27281153	PRJNA1192965_P_NODE_1963_length_303_cov_1.339130_g1944_i0	PRJNA1192965	1963	303	1.33913	4.0575639	Fungi	4751	Fungi	Fungi	83.2	3.65e-18	NR	KAL0953612.1	104357	g1944	i0	64.1	11.4356435643564	64	23	63.4	0	7	198	1	64	KAL0953612.1 hypothetical protein HGRIS_004820 [Hohenbuehelia grisea]	diamond	3465	83.6	0.995215311004785	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pleurotaceae	Hohenbuehelia	Hohenbuehelia grisea
27325259	27325259	PRJNA1192965_P_NODE_4003_length_247_cov_0.885057_g3984_i0	PRJNA1192965	4003	247	0.885057	2.18609079	Plicaturopsis crispa FD-325 SS-3	944288	Fungi	Fungi	60.8	1.58e-8	NR	KII85375.1	944288	g3984	i0	54	1.12955465587045	50	23	60.7	0	3	152	52	101	KII85375.1 hypothetical protein PLICRDRAFT_668004 [Plicaturopsis crispa FD-325 SS-3]	diamond	279	60.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Amylocorticiales	Amylocorticiaceae	Plicatura	Plicatura crispa
27376178	27376178	PRJNA1192965_P_NODE_3683_length_249_cov_0.875000_g3664_i0	PRJNA1192965	3683	249	0.875	2.17875	Agaricales	5338	Fungi	Fungi	44.7	0.00863	NR	KAF9071749.1	206335	g3664	i0	42.6	2.75903614457831	61	33	71.1	1	196	20	1231	1291	KAF9071749.1 hypothetical protein BDP27DRAFT_1262427 [Rhodocollybia butyracea]	diamond	687	44.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Omphalotaceae	Rhodocollybia	Rhodocollybia butyracea
27881047	27881047	PRJNA1192965_P_NODE_4565_length_244_cov_0.900585_g4546_i0	PRJNA1192965	4565	244	0.900585	2.1974274	root	1	Root_unresolved	Root_unresolved	46.6	9.55e-4	NR	KAJ6494969.1	1033282	g4546	i0	35.3	5.07786885245902	85	42	88.5	2	239	24	16	100	KAJ6494969.1 peptidyl-tRNA hydrolase [Mycena vulgaris]	diamond	1239	47	0.991489361702128	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena vulgaris
28146422	28146422	PRJNA1192965_P_NODE_4545_length_244_cov_0.900585_g4526_i0	PRJNA1192965	4545	244	0.900585	2.1974274	Serendipita indica DSM 11827	1109443	Fungi	Fungi	62.8	5.89e-11	NR	CCA73580.1	1109443	g4526	i0	67.6	0.454918032786885	37	12	45.5	0	9	119	1	37	CCA73580.1 hypothetical protein PIIN_07532 [Serendipita indica DSM 11827]	diamond	111	62.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Sebacinales	Serendipitaceae	Serendipita	Serendipita indica
29238858	29238858	PRJNA1192965_P_NODE_5009_length_242_cov_0.911243_g4990_i0	PRJNA1192965	5009	242	0.911243	2.20520806	Wallemia	148959	Fungi	Fungi	42.4	0.0488	NR	XP_006957814.1	671144	g4990	i0	30.9	1.36363636363636	55	38	68.2	0	171	7	313	367	XP_006957814.1 hypothetical protein WALSEDRAFT_60126 [Wallemia mellicola CBS 633.66]	diamond	330	42.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Wallemiomycetes	Wallemiales	Wallemiaceae	Wallemia	Wallemia mellicola
29901973	29901973	PRJNA1192965_P_NODE_3731_length_249_cov_0.875000_g3712_i0	PRJNA1192965	3731	249	0.875	2.17875	Opisthokonta	33154	Fungi	Fungi	92.4	1.16e-19	NR	KAJ3500756.1	84603	g3712	i0	62.3	7.68674698795181	69	25	81.9	1	30	233	89	157	KAJ3500756.1 hypothetical protein NLJ89_g9648 [Agrocybe chaxingu]	diamond	1914	92.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Strophariaceae	Agrocybe	Agrocybe chaxingu
29946085	29946085	PRJNA1192965_P_NODE_2531_length_277_cov_1.225490_g2512_i0	PRJNA1192965	2531	277	1.22549	3.3946073	Sphagnurus paluster	117069	Fungi	Fungi	145	4.67e-38	NR	KAG5639558.1	117069	g2512	i0	70.7	5.97833935018051	92	27	99.6	0	2	277	989	1080	KAG5639558.1 hypothetical protein H0H81_012229 [Sphagnurus paluster]	diamond	1656	145	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Lyophyllaceae	Sphagnurus	Sphagnurus paluster
30609342	30609342	PRJNA1192965_P_NODE_3533_length_250_cov_0.870056_g3514_i0	PRJNA1192965	3533	250	0.870056	2.17514	Saitozyma podzolica	1890683	Fungi	Fungi	42.7	0.0426	NR	RSH85214.1	1890683	g3514	i0	46.2	0.78	65	30	74.4	2	62	247	794	856	RSH85214.1 MutS-like protein [Saitozyma podzolica]	diamond	195	42.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Trimorphomycetaceae	Saitozyma	Saitozyma podzolica
30849659	30849659	PRJNA1192965_P_NODE_2754_length_268_cov_1.579487_g2735_i0	PRJNA1192965	2754	268	1.579487	4.23302516	Malassezia	55193	Fungi	Fungi	118	1.55e-28	NR	XP_017992035.1	77020	g2735	i0	67.4	8.83208955223881	89	29	99.6	0	2	268	402	490	XP_017992035.1 copper p-type atpase [Malassezia pachydermatis]	diamond	2367	118	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia pachydermatis
31873986	31873986	PRJNA1192965_P_NODE_3937_length_247_cov_1.660920_g3918_i0	PRJNA1192965	3937	247	1.66092	4.1024724	Malassezia vespertilionis	2020962	Fungi	Fungi	61.6	4.34e-9	NR	XP_056063886.1	2020962	g3918	i0	42.9	4.21457489878543	70	40	85	0	247	38	9	78	XP_056063886.1 lysophospholipase [Malassezia vespertilionis]	diamond	1041	61.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia vespertilionis
32285695	32285695	PRJNA1192965_P_NODE_979_length_392_cov_6.131661_g960_i0	PRJNA1192965	979	392	6.131661	24.03611112	Tulasnella sp. 417	2600225	Fungi	Fungi	110	5.13e-28	NR	KAG8920536.1	2600225	g960	i0	47.5	2.70918367346939	122	64	93.4	0	8	373	6	127	KAG8920536.1 ribosomal protein S24A [Tulasnella sp. 417]	diamond	1062	110	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Tulasnellaceae	Tulasnella	Tulasnella sp. 417

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