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

8 rows where analysis = "diamond", bioproject = "PRJNA688736" 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
3729659	3729659	PRJNA688736_P_NODE_47323_length_245_cov_1.360465_g47038_i0	PRJNA688736	47323	245	1.360465	3.33313925	Ceratiomyxa fruticulosa	435415	Evosea	other_Eukaryota	132	8.289999999999998e-35	NR	ABY84903.1	435415	g47038	i0	74.1	3.96734693877551	81	21	99.2	0	244	2	117	197	ABY84903.1 elongation factor 1A, partial [Ceratiomyxa fruticulosa]	diamond	972	132	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa		Ceratiomyxaceae	Ceratiomyxa	Ceratiomyxa fruticulosa
14696900	14696900	PRJNA688736_P_NODE_40932_length_252_cov_0.871508_g40647_i0	PRJNA688736	40932	252	0.871508	2.19620016	Evosea	2605435	Evosea	other_Eukaryota	119	2.899999999999999e-29	NR	AOE43339.1	361085	g40647	i0	71.4	2	84	24	100	0	1	252	435	518	AOE43339.1 dihydrolipoamide acetyltransferase [Synstelium polycarpum]	diamond	504	120	0.991666666666667	Eukaryota	Amoebozoa	Evosea	Eumycetozoa			Synstelium	Synstelium polycarpum
26809099	26809099	PRJNA688736_P_NODE_51421_length_231_cov_2.670886_g51136_i0	PRJNA688736	51421	231	2.670886	6.16974666	Eumycetozoa	142796	Evosea	other_Eukaryota	67.4	1.48e-11	NR	XP_012759525.1	1410327	g51136	i0	63	3.75324675324675	46	17	59.7	0	215	78	118	163	XP_012759525.1 hypothetical protein SAMD00019534_006380, partial [Acytostelium subglobosum LB1]	diamond	867	67.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
27050731	27050731	PRJNA688736_P_NODE_41982_length_251_cov_0.876404_g41697_i0	PRJNA688736	41982	251	0.876404	2.19977404	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	147	1.3099999999999999e-42	NR	XP_004348701.1	1257118	g41697	i0	88.6	0.944223107569721	79	9	94.4	0	239	3	1	79	XP_004348701.1 Ras family protein [Acanthamoeba castellanii str. Neff]	diamond	237	147	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
27303659	27303659	PRJNA688736_P_NODE_28843_length_298_cov_0.915556_g28558_i0	PRJNA688736	28843	298	0.915556	2.72835688	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	134	5.81e-38	NR	7SOG_A	5755	g28558	i0	62.2	0.986577181208054	98	37	98.7	0	3	296	3	100	7SOG_A Chain A, Actophorin [Acanthamoeba castellanii]	diamond	294	134	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
28882223	28882223	PRJNA688736_P_NODE_39868_length_253_cov_0.866667_g39583_i0	PRJNA688736	39868	253	0.866667	2.19266751	Polysphondylium violaceum	133409	Evosea	other_Eukaryota	89.7	1.07e-18	NR	KAF2074889.1	133409	g39583	i0	60.5	0.901185770750988	76	28	87.7	1	253	32	404	479	KAF2074889.1 hypothetical protein CYY_003808 [Polysphondylium violaceum]	diamond	228	89.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
29304259	29304259	PRJNA688736_P_NODE_45149_length_248_cov_0.891429_g44864_i0	PRJNA688736	45149	248	0.891429	2.21074392	root	1	Root_unresolved	Root_unresolved	127	2.88e-33	NR	KAF2075816.1	133409	g44864	i0	71.3	26.5161290322581	80	23	96.8	0	3	242	245	324	KAF2075816.1 hypothetical protein CYY_002899 [Polysphondylium violaceum]	diamond	6576	128	0.9921875	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
30461860	30461860	PRJNA688736_P_NODE_44173_length_249_cov_0.886364_g43888_i0	PRJNA688736	44173	249	0.886364	2.20704636	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	49.7	1.4e-4	NR	KAH3756930.1	1580589	g43888	i0	38.6	0.686746987951807	57	33	66.3	1	185	21	19	75	KAH3756930.1 hypothetical protein Pelo_11239 [Pelomyxa schiedti]	diamond	171	49.7	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);;