metadata: contig_metadata: 15 rows where bioproject = "PRJNA556992", tax_kingdom = "Fungi" and tax

15 rows where bioproject = "PRJNA556992", 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
18383488	18383488	PRJNA556992_P_NODE_67055_length_461_cov_1.432990_g64882_i0	PRJNA556992	67055	461	1.43299	6.6060839	Heterosporis sp. NBDP-2013a	1289055	Fungi	Fungi	75	9.55e-9	NTclustered	gi\|448278458\|gb\|KC137554.1\|	1289055	g64882	i0	95.652	0.0997830802603037	46	2	10	0	14	59	2962	2917	Heterosporis sp. NBDP-2013a isolate MN/CISCO small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	46	75	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Pleistophoridae	Heterosporis	Heterosporis sp. NBDP-2013a
24748014	24748014	PRJNA556992_P_NODE_1000020_length_230_cov_4.687898_g997830_i0	PRJNA556992	1000020	230	4.687898	10.7821654	Nematocida ausubeli	1913371	Fungi	Fungi	152	1.97e-32	NTclustered	gi\|2432061457\|ref\|XR_008288892.1\|	1913371	g997830	i0	79.487	2.04347826086957	234	33	97	14	7	230	1169	1397	Nematocida ausubeli 28S ribosomal RNA (NESG_02472), partial rRNA	blastn	470	152	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida ausubeli
26793892	26793892	PRJNA556992_P_NODE_664881_length_253_cov_6.505556_g662692_i0	PRJNA556992	664881	253	6.505556	16.45905668	Nematocida sp. AWRm8	1927920	Fungi	Fungi	135	3.0599999999999995e-37	NR	KAI5181236.1	2670343	g662692	i0	77.8	1.94466403162055	81	18	96	0	245	3	35	115	KAI5181236.1 GPN-loop GTPase [Nematocida sp. AWRm80]	diamond	492	135	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida sp. AWRm80
26920507	26920507	PRJNA556992_P_NODE_710242_length_250_cov_5.033898_g708053_i0	PRJNA556992	710242	250	5.033898	12.584745	Cucumispora dikerogammari	658444	Fungi	Fungi	43.5	0.0203	NR	KAF7693671.1	658444	g708053	i0	41.1	0.672	56	30	67.2	1	17	184	227	279	KAF7693671.1 hypothetical protein CDIK_2194 [Cucumispora dikerogammari]	diamond	168	43.5	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Cucumispora	Cucumispora dikerogammari
26951907	26951907	PRJNA556992_P_NODE_650122_length_255_cov_1.478022_g647933_i0	PRJNA556992	650122	255	1.478022	3.7689561	Enteropsectra breve	1912989	Fungi	Fungi	88.6	3.18e-18	NR	KAI5151526.1	1912989	g647933	i0	46.3	0.964705882352941	82	44	96.5	0	253	8	617	698	KAI5151526.1 hypothetical protein ENBRE01_2196 [Enteropsectra breve]	diamond	246	88.6	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Enteropsectra	Enteropsectra breve
26983756	26983756	PRJNA556992_P_NODE_841102_length_244_cov_0.900585_g838912_i0	PRJNA556992	841102	244	0.900585	2.1974274	Vairimorpha apis BRL	35231	Fungi	Fungi	65.9	1.73e-10	NR	EQB59838.1	1037528	g838912	i0	49.2	2.37295081967213	63	31	76.2	1	20	205	8	70	EQB59838.1 stress response transcription factor [Vairimorpha apis BRL 01]	diamond	579	65.9	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vairimorpha	Vairimorpha apis
27204909	27204909	PRJNA556992_P_NODE_817222_length_245_cov_1.465116_g815032_i0	PRJNA556992	817222	245	1.465116	3.5895342	Nematocida sp. LUAm3	2670340	Fungi	Fungi	49.3	5.49e-5	NR	KAI5171980.1	2670340	g815032	i0	32.1	0.955102040816327	78	39	78.4	2	195	4	19	96	KAI5171980.1 cleavage and polyadenylation specificity factor subunit 4 [Nematocida sp. LUAm3]	diamond	234	49.3	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida sp. LUAm3
27805051	27805051	PRJNA556992_P_NODE_1124764_length_207_cov_4.865672_g1122573_i0	PRJNA556992	1124764	207	4.865672	10.07194104	Nematocida homosporus	1912981	Fungi	Fungi	103	5.6999999999999986e-24	NR	XP_051347255.1	1912981	g1122573	i0	81.7	0.869565217391304	60	11	87	0	6	185	452	511	XP_051347255.1 ATP-dependent RNA helicase DDX55/SPB4 [Nematocida homosporus]	diamond	180	103	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida homosporus
28152547	28152547	PRJNA556992_P_NODE_386965_length_278_cov_1.487805_g384776_i0	PRJNA556992	386965	278	1.487805	4.1360979	Enterocytozoon bieneusi H348	481877	Fungi	Fungi	96.7	3.59e-23	NR	EDQ31198.1	481877	g384776	i0	64.2	7.26258992805755	81	23	80.9	1	278	54	17	97	EDQ31198.1 SSU ribosomal protein S27AE - ubiquitin [Enterocytozoon bieneusi H348]	diamond	2019	96.7	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Enterocytozoon	Enterocytozoon bieneusi
28640546	28640546	PRJNA556992_P_NODE_736987_length_249_cov_2.062500_g734798_i0	PRJNA556992	736987	249	2.0625	5.135625	Eukaryota	2759	Fungi	Fungi	71.2	3.4e-12	NR	OQS54865.1	646526	g734798	i0	50.7	1.81927710843373	75	17	90.4	1	23	247	108	162	OQS54865.1 CCA1 [Enterocytozoon hepatopenaei]	diamond	453	71.6	0.994413407821229	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Ecytonucleospora	Ecytonucleospora hepatopenaei
28829717	28829717	PRJNA556992_P_NODE_919608_length_239_cov_2.180723_g917418_i0	PRJNA556992	919608	239	2.180723	5.21192797	Opisthokonta	33154	Fungi	Fungi	89	1e-18	NR	KAG0418557.1	288439	g917418	i0	46.8	7.34309623430962	79	42	99.2	0	1	237	227	305	KAG0418557.1 Actin-2 [Dictyocoela roeselum]	diamond	1755	89	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Dictyocoela	Dictyocoela roeselum
29005312	29005312	PRJNA556992_P_NODE_462908_length_270_cov_3.649746_g460719_i0	PRJNA556992	462908	270	3.649746	9.8543142	Pancytospora epiphaga	1938578	Fungi	Fungi	153	5.57e-41	NR	KAI5176142.1	1938578	g460719	i0	76.7	1.98888888888889	90	21	100	0	1	270	690	779	KAI5176142.1 hypothetical protein PAEPH01_2241 [Pancytospora epiphaga]	diamond	537	153	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pancytospora	Pancytospora epiphaga
29050928	29050928	PRJNA556992_P_NODE_1058448_length_222_cov_10.375839_g1056258_i0	PRJNA556992	1058448	222	10.375839	23.03436258	Eukaryota	2759	Fungi	Fungi	57.4	1.95e-7	NR	KAK6090911.1	40135	g1056258	i0	45.5	3.28378378378378	55	30	74.3	0	165	1	292	346	KAK6090911.1 hypothetical protein P3W45_000156 [Vairimorpha bombi]	diamond	729	57.4	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vairimorpha	Vairimorpha bombi
30078140	30078140	PRJNA556992_P_NODE_1036072_length_227_cov_2.006494_g1033882_i0	PRJNA556992	1036072	227	2.006494	4.55474138	Nematocida sp. AWRm8	1927920	Fungi	Fungi	75.5	8.76e-14	NR	KAI5180373.1	2670343	g1033882	i0	59.7	0.819383259911894	62	25	81.9	0	225	40	254	315	KAI5180373.1 DNA excision repair protein ERCC-3 [Nematocida sp. AWRm80]	diamond	186	75.5	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida sp. AWRm80
32418424	32418424	PRJNA556992_P_NODE_929199_length_238_cov_2.230303_g927009_i0	PRJNA556992	929199	238	2.230303	5.30812114	Vavraia culicis subsp. floridensis	948595	Fungi	Fungi	44.7	0.00719	NR	XP_008073723.1	948595	g927009	i0	35.8	0.84453781512605	67	37	84.5	2	238	38	347	407	XP_008073723.1 uncharacterized protein VCUG_00702 [Vavraia culicis subsp. floridensis]	diamond	201	44.7	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Pleistophoridae	Vavraia	Vavraia 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);;