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

10 rows where analysis = "diamond", bioproject = "PRJNA795663" 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
2055238	2055238	PRJNA795663_S_NODE_14542_length_166_cov_1.480620_g14437_i0	PRJNA795663	14542	166	1.48062	2.4578292	Malassezia	55193	Fungi	Fungi	113	2.31e-28	NR	KAI3627975.1	55194	g14437	i0	89.1	3.97590361445783	55	6	99.4	0	165	1	65	119	KAI3627975.1 ADH6 [Malassezia furfur]	diamond	660	113	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia furfur
28357672	28357672	PRJNA795663_S_NODE_17126_length_156_cov_1.294118_g17021_i0	PRJNA795663	17126	156	1.294118	2.01882408	Malassezia	55193	Fungi	Fungi	91.7	5.46e-20	NR	XP_018739428.1	1230383	g17021	i0	97.8	4.51923076923077	45	1	86.5	0	20	154	76	120	XP_018739428.1 uncharacterized protein MSY001_0812 [Malassezia sympodialis ATCC 42132]	diamond	705	91.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia sympodialis
29264137	29264137	PRJNA795663_S_NODE_16429_length_158_cov_2.404959_g16324_i0	PRJNA795663	16429	158	2.404959	3.79983522	Cystobasidium minutum MCA 421	29899	Fungi	Fungi	76.6	1.3e-14	NR	XP_066825239.1	1397322	g16324	i0	92.5	0.759493670886076	40	3	75.9	0	156	37	271	310	XP_066825239.1 uncharacterized protein P389DRAFT_209225 [Cystobasidium minutum MCA 4210]	diamond	120	76.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Cystobasidiomycetes	Cystobasidiales	Cystobasidiaceae	Cystobasidium	Cystobasidium minutum
29273285	29273285	PRJNA795663_S_NODE_11089_length_185_cov_1.804054_g10984_i0	PRJNA795663	11089	185	1.804054	3.3374999	Malassezia	55193	Fungi	Fungi	82	3.84e-18	NR	XP_027484011.1	76775	g10984	i0	76.3	1.91351351351351	59	13	95.7	1	1	177	60	117	XP_027484011.1 DASH complex subunit DAD3 [Malassezia restricta]	diamond	354	82.4	0.995145631067961	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
30148391	30148391	PRJNA795663_S_NODE_9772_length_195_cov_1.208861_g9667_i0	PRJNA795663	9772	195	1.208861	2.35727895	Ceratobasidium sp. AG-I	305860	Fungi	Fungi	135	1.78e-39	NR	KAF8607268.1	305860	g9667	i0	95.3	0.984615384615385	64	3	98.5	0	2	193	26	89	KAF8607268.1 ubiquinol-cytochrome c reductase subunit 8 [Ceratobasidium sp. AG-I]	diamond	192	135	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Ceratobasidium	Ceratobasidium sp. AG-I
31412653	31412653	PRJNA795663_S_NODE_11456_length_183_cov_1.123288_g11351_i0	PRJNA795663	11456	183	1.123288	2.05561704	Marasmiellus scandens	2682957	Fungi	Fungi	53.5	2.55e-6	NR	KAK7464989.1	2682957	g11351	i0	63.3	2.95081967213115	49	15	75.4	2	41	178	11	59	KAK7464989.1 hypothetical protein VKT23_006198 [Marasmiellus scandens]	diamond	540	53.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Omphalotaceae	Marasmiellus	Marasmiellus scandens
31832788	31832788	PRJNA795663_S_NODE_15457_length_162_cov_1.504000_g15352_i0	PRJNA795663	15457	162	1.504	2.43648	Malassezia	55193	Fungi	Fungi	76.3	1.06e-14	NR	WFC93668.1	1821822	g15352	i0	78.3	4.25925925925926	46	10	85.2	0	160	23	192	237	WFC93668.1 alcohol dehydrogenase (NADP(+)) [Malassezia brasiliensis]	diamond	690	76.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia brasiliensis
32054387	32054387	PRJNA795663_S_NODE_5178_length_256_cov_2.168950_g5073_i0	PRJNA795663	5178	256	2.16895	5.552512	Tremellales	5234	Fungi	Fungi	71.2	1.11e-13	NR	KAK1923396.1	5418	g5073	i0	82.9	1.91015625	41	7	48	0	21	143	77	117	KAK1923396.1 hypothetical protein DB88DRAFT_510955 [Papiliotrema laurentii]	diamond	489	71.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Rhynchogastremaceae	Papiliotrema	Papiliotrema laurentii
32425030	32425030	PRJNA795663_S_NODE_15479_length_162_cov_1.296000_g15374_i0	PRJNA795663	15479	162	1.296	2.09952	Atractiella rhizophila	1938712	Fungi	Fungi	76.3	1.85e-14	NR	KAH8928873.1	1938712	g15374	i0	58.8	0.944444444444444	51	21	94.4	0	158	6	68	118	KAH8928873.1 hypothetical protein BT69DRAFT_408818 [Atractiella rhizophila]	diamond	153	76.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Atractiellomycetes	Atractiellales	Hoehnelomycetaceae	Atractiella	Atractiella rhizophila
32623624	32623624	PRJNA795663_S_NODE_9460_length_197_cov_2.318750_g9355_i0	PRJNA795663	9460	197	2.31875	4.5679375	Malassezia	55193	Fungi	Fungi	125	3.98e-32	NR	XP_018739428.1	1230383	g9355	i0	90.8	4.9492385786802	65	6	99	0	197	3	321	385	XP_018739428.1 uncharacterized protein MSY001_0812 [Malassezia sympodialis ATCC 42132]	diamond	975	125	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia sympodialis

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