metadata: contig_metadata: 5 rows where bioproject = "PRJEB12982" and tax

5 rows where bioproject = "PRJEB12982" 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
3847187	3847187	PRJEB12982_P_NODE_19444_length_163_cov_1.342105_g19281_i0	PRJEB12982	19444	163	1.342105	2.18763115	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	88.6	3.44e-20	NR	KAG8463376.1	2081491	g19281	i0	71.2	2.83435582822086	52	15	95.7	0	158	3	83	134	KAG8463376.1 hypothetical protein KFE25_004887 [Diacronema lutheri]	diamond	462	88.6	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
28738445	28738445	PRJEB12982_P_NODE_19047_length_164_cov_0.886957_g18884_i0	PRJEB12982	19047	164	0.886957	1.45460948	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	48.1	1.56e-4	NR	KOO22442.1	1460289	g18884	i0	56.4	1.48170731707317	39	15	67.7	1	157	47	99	137	KOO22442.1 upf0602 protein [Chrysochromulina tobinii]	diamond	243	48.1	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
30728091	30728091	PRJEB12982_P_NODE_18594_length_165_cov_0.879310_g18431_i0	PRJEB12982	18594	165	0.87931	1.4508615	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	67	4.06e-12	NR	KAG8465585.1	2081491	g18431	i0	57.4	11.7272727272727	54	23	98.2	0	165	4	68	121	KAG8465585.1 hypothetical protein KFE25_002892 [Diacronema lutheri]	diamond	1935	67	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
31290505	31290505	PRJEB12982_P_NODE_19515_length_163_cov_0.894737_g19352_i0	PRJEB12982	19515	163	0.894737	1.45842131	root	1	Root_unresolved	Root_unresolved	53.5	4.09e-7	NR	XP_005780270.1	280463	g19352	i0	76.7	5.04294478527607	30	7	55.2	0	73	162	86	115	XP_005780270.1 FKBP-type peptidyl-prolyl cis-trans isomerase, partial [Emiliania huxleyi CCMP1516]	diamond	822	53.9	0.992578849721707	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
32499366	32499366	PRJEB12982_P_NODE_16839_length_167_cov_0.864407_g16676_i0	PRJEB12982	16839	167	0.864407	1.44355969	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	105	4.67e-26	NR	KOO21533.1	1460289	g16676	i0	87	1.94011976047904	54	7	97	0	166	5	1	54	KOO21533.1 prolyl-tRNA synthetase [Chrysochromulina tobinii]	diamond	324	105	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii

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