metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA1144090" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA1144090" 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
4114185	4114185	PRJNA1144090_P_NODE_28964_length_490_cov_3.316547_g28430_i0	PRJNA1144090	28964	490	3.316547	16.2510803	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	255	3.39e-63	NTclustered	gi\|551548842\|ref\|XM_005762007.1\|	280463	g28430	i0	82.215	16.4775510204082	298	51	61	2	108	404	106	402	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	8074	255	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
6665206	6665206	PRJNA1144090_P_NODE_42306_length_396_cov_1.108359_g41771_i0	PRJNA1144090	42306	396	1.108359	4.38910164	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	254	9.68e-63	NTclustered	gi\|551602412\|ref\|XM_005782724.1\|	280463	g41771	i0	79.528	10.1338383838384	381	59	93	15	25	391	313	688	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	4013	254	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
7940558	7940558	PRJNA1144090_P_NODE_59147_length_330_cov_1.793774_g58612_i0	PRJNA1144090	59147	330	1.793774	5.9194542	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	366	9.77e-97	NTclustered	gi\|551565477\|ref\|XM_005769118.1\|	280463	g58612	i0	86.707	35.5727272727273	331	42	100	2	1	330	1290	961	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	11739	366	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
7940586	7940586	PRJNA1144090_P_NODE_61087_length_324_cov_600.123506_g60552_i0	PRJNA1144090	61087	324	600.123506	1944.40015944	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	76.8	1.81e-9	NTclustered	gi\|551583056\|ref\|XM_005776908.1\|	280463	g60552	i0	85.915	0.438271604938272	71	10	22	0	209	279	388	318	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	142	76.8	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
11766388	11766388	PRJNA1144090_P_NODE_80370_length_281_cov_1.480769_g79835_i0	PRJNA1144090	80370	281	1.480769	4.16096089	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	209	1.45e-49	NTclustered	gi\|551539306\|ref\|XM_005758086.1\|	280463	g79835	i0	81.538	44.7864768683274	260	42	91	6	5	261	419	163	Emiliania huxleyi CCMP1516 receptor of activated protein kinase C partial mRNA	blastn	12585	209	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
18138874	18138874	PRJNA1144090_P_NODE_24275_length_543_cov_19.178723_g23745_i0	PRJNA1144090	24275	543	19.178723	104.14046589	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	233	1.78e-56	NTclustered	gi\|551615762\|ref\|XM_005788689.1\|	280463	g23745	i0	80.872	45.8066298342541	298	55	55	2	148	444	498	794	Emiliania huxleyi CCMP1516 putative histone H2B mRNA	blastn	24873	233	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
19413338	19413338	PRJNA1144090_P_NODE_43556_length_389_cov_2.303797_g43021_i0	PRJNA1144090	43556	389	2.303797	8.96177033	Isochrysis galbana	37099	Haptophyta	other_Eukaryota	291	7.24e-74	NTclustered	gi\|34329016\|gb\|AY292373.1\|	37099	g43021	i0	82.493	84.254498714653	337	54	86	4	54	386	327	662	Isochrysis galbana glyceraldehyde-3-phosphate dehydrogenase (GAPDH) gene, partial cds	blastn	32775	291	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Isochrysidaceae	Isochrysis	Isochrysis galbana

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