metadata: contig_metadata: 8 rows where bioproject = "PRJNA749559" and tax

8 rows where bioproject = "PRJNA749559" and tax_phylum = "Zoopagomycota"

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_class	tax_order	tax_family	tax_genus	tax_species
4554484	4554484	PRJNA749559_P_NODE_844_length_511_cov_5.751111_g774_i0	PRJNA749559	844	511	5.751111	29.38817721	Entomophthora muscae	34485	Fungi	Fungi	379	2.02e-100	NTclustered	gi\|82398173\|gb\|DQ273772.1\|	34485	g774	i0	86.441	29.9373776908023	354	38	68	9	12	361	1707	2054	Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence	blastn	15298	379	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophthora	Entomophthora muscae
11403650	11403650	PRJNA749559_P_NODE_4289_length_208_cov_0.870748_g4219_i0	PRJNA749559	4289	208	0.870748	1.81115584	Capillidium	2878381	Fungi	Fungi	276	9.93e-70	NTclustered	gi\|2273784342\|ref\|NC_064684.1\|	181046	g4219	i0	92.746	12.6634615384615	193	11	92	2	17	208	3720	3530	Conidiobolus rhysosporus strain ATCC 12588 mitochondrion, complete genome	blastn	2634	276	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Capillidium	Capillidium rhysosporum
13479792	13479792	PRJNA749559_P_NODE_551_length_645_cov_5.239726_g485_i0	PRJNA749559	551	645	5.239726	33.7962327	Pandora neoaphidis	76017	Fungi	Fungi	1182	0	NTclustered	gi\|1390220645\|gb\|MH366734.1\|	76017	g485	i0	99.69	78.9054263565891	645	2	100	0	1	645	685	41	Pandora neoaphidis voucher Number 21 large subunit ribosomal RNA gene, partial sequence	blastn	50894	1182	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Pandora	Pandora neoaphidis
13479793	13479793	PRJNA749559_P_NODE_691_length_575_cov_6.659533_g624_i0	PRJNA749559	691	575	6.659533	38.29231475	Pandora neoaphidis	76017	Fungi	Fungi	1062	0	NTclustered	gi\|166812022\|gb\|EU267188.1\|	76017	g624	i0	100	86.2208695652174	575	0	100	0	1	575	1159	585	Pandora neoaphidis ARSEF 1607 pn1607-1 MboI+ pattern 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 25S ribosomal RNA gene, partial sequence	blastn	49577	1062	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Pandora	Pandora neoaphidis
14754809	14754809	PRJNA749559_P_NODE_2792_length_259_cov_3.080808_g2722_i0	PRJNA749559	2792	259	3.080808	7.97929272	Pandora neoaphidis	76017	Fungi	Fungi	479	9.13e-131	NTclustered	gi\|166812027\|gb\|EU267193.1\|	76017	g2722	i0	100	98.007722007722	259	0	100	0	1	259	101	359	Pandora neoaphidis ARSEF 7939 pn7939-3 MboI- pattern 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 25S ribosomal RNA gene, partial sequence	blastn	25384	479	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Pandora	Pandora neoaphidis
17777573	17777573	PRJNA749559_P_NODE_2414_length_280_cov_1.168950_g2344_i0	PRJNA749559	2414	280	1.16895	3.27306	Entomophthorales	4857	Fungi	Fungi	327	3.83e-85	NTclustered	gi\|402230189\|gb\|JX242642.1\|	176681	g2344	i0	98.387	49.4535714285714	186	3	66	0	1	186	305	490	Pandora kondoiensis strain CBS 642.92 16S ribosomal RNA gene, partial sequence; mitochondrial	blastn	13847	327	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Pandora	Pandora kondoiensis
21128514	21128514	PRJNA749559_P_NODE_1757_length_334_cov_1.608059_g1687_i0	PRJNA749559	1757	334	1.608059	5.37091706	Entomophaga aulicae	39303	Fungi	Fungi	241	6.26e-59	NTclustered	gi\|1373048\|gb\|U35394.1\|EAU35394	39303	g1687	i0	89.474	57.059880239521	190	20	57	0	145	334	6060	5871	Entomophaga aulicae 18S, ITS-1, 5.8S, ITS-2, and 25S ribosomal RNA genes	blastn	19058	241	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophaga	Entomophaga aulicae
22403359	22403359	PRJNA749559_P_NODE_1558_length_356_cov_3.728814_g1488_i0	PRJNA749559	1558	356	3.728814	13.27457784	Pandora neoaphidis	76017	Fungi	Fungi	658	0	NTclustered	gi\|166812027\|gb\|EU267193.1\|	76017	g1488	i0	100	100.935393258427	356	0	100	0	1	356	1666	1311	Pandora neoaphidis ARSEF 7939 pn7939-3 MboI- pattern 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 25S ribosomal RNA gene, partial sequence	blastn	35933	658	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Pandora	Pandora neoaphidis

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