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

7 rows where analysis = "diamond", bioproject = "PRJNA1248471" 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
27958022	27958022	PRJNA1248471_S_NODE_10425_length_202_cov_0.875817_g10325_i0	PRJNA1248471	10425	202	0.875817	1.76915034	Neohortaea acidophila	245834	Fungi	Fungi	95.9	2.27e-24	NR	XP_033592549.1	245834	g10325	i0	75	0.831683168316832	56	14	83.2	0	200	33	2	57	XP_033592549.1 ATPase, F0 complex, subunit J [Neohortaea acidophila]	diamond	168	95.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Mycosphaerellales	Teratosphaeriaceae	Neohortaea	Neohortaea acidophila
28084241	28084241	PRJNA1248471_S_NODE_6185_length_237_cov_1.627660_g6085_i0	PRJNA1248471	6185	237	1.62766	3.8575542	Aspergillus udagawae	91492	Fungi	Fungi	138	9.76e-36	NR	GFF63562.1	91492	g6085	i0	84.4	3.8987341772151902	77	12	97.5	0	237	7	306	382	GFF63562.1 unnamed protein product [Aspergillus udagawae]	diamond	924	138	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus udagawae
28115791	28115791	PRJNA1248471_S_NODE_20305_length_164_cov_1.330435_g20205_i0	PRJNA1248471	20305	164	1.330435	2.1819134	Knufia obscura	1635080	Fungi	Fungi	67.8	1.04e-12	NR	XP_064734377.1	1635080	g20205	i0	72.1	3.14634146341463	43	12	78.7	0	3	131	86	128	XP_064734377.1 uncharacterized protein PMZ80_000429 [Knufia obscura]	diamond	516	67.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Trichomeriaceae	Knufia	Knufia obscura
28431718	28431718	PRJNA1248471_S_NODE_3826_length_280_cov_1.861472_g3726_i0	PRJNA1248471	3826	280	1.861472	5.2121216	Lithohypha guttulata	1690604	Fungi	Fungi	127	1.16e-32	NR	KAK5106566.1	1690604	g3726	i0	86.4	5.66785714285714	66	9	70.7	0	280	83	376	441	KAK5106566.1 hypothetical protein LTS08_000686 [Lithohypha guttulata]	diamond	1587	127	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Trichomeriaceae	Lithohypha	Lithohypha guttulata
29347380	29347380	PRJNA1248471_S_NODE_17809_length_169_cov_1.575000_g17709_i0	PRJNA1248471	17809	169	1.575	2.66175	Lignoscripta atroalba	2918522	Fungi	Fungi	40.8	0.0395	NR	MCJ1256285.1	2918522	g17709	i0	94.7	1.3491124260355	19	1	33.7	0	167	111	132	150	MCJ1256285.1 hypothetical protein [Lignoscripta atroalba]	diamond	228	40.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Trapeliales	Trapeliaceae	Lignoscripta	Lignoscripta atroalba
31956532	31956532	PRJNA1248471_S_NODE_16957_length_172_cov_1.243902_g16857_i0	PRJNA1248471	16957	172	1.243902	2.13951144	Chaetothyriales	34395	Fungi	Fungi	90.1	1.36e-19	NR	XP_016625510.1	1442370	g16857	i0	77.2	6.94186046511628	57	13	99.4	0	1	171	269	325	XP_016625510.1 uncharacterized protein Z519_00504 [Cladophialophora bantiana CBS 173.52]	diamond	1194	90.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Herpotrichiellaceae	Cladophialophora	Cladophialophora bantiana
32128614	32128614	PRJNA1248471_S_NODE_6458_length_234_cov_1.156757_g6358_i0	PRJNA1248471	6458	234	1.156757	2.70681138	Aspergillus chevalieri	182096	Fungi	Fungi	60.8	1.39e-8	NR	XP_043131589.1	182096	g6358	i0	45.5	3.82051282051282	77	17	89.7	2	219	10	437	495	XP_043131589.1 uncharacterized protein ACHE_10469S [Aspergillus chevalieri]	diamond	894	60.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Aspergillus	Aspergillus chevalieri

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