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

10 rows where analysis = "blastn", bioproject = "PRJNA971593" 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
3494873	3494873	PRJNA971593_P_NODE_17803_length_283_cov_0.814286_g17654_i0	PRJNA971593	17803	283	0.814286	2.30442938	Raphidocystis contractilis	2792838	Root_unresolved	Root_unresolved	315	3.02e-81	NTclustered	gi\|193811885\|dbj\|AB332032.1\|	2792838	g17654	i0	87.273	0.971731448763251	275	35	97	0	9	283	1229	955	Raphidocystis contractilis EFL mRNA for translation elongation factor-like protein, partial cds	blastn	275	315	1	Eukaryota	Haptista		Centroplasthelida	Acanthocystida	Raphidocystidae	Raphidocystis	Raphidocystis contractilis
4772464	4772464	PRJNA971593_P_NODE_13704_length_325_cov_1.515873_g13555_i0	PRJNA971593	13704	325	1.515873	4.92658725	Dicrateria rotunda	2703868	Haptophyta	other_Eukaryota	228	4.729999999999998e-55	NTclustered	gi\|259419544\|emb\|FN392559.1\|	2703868	g13555	i0	89.071	60.0615384615385	183	20	56	0	1	183	216	398	Imantonia rotunda partial mRNA for ADP-ribosylation factor 3, contig 10068	blastn	19520	228	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Isochrysidaceae	Dicrateria	Dicrateria rotunda
9872326	9872326	PRJNA971593_P_NODE_12488_length_342_cov_0.858736_g12339_i0	PRJNA971593	12488	342	0.858736	2.93687712	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	255	2.3e-63	NTclustered	gi\|551563443\|ref\|XM_005768342.1\|	280463	g12339	i0	81.47	64.5701754385965	313	56	91	2	4	315	618	307	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	22083	255	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
9872348	9872348	PRJNA971593_P_NODE_14468_length_316_cov_1.267490_g14319_i0	PRJNA971593	14468	316	1.26749	4.0052684	Raphidocystis contractilis	2792838	Root_unresolved	Root_unresolved	333	9.439999999999998e-87	NTclustered	gi\|259475611\|emb\|FN392419.1\|	2792838	g14319	i0	87.329	0.924050632911392	292	35	92	2	1	291	400	110	Raphidiophrys contractilis partial mRNA for 40S ribosomal protein S15, contig 26087	blastn	292	333	1	Eukaryota	Haptista		Centroplasthelida	Acanthocystida	Raphidocystidae	Raphidocystis	Raphidocystis contractilis
9872457	9872457	PRJNA971593_P_NODE_23248_length_250_cov_0.870056_g23099_i0	PRJNA971593	23248	250	0.870056	2.17514	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	172	1.67e-38	NTclustered	gi\|551623618\|ref\|XM_005792051.1\|	280463	g23099	i0	82.323	58.504	198	35	79	0	32	229	1059	862	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	14626	172	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
10194938	10194938	PRJNA971593_P_NODE_22668_length_250_cov_1.305085_g22519_i0	PRJNA971593	22668	250	1.305085	3.2627125	Pavlovophyceae	3435358	Haptophyta	other_Eukaryota	106	1.71e-18	NTclustered	gi\|551620801\|ref\|XM_005790860.1\|	280463	g22519	i0	83.471	1.956	121	13	47	3	134	250	1513	1396	Emiliania huxleyi CCMP1516 S-adenosyl-L-homocysteine hydrolase mRNA	blastn	489	106	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
11147844	11147844	PRJNA971593_P_NODE_21729_length_252_cov_1.290503_g21580_i0	PRJNA971593	21729	252	1.290503	3.25206756	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	226	1.2699999999999999e-54	NTclustered	gi\|551599845\|ref\|XM_005781656.1\|	280463	g21580	i0	83.004	108.837301587302	253	39	99	4	2	252	763	513	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	27427	226	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
12423301	12423301	PRJNA971593_P_NODE_10490_length_373_cov_3.330000_g10341_i0	PRJNA971593	10490	373	3.33	12.4209	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	230	1.5299999999999996e-55	NTclustered	gi\|551548842\|ref\|XM_005762007.1\|	280463	g10341	i0	80.323	3.6112600536193	310	56	82	4	26	332	412	105	Emiliania huxleyi CCMP1516 hypothetical protein mRNA	blastn	1347	230	1	Eukaryota	Haptista	Haptophyta		Isochrysidales	Noelaerhabdaceae	Emiliania	Emiliania huxleyi
13698031	13698031	PRJNA971593_P_NODE_28311_length_242_cov_0.911243_g28162_i0	PRJNA971593	28311	242	0.911243	2.20520806	Raphidocystis contractilis	2792838	Root_unresolved	Root_unresolved	204	5.69e-48	NTclustered	gi\|259475524\|emb\|FN392332.1\|	2792838	g28162	i0	82.427	1.54545454545455	239	36	97	4	9	242	575	338	Raphidiophrys contractilis partial mRNA for V-type proton ATPase 16 kDa proteolipid subunit, contig 00645	blastn	374	204	1	Eukaryota	Haptista		Centroplasthelida	Acanthocystida	Raphidocystidae	Raphidocystis	Raphidocystis contractilis
16247280	16247280	PRJNA971593_P_NODE_7613_length_441_cov_1.255435_g7464_i0	PRJNA971593	7613	441	1.255435	5.53646835	Emiliania huxleyi	2903	Haptophyta	other_Eukaryota	243	2.3600000000000007e-59	NTclustered	gi\|551605551\|ref\|XM_005784111.1\|	280463	g7464	i0	80.363	3.46258503401361	331	56	73	3	1	322	1176	1506	Emiliania huxleyi CCMP1516 putative dihydrolipoamide dehydrogenase 1 (DLD1), mRNA	blastn	1527	243	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);;