metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA356682" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA356682" and tax_phylum = "Ascomycota"

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
26933760	26933760	PRJNA356682_P_NODE_13742_length_381_cov_1.954545_g13052_i0	PRJNA356682	13742	381	1.954545	7.44681645	Dothideomycetes	147541	Fungi	Fungi	44.3	0.0432	NR	THW14794.1	5580	g13052	i0	38.2	1.07086614173228	68	33	53.5	1	45	248	302	360	THW14794.1 putative multicopper oxidase, type 1, partial [Aureobasidium pullulans]	diamond	408	44.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Dothideales	Saccotheciaceae	Aureobasidium	Aureobasidium pullulans
27028727	27028727	PRJNA356682_P_NODE_38582_length_248_cov_0.880000_g37891_i0	PRJNA356682	38582	248	0.88	2.1824	Eukaryota	2759	Fungi	Fungi	85.9	2.6e-17	NR	MCJ1356809.1	90408	g37891	i0	51.8	6	83	39	99.2	1	248	3	507	589	MCJ1356809.1 26S proteasome non-ATPase regulatory subunit [Icmadophila ericetorum]	diamond	1488	86.7	0.990772779700115	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Pertusariales	Icmadophilaceae	Icmadophila	Icmadophila ericetorum
27944863	27944863	PRJNA356682_P_NODE_19445_length_326_cov_30.256917_g18754_i0	PRJNA356682	19445	326	30.256917	98.63754942	Saccharomyces	4930	Fungi	Fungi	65.1	1.48e-10	NR	KAF4001137.1	4932	g18754	i0	53.7	3.03680981595092	67	21	61.7	1	8	208	51	107	KAF4001137.1 Protein TAR1 domain protein [Saccharomyces cerevisiae]	diamond	990	65.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Saccharomyces	Saccharomyces cerevisiae
28022553	28022553	PRJNA356682_P_NODE_42525_length_243_cov_1.811765_g41834_i0	PRJNA356682	42525	243	1.811765	4.40258895	Fusarium xylarioides	221167	Fungi	Fungi	42.7	0.0361	NR	KAG5764302.1	221167	g41834	i0	35.7	0.691358024691358	56	36	69.1	0	226	59	281	336	KAG5764302.1 hypothetical protein H9Q72_007628 [Fusarium xylarioides]	diamond	168	42.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium xylarioides
28085456	28085456	PRJNA356682_P_NODE_46445_length_229_cov_2.692308_g45754_i0	PRJNA356682	46445	229	2.692308	6.16538532	Fusarium graminearum	5518	Fungi	Fungi	110	2.1600000000000003e-27	NR	EYB28013.1	5518	g45754	i0	74.7	0.982532751091703	75	19	98.3	0	229	5	76	150	EYB28013.1 hypothetical protein FG05_30296 [Fusarium graminearum]	diamond	225	110	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium graminearum
29506304	29506304	PRJNA356682_P_NODE_44830_length_241_cov_0.916667_g44139_i0	PRJNA356682	44830	241	0.916667	2.20916747	Cytospora schulzeri	448051	Fungi	Fungi	54.7	2.23e-6	NR	ROW10510.1	448051	g44139	i0	70.6	2.11618257261411	34	10	42.3	0	240	139	271	304	ROW10510.1 hypothetical protein VMCG_01763 [Cytospora schulzeri]	diamond	510	54.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Diaporthales	Cytosporaceae	Cytospora	Cytospora schulzeri
30611836	30611836	PRJNA356682_P_NODE_7673_length_505_cov_3.601852_g6984_i0	PRJNA356682	7673	505	3.601852	18.1893526	Candelaria pacifica	460848	Fungi	Fungi	45.8	0.0355	NR	KAI9688013.1	460848	g6984	i0	28.8	0.700990099009901	118	79	67.1	2	414	76	324	441	KAI9688013.1 MAG: hypothetical protein M1812_008578 [Candelaria pacifica]	diamond	354	45.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Candelariomycetes	Candelariales	Candelariaceae	Candelaria	Candelaria pacifica
30675030	30675030	PRJNA356682_P_NODE_43633_length_242_cov_0.911243_g42942_i0	PRJNA356682	43633	242	0.911243	2.20520806	Lecanicillium sp. MT-2	1756136	Fungi	Fungi	127	4.43e-33	NR	KAK3181793.1	1964301	g42942	i0	82.4	0.91735537190082606	74	13	91.7	0	11	232	100	173	KAK3181793.1 hypothetical protein K4F52_006860 [Lecanicillium sp. MT-2017a]	diamond	222	127	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Cordycipitaceae	Lecanicillium	Lecanicillium sp. MT-2017a
31275490	31275490	PRJNA356682_P_NODE_37115_length_250_cov_0.870056_g36424_i0	PRJNA356682	37115	250	0.870056	2.17514	Chaetothyriales sp. CBS 132	1715222	Fungi	Fungi	47.4	9.46e-4	NR	RMZ86240.1	2249419	g36424	i0	38.3	0.72	60	37	72	0	248	69	998	1057	RMZ86240.1 hypothetical protein DV737_g48, partial [Chaetothyriales sp. CBS 132003]	diamond	180	47.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales			Chaetothyriales sp. CBS 132003
32855866	32855866	PRJNA356682_P_NODE_42360_length_244_cov_0.871345_g41669_i0	PRJNA356682	42360	244	0.871345	2.1260818	Ampelomyces quisqualis	50730	Fungi	Fungi	156	4.89e-42	NR	KAF1920339.1	50730	g41669	i0	90.1	0.995901639344262	81	8	99.6	0	243	1	562	642	KAF1920339.1 hypothetical protein BDU57DRAFT_464681 [Ampelomyces quisqualis]	diamond	243	156	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Phaeosphaeriaceae	Ampelomyces	Ampelomyces quisqualis

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