metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA692200" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA692200" 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
16482127	16482127	PRJNA692200_S_NODE_8373_length_240_cov_1.596859_g8316_i0	PRJNA692200	8373	240	1.596859	3.8324616	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	114	2.96e-27	NR	XP_004359557.1	261658	g8316	i0	71.1	2.85	76	22	95	0	3	230	596	671	XP_004359557.1 succinate dehydrogenase [Cavenderia fasciculata]	diamond	684	114	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
21075311	21075311	PRJNA692200_S_NODE_3717_length_318_cov_6.910781_g3660_i0	PRJNA692200	3717	318	6.910781	21.97628358	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	151	2.1799999999999994e-42	NR	XP_004356622.1	1257118	g3660	i0	83.5	0.80188679245283	85	14	80.2	0	316	62	231	315	XP_004356622.1 mitochondrial phosphate transporter, putative [Acanthamoeba castellanii str. Neff]	diamond	255	151	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
26702556	26702556	PRJNA692200_S_NODE_19901_length_167_cov_1.381356_g19844_i0	PRJNA692200	19901	167	1.381356	2.30686452	Entamoeba histolytica HM-1:IMSS	294381	Evosea	other_Eukaryota	61.6	2.89e-9	NR	XP_654998.1	294381	g19844	i0	51.9	2.80239520958084	52	25	93.4	0	166	11	408	459	XP_654998.1 alanyl-tRNA synthetase, putative [Entamoeba histolytica HM-1:IMSS]	diamond	468	61.6	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica
27461946	27461946	PRJNA692200_S_NODE_18123_length_173_cov_1.637097_g18066_i0	PRJNA692200	18123	173	1.637097	2.83217781	Polysphondylium violaceum	133409	Evosea	other_Eukaryota	42	0.018	NR	KAF2073891.1	133409	g18066	i0	71.4	0.364161849710983	21	6	36.4	0	1	63	144	164	KAF2073891.1 hypothetical protein CYY_004815 [Polysphondylium violaceum]	diamond	63	42	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
30177281	30177281	PRJNA692200_S_NODE_14612_length_190_cov_1.078014_g14555_i0	PRJNA692200	14612	190	1.078014	2.0482266	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	74.7	9.59e-14	NR	PRP86442.1	1890364	g14555	i0	73.3	0.710526315789474	45	12	71.1	0	6	140	144	188	PRP86442.1 hypothetical protein PROFUN_05361 [Planoprotostelium fungivorum]	diamond	135	74.7	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
30208702	30208702	PRJNA692200_S_NODE_22132_length_162_cov_0.893805_g22075_i0	PRJNA692200	22132	162	0.893805	1.4479641	Entamoeba histolytica	5759	Evosea	other_Eukaryota	57.4	5.6e-8	NR	AAF73892.1	5759	g22075	i0	50.8	2.18518518518519	59	23	98.1	1	3	161	173	231	AAF73892.1 enhancer binding protein-1 [Entamoeba histolytica]	diamond	354	57.4	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica
30462158	30462158	PRJNA692200_S_NODE_17893_length_174_cov_1.512000_g17836_i0	PRJNA692200	17893	174	1.512	2.63088	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	58.9	2.8e-8	NR	XP_004368092.1	1257118	g17836	i0	59.2	0.844827586206897	49	18	84.5	1	173	27	479	525	XP_004368092.1 GTPase of unknown function subfamily protein [Acanthamoeba castellanii str. Neff]	diamond	147	58.9	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
30556313	30556313	PRJNA692200_S_NODE_15773_length_184_cov_1.911111_g15716_i0	PRJNA692200	15773	184	1.911111	3.51644424	Acytostelium subglobosum LB1	1410327	Evosea	other_Eukaryota	46.2	0.00103	NR	XP_012755097.1	1410327	g15716	i0	48	1.48369565217391	50	26	81.5	0	151	2	108	157	XP_012755097.1 hypothetical protein SAMD00019534_051720 [Acytostelium subglobosum LB1]	diamond	273	46.2	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
32611779	32611779	PRJNA692200_S_NODE_20400_length_166_cov_0.888889_g20343_i0	PRJNA692200	20400	166	0.888889	1.47555574	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	71.2	6.3e-14	NR	KAH3761877.1	1580589	g20343	i0	59.3	0.975903614457831	54	22	97.6	0	162	1	81	134	KAH3761877.1 multiprotein-bridging factor 1b [Pelomyxa schiedti]	diamond	162	71.2	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti

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