metadata: contig_metadata: 6 rows where bioproject = "PRJNA758088", tax_clade = "Haptista" and tax

6 rows where bioproject = "PRJNA758088", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"

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_order	tax_family	tax_genus	tax_species
27536776	27536776	PRJNA758088_P_NODE_169783_length_325_cov_1.222222_g162812_i0	PRJNA758088	169783	325	1.222222	3.9722215	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	139	4.28e-36	NR	XP_005770544.1	280463	g162812	i0	65.9	3.63692307692308	91	31	84	0	51	323	278	368	XP_005770544.1 hypothetical protein EMIHUDRAFT_461333 [Emiliania huxleyi CCMP1516]	diamond	1182	139	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
27968972	27968972	PRJNA758088_P_NODE_363005_length_241_cov_0.916667_g356034_i0	PRJNA758088	363005	241	0.916667	2.20916747	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	151	2.23e-44	NR	KAL1495828.1	97485	g356034	i0	86.3	3.97095435684647	80	11	99.6	0	240	1	35	114	KAL1495828.1 hypothetical protein AB1Y20_016688 [Prymnesium parvum]	diamond	957	151	1	Eukaryota	Haptista	Haptophyta	Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
31285178	31285178	PRJNA758088_P_NODE_166915_length_328_cov_0.854902_g159944_i0	PRJNA758088	166915	328	0.854902	2.80407856	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	183	1.04e-54	NR	KAL1521758.1	97485	g159944	i0	73.4	0.996951219512195	109	29	99.7	0	328	2	101	209	KAL1521758.1 hypothetical protein AB1Y20_021412 [Prymnesium parvum]	diamond	327	183	1	Eukaryota	Haptista	Haptophyta	Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
31696467	31696467	PRJNA758088_P_NODE_68897_length_517_cov_5.425676_g61946_i0	PRJNA758088	68897	517	5.425676	28.05074492	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	75.9	6.280000000000002e-13	NR	KAL1522327.1	97485	g61946	i0	54.9	0.411992263056093	71	30	40	1	453	247	7	77	KAL1522327.1 hypothetical protein AB1Y20_017319 [Prymnesium parvum]	diamond	213	75.9	1	Eukaryota	Haptista	Haptophyta	Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
32456011	32456011	PRJNA758088_P_NODE_154719_length_339_cov_1.338346_g147748_i0	PRJNA758088	154719	339	1.338346	4.53699294	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	92.8	3.08e-19	NR	KOO34671.1	1460289	g147748	i0	45.5	0.97345132743362806	110	58	95.6	1	5	328	398	507	KOO34671.1 hypothetical protein Ctob_009279 [Chrysochromulina tobinii]	diamond	330	92.8	1	Eukaryota	Haptista	Haptophyta	Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
32834128	32834128	PRJNA758088_P_NODE_290600_length_250_cov_0.870056_g283629_i0	PRJNA758088	290600	250	0.870056	2.17514	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	55.5	1.38e-6	NR	KAL1507547.1	97485	g283629	i0	43.7	0.852	71	35	80.4	2	228	28	324	393	KAL1507547.1 hypothetical protein AB1Y20_007168 [Prymnesium parvum]	diamond	213	55.5	1	Eukaryota	Haptista	Haptophyta	Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum

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