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

10 rows where analysis = "diamond", bioproject = "PRJNA401346" 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
5517958	5517958	PRJNA401346_P_NODE_3165_length_290_cov_1.803493_g3144_i0	PRJNA401346	3165	290	1.803493	5.2301297	Fungi	4751	Fungi	Fungi	139	1.1399999999999999e-40	NR	XP_002143100.1	4952	g3144	i0	78	10.0551724137931	82	18	84.8	0	269	24	1	82	XP_002143100.1 40S ribosomal protein eS27 [Yarrowia lipolytica]	diamond	2916	139	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dipodascomycetes	Dipodascales		Yarrowia	Yarrowia lipolytica
7459027	7459027	PRJNA401346_P_NODE_6286_length_209_cov_0.864865_g6265_i0	PRJNA401346	6286	209	0.864865	1.80756785	Eukaryota	2759	Fungi	Fungi	78.6	5.72e-15	NR	NP_593482.1	4896	g6265	i0	54.5	8.6555023923445	55	25	78.9	0	198	34	127	181	NP_593482.1 exonuclease II Exo2 [Schizosaccharomyces pombe]	diamond	1809	78.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Schizosaccharomycetes	Schizosaccharomycetales	Schizosaccharomycetaceae	Schizosaccharomyces	Schizosaccharomyces pombe
17658647	17658647	PRJNA401346_P_NODE_6394_length_209_cov_0.864865_g6373_i0	PRJNA401346	6394	209	0.864865	1.80756785	Pleosporales	92860	Fungi	Fungi	135	7.239999999999998e-35	NR	XP_043165507.1	119953	g6373	i0	98.5	13.1052631578947	66	1	94.7	0	199	2	660	725	XP_043165507.1 uncharacterized protein ALTATR162_LOCUS1970 [Alternaria atra]	diamond	2739	135	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Pleosporaceae	Alternaria	Alternaria atra
27281884	27281884	PRJNA401346_P_NODE_6083_length_212_cov_1.271523_g6062_i0	PRJNA401346	6083	212	1.271523	2.69562876	Eukaryota	2759	Fungi	Fungi	95.5	7.1e-23	NR	KAG9542518.1	46634	g6062	i0	68.8	53.6462264150943	64	20	90.6	0	203	12	4	67	KAG9542518.1 ras-related protein-like protein, partial [Aureobasidium melanogenum]	diamond	11373	95.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Dothideales	Saccotheciaceae	Aureobasidium	Aureobasidium melanogenum
27675917	27675917	PRJNA401346_P_NODE_4584_length_249_cov_1.111702_g4563_i0	PRJNA401346	4584	249	1.111702	2.76813798	Lizonia empirigonia	1496277	Fungi	Fungi	158	8.05e-48	NR	KAF1365574.1	1496277	g4563	i0	85.5	1	83	12	100	0	1	249	44	126	KAF1365574.1 Aegerolysin family protein [Lizonia empirigonia]	diamond	249	158	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes		Pseudoperisporiaceae	Lizonia	Lizonia empirigonia
28734377	28734377	PRJNA401346_P_NODE_7587_length_205_cov_0.888889_g7566_i0	PRJNA401346	7587	205	0.888889	1.82222245	Eukaryota	2759	Fungi	Fungi	99.8	6.019999999999999e-23	NR	KAA8571655.1	38448	g7566	i0	76.5	26.8682926829268	68	16	99.5	0	1	204	190	257	KAA8571655.1 hypothetical protein EYC84_001646 [Monilinia fructicola]	diamond	5508	100	0.998	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Sclerotiniaceae	Monilinia	Monilinia fructicola
28780585	28780585	PRJNA401346_P_NODE_2667_length_310_cov_1.285141_g2646_i0	PRJNA401346	2667	310	1.285141	3.9839371	Lizonia empirigonia	1496277	Fungi	Fungi	162	2.73e-49	NR	KAF1365574.1	1496277	g2646	i0	78.1	0.929032258064516	96	21	92.9	0	309	22	40	135	KAF1365574.1 Aegerolysin family protein [Lizonia empirigonia]	diamond	288	162	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes		Pseudoperisporiaceae	Lizonia	Lizonia empirigonia
28906827	28906827	PRJNA401346_P_NODE_8508_length_202_cov_0.907801_g8487_i0	PRJNA401346	8508	202	0.907801	1.83375802	Erysiphe pulchra	225359	Fungi	Fungi	92.4	7.05e-20	NR	POS85527.1	225359	g8487	i0	86.7	0.668316831683168	45	6	66.8	0	201	67	1659	1703	POS85527.1 hypothetical protein EPUL_003889 [Erysiphe pulchra]	diamond	135	92.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Erysiphales	Erysiphaceae	Erysiphe	Erysiphe pulchra
29632858	29632858	PRJNA401346_P_NODE_8050_length_203_cov_0.901408_g8029_i0	PRJNA401346	8050	203	0.901408	1.82985824	Erysiphe necator	52586	Fungi	Fungi	124	1.09e-32	NR	KAI6245205.1	52586	g8029	i0	94	0.990147783251232	67	4	99	0	201	1	194	260	KAI6245205.1 Mitochondrial phosphate carrier protein [Erysiphe necator]	diamond	201	124	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Erysiphales	Erysiphaceae	Erysiphe	Erysiphe necator
31103083	31103083	PRJNA401346_P_NODE_8275_length_203_cov_0.894366_g8254_i0	PRJNA401346	8275	203	0.894366	1.81556298	Fusarium	5506	Fungi	Fungi	42.4	0.0305	NR	KAF5687264.1	48490	g8254	i0	38.3	1.38916256157635	47	24	62.1	1	62	187	238	284	KAF5687264.1 e3 ubiquitin ligase ARI4 [Fusarium circinatum]	diamond	282	42.4	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium circinatum

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