metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA744060" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA744060" 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
4551964	4551964	PRJNA744060_P_NODE_40704_length_261_cov_1.563830_g40375_i0	PRJNA744060	40704	261	1.56383	4.0815963	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	121	6.429999999999999e-23	NTclustered	gi\|551542407\|ref\|XM_005759334.1\|	280463	g40375	i0	84.553	6.55938697318008	123	17	47	2	15	136	682	561	Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA	blastn	1712	121	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
10927058	10927058	PRJNA744060_P_NODE_21909_length_346_cov_1.457875_g21580_i0	PRJNA744060	21909	346	1.457875	5.0442475	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	54.7	0.009	NTclustered	gi\|551612973\|ref\|XM_005787429.1\|	280463	g21580	i0	100	0.0838150289017341	29	0	8	0	318	346	4975	4947	Emiliania huxleyi CCMP1516 hypothetical protein partial mRNA	blastn	29	54.7	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
14752344	14752344	PRJNA744060_P_NODE_40172_length_262_cov_2.560847_g39843_i0	PRJNA744060	40172	262	2.560847	6.70941914	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	106	1.81e-18	NTclustered	gi\|551624680\|ref\|XM_005792486.1\|	280463	g39843	i0	87.234	31.7137404580153	94	11	36	1	4	97	600	692	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	8309	106	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
16025626	16025626	PRJNA744060_P_NODE_18033_length_379_cov_73.071895_g17704_i0	PRJNA744060	18033	379	73.071895	276.94248205	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	230	1.5499999999999996e-55	NTclustered	gi\|551548842\|ref\|XM_005762007.1\|	280463	g17704	i0	80.323	3.55408970976253	310	56	81	4	28	334	412	105	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	1347	230	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
16026103	16026103	PRJNA744060_P_NODE_4413_length_748_cov_6.697778_g4118_i0	PRJNA744060	4413	748	6.697778	50.09937944	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	300	2.42e-76	NTclustered	gi\|551548842\|ref\|XM_005762007.1\|	280463	g4118	i0	84.59	6.86898395721925	305	43	41	4	379	681	402	100	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	5138	300	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
17301698	17301698	PRJNA744060_P_NODE_50954_length_242_cov_1.881657_g50625_i0	PRJNA744060	50954	242	1.881657	4.55360994	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	187	5.73e-43	NTclustered	gi\|551563443\|ref\|XM_005768342.1\|	280463	g50625	i0	81.277	92.2685950413223	235	40	96	4	4	236	556	788	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	22329	187	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
19050255	19050255	PRJNA744060_P_NODE_46035_length_249_cov_9.710227_g45706_i0	PRJNA744060	46035	249	9.710227	24.17846523	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	267	7.39e-67	NTclustered	gi\|551606591\|ref\|XM_005784584.1\|	280463	g45706	i0	94.253	119.21686746988	174	10	70	0	1	174	257	84	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	29685	267	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
19849913	19849913	PRJNA744060_P_NODE_11556_length_471_cov_2.670854_g11228_i0	PRJNA744060	11556	471	2.670854	12.57972234	Isochrysis galbana	37099	Haptophyta	other_Eukaryota	294	6.89e-75	NTclustered	gi\|40949675\|gb\|AY430418.1\|	37099	g11228	i0	78.39	76.1677282377919	472	88	98	12	6	467	493	960	Isochrysis galbana enolase gene, partial cds	blastn	35875	294	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Isochrysidaceae	Isochrysis	Isochrysis galbana
21126073	21126073	PRJNA744060_P_NODE_44437_length_252_cov_1.307263_g44108_i0	PRJNA744060	44437	252	1.307263	3.29430276	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	152	2.19e-32	NTclustered	gi\|551535072\|ref\|XM_005756305.1\|	280463	g44108	i0	77.866	3.75396825396825	253	50	99	5	1	250	695	446	Emiliania huxleyi CCMP1516 cell division cycle protein 48 mRNA	blastn	946	152	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
23675902	23675902	PRJNA744060_P_NODE_11819_length_466_cov_1.885496_g11491_i0	PRJNA744060	11819	466	1.885496	8.78641136	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	268	4.13e-67	NTclustered	gi\|551539721\|ref\|XM_005758255.1\|	280463	g11491	i0	78.894	9.30901287553648	398	82	85	2	70	466	1429	1825	Emiliania huxleyi CCMP1516 ATP-dependent RNA helicase mRNA	blastn	4338	268	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);;