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

5 rows where analysis = "diamond", bioproject = "PRJNA801875" 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
29147643	29147643	PRJNA801875_P_NODE_4409_length_156_cov_0.966942_g4306_i0	PRJNA801875	4409	156	0.966942	1.50842952	Tulasnella	5240	Fungi	Fungi	62.4	6.05e-10	NR	KAG8926890.1	2600224	g4306	i0	65.1	1.65384615384615	43	15	82.7	0	8	136	79	121	KAG8926890.1 hypothetical protein FRC00_002469 [Tulasnella sp. 408]	diamond	258	62.8	0.993630573248408	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Cantharellales	Tulasnellaceae	Tulasnella	Tulasnella sp. 408
29233251	29233251	PRJNA801875_P_NODE_2889_length_197_cov_1.827160_g2786_i0	PRJNA801875	2889	197	1.82716	3.5995052	Malassezia arunalokei	1514897	Fungi	Fungi	115	5.02e-28	NR	WFD16437.1	1514897	g2786	i0	96.9	0.989847715736041	65	2	99	0	1	195	2659	2723	WFD16437.1 hypothetical protein MARU1_002474 [Malassezia arunalokei]	diamond	195	115	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Malasseziomycetes	Malasseziales	Malasseziaceae	Malassezia	Malassezia arunalokei
30947901	30947901	PRJNA801875_P_NODE_3894_length_166_cov_1.213740_g3791_i0	PRJNA801875	3894	166	1.21374	2.0148084	Russulales	452342	Fungi	Fungi	47.8	2.18e-4	NR	XP_007299727.1	721885	g3791	i0	52.1	3.28915662650602	48	21	86.7	1	146	3	33	78	XP_007299727.1 uncharacterized protein STEHIDRAFT_118066 [Stereum hirsutum FP-91666 SS1]	diamond	546	47.8	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Stereaceae	Stereum	Stereum hirsutum
32086162	32086162	PRJNA801875_P_NODE_3538_length_174_cov_1.992806_g3435_i0	PRJNA801875	3538	174	1.992806	3.46748244	Opisthokonta	33154	Fungi	Fungi	63.5	1.69e-10	NR	GJN88215.1	86838	g3435	i0	43.9	1.96551724137931	57	32	98.3	0	174	4	74	130	GJN88215.1 hypothetical protein Rhopal_001180-T1 [Rhodotorula paludigena]	diamond	342	63.5	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Microbotryomycetes	Sporidiobolales	Sporidiobolaceae	Rhodotorula	Rhodotorula paludigena
32686622	32686622	PRJNA801875_P_NODE_1900_length_268_cov_2.935622_g1797_i0	PRJNA801875	1900	268	2.935622	7.86746696	Cryptococcus	5206	Fungi	Fungi	61.6	1.16e-8	NR	WVO14878.1	5208	g1797	i0	38.5	2.01492537313433	91	49	97.4	3	4	264	44	131	WVO14878.1 hypothetical protein L204_102517 [Cryptococcus depauperatus]	diamond	540	62	0.993548387096774	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Tremellomycetes	Tremellales	Cryptococcaceae	Cryptococcus	Cryptococcus depauperatus

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