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

7 rows where analysis = "diamond", bioproject = "PRJNA547066" 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
3062473	3062473	PRJNA547066_P_NODE_3443_length_232_cov_0.934010_g3349_i0	PRJNA547066	3443	232	0.93401	2.1669032	Cladosporium halotolerans	1052096	Fungi	Fungi	147	2.99e-39	NR	XP_069232030.1	1052096	g3349	i0	85.7	0.995689655172414	77	10	99.6	1	1	231	547	622	XP_069232030.1 uncharacterized protein WHR41_02586 [Cladosporium halotolerans]	diamond	231	147	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Cladosporiales	Cladosporiaceae	Cladosporium	Cladosporium halotolerans
3062481	3062481	PRJNA547066_P_NODE_4463_length_187_cov_1.210526_g4369_i0	PRJNA547066	4463	187	1.210526	2.26368362	Golovinomyces	184027	Fungi	Fungi	117	2.74e-31	NR	RKF54661.1	62708	g4369	i0	98.4	2.93582887700535	61	1	97.9	0	3	185	85	145	RKF54661.1 Growth hormone-inducible transmembrane protein [Golovinomyces cichoracearum]	diamond	549	117	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Erysiphales	Erysiphaceae	Golovinomyces	Golovinomyces cichoracearum
26617926	26617926	PRJNA547066_P_NODE_2681_length_282_cov_1.943320_g2587_i0	PRJNA547066	2681	282	1.94332	5.4801624	Xylariaceae	37990	Fungi	Fungi	94.7	6.83e-22	NR	GAP82703.2	77044	g2587	i0	71.9	4.59574468085106	64	18	68.1	0	89	280	57	120	GAP82703.2 hypothetical protein SAMD00023353_0102390 [Rosellinia necatrix]	diamond	1296	95.5	0.991623036649215	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Xylariales	Xylariaceae	Rosellinia	Rosellinia necatrix
27741633	27741633	PRJNA547066_P_NODE_2924_length_263_cov_1.570175_g2830_i0	PRJNA547066	2924	263	1.570175	4.12956025	Golovinomyces cichoracearum	62708	Fungi	Fungi	167	6.18e-50	NR	RKF65428.1	62708	g2830	i0	95.4	0.992395437262357	87	4	99.2	0	261	1	29	115	RKF65428.1 Vesicle-associated membrane protein 713 [Golovinomyces cichoracearum]	diamond	261	167	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Erysiphales	Erysiphaceae	Golovinomyces	Golovinomyces cichoracearum
27835908	27835908	PRJNA547066_P_NODE_1824_length_362_cov_1.079511_g1731_i0	PRJNA547066	1824	362	1.079511	3.90782982	Podosphaera aphanis	79252	Fungi	Fungi	48.1	0.00174	NR	KAI0996512.1	79252	g1731	i0	52.1	0.795580110497238	48	23	39.8	0	188	331	413	460	KAI0996512.1 hypothetical protein K3495_g11669 [Podosphaera aphanis]	diamond	288	48.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Erysiphales	Erysiphaceae	Podosphaera	Podosphaera aphanis
28261145	28261145	PRJNA547066_P_NODE_5026_length_172_cov_1.459854_g4932_i0	PRJNA547066	5026	172	1.459854	2.51094888	Dothideomycetes	147541	Fungi	Fungi	109	3.38e-26	NR	TLD06765.1	86259	g4932	i0	87.5	1.95348837209302	56	7	97.7	0	170	3	231	286	TLD06765.1 hypothetical protein E2P81_ATG10374 [Venturia nashicola]	diamond	336	109	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Venturiales	Venturiaceae	Venturia	Venturia nashicola
31862603	31862603	PRJNA547066_P_NODE_817_length_545_cov_1.515686_g729_i0	PRJNA547066	817	545	1.515686	8.2604887	Trichomeriaceae	1233474	Fungi	Fungi	162	2.2e-42	NR	XP_064725646.1	1635080	g729	i0	86	1.53577981651376	93	13	51.2	0	279	1	659	751	XP_064725646.1 chitin synthase I [Knufia obscura]	diamond	837	162	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Chaetothyriales	Trichomeriaceae	Knufia	Knufia obscura

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