metadata: contig_metadata: 10 rows where bioproject = "PRJNA688157" and tax

10 rows where bioproject = "PRJNA688157" 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
666830	666830	PRJNA688157_S_NODE_30921_length_348_cov_2.745455_g30779_i0	PRJNA688157	30921	348	2.745455	9.5541834	Malassezia globosa	76773	Fungi	Fungi	584	2.63e-162	NTclustered	gi\|164659138\|ref\|XM_001730642.1\|	425265	g30779	i0	98.204	17.8908045977011	334	6	96	0	15	348	889	556	Malassezia globosa CBS 7966 uncharacterized protein (MGL_2148), partial mRNA	blastn	6226	584	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia globosa
1942813	1942813	PRJNA688157_S_NODE_79742_length_257_cov_1.690217_g79600_i0	PRJNA688157	79742	257	1.690217	4.34385769	Malassezia globosa	76773	Fungi	Fungi	475	1.1699999999999999e-129	NTclustered	gi\|1805972860\|gb\|CP046440.1\|	76773	g79600	i0	100	46.2529182879377	257	0	100	0	1	257	30090	29834	Malassezia globosa strain CBS7966 mitochondrion, complete genome	blastn	11887	475	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia globosa
10870866	10870866	PRJNA688157_S_NODE_28709_length_355_cov_2.453901_g28567_i0	PRJNA688157	28709	355	2.453901	8.71134855	Beauveria bassiana	176275	Fungi	Fungi	206	2.44e-48	NTclustered	gi\|667649190\|ref\|XM_008598205.1\|	655819	g28567	i0	96.748	5.17464788732394	123	4	35	0	1	123	398	520	Beauveria bassiana ARSEF 2860 uncharacterized protein (BBA_03108), partial mRNA	blastn	1837	206	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Cordycipitaceae	Beauveria	Beauveria bassiana
10870873	10870873	PRJNA688157_S_NODE_76609_length_261_cov_2.207447_g76467_i0	PRJNA688157	76609	261	2.207447	5.76143667	Malassezia restricta	76775	Fungi	Fungi	475	1.1899999999999999e-129	NTclustered	gi\|1546638659\|ref\|XM_027630971.1\|	76775	g76467	i0	99.615	1.15708812260536	260	1	99	0	2	261	574	315	Malassezia restricta cell division control protein 42 (MRET_4344), partial mRNA	blastn	302	475	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
13420789	13420789	PRJNA688157_S_NODE_45991_length_311_cov_5.029412_g45849_i0	PRJNA688157	45991	311	5.029412	15.64147132	Malassezia globosa	76773	Fungi	Fungi	569	6.489999999999998e-158	NTclustered	gi\|1805972860\|gb\|CP046440.1\|	76773	g45849	i0	100	46.6913183279743	308	0	99	0	4	311	2992	2685	Malassezia globosa strain CBS7966 mitochondrion, complete genome	blastn	14521	569	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia globosa
24892960	24892960	PRJNA688157_S_NODE_61660_length_283_cov_2.295238_g61518_i0	PRJNA688157	61660	283	2.295238	6.49552354	Malassezia restricta	76775	Fungi	Fungi	383	8.15e-102	NTclustered	gi\|1546636765\|ref\|XM_027630025.1\|	76775	g61518	i0	94.048	0.890459363957597	252	15	89	0	1	252	1393	1644	Malassezia restricta myo-inositol-1-phosphate synthase (MRET_3398), partial mRNA	blastn	252	383	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
29135117	29135117	PRJNA688157_S_NODE_39269_length_326_cov_1.644269_g39127_i0	PRJNA688157	39269	326	1.644269	5.36031694	Sarocladium implicatum	1610689	Fungi	Fungi	209	1.87e-64	NR	KAH8178064.1	1610689	g39127	i0	83.3	1.98773006134969	108	18	99.4	0	325	2	241	348	KAH8178064.1 alpha/beta hydrolase fold domain-containing protein [Sarocladium implicatum]	diamond	648	209	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium implicatum
31536186	31536186	PRJNA688157_S_NODE_68936_length_272_cov_1.763819_g68794_i0	PRJNA688157	68936	272	1.763819	4.79758768	Cladosporium halotolerans	1052096	Fungi	Fungi	95.5	1.46e-20	NR	XP_069225492.1	1052096	g68794	i0	79.7	0.650735294117647	59	7	65.1	1	272	96	575	628	XP_069225492.1 uncharacterized protein WHR41_08899 [Cladosporium halotolerans]	diamond	177	95.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
32085263	32085263	PRJNA688157_S_NODE_83998_length_252_cov_1.301676_g83856_i0	PRJNA688157	83998	252	1.301676	3.28022352	Rhizoctonia	1322061	Fungi	Fungi	46.2	0.00227	NR	KAJ1307419.1	456999	g83856	i0	66.7	0.94047619047619	27	9	32.1	0	2	82	274	300	KAJ1307419.1 hypothetical protein OPQ81_001521 [Rhizoctonia solani]	diamond	237	46.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Rhizoctonia	Rhizoctonia solani
32863296	32863296	PRJNA688157_S_NODE_51840_length_300_cov_2.057269_g51698_i0	PRJNA688157	51840	300	2.057269	6.171807	Trematosphaeria pertusa	390896	Fungi	Fungi	56.6	7.93e-7	NR	XP_033675286.1	390896	g51698	i0	38.6	2.9	88	53	88	1	23	286	77	163	XP_033675286.1 uncharacterized protein BU26DRAFT_556950 [Trematosphaeria pertusa]	diamond	870	56.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Trematosphaeriaceae	Trematosphaeria	Trematosphaeria pertusa

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