metadata: contig_metadata: 14 rows where bioproject = "PRJNA1120060", tax_clade = "Haptista" and tax

14 rows where bioproject = "PRJNA1120060", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"

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
1538371	1538371	PRJNA1120060_P_NODE_3516762_length_205_cov_6.037879_g3498636_i0	PRJNA1120060	3516762	205	6.037879	12.37765195	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	52.8	0.018	NTclustered	gi\|551622197\|ref\|XM_005791430.1\|	280463	g3498636	i0	100	0.136585365853659	28	0	14	0	78	105	98	125	Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA	blastn	28	52.8	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
14275291	14275291	PRJNA1120060_P_NODE_2038012_length_271_cov_2.181818_g2019975_i0	PRJNA1120060	2038012	271	2.181818	5.91272678	Phaeocystis globosa	33658	Haptophyta	other_Eukaryota	52.8	0.025	NTclustered	gi\|1983803697\|gb\|MT471327.1\|	33658	g2019975	i0	100	0.929889298892989	28	0	10	0	66	93	90566	90539	Phaeocystis globosa strain CNS00066 chloroplast, complete genome	blastn	252	52.8	1	Eukaryota	Haptista	Haptophyta		Phaeocystales	Phaeocystaceae	Phaeocystis	Phaeocystis globosa
21912672	21912672	PRJNA1120060_P_NODE_1289618_length_307_cov_3.854701_g1271671_i0	PRJNA1120060	1289618	307	3.854701	11.83393207	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	56.5	0.002	NTclustered	gi\|112132264\|gb\|DQ658307.1\|	2903	g1271671	i0	100	0.0977198697068404	30	0	10	0	162	191	224	253	Emiliania huxleyi clone Plate1_K09_compl;77-2-12-B04 mRNA sequence	blastn	30	56.5	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
24458685	24458685	PRJNA1120060_P_NODE_107320_length_558_cov_2.927835_g92571_i0	PRJNA1120060	107320	558	2.927835	16.3373193	root	1	Root_unresolved	Root_unresolved	256	1.74e-76	NR	KAL1495697.1	97485	g92571	i0	80	23.0752688172043	160	30	84.9	1	6	479	727	886	KAL1495697.1 hypothetical protein AB1Y20_016560 [Prymnesium parvum]	diamond	12876	258	0.992248062015504	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
27217017	27217017	PRJNA1120060_P_NODE_2865962_length_244_cov_3.087719_g2847873_i0	PRJNA1120060	2865962	244	3.087719	7.53403436	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	138	4.75e-39	NR	KAJ1640026.1	483367	g2847873	i0	78.8	2.95081967213115	80	17	98.4	0	5	244	59	138	KAJ1640026.1 glutamine synthetase type III N terminal-domain-containing protein [Pavlovales sp. CCMP2436]	diamond	720	138	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
27606754	27606754	PRJNA1120060_P_NODE_3143464_length_234_cov_2.546584_g3125360_i0	PRJNA1120060	3143464	234	2.546584	5.95900656	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	49.3	1.6e-4	NR	KAG8460324.1	2081491	g3125360	i0	39.7	0.871794871794872	68	41	87.2	0	9	212	572	639	KAG8460324.1 hypothetical protein KFE25_011815 [Diacronema lutheri]	diamond	204	49.3	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
28985947	28985947	PRJNA1120060_P_NODE_775508_length_323_cov_3.760000_g757639_i0	PRJNA1120060	775508	323	3.76	12.1448	root	1	Root_unresolved	Root_unresolved	59.7	1.1e-7	NR	KAL1495704.1	97485	g757639	i0	62.5	4.36532507739938	40	15	37.2	0	12	131	515	554	KAL1495704.1 hypothetical protein AB1Y20_016567 [Prymnesium parvum]	diamond	1410	59.7	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
30226148	30226148	PRJNA1120060_P_NODE_1238892_length_309_cov_4.372881_g1220951_i0	PRJNA1120060	1238892	309	4.372881	13.51220229	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	55.5	2.86e-6	NR	XP_005770079.1	280463	g1220951	i0	52.5	2.83495145631068	59	28	57.3	0	24	200	1637	1695	XP_005770079.1 hypothetical protein EMIHUDRAFT_118474 [Emiliania huxleyi CCMP1516]	diamond	876	55.5	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
30449127	30449127	PRJNA1120060_P_NODE_404353_length_388_cov_1.320635_g386931_i0	PRJNA1120060	404353	388	1.320635	5.1240638	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	116	2.14e-28	NR	KOO23867.1	1460289	g386931	i0	68.1	3.56443298969072	72	23	55.7	0	387	172	250	321	KOO23867.1 alteRNAtive oxidase [Chrysochromulina tobinii]	diamond	1383	116	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
31237844	31237844	PRJNA1120060_P_NODE_2276255_length_262_cov_1.666667_g2258200_i0	PRJNA1120060	2276255	262	1.666667	4.36666754	Pavlovales sp. CCMP2436	483367	Haptophyta	other_Eukaryota	42.7	0.0455	NR	KAJ1622076.1	483367	g2258200	i0	45.5	0.755725190839695	66	33	73.3	2	218	27	57	121	KAJ1622076.1 hypothetical protein T492DRAFT_885896, partial [Pavlovales sp. CCMP2436]	diamond	198	42.7	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
31364605	31364605	PRJNA1120060_P_NODE_221896_length_455_cov_3.424084_g205259_i0	PRJNA1120060	221896	455	3.424084	15.5795822	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	46.2	0.0177	NR	XP_005779120.1	280463	g205259	i0	38.3	0.30989010989011	47	28	30.3	1	197	334	99	145	XP_005779120.1 hypothetical protein EMIHUDRAFT_443392 [Emiliania huxleyi CCMP1516]	diamond	141	46.2	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
31491128	31491128	PRJNA1120060_P_NODE_2140916_length_267_cov_2.180412_g2122870_i0	PRJNA1120060	2140916	267	2.180412	5.82170004	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	147	7.28e-39	NR	KAG8468248.1	2081491	g2122870	i0	81.8	2.96629213483146	88	16	98.9	0	2	265	124	211	KAG8468248.1 hypothetical protein KFE25_013331 [Diacronema lutheri]	diamond	792	147	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
32156205	32156205	PRJNA1120060_P_NODE_3397498_length_216_cov_6.167832_g3379378_i0	PRJNA1120060	3397498	216	6.167832	13.32251712	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	43.1	0.0185	NR	KAL1498636.1	97485	g3379378	i0	40	0.833333333333333	60	27	70.8	2	200	48	117	176	KAL1498636.1 hypothetical protein AB1Y20_013949 [Prymnesium parvum]	diamond	180	43.1	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
32376191	32376191	PRJNA1120060_P_NODE_1152179_length_311_cov_2.352941_g1134244_i0	PRJNA1120060	1152179	311	2.352941	7.31764651	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	67	2.47e-10	NR	XP_005769679.1	280463	g1134244	i0	36.4	3.09646302250804	107	58	97.4	2	305	3	369	471	XP_005769679.1 glycosyltransferase, family 8 [Emiliania huxleyi CCMP1516]	diamond	963	67	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);;