metadata: contig_metadata: 14 rows where analysis = "diamond", bioproject = "PRJEB58983" and tax

14 rows where analysis = "diamond", bioproject = "PRJEB58983" 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
11603404	11603404	PRJEB58983_P_NODE_27730_length_253_cov_2.155556_g27315_i0	PRJEB58983	27730	253	2.155556	5.45355668	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	130	1.65e-33	NR	XP_004344078.1	1257118	g27315	i0	80.3	0.901185770750988	76	15	90.1	0	251	24	402	477	XP_004344078.1 Sadenosyl-L-homocysteine hydrolase, putative [Acanthamoeba castellanii str. Neff]	diamond	228	130	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
23076722	23076722	PRJEB58983_P_NODE_14239_length_337_cov_1.659091_g13824_i0	PRJEB58983	14239	337	1.659091	5.59113667	Acanthamoeba healyi	65661	Discosea	other_Eukaryota	155	1.04e-43	NR	AAL67857.1	65661	g13824	i0	68.8	2.97329376854599	112	35	99.7	0	2	337	195	306	AAL67857.1 cysteine proteinase [Acanthamoeba healyi]	diamond	1002	155	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba healyi
26590123	26590123	PRJEB58983_P_NODE_31101_length_245_cov_0.906977_g30686_i0	PRJEB58983	31101	245	0.906977	2.22209365	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	87	9.47e-18	NR	XP_004367810.1	1257118	g30686	i0	53.1	0.991836734693878	81	38	99.2	0	245	3	299	379	XP_004367810.1 RhoGEF domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	243	87	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
27065138	27065138	PRJEB58983_P_NODE_4742_length_562_cov_1.928425_g4332_i0	PRJEB58983	4742	562	1.928425	10.8377485	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	47.8	0.00128	NR	XP_004351526.1	1257118	g4332	i0	46.9	0.261565836298932	49	26	26.2	0	509	363	26	74	XP_004351526.1 selT/selW/selH selenoprotein domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	147	47.8	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
27127996	27127996	PRJEB58983_P_NODE_28282_length_252_cov_0.871508_g27867_i0	PRJEB58983	28282	252	0.871508	2.19620016	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	107	5.07e-26	NR	XP_003293708.1	5786	g27867	i0	63.3	0.94047619047619	79	28	92.9	1	248	15	196	274	XP_003293708.1 uncharacterized protein DICPUDRAFT_84250 [Dictyostelium purpureum]	diamond	237	107	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
27697406	27697406	PRJEB58983_P_NODE_22584_length_276_cov_2.216749_g22169_i0	PRJEB58983	22584	276	2.216749	6.11822724	Heterostelium album PN5	2086695	Evosea	other_Eukaryota	90.9	4.35e-19	NR	XP_020430246.1	670386	g22169	i0	60.9	1.54347826086957	64	25	69.6	0	209	18	37	100	XP_020430246.1 isovaleryl-CoA dehydrogenase [Heterostelium album PN500]	diamond	426	90.9	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
27823507	27823507	PRJEB58983_P_NODE_27964_length_253_cov_0.866667_g27549_i0	PRJEB58983	27964	253	0.866667	2.19266751	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	48.9	2.96e-4	NR	XP_004367915.1	1257118	g27549	i0	37.2	1.0197628458498	86	50	98.4	3	5	253	20	104	XP_004367915.1 leucine rich repeat domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	258	48.9	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
28139338	28139338	PRJEB58983_P_NODE_30725_length_246_cov_0.901734_g30310_i0	PRJEB58983	30725	246	0.901734	2.21826564	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	59.3	5.2100000000000003e-08	NR	PRP88790.1	1890364	g30310	i0	38.3	0.98780487804878	81	41	98.8	1	2	244	295	366	PRP88790.1 translation factor [Planoprotostelium fungivorum]	diamond	243	59.3	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
28833655	28833655	PRJEB58983_P_NODE_21108_length_284_cov_1.379147_g20693_i0	PRJEB58983	21108	284	1.379147	3.91677748	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	130	8.94e-36	NR	PRP86688.1	1890364	g20693	i0	67.4	1.88028169014085	89	29	94	0	267	1	83	171	PRP86688.1 hypothetical protein PROFUN_05167 [Planoprotostelium fungivorum]	diamond	534	130	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
31202182	31202182	PRJEB58983_P_NODE_31215_length_245_cov_0.877907_g30800_i0	PRJEB58983	31215	245	0.877907	2.15087215	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	82.8	3e-16	NR	XP_004350707.1	261658	g30800	i0	54.9	0.869387755102041	71	32	86.9	0	241	29	629	699	XP_004350707.1 uncharacterized protein DFA_11760 [Cavenderia fasciculata]	diamond	213	82.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
31297480	31297480	PRJEB58983_P_NODE_27915_length_253_cov_0.866667_g27500_i0	PRJEB58983	27915	253	0.866667	2.19266751	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	92.8	1e-19	NR	PRP83916.1	1890364	g27500	i0	51.8	0.984189723320158	83	40	98.4	0	251	3	54	136	PRP83916.1 ubiquitin-like modifier activating enzyme 6 [Planoprotostelium fungivorum]	diamond	249	92.8	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
31519061	31519061	PRJEB58983_P_NODE_30696_length_246_cov_0.901734_g30281_i0	PRJEB58983	30696	246	0.901734	2.21826564	Heterostelium album PN5	2086695	Evosea	other_Eukaryota	52.4	1.56e-5	NR	XP_020431653.1	670386	g30281	i0	57.9	0.463414634146341	38	15	46.3	1	246	133	465	501	XP_020431653.1 putative zinc transporter [Heterostelium album PN500]	diamond	114	52.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
31582319	31582319	PRJEB58983_P_NODE_21596_length_281_cov_2.365385_g21181_i0	PRJEB58983	21596	281	2.365385	6.64673185	Acytostelium subglobosum LB1	1410327	Evosea	other_Eukaryota	95.5	1.63e-20	NR	XP_012752933.1	1410327	g21181	i0	51.6	0.99288256227758	93	44	99.3	1	279	1	50	141	XP_012752933.1 hypothetical protein SAMD00019534_070720 [Acytostelium subglobosum LB1]	diamond	279	95.5	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
32056672	32056672	PRJEB58983_P_NODE_29898_length_248_cov_0.891429_g29483_i0	PRJEB58983	29898	248	0.891429	2.21074392	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	47.8	6.9e-4	NR	PRP77243.1	1890364	g29483	i0	39.4	0.858870967741935	71	42	84.7	1	16	225	547	617	PRP77243.1 endoglucanase (endo-1,4-beta-glucanase) (cellulase) [Planoprotostelium fungivorum]	diamond	213	47.8	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum

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