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

10 rows where analysis = "diamond", bioproject = "PRJNA492363" 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
32918107	32918107	PRJNA492363_S_NODE_41681_length_236_cov_2.080000_g40860_i0	PRJNA492363	41681	236	2.08	4.9088	Tilletiopsis washingtonensis	58919	Fungi	Fungi	67.4	6.89e-11	NR	XP_025600827.1	58919	g40860	i0	42.5	0.927966101694915	73	41	91.5	1	227	12	236	308	XP_025600827.1 alpha/beta-hydrolase [Tilletiopsis washingtonensis]	diamond	219	67.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Entylomatales		Tilletiopsis	Tilletiopsis washingtonensis
32935158	32935158	PRJNA492363_S_NODE_113065_length_192_cov_2.435115_g112244_i0	PRJNA492363	113065	192	2.435115	4.6754208	Mycena leptocephala	230808	Fungi	Fungi	45.1	0.00288	NR	KAJ7936227.1	230808	g112244	i0	37.3	3.1875	67	36	95.3	2	6	188	592	658	KAJ7936227.1 hypothetical protein B0H13DRAFT_2303939 [Mycena leptocephala]	diamond	612	45.1	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena leptocephala
32952667	32952667	PRJNA492363_S_NODE_97146_length_203_cov_0.901408_g96325_i0	PRJNA492363	97146	203	0.901408	1.82985824	Phaffia rhodozyma	264483	Fungi	Fungi	91.3	1.28e-19	NR	CDZ96153.1	264483	g96325	i0	71.4	0.931034482758621	63	18	93.1	0	202	14	157	219	CDZ96153.1 NADH dehydrogenase subunits 2, 5, and related proteins [Phaffia rhodozyma]	diamond	189	91.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Cystofilobasidiales	Mrakiaceae	Phaffia	Phaffia rhodozyma
32969785	32969785	PRJNA492363_S_NODE_89674_length_207_cov_1.308219_g88853_i0	PRJNA492363	89674	207	1.308219	2.70801333	Cyphobasidiales sp. Tagirdzhanova-	2801448	Fungi	Fungi	71.6	1.17e-12	NR	CAD6585176.1	2778381	g88853	i0	66	0.681159420289855	47	16	68.1	0	146	6	287	333	CAD6585176.1 MAG: hypothetical protein CYPHOPRED_002987 [Cyphobasidiales sp. Tagirdzhanova-0007]	diamond	141	71.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Cystobasidiomycetes	Cyphobasidiales			Cyphobasidiales sp. Tagirdzhanova-0007
32975694	32975694	PRJNA492363_S_NODE_68650_length_224_cov_1.852761_g67829_i0	PRJNA492363	68650	224	1.852761	4.15018464	Agaricomycetes	155619	Fungi	Fungi	68.9	1.7e-11	NR	TDL28535.1	50990	g67829	i0	87.2	3.16071428571429	39	5	52.2	0	33	149	487	525	TDL28535.1 glycoside hydrolase family 3 protein [Rickenella mellea]	diamond	708	69.3	0.994227994227994	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Hymenochaetales	Rickenellaceae	Rickenella	Rickenella mellea
33003731	33003731	PRJNA492363_S_NODE_95259_length_204_cov_0.895105_g94438_i0	PRJNA492363	95259	204	0.895105	1.8260142	Pterula gracilis	1884261	Fungi	Fungi	84.7	3.02e-19	NR	TFL07557.1	1884261	g94438	i0	53.7	0.985294117647059	67	31	98.5	0	4	204	26	92	TFL07557.1 hypothetical protein BDV98DRAFT_558054 [Pterula gracilis]	diamond	201	84.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Pterulaceae	Pterulicium	Pterulicium gracile
33003743	33003743	PRJNA492363_S_NODE_97107_length_203_cov_0.901408_g96286_i0	PRJNA492363	97107	203	0.901408	1.82985824	Peniophora sp. CONT	1314672	Fungi	Fungi	101	6.5e-26	NR	KZV68545.1	1314672	g96286	i0	88.1	0.87192118226601	59	7	87.2	0	26	202	1	59	KZV68545.1 fungal hydrophobin [Peniophora sp. CONT]	diamond	177	101	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Peniophoraceae	Peniophora	Peniophora sp. CONT
33020725	33020725	PRJNA492363_S_NODE_86036_length_209_cov_1.189189_g85215_i0	PRJNA492363	86036	209	1.189189	2.48540501	Cystobasidium minutum MCA 421	29899	Fungi	Fungi	102	1.7099999999999998e-23	NR	XP_066823536.1	1397322	g85215	i0	95.7	0.674641148325359	47	2	67.5	0	1	141	198	244	XP_066823536.1 uncharacterized protein P389DRAFT_195140 [Cystobasidium minutum MCA 4210]	diamond	141	102	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Cystobasidiomycetes	Cystobasidiales	Cystobasidiaceae	Cystobasidium	Cystobasidium minutum
33157078	33157078	PRJNA492363_S_NODE_67040_length_225_cov_1.500000_g66219_i0	PRJNA492363	67040	225	1.5	3.375	Microbotryomycetes sp. JL221	2987685	Fungi	Fungi	88.2	2.92e-18	NR	KAK4057521.1	2987685	g66219	i0	50.7	2.84	69	34	92	0	6	212	410	478	KAK4057521.1 eukaryotic translation initiation factor 2-alpha kinase [Microbotryomycetes sp. JL221]	diamond	639	88.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes				Microbotryomycetes sp. JL221
33157130	33157130	PRJNA492363_S_NODE_86304_length_209_cov_0.864865_g85483_i0	PRJNA492363	86304	209	0.864865	1.80756785	Naganishia adeliensis	92952	Fungi	Fungi	41.2	0.0205	NR	KAJ9110021.1	92952	g85483	i0	67.7	0.444976076555024	31	10	44.5	0	205	113	32	62	KAJ9110021.1 hypothetical protein QFC20_003095 [Naganishia adeliensis]	diamond	93	41.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Naganishia	Naganishia adeliensis

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