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

13 rows where bioproject = "PRJNA695273", 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
677936	677936	PRJNA695273_P_NODE_31721_length_484_cov_6.980535_g30963_i0	PRJNA695273	31721	484	6.980535	33.7857894	Synchytrium endobioticum	286115	Fungi	Fungi	222	1.8800000000000002e-71	NR	TPX40759.1	286115	g30963	i0	81.5	7.38842975206612	130	24	80.6	0	449	60	38	167	TPX40759.1 hypothetical protein SeMB42_g05894 [Synchytrium endobioticum]	diamond	3576	222	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Synchytriales	Synchytriaceae	Synchytrium	Synchytrium endobioticum
8331275	8331275	PRJNA695273_P_NODE_40747_length_425_cov_1.724432_g39989_i0	PRJNA695273	40747	425	1.724432	7.328836	Eukaryota	2759	Fungi	Fungi	204	7.49e-65	NR	KAJ3397372.1	109889	g39989	i0	83.7	33.1694117647059	123	20	86.8	0	420	52	29	151	KAJ3397372.1 ribosomal 40S subunit protein S13 [Lobulomyces angularis]	diamond	14097	205	0.995121951219512	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Lobulomycetales	Lobulomycetaceae	Lobulomyces	Lobulomyces angularis
8835610	8835610	PRJNA695273_P_NODE_35887_length_453_cov_4.468421_g35129_i0	PRJNA695273	35887	453	4.468421	20.24194713	Quaeritorhiza haematococci	2654861	Fungi	Fungi	155	5.27e-46	NR	KAJ3083753.1	2654861	g35129	i0	69.2	3.44370860927152	104	28	68.9	1	436	125	1	100	KAJ3083753.1 40S ribosomal protein S26, partial [Quaeritorhiza haematococci]	diamond	1560	155	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes		Quaeritorhizaceae	Quaeritorhiza	Quaeritorhiza haematococci
14706908	14706908	PRJNA695273_P_NODE_31192_length_489_cov_1.935096_g30434_i0	PRJNA695273	31192	489	1.935096	9.46261944	Powellomyces hirtus	109895	Fungi	Fungi	191	1.84e-59	NR	KAI8920797.1	109895	g30434	i0	79.5	4.2760736196319	117	24	71.8	0	1	351	8	124	KAI8920797.1 ribosomal protein S27a, partial [Powellomyces hirtus]	diamond	2091	191	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Powellomyces	Powellomyces hirtus
19803998	19803998	PRJNA695273_P_NODE_141076_length_247_cov_0.885057_g140318_i0	PRJNA695273	141076	247	0.885057	2.18609079	Chytridiomycetes	451435	Fungi	Fungi	165	2.96e-45	NR	KAH6586459.1	1357716	g140318	i0	93.9	2.98785425101215	82	5	99.6	0	246	1	187	268	KAH6586459.1 hypothetical protein BASA50_000414 [Batrachochytrium salamandrivorans]	diamond	738	165	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
19805244	19805244	PRJNA695273_P_NODE_53956_length_371_cov_1.657718_g53198_i0	PRJNA695273	53956	371	1.657718	6.15013378	Feramyces austinii	2170546	Fungi	Fungi	457	6.4e-124	NTclustered	gi\|1388116306\|gb\|MH043840.1\|	2170546	g53198	i0	94.02	19.0026954177898	301	18	81	0	71	371	1	301	Feramyces austinii strain WSF3a Glycosyl hydrolase family 130 mRNA, partial cds	blastn	7050	457	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Neocallimastigomycetes	Neocallimastigales	Neocallimastigaceae	Feramyces	Feramyces austinii
27283601	27283601	PRJNA695273_P_NODE_134803_length_248_cov_1.691429_g134045_i0	PRJNA695273	134803	248	1.691429	4.19474392	Chytridiomycetes	451435	Fungi	Fungi	50.4	7.69e-5	NR	KAJ3211891.1	109932	g134045	i0	42.3	3.84677419354839	78	43	94.4	1	238	5	813	888	KAJ3211891.1 hypothetical protein HDU82_004581 [Entophlyctis luteolus]	diamond	954	50.8	0.992125984251969	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Entophlyctis	Entophlyctis luteolus
30947193	30947193	PRJNA695273_P_NODE_89894_length_291_cov_1.412844_g89136_i0	PRJNA695273	89894	291	1.412844	4.11137604	Eukaryota	2759	Fungi	Fungi	83.6	1.97e-18	NR	KAJ3152744.1	1134077	g89136	i0	50.6	7.05154639175258	79	39	81.4	0	290	54	3	81	KAJ3152744.1 hypothetical protein HDU86_005501 [Geranomyces michiganensis]	diamond	2052	84.3	0.991696322657177	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Geranomyces	Geranomyces michiganensis
31030762	31030762	PRJNA695273_P_NODE_129135_length_250_cov_0.870056_g128377_i0	PRJNA695273	129135	250	0.870056	2.17514	Polyrhizophydium stewartii	2732419	Fungi	Fungi	97.8	1.6e-21	NR	KAL2911735.1	2732419	g128377	i0	80.8	0.624	52	10	62.4	0	93	248	519	570	KAL2911735.1 Osmotic growth protein [Polyrhizophydium stewartii]	diamond	156	97.8	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Polyrhizophydium	Polyrhizophydium stewartii
31979198	31979198	PRJNA695273_P_NODE_50178_length_383_cov_6.219355_g49420_i0	PRJNA695273	50178	383	6.219355	23.82012965	Fimicolochytrium jonesii	1396493	Fungi	Fungi	83.2	1.94e-17	NR	XP_052928359.1	1396493	g49420	i0	41.8	2.67885117493473	110	60	83.8	2	383	63	6	114	XP_052928359.1 ribosomal L28e/Mak16 [Fimicolochytrium jonesii]	diamond	1026	83.2	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Powellomycetaceae	Fimicolochytrium	Fimicolochytrium jonesii
32169373	32169373	PRJNA695273_P_NODE_67238_length_335_cov_1.637405_g66480_i0	PRJNA695273	67238	335	1.637405	5.48530675	Piromyces finnis	1754191	Fungi	Fungi	77	1.07e-13	NR	ORX43597.1	1754191	g66480	i0	37.8	0.994029850746269	111	69	99.4	0	2	334	1266	1376	ORX43597.1 ras GEF [Piromyces finnis]	diamond	333	77	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Neocallimastigomycetes	Neocallimastigales	Neocallimastigaceae	Piromyces	Piromyces finnis
32422264	32422264	PRJNA695273_P_NODE_152879_length_243_cov_0.905882_g152121_i0	PRJNA695273	152879	243	0.905882	2.20129326	Quaeritorhiza haematococci	2654861	Fungi	Fungi	71.2	3.38e-12	NR	KAJ3063251.1	2654861	g152121	i0	47.6	1.01234567901235	82	42	100	1	1	243	281	362	KAJ3063251.1 hypothetical protein HK102_008526, partial [Quaeritorhiza haematococci]	diamond	246	71.2	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes		Quaeritorhizaceae	Quaeritorhiza	Quaeritorhiza haematococci
32517394	32517394	PRJNA695273_P_NODE_103719_length_275_cov_2.227723_g102961_i0	PRJNA695273	103719	275	2.227723	6.12623825	Spizellomyces sp. 'palustris'	117820	Fungi	Fungi	55.5	1.24e-6	NR	TPX62503.1	117820	g102961	i0	64.1	0.425454545454545	39	14	42.5	0	270	154	202	240	TPX62503.1 hypothetical protein SpCBS45565_g06994 [Spizellomyces sp. 'palustris']	diamond	117	55.5	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Spizellomycetales	Spizellomycetaceae	Spizellomyces	Spizellomyces sp. 'palustris'

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