metadata: contig_metadata: 7 rows where bioproject = "PRJNA608894", tax_clade = "Haptista" and tax

7 rows where bioproject = "PRJNA608894", 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
585756	585756	PRJNA608894_P_NODE_55281_length_246_cov_0.890173_g54782_i0	PRJNA608894	55281	246	0.890173	2.18982558	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	58.4	4.78e-4	NTclustered	gi\|551555474\|ref\|XM_005764869.1\|	280463	g54782	i0	97.059	0.276422764227642	34	1	14	0	135	168	1689	1656	Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA	blastn	68	58.4	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
9513833	9513833	PRJNA608894_P_NODE_35908_length_301_cov_1.179825_g35409_i0	PRJNA608894	35908	301	1.179825	3.55127325	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	169	2.67e-37	NTclustered	gi\|551580226\|ref\|XM_005775612.1\|	280463	g35409	i0	81.25	7.58471760797342	208	39	69	0	94	301	73	280	Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA	blastn	2283	169	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
18437117	18437117	PRJNA608894_P_NODE_18055_length_493_cov_7.661905_g17559_i0	PRJNA608894	18055	493	7.661905	37.77319165	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	148	2.3999999999999998e-43	NR	XP_005758635.1	280463	g17559	i0	86.4	15.2981744421907	81	11	49.3	0	48	290	3	83	XP_005758635.1 hypothetical protein EMIHUDRAFT_425447 [Emiliania huxleyi CCMP1516]	diamond	7542	148	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
22262310	22262310	PRJNA608894_P_NODE_23058_length_407_cov_4.098802_g22561_i0	PRJNA608894	23058	407	4.098802	16.68212414	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	157	1.6499999999999999e-43	NR	KAL1512169.1	97485	g22561	i0	60.3	9.17690417690418	121	48	89.2	0	396	34	297	417	KAL1512169.1 hypothetical protein AB1Y20_005435 [Prymnesium parvum]	diamond	3735	157	1	Eukaryota	Haptista	Haptophyta	Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
27301459	27301459	PRJNA608894_P_NODE_55323_length_246_cov_0.890173_g54824_i0	PRJNA608894	55323	246	0.890173	2.18982558	Prymnesium sp.	2812485	Haptophyta	other_Eukaryota	47.8	6.18e-4	NR	KAL3929425.1	2812485	g54824	i0	47.4	1.40243902439024	38	20	46.3	0	245	132	271	308	KAL3929425.1 MAG: hypothetical protein SGPRY_001966 [Prymnesium sp.]	diamond	345	47.8	1	Eukaryota	Haptista	Haptophyta	Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium sp.
28311906	28311906	PRJNA608894_P_NODE_60986_length_236_cov_3.374233_g60487_i0	PRJNA608894	60986	236	3.374233	7.96318988	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	82	4.85e-16	NR	KAL1528815.1	97485	g60487	i0	53.4	1.85593220338983	73	34	92.8	0	230	12	394	466	KAL1528815.1 hypothetical protein AB1Y20_010138 [Prymnesium parvum]	diamond	438	82	1	Eukaryota	Haptista	Haptophyta	Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
30364888	30364888	PRJNA608894_P_NODE_26852_length_362_cov_33.816609_g26354_i0	PRJNA608894	26852	362	33.816609	122.41612458	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	87.8	1.2e-19	NR	XP_005782836.1	280463	g26354	i0	50	1.72375690607735	102	47	83.7	2	341	39	16	114	XP_005782836.1 hypothetical protein EMIHUDRAFT_442529 [Emiliania huxleyi CCMP1516]	diamond	624	87.8	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);;