metadata: contig_metadata: 6 rows where bioproject = "PRJNA1047551" and tax

6 rows where bioproject = "PRJNA1047551" 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
26591812	26591812	PRJNA1047551_S_NODE_2581_length_284_cov_1.907631_g2454_i0	PRJNA1047551	2581	284	1.907631	5.41767204	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	181	3.2199999999999993e-52	NR	PRP80716.1	1890364	g2454	i0	95.7	0.992957746478873	94	4	99.3	0	2	283	228	321	PRP80716.1 hypothetical protein PROFUN_11589 [Planoprotostelium fungivorum]	diamond	282	181	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
26718321	26718321	PRJNA1047551_S_NODE_5461_length_209_cov_5.425287_g5334_i0	PRJNA1047551	5461	209	5.425287	11.33884983	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	50.8	4.99e-6	NR	XP_004361742.1	261658	g5334	i0	44.4	0.77511961722488	54	29	76.1	1	13	171	54	107	XP_004361742.1 DUF614 family protein [Cavenderia fasciculata]	diamond	162	50.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
27129675	27129675	PRJNA1047551_S_NODE_6022_length_202_cov_1.311377_g5895_i0	PRJNA1047551	6022	202	1.311377	2.64898154	Dictyostelium discoideum AX4	352472	Evosea	other_Eukaryota	77	1.73e-14	NR	XP_637351.1	352472	g5895	i0	50	0.98019801980198	66	33	98	0	3	200	542	607	XP_637351.1 vacuolar H+-ATPase A subunit [Dictyostelium discoideum AX4]	diamond	198	77	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
30161425	30161425	PRJNA1047551_S_NODE_3552_length_248_cov_2.262911_g3425_i0	PRJNA1047551	3552	248	2.262911	5.61201928	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	47	3.96e-4	NR	XP_004349605.1	1257118	g3425	i0	57.1	0.423387096774194	35	15	42.3	0	248	144	99	133	XP_004349605.1 uncharacterized protein ACA1_142080 [Acanthamoeba castellanii str. Neff]	diamond	105	47	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
31299169	31299169	PRJNA1047551_S_NODE_11115_length_161_cov_4.277778_g10988_i0	PRJNA1047551	11115	161	4.277778	6.88722258	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	43.5	0.00285	NR	XP_004349605.1	1257118	g10988	i0	62.1	0.540372670807453	29	11	54	0	157	71	105	133	XP_004349605.1 uncharacterized protein ACA1_142080 [Acanthamoeba castellanii str. Neff]	diamond	87	43.5	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
31646950	31646950	PRJNA1047551_S_NODE_10677_length_164_cov_1.379845_g10550_i0	PRJNA1047551	10677	164	1.379845	2.2629458	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	65.9	3.13e-12	NR	XP_004336952.1	1257118	g10550	i0	66	0.914634146341463	50	17	91.5	0	1	150	48	97	XP_004336952.1 ubiquitin family protein [Acanthamoeba castellanii str. Neff]	diamond	150	65.9	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);;