metadata: contig_metadata: 18 rows where bioproject = "PRJNA1085664" and tax

18 rows where bioproject = "PRJNA1085664" 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
193542	193542	PRJNA1085664_S_NODE_26221_length_172_cov_5.224806_g25802_i0	PRJNA1085664	26221	172	5.224806	8.98666632	Ascoidea rubescens	54195	Fungi	Fungi	60.2	8.62e-5	NTclustered	gi\|1147181152\|ref\|XM_020192680.1\|	1344418	g25802	i0	94.737	0.22093023255814	38	2	22	0	96	133	2735	2772	Ascoidea rubescens DSM 1968 uncharacterized protein (ASCRUDRAFT_74425), mRNA	blastn	38	60.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Ascoideales	Ascoideaceae	Ascoidea	Ascoidea rubescens
193572	193572	PRJNA1085664_S_NODE_33241_length_155_cov_1.258929_g32822_i0	PRJNA1085664	33241	155	1.258929	1.95133995	Malassezia restricta	76775	Fungi	Fungi	270	3.23e-68	NTclustered	gi\|1546632162\|ref\|XM_027627741.1\|	76775	g32822	i0	98.065	1	155	3	100	0	1	155	2105	2259	Malassezia restricta heat shock 70kDa protein 4 (MRET_1114), partial mRNA	blastn	155	270	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
2744243	2744243	PRJNA1085664_S_NODE_24423_length_178_cov_1.555556_g24004_i0	PRJNA1085664	24423	178	1.555556	2.76888968	Suillus luteus	5384	Fungi	Fungi	52.8	0.015	NTclustered	gi\|998623171\|emb\|LN999935.1\|	5384	g24004	i0	100	0.157303370786517	28	0	16	0	151	178	30	3	Suillus luteus mRNA for Isocitrate lyase (ICL gene), isolate sp9	blastn	28	52.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Suillaceae	Suillus	Suillus luteus
4020139	4020139	PRJNA1085664_S_NODE_30984_length_160_cov_1.153846_g30565_i0	PRJNA1085664	30984	160	1.153846	1.8461536	Malassezia restricta	76775	Fungi	Fungi	285	1.2e-72	NTclustered	gi\|1546635837\|ref\|XM_027629561.1\|	76775	g30565	i0	98.75	1	160	2	100	0	1	160	1299	1140	Malassezia restricta tyrosyl-tRNA synthetase (MRET_2934), partial mRNA	blastn	160	285	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
6571427	6571427	PRJNA1085664_S_NODE_21166_length_190_cov_1.918367_g20747_i0	PRJNA1085664	21166	190	1.918367	3.6448973	Psilocybe cubensis	181762	Fungi	Fungi	145	2.6199999999999997e-30	NTclustered	gi\|2234837769\|ref\|XM_047887730.1\|	181762	g20747	i0	87.805	8.63157894736842	123	15	65	0	1	123	469	591	Psilocybe cubensis uncharacterized protein (JR316_0001932), partial mRNA	blastn	1640	145	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Strophariaceae	Psilocybe	Psilocybe cubensis
10396823	10396823	PRJNA1085664_S_NODE_13289_length_238_cov_2.548718_g12870_i0	PRJNA1085664	13289	238	2.548718	6.06594884	Hericium alpestre	135208	Fungi	Fungi	56.5	0.002	NTclustered	gi\|2489641794\|ref\|NC_073556.1\|	135208	g12870	i0	96.97	0.714285714285714	33	1	14	0	31	63	27974	27942	Hericium alpestre mitochondrion, complete genome	blastn	170	56.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Hericiaceae	Hericium	Hericium alpestre
12496130	12496130	PRJNA1085664_S_NODE_10410_length_269_cov_3.659292_g9991_i0	PRJNA1085664	10410	269	3.659292	9.84349548	Ascomycota	4890	Fungi	Fungi	449	7.48e-122	NTclustered	gi\|397208208\|gb\|JX175041.1\|	175245	g9991	i0	100	89.9814126394052	243	0	90	0	25	267	514	756	Uncultured fungus isolate FIGWASP 066 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	24205	453	0.991169977924945	Eukaryota	Opisthokonta	Fungi						uncultured fungus
16770501	16770501	PRJNA1085664_S_NODE_26594_length_171_cov_2.601562_g26175_i0	PRJNA1085664	26594	171	2.601562	4.44867102	Rhizopogon vinicolor	80600	Fungi	Fungi	54.7	0.004	NTclustered	gi\|1693287358\|ref\|NC_042699.1\|	80600	g26175	i0	87.5	0.280701754385965	48	4	28	2	92	139	75156	75201	Rhizopogon vinicolor mitochondrion, complete genome	blastn	48	54.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Rhizopogonaceae	Rhizopogon	Rhizopogon vinicolor
17595118	17595118	PRJNA1085664_S_NODE_18934_length_200_cov_1.426752_g18515_i0	PRJNA1085664	18934	200	1.426752	2.853504	Mycosphaerellales	2726947	Fungi	Fungi	318	1.55e-82	NTclustered	gi\|284159107\|gb\|GU214694.1\|	438378	g18515	i0	95.5	100	200	7	100	1	1	200	4136	4333	Ramularia uredinicola strain CPC 10813 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	20000	318	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Mycosphaerellaceae	Ramularia	Ramularia uredinicola
17595119	17595119	PRJNA1085664_S_NODE_19634_length_197_cov_1.220779_g19215_i0	PRJNA1085664	19634	197	1.220779	2.40493463	Agaricomycetes	155619	Fungi	Fungi	198	2.07e-46	NTclustered	gi\|636627976\|ref\|XM_008046932.1\|	717944	g19215	i0	84.772	52.5380710659898	197	30	100	0	1	197	385	581	Trametes versicolor FP-101664 SS1 manganese superoxide dismutase (TRAVEDRAFT_175708), partial mRNA	blastn	10350	198	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Trametes	Trametes versicolor
21870349	21870349	PRJNA1085664_S_NODE_18878_length_200_cov_2.248408_g18459_i0	PRJNA1085664	18878	200	2.248408	4.496816	Penicilliopsis zonata	41063	Fungi	Fungi	110	1.02e-19	NTclustered	gi\|1249078766\|ref\|XM_022724715.1\|	1073090	g18459	i0	87.368	6.79	95	12	48	0	7	101	197	291	Penicilliopsis zonata CBS 506.65 hypothetical protein (ASPZODRAFT_141064), partial mRNA	blastn	1358	110	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicilliopsis	Penicilliopsis zonata
26909357	26909357	PRJNA1085664_S_NODE_32522_length_156_cov_2.079646_g32103_i0	PRJNA1085664	32522	156	2.079646	3.24424776	Imleria badia	36058	Fungi	Fungi	79.7	8.14e-18	NR	KAF8548603.1	36058	g32103	i0	65.4	4	52	17	100	1	156	1	31	81	KAF8548603.1 hypothetical protein OG21DRAFT_705673 [Imleria badia]	diamond	624	79.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Boletaceae	Imleria	Imleria badia
27288733	27288733	PRJNA1085664_S_NODE_19603_length_197_cov_1.266234_g19184_i0	PRJNA1085664	19603	197	1.266234	2.49448098	Hydnum rufescens UP5	139363	Fungi	Fungi	45.8	5.58e-4	NR	KAF9516900.1	1448309	g19184	i0	59	0.593908629441624	39	15	59.4	1	2	118	93	130	KAF9516900.1 hypothetical protein BS47DRAFT_1340198 [Hydnum rufescens UP504]	diamond	117	45.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Hydnaceae	Hydnum	Hydnum rufescens
27352216	27352216	PRJNA1085664_S_NODE_22443_length_185_cov_1.352113_g22024_i0	PRJNA1085664	22443	185	1.352113	2.50140905	Apiospora arundinis	335852	Fungi	Fungi	42.4	0.0225	NR	KAK6815822.1	335852	g22024	i0	41.2	0.827027027027027	51	21	68.1	1	39	164	132	182	KAK6815822.1 hypothetical protein PG987_016588 [Apiospora arundinis]	diamond	153	42.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Amphisphaeriales	Apiosporaceae	Apiospora	Apiospora arundinis
27659385	27659385	PRJNA1085664_S_NODE_22424_length_185_cov_1.514085_g22005_i0	PRJNA1085664	22424	185	1.514085	2.80105725	root	1	Root_unresolved	Root_unresolved	41.6	0.0433	NR	KAI9511695.1	71964	g22005	i0	29.6	1.63783783783784	54	36	84.3	1	29	184	140	193	KAI9511695.1 hypothetical protein F5148DRAFT_974774 [Russula earlei]	diamond	303	41.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Russulaceae	Russula	Russula earlei
29341278	29341278	PRJNA1085664_S_NODE_28229_length_167_cov_1.137097_g27810_i0	PRJNA1085664	28229	167	1.137097	1.89895199	Eutypa lata UCREL1	1287681	Fungi	Fungi	87	2.8e-18	NR	EMR61791.1	1287681	g27810	i0	93	0.772455089820359	43	3	77.2	0	3	131	416	458	EMR61791.1 putative major facilitator superfamily transporter protein [Eutypa lata UCREL1]	diamond	129	87	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Xylariales	Diatrypaceae	Eutypa	Eutypa lata
31900809	31900809	PRJNA1085664_S_NODE_29717_length_163_cov_1.175000_g29298_i0	PRJNA1085664	29717	163	1.175	1.91525	Clavulina sp. PMI_39	1745192	Fungi	Fungi	49.3	6.12e-5	NR	KAF8309361.1	1486700	g29298	i0	57.8	0.828220858895706	45	17	79.1	1	5	133	308	352	KAF8309361.1 Aldo/keto reductase [Clavulina sp. PMI_390]	diamond	135	49.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Hydnaceae	Clavulina	Clavulina sp. PMI_390
31932344	31932344	PRJNA1085664_S_NODE_17817_length_206_cov_1.680982_g17398_i0	PRJNA1085664	17817	206	1.680982	3.46282292	Clavulina sp. PMI_39	1745192	Fungi	Fungi	108	1.9699999999999999e-28	NR	KAF8310259.1	1486700	g17398	i0	83.6	0.800970873786408	55	9	80.1	0	206	42	71	125	KAF8310259.1 hypothetical protein DL93DRAFT_2062186, partial [Clavulina sp. PMI_390]	diamond	165	108	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Hydnaceae	Clavulina	Clavulina sp. PMI_390

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