metadata: contig_metadata: 7 rows where bioproject = "PRJNA715462", tax_kingdom = "Fungi" and tax

7 rows where bioproject = "PRJNA715462", 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
12185414	12185414	PRJNA715462_P_NODE_47770_length_258_cov_1.632432_g46974_i0	PRJNA715462	47770	258	1.632432	4.21167456	Mitosporidium daphniae	1485682	Fungi	Fungi	104	6.39e-18	NTclustered	gi\|914965164\|ref\|XM_013383825.1\|	1485682	g46974	i0	89.412	26.6240310077519	85	6	33	2	1	85	176	257	Mitosporidium daphniae putative ubiquitin/ribosomal protein S27a fusion protein (DI09_12p200), partial mRNA	blastn	6869	104	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
19833186	19833186	PRJNA715462_P_NODE_56536_length_248_cov_0.880000_g55740_i0	PRJNA715462	56536	248	0.88	2.1824	Fungi	4751	Fungi	Fungi	114	1.03e-27	NR	XP_013238870.1	1485682	g55740	i0	65.9	16.8508064516129	82	28	99.2	0	247	2	331	412	XP_013238870.1 elongation factor 1-alpha [Mitosporidium daphniae]	diamond	4179	114	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
28125830	28125830	PRJNA715462_P_NODE_16325_length_475_cov_2.124378_g15529_i0	PRJNA715462	16325	475	2.124378	10.0907955	Mitosporidium daphniae	1485682	Fungi	Fungi	80.1	3.61e-16	NR	XP_013237325.1	1485682	g15529	i0	58.3	0.865263157894737	72	30	45.5	0	19	234	1	72	XP_013237325.1 uncharacterized protein DI09_51p90 [Mitosporidium daphniae]	diamond	411	80.1	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
29514860	29514860	PRJNA715462_P_NODE_28830_length_333_cov_1.184615_g28034_i0	PRJNA715462	28830	333	1.184615	3.94476795	Hepatospora eriocheir	1081669	Fungi	Fungi	46.6	0.00342	NR	ORD95894.1	1081669	g28034	i0	31.3	1.59459459459459	80	53	70.3	1	271	38	63	142	ORD95894.1 SENP2 [Hepatospora eriocheir]	diamond	531	46.6	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Hepatosporidae	Hepatospora	Hepatospora eriocheir
31948403	31948403	PRJNA715462_P_NODE_59537_length_246_cov_0.890173_g58741_i0	PRJNA715462	59537	246	0.890173	2.18982558	Encephalitozoon hellem ATCC 5	27973	Fungi	Fungi	50.8	5.41e-5	NR	XP_003886961.1	907965	g58741	i0	31.3	0.975609756097561	80	52	96.3	3	242	6	48	125	XP_003886961.1 ubiquitin-activating enzyme E1 [Encephalitozoon hellem ATCC 50504]	diamond	240	50.8	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Unikaryonidae	Encephalitozoon	Encephalitozoon hellem
32518285	32518285	PRJNA715462_P_NODE_11199_length_623_cov_2.056364_g10416_i0	PRJNA715462	11199	623	2.056364	12.81114772	Pancytospora philotis	1923975	Fungi	Fungi	50.8	0.0018	NR	KAI4293155.1	1923975	g10416	i0	52.3	0.727126805778491	44	21	21.2	0	486	355	630	673	KAI4293155.1 hypothetical protein PAPHI01_2429 [Pancytospora philotis]	diamond	453	50.8	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pancytospora	Pancytospora philotis
32738849	32738849	PRJNA715462_P_NODE_24540_length_365_cov_1.373288_g23744_i0	PRJNA715462	24540	365	1.373288	5.0125012	Trachipleistophora hominis	72359	Fungi	Fungi	111	7.02e-28	NR	ELQ75495.1	72359	g23744	i0	75	1.76712328767123	68	17	55.9	0	2	205	123	190	ELQ75495.1 60S ribosomal protein L11, partial [Trachipleistophora hominis]	diamond	645	111	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Pleistophoridae	Trachipleistophora	Trachipleistophora hominis

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