metadata: contig_metadata: 6 rows where bioproject = "PRJNA599026", tax_clade = "Haptista" and tax

6 rows where bioproject = "PRJNA599026", 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
26731293	26731293	PRJNA599026_S_NODE_18241_length_241_cov_1.328125_g17785_i0	PRJNA599026	18241	241	1.328125	3.20078125	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	55.8	7.1e-7	NR	KAL1505065.1	97485	g17785	i0	50	0.622406639004149	50	23	61	2	151	5	193	241	KAL1505065.1 hypothetical protein AB1Y20_008825 [Prymnesium parvum]	diamond	150	55.8	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
26763344	26763344	PRJNA599026_S_NODE_26221_length_211_cov_2.086420_g25765_i0	PRJNA599026	26221	211	2.08642	4.4023462	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	46.2	0.00151	NR	KAL1525386.1	97485	g25765	i0	40.4	0.81042654028436	57	28	72.5	1	22	174	672	728	KAL1525386.1 hypothetical protein AB1Y20_020245 [Prymnesium parvum]	diamond	171	46.2	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
28766893	28766893	PRJNA599026_S_NODE_19187_length_236_cov_2.454545_g18731_i0	PRJNA599026	19187	236	2.454545	5.7927262	Cryptophyceae	3027	Haptophyta	other_Eukaryota	52.8	9.32e-6	NR	XP_005786475.1	280463	g18731	i0	64.9	3	37	13	47	0	97	207	243	279	XP_005786475.1 hypothetical protein EMIHUDRAFT_228899 [Emiliania huxleyi CCMP1516]	diamond	708	52.8	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
30711750	30711750	PRJNA599026_S_NODE_40914_length_180_cov_1.595420_g40458_i0	PRJNA599026	40914	180	1.59542	2.871756	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	67.8	1.11e-11	NR	XP_005778345.1	280463	g40458	i0	63	0.766666666666667	46	17	76.7	0	138	1	159	204	XP_005778345.1 hypothetical protein EMIHUDRAFT_443537 [Emiliania huxleyi CCMP1516]	diamond	138	67.8	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
31881421	31881421	PRJNA599026_S_NODE_57417_length_165_cov_0.879310_g56961_i0	PRJNA599026	57417	165	0.87931	1.4508615	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	65.9	9.09e-11	NR	KOO22122.1	1460289	g56961	i0	60.8	0.927272727272727	51	20	92.7	0	165	13	311	361	KOO22122.1 peptidase leucyl aminopeptidase domain-containing protein [Chrysochromulina tobinii]	diamond	153	65.9	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
32766417	32766417	PRJNA599026_S_NODE_11200_length_294_cov_1.538776_g10744_i0	PRJNA599026	11200	294	1.538776	4.52400144	Pavlovales sp. CCMP2436	483367	Haptophyta	other_Eukaryota	64.3	1.51e-9	NR	KAJ1630946.1	483367	g10744	i0	55.3	2.51020408163265	47	21	48	0	174	34	40	86	KAJ1630946.1 hypothetical protein T492DRAFT_613302, partial [Pavlovales sp. CCMP2436]	diamond	738	64.3	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);;