metadata: contig_metadata: 9 rows where bioproject = "PRJNA1158727", tax_clade = "Haptista" and tax

9 rows where bioproject = "PRJNA1158727", 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
4130064	4130064	PRJNA1158727_P_NODE_103924_length_287_cov_1.439252_g96463_i0	PRJNA1158727	103924	287	1.439252	4.13065324	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	110	6.09e-29	NR	KAG8469654.1	2081491	g96463	i0	64.9	0.982578397212544	94	33	98.3	0	6	287	8	101	KAG8469654.1 hypothetical protein KFE25_006109 [Diacronema lutheri]	diamond	282	110	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
19431687	19431687	PRJNA1158727_P_NODE_51536_length_487_cov_1.188406_g44079_i0	PRJNA1158727	51536	487	1.188406	5.78753722	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	92.4	8.82e-21	NR	KAL1508698.1	97485	g44079	i0	53	2.1006160164271	83	39	51.1	0	1	249	30	112	KAL1508698.1 hypothetical protein AB1Y20_004793 [Prymnesium parvum]	diamond	1023	92.4	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
20705786	20705786	PRJNA1158727_P_NODE_163217_length_241_cov_0.916667_g155755_i0	PRJNA1158727	163217	241	0.916667	2.20916747	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	117	9.13e-31	NR	KAL1511153.1	97485	g155755	i0	75.9	9.82157676348548	79	18	97.1	1	239	6	99	177	KAL1511153.1 hypothetical protein AB1Y20_005971 [Prymnesium parvum]	diamond	2367	118	0.991525423728814	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
20708151	20708151	PRJNA1158727_P_NODE_92197_length_309_cov_1.161017_g84736_i0	PRJNA1158727	92197	309	1.161017	3.58754253	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	155	1.94e-45	NR	KAG8463376.1	2081491	g84736	i0	68.7	0.961165048543689	99	31	96.1	0	12	308	34	132	KAG8463376.1 hypothetical protein KFE25_004887 [Diacronema lutheri]	diamond	297	155	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
21982638	21982638	PRJNA1158727_P_NODE_56678_length_447_cov_1.529412_g49218_i0	PRJNA1158727	56678	447	1.529412	6.83647164	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	224	2.76e-70	NR	KOO23867.1	1460289	g49218	i0	70.3	0.973154362416107	145	43	97.3	0	442	8	125	269	KOO23867.1 alteRNAtive oxidase [Chrysochromulina tobinii]	diamond	435	224	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
28777168	28777168	PRJNA1158727_P_NODE_140947_length_249_cov_0.875000_g133485_i0	PRJNA1158727	140947	249	0.875	2.17875	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	44.3	0.0113	NR	XP_005787110.1	280463	g133485	i0	44.3	0.951807228915663	79	33	95.2	4	1	237	292	359	XP_005787110.1 hypothetical protein EMIHUDRAFT_425634 [Emiliania huxleyi CCMP1516]	diamond	237	44.3	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
30786411	30786411	PRJNA1158727_P_NODE_108714_length_281_cov_1.461538_g101253_i0	PRJNA1158727	108714	281	1.461538	4.10692178	Prymnesium	35143	Haptophyta	other_Eukaryota	102	2.51e-23	NR	KAL1495267.1	97485	g101253	i0	59	1.81494661921708	78	32	83.3	0	3	236	111	188	KAL1495267.1 hypothetical protein AB1Y20_017127 [Prymnesium parvum]	diamond	510	103	0.990291262135922	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
30893573	30893573	PRJNA1158727_P_NODE_67194_length_387_cov_0.980892_g59733_i0	PRJNA1158727	67194	387	0.980892	3.79605204	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	65.1	2.76e-9	NR	XP_005780827.1	280463	g59733	i0	33.9	0.984496124031008	127	71	93.8	5	3	365	78	197	XP_005780827.1 hypothetical protein EMIHUDRAFT_449972 [Emiliania huxleyi CCMP1516]	diamond	381	65.1	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
31810326	31810326	PRJNA1158727_P_NODE_116977_length_271_cov_1.202020_g109516_i0	PRJNA1158727	116977	271	1.20202	3.2574742	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	69.7	1.73e-11	NR	KAG8468614.1	2081491	g109516	i0	50.7	1.48339483394834	69	34	76.4	0	8	214	419	487	KAG8468614.1 hypothetical protein KFE25_013697 [Diacronema lutheri]	diamond	402	69.7	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri

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