metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJNA637328" and tax

14 rows where analysis = "diamond", bioproject = "PRJNA637328" 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
13363100	13363100	PRJNA637328_P_NODE_12311_length_274_cov_3.702222_g11835_i0	PRJNA637328	12311	274	3.702222	10.14408828	Malassezia arunalokei	1514897	Fungi	Fungi	133	3.0399999999999992e-34	NR	WFD15028.1	1514897	g11835	i0	100	0.678832116788321	62	0	67.9	0	272	87	520	581	WFD15028.1 squalene monooxygenase [Malassezia arunalokei]	diamond	186	133	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia arunalokei
26966857	26966857	PRJNA637328_P_NODE_3502_length_474_cov_2.216471_g3034_i0	PRJNA637328	3502	474	2.216471	10.50607254	Eukaryota	2759	Fungi	Fungi	192	2.4199999999999997e-57	NR	AMK06850.1	34349	g3034	i0	56.7	42.7088607594937	157	61	99.4	2	472	2	191	340	AMK06850.1 translation elongation factor 1-alpha, partial [Mixia osmundae]	diamond	20244	192	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Mixiomycetes	Mixiales	Mixiaceae	Mixia	Mixia osmundae
26985981	26985981	PRJNA637328_P_NODE_18642_length_243_cov_1.051546_g18165_i0	PRJNA637328	18642	243	1.051546	2.55525678	Tremellales sp. Uapishka_1	3038892	Fungi	Fungi	46.6	0.00165	NR	KAK4687354.1	3038892	g18165	i0	37.5	0.790123456790123	64	40	79	0	30	221	122	185	KAK4687354.1 mediator of RNA polymerase II transcription subunit 6, partial [Tremellales sp. Uapishka_1]	diamond	192	46.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales			Tremellales sp. Uapishka_1
27334039	27334039	PRJNA637328_P_NODE_21843_length_210_cov_5.031056_g21366_i0	PRJNA637328	21843	210	5.031056	10.5652176	Coprinellus aureogranulatus	752674	Fungi	Fungi	86.3	3.3e-20	NR	KAJ3500773.1	752674	g21366	i0	98.5	0.971428571428571	68	1	97.1	0	7	210	1	68	KAJ3500773.1 hypothetical protein NMY22_g19151 [Coprinellus aureogranulatus]	diamond	204	86.3	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Psathyrellaceae	Coprinellus	Coprinellus aureogranulatus
27870573	27870573	PRJNA637328_P_NODE_15285_length_257_cov_2.437500_g14808_i0	PRJNA637328	15285	257	2.4375	6.264375	Malassezia restricta	76775	Fungi	Fungi	53.5	5.37e-6	NR	XP_027484041.1	76775	g14808	i0	100	0.326848249027237	28	0	32.7	0	118	201	233	260	XP_027484041.1 cysteine-rich secretory protein [Malassezia restricta]	diamond	84	53.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
27933848	27933848	PRJNA637328_P_NODE_18745_length_242_cov_4.227979_g18268_i0	PRJNA637328	18745	242	4.227979	10.23170918	Malassezia restricta CBS 7877	425264	Fungi	Fungi	77.8	3.45e-16	NR	AYO44872.1	425264	g18268	i0	61.4	0.706611570247934	57	9	70.7	1	47	217	4	47	AYO44872.1 Plasma membrane proteolipid 3 [Malassezia restricta CBS 7877]	diamond	171	77.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
28028669	28028669	PRJNA637328_P_NODE_14045_length_263_cov_4.841121_g13568_i0	PRJNA637328	14045	263	4.841121	12.73214823	Naganishia adeliensis	92952	Fungi	Fungi	167	1.7199999999999998e-47	NR	KAJ9091675.1	92952	g13568	i0	92	0.992395437262357	87	7	99.2	0	261	1	380	466	KAJ9091675.1 hypothetical protein QFC20_007586 [Naganishia adeliensis]	diamond	261	167	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Filobasidiales	Filobasidiaceae	Naganishia	Naganishia adeliensis
28988488	28988488	PRJNA637328_P_NODE_9508_length_300_cov_3.617530_g9033_i0	PRJNA637328	9508	300	3.61753	10.85259	Agaricomycetes	155619	Fungi	Fungi	52	3.76e-5	NR	YP_010130215.1	264083	g9033	i0	52.2	1.32	46	22	46	0	292	155	315	360	YP_010130215.1 LAGLIDADG endonuclease [Clavaria fumosa]	diamond	396	52.4	0.99236641221374	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Clavariaceae	Clavaria	Clavaria fumosa
29354769	29354769	PRJNA637328_P_NODE_15209_length_258_cov_0.971292_g14732_i0	PRJNA637328	15209	258	0.971292	2.50593336	Tremellales sp. Uapishka_1	3038892	Fungi	Fungi	159	8.64e-46	NR	KAK4687591.1	3038892	g14732	i0	91.8	0.988372093023256	85	7	98.8	0	257	3	226	310	KAK4687591.1 hypothetical protein P7C73_g2525, partial [Tremellales sp. Uapishka_1]	diamond	255	159	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales			Tremellales sp. Uapishka_1
29859802	29859802	PRJNA637328_P_NODE_10311_length_291_cov_5.438017_g9836_i0	PRJNA637328	10311	291	5.438017	15.82462947	Rhizoctonia solani 123E	1423351	Fungi	Fungi	82	1.04e-15	NR	KEP45283.1	1423351	g9836	i0	53.7	3.44329896907217	82	30	82.5	2	270	31	515	590	KEP45283.1 putative Transposon Tf2-1 polyprotein, partial [Rhizoctonia solani 123E]	diamond	1002	82	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Ceratobasidiaceae	Rhizoctonia	Rhizoctonia solani
30441162	30441162	PRJNA637328_P_NODE_10873_length_286_cov_2.202532_g10398_i0	PRJNA637328	10873	286	2.202532	6.29924152	Basidiomycota	5204	Fungi	Fungi	124	1e-30	NR	XP_025600286.1	58919	g10398	i0	68.8	2.92657342657343	93	25	97.6	1	283	5	296	384	XP_025600286.1 26S proteasome regulatory complex, non-ATPase subcomplex, Rpn1 subunit [Tilletiopsis washingtonensis]	diamond	837	125	0.992	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Entylomatales		Tilletiopsis	Tilletiopsis washingtonensis
30934165	30934165	PRJNA637328_P_NODE_15034_length_258_cov_3.540670_g14557_i0	PRJNA637328	15034	258	3.54067	9.1349286	Cystobasidium minutum MCA 421	29899	Fungi	Fungi	75.5	9.41e-14	NR	XP_066824944.1	1397322	g14557	i0	100	0.406976744186047	35	0	40.7	0	2	106	323	357	XP_066824944.1 GroES-like protein [Cystobasidium minutum MCA 4210]	diamond	105	75.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Cystobasidiomycetes	Cystobasidiales	Cystobasidiaceae	Cystobasidium	Cystobasidium minutum
30997332	30997332	PRJNA637328_P_NODE_10894_length_286_cov_1.700422_g10419_i0	PRJNA637328	10894	286	1.700422	4.86320692	Malassezia restricta CBS 7877	425264	Fungi	Fungi	183	3.97e-58	NR	AYO44923.1	425264	g10419	i0	95.5	0.923076923076923	88	4	92.3	0	286	23	3	90	AYO44923.1 hypothetical protein DNF11_3973 [Malassezia restricta CBS 7877]	diamond	264	183	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia restricta
31029082	31029082	PRJNA637328_P_NODE_13975_length_264_cov_1.204651_g13498_i0	PRJNA637328	13975	264	1.204651	3.18027864	Malassezia restricta CBS 7877	425264	Fungi	Fungi	120	1.01e-31	NR	AYO41579.1	425264	g13498	i0	81.7	0.806818181818182	71	13	80.7	0	213	1	1	71	AYO41579.1 Rare lipoprotein A (RlpA)-like double-psi beta-barrel [Malassezia restricta CBS 7877]	diamond	213	120	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);;