metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA1122875" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA1122875" 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_order	tax_family	tax_genus	tax_species
1552020	1552020	PRJNA1122875_P_NODE_14682_length_435_cov_3.140884_g14458_i0	PRJNA1122875	14682	435	3.140884	13.6628454	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	305	2.92e-78	NTclustered	gi\|551551158\|ref\|XM_005762979.1\|	280463	g14458	i0	92.857	73.767816091954	210	15	48	0	226	435	687	478	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	32089	305	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
4105042	4105042	PRJNA1122875_P_NODE_8004_length_576_cov_2.473161_g7786_i0	PRJNA1122875	8004	576	2.473161	14.24540736	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	291	1.11e-73	NTclustered	gi\|551548842\|ref\|XM_005762007.1\|	280463	g7786	i0	83.934	4.15625	305	47	53	2	218	521	402	99	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	2394	291	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
7930699	7930699	PRJNA1122875_P_NODE_43667_length_251_cov_0.865169_g43443_i0	PRJNA1122875	43667	251	0.865169	2.17157419	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	128	3.67e-25	NTclustered	gi\|551542013\|ref\|XM_005759177.1\|	280463	g43443	i0	80.838	3.07171314741036	167	29	66	3	86	251	497	333	Emiliania huxleyi CCMP1516 Aps1, sigma subunit of the adaptin 1 complex (Aps1-1), mRNA	blastn	771	128	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
11756485	11756485	PRJNA1122875_P_NODE_970_length_1220_cov_3.823888_g881_i0	PRJNA1122875	970	1220	3.823888	46.6514336	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	721	0	NTclustered	gi\|551602412\|ref\|XM_005782724.1\|	280463	g881	i0	83.333	62.5344262295082	786	125	64	6	427	1209	1435	653	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	76292	721	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
15580346	15580346	PRJNA1122875_P_NODE_19873_length_374_cov_1.023256_g19649_i0	PRJNA1122875	19873	374	1.023256	3.82697744	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	60.2	2.13e-4	NTclustered	gi\|551552913\|ref\|XM_005763745.1\|	280463	g19649	i0	94.737	8.03475935828877	38	2	10	0	34	71	305	342	Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA	blastn	3005	60.2	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
18129457	18129457	PRJNA1122875_P_NODE_3835_length_777_cov_4.485795_g3643_i0	PRJNA1122875	3835	777	4.485795	34.85462715	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	342	4.13e-89	NTclustered	gi\|551555214\|ref\|XM_005764747.1\|	280463	g3643	i0	80.674	33.7065637065637	445	82	57	4	4	446	1182	1624	Emiliania huxleyi CCMP1516 putative propionyl-CoA carboxylase (ACC-3), partial mRNA	blastn	26190	342	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
18129495	18129495	PRJNA1122875_P_NODE_41835_length_255_cov_1.423077_g41611_i0	PRJNA1122875	41835	255	1.423077	3.62884635	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	65.8	2.98e-6	NTclustered	gi\|551582096\|ref\|XM_005776471.1\|	280463	g41611	i0	93.182	5.14901960784314	44	3	17	0	14	57	1020	977	Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA	blastn	1313	65.8	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi

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