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

10 rows where analysis = "diamond", bioproject = "PRJNA897077" 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
28161356	28161356	PRJNA897077_P_NODE_20005_length_242_cov_0.923077_g19878_i0	PRJNA897077	20005	242	0.923077	2.23384634	Sarocladium strictum	5046	Fungi	Fungi	57.4	2.52e-7	NR	KAL2207107.1	5046	g19878	i0	41.9	0.91735537190082606	74	36	83.1	2	222	22	70	143	KAL2207107.1 hypothetical protein CC79DRAFT_1321241 [Sarocladium strictum]	diamond	222	57.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
28295093	28295093	PRJNA897077_P_NODE_4766_length_443_cov_1.900000_g4639_i0	PRJNA897077	4766	443	1.9	8.417	Opisthokonta	33154	Fungi	Fungi	150	2.3499999999999994e-42	NR	OXV11436.1	519963	g4639	i0	55.9	13.4356659142212	118	52	79.9	0	358	5	86	203	OXV11436.1 hypothetical protein Egran_00799 [Elaphomyces granulatus]	diamond	5952	150	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Elaphomycetaceae	Elaphomyces	Elaphomyces granulatus
28950733	28950733	PRJNA897077_P_NODE_18328_length_246_cov_0.901734_g18201_i0	PRJNA897077	18328	246	0.901734	2.21826564	Aspergillus awamori	105351	Fungi	Fungi	59.7	3.2e-8	NR	GCB24479.1	105351	g18201	i0	53.4	1.25609756097561	58	26	69.5	1	246	76	218	275	GCB24479.1 hypothetical protein AAWM_07364 [Aspergillus awamori]	diamond	309	59.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus awamori
29108493	29108493	PRJNA897077_P_NODE_13648_length_269_cov_1.255102_g13521_i0	PRJNA897077	13648	269	1.255102	3.37622438	Sarocladium strictum	5046	Fungi	Fungi	83.2	2.85e-16	NR	KAL2213864.1	5046	g13521	i0	55.7	0.780669144981413	70	30	78.1	1	58	267	424	492	KAL2213864.1 hypothetical protein CC79DRAFT_1327754 [Sarocladium strictum]	diamond	210	83.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
29487067	29487067	PRJNA897077_P_NODE_16570_length_250_cov_0.881356_g16443_i0	PRJNA897077	16570	250	0.881356	2.20339	Neophaeococcomyces mojaviensis	3383035	Fungi	Fungi	79.3	4.9e-15	NR	KAJ9651563.1	3383035	g16443	i0	67.9	0.636	53	17	63.6	0	177	19	1	53	KAJ9651563.1 chromosome loss- protein [Neophaeococcomyces mojaviensis]	diamond	159	79.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales		Neophaeococcomyces	Neophaeococcomyces mojaviensis
30118787	30118787	PRJNA897077_P_NODE_18912_length_244_cov_0.912281_g18785_i0	PRJNA897077	18912	244	0.912281	2.22596564	Cercospora berteroae	357750	Fungi	Fungi	45.4	0.00434	NR	PPJ49735.1	357750	g18785	i0	58.3	1.32786885245902	36	14	44.3	1	127	20	681	715	PPJ49735.1 hypothetical protein CBER1_02863 [Cercospora berteroae]	diamond	324	45.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Mycosphaerellaceae	Cercospora	Cercospora berteroae
30213537	30213537	PRJNA897077_P_NODE_15372_length_253_cov_0.866667_g15245_i0	PRJNA897077	15372	253	0.866667	2.19266751	Sarocladium strictum	5046	Fungi	Fungi	159	2.6499999999999998e-43	NR	KAL2201995.1	5046	g15245	i0	89.3	0.99604743083004	84	9	99.6	0	2	253	728	811	KAL2201995.1 PALB protein [Sarocladium strictum]	diamond	252	159	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
30466780	30466780	PRJNA897077_P_NODE_15693_length_252_cov_0.871508_g15566_i0	PRJNA897077	15693	252	0.871508	2.19620016	Chaetothyriales sp. CBS 132	1715222	Fungi	Fungi	53.9	4.51e-6	NR	RMZ79039.1	2249419	g15566	i0	51	0.607142857142857	51	24	60.7	1	9	161	127	176	RMZ79039.1 hypothetical protein DV737_g3574, partial [Chaetothyriales sp. CBS 132003]	diamond	153	53.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales			Chaetothyriales sp. CBS 132003
31327304	31327304	PRJNA897077_P_NODE_6115_length_393_cov_2.675000_g5988_i0	PRJNA897077	6115	393	2.675	10.51275	Ascomycota	4890	Fungi	Fungi	47.8	4.06e-4	NR	KAJ6259137.1	74499	g5988	i0	43.5	1.09923664122137	85	43	62.6	2	264	19	2	84	KAJ6259137.1 putative 26S proteasome complex subunit sem-1 [Drechslerella dactyloides]	diamond	432	48.1	0.993762993762994	Eukaryota	Opisthokonta	Fungi	Ascomycota	Orbiliomycetes	Orbiliales	Orbiliaceae	Drechslerella	Drechslerella dactyloides
32086552	32086552	PRJNA897077_P_NODE_16038_length_251_cov_0.876404_g15911_i0	PRJNA897077	16038	251	0.876404	2.19977404	Ascomycota	4890	Fungi	Fungi	140	1.82e-36	NR	XP_049113331.1	63214	g15911	i0	79.5	4.9601593625498	83	17	99.2	0	3	251	1426	1508	XP_049113331.1 acyl transferase domain-containing protein [Hypoxylon fragiforme]	diamond	1245	140	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Xylariales	Hypoxylaceae	Hypoxylon	Hypoxylon fragiforme

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