metadata: contig_metadata: 11 rows where bioproject = "PRJNA1136505", tax_phylum = "Haptophyta" and tax

11 rows where bioproject = "PRJNA1136505", tax_phylum = "Haptophyta" 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
7937579	7937579	PRJNA1136505_P_NODE_98887_length_290_cov_1.115207_g92027_i0	PRJNA1136505	98887	290	1.115207	3.2341003	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	154	7.160000000000001e-33	NTclustered	gi\|551628172\|ref\|XM_005794010.1\|	280463	g92027	i0	77.992	4.16206896551724	259	47	88	8	8	261	266	13	Emiliania huxleyi CCMP1516 proteasome subunit alpha type partial mRNA	blastn	1207	154	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
14313418	14313418	PRJNA1136505_P_NODE_145392_length_245_cov_0.895349_g138532_i0	PRJNA1136505	145392	245	0.895349	2.19360505	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	130	3.68e-33	NR	KAL1504608.1	97485	g138532	i0	84.2	159.6	76	12	93.1	0	2	229	321	396	KAL1504608.1 hypothetical protein AB1Y20_008392 [Prymnesium parvum]	diamond	39102	130	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
20685902	20685902	PRJNA1136505_P_NODE_154257_length_241_cov_1.375000_g147397_i0	PRJNA1136505	154257	241	1.375	3.31375	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	220	5.62e-53	NTclustered	gi\|551614578\|ref\|XM_005788150.1\|	280463	g147397	i0	83.333	1.99585062240664	240	38	99	2	1	239	4127	3889	Emiliania huxleyi CCMP1516 acetyl-CoA carboxylase (ACC-2), mRNA	blastn	481	220	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
26975413	26975413	PRJNA1136505_P_NODE_120662_length_262_cov_1.428571_g113802_i0	PRJNA1136505	120662	262	1.428571	3.74285602	Prymnesium sp.	2812485	Haptophyta	other_Eukaryota	86.3	2.3e-17	NR	KAL3932124.1	2812485	g113802	i0	49.3	0.83587786259542	73	37	83.6	0	37	255	13	85	KAL3932124.1 MAG: hypothetical protein SGPRY_000829 [Prymnesium sp.]	diamond	219	86.3	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium sp.
27544352	27544352	PRJNA1136505_P_NODE_72904_length_344_cov_4.874539_g66044_i0	PRJNA1136505	72904	344	4.874539	16.76841416	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	51.6	1.67e-5	NR	KAG8458568.1	2081491	g66044	i0	32.6	0.75	86	52	70.6	2	344	102	26	110	KAG8458568.1 hypothetical protein KFE25_003103 [Diacronema lutheri]	diamond	258	51.6	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
27734077	27734077	PRJNA1136505_P_NODE_115004_length_269_cov_1.224490_g108144_i0	PRJNA1136505	115004	269	1.22449	3.2938781	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	57.8	2.62e-7	NR	KAL1528391.1	97485	g108144	i0	41.4	1.10408921933085	99	42	92.6	4	254	6	605	703	KAL1528391.1 hypothetical protein AB1Y20_009741 [Prymnesium parvum]	diamond	297	57.8	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
29501799	29501799	PRJNA1136505_P_NODE_56890_length_403_cov_2.393939_g50030_i0	PRJNA1136505	56890	403	2.393939	9.64757417	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	118	6.389999999999999e-31	NR	XP_005788845.1	280463	g50030	i0	50.4	0.915632754342432	123	61	91.6	0	369	1	29	151	XP_005788845.1 hypothetical protein EMIHUDRAFT_455093 [Emiliania huxleyi CCMP1516]	diamond	369	118	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
29849314	29849314	PRJNA1136505_P_NODE_61171_length_384_cov_1.485531_g54311_i0	PRJNA1136505	61171	384	1.485531	5.70443904	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	107	1.41e-25	NR	KAG8467162.1	2081491	g54311	i0	49.2	3.078125	132	61	99.2	4	3	383	27	157	KAG8467162.1 hypothetical protein KFE25_000478 [Diacronema lutheri]	diamond	1182	107	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
30038751	30038751	PRJNA1136505_P_NODE_67031_length_363_cov_0.917241_g60171_i0	PRJNA1136505	67031	363	0.917241	3.32958483	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	77.4	1.08e-13	NR	XP_005788682.1	280463	g60171	i0	39.8	0.933884297520661	113	66	93.4	2	23	361	460	570	XP_005788682.1 hypothetical protein EMIHUDRAFT_110305 [Emiliania huxleyi CCMP1516]	diamond	339	77.4	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
31892700	31892700	PRJNA1136505_P_NODE_127917_length_253_cov_1.616667_g121057_i0	PRJNA1136505	127917	253	1.616667	4.09016751	Diacronema	70451	Haptophyta	other_Eukaryota	58.2	1.49e-7	NR	KAJ1633252.1	483367	g121057	i0	37.3	1.96837944664032	83	52	98.4	0	3	251	350	432	KAJ1633252.1 lung seven transmembrane receptor-domain-containing protein [Pavlovales sp. CCMP2436]	diamond	498	58.5	0.994871794871795	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
32599684	32599684	PRJNA1136505_P_NODE_28620_length_741_cov_1.520958_g21945_i0	PRJNA1136505	28620	741	1.520958	11.27029878	Pavlovales sp. CCMP2436	483367	Haptophyta	other_Eukaryota	98.2	1.96e-19	NR	KAJ1633252.1	483367	g21945	i0	28.8	1.05263157894737	260	154	99.2	11	6	740	19	262	KAJ1633252.1 lung seven transmembrane receptor-domain-containing protein [Pavlovales sp. CCMP2436]	diamond	780	98.2	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436

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