metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA770826" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA770826" 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
746935	746935	PRJNA770826_P_NODE_42401_length_162_cov_0.920354_g42230_i0	PRJNA770826	42401	162	0.920354	1.49097348	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	52.8	0.013	NTclustered	gi\|831770775\|ref\|XM_012897648.1\|	1410327	g42230	i0	96.774	0.191358024691358	31	1	19	0	131	161	2340	2310	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	31	52.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
4575156	4575156	PRJNA770826_P_NODE_21804_length_173_cov_1.258065_g21633_i0	PRJNA770826	21804	173	1.258065	2.17645245	Perichaena dictyonema	2951132	Evosea	other_Eukaryota	198	1.7599999999999998e-46	NTclustered	gi\|2287448780\|gb\|ON693880.1\|	2951132	g21633	i0	87.283	97.8265895953757	173	22	100	0	1	173	588	416	Perichaena dictyonema voucher MA59057 elongation factor 1-alpha (EF1A) gene, partial cds	blastn	16924	198	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Trichiida	Trichiidae	Perichaena	Perichaena dictyonema
5035030	5035030	PRJNA770826_P_NODE_1264_length_755_cov_2.524079_g1127_i0	PRJNA770826	1264	755	2.524079	19.05679645	Heterostelium	2058189	Evosea	other_Eukaryota	632	2.1299999999999995e-176	NTclustered	gi\|1160565032\|ref\|XM_020583308.1\|	670386	g1127	i0	82.401	96.6728476821192	733	121	97	8	27	755	1131	403	Polysphondylium pallidum PN500 actin (act10), partial mRNA	blastn	72988	638	0.990595611285266	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
7125546	7125546	PRJNA770826_P_NODE_11806_length_234_cov_4.497297_g11635_i0	PRJNA770826	11806	234	4.497297	10.52367498	Entamoeba invadens	33085	Evosea	other_Eukaryota	231	2.5099999999999996e-56	NTclustered	gi\|471206332\|ref\|XM_004259871.1\|	370355	g11635	i0	85.65	95.0598290598291	223	28	94	3	1	221	248	28	Entamoeba invadens IP1 actin, putative (EIN_054230) mRNA, complete cds	blastn	22244	231	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba invadens
7125667	7125667	PRJNA770826_P_NODE_4166_length_423_cov_1.390374_g3995_i0	PRJNA770826	4166	423	1.390374	5.8812820200000004	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	241	8.1e-59	NTclustered	gi\|470238151\|ref\|XM_004350982.1\|	261658	g3995	i0	78.093	8.95508274231678	388	79	91	6	21	405	401	17	Cavenderia fasciculata Ras GTPase (rapA), partial mRNA	blastn	3788	241	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
8400138	8400138	PRJNA770826_P_NODE_36847_length_164_cov_0.904348_g36676_i0	PRJNA770826	36847	164	0.904348	1.48313072	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	100	4.82e-17	NTclustered	gi\|330833864\|ref\|XM_003291950.1\|	5786	g36676	i0	79.71	0.841463414634146	138	28	84	0	16	153	1307	1444	Dictyostelium purpureum citrate synthase (DICPUDRAFT_50173), mRNA	blastn	138	100	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
10950961	10950961	PRJNA770826_P_NODE_20389_length_179_cov_1.530769_g20218_i0	PRJNA770826	20389	179	1.530769	2.74007651	Heterostelium album	2086695	Evosea	other_Eukaryota	52.8	0.015	NTclustered	gi\|1160564508\|ref\|XM_020583046.1\|	670386	g20218	i0	94.118	0.189944134078212	34	2	19	0	53	86	508	541	Polysphondylium pallidum PN500 prestalk protein partial mRNA	blastn	34	52.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
12226678	12226678	PRJNA770826_P_NODE_6990_length_313_cov_2.166667_g6819_i0	PRJNA770826	6990	313	2.166667	6.78166771	Arcyria cinerea	137621	Evosea	other_Eukaryota	224	5.86e-54	NTclustered	gi\|2772191509\|gb\|PQ014932.1\|	137621	g6819	i0	79.683	97.035143769968	315	60	100	4	1	313	678	366	Arcyria cinerea voucher H7029319a translation elongation factor 1-alpha (EF1a) gene, partial cds	blastn	30372	224	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Trichiida	Trichiidae	Arcyria	Arcyria cinerea
13500753	13500753	PRJNA770826_P_NODE_9531_length_262_cov_0.957746_g9360_i0	PRJNA770826	9531	262	0.957746	2.50929452	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	270	6.0599999999999985e-68	NTclustered	gi\|330842214\|ref\|XM_003293030.1\|	5786	g9360	i0	86.64	37.2824427480916	247	30	94	3	4	248	395	150	Dictyostelium purpureum uncharacterized protein (rac1A), mRNA	blastn	9768	270	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
14775859	14775859	PRJNA770826_P_NODE_4792_length_391_cov_1.388889_g4621_i0	PRJNA770826	4792	391	1.388889	5.43055599	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	313	1.55e-80	NTclustered	gi\|470260760\|ref\|XM_004360149.1\|	261658	g4621	i0	81.266	79.3324808184143	395	67	100	7	1	391	246	637	Cavenderia fasciculata elongation factor 1 alpha (efaAI), partial mRNA	blastn	31019	313	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
16049609	16049609	PRJNA770826_P_NODE_9773_length_258_cov_2.373206_g9602_i0	PRJNA770826	9773	258	2.373206	6.12287148	Physarum polycephalum	5791	Evosea	other_Eukaryota	159	1.3499999999999999e-34	NTclustered	gi\|16024892\|gb\|AY050559.1\|	5791	g9602	i0	80.788	0.786821705426357	203	39	79	0	51	253	250	452	Physarum polycephalum Skp1 (Skp1) mRNA, complete cds	blastn	203	159	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum polycephalum
18598555	18598555	PRJNA770826_P_NODE_1035_length_827_cov_1.570694_g907_i0	PRJNA770826	1035	827	1.570694	12.98963938	Heterostelium album	2086695	Evosea	other_Eukaryota	326	4.44e-84	NTclustered	gi\|1160570294\|ref\|XM_020574641.1\|	670386	g907	i0	78.363	27.5550181378476	513	103	62	6	46	556	773	267	Polysphondylium pallidum PN500 ribosomal protein S2 (rps2), partial mRNA	blastn	22788	326	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
21149485	21149485	PRJNA770826_P_NODE_27157_length_168_cov_0.873950_g26986_i0	PRJNA770826	27157	168	0.87395	1.468236	Heterostelium album	2086695	Evosea	other_Eukaryota	99	1.79e-16	NTclustered	gi\|1160553932\|ref\|XM_020572791.1\|	670386	g26986	i0	81.967	0.726190476190476	122	17	71	5	15	133	158	39	Polysphondylium pallidum PN500 Rab GTPase (rab11A), partial mRNA	blastn	122	99	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
21149506	21149506	PRJNA770826_P_NODE_32017_length_166_cov_0.888889_g31846_i0	PRJNA770826	32017	166	0.888889	1.47555574	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	84.2	4.93e-12	NTclustered	gi\|831775482\|ref\|XM_012899065.1\|	1410327	g31846	i0	97.917	0.289156626506024	48	1	29	0	28	75	232	279	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	48	84.2	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
21608866	21608866	PRJNA770826_P_NODE_28097_length_167_cov_1.322034_g27926_i0	PRJNA770826	28097	167	1.322034	2.20779678	Acytosteliales	2058181	Evosea	other_Eukaryota	169	1.33e-37	NTclustered	gi\|470268043\|ref\|XM_004362178.1\|	261658	g27926	i0	85.276	40.940119760479	163	24	98	0	2	164	183	345	Cavenderia fasciculata S60 ribosomal protein L10 (rpl10), partial mRNA	blastn	6837	169	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
22424273	22424273	PRJNA770826_P_NODE_5238_length_372_cov_1.430341_g5067_i0	PRJNA770826	5238	372	1.430341	5.32086852	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	60.2	2.11e-4	NTclustered	gi\|66826860\|ref\|XM_641693.1\|	352472	g5067	i0	100	0.185483870967742	32	0	9	0	84	115	1607	1638	Dictyostelium discoideum AX4 extracellular matrix protein ST310 (ecmB) mRNA, complete cds	blastn	69	60.2	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
22424299	22424299	PRJNA770826_P_NODE_8278_length_282_cov_2.579399_g8107_i0	PRJNA770826	8278	282	2.579399	7.27390518	Rostrostelium ellipticum	361140	Evosea	other_Eukaryota	200	8.78e-47	NTclustered	gi\|1057487783\|gb\|KX539452.1\|	361140	g8107	i0	80.37	59.1489361702128	270	47	96	5	1	270	1422	1685	Rostrostelium ellipticum strain AE2 phosphoenolpyruvate carboxykinase (gtp) gene, complete cds	blastn	16680	200	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Rostrostelium	Rostrostelium ellipticum
23699836	23699836	PRJNA770826_P_NODE_18759_length_187_cov_1.152174_g18588_i0	PRJNA770826	18759	187	1.152174	2.15456538	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	211	2.5e-50	NTclustered	gi\|831790313\|ref\|XM_012903893.1\|	1410327	g18588	i0	87.568	38.3957219251337	185	19	98	3	4	186	273	91	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	7180	211	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum

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