metadata: contig_metadata: 6 rows where bioproject = "PRJNA1123436" and tax

6 rows where bioproject = "PRJNA1123436" 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
2830715	2830715	PRJNA1123436_P_NODE_60123_length_321_cov_30.500000_g58909_i0	PRJNA1123436	60123	321	30.5	97.905	Rebecca salina	561169	Haptophyta	other_Eukaryota	255	2.14e-63	NTclustered	gi\|318084144\|gb\|HM595079.1\|	561169	g58909	i0	97.333	74.2242990654206	150	4	91	0	3	152	3706	3855	Rebecca salina 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, tRNA-Ile and tRNA-Ala genes, complete sequence; and 23S ribosomal RNA gene, partial sequence; plastid	blastn	23826	255	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Rebecca	Rebecca salina
12508440	12508440	PRJNA1123436_P_NODE_57590_length_328_cov_3.368627_g56376_i0	PRJNA1123436	57590	328	3.368627	11.04909656	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	244	4.7399999999999996e-60	NTclustered	gi\|2059554226\|gb\|MZ469767.1\|	2200936	g56376	i0	95.455	49.0914634146341	154	6	89	1	162	315	253	405	Chrysochromulina sp. strain DAD-ALGEUK-39 large subunit ribosomal RNA gene, partial sequence; chloroplast	blastn	16102	246	0.991869918699187	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina sp.
28649381	28649381	PRJNA1123436_P_NODE_25727_length_512_cov_1.788155_g24520_i0	PRJNA1123436	25727	512	1.788155	9.1553536	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	45.1	0.0182	NR	KAL1514668.1	97485	g24520	i0	37.5	0.421875	72	39	39.8	2	248	45	62	131	KAL1514668.1 hypothetical protein AB1Y20_003756 [Prymnesium parvum]	diamond	216	45.1	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
29817335	29817335	PRJNA1123436_P_NODE_113711_length_245_cov_0.895349_g112497_i0	PRJNA1123436	113711	245	0.895349	2.19360505	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	57	3.47e-7	NR	KAL1528691.1	97485	g112497	i0	46.9	0.991836734693878	81	41	96.7	1	242	6	154	234	KAL1528691.1 hypothetical protein AB1Y20_010027 [Prymnesium parvum]	diamond	243	57	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
30386593	30386593	PRJNA1123436_P_NODE_60693_length_320_cov_2.469636_g59479_i0	PRJNA1123436	60693	320	2.469636	7.9028352	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	109	1.08e-25	NR	XP_005764372.1	280463	g59479	i0	48.3	1.10625	118	49	99.4	1	320	3	264	381	XP_005764372.1 aspartate aminotransferase [Emiliania huxleyi CCMP1516]	diamond	354	109	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
31935055	31935055	PRJNA1123436_P_NODE_91377_length_257_cov_1.255435_g90163_i0	PRJNA1123436	91377	257	1.255435	3.22646795	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	110	1.12e-26	NR	KOO31236.1	1460289	g90163	i0	65.4	0.945525291828794	81	28	94.6	0	257	15	271	351	KOO31236.1 hypothetical protein Ctob_013751 [Chrysochromulina tobinii]	diamond	243	110	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii

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