metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA1089179" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA1089179" 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
27162123	27162123	PRJNA1089179_P_NODE_18202_length_210_cov_9.927007_g18184_i0	PRJNA1089179	18202	210	9.927007	20.8467147	Vanrija pseudolonga	143232	Fungi	Fungi	46.6	9.47e-4	NR	XP_062624445.1	143232	g18184	i0	86.7	0.428571428571429	30	4	42.9	0	12	101	236	265	XP_062624445.1 uncharacterized protein LOC62_02G001960 [Vanrija pseudolonga]	diamond	90	46.6	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Trichosporonales	Trichosporonaceae	Vanrija	Vanrija pseudolonga
27257167	27257167	PRJNA1089179_P_NODE_6203_length_352_cov_1.017921_g6185_i0	PRJNA1089179	6203	352	1.017921	3.58308192	Irpex lacteus	5319	Fungi	Fungi	189	4.15e-58	NR	KAI0779077.1	5319	g6185	i0	95	1.70454545454545	100	5	85.2	0	1	300	145	244	KAI0779077.1 hypothetical protein BC629DRAFT_587796 [Irpex lacteus]	diamond	600	189	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Irpicaceae	Irpex	Irpex lacteus
27541560	27541560	PRJNA1089179_P_NODE_13764_length_256_cov_1.398907_g13746_i0	PRJNA1089179	13764	256	1.398907	3.58120192	Peniophora sp. CONT	1314672	Fungi	Fungi	129	2.08e-32	NR	KZV65910.1	1314672	g13746	i0	82.9	0.9609375	82	14	96.1	0	254	9	304	385	KZV65910.1 DNA-binding protein [Peniophora sp. CONT]	diamond	246	129	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Peniophoraceae	Peniophora	Peniophora sp. CONT
27754141	27754141	PRJNA1089179_P_NODE_17624_length_235_cov_37.913580_g17606_i0	PRJNA1089179	17624	235	37.91358	89.096913	Polyporales	5303	Fungi	Fungi	107	1.43e-27	NR	KAI0084914.1	378272	g17606	i0	76.8	4.36595744680851	69	12	88.1	1	11	217	86	150	KAI0084914.1 NAD-P-binding protein [Irpex rosettiformis]	diamond	1026	107	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Irpicaceae	Irpex	Irpex rosettiformis
28235833	28235833	PRJNA1089179_P_NODE_7026_length_336_cov_0.916350_g7008_i0	PRJNA1089179	7026	336	0.91635	3.078936	Hebeloma cylindrosporum	76867	Fungi	Fungi	45.8	0.00913	NR	KIM37668.1	76867	g7008	i0	35	0.535714285714286	60	37	52.7	2	248	72	199	257	KIM37668.1 hypothetical protein M413DRAFT_30844 [Hebeloma cylindrosporum]	diamond	180	45.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Hymenogastraceae	Hebeloma	Hebeloma cylindrosporum
29656533	29656533	PRJNA1089179_P_NODE_17750_length_232_cov_28.962264_g17732_i0	PRJNA1089179	17750	232	28.962264	67.19245248	Sparassis crispa	139825	Fungi	Fungi	57.4	2.28e-7	NR	XP_027618488.1	139825	g17732	i0	51.1	0.607758620689655	47	23	60.8	0	68	208	798	844	XP_027618488.1 predicted protein [Sparassis crispa]	diamond	141	57.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Sparassidaceae	Sparassis	Sparassis crispa
29656535	29656535	PRJNA1089179_P_NODE_6490_length_346_cov_1.769231_g6472_i0	PRJNA1089179	6490	346	1.769231	6.12153926	Mycena maculata	230809	Fungi	Fungi	57.8	1.4e-7	NR	KAJ7746787.1	230809	g6472	i0	51.3	0.893063583815029	39	19	33.8	0	80	196	37	75	KAJ7746787.1 PLAC8 family-domain-containing protein [Mycena maculata]	diamond	309	57.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena maculata
29751397	29751397	PRJNA1089179_P_NODE_13491_length_258_cov_31.908108_g13473_i0	PRJNA1089179	13491	258	31.908108	82.32291864	Irpex lacteus	5319	Fungi	Fungi	136	6.28e-35	NR	KAI0806225.1	5319	g13473	i0	100	0.848837209302326	73	0	84.9	0	237	19	82	154	KAI0806225.1 multidrug resistance-associated ABC transporter [Irpex lacteus]	diamond	219	136	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Polyporales	Irpicaceae	Irpex	Irpex lacteus
32303883	32303883	PRJNA1089179_P_NODE_10179_length_290_cov_1.419355_g10161_i0	PRJNA1089179	10179	290	1.419355	4.1161295	Eukaryota	2759	Fungi	Fungi	70.5	3.13e-13	NR	KAJ6577258.1	230804	g10161	i0	47.3	3.85862068965517	74	29	76.6	1	43	264	50	113	KAJ6577258.1 hypothetical protein B0H19DRAFT_1252626 [Mycena capillaripes]	diamond	1119	70.9	0.994358251057828	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena capillaripes

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