metadata: contig_metadata: 6 rows where bioproject = "PRJNA849172", tax_kingdom = "Fungi" and tax

6 rows where bioproject = "PRJNA849172", 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
17414416	17414416	PRJNA849172_P_NODE_3854_length_1134_cov_51.790763_g3610_i0	PRJNA849172	3854	1134	51.790763	587.30725242	Fungi	4751	Fungi	Fungi	110	1.79e-23	NR	OLY78120.1	133383	g3610	i0	42.5	2.07936507936508	174	88	45.8	5	1132	614	35	197	OLY78120.1 Phosphatidylinositol N-acetylglucosaminyltransferase GPI2 subunit [Smittium mucronatum]	diamond	2358	111	0.990990990990991	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium mucronatum
27347844	27347844	PRJNA849172_P_NODE_17623_length_494_cov_34.059382_g17264_i0	PRJNA849172	17623	494	34.059382	168.25334708	Fungi	4751	Fungi	Fungi	150	5.18e-40	NR	KAK9766504.1	34480	g17264	i0	52.9	3.39473684210526	140	64	85	1	15	434	312	449	KAK9766504.1 saccharopine dehydrogenase (NADP+, L-glutamate-forming) [Basidiobolus ranarum]	diamond	1677	151	0.993377483443709	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
29084393	29084393	PRJNA849172_P_NODE_93528_length_249_cov_14.630682_g93168_i0	PRJNA849172	93528	249	14.630682	36.43039818	Eukaryota	2759	Fungi	Fungi	72	1.98e-12	NR	KAK9703941.1	34480	g93168	i0	53.8	2.31325301204819	65	29	77.1	1	1	192	509	573	KAK9703941.1 DNA helicase [Basidiobolus ranarum]	diamond	576	72	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
30749960	30749960	PRJNA849172_P_NODE_140654_length_207_cov_4.291045_g140294_i0	PRJNA849172	140654	207	4.2910450000000004	8.88246315	Spiromyces aspiralis	68401	Fungi	Fungi	60.1	1.74e-8	NR	KAJ1678471.1	68401	g140294	i0	42.4	0.956521739130435	66	38	95.7	0	206	9	91	156	KAJ1678471.1 Pre-rRNA-processing protein ipi3 [Spiromyces aspiralis]	diamond	198	60.1	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Spiromyces	Spiromyces aspiralis
31168794	31168794	PRJNA849172_P_NODE_27475_length_391_cov_28.327044_g27116_i0	PRJNA849172	27475	391	28.327044	110.75874204	Eukaryota	2759	Fungi	Fungi	94.4	5.16e-21	NR	RKP35578.1	215637	g27116	i0	82.4	1.17391304347826	51	9	39.1	0	391	239	88	138	RKP35578.1 ras-related protein RABB1c-like protein [Dimargaris cristalligena]	diamond	459	95.1	0.992639327024185	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dimargaris	Dimargaris cristalligena
32898802	32898802	PRJNA849172_P_NODE_112280_length_238_cov_10.587879_g111920_i0	PRJNA849172	112280	238	10.587879	25.19915202	Coemansia brasiliensis	2650707	Fungi	Fungi	46.6	8.13e-4	NR	KAJ2850962.1	2650707	g111920	i0	35.8	1.02100840336134	81	46	94.5	1	1	225	29	109	KAJ2850962.1 translation machinery-associated protein 16 [Coemansia brasiliensis]	diamond	243	46.6	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia brasiliensis

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