metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA1020641" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA1020641" 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
26773969	26773969	PRJNA1020641_P_NODE_6841_length_244_cov_0.900585_g6798_i0	PRJNA1020641	6841	244	0.900585	2.1974274	Entamoeba	5758	Evosea	other_Eukaryota	110	6.35e-26	NR	XP_656795.1	294381	g6798	i0	58	2.98770491803279	81	34	99.6	0	1	243	451	531	XP_656795.1 phosphoribulokinase /uridine kinase family protein [Entamoeba histolytica HM-1:IMSS]	diamond	729	110	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba histolytica
28551003	28551003	PRJNA1020641_P_NODE_7207_length_242_cov_0.911243_g7164_i0	PRJNA1020641	7207	242	0.911243	2.20520806	Acytostelium subglobosum LB1	1410327	Evosea	other_Eukaryota	61.6	5.41e-9	NR	XP_012751385.1	1410327	g7164	i0	53.2	1.53719008264463	62	29	76.9	0	187	2	1	62	XP_012751385.1 hypothetical protein SAMD00019534_090420, partial [Acytostelium subglobosum LB1]	diamond	372	61.6	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
29498004	29498004	PRJNA1020641_P_NODE_6510_length_246_cov_0.890173_g6467_i0	PRJNA1020641	6510	246	0.890173	2.18982558	Entamoeba dispar SAW76	46681	Evosea	other_Eukaryota	75.1	1.5e-13	NR	XP_001739217.1	370354	g6467	i0	45.5	2.76829268292683	77	42	93.9	0	11	241	193	269	XP_001739217.1 uridine cytidine kinase I, putative [Entamoeba dispar SAW760]	diamond	681	75.1	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
30666775	30666775	PRJNA1020641_P_NODE_6033_length_249_cov_0.875000_g5990_i0	PRJNA1020641	6033	249	0.875	2.17875	Entamoeba dispar SAW76	46681	Evosea	other_Eukaryota	55.8	8.75e-7	NR	XP_001738252.1	370354	g5990	i0	39.7	3.67469879518072	73	41	84.3	1	230	21	68	140	XP_001738252.1 uncharacterized protein EDI_301180 [Entamoeba dispar SAW760]	diamond	915	55.8	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba dispar
31583677	31583677	PRJNA1020641_P_NODE_5536_length_251_cov_0.865169_g5493_i0	PRJNA1020641	5536	251	0.865169	2.17157419	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	63.5	1.97e-9	NR	PRP77143.1	1890364	g5493	i0	43.8	2.73705179282869	73	40	87.3	1	225	7	1142	1213	PRP77143.1 alpha amylase domain-containing protein, partial [Planoprotostelium fungivorum]	diamond	687	63.5	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
31615086	31615086	PRJNA1020641_P_NODE_7296_length_242_cov_0.911243_g7253_i0	PRJNA1020641	7296	242	0.911243	2.20520806	Acytostelium subglobosum LB1	1410327	Evosea	other_Eukaryota	57	2.99e-7	NR	XP_012759414.1	1410327	g7253	i0	58.7	4.53719008264463	46	19	57	0	104	241	154	199	XP_012759414.1 hypothetical protein SAMD00019534_005270, partial [Acytostelium subglobosum LB1]	diamond	1098	57	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
32595862	32595862	PRJNA1020641_P_NODE_5820_length_250_cov_0.870056_g5777_i0	PRJNA1020641	5820	250	0.870056	2.17514	Entamoeba invadens IP1	370355	Evosea	other_Eukaryota	90.5	6.13e-19	NR	XP_004183988.1	370355	g5777	i0	53.2	2.856	77	36	92.4	0	3	233	37	113	XP_004183988.1 Luminal-binding protein 4 precursor, putative [Entamoeba invadens IP1]	diamond	714	90.5	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba invadens

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