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

5 rows where analysis = "diamond", bioproject = "PRJNA306153" 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
26902160	26902160	PRJNA306153_S_NODE_1761_length_186_cov_4.382166_g1748_i0	PRJNA306153	1761	186	4.382166	8.15082876	Ascomycota	4890	Fungi	Fungi	76.3	1.22e-14	NR	KAA8572530.1	38448	g1748	i0	57.4	13.7741935483871	61	26	98.4	0	185	3	124	184	KAA8572530.1 hypothetical protein EYC84_003140 [Monilinia fructicola]	diamond	2562	76.6	0.996083550913838	Eukaryota	Opisthokonta	Fungi	Ascomycota	Leotiomycetes	Helotiales	Sclerotiniaceae	Monilinia	Monilinia fructicola
29916436	29916436	PRJNA306153_S_NODE_1891_length_180_cov_3.470199_g1878_i0	PRJNA306153	1891	180	3.470199	6.2463582	Ascobolus immersus RN42	1160509	Fungi	Fungi	85.5	5.62e-19	NR	RPA76833.1	1160509	g1878	i0	69.5	0.983333333333333	59	18	98.3	0	2	178	30	88	RPA76833.1 60S ribosomal protein L17 [Ascobolus immersus RN42]	diamond	177	85.5	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Pezizomycetes	Pezizales	Ascobolaceae	Ascobolus	Ascobolus immersus
30769413	30769413	PRJNA306153_S_NODE_1714_length_188_cov_3.698113_g1701_i0	PRJNA306153	1714	188	3.698113	6.95245244	Xylographa carneopallida	1590122	Fungi	Fungi	53.9	2.05e-6	NR	MCJ1296781.1	1590122	g1701	i0	41.2	1.08510638297872	68	31	98.9	3	3	188	792	856	MCJ1296781.1 hypothetical protein [Xylographa carneopallida]	diamond	204	53.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Baeomycetales	Xylographaceae	Xylographa	Xylographa carneopallida
32224055	32224055	PRJNA306153_S_NODE_1918_length_179_cov_3.520000_g1905_i0	PRJNA306153	1918	179	3.52	6.3008	Xylographa carneopallida	1590122	Fungi	Fungi	44.7	0.00335	NR	MCJ1296781.1	1590122	g1905	i0	35.9	1.07262569832402	64	34	95.5	1	177	7	850	913	MCJ1296781.1 hypothetical protein [Xylographa carneopallida]	diamond	192	44.7	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Lecanoromycetes	Baeomycetales	Xylographaceae	Xylographa	Xylographa carneopallida
32666379	32666379	PRJNA306153_S_NODE_1920_length_179_cov_3.313333_g1907_i0	PRJNA306153	1920	179	3.313333	5.93086607	Neolecta irregularis DAH-3	1198029	Fungi	Fungi	89	1.14e-20	NR	OLL26529.1	1198029	g1907	i0	69	1.94413407821229	58	18	97.2	0	6	179	26	83	OLL26529.1 40S ribosomal protein S18 [Neolecta irregularis DAH-3]	diamond	348	89	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Neolectomycetes	Neolectales	Neolectaceae	Neolecta	Neolecta irregularis

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