metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA796753" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA796753" and tax_phylum = "Evosea"

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
780806	780806	PRJNA796753_P_NODE_50941_length_243_cov_0.905882_g50629_i0	PRJNA796753	50941	243	0.905882	2.20129326	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	202	2.0599999999999995e-47	NTclustered	gi\|330840296\|ref\|XM_003292106.1\|	5786	g50629	i0	82.743	3.60493827160494	226	39	93	0	3	228	2064	1839	Dictyostelium purpureum major vault protein-alpha (DICPUDRAFT_50257), partial mRNA	blastn	876	202	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
2056547	2056547	PRJNA796753_P_NODE_21262_length_321_cov_1.862903_g20950_i0	PRJNA796753	21262	321	1.862903	5.97991863	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	76.8	1.79e-9	NTclustered	gi\|167843288\|gb\|EU339291.1\|	5786	g20950	i0	97.727	1.69470404984424	44	1	14	0	268	311	1979	1936	Dictyostelium purpureum strain WS321 tRNA-Pro gene, complete sequence; ATPase subunit 9 (atp9) gene, complete cds; and large subunit ribosomal RNA gene, partial sequence; mitochondrial	blastn	544	76.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
3331717	3331717	PRJNA796753_P_NODE_21123_length_322_cov_1.670683_g20811_i0	PRJNA796753	21123	322	1.670683	5.37959926	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	233	1.01e-56	NTclustered	gi\|470267221\|ref\|XM_004361931.1\|	261658	g20811	i0	80.124	59.639751552795	322	57	99	5	2	322	344	29	Cavenderia fasciculata ubiquitin/ribosomal protein L40 fusion protein (ubqB), partial mRNA	blastn	19204	233	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
3768499	3768499	PRJNA796753_P_NODE_9703_length_444_cov_2.191375_g9391_i0	PRJNA796753	9703	444	2.191375	9.729705	Dictyostelium	5782	Evosea	other_Eukaryota	244	6.600000000000002e-60	NTclustered	gi\|7209\|emb\|X60270.1\|	44689	g9391	i0	86.222	6.03153153153153	225	31	51	0	1	225	23	247	D.discoideum DdANN7 mRNA for annexin VII, partial cds	blastn	2678	244	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
4609165	4609165	PRJNA796753_P_NODE_49964_length_244_cov_0.900585_g49652_i0	PRJNA796753	49964	244	0.900585	2.1974274	Heterostelium album	2086695	Evosea	other_Eukaryota	58.4	4.73e-4	NTclustered	gi\|1160569718\|ref\|XM_020572256.1\|	670386	g49652	i0	100	5.40983606557377	31	0	13	0	113	143	179	149	Polysphondylium pallidum PN500 hypothetical protein partial mRNA	blastn	1320	58.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
5884193	5884193	PRJNA796753_P_NODE_28705_length_284_cov_1.545024_g28393_i0	PRJNA796753	28705	284	1.545024	4.38786816	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	279	1.1e-70	NTclustered	gi\|330795966\|ref\|XM_003285993.1\|	5786	g28393	i0	87.398	83.0246478873239	246	28	86	1	29	271	5	250	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_46519), mRNA	blastn	23579	279	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
10984792	10984792	PRJNA796753_P_NODE_50089_length_244_cov_0.900585_g49777_i0	PRJNA796753	50089	244	0.900585	2.1974274	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	178	3.48e-40	NTclustered	gi\|831767479\|ref\|XM_012896660.1\|	1410327	g49777	i0	81.651	4.90983606557377	218	36	89	3	28	243	1	216	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	1198	178	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
12260116	12260116	PRJNA796753_P_NODE_16970_length_350_cov_2.606498_g16658_i0	PRJNA796753	16970	350	2.606498	9.122743	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	111	5.38e-20	NTclustered	gi\|831770083\|ref\|XM_012897446.1\|	1410327	g16658	i0	93.333	2.50571428571429	75	5	21	0	263	337	256	330	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	877	111	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
12260276	12260276	PRJNA796753_P_NODE_4390_length_641_cov_1.022887_g4088_i0	PRJNA796753	4390	641	1.022887	6.55670567	Entamoeba dispar	46681	Evosea	other_Eukaryota	383	1.9899999999999997e-101	NTclustered	gi\|167393182\|ref\|XM_001740406.1\|	370354	g4088	i0	79.464	63.1450858034321	560	99	87	13	34	588	1	549	Entamoeba dispar SAW760 elongation factor 1-alpha (EDI_196620), partial mRNA	blastn	40476	383	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
13534269	13534269	PRJNA796753_P_NODE_18151_length_341_cov_4.854478_g17839_i0	PRJNA796753	18151	341	4.854478	16.55376998	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	86.1	3.18e-12	NTclustered	gi\|831770083\|ref\|XM_012897446.1\|	1410327	g17839	i0	89.552	8.03519061583578	67	7	20	0	5	71	317	251	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	2740	86.1	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
17358984	17358984	PRJNA796753_P_NODE_1714_length_968_cov_3.810056_g1502_i0	PRJNA796753	1714	968	3.810056	36.88134208	Filamoeba nolandi	136452	Evosea	other_Eukaryota	643	1.2699999999999999e-179	NTclustered	gi\|146448849\|gb\|EF513192.1\|	136452	g1502	i0	79.402	70.4173553719008	937	173	96	14	36	962	430	1356	Filamoeba nolandi elongation factor 1A (EF1A) gene, partial cds	blastn	68164	643	1	Eukaryota	Amoebozoa	Evosea	Variosea			Filamoeba	Filamoeba nolandi
17359113	17359113	PRJNA796753_P_NODE_4154_length_657_cov_2.994863_g3854_i0	PRJNA796753	4154	657	2.994863	19.67624991	Filamoeba nolandi	136452	Evosea	other_Eukaryota	1175	0	NTclustered	gi\|57546814\|gb\|AY714368.1\|	136452	g3854	i0	98.935	69.7351598173516	657	7	100	0	1	657	1165	1821	Filamoeba nolandi strain CCAP1526 small subunit ribosomal RNA gene, complete sequence	blastn	45816	1175	1	Eukaryota	Amoebozoa	Evosea	Variosea			Filamoeba	Filamoeba nolandi
18632155	18632155	PRJNA796753_P_NODE_31095_length_276_cov_1.517241_g30783_i0	PRJNA796753	31095	276	1.517241	4.18758516	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	58.4	5.45e-4	NTclustered	gi\|66820321\|ref\|XM_638698.1\|	352472	g30783	i0	100	0.213768115942029	31	0	11	0	33	63	4157	4187	Dictyostelium discoideum AX4 hypothetical protein (pks17) mRNA, complete cds	blastn	59	58.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
18632210	18632210	PRJNA796753_P_NODE_40135_length_250_cov_1.497175_g39823_i0	PRJNA796753	40135	250	1.497175	3.7429375	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	193	1.28e-44	NTclustered	gi\|470238151\|ref\|XM_004350982.1\|	261658	g39823	i0	83.654	3.276	208	30	82	4	33	238	160	365	Cavenderia fasciculata Ras GTPase (rapA), partial mRNA	blastn	819	193	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
19907405	19907405	PRJNA796753_P_NODE_14436_length_374_cov_1.259136_g14124_i0	PRJNA796753	14436	374	1.259136	4.70916864	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	270	9.03e-68	NTclustered	gi\|330842539\|ref\|XM_003293186.1\|	5786	g14124	i0	84.42	68.475935828877	276	41	74	2	9	283	317	43	Dictyostelium purpureum calmodulin (DICPUDRAFT_93011), mRNA	blastn	25610	270	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
19907444	19907444	PRJNA796753_P_NODE_2156_length_885_cov_6.083744_g1907_i0	PRJNA796753	2156	885	6.083744	53.8411344	Heterostelium album	2086695	Evosea	other_Eukaryota	200	3.01e-46	NTclustered	gi\|1160555008\|ref\|XM_020573329.1\|	670386	g1907	i0	89.744	1.41468926553672	156	16	22	0	67	222	329	174	Polysphondylium pallidum PN500 annexin VII partial mRNA	blastn	1252	200	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
19907692	19907692	PRJNA796753_P_NODE_916_length_1224_cov_6.425717_g759_i1	PRJNA796753	916	1224	6.425717	78.65077608	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	963	0	NTclustered	gi\|330791385\|ref\|XM_003283726.1\|	5786	g759	i1	82.254	91.7736928104575	1127	188	92	12	52	1172	16	1136	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_91170), partial mRNA	blastn	112331	963	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
21183136	21183136	PRJNA796753_P_NODE_26477_length_292_cov_1.406393_g26165_i0	PRJNA796753	26477	292	1.406393	4.10666756	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	198	3.28e-46	NTclustered	gi\|831767479\|ref\|XM_012896660.1\|	1410327	g26165	i0	81.124	1.31164383561644	249	45	85	2	23	270	248	1	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	383	198	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
21183223	21183223	PRJNA796753_P_NODE_42057_length_249_cov_0.875000_g41745_i0	PRJNA796753	42057	249	0.875	2.17875	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	182	2.75e-41	NTclustered	gi\|470249752\|ref\|XM_004367051.1\|	261658	g41745	i0	82.524	30.859437751004	206	36	83	0	40	245	40	245	Cavenderia fasciculata Rab GTPase (rab8B), partial mRNA	blastn	7684	182	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
22457839	22457839	PRJNA796753_P_NODE_3078_length_755_cov_3.683284_g2801_i0	PRJNA796753	3078	755	3.683284	27.8087942	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	331	8.68e-86	NTclustered	gi\|831791097\|ref\|XM_012904149.1\|	1410327	g2801	i0	79.368	5.12582781456954	475	94	63	4	231	703	473	1	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	3870	331	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
22457932	22457932	PRJNA796753_P_NODE_4618_length_625_cov_9.201087_g4314_i0	PRJNA796753	4618	625	9.201087	57.50679375	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	233	2.0599999999999997e-56	NTclustered	gi\|470250617\|ref\|XM_004358349.1\|	261658	g4314	i0	79.819	47.6384	332	58	52	8	9	336	18	344	Cavenderia fasciculata ubiquitin (ubqD), partial mRNA	blastn	29774	235	0.991489361702128	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
22457977	22457977	PRJNA796753_P_NODE_53478_length_241_cov_1.535714_g53166_i0	PRJNA796753	53478	241	1.535714	3.70107074	Heterostelium album	2086695	Evosea	other_Eukaryota	52.8	0.022	NTclustered	gi\|1160565930\|ref\|XM_020580587.1\|	670386	g53166	i0	100	0.232365145228216	28	0	12	0	187	214	8418	8391	Polysphondylium pallidum PN500 IPT/TIG domain-containing protein partial mRNA	blastn	56	52.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
25007023	25007023	PRJNA796753_P_NODE_15760_length_361_cov_1.333333_g15448_i0	PRJNA796753	15760	361	1.333333	4.81333213	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	211	5.34e-50	NTclustered	gi\|330818907\|ref\|XM_003291484.1\|	5786	g15448	i0	80.741	13.7313019390582	270	52	75	0	13	282	146	415	Dictyostelium purpureum ribosomal protein L10E (DICPUDRAFT_92700), mRNA	blastn	4957	211	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
25007194	25007194	PRJNA796753_P_NODE_44100_length_248_cov_0.880000_g43788_i0	PRJNA796753	44100	248	0.88	2.1824	Rhizomastix varia	1745347	Evosea	other_Eukaryota	292	1.21e-74	NTclustered	gi\|944556463\|gb\|KP343611.1\|	1745347	g43788	i0	87.903	102.479838709677	248	30	100	0	1	248	502	255	Rhizomastix varia strain FBAN clone 2 actin gene, partial cds	blastn	25415	292	1	Eukaryota	Amoebozoa	Evosea				Rhizomastix	Rhizomastix varia

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