metadata: contig_metadata: 8 rows where bioproject = "PRJNA492406" and tax

8 rows where bioproject = "PRJNA492406" and tax_phylum = "Haptophyta"

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
1726943	1726943	PRJNA492406_P_NODE_11062_length_372_cov_2.872910_g10763_i0	PRJNA492406	11062	372	2.87291	10.6872252	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	122	5.43e-33	NR	XP_005765065.1	280463	g10763	i0	57.1	0.959677419354839	119	46	96	2	357	1	2	115	XP_005765065.1 hypothetical protein EMIHUDRAFT_416466 [Emiliania huxleyi CCMP1516]	diamond	357	122	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
26855148	26855148	PRJNA492406_P_NODE_14501_length_329_cov_1.656250_g14202_i0	PRJNA492406	14501	329	1.65625	5.4490625	Pavlovales sp. CCMP2436	483367	Haptophyta	other_Eukaryota	142	4.799999999999998e-41	NR	KAJ1638552.1	483367	g14202	i0	73.2	3.62917933130699	97	26	88.4	0	37	327	10	106	KAJ1638552.1 transcription factor [Pavlovales sp. CCMP2436]	diamond	1194	142	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
28560866	28560866	PRJNA492406_P_NODE_24287_length_262_cov_1.365079_g23988_i0	PRJNA492406	24287	262	1.365079	3.57650698	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	47.4	8.75e-4	NR	KOO26516.1	1460289	g23988	i0	34.5	0.961832061068702	84	54	95	1	249	1	21	104	KOO26516.1 hypothetical protein Ctob_003635 [Chrysochromulina tobinii]	diamond	252	47.4	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
28734639	28734639	PRJNA492406_P_NODE_18967_length_288_cov_1.381395_g18668_i0	PRJNA492406	18967	288	1.381395	3.9784176	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	62	1.12e-8	NR	KAG8459797.1	2081491	g18668	i0	53.7	5.20833333333333	67	30	69.8	1	287	87	4440	4505	KAG8459797.1 hypothetical protein KFE25_014360 [Diacronema lutheri]	diamond	1500	62.4	0.993589743589744	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
29902981	29902981	PRJNA492406_P_NODE_24211_length_262_cov_1.873016_g23912_i0	PRJNA492406	24211	262	1.873016	4.90730192	Prymnesiales	73028	Haptophyta	other_Eukaryota	124	7.4299999999999995e-31	NR	KAL1512226.1	97485	g23912	i0	67.8	1.99236641221374	87	28	99.6	0	261	1	4774	4860	KAL1512226.1 hypothetical protein AB1Y20_005488 [Prymnesium parvum]	diamond	522	124	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
31340360	31340360	PRJNA492406_P_NODE_20116_length_283_cov_1.200000_g19817_i0	PRJNA492406	20116	283	1.2	3.396	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	51.6	4.29e-5	NR	KAL1495751.1	97485	g19817	i0	69.7	2.63957597173145	33	10	35	0	180	278	1	33	KAL1495751.1 hypothetical protein AB1Y20_016613 [Prymnesium parvum]	diamond	747	51.6	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
32258146	32258146	PRJNA492406_P_NODE_32518_length_234_cov_4.807453_g32219_i0	PRJNA492406	32518	234	4.807453	11.24944002	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	55.8	8.11e-7	NR	KAG8470448.1	2081491	g32219	i0	39.7	1.66666666666667	68	41	87.2	0	30	233	404	471	KAG8470448.1 hypothetical protein KFE25_008869 [Diacronema lutheri]	diamond	390	55.8	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
32636862	32636862	PRJNA492406_P_NODE_30400_length_244_cov_0.900585_g30101_i0	PRJNA492406	30400	244	0.900585	2.1974274	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	60.8	1.6e-8	NR	KAL1510237.1	97485	g30101	i0	40.7	0.995901639344262	81	47	99.6	1	243	1	918	997	KAL1510237.1 hypothetical protein AB1Y20_006563 [Prymnesium parvum]	diamond	243	60.8	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum

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