metadata: contig_metadata: 10 rows where bioproject = "PRJNA657343", tax_clade = "Haptista" and tax

10 rows where bioproject = "PRJNA657343", tax_clade = "Haptista" and tax_superkingdom = "Eukaryota"

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
18475339	18475339	PRJNA657343_P_NODE_33695_length_171_cov_1.827869_g33671_i0	PRJNA657343	33695	171	1.827869	3.12565599	Dicrateria rotunda	2703868	Haptophyta	other_Eukaryota	231	1.71e-56	NTclustered	gi\|259419547\|emb\|FN392562.1\|	2703868	g33671	i0	92.547	100.321637426901	161	12	94	0	5	165	37	197	Imantonia rotunda partial mRNA for calmodulin, contig 03038	blastn	17155	231	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Isochrysidaceae	Dicrateria	Dicrateria rotunda
19749832	19749832	PRJNA657343_P_NODE_21756_length_201_cov_1.342105_g21732_i0	PRJNA657343	21756	201	1.342105	2.69763105	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	102	2.8899999999999995e-23	NR	KOO23743.1	1460289	g21732	i0	75.4	0.970149253731343	65	16	97	0	201	7	488	552	KOO23743.1 protein kinase domain-containing protein [Chrysochromulina tobinii]	diamond	195	102	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
26860190	26860190	PRJNA657343_P_NODE_3241_length_408_cov_2.292479_g3218_i0	PRJNA657343	3241	408	2.292479	9.35331432	Pavlovales sp. CCMP2436	483367	Haptophyta	other_Eukaryota	69.7	4.63e-11	NR	KAJ1619003.1	483367	g3218	i0	50	0.411764705882353	56	28	41.2	0	237	404	15	70	KAJ1619003.1 hypothetical protein T492DRAFT_1088881 [Pavlovales sp. CCMP2436]	diamond	168	69.7	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
28514784	28514784	PRJNA657343_P_NODE_15247_length_229_cov_4.172222_g15223_i0	PRJNA657343	15247	229	4.172222	9.55438838	Pavlovophyceae	3435358	Haptophyta	other_Eukaryota	77.8	1.42e-14	NR	KOO35527.1	1460289	g15223	i0	63.2	3.78602620087336	57	21	74.7	0	223	53	79	135	KOO35527.1 acyl carrier protein [Chrysochromulina tobinii]	diamond	867	78.2	0.994884910485933	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
28546583	28546583	PRJNA657343_P_NODE_3807_length_384_cov_1.997015_g3784_i0	PRJNA657343	3807	384	1.997015	7.6685376	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	103	4.4299999999999996e-24	NR	KAL1508382.1	97485	g3784	i0	51	5.328125	96	43	71.9	1	6	281	156	251	KAL1508382.1 hypothetical protein AB1Y20_004492 [Prymnesium parvum]	diamond	2046	103	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
29020238	29020238	PRJNA657343_P_NODE_34988_length_169_cov_1.225000_g34964_i0	PRJNA657343	34988	169	1.225	2.07025	Noelaerhabdaceae	418966	Haptophyta	other_Eukaryota	80.5	6.19e-16	NR	ALD47974.1	2903	g34964	i0	61.4	6.92307692307692	57	19	95.9	1	166	5	212	268	ALD47974.1 adaptor protein complex 2 subunit mu [Emiliania huxleyi]	diamond	1170	80.5	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
29102562	29102562	PRJNA657343_P_NODE_42668_length_163_cov_1.324561_g42644_i0	PRJNA657343	42668	163	1.324561	2.15903443	Pavlovales sp. CCMP2436	483367	Haptophyta	other_Eukaryota	60.1	7.94e-9	NR	KAJ1619003.1	483367	g42644	i0	52	0.920245398773006	50	22	92	1	14	163	202	249	KAJ1619003.1 hypothetical protein T492DRAFT_1088881 [Pavlovales sp. CCMP2436]	diamond	150	60.1	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
31313663	31313663	PRJNA657343_P_NODE_3615_length_392_cov_1.985423_g3592_i0	PRJNA657343	3615	392	1.985423	7.78285816	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	68.2	2.58e-10	NR	KAL1530918.1	97485	g3592	i0	34.3	1.02551020408163	134	75	95.7	6	385	11	706	835	KAL1530918.1 hypothetical protein AB1Y20_001809 [Prymnesium parvum]	diamond	402	68.2	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
31882940	31882940	PRJNA657343_P_NODE_43017_length_163_cov_0.912281_g42993_i0	PRJNA657343	43017	163	0.912281	1.48701803	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	48.5	8.98e-5	NR	XP_005781115.1	280463	g42993	i0	52.3	1.61963190184049	44	20	79.1	1	9	137	93	136	XP_005781115.1 hypothetical protein EMIHUDRAFT_49339, partial [Emiliania huxleyi CCMP1516]	diamond	264	48.5	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
32104481	32104481	PRJNA657343_P_NODE_36378_length_168_cov_0.873950_g36354_i0	PRJNA657343	36378	168	0.87395	1.468236	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	52.4	5.09e-6	NR	KAL1508547.1	97485	g36354	i0	58.7	0.821428571428571	46	14	73.2	1	168	46	249	294	KAL1508547.1 hypothetical protein AB1Y20_004646 [Prymnesium parvum]	diamond	138	52.4	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);;