metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA615351" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA615351" and tax_phylum = "Haptophyta"

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
595989	595989	PRJNA615351_P_NODE_91561_length_357_cov_2.397516_g77477_i0	PRJNA615351	91561	357	2.397516	8.55913212	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	200	1.1399999999999999e-46	NTclustered	gi\|551616895\|ref\|XM_005789234.1\|	280463	g77477	i0	76.944	1.6890756302521	360	77	100	6	1	357	1274	918	Emiliania huxleyi CCMP1516 serine hydroxymethyltransferase mRNA	blastn	603	200	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
4423057	4423057	PRJNA615351_P_NODE_118964_length_253_cov_1.752294_g104864_i0	PRJNA615351	118964	253	1.752294	4.43330382	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	63.9	1.06e-5	NTclustered	gi\|551619823\|ref\|XM_005790438.1\|	280463	g104864	i0	90	0.197628458498024	50	3	19	2	2	50	116	164	Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA	blastn	50	63.9	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
6973954	6973954	PRJNA615351_P_NODE_130906_length_224_cov_1.677249_g116806_i0	PRJNA615351	130906	224	1.677249	3.75703776	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	233	6.62e-57	NTclustered	gi\|551592156\|ref\|XM_005780155.1\|	280463	g116806	i0	86.239	65.8035714285714	218	26	96	4	1	216	1095	1310	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	14740	233	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
6973998	6973998	PRJNA615351_P_NODE_145046_length_197_cov_3.666667_g130946_i0	PRJNA615351	145046	197	3.666667	7.22333399	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	150	5.88e-32	NTclustered	gi\|551561154\|ref\|XM_005767403.1\|	280463	g130946	i0	80.829	1.9238578680203	193	36	97	1	1	192	210	18	Emiliania huxleyi CCMP1516 RAN, ras superfamily GTPase (RAN-2), partial mRNA	blastn	379	150	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
12074937	12074937	PRJNA615351_P_NODE_163590_length_172_cov_1.810219_g149490_i0	PRJNA615351	163590	172	1.810219	3.11357668	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	113	6.52e-21	NTclustered	gi\|551597690\|ref\|XM_005780871.1\|	280463	g149490	i0	79.07	35.4767441860465	172	30	98	6	3	171	857	1025	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	6102	113	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
13350007	13350007	PRJNA615351_P_NODE_51411_length_706_cov_8.318927_g37079_i1	PRJNA615351	51411	706	8.318927	58.73162462	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	359	3.71e-94	NTclustered	gi\|551568843\|ref\|XM_005770320.1\|	280463	g37079	i1	82.27	45.1798866855524	423	67	59	8	286	704	492	74	Emiliania huxleyi CCMP1516 peptidyl-prolyl isomerase (CYPB1), mRNA	blastn	31897	359	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
15898367	15898367	PRJNA615351_P_NODE_114173_length_267_cov_1.482759_g100074_i0	PRJNA615351	114173	267	1.482759	3.95896653	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	122	1.8399999999999998e-23	NTclustered	gi\|551550104\|ref\|XM_005762530.1\|	280463	g100074	i0	85.124	0.453183520599251	121	16	45	2	147	266	45	164	Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA	blastn	121	122	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
15898505	15898505	PRJNA615351_P_NODE_155993_length_182_cov_1.088435_g141893_i0	PRJNA615351	155993	182	1.088435	1.9809517	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	52.8	0.015	NTclustered	gi\|551587618\|ref\|XM_005778607.1\|	280463	g141893	i0	92.105	0.208791208791209	38	1	20	2	86	121	255	218	Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA	blastn	38	52.8	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
18447652	18447652	PRJNA615351_P_NODE_160415_length_176_cov_1.666667_g146315_i0	PRJNA615351	160415	176	1.666667	2.93333392	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	122	1.1199999999999999e-23	NTclustered	gi\|551542776\|ref\|XM_005759518.1\|	280463	g146315	i0	80	6.86931818181818	165	33	94	0	1	165	280	116	Emiliania huxleyi CCMP1516 MAP kinase (MAPK3), mRNA	blastn	1209	122	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);;