metadata: contig_metadata: 10 rows where bioproject = "PRJEB25789" and tax

10 rows where bioproject = "PRJEB25789" 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
19148701	19148701	PRJEB25789_S_NODE_20336_length_236_cov_2.067485_g20257_i0	PRJEB25789	20336	236	2.067485	4.8792646	Dictyostelium purpureum	5786	Evosea	other_Eukaryota	209	1.19e-49	NTclustered	gi\|330790679\|ref\|XM_003283376.1\|	5786	g20257	i0	83.857	19.9152542372881	223	32	94	4	16	236	798	578	Dictyostelium purpureum 60S ribosomal protein L8 (DICPUDRAFT_91096), mRNA	blastn	4700	209	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
26646605	26646605	PRJEB25789_S_NODE_18261_length_246_cov_0.890173_g18182_i0	PRJEB25789	18261	246	0.890173	2.18982558	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	42.4	0.021	NR	XP_001737126.1	370354	g18182	i0	33.3	2.01219512195122	81	50	93.9	1	14	244	15	95	XP_001737126.1 profilin, putative [Entamoeba dispar SAW760]	diamond	495	42.4	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
27159331	27159331	PRJEB25789_S_NODE_17062_length_250_cov_0.864407_g16983_i0	PRJEB25789	17062	250	0.864407	2.1610175	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	112	6.89e-30	NR	XP_004333102.1	1257118	g16983	i0	68.8	0.96	80	25	96	0	250	11	54	133	XP_004333102.1 ribosomal protein L32, putative [Acanthamoeba castellanii str. Neff]	diamond	240	112	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
27349493	27349493	PRJEB25789_S_NODE_12263_length_283_cov_1.023810_g12184_i0	PRJEB25789	12263	283	1.02381	2.8973823	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	57.8	1.63e-8	NR	PRP89373.1	1890364	g12184	i0	63.2	0.92226148409894	87	30	91.2	2	277	20	3	88	PRP89373.1 hypothetical protein PROFUN_01236 [Planoprotostelium fungivorum]	diamond	261	57.8	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
27949201	27949201	PRJEB25789_S_NODE_14685_length_263_cov_2.231579_g14606_i0	PRJEB25789	14685	263	2.231579	5.86905277	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	104	3.93e-25	NR	XP_004337280.1	1257118	g14606	i0	63.5	0.96958174904943	85	31	97	0	255	1	147	231	XP_004337280.1 40S ribosomal protein S3a, putative [Acanthamoeba castellanii str. Neff]	diamond	255	104	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
28738571	28738571	PRJEB25789_S_NODE_16127_length_254_cov_1.276243_g16048_i0	PRJEB25789	16127	254	1.276243	3.24165722	Dictyostelium discoideum AX4	352472	Evosea	other_Eukaryota	157	2.9e-46	NR	XP_636818.2	352472	g16048	i0	84.5	4.96062992125984	84	13	99.2	0	3	254	4	87	XP_636818.2 S60 ribosomal protein L10 [Dictyostelium discoideum AX4]	diamond	1260	157	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
28991456	28991456	PRJEB25789_S_NODE_18328_length_246_cov_0.890173_g18249_i0	PRJEB25789	18328	246	0.890173	2.18982558	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	141	7.379999999999997e-42	NR	XP_004352812.1	1257118	g18249	i0	83.8	5.91463414634146	80	13	97.6	0	240	1	1	80	XP_004352812.1 ribosomal L37ae protein family [Acanthamoeba castellanii str. Neff]	diamond	1455	141	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
29622165	29622165	PRJEB25789_S_NODE_11150_length_293_cov_1.318182_g11071_i0	PRJEB25789	11150	293	1.318182	3.86227326	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	118	2.44e-30	NR	PRP83381.1	1890364	g11071	i0	66.3	0.849829351535836	83	28	85	0	259	11	150	232	PRP83381.1 ribosomal protein S3a, component of cytosolic 80S ribosome and 40S small subunit [Planoprotostelium fungivorum]	diamond	249	118	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
30949625	30949625	PRJEB25789_S_NODE_4394_length_422_cov_3.263610_g4315_i0	PRJEB25789	4394	422	3.26361	13.7724342	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	138	3.59e-38	NR	PRP86688.1	1890364	g4315	i0	57.1	1.79857819905213	126	52	88.2	2	420	49	81	206	PRP86688.1 hypothetical protein PROFUN_05167 [Planoprotostelium fungivorum]	diamond	759	138	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
32056237	32056237	PRJEB25789_S_NODE_7538_length_339_cov_1.274436_g7459_i0	PRJEB25789	7538	339	1.274436	4.32033804	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	107	1.5399999999999999e-24	NR	XP_004333651.1	1257118	g7459	i0	55.1	2.69026548672566	107	45	92	2	336	25	320	426	XP_004333651.1 coronin3, putative [Acanthamoeba castellanii str. Neff]	diamond	912	107	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);;