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

7 rows where bioproject = "PRJNA1180292", 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
1592480	1592480	PRJNA1180292_P_NODE_10962_length_246_cov_0.901734_g10830_i0	PRJNA1180292	10962	246	0.901734	2.21826564	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	54.7	0.006	NTclustered	gi\|551548444\|ref\|XM_005761808.1\|	280463	g10830	i0	100	0.117886178861789	29	0	12	0	48	76	747	775	Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA	blastn	29	54.7	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
18169517	18169517	PRJNA1180292_P_NODE_5295_length_303_cov_1.017391_g5163_i0	PRJNA1180292	5295	303	1.017391	3.08269473	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	110	1.21e-28	NR	KAL1522762.1	97485	g5163	i0	69.4	1.40594059405941	72	22	71.3	0	3	218	53	124	KAL1522762.1 hypothetical protein AB1Y20_017734 [Prymnesium parvum]	diamond	426	110	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
24543802	24543802	PRJNA1180292_P_NODE_11080_length_246_cov_0.901734_g10948_i0	PRJNA1180292	11080	246	0.901734	2.21826564	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	109	3.87e-28	NR	KAG8471263.1	2081491	g10948	i0	79.7	2.52439024390244	69	14	84.1	0	207	1	18	86	KAG8471263.1 hypothetical protein KFE25_009684 [Diacronema lutheri]	diamond	621	109	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
28114349	28114349	PRJNA1180292_P_NODE_5885_length_288_cov_1.441860_g5753_i0	PRJNA1180292	5885	288	1.44186	4.1525568	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	94.7	1.08e-20	NR	KOO27201.1	1460289	g5753	i0	58	1.79166666666667	88	37	91.7	0	23	286	257	344	KOO27201.1 translation initiation factor eif2 alpha subunit [Chrysochromulina tobinii]	diamond	516	94.7	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
28303914	28303914	PRJNA1180292_P_NODE_2166_length_462_cov_3.437018_g2034_i0	PRJNA1180292	2166	462	3.437018	15.87902316	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	208	3.61e-66	NR	KAL1523551.1	97485	g2034	i0	74.3	4.88961038961039	152	34	96.1	2	3	446	1	151	KAL1523551.1 hypothetical protein AB1Y20_018487 [Prymnesium parvum]	diamond	2259	208	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
31114628	31114628	PRJNA1180292_P_NODE_7595_length_256_cov_1.278689_g7463_i0	PRJNA1180292	7595	256	1.278689	3.27344384	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	77.8	1.25e-14	NR	XP_005761487.1	280463	g7463	i0	43.6	0.9140625	78	43	91.4	1	2	235	63	139	XP_005761487.1 hypothetical protein EMIHUDRAFT_438175 [Emiliania huxleyi CCMP1516]	diamond	234	77.8	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
31576846	31576846	PRJNA1180292_P_NODE_9296_length_250_cov_0.881356_g9164_i0	PRJNA1180292	9296	250	0.881356	2.20339	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	86.3	7.1e-18	NR	KAJ1638409.1	483367	g9164	i0	61.3	2.94	62	24	74.4	0	250	65	261	322	KAJ1638409.1 mitochondrial carrier domain-containing protein [Pavlovales sp. CCMP2436]	diamond	735	86.3	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436

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