metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA1086823" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA1086823" 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
28488756	28488756	PRJNA1086823_P_NODE_17527_length_244_cov_1.824561_g17410_i0	PRJNA1086823	17527	244	1.824561	4.45192884	Siphonaria sp. JEL	2047469	Fungi	Fungi	73.6	7.96e-14	NR	KAJ3026490.1	2723227	g17410	i0	51.3	0.934426229508197	76	37	93.4	0	2	229	47	122	KAJ3026490.1 Meiotic nuclear division protein 1 [Siphonaria sp. JEL0065]	diamond	228	73.6	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Siphonaria	Siphonaria sp. JEL0065
29246397	29246397	PRJNA1086823_P_NODE_3429_length_417_cov_8.848837_g3312_i0	PRJNA1086823	3429	417	8.848837	36.89965029	Cladochytrium tenue	1604274	Fungi	Fungi	154	1.6699999999999998e-45	NR	KAJ1568147.1	1604274	g3312	i0	63.3	1.86330935251799	128	47	92.1	0	402	19	4	131	KAJ1568147.1 60S ribosomal protein L32 [Cladochytrium tenue]	diamond	777	154	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Cladochytriales	Cladochytriaceae	Cladochytrium	Cladochytrium tenue
30794113	30794113	PRJNA1086823_P_NODE_17454_length_245_cov_0.906977_g17337_i0	PRJNA1086823	17454	245	0.906977	2.22209365	Polyrhizophydium stewartii	2732419	Fungi	Fungi	62	6.37e-9	NR	KAL2912896.1	2732419	g17337	i0	42	7.81224489795918	81	41	96.7	2	239	3	1349	1425	KAL2912896.1 proteasome component M29 [Polyrhizophydium stewartii]	diamond	1914	62	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Polyrhizophydium	Polyrhizophydium stewartii
31101453	31101453	PRJNA1086823_P_NODE_8395_length_288_cov_2.972093_g8278_i0	PRJNA1086823	8395	288	2.972093	8.55962784	Fungi	4751	Fungi	Fungi	107	8.349999999999999e-28	NR	KAJ3245456.1	4814	g8278	i0	61.6	29.09375	86	33	89.6	0	287	30	37	122	KAJ3245456.1 60S ribosomal protein L30 [Chytriomyces hyalinus]	diamond	8379	108	0.990740740740741	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytriomycetaceae	Chytriomyces	Chytriomyces hyalinus
31268244	31268244	PRJNA1086823_P_NODE_4835_length_361_cov_1.319444_g4718_i0	PRJNA1086823	4835	361	1.319444	4.76319284	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	106	2.3e-26	NR	KAH6601223.1	1357716	g4718	i0	51.9	2.70914127423823	108	50	89.8	2	332	9	1	106	KAH6601223.1 hypothetical protein BASA50_001749 [Batrachochytrium salamandrivorans]	diamond	978	106	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
31331388	31331388	PRJNA1086823_P_NODE_17516_length_244_cov_1.824561_g17399_i0	PRJNA1086823	17516	244	1.824561	4.45192884	Batrachochytrium salamandrivorans	1357716	Fungi	Fungi	53.1	8.43e-7	NR	KAH9257738.1	1357716	g17399	i0	38.4	0.897540983606557	73	44	89.8	1	3	221	24	95	KAH9257738.1 hypothetical protein BASA81_004204 [Batrachochytrium salamandrivorans]	diamond	219	53.1	1	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Rhizophydiales		Batrachochytrium	Batrachochytrium salamandrivorans
31828746	31828746	PRJNA1086823_P_NODE_17597_length_244_cov_1.216374_g17480_i0	PRJNA1086823	17597	244	1.216374	2.96795256	Chytridiaceae	4812	Fungi	Fungi	67.8	3.84e-12	NR	KAI8847197.1	64509	g17480	i0	48.6	1.89344262295082	74	38	91	0	244	23	25	98	KAI8847197.1 Rpl14 protein [Chytridium lagenaria]	diamond	462	68.2	0.994134897360704	Eukaryota	Opisthokonta	Fungi	Chytridiomycota	Chytridiomycetes	Chytridiales	Chytridiaceae	Chytridium	Chytridium lagenaria

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