metadata: contig_metadata: 12 rows where analysis = "diamond", bioproject = "PRJNA751877" and tax

12 rows where analysis = "diamond", bioproject = "PRJNA751877" 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
16029071	16029071	PRJNA751877_P_NODE_2513_length_542_cov_2.230277_g2392_i0	PRJNA751877	2513	542	2.230277	12.08810134	Sporobolomyces phaffii	183961	Fungi	Fungi	106	8.58e-24	NR	GAA6021717.1	183961	g2392	i0	52.3	0.719557195571956	130	17	72	3	108	497	17	101	GAA6021717.1 hypothetical protein JCM11491_001391 [Sporobolomyces phaffii]	diamond	390	106	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Sporobolomyces	Sporobolomyces phaffii
18578196	18578196	PRJNA751877_P_NODE_27755_length_244_cov_0.900585_g27633_i0	PRJNA751877	27755	244	0.900585	2.1974274	Eukaryota	2759	Fungi	Fungi	138	9.68e-40	NR	KAF7762329.1	192524	g27633	i0	79	21.8606557377049	81	17	99.6	0	243	1	20	100	KAF7762329.1 hypothetical protein Agabi119p4_8922 [Agaricus bisporus var. burnettii]	diamond	5334	138	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Agaricaceae	Agaricus	Agaricus bisporus
23679409	23679409	PRJNA751877_P_NODE_27479_length_244_cov_1.479532_g27357_i0	PRJNA751877	27479	244	1.479532	3.61005808	Mycena floridula	1033242	Fungi	Fungi	95.5	1.93e-23	NR	KAJ7587393.1	1033242	g27357	i0	59.7	4.37704918032787	77	31	94.7	0	244	14	4	80	KAJ7587393.1 acyl-CoA-binding protein [Mycena floridula]	diamond	1068	95.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena floridula
27252302	27252302	PRJNA751877_P_NODE_26403_length_246_cov_0.890173_g26281_i0	PRJNA751877	26403	246	0.890173	2.18982558	Irpex	5318	Fungi	Fungi	59.7	4.31e-8	NR	KAI0803164.1	5319	g26281	i0	100	1.70731707317073	27	0	32.9	0	165	85	113	139	KAI0803164.1 Dopey, N-terminal-domain-containing protein [Irpex lacteus]	diamond	420	59.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Irpicaceae	Irpex	Irpex lacteus
28379187	28379187	PRJNA751877_P_NODE_23406_length_250_cov_0.870056_g23284_i0	PRJNA751877	23406	250	0.870056	2.17514	Rhodotorula pacifica	1495444	Fungi	Fungi	58.2	1.49e-7	NR	GAA5985262.1	1495444	g23284	i0	56.4	0.66	55	24	66	0	84	248	432	486	GAA5985262.1 hypothetical protein JCM10908_002591 [Rhodotorula pacifica]	diamond	165	58.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula pacifica
28568611	28568611	PRJNA751877_P_NODE_20307_length_263_cov_2.026316_g20185_i0	PRJNA751877	20307	263	2.026316	5.32921108	Wallemia mellicola	1708541	Fungi	Fungi	63.2	2.51e-9	NR	TIB68056.1	1708541	g20185	i0	46.5	0.809885931558935	71	38	81	0	236	24	67	137	TIB68056.1 hypothetical protein E3Q24_03802 [Wallemia mellicola]	diamond	213	63.2	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Wallemiomycetes	Wallemiales	Wallemiaceae	Wallemia	Wallemia mellicola
28663514	28663514	PRJNA751877_P_NODE_3107_length_507_cov_1.041475_g2985_i0	PRJNA751877	3107	507	1.041475	5.28027825	Marasmius crinis-equi	585013	Fungi	Fungi	145	2.4699999999999997e-37	NR	KAL0565053.1	585013	g2985	i0	56.8	9.43786982248521	132	55	76.9	1	438	49	77	208	KAL0565053.1 60S ribosomal protein L6 [Marasmius crinis-equi]	diamond	4785	145	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Marasmiaceae	Marasmius	Marasmius crinis-equi
29452431	29452431	PRJNA751877_P_NODE_24090_length_249_cov_0.875000_g23968_i0	PRJNA751877	24090	249	0.875	2.17875	Peniophora sp. CONT	1314672	Fungi	Fungi	158	5.5699999999999985e-47	NR	KZV70847.1	1314672	g23968	i0	88	2	83	10	100	0	1	249	111	193	KZV70847.1 hypothetical protein PENSPDRAFT_651150, partial [Peniophora sp. CONT]	diamond	498	158	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Peniophoraceae	Peniophora	Peniophora sp. CONT
30526657	30526657	PRJNA751877_P_NODE_29453_length_242_cov_0.911243_g29331_i0	PRJNA751877	29453	242	0.911243	2.20520806	Fomitopsis serialis	139415	Fungi	Fungi	43.5	0.0192	NR	XP_047884224.1	139415	g29331	i0	27.3	0.954545454545455	77	52	95.5	1	6	236	112	184	XP_047884224.1 Metallo-dependent phosphatase-like protein [Fomitopsis serialis]	diamond	231	43.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Fomitopsidaceae	Fomitopsis	Fomitopsis serialis
31548295	31548295	PRJNA751877_P_NODE_30256_length_241_cov_0.916667_g30134_i0	PRJNA751877	30256	241	0.916667	2.20916747	Fungi	4751	Fungi	Fungi	105	8.58e-25	NR	XP_052946024.1	4972	g30134	i0	66.2	9.60995850622407	77	26	95.9	0	9	239	1	77	XP_052946024.1 putative 60S ribosomal protein L4 [Dioszegia hungarica]	diamond	2316	105	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Bulleribasidiaceae	Dioszegia	Dioszegia hungarica
32402382	32402382	PRJNA751877_P_NODE_28139_length_244_cov_0.900585_g28017_i0	PRJNA751877	28139	244	0.900585	2.1974274	Physalacriaceae	862241	Fungi	Fungi	73.2	7.42e-13	NR	KAF8919770.1	139077	g28017	i0	89.5	5.60655737704918	38	4	46.7	0	1	114	1003	1040	KAF8919770.1 hypothetical protein CPB85DRAFT_1373089 [Mucidula mucida]	diamond	1368	73.6	0.994565217391304	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Physalacriaceae	Mucidula	Mucidula mucida
32613552	32613552	PRJNA751877_P_NODE_26960_length_245_cov_0.895349_g26838_i0	PRJNA751877	26960	245	0.895349	2.19360505	Cryptococcus depauperatus	5208	Fungi	Fungi	65.9	2.7e-10	NR	WVO13118.1	5208	g26838	i0	38.6	2.09387755102041	83	27	73.5	2	204	25	262	343	WVO13118.1 hypothetical protein L204_100729 [Cryptococcus depauperatus]	diamond	513	65.9	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Cryptococcus	Cryptococcus depauperatus

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