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

9 rows where analysis = "diamond", bioproject = "PRJNA1151638" 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
27987951	27987951	PRJNA1151638_P_NODE_5385_length_249_cov_0.886364_g5318_i0	PRJNA1151638	5385	249	0.886364	2.20704636	Cystobasidium minutum MCA 421	29899	Fungi	Fungi	57.8	1.98e-7	NR	XP_066820679.1	1397322	g5318	i0	44.9	0.939759036144578	78	25	94	1	239	6	296	355	XP_066820679.1 uncharacterized protein P389DRAFT_99876 [Cystobasidium minutum MCA 4210]	diamond	234	57.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Cystobasidiomycetes	Cystobasidiales	Cystobasidiaceae	Cystobasidium	Cystobasidium minutum
28859642	28859642	PRJNA1151638_P_NODE_6328_length_244_cov_0.912281_g6261_i0	PRJNA1151638	6328	244	0.912281	2.22596564	Malassezia	55193	Fungi	Fungi	67	3.63e-11	NR	AYO41756.1	425264	g6261	i0	88.9	0.885245901639344	36	4	44.3	0	136	243	192	227	AYO41756.1 Transport protein particle subunit trs31 [Malassezia restricta CBS 7877]	diamond	216	67	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
29787433	29787433	PRJNA1151638_P_NODE_6191_length_245_cov_0.901163_g6124_i0	PRJNA1151638	6191	245	0.901163	2.20784935	Cladosporium halotolerans	1052096	Fungi	Fungi	61.2	1.12e-8	NR	XP_069227350.1	1052096	g6124	i0	96.7	0.36734693877551	30	1	36.7	0	244	155	52	81	XP_069227350.1 uncharacterized protein WHR41_06762 [Cladosporium halotolerans]	diamond	90	61.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
29945629	29945629	PRJNA1151638_P_NODE_6571_length_243_cov_0.917647_g6504_i0	PRJNA1151638	6571	243	0.917647	2.22988221	Cystobasidium minutum MCA 421	29899	Fungi	Fungi	67.8	5.3e-11	NR	XP_066824360.1	1397322	g6504	i0	70.2	0.580246913580247	47	14	58	0	141	1	7	53	XP_066824360.1 uncharacterized protein P389DRAFT_32636 [Cystobasidium minutum MCA 4210]	diamond	141	67.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Cystobasidiomycetes	Cystobasidiales	Cystobasidiaceae	Cystobasidium	Cystobasidium minutum
30798492	30798492	PRJNA1151638_P_NODE_4754_length_253_cov_0.866667_g4687_i0	PRJNA1151638	4754	253	0.866667	2.19266751	Scheffersomyces xylosifermentans	1304137	Fungi	Fungi	78.6	1.06e-14	NR	XP_064776746.1	1304137	g4687	i0	45.3	1.0197628458498	86	43	97.2	2	253	8	1079	1164	XP_064776746.1 SAC3/GANP/Nin1/mts3/eIF-3 p25 family-domain-containing protein [Scheffersomyces xylosifermentans]	diamond	258	78.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales	Debaryomycetaceae	Scheffersomyces	Scheffersomyces xylosifermentans
31430671	31430671	PRJNA1151638_P_NODE_4876_length_252_cov_1.329609_g4809_i0	PRJNA1151638	4876	252	1.329609	3.35061468	Zasmidium cellare	395010	Fungi	Fungi	119	6.78e-29	NR	KAK4507054.1	395010	g4809	i0	66.7	1	84	26	100	1	1	252	840	921	KAK4507054.1 hypothetical protein PRZ48_000788 [Zasmidium cellare]	diamond	252	119	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Mycosphaerellaceae	Zasmidium	Zasmidium cellare
31651963	31651963	PRJNA1151638_P_NODE_6137_length_245_cov_0.906977_g6070_i0	PRJNA1151638	6137	245	0.906977	2.22209365	Rhodotorula mucilaginosa	5537	Fungi	Fungi	112	8.65e-27	NR	KAG0664242.1	5537	g6070	i0	100	0.991836734693878	81	0	99.2	0	245	3	41	121	KAG0664242.1 SWI/SNF chromatin-remodeling complex subunit [Rhodotorula mucilaginosa]	diamond	243	112	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula mucilaginosa
32840737	32840737	PRJNA1151638_P_NODE_6540_length_243_cov_0.917647_g6473_i0	PRJNA1151638	6540	243	0.917647	2.22988221	Penicillium	5073	Fungi	Fungi	136	4.3999999999999996e-38	NR	XP_065958079.1	36651	g6473	i0	76.5	6	81	19	100	0	243	1	79	159	XP_065958079.1 AIG2-like [Penicillium digitatum]	diamond	1458	136	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium digitatum
32903740	32903740	PRJNA1151638_P_NODE_6580_length_243_cov_0.917647_g6513_i0	PRJNA1151638	6580	243	0.917647	2.22988221	Malassezia	55193	Fungi	Fungi	135	3.69e-35	NR	KAI3627193.1	55194	g6513	i0	75	2.96296296296296	80	20	98.8	0	242	3	84	163	KAI3627193.1 ASH2 [Malassezia furfur]	diamond	720	136	0.992647058823529	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia furfur

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