metadata: contig_metadata: 12 rows where bioproject = "PRJEB8827", tax_clade = "Opisthokonta" and tax

12 rows where bioproject = "PRJEB8827", 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
25530322	25530322	PRJEB8827h_S_NODE_233_length_453_cov_5.129187_g214_i0	PRJEB8827	233	453	5.129187	23.23521711	Synchytrium endobioticum	286115	Fungi	Fungi	129	3e-34	NR	TPX49355.1	286115	g214	i0	59.2	5.18543046357616	98	40	64.9	0	450	157	104	201	TPX49355.1 hypothetical protein SeLEV6574_g01513 [Synchytrium endobioticum]	diamond	2349	129	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Synchytriales	Synchytriaceae	Synchytrium	Synchytrium endobioticum
25665462	25665462	PRJEB8827b_S_NODE_38194_length_162_cov_1.181102_g38142_i0	PRJEB8827	38194	162	1.181102	1.91338524	Spizellomyces punctatus DAOM BR117	645134	Fungi	Fungi	115	1.7e-21	NTclustered	gi\|1026990807\|ref\|XM_016753365.1\|	645134	g38142	i0	94.595	38.7469135802469	74	4	46	0	89	162	1478	1405	Spizellomyces punctatus DAOM BR117 tubulin alpha chain (SPPG_05136), mRNA	blastn	6277	115	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Spizellomycetaceae	Spizellomyces	Spizellomyces punctatus
25938428	25938428	PRJEB8827f_S_NODE_428_length_466_cov_12.466357_g408_i0	PRJEB8827	428	466	12.466357	58.09322362	Synchytrium endobioticum	286115	Fungi	Fungi	151	6.1099999999999985e-43	NR	TPX49355.1	286115	g408	i0	62.4	5.60729613733906	109	41	70.2	0	1	327	93	201	TPX49355.1 hypothetical protein SeLEV6574_g01513 [Synchytrium endobioticum]	diamond	2613	151	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Synchytriales	Synchytriaceae	Synchytrium	Synchytrium endobioticum
26026120	26026120	PRJEB8827h_S_NODE_508_length_366_cov_3.691843_g489_i0	PRJEB8827	508	366	3.691843	13.51214538	Staurastromyces	2006669	Fungi	Fungi	102	3.4e-17	NTclustered	gi\|2465121858\|gb\|OQ687259.1\|	687209	g489	i0	81.203	37.4234972677596	133	20	36	4	236	366	405	534	Uncultured Rhizophydiales isolate UMPB-1297 small subunit ribosomal RNA gene, partial sequence	blastn	13697	102	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales			uncultured Rhizophydiales
26210536	26210536	PRJEB8827f_S_NODE_2878_length_256_cov_2.927602_g2858_i0	PRJEB8827	2878	256	2.927602	7.49466112	Polychytrium aggregatum	110093	Fungi	Fungi	246	9.95e-61	NTclustered	gi\|2432149348\|ref\|XM_053111166.1\|	110093	g2858	i0	87.736	80.1484375	212	25	83	1	45	256	531	321	Polychytrium aggregatum ribosomal protein S19-domain-containing protein (BJ171DRAFT_506928), mRNA	blastn	20518	246	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Polychytriales		Polychytrium	Polychytrium aggregatum
32931279	32931279	PRJEB8827f_S_NODE_5897_length_201_cov_2.198795_g5877_i0	PRJEB8827	5897	201	2.198795	4.41957795	Lobulomyces angularis	109889	Fungi	Fungi	51.2	1.64e-5	NR	KAJ3395771.1	109889	g5877	i0	68.8	0.477611940298507	32	10	47.8	0	24	119	207	238	KAJ3395771.1 hypothetical protein HDU92_004934 [Lobulomyces angularis]	diamond	96	51.2	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Lobulomycetales	Lobulomycetaceae	Lobulomyces	Lobulomyces angularis
32982757	32982757	PRJEB8827g_S_NODE_10723_length_158_cov_1.934959_g10702_i0	PRJEB8827	10723	158	1.934959	3.05723522	Chytridium lagenaria	64509	Fungi	Fungi	92	5e-20	NR	KAI8838341.1	64509	g10702	i0	71.2	0.987341772151899	52	15	98.7	0	2	157	986	1037	KAI8838341.1 hypothetical protein BC829DRAFT_421264 [Chytridium lagenaria]	diamond	156	92	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytridiaceae	Chytridium	Chytridium lagenaria
32999333	32999333	PRJEB8827b_S_NODE_1171_length_278_cov_6.572016_g1119_i0	PRJEB8827	1171	278	6.572016	18.27020448	Phlyctochytrium planicorne	261098	Fungi	Fungi	136	1.2899999999999999e-38	NR	KAJ3096340.1	261098	g1119	i0	68.8	0.863309352517986	80	25	86.3	0	5	244	95	174	KAJ3096340.1 hypothetical protein HDU97_006013 [Phlyctochytrium planicorne]	diamond	240	136	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytridiaceae	Phlyctochytrium	Phlyctochytrium planicorne
32999337	32999337	PRJEB8827b_S_NODE_28547_length_177_cov_3.021127_g28495_i0	PRJEB8827	28547	177	3.021127	5.34739479	Polyrhizophydium stewartii	2732419	Fungi	Fungi	80.9	5.46e-16	NR	KAL2917375.1	2732419	g28495	i0	66	0.796610169491525	47	16	79.7	0	2	142	783	829	KAL2917375.1 translation elongation factor 2 [Polyrhizophydium stewartii]	diamond	141	80.9	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Polyrhizophydium	Polyrhizophydium stewartii
32999608	32999608	PRJEB8827f_S_NODE_6363_length_197_cov_7293.808642_g6343_i0	PRJEB8827	6363	197	7293.808642	14368.80302474	Rhizophlyctis rosea	64517	Fungi	Fungi	46.6	7.62e-4	NR	KAJ3038683.1	64517	g6343	i0	66.7	0.883248730964467	30	10	45.7	0	138	49	211	240	KAJ3038683.1 hypothetical protein HDV00_000432 [Rhizophlyctis rosea]	diamond	174	46.6	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophlyctidales	Rhizophlyctidaceae	Rhizophlyctis	Rhizophlyctis rosea
32999656	32999656	PRJEB8827h_S_NODE_2099_length_231_cov_2.469388_g2080_i0	PRJEB8827	2099	231	2.469388	5.70428628	Blyttiomyces sp. JEL	2750429	Fungi	Fungi	51.6	2.19e-5	NR	KAJ3277740.1	2724214	g2080	i0	41.3	1.62337662337662	63	35	80.5	2	227	42	255	316	KAJ3277740.1 hypothetical protein HDU76_010187 [Blyttiomyces sp. JEL0837]	diamond	375	51.6	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes			Blyttiomyces	Blyttiomyces sp. JEL0837
33145335	33145335	PRJEB8827g_S_NODE_3543_length_189_cov_1.818182_g3522_i0	PRJEB8827	3543	189	1.818182	3.43636398	Batrachochytrium	100474	Fungi	Fungi	69.3	6.8e-12	NR	KAJ8326405.1	109871	g3522	i0	61.1	4.28571428571429	54	16	85.7	2	189	28	315	363	KAJ8326405.1 cross-pathway control WD-repeat protein cpc2 [Batrachochytrium dendrobatidis]	diamond	810	69.3	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium dendrobatidis

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