metadata: contig_metadata: 28 rows where analysis = "blastn", bioproject = "PRJNA800090" and tax

28 rows where analysis = "blastn", bioproject = "PRJNA800090" and tax_clade = "Amoebozoa"

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
797505	797505	PRJNA800090_P_NODE_153001_length_253_cov_1.586957_g150816_i0	PRJNA800090	153001	253	1.586957	4.01500121	Platyamoeba placida	3454475	Discosea	other_Eukaryota	307	4.44e-79	NTclustered	gi\|33946348\|gb\|AY294153.1\|	197527	g150816	i0	89.069	98.3083003952569	247	27	98	0	4	250	579	333	Platyamoeba placida actin mRNA, partial cds	blastn	24872	307	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Platyamoeba	Platyamoeba placida
798785	798785	PRJNA800090_P_NODE_32661_length_664_cov_2.080672_g30545_i0	PRJNA800090	32661	664	2.080672	13.81566208	Copromyxa protea	931554	Tubulinea	other_Eukaryota	510	9.08e-140	NTclustered	gi\|508737347\|dbj\|AB766053.1\|	931554	g30545	i0	82.676	0.878012048192771	583	93	87	8	1	579	1308	730	Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324	blastn	583	510	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Hartmannellidae	Copromyxa	Copromyxa protea
3347565	3347565	PRJNA800090_P_NODE_110243_length_307_cov_1.840336_g108058_i0	PRJNA800090	110243	307	1.840336	5.64983152	Entamoeba dispar	46681	Evosea	other_Eukaryota	250	9.46e-62	NTclustered	gi\|167379133\|ref\|XM_001734953.1\|	370354	g108058	i0	81.731	25.3648208469055	312	45	99	8	1	306	1930	1625	Entamoeba dispar SAW760 transitional endoplasmic reticulum ATPase, putative (EDI_130320), partial mRNA	blastn	7787	250	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
3347809	3347809	PRJNA800090_P_NODE_120963_length_290_cov_2.755656_g118778_i0	PRJNA800090	120963	290	2.755656	7.9914024	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	226	1.5e-54	NTclustered	gi\|330791340\|ref\|XM_003283704.1\|	5786	g118778	i0	82.812	8.82413793103448	256	40	88	4	2	255	16	269	Dictyostelium purpureum Rab GTPase (DICPUDRAFT_74712), partial mRNA	blastn	2559	226	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
3347991	3347991	PRJNA800090_P_NODE_130123_length_277_cov_3.687500_g127938_i0	PRJNA800090	130123	277	3.6875	10.214375	Ripella tribonemae	2047823	Discosea	other_Eukaryota	403	6.11e-108	NTclustered	gi\|1269228469\|gb\|MF683594.1\|	2047823	g127938	i0	95.312	81.115523465704	256	9	92	3	1	254	928	674	Ripella tribonemae clone 22.1.12 18S ribosomal RNA gene, partial sequence	blastn	22469	403	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella tribonemae
3772832	3772832	PRJNA800090_P_NODE_61903_length_441_cov_1.943548_g59719_i0	PRJNA800090	61903	441	1.943548	8.57104668	Eumycetozoa	142796	Evosea	other_Eukaryota	292	2.3099999999999998e-74	NTclustered	gi\|2805783493\|gb\|PP796513.1\|	385471	g59719	i0	79.007	93.7687074829932	443	81	99	11	3	439	60	496	Diachea leucopodia translation elongation factor 1-alpha (EF1A) gene, partial cds	blastn	41352	292	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Stemonitida	Stemonitidae	Diachea	Diachea leucopodia
7176725	7176725	PRJNA800090_P_NODE_192686_length_228_cov_0.918239_g190501_i0	PRJNA800090	192686	228	0.918239	2.09358492	Mayorella sp. JJP-2003	242541	Discosea	other_Eukaryota	326	1.08e-84	NTclustered	gi\|33946346\|gb\|AY294152.1\|	242541	g190501	i0	92.544	79.5219298245614	228	15	100	2	1	228	11	236	Mayorella sp. JJP-2003 actin mRNA, partial cds	blastn	18131	326	1	Eukaryota	Amoebozoa	Discosea		Longamoebia		Mayorella	Mayorella sp. JJP-2003
7177547	7177547	PRJNA800090_P_NODE_50806_length_501_cov_2.796296_g48624_i0	PRJNA800090	50806	501	2.796296	14.00944296	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	344	7.209999999999998e-90	NTclustered	gi\|470380222\|ref\|XM_004333620.1\|	1257118	g48624	i0	80.866	74.6646706586826	439	82	87	2	2	439	449	12	Acanthamoeba castellanii str. Neff ran, putative (ACA1_260190), partial mRNA	blastn	37407	344	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
7178167	7178167	PRJNA800090_P_NODE_78966_length_377_cov_2.107143_g76781_i0	PRJNA800090	78966	377	2.107143	7.94392911	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	276	1.96e-69	NTclustered	gi\|66810382\|ref\|XM_633823.1\|	352472	g76781	i0	79.841	41.8965517241379	377	76	100	0	1	377	121	497	Dictyostelium discoideum AX4 Rab GTPase (rab1A) mRNA, complete cds	blastn	15795	276	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
8450748	8450748	PRJNA800090_P_NODE_160947_length_246_cov_1.237288_g158762_i0	PRJNA800090	160947	246	1.237288	3.04372848	Entamoeba nuttalli	412467	Evosea	other_Eukaryota	154	5.9200000000000005e-33	NTclustered	gi\|672810997\|ref\|XM_008862315.1\|	1076696	g158762	i0	78.855	0.922764227642276	227	48	92	0	1	227	233	7	Entamoeba nuttalli P19 ribosomal S17 protein partial mRNA	blastn	227	154	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba nuttalli
8450947	8450947	PRJNA800090_P_NODE_169787_length_238_cov_1.189349_g167602_i0	PRJNA800090	169787	238	1.189349	2.83065062	Cochliopodium minus	313997	Discosea	other_Eukaryota	337	5.27e-88	NTclustered	gi\|330902862\|gb\|JF298257.1\|	313997	g167602	i0	92.469	13.1344537815126	239	13	100	4	1	238	385	151	Cochliopodium minus 18S ribosomal RNA gene, partial sequence	blastn	3126	337	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium minus
8452781	8452781	PRJNA800090_P_NODE_76227_length_386_cov_1.381703_g74042_i0	PRJNA800090	76227	386	1.381703	5.33337358	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	292	1.99e-74	NTclustered	gi\|470442906\|ref\|XM_004339540.1\|	1257118	g74042	i0	84.459	20.9974093264249	296	46	77	0	27	322	315	20	Acanthamoeba castellanii str. Neff 60S ribosomal protein, putative (ACA1_063390), partial mRNA	blastn	8105	292	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
8873267	8873267	PRJNA800090_P_NODE_121887_length_289_cov_1.804545_g119702_i0	PRJNA800090	121887	289	1.804545	5.21513505	Dictyostelium	5782	Evosea	other_Eukaryota	217	8.96e-52	NTclustered	gi\|7209\|emb\|X60270.1\|	44689	g119702	i0	81.159	27.1557093425606	276	46	93	5	10	279	61	336	D.discoideum DdANN7 mRNA for annexin VII, partial cds	blastn	7848	217	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
9726421	9726421	PRJNA800090_P_NODE_189828_length_229_cov_0.912500_g187643_i0	PRJNA800090	189828	229	0.9125	2.089625	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	69.4	2.03e-7	NTclustered	gi\|470261894\|ref\|XM_004360475.1\|	261658	g187643	i0	81.395	0.375545851528384	86	15	38	1	6	91	248	164	Cavenderia fasciculata succinate dehydrogenase (sdhB), partial mRNA	blastn	86	69.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
10149534	10149534	PRJNA800090_P_NODE_56748_length_466_cov_3.879093_g54564_i0	PRJNA800090	56748	466	3.879093	18.07657338	Vannellidae	95227	Discosea	other_Eukaryota	647	0	NTclustered	gi\|327391632\|gb\|HM363630.1\|	1002217	g54564	i0	94.55	100.510729613734	422	18	90	3	1	418	56	476	Vannella sp. GERL14 small subunit ribosomal RNA gene, partial sequence	blastn	46838	647	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Vannella	Vannella sp. GERL14
11003532	11003532	PRJNA800090_P_NODE_70809_length_405_cov_1.437500_g68624_i0	PRJNA800090	70809	405	1.4375	5.821875	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	311	5.81e-80	NTclustered	gi\|470418521\|ref\|XM_004337050.1\|	1257118	g68624	i0	82.825	74.1802469135802	361	49	89	7	11	369	359	10	Acanthamoeba castellanii str. Neff cyclophylin, putative (ACA1_215460), partial mRNA	blastn	30043	311	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
11424098	11424098	PRJNA800090_P_NODE_135829_length_270_cov_4.024876_g133644_i0	PRJNA800090	135829	270	4.024876	10.8671652	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	250	8.18e-62	NTclustered	gi\|330792727\|ref\|XM_003284391.1\|	5786	g133644	i0	85.714	93.3740740740741	238	33	88	1	21	258	307	71	Dictyostelium purpureum elongation factor 1 alpha (DICPUDRAFT_52946), mRNA	blastn	25211	250	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
12277792	12277792	PRJNA800090_P_NODE_18790_length_926_cov_2.548425_g17084_i0	PRJNA800090	18790	926	2.548425	23.5984155	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	431	1.03e-115	NTclustered	gi\|330844711\|ref\|XM_003294212.1\|	5786	g17084	i0	77.047	15.7580993520518	806	150	86	26	133	926	55	837	Dictyostelium purpureum succinyl coenzyme A synthetase alpha subunit (DICPUDRAFT_159229), partial mRNA	blastn	14592	431	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
13550698	13550698	PRJNA800090_P_NODE_135611_length_271_cov_1.331683_g133426_i0	PRJNA800090	135611	271	1.331683	3.60886093	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	62.1	4.13e-5	NTclustered	gi\|66820722\|ref\|XM_638845.1\|	352472	g133426	i0	91.111	0.166051660516605	45	4	17	0	4	48	1220	1176	Dictyostelium discoideum AX4 hypothetical protein (DDB_G0274803) mRNA, complete cds	blastn	45	62.1	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
16099783	16099783	PRJNA800090_P_NODE_14233_length_1073_cov_1.813745_g12794_i0	PRJNA800090	14233	1073	1.813745	19.46148385	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	56.5	0.008	NTclustered	gi\|375333686\|gb\|JN802190.1\|	361077	g12794	i0	94.444	0.0335507921714818	36	2	3	0	832	867	1473	1508	Tieghemostelium lacteum extracellular matrix protein (EcmA) gene, complete cds	blastn	36	56.5	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
16100045	16100045	PRJNA800090_P_NODE_153253_length_253_cov_1.554348_g151068_i0	PRJNA800090	153253	253	1.554348	3.93250044	Cochliopodium minus	313997	Discosea	other_Eukaryota	374	4.31e-99	NTclustered	gi\|330902862\|gb\|JF298257.1\|	313997	g151068	i0	93.103	73.3715415019763	261	9	100	4	1	253	2112	1853	Cochliopodium minus 18S ribosomal RNA gene, partial sequence	blastn	18563	374	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium minus
16523598	16523598	PRJNA800090_P_NODE_198553_length_215_cov_2.239726_g196368_i0	PRJNA800090	198553	215	2.239726	4.8154109	Dictyostelium	5782	Evosea	other_Eukaryota	233	6.309999999999999e-57	NTclustered	gi\|7209\|emb\|X60270.1\|	44689	g196368	i0	88.06	19.3441860465116	201	18	94	2	15	215	252	58	D.discoideum DdANN7 mRNA for annexin VII, partial cds	blastn	4159	233	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
23751052	23751052	PRJNA800090_P_NODE_191179_length_229_cov_0.868750_g188994_i0	PRJNA800090	191179	229	0.86875	1.9894375	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	52.8	0.02	NTclustered	gi\|330802427\|ref\|XM_003289171.1\|	5786	g188994	i0	100	0.122270742358079	28	0	12	0	191	218	58	85	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_22470), partial mRNA	blastn	28	52.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
23751899	23751899	PRJNA800090_P_NODE_52719_length_489_cov_3.528571_g50535_i0	PRJNA800090	52719	489	3.528571	17.25471219	Entamoeba histolytica	5759	Evosea	other_Eukaryota	305	3.32e-78	NTclustered	gi\|183234457\|ref\|XM_645739.2\|	294381	g50535	i0	79.229	26.1492842535787	467	75	93	21	5	460	71	526	Entamoeba histolytica HM-1:IMSS Rho family GTPase (EHI_197840), mRNA	blastn	12787	305	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica
25024162	25024162	PRJNA800090_P_NODE_156160_length_250_cov_1.613260_g153975_i0	PRJNA800090	156160	250	1.61326	4.03315	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	182	2.769999999999999e-41	NTclustered	gi\|66817211\|ref\|XM_637392.1\|	352472	g153975	i0	81.013	21.18	237	37	93	8	11	243	184	416	Dictyostelium discoideum AX4 60S ribosomal protein L4 (rpl4) mRNA, complete cds	blastn	5295	182	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
25025539	25025539	PRJNA800090_P_NODE_40660_length_578_cov_2.133595_g38501_i0	PRJNA800090	40660	578	2.133595	12.3321791	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	363	2.32e-95	NTclustered	gi\|330822624\|ref\|XM_003291701.1\|	5786	g38501	i0	79.159	46.0415224913495	547	96	93	17	41	578	1521	984	Dictyostelium purpureum vacuolar H+ ATPase B subunit (DICPUDRAFT_50012), mRNA	blastn	26612	363	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
25025647	25025647	PRJNA800090_P_NODE_45480_length_538_cov_1.663113_g43308_i0	PRJNA800090	45480	538	1.663113	8.94754794	Paramoeba branchiphila	308475	Discosea	other_Eukaryota	433	1.6199999999999995e-116	NTclustered	gi\|226347442\|gb\|FJ807261.1\|	308475	g43308	i0	81.262	64.407063197026	539	97	99	4	1	537	629	93	Neoparamoeba branchiphila strain AMOP1 elongation factor 1 alpha gene, partial cds	blastn	34651	433	1	Eukaryota	Amoebozoa	Discosea	Flabellinia	Dactylopodida	Paramoebidae	Paramoeba	Paramoeba branchiphila
25447734	25447734	PRJNA800090_P_NODE_61360_length_443_cov_3.358289_g59176_i0	PRJNA800090	61360	443	3.358289	14.87722027	Ripella	1217112	Discosea	other_Eukaryota	647	0	NTclustered	gi\|1269228431\|gb\|MF683556.1\|	2047822	g59176	i0	94.976	94.4243792325056	418	12	94	6	27	443	1234	1643	Ripella decalvata clone 26.2.11 18S ribosomal RNA gene, partial sequence	blastn	41830	647	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella decalvata

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