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

10 rows where analysis = "diamond", bioproject = "PRJNA638138" 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
609411	609411	PRJNA638138_P_NODE_28561_length_245_cov_0.895349_g28346_i0	PRJNA638138	28561	245	0.895349	2.19360505	Cladosporium halotolerans	1052096	Fungi	Fungi	157	1.66e-44	NR	XP_069227169.1	1052096	g28346	i0	87.7	0.991836734693878	81	10	99.2	0	3	245	127	207	XP_069227169.1 uncharacterized protein WHR41_08132 [Cladosporium halotolerans]	diamond	243	157	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
26859856	26859856	PRJNA638138_P_NODE_32621_length_243_cov_0.905882_g32406_i0	PRJNA638138	32621	243	0.905882	2.20129326	Periconia digitata	1303443	Fungi	Fungi	59.7	3.62e-8	NR	CAI6340160.1	1303443	g32406	i0	96.6	0.358024691358025	29	1	35.8	0	156	242	1	29	CAI6340160.1 unnamed protein product [Periconia digitata]	diamond	87	59.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Periconiaceae	Periconia	Periconia digitata
26903788	26903788	PRJNA638138_P_NODE_13741_length_293_cov_0.972727_g13526_i0	PRJNA638138	13741	293	0.972727	2.85009011	Fusarium	5506	Fungi	Fungi	43.9	0.0251	NR	SCO82743.1	5507	g13526	i0	34.2	1.49488054607509	73	46	74.7	2	262	44	195	265	SCO82743.1 uncharacterized protein FRV6_06956 [Fusarium oxysporum]	diamond	438	43.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium oxysporum
27694009	27694009	PRJNA638138_P_NODE_17884_length_260_cov_1.358289_g17669_i0	PRJNA638138	17884	260	1.358289	3.5315514	Pleosporales	92860	Fungi	Fungi	64.3	1.13e-9	NR	KAL1595376.1	749835	g17669	i0	49.3	13.5692307692308	75	38	86.5	0	243	19	23	97	KAL1595376.1 putative RNA helicase [Nothophoma quercina]	diamond	3528	64.7	0.993817619783617	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Didymellaceae	Nothophoma	Nothophoma quercina
28375796	28375796	PRJNA638138_P_NODE_24066_length_248_cov_0.880000_g23851_i0	PRJNA638138	24066	248	0.88	2.1824	Paraphoma chrysanthemicola	798071	Fungi	Fungi	43.1	0.0291	NR	KAH7073529.1	798071	g23851	i0	44.8	0.701612903225806	58	28	65.3	1	173	12	29	86	KAH7073529.1 hypothetical protein BKA63DRAFT_514286 [Paraphoma chrysanthemicola]	diamond	174	43.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Phaeosphaeriaceae	Paraphoma	Paraphoma chrysanthemicola
29070698	29070698	PRJNA638138_P_NODE_20928_length_250_cov_0.870056_g20713_i0	PRJNA638138	20928	250	0.870056	2.17514	Decorospora gaudefroyi	184978	Fungi	Fungi	42.7	0.0358	NR	KAF1838669.1	184978	g20713	i0	36.2	0.828	69	30	76.8	4	16	207	41	100	KAF1838669.1 hypothetical protein BDW02DRAFT_366137 [Decorospora gaudefroyi]	diamond	207	42.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Pleosporaceae	Decorospora	Decorospora gaudefroyi
29512370	29512370	PRJNA638138_P_NODE_21450_length_250_cov_0.870056_g21235_i0	PRJNA638138	21450	250	0.870056	2.17514	Phaeosphaeriaceae sp. SRC1lsM3a	765868	Fungi	Fungi	135	3.93e-38	NR	OAK98368.1	765868	g21235	i0	89.3	1.776	75	8	90	0	2	226	57	131	OAK98368.1 hypothetical protein IQ06DRAFT_188788, partial [Phaeosphaeriaceae sp. SRC1lsM3a]	diamond	444	135	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Phaeosphaeriaceae		Phaeosphaeriaceae sp. SRC1lsM3a
30428937	30428937	PRJNA638138_P_NODE_30233_length_244_cov_0.900585_g30018_i0	PRJNA638138	30233	244	0.900585	2.1974274	Cladosporium halotolerans	1052096	Fungi	Fungi	71.6	2.42e-12	NR	XP_069229203.1	1052096	g30018	i0	94.1	0.418032786885246	34	2	41.8	0	242	141	599	632	XP_069229203.1 uncharacterized protein WHR41_04763 [Cladosporium halotolerans]	diamond	102	71.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
32578907	32578907	PRJNA638138_P_NODE_27639_length_246_cov_0.890173_g27424_i0	PRJNA638138	27639	246	0.890173	2.18982558	Lithohypha guttulata	1690604	Fungi	Fungi	73.9	4.06e-14	NR	KAK5081450.1	1690604	g27424	i0	83.3	0.51219512195122	42	7	51.2	0	1	126	143	184	KAK5081450.1 hypothetical protein LTR24_008204 [Lithohypha guttulata]	diamond	126	73.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Trichomeriaceae	Lithohypha	Lithohypha guttulata
32830663	32830663	PRJNA638138_P_NODE_30760_length_244_cov_0.900585_g30545_i0	PRJNA638138	30760	244	0.900585	2.1974274	Fusarium oxysporum f. sp. albedinis	72712	Fungi	Fungi	43.5	0.00503	NR	KAJ0142965.1	72712	g30545	i0	43.9	0.504098360655738	41	23	50.4	0	41	163	16	56	KAJ0142965.1 Fumonisin B1 esterase [Fusarium oxysporum f. sp. albedinis]	diamond	123	43.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium oxysporum

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