metadata: contig_metadata: 14 rows where bioproject = "PRJNA1126198", tax_kingdom = "Fungi" and tax

14 rows where bioproject = "PRJNA1126198", tax_kingdom = "Fungi" 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
1030534	1030534	PRJNA1126198_P_NODE_53941_length_391_cov_3.594340_g53224_i0	PRJNA1126198	53941	391	3.59434	14.0538694	Dimargaris cristalligena	215637	Fungi	Fungi	107	5.79e-28	NR	RKP37978.1	215637	g53224	i0	86.9	16.2890025575448	61	8	46.8	0	18	200	7	67	RKP37978.1 ribosomal protein S28e, partial [Dimargaris cristalligena]	diamond	6369	107	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dimargaris	Dimargaris cristalligena
10485023	10485023	PRJNA1126198_P_NODE_365289_length_252_cov_1.608939_g364568_i0	PRJNA1126198	365289	252	1.608939	4.05452628	Eukaryota	2759	Fungi	Fungi	124	1.15e-30	NR	PVV02380.1	133381	g364568	i0	69	15.952380952381	84	25	98.8	1	3	251	64	147	PVV02380.1 hypothetical protein BB560_003167, partial [Smittium megazygosporum]	diamond	4020	125	0.992	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium megazygosporum
13034831	13034831	PRJNA1126198_P_NODE_155371_length_310_cov_2.565401_g154652_i0	PRJNA1126198	155371	310	2.565401	7.9527431	Zoophagus pectosporus	2082958	Fungi	Fungi	126	1.68e-24	NTclustered	gi\|2130025291\|gb\|OL396565.1\|	2082958	g154652	i0	83.704	36.0838709677419	135	21	43	1	136	269	201	335	Zoophagus pectosporus isolate B39 large subunit ribosomal RNA gene, partial sequence	blastn	11186	126	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Zoopagaceae	Zoophagus	Zoophagus pectosporus
16858248	16858248	PRJNA1126198_P_NODE_10714_length_582_cov_5.915521_g10043_i0	PRJNA1126198	10714	582	5.915521	34.42833222	Fungi	4751	Fungi	Fungi	175	2.01e-51	NR	ORX94405.1	1314790	g10043	i0	58.4	5.10309278350515	161	62	80.9	3	487	17	79	238	ORX94405.1 hypothetical protein K493DRAFT_315504 [Basidiobolus meristosporus CBS 931.73]	diamond	2970	175	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
19407007	19407007	PRJNA1126198_P_NODE_15596_length_524_cov_8.895787_g14911_i0	PRJNA1126198	15596	524	8.895787	46.61392388	Spiromyces aspiralis	68401	Fungi	Fungi	162	1.28e-47	NR	KAJ1675135.1	68401	g14911	i0	56	3.88740458015267	134	58	76.1	1	499	101	6	139	KAJ1675135.1 Protein component of the small (40S) ribosomal subunit [Spiromyces aspiralis]	diamond	2037	162	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Spiromyces	Spiromyces aspiralis
24507236	24507236	PRJNA1126198_P_NODE_259300_length_275_cov_3.777228_g258579_i0	PRJNA1126198	259300	275	3.777228	10.387377	Entomophthora muscae	34485	Fungi	Fungi	207	5.0999999999999995e-49	NTclustered	gi\|82398173\|gb\|DQ273772.1\|	34485	g258579	i0	80.783	17.2763636363636	281	40	100	13	1	275	1963	1691	Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence	blastn	4751	207	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae
27196520	27196520	PRJNA1126198_P_NODE_484762_length_232_cov_2.729560_g484041_i0	PRJNA1126198	484762	232	2.72956	6.3325792	Piptocephalis tieghemiana	1286916	Fungi	Fungi	61.2	2.61e-9	NR	KAI9229188.1	1286916	g484041	i0	35.9	1.00862068965517	78	45	97	2	226	2	19	94	KAI9229188.1 MAG: putative E2 ubiquitin-conjugating enzyme [Piptocephalis tieghemiana]	diamond	234	61.2	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Piptocephalidaceae	Piptocephalis	Piptocephalis tieghemiana
27733990	27733990	PRJNA1126198_P_NODE_383804_length_250_cov_1.378531_g383083_i0	PRJNA1126198	383804	250	1.378531	3.4463275	Basidiobolus ranarum	34480	Fungi	Fungi	87.8	4.75e-18	NR	KAK9704053.1	34480	g383083	i0	44.4	0.972	81	44	96	1	249	10	194	274	KAK9704053.1 hypothetical protein K7432_010416 [Basidiobolus ranarum]	diamond	243	87.8	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
28586387	28586387	PRJNA1126198_P_NODE_484987_length_232_cov_2.496855_g484266_i0	PRJNA1126198	484987	232	2.496855	5.7927036	Mycoemilia scoparia	417184	Fungi	Fungi	99.8	2.7900000000000003e-22	NR	KAJ1920911.1	417184	g484266	i0	64.5	2.97413793103448	76	27	98.3	0	229	2	134	209	KAJ1920911.1 fimbrin [Mycoemilia scoparia]	diamond	690	99.8	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Mycoemilia	Mycoemilia scoparia
30133127	30133127	PRJNA1126198_P_NODE_47192_length_403_cov_1.418182_g46475_i0	PRJNA1126198	47192	403	1.418182	5.71527346	Piptocephalis tieghemiana	1286916	Fungi	Fungi	108	4.25e-26	NR	KAI9227759.1	1286916	g46475	i0	39.7	1.96526054590571	136	67	91.6	2	372	4	17	150	KAI9227759.1 MAG: hypothetical protein DHS80DRAFT_23983 [Piptocephalis tieghemiana]	diamond	792	108	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Piptocephalidaceae	Piptocephalis	Piptocephalis tieghemiana
30217312	30217312	PRJNA1126198_P_NODE_362612_length_253_cov_0.866667_g361891_i0	PRJNA1126198	362612	253	0.866667	2.19266751	Fungi	4751	Fungi	Fungi	121	9.47e-30	NR	ORX99045.1	1314790	g361891	i0	67.9	10.9565217391304	84	27	99.6	0	252	1	193	276	ORX99045.1 transketolase [Basidiobolus meristosporus CBS 931.73]	diamond	2772	122	0.991803278688525	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
30260104	30260104	PRJNA1126198_P_NODE_29392_length_449_cov_1.361702_g28686_i0	PRJNA1126198	29392	449	1.361702	6.11404198	Furculomyces boomerangus	61424	Fungi	Fungi	81.6	5.61e-15	NR	PVU90645.1	61424	g28686	i0	44.8	1.14253897550111	87	44	56.1	2	254	3	1	86	PVU90645.1 hypothetical protein BB559_004513 [Furculomyces boomerangus]	diamond	513	81.6	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Furculomyces	Furculomyces boomerangus
31397606	31397606	PRJNA1126198_P_NODE_203716_length_291_cov_1.779817_g202996_i0	PRJNA1126198	203716	291	1.779817	5.17926747	Basidiobolus ranarum	34480	Fungi	Fungi	65.5	4.19e-10	NR	KAK9767093.1	34480	g202996	i0	37.5	0.824742268041237	80	50	82.5	0	264	25	38	117	KAK9767093.1 hypothetical protein K7432_003360 [Basidiobolus ranarum]	diamond	240	65.5	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
32756970	32756970	PRJNA1126198_P_NODE_483740_length_233_cov_2.412500_g483019_i0	PRJNA1126198	483740	233	2.4125	5.621125	Basidiobolus ranarum	34480	Fungi	Fungi	79.7	2.85e-15	NR	KAK9704053.1	34480	g483019	i0	61.2	0.862660944206009	67	24	83.7	1	3	197	87	153	KAK9704053.1 hypothetical protein K7432_010416 [Basidiobolus ranarum]	diamond	201	79.7	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum

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