metadata: contig_metadata: 13 rows where bioproject = "PRJNA559720", tax_kingdom = "Fungi" and tax

13 rows where bioproject = "PRJNA559720", tax_kingdom = "Fungi" 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
3094530	3094530	PRJNA559720_P_NODE_4503_length_491_cov_1.909091_g4365_i0	PRJNA559720	4503	491	1.909091	9.37363681	Chytriomyces	109882	Fungi	Fungi	120	2.04e-29	NR	TPX75126.1	246404	g4365	i0	55.6	1.979633401222	108	48	66	0	491	168	109	216	TPX75126.1 hypothetical protein CcCBS67573_g03594 [Chytriomyces confervae]	diamond	972	120	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Chytriomyces	Chytriomyces confervae
6233976	6233976	PRJNA559720_P_NODE_985_length_936_cov_18.657010_g914_i0	PRJNA559720	985	936	18.65701	174.6296136	Eukaryota	2759	Fungi	Fungi	290	1.2699999999999999e-95	NR	KXS11134.1	1344416	g914	i0	82.4	4.79166666666667	165	28	52.9	1	912	418	1	164	KXS11134.1 hypothetical protein M427DRAFT_73326 [Gonapodya prolifera JEL478]	diamond	4485	292	0.993150684931507	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Monoblepharidomycetes	Monoblepharidales	Gonapodyaceae	Gonapodya	Gonapodya prolifera
10747876	10747876	PRJNA559720_P_NODE_229_length_1491_cov_4.051481_g203_i0	PRJNA559720	229	1491	4.051481	60.40758171	Fungi	4751	Fungi	Fungi	566	5.0499999999999996e-195	NR	KAI9005658.1	82268	g203	i0	53.8	19.251509054326	509	208	99.4	6	1491	10	92	588	KAI9005658.1 asparagine synthase [Hyaloraphidium curvatum]	diamond	28704	571	0.991243432574431	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Monoblepharidomycetes	Monoblepharidales		Hyaloraphidium	Hyaloraphidium curvatum
27015632	27015632	PRJNA559720_P_NODE_9742_length_313_cov_1.641667_g9603_i0	PRJNA559720	9742	313	1.641667	5.13841771	Gorgonomyces haynaldii	382530	Fungi	Fungi	71.2	8.82e-12	NR	KAI8908955.1	382530	g9603	i0	30.9	3.74760383386581	97	67	93	0	301	11	2713	2809	KAI8908955.1 hypothetical protein EDD86DRAFT_275886 [Gorgonomyces haynaldii]	diamond	1173	71.2	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales	Gorgonomycetaceae	Gorgonomyces	Gorgonomyces haynaldii
27029688	27029688	PRJNA559720_P_NODE_4902_length_468_cov_3.253165_g4764_i0	PRJNA559720	4902	468	3.253165	15.2248122	Fungi	4751	Fungi	Fungi	248	5.24e-81	NR	KAJ3386682.1	4814	g4764	i0	78.1	78.2307692307692	155	34	99.4	0	2	466	10	164	KAJ3386682.1 hypothetical protein HDU80_000331 [Chytriomyces hyalinus]	diamond	36612	250	0.992	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Chytriomyces	Chytriomyces hyalinus
27679525	27679525	PRJNA559720_P_NODE_4064_length_516_cov_1.097065_g3931_i0	PRJNA559720	4064	516	1.097065	5.6608554	Chytriomyces confervae	246404	Fungi	Fungi	52	2.86e-4	NR	TPX75260.1	246404	g3931	i0	32.3	3.19186046511628	124	83	72.1	1	379	8	40	162	TPX75260.1 hypothetical protein CcCBS67573_g03464 [Chytriomyces confervae]	diamond	1647	52	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Chytriomyces	Chytriomyces confervae
28058032	28058032	PRJNA559720_P_NODE_3625_length_544_cov_1.169851_g3497_i0	PRJNA559720	3625	544	1.169851	6.36398944	Piromyces finnis	1754191	Fungi	Fungi	115	1.4500000000000002e-27	NR	ORX52260.1	1754191	g3497	i0	33.7	0.948529411764706	172	111	93.2	3	2	508	61	232	ORX52260.1 mitochondrial folate transporter/carrier [Piromyces finnis]	diamond	516	115	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Neocallimastigomycetes	Neocallimastigales	Neocallimastigaceae	Piromyces	Piromyces finnis
29384291	29384291	PRJNA559720_P_NODE_10149_length_305_cov_1.280172_g10010_i0	PRJNA559720	10149	305	1.280172	3.9045246	Phlyctochytrium planicorne	261098	Fungi	Fungi	50.1	2.1e-4	NR	KAJ3106069.1	261098	g10010	i0	37.8	0.727868852459016	74	45	72.8	1	75	296	808	880	KAJ3106069.1 clathrin associated protein complex large subunit [Phlyctochytrium planicorne]	diamond	222	50.1	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytridiaceae	Phlyctochytrium	Phlyctochytrium planicorne
29921178	29921178	PRJNA559720_P_NODE_2051_length_707_cov_2.542587_g1939_i0	PRJNA559720	2051	707	2.542587	17.97609009	Chytridiales sp. JEL	2011832	Fungi	Fungi	194	1.41e-54	NR	KAJ3414597.1	2786947	g1939	i0	41.9	3.004243281471	236	134	99.7	2	3	707	359	592	KAJ3414597.1 U3 snoRNP protein [Chytridiales sp. JEL 0842]	diamond	2124	194	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales			Chytridiales sp. JEL 0842
30615968	30615968	PRJNA559720_P_NODE_13053_length_257_cov_1.489130_g12914_i0	PRJNA559720	13053	257	1.48913	3.8270641	Phlyctochytrium planicorne	261098	Fungi	Fungi	56.6	5.79e-7	NR	KAJ3109091.1	261098	g12914	i0	59.2	2.27626459143969	49	20	57.2	0	43	189	83	131	KAJ3109091.1 Glucose-repressible alcohol dehydrogenase transcriptional effector [Phlyctochytrium planicorne]	diamond	585	56.6	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytridiaceae	Phlyctochytrium	Phlyctochytrium planicorne
30882808	30882808	PRJNA559720_P_NODE_5854_length_426_cov_1.362606_g5715_i0	PRJNA559720	5854	426	1.362606	5.80470156	Chytridiomycetes	451435	Fungi	Fungi	84.3	9.45e-18	NR	KAI8812657.1	109936	g5715	i0	38.9	1.64084507042254	108	59	71.1	2	363	61	22	129	KAI8812657.1 protein CYTB-5.1, partial [Cladochytrium replicatum]	diamond	699	84.3	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Cladochytriales	Cladochytriaceae	Cladochytrium	Cladochytrium replicatum
31596198	31596198	PRJNA559720_P_NODE_4016_length_518_cov_3.429213_g1500_i1	PRJNA559720	4016	518	3.429213	17.76332334	Gonapodya prolifera JEL478	1344416	Fungi	Fungi	77.4	3.66e-13	NR	KXS20171.1	1344416	g1500	i1	42.7	0.515444015444015	89	48	51.5	1	111	377	280	365	KXS20171.1 PIN domain-like protein [Gonapodya prolifera JEL478]	diamond	267	77.4	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Monoblepharidomycetes	Monoblepharidales	Gonapodyaceae	Gonapodya	Gonapodya prolifera
32070461	32070461	PRJNA559720_P_NODE_5458_length_442_cov_2.560976_g5319_i0	PRJNA559720	5458	442	2.560976	11.31951392	Polychytrium aggregatum	110093	Fungi	Fungi	57	2.7e-7	NR	XP_052967177.1	110093	g5319	i0	37.8	2.80316742081448	82	40	55.7	2	333	88	43	113	XP_052967177.1 mitochondrial ribosomal protein L37-domain-containing protein [Polychytrium aggregatum]	diamond	1239	57	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum

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