metadata: contig_metadata: 10 rows where bioproject = "PRJNA662254", tax_clade = "Haptista" and tax

10 rows where bioproject = "PRJNA662254", 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
7006820	7006820	PRJNA662254_P_NODE_13406_length_449_cov_1.228723_g12755_i0	PRJNA662254	13406	449	1.228723	5.51696627	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	244	6.68e-60	NTclustered	gi\|551615762\|ref\|XM_005788689.1\|	280463	g12755	i0	81.544	55.3630289532294	298	53	66	2	18	314	794	498	Emiliania huxleyi CCMP1516 putative histone H2B mRNA	blastn	24858	244	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
10090518	10090518	PRJNA662254_P_NODE_31168_length_297_cov_2.352679_g30517_i0	PRJNA662254	31168	297	2.352679	6.98745663	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	189	2.02e-43	NTclustered	gi\|61187370\|gb\|AY752991.1\|	299901	g30517	i0	94.355	43.7542087542088	124	6	42	1	58	181	1977	2099	Sphaerastrum fockii 28S ribosomal RNA gene, partial sequence	blastn	12995	189	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Heterophryidae	Sphaerastrum	Sphaerastrum fockii
19013477	19013477	PRJNA662254_P_NODE_1995_length_1257_cov_1.519426_g1649_i0	PRJNA662254	1995	1257	1.519426	19.09918482	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	551	8.279999999999999e-194	NR	KAL1521514.1	97485	g1649	i0	69.2	22.2673031026253	390	119	93.1	1	1210	41	1	389	KAL1521514.1 hypothetical protein AB1Y20_021174 [Prymnesium parvum]	diamond	27990	551	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
27713670	27713670	PRJNA662254_P_NODE_9724_length_534_cov_1.366594_g9081_i0	PRJNA662254	9724	534	1.366594	7.29761196	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	224	2.65e-70	NR	XP_005767823.1	280463	g9081	i0	63.8	17.3314606741573	163	59	91.6	0	532	44	65	227	XP_005767823.1 hypothetical protein EMIHUDRAFT_356503 [Emiliania huxleyi CCMP1516]	diamond	9255	224	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
28660539	28660539	PRJNA662254_P_NODE_3447_length_950_cov_2.004561_g2968_i0	PRJNA662254	3447	950	2.004561	19.0433295	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	136	1.29e-31	NR	XP_005767425.1	280463	g2968	i0	32.3	2.76	316	185	99.5	9	2	946	447	734	XP_005767425.1 hypothetical protein EMIHUDRAFT_445703 [Emiliania huxleyi CCMP1516]	diamond	2622	136	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
30902982	30902982	PRJNA662254_P_NODE_52194_length_248_cov_0.880000_g51543_i0	PRJNA662254	52194	248	0.88	2.1824	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	63.9	1.33e-9	NR	KOO28007.1	1460289	g51543	i0	46.2	0.786290322580645	65	35	78.6	0	215	21	35	99	KOO28007.1 hypothetical protein Ctob_007633 [Chrysochromulina tobinii]	diamond	195	63.9	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
32211795	32211795	PRJNA662254_P_NODE_25018_length_330_cov_1.326848_g24367_i0	PRJNA662254	25018	330	1.326848	4.3785984	Diacronema	70451	Haptophyta	other_Eukaryota	118	2.3e-31	NR	KAJ1641330.1	483367	g24367	i0	69.2	1.41818181818182	78	24	70.9	0	234	1	19	96	KAJ1641330.1 40S ribosomal protein S19 like [Pavlovales sp. CCMP2436]	diamond	468	118	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
32579355	32579355	PRJNA662254_P_NODE_62779_length_242_cov_0.911243_g62128_i0	PRJNA662254	62779	242	0.911243	2.20520806	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	64.3	8.52e-10	NR	KAG8460774.1	2081491	g62128	i0	44.9	0.966942148760331	78	43	96.7	0	2	235	295	372	KAG8460774.1 hypothetical protein KFE25_010829 [Diacronema lutheri]	diamond	234	64.3	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
32641848	32641848	PRJNA662254_P_NODE_60380_length_243_cov_1.358824_g59729_i0	PRJNA662254	60380	243	1.358824	3.30194232	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	72.8	8.97e-14	NR	KOO22415.1	1460289	g59729	i0	47.1	1.67901234567901	68	36	84	0	238	35	62	129	KOO22415.1 hypothetical protein Ctob_000523 [Chrysochromulina tobinii]	diamond	408	72.8	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
32862485	32862485	PRJNA662254_P_NODE_41500_length_261_cov_0.893617_g40849_i0	PRJNA662254	41500	261	0.893617	2.33234037	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	52	2.34e-5	NR	KAG8461678.1	2081491	g40849	i0	42.7	0.942528735632184	82	34	79.3	3	1	207	172	253	KAG8461678.1 hypothetical protein KFE25_001296 [Diacronema lutheri]	diamond	246	52	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri

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