metadata: contig_metadata: 4 rows where analysis = "diamond", bioproject = "PRJEB25789" and tax

4 rows where analysis = "diamond", bioproject = "PRJEB25789" 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
26684846	26684846	PRJEB25789_S_NODE_15941_length_255_cov_1.269231_g15862_i0	PRJEB25789	15941	255	1.269231	3.23653905	Babjeviella inositovora NRRL Y-12698	984486	Fungi	Fungi	79.7	3.23e-17	NR	XP_018988354.1	984486	g15862	i0	58.8	8.02352941176471	68	28	80	0	253	50	30	97	XP_018988354.1 uncharacterized protein BABINDRAFT_170095 [Babjeviella inositovora NRRL Y-12698]	diamond	2046	79.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pichiomycetes	Serinales		Babjeviella	Babjeviella inositovora
29584315	29584315	PRJEB25789_S_NODE_11450_length_290_cov_1.419355_g11371_i0	PRJEB25789	11450	290	1.419355	4.1161295	Lecanoromycetes	147547	Fungi	Fungi	47.8	0.00107	NR	KAG7007676.1	116821	g11371	i0	33.3	1.37586206896552	96	49	87.9	4	21	275	246	337	KAG7007676.1 hypothetical protein G7Y79_00008g023140 [Physcia stellaris]	diamond	399	47.8	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Caliciales	Physciaceae	Physcia	Physcia stellaris
32056238	32056238	PRJEB25789_S_NODE_9218_length_314_cov_4.941909_g9139_i0	PRJEB25789	9218	314	4.941909	15.51759426	Zygosaccharomyces bailii ISA13	4954	Fungi	Fungi	61.6	1.09e-9	NR	CDH16361.1	1355161	g9139	i0	51.4	2.00636942675159	70	24	66.9	1	313	104	7	66	CDH16361.1 probable protein TAR1 [Zygosaccharomyces bailii ISA1307]	diamond	630	61.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Saccharomycetes	Saccharomycetales	Saccharomycetaceae	Zygosaccharomyces	Zygosaccharomyces bailii
32492963	32492963	PRJEB25789_S_NODE_13879_length_269_cov_1.571429_g13800_i0	PRJEB25789	13879	269	1.571429	4.22714401	Eukaryota	2759	Fungi	Fungi	116	1.3e-28	NR	XP_054120508.1	37727	g13800	i0	62.1	5.79925650557621	87	33	97	0	1	261	290	376	XP_054120508.1 uncharacterized protein EYB26_005243 [Talaromyces marneffei]	diamond	1560	117	0.991452991452991	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Trichocomaceae	Talaromyces	Talaromyces marneffei

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