metadata: contig_metadata: 9 rows where bioproject = "PRJNA1123309", tax_kingdom = "Fungi" and tax

9 rows where bioproject = "PRJNA1123309", 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
25255319	25255319	PRJNA1123309_P_NODE_33180_length_287_cov_1.509346_g32800_i0	PRJNA1123309	33180	287	1.509346	4.33182302	Eukaryota	2759	Fungi	Fungi	147	8.62e-41	NR	RKP09286.1	78915	g32800	i0	75	7.23344947735192	88	22	92	0	272	9	21	108	RKP09286.1 ATPase GET3 [Thamnocephalis sphaerospora]	diamond	2076	147	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Sigmoideomycetaceae	Thamnocephalis	Thamnocephalis sphaerospora
26975227	26975227	PRJNA1123309_P_NODE_58742_length_246_cov_0.901734_g58362_i0	PRJNA1123309	58742	246	0.901734	2.21826564	Conidiobolus coronatus NRRL 28638	796925	Fungi	Fungi	72.4	1.37e-12	NR	KXN68529.1	796925	g58362	i0	48.1	2.10975609756098	79	32	93.9	4	14	244	649	720	KXN68529.1 kinase-like protein [Conidiobolus coronatus NRRL 28638]	diamond	519	72.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Conidiobolus	Conidiobolus coronatus
27133022	27133022	PRJNA1123309_P_NODE_5662_length_614_cov_8.426987_g5313_i0	PRJNA1123309	5662	614	8.426987	51.74170018	Basidiobolus meristosporus CBS 931.73	1314790	Fungi	Fungi	124	9.57e-32	NR	ORX94009.1	1314790	g5313	i0	41.8	2.5114006514658	184	98	88.9	3	546	1	3	179	ORX94009.1 F1 complex, OSCP/delta subunit of ATPase [Basidiobolus meristosporus CBS 931.73]	diamond	1542	124	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
27848901	27848901	PRJNA1123309_P_NODE_16704_length_381_cov_1.000000_g16325_i0	PRJNA1123309	16704	381	1	3.81	Eukaryota	2759	Fungi	Fungi	147	5.88e-42	NR	RKP08891.1	78915	g16325	i0	59.3	9.68503937007874	123	46	94.5	2	370	11	83	204	RKP08891.1 ras family-domain-containing protein [Thamnocephalis sphaerospora]	diamond	3690	148	0.993243243243243	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Sigmoideomycetaceae	Thamnocephalis	Thamnocephalis sphaerospora
28449189	28449189	PRJNA1123309_P_NODE_45846_length_255_cov_2.489011_g45466_i0	PRJNA1123309	45846	255	2.489011	6.34697805	Fungi	4751	Fungi	Fungi	51.6	3.23e-5	NR	ORX99155.1	1314790	g45466	i0	41.4	2.4	58	32	65.9	1	243	76	400	457	ORX99155.1 U3 small nucleolar RNA-associated protein 15, partial [Basidiobolus meristosporus CBS 931.73]	diamond	612	51.6	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
29880841	29880841	PRJNA1123309_P_NODE_57191_length_247_cov_0.896552_g56811_i0	PRJNA1123309	57191	247	0.896552	2.21448344	Dimargaris cristalligena	215637	Fungi	Fungi	47	0.00128	NR	KAJ1986233.1	215637	g56811	i0	42.5	1.65182186234818	73	38	83.8	1	235	29	657	729	KAJ1986233.1 hypothetical protein H4R33_003481 [Dimargaris cristalligena]	diamond	408	47	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dimargaris	Dimargaris cristalligena
31428980	31428980	PRJNA1123309_P_NODE_65636_length_242_cov_1.224852_g65256_i0	PRJNA1123309	65636	242	1.224852	2.96414184	Spiromyces aspiralis	68401	Fungi	Fungi	55.1	1.01e-7	NR	KAJ1677474.1	68401	g65256	i0	56.4	0.681818181818182	55	20	68.2	1	240	76	9	59	KAJ1677474.1 cyclin-dependent protein kinase [Spiromyces aspiralis]	diamond	165	55.1	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Spiromyces	Spiromyces aspiralis
32219970	32219970	PRJNA1123309_P_NODE_57438_length_247_cov_0.896552_g57058_i0	PRJNA1123309	57438	247	0.896552	2.21448344	Coemansia biformis	1286918	Fungi	Fungi	50.4	7.39e-5	NR	KAJ1729247.1	1286918	g57058	i0	43.1	2.11336032388664	58	33	70.4	0	15	188	532	589	KAJ1729247.1 RNA-binding ribosome biosynthesis protein mak21, partial [Coemansia biformis]	diamond	522	50.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia biformis
32557423	32557423	PRJNA1123309_P_NODE_38159_length_275_cov_1.465347_g37779_i0	PRJNA1123309	38159	275	1.465347	4.02970425	root	1	Root_unresolved	Root_unresolved	77.4	1.39e-15	NR	XP_040743198.1	61395	g37779	i0	54.3	1.35272727272727	70	32	76.4	0	211	2	1	70	XP_040743198.1 uncharacterized protein DL89DRAFT_267709 [Linderina pennispora]	diamond	372	77.8	0.994858611825193	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Linderina	Linderina pennispora

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