metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA169559" and tax

7 rows where analysis = "diamond", 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
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
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);;