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

7 rows where analysis = "diamond", bioproject = "PRJEB15333" 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
28864746	28864746	PRJEB15333_P_NODE_18128_length_167_cov_0.881356_g18044_i0	PRJEB15333	18128	167	0.881356	1.47186452	Penicillium canariense	189055	Fungi	Fungi	50.4	2.55e-5	NR	XP_056542318.1	189055	g18044	i0	50	2.33532934131737	46	23	82.6	0	14	151	1263	1308	XP_056542318.1 zinc finger protein [Penicillium canariense]	diamond	390	50.8	0.992125984251969	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium canariense
29401576	29401576	PRJEB15333_P_NODE_14489_length_181_cov_1.568182_g14405_i0	PRJEB15333	14489	181	1.568182	2.83840942	Diplogelasinospora grovesii	303347	Fungi	Fungi	43.1	0.0101	NR	KAK3933633.1	303347	g14405	i0	39.7	0.961325966850829	58	31	89.5	1	172	11	48	105	KAK3933633.1 hypothetical protein QBC46DRAFT_432328, partial [Diplogelasinospora grovesii]	diamond	174	43.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Sordariales	Diplogelasinosporaceae	Diplogelasinospora	Diplogelasinospora grovesii
29527945	29527945	PRJEB15333_P_NODE_20070_length_163_cov_0.912281_g19986_i0	PRJEB15333	20070	163	0.912281	1.48701803	Lecanicillium fungicola	93591	Fungi	Fungi	64.3	3.09e-10	NR	KAJ2975916.1	93591	g19986	i0	90.3	0.570552147239264	31	3	57.1	0	70	162	250	280	KAJ2975916.1 hypothetical protein NQ176_g5245 [Lecanicillium fungicola]	diamond	93	64.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Cordycipitaceae	Zarea	Zarea fungicola
31107272	31107272	PRJEB15333_P_NODE_14335_length_182_cov_1.481203_g14251_i0	PRJEB15333	14335	182	1.481203	2.69578946	Botryosphaeria dothidea	55169	Fungi	Fungi	41.6	0.0432	NR	KAK7715917.1	55169	g14251	i0	39.6	0.791208791208791	48	29	79.1	0	7	150	866	913	KAK7715917.1 hypothetical protein SLS57_006668 [Botryosphaeria dothidea]	diamond	144	41.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Botryosphaeriales	Botryosphaeriaceae	Botryosphaeria	Botryosphaeria dothidea
31360489	31360489	PRJEB15333_P_NODE_19476_length_164_cov_0.904348_g19392_i0	PRJEB15333	19476	164	0.904348	1.48313072	Phaeosphaeriaceae sp. PMI8	1756107	Fungi	Fungi	40.4	0.0493	NR	KAH8730602.1	1770614	g19392	i0	34.9	0.786585365853659	43	27	76.8	1	11	136	12	54	KAH8730602.1 hypothetical protein GQ44DRAFT_449649 [Phaeosphaeriaceae sp. PMI808]	diamond	129	40.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Phaeosphaeriaceae		Phaeosphaeriaceae sp. PMI808
32056206	32056206	PRJEB15333_P_NODE_9738_length_217_cov_0.738095_g9654_i0	PRJEB15333	9738	217	0.738095	1.60166615	Durotheca rogersii	419775	Fungi	Fungi	43.9	0.0102	NR	XP_051370090.1	419775	g9654	i0	40.4	0.788018433179724	57	34	78.8	0	214	44	194	250	XP_051370090.1 uncharacterized protein GGS23DRAFT_148588 [Durotheca rogersii]	diamond	171	43.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Xylariales	Xylariaceae	Durotheca	Durotheca rogersii
32309689	32309689	PRJEB15333_P_NODE_4299_length_310_cov_2.789272_g4215_i0	PRJEB15333	4299	310	2.789272	8.6467432	Didymella heteroderae	1769908	Fungi	Fungi	44.7	0.0176	NR	KAF3044771.1	1769908	g4215	i0	31.5	0.706451612903226	73	41	70.6	2	247	29	665	728	KAF3044771.1 glutamine--fructose-6-phosphate transaminase (isomerizing) [Didymella heteroderae]	diamond	219	44.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Didymellaceae	Didymella	Didymella heteroderae

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