metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA727760" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA727760" 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
27716103	27716103	PRJNA727760_S_NODE_2544_length_285_cov_1.561321_g2516_i0	PRJNA727760	2544	285	1.561321	4.44976485	Malassezia restricta CBS 7877	425264	Fungi	Fungi	118	6.229999999999999e-31	NR	AYO44820.1	425264	g2516	i0	71.1	0.947368421052632	90	26	94.7	0	283	14	61	150	AYO44820.1 heat shock protein GrpE [Malassezia restricta CBS 7877]	diamond	270	118	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
28104746	28104746	PRJNA727760_S_NODE_2505_length_288_cov_0.934884_g2477_i0	PRJNA727760	2505	288	0.934884	2.69246592	Microbotryomycetes	162481	Fungi	Fungi	60.5	6.06e-9	NR	GAA5898551.1	183962	g2477	i0	75.5	2.86458333333333	49	4	44.8	3	286	158	110	156	GAA5898551.1 hypothetical protein JCM6883_003349 [Sporobolomyces salmoneus]	diamond	825	60.8	0.995065789473684	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Sporobolomyces	Sporobolomyces salmoneus
29262618	29262618	PRJNA727760_S_NODE_2669_length_279_cov_1.893204_g2641_i0	PRJNA727760	2669	279	1.893204	5.28203916	Sarocladium strictum	5046	Fungi	Fungi	58.9	1.08e-7	NR	KAL2213322.1	5046	g2641	i0	47.8	0.741935483870968	69	25	67.7	2	12	200	325	388	KAL2213322.1 concanavalin A-like lectin/glucanase [Sarocladium strictum]	diamond	207	58.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
29767924	29767924	PRJNA727760_S_NODE_2491_length_288_cov_1.813953_g2463_i0	PRJNA727760	2491	288	1.813953	5.22418464	Knufia fluminis	191047	Fungi	Fungi	80.1	7.77e-17	NR	KAK5953335.1	191047	g2463	i0	62.8	0.8125	78	21	72.9	1	287	78	53	130	KAK5953335.1 hypothetical protein OHC33_005903 [Knufia fluminis]	diamond	234	80.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Trichomeriaceae	Knufia	Knufia fluminis
29926095	29926095	PRJNA727760_S_NODE_1631_length_361_cov_1.083333_g1603_i0	PRJNA727760	1631	361	1.083333	3.91083213	Purpureocillium lilacinum	33203	Fungi	Fungi	68.9	9.7e-11	NR	XP_018181215.1	33203	g1603	i0	89.1	0.914127423822715	55	6	45.7	0	361	197	813	867	XP_018181215.1 translation initiation factor 3 subunit c [Purpureocillium lilacinum]	diamond	330	68.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Ophiocordycipitaceae	Purpureocillium	Purpureocillium lilacinum
30431873	30431873	PRJNA727760_S_NODE_1193_length_429_cov_1.558989_g1165_i0	PRJNA727760	1193	429	1.558989	6.68806281	Sarocladium strictum	5046	Fungi	Fungi	137	6.74e-39	NR	KAK0385092.1	5046	g1165	i0	95.3	0.741258741258741	106	2	72	1	429	121	17	122	KAK0385092.1 hypothetical protein NLU13_7570 [Sarocladium strictum]	diamond	318	137	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
31157796	31157796	PRJNA727760_S_NODE_3375_length_252_cov_1.284916_g3347_i0	PRJNA727760	3375	252	1.284916	3.23798832	Talaromyces marneffei	37727	Fungi	Fungi	57	1.65e-8	NR	XP_054121538.1	37727	g3347	i0	46.4	0.821428571428571	69	34	82.1	1	252	46	8	73	XP_054121538.1 uncharacterized protein EYB26_006287 [Talaromyces marneffei]	diamond	207	57	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Trichocomaceae	Talaromyces	Talaromyces marneffei
31664041	31664041	PRJNA727760_S_NODE_3637_length_246_cov_0.901734_g3609_i0	PRJNA727760	3637	246	0.901734	2.21826564	Malassezia psittaci	1821823	Fungi	Fungi	60.5	7.19e-9	NR	WFD42247.1	1821823	g3609	i0	43	0.963414634146341	79	32	80.5	2	5	202	119	197	WFD42247.1 hypothetical protein MPSI1_000888 [Malassezia psittaci]	diamond	237	60.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia psittaci
31822168	31822168	PRJNA727760_S_NODE_2557_length_284_cov_3.322275_g2529_i0	PRJNA727760	2557	284	3.322275	9.435261	Sarocladium strictum	5046	Fungi	Fungi	92	3.8e-21	NR	KAK0386860.1	5046	g2529	i0	86.4	0.623239436619718	59	8	62.3	0	280	104	107	165	KAK0386860.1 hypothetical protein NLU13_5173 [Sarocladium strictum]	diamond	177	92	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum

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