metadata: contig_metadata: 11 rows where bioproject = "PRJNA169559" and tax

11 rows where bioproject = "PRJNA169559" 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
1639906	1639906	PRJNA169559_P_NODE_4562_length_793_cov_2.099476_g3297_i0	PRJNA169559	4562	793	2.099476	16.64884468	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	56.5	0.006	NTclustered	gi\|551612603\|ref\|XM_005787267.1\|	280463	g3297	i0	96.97	0.0416141235813367	33	1	4	0	18	50	183	151	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	33	56.5	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
8018367	8018367	PRJNA169559_P_NODE_30407_length_263_cov_1.952991_g28331_i0	PRJNA169559	30407	263	1.952991	5.13636633	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	69.4	2.38e-7	NTclustered	gi\|551544733\|ref\|XM_005760352.1\|	280463	g28331	i0	97.5	1.31939163498099	40	1	15	0	1	40	411	450	Emiliania huxleyi CCMP1516 uracil phosphoribosyltransferase mRNA	blastn	347	69.4	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
9293098	9293098	PRJNA169559_P_NODE_2688_length_1008_cov_8.106231_g1744_i0	PRJNA169559	2688	1008	8.106231	81.71080848	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	440	1.8699999999999994e-118	NTclustered	gi\|551555706\|ref\|XM_005764956.1\|	280463	g1744	i0	76.143	15.8214285714286	897	181	88	27	20	901	1077	199	Emiliania huxleyi CCMP1516 mitochondrial carrier protein mRNA	blastn	15948	440	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
11258091	11258091	PRJNA169559_P_NODE_9369_length_555_cov_5.728137_g7658_i0	PRJNA169559	9369	555	5.728137	31.79116035	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	228	9.45e-73	NR	KOO26384.1	1460289	g7658	i0	61.9	3.81621621621622	181	68	97.3	1	547	8	30	210	KOO26384.1 peptidyl-prolyl cis-trans isomerase [Chrysochromulina tobinii]	diamond	2118	228	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
20180850	20180850	PRJNA169559_P_NODE_10856_length_512_cov_3.573499_g9061_i0	PRJNA169559	10856	512	3.573499	18.29631488	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	119	3.2399999999999996e-31	NR	XP_005765065.1	280463	g9061	i0	55.6	3.486328125	117	47	68	2	418	71	7	119	XP_005765065.1 hypothetical protein EMIHUDRAFT_416466 [Emiliania huxleyi CCMP1516]	diamond	1785	119	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
22041468	22041468	PRJNA169559_P_NODE_14258_length_445_cov_2.504808_g12331_i0	PRJNA169559	14258	445	2.504808	11.1463956	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	159	2.47e-34	NTclustered	gi\|551586694\|ref\|XM_005778339.1\|	280463	g12331	i0	77.586	41.9910112359551	290	48	64	15	149	431	1086	1365	Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA	blastn	18686	159	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
28273936	28273936	PRJNA169559_P_NODE_666_length_2054_cov_5.495802_g308_i0	PRJNA169559	666	2054	5.495802	112.88377308	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	137	1.7499999999999998e-30	NR	XP_005759595.1	280463	g308	i0	32.8	0.454235637779942	311	173	44.4	7	1077	1988	159	440	XP_005759595.1 von Willebrand factor type A domain-containing protein [Emiliania huxleyi CCMP1516]	diamond	933	137	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
28652996	28652996	PRJNA169559_P_NODE_48307_length_161_cov_1.643939_g46230_i0	PRJNA169559	48307	161	1.643939	2.64674179	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	62	1.94e-9	NR	KAG8466765.1	2081491	g46230	i0	49.1	0.987577639751553	53	27	98.8	0	159	1	200	252	KAG8466765.1 hypothetical protein KFE25_008144 [Diacronema lutheri]	diamond	159	62	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
29568542	29568542	PRJNA169559_P_NODE_20310_length_368_cov_16.820059_g18267_i0	PRJNA169559	20310	368	16.820059	61.89781712	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	93.6	6.91e-22	NR	XP_005782836.1	280463	g18267	i0	51	6.70923913043478	102	46	82.3	2	18	320	16	114	XP_005782836.1 hypothetical protein EMIHUDRAFT_442529 [Emiliania huxleyi CCMP1516]	diamond	2469	93.6	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
29631467	29631467	PRJNA169559_P_NODE_44630_length_219_cov_1.984211_g42553_i0	PRJNA169559	44630	219	1.984211	4.34542209	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	72	1.35e-12	NR	KAL1526066.1	97485	g42553	i0	45.8	1.13698630136986	83	29	91.8	1	13	213	788	870	KAL1526066.1 hypothetical protein AB1Y20_020887 [Prymnesium parvum]	diamond	249	72	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
32697466	32697466	PRJNA169559_P_NODE_14340_length_444_cov_2.320482_g12411_i0	PRJNA169559	14340	444	2.320482	10.30294008	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	200	1.89e-60	NR	XP_005776995.1	280463	g12411	i0	66.2	5.39189189189189	133	45	89.9	0	2	400	231	363	XP_005776995.1 hypothetical protein EMIHUDRAFT_427101 [Emiliania huxleyi CCMP1516]	diamond	2394	200	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);;