metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA494251" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA494251" 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
3026564	3026564	PRJNA494251_S_NODE_523_length_298_cov_0.742222_g508_i0	PRJNA494251	523	298	0.742222	2.21182156	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	276	1.51e-69	NTclustered	gi\|551539306\|ref\|XM_005758086.1\|	280463	g508	i0	84.532	85.1342281879195	278	43	93	0	14	291	506	783	Emiliania huxleyi CCMP1516 receptor of activated protein kinase C partial mRNA	blastn	25370	276	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
4302268	4302268	PRJNA494251_P_NODE_35264_length_255_cov_1.670330_g34950_i0	PRJNA494251	35264	255	1.67033	4.2593415	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	52.8	0.023	NTclustered	gi\|551561853\|ref\|XM_005767679.1\|	280463	g34950	i0	96.774	0.12156862745098	31	1	12	0	157	187	150	120	Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA	blastn	31	52.8	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
11954010	11954010	PRJNA494251_P_NODE_25490_length_289_cov_1.078704_g25176_i0	PRJNA494251	25490	289	1.078704	3.11745456	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	141	5.550000000000001e-29	NTclustered	gi\|551613833\|ref\|XM_005787831.1\|	280463	g25176	i0	79.793	0.667820069204152	193	39	67	0	24	216	1238	1430	Emiliania huxleyi CCMP1516 putative EF-1 alpha/Tu like protein (EFG1), mRNA	blastn	193	141	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
13229340	13229340	PRJNA494251_P_NODE_45831_length_244_cov_0.900585_g45517_i0	PRJNA494251	45831	244	0.900585	2.1974274	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	52.8	0.022	NTclustered	gi\|551545064\|ref\|XM_005760483.1\|	280463	g45517	i0	100	0.229508196721311	28	0	11	0	58	85	721	694	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	56	52.8	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
14504080	14504080	PRJNA494251_P_NODE_31092_length_268_cov_1.564103_g30778_i0	PRJNA494251	31092	268	1.564103	4.19179604	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	134	8.520000000000001e-27	NTclustered	gi\|551610509\|ref\|XM_005786317.1\|	280463	g30778	i0	79.899	9.20522388059701	199	26	73	11	69	263	940	1128	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	2467	134	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
15777937	15777937	PRJNA494251_P_NODE_29473_length_274_cov_1.094527_g29159_i0	PRJNA494251	29473	274	1.094527	2.99900398	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	56.5	0.002	NTclustered	gi\|551548874\|ref\|XM_005762023.1\|	280463	g29159	i0	90.476	0.361313868613139	42	4	15	0	119	160	770	811	Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA	blastn	99	56.5	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
21508827	21508827	PRJNA494251_P_NODE_23417_length_298_cov_2.888889_g23103_i0	PRJNA494251	23417	298	2.888889	8.60888922	Isochrysidales	73020	Haptophyta	other_Eukaryota	209	1.55e-49	NTclustered	gi\|551624794\|ref\|XM_005792543.1\|	280463	g23103	i0	87.5	3.71476510067114	184	19	61	4	33	214	248	67	Emiliania huxleyi CCMP1516 40S ribosomal protein S14 partial mRNA	blastn	1107	211	0.990521327014218	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
24701441	24701441	PRJNA494251_P_NODE_43220_length_246_cov_0.890173_g42906_i0	PRJNA494251	43220	246	0.890173	2.18982558	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	222	1.5999999999999996e-53	NTclustered	gi\|34329030\|gb\|AY292380.1\|	97485	g42906	i0	84.821	87.7113821138211	224	31	91	3	1	224	614	394	Prymnesium parvum glyceraldehyde-3-phosphate dehydrogenase (GAPDH) gene, partial cds	blastn	21577	222	1	Eukaryota	Haptista	Haptophyta	Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
24701565	24701565	PRJNA494251_P_NODE_6940_length_494_cov_1.603325_g6637_i0	PRJNA494251	6940	494	1.603325	7.9204255	Dicrateria rotunda	2703868	Haptophyta	other_Eukaryota	159	2.76e-34	NTclustered	gi\|259419561\|emb\|FN392576.1\|	2703868	g6637	i0	83.626	0.346153846153846	171	26	34	2	8	177	255	86	Imantonia rotunda partial mRNA for 60S ribosomal protein L19, contig 25573	blastn	171	159	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Isochrysidaceae	Dicrateria	Dicrateria rotunda
24701584	24701584	PRJNA494251_P_NODE_8200_length_459_cov_4.183938_g7897_i0	PRJNA494251	8200	459	4.183938	19.20427542	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	198	5.41e-46	NTclustered	gi\|551539306\|ref\|XM_005758086.1\|	280463	g7897	i0	81.78	2.9520697167756	236	43	51	0	215	450	171	406	Emiliania huxleyi CCMP1516 receptor of activated protein kinase C partial mRNA	blastn	1355	198	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);;