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

10 rows where analysis = "blastn", bioproject = "PRJNA741997" 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
1198139	1198139	PRJNA741997_P_NODE_69781_length_255_cov_1.467033_g68661_i0	PRJNA741997	69781	255	1.467033	3.74093415	root	1	Root_unresolved	Root_unresolved	174	4.74e-39	NTclustered	gi\|551583408\|ref\|XM_005777084.1\|	280463	g68661	i0	84.659	63.8549019607843	176	25	69	2	70	244	1355	1181	Emiliania huxleyi CCMP1516 isocitrate dehydrogenase, NADP-dependent (IDH1), mRNA	blastn	16283	174	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
1997538	1997538	PRJNA741997_P_NODE_50142_length_305_cov_1.129310_g49022_i0	PRJNA741997	50142	305	1.12931	3.4443955	Isochrysis galbana	37099	Haptophyta	other_Eukaryota	163	1.26e-35	NTclustered	gi\|59894147\|gb\|AY729856.1\|	37099	g49022	i0	77.023	11.9967213114754	309	55	99	14	1	301	1725	1425	Isochrysis galbana heat shock protein 90 gene, partial cds	blastn	3659	163	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Isochrysidaceae	Isochrysis	Isochrysis galbana
6302153	6302153	PRJNA741997_P_NODE_34925_length_368_cov_1.010169_g33805_i0	PRJNA741997	34925	368	1.010169	3.71742192	root	1	Root_unresolved	Root_unresolved	180	1.54e-40	NTclustered	gi\|551605026\|ref\|XM_005783894.1\|	280463	g33805	i0	83.417	60.6983695652174	199	28	53	4	136	330	989	1186	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	22337	180	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
13475316	13475316	PRJNA741997_P_NODE_44231_length_326_cov_1.533597_g43111_i0	PRJNA741997	44231	326	1.533597	4.99952622	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	204	7.99e-48	NTclustered	gi\|551555214\|ref\|XM_005764747.1\|	280463	g43111	i0	79.344	50.6656441717791	305	52	93	7	1	304	1270	1564	Emiliania huxleyi CCMP1516 putative propionyl-CoA carboxylase (ACC-3), partial mRNA	blastn	16517	204	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
14750690	14750690	PRJNA741997_P_NODE_90532_length_233_cov_2.275000_g89412_i0	PRJNA741997	90532	233	2.275	5.30075	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	121	5.64e-23	NTclustered	gi\|551557601\|ref\|XM_005765767.1\|	280463	g89412	i0	85.841	4.38197424892704	113	16	48	0	6	118	5129	5017	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	1021	121	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
16024136	16024136	PRJNA741997_P_NODE_57513_length_283_cov_1.538095_g56393_i0	PRJNA741997	57513	283	1.538095	4.35280885	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	204	6.809999999999998e-48	NTclustered	gi\|551615633\|ref\|XM_005788628.1\|	280463	g56393	i0	80.755	51.1272084805654	265	47	93	4	20	282	1131	869	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	14469	204	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
17299681	17299681	PRJNA741997_P_NODE_59154_length_280_cov_1.115942_g58034_i0	PRJNA741997	59154	280	1.115942	3.1246376	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	167	8.83e-37	NTclustered	gi\|551544771\|ref\|XM_005760371.1\|	280463	g58034	i0	80.087	3.24285714285714	231	40	81	6	4	231	64	291	Emiliania huxleyi CCMP1516 ADP-ribosylation factor (Arf1), partial mRNA	blastn	908	167	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
17299849	17299849	PRJNA741997_P_NODE_87034_length_242_cov_1.366864_g85914_i0	PRJNA741997	87034	242	1.366864	3.30781088	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	165	2.68e-36	NTclustered	gi\|551593238\|ref\|XM_005780539.1\|	280463	g85914	i0	83.908	68.2190082644628	174	26	71	2	29	201	415	587	Emiliania huxleyi CCMP1516 arginine-tRNA ligase mRNA	blastn	16509	165	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
21600324	21600324	PRJNA741997_P_NODE_56657_length_285_cov_1.452830_g55537_i0	PRJNA741997	56657	285	1.45283	4.1405655	Emiliania	2902	Haptophyta	other_Eukaryota	56.5	0.002	NTclustered	gi\|112143949\|gb\|DQ658352.1\|	2903	g55537	i0	94.444	0.378947368421053	36	2	13	0	219	254	984	949	Emiliania huxleyi clone Plate2_K11_compl;77-2-35-H12 hypothetical protein, complete cds	blastn	108	56.5	1	Eukaryota	Haptista	Haptophyta	Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
24947786	24947786	PRJNA741997_P_NODE_20060_length_513_cov_1.459091_g18945_i0	PRJNA741997	20060	513	1.459091	7.48513683	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	300	1.62e-76	NTclustered	gi\|551555356\|ref\|XM_005764818.1\|	280463	g18945	i0	78.775	26.9025341130604	457	89	88	8	52	504	963	511	Emiliania huxleyi CCMP1516 mitochondrial malic enzyme (NAD-ME_2), partial mRNA	blastn	13801	300	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);;