metadata: contig_metadata: 5 rows where bioproject = "PRJNA1093380" and tax

5 rows where bioproject = "PRJNA1093380" 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
6577058	6577058	PRJNA1093380_P_NODE_16686_length_241_cov_4.488095_g16580_i0	PRJNA1093380	16686	241	4.488095	10.81630895	Raphidocystis contractilis	2792838	Root_unresolved	Root_unresolved	235	2.0099999999999997e-57	NTclustered	gi\|259475615\|emb\|FN392423.1\|	2792838	g16580	i0	84.232	8.40248962655602	241	38	100	0	1	241	216	456	Raphidiophrys contractilis partial mRNA for 40S ribosomal protein S23, contig D2-M13	blastn	2025	235	1	Eukaryota	Haptista		Centroplasthelida	Acanthocystida	Raphidocystidae	Raphidocystis	Raphidocystis contractilis
14227779	14227779	PRJNA1093380_P_NODE_12652_length_250_cov_0.870056_g12546_i0	PRJNA1093380	12652	250	0.870056	2.17514	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	117	5.54e-31	NR	KAL1520922.1	97485	g12546	i0	69.9	1.992	83	24	99.6	1	2	250	52	133	KAL1520922.1 hypothetical protein AB1Y20_022482 [Prymnesium parvum]	diamond	498	117	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
27794295	27794295	PRJNA1093380_P_NODE_7704_length_275_cov_1.222772_g7598_i0	PRJNA1093380	7704	275	1.222772	3.362623	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	106	1.88e-24	NR	KAL1508433.1	97485	g7598	i0	61.4	0.905454545454545	83	31	89.5	1	28	273	647	729	KAL1508433.1 hypothetical protein AB1Y20_004537 [Prymnesium parvum]	diamond	249	106	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
29909799	29909799	PRJNA1093380_P_NODE_11311_length_254_cov_1.646409_g11205_i0	PRJNA1093380	11311	254	1.646409	4.18187886	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	52	1.23e-5	NR	XP_005757983.1	280463	g11205	i0	47.7	1.93700787401575	44	23	52	0	118	249	30	73	XP_005757983.1 hypothetical protein EMIHUDRAFT_446583 [Emiliania huxleyi CCMP1516]	diamond	492	52	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
32565648	32565648	PRJNA1093380_P_NODE_14179_length_247_cov_0.885057_g14073_i0	PRJNA1093380	14179	247	0.885057	2.18609079	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	89	2.07e-18	NR	KOO21731.1	1460289	g14073	i0	47.7	1.06882591093117	88	38	97.2	2	3	242	531	618	KOO21731.1 membrane glycoprotein yil173w [Chrysochromulina tobinii]	diamond	264	89	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);;