metadata: contig_metadata: 13 rows where bioproject = "PRJNA1092581", tax_clade = "Opisthokonta" and tax

13 rows where bioproject = "PRJNA1092581", tax_clade = "Opisthokonta" and tax_phylum = "Chytridiomycota"

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
5298723	5298723	PRJNA1092581_P_NODE_115985_length_230_cov_3.089172_g115452_i0	PRJNA1092581	115985	230	3.089172	7.1050956	Fimicolochytrium jonesii	1396493	Fungi	Fungi	154	5.47e-33	NTclustered	gi\|2432091355\|ref\|XM_053068060.1\|	1396493	g115452	i0	80.476	32.8260869565217	210	33	90	7	1	206	182	387	Fimicolochytrium jonesii ubiquitin-60S ribosomal protein L40 fusion protein (EV422DRAFT_499054), partial mRNA	blastn	7550	154	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Fimicolochytrium	Fimicolochytrium jonesii
11675774	11675774	PRJNA1092581_P_NODE_50050_length_380_cov_5.029316_g49517_i0	PRJNA1092581	50050	380	5.029316	19.1114008	Eukaryota	2759	Fungi	Fungi	123	1.57e-33	NR	KAI9008584.1	82268	g49517	i0	54.2	3.20526315789474	107	49	84.5	0	31	351	5	111	KAI9008584.1 50S ribosomal protein L30e-like protein [Hyaloraphidium curvatum]	diamond	1218	124	0.991935483870968	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Monoblepharidomycetes	Monoblepharidales		Hyaloraphidium	Hyaloraphidium curvatum
26719007	26719007	PRJNA1092581_P_NODE_65841_length_324_cov_3.697211_g65308_i0	PRJNA1092581	65841	324	3.697211	11.97896364	Rhizophlyctis rosea	64517	Fungi	Fungi	46.6	0.00435	NR	KAJ3037849.1	64517	g65308	i0	45.5	0.944444444444444	44	24	40.7	0	173	42	1676	1719	KAJ3037849.1 Eukaryotic translation initiation factor 4 gamma 2 [Rhizophlyctis rosea]	diamond	306	46.6	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophlyctidales	Rhizophlyctidaceae	Rhizophlyctis	Rhizophlyctis rosea
27920343	27920343	PRJNA1092581_P_NODE_85285_length_278_cov_3.526829_g84752_i0	PRJNA1092581	85285	278	3.526829	9.80458462	Fimicolochytrium jonesii	1396493	Fungi	Fungi	44.3	0.0132	NR	XP_052928944.1	1396493	g84752	i0	49.1	0.571942446043165	53	22	52.9	3	23	169	180	231	XP_052928944.1 uncharacterized protein EV422DRAFT_518041 [Fimicolochytrium jonesii]	diamond	159	44.3	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Fimicolochytrium	Fimicolochytrium jonesii
28299211	28299211	PRJNA1092581_P_NODE_106986_length_244_cov_1.707602_g106453_i0	PRJNA1092581	106986	244	1.707602	4.16654888	Caulochytrium protostelioides	1555241	Fungi	Fungi	53.1	8.22e-6	NR	RKP02759.1	1555241	g106453	i0	56.1	0.504098360655738	41	18	50.4	0	222	100	331	371	RKP02759.1 hypothetical protein CXG81DRAFT_10441 [Caulochytrium protostelioides]	diamond	123	53.1	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Caulochytriales	Caulochytriaceae	Caulochytrium	Caulochytrium protostelioides
28330777	28330777	PRJNA1092581_P_NODE_26206_length_543_cov_4.557447_g25676_i0	PRJNA1092581	26206	543	4.557447	24.74693721	Boothiomyces macroporosus	261099	Fungi	Fungi	78.2	3.5e-13	NR	KAJ3254037.1	261099	g25676	i0	54.2	0.458563535911602	83	26	45.9	2	533	285	373	443	KAJ3254037.1 Signal recognition particle [Boothiomyces macroporosus]	diamond	249	78.2	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales	Terramycetaceae	Boothiomyces	Boothiomyces macroporosus
29814783	29814783	PRJNA1092581_P_NODE_99631_length_253_cov_4.833333_g99098_i0	PRJNA1092581	99631	253	4.833333	12.22833249	Synchytrium endobioticum	286115	Fungi	Fungi	63.9	1.48e-9	NR	TPX48403.1	286115	g99098	i0	55.6	1.28063241106719	54	23	64	1	1	162	805	857	TPX48403.1 AMP deaminase [Synchytrium endobioticum]	diamond	324	63.9	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Synchytriales	Synchytriaceae	Synchytrium	Synchytrium endobioticum
29878157	29878157	PRJNA1092581_P_NODE_44231_length_408_cov_5.277612_g43698_i0	PRJNA1092581	44231	408	5.277612	21.53265696	Phlyctochytrium bullatum	1352834	Fungi	Fungi	70.5	4.35e-11	NR	KAJ3110523.1	1352834	g43698	i0	53.7	0.397058823529412	54	25	39.7	0	50	211	107	160	KAJ3110523.1 hypothetical protein HDU96_006509, partial [Phlyctochytrium bullatum]	diamond	162	70.5	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytridiaceae	Phlyctochytrium	Phlyctochytrium bullatum
31386309	31386309	PRJNA1092581_P_NODE_51836_length_372_cov_11.598662_g51303_i0	PRJNA1092581	51836	372	11.598662	43.14702264	Eukaryota	2759	Fungi	Fungi	66.6	4.85e-11	NR	XP_052970607.1	110093	g51303	i0	41.3	1.79032258064516	109	60	84.7	1	355	41	23	131	XP_052970607.1 uncharacterized protein BJ171DRAFT_209217 [Polychytrium aggregatum]	diamond	666	66.6	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
31394909	31394909	PRJNA1092581_P_NODE_101616_length_250_cov_8.666667_g101083_i0	PRJNA1092581	101616	250	8.666667	21.6666675	Powellomyces hirtus	109895	Fungi	Fungi	79.3	7.95e-16	NR	KAI8912157.1	109895	g101083	i0	52.1	1.704	71	34	85.2	0	223	11	113	183	KAI8912157.1 hypothetical protein DFJ77DRAFT_467136 [Powellomyces hirtus]	diamond	426	79.3	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Powellomyces	Powellomyces hirtus
31837409	31837409	PRJNA1092581_P_NODE_1617_length_1573_cov_4.802667_g1474_i0	PRJNA1092581	1617	1573	4.802667	75.54595191	Gaertneriomyces sp. JEL	1983341	Fungi	Fungi	204	2.99e-56	NR	KAJ3176278.1	2724198	g1474	i0	46.4	0.427209154481882	224	112	41.4	5	526	1176	195	417	KAJ3176278.1 hypothetical protein HDU85_007256 [Gaertneriomyces sp. JEL0708]	diamond	672	204	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Spizellomycetaceae	Gaertneriomyces	Gaertneriomyces sp. JEL0708
31869173	31869173	PRJNA1092581_P_NODE_8817_length_899_cov_11.472155_g8406_i0	PRJNA1092581	8817	899	11.472155	103.13467345	Batrachochytrium dendrobatidis	109871	Fungi	Fungi	126	6.9e-29	NR	KAL5032449.1	109871	g8406	i0	34	3.12347052280311	241	115	71.4	6	255	896	228	451	KAL5032449.1 hypothetical protein RTP6_000548 [Batrachochytrium dendrobatidis]	diamond	2808	126	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium dendrobatidis
32122549	32122549	PRJNA1092581_P_NODE_8318_length_922_cov_2.652532_g7918_i0	PRJNA1092581	8318	922	2.652532	24.45634504	Nowakowskiella sp. JEL	2012159	Fungi	Fungi	52.4	0.00211	NR	KAJ3128647.1	2732418	g7918	i0	24.6	0.370932754880694	114	72	35.1	2	692	369	1027	1132	KAJ3128647.1 hypothetical protein HK098_003854 [Nowakowskiella sp. JEL0407]	diamond	342	52.4	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Cladochytriales	Nowakowskiellaceae	Nowakowskiella	Nowakowskiella sp. JEL0407

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