metadata: contig_metadata: 7 rows where bioproject = "PRJNA345071" and tax

7 rows where bioproject = "PRJNA345071" 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
27769961	27769961	PRJNA345071_P_NODE_7704_length_253_cov_0.866667_g7664_i0	PRJNA345071	7704	253	0.866667	2.19266751	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	108	4.02e-25	NR	KOO30748.1	1460289	g7664	i0	56.6	0.984189723320158	83	36	98.4	0	252	4	545	627	KOO30748.1 glutamine catalytic domain protein [Chrysochromulina tobinii]	diamond	249	108	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
29253454	29253454	PRJNA345071_P_NODE_7169_length_258_cov_1.432432_g7129_i0	PRJNA345071	7169	258	1.432432	3.69567456	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	72.4	1.21e-12	NR	XP_005775431.1	280463	g7129	i0	43.2	2.02325581395349	88	45	96.5	1	10	258	94	181	XP_005775431.1 hypothetical protein EMIHUDRAFT_195508 [Emiliania huxleyi CCMP1516]	diamond	522	72.4	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
30200908	30200908	PRJNA345071_P_NODE_6792_length_263_cov_1.263158_g6752_i0	PRJNA345071	6792	263	1.263158	3.32210554	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	79	8.6e-15	NR	XP_005771754.1	280463	g6752	i0	47.4	1.7680608365019	78	40	87.8	1	13	243	94	171	XP_005771754.1 hypothetical protein EMIHUDRAFT_118001 [Emiliania huxleyi CCMP1516]	diamond	465	79	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
30801339	30801339	PRJNA345071_P_NODE_8154_length_251_cov_0.876404_g8114_i0	PRJNA345071	8154	251	0.876404	2.19977404	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	146	1.26e-39	NR	XP_005775299.1	280463	g8114	i0	86.6	0.9800796812749	82	11	98	0	248	3	179	260	XP_005775299.1 amidohydrolase [Emiliania huxleyi CCMP1516]	diamond	246	146	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
31608982	31608982	PRJNA345071_P_NODE_8636_length_249_cov_1.017045_g8596_i0	PRJNA345071	8636	249	1.017045	2.5324420499999998	Pavlovophyceae	3435358	Haptophyta	other_Eukaryota	115	1.35e-28	NR	KAG8469409.1	2081491	g8596	i0	63.9	2.89156626506024	83	30	100	0	249	1	36	118	KAG8469409.1 hypothetical protein KFE25_005864 [Diacronema lutheri]	diamond	720	115	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
32572727	32572727	PRJNA345071_P_NODE_10499_length_243_cov_0.917647_g10459_i0	PRJNA345071	10499	243	0.917647	2.22988221	Prymnesium sp.	2812485	Haptophyta	other_Eukaryota	50.8	1.67e-5	NR	KAL3929528.1	2812485	g10459	i0	40	0.617283950617284	50	30	61.7	0	93	242	3	52	KAL3929528.1 MAG: hypothetical protein SGPRY_001922 [Prymnesium sp.]	diamond	150	50.8	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium sp.
32761382	32761382	PRJNA345071_P_NODE_5180_length_287_cov_2.266355_g5140_i0	PRJNA345071	5180	287	2.266355	6.50443885	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	59.7	2.91e-8	NR	XP_005783668.1	280463	g5140	i0	63.2	0.397212543554007	38	14	39.7	0	143	30	52	89	XP_005783668.1 hypothetical protein EMIHUDRAFT_456383 [Emiliania huxleyi CCMP1516]	diamond	114	59.7	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi

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