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

6 rows where bioproject = "PRJNA395690", 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_class	tax_order	tax_family	tax_genus	tax_species
13165585	13165585	PRJNA395690_P_NODE_5571_length_339_cov_2.413793_g5421_i0	PRJNA395690	5571	339	2.413793	8.18275827	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	198	3.89e-46	NTclustered	gi\|551548842\|ref\|XM_005762007.1\|	280463	g5421	i0	81.028	61.7050147492625	253	44	74	2	15	265	401	151	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	20918	198	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
19537295	19537295	PRJNA395690_P_NODE_10736_length_248_cov_2.291457_g10584_i0	PRJNA395690	10736	248	2.291457	5.68281336	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	111	1.1e-27	NR	XP_005767823.1	280463	g10584	i0	65	10.1129032258065	80	28	96.8	0	243	4	145	224	XP_005767823.1 hypothetical protein EMIHUDRAFT_356503 [Emiliania huxleyi CCMP1516]	diamond	2508	111	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
28401767	28401767	PRJNA395690_P_NODE_10146_length_255_cov_1.980583_g9994_i0	PRJNA395690	10146	255	1.980583	5.05048665	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	119	1.6199999999999998e-32	NR	KAL1515397.1	97485	g9994	i0	73.1	6.45882352941176	78	21	91.8	0	236	3	1	78	KAL1515397.1 hypothetical protein AB1Y20_002025 [Prymnesium parvum]	diamond	1647	119	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
29002117	29002117	PRJNA395690_P_NODE_23368_length_178_cov_2.325581_g23216_i0	PRJNA395690	23368	178	2.325581	4.13953418	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	63.5	6.94e-10	NR	KAG8464037.1	2081491	g23216	i0	56.8	8.24157303370787	44	19	74.2	0	33	164	1863	1906	KAG8464037.1 hypothetical protein KFE25_000205 [Diacronema lutheri]	diamond	1467	63.5	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
30850342	30850342	PRJNA395690_P_NODE_8714_length_274_cov_1.115556_g8562_i0	PRJNA395690	8714	274	1.115556	3.05662344	Pavlovophyceae	3435358	Haptophyta	other_Eukaryota	112	9.8e-27	NR	KAL1504882.1	97485	g8562	i0	68.1	3.24087591240876	72	23	78.8	0	28	243	303	374	KAL1504882.1 hypothetical protein AB1Y20_008652 [Prymnesium parvum]	diamond	888	113	0.991150442477876	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
31687150	31687150	PRJNA395690_P_NODE_24117_length_177_cov_1.156250_g23965_i0	PRJNA395690	24117	177	1.15625	2.0465625	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	50.4	2.95e-5	NR	XP_005757838.1	280463	g23965	i0	63.2	4.40677966101695	38	13	64.4	1	64	177	301	337	XP_005757838.1 hypothetical protein EMIHUDRAFT_433184 [Emiliania huxleyi CCMP1516]	diamond	780	50.4	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);;