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

5 rows where analysis = "diamond", bioproject = "PRJNA1242190" 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
23303304	23303304	PRJNA1242190_S_NODE_4119_length_396_cov_2.839009_g4112_i0	PRJNA1242190	4119	396	2.839009	11.24247564	Eukaryota	2759	Fungi	Fungi	125	9.03e-34	NR	CEQ40310.1	5005	g4112	i0	81.2	17.75	69	13	52.3	0	394	188	78	146	CEQ40310.1 SPOSA6832_01923 [Sporobolomyces salmonicolor]	diamond	7029	126	0.992063492063492	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Sporobolomyces	Sporobolomyces salmonicolor
26883902	26883902	PRJNA1242190_S_NODE_10461_length_267_cov_1.840206_g10454_i0	PRJNA1242190	10461	267	1.840206	4.91335002	Malassezia brasiliensis	1821822	Fungi	Fungi	47	0.00163	NR	WFC95400.1	1821822	g10454	i0	37.3	0.662921348314607	59	36	65.2	1	2	175	1406	1464	WFC95400.1 phosphoinositide 5-phosphatase [Malassezia brasiliensis]	diamond	177	47	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia brasiliensis
27547510	27547510	PRJNA1242190_S_NODE_7764_length_305_cov_2.887931_g7757_i0	PRJNA1242190	7764	305	2.887931	8.80818955	Tilletiopsis washingtonensis	58919	Fungi	Fungi	44.7	0.0151	NR	XP_025595858.1	58919	g7757	i0	49.2	0.580327868852459	59	27	55.1	2	301	134	306	364	XP_025595858.1 hypothetical protein FA09DRAFT_335231 [Tilletiopsis washingtonensis]	diamond	177	44.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Exobasidiomycetes	Entylomatales		Tilletiopsis	Tilletiopsis washingtonensis
29189534	29189534	PRJNA1242190_S_NODE_3249_length_434_cov_5.603878_g3242_i0	PRJNA1242190	3249	434	5.603878	24.32083052	Tulasnella sp. 417	2600225	Fungi	Fungi	123	4.25e-33	NR	KAG8920536.1	2600225	g3242	i0	50.8	0.898617511520737	130	60	87.1	1	5	382	6	135	KAG8920536.1 ribosomal protein S24A [Tulasnella sp. 417]	diamond	390	123	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Tulasnellaceae	Tulasnella	Tulasnella sp. 417
32350040	32350040	PRJNA1242190_S_NODE_2359_length_481_cov_3.995098_g2352_i0	PRJNA1242190	2359	481	3.995098	19.21642138	Tulasnella sp. 417	2600225	Fungi	Fungi	110	1e-27	NR	KAG8920536.1	2600225	g2352	i0	47.5	2.20790020790021	122	64	76.1	0	476	111	6	127	KAG8920536.1 ribosomal protein S24A [Tulasnella sp. 417]	diamond	1062	110	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Tulasnellaceae	Tulasnella	Tulasnella sp. 417

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