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

10 rows where analysis = "diamond", bioproject = "PRJNA983838" 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
28542487	28542487	PRJNA983838_P_NODE_109687_length_249_cov_0.886364_g107320_i0	PRJNA983838	109687	249	0.886364	2.20704636	Filobasidium floriforme	5210	Fungi	Fungi	44.7	0.00833	NR	XP_046038069.1	5210	g107320	i0	70	0.481927710843373	40	11	47	1	95	211	704	743	XP_046038069.1 NOL1/NOP2/sun family-domain-containing protein [Filobasidium floriforme]	diamond	120	44.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Filobasidium	Filobasidium floriforme
29363263	29363263	PRJNA983838_P_NODE_101109_length_258_cov_1.540541_g98742_i0	PRJNA983838	101109	258	1.540541	3.97459578	Dioszegia hungarica	4972	Fungi	Fungi	125	3.25e-32	NR	XP_052946212.1	4972	g98742	i0	67.4	2	86	27	98.8	1	2	256	329	414	XP_052946212.1 dehydrogenase [Dioszegia hungarica]	diamond	516	125	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Bulleribasidiaceae	Dioszegia	Dioszegia hungarica
30152477	30152477	PRJNA983838_P_NODE_96112_length_266_cov_2.393782_g93745_i0	PRJNA983838	96112	266	2.393782	6.36746012	Moesziomyces antarcticus	84753	Fungi	Fungi	52	2.75e-5	NR	XP_014657340.1	84753	g93745	i0	40.4	1.77067669172932	89	46	92.5	3	6	251	736	824	XP_014657340.1 pre-mRNA-splicing factor CLF1 [Moesziomyces antarcticus]	diamond	471	52	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Ustilaginomycetes	Ustilaginales	Ustilaginaceae	Moesziomyces	Moesziomyces antarcticus
30405914	30405914	PRJNA983838_P_NODE_104113_length_253_cov_1.655556_g101746_i0	PRJNA983838	104113	253	1.655556	4.18855668	Malassezia restricta	76775	Fungi	Fungi	50.8	5.73e-5	NR	XP_027486788.1	76775	g101746	i0	49.1	0.675889328063241	57	29	67.6	0	173	3	1	57	XP_027486788.1 mitofilin [Malassezia restricta]	diamond	171	50.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
30816204	30816204	PRJNA983838_P_NODE_106094_length_252_cov_0.871508_g103727_i0	PRJNA983838	106094	252	0.871508	2.19620016	Tulasnella sp. 4	1905295	Fungi	Fungi	61.2	1.29e-8	NR	KAG8900584.1	2600223	g103727	i0	68.3	1.95238095238095	41	13	48.8	0	1	123	609	649	KAG8900584.1 succinate dehydrogenase flavoprotein subunit [Tulasnella sp. 403]	diamond	492	61.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Tulasnellaceae	Tulasnella	Tulasnella sp. 403
31359655	31359655	PRJNA983838_P_NODE_106796_length_251_cov_0.876404_g104429_i0	PRJNA983838	106796	251	0.876404	2.19977404	Ceratobasidium	5251	Fungi	Fungi	42.7	0.0422	NR	QRV95853.1	170446	g104429	i0	37.7	1.26693227091633	53	33	63.3	0	190	32	123	175	QRV95853.1 cell surface glycoprotein 1 [Ceratobasidium sp. AG-Ba]	diamond	318	42.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Ceratobasidium	Ceratobasidium sp. AG-Ba
31612565	31612565	PRJNA983838_P_NODE_116116_length_244_cov_0.912281_g113749_i0	PRJNA983838	116116	244	0.912281	2.22596564	Malassezia	55193	Fungi	Fungi	117	9.78e-29	NR	WFD25940.1	180528	g113749	i0	68.8	3.9344262295082	80	25	98.4	0	242	3	205	284	WFD25940.1 hypothetical protein MNAN1_000913 [Malassezia nana]	diamond	960	118	0.991525423728814	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia nana
31954393	31954393	PRJNA983838_P_NODE_90417_length_277_cov_1.529412_g88050_i0	PRJNA983838	90417	277	1.529412	4.23647124	Mycena leptocephala	230808	Fungi	Fungi	50.4	6.52e-5	NR	KAJ7910844.1	230808	g88050	i0	55.3	0.509025270758123	47	21	50.9	0	271	131	70	116	KAJ7910844.1 hypothetical protein B0H13DRAFT_2272266 [Mycena leptocephala]	diamond	141	50.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena leptocephala
32080996	32080996	PRJNA983838_P_NODE_112018_length_247_cov_0.896552_g109651_i0	PRJNA983838	112018	247	0.896552	2.21448344	Stereum hirsutum FP-91666 SS1	721885	Fungi	Fungi	77.4	2.37e-14	NR	XP_007304656.1	721885	g109651	i0	88.6	0.534412955465587	44	3	51	1	132	7	1	44	XP_007304656.1 uncharacterized protein STEHIDRAFT_59151 [Stereum hirsutum FP-91666 SS1]	diamond	132	77.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Stereaceae	Stereum	Stereum hirsutum
32744786	32744786	PRJNA983838_P_NODE_112000_length_247_cov_0.896552_g109633_i0	PRJNA983838	112000	247	0.896552	2.21448344	Trametes sanguinea	158606	Fungi	Fungi	42.4	0.0477	NR	KAJ3013415.1	158606	g109633	i0	41	0.740890688259109	61	24	59.5	2	210	64	176	236	KAJ3013415.1 hypothetical protein NUW54_g1600 [Trametes sanguinea]	diamond	183	42.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Polyporaceae	Trametes	Trametes sanguinea

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