metadata: contig_metadata: 8 rows where bioproject = "PRJEB14175" and tax

8 rows where bioproject = "PRJEB14175" 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
25611041	25611041	PRJEB14175_P_NODE_65009_length_459_cov_2.592965_g62752_i0	PRJEB14175	65009	459	2.592965	11.90170935	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	496	1.7099999999999998e-135	NTclustered	gi\|551551158\|ref\|XM_005762979.1\|	280463	g62752	i0	91.033	191.821350762527	368	31	80	2	86	452	695	329	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	88046	501	0.99001996007984	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
25911334	25911334	PRJEB14175_P_NODE_145732_length_282_cov_2.624434_g143465_i0	PRJEB14175	145732	282	2.624434	7.40090388	Dicrateria rotunda	2703868	Haptophyta	other_Eukaryota	73.1	2e-8	NTclustered	gi\|259419564\|emb\|FN392579.1\|	2703868	g143465	i0	83.333	1.23758865248227	84	8	29	6	175	255	187	107	Imantonia rotunda partial mRNA for 60S ribosomal protein L3, contig 19007	blastn	349	73.1	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Isochrysidaceae	Dicrateria	Dicrateria rotunda
25919868	25919868	PRJEB14175_P_NODE_79924_length_408_cov_20.121037_g77662_i0	PRJEB14175	79924	408	20.121037	82.09383096	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	52.8	0.039	NTclustered	gi\|551570948\|ref\|XM_005771335.1\|	280463	g77662	i0	100	0.137254901960784	28	0	7	0	117	144	24	51	Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA	blastn	56	52.8	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
25920663	25920663	PRJEB14175_P_NODE_94380_length_370_cov_12.365696_g92114_i0	PRJEB14175	94380	370	12.365696	45.7530752	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	165	4.33e-36	NTclustered	gi\|551624444\|ref\|XM_005792404.1\|	280463	g92114	i0	85.093	20.8783783783784	161	24	44	0	68	228	36	196	Emiliania huxleyi CCMP1516 ribosomal protein S8 partial mRNA	blastn	7725	165	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
32926149	32926149	PRJEB14175_P_NODE_194897_length_232_cov_2.461988_g192630_i0	PRJEB14175	194897	232	2.461988	5.71181216	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	43.9	0.0127	NR	KAL1503645.1	97485	g192630	i0	40.8	0.633620689655172	49	29	63.4	0	29	175	471	519	KAL1503645.1 hypothetical protein AB1Y20_012119 [Prymnesium parvum]	diamond	147	43.9	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
33063760	33063760	PRJEB14175_P_NODE_69901_length_441_cov_3.844737_g67643_i0	PRJEB14175	69901	441	3.844737	16.95529017	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	62.4	4.29e-8	NR	KAG8463118.1	2081491	g67643	i0	39.3	0.571428571428571	84	50	56.5	1	418	170	675	758	KAG8463118.1 hypothetical protein KFE25_011115 [Diacronema lutheri]	diamond	252	62.4	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
33080472	33080472	PRJEB14175_P_NODE_26942_length_713_cov_6.059816_g24914_i0	PRJEB14175	26942	713	6.059816	43.20648808	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	111	4.55e-25	NR	KOO28346.1	1460289	g24914	i0	40.7	0.681626928471248	162	90	66.9	3	148	624	148	306	KOO28346.1 von willebrand factor type a domain containing protein [Chrysochromulina tobinii]	diamond	486	111	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
33080659	33080659	PRJEB14175_P_NODE_48190_length_537_cov_26.233193_g45961_i0	PRJEB14175	48190	537	26.233193	140.87224641	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	62	6e-9	NR	KAL1526574.1	97485	g45961	i0	42.9	0.391061452513966	70	38	38.5	2	3	209	11	79	KAL1526574.1 hypothetical protein AB1Y20_015281 [Prymnesium parvum]	diamond	210	62	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);;