metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJNA1122875" and tax

21 rows where analysis = "blastn", bioproject = "PRJNA1122875" 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
1552114	1552114	PRJNA1122875_P_NODE_22422_length_350_cov_2.079422_g22198_i0	PRJNA1122875	22422	350	2.079422	7.277977	Leocarpus fragilis	289947	Evosea	other_Eukaryota	276	1.7999999999999998e-69	NTclustered	gi\|2049856652\|gb\|MG963756.1\|	289947	g22198	i0	81.548	38.3857142857143	336	60	96	2	14	348	454	120	Leocarpus fragilis strain MA-Fungi 90734 alpha-tubulin (a-Tub) gene, partial cds	blastn	13435	276	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Leocarpus	Leocarpus fragilis
4104448	4104448	PRJNA1122875_P_NODE_12144_length_477_cov_5.952970_g11921_i0	PRJNA1122875	12144	477	5.95297	28.3956669	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	100	1.63e-16	NTclustered	gi\|831770083\|ref\|XM_012897446.1\|	1410327	g11921	i0	90.667	1.73375262054507	75	7	16	0	278	352	256	330	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	827	100	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
4104990	4104990	PRJNA1122875_P_NODE_53344_length_241_cov_0.916667_g53120_i0	PRJNA1122875	53344	241	0.916667	2.20916747	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	58.4	4.66e-4	NTclustered	gi\|66809058\|ref\|XM_633160.1\|	352472	g53120	i0	100	14.3360995850622	31	0	13	0	39	69	3302	3332	Dictyostelium discoideum AX4 integrator complex subunit 1 (ints1) mRNA, complete cds	blastn	3455	58.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
5380554	5380554	PRJNA1122875_P_NODE_13685_length_450_cov_3.981432_g13461_i0	PRJNA1122875	13685	450	3.981432	17.916444	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	187	1.1499999999999999e-42	NTclustered	gi\|470247107\|ref\|XM_004357209.1\|	261658	g13461	i0	80.153	2.60666666666667	262	42	57	9	189	445	257	1	Cavenderia fasciculata 40S ribosomal protein S17 (rps17), partial mRNA	blastn	1173	187	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
5380695	5380695	PRJNA1122875_P_NODE_24145_length_338_cov_2.026415_g23921_i0	PRJNA1122875	24145	338	2.026415	6.8492827	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	178	5.05e-40	NTclustered	gi\|66828894\|ref\|XM_642709.1\|	352472	g23921	i0	87.582	7.82248520710059	153	19	45	0	159	311	1392	1240	Dictyostelium discoideum AX4 protein transport protein SEC61 alpha subunit (sec61a) mRNA, complete cds	blastn	2644	178	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
6655436	6655436	PRJNA1122875_P_NODE_27046_length_317_cov_6.372951_g26822_i0	PRJNA1122875	27046	317	6.372951	20.20225467	Acytostelium subglobosum	361139	Evosea	other_Eukaryota	82.4	3.79e-11	NTclustered	gi\|831770083\|ref\|XM_012897446.1\|	1410327	g26822	i0	86.486	2.41640378548896	74	10	23	0	3	76	299	226	Acytostelium subglobosum LB1 hypothetical protein partial mRNA	blastn	766	82.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
6655717	6655717	PRJNA1122875_P_NODE_49846_length_245_cov_0.895349_g49622_i0	PRJNA1122875	49846	245	0.895349	2.19360505	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	209	1.24e-49	NTclustered	gi\|470236819\|ref\|XM_004350313.1\|	261658	g49622	i0	83.482	73.6897959183674	224	37	91	0	7	230	410	187	Cavenderia fasciculata histone H3 (H3a), partial mRNA	blastn	18054	209	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
7406711	7406711	PRJNA1122875_P_NODE_686_length_1340_cov_17.295975_g611_i1	PRJNA1122875	686	1340	17.295975	231.766065	Eumycetozoa	142796	Evosea	other_Eukaryota	861	0	NTclustered	gi\|511083902\|dbj\|AK419160.1\|	5759	g611	i1	80.766	83.0268656716418	1123	198	83	16	162	1275	1142	29	Entamoeba histolytica cDNA clone: Xeh-003B20, actin, complete cds, strain: HM-1:IMSS	blastn	111256	861	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica
7930464	7930464	PRJNA1122875_P_NODE_24047_length_339_cov_1.676692_g23823_i0	PRJNA1122875	24047	339	1.676692	5.68398588	Leocarpus fragilis	289947	Evosea	other_Eukaryota	379	1.29e-100	NTclustered	gi\|2049856652\|gb\|MG963756.1\|	289947	g23823	i0	87.5	95.7699115044248	328	41	97	0	12	339	748	421	Leocarpus fragilis strain MA-Fungi 90734 alpha-tubulin (a-Tub) gene, partial cds	blastn	32466	379	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Leocarpus	Leocarpus fragilis
8681949	8681949	PRJNA1122875_P_NODE_33847_length_284_cov_0.848341_g33623_i0	PRJNA1122875	33847	284	0.848341	2.40928844	root	1	Root_unresolved	Root_unresolved	54.7	0.007	NTclustered	gi\|326632063\|gb\|HQ849402.1\|	5791	g33623	i0	100	0.204225352112676	29	0	10	0	61	89	675	647	Physarum polycephalum strain M3CVIII ATP synthase subunit A (atpA) mRNA, complete cds; mitochondrial	blastn	58	54.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum polycephalum
9956845	9956845	PRJNA1122875_P_NODE_47508_length_247_cov_0.885057_g47284_i0	PRJNA1122875	47508	247	0.885057	2.18609079	Entamoeba	5758	Evosea	other_Eukaryota	52.8	0.022	NTclustered	gi\|183235111\|ref\|XM_001914121.1\|	294381	g47284	i0	100	0.226720647773279	28	0	11	0	1	28	52	25	Entamoeba histolytica HM-1:IMSS uncharacterized protein (EHI_018620), partial mRNA	blastn	56	52.8	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica
13031636	13031636	PRJNA1122875_P_NODE_811_length_1281_cov_2.370033_g731_i0	PRJNA1122875	811	1281	2.370033	30.36012273	Heterostelium album	2086695	Evosea	other_Eukaryota	1055	0	NTclustered	gi\|1160574132\|ref\|XM_020577244.1\|	670386	g731	i0	83.762	87.3083528493365	1127	169	87	14	132	1251	1131	12	Polysphondylium pallidum PN500 actin (act10), partial mRNA	blastn	111842	1055	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
13782065	13782065	PRJNA1122875_P_NODE_41851_length_255_cov_1.302198_g41627_i0	PRJNA1122875	41851	255	1.302198	3.3206049	Dictyostelium	5782	Evosea	other_Eukaryota	217	7.76e-52	NTclustered	gi\|7194\|emb\|X03282.1\|	44689	g41627	i0	87.634	73.7725490196078	186	23	73	0	70	255	1131	946	dictyostelium discoideum gene for actin A12	blastn	18812	217	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
14306630	14306630	PRJNA1122875_P_NODE_4192_length_750_cov_4.500739_g3994_i0	PRJNA1122875	4192	750	4.500739	33.7555425	Heterostelium album	2086695	Evosea	other_Eukaryota	91.6	1.59e-13	NTclustered	gi\|1160555830\|ref\|XM_020573740.1\|	670386	g3994	i0	86.022	1.07066666666667	93	4	21	3	169	261	349	432	Polysphondylium pallidum PN500 hypothetical protein partial mRNA	blastn	803	91.6	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
18129269	18129269	PRJNA1122875_P_NODE_23275_length_345_cov_1.919118_g23051_i0	PRJNA1122875	23275	345	1.919118	6.6209571	Heterostelium album	2086695	Evosea	other_Eukaryota	195	5.13e-45	NTclustered	gi\|1160575132\|ref\|XM_020582306.1\|	670386	g23051	i0	80.62	5.1304347826087	258	44	74	6	75	329	639	385	Polysphondylium pallidum PN500 S60 ribosomal protein L7 (rpl7), partial mRNA	blastn	1770	195	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
18129304	18129304	PRJNA1122875_P_NODE_25975_length_325_cov_1.178571_g25751_i0	PRJNA1122875	25975	325	1.178571	3.83035575	Rhizomastix varia	1745347	Evosea	other_Eukaryota	357	5.78e-94	NTclustered	gi\|944556463\|gb\|KP343611.1\|	1745347	g25751	i0	86.462	100.212307692308	325	44	100	0	1	325	200	524	Rhizomastix varia strain FBAN clone 2 actin gene, partial cds	blastn	32569	357	1	Eukaryota	Amoebozoa	Evosea				Rhizomastix	Rhizomastix varia
20155186	20155186	PRJNA1122875_P_NODE_47016_length_247_cov_1.770115_g46792_i0	PRJNA1122875	47016	247	1.770115	4.37218405	Didymium	5792	Evosea	other_Eukaryota	235	2.07e-57	NTclustered	gi\|2049856620\|gb\|MG963739.1\|	1573252	g46792	i0	83.806	91.3157894736842	247	40	100	0	1	247	62	308	Didymium tehuacanense strain MA-Fungi 79152 alpha-tubulin (a-Tub) gene, partial cds	blastn	22555	235	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Didymiaceae	Didymium	Didymium tehuacanense
21954553	21954553	PRJNA1122875_P_NODE_43698_length_251_cov_0.865169_g43474_i0	PRJNA1122875	43698	251	0.865169	2.17157419	Entamoeba dispar	46681	Evosea	other_Eukaryota	60.2	1.36e-4	NTclustered	gi\|167378048\|ref\|XM_001734598.1\|	370354	g43474	i0	100	0.270916334661355	32	0	13	0	206	237	387	356	Entamoeba dispar SAW760 splicing factor, arginine/serine-rich, putative (EDI_033100), partial mRNA	blastn	68	60.2	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
23230013	23230013	PRJNA1122875_P_NODE_38039_length_269_cov_1.571429_g37815_i0	PRJNA1122875	38039	269	1.571429	4.22714401	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	193	1.39e-44	NTclustered	gi\|66811047\|ref\|XM_634139.1\|	352472	g37815	i0	80.859	26.1635687732342	256	40	93	6	2	251	986	1238	Dictyostelium discoideum AX4 phosphopyruvate hydratase (enoA) mRNA, complete cds	blastn	7038	193	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
23230293	23230293	PRJNA1122875_P_NODE_9319_length_539_cov_2.877682_g9100_i0	PRJNA1122875	9319	539	2.877682	15.51070598	Angulamoeba microcystivorans	1654978	Evosea	other_Eukaryota	852	0	NTclustered	gi\|295983903\|gb\|HM017144.1\|	1654978	g9100	i0	95.028	61.5250463821892	543	23	100	3	1	539	802	260	Angulamoeba microcystivorans strain A2WVB 18S ribosomal RNA gene, partial sequence	blastn	33162	852	1	Eukaryota	Amoebozoa	Evosea	Variosea			Angulamoeba	Angulamoeba microcystivorans
23230295	23230295	PRJNA1122875_P_NODE_9579_length_533_cov_1.708696_g9360_i0	PRJNA1122875	9579	533	1.708696	9.10734968	Mastigamoeba balamuthi	108607	Evosea	other_Eukaryota	100	1.84e-16	NTclustered	gi\|148536468\|gb\|EF410004.1\|	108607	g9360	i0	79.195	6.36210131332083	149	27	28	4	363	509	1638	1492	Mastigamoeba balamuthi chaperonin 60 (Cpn60) mRNA, complete cds	blastn	3391	100	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Mastigamoebidae	Mastigamoeba	Mastigamoeba balamuthi

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