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

8 rows where bioproject = "PRJNA839281" 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
2105264	2105264	PRJNA839281_S_NODE_34202_length_163_cov_0.894737_g33933_i0	PRJNA839281	34202	163	0.894737	1.45842131	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	52.8	0.014	NTclustered	gi\|551614723\|ref\|XM_005788213.1\|	280463	g33933	i0	100	0.171779141104294	28	0	17	0	7	34	509	482	Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA	blastn	28	52.8	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
5058404	5058404	PRJNA839281_S_NODE_5324_length_375_cov_4.705521_g5055_i0	PRJNA839281	5324	375	4.705521	17.64570375	Prymnesium	35143	Haptophyta	other_Eukaryota	77.8	4.74e-15	NR	KAL1520798.1	97485	g5055	i0	70.8	0.768	48	14	38.4	0	368	225	126	173	KAL1520798.1 hypothetical protein AB1Y20_022362 [Prymnesium parvum]	diamond	288	77.8	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
29675334	29675334	PRJNA839281_S_NODE_32410_length_164_cov_0.886957_g32141_i0	PRJNA839281	32410	164	0.886957	1.45460948	Prymnesium parvum	97485	Haptophyta	other_Eukaryota	61.6	2.76e-9	NR	KAL1529831.1	97485	g32141	i0	47.2	1.9390243902439	53	28	97	0	2	160	524	576	KAL1529831.1 hypothetical protein AB1Y20_000763 [Prymnesium parvum]	diamond	318	61.6	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium parvum
30686453	30686453	PRJNA839281_S_NODE_30153_length_165_cov_0.879310_g29884_i0	PRJNA839281	30153	165	0.87931	1.4508615	Chrysochromulina tobinii	1460289	Haptophyta	other_Eukaryota	50.8	1.67e-5	NR	KOO31826.1	1460289	g29884	i0	46.3	0.981818181818182	54	29	98.2	0	164	3	48	101	KOO31826.1 protein kinase [Chrysochromulina tobinii]	diamond	162	50.8	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Chrysochromulinaceae	Chrysochromulina	Chrysochromulina tobinii
31295429	31295429	PRJNA839281_S_NODE_32935_length_163_cov_1.535088_g32666_i0	PRJNA839281	32935	163	1.535088	2.50219344	Diacronema	70451	Haptophyta	other_Eukaryota	77.8	7.77e-17	NR	KAJ1629508.1	483367	g32666	i0	64.2	2.96319018404908	53	14	97.5	1	163	5	46	93	KAJ1629508.1 ribosomal protein L35A [Pavlovales sp. CCMP2436]	diamond	483	77.8	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales			Pavlovales sp. CCMP2436
31350371	31350371	PRJNA839281_S_NODE_13016_length_222_cov_1.265896_g12747_i0	PRJNA839281	13016	222	1.265896	2.81028912	Diacronema lutheri	2081491	Haptophyta	other_Eukaryota	74.7	1.38e-13	NR	KAG8458295.1	2081491	g12747	i0	61.5	3.52702702702703	52	20	70.3	0	3	158	368	419	KAG8458295.1 hypothetical protein KFE25_005142 [Diacronema lutheri]	diamond	783	74.7	1	Eukaryota	Haptista	Haptophyta	Pavlovophyceae	Pavlovales	Pavlovaceae	Diacronema	Diacronema lutheri
31666433	31666433	PRJNA839281_S_NODE_22797_length_177_cov_1.062500_g22528_i0	PRJNA839281	22797	177	1.0625	1.880625	Emiliania huxleyi CCMP1516	280463	Haptophyta	other_Eukaryota	84	4.73e-17	NR	XP_005793203.1	280463	g22528	i0	59.3	1	59	24	100	0	177	1	1366	1424	XP_005793203.1 clathrin heavy chain [Emiliania huxleyi CCMP1516]	diamond	177	84	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
32077806	32077806	PRJNA839281_S_NODE_36878_length_161_cov_0.910714_g36609_i0	PRJNA839281	36878	161	0.910714	1.46624954	Prymnesium sp.	2812485	Haptophyta	other_Eukaryota	43.1	0.00914	NR	KAL3933726.1	2812485	g36609	i0	39.6	1.99378881987578	53	32	98.8	0	3	161	3669	3721	KAL3933726.1 MAG: hypothetical protein SGPRY_000160 [Prymnesium sp.]	diamond	321	43.1	1	Eukaryota	Haptista	Haptophyta		Prymnesiales	Prymnesiaceae	Prymnesium	Prymnesium sp.

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