metadata: contig_metadata: 10 rows where bioproject = "PRJNA1120203" and tax

10 rows where bioproject = "PRJNA1120203" 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
11230990	11230990	PRJNA1120203_P_NODE_31589_length_417_cov_3.497093_g30574_i0	PRJNA1120203	31589	417	3.497093	14.58287781	root	1	Root_unresolved	Root_unresolved	555	2.51e-153	NTclustered	gi\|523420608\|ref\|NC_016703.2\|	33657	g30574	i0	91.542	104.280575539568	402	34	96	0	3	404	42183	42584	Phaeocystis antarctica strain CCMP1374 plastid, complete genome	blastn	43485	555	1	Eukaryota	Haptista	Haptophyta		Phaeocystales	Phaeocystaceae	Phaeocystis	Phaeocystis antarctica
16330404	16330404	PRJNA1120203_P_NODE_59513_length_291_cov_53.077982_g58497_i0	PRJNA1120203	59513	291	53.077982	154.45692762	root	1	Root_unresolved	Root_unresolved	250	8.909999999999999e-62	NTclustered	gi\|2059554210\|gb\|MZ469751.1\|	40639	g58497	i0	99.275	95.766323024055	138	1	94	0	141	278	269	406	Isochrysis sp. strain DAD-ALGEUK-23 large subunit ribosomal RNA gene, partial sequence; chloroplast	blastn	27868	252	0.992063492063492	Eukaryota	Haptista	Haptophyta		Isochrysidales	Isochrysidaceae	Isochrysis	Isochrysis sp.
17605343	17605343	PRJNA1120203_P_NODE_33714_length_400_cov_27.611621_g32699_i0	PRJNA1120203	33714	400	27.611621	110.446484	Pavlovaceae	418969	Haptophyta	other_Eukaryota	396	1.5399999999999995e-105	NTclustered	gi\|456061976\|ref\|NC_020371.1\|	2081491	g32699	i0	98.23	94.8525	226	4	94	0	163	388	2235	2460	Pavlova lutheri chloroplast, complete genome	blastn	37941	396	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
20154316	20154316	PRJNA1120203_P_NODE_55636_length_302_cov_71.078603_g54620_i0	PRJNA1120203	55636	302	71.078603	214.65738106	root	1	Root_unresolved	Root_unresolved	250	9.29e-62	NTclustered	gi\|2059554210\|gb\|MZ469751.1\|	40639	g54620	i0	99.275	90.5066225165563	138	1	46	0	152	289	269	406	Isochrysis sp. strain DAD-ALGEUK-23 large subunit ribosomal RNA gene, partial sequence; chloroplast	blastn	27333	252	0.992063492063492	Eukaryota	Haptista	Haptophyta		Isochrysidales	Isochrysidaceae	Isochrysis	Isochrysis sp.
28649226	28649226	PRJNA1120203_P_NODE_78327_length_251_cov_0.865169_g77311_i0	PRJNA1120203	78327	251	0.865169	2.17157419	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	47.4	8.84e-4	NR	XP_005793414.1	280463	g77311	i0	38.5	0.621513944223108	52	31	62.2	1	157	2	5	55	XP_005793414.1 hypothetical protein EMIHUDRAFT_222007 [Emiliania huxleyi CCMP1516]	diamond	156	47.4	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
29533203	29533203	PRJNA1120203_P_NODE_78550_length_251_cov_0.865169_g77534_i0	PRJNA1120203	78550	251	0.865169	2.17157419	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	98.2	1.46e-22	NR	KAL1522136.1	97485	g77534	i0	58	0.968127490039841	81	34	96.8	0	1	243	143	223	KAL1522136.1 hypothetical protein AB1Y20_021777 [Prymnesium parvum]	diamond	243	98.2	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
29690701	29690701	PRJNA1120203_P_NODE_87870_length_248_cov_0.880000_g86854_i0	PRJNA1120203	87870	248	0.88	2.1824	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	93.2	5.43e-20	NR	KAL1522970.1	97485	g86854	i0	61.3	0.907258064516129	75	29	90.7	0	19	243	52	126	KAL1522970.1 hypothetical protein AB1Y20_017934 [Prymnesium parvum]	diamond	225	93.2	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
30070020	30070020	PRJNA1120203_P_NODE_92592_length_246_cov_0.890173_g91576_i0	PRJNA1120203	92592	246	0.890173	2.18982558	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	92	1.69e-19	NR	KAL1523589.1	97485	g91576	i0	76.9	0.634146341463415	52	12	63.4	0	244	89	465	516	KAL1523589.1 hypothetical protein AB1Y20_018525 [Prymnesium parvum]	diamond	156	92	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
30638633	30638633	PRJNA1120203_P_NODE_100773_length_243_cov_0.905882_g99757_i0	PRJNA1120203	100773	243	0.905882	2.20129326	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	109	4.09e-26	NR	KOO35829.1	1460289	g99757	i0	66.7	1	81	23	100	1	1	243	255	331	KOO35829.1 ph domain-containing protein [Chrysochromulina tobinii]	diamond	243	109	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
32662071	32662071	PRJNA1120203_P_NODE_81820_length_250_cov_0.870056_g80804_i0	PRJNA1120203	81820	250	0.870056	2.17514	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	59.3	3.28e-8	NR	KOO33684.1	1460289	g80804	i0	37.3	0.804	67	42	80.4	0	48	248	1	67	KOO33684.1 hypothetical protein Ctob_014736 [Chrysochromulina tobinii]	diamond	201	59.3	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);;