metadata: contig_metadata: 5 rows where bioproject = "PRJNA438111", tax_kingdom = "Fungi" and tax

5 rows where bioproject = "PRJNA438111", tax_kingdom = "Fungi" and tax_phylum = "Microsporidia"

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_family	tax_genus	tax_species
27755934	27755934	PRJNA438111_P_NODE_45124_length_187_cov_3.822785_g44499_i0	PRJNA438111	45124	187	3.822785	7.14860795	Eukaryota	2759	Fungi	Fungi	58.5	4.74e-8	NR	EJW03807.1	1003232	g44499	i0	48.4	4.97326203208556	62	29	99.5	1	186	1	158	216	EJW03807.1 hypothetical protein EDEG_01899 [Edhazardia aedis USNM 41457]	diamond	930	58.9	0.99320882852292	Eukaryota	Opisthokonta	Fungi	Microsporidia	Culicosporidae	Edhazardia	Edhazardia aedis
28339245	28339245	PRJNA438111_P_NODE_21266_length_233_cov_5.240196_g20641_i0	PRJNA438111	21266	233	5.240196	12.20965668	Hamiltosporidium magnivora	148818	Fungi	Fungi	50.4	6.11e-5	NR	TBT99726.1	148818	g20641	i0	51.5	0.849785407725322	33	16	42.5	0	230	132	341	373	TBT99726.1 subunit A of calcineurin, partial [Hamiltosporidium magnivora]	diamond	198	50.4	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Dubosqiidae	Hamiltosporidium	Hamiltosporidium magnivora
29507388	29507388	PRJNA438111_P_NODE_19550_length_242_cov_3.488263_g18925_i0	PRJNA438111	19550	242	3.488263	8.44159646	Vairimorpha necatrix	6039	Fungi	Fungi	45.1	0.00548	NR	XP_065330076.1	6039	g18925	i0	48.9	2.21900826446281	47	24	58.3	0	198	58	108	154	XP_065330076.1 E3 ubiquitin-protein ligase [Vairimorpha necatrix]	diamond	537	45.1	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vairimorpha	Vairimorpha necatrix
29886525	29886525	PRJNA438111_P_NODE_1991_length_681_cov_3.466258_g1591_i0	PRJNA438111	1991	681	3.466258	23.60521698	Dictyocoela muelleri	279532	Fungi	Fungi	143	1.2e-35	NR	KAG0442643.1	279532	g1591	i0	39.9	0.960352422907489	218	116	93	6	672	40	126	335	KAG0442643.1 Glutathione hydrolase proenzyme 1 [Dictyocoela muelleri]	diamond	654	143	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Dictyocoela	Dictyocoela muelleri
30707771	30707771	PRJNA438111_P_NODE_12394_length_294_cov_2.913208_g11769_i0	PRJNA438111	12394	294	2.913208	8.56483152	Vairimorpha bombi	40135	Fungi	Fungi	138	9.07e-36	NR	KAK6090347.1	40135	g11769	i0	63.3	1	98	35	100	1	1	294	345	441	KAK6090347.1 hypothetical protein P3W45_000704 [Vairimorpha bombi]	diamond	294	138	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vairimorpha	Vairimorpha bombi

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