metadata: contig_metadata: 65 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax

65 rows where analysis = "blastn", bioproject = "PRJEB64798" 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
126518	126518	PRJEB64798_P_NODE_114021_length_209_cov_5.262500_g112255_i0	PRJEB64798	114021	209	5.2625	10.998625	Oxnerella micra	1147772	Root_unresolved	Root_unresolved	276	9.99e-70	NTclustered	gi\|375582525\|gb\|JQ245080.1\|	1147772	g112255	i0	91.22	3.57416267942584	205	15	98	3	6	209	1136	1338	Oxnerella micra 28S ribosomal RNA gene, partial sequence	blastn	747	276	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Oxnerellidae	Oxnerella	Oxnerella micra
127218	127218	PRJEB64798_P_NODE_160461_length_183_cov_3.865672_g158695_i0	PRJEB64798	160461	183	3.865672	7.07417976	Sphaerastrum fockii	299901	Root_unresolved	Root_unresolved	130	7e-26	NTclustered	gi\|61187370\|gb\|AY752991.1\|	299901	g158695	i0	81.319	31.4644808743169	182	14	99	7	2	182	1638	1800	Sphaerastrum fockii 28S ribosomal RNA gene, partial sequence	blastn	5758	130	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Heterophryidae	Sphaerastrum	Sphaerastrum fockii
127388	127388	PRJEB64798_P_NODE_173581_length_177_cov_3.531250_g171815_i0	PRJEB64798	173581	177	3.53125	6.2503125	Heterophryidae sp. 1 VVZ-2016	1795049	Root_unresolved	Root_unresolved	265	1.7599999999999998e-66	NTclustered	gi\|985769340\|gb\|KU178909.1\|	1795049	g171815	i0	94.767	9.18079096045198	172	5	97	3	1	172	885	718	Heterophryidae sp. 1 VVZ-2016 18S ribosomal RNA gene, partial sequence	blastn	1625	265	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Heterophryidae		Heterophryidae sp. 1 VVZ-2016
1401718	1401718	PRJEB64798_P_NODE_157162_length_185_cov_1.419118_g155396_i0	PRJEB64798	157162	185	1.419118	2.6253683	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	117	5.5200000000000005e-22	NTclustered	gi\|551606591\|ref\|XM_005784584.1\|	280463	g155396	i0	79.885	64.1351351351351	174	23	92	9	6	176	419	255	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	11865	117	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
1403393	1403393	PRJEB64798_P_NODE_38162_length_320_cov_3.261993_g36402_i0	PRJEB64798	38162	320	3.261993	10.4383776	Sphaerastrum fockii	299901	Root_unresolved	Root_unresolved	394	4.33e-105	NTclustered	gi\|61187370\|gb\|AY752991.1\|	299901	g36402	i0	90.228	6.753125	307	22	94	6	19	320	649	346	Sphaerastrum fockii 28S ribosomal RNA gene, partial sequence	blastn	2161	394	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Heterophryidae	Sphaerastrum	Sphaerastrum fockii
1403782	1403782	PRJEB64798_P_NODE_58582_length_254_cov_63.136585_g56817_i0	PRJEB64798	58582	254	63.136585	160.3669259	Meringosphaera mediterranea	2837474	Root_unresolved	Root_unresolved	106	1.75e-18	NTclustered	gi\|2526806211\|gb\|OR195157.1\|	2837474	g56817	i0	83.333	32.244094488189	120	15	47	5	1	119	2824	2939	Meringosphaera mediterranea isolate S7 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence	blastn	8190	106	1	Eukaryota	Haptista		Centroplasthelida			Meringosphaera	Meringosphaera mediterranea
2268364	2268364	PRJEB64798_P_NODE_20182_length_443_cov_86.421320_g18452_i0	PRJEB64798	20182	443	86.42132	382.8464476	Centroplasthelida	193537	Root_unresolved	Root_unresolved	468	3.59e-127	NTclustered	gi\|55469153\|gb\|AY749626.1\|	299876	g18452	i0	90.358	48.6749435665914	363	26	81	8	2	359	1264	906	Acanthocystis sp. Oxford8 18S ribosomal RNA gene, partial sequence	blastn	21563	468	1	Eukaryota	Haptista		Centroplasthelida	Acanthocystida	Acanthocystidae	Acanthocystis	Acanthocystis sp. Oxford8
2679216	2679216	PRJEB64798_P_NODE_49543_length_278_cov_33.908297_g47778_i0	PRJEB64798	49543	278	33.908297	94.26506566	Haptophyta environmental samples	171259	Haptophyta	other_Eukaryota	100	9.01e-17	NTclustered	gi\|1771196870\|dbj\|LC507231.1\|	171259	g47778	i0	96.667	21.1618705035971	60	2	22	0	200	259	186	127	Haptophyta environmental samples OTU035_Lake Takahoko gene for 18S ribosomal RNA, partial sequence	blastn	5883	100	1	Eukaryota	Haptista	Haptophyta					Haptophyta environmental samples
3543548	3543548	PRJEB64798_P_NODE_172463_length_177_cov_17.273438_g170697_i0	PRJEB64798	172463	177	17.273438	30.57398526	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	124	3.12e-24	NTclustered	gi\|551571117\|ref\|XM_005771409.1\|	280463	g170697	i0	80.357	4.38418079096045	168	30	94	3	10	175	336	170	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	776	124	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
3954929	3954929	PRJEB64798_P_NODE_38024_length_320_cov_10.169742_g36264_i0	PRJEB64798	38024	320	10.169742	32.5431744	Acanthocystis sp. Oxford8	299876	Root_unresolved	Root_unresolved	176	1.71e-39	NTclustered	gi\|55469153\|gb\|AY749626.1\|	299876	g36264	i0	81.466	50.6125	232	27	72	16	1	231	1997	1781	Acanthocystis sp. Oxford8 18S ribosomal RNA gene, partial sequence	blastn	16196	176	1	Eukaryota	Haptista		Centroplasthelida	Acanthocystida	Acanthocystidae	Acanthocystis	Acanthocystis sp. Oxford8
4820642	4820642	PRJEB64798_P_NODE_110044_length_210_cov_5.944099_g108278_i0	PRJEB64798	110044	210	5.944099	12.4826079	Pavlovaceae	418969	Haptophyta	other_Eukaryota	91.6	3.91e-14	NTclustered	gi\|321401323\|gb\|HQ908424.1\|	2081491	g108278	i0	90	1.51428571428571	70	7	33	0	8	77	1946	1877	Pavlova lutheri strain CCMP 1325 mitochondrion, partial genome	blastn	318	91.6	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
6096165	6096165	PRJEB64798_P_NODE_171805_length_178_cov_2.232558_g170039_i0	PRJEB64798	171805	178	2.232558	3.97395324	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	100	5.3e-17	NTclustered	gi\|9885780\|gb\|AF289038.1\|AF289038	35144	g170039	i0	78.912	6.01685393258427	147	31	83	0	1	147	2611	2465	Prymnesium patelliferum internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	1071	100	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
6506042	6506042	PRJEB64798_P_NODE_196446_length_168_cov_4.722689_g194680_i0	PRJEB64798	196446	168	4.722689	7.93411752	Diacronema sp.	2812047	Haptophyta	other_Eukaryota	270	3.5799999999999998e-68	NTclustered	gi\|2250364170\|gb\|ON714941.1\|	2812047	g194680	i0	96.341	87.8928571428571	164	6	98	0	2	165	173	10	Diacronema sp. isolate OTU_266 small subunit ribosomal RNA gene, partial sequence	blastn	14766	270	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema sp.
6506655	6506655	PRJEB64798_P_NODE_239926_length_155_cov_4.000000_g238160_i0	PRJEB64798	239926	155	4	6.2	Isochrysis galbana	37099	Haptophyta	other_Eukaryota	209	7.15e-50	NTclustered	gi\|638920537\|gb\|KF953490.1\|	37099	g238160	i0	91.946	94.2387096774194	149	12	96	0	1	149	332	184	Isochrysis galbana alpha-tubulin mRNA, partial cds	blastn	14607	209	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Isochrysidaceae	Isochrysis	Isochrysis galbana
6507159	6507159	PRJEB64798_P_NODE_43246_length_299_cov_41.984000_g41481_i0	PRJEB64798	43246	299	41.984	125.53216	Sphaerastrum fockii	299901	Root_unresolved	Root_unresolved	124	5.81e-24	NTclustered	gi\|61187370\|gb\|AY752991.1\|	299901	g41481	i0	83.969	13.4481605351171	131	19	44	1	7	137	2564	2692	Sphaerastrum fockii 28S ribosomal RNA gene, partial sequence	blastn	4021	124	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Heterophryidae	Sphaerastrum	Sphaerastrum fockii
6507239	6507239	PRJEB64798_P_NODE_46766_length_287_cov_4.399160_g45001_i0	PRJEB64798	46766	287	4.39916	12.6255892	Marophrys sp. SRT127	2488311	Root_unresolved	Root_unresolved	209	1.49e-49	NTclustered	gi\|1601521829\|dbj\|AP019310.1\|	2488311	g45001	i0	83.262	17.3066202090592	233	34	80	5	1	230	64525	64755	Marophrys sp. SRT127 mitochondrial DNA, complete sequence	blastn	4967	209	1	Eukaryota	Haptista		Centroplasthelida	Acanthocystida		Marophrys	Marophrys sp. SRT127
7370888	7370888	PRJEB64798_P_NODE_25406_length_390_cov_13.093842_g23657_i0	PRJEB64798	25406	390	13.093842	51.0659838	Pterocystida	2607628	Root_unresolved	Root_unresolved	134	1.29e-26	NTclustered	gi\|197723528\|gb\|EF681909.2\|	193542	g23657	i0	96.296	22.3615384615385	81	3	21	0	232	312	1146	1066	Chlamydaster sterni strain HFCC65 28S ribosomal RNA gene, partial sequence	blastn	8721	135	0.992592592592593	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Pterocystidae	Chlamydaster	Chlamydaster sterni
7780030	7780030	PRJEB64798_P_NODE_182507_length_173_cov_4.758065_g180741_i0	PRJEB64798	182507	173	4.758065	8.23145245	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	195	2.28e-45	NTclustered	gi\|551544771\|ref\|XM_005760371.1\|	280463	g180741	i0	88.415	49.3179190751445	164	15	94	4	6	167	85	246	Emiliania huxleyi CCMP1516 ADP-ribosylation factor (Arf1), partial mRNA	blastn	8532	195	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
7780489	7780489	PRJEB64798_P_NODE_214307_length_163_cov_13.798246_g212541_i0	PRJEB64798	214307	163	13.798246	22.49114098	Meringosphaera mediterranea	2837474	Root_unresolved	Root_unresolved	52.8	0.014	NTclustered	gi\|2526806206\|gb\|OR195152.1\|	2837474	g212541	i0	100	0.515337423312883	28	0	17	0	9	36	1437	1410	Meringosphaera mediterranea isolate S2 large subunit ribosomal RNA gene, partial sequence	blastn	84	52.8	1	Eukaryota	Haptista		Centroplasthelida			Meringosphaera	Meringosphaera mediterranea
7781193	7781193	PRJEB64798_P_NODE_35627_length_330_cov_83.569395_g33869_i0	PRJEB64798	35627	330	83.569395	275.7790035	Pavlova gyrans	44452	Haptophyta	other_Eukaryota	274	6.09e-69	NTclustered	gi\|238617593\|gb\|FJ973368.1\|	44452	g33869	i0	82.544	101.163636363636	338	34	99	18	1	328	1228	906	Pavlova gyrans strain CCMP 607 28S ribosomal RNA gene, partial sequence	blastn	33384	274	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Pavlova	Pavlova gyrans
8646797	8646797	PRJEB64798_P_NODE_78727_length_216_cov_423.622754_g76961_i0	PRJEB64798	78727	216	423.622754	915.02514864	Pterocystida	2607628	Root_unresolved	Root_unresolved	335	1.6899999999999993e-87	NTclustered	gi\|61187375\|gb\|AY752993.1\|	299886	g76961	i0	96.535	104.203703703704	202	7	94	0	13	214	3225	3426	Pterocystis tropica 28S ribosomal RNA gene, partial sequence	blastn	22508	335	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Pterocystidae	Pterocystis	Pterocystis tropica
9054390	9054390	PRJEB64798_P_NODE_150248_length_188_cov_5.179856_g148482_i0	PRJEB64798	150248	188	5.179856	9.73812928	Acanthocystis spinifera	299835	Root_unresolved	Root_unresolved	187	4.2299999999999985e-43	NTclustered	gi\|55469157\|gb\|AY749630.1\|	299835	g148482	i0	85.106	56.7074468085106	188	22	99	6	1	187	1843	2025	Acanthocystis spinifera 18S ribosomal RNA gene, partial sequence	blastn	10661	187	1	Eukaryota	Haptista		Centroplasthelida	Acanthocystida	Acanthocystidae	Acanthocystis	Acanthocystis spinifera
9056298	9056298	PRJEB64798_P_NODE_48608_length_281_cov_7.754310_g46843_i0	PRJEB64798	48608	281	7.75431	21.7896111	Acanthocystis sp. Oxford8	299876	Root_unresolved	Root_unresolved	401	2.2299999999999988e-107	NTclustered	gi\|55469153\|gb\|AY749626.1\|	299876	g46843	i0	92.883	57.3024911032028	281	12	99	8	4	280	1709	1985	Acanthocystis sp. Oxford8 18S ribosomal RNA gene, partial sequence	blastn	16102	401	1	Eukaryota	Haptista		Centroplasthelida	Acanthocystida	Acanthocystidae	Acanthocystis	Acanthocystis sp. Oxford8
9921652	9921652	PRJEB64798_P_NODE_45708_length_290_cov_58.294606_g43943_i0	PRJEB64798	45708	290	58.294606	169.0543574	Pterocystida	2607628	Root_unresolved	Root_unresolved	279	1.13e-70	NTclustered	gi\|61187375\|gb\|AY752993.1\|	299886	g43943	i0	98.726	78.548275862069	157	2	76	0	122	278	3381	3225	Pterocystis tropica 28S ribosomal RNA gene, partial sequence	blastn	22779	279	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Pterocystidae	Pterocystis	Pterocystis tropica
10330532	10330532	PRJEB64798_P_NODE_172489_length_177_cov_15.695312_g170723_i0	PRJEB64798	172489	177	15.695312	27.78070224	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	211	2.33e-50	NTclustered	gi\|551564199\|ref\|XM_005768624.1\|	280463	g170723	i0	93.617	73.8757062146893	141	9	80	0	1	141	210	350	Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA	blastn	13076	211	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
10331311	10331311	PRJEB64798_P_NODE_226589_length_160_cov_3.225225_g224823_i0	PRJEB64798	226589	160	3.225225	5.16036	Haptophyceae sp. NIES-3900	2748608	Haptophyta	other_Eukaryota	84.2	4.71e-12	NTclustered	gi\|1941608488\|dbj\|LC564893.1\|	2748608	g224823	i0	84.706	1.575	85	11	53	2	27	110	98434	98351	Haptophyceae sp. NIES-3900 chloroplast DNA, complete genome	blastn	252	84.2	1	Eukaryota	Haptista	Haptophyta					Haptophyceae sp. NIES-3900
10331443	10331443	PRJEB64798_P_NODE_236829_length_156_cov_4.775701_g235063_i0	PRJEB64798	236829	156	4.775701	7.45009356	Marophrys sp. SRT127	2488311	Root_unresolved	Root_unresolved	119	1.2500000000000001e-22	NTclustered	gi\|1601521829\|dbj\|AP019310.1\|	2488311	g235063	i0	86.486	0.711538461538462	111	11	70	4	22	130	64580	64688	Marophrys sp. SRT127 mitochondrial DNA, complete sequence	blastn	111	119	1	Eukaryota	Haptista		Centroplasthelida	Acanthocystida		Marophrys	Marophrys sp. SRT127
10332523	10332523	PRJEB64798_P_NODE_72169_length_227_cov_7.657303_g70404_i0	PRJEB64798	72169	227	7.657303	17.38207781	Haptolina brevifila	156173	Haptophyta	other_Eukaryota	89.8	1.54e-13	NTclustered	gi\|303431894\|emb\|AM490995.2\|	156173	g70404	i0	80.342	22.1057268722467	117	19	51	4	110	224	133	19	Haptolina brevifilum partial 18S rRNA gene, strain Kawachi, Japan	blastn	5018	89.8	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Haptolina	Haptolina brevifila
11196587	11196587	PRJEB64798_P_NODE_22309_length_419_cov_16.737838_g20569_i0	PRJEB64798	22309	419	16.737838	70.13154122	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	128	6.51e-25	NTclustered	gi\|197723528\|gb\|EF681909.2\|	193542	g20569	i0	95.062	19.5011933174224	81	4	27	0	270	350	1146	1066	Chlamydaster sterni strain HFCC65 28S ribosomal RNA gene, partial sequence	blastn	8171	128	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Pterocystidae	Chlamydaster	Chlamydaster sterni
11197008	11197008	PRJEB64798_P_NODE_66669_length_237_cov_14.191489_g64904_i0	PRJEB64798	66669	237	14.191489	33.63382893	Phaeocystis	33656	Haptophyta	other_Eukaryota	86.1	2.1e-12	NTclustered	gi\|9885782\|gb\|AF289040.1\|AF289040	33657	g64904	i0	94.545	4.11814345991561	55	3	23	0	176	230	199	145	Phaeocystis antarctica internal transcribed spacer 2, partial sequence; and 28S ribosomal RNA gene, complete sequence	blastn	976	86.1	1	Eukaryota	Haptista	Haptophyta		Phaeocystales	Phaeocystaceae	Phaeocystis	Phaeocystis antarctica
11605814	11605814	PRJEB64798_P_NODE_164770_length_181_cov_3.446970_g163004_i0	PRJEB64798	164770	181	3.44697	6.2390157	Sphaerastrum fockii	299901	Root_unresolved	Root_unresolved	69.4	1.53e-7	NTclustered	gi\|61187370\|gb\|AY752991.1\|	299901	g163004	i0	91.837	4.13259668508287	49	4	27	0	1	49	2285	2237	Sphaerastrum fockii 28S ribosomal RNA gene, partial sequence	blastn	748	69.4	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Heterophryidae	Sphaerastrum	Sphaerastrum fockii
11605867	11605867	PRJEB64798_P_NODE_167750_length_180_cov_1.190840_g165984_i0	PRJEB64798	167750	180	1.19084	2.143512	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	161	2.43e-35	NTclustered	gi\|551576855\|ref\|XM_005774014.1\|	280463	g165984	i0	84	0.972222222222222	175	20	95	6	8	178	934	1104	Emiliania huxleyi CCMP1516 L-Rhamnonate dehydratase mRNA	blastn	175	161	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
11606891	11606891	PRJEB64798_P_NODE_238650_length_155_cov_11.528302_g236884_i0	PRJEB64798	238650	155	11.528302	17.8688681	Raphidocystis pallida	2939597	Root_unresolved	Root_unresolved	180	5.599999999999998e-41	NTclustered	gi\|2232966924\|gb\|ON392107.1\|	2939597	g236884	i0	88.742	34.3032258064516	151	11	97	4	1	151	628	484	Raphidocystis pallida isolate PL19-06 small subunit ribosomal RNA gene, partial sequence	blastn	5317	180	1	Eukaryota	Haptista		Centroplasthelida	Acanthocystida	Raphidocystidae	Raphidocystis	Raphidocystis pallida
11607519	11607519	PRJEB64798_P_NODE_46790_length_287_cov_3.773109_g45025_i0	PRJEB64798	46790	287	3.773109	10.82882283	Triangulopteris lacunata	2900362	Root_unresolved	Root_unresolved	174	5.4299999999999997e-39	NTclustered	gi\|2160613664\|gb\|OL739463.1\|	2900362	g45025	i0	83.333	72.1428571428571	204	18	70	11	80	281	1359	1548	Triangulopteris lacunata clone HF-25 small subunit ribosomal RNA gene, partial sequence	blastn	20705	174	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Pterocystidae	Triangulopteris	Triangulopteris lacunata
12881253	12881253	PRJEB64798_P_NODE_182911_length_173_cov_3.330645_g181145_i0	PRJEB64798	182911	173	3.330645	5.76201585	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	69.4	1.44e-7	NTclustered	gi\|551614683\|ref\|XM_005788194.1\|	280463	g181145	i0	80.22	1.57803468208092	91	18	53	0	79	169	808	898	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	273	69.4	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
13746130	13746130	PRJEB64798_P_NODE_11111_length_600_cov_65.655172_g9575_i0	PRJEB64798	11111	600	65.655172	393.931032	Pterocystida	2607628	Root_unresolved	Root_unresolved	176	3.38e-39	NTclustered	gi\|61187370\|gb\|AY752991.1\|	299901	g9575	i0	83.333	18.0883333333333	204	21	34	8	8	210	1571	1762	Sphaerastrum fockii 28S ribosomal RNA gene, partial sequence	blastn	10853	176	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Heterophryidae	Sphaerastrum	Sphaerastrum fockii
13746316	13746316	PRJEB64798_P_NODE_147451_length_189_cov_93.300000_g145685_i0	PRJEB64798	147451	189	93.3	176.337	Pterocystida	2607628	Root_unresolved	Root_unresolved	100	5.71e-17	NTclustered	gi\|61187375\|gb\|AY752993.1\|	299886	g145685	i0	81.343	6.47619047619048	134	16	68	9	62	189	2572	2702	Pterocystis tropica 28S ribosomal RNA gene, partial sequence	blastn	1224	100	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Pterocystidae	Pterocystis	Pterocystis tropica
13747123	13747123	PRJEB64798_P_NODE_72931_length_226_cov_3.666667_g71166_i0	PRJEB64798	72931	226	3.666667	8.28666742	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	60.2	1.2e-4	NTclustered	gi\|9885782\|gb\|AF289040.1\|AF289040	33657	g71166	i0	97.143	7.85398230088496	35	1	15	0	1	35	165	199	Phaeocystis antarctica internal transcribed spacer 2, partial sequence; and 28S ribosomal RNA gene, complete sequence	blastn	1775	60.2	1	Eukaryota	Haptista	Haptophyta		Phaeocystales	Phaeocystaceae	Phaeocystis	Phaeocystis antarctica
14155278	14155278	PRJEB64798_P_NODE_13492_length_543_cov_47.785425_g11845_i0	PRJEB64798	13492	543	47.785425	259.47485775	Haptophyta environmental samples	171259	Haptophyta	other_Eukaryota	121	1.44e-22	NTclustered	gi\|822590914\|gb\|KR338468.1\|	171259	g11845	i0	76.327	25.7053406998158	245	46	44	11	305	543	464	702	Uncultured haptophyte clone 7BDCM04 18S ribosomal RNA gene, partial sequence	blastn	13958	121	1	Eukaryota	Haptista	Haptophyta					Haptophyta environmental samples
14156511	14156511	PRJEB64798_P_NODE_216152_length_163_cov_2.473684_g214386_i0	PRJEB64798	216152	163	2.473684	4.03210492	Sphaerastrum fockii	299901	Root_unresolved	Root_unresolved	93.5	8.01e-15	NTclustered	gi\|61187370\|gb\|AY752991.1\|	299901	g214386	i0	98.113	3.51533742331288	53	1	53	0	106	158	2696	2644	Sphaerastrum fockii 28S ribosomal RNA gene, partial sequence	blastn	573	93.5	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Heterophryidae	Sphaerastrum	Sphaerastrum fockii
14157744	14157744	PRJEB64798_P_NODE_63672_length_243_cov_150.634021_g61907_i0	PRJEB64798	63672	243	150.634021	366.04067103	Meringosphaera mediterranea	2837474	Root_unresolved	Root_unresolved	124	4.579999999999999e-24	NTclustered	gi\|2526806211\|gb\|OR195157.1\|	2837474	g61907	i0	83.333	37.6502057613169	138	20	56	3	107	243	2949	2814	Meringosphaera mediterranea isolate S7 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence	blastn	9149	124	1	Eukaryota	Haptista		Centroplasthelida			Meringosphaera	Meringosphaera mediterranea
15429340	15429340	PRJEB64798_P_NODE_13873_length_536_cov_22.671458_g12215_i0	PRJEB64798	13873	536	22.671458	121.51901488	Heterophryidae sp. 3 VVZ-2016	1795051	Root_unresolved	Root_unresolved	215	6.35e-51	NTclustered	gi\|985769339\|gb\|KU178908.1\|	1795051	g12215	i0	87.766	45.5764925373134	188	18	65	5	2	188	448	265	Heterophryidae sp. 3 VVZ-2016 18S ribosomal RNA gene, partial sequence	blastn	24429	215	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Heterophryidae		Heterophryidae sp. 3 VVZ-2016
15430850	15430850	PRJEB64798_P_NODE_240973_length_155_cov_2.283019_g239207_i0	PRJEB64798	240973	155	2.283019	3.53867945	Diacronema viridis	2793420	Haptophyta	other_Eukaryota	100	4.49e-17	NTclustered	gi\|1941799838\|gb\|MW044630.1\|	2793420	g239207	i0	81.301	1.58709677419355	123	23	79	0	25	147	28016	27894	Diacronema viridis mitochondrion, complete genome	blastn	246	100	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema viridis
16295656	16295656	PRJEB64798_P_NODE_16853_length_485_cov_20.694954_g15150_i0	PRJEB64798	16853	485	20.694954	100.3705269	Phaeocystis	33656	Haptophyta	other_Eukaryota	167	1.6200000000000002e-36	NTclustered	gi\|1074200956\|dbj\|LC189148.1\|	118080	g15150	i0	91.803	39.379381443299	122	6	40	4	263	383	1330	1448	Phaeocystis jahnii gene for 18S ribosomal RNA, partial sequence, strain: NIES-3884	blastn	19099	167	1	Eukaryota	Haptista	Haptophyta		Phaeocystales	Phaeocystaceae	Phaeocystis	Phaeocystis jahnii
16705607	16705607	PRJEB64798_P_NODE_40394_length_310_cov_39.022989_g38629_i0	PRJEB64798	40394	310	39.022989	120.9712659	Oxnerella micra	1147772	Root_unresolved	Root_unresolved	176	1.65e-39	NTclustered	gi\|375582525\|gb\|JQ245080.1\|	1147772	g38629	i0	96.262	34.6903225806452	107	4	35	0	8	114	954	1060	Oxnerella micra 28S ribosomal RNA gene, partial sequence	blastn	10754	176	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Oxnerellidae	Oxnerella	Oxnerella micra
17571339	17571339	PRJEB64798_P_NODE_31934_length_348_cov_38.933110_g30177_i0	PRJEB64798	31934	348	38.93311	135.4872228	Acanthocystis	299834	Root_unresolved	Root_unresolved	536	7.459999999999997e-148	NTclustered	gi\|55469153\|gb\|AY749626.1\|	299876	g30177	i0	94.618	48.367816091954	353	8	98	4	2	343	453	101	Acanthocystis sp. Oxford8 18S ribosomal RNA gene, partial sequence	blastn	16832	536	1	Eukaryota	Haptista		Centroplasthelida	Acanthocystida	Acanthocystidae	Acanthocystis	Acanthocystis sp. Oxford8
17978005	17978005	PRJEB64798_P_NODE_108315_length_210_cov_11.204969_g106549_i0	PRJEB64798	108315	210	11.204969	23.5304349	Sphaerastrum fockii	299901	Root_unresolved	Root_unresolved	119	1.79e-22	NTclustered	gi\|61187370\|gb\|AY752991.1\|	299901	g106549	i0	85.217	15.7809523809524	115	17	55	0	93	207	2679	2565	Sphaerastrum fockii 28S ribosomal RNA gene, partial sequence	blastn	3314	119	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Heterophryidae	Sphaerastrum	Sphaerastrum fockii
17979882	17979882	PRJEB64798_P_NODE_233855_length_157_cov_5.083333_g232089_i0	PRJEB64798	233855	157	5.083333	7.98083281	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	172	9.53e-39	NTclustered	gi\|551539306\|ref\|XM_005758086.1\|	280463	g232089	i0	87.013	91.6242038216561	154	18	97	2	4	156	322	474	Emiliania huxleyi CCMP1516 receptor of activated protein kinase C partial mRNA	blastn	14385	172	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
17980013	17980013	PRJEB64798_P_NODE_24355_length_399_cov_13.600000_g22607_i0	PRJEB64798	24355	399	13.6	54.264	Pterocystis tropica	299886	Root_unresolved	Root_unresolved	54.7	0.011	NTclustered	gi\|61187375\|gb\|AY752993.1\|	299886	g22607	i0	94.444	0.0902255639097744	36	1	9	1	32	67	1985	1951	Pterocystis tropica 28S ribosomal RNA gene, partial sequence	blastn	36	54.7	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Pterocystidae	Pterocystis	Pterocystis tropica
17980150	17980150	PRJEB64798_P_NODE_26075_length_385_cov_53.779762_g24325_i0	PRJEB64798	26075	385	53.779762	207.0520837	uncultured Centroheliozoa	315785	Root_unresolved	Root_unresolved	680	0	NTclustered	gi\|157781164\|gb\|EU143988.1\|	315785	g24325	i0	99.465	109.958441558442	374	2	97	0	8	381	386	13	Uncultured centroheliozoan clone EB17.116 18S ribosomal RNA gene, partial sequence	blastn	42334	680	1	Eukaryota	Haptista		Centroplasthelida				uncultured Centroheliozoa
17980773	17980773	PRJEB64798_P_NODE_58575_length_254_cov_180.063415_g56810_i0	PRJEB64798	58575	254	180.063415	457.3610741	Oxnerella micra	1147772	Root_unresolved	Root_unresolved	403	5.53e-108	NTclustered	gi\|375582525\|gb\|JQ245080.1\|	1147772	g56810	i0	96.016	90.7716535433071	251	5	97	5	7	253	1226	1475	Oxnerella micra 28S ribosomal RNA gene, partial sequence	blastn	23056	403	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Oxnerellidae	Oxnerella	Oxnerella micra
19252755	19252755	PRJEB64798_P_NODE_156096_length_185_cov_5.125000_g154330_i0	PRJEB64798	156096	185	5.125	9.48125	Chrysochromulina sp.	2200936	Haptophyta	other_Eukaryota	267	5.18e-67	NTclustered	gi\|2059554223\|gb\|MZ469764.1\|	2200936	g154330	i0	93.37	102.048648648649	181	11	97	1	1	180	393	213	Chrysochromulina sp. strain DAD-ALGEUK-36 large subunit ribosomal RNA gene, partial sequence; chloroplast	blastn	18879	267	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina sp.
20120159	20120159	PRJEB64798_P_NODE_56456_length_259_cov_37.333333_g54691_i0	PRJEB64798	56456	259	37.333333	96.69333247	Pterocystida	2607628	Root_unresolved	Root_unresolved	62.1	3.92e-5	NTclustered	gi\|61187375\|gb\|AY752993.1\|	299886	g54691	i0	100	2.8030888030888	33	0	13	0	1	33	2702	2670	Pterocystis tropica 28S ribosomal RNA gene, partial sequence	blastn	726	62.1	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Pterocystidae	Pterocystis	Pterocystis tropica
20528645	20528645	PRJEB64798_P_NODE_191977_length_169_cov_11.383333_g190211_i0	PRJEB64798	191977	169	11.383333	19.23783277	Acanthocystis nichollsi	299881	Root_unresolved	Root_unresolved	248	1.68e-61	NTclustered	gi\|55469159\|gb\|AY749632.1\|	299881	g190211	i0	94.479	19.2958579881657	163	5	95	3	2	161	962	801	Acanthocystis nichollsi 18S ribosomal RNA gene, partial sequence	blastn	3261	248	1	Eukaryota	Haptista		Centroplasthelida	Acanthocystida	Acanthocystidae	Acanthocystis	Acanthocystis nichollsi
20528820	20528820	PRJEB64798_P_NODE_202817_length_166_cov_17.034188_g201051_i0	PRJEB64798	202817	166	17.034188	28.27675208	Pterocystis tropica	299886	Root_unresolved	Root_unresolved	231	1.6599999999999998e-56	NTclustered	gi\|61187375\|gb\|AY752993.1\|	299886	g201051	i0	94.118	24.2530120481928	153	7	92	2	15	166	2255	2406	Pterocystis tropica 28S ribosomal RNA gene, partial sequence	blastn	4026	231	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Pterocystidae	Pterocystis	Pterocystis tropica
20529384	20529384	PRJEB64798_P_NODE_241817_length_154_cov_7.980952_g240051_i0	PRJEB64798	241817	154	7.980952	12.29066608	Acanthocystis sp. Oxford2	299871	Root_unresolved	Root_unresolved	117	4.42e-22	NTclustered	gi\|55469148\|gb\|AY749621.1\|	299871	g240051	i0	92.857	11.7142857142857	84	1	52	3	1	80	1166	1084	Acanthocystis sp. Oxford2 18S ribosomal RNA gene, partial sequence	blastn	1804	117	1	Eukaryota	Haptista		Centroplasthelida	Acanthocystida	Acanthocystidae	Acanthocystis	Acanthocystis sp. Oxford2
21394906	21394906	PRJEB64798_P_NODE_13177_length_550_cov_44.293413_g11535_i0	PRJEB64798	13177	550	44.293413	243.6137715	Acanthocystis	299834	Root_unresolved	Root_unresolved	883	0	NTclustered	gi\|55469153\|gb\|AY749626.1\|	299876	g11535	i0	95.985	41.3890909090909	548	14	99	6	6	549	721	1264	Acanthocystis sp. Oxford8 18S ribosomal RNA gene, partial sequence	blastn	22764	883	1	Eukaryota	Haptista		Centroplasthelida	Acanthocystida	Acanthocystidae	Acanthocystis	Acanthocystis sp. Oxford8
21803455	21803455	PRJEB64798_P_NODE_127238_length_199_cov_16.006667_g125472_i0	PRJEB64798	127238	199	16.006667	31.85326733	Raphidocystis contractilis	2792838	Root_unresolved	Root_unresolved	128	2.79e-25	NTclustered	gi\|81230320\|dbj\|AB196984.1\|	2792838	g125472	i0	95.122	26.0402010050251	82	3	41	1	1	82	1401	1321	Raphidocystis contractilis gene for 18S ribosomal RNA, partial sequence	blastn	5182	128	1	Eukaryota	Haptista		Centroplasthelida	Acanthocystida	Raphidocystidae	Raphidocystis	Raphidocystis contractilis
21806082	21806082	PRJEB64798_P_NODE_62958_length_245_cov_4.193878_g61193_i0	PRJEB64798	62958	245	4.193878	10.2750011	Raphidocystis contractilis	2792838	Root_unresolved	Root_unresolved	84.2	7.84e-12	NTclustered	gi\|81230320\|dbj\|AB196984.1\|	2792838	g61193	i0	96.078	1.78775510204082	51	2	21	0	93	143	931	881	Raphidocystis contractilis gene for 18S ribosomal RNA, partial sequence	blastn	438	84.2	1	Eukaryota	Haptista		Centroplasthelida	Acanthocystida	Raphidocystidae	Raphidocystis	Raphidocystis contractilis
22669750	22669750	PRJEB64798_P_NODE_144238_length_191_cov_5.338028_g142472_i0	PRJEB64798	144238	191	5.338028	10.19563348	Heterophryidae	193539	Root_unresolved	Root_unresolved	69.4	1.63e-7	NTclustered	gi\|61187370\|gb\|AY752991.1\|	299901	g142472	i0	92	3.84293193717278	50	2	26	2	2	50	2285	2237	Sphaerastrum fockii 28S ribosomal RNA gene, partial sequence	blastn	734	69.4	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Heterophryidae	Sphaerastrum	Sphaerastrum fockii
23079463	23079463	PRJEB64798_P_NODE_175459_length_176_cov_4.944882_g173693_i0	PRJEB64798	175459	176	4.944882	8.70299232	Oxnerella micra	1147772	Root_unresolved	Root_unresolved	241	2.950000000000001e-59	NTclustered	gi\|375582525\|gb\|JQ245080.1\|	1147772	g173693	i0	91.86	3.94318181818182	172	14	98	0	5	176	1179	1350	Oxnerella micra 28S ribosomal RNA gene, partial sequence	blastn	694	241	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Oxnerellidae	Oxnerella	Oxnerella micra
23081176	23081176	PRJEB64798_P_NODE_58159_length_255_cov_21.868932_g56394_i0	PRJEB64798	58159	255	21.868932	55.7657766	Pterocystis tropica	299886	Root_unresolved	Root_unresolved	327	3.44e-85	NTclustered	gi\|61187375\|gb\|AY752993.1\|	299886	g56394	i0	96.059	80.1529411764706	203	5	97	3	54	255	1494	1694	Pterocystis tropica 28S ribosomal RNA gene, partial sequence	blastn	20439	327	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Pterocystidae	Pterocystis	Pterocystis tropica
24354200	24354200	PRJEB64798_P_NODE_23720_length_405_cov_89.957865_g21975_i0	PRJEB64798	23720	405	89.957865	364.32935325	Oxnerella micra	1147772	Root_unresolved	Root_unresolved	261	5.93e-65	NTclustered	gi\|375582525\|gb\|JQ245080.1\|	1147772	g21975	i0	85.769	28.7975308641975	260	22	63	10	109	363	970	1219	Oxnerella micra 28S ribosomal RNA gene, partial sequence	blastn	11663	261	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Oxnerellidae	Oxnerella	Oxnerella micra
25218854	25218854	PRJEB64798_P_NODE_123000_length_204_cov_4.193548_g121234_i0	PRJEB64798	123000	204	4.193548	8.55483792	Pavlovaceae	418969	Haptophyta	other_Eukaryota	63.9	8.22e-6	NTclustered	gi\|321401323\|gb\|HQ908424.1\|	2081491	g121234	i0	83.824	1.36274509803922	68	9	32	2	110	175	1423	1356	Pavlova lutheri strain CCMP 1325 mitochondrion, partial genome	blastn	278	63.9	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
25219828	25219828	PRJEB64798_P_NODE_76960_length_219_cov_10.952941_g75194_i0	PRJEB64798	76960	219	10.952941	23.98694079	Pterocystida	2607628	Root_unresolved	Root_unresolved	202	1.82e-47	NTclustered	gi\|61187375\|gb\|AY752993.1\|	299886	g75194	i0	95.276	31.7168949771689	127	6	73	0	3	129	2973	3099	Pterocystis tropica 28S ribosomal RNA gene, partial sequence	blastn	6946	202	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Pterocystidae	Pterocystis	Pterocystis tropica

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