metadata: contig_metadata: 12 rows where bioproject = "PRJEB43370", tax_clade = "Haptista" and tax

12 rows where bioproject = "PRJEB43370", 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
8643090	8643090	PRJEB43370_P_NODE_8827_length_166_cov_0.888889_g8784_i0	PRJEB43370	8827	166	0.888889	1.47555574	Viridiplantae	33090	Haptophyta	other_Eukaryota	115	1.75e-21	NTclustered	gi\|551555706\|ref\|XM_005764956.1\|	280463	g8784	i0	86.538	6.17469879518072	104	14	63	0	44	147	481	584	Emiliania huxleyi CCMP1516 mitochondrial carrier protein mRNA	blastn	1025	115	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
8987301	8987301	PRJEB43370_P_NODE_2088_length_301_cov_1.238095_g2045_i0	PRJEB43370	2088	301	1.238095	3.72666595	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	117	9.52e-32	NR	KAG8469654.1	2081491	g2045	i0	66	1.96345514950166	97	33	96.7	0	292	2	8	104	KAG8469654.1 hypothetical protein KFE25_006109 [Diacronema lutheri]	diamond	591	117	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
27469342	27469342	PRJEB43370_P_NODE_1963_length_310_cov_3.574713_g1920_i0	PRJEB43370	1963	310	3.574713	11.0816103	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	79.3	1.39e-16	NR	XP_005782836.1	280463	g1920	i0	49.5	5.62258064516129	93	43	89	2	283	8	20	109	XP_005782836.1 hypothetical protein EMIHUDRAFT_442529 [Emiliania huxleyi CCMP1516]	diamond	1743	79.3	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
27658838	27658838	PRJEB43370_P_NODE_2984_length_251_cov_2.683168_g2941_i0	PRJEB43370	2984	251	2.683168	6.73475168	Diacronema	70451	Haptophyta	other_Eukaryota	104	3.18e-26	NR	KAJ1641330.1	483367	g2941	i0	60.3	1.86454183266932	78	31	93.2	0	234	1	19	96	KAJ1641330.1 40S ribosomal protein S19 like [Pavlovales sp. CCMP2436]	diamond	468	105	0.990476190476191	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
29970265	29970265	PRJEB43370_P_NODE_1571_length_350_cov_1.554817_g1528_i0	PRJEB43370	1571	350	1.554817	5.4418595	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	112	4.68e-26	NR	XP_005764058.1	280463	g1528	i0	52.1	3.04285714285714	117	53	97.7	2	2	343	492	608	XP_005764058.1 hypothetical protein EMIHUDRAFT_214491 [Emiliania huxleyi CCMP1516]	diamond	1065	112	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
30127973	30127973	PRJEB43370_P_NODE_4272_length_216_cov_0.934132_g4229_i0	PRJEB43370	4272	216	0.934132	2.01772512	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	95.5	1e-21	NR	KAL1528863.1	97485	g4229	i0	56.9	1	72	29	97.2	1	5	214	186	257	KAL1528863.1 hypothetical protein AB1Y20_010186 [Prymnesium parvum]	diamond	216	95.5	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
30570320	30570320	PRJEB43370_P_NODE_10973_length_162_cov_0.920354_g10930_i0	PRJEB43370	10973	162	0.920354	1.49097348	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	46.2	7.36e-4	NR	KOO33504.1	1460289	g10930	i0	47.1	0.944444444444444	51	27	94.4	0	2	154	777	827	KOO33504.1 NAD mitochondrial [Chrysochromulina tobinii]	diamond	153	46.2	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
30570326	30570326	PRJEB43370_P_NODE_3193_length_244_cov_1.482051_g3150_i0	PRJEB43370	3193	244	1.482051	3.61620444	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	118	1.14e-28	NR	KAL1521978.1	97485	g3150	i0	66.7	10.5491803278689	78	26	95.9	0	8	241	2720	2797	KAL1521978.1 hypothetical protein AB1Y20_021623 [Prymnesium parvum]	diamond	2574	118	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
31163935	31163935	PRJEB43370_P_NODE_9375_length_165_cov_0.896552_g9332_i0	PRJEB43370	9375	165	0.896552	1.4793108	Prymnesiales	73028	Haptophyta	other_Eukaryota	74.3	9.15e-14	NR	KAL1503510.1	97485	g9332	i0	73.5	4.63636363636364	49	13	89.1	0	164	18	151	199	KAL1503510.1 hypothetical protein AB1Y20_011990 [Prymnesium parvum]	diamond	765	74.3	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
32214870	32214870	PRJEB43370_P_NODE_10458_length_163_cov_0.912281_g10415_i0	PRJEB43370	10458	163	0.912281	1.48701803	Prymnesium sp.	2812485	Haptophyta	other_Eukaryota	54.3	1.01e-6	NR	KAL3922856.1	2812485	g10415	i0	50.9	0.975460122699387	53	25	95.7	1	161	6	500	552	KAL3922856.1 MAG: hypothetical protein SGPRY_004412 [Prymnesium sp.]	diamond	159	54.3	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium sp.
32310011	32310011	PRJEB43370_P_NODE_10479_length_163_cov_0.912281_g10436_i0	PRJEB43370	10479	163	0.912281	1.48701803	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	48.9	8.51e-5	NR	KAL1495644.1	97485	g10436	i0	42.6	0.993865030674847	54	30	99.4	1	1	162	291	343	KAL1495644.1 hypothetical protein AB1Y20_016511 [Prymnesium parvum]	diamond	162	48.9	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
32468153	32468153	PRJEB43370_P_NODE_10179_length_163_cov_0.912281_g10136_i0	PRJEB43370	10179	163	0.912281	1.48701803	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	57.8	6.03e-8	NR	KOO32670.1	1460289	g10136	i0	65.3	0.901840490797546	49	17	90.2	0	15	161	16	64	KOO32670.1 hypothetical protein Ctob_015428 [Chrysochromulina tobinii]	diamond	147	57.8	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii

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