metadata: contig_metadata: 7 rows where bioproject = "PRJNA685607", tax_clade = "Sar" and tax

7 rows where bioproject = "PRJNA685607", tax_clade = "Sar" and tax_phylum = "Cercozoa"

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
5769865	5769865	PRJNA685607_P_NODE_16545_length_403_cov_1.472727_g16187_i0	PRJNA685607	16545	403	1.472727	5.93508981	Bodomorpha minima	188950	SAR_Eukaryotes	SAR_Eukaryotes	257	7.630000000000001e-64	NTclustered	gi\|238617630\|gb\|FJ973394.1\|	188950	g16187	i0	79.614	87.9032258064516	363	70	90	4	38	398	697	337	Bodomorpha minima strain ATCC 50339 actin (act) gene, partial cds	blastn	35425	257	1	Eukaryota	Sar	Cercozoa		Glissomonadida	Viridiraptoridae	Bodomorpha	Bodomorpha minima
8319419	8319419	PRJNA685607_P_NODE_33647_length_318_cov_1.257143_g33288_i0	PRJNA685607	33647	318	1.257143	3.99771474	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	195	4.68e-45	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g33288	i0	91.096	52.1006289308176	146	10	45	3	1	143	3695	3840	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	16568	195	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
18518539	18518539	PRJNA685607_P_NODE_80475_length_246_cov_0.890173_g80116_i0	PRJNA685607	80475	246	0.890173	2.18982558	Thaumatomonas	45099	SAR_Eukaryotes	SAR_Eukaryotes	139	1.29e-36	NR	AAP72162.1	188940	g80116	i0	87.7	14.8170731707317	81	10	98.8	0	1	243	315	395	AAP72162.1 heat shock protein 90, partial [Thaumatomonas sp. (SA)]	diamond	3645	139	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida	Thaumatomastigidae	Thaumatomonas	Thaumatomonas sp. (SA)
27777346	27777346	PRJNA685607_P_NODE_69464_length_250_cov_0.870056_g69105_i0	PRJNA685607	69464	250	0.870056	2.17514	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	60.1	1.42e-8	NR	MES1908406.1	1215613	g69105	i0	36.1	0.996	83	52	98.4	1	249	4	35	117	MES1908406.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	249	60.1	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
28629885	28629885	PRJNA685607_P_NODE_10547_length_482_cov_1.200489_g10191_i0	PRJNA685607	10547	482	1.200489	5.78635698	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	124	4.0399999999999996e-32	NR	MES1908571.1	1215613	g10191	i0	47.1	0.952282157676348	153	80	94.6	1	458	3	59	211	MES1908571.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	459	124	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
29829434	29829434	PRJNA685607_P_NODE_21231_length_369_cov_1.040541_g20872_i0	PRJNA685607	21231	369	1.040541	3.83959629	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	174	8.43e-52	NR	ADK26624.1	323453	g20872	i0	67.5	1	123	40	100	0	369	1	124	246	ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74]	diamond	369	174	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
30240242	30240242	PRJNA685607_P_NODE_10032_length_492_cov_1.219570_g9676_i0	PRJNA685607	10032	492	1.21957	6.0002844	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	206	1.69e-63	NR	ADK26624.1	323453	g9676	i0	62.1	0.981707317073171	161	61	98.2	0	486	4	113	273	ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74]	diamond	483	206	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74

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