metadata: contig_metadata: 10 rows where bioproject = "PRJNA940501", tax_kingdom = "Fungi" and tax

10 rows where bioproject = "PRJNA940501", 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
9848581	9848581	PRJNA940501_S_NODE_317788_length_163_cov_45.175000_g316970_i0	PRJNA940501	317788	163	45.175	73.63525	Vairimorpha necatrix	6039	Fungi	Fungi	58.4	2.92e-4	NTclustered	gi\|2735582564\|ref\|XM_065472493.1\|	6039	g316970	i0	94.737	0.233128834355828	38	0	22	2	99	134	128	91	Vairimorpha necatrix uncharacterized protein (VNE69_01357), partial mRNA	blastn	38	58.4	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vairimorpha	Vairimorpha necatrix
20044943	20044943	PRJNA940501_S_NODE_15456_length_395_cov_1.806818_g14642_i0	PRJNA940501	15456	395	1.806818	7.1369311	Enteropsectra breve	1912989	Fungi	Fungi	56.6	2.47e-6	NR	KAI5150767.1	1912989	g14642	i0	34.8	1.09367088607595	66	43	50.1	0	154	351	301	366	KAI5150767.1 hypothetical protein ENBRE01_1695 [Enteropsectra breve]	diamond	432	56.6	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Enteropsectra	Enteropsectra breve
20045553	20045553	PRJNA940501_S_NODE_193356_length_195_cov_1.546053_g192538_i0	PRJNA940501	193356	195	1.546053	3.01480335	Nematocida parisii	586133	Fungi	Fungi	54.7	0.005	NTclustered	gi\|906374713\|ref\|XM_013204459.1\|	881290	g192538	i0	100	0.292307692307692	29	0	15	0	63	91	993	1021	Nematocida parisii ERTm1 uncharacterized protein (NEPG_02086), partial mRNA	blastn	57	54.7	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida parisii
23870332	23870332	PRJNA940501_S_NODE_12819_length_423_cov_4.847368_g12010_i0	PRJNA940501	12819	423	4.847368	20.50436664	Eukaryota	2759	Fungi	Fungi	143	1.4599999999999996e-40	NR	KAG0440815.1	279532	g12010	i0	63.4	6.41843971631206	101	37	71.6	0	1	303	68	168	KAG0440815.1 60S ribosomal protein L11 [Dictyocoela muelleri]	diamond	2715	143	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Dictyocoela	Dictyocoela muelleri
28572645	28572645	PRJNA940501_S_NODE_130967_length_220_cov_2.124294_g130149_i0	PRJNA940501	130967	220	2.124294	4.6734468	Vairimorpha necatrix	6039	Fungi	Fungi	44.3	0.00771	NR	XP_065330279.1	6039	g130149	i0	37.7	0.722727272727273	53	29	72.3	1	184	26	173	221	XP_065330279.1 bromodomain-containing protein 1 [Vairimorpha necatrix]	diamond	159	44.3	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Nosematidae	Vairimorpha	Vairimorpha necatrix
29078055	29078055	PRJNA940501_S_NODE_334308_length_160_cov_2.008547_g333490_i0	PRJNA940501	334308	160	2.008547	3.2136752	Hamiltosporidium magnivora	148818	Fungi	Fungi	41.6	0.0302	NR	TBU00204.1	148818	g333490	i0	40	0.75	40	23	73.1	1	21	137	145	184	TBU00204.1 hypothetical protein CWI39_1758p0010 [Hamiltosporidium magnivora]	diamond	120	41.6	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Dubosqiidae	Hamiltosporidium	Hamiltosporidium magnivora
29267107	29267107	PRJNA940501_S_NODE_139889_length_216_cov_1.514451_g139071_i0	PRJNA940501	139889	216	1.514451	3.27121416	Amphiamblys sp. WSBS2	1866961	Fungi	Fungi	43.1	0.0182	NR	OIR57779.1	1866961	g139071	i0	42.6	0.652777777777778	47	26	63.9	1	176	39	27	73	OIR57779.1 MAG: uncharacterized protein A8A55_1450 [Amphiamblys sp. WSBS2006]	diamond	141	43.1	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Amphiacanthidae	Amphiamblys	Amphiamblys sp. WSBS2006
29708958	29708958	PRJNA940501_S_NODE_206030_length_191_cov_1.527027_g205212_i0	PRJNA940501	206030	191	1.527027	2.91662157	Enteropsectra breve	1912989	Fungi	Fungi	42.7	0.00508	NR	KAI5150633.1	1912989	g205212	i0	69.2	0.816753926701571	26	8	40.8	0	188	111	58	83	KAI5150633.1 hypothetical protein ENBRE01_1611 [Enteropsectra breve]	diamond	156	42.7	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Enteropsectra	Enteropsectra breve
30720186	30720186	PRJNA940501_S_NODE_107514_length_233_cov_1.710526_g106696_i0	PRJNA940501	107514	233	1.710526	3.98552558	Nematocida sp. AWRm77	2670344	Fungi	Fungi	41.2	0.0451	NR	KAI5189085.1	2670344	g106696	i0	43.4	0.682403433476395	53	26	68.2	2	221	63	18	66	KAI5189085.1 hypothetical protein NECID01_0440 [Nematocida sp. AWRm77]	diamond	159	41.2	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida sp. AWRm77
31162390	31162390	PRJNA940501_S_NODE_51915_length_282_cov_2.242678_g51097_i0	PRJNA940501	51915	282	2.242678	6.32435196	Dictyocoela muelleri	279532	Fungi	Fungi	44.3	0.00974	NR	KAG0440815.1	279532	g51097	i0	60.6	0.702127659574468	33	13	35.1	0	1	99	136	168	KAG0440815.1 60S ribosomal protein L11 [Dictyocoela muelleri]	diamond	198	44.3	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Dictyocoela	Dictyocoela muelleri

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