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

9 rows where analysis = "diamond", bioproject = "PRJNA168635" 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
27692245	27692245	PRJNA168635_P_NODE_21364_length_178_cov_1.604651_g20948_i0	PRJNA168635	21364	178	1.604651	2.85627878	Eumycetozoa	142796	Evosea	other_Eukaryota	50.1	4.13e-5	NR	KAF2077285.1	133409	g20948	i0	44.9	2.6123595505618	49	26	80.9	1	169	26	900	948	KAF2077285.1 hypothetical protein CYY_001410 [Polysphondylium violaceum]	diamond	465	50.1	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
27706121	27706121	PRJNA168635_P_NODE_25104_length_169_cov_1.608333_g24688_i0	PRJNA168635	25104	169	1.608333	2.71808277	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	41.2	0.0497	NR	KYQ91743.1	361077	g24688	i0	33.9	0.994082840236686	56	37	99.4	0	169	2	107	162	KYQ91743.1 myosin heavy chain kinase [Tieghemostelium lacteum]	diamond	168	41.2	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
28652969	28652969	PRJNA168635_P_NODE_12627_length_229_cov_1.238889_g12211_i0	PRJNA168635	12627	229	1.238889	2.83705581	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	48.9	1.82e-5	NR	XP_004354089.1	261658	g12211	i0	33.9	0.77292576419214	59	39	77.3	0	216	40	10	68	XP_004354089.1 uncharacterized protein DFA_10181 [Cavenderia fasciculata]	diamond	177	48.9	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
28905283	28905283	PRJNA168635_P_NODE_34568_length_154_cov_3.428571_g34152_i0	PRJNA168635	34568	154	3.428571	5.27999934	Acanthamoeba castellanii	5755	Discosea	other_Eukaryota	79	1.03e-15	NR	BBJ29173.1	5755	g34152	i0	66.7	1.98701298701299	51	17	99.4	0	154	2	140	190	BBJ29173.1 cysteine proteinase 5 [Acanthamoeba castellanii]	diamond	306	79	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
29884529	29884529	PRJNA168635_P_NODE_32151_length_162_cov_0.920354_g31735_i0	PRJNA168635	32151	162	0.920354	1.49097348	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	72.4	3.06e-13	NR	XP_004344650.1	1257118	g31735	i0	63	1	54	20	100	0	1	162	216	269	XP_004344650.1 uncharacterized protein ACA1_278780 [Acanthamoeba castellanii str. Neff]	diamond	162	72.4	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
31432706	31432706	PRJNA168635_P_NODE_11436_length_242_cov_3.316062_g11020_i0	PRJNA168635	11436	242	3.316062	8.02487004	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	42.4	0.0472	NR	KAH3759767.1	1580589	g11020	i0	45.9	0.45867768595041303	37	20	45.9	0	238	128	128	164	KAH3759767.1 papain cysteine proteinase [Pelomyxa schiedti]	diamond	111	42.4	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti
32002145	32002145	PRJNA168635_P_NODE_16498_length_197_cov_1.702703_g16082_i0	PRJNA168635	16498	197	1.702703	3.35432491	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	92.8	5.9400000000000005e-21	NR	AER35085.1	361077	g16082	i0	68.9	3.71573604060914	61	19	92.9	0	13	195	171	231	AER35085.1 ribosomal protein S2 [Tieghemostelium lacteum]	diamond	732	92.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
32128904	32128904	PRJNA168635_P_NODE_22018_length_176_cov_2.417323_g21602_i0	PRJNA168635	22018	176	2.417323	4.25448848	Dictyostelium discoideum	44689	Evosea	other_Eukaryota	80.9	2.58e-16	NR	BAD89149.1	44689	g21602	i0	71.1	1.36363636363636	38	11	64.8	0	1	114	285	322	BAD89149.1 inhibitor of growth-1 homologue, DNG1 [Dictyostelium discoideum]	diamond	240	80.9	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
32886339	32886339	PRJNA168635_P_NODE_31120_length_163_cov_0.912281_g30704_i0	PRJNA168635	31120	163	0.912281	1.48701803	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	59.3	1.8e-8	NR	PRP88592.1	1890364	g30704	i0	52.8	1.87730061349693	53	25	97.5	0	162	4	244	296	PRP88592.1 transcription elongation regulator 1-like [Planoprotostelium fungivorum]	diamond	306	59.3	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);;