metadata: contig_metadata: 26 rows where bioproject = "PRJNA596870" and tax

26 rows where bioproject = "PRJNA596870" and tax_clade = "Amoebozoa"

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
1844210	1844210	PRJNA596870_P_NODE_37562_length_243_cov_0.905882_g37429_i0	PRJNA596870	37562	243	0.905882	2.20129326	Amoeba proteus	5775	Tubulinea	other_Eukaryota	139	1.75e-37	NR	AAP88974.1	5775	g37429	i0	78.8	1.97530864197531	80	17	98.8	0	2	241	65	144	AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus]	diamond	480	139	1	Eukaryota	Amoebozoa	Tubulinea	Elardia	Euamoebida	Amoebidae	Amoeba	Amoeba proteus
9496470	9496470	PRJNA596870_P_NODE_10088_length_398_cov_1.356923_g9955_i0	PRJNA596870	10088	398	1.356923	5.40055354	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	158	2.16e-43	NR	XP_003291358.1	5786	g9955	i0	53.8	2.99246231155779	132	61	99.5	0	396	1	280	411	XP_003291358.1 actin binding protein [Dictyostelium purpureum]	diamond	1191	159	0.993710691823899	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
12047477	12047477	PRJNA596870_P_NODE_24310_length_275_cov_1.143564_g24177_i0	PRJNA596870	24310	275	1.143564	3.144801	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	54.7	0.007	NTclustered	gi\|66823272\|ref\|XM_639899.1\|	352472	g24177	i0	100	0.105454545454545	29	0	11	0	225	253	788	816	Dictyostelium discoideum AX4 hypothetical protein (DDB_G0272746) mRNA, complete cds	blastn	29	54.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
13322545	13322545	PRJNA596870_P_NODE_37991_length_243_cov_0.905882_g37858_i0	PRJNA596870	37991	243	0.905882	2.20129326	Heterostelium album	2086695	Evosea	other_Eukaryota	58.4	4.71e-4	NTclustered	gi\|1160562778\|ref\|XM_020579604.1\|	670386	g37858	i0	94.595	0.296296296296296	37	2	15	0	44	80	1461	1497	Polysphondylium pallidum PN500 aldehyde dehydrogenase partial mRNA	blastn	72	58.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
14597472	14597472	PRJNA596870_P_NODE_36912_length_244_cov_0.900585_g36779_i0	PRJNA596870	36912	244	0.900585	2.1974274	Vexillifera fluvialis	1105343	Discosea	other_Eukaryota	409	1.1299999999999998e-109	NTclustered	gi\|354720323\|gb\|HQ687482.1\|	1105343	g36779	i0	96.774	58.3032786885246	248	3	100	4	1	244	1491	1245	Vexillifera fluvialis strain RR1 small subunit ribosomal RNA gene, partial sequence	blastn	14226	409	1	Eukaryota	Amoebozoa	Discosea	Flabellinia	Dactylopodida	Vexilliferidae	Vexillifera	Vexillifera fluvialis
15871224	15871224	PRJNA596870_P_NODE_33213_length_247_cov_5.925287_g33080_i0	PRJNA596870	33213	247	5.925287	14.63545889	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	281	2.62e-71	NTclustered	gi\|470421212\|ref\|XM_004337322.1\|	1257118	g33080	i0	89.593	82.2672064777328	221	23	89	0	27	247	1	221	Acanthamoeba castellanii str. Neff actin, putative (ACA1_328920), partial mRNA	blastn	20320	281	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
17146287	17146287	PRJNA596870_P_NODE_39774_length_241_cov_0.916667_g39641_i0	PRJNA596870	39774	241	0.916667	2.20916747	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	123	1.2499999999999999e-31	NR	PRP81227.1	1890364	g39641	i0	71.3	0.995850622406639	80	22	99.6	1	240	1	91	169	PRP81227.1 S-adenosylmethionine synthetase [Planoprotostelium fungivorum]	diamond	240	123	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
18420370	18420370	PRJNA596870_P_NODE_29295_length_251_cov_0.865169_g29162_i0	PRJNA596870	29295	251	0.865169	2.17157419	Heterostelium album	2086695	Evosea	other_Eukaryota	52.8	0.023	NTclustered	gi\|1160566216\|ref\|XM_020580730.1\|	670386	g29162	i0	100	0.111553784860558	28	0	11	0	55	82	2180	2207	Polysphondylium pallidum PN500 RabGAP/TBC domain-containing protein partial mRNA	blastn	28	52.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
24794521	24794521	PRJNA596870_P_NODE_27580_length_258_cov_1.248649_g27447_i0	PRJNA596870	27580	258	1.248649	3.22151442	Vexillifera fluvialis	1105343	Discosea	other_Eukaryota	477	3.2699999999999985e-130	NTclustered	gi\|354720323\|gb\|HQ687482.1\|	1105343	g27447	i0	100	78.6124031007752	258	0	100	0	1	258	823	1080	Vexillifera fluvialis strain RR1 small subunit ribosomal RNA gene, partial sequence	blastn	20282	477	1	Eukaryota	Amoebozoa	Discosea	Flabellinia	Dactylopodida	Vexilliferidae	Vexillifera	Vexillifera fluvialis
26699784	26699784	PRJNA596870_P_NODE_35761_length_245_cov_0.895349_g35628_i0	PRJNA596870	35761	245	0.895349	2.19360505	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	63.5	1.82e-9	NR	PRP84049.1	1890364	g35628	i0	40.3	2.90204081632653	77	46	94.3	0	236	6	405	481	PRP84049.1 SH2 domain-containing protein [Planoprotostelium fungivorum]	diamond	711	63.5	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
26953097	26953097	PRJNA596870_P_NODE_14962_length_338_cov_1.162264_g14829_i0	PRJNA596870	14962	338	1.162264	3.92845232	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	186	1.83e-56	NR	XP_004333661.1	1257118	g14829	i0	75	0.994082840236686	112	28	99.4	0	2	337	31	142	XP_004333661.1 actin bundling protein [Acanthamoeba castellanii str. Neff]	diamond	336	186	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
27205977	27205977	PRJNA596870_P_NODE_11982_length_370_cov_1.037037_g11849_i0	PRJNA596870	11982	370	1.037037	3.8370369	Polysphondylium violaceum	133409	Evosea	other_Eukaryota	45.8	0.0119	NR	KAF2068090.1	133409	g11849	i0	43.3	0.486486486486487	60	32	47	1	5	178	45	104	KAF2068090.1 hypothetical protein CYY_010584, partial [Polysphondylium violaceum]	diamond	180	45.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
27585333	27585333	PRJNA596870_P_NODE_40004_length_241_cov_0.916667_g39871_i0	PRJNA596870	40004	241	0.916667	2.20916747	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	95.1	1.31e-20	NR	XP_004341800.1	1257118	g39871	i0	62.8	0.970954356846473	78	28	95.9	1	239	9	1004	1081	XP_004341800.1 Poly(ADPribose) polymerase catalytic domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	234	95.1	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
28406330	28406330	PRJNA596870_P_NODE_30826_length_250_cov_0.870056_g30693_i0	PRJNA596870	30826	250	0.870056	2.17514	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	47	0.00128	NR	XP_004336035.1	1257118	g30693	i0	47.7	0.528	44	20	51.6	2	137	9	637	678	XP_004336035.1 uncharacterized protein ACA1_366340 [Acanthamoeba castellanii str. Neff]	diamond	132	47	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
28848100	28848100	PRJNA596870_P_NODE_16688_length_323_cov_1.140000_g16555_i0	PRJNA596870	16688	323	1.14	3.6822	Acytostelium subglobosum LB1	1410327	Evosea	other_Eukaryota	65.9	2.03e-10	NR	XP_012754939.1	1410327	g16555	i0	49.3	1.96904024767802	71	33	65.9	1	321	109	32	99	XP_012754939.1 hypothetical protein SAMD00019534_050140 [Acytostelium subglobosum LB1]	diamond	636	65.9	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
29132620	29132620	PRJNA596870_P_NODE_33589_length_247_cov_0.885057_g33456_i0	PRJNA596870	33589	247	0.885057	2.18609079	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	56.2	6.67e-7	NR	PRP75500.1	1890364	g33456	i0	69	0.510121457489879	42	12	49.8	1	182	60	418	459	PRP75500.1 hypothetical protein PROFUN_10678 [Planoprotostelium fungivorum]	diamond	126	56.2	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
29429778	29429778	PRJNA596870_P_NODE_22049_length_286_cov_1.502347_g21916_i0	PRJNA596870	22049	286	1.502347	4.29671242	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	109	1.03e-25	NR	XP_020437443.1	670386	g21916	i0	53.7	3.01048951048951	95	44	99.7	0	285	1	300	394	XP_020437443.1 actin binding protein [Heterostelium album PN500]	diamond	861	109	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
30237804	30237804	PRJNA596870_P_NODE_17192_length_319_cov_1.252033_g17059_i0	PRJNA596870	17192	319	1.252033	3.99398527	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	110	2.92e-29	NR	PRP89405.1	1890364	g17059	i0	65.1	0.780564263322884	83	28	78.1	1	310	62	10	91	PRP89405.1 40S ribosomal protein S21 [Planoprotostelium fungivorum]	diamond	249	110	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
30333067	30333067	PRJNA596870_P_NODE_20872_length_293_cov_0.881818_g20739_i0	PRJNA596870	20872	293	0.881818	2.58372674	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	110	7.04e-28	NR	PRP86688.1	1890364	g20739	i0	61.9	1.7098976109215	84	32	86	0	252	1	80	163	PRP86688.1 hypothetical protein PROFUN_05167 [Planoprotostelium fungivorum]	diamond	501	110	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
30364608	30364608	PRJNA596870_P_NODE_26732_length_262_cov_1.851852_g26599_i0	PRJNA596870	26732	262	1.851852	4.85185224	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	81.3	1.32e-15	NR	XP_003283993.1	5786	g26599	i0	61.4	0.801526717557252	70	21	80.2	1	262	53	595	658	XP_003283993.1 uncharacterized protein DICPUDRAFT_52641 [Dictyostelium purpureum]	diamond	210	81.3	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
30440862	30440862	PRJNA596870_P_NODE_31953_length_249_cov_0.875000_g31820_i0	PRJNA596870	31953	249	0.875	2.17875	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	43.9	0.0124	NR	XP_004337603.1	1257118	g31820	i0	60.5	1.78313253012048	38	15	45.8	0	114	1	72	109	XP_004337603.1 ribosomal protein L23, putative [Acanthamoeba castellanii str. Neff]	diamond	444	43.9	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
31343835	31343835	PRJNA596870_P_NODE_30376_length_250_cov_0.870056_g30243_i0	PRJNA596870	30376	250	0.870056	2.17514	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	99	4.1e-22	NR	XP_004346040.1	1257118	g30243	i0	64.6	0.984	82	28	97.2	1	7	249	357	438	XP_004346040.1 Solute carrier family 29 (nucleoside transporters), member 1, putative [Acanthamoeba castellanii str. Neff]	diamond	246	99	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
31502124	31502124	PRJNA596870_P_NODE_26076_length_266_cov_1.383420_g25943_i0	PRJNA596870	26076	266	1.38342	3.6798972	Acytostelium subglobosum LB1	1410327	Evosea	other_Eukaryota	45.1	0.00455	NR	XP_012757531.1	1410327	g25943	i0	41.2	0.766917293233083	68	38	74.4	1	64	261	10	77	XP_012757531.1 hypothetical protein SAMD00019534_014860 [Acytostelium subglobosum LB1]	diamond	204	45.1	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
31691682	31691682	PRJNA596870_P_NODE_29377_length_251_cov_0.865169_g29244_i0	PRJNA596870	29377	251	0.865169	2.17157419	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	106	2.07e-25	NR	XP_004334145.1	1257118	g29244	i0	62.8	0.932270916334661	78	29	93.2	0	1	234	129	206	XP_004334145.1 ATPase family associated with various cellular activities (AAA) domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	234	106	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
32766389	32766389	PRJNA596870_P_NODE_34480_length_246_cov_0.890173_g34347_i0	PRJNA596870	34480	246	0.890173	2.18982558	Acytostelium subglobosum LB1	1410327	Evosea	other_Eukaryota	56.6	4.54e-7	NR	XP_012753477.1	1410327	g34347	i0	45.3	0.646341463414634	53	29	64.6	0	160	2	233	285	XP_012753477.1 hypothetical protein SAMD00019534_069110 [Acytostelium subglobosum LB1]	diamond	159	56.6	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
32779657	32779657	PRJNA596870_P_NODE_29520_length_251_cov_0.865169_g29387_i0	PRJNA596870	29520	251	0.865169	2.17157419	Eumycetozoa	142796	Evosea	other_Eukaryota	52.8	1.25e-5	NR	XP_003284809.1	5786	g29387	i0	38.6	4.37450199203187	70	39	83.7	1	2	211	1474	1539	XP_003284809.1 uncharacterized protein DICPUDRAFT_148631 [Dictyostelium purpureum]	diamond	1098	52.8	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);;