metadata: contig_metadata: 5 rows where bioproject = "PRJNA1011844", tax_kingdom = "Fungi" and tax

5 rows where bioproject = "PRJNA1011844", 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
13755604	13755604	PRJNA1011844_P_NODE_50351_length_623_cov_2.592727_g42096_i0	PRJNA1011844	50351	623	2.592727	16.15268921	Fungi	4751	Fungi	Fungi	183	2.0999999999999996e-41	NTclustered	gi\|1378896647\|gb\|MF278562.1\|	1485682	g42096	i0	95.652	20.8234349919743	115	4	18	1	456	570	5537	5650	Mitosporidium daphniae strain UGP3 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	12973	183	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
28234664	28234664	PRJNA1011844_P_NODE_112746_length_296_cov_2.461883_g104170_i0	PRJNA1011844	112746	296	2.461883	7.28717368	Pancytospora philotis	1923975	Fungi	Fungi	62.4	8.42e-9	NR	KAI4293171.1	1923975	g104170	i0	37.3	2.52364864864865	83	51	84.1	1	258	10	395	476	KAI4293171.1 hypothetical protein PAPHI01_2445 [Pancytospora philotis]	diamond	747	62.4	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Pancytospora	Pancytospora philotis
28929680	28929680	PRJNA1011844_P_NODE_93408_length_347_cov_4.065693_g84847_i0	PRJNA1011844	93408	347	4.065693	14.10795471	Anncaliia algerae PRA1	723287	Fungi	Fungi	75.9	1.06e-13	NR	KCZ78782.1	1240240	g84847	i0	34.8	1.72046109510086	112	71	95.1	1	334	5	13	124	KCZ78782.1 hypothetical protein H311_00181, partial [Anncaliia algerae PRA109]	diamond	597	75.9	1	Eukaryota	Opisthokonta	Fungi	Microsporidia	Tubulinosematidae	Anncaliia	Anncaliia algerae
29268989	29268989	PRJNA1011844_P_NODE_160269_length_242_cov_0.911243_g151689_i0	PRJNA1011844	160269	242	0.911243	2.20520806	Fungi	4751	Fungi	Fungi	95.9	2.14e-22	NR	XP_013236758.1	1485682	g151689	i0	62.2	4.63636363636364	74	28	91.7	0	231	10	50	123	XP_013236758.1 40S ribosomal protein S6 [Mitosporidium daphniae]	diamond	1122	96.7	0.991726990692865	Eukaryota	Opisthokonta	Fungi	Microsporidia		Mitosporidium	Mitosporidium daphniae
32532765	32532765	PRJNA1011844_P_NODE_50639_length_619_cov_10.326007_g42378_i0	PRJNA1011844	50639	619	10.326007	63.91798333	Nematocida sp. LUAm3	2670340	Fungi	Fungi	116	1.53e-27	NR	KAI5170622.1	2670340	g42378	i0	65	16.2600969305331	80	27	38.8	1	16	255	217	295	KAI5170622.1 serine/threonine-protein phosphatase PP1 catalytic subunit [Nematocida sp. LUAm3]	diamond	10065	116	1	Eukaryota	Opisthokonta	Fungi	Microsporidia		Nematocida	Nematocida sp. LUAm3

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