metadata: contig_metadata: 9 rows where bioproject = "PRJNA1120771" and tax

9 rows where bioproject = "PRJNA1120771" and tax_clade = "Haptista"

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
4103777	4103777	PRJNA1120771_S_NODE_6044_length_401_cov_5.011173_g5644_i0	PRJNA1120771	6044	401	5.011173	20.09480373	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	146	2.2e-41	NR	KAL1508631.1	97485	g5644	i0	63.4	1.51870324189526	101	37	75.6	0	3	305	100	200	KAL1508631.1 hypothetical protein AB1Y20_004727 [Prymnesium parvum]	diamond	609	146	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
27438878	27438878	PRJNA1120771_S_NODE_12703_length_309_cov_1.308271_g12303_i0	PRJNA1120771	12703	309	1.308271	4.04255739	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	51.2	7.67e-5	NR	KAJ1626287.1	483367	g12303	i0	52.3	1.68932038834951	44	21	42.7	0	307	176	236	279	KAJ1626287.1 JAB1/Mov34/MPN/PAD-1 ubiquitin protease-domain-containing protein [Pavlovales sp. CCMP2436]	diamond	522	51.2	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
27670531	27670531	PRJNA1120771_S_NODE_13104_length_305_cov_3.729008_g12704_i0	PRJNA1120771	13104	305	3.729008	11.3734744	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	102	1.11e-22	NR	KOO24299.1	1460289	g12704	i0	55.9	2.62622950819672	93	37	91.5	1	1	279	172	260	KOO24299.1 large subunit gtpase 1-like protein [Chrysochromulina tobinii]	diamond	801	102	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
27848872	27848872	PRJNA1120771_S_NODE_24504_length_241_cov_3.075758_g24104_i0	PRJNA1120771	24504	241	3.075758	7.41257678	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	87	6.77e-18	NR	KAL1512318.1	97485	g24104	i0	55.6	4.43153526970954	72	32	89.6	0	1	216	336	407	KAL1512318.1 hypothetical protein AB1Y20_005580 [Prymnesium parvum]	diamond	1068	87.4	0.995423340961098	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
28049197	28049197	PRJNA1120771_S_NODE_18865_length_267_cov_1.941964_g18465_i0	PRJNA1120771	18865	267	1.941964	5.18504388	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	50.1	1.33e-4	NR	KAG8464070.1	2081491	g18465	i0	37.7	0.595505617977528	53	33	59.6	0	2	160	1179	1231	KAG8464070.1 hypothetical protein KFE25_000238 [Diacronema lutheri]	diamond	159	50.1	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
28354192	28354192	PRJNA1120771_S_NODE_17786_length_273_cov_2.647826_g17386_i0	PRJNA1120771	17786	273	2.647826	7.22856498	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	68.2	5.96e-11	NR	KAL1519368.1	97485	g17386	i0	51.5	2.81318681318681	68	26	74.7	1	2	205	251	311	KAL1519368.1 hypothetical protein AB1Y20_022894 [Prymnesium parvum]	diamond	768	68.2	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
31523963	31523963	PRJNA1120771_S_NODE_16356_length_282_cov_1.313808_g15956_i0	PRJNA1120771	16356	282	1.313808	3.70493856	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	53.1	1.26e-5	NR	XP_005762529.1	280463	g15956	i0	47.7	0.468085106382979	44	23	46.8	0	219	88	349	392	XP_005762529.1 hypothetical protein EMIHUDRAFT_120647 [Emiliania huxleyi CCMP1516]	diamond	132	53.1	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
32188233	32188233	PRJNA1120771_S_NODE_25578_length_237_cov_2.082474_g25178_i0	PRJNA1120771	25578	237	2.082474	4.93546338	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	68.6	2.81e-11	NR	KAG8466028.1	2081491	g25178	i0	75.6	0.518987341772152	41	10	51.9	0	12	134	4214	4254	KAG8466028.1 hypothetical protein KFE25_005598 [Diacronema lutheri]	diamond	123	68.6	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
32788124	32788124	PRJNA1120771_S_NODE_20220_length_260_cov_2.276498_g19820_i0	PRJNA1120771	20220	260	2.276498	5.9188948	Pavlovales sp. CCMP2436	483367	Haptophyta	other_Eukaryota	43.9	0.0174	NR	KAJ1629966.1	483367	g19820	i0	69.2	0.3	26	8	30	0	2	79	392	417	KAJ1629966.1 delta-5 desaturase [Pavlovales sp. CCMP2436]	diamond	78	43.9	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);;