metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA414225" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA414225" 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	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
27313632	27313632	PRJNA414225_P_NODE_79883_length_163_cov_0.894737_g79796_i0	PRJNA414225	79883	163	0.894737	1.45842131	Naganishia	1851509	Fungi	Fungi	77.8	5.58e-15	NR	KAJ9123239.1	1424756	g79796	i0	92.5	2.94478527607362	40	3	73.6	162	43	221	260	KAJ9123239.1 hypothetical protein QFC22_001435 [Naganishia vaughanmartiniae]	diamond	480	77.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Naganishia	Naganishia vaughanmartiniae
27724391	27724391	PRJNA414225_P_NODE_81364_length_163_cov_0.894737_g81277_i0	PRJNA414225	81364	163	0.894737	1.45842131	Malassezia	55193	Fungi	Fungi	73.9	1.15e-13	NR	WFD18028.1	1381934	g81277	i0	63.5	1.91411042944785	52	19	95.7	1	156	336	387	WFD18028.1 acid phosphatase [Malassezia caprae]	diamond	312	74.3	0.994616419919246	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia caprae
28338888	28338888	PRJNA414225_P_NODE_89546_length_162_cov_0.902655_g89459_i0	PRJNA414225	89546	162	0.902655	1.4623011	Phenoliferia sp. Uapishka_3	3038894	Fungi	Fungi	48.5	1.12e-4	NR	KAK4704479.1	3038894	g89459	i0	63.3	0.555555555555556	30	11	55.6	161	72	806	835	KAK4704479.1 hypothetical protein P7C70_g1734, partial [Phenoliferia sp. Uapishka_3]	diamond	90	48.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Kriegeriales	Kriegeriaceae	Phenoliferia	Phenoliferia sp. Uapishka_3
29065170	29065170	PRJNA414225_P_NODE_34008_length_176_cov_1.559055_g33921_i0	PRJNA414225	34008	176	1.559055	2.7439368	Phlebiopsis gigantea 11	82310	Fungi	Fungi	80.1	2.72e-16	NR	KIP07301.1	745531	g33921	i0	69	0.988636363636364	58	18	98.9	2	175	123	180	KIP07301.1 hypothetical protein PHLGIDRAFT_13329 [Phlebiopsis gigantea 11061_1 CR5-6]	diamond	174	80.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Phanerochaetaceae	Phlebiopsis	Phlebiopsis gigantea
29270941	29270941	PRJNA414225_P_NODE_7689_length_223_cov_0.885057_g7602_i0	PRJNA414225	7689	223	0.885057	1.97367711	Basidiomycota	5204	Fungi	Fungi	99	1.8299999999999994e-23	NR	KAF8812528.1	171480	g7602	i0	68.6	4.73542600896861	70	22	94.2	13	222	66	135	KAF8812528.1 hypothetical protein BYT27DRAFT_6425208 [Phlegmacium glaucopus]	diamond	1056	100	0.99	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Cortinariaceae	Phlegmacium	Phlegmacium glaucopus
29317609	29317609	PRJNA414225_P_NODE_56369_length_166_cov_0.871795_g56282_i0	PRJNA414225	56369	166	0.871795	1.4471797	Naganishia albida	100951	Fungi	Fungi	44.3	9.36e-4	NR	KAI5450956.1	100951	g56282	i0	58.3	0.650602409638554	36	15	65.1	43	150	35	70	KAI5450956.1 hypothetical protein NCC49_002695 [Naganishia albida]	diamond	108	44.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Naganishia	Naganishia albida
30692442	30692442	PRJNA414225_P_NODE_36213_length_174_cov_1.632000_g36126_i0	PRJNA414225	36213	174	1.632	2.83968	Malassezia	55193	Fungi	Fungi	52.4	4.79e-6	NR	XP_027486623.1	76775	g36126	i0	61.5	2.36206896551724	39	15	67.2	124	8	7	45	XP_027486623.1 TP53 regulating kinase and related kinases [Malassezia restricta]	diamond	411	52.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
30897235	30897235	PRJNA414225_P_NODE_79934_length_163_cov_0.894737_g79847_i0	PRJNA414225	79934	163	0.894737	1.45842131	Cryptococcus sp. DSM 1	2770023	Fungi	Fungi	84	3.77e-17	NR	WVQ71969.1	2770023	g79847	i0	81.5	0.993865030674847	54	10	99.4	1	162	201	254	WVQ71969.1 hypothetical protein IAR50_001512 [Cryptococcus sp. DSM 104548]	diamond	162	84	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Cryptococcus	Cryptococcus sp. DSM 104548
31117966	31117966	PRJNA414225_P_NODE_79315_length_163_cov_0.894737_g79228_i0	PRJNA414225	79315	163	0.894737	1.45842131	Malassezia equina	1381935	Fungi	Fungi	63.9	4.21e-10	NR	WFD24149.1	1381935	g79228	i0	76.3	1.43558282208589	38	9	69.9	22	135	2	39	WFD24149.1 hypothetical protein MEQU1_002846 [Malassezia equina]	diamond	234	63.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia equina
32066972	32066972	PRJNA414225_P_NODE_88178_length_162_cov_0.902655_g88091_i0	PRJNA414225	88178	162	0.902655	1.4623011	Malassezia restricta	76775	Fungi	Fungi	65.9	1.52e-12	NR	XP_027484264.1	76775	g88091	i0	94.4	0.666666666666667	36	2	66.7	55	162	16	51	XP_027484264.1 elongation factor-2 kinase [Malassezia restricta]	diamond	108	65.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta

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