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

5 rows where analysis = "diamond", bioproject = "PRJNA451191" 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
28529007	28529007	PRJNA451191_P_NODE_33907_length_244_cov_2.371585_g33636_i0	PRJNA451191	33907	244	2.371585	5.7866674	Stachybotrys chartarum IBT 4	74722	Fungi	Fungi	42.7	0.0373	NR	KFA56331.1	1280524	g33636	i0	37.5	0.491803278688525	40	25	49.2	0	134	15	140	179	KFA56331.1 hypothetical protein S40293_09250 [Stachybotrys chartarum IBT 40293]	diamond	120	42.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Stachybotryaceae	Stachybotrys	Stachybotrys chartarum
28529013	28529013	PRJNA451191_P_NODE_53047_length_204_cov_0.909091_g52776_i0	PRJNA451191	53047	204	0.909091	1.85454564	Hapsidospora chrysogenum ATCC 1155	5044	Fungi	Fungi	76.3	6.2e-15	NR	KFH43794.1	857340	g52776	i0	60	1.02941176470588	70	26	100	1	1	204	151	220	KFH43794.1 hypothetical protein ACRE_054370 [Hapsidospora chrysogenum ATCC 11550]	diamond	210	76.3	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Bionectriaceae	Hapsidospora	Hapsidospora chrysogena
31577772	31577772	PRJNA451191_P_NODE_21416_length_309_cov_3.895161_g21145_i0	PRJNA451191	21416	309	3.895161	12.03604749	Saccharomyces	4930	Fungi	Fungi	64.7	1.7e-10	NR	KAF4001137.1	4932	g21145	i0	53.7	3.20388349514563	67	21	65	1	308	108	51	107	KAF4001137.1 Protein TAR1 domain protein [Saccharomyces cerevisiae]	diamond	990	64.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Saccharomyces	Saccharomyces cerevisiae
31593276	31593276	PRJNA451191_P_NODE_28196_length_268_cov_1.130435_g27925_i0	PRJNA451191	28196	268	1.130435	3.0295658	Flavoplaca oasis	1301336	Fungi	Fungi	43.5	0.0222	NR	KAI4275426.1	1301336	g27925	i0	34.9	0.705223880597015	63	33	70.5	2	23	211	48	102	KAI4275426.1 MAG: hypothetical protein LQ337_003225 [Flavoplaca oasis]	diamond	189	43.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Teloschistales	Teloschistaceae	Flavoplaca	Flavoplaca oasis
31846000	31846000	PRJNA451191_P_NODE_11937_length_430_cov_3.704607_g11666_i0	PRJNA451191	11937	430	3.704607	15.9298101	Fusarium flagelliforme	2675880	Fungi	Fungi	44.7	0.0433	NR	XP_045977701.1	2675880	g11666	i0	32.1	0.390697674418605	56	38	39.1	0	82	249	45	100	XP_045977701.1 uncharacterized protein B0J16DRAFT_389244 [Fusarium flagelliforme]	diamond	168	44.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales	Nectriaceae	Fusarium	Fusarium flagelliforme

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