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

12 rows where bioproject = "PRJNA1085664" 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
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
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
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
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
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
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);;