metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA879067" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA879067" 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
854981	854981	PRJNA879067_P_NODE_38141_length_645_cov_3.805944_g34712_i0	PRJNA879067	38141	645	3.805944	24.5483388	Entamoeba dispar	46681	Evosea	other_Eukaryota	1127	0	NTclustered	gi\|167387358\|ref\|XM_001738075.1\|	370354	g34712	i0	99.675	2.86511627906977	616	2	96	0	1	616	1109	494	Entamoeba dispar SAW760 Tropomyosin-2, putative (EDI_309330), partial mRNA	blastn	1848	1127	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
855526	855526	PRJNA879067_P_NODE_56121_length_477_cov_1.413366_g52636_i0	PRJNA879067	56121	477	1.413366	6.74175582	Entamoeba dispar	46681	Evosea	other_Eukaryota	876	0	NTclustered	gi\|167391427\|ref\|XM_001739719.1\|	370354	g52636	i0	99.79	1.9916142557652	477	1	100	0	1	477	63	539	Entamoeba dispar SAW760 uncharacterized protein (EDI_282480), partial mRNA	blastn	950	876	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
1239050	1239050	PRJNA879067_P_NODE_49601_length_528_cov_2.026374_g46121_i0	PRJNA879067	49601	528	2.026374	10.69925472	Entamoeba	5758	Evosea	other_Eukaryota	918	0	NTclustered	gi\|161085285\|dbj\|AB287424.1\|	46681	g46121	i0	99.602	9.47537878787879	503	2	95	0	1	503	1777	1275	Entamoeba dispar igl2 mRNA for intermediate subunit of galactose lectin 2, complete cds, strain: SAW1734RclAR	blastn	5003	924	0.993506493506494	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
3407261	3407261	PRJNA879067_P_NODE_92983_length_287_cov_2.210280_g89497_i0	PRJNA879067	92983	287	2.21028	6.3435036	Entamoeba dispar	46681	Evosea	other_Eukaryota	490	4.749999999999998e-134	NTclustered	gi\|167386327\|ref\|XM_001737660.1\|	370354	g89497	i0	100	0.923344947735192	265	0	92	0	1	265	2013	1749	Entamoeba dispar SAW760 cylicin-1, putative (EDI_239030), partial mRNA	blastn	265	490	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
6342735	6342735	PRJNA879067_P_NODE_104625_length_249_cov_0.875000_g101139_i0	PRJNA879067	104625	249	0.875	2.17875	Entamoeba	5758	Evosea	other_Eukaryota	398	2.51e-106	NTclustered	gi\|511083948\|dbj\|AK419183.1\|	5759	g101139	i0	98.238	4.35341365461847	227	4	91	0	23	249	3	229	Entamoeba histolytica cDNA clone: Xeh-003D09, 60S ribosomal protein L27, putative, complete cds, strain: HM-1:IMSS	blastn	1084	398	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica
8509228	8509228	PRJNA879067_P_NODE_87967_length_306_cov_1.763948_g84481_i0	PRJNA879067	87967	306	1.763948	5.39768088	Entamoeba dispar	46681	Evosea	other_Eukaryota	512	1.09e-140	NTclustered	gi\|167386176\|ref\|XM_001737597.1\|	370354	g84481	i0	100	2.7156862745098	277	0	91	0	30	306	84	360	Entamoeba dispar SAW760 uncharacterized protein (EDI_024350), partial mRNA	blastn	831	512	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
8509321	8509321	PRJNA879067_P_NODE_91847_length_291_cov_2.816514_g88361_i0	PRJNA879067	91847	291	2.816514	8.19605574	Entamoeba dispar	46681	Evosea	other_Eukaryota	499	8.01e-137	NTclustered	gi\|167377626\|ref\|XM_001734421.1\|	370354	g88361	i0	100	8.35051546391753	270	0	93	0	22	291	201	470	Entamoeba dispar SAW760 60S ribosomal protein L9, putative (EDI_012610), partial mRNA	blastn	2430	499	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
8891717	8891717	PRJNA879067_P_NODE_127_length_7579_cov_9.342659_g73_i0	PRJNA879067	127	7579	9.342659	708.08012561	root	1	Root_unresolved	Root_unresolved	6434	0	NTclustered	gi\|1057487862\|gb\|KX539491.1\|	133408	g73	i0	98.209	56.2919910278401	3685	60	49	1	3901	7579	3932	248	Acytostelium leptosomum strain FG12A dihydrolipoamide acetyltransferase (pdhC) gene, complete cds	blastn	426637	6434	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium leptosomum
9783848	9783848	PRJNA879067_P_NODE_75728_length_358_cov_2.985965_g72242_i0	PRJNA879067	75728	358	2.985965	10.6897547	Entamoeba dispar	46681	Evosea	other_Eukaryota	582	9.719999999999996e-162	NTclustered	gi\|167379566\|ref\|XM_001735142.1\|	370354	g72242	i0	100	8.05027932960894	315	0	88	0	44	358	1	315	Entamoeba dispar SAW760 60S acidic ribosomal protein P2, putative (EDI_005370), partial mRNA	blastn	2882	582	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
11058981	11058981	PRJNA879067_P_NODE_50729_length_519_cov_1.130045_g47247_i0	PRJNA879067	50729	519	1.130045	5.86493355	Entamoeba dispar	46681	Evosea	other_Eukaryota	878	0	NTclustered	gi\|167387034\|ref\|XM_001737944.1\|	370354	g47247	i0	99.584	4.84585741811175	481	2	93	0	39	519	1	481	Entamoeba dispar SAW760 uncharacterized protein (EDI_138600), partial mRNA	blastn	2515	878	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
12334774	12334774	PRJNA879067_P_NODE_63750_length_424_cov_5.874644_g60265_i0	PRJNA879067	63750	424	5.874644	24.90849056	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	54.7	0.011	NTclustered	gi\|1468982\|gb\|U64830.1\|DDU64830	44689	g60265	i0	100	0.0683962264150943	29	0	7	0	73	101	4246	4274	Dictyostelium discoideum AX2 protein tyrosine kinase gene, complete cds	blastn	29	54.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
12335580	12335580	PRJNA879067_P_NODE_95530_length_278_cov_2.136585_g92044_i0	PRJNA879067	95530	278	2.136585	5.9397063	Entamoeba dispar	46681	Evosea	other_Eukaryota	438	1.6799999999999995e-118	NTclustered	gi\|167539979\|ref\|XM_001741434.1\|	370354	g92044	i0	100	3.73381294964029	237	0	85	0	42	278	1	237	Entamoeba dispar SAW760 40S ribosomal protein S20, putative (EDI_201320), partial mRNA	blastn	1038	438	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
13609320	13609320	PRJNA879067_P_NODE_63931_length_423_cov_4.865714_g60446_i0	PRJNA879067	63931	423	4.865714	20.58197022	Entamoeba dispar	46681	Evosea	other_Eukaryota	658	0	NTclustered	gi\|167383273\|ref\|XM_001736416.1\|	370354	g60446	i0	96.985	2.87470449172577	398	0	91	1	1	386	398	1	Entamoeba dispar SAW760 uncharacterized protein (EDI_339620), partial mRNA	blastn	1216	658	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
14883159	14883159	PRJNA879067_P_NODE_46332_length_557_cov_2.185950_g42863_i0	PRJNA879067	46332	557	2.18595	12.1757415	Entamoeba dispar	46681	Evosea	other_Eukaryota	861	0	NTclustered	gi\|167388817\|ref\|XM_001738653.1\|	370354	g42863	i0	98.566	1.79533213644524	488	5	87	1	42	527	4691	4204	Entamoeba dispar SAW760 uncharacterized protein (EDI_224640), partial mRNA	blastn	1000	861	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
19090467	19090467	PRJNA879067_P_NODE_37515_length_653_cov_2.950000_g34092_i0	PRJNA879067	37515	653	2.95	19.2635	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	58.4	0.001	NTclustered	gi\|167540326\|ref\|XM_001741781.1\|	370354	g34092	i0	92.683	0.171516079632466	41	2	6	1	403	443	40	1	Entamoeba dispar SAW760 serine/threonine protein kinase ULK3, putative (EDI_247400), partial mRNA	blastn	112	58.4	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
19983062	19983062	PRJNA879067_P_NODE_90976_length_295_cov_0.909910_g87490_i0	PRJNA879067	90976	295	0.90991	2.6842345	Entamoeba dispar	46681	Evosea	other_Eukaryota	424	5.04e-114	NTclustered	gi\|167387800\|ref\|XM_001738263.1\|	370354	g87490	i0	97.951	2.47457627118644	244	5	83	0	27	270	1668	1425	Entamoeba dispar SAW760 axoneme-associated protein mst101, putative (EDI_340670), partial mRNA	blastn	730	424	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
21256704	21256704	PRJNA879067_P_NODE_29897_length_766_cov_2.493506_g26594_i0	PRJNA879067	29897	766	2.493506	19.10025596	Entamoeba histolytica	5759	Evosea	other_Eukaryota	1327	0	NTclustered	gi\|467633\|emb\|Z29969.1\|	5759	g26594	i0	99.587	38.8407310704961	727	3	95	0	40	766	1374	2100	E.histolytica plasmid genes for ribosomal RNA and hemolysins HLY1, HLY5mc1 HLY5mc2 HLY4	blastn	29752	1327	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica
23808515	23808515	PRJNA879067_P_NODE_88939_length_302_cov_3.458515_g85453_i0	PRJNA879067	88939	302	3.458515	10.4447153	Entamoeba dispar	46681	Evosea	other_Eukaryota	508	1.39e-139	NTclustered	gi\|167389812\|ref\|XM_001739042.1\|	370354	g85453	i0	99.64	10.6920529801325	278	1	92	0	1	278	332	55	Entamoeba dispar SAW760 uncharacterized protein (EDI_080200), partial mRNA	blastn	3229	508	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
25079966	25079966	PRJNA879067_P_NODE_110760_length_241_cov_0.916667_g107274_i0	PRJNA879067	110760	241	0.916667	2.20916747	Entamoeba histolytica	5759	Evosea	other_Eukaryota	124	4.53e-24	NTclustered	gi\|183234547\|ref\|XM_001914001.1\|	294381	g107274	i0	79.255	0.780082987551867	188	31	75	6	16	196	696	882	Entamoeba histolytica HM-1:IMSS serine-rich protein C30B4.01c precursor, putative (EHI_113890), mRNA	blastn	188	124	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica

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