metadata: contig_metadata: 6 rows where analysis = "diamond", bioproject = "PRJEB7799" and tax

6 rows where analysis = "diamond", bioproject = "PRJEB7799" 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
32913609	32913609	PRJEB7799o_S_NODE_5009_length_151_cov_1.241379_g5001_i0	PRJEB7799	5009	151	1.241379	1.87448229	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	74.7	6.4e-16	NR	XP_004352812.1	1257118	g5001	i0	78.6	6.6158940397351	42	9	83.4	0	151	26	50	91	XP_004352812.1 ribosomal L37ae protein family [Acanthamoeba castellanii str. Neff]	diamond	999	74.7	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
32913772	32913772	PRJEB7799p_S_NODE_3873_length_256_cov_4.619910_g3850_i0	PRJEB7799	3873	256	4.61991	11.8269696	Acytostelium subglobosum LB1	1410327	Evosea	other_Eukaryota	48.9	2.88e-4	NR	XP_012748867.1	1410327	g3850	i0	69	0.66796875	29	9	34	0	2	88	49	77	XP_012748867.1 hypothetical protein SAMD00019534_114090 [Acytostelium subglobosum LB1]	diamond	171	48.9	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum
32957663	32957663	PRJEB7799p_S_NODE_4530_length_241_cov_4.165049_g4507_i0	PRJEB7799	4530	241	4.165049	10.03776809	root	1	Root_unresolved	Root_unresolved	87	7.24e-20	NR	P22271.2	5791	g4507	i0	72.7	2.05394190871369	55	15	68.5	0	240	76	70	124	P22271.2 RecName: Full=Profilin-A [Physarum polycephalum]	diamond	495	87.8	0.990888382687927	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Physariida	Physaraceae	Physarum	Physarum polycephalum
33042879	33042879	PRJEB7799p_S_NODE_4924_length_235_cov_2.485000_g4901_i0	PRJEB7799	4924	235	2.485	5.83975	Acanthamoeba	5754	Discosea	other_Eukaryota	47.4	7.44e-4	NR	ABY63400.1	65661	g4901	i0	42.4	1.5063829787234	59	33	75.3	1	3	179	352	409	ABY63400.1 encystation-mediating serine proteinase [Acanthamoeba healyi]	diamond	354	47.8	0.99163179916318	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba healyi
33101462	33101462	PRJEB7799o_S_NODE_1982_length_190_cov_3.154839_g1974_i0	PRJEB7799	1982	190	3.154839	5.9941941	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	55.8	8.82e-8	NR	KYR02504.1	361077	g1974	i0	54.3	1.43684210526316	46	21	72.6	0	188	51	100	145	KYR02504.1 actin binding protein [Tieghemostelium lacteum]	diamond	273	55.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
33169782	33169782	PRJEB7799p_S_NODE_17072_length_172_cov_2.335766_g17049_i0	PRJEB7799	17072	172	2.335766	4.01751752	Polysphondylium violaceum	133409	Evosea	other_Eukaryota	46.6	3.41e-4	NR	KAF2071651.1	133409	g17049	i0	43.1	0.88953488372093	51	27	89	1	6	158	123	171	KAF2071651.1 hypothetical protein CYY_007026 [Polysphondylium violaceum]	diamond	153	46.6	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum

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