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

4 rows where analysis = "diamond", bioproject = "PRJEB9859" and tax_phylum = "Basidiomycota"

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
26622737	26622737	PRJEB9859_P_NODE_5421_length_243_cov_1.037383_g5386_i0	PRJEB9859	5421	243	1.037383	2.52084069	Tulasnella sp. JGI-2	1905295	Fungi	Fungi	47.4	5.3e-4	NR	KAG9014962.1	2600232	g5386	i0	64.7	0.888888888888889	34	12	42	0	57	158	159	192	KAG9014962.1 GAL4 enhancer protein [Tulasnella sp. JGI-2019a]	diamond	216	47.4	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Tulasnellaceae		Tulasnella sp. JGI-2019a
28708301	28708301	PRJEB9859_P_NODE_647_length_445_cov_4.882212_g617_i0	PRJEB9859	647	445	4.882212	21.7258434	Tulasnella sp. 417	2600225	Fungi	Fungi	122	9.87e-33	NR	KAG8920536.1	2600225	g617	i0	50.8	0.876404494382023	130	60	84.9	1	420	43	6	135	KAG8920536.1 ribosomal protein S24A [Tulasnella sp. 417]	diamond	390	122	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Tulasnellaceae	Tulasnella	Tulasnella sp. 417
31804201	31804201	PRJEB9859_P_NODE_1797_length_330_cov_2.740864_g1762_i0	PRJEB9859	1797	330	2.740864	9.0448512	Psilocybe cyanescens	93625	Fungi	Fungi	152	1.28e-41	NR	PPQ90753.1	93625	g1762	i0	79.6	5.02727272727273	93	19	84.5	0	318	40	359	451	PPQ90753.1 hypothetical protein CVT25_010142 [Psilocybe cyanescens]	diamond	1659	152	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Strophariaceae	Psilocybe	Psilocybe cyanescens
32374015	32374015	PRJEB9859_P_NODE_4659_length_248_cov_1.013699_g4624_i0	PRJEB9859	4659	248	1.013699	2.51397352	Mycena chlorophos	658473	Fungi	Fungi	94.7	1.48e-20	NR	GAT44749.1	658473	g4624	i0	75.8	3.09677419354839	62	15	75	0	213	28	391	452	GAT44749.1 aryl-alcohol oxidase-like protein [Mycena chlorophos]	diamond	768	94.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Agaricales	Mycenaceae	Mycena	Mycena chlorophos

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