metadata: contig_metadata: 9 rows where bioproject = "PRJNA1240804", tax_kingdom = "Fungi" and tax

9 rows where bioproject = "PRJNA1240804", tax_kingdom = "Fungi" 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
347257	347257	PRJNA1240804_P_NODE_138341_length_164_cov_0.904348_g137975_i0	PRJNA1240804	138341	164	0.904348	1.48313072	Neoconidiobolus thromboides	76012	Fungi	Fungi	156	1.01e-33	NTclustered	gi\|2032035963\|gb\|MW795364.1\|	76012	g137975	i0	86.62	2	142	17	85	2	15	154	32505	32646	Neoconidiobolus thromboides strain ATCC 12587 mitochondrion, complete genome	blastn	328	156	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Ancylistaceae	Neoconidiobolus	Neoconidiobolus thromboides
347529	347529	PRJNA1240804_P_NODE_15821_length_341_cov_2.907534_g15456_i0	PRJNA1240804	15821	341	2.907534	9.91469094	Harpella melusinae	370264	Fungi	Fungi	78.7	5.32e-10	NTclustered	gi\|666440445\|gb\|KF848904.1\|	370264	g15456	i0	86.486	17.4105571847507	74	7	21	3	11	82	2074	2002	Harpella melusinae 28S ribosomal RNA gene, partial sequence	blastn	5937	78.7	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Harpellomycetes	Harpellales	Harpellaceae	Harpella	Harpella melusinae
8702784	8702784	PRJNA1240804_P_NODE_101007_length_173_cov_0.991935_g100641_i0	PRJNA1240804	101007	173	0.991935	1.71604755	Basidiobolus	4859	Fungi	Fungi	289	1.02e-73	NTclustered	gi\|145307954\|gb\|EF392490.1\|	34480	g100641	i0	99.375	31.4913294797688	160	0	92	1	15	173	130	289	Basidiobolus ranarum strain ARSEF 260 small subunit ribosomal RNA gene, partial sequence; mitochondrial	blastn	5448	289	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
13803455	13803455	PRJNA1240804_P_NODE_152511_length_158_cov_3.614679_g152145_i0	PRJNA1240804	152511	158	3.614679	5.71119282	Dispira	78922	Fungi	Fungi	86.1	1.29e-12	NTclustered	gi\|666440456\|gb\|KF848915.1\|	78923	g152145	i0	94.545	3.21518987341772	55	3	35	0	14	68	1983	2037	Dispira cornuta strain NRRL A-16106 28S ribosomal RNA gene, partial sequence	blastn	508	86.1	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dispira	Dispira cornuta
13803511	13803511	PRJNA1240804_P_NODE_23791_length_291_cov_3.776860_g23425_i0	PRJNA1240804	23791	291	3.77686	10.9906626	Basidiobolus	4859	Fungi	Fungi	479	1.0399999999999996e-130	NTclustered	gi\|158149036\|dbj\|AB363770.1\|	34480	g23425	i0	97.842	95.4089347079038	278	5	95	1	2	278	317	40	Basidiobolus ranarum gene for large subunit rRNA, partial sequence, strain: IFM 41413	blastn	27764	479	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
22026016	22026016	PRJNA1240804_P_NODE_91398_length_179_cov_1.200000_g91032_i0	PRJNA1240804	91398	179	1.2	2.148	Entomophaga aulicae	39303	Fungi	Fungi	54.7	0.004	NTclustered	gi\|1373048\|gb\|U35394.1\|EAU35394	39303	g91032	i0	96.875	0.17877094972067	32	1	18	0	86	117	6048	6017	Entomophaga aulicae 18S, ITS-1, 5.8S, ITS-2, and 25S ribosomal RNA genes	blastn	32	54.7	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Entomophthoromycetes	Entomophthorales	Entomophthoraceae	Entomophaga	Entomophaga aulicae
23300071	23300071	PRJNA1240804_P_NODE_154419_length_152_cov_2.194175_g154053_i0	PRJNA1240804	154419	152	2.194175	3.335146	Basidiobolus ranarum	34480	Fungi	Fungi	257	2.45e-64	NTclustered	gi\|82398540\|gb\|DQ273807.1\|	34480	g154053	i0	100	91.7434210526316	139	0	91	0	1	139	1623	1485	Basidiobolus ranarum isolate AFTOL-ID 301 28S ribosomal RNA gene, partial sequence	blastn	13945	257	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
23300902	23300902	PRJNA1240804_P_NODE_52039_length_216_cov_1.065868_g51673_i0	PRJNA1240804	52039	216	1.065868	2.30227488	Basidiobolus ranarum	34480	Fungi	Fungi	270	4.829999999999999e-68	NTclustered	gi\|82398540\|gb\|DQ273807.1\|	34480	g51673	i0	90.594	69.1898148148148	202	19	94	0	15	216	2098	2299	Basidiobolus ranarum isolate AFTOL-ID 301 28S ribosomal RNA gene, partial sequence	blastn	14945	270	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Basidiobolomycetes	Basidiobolales	Basidiobolaceae	Basidiobolus	Basidiobolus ranarum
27199678	27199678	PRJNA1240804_P_NODE_150142_length_162_cov_0.920354_g149776_i0	PRJNA1240804	150142	162	0.920354	1.49097348	Dimargaris verticillata	2761393	Fungi	Fungi	55.5	3.93e-7	NR	KAJ1981906.1	2761393	g149776	i0	62.3	0.981481481481482	53	18	96.3	2	157	2	309	360	KAJ1981906.1 ribosome-binding protein [Dimargaris verticillata]	diamond	159	55.5	1	Eukaryota	Opisthokonta	Fungi	Zoopagomycota	Dimargaritomycetes	Dimargaritales	Dimargaritaceae	Dimargaris	Dimargaris verticillata

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