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

14 rows where bioproject = "PRJNA738523", 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
12198930	12198930	PRJNA738523_P_NODE_4210_length_338_cov_3.362264_g4139_i0	PRJNA738523	4210	338	3.362264	11.36445232	Basidiobolus meristosporus CBS 931.73	1314790	Fungi	Fungi	114	7.6899999999999995e-28	NR	ORY05845.1	1314790	g4139	i0	57.4	0.896449704142012	101	36	89.6	3	32	334	10	103	ORY05845.1 reductase M2 polypeptide variant 3d [Basidiobolus meristosporus CBS 931.73]	diamond	303	114	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
17297600	17297600	PRJNA738523_P_NODE_14554_length_244_cov_0.900585_g14483_i0	PRJNA738523	14554	244	0.900585	2.1974274	Basidiobolus meristosporus CBS 931.73	1314790	Fungi	Fungi	150	2.64e-44	NR	ORX88462.1	1314790	g14483	i0	86.4	7.9672131147541	81	11	99.6	0	2	244	73	153	ORX88462.1 hypothetical protein K493DRAFT_290577 [Basidiobolus meristosporus CBS 931.73]	diamond	1944	150	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus meristosporus
21122088	21122088	PRJNA738523_P_NODE_13337_length_246_cov_0.890173_g13266_i0	PRJNA738523	13337	246	0.890173	2.18982558	Coemansia	4863	Fungi	Fungi	90.5	3.31e-20	NR	KAJ2882654.1	1052880	g13266	i0	60.6	12.0243902439024	71	28	86.6	0	7	219	115	185	KAJ2882654.1 proteasome regulatory particle subunit, partial [Coemansia asiatica]	diamond	2958	90.9	0.995599559955996	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia asiatica
23672587	23672587	PRJNA738523_P_NODE_6759_length_286_cov_1.769953_g6688_i0	PRJNA738523	6759	286	1.769953	5.06206558	Entomophthora muscae	34485	Fungi	Fungi	112	2.17e-27	NR	KAJ9058134.1	34485	g6688	i0	63.5	1.00699300699301	96	29	95.5	3	2	274	17	111	KAJ9058134.1 Molecular chaperone (DnaJ super) [Entomophthora muscae]	diamond	288	112	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae
24149339	24149339	PRJNA738523_P_NODE_13259_length_246_cov_0.890173_g13188_i0	PRJNA738523	13259	246	0.890173	2.18982558	Coemansia javaensis	2761396	Fungi	Fungi	118	1.84e-29	NR	KAJ2784795.1	2761396	g13188	i0	66.7	0.98780487804878	81	27	98.8	0	244	2	132	212	KAJ2784795.1 S-adenosyl-L-homocysteine hydrolase [Coemansia javaensis]	diamond	243	118	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia javaensis
24945986	24945986	PRJNA738523_P_NODE_15720_length_242_cov_0.911243_g15649_i0	PRJNA738523	15720	242	0.911243	2.20520806	Syncephalis	78910	Fungi	Fungi	120	2.3499999999999998e-32	NR	RKP22221.1	1712513	g15649	i0	71.1	1.88429752066116	76	22	94.2	0	230	3	90	165	RKP22221.1 Ribose/Galactose isomerase-domain-containing protein, partial [Syncephalis pseudoplumigaleata]	diamond	456	120	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Zoopagomycetes	Zoopagales	Piptocephalidaceae	Syncephalis	Syncephalis pseudoplumigaleata
27337087	27337087	PRJNA738523_P_NODE_5783_length_302_cov_0.890830_g5712_i0	PRJNA738523	5783	302	0.89083	2.6903066	Smittium culicis	133412	Fungi	Fungi	68.2	9.01e-11	NR	OMJ17362.1	133412	g5712	i0	52.4	1.87748344370861	63	30	62.6	0	92	280	1293	1355	OMJ17362.1 Calcium-transporting ATPase 1 [Smittium culicis]	diamond	567	68.2	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium culicis
28189231	28189231	PRJNA738523_P_NODE_12946_length_247_cov_0.885057_g12875_i0	PRJNA738523	12946	247	0.885057	2.18609079	Coemansia helicoidea	1286919	Fungi	Fungi	95.5	3.58e-22	NR	KAJ2796721.1	1286919	g12875	i0	53.1	2.91497975708502	81	38	98.4	0	245	3	25	105	KAJ2796721.1 hypothetical protein H4R21_004602 [Coemansia helicoidea]	diamond	720	95.5	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia helicoidea
28704944	28704944	PRJNA738523_P_NODE_12127_length_248_cov_0.880000_g12056_i0	PRJNA738523	12127	248	0.88	2.1824	Coemansia	4863	Fungi	Fungi	77.4	1.63e-14	NR	PIA16963.1	763665	g12056	i0	94.3	5.47983870967742	35	2	42.3	0	247	143	319	353	PIA16963.1 transcription elongation factor [Coemansia reversa NRRL 1564]	diamond	1359	77.4	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia reversa
29525880	29525880	PRJNA738523_P_NODE_10850_length_251_cov_0.865169_g10779_i0	PRJNA738523	10850	251	0.865169	2.17157419	Coemansia	4863	Fungi	Fungi	79	2.75e-16	NR	KAJ2257032.1	2663915	g10779	i0	62.1	6.93227091633466	58	20	66.9	1	1	168	93	150	KAJ2257032.1 ribosomal protein S7A, partial [Coemansia sp. RSA 455]	diamond	1740	79	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Kickxellomycetes	Kickxellales	Kickxellaceae	Coemansia	Coemansia sp. RSA 455
29967885	29967885	PRJNA738523_P_NODE_14291_length_244_cov_0.900585_g14220_i0	PRJNA738523	14291	244	0.900585	2.1974274	Fungi	4751	Fungi	Fungi	88.6	1.39e-20	NR	KAJ1930003.1	78921	g14220	i0	61.5	1.93032786885246	78	25	95.9	2	238	5	14	86	KAJ1930003.1 60S ribosomal protein L33B [Tieghemiomyces parasiticus]	diamond	471	88.6	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Tieghemiomyces	Tieghemiomyces parasiticus
30400506	30400506	PRJNA738523_P_NODE_3873_length_348_cov_3.509091_g3802_i0	PRJNA738523	3873	348	3.509091	12.21163668	Dimargaris cristalligena	215637	Fungi	Fungi	90.1	2.49e-20	NR	KAJ1984035.1	215637	g3802	i0	39.1	2.77586206896552	110	66	94	1	343	17	29	138	KAJ1984035.1 cofilin [Dimargaris cristalligena]	diamond	966	90.1	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dimargaris	Dimargaris cristalligena
30937297	30937297	PRJNA738523_P_NODE_13494_length_246_cov_0.890173_g13423_i0	PRJNA738523	13494	246	0.890173	2.18982558	Massospora cicadina	348617	Fungi	Fungi	78.2	4.63e-16	NR	KAI0217107.1	348617	g13423	i0	55.4	4.41463414634146	74	32	90.2	1	229	8	22	94	KAI0217107.1 hypothetical protein L0F63_003640 [Massospora cicadina]	diamond	1086	78.2	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Massospora	Massospora cicadina
32550503	32550503	PRJNA738523_P_NODE_13999_length_245_cov_0.895349_g13928_i0	PRJNA738523	13999	245	0.895349	2.19360505	Smittium culicis	133412	Fungi	Fungi	54.3	2.03e-6	NR	OMJ11049.1	133412	g13928	i0	36.5	1.04081632653061	85	45	93.1	3	245	18	28	112	OMJ11049.1 UPF0220 protein [Smittium culicis]	diamond	255	54.3	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Legeriomycetaceae	Smittium	Smittium culicis

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