metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA1102048" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA1102048" 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
211751	211751	PRJNA1102048_P_NODE_1421_length_644_cov_5.266200_g1321_i0	PRJNA1102048	1421	644	5.2662	33.914328	Heterostelium album	2086695	Evosea	other_Eukaryota	375	3.339999999999999e-99	NTclustered	gi\|1160573488\|ref\|XM_020576922.1\|	670386	g1321	i0	82.127	2.08074534161491	442	75	68	4	10	449	1	440	Polysphondylium pallidum PN500 Ras GTPase (rasG), partial mRNA	blastn	1340	375	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
1486303	1486303	PRJNA1102048_P_NODE_10982_length_267_cov_2.237113_g10878_i0	PRJNA1102048	10982	267	2.237113	5.97309171	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	147	1.09e-30	NTclustered	gi\|330795848\|ref\|XM_003285935.1\|	5786	g10878	i0	80.203	0.737827715355805	197	37	73	2	69	264	1	196	Dictyostelium purpureum vacuolar ATPase proteolipid subunit (DICPUDRAFT_30216), partial mRNA	blastn	197	147	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
1486422	1486422	PRJNA1102048_P_NODE_4582_length_399_cov_0.944785_g4478_i0	PRJNA1102048	4582	399	0.944785	3.76969215	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	278	5.7900000000000006e-70	NTclustered	gi\|330844711\|ref\|XM_003294212.1\|	5786	g4478	i0	80.376	18.6315789473684	372	67	92	4	2	370	253	621	Dictyostelium purpureum succinyl coenzyme A synthetase alpha subunit (DICPUDRAFT_159229), partial mRNA	blastn	7434	278	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
2762474	2762474	PRJNA1102048_P_NODE_6023_length_352_cov_1.405018_g5919_i0	PRJNA1102048	6023	352	1.405018	4.94566336	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	145	5.3399999999999995e-30	NTclustered	gi\|330801204\|ref\|XM_003288572.1\|	5786	g5919	i0	85.517	2.90625	145	14	40	6	14	154	393	534	Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_92126), mRNA	blastn	1023	145	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
4038416	4038416	PRJNA1102048_P_NODE_10064_length_277_cov_4.127451_g9960_i0	PRJNA1102048	10064	277	4.127451	11.43303927	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	174	5.21e-39	NTclustered	gi\|831753561\|ref\|XM_012892397.1\|	1410327	g9960	i0	80.085	24.5198555956679	236	45	85	2	1	235	262	28	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	6792	174	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
5314659	5314659	PRJNA1102048_P_NODE_8165_length_304_cov_2.489177_g8061_i0	PRJNA1102048	8165	304	2.489177	7.56709808	Soliformovum irregulare	435424	Evosea	other_Eukaryota	239	2.03e-58	NTclustered	gi\|374255694\|emb\|HE614594.1\|	435424	g8061	i0	85.897	2.30921052631579	234	22	75	7	2	230	922	695	Soliformovum irregulare partial 18S rRNA gene, strain ATCC 26826	blastn	702	239	1	Eukaryota	Amoebozoa	Evosea	Variosea	Fractovitellida	Soliformoviidae	Soliformovum	Soliformovum irregulare
7397802	7397802	PRJNA1102048_P_NODE_6326_length_343_cov_1.577778_g6222_i0	PRJNA1102048	6326	343	1.577778	5.41177854	Eumycetozoa	142796	Evosea	other_Eukaryota	215	3.91e-51	NTclustered	gi\|330792727\|ref\|XM_003284391.1\|	5786	g6222	i0	78.571	57.5481049562682	336	64	97	5	8	339	1098	767	Dictyostelium purpureum elongation factor 1 alpha (DICPUDRAFT_52946), mRNA	blastn	19739	215	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
7864382	7864382	PRJNA1102048_P_NODE_1207_length_688_cov_1.637398_g1110_i0	PRJNA1102048	1207	688	1.637398	11.26529824	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	425	3.51e-114	NTclustered	gi\|66805998\|ref\|XM_631629.1\|	352472	g1110	i0	79.508	13.8851744186047	610	115	88	8	75	679	1745	1141	Dictyostelium discoideum AX4 elongation factor 2 (efbA) mRNA, complete cds	blastn	9553	425	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
10415124	10415124	PRJNA1102048_P_NODE_18209_length_227_cov_2.402597_g18105_i0	PRJNA1102048	18209	227	2.402597	5.45389519	Heterostelium album	2086695	Evosea	other_Eukaryota	228	3.129999999999999e-55	NTclustered	gi\|1160557950\|ref\|XM_020575808.1\|	670386	g18105	i0	87.129	237.859030837004	202	25	89	1	27	227	414	615	Polysphondylium pallidum PN500 ubiquitin (ubqI), partial mRNA	blastn	53994	228	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
12498820	12498820	PRJNA1102048_P_NODE_14730_length_247_cov_0.885057_g14626_i0	PRJNA1102048	14730	247	0.885057	2.18609079	Entamoeba	5758	Evosea	other_Eukaryota	100	7.86e-17	NTclustered	gi\|915229\|gb\|U29720.1\|EHU29720	5759	g14626	i0	79.355	2.40485829959514	155	23	61	8	8	157	468	618	Entamoeba histolytica p21racA (Eh racA) gene, complete cds	blastn	594	100	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica
17597724	17597724	PRJNA1102048_P_NODE_4494_length_402_cov_3.844985_g4390_i0	PRJNA1102048	4494	402	3.844985	15.4568397	Dictyostelium	5782	Evosea	other_Eukaryota	267	1.26e-66	NTclustered	gi\|167938\|gb\|M23749.1\|DDIUBIQB	44689	g4390	i0	79.841	87.7412935323383	377	67	93	9	29	402	385	15	D.discoideum ubiquitin mRNA, complete cds, clone DCUBV45	blastn	35272	267	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
18871586	18871586	PRJNA1102048_P_NODE_15395_length_245_cov_4.284884_g15291_i0	PRJNA1102048	15395	245	4.284884	10.4979658	Dictyostelium	5782	Evosea	other_Eukaryota	204	5.77e-48	NTclustered	gi\|167787\|gb\|M26017.1\|DDIEF2	44689	g15291	i0	82.969	1.86938775510204	229	35	93	4	9	235	1549	1775	D.discoideum elongation factor 2 mRNA, complete cds	blastn	458	204	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
19337540	19337540	PRJNA1102048_P_NODE_17476_length_241_cov_1.375000_g17372_i0	PRJNA1102048	17476	241	1.375	3.31375	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	206	1.57e-48	NTclustered	gi\|330791897\|ref\|XM_003283980.1\|	5786	g17372	i0	83.111	24.2738589211618	225	38	93	0	1	225	870	1094	Dictyostelium purpureum 26S proteasome ATPase 2 subunit (DICPUDRAFT_96551), mRNA	blastn	5850	206	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
19337562	19337562	PRJNA1102048_P_NODE_5756_length_359_cov_1.611888_g5652_i0	PRJNA1102048	5756	359	1.611888	5.78667792	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	63.9	1.57e-5	NTclustered	gi\|470253421\|ref\|XM_004359752.1\|	261658	g5652	i0	97.297	8.63509749303621	37	1	10	0	316	352	1973	2009	Cavenderia fasciculata uncharacterized protein (DFA_01844), partial mRNA	blastn	3100	63.9	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
19337594	19337594	PRJNA1102048_P_NODE_936_length_761_cov_2.415698_g844_i0	PRJNA1102048	936	761	2.415698	18.38346178	Paradiacheopsis fimbriata	3090611	Evosea	other_Eukaryota	516	2.25e-141	NTclustered	gi\|2714663807\|gb\|OR759931.1\|	3090611	g844	i0	79.515	79.3337713534823	742	138	97	13	18	752	1022	288	Paradiacheopsis fimbriata voucher MYX11125 translation elongation factor EF-1 subunit alpha (EF1A) gene, partial cds	blastn	60373	516	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Stemonitida	Stemonitidae	Paradiacheopsis	Paradiacheopsis fimbriata
23164084	23164084	PRJNA1102048_P_NODE_6199_length_346_cov_2.670330_g6095_i0	PRJNA1102048	6199	346	2.67033	9.2393418	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	207	6.5999999999999986e-49	NTclustered	gi\|354683888\|gb\|JN048920.1\|	361077	g6095	i0	78.981	2.33526011560694	314	58	90	8	26	336	315	7	Tieghemostelium lacteum 60S ribosomal protein L5 gene, complete cds	blastn	808	207	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
24437686	24437686	PRJNA1102048_P_NODE_8340_length_301_cov_1.350877_g8236_i0	PRJNA1102048	8340	301	1.350877	4.06613977	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	220	7.26e-53	NTclustered	gi\|330822624\|ref\|XM_003291701.1\|	5786	g8236	i0	81.362	18.8372093023256	279	44	91	6	2	276	739	465	Dictyostelium purpureum vacuolar H+ ATPase B subunit (DICPUDRAFT_50012), mRNA	blastn	5670	220	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum

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