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

10 rows where bioproject = "PRJNA770361", 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
10950358	10950358	PRJNA770361_P_NODE_13389_length_254_cov_1.486188_g13294_i0	PRJNA770361	13389	254	1.486188	3.77491752	Pseudoloma neurophilia	146866	Fungi	Fungi	470	5.37e-128	NTclustered	gi\|11993647\|gb\|AF322654.1\|	146866	g13294	i0	100	96.0393700787402	254	0	100	0	1	254	882	1135	Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	24394	470	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pseudoloma	Pseudoloma neurophilia
21608524	21608524	PRJNA770361_P_NODE_14817_length_251_cov_0.876404_g14722_i0	PRJNA770361	14817	251	0.876404	2.19977404	Heterosporis	157917	Fungi	Fungi	355	1.55e-93	NTclustered	gi\|448278458\|gb\|KC137554.1\|	1289055	g14722	i0	92.43	35.0796812749004	251	15	99	3	1	249	3471	3223	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	8805	355	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Pleistophoridae	Heterosporis	Heterosporis sp. NBDP-2013a
28663934	28663934	PRJNA770361_P_NODE_16647_length_247_cov_0.896552_g16552_i0	PRJNA770361	16647	247	0.896552	2.21448344	Enterospora canceri	1081671	Fungi	Fungi	86.7	4.98e-18	NR	ORD93907.1	1081671	g16552	i0	59.3	0.983805668016194	81	30	98.4	2	3	245	145	222	ORD93907.1 ASNA [Enterospora canceri]	diamond	243	86.7	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Enterocytozoonidae	Enterospora	Enterospora canceri
28727020	28727020	PRJNA770361_P_NODE_10567_length_290_cov_1.437788_g10472_i0	PRJNA770361	10567	290	1.437788	4.1695852	Pseudoloma neurophilia	146866	Fungi	Fungi	196	1.65e-60	NR	KRH92775.1	146866	g10472	i0	100	0.993103448275862	96	0	99.3	0	2	289	2	97	KRH92775.1 hypothetical protein M153_2800000189 [Pseudoloma neurophilia]	diamond	288	196	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pseudoloma	Pseudoloma neurophilia
29768860	29768860	PRJNA770361_P_NODE_6411_length_370_cov_1.050505_g6316_i0	PRJNA770361	6411	370	1.050505	3.8868685	Dictyocoela muelleri	279532	Fungi	Fungi	72	2.85e-12	NR	KAG0421621.1	279532	g6316	i0	37.6	4.1027027027027	85	53	68.9	0	258	4	137	221	KAG0421621.1 hypothetical protein DMUE_6280, partial [Dictyocoela muelleri]	diamond	1518	72	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Dictyocoela	Dictyocoela muelleri
30274661	30274661	PRJNA770361_P_NODE_15052_length_250_cov_0.881356_g14957_i0	PRJNA770361	15052	250	0.881356	2.20339	Pseudoloma neurophilia	146866	Fungi	Fungi	163	4.97e-45	NR	KRH94921.1	146866	g14957	i0	100	0.996	83	0	99.6	0	250	2	212	294	KRH94921.1 ATP-binding Cassette (ABC) Superfamily [Pseudoloma neurophilia]	diamond	249	163	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pseudoloma	Pseudoloma neurophilia
30338058	30338058	PRJNA770361_P_NODE_18912_length_242_cov_0.923077_g18817_i0	PRJNA770361	18912	242	0.923077	2.23384634	Pseudoloma neurophilia	146866	Fungi	Fungi	152	4.19e-43	NR	KRH92308.1	146866	g18817	i0	100	0.991735537190083	80	0	99.2	0	241	2	71	150	KRH92308.1 double strand break repair protein MRE11A isoform, partial [Pseudoloma neurophilia]	diamond	240	152	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pseudoloma	Pseudoloma neurophilia
31664976	31664976	PRJNA770361_P_NODE_18357_length_243_cov_0.917647_g18262_i0	PRJNA770361	18357	243	0.917647	2.22988221	Pseudoloma neurophilia	146866	Fungi	Fungi	162	7.99e-49	NR	KRH94081.1	146866	g18262	i0	100	0.987654320987654	80	0	98.8	0	2	241	10	89	KRH94081.1 ribosomal protein S7 [Pseudoloma neurophilia]	diamond	240	162	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pseudoloma	Pseudoloma neurophilia
32708410	32708410	PRJNA770361_P_NODE_10580_length_290_cov_1.271889_g10485_i0	PRJNA770361	10580	290	1.271889	3.6884781	Pseudoloma neurophilia	146866	Fungi	Fungi	201	1.73e-61	NR	KRH94915.1	146866	g10485	i0	100	0.993103448275862	96	0	99.3	0	288	1	219	314	KRH94915.1 hypothetical protein M153_11200021404 [Pseudoloma neurophilia]	diamond	288	201	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pseudoloma	Pseudoloma neurophilia
32802877	32802877	PRJNA770361_P_NODE_18880_length_242_cov_0.923077_g18785_i0	PRJNA770361	18880	242	0.923077	2.23384634	Pseudoloma neurophilia	146866	Fungi	Fungi	163	9.47e-49	NR	KRH93857.1	146866	g18785	i0	100	0.991735537190083	80	0	99.2	0	3	242	43	122	KRH93857.1 20S proteasome, regulatory subunit beta type PSMB6/PSMB9/PRE3 [Pseudoloma neurophilia]	diamond	240	163	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pseudoloma	Pseudoloma neurophilia

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