metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA635397" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA635397" and tax_clade = "Haptista"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
18457712	18457712	PRJNA635397_P_NODE_23135_length_333_cov_1.450000_g22681_i0	PRJNA635397	23135	333	1.45	4.8285	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	169	3.13e-49	NR	KOO23867.1	1460289	g22681	i0	68.5	4	111	35	100	0	333	1	136	246	KOO23867.1 alteRNAtive oxidase [Chrysochromulina tobinii]	diamond	1332	169	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
26796166	26796166	PRJNA635397_P_NODE_21941_length_343_cov_1.466667_g21487_i0	PRJNA635397	21941	343	1.466667	5.03066781	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	79.3	1.68e-14	NR	KAL1502925.1	97485	g21487	i0	35.6	1.03206997084548	118	60	92.7	3	24	341	165	278	KAL1502925.1 hypothetical protein AB1Y20_010997 [Prymnesium parvum]	diamond	354	79.3	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
26954194	26954194	PRJNA635397_P_NODE_21602_length_346_cov_1.216117_g21148_i0	PRJNA635397	21602	346	1.216117	4.20776482	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	43.9	0.0286	NR	KAL1493535.1	97485	g21148	i0	35.4	0.684971098265896	79	31	51.2	3	157	333	9	87	KAL1493535.1 hypothetical protein AB1Y20_017238 [Prymnesium parvum]	diamond	237	43.9	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
27302324	27302324	PRJNA635397_P_NODE_45543_length_243_cov_1.347059_g45089_i0	PRJNA635397	45543	243	1.347059	3.27335337	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	50.8	5.13e-5	NR	KAG8465884.1	2081491	g45089	i0	40	0.987654320987654	80	39	87.7	3	216	4	52	131	KAG8465884.1 hypothetical protein KFE25_005454 [Diacronema lutheri]	diamond	240	50.8	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
27346502	27346502	PRJNA635397_P_NODE_11343_length_511_cov_1.205479_g10890_i0	PRJNA635397	11343	511	1.205479	6.15999769	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	283	2.1199999999999993e-90	NR	KAL1495187.1	97485	g10890	i0	76.5	11.9706457925636	183	29	99.2	1	3	509	357	539	KAL1495187.1 hypothetical protein AB1Y20_017052 [Prymnesium parvum]	diamond	6117	285	0.992982456140351	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
28830220	28830220	PRJNA635397_P_NODE_47108_length_238_cov_3.454545_g46654_i0	PRJNA635397	47108	238	3.454545	8.2218171	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	97.1	2.64e-21	NR	KOO24782.1	1460289	g46654	i0	60.8	4.02100840336134	79	29	99.6	1	2	238	441	517	KOO24782.1 tripeptidyl peptidase i [Chrysochromulina tobinii]	diamond	957	97.1	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
29891550	29891550	PRJNA635397_P_NODE_23091_length_333_cov_2.442308_g22637_i0	PRJNA635397	23091	333	2.442308	8.13288564	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	93.2	6.58e-22	NR	XP_005782836.1	280463	g22637	i0	51	7.34234234234234	102	46	91	2	318	16	16	114	XP_005782836.1 hypothetical protein EMIHUDRAFT_442529 [Emiliania huxleyi CCMP1516]	diamond	2445	93.2	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
32148340	32148340	PRJNA635397_P_NODE_33198_length_275_cov_1.524752_g32744_i0	PRJNA635397	33198	275	1.524752	4.193068	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	89.7	1.6e-18	NR	KAJ1616776.1	483367	g32744	i0	75.9	4.15636363636364	58	14	63.3	0	102	275	12	69	KAJ1616776.1 chaperonin Cpn60/TCP-1 family [Pavlovales sp. CCMP2436]	diamond	1143	90.5	0.991160220994475	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
32262600	32262600	PRJNA635397_P_NODE_29398_length_293_cov_1.822727_g28944_i0	PRJNA635397	29398	293	1.822727	5.34059011	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	48.5	2.3e-4	NR	XP_005793372.1	280463	g28944	i0	57.4	1.24914675767918	61	24	62.5	1	46	228	1	59	XP_005793372.1 hypothetical protein EMIHUDRAFT_125495, partial [Emiliania huxleyi CCMP1516]	diamond	366	48.5	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi

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