metadata: contig_metadata: 27 rows where analysis = "blastn", bioproject = "PRJNA1078753" and tax

27 rows where analysis = "blastn", bioproject = "PRJNA1078753" 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
1467066	1467066	PRJNA1078753_P_NODE_17022_length_291_cov_2.119266_g16826_i0	PRJNA1078753	17022	291	2.119266	6.16706406	Heterostelium album	2086695	Evosea	other_Eukaryota	204	7.03e-48	NTclustered	gi\|1160571292\|ref\|XM_020575140.1\|	670386	g16826	i0	79.661	17.2920962199313	295	50	99	8	2	291	968	679	Polysphondylium pallidum PN500 vacuolar H+-ATPase A subunit (vatA), partial mRNA	blastn	5032	204	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
1467121	1467121	PRJNA1078753_P_NODE_2402_length_639_cov_7.014134_g2213_i0	PRJNA1078753	2402	639	7.014134	44.82031626	Heterostelium album	2086695	Evosea	other_Eukaryota	409	3.27e-109	NTclustered	gi\|1160573488\|ref\|XM_020576922.1\|	670386	g2213	i0	81.637	2.18935837245696	501	84	78	8	7	503	1	497	Polysphondylium pallidum PN500 Ras GTPase (rasG), partial mRNA	blastn	1399	409	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
1467283	1467283	PRJNA1078753_P_NODE_6882_length_410_cov_3.448071_g6686_i0	PRJNA1078753	6882	410	3.448071	14.1370911	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	357	7.45e-94	NTclustered	gi\|831769071\|ref\|XM_012897140.1\|	1410327	g6686	i0	84.182	25.9243902439024	373	53	90	6	24	393	370	1	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	10629	357	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
2743226	2743226	PRJNA1078753_P_NODE_21963_length_270_cov_1.974619_g21767_i0	PRJNA1078753	21963	270	1.974619	5.3314713	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	213	1.07e-50	NTclustered	gi\|330793229\|ref\|XM_003284640.1\|	5786	g21767	i0	84.651	12.7222222222222	215	31	79	2	10	223	336	123	Dictyostelium purpureum uncharacterized protein (rasD), mRNA	blastn	3435	213	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
2743254	2743254	PRJNA1078753_P_NODE_26523_length_252_cov_1.720670_g26327_i0	PRJNA1078753	26523	252	1.72067	4.3360884	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	163	1.01e-35	NTclustered	gi\|330793229\|ref\|XM_003284640.1\|	5786	g26327	i0	80.822	7.34523809523809	219	32	85	6	10	223	336	123	Dictyostelium purpureum uncharacterized protein (rasD), mRNA	blastn	1851	163	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
4019100	4019100	PRJNA1078753_P_NODE_2724_length_605_cov_3.567669_g2532_i0	PRJNA1078753	2724	605	3.567669	21.58439745	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	327	8.890000000000001e-85	NTclustered	gi\|330845407\|ref\|XM_003294531.1\|	5786	g2532	i0	79.526	13.9719008264463	464	91	76	4	31	492	65	526	Dictyostelium purpureum uncharacterized protein (rapA), mRNA	blastn	8453	327	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
5295245	5295245	PRJNA1078753_P_NODE_11245_length_341_cov_1.149254_g11049_i0	PRJNA1078753	11245	341	1.149254	3.91895614	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	215	3.88e-51	NTclustered	gi\|330799685\|ref\|XM_003287825.1\|	5786	g11049	i0	80.678	2.04398826979472	295	42	84	13	2	289	385	99	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_47601), mRNA	blastn	697	215	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
9120062	9120062	PRJNA1078753_P_NODE_108_length_2103_cov_7.311330_g76_i0	PRJNA1078753	108	2103	7.31133	153.7572699	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	979	0	NTclustered	gi\|330818764\|ref\|XM_003291461.1\|	5786	g76	i0	77.757	69.3728007608179	1641	334	77	26	42	1668	13	1636	Dictyostelium purpureum heat shock protein (DICPUDRAFT_49867), partial mRNA	blastn	145891	979	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
9120162	9120162	PRJNA1078753_P_NODE_2588_length_618_cov_3.623853_g2397_i0	PRJNA1078753	2588	618	3.623853	22.39541154	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	344	9.03e-90	NTclustered	gi\|330822609\|ref\|XM_003291694.1\|	5786	g2397	i0	79.134	0.886731391585761	508	99	82	6	22	525	141	645	Dictyostelium purpureum uncharacterized protein (rasG), mRNA	blastn	548	344	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
10395818	10395818	PRJNA1078753_P_NODE_22809_length_267_cov_1.520619_g22613_i0	PRJNA1078753	22809	267	1.520619	4.06005273	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	261	3.73e-65	NTclustered	gi\|66826742\|ref\|XM_641634.1\|	352472	g22613	i0	84.387	36.1685393258427	269	38	100	4	1	267	720	986	Dictyostelium discoideum AX4 26S proteasome ATPase 1 subunit (psmC1) mRNA, complete cds	blastn	9657	261	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
11671113	11671113	PRJNA1078753_P_NODE_12670_length_326_cov_3.035573_g12474_i0	PRJNA1078753	12670	326	3.035573	9.89596798	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	281	3.59e-71	NTclustered	gi\|5007075\|gb\|AF153328.1\|	44689	g12474	i0	84.698	79.4509202453988	281	43	86	0	8	288	3	283	Dictyostelium discoideum Rac1C (rac1C) mRNA, complete cds	blastn	25901	281	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
15495112	15495112	PRJNA1078753_P_NODE_18073_length_286_cov_6.211268_g17877_i0	PRJNA1078753	18073	286	6.211268	17.76422648	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	167	9.05e-37	NTclustered	gi\|330795848\|ref\|XM_003285935.1\|	5786	g17877	i0	81.463	0.716783216783217	205	36	71	2	19	222	204	1	Dictyostelium purpureum vacuolar ATPase proteolipid subunit (DICPUDRAFT_30216), partial mRNA	blastn	205	167	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
15495230	15495230	PRJNA1078753_P_NODE_333_length_1455_cov_33.482634_g245_i0	PRJNA1078753	333	1455	33.482634	487.1723247	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	771	0	NTclustered	gi\|330792727\|ref\|XM_003284391.1\|	5786	g245	i0	77.769	47.0927835051546	1300	258	88	28	158	1437	1353	65	Dictyostelium purpureum elongation factor 1 alpha (DICPUDRAFT_52946), mRNA	blastn	68520	771	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
15495234	15495234	PRJNA1078753_P_NODE_33873_length_247_cov_0.885057_g33677_i0	PRJNA1078753	33873	247	0.885057	2.18609079	Heterostelium album	2086695	Evosea	other_Eukaryota	63.9	1.03e-5	NTclustered	gi\|1160564828\|ref\|XM_020583206.1\|	670386	g33677	i0	100	13.0121457489879	34	0	14	0	111	144	842	809	Polysphondylium pallidum PN500 adenylate kinase (adkB), partial mRNA	blastn	3214	63.9	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
16319527	16319527	PRJNA1078753_P_NODE_6153_length_430_cov_1.607843_g5957_i0	PRJNA1078753	6153	430	1.607843	6.9137249	Dictyostelium	5782	Evosea	other_Eukaryota	436	9.8e-118	NTclustered	gi\|7276\|emb\|X55972.1\|	44689	g5957	i0	85.612	96.8790697674419	417	58	97	2	2	417	24	439	D. discoideum EF1-II gene for elongation factor 1 alpha	blastn	41658	436	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
17594748	17594748	PRJNA1078753_P_NODE_36074_length_245_cov_2.686047_g35878_i0	PRJNA1078753	36074	245	2.686047	6.58081515	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	180	9.72e-41	NTclustered	gi\|330845015\|ref\|XM_003294352.1\|	5786	g35878	i0	84.043	3.97959183673469	188	28	76	2	43	229	82	268	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_51485), mRNA	blastn	975	180	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
17594761	17594761	PRJNA1078753_P_NODE_3854_length_522_cov_2.289532_g3660_i0	PRJNA1078753	3854	522	2.289532	11.95135704	Dictyostelium	5782	Evosea	other_Eukaryota	375	2.6699999999999997e-99	NTclustered	gi\|433874\|emb\|X75263.1\|	44689	g3660	i0	81.303	88.8984674329502	476	77	90	11	22	491	66	535	D.discoideum (AX3) mRNA for heat shock cognate protein (hsc70)	blastn	46405	375	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
18044287	18044287	PRJNA1078753_P_NODE_2435_length_635_cov_2.225979_g2245_i0	PRJNA1078753	2435	635	2.225979	14.13496665	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	333	2.01e-86	NTclustered	gi\|330840718\|ref\|XM_003292310.1\|	5786	g2245	i0	82.353	13.5448818897638	391	61	61	8	248	635	372	757	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_50380), mRNA	blastn	8601	333	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
18044446	18044446	PRJNA1078753_P_NODE_6295_length_426_cov_1.648725_g6099_i0	PRJNA1078753	6295	426	1.648725	7.0235685	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	54.7	0.011	NTclustered	gi\|66800078\|ref\|XM_628963.1\|	352472	g6099	i0	100	0.068075117370892	29	0	7	0	390	418	1472	1500	Dictyostelium discoideum AX4 hypothetical protein (dyrk2) mRNA, complete cds	blastn	29	54.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
18044455	18044455	PRJNA1078753_P_NODE_8055_length_385_cov_1.480769_g7859_i0	PRJNA1078753	8055	385	1.480769	5.70096065	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	54.7	0.01	NTclustered	gi\|66800078\|ref\|XM_628963.1\|	352472	g7859	i0	100	0.0753246753246753	29	0	8	0	357	385	1500	1472	Dictyostelium discoideum AX4 hypothetical protein (dyrk2) mRNA, complete cds	blastn	29	54.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
19318281	19318281	PRJNA1078753_P_NODE_28976_length_250_cov_0.870056_g28780_i0	PRJNA1078753	28976	250	0.870056	2.17514	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	191	4.6e-44	NTclustered	gi\|831792076\|ref\|XM_012904471.1\|	1410327	g28780	i0	80.632	2.276	253	43	100	6	1	250	1605	1356	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	569	191	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
19318458	19318458	PRJNA1078753_P_NODE_8396_length_379_cov_1.143791_g8200_i0	PRJNA1078753	8396	379	1.143791	4.33496789	Didymium quitense	2059305	Evosea	other_Eukaryota	237	9.29e-58	NTclustered	gi\|2329703132\|gb\|MW239927.1\|	2059305	g8200	i0	78.474	79.7440633245383	367	75	96	4	1	365	173	537	Didymium quitense strain MA-Fungi 88326 alpha tubulin (aTUB) gene, partial cds	blastn	30223	237	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Didymium	Didymium quitense
21869233	21869233	PRJNA1078753_P_NODE_1358_length_821_cov_3.840909_g1196_i0	PRJNA1078753	1358	821	3.840909	31.53386289	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	492	4.0999999999999992e-134	NTclustered	gi\|330801204\|ref\|XM_003288572.1\|	5786	g1196	i0	84.038	52.2070645554202	520	74	63	8	238	752	534	19	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_92126), mRNA	blastn	42862	492	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
22693723	22693723	PRJNA1078753_P_NODE_12658_length_326_cov_7.509881_g12462_i0	PRJNA1078753	12658	326	7.509881	24.48221206	Dictyostelium	5782	Evosea	other_Eukaryota	215	3.69e-51	NTclustered	gi\|167948\|gb\|M23754.1\|DDIUBIQG	44689	g12462	i0	84	52.1104294478528	225	34	69	2	103	326	913	690	D.discoideum ubiquitin mRNA, complete cds, clone DCUB2	blastn	16988	215	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
23144880	23144880	PRJNA1078753_P_NODE_43659_length_241_cov_0.916667_g43463_i0	PRJNA1078753	43659	241	0.916667	2.20916747	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	182	2.65e-41	NTclustered	gi\|66826862\|ref\|XM_641694.1\|	352472	g43463	i0	80.816	27.5477178423237	245	36	100	10	1	241	1887	1650	Dictyostelium discoideum AX4 DNA topoisomerase II (top2) mRNA, complete cds	blastn	6639	182	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
24418369	24418369	PRJNA1078753_P_NODE_1660_length_747_cov_1.913947_g1486_i0	PRJNA1078753	1660	747	1.913947	14.29718409	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	416	2.2999999999999993e-111	NTclustered	gi\|831786906\|ref\|XM_012902805.1\|	1410327	g1486	i0	78.387	80.6278447121821	657	130	87	10	94	744	798	148	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	60229	416	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
24418382	24418382	PRJNA1078753_P_NODE_18080_length_286_cov_3.384977_g17884_i0	PRJNA1078753	18080	286	3.384977	9.68103422	Entamoeba dispar	46681	Evosea	other_Eukaryota	189	1.9299999999999998e-43	NTclustered	gi\|167380911\|ref\|XM_001735454.1\|	370354	g17884	i0	81.013	7.09440559440559	237	45	83	0	1	237	273	37	Entamoeba dispar SAW760 14-3-3 protein (EDI_244420), partial mRNA	blastn	2029	189	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar

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