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

12 rows where bioproject = "PRJDB14274" 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
8584	8584	PRJDB14274_S_NODE_7701_length_229_cov_0.922619_g7623_i0	PRJDB14274	7701	229	0.922619	2.11279751	Laccaria bicolor	29883	Fungi	Fungi	60.2	1.22e-4	NTclustered	gi\|170106298\|ref\|XM_001884326.1\|	486041	g7623	i0	97.143	0.152838427947598	35	1	15	0	131	165	625	591	Laccaria bicolor S238N-H82 uncharacterized protein (LACBIDRAFT_303903), partial mRNA	blastn	35	60.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Hydnangiaceae	Laccaria	Laccaria bicolor
5110980	5110980	PRJDB14274_S_NODE_5725_length_262_cov_1.253731_g5647_i0	PRJDB14274	5725	262	1.253731	3.28477522	Pseudozyma flocculosa	84751	Fungi	Fungi	54.7	0.007	NTclustered	gi\|630966689\|ref\|XM_007881562.1\|	1277687	g5647	i0	100	0.110687022900763	29	0	11	0	93	121	132	104	Pseudozyma flocculosa PF-1 uncharacterized protein (PFL1_04038), partial mRNA	blastn	29	54.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Ustilaginales	Ustilaginaceae	Pseudozyma	Pseudozyma flocculosa
11486468	11486468	PRJDB14274_S_NODE_6090_length_254_cov_2.062176_g6012_i0	PRJDB14274	6090	254	2.062176	5.23792704	Trichosporon asahii	82508	Fungi	Fungi	58.4	4.96e-4	NTclustered	gi\|930416156\|ref\|XM_014326876.1\|	1186058	g6012	i0	97.143	0.267716535433071	35	0	14	1	203	237	912	945	Trichosporon asahii var. asahii CBS 2479 uncharacterized protein (A1Q1_07892), partial mRNA	blastn	68	58.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Trichosporonales	Trichosporonaceae	Trichosporon	Trichosporon asahii
16585374	16585374	PRJDB14274_S_NODE_414_length_928_cov_5.076125_g370_i0	PRJDB14274	414	928	5.076125	47.10644	Tilletiopsis washingtonensis	58919	Fungi	Fungi	388	6.289999999999998e-103	NTclustered	gi\|1423587035\|ref\|XM_025743209.1\|	58919	g370	i0	79.815	18.1713362068966	540	103	58	6	296	832	591	55	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
16585390	16585390	PRJDB14274_S_NODE_8914_length_212_cov_1.841060_g8836_i0	PRJDB14274	8914	212	1.84106	3.9030472	Rhodotorula graminis	29898	Fungi	Fungi	204	4.86e-48	NTclustered	gi\|1069930902\|ref\|XM_018412876.1\|	578459	g8836	i0	87.931	80.5094339622642	174	19	82	2	40	212	1826	1654	Rhodotorula graminis WP1 uncharacterized protein (RHOBADRAFT_29596), mRNA	blastn	17068	204	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula graminis
20409190	20409190	PRJDB14274_S_NODE_9657_length_206_cov_1.655172_g9579_i0	PRJDB14274	9657	206	1.655172	3.40965432	Lentinus tigrinus	5365	Fungi	Fungi	143	1.04e-29	NTclustered	gi\|2797387783\|ref\|XM_067683197.1\|	1328758	g9579	i0	81.183	2.88834951456311	186	27	88	8	3	184	2721	2902	Lentinus tigrinus ALCF2SS1-7 26S proteasome regulatory complex, non-ATPase subcomplex, Rpn1 subunit (L226DRAFT_557747), mRNA	blastn	595	143	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Lentinus	Lentinus tigrinus
27411941	27411941	PRJDB14274_S_NODE_7403_length_233_cov_1.133721_g7325_i0	PRJDB14274	7403	233	1.133721	2.64156993	Malassezia pachydermatis	77020	Fungi	Fungi	45.8	0.00254	NR	XP_017994028.1	77020	g7325	i0	76	0.682403433476395	25	6	32.2	0	232	158	289	313	XP_017994028.1 trm8-part of complex required for 7-methylguanosine modification [Malassezia pachydermatis]	diamond	159	45.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia pachydermatis
29148657	29148657	PRJDB14274_S_NODE_8249_length_221_cov_1.218750_g8171_i0	PRJDB14274	8249	221	1.21875	2.6934375	Imleria badia	36058	Fungi	Fungi	76.6	3.18e-14	NR	KAF8557423.1	36058	g8171	i0	49.3	0.963800904977376	71	36	96.4	0	215	3	413	483	KAF8557423.1 PRMT5-domain-containing protein [Imleria badia]	diamond	213	76.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Boletaceae	Imleria	Imleria badia
31201031	31201031	PRJDB14274_S_NODE_4175_length_302_cov_1.597510_g4097_i0	PRJDB14274	4175	302	1.59751	4.8244802	Mycena vulgaris	1033282	Fungi	Fungi	43.9	0.0274	NR	KAJ6527347.1	1033282	g4097	i0	37.8	0.894039735099338	90	43	86.4	3	301	41	212	291	KAJ6527347.1 hypothetical protein DFH09DRAFT_1414366 [Mycena vulgaris]	diamond	270	43.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena vulgaris
31232882	31232882	PRJDB14274_S_NODE_6115_length_254_cov_1.331606_g6037_i0	PRJDB14274	6115	254	1.331606	3.38227924	Fomitiporia mediterranea MF3/22	694068	Fungi	Fungi	43.9	0.0164	NR	XP_007266028.1	694068	g6037	i0	41.8	0.649606299212598	55	31	65	1	81	245	5	58	XP_007266028.1 uncharacterized protein FOMMEDRAFT_167616 [Fomitiporia mediterranea MF3/22]	diamond	165	43.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Hymenochaetales	Hymenochaetaceae	Fomitiporia	Fomitiporia mediterranea
32308955	32308955	PRJDB14274_S_NODE_8939_length_212_cov_1.291391_g8861_i0	PRJDB14274	8939	212	1.291391	2.73774892	Kwoniella heveanensis BCC8398	1296120	Fungi	Fungi	42.4	0.0334	NR	OCF33127.1	1296120	g8861	i0	50	0.594339622641509	42	21	59.4	0	3	128	253	294	OCF33127.1 lysophosphatidate acyltransferase [Kwoniella heveanensis BCC8398]	diamond	126	42.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Kwoniella	Kwoniella heveanensis
32524572	32524572	PRJDB14274_S_NODE_7079_length_238_cov_1.367232_g7001_i0	PRJDB14274	7079	238	1.367232	3.25401216	Tulasnella	5240	Fungi	Fungi	105	1.35e-25	NR	KAG8919841.1	2600224	g7001	i0	64.4	5.53361344537815	73	26	92	0	19	237	106	178	KAG8919841.1 hypothetical protein FRC00_010845, partial [Tulasnella sp. 408]	diamond	1317	105	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Tulasnellaceae	Tulasnella	Tulasnella sp. 408

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