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

11 rows where bioproject = "PRJEB81463", 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
140591	140591	PRJEB81463_P_NODE_29861_length_227_cov_2.012987_g29589_i0	PRJEB81463	29861	227	2.012987	4.56948049	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	76.6	1.19e-14	NR	MES1909515.1	1215613	g29589	i0	50.8	2.57709251101322	63	31	83.3	0	2	190	148	210	MES1909515.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	585	76.6	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
5243102	5243102	PRJEB81463_P_NODE_23825_length_248_cov_0.891429_g23553_i0	PRJEB81463	23825	248	0.891429	2.21074392	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	110	7.76e-26	NR	MES1911124.1	1215613	g23553	i0	64.2	0.979838709677419	81	29	98	0	244	2	455	535	MES1911124.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	243	110	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
6518771	6518771	PRJEB81463_P_NODE_27626_length_243_cov_0.917647_g27354_i0	PRJEB81463	27626	243	0.917647	2.22988221	Heteromita sp. PRA-74	323453	SAR_Eukaryotes	SAR_Eukaryotes	136	1.7699999999999998e-37	NR	ADK26624.1	323453	g27354	i0	76.5	1	81	19	100	0	243	1	116	196	ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74]	diamond	243	136	1	Eukaryota	Sar	Cercozoa		Cercomonadida	Heteromitidae	Heteromita	Heteromita sp. PRA-74
12893848	12893848	PRJEB81463_P_NODE_12151_length_292_cov_3.027397_g11879_i0	PRJEB81463	12151	292	3.027397	8.83999924	Esquamula lacrimiformis	1176540	SAR_Eukaryotes	SAR_Eukaryotes	231	3.24e-56	NTclustered	gi\|409971369\|dbj\|AB714271.1\|	1176540	g11879	i0	81.757	20.4760273972603	296	37	100	12	1	292	3723	4005	Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence	blastn	5979	231	1	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida		Esquamula	Esquamula lacrimiformis
16300011	16300011	PRJEB81463_P_NODE_10773_length_309_cov_4.656780_g10501_i0	PRJEB81463	10773	309	4.65678	14.3894502	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	372	1.95e-98	NTclustered	gi\|160337402\|gb\|EF455799.1\|	188939	g10501	i0	88.779	98.1974110032362	303	34	98	0	6	308	603	301	Thaumatomonas seravini beta-tubulin (btub) gene, partial cds	blastn	30343	374	0.994652406417112	Eukaryota	Sar	Cercozoa	Imbricatea	Thaumatomonadida	Thaumatomastigidae	Thaumatomonas	Thaumatomonas seravini
17992120	17992120	PRJEB81463_P_NODE_29135_length_234_cov_2.832298_g28863_i0	PRJEB81463	29135	234	2.832298	6.62757732	Gymnochlora stellata	67809	SAR_Eukaryotes	SAR_Eukaryotes	132	1.72e-36	NR	ACF24565.1	67809	g28863	i0	84.4	0.987179487179487	77	12	98.7	0	2	232	53	129	ACF24565.1 proteasome alpha 4 subunit [Gymnochlora stellata]	diamond	231	132	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Gymnochlora	Gymnochlora stellata
19266203	19266203	PRJEB81463_P_NODE_8176_length_351_cov_4.341727_g7904_i0	PRJEB81463	8176	351	4.341727	15.23946177	Mesofila sp. ATCC PRA-54	439948	SAR_Eukaryotes	SAR_Eukaryotes	327	4.92e-85	NTclustered	gi\|160337400\|gb\|EF455798.1\|	439948	g7904	i0	83.908	97.5128205128205	348	50	98	6	2	346	370	714	Dimorpha sp. ATCC PRA-54 clone 2 actin gene, partial cds	blastn	34227	327	1	Eukaryota	Sar	Cercozoa			Mesofilidae	Mesofila	Mesofila sp. ATCC PRA-54
26812798	26812798	PRJEB81463_P_NODE_23961_length_248_cov_0.880000_g23689_i0	PRJEB81463	23961	248	0.88	2.1824	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	68.2	4.29e-11	NR	MES1912100.1	1215613	g23689	i0	41.8	0.955645161290323	79	46	95.6	0	243	7	404	482	MES1912100.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	237	68.2	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
28037815	28037815	PRJEB81463_P_NODE_30785_length_202_cov_4.131783_g30513_i0	PRJEB81463	30785	202	4.131783	8.34620166	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	108	2.99e-28	NR	AAY21202.1	227086	g30513	i0	75.8	5.88118811881188	66	16	98	0	200	3	29	94	AAY21202.1 Rpl7A, partial [Bigelowiella natans]	diamond	1188	108	1	Eukaryota	Sar	Cercozoa	Chlorarachniophyceae			Bigelowiella	Bigelowiella natans
28202692	28202692	PRJEB81463_P_NODE_7106_length_376_cov_1.699670_g6834_i0	PRJEB81463	7106	376	1.69967	6.3907592	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	62.4	4.06e-9	NR	MES1913617.1	1215613	g6834	i0	52.7	0.438829787234043	55	25	43.9	1	234	70	112	165	MES1913617.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	165	62.4	1	Eukaryota	Sar	Cercozoa					Cercozoa sp. M6MM
29244874	29244874	PRJEB81463_P_NODE_8629_length_342_cov_2.301115_g8357_i0	PRJEB81463	8629	342	2.301115	7.8698133	Cercozoa sp. M6MM	1215613	SAR_Eukaryotes	SAR_Eukaryotes	89	7.64e-18	NR	MES1911981.1	1215613	g8357	i0	39.8	0.991228070175439	113	67	98.2	1	1	336	884	996	MES1911981.1 hypothetical protein [Cercozoa sp. M6MM]	diamond	339	89	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);;