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

5 rows where analysis = "diamond", bioproject = "PRJEB2333" 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
27696950	27696950	PRJEB2333_P_NODE_3084_length_434_cov_1.352645_g2309_i0	PRJEB2333	3084	434	1.352645	5.8704793	Pichia membranifaciens	4926	Fungi	Fungi	77	7.08e-15	NR	GAV28409.1	4926	g2309	i0	64.3	1.88709677419355	56	20	38.7	0	183	16	76	131	GAV28409.1 60S ribosomal protein [Pichia membranifaciens]	diamond	819	77	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Pichiales	Pichiaceae	Pichia	Pichia membranifaciens
28138887	28138887	PRJEB2333_P_NODE_2585_length_548_cov_1.123288_g1816_i0	PRJEB2333	2585	548	1.123288	6.15561824	Nadsonia fulvescens var. elongata DSM 6958	857566	Fungi	Fungi	110	8.22e-27	NR	ODQ66779.1	857566	g1816	i0	62.7	0.454379562043796	83	30	45.4	1	293	541	77	158	ODQ66779.1 60S ribosomal protein L11-A, partial [Nadsonia fulvescens var. elongata DSM 6958]	diamond	249	110	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dipodascomycetes	Dipodascales		Nadsonia	Nadsonia fulvescens
28732140	28732140	PRJEB2333_P_NODE_2987_length_447_cov_2.239024_g2213_i0	PRJEB2333	2987	447	2.239024	10.00843728	Pichiomycetes	3239874	Fungi	Fungi	99.4	6.559999999999999e-23	NR	ANZ77480.1	4922	g2213	i0	52.4	5.46308724832215	103	38	69.1	1	5	313	63	154	ANZ77480.1 BA75_04938T0 [Komagataella pastoris]	diamond	2442	100	0.994	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Pichiales	Pichiaceae	Komagataella	Komagataella pastoris
31075953	31075953	PRJEB2333_P_NODE_4275_length_171_cov_1.455224_g3498_i0	PRJEB2333	4275	171	1.455224	2.48843304	Xylographa carneopallida	1590122	Fungi	Fungi	79	1.89e-16	NR	MCJ1296998.1	1590122	g3498	i0	62.5	1.96491228070175	56	21	98.2	0	3	170	102	157	MCJ1296998.1 Rho GTPase protein rac1 [Xylographa carneopallida]	diamond	336	79	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Baeomycetales	Xylographaceae	Xylographa	Xylographa carneopallida
32492961	32492961	PRJEB2333_P_NODE_4019_length_186_cov_1.570470_g3242_i0	PRJEB2333	4019	186	1.57047	2.9210742	Ascomycota	4890	Fungi	Fungi	85.1	3.69e-19	NR	XP_069259469.1	28565	g3242	i0	64.5	19.4838709677419	62	22	100	0	186	1	49	110	XP_069259469.1 40S ribosomal protein eS12 [Thermomyces dupontii]	diamond	3624	85.5	0.9953216374269	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Trichocomaceae	Thermomyces	Thermomyces dupontii

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