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

13 rows where bioproject = "PRJNA753704", 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
731050	731050	PRJNA753704_P_NODE_26781_length_245_cov_1.813953_g26420_i0	PRJNA753704	26781	245	1.813953	4.44418485	Fungi	4751	Fungi	Fungi	100	8.86e-26	NR	KAI8904132.1	382530	g26420	i0	64.9	3.62448979591837	74	26	90.6	0	1	222	9	82	KAI8904132.1 putative 40s ribosomal protein s21 [Gorgonomyces haynaldii]	diamond	888	100	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales	Gorgonomycetaceae	Gorgonomyces	Gorgonomyces haynaldii
5834524	5834524	PRJNA753704_P_NODE_11425_length_350_cov_2.891697_g11064_i0	PRJNA753704	11425	350	2.891697	10.1209395	Fimicolochytrium jonesii	1396493	Fungi	Fungi	182	4.04e-41	NTclustered	gi\|2432072721\|ref\|XM_053073277.1\|	1396493	g11064	i0	77.448	9.83142857142857	337	54	94	15	12	340	537	859	Fimicolochytrium jonesii Hsp90 protein-domain-containing protein (EV422DRAFT_578072), mRNA	blastn	3441	182	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Fimicolochytrium	Fimicolochytrium jonesii
9659586	9659586	PRJNA753704_P_NODE_25028_length_249_cov_2.068182_g24667_i0	PRJNA753704	25028	249	2.068182	5.14977318	Chytridiales sp. JEL	2011832	Fungi	Fungi	157	6.879999999999999e-43	NR	KAJ3405388.1	2786947	g24667	i0	87.8	1.97590361445783	82	10	98.8	0	248	3	148	229	KAJ3405388.1 Pre-mRNA-processing-splicing factor 8, partial [Chytridiales sp. JEL 0842]	diamond	492	157	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales			Chytridiales sp. JEL 0842
10934959	10934959	PRJNA753704_P_NODE_11969_length_343_cov_1.959259_g11608_i0	PRJNA753704	11969	343	1.959259	6.72025837	Fimicolochytrium jonesii	1396493	Fungi	Fungi	241	6.45e-59	NTclustered	gi\|2432064921\|ref\|XM_053069781.1\|	1396493	g11608	i0	81.787	30.9125364431487	291	49	84	4	11	299	542	254	Fimicolochytrium jonesii tubulin, alpha, ubiquitous (EV422DRAFT_521958), mRNA	blastn	10603	241	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Fimicolochytrium	Fimicolochytrium jonesii
16033698	16033698	PRJNA753704_P_NODE_2333_length_716_cov_5.847589_g1997_i0	PRJNA753704	2333	716	5.847589	41.86873724	Rhizophydium sp.	2012224	Fungi	Fungi	440	1.31e-118	NTclustered	gi\|1866582435\|gb\|MT730610.1\|	2012224	g1997	i0	81.93	77.0572625698324	570	58	78	26	1	562	3964	4496	Rhizophydium sp. isolate ARG035 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	55173	440	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales	Rhizophydiaceae	Rhizophydium	Rhizophydium sp.
29231980	29231980	PRJNA753704_P_NODE_27929_length_243_cov_0.917647_g27568_i0	PRJNA753704	27929	243	0.917647	2.22988221	Phlyctochytrium arcticum	1117335	Fungi	Fungi	74.7	2e-13	NR	KAI9102516.1	1117335	g27568	i0	44.2	6.72839506172839	77	41	95.1	1	11	241	339	413	KAI9102516.1 ras guanine nucleotide exchange factor domain-containing protein [Phlyctochytrium arcticum]	diamond	1635	74.7	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytridiaceae	Phlyctochytrium	Phlyctochytrium arcticum
29800088	29800088	PRJNA753704_P_NODE_16071_length_300_cov_1.030837_g15710_i0	PRJNA753704	16071	300	1.030837	3.092511	Boothiomyces macroporosus	261099	Fungi	Fungi	49.7	2.62e-4	NR	KAJ3250372.1	261099	g15710	i0	34.7	0.72	72	46	72	1	280	65	490	560	KAJ3250372.1 hypothetical protein HK103_003625 [Boothiomyces macroporosus]	diamond	216	49.7	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales	Terramycetaceae	Boothiomyces	Boothiomyces macroporosus
30052779	30052779	PRJNA753704_P_NODE_26091_length_247_cov_0.896552_g25730_i0	PRJNA753704	26091	247	0.896552	2.21448344	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	54.3	3.45e-6	NR	KAH9254574.1	1357716	g25730	i0	42.9	0.765182186234818	63	36	76.5	0	1	189	2323	2385	KAH9254574.1 hypothetical protein BASA81_007331 [Batrachochytrium salamandrivorans]	diamond	189	54.3	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
30400931	30400931	PRJNA753704_P_NODE_16913_length_293_cov_0.850000_g16552_i0	PRJNA753704	16913	293	0.85	2.4905	Hyaloraphidium curvatum	82268	Fungi	Fungi	65.9	4.94e-10	NR	KAI9006319.1	82268	g16552	i0	39.1	0.890784982935154	87	44	89.1	1	293	33	234	311	KAI9006319.1 hypothetical protein DFJ74DRAFT_690279 [Hyaloraphidium curvatum]	diamond	261	65.9	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Monoblepharidomycetes	Monoblepharidales		Hyaloraphidium	Hyaloraphidium curvatum
30653045	30653045	PRJNA753704_P_NODE_5013_length_508_cov_3.714943_g4652_i0	PRJNA753704	5013	508	3.714943	18.87191044	Hyaloraphidium curvatum	82268	Fungi	Fungi	68.2	7.83e-10	NR	KAI9031179.1	82268	g4652	i0	34.1	1.56496062992126	135	69	73.8	6	68	442	73	197	KAI9031179.1 kinase-like domain-containing protein [Hyaloraphidium curvatum]	diamond	795	68.2	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Monoblepharidomycetes	Monoblepharidales		Hyaloraphidium	Hyaloraphidium curvatum
30716300	30716300	PRJNA753704_P_NODE_25994_length_247_cov_1.666667_g25633_i0	PRJNA753704	25994	247	1.666667	4.11666749	Globomyces pollinis-pini	382532	Fungi	Fungi	63.9	1.26e-9	NR	KAI8892613.1	382532	g25633	i0	47.6	1.54251012145749	63	33	76.5	0	57	245	25	87	KAI8892613.1 citrate synthase-like protein [Globomyces pollinis-pini]	diamond	381	63.9	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales	Globomycetaceae	Globomyces	Globomyces pollinis-pini
32139368	32139368	PRJNA753704_P_NODE_28898_length_239_cov_2.204819_g28537_i0	PRJNA753704	28898	239	2.204819	5.26951741	Synchytrium endobioticum	286115	Fungi	Fungi	52.8	1.05e-5	NR	TPX45819.1	286115	g28537	i0	47.1	1.74476987447699	70	33	82.8	2	3	200	1040	1109	TPX45819.1 hypothetical protein SeLEV6574_g03638 [Synchytrium endobioticum]	diamond	417	52.8	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Synchytriales	Synchytriaceae	Synchytrium	Synchytrium endobioticum
32434200	32434200	PRJNA753704_P_NODE_19339_length_276_cov_1.315271_g18978_i0	PRJNA753704	19339	276	1.315271	3.63014796	Dinochytrium	3065265	Fungi	Fungi	136	2.3899999999999997e-37	NR	KAJ3194626.1	1774096	g18978	i0	72.8	13.9782608695652	92	25	100	0	276	1	172	263	KAJ3194626.1 hypothetical protein HDU67_004658 [Dinochytrium kinnereticum]	diamond	3858	137	0.992700729927007	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytridiaceae	Dinochytrium	Dinochytrium kinnereticum

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