metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA939415" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA939415" 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
26708281	26708281	PRJNA939415_P_NODE_87641_length_247_cov_3.172414_g87219_i0	PRJNA939415	87641	247	3.172414	7.83586258	Heterostelium album PN5	2086695	Evosea	other_Eukaryota	46.2	0.0015	NR	XP_020436228.1	670386	g87219	i0	41.9	0.522267206477733	43	24	52.2	1	106	234	91	132	XP_020436228.1 hypothetical protein PPL_03184 [Heterostelium album PN500]	diamond	129	46.2	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium album
27600947	27600947	PRJNA939415_P_NODE_88444_length_247_cov_0.885057_g88022_i0	PRJNA939415	88444	247	0.885057	2.18609079	Acytosteliales	2058181	Evosea	other_Eukaryota	43.1	0.0283	NR	XP_004350678.1	261658	g88022	i0	43.8	1.2753036437247	48	12	58.3	1	245	102	350	382	XP_004350678.1 pleckstrin domain-containing protein [Cavenderia fasciculata]	diamond	315	43.1	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
27846318	27846318	PRJNA939415_P_NODE_91524_length_244_cov_2.467836_g91102_i0	PRJNA939415	91524	244	2.467836	6.02151984	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	48.5	3.47e-4	NR	XP_004368092.1	1257118	g91102	i0	53.8	1.77049180327869	39	18	48	0	65	181	218	256	XP_004368092.1 GTPase of unknown function subfamily protein [Acanthamoeba castellanii str. Neff]	diamond	432	48.5	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
29424849	29424849	PRJNA939415_P_NODE_100749_length_233_cov_5.393750_g100327_i0	PRJNA939415	100749	233	5.39375	12.5674375	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	86.7	1.14e-17	NR	XP_004338567.1	1257118	g100327	i0	61.6	1.931330472103	73	28	94	0	3	221	728	800	XP_004338567.1 MIF4G domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	450	86.7	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
30278151	30278151	PRJNA939415_P_NODE_102352_length_231_cov_3.132911_g101930_i0	PRJNA939415	102352	231	3.132911	7.23702441	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	88.2	3.07e-18	NR	KAH3764427.1	1580589	g101930	i0	56.6	0.987012987012987	76	30	98.7	1	2	229	332	404	KAH3764427.1 hypothetical protein Pelo_3725 [Pelomyxa schiedti]	diamond	228	88.2	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti
30341628	30341628	PRJNA939415_P_NODE_91472_length_244_cov_2.573099_g91050_i0	PRJNA939415	91472	244	2.573099	6.27836156	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	48.5	3.62e-4	NR	PRP86402.1	1890364	g91050	i0	40.3	1.65983606557377	67	29	82.4	2	1	201	749	804	PRP86402.1 hypothetical protein PROFUN_05321 [Planoprotostelium fungivorum]	diamond	405	48.5	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
30625291	30625291	PRJNA939415_P_NODE_77773_length_256_cov_2.628415_g77351_i0	PRJNA939415	77773	256	2.628415	6.7287424	Dictyostelium discoideum AX4	352472	Evosea	other_Eukaryota	57.4	3.11e-7	NR	XP_645927.1	352472	g77351	i0	33.7	3.87890625	83	45	97.3	1	8	256	622	694	XP_645927.1 WD-40 repeat-containing protein [Dictyostelium discoideum AX4]	diamond	993	57.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
31288863	31288863	PRJNA939415_P_NODE_36815_length_298_cov_3.897778_g36393_i0	PRJNA939415	36815	298	3.897778	11.61537844	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	74.7	3.76e-13	NR	XP_004336254.1	1257118	g36393	i0	64	0.503355704697987	50	18	50.3	0	150	1	282	331	XP_004336254.1 RNA 3'terminal phosphate cyclase [Acanthamoeba castellanii str. Neff]	diamond	150	74.7	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
31763433	31763433	PRJNA939415_P_NODE_56517_length_277_cov_2.480392_g56095_i0	PRJNA939415	56517	277	2.480392	6.87068584	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	62.4	6.91e-9	NR	PRP82273.1	1890364	g56095	i0	39.3	1.66787003610108	89	53	96.4	1	9	275	1049	1136	PRP82273.1 amine oxidase [Planoprotostelium fungivorum]	diamond	462	62.4	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
32364797	32364797	PRJNA939415_P_NODE_96079_length_240_cov_3.898204_g95657_i0	PRJNA939415	96079	240	3.898204	9.3556896	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	94.4	2.46e-20	NR	XP_004343994.1	1257118	g95657	i0	51.3	0.95	76	37	95	0	5	232	893	968	XP_004343994.1 aldehyde oxidase and xanthine dehydrogenase, molybdopterin binding domain containing protein [Acanthamoeba castellanii str. Neff]	diamond	228	94.4	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii

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