metadata: contig_metadata: 6 rows where bioproject = "PRJNA1105232", tax_clade = "Haptista" and tax

6 rows where bioproject = "PRJNA1105232", tax_clade = "Haptista" 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_class	tax_order	tax_family	tax_genus	tax_species
18064238	18064238	PRJNA1105232_S_NODE_12475_length_184_cov_0.911111_g12259_i0	PRJNA1105232	12475	184	0.911111	1.67644424	Pavlovales sp. CCMP2436	483367	Haptophyta	other_Eukaryota	90.5	2.59e-19	NR	KAJ1627390.1	483367	g12259	i0	61.7	7.80978260869565	60	23	97.8	0	181	2	2076	2135	KAJ1627390.1 Sec63 Brl domain-containing protein [Pavlovales sp. CCMP2436]	diamond	1437	90.5	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
26941017	26941017	PRJNA1105232_S_NODE_10222_length_200_cov_1.377483_g10006_i0	PRJNA1105232	10222	200	1.377483	2.754966	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	61.2	8.59e-10	NR	KAG8467790.1	2081491	g10006	i0	42.4	0.99	66	38	99	0	2	199	56	121	KAG8467790.1 hypothetical protein KFE25_006842 [Diacronema lutheri]	diamond	198	61.2	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
30794309	30794309	PRJNA1105232_S_NODE_8094_length_219_cov_2.305882_g7878_i0	PRJNA1105232	8094	219	2.305882	5.04988158	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	82.8	2.17e-16	NR	KAG8466765.1	2081491	g7878	i0	49.4	1.10958904109589	81	33	100	2	1	219	266	346	KAG8466765.1 hypothetical protein KFE25_008144 [Diacronema lutheri]	diamond	243	82.8	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
31354653	31354653	PRJNA1105232_S_NODE_6316_length_242_cov_1.077720_g6100_i0	PRJNA1105232	6316	242	1.07772	2.6080824	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	55.8	2.77e-7	NR	KAL1520798.1	97485	g6100	i0	63.4	1.51239669421488	41	15	50.8	0	242	120	133	173	KAL1520798.1 hypothetical protein AB1Y20_022362 [Prymnesium parvum]	diamond	366	56.2	0.99288256227758	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
32240577	32240577	PRJNA1105232_S_NODE_13738_length_176_cov_2.669291_g13522_i0	PRJNA1105232	13738	176	2.669291	4.69795216	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	53.5	2.27e-6	NR	XP_005789617.1	280463	g13522	i0	56.5	11.3352272727273	46	20	78.4	0	37	174	279	324	XP_005789617.1 GPB1, beta subunit of a heterotrimeric G-protein [Emiliania huxleyi CCMP1516]	diamond	1995	53.5	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
32525467	32525467	PRJNA1105232_S_NODE_9039_length_210_cov_1.937888_g8823_i0	PRJNA1105232	9039	210	1.937888	4.0695648	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	70.1	4.04e-12	NR	KAL1525934.1	97485	g8823	i0	44.7	2.07142857142857	76	35	98.6	1	1	207	220	295	KAL1525934.1 hypothetical protein AB1Y20_020760 [Prymnesium parvum]	diamond	435	70.1	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum

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