metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA546018" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA546018" 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
28436010	28436010	PRJNA546018_S_NODE_13586_length_455_cov_3.116751_g13262_i0	PRJNA546018	13586	455	3.116751	14.18121705	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	72.8	2.79e-13	NR	PRP78805.1	1890364	g13262	i0	59.3	0.389010989010989	59	23	38.9	1	418	242	1	58	PRP78805.1 hypothetical protein PROFUN_00978 [Planoprotostelium fungivorum]	diamond	177	72.8	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
29540899	29540899	PRJNA546018_S_NODE_34770_length_263_cov_3.153465_g34445_i0	PRJNA546018	34770	263	3.153465	8.29361295	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	47.8	5.57e-4	NR	XP_004351187.1	261658	g34445	i0	36.6	1.6425855513308	71	37	81	2	22	234	148	210	XP_004351187.1 translocon-associated protein subunit beta [Cavenderia fasciculata]	diamond	432	47.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
30994245	30994245	PRJNA546018_S_NODE_52534_length_209_cov_2.013514_g52209_i0	PRJNA546018	52534	209	2.013514	4.20824426	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	83.2	1.34e-16	NR	PRP73456.1	1890364	g52209	i0	59.4	0.91866028708134	64	26	91.9	0	204	13	245	308	PRP73456.1 component of SCAR regulatory complex, partial [Planoprotostelium fungivorum]	diamond	192	83.2	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
31183485	31183485	PRJNA546018_S_NODE_58015_length_200_cov_3.223022_g57690_i0	PRJNA546018	58015	200	3.223022	6.446044	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	55.8	4.59e-8	NR	KAH3757450.1	1580589	g57690	i0	47.8	1.395	46	24	69	0	7	144	42	87	KAH3757450.1 hypothetical protein Pelo_10776 [Pelomyxa schiedti]	diamond	279	55.8	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti
31657938	31657938	PRJNA546018_S_NODE_12777_length_472_cov_11.586375_g12453_i0	PRJNA546018	12777	472	11.586375	54.68769	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	113	1.15e-28	NR	XP_004356446.1	1257118	g12453	i0	67.1	0.444915254237288	70	23	44.5	0	225	434	72	141	XP_004356446.1 cytochrome-c oxidase [Acanthamoeba castellanii str. Neff]	diamond	210	113	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
32638318	32638318	PRJNA546018_S_NODE_33640_length_268_cov_2.628019_g33315_i0	PRJNA546018	33640	268	2.628019	7.04309092	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	53.1	1.15e-5	NR	KYR03085.1	361077	g33315	i0	52.2	1.02985074626866	46	22	51.5	0	201	64	1194	1239	KYR03085.1 DOCK family protein [Tieghemostelium lacteum]	diamond	276	53.1	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
32827558	32827558	PRJNA546018_S_NODE_17180_length_396_cov_4.053731_g16855_i0	PRJNA546018	17180	396	4.053731	16.05277476	Vermamoeba vermiformis	5778	Tubulinea	other_Eukaryota	138	1.03e-39	NR	YP_003540819.1	5778	g16855	i0	84	1.13636363636364	75	12	56.8	0	171	395	7	81	YP_003540819.1 ribosomal protein S19 [Vermamoeba vermiformis]	diamond	450	138	1	Eukaryota	Amoebozoa	Tubulinea	Echinamoebida			Vermamoeba	Vermamoeba vermiformis
32890347	32890347	PRJNA546018_S_NODE_4340_length_883_cov_17.532847_g4115_i0	PRJNA546018	4340	883	17.532847	154.81503901	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	134	2.31e-33	NR	PRP87951.1	1890364	g4115	i0	51.2	0.431483578708947	127	61	42.8	1	663	286	26	152	PRP87951.1 hypothetical protein PROFUN_02688 [Planoprotostelium fungivorum]	diamond	381	134	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);;