metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA630162" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA630162" 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
602800	602800	PRJNA630162_P_NODE_97341_length_187_cov_1.826087_g95818_i0	PRJNA630162	97341	187	1.826087	3.41478269	Chrysochromulina parva	127563	Haptophyta	other_Eukaryota	244	2.4599999999999999e-60	NTclustered	gi\|1347725412\|ref\|NC_036938.1\|	127563	g95818	i0	90.761	1.72192513368984	184	15	98	2	1	183	9895	9713	Chrysochromulina parva mitochondrion, complete genome	blastn	322	244	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina parva
1878700	1878700	PRJNA630162_P_NODE_65682_length_218_cov_2.065089_g64159_i0	PRJNA630162	65682	218	2.065089	4.50189402	Pavlova gyrans	44452	Haptophyta	other_Eukaryota	174	3.94e-39	NTclustered	gi\|238617593\|gb\|FJ973368.1\|	44452	g64159	i0	81.905	43.8623853211009	210	30	94	6	10	214	2052	1846	Pavlova gyrans strain CCMP 607 28S ribosomal RNA gene, partial sequence	blastn	9562	174	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Pavlova	Pavlova gyrans
2426477	2426477	PRJNA630162_P_NODE_149342_length_164_cov_8.739130_g147819_i0	PRJNA630162	149342	164	8.73913	14.3321732	Isochrysis	37098	Haptophyta	other_Eukaryota	228	2.1199999999999996e-55	NTclustered	gi\|595763595\|gb\|KF998564.1\|	37099	g147819	i0	92.593	92.4512195121951	162	7	96	3	1	157	412	251	Isochrysis galbana strain East China Sea 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	15162	228	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Isochrysidaceae	Isochrysis	Isochrysis galbana
6255211	6255211	PRJNA630162_P_NODE_54245_length_239_cov_2.794737_g52722_i0	PRJNA630162	54245	239	2.794737	6.67942143	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	379	8.679999999999998e-101	NTclustered	gi\|523420608\|ref\|NC_016703.2\|	33657	g52722	i0	95.745	97.9456066945607	235	10	98	0	1	235	19445	19679	Phaeocystis antarctica strain CCMP1374 plastid, complete genome	blastn	23409	379	1	Eukaryota	Haptista	Haptophyta		Phaeocystales	Phaeocystaceae	Phaeocystis	Phaeocystis antarctica
6980634	6980634	PRJNA630162_P_NODE_27146_length_349_cov_8.723333_g25624_i0	PRJNA630162	27146	349	8.723333	30.44443217	Haptophyta environmental samples	171259	Haptophyta	other_Eukaryota	562	1.23e-155	NTclustered	gi\|60687332\|gb\|AY821959.1\|	171259	g25624	i0	95.739	96.7449856733524	352	9	99	4	3	349	15	365	Haptophyta environmental samples clone CV1_B1_97 small subunit ribosomal RNA gene, partial sequence	blastn	33764	562	1	Eukaryota	Haptista	Haptophyta					Haptophyta environmental samples
7528956	7528956	PRJNA630162_P_NODE_115646_length_176_cov_5.897638_g114123_i0	PRJNA630162	115646	176	5.897638	10.37984288	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	163	6.570000000000001e-36	NTclustered	gi\|2546898262\|gb\|OR148362.1\|	35137	g114123	i0	84.024	16.8352272727273	169	27	96	0	1	169	96077	96245	Ochrosphaera neapolitana strain A15,280 plastid, complete genome	blastn	2963	163	1	Eukaryota	Haptista	Haptophyta		Coccolithales	Hymenomonadaceae	Ochrosphaera	Ochrosphaera neapolitana
8804056	8804056	PRJNA630162_P_NODE_113827_length_177_cov_4.656250_g112304_i0	PRJNA630162	113827	177	4.65625	8.2415625	Isochrysidaceae	418951	Haptophyta	other_Eukaryota	176	8.5e-40	NTclustered	gi\|2429804553\|ref\|NC_069636.1\|	13221	g112304	i0	92.063	133.401129943503	126	8	95	1	53	176	33539	33414	Chrysotila carterae chloroplast, complete genome	blastn	23612	176	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Isochrysidaceae	Chrysotila	Chrysotila carterae
10079786	10079786	PRJNA630162_P_NODE_172888_length_150_cov_8.584158_g171365_i0	PRJNA630162	172888	150	8.584158	12.876237	Chrysochromulina	35140	Haptophyta	other_Eukaryota	276	6.660000000000001e-70	NTclustered	gi\|1347725299\|ref\|NC_036937.1\|	127563	g171365	i0	100	165.326666666667	149	0	99	0	2	150	65853	66001	Chrysochromulina parva chloroplast, complete genome	blastn	24799	276	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina parva
13356523	13356523	PRJNA630162_P_NODE_45691_length_261_cov_12.929245_g44168_i0	PRJNA630162	45691	261	12.929245	33.74532945	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	440	4.3499999999999984e-119	NTclustered	gi\|551614683\|ref\|XM_005788194.1\|	280463	g44168	i0	97.656	29.8199233716475	256	6	98	0	1	256	51	306	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	7783	440	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
13905352	13905352	PRJNA630162_P_NODE_32811_length_314_cov_2.196226_g31289_i0	PRJNA630162	32811	314	2.196226	6.89614964	Noelaerhabdaceae	418966	Haptophyta	other_Eukaryota	71.3	8.11e-8	NTclustered	gi\|2235062386\|gb\|OL703623.1\|	2903	g31289	i0	79.048	10.3662420382166	105	21	33	1	133	237	201	304	Emiliania huxleyi strain RCC1217 mitochondrion, partial genome	blastn	3255	71.3	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
14630858	14630858	PRJNA630162_P_NODE_167572_length_156_cov_14.514019_g166049_i0	PRJNA630162	167572	156	14.514019	22.64186964	Pavlova gyrans	44452	Haptophyta	other_Eukaryota	87.9	3.52e-13	NTclustered	gi\|238617593\|gb\|FJ973368.1\|	44452	g166049	i0	98	34.5897435897436	50	1	32	0	2	51	2059	2010	Pavlova gyrans strain CCMP 607 28S ribosomal RNA gene, partial sequence	blastn	5396	87.9	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Pavlova	Pavlova gyrans
14630933	14630933	PRJNA630162_P_NODE_18172_length_436_cov_68.240310_g16663_i0	PRJNA630162	18172	436	68.24031	297.5277516	Haptophyta environmental samples	171259	Haptophyta	other_Eukaryota	176	2.3999999999999998e-39	NTclustered	gi\|194146360\|gb\|EU616327.1\|	171259	g16663	i0	86.061	39.3967889908257	165	22	38	1	267	431	767	604	Uncultured haptophyte clone MV5_19_190 28S ribosomal RNA gene, partial sequence	blastn	17177	176	1	Eukaryota	Haptista	Haptophyta					Haptophyta environmental samples
14631786	14631786	PRJNA630162_P_NODE_93992_length_189_cov_1.971429_g92469_i0	PRJNA630162	93992	189	1.971429	3.72600081	Haptophyceae sp. NIES-3900	2748608	Haptophyta	other_Eukaryota	54.7	0.005	NTclustered	gi\|1941608438\|dbj\|LC564891.1\|	2748608	g92469	i0	100	0.153439153439153	29	0	15	0	132	160	7514	7486	Haptophyceae sp. NIES-3900 mitochondrial DNA, note: Mt_DNA1	blastn	29	54.7	1	Eukaryota	Haptista	Haptophyta					Haptophyceae sp. NIES-3900
15179506	15179506	PRJNA630162_P_NODE_106772_length_181_cov_2.977273_g105249_i0	PRJNA630162	106772	181	2.977273	5.38886413	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	252	1.41e-62	NTclustered	gi\|2530650642\|gb\|ON844104.1\|	2903	g105249	i0	96.689	128.707182320442	151	5	83	0	19	169	88010	87860	Emiliania huxleyi strain CS-369 plastid, complete genome	blastn	23296	254	0.992125984251969	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
17179633	17179633	PRJNA630162_P_NODE_137094_length_167_cov_659.457627_g135571_i0	PRJNA630162	137094	167	659.457627	1101.29423709	Haptophyta environmental samples	171259	Haptophyta	other_Eukaryota	303	3.5e-78	NTclustered	gi\|60687333\|gb\|AY821960.1\|	171259	g135571	i0	99.401	100.209580838323	167	1	100	0	1	167	1626	1460	Haptophyta environmental samples clone CV1_B2_32 small subunit ribosomal RNA gene, partial sequence	blastn	16735	303	1	Eukaryota	Haptista	Haptophyta					Haptophyta environmental samples
17180381	17180381	PRJNA630162_P_NODE_51554_length_245_cov_4.377551_g50031_i0	PRJNA630162	51554	245	4.377551	10.72499995	Isochrysis litoralis	418952	Haptophyta	other_Eukaryota	313	9.19e-81	NTclustered	gi\|213390501\|gb\|EU819085.1\|	418952	g50031	i0	90.123	97.0857142857143	243	20	99	3	1	242	458	219	Isochrysis litoralis 28S ribosomal RNA gene, partial sequence	blastn	23786	313	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Isochrysidaceae	Isochrysis	Isochrysis litoralis
17729388	17729388	PRJNA630162_P_NODE_62014_length_224_cov_3.965714_g60491_i0	PRJNA630162	62014	224	3.965714	8.88319936	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	58.4	4.28e-4	NTclustered	gi\|984294429\|gb\|KT389890.1\|	33657	g60491	i0	100	6.83928571428571	31	0	14	0	1	31	779	809	Phaeocystis antarctica clone KJ22-0.2-70 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence	blastn	1532	58.4	1	Eukaryota	Haptista	Haptophyta		Phaeocystales	Phaeocystaceae	Phaeocystis	Phaeocystis antarctica
19003103	19003103	PRJNA630162_P_NODE_91815_length_190_cov_4.822695_g90292_i0	PRJNA630162	91815	190	4.822695	9.1631205	Pavlovaceae	418969	Haptophyta	other_Eukaryota	340	3.1099999999999993e-89	NTclustered	gi\|456061976\|ref\|NC_020371.1\|	2081491	g90292	i0	98.947	107.647368421053	190	2	100	0	1	190	2260	2449	Pavlova lutheri chloroplast, complete genome	blastn	20453	340	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
19728163	19728163	PRJNA630162_P_NODE_127596_length_170_cov_3.140496_g126073_i0	PRJNA630162	127596	170	3.140496	5.3388432	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	274	2.79e-69	NTclustered	gi\|9885780\|gb\|AF289038.1\|AF289038	35144	g126073	i0	96.933	9.42352941176471	163	5	96	0	2	164	2599	2437	Prymnesium patelliferum internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence	blastn	1602	274	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
19728609	19728609	PRJNA630162_P_NODE_19616_length_418_cov_12.056911_g18103_i0	PRJNA630162	19616	418	12.056911	50.39788798	Haptophyta environmental samples	171259	Haptophyta	other_Eukaryota	586	8.919999999999996e-163	NTclustered	gi\|60687332\|gb\|AY821959.1\|	171259	g18103	i0	92.308	72.633971291866	416	27	99	5	1	414	1041	629	Haptophyta environmental samples clone CV1_B1_97 small subunit ribosomal RNA gene, partial sequence	blastn	30361	586	1	Eukaryota	Haptista	Haptophyta					Haptophyta environmental samples
21553302	21553302	PRJNA630162_P_NODE_23017_length_382_cov_8.861862_g21499_i0	PRJNA630162	23017	382	8.861862	33.85231284	Emiliania	2902	Haptophyta	other_Eukaryota	678	0	NTclustered	gi\|451352913\|gb\|JX680418.1\|	171259	g21499	i0	99.202	98.4397905759162	376	3	98	0	5	380	190	565	Uncultured haptophyte clone EV3-Pry1-C7 18S ribosomal RNA gene, partial sequence	blastn	37604	678	1	Eukaryota	Haptista	Haptophyta					Haptophyta environmental samples
22278464	22278464	PRJNA630162_P_NODE_101678_length_184_cov_4.985185_g100155_i0	PRJNA630162	101678	184	4.985185	9.1727404	Pavlova gyrans	44452	Haptophyta	other_Eukaryota	135	1.51e-27	NTclustered	gi\|238617593\|gb\|FJ973368.1\|	44452	g100155	i0	85.926	67.8260869565217	135	9	69	8	58	184	1034	902	Pavlova gyrans strain CCMP 607 28S ribosomal RNA gene, partial sequence	blastn	12480	135	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Pavlova	Pavlova gyrans
22278764	22278764	PRJNA630162_P_NODE_133658_length_168_cov_2.495798_g132135_i0	PRJNA630162	133658	168	2.495798	4.19294064	Chrysochromulina parva	127563	Haptophyta	other_Eukaryota	298	1.64e-76	NTclustered	gi\|1347725412\|ref\|NC_036938.1\|	127563	g132135	i0	100	1.91666666666667	161	0	96	0	8	168	2792	2952	Chrysochromulina parva mitochondrion, complete genome	blastn	322	298	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina parva
22279220	22279220	PRJNA630162_P_NODE_24058_length_373_cov_567.941358_g22539_i0	PRJNA630162	24058	373	567.941358	2118.42126534	Diacronema vlkianum	70452	Haptophyta	other_Eukaryota	627	4.639999999999999e-175	NTclustered	gi\|330423579\|gb\|JF714241.1\|	70452	g22539	i0	97.051	99.9785522788204	373	10	100	1	1	373	12	383	Diacronema vlkianum strain AC67 18S ribosomal RNA gene, partial sequence	blastn	37292	627	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema vlkianum
22279429	22279429	PRJNA630162_P_NODE_43538_length_268_cov_11.593607_g42015_i0	PRJNA630162	43538	268	11.593607	31.07086676	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	195	3.85e-45	NTclustered	gi\|551564253\|ref\|XM_005768650.1\|	280463	g42015	i0	80.37	67.4029850746269	270	42	100	11	1	268	380	640	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	18064	195	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
22279521	22279521	PRJNA630162_P_NODE_52978_length_242_cov_1.953368_g51455_i0	PRJNA630162	52978	242	1.953368	4.72715056	Dicrateria rotunda	2703868	Haptophyta	other_Eukaryota	276	1.19e-69	NTclustered	gi\|2632235331\|gb\|OR922713.1\|	2703868	g51455	i0	87.654	40.7314049586777	243	22	98	7	6	242	4440	4680	Dicrateria rotunda strain AGSB0127 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence	blastn	9857	276	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Isochrysidaceae	Dicrateria	Dicrateria rotunda
22828634	22828634	PRJNA630162_P_NODE_141378_length_166_cov_2.965812_g139855_i0	PRJNA630162	141378	166	2.965812	4.92324792	Pavlovaceae	418969	Haptophyta	other_Eukaryota	283	4.53e-72	NTclustered	gi\|456061976\|ref\|NC_020371.1\|	2081491	g139855	i0	98.742	30.1746987951807	159	2	96	0	8	166	556	714	Pavlova lutheri chloroplast, complete genome	blastn	5009	283	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
22829057	22829057	PRJNA630162_P_NODE_86378_length_194_cov_7.241379_g84855_i0	PRJNA630162	86378	194	7.241379	14.04827526	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	351	1.47e-92	NTclustered	gi\|408717423\|gb\|JX453462.1\|	171259	g84855	i0	100	86.8865979381443	190	0	98	0	5	194	121	310	Uncultured haptophyte clone Finsevatn_8912 18S ribosomal RNA gene, partial sequence	blastn	16856	351	1	Eukaryota	Haptista	Haptophyta					Haptophyta environmental samples

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