metadata: contig_metadata: 11 rows where bioproject = "PRJNA914897", tax_kingdom = "Fungi" and tax

11 rows where bioproject = "PRJNA914897", 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
2170231	2170231	PRJNA914897_P_NODE_22282_length_353_cov_0.821429_g21858_i0	PRJNA914897	22282	353	0.821429	2.89964437	Dictyocoela roeselum	288439	Fungi	Fungi	112	3.18e-28	NR	KAG0416618.1	288439	g21858	i0	46.2	2.93201133144476	117	55	99.4	2	351	1	72	180	KAG0416618.1 DNA-directed RNA polymerase II subunit RPB2, partial [Dictyocoela roeselum]	diamond	1035	112	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Dictyocoela	Dictyocoela roeselum
4723310	4723310	PRJNA914897_P_NODE_12724_length_512_cov_1.578588_g12304_i0	PRJNA914897	12724	512	1.578588	8.08237056	Hepatospora eriocheir	1081669	Fungi	Fungi	60.5	3.45e-7	NR	ORD96424.1	1081669	g12304	i0	46.7	0.3515625	60	32	35.2	0	257	436	145	204	ORD96424.1 IF4A [Hepatospora eriocheir]	diamond	180	60.5	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Hepatosporidae	Hepatospora	Hepatospora eriocheir
16197806	16197806	PRJNA914897_P_NODE_33553_length_268_cov_1.184615_g33129_i0	PRJNA914897	33553	268	1.184615	3.1747682	Anncaliia	311453	Fungi	Fungi	81.6	2.19e-16	NR	KCZ74381.1	1240240	g33129	i0	47.4	2.60820895522388	78	41	87.3	0	238	5	71	148	KCZ74381.1 CMGC/CDK/CDC2 protein kinase, partial [Anncaliia algerae PRA109]	diamond	699	81.6	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Tubulinosematidae	Anncaliia	Anncaliia algerae
26714958	26714958	PRJNA914897_P_NODE_25541_length_322_cov_1.546185_g25117_i0	PRJNA914897	25541	322	1.546185	4.9787157	Enterocytozoonidae	27970	Fungi	Fungi	43.9	0.0362	NR	EED44513.1	481877	g25117	i0	43.8	1.3416149068323	48	27	44.7	0	179	322	399	446	EED44513.1 SMP2 protein [Enterocytozoon bieneusi H348]	diamond	432	43.9	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Enterocytozoon	Enterocytozoon bieneusi
26992657	26992657	PRJNA914897_P_NODE_37642_length_249_cov_1.147727_g37218_i0	PRJNA914897	37642	249	1.147727	2.85784023	Encephalitozoon hellem ATCC 5	27973	Fungi	Fungi	47.4	8.86e-4	NR	XP_003887916.1	907965	g37218	i0	37.3	0.903614457831325	75	33	86.7	3	33	248	35	98	XP_003887916.1 mRNA capping enzyme subunit alpha [Encephalitozoon hellem ATCC 50504]	diamond	225	47.4	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Unikaryonidae	Encephalitozoon	Encephalitozoon hellem
27119094	27119094	PRJNA914897_P_NODE_35002_length_259_cov_1.580645_g34578_i0	PRJNA914897	35002	259	1.580645	4.09387055	Ordospora colligata OC4	1354746	Fungi	Fungi	89	7.02e-19	NR	XP_014562876.1	1354746	g34578	i0	53.4	1.69111969111969	73	33	84.6	1	12	230	179	250	XP_014562876.1 PP1 serine/threonine phosphatase [Ordospora colligata OC4]	diamond	438	89	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Ordosporidae	Ordospora	Ordospora colligata
28130130	28130130	PRJNA914897_P_NODE_23965_length_336_cov_1.486692_g23541_i0	PRJNA914897	23965	336	1.486692	4.99528512	Enterocytozoon bieneusi H348	481877	Fungi	Fungi	43.9	0.0399	NR	EED43697.1	481877	g23541	i0	27.7	0.741071428571429	83	60	74.1	0	336	88	166	248	EED43697.1 vacuolar acidic amino acid exporter AVT6 [Enterocytozoon bieneusi H348]	diamond	249	43.9	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Enterocytozoon	Enterocytozoon bieneusi
28611018	28611018	PRJNA914897_P_NODE_30047_length_288_cov_1.176744_g29623_i0	PRJNA914897	30047	288	1.176744	3.38902272	Fungi	4751	Fungi	Fungi	93.6	1.26e-20	NR	EQB62048.1	1037528	g29623	i0	52.9	13.9270833333333	87	41	90.6	0	262	2	197	283	EQB62048.1 dna replication factor c subunit [Vairimorpha apis BRL 01]	diamond	4011	93.6	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vairimorpha	Vairimorpha apis
29961336	29961336	PRJNA914897_P_NODE_20731_length_370_cov_1.296296_g20308_i0	PRJNA914897	20731	370	1.296296	4.7962952	Hepatospora eriocheir	1081669	Fungi	Fungi	47	0.00449	NR	ORD99484.1	1081669	g20308	i0	32.7	0.891891891891892	110	60	88.4	3	349	23	3	99	ORD99484.1 DPOD2 [Hepatospora eriocheir]	diamond	330	47	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Hepatosporidae	Hepatospora	Hepatospora eriocheir
30790185	30790185	PRJNA914897_P_NODE_4354_length_962_cov_14.964004_g3979_i1	PRJNA914897	4354	962	14.964004	143.95371848	Fungi	4751	Fungi	Fungi	194	5.08e-56	NR	EJW03775.1	1003232	g3979	i1	38.5	16.6403326403326	260	147	81.1	4	78	857	11	257	EJW03775.1 hypothetical protein EDEG_01931 [Edhazardia aedis USNM 41457]	diamond	16008	194	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Culicosporidae	Edhazardia	Edhazardia aedis
32774248	32774248	PRJNA914897_P_NODE_36100_length_253_cov_1.283333_g35676_i0	PRJNA914897	36100	253	1.283333	3.24683249	Mitosporidium daphniae	1485682	Fungi	Fungi	63.2	2.7e-9	NR	XP_013238975.1	1485682	g35676	i0	56.8	0.521739130434783	44	19	52.2	0	142	11	69	112	XP_013238975.1 lysine-tRNA ligase [Mitosporidium daphniae]	diamond	132	63.2	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae

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