metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1193541" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1193541" 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
320604	320604	PRJNA1193541_P_NODE_11261_length_262_cov_1.386243_g11123_i0	PRJNA1193541	11261	262	1.386243	3.63195666	Hypocreales	5125	Fungi	Fungi	149	1.3899999999999996e-42	NR	KAK0392783.1	5046	g11123	i0	82.8	9.9618320610687	87	15	99.6	0	2	262	171	257	KAK0392783.1 hypothetical protein NLU13_2278 [Sarocladium strictum]	diamond	2610	149	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Sarocladiaceae	Sarocladium	Sarocladium strictum
23272737	23272737	PRJNA1193541_P_NODE_11659_length_256_cov_1.573770_g11521_i0	PRJNA1193541	11659	256	1.57377	4.0288512	Microdochium bolleyi	196109	Fungi	Fungi	147	5.37e-39	NR	KXJ87112.1	196109	g11521	i0	94.8	1.8046875	77	4	90.2	0	25	255	245	321	KXJ87112.1 male sterility protein [Microdochium bolleyi]	diamond	462	147	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Xylariales	Microdochiaceae	Microdochium	Microdochium bolleyi
31589544	31589544	PRJNA1193541_P_NODE_13596_length_246_cov_0.890173_g13458_i0	PRJNA1193541	13596	246	0.890173	2.18982558	Fusarium proliferatum	948311	Fungi	Fungi	91.7	2.85e-20	NR	ABS29332.1	948311	g13458	i0	61.3	1.82926829268293	75	29	91.5	0	3	227	140	214	ABS29332.1 DNA polymerase, partial [Fusarium proliferatum]	diamond	450	91.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium proliferatum
32063791	32063791	PRJNA1193541_P_NODE_11378_length_260_cov_1.812834_g11240_i0	PRJNA1193541	11378	260	1.812834	4.7133684	Westerdykella ornata	318751	Fungi	Fungi	43.5	0.0242	NR	XP_033656339.1	318751	g11240	i0	30.7	0.865384615384615	75	43	86.5	1	15	239	441	506	XP_033656339.1 rhomboid-domain-containing protein [Westerdykella ornata]	diamond	225	43.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Sporormiaceae	Westerdykella	Westerdykella ornata
32759029	32759029	PRJNA1193541_P_NODE_14240_length_244_cov_0.900585_g14102_i0	PRJNA1193541	14240	244	0.900585	2.1974274	Golovinomyces cichoracearum	62708	Fungi	Fungi	133	3.78e-37	NR	RKF56651.1	62708	g14102	i0	97.1	0.848360655737705	69	2	84.8	0	2	208	123	191	RKF56651.1 hypothetical protein GcM3_194009 [Golovinomyces cichoracearum]	diamond	207	133	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Erysiphales	Erysiphaceae	Golovinomyces	Golovinomyces cichoracearum

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