metadata: contig_metadata: 8 rows where bioproject = "PRJEB14664", tax_clade = "Haptista" and tax

8 rows where bioproject = "PRJEB14664", 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
8638826	8638826	PRJEB14664_P_NODE_14967_length_183_cov_1.493243_g14837_i0	PRJEB14664	14967	183	1.493243	2.73263469	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	112	5.410000000000001e-27	NR	KAG8468860.1	2081491	g14837	i0	86.9	11	61	8	100	0	183	1	343	403	KAG8468860.1 hypothetical protein KFE25_007378 [Diacronema lutheri]	diamond	2013	112	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
11189106	11189106	PRJEB14664_P_NODE_3529_length_475_cov_1.981818_g3405_i0	PRJEB14664	3529	475	1.981818	9.4136355	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	199	1.8e-59	NR	KAL1530215.1	97485	g3405	i0	59.1	7.02947368421053	159	62	98.5	2	475	8	36	194	KAL1530215.1 hypothetical protein AB1Y20_001130 [Prymnesium parvum]	diamond	3339	199	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
16598091	16598091	PRJEB14664_P_NODE_4494_length_409_cov_2.425134_g4366_i0	PRJEB14664	4494	409	2.425134	9.91879806	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	254	1.35e-84	NR	KAL1520798.1	97485	g4366	i0	87.3	40.2909535452323	134	17	98.3	0	6	407	1	134	KAL1520798.1 hypothetical protein AB1Y20_022362 [Prymnesium parvum]	diamond	16479	256	0.9921875	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
27627161	27627161	PRJEB14664_P_NODE_13684_length_194_cov_2.012579_g13554_i0	PRJEB14664	13684	194	2.012579	3.90440326	Prymnesiales	73028	Haptophyta	other_Eukaryota	62.8	1.2e-10	NR	KAL1521143.1	97485	g13554	i0	65.5	1.79381443298969	58	19	88.1	1	24	194	5	62	KAL1521143.1 hypothetical protein AB1Y20_022697 [Prymnesium parvum]	diamond	348	63.2	0.993670886075949	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
27722123	27722123	PRJEB14664_P_NODE_11804_length_215_cov_1.972222_g11674_i0	PRJEB14664	11804	215	1.972222	4.2402773	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	87	5.53e-18	NR	XP_005759595.1	280463	g11674	i0	62.7	4.08837209302326	59	22	82.3	0	37	213	192	250	XP_005759595.1 von Willebrand factor type A domain-containing protein [Emiliania huxleyi CCMP1516]	diamond	879	87.8	0.990888382687927	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
29521402	29521402	PRJEB14664_P_NODE_19770_length_153_cov_0.898305_g19640_i0	PRJEB14664	19770	153	0.898305	1.37440665	Diacronema	70451	Haptophyta	other_Eukaryota	63.2	7.03e-11	NR	KAJ1633966.1	483367	g19640	i0	64	4.90196078431373	50	18	98	0	2	151	49	98	KAJ1633966.1 ribosomal protein rps12 [Pavlovales sp. CCMP2436]	diamond	750	63.2	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
29559225	29559225	PRJEB14664_P_NODE_16610_length_171_cov_1.161765_g16480_i0	PRJEB14664	16610	171	1.161765	1.98661815	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	51.6	4.53e-6	NR	KAG8460699.1	2081491	g16480	i0	57.1	0.736842105263158	42	17	73.7	1	157	32	134	174	KAG8460699.1 hypothetical protein KFE25_011474 [Diacronema lutheri]	diamond	126	51.6	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
32807932	32807932	PRJEB14664_P_NODE_15480_length_179_cov_1.631944_g15350_i0	PRJEB14664	15480	179	1.631944	2.92117976	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	81.3	4.18e-16	NR	KAL1526066.1	97485	g15350	i0	66.1	5.64804469273743	56	19	93.9	0	9	176	477	532	KAL1526066.1 hypothetical protein AB1Y20_020887 [Prymnesium parvum]	diamond	1011	81.3	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum

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