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

9 rows where bioproject = "PRJNA478247" 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
15750413	15750413	PRJNA478247_P_NODE_2213_length_228_cov_1.582915_g2107_i0	PRJNA478247	2213	228	1.582915	3.6090462	Raphidocystis contractilis	2792838	Root_unresolved	Root_unresolved	114	1.48e-27	NR	BBB87256.1	2792838	g2107	i0	82.7	0.986842105263158	75	13	98.7	0	225	1	594	668	BBB87256.1 major vault protein [Raphidocystis contractilis]	diamond	225	114	1	Eukaryota	Haptista		Centroplasthelida	Acanthocystida	Raphidocystidae	Raphidocystis	Raphidocystis contractilis
27155178	27155178	PRJNA478247_P_NODE_3142_length_170_cov_2.921986_g3036_i0	PRJNA478247	3142	170	2.921986	4.9673762	Viridiplantae	33090	Haptophyta	other_Eukaryota	87	1.8e-19	NR	KAG8464833.1	2081491	g3036	i0	84.8	18.0352941176471	46	7	81.2	0	140	3	1	46	KAG8464833.1 hypothetical protein KFE25_010201 [Diacronema lutheri]	diamond	3066	87	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
28655381	28655381	PRJNA478247_P_NODE_1987_length_248_cov_1.470320_g1881_i0	PRJNA478247	1987	248	1.47032	3.6463936	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	92.4	9.78e-21	NR	KOO35749.1	1460289	g1881	i0	62.2	0.991935483870968	82	29	99.2	1	248	3	36	115	KOO35749.1 40s ribosomal protein s6-like protein [Chrysochromulina tobinii]	diamond	246	92.4	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
28844559	28844559	PRJNA478247_P_NODE_1908_length_254_cov_1.773333_g1802_i0	PRJNA478247	1908	254	1.773333	4.50426582	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	90.5	3.3e-19	NR	KAL1519359.1	97485	g1802	i0	53.6	0.992125984251969	84	32	93.3	3	1	237	291	372	KAL1519359.1 hypothetical protein AB1Y20_022885 [Prymnesium parvum]	diamond	252	90.5	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
30802935	30802935	PRJNA478247_P_NODE_1154_length_368_cov_6.699115_g1048_i0	PRJNA478247	1154	368	6.699115	24.6527432	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	62	2.24e-8	NR	KOO30387.1	1460289	g1048	i0	55.2	2.77989130434783	58	25	46.5	1	265	95	20	77	KOO30387.1 papain family cysteine protease containing protein [Chrysochromulina tobinii]	diamond	1023	62	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
31103296	31103296	PRJNA478247_P_NODE_3475_length_155_cov_4.349206_g3369_i0	PRJNA478247	3475	155	4.349206	6.7412693	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	50.4	6.87e-6	NR	XP_005793277.1	280463	g3369	i0	57.5	6.01935483870968	40	17	77.4	0	34	153	2	41	XP_005793277.1 hypothetical protein EMIHUDRAFT_439486, partial [Emiliania huxleyi CCMP1516]	diamond	933	50.4	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
31672562	31672562	PRJNA478247_P_NODE_457_length_678_cov_2.872111_g246_i1	PRJNA478247	457	678	2.872111	19.47291258	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	285	4.1e-93	NR	KAL1524389.1	97485	g246	i1	72.2	6.92477876106195	223	59	98.7	2	678	10	58	277	KAL1524389.1 hypothetical protein AB1Y20_019284 [Prymnesium parvum]	diamond	4695	285	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
32099380	32099380	PRJNA478247_P_NODE_1298_length_339_cov_1.680645_g1192_i0	PRJNA478247	1298	339	1.680645	5.69738655	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	154	5.5599999999999984e-43	NR	XP_005776741.1	280463	g1192	i0	61.1	2	113	36	92.9	2	319	5	24	136	XP_005776741.1 hypothetical protein EMIHUDRAFT_457782 [Emiliania huxleyi CCMP1516]	diamond	678	154	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
32825940	32825940	PRJNA478247_P_NODE_2120_length_235_cov_2.951456_g2014_i0	PRJNA478247	2120	235	2.951456	6.9359216	Raphidocystis contractilis	2792838	Root_unresolved	Root_unresolved	75.9	7e-14	NR	BBB87256.1	2792838	g2014	i0	52.2	4.3531914893617	69	33	88.1	0	209	3	742	810	BBB87256.1 major vault protein [Raphidocystis contractilis]	diamond	1023	76.3	0.99475753604194	Eukaryota	Haptista		Centroplasthelida	Acanthocystida	Raphidocystidae	Raphidocystis	Raphidocystis contractilis

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