metadata: contig_metadata: 11 rows where bioproject = "PRJNA917598", tax_clade = "Sar" and tax

11 rows where bioproject = "PRJNA917598", 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
2527224	2527224	PRJNA917598_P_NODE_66782_length_278_cov_1.502439_g65838_i0	PRJNA917598	66782	278	1.502439	4.17678042	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	93.5	1.51e-14	NTclustered	gi\|220983369\|dbj\|AB453005.1\|	29199	g65838	i0	90.141	8.96043165467626	71	7	26	0	1	71	3024	3094	Chlorarachnion reptans gene for nuclear large subunit ribosomal RNA, partial sequence	blastn	2491	93.5	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Chlorarachnion	Chlorarachnion reptans
8549706	8549706	PRJNA917598_P_NODE_71567_length_269_cov_1.081633_g70623_i0	PRJNA917598	71567	269	1.081633	2.90959277	Thaumatomonas sp. TMT002	407209	SAR_Eukaryotes	SAR_Eukaryotes	272	1.74e-68	NTclustered	gi\|116222248\|gb\|DQ980510.1\|	407209	g70623	i0	85.659	95.9144981412639	258	37	96	0	1	258	109	366	Thaumatomonas sp. TMT002 alpha tubulin gene, partial cds	blastn	25801	272	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida	Thaumatomastigidae	Thaumatomonas	Thaumatomonas sp. TMT002
11098830	11098830	PRJNA917598_P_NODE_14589_length_617_cov_2.097426_g13655_i0	PRJNA917598	14589	617	2.097426	12.94111842	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	256	8.81e-85	NR	ADK26622.1	323453	g13655	i0	94.6	0.632090761750405	130	7	63.2	0	575	186	1	130	ADK26622.1 rps22a [Heteromita sp. PRA-74]	diamond	390	256	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
13649814	13649814	PRJNA917598_P_NODE_49491_length_326_cov_1.217391_g48547_i0	PRJNA917598	49491	326	1.217391	3.96869466	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	186	9.47e-57	NR	ADK26624.1	323453	g48547	i0	89.8	0.901840490797546	98	10	90.2	0	1	294	179	276	ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74]	diamond	294	186	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
14923259	14923259	PRJNA917598_P_NODE_14032_length_630_cov_1.062837_g13099_i0	PRJNA917598	14032	630	1.062837	6.6958731	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	278	9.48e-70	NTclustered	gi\|300676723\|gb\|GQ377712.1\|	323453	g13099	i0	78.846	13.4619047619048	416	85	66	3	1	415	423	10	Heteromita sp. PRA-74 elongation factor 2 (ef2) mRNA, partial cds	blastn	8481	278	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
16198558	16198558	PRJNA917598_P_NODE_29093_length_426_cov_3.059490_g28149_i0	PRJNA917598	29093	426	3.05949	13.0334274	Rosculus hawesi	2231161	SAR_Eukaryotes	SAR_Eukaryotes	776	0	NTclustered	gi\|1402550477\|gb\|MH488763.1\|	2231161	g28149	i0	99.531	11.1384976525822	426	2	100	0	1	426	26	451	Rosculus hawesi isolate C1C small subunit ribosomal RNA gene, partial sequence	blastn	4745	776	1	Eukaryota	Sar	Cercozoa			Guttulinopsidae	Rosculus	Rosculus hawesi
16199878	16199878	PRJNA917598_P_NODE_80213_length_251_cov_0.865169_g79269_i0	PRJNA917598	80213	251	0.865169	2.17157419	Cercomonas sp. HFCC53	458867	SAR_Eukaryotes	SAR_Eukaryotes	459	1.1499999999999996e-124	NTclustered	gi\|161015705\|gb\|EF681939.1\|	458867	g79269	i0	99.602	11.0557768924303	251	1	100	0	1	251	253	503	Cercomonas sp. HFCC53 28S ribosomal RNA gene, partial sequence	blastn	2775	459	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Cercomonadidae	Cercomonas	Cercomonas sp. HFCC53
17474228	17474228	PRJNA917598_P_NODE_41914_length_354_cov_4.533808_g40970_i0	PRJNA917598	41914	354	4.533808	16.04968032	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	387	8.08e-103	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g40970	i0	86.761	61.3841807909604	355	37	99	10	1	350	3659	4008	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	21730	387	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
20022810	20022810	PRJNA917598_P_NODE_46076_length_338_cov_1.452830_g45132_i0	PRJNA917598	46076	338	1.45283	4.9105654	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	221	5.31e-72	NR	ADK47156.1	323453	g45132	i0	95.5	0.994082840236686	112	5	99.4	0	1	336	17	128	ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74]	diamond	336	221	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
27561549	27561549	PRJNA917598_P_NODE_85984_length_247_cov_0.885057_g85040_i0	PRJNA917598	85984	247	0.885057	2.18609079	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	97.8	1.0300000000000001e-22	NR	MES1915897.1	1215613	g85040	i0	56.6	2.01619433198381	83	33	99.6	2	1	246	60	140	MES1915897.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	498	97.8	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
31762982	31762982	PRJNA917598_P_NODE_86437_length_247_cov_0.885057_g85493_i0	PRJNA917598	86437	247	0.885057	2.18609079	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	75.5	1.18e-13	NR	MES1910298.1	1215613	g85493	i0	46.9	1.94331983805668	81	43	98.4	0	246	4	430	510	MES1910298.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	480	75.5	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM

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