metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1036688" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1036688" 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
26940120	26940120	PRJNA1036688_P_NODE_7042_length_213_cov_2.414773_g6750_i0	PRJNA1036688	7042	213	2.414773	5.14346649	Naematelia encephala	71784	Fungi	Fungi	89.4	4.38e-19	NR	ORY30542.1	71784	g6750	i0	64.8	1	71	25	100	0	213	1	169	239	ORY30542.1 zinc-type alcohol dehydrogenase [Naematelia encephala]	diamond	213	89.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Naemateliaceae	Naematelia	Naematelia encephala
27667232	27667232	PRJNA1036688_P_NODE_11844_length_153_cov_2.405172_g11552_i0	PRJNA1036688	11844	153	2.405172	3.67991316	Malassezia arunalokei	1514897	Fungi	Fungi	68.9	6.13e-12	NR	WFD16437.1	1514897	g11552	i0	100	0.647058823529412	33	0	64.7	0	151	53	2840	2872	WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei]	diamond	99	68.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia arunalokei
28424964	28424964	PRJNA1036688_P_NODE_11646_length_155_cov_1.313559_g11354_i0	PRJNA1036688	11646	155	1.313559	2.03601645	Tilletiaria anomala UBC 951	1037660	Fungi	Fungi	44.7	0.00141	NR	XP_013240370.1	1037660	g11354	i0	44.4	1.74193548387097	45	25	87.1	0	135	1	1	45	XP_013240370.1 translationally-controlled tumor protein [Tilletiaria anomala UBC 951]	diamond	270	44.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Georgefischeriales	Tilletiariaceae	Tilletiaria	Tilletiaria anomala
28479998	28479998	PRJNA1036688_P_NODE_11966_length_152_cov_2.695652_g11674_i0	PRJNA1036688	11966	152	2.695652	4.09739104	Agaricomycetes	155619	Fungi	Fungi	73.2	1.09e-13	NR	XP_047752544.1	181762	g11674	i0	72	8.88157894736842	50	14	98.7	0	3	152	138	187	XP_047752544.1 Protein rds1 [Psilocybe cubensis]	diamond	1350	73.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Strophariaceae	Psilocybe	Psilocybe cubensis
30256734	30256734	PRJNA1036688_P_NODE_8752_length_184_cov_4.360544_g8460_i0	PRJNA1036688	8752	184	4.360544	8.02340096	Malassezia arunalokei	1514897	Fungi	Fungi	68.2	1.86e-11	NR	WFD16437.1	1514897	g8460	i0	69	0.945652173913043	58	6	75	1	14	151	932	989	WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei]	diamond	174	68.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia arunalokei
31078011	31078011	PRJNA1036688_P_NODE_6395_length_229_cov_1.536458_g6103_i0	PRJNA1036688	6395	229	1.536458	3.51848882	Rhodotorula dairenensis	86832	Fungi	Fungi	45.8	0.00247	NR	GAA5871955.1	86832	g6103	i0	32.4	0.930131004366812	71	44	93	1	17	229	48	114	GAA5871955.1 hypothetical protein JCM3774_000739 [Rhodotorula dairenensis]	diamond	213	45.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula dairenensis
31078012	31078012	PRJNA1036688_P_NODE_7755_length_199_cov_2.783951_g7463_i0	PRJNA1036688	7755	199	2.783951	5.54006249	Malassezia arunalokei	1514897	Fungi	Fungi	119	2.34e-29	NR	WFD16437.1	1514897	g7463	i0	97	0.994974874371859	66	2	99.5	0	1	198	2684	2749	WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei]	diamond	198	119	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia arunalokei
32208521	32208521	PRJNA1036688_P_NODE_11278_length_158_cov_1.256198_g10986_i0	PRJNA1036688	11278	158	1.256198	1.98479284	Suillus	5379	Fungi	Fungi	61.2	5.55e-10	NR	KAG2047545.1	279518	g10986	i0	61.5	2.9620253164557	52	19	98.7	1	3	158	1	51	KAG2047545.1 hypothetical protein BDR06DRAFT_86935 [Suillus hirtellus]	diamond	468	61.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Boletales	Suillaceae	Suillus	Suillus hirtellus

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