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

4 rows where analysis = "diamond", bioproject = "PRJNA287283" 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
29663197	29663197	PRJNA287283_P_NODE_10390_length_175_cov_0.918033_g10166_i0	PRJNA287283	10390	175	0.918033	1.60655775	Epicoccum nigrum	105696	Fungi	Fungi	66.2	7.75e-11	NR	KAG9196832.1	105696	g10166	i0	56.1	1.95428571428571	57	25	97.7	0	174	4	822	878	KAG9196832.1 hypothetical protein G6514_003939 [Epicoccum nigrum]	diamond	342	66.2	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Didymellaceae	Epicoccum	Epicoccum nigrum
30074010	30074010	PRJNA287283_P_NODE_8572_length_183_cov_0.861538_g8348_i0	PRJNA287283	8572	183	0.861538	1.57661454	Penicillium macrosclerotiorum	303699	Fungi	Fungi	43.9	0.00144	NR	XP_056932175.1	303699	g8348	i0	43.6	1.68852459016393	55	25	90.2	1	182	18	13	61	XP_056932175.1 uncharacterized protein N7462_007787 [Penicillium macrosclerotiorum]	diamond	309	43.9	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Eurotiomycetes	Eurotiales	Aspergillaceae	Penicillium	Penicillium macrosclerotiorum
30218104	30218104	PRJNA287283_P_NODE_10412_length_175_cov_0.918033_g10188_i0	PRJNA287283	10412	175	0.918033	1.60655775	Cordycipitaceae	474943	Fungi	Fungi	56.6	1.57e-7	NR	KAJ6782909.1	12942	g10188	i0	73.5	4.04571428571429	34	9	58.3	0	37	138	245	278	KAJ6782909.1 hypothetical protein PWT90_04898 [Aphanocladium album]	diamond	708	56.6	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Sordariomycetes	Hypocreales		Aphanocladium	Aphanocladium album
32823811	32823811	PRJNA287283_P_NODE_5980_length_237_cov_0.847826_g5756_i0	PRJNA287283	5980	237	0.847826	2.00934762	Polyplosphaeria fusca	682080	Fungi	Fungi	45.1	0.0033	NR	KAF2736442.1	682080	g5756	i0	52.9	0.645569620253165	51	19	64.6	2	61	213	121	166	KAF2736442.1 hypothetical protein EJ04DRAFT_159750 [Polyplosphaeria fusca]	diamond	153	45.1	1	Eukaryota	Opisthokonta	Fungi	Ascomycota	Dothideomycetes	Pleosporales	Tetraplosphaeriaceae	Polyplosphaeria	Polyplosphaeria fusca

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