metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJNA951412" and tax

6 rows where analysis = "diamond", bioproject = "PRJNA951412" and tax_phylum = "Mucoromycota"

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
22611822	22611822	PRJNA951412_P_NODE_418_length_742_cov_2.913303_g336_i0	PRJNA951412	418	742	2.913303	21.61670826	Fungi	4751	Fungi	Fungi	150	7.75e-39	NR	KAG9326980.1	64518	g336	i0	68.2	8.42587601078167	110	35	44.5	0	9	338	1	110	KAG9326980.1 hypothetical protein KVV02_001930 [Mortierella alpina]	diamond	6252	151	0.993377483443709	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Mortierella	Mortierella alpina
27151580	27151580	PRJNA951412_P_NODE_4502_length_251_cov_0.876404_g4417_i0	PRJNA951412	4502	251	0.876404	2.19977404	Mortierella alpina	64518	Fungi	Fungi	75.5	6.74e-15	NR	KAF9942912.1	64518	g4417	i0	64.3	0.669322709163347	56	20	66.9	0	82	249	2	57	KAF9942912.1 glutathione peroxidase gpx1 [Mortierella alpina]	diamond	168	75.5	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Mortierella	Mortierella alpina
27594436	27594436	PRJNA951412_P_NODE_944_length_468_cov_1.592405_g859_i0	PRJNA951412	944	468	1.592405	7.4524554	Mortierella sp. GBA35	1896188	Fungi	Fungi	65.1	6.17e-9	NR	KAF9102027.1	1896188	g859	i0	40.5	7.75641025641026	111	57	66.7	5	4	315	392	500	KAF9102027.1 hypothetical protein BGX29_005016 [Mortierella sp. GBA35]	diamond	3630	65.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mortierellomycetes	Mortierellales	Mortierellaceae	Mortierella	Mortierella sp. GBA35
29022044	29022044	PRJNA951412_P_NODE_5388_length_249_cov_0.875000_g5303_i0	PRJNA951412	5388	249	0.875	2.17875	Opisthokonta	33154	Fungi	Fungi	45.1	0.00558	NR	KAI9027232.1	269771	g5303	i0	52.4	0.867469879518072	42	19	50.6	1	2	127	157	197	KAI9027232.1 hypothetical protein CLU79DRAFT_698043 [Phycomyces nitens]	diamond	216	45.1	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Phycomycetaceae	Phycomyces	Phycomyces nitens
29204768	29204768	PRJNA951412_P_NODE_3129_length_277_cov_2.274510_g3044_i0	PRJNA951412	3129	277	2.27451	6.3003927	Bifiguratus adelaidae	1938954	Fungi	Fungi	63.9	1.74e-9	NR	OZJ05900.1	1938954	g3044	i0	53.5	2.87003610108303	71	29	75.8	2	277	68	41	108	OZJ05900.1 hypothetical protein BZG36_01178 [Bifiguratus adelaidae]	diamond	795	63.9	1	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Endogonomycetes	Endogonales		Bifiguratus	Bifiguratus adelaidae
31200749	31200749	PRJNA951412_P_NODE_6255_length_246_cov_0.901734_g6170_i0	PRJNA951412	6255	246	0.901734	2.21826564	Eukaryota	2759	Fungi	Fungi	101	5.0099999999999997e-23	NR	ORY99023.1	13706	g6170	i0	63	6.89024390243902	81	28	96.3	2	3	239	244	324	ORY99023.1 chaperonin 10-like protein [Syncephalastrum racemosum]	diamond	1695	102	0.990196078431373	Eukaryota	Opisthokonta	Fungi	Mucoromycota	Mucoromycetes	Mucorales	Syncephalastraceae	Syncephalastrum	Syncephalastrum racemosum

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