metadata: contig_metadata: 11 rows where bioproject = "PRJNA764222" and tax

11 rows where bioproject = "PRJNA764222" and tax_clade = "Sar"

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
1205798	1205798	PRJNA764222_S_NODE_9721_length_265_cov_1.665138_g9563_i0	PRJNA764222	9721	265	1.665138	4.4126157	Plasmodium	5820	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.007	NTclustered	gi\|124804411\|ref\|XM_001347959.1\|	36329	g9563	i0	96.875	0.362264150943396	32	1	12	0	224	255	425	394	Plasmodium falciparum 3D7 conserved Plasmodium protein, unknown function (PF3D7_1131400), partial mRNA	blastn	96	54.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium falciparum
5034052	5034052	PRJNA764222_S_NODE_19244_length_213_cov_0.975904_g19086_i0	PRJNA764222	19244	213	0.975904	2.07867552	Eukaryota	2759	SAR_Eukaryotes	SAR_Eukaryotes	89.8	1.43e-13	NTclustered	gi\|2321223487\|gb\|OP720871.1\|	46767	g19086	i0	92.063	27.3427230046948	63	5	30	0	1	63	1437	1499	Blastocystis sp. isolate Mflo44a small subunit ribosomal RNA gene, partial sequence	blastn	5824	89.8	1	Eukaryota	Sar		Bigyra	Opalinata	Blastocystidae	Blastocystis	Blastocystis sp.
7123391	7123391	PRJNA764222_S_NODE_20986_length_205_cov_1.335443_g20828_i0	PRJNA764222	20986	205	1.335443	2.73765815	Babesia ovata	189622	SAR_Eukaryotes	SAR_Eukaryotes	342	9.489999999999999e-90	NTclustered	gi\|1624698140\|ref\|XM_029013938.1\|	189622	g20828	i0	96.618	200.926829268293	207	5	100	1	1	205	503	297	Babesia ovata Retrovirus-related Pol poly LINE-1, putative (BOVATA_050210), partial mRNA	blastn	41190	342	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Piroplasmida	Babesiidae	Babesia	Babesia ovata
7123431	7123431	PRJNA764222_S_NODE_24866_length_189_cov_1.035211_g24708_i0	PRJNA764222	24866	189	1.035211	1.95654879	Kentrophoros sp. 1 BS-2022	2930470	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.005	NTclustered	gi\|2261268989\|emb\|OX095830.1\|	2930470	g24708	i0	100	0.746031746031746	29	0	15	0	1	29	10	38	Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+)	blastn	141	54.7	1	Eukaryota	Sar	Ciliophora	Karyorelictea	Protostomatida	Kentrophoridae	Kentrophoros	Kentrophoros sp. 1 BS-2022
8398039	8398039	PRJNA764222_S_NODE_5067_length_309_cov_1.011450_g4909_i0	PRJNA764222	5067	309	1.01145	3.1253805	Kentrophoros sp. 1 BS-2022	2930470	SAR_Eukaryotes	SAR_Eukaryotes	56.5	0.002	NTclustered	gi\|2261268989\|emb\|OX095830.1\|	2930470	g4909	i0	100	0.0970873786407767	30	0	10	0	1	30	11	40	Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+)	blastn	30	56.5	1	Eukaryota	Sar	Ciliophora	Karyorelictea	Protostomatida	Kentrophoridae	Kentrophoros	Kentrophoros sp. 1 BS-2022
12685485	12685485	PRJNA764222_S_NODE_7530_length_282_cov_3.485106_g7372_i0	PRJNA764222	7530	282	3.485106	9.82799892	root	1	Root_unresolved	Root_unresolved	76.8	1.54e-9	NTclustered	gi\|918021166\|ref\|NC_027746.1\|	1534972	g7372	i0	78.195	2.43262411347518	133	20	46	7	140	269	9791	9665	Triparma laevis chloroplast DNA, complete sequence	blastn	686	76.8	1	Eukaryota	Sar		Bolidophyceae	Parmales	Triparmaceae	Triparma	Triparma laevis
14773607	14773607	PRJNA764222_S_NODE_22852_length_197_cov_1.406667_g22694_i0	PRJNA764222	22852	197	1.406667	2.77113399	Trachelocercidae sp. 3 BS-2022	2930473	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.005	NTclustered	gi\|2261268975\|emb\|OX095823.1\|	2930473	g22694	i0	100	0.289340101522843	29	0	15	0	1	29	9	37	Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-)	blastn	57	54.7	1	Eukaryota	Sar	Ciliophora	Karyorelictea	Protostomatida	Trachelocercidae		Trachelocercidae sp. 3 BS-2022
18596373	18596373	PRJNA764222_S_NODE_22695_length_197_cov_3.106667_g22537_i0	PRJNA764222	22695	197	3.106667	6.12013399	Eimeria necatrix	51315	SAR_Eukaryotes	SAR_Eukaryotes	54.7	0.005	NTclustered	gi\|921131479\|ref\|XM_013584821.1\|	51315	g22537	i0	100	0.147208121827411	29	0	15	0	24	52	1784	1756	Eimeria necatrix hypothetical protein partial mRNA	blastn	29	54.7	1	Eukaryota	Sar	Apicomplexa	Conoidasida	Eucoccidiorida	Eimeriidae	Eimeria	Eimeria necatrix
22883548	22883548	PRJNA764222_S_NODE_7038_length_287_cov_2.308333_g6880_i0	PRJNA764222	7038	287	2.308333	6.62491571	Rosculus	373137	SAR_Eukaryotes	SAR_Eukaryotes	499	7.88e-137	NTclustered	gi\|1002343691\|gb\|KU738569.1\|	1808988	g6880	i0	98.587	23.9547038327526	283	2	98	2	7	287	1	283	Rosculus elongata isolate S14D1 18S ribosomal RNA gene, partial sequence	blastn	6875	499	1	Eukaryota	Sar	Cercozoa			Guttulinopsidae	Rosculus	Rosculus elongata
27685344	27685344	PRJNA764222_S_NODE_23244_length_195_cov_2.574324_g23086_i0	PRJNA764222	23244	195	2.574324	5.0199318	Mayamaea pseudoterrestris	2872254	SAR_Eukaryotes	SAR_Eukaryotes	118	1.94e-30	NR	GKY93333.1	2872254	g23086	i0	82.8	0.984615384615385	64	10	98.5	1	193	2	257	319	GKY93333.1 hypothetical protein MPSEU_000300900 [Mayamaea pseudoterrestris]	diamond	192	118	1	Eukaryota	Sar	Bacillariophyta	Bacillariophyceae	Naviculales	Naviculaceae	Mayamaea	Mayamaea pseudoterrestris
30653352	30653352	PRJNA764222_S_NODE_2133_length_403_cov_2.668539_g1975_i0	PRJNA764222	2133	403	2.668539	10.75421217	Plasmodium yoelii	5861	SAR_Eukaryotes	SAR_Eukaryotes	44.7	0.037	NR	XP_022810819.1	5861	g1975	i0	33.1	0.945409429280397	127	81	91.6	3	385	17	95	221	XP_022810819.1 PIR protein [Plasmodium yoelii]	diamond	381	44.7	1	Eukaryota	Sar	Apicomplexa	Aconoidasida	Haemosporida	Plasmodiidae	Plasmodium	Plasmodium yoelii

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