metadata: contig_metadata: 14 rows where bioproject = "PRJNA1092581", tax_clade = "Opisthokonta" and tax

14 rows where bioproject = "PRJNA1092581", tax_clade = "Opisthokonta" and tax_phylum = "Zoopagomycota"

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
4846525	4846525	PRJNA1092581_P_NODE_56364_length_355_cov_2.141844_g55831_i0	PRJNA1092581	56364	355	2.141844	7.6035462	Fungi	4751	Fungi	Fungi	144	3.05e-37	NR	KAJ1925827.1	78921	g55831	i0	64.3	13.2084507042254	112	39	94.6	1	338	3	351	461	KAJ1925827.1 hypothetical protein IWQ60_004314 [Tieghemiomyces parasiticus]	diamond	4689	145	0.993103448275862	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Tieghemiomyces	Tieghemiomyces parasiticus
9123903	9123903	PRJNA1092581_P_NODE_19168_length_635_cov_5.185053_g18650_i0	PRJNA1092581	19168	635	5.185053	32.92508655	Fungi	4751	Fungi	Fungi	271	2.05e-89	NR	OMH78596.1	1213189	g18650	i0	72.4	33.6803149606299	185	51	87.4	0	36	590	3	187	OMH78596.1 40S ribosomal protein S9 [Zancudomyces culisetae]	diamond	21387	271	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Zancudomyces	Zancudomyces culisetae
18049912	18049912	PRJNA1092581_P_NODE_95035_length_261_cov_1.297872_g94502_i0	PRJNA1092581	95035	261	1.297872	3.3874459200000002	Fungi	4751	Fungi	Fungi	144	3.36e-39	NR	KAI8873377.1	304332	g94502	i0	78.8	15.5287356321839	80	17	92	0	22	261	332	411	KAI8873377.1 citrate synthase [Ramicandelaber brevisporus]	diamond	4053	144	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota		Ramicandelaberales	Ramicandelaberaceae	Ramicandelaber	Ramicandelaber brevisporus
19321983	19321983	PRJNA1092581_P_NODE_18796_length_642_cov_2.137083_g18279_i0	PRJNA1092581	18796	642	2.137083	13.72007286	Syncephalis fuscata	1851187	Fungi	Fungi	202	1.07e-57	NR	KAI9595889.1	1851187	g18279	i0	58.2	1.7196261682243	184	62	85	3	3	548	448	618	KAI9595889.1 Fungalysin metallopeptidase-domain-containing protein [Syncephalis fuscata]	diamond	1104	202	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Piptocephalidaceae	Syncephalis	Syncephalis fuscata
26687675	26687675	PRJNA1092581_P_NODE_126461_length_202_cov_6.744186_g125928_i0	PRJNA1092581	126461	202	6.744186	13.62325572	Coemansia sp. RSA 1646	2512252	Fungi	Fungi	58.9	2.46e-8	NR	KAJ1666236.1	2512252	g125928	i0	56.8	1.36633663366337	44	19	65.3	0	147	16	7	50	KAJ1666236.1 Proteasome subunit beta type-6 [Coemansia sp. RSA 1646]	diamond	276	58.9	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. RSA 1646
26846310	26846310	PRJNA1092581_P_NODE_10101_length_850_cov_12.580438_g9668_i0	PRJNA1092581	10101	850	12.580438	106.933723	Coemansia sp. RSA 27	2012158	Fungi	Fungi	86.3	2.28e-16	NR	KAJ1860105.1	2849857	g9668	i0	32.3	0.776470588235294	220	119	77.6	8	791	132	1	190	KAJ1860105.1 hypothetical protein LPJ73_001525 [Coemansia sp. RSA 2703]	diamond	660	86.3	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. RSA 2703
27099120	27099120	PRJNA1092581_P_NODE_113062_length_235_cov_2.691358_g112529_i0	PRJNA1092581	113062	235	2.691358	6.3246913	Entomophthora muscae	34485	Fungi	Fungi	46.6	0.00145	NR	KAJ9072940.1	34485	g112529	i0	59.4	0.408510638297872	32	13	40.9	0	14	109	415	446	KAJ9072940.1 RNA exonuclease ngl2 [Entomophthora muscae]	diamond	96	46.6	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae
27312052	27312052	PRJNA1092581_P_NODE_42663_length_416_cov_132.489796_g42130_i0	PRJNA1092581	42663	416	132.489796	551.15755136	Zoopagomycota	1913638	Fungi	Fungi	85.1	3.78e-16	NR	KAJ9050822.1	34485	g42130	i0	55.7	3.52644230769231	61	27	44	0	367	185	344	404	KAJ9050822.1 hypothetical protein DSO57_1010616 [Entomophthora muscae]	diamond	1467	85.5	0.9953216374269	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae
29025825	29025825	PRJNA1092581_P_NODE_77188_length_295_cov_5.319820_g76655_i0	PRJNA1092581	77188	295	5.31982	15.693469	Conidiobolus coronatus NRRL 28638	796925	Fungi	Fungi	53.5	8.75e-6	NR	KXN73344.1	796925	g76655	i0	42.5	0.884745762711864	87	36	85.4	3	5	256	194	269	KXN73344.1 hypothetical protein CONCODRAFT_77395 [Conidiobolus coronatus NRRL 28638]	diamond	261	53.5	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Conidiobolus	Conidiobolus coronatus
29647991	29647991	PRJNA1092581_P_NODE_68190_length_317_cov_13.463115_g67657_i0	PRJNA1092581	68190	317	13.463115	42.67807455	Kickxellaceae	4862	Fungi	Fungi	92.4	8.73e-22	NR	KAI8324823.1	61414	g67657	i0	70.5	3.48264984227129	61	18	57.7	0	8	190	47	107	KAI8324823.1 ribosomal protein L35A [Martensiomyces pterosporus]	diamond	1104	92.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Martensiomyces	Martensiomyces pterosporus
30604620	30604620	PRJNA1092581_P_NODE_57353_length_351_cov_4.733813_g56820_i0	PRJNA1092581	57353	351	4.733813	16.61568363	Conidiobolus coronatus NRRL 28638	796925	Fungi	Fungi	120	1.4e-31	NR	KXN65293.1	796925	g56820	i0	93.8	1.09401709401709	65	4	55.6	0	47	241	111	175	KXN65293.1 hypothetical protein CONCODRAFT_13171 [Conidiobolus coronatus NRRL 28638]	diamond	384	120	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Conidiobolus	Conidiobolus coronatus
31164504	31164504	PRJNA1092581_P_NODE_84615_length_279_cov_7.737864_g84082_i0	PRJNA1092581	84615	279	7.737864	21.58864056	Eukaryota	2759	Fungi	Fungi	107	3.9999999999999996e-26	NR	KAI9503237.1	417178	g84082	i0	64.4	40.0860215053763	87	27	89.2	2	3	251	157	243	KAI9503237.1 14-3-3 family protein epsilon [Coemansia spiralis]	diamond	11184	108	0.990740740740741	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia spiralis
32059031	32059031	PRJNA1092581_P_NODE_73598_length_304_cov_2.259740_g73065_i0	PRJNA1092581	73598	304	2.25974	6.8696096	Smittium angustum	133377	Fungi	Fungi	68.6	6.77e-11	NR	PWA01920.1	133377	g73065	i0	45.2	1.18421052631579	62	34	61.2	0	189	4	201	262	PWA01920.1 hypothetical protein BB558_001944 [Smittium angustum]	diamond	360	68.6	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium angustum
32090743	32090743	PRJNA1092581_P_NODE_119958_length_222_cov_5.503356_g119425_i0	PRJNA1092581	119958	222	5.503356	12.21745032	Conidiobolus coronatus NRRL 28638	796925	Fungi	Fungi	57.8	4.56e-9	NR	KXN73003.1	796925	g119425	i0	87.9	11.9459459459459	33	4	44.6	0	7	105	36	68	KXN73003.1 ribosomal protein S28e [Conidiobolus coronatus NRRL 28638]	diamond	2652	57.8	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Conidiobolus	Conidiobolus coronatus

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