metadata: contig_metadata: 13 rows where bioproject = "PRJNA624323" and tax

13 rows where bioproject = "PRJNA624323" and tax_phylum = "Blastocladiomycota"

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
4423947	4423947	PRJNA624323_P_NODE_2464_length_468_cov_2.379747_g2303_i0	PRJNA624323	2464	468	2.379747	11.13721596	Allomyces macrogynus	28583	Fungi	Fungi	813	0	NTclustered	gi\|11467573\|ref\|NC_001715.1\|	28583	g2303	i0	97.886	23.1474358974359	473	5	100	5	1	468	39426	38954	Allomyces macrogynus mitochondrion, complete genome	blastn	10833	813	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces macrogynus
8803083	8803083	PRJNA624323_P_NODE_5907_length_296_cov_13.542601_g5745_i0	PRJNA624323	5907	296	13.542601	40.08609896	Catenaria	109875	Fungi	Fungi	547	2.8799999999999986e-151	NTclustered	gi\|358441454\|gb\|JN939185.1\|	109876	g5745	i0	100	80.3445945945946	296	0	100	0	1	296	306	11	Catenaria anguillulae strain FSU 2502 28S ribosomal RNA (LSU) gene, partial sequence	blastn	23782	547	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Catenariaceae	Catenaria	Catenaria anguillulae
12075714	12075714	PRJNA624323_P_NODE_2190_length_498_cov_8.251765_g2030_i0	PRJNA624323	2190	498	8.251765	41.0937897	Allomyces macrogynus	28583	Fungi	Fungi	771	0	NTclustered	gi\|11467573\|ref\|NC_001715.1\|	28583	g2030	i0	99.528	14.6807228915663	424	1	85	1	28	451	1992	1570	Allomyces macrogynus mitochondrion, complete genome	blastn	7311	771	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces macrogynus
13350543	13350543	PRJNA624323_P_NODE_5251_length_316_cov_12.288066_g5089_i0	PRJNA624323	5251	316	12.288066	38.83028856	Blastocladiella emersonii	4808	Fungi	Fungi	178	4.68e-40	NTclustered	gi\|2440036\|emb\|X90411.1\|	4808	g5089	i0	96.296	34.8607594936709	108	4	34	0	209	316	3376	3269	B.emersonii DNA for 28S ribosomal RNA gene	blastn	11016	178	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
14625289	14625289	PRJNA624323_P_NODE_5832_length_298_cov_12.328889_g5670_i0	PRJNA624323	5832	298	12.328889	36.74008922	Allomyces arbusculus	64504	Fungi	Fungi	451	2.34e-122	NTclustered	gi\|927028429\|emb\|LN878292.1\|	64504	g5670	i0	94.02	65.1610738255034	301	12	100	4	1	298	968	671	Allomyces arbusculus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, culture collection DSM:954	blastn	19418	451	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces arbusculus
17174237	17174237	PRJNA624323_P_NODE_2534_length_462_cov_3.434447_g2373_i0	PRJNA624323	2534	462	3.434447	15.86714514	Allomyces macrogynus	28583	Fungi	Fungi	804	0	NTclustered	gi\|11467573\|ref\|NC_001715.1\|	28583	g2373	i0	98.06	16.3354978354978	464	5	99	4	1	461	642	1104	Allomyces macrogynus mitochondrion, complete genome	blastn	7547	804	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces macrogynus
18448433	18448433	PRJNA624323_P_NODE_4475_length_343_cov_6.748148_g4313_i0	PRJNA624323	4475	343	6.748148	23.14614764	Catenaria sp.	2420186	Fungi	Fungi	634	2.5299999999999996e-177	NTclustered	gi\|1866582684\|gb\|MT730859.1\|	2420186	g4313	i0	100	68.3906705539359	343	0	100	0	1	343	4462	4120	Catenaria sp. isolate JEL0871 small subunit ribosomal RNA gene, partial sequence; 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	23458	634	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Catenariaceae	Catenaria	Catenaria sp.
18448434	18448434	PRJNA624323_P_NODE_4615_length_338_cov_117.411321_g4453_i0	PRJNA624323	4615	338	117.411321	396.85026498	Blastocladiella emersonii	4808	Fungi	Fungi	235	2.9499999999999996e-57	NTclustered	gi\|2440036\|emb\|X90411.1\|	4808	g4453	i0	94.194	41.4408284023669	155	8	46	1	6	160	3228	3381	B.emersonii DNA for 28S ribosomal RNA gene	blastn	14007	235	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Blastocladiella	Blastocladiella emersonii
18448440	18448440	PRJNA624323_P_NODE_6755_length_275_cov_1.331683_g6593_i0	PRJNA624323	6755	275	1.331683	3.66212825	Allomyces macrogynus	28583	Fungi	Fungi	435	2.15e-117	NTclustered	gi\|11467573\|ref\|NC_001715.1\|	28583	g6593	i0	95	2.48	280	9	100	1	1	275	3215	3494	Allomyces macrogynus mitochondrion, complete genome	blastn	682	435	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces macrogynus
19722968	19722968	PRJNA624323_P_NODE_3676_length_382_cov_52.459547_g3514_i0	PRJNA624323	3676	382	52.459547	200.39546954	Allomyces arbusculus	64504	Fungi	Fungi	604	2.2299999999999998e-168	NTclustered	gi\|1405239019\|ref\|NG_027623.1\|	64504	g3514	i0	95.3	72.4816753926702	383	14	100	4	1	382	1582	1961	Allomyces arbusculus UCBMG Brasil 2 28S rRNA gene, partial sequence; from reference material	blastn	27688	604	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces arbusculus
20998670	20998670	PRJNA624323_P_NODE_10237_length_202_cov_7.914729_g10075_i0	PRJNA624323	10237	202	7.914729	15.98775258	Allomyces macrogynus	28583	Fungi	Fungi	322	1.21e-83	NTclustered	gi\|11467573\|ref\|NC_001715.1\|	28583	g10075	i0	95.146	1.58910891089109	206	6	100	2	1	202	603	398	Allomyces macrogynus mitochondrion, complete genome	blastn	321	322	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces macrogynus
22827564	22827564	PRJNA624323_P_NODE_4858_length_329_cov_31.484375_g4696_i0	PRJNA624323	4858	329	31.484375	103.58359375	Allomyces	28581	Fungi	Fungi	590	5.309999999999999e-164	NTclustered	gi\|321173763\|gb\|HQ888744.1\|	64506	g4696	i0	98.784	44.6534954407295	329	4	100	0	1	329	659	331	Allomyces moniliformis strain India 3 28S ribosomal RNA gene, partial sequence	blastn	14691	590	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces moniliformis
23548862	23548862	PRJNA624323_P_NODE_5419_length_311_cov_1.886555_g5257_i0	PRJNA624323	5419	311	1.886555	5.86718605	Allomyces macrogynus	28583	Fungi	Fungi	435	2.47e-117	NTclustered	gi\|11467573\|ref\|NC_001715.1\|	28583	g5257	i0	97.276	12.4951768488746	257	5	82	2	35	290	38798	38543	Allomyces macrogynus mitochondrion, complete genome	blastn	3886	435	1	Eukaryota	Opisthokonta	Fungi	Blastocladiomycota	Blastocladiomycetes	Blastocladiales	Blastocladiaceae	Allomyces	Allomyces macrogynus

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