metadata: contig_metadata: 10 rows where bioproject = "PRJNA168635" and tax

10 rows where bioproject = "PRJNA168635" 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
2329434	2329434	PRJNA168635_P_NODE_13322_length_222_cov_2.520231_g12906_i0	PRJNA168635	13322	222	2.520231	5.59491282	Pterocystida	2607628	Root_unresolved	Root_unresolved	193	1.11e-44	NTclustered	gi\|61187375\|gb\|AY752993.1\|	299886	g12906	i0	95.798	66.7792792792793	119	5	54	0	23	141	3260	3378	Pterocystis tropica 28S ribosomal RNA gene, partial sequence	blastn	14825	193	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Pterocystidae	Pterocystis	Pterocystis tropica
5467734	5467734	PRJNA168635_P_NODE_19925_length_182_cov_5.962406_g19509_i0	PRJNA168635	19925	182	5.962406	10.85157892	Oxnerella micra	1147772	Root_unresolved	Root_unresolved	244	2.38e-60	NTclustered	gi\|375582525\|gb\|JQ245080.1\|	1147772	g19509	i0	93.827	72.4450549450549	162	10	89	0	21	182	1118	1279	Oxnerella micra 28S ribosomal RNA gene, partial sequence	blastn	13185	244	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Oxnerellidae	Oxnerella	Oxnerella micra
9292554	9292554	PRJNA168635_P_NODE_21688_length_177_cov_1.796875_g21272_i0	PRJNA168635	21688	177	1.796875	3.18046875	Chrysochromulina sp.	2200936	Haptophyta	other_Eukaryota	222	1.08e-53	NTclustered	gi\|2059554223\|gb\|MZ469764.1\|	2200936	g21272	i0	91.975	111.158192090395	162	8	90	5	19	177	167	326	Chrysochromulina sp. strain DAD-ALGEUK-36 large subunit ribosomal RNA gene, partial sequence; chloroplast	blastn	19675	222	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina sp.
11257420	11257420	PRJNA168635_P_NODE_12689_length_228_cov_3.458101_g12273_i0	PRJNA168635	12689	228	3.458101	7.88447028	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	411	2.909999999999999e-110	NTclustered	gi\|408717423\|gb\|JX453462.1\|	171259	g12273	i0	99.123	86.9298245614035	228	2	100	0	1	228	337	110	Uncultured haptophyte clone Finsevatn_8912 18S ribosomal RNA gene, partial sequence	blastn	19820	411	1	Eukaryota	Haptista	Haptophyta					Haptophyta environmental samples
12532983	12532983	PRJNA168635_P_NODE_530_length_979_cov_68.145161_g378_i0	PRJNA168635	530	979	68.145161	667.14112619	Pterocystida	2607628	Root_unresolved	Root_unresolved	743	0	NTclustered	gi\|61187375\|gb\|AY752993.1\|	299886	g378	i0	90.411	57.4790602655771	584	28	59	12	156	737	1951	2508	Pterocystis tropica 28S ribosomal RNA gene, partial sequence	blastn	56272	743	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Pterocystidae	Pterocystis	Pterocystis tropica
20766304	20766304	PRJNA168635_P_NODE_7657_length_305_cov_4.851562_g7244_i0	PRJNA168635	7657	305	4.851562	14.7972641	Meringosphaera mediterranea	2837474	Root_unresolved	Root_unresolved	69.4	2.82e-7	NTclustered	gi\|2528217843\|gb\|OR196765.1\|	2837474	g7244	i0	95.349	3.35737704918033	43	2	14	0	245	287	1713	1671	Meringosphaera mediterranea isolate S11 large subunit ribosomal RNA gene, partial sequence	blastn	1024	69.4	1	Eukaryota	Haptista		Centroplasthelida			Meringosphaera	Meringosphaera mediterranea
22041407	22041407	PRJNA168635_P_NODE_9578_length_269_cov_4.650000_g9163_i0	PRJNA168635	9578	269	4.65	12.5085	Heterophryidae sp. 3 VVZ-2016	1795051	Root_unresolved	Root_unresolved	139	1.84e-28	NTclustered	gi\|985769339\|gb\|KU178908.1\|	1795051	g9163	i0	87.121	38.9256505576208	132	5	46	7	145	267	188	60	Heterophryidae sp. 3 VVZ-2016 18S ribosomal RNA gene, partial sequence	blastn	10471	139	1	Eukaryota	Haptista		Centroplasthelida	Pterocystida	Heterophryidae		Heterophryidae sp. 3 VVZ-2016
27010500	27010500	PRJNA168635_P_NODE_18322_length_188_cov_2.215827_g17906_i0	PRJNA168635	18322	188	2.215827	4.16575476	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	58.5	4.77e-8	NR	XP_005761491.1	280463	g17906	i0	45.2	0.98936170212766	62	33	97.3	1	188	6	18	79	XP_005761491.1 hypothetical protein EMIHUDRAFT_452958 [Emiliania huxleyi CCMP1516]	diamond	186	58.5	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
30327192	30327192	PRJNA168635_P_NODE_29412_length_164_cov_4.165217_g28996_i0	PRJNA168635	29412	164	4.165217	6.83095588	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	62	1.74e-10	NR	XP_005783594.1	280463	g28996	i0	64.7	5.59756097560976	51	18	93.3	0	156	4	5	55	XP_005783594.1 hypothetical protein EMIHUDRAFT_79084 [Emiliania huxleyi CCMP1516]	diamond	918	62	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
31907206	31907206	PRJNA168635_P_NODE_33597_length_157_cov_3.805556_g33181_i0	PRJNA168635	33597	157	3.805556	5.97472292	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	70.9	5.38e-13	NR	KAG8457738.1	2081491	g33181	i0	61.2	2.88535031847134	49	19	93.6	0	149	3	132	180	KAG8457738.1 hypothetical protein KFE25_013244 [Diacronema lutheri]	diamond	453	70.9	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);;