metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA1204310" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA1204310" 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_order	tax_family	tax_genus	tax_species
328795	328795	PRJNA1204310_P_NODE_19861_length_405_cov_2.349398_g19564_i0	PRJNA1204310	19861	405	2.349398	9.5150619	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	259	2.13e-64	NTclustered	gi\|551583408\|ref\|XM_005777084.1\|	280463	g19564	i0	81.505	37.6987654320988	319	55	78	4	33	349	1365	1049	Emiliania huxleyi CCMP1516 isocitrate dehydrogenase, NADP-dependent (IDH1), mRNA	blastn	15268	259	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
329467	329467	PRJNA1204310_P_NODE_49561_length_257_cov_1.451087_g49264_i0	PRJNA1204310	49561	257	1.451087	3.72929359	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	106	1.77e-18	NTclustered	gi\|551583056\|ref\|XM_005776908.1\|	280463	g49264	i0	82.906	0.910505836575875	117	20	46	0	130	246	394	278	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	234	106	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
2879954	2879954	PRJNA1204310_P_NODE_29823_length_340_cov_3.962547_g29526_i0	PRJNA1204310	29823	340	3.962547	13.4726598	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	206	2.33e-48	NTclustered	gi\|551548842\|ref\|XM_005762007.1\|	280463	g29526	i0	83.186	6.11176470588235	226	36	66	2	10	234	330	106	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	2078	206	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
14357899	14357899	PRJNA1204310_P_NODE_24112_length_373_cov_2.080000_g23815_i0	PRJNA1204310	24112	373	2.08	7.7584	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	211	5.53e-50	NTclustered	gi\|551539306\|ref\|XM_005758086.1\|	280463	g23815	i0	78.107	74.6193029490617	338	70	90	4	37	372	681	346	Emiliania huxleyi CCMP1516 receptor of activated protein kinase C partial mRNA	blastn	27833	211	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
15632647	15632647	PRJNA1204310_P_NODE_63173_length_213_cov_5.514286_g62876_i0	PRJNA1204310	63173	213	5.514286	11.74542918	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	76.8	1.11e-9	NTclustered	gi\|551583056\|ref\|XM_005776908.1\|	280463	g62876	i0	85.915	0.666666666666667	71	10	33	0	36	106	318	388	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	142	76.8	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
20730742	20730742	PRJNA1204310_P_NODE_38637_length_299_cov_1.035398_g38340_i0	PRJNA1204310	38637	299	1.035398	3.09584002	Dicrateria rotunda	2703868	Haptophyta	other_Eukaryota	198	3.3699999999999998e-46	NTclustered	gi\|259419544\|emb\|FN392559.1\|	2703868	g38340	i0	85.34	27.2073578595318	191	28	64	0	109	299	300	110	Imantonia rotunda partial mRNA for ADP-ribosylation factor 3, contig 10068	blastn	8135	198	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Isochrysidaceae	Dicrateria	Dicrateria rotunda

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