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

5 rows where bioproject = "PRJNA951388", 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
26835846	26835846	PRJNA951388_S_NODE_6521_length_333_cov_2.903846_g6394_i0	PRJNA951388	6521	333	2.903846	9.66980718	Dictyocoela muelleri	279532	Fungi	Fungi	54.7	3.55e-6	NR	KAG0423398.1	279532	g6394	i0	39.4	0.594594594594595	66	40	59.5	0	10	207	141	206	KAG0423398.1 Histone-lysine N-methyltransferase SETMAR, partial [Dictyocoela muelleri]	diamond	198	54.7	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Dictyocoela	Dictyocoela muelleri
27341835	27341835	PRJNA951388_S_NODE_5783_length_352_cov_3.229391_g5656_i0	PRJNA951388	5783	352	3.229391	11.36745632	Dictyocoela muelleri	279532	Fungi	Fungi	70.1	4.24e-12	NR	KAG0418335.1	279532	g5656	i0	65.9	1.15909090909091	44	15	37.5	0	119	250	113	156	KAG0418335.1 hypothetical protein DMUE_6402, partial [Dictyocoela muelleri]	diamond	408	70.1	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Dictyocoela	Dictyocoela muelleri
29589678	29589678	PRJNA951388_S_NODE_4550_length_390_cov_2.069401_g4423_i0	PRJNA951388	4550	390	2.069401	8.0706639	Hamiltosporidium	1176354	Fungi	Fungi	135	8.029999999999999e-38	NR	TBT97161.1	148818	g4423	i0	62.8	2.60769230769231	113	42	86.9	0	2	340	1	113	TBT97161.1 hypothetical protein CWI36_3098p0020, partial [Hamiltosporidium magnivora]	diamond	1017	135	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Dubosqiidae	Hamiltosporidium	Hamiltosporidium magnivora
29621119	29621119	PRJNA951388_S_NODE_6750_length_327_cov_2.425197_g6623_i0	PRJNA951388	6750	327	2.425197	7.93039419	Opisthokonta	33154	Fungi	Fungi	55.8	2.22e-6	NR	KAG0439128.1	279532	g6623	i0	30.9	6.76146788990826	97	66	89	1	306	16	60	155	KAG0439128.1 hypothetical protein DMUE_2647 [Dictyocoela muelleri]	diamond	2211	55.8	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Dictyocoela	Dictyocoela muelleri
32617940	32617940	PRJNA951388_S_NODE_6420_length_335_cov_4.003817_g6293_i0	PRJNA951388	6420	335	4.003817	13.41278695	Enteropsectra breve	1912989	Fungi	Fungi	63.9	3.49e-9	NR	KAI5150767.1	1912989	g6293	i0	42.7	1.59402985074627	89	50	79.7	1	68	334	135	222	KAI5150767.1 hypothetical protein ENBRE01_1695 [Enteropsectra breve]	diamond	534	63.9	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Enteropsectra	Enteropsectra breve

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