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

9 rows where analysis = "diamond", bioproject = "PRJNA1067443" 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
1013582	1013582	PRJNA1067443_P_NODE_7821_length_307_cov_3.397436_g7803_i0	PRJNA1067443	7821	307	3.397436	10.43012852	Wallemia hederae	1540922	Fungi	Fungi	198	1.71e-61	NR	TIA86889.1	1540922	g7803	i0	100	0.928338762214984	95	0	92.8	0	3	287	2	96	TIA86889.1 hypothetical protein E3P99_03545 [Wallemia hederae]	diamond	285	198	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Wallemiomycetes	Wallemiales	Wallemiaceae	Wallemia	Wallemia hederae
19306890	19306890	PRJNA1067443_P_NODE_11196_length_278_cov_1.502439_g11178_i0	PRJNA1067443	11196	278	1.502439	4.17678042	Malassezia restricta CBS 7877	425264	Fungi	Fungi	160	4.95e-47	NR	AYO41766.1	425264	g11178	i0	83.7	2.97841726618705	92	15	99.3	0	278	3	122	213	AYO41766.1 putative 6-phosphogluconolactonase [Malassezia restricta CBS 7877]	diamond	828	160	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
27003851	27003851	PRJNA1067443_P_NODE_21942_length_242_cov_0.911243_g21924_i0	PRJNA1067443	21942	242	0.911243	2.20520806	Rhodotorula mucilaginosa	5537	Fungi	Fungi	101	5.319999999999999e-23	NR	KAG0658434.1	5537	g21924	i0	100	0.582644628099174	47	0	58.3	0	141	1	390	436	KAG0658434.1 surf-like protein [Rhodotorula mucilaginosa]	diamond	141	101	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula mucilaginosa
27343625	27343625	PRJNA1067443_P_NODE_10163_length_284_cov_2.137441_g10145_i0	PRJNA1067443	10163	284	2.137441	6.07033244	Malassezia	55193	Fungi	Fungi	138	1.79e-35	NR	WFD04384.1	76774	g10145	i0	73.4	2.95774647887324	94	25	99.3	0	284	3	650	743	WFD04384.1 hypothetical protein MOBT1_003091 [Malassezia obtusa]	diamond	840	138	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia obtusa
27856886	27856886	PRJNA1067443_P_NODE_16585_length_251_cov_0.865169_g16567_i0	PRJNA1067443	16585	251	0.865169	2.17157419	Rhodotorula sp. CCFEE 5	1853554	Fungi	Fungi	134	1.9099999999999999e-34	NR	TKA55791.1	1965284	g16567	i0	89.2	1.97211155378486	83	8	99.2	1	2	250	700	781	TKA55791.1 hypothetical protein B0A53_02929 [Rhodotorula sp. CCFEE 5036]	diamond	495	134	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula sp. CCFEE 5036
29530435	29530435	PRJNA1067443_P_NODE_13570_length_264_cov_2.319372_g13552_i0	PRJNA1067443	13570	264	2.319372	6.12314208	Malassezia restricta	76775	Fungi	Fungi	48.5	3.65e-5	NR	XP_027483267.1	76775	g13552	i0	70.6	0.386363636363636	34	9	37.5	1	264	166	34	67	XP_027483267.1 mitochondrial export protein SOM1 [Malassezia restricta]	diamond	102	48.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
31172800	31172800	PRJNA1067443_P_NODE_6835_length_321_cov_3.512097_g6817_i0	PRJNA1067443	6835	321	3.512097	11.27383137	Coprinopsis cinerea okayama7#13	5346	Fungi	Fungi	199	8.16e-60	NR	XP_001838108.2	240176	g6817	i0	99	0.934579439252336	100	1	93.5	0	1	300	225	324	XP_001838108.2 hypothetical protein CC1G_05589 [Coprinopsis cinerea okayama7#130]	diamond	300	199	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Psathyrellaceae	Coprinopsis	Coprinopsis cinerea
31236227	31236227	PRJNA1067443_P_NODE_21235_length_243_cov_0.905882_g21217_i0	PRJNA1067443	21235	243	0.905882	2.20129326	Malassezia cuniculi	948313	Fungi	Fungi	108	2.55e-25	NR	WFD33702.1	948313	g21217	i0	65	0.987654320987654	80	28	98.8	0	241	2	359	438	WFD33702.1 hypothetical protein MCUN1_000515 [Malassezia cuniculi]	diamond	240	108	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia cuniculi
32879870	32879870	PRJNA1067443_P_NODE_22760_length_241_cov_0.916667_g22742_i0	PRJNA1067443	22760	241	0.916667	2.20916747	Malassezia equina	1381935	Fungi	Fungi	72.4	1.19e-12	NR	WFD21610.1	1381935	g22742	i0	51.4	2.4149377593361	74	33	92.1	1	239	18	379	449	WFD21610.1 Manganese transporter smf1 [Malassezia equina]	diamond	582	72.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia equina

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