metadata: contig_metadata: 9 rows where bioproject = "PRJEB25789" and tax

9 rows where bioproject = "PRJEB25789" 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
1297552	1297552	PRJEB25789_S_NODE_6962_length_350_cov_1.111913_g6883_i0	PRJEB25789	6962	350	1.111913	3.8916955	Agaricales	5338	Fungi	Fungi	103	6.149999999999999e-23	NR	TFK36212.1	68775	g6883	i0	74.2	5.25428571428571	66	17	56.6	0	152	349	269	334	TFK36212.1 hypothetical protein BDQ12DRAFT_737074 [Crucibulum laeve]	diamond	1839	103	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Nidulariaceae	Crucibulum	Crucibulum laeve
15325256	15325256	PRJEB25789_S_NODE_13993_length_268_cov_2.323077_g13914_i0	PRJEB25789	13993	268	2.323077	6.22584636	Agaricus bisporus var. burnettii	192524	Fungi	Fungi	156	3.1699999999999995e-47	NR	KAF7770365.1	192524	g13914	i0	83.5	10.4440298507463	85	14	95.1	0	267	13	41	125	KAF7770365.1 hypothetical protein Agabi119p4_6339 [Agaricus bisporus var. burnettii]	diamond	2799	156	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Agaricaceae	Agaricus	Agaricus bisporus
15325393	15325393	PRJEB25789_S_NODE_20353_length_235_cov_2.851852_g20274_i0	PRJEB25789	20353	235	2.851852	6.7018522	Cystobasidium minutum	29899	Fungi	Fungi	198	2.56e-46	NTclustered	gi\|2781610320\|ref\|XM_066965710.1\|	1397322	g20274	i0	86.264	24.8765957446809	182	25	77	0	1	182	1092	911	Cystobasidium minutum MCA 4210 putative ATP2-F1F0-ATPase complex, F1 beta subunit (P389DRAFT_172179), mRNA	blastn	5846	198	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Cystobasidiomycetes	Cystobasidiales	Cystobasidiaceae	Cystobasidium	Cystobasidium minutum
17874815	17874815	PRJEB25789_S_NODE_18675_length_245_cov_0.895349_g18596_i0	PRJEB25789	18675	245	0.895349	2.19360505	Fungi	4751	Fungi	Fungi	113	5.950000000000001e-29	NR	KAG7579948.1	5210	g18596	i0	64.2	2.97551020408163	81	29	99.2	0	3	245	90	170	KAG7579948.1 hypothetical protein FFLO_00156 [Filobasidium floriforme]	diamond	729	113	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Filobasidium	Filobasidium floriforme
19148535	19148535	PRJEB25789_S_NODE_12056_length_284_cov_2.137441_g11977_i0	PRJEB25789	12056	284	2.137441	6.07033244	Kwoniella dendrophila	4975	Fungi	Fungi	211	4.09e-50	NTclustered	gi\|2752982483\|ref\|XM_066217289.1\|	1295534	g11977	i0	82.4	12.0246478873239	250	37	87	7	3	249	323	78	Kwoniella dendrophila CBS 6074 60S ribosomal protein L44 (L201_001500), partial mRNA	blastn	3415	211	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Kwoniella	Kwoniella dendrophila
24248919	24248919	PRJEB25789_S_NODE_13380_length_273_cov_1.540000_g13301_i0	PRJEB25789	13380	273	1.54	4.2042	Kwoniella dendrophila	4975	Fungi	Fungi	176	1.43e-39	NTclustered	gi\|2752998205\|ref\|XM_066219914.1\|	1295534	g13301	i0	81.034	99.1904761904762	232	35	84	7	45	273	229	4	Kwoniella dendrophila CBS 6074 ubiquitin-60S ribosomal protein L40 (L201_004168), partial mRNA	blastn	27079	176	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Kwoniella	Kwoniella dendrophila
24249127	24249127	PRJEB25789_S_NODE_6380_length_362_cov_2.228374_g6301_i0	PRJEB25789	6380	362	2.228374	8.06671388	Malassezia restricta	76775	Fungi	Fungi	669	0	NTclustered	gi\|1546635598\|ref\|XR_003525370.1\|	76775	g6301	i0	100	106.649171270718	362	0	100	0	1	362	1502	1863	Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA	blastn	38607	669	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
30943152	30943152	PRJEB25789_S_NODE_8774_length_320_cov_1.554656_g8695_i0	PRJEB25789	8774	320	1.554656	4.9748992	Eukaryota	2759	Fungi	Fungi	110	8.16e-28	NR	XP_046038547.1	5210	g8695	i0	56.6	6.553125	99	43	92.8	0	320	24	98	196	XP_046038547.1 P-loop containing nucleoside triphosphate hydrolase protein [Filobasidium floriforme]	diamond	2097	110	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Filobasidium	Filobasidium floriforme
31107304	31107304	PRJEB25789_S_NODE_14295_length_266_cov_1.595855_g14216_i0	PRJEB25789	14295	266	1.595855	4.2449743	Kwoniella newhampshirensis	1651941	Fungi	Fungi	94	3.0800000000000003e-22	NR	XP_066805517.1	1651941	g14216	i0	53.6	0.947368421052632	84	37	92.5	1	253	8	60	143	XP_066805517.1 hypothetical protein IAR55_001189 [Kwoniella newhampshirensis]	diamond	252	94	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Kwoniella	Kwoniella newhampshirensis

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