metadata: contig_metadata: 10 rows where analysis = "diamond", bioproject = "PRJNA1263632" and tax

10 rows where analysis = "diamond", bioproject = "PRJNA1263632" and tax_phylum = "Evosea"

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
2914513	2914513	PRJNA1263632_P_NODE_8063_length_243_cov_0.905882_g8045_i0	PRJNA1263632	8063	243	0.905882	2.20129326	Eumycetozoa	142796	Evosea	other_Eukaryota	105	1.52e-25	NR	XP_629513.1	352472	g8045	i0	65.3	2.65432098765432	72	25	88.9	0	243	28	202	273	XP_629513.1 cytochrome c1 [Dictyostelium discoideum AX4]	diamond	645	105	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium discoideum
9291970	9291970	PRJNA1263632_P_NODE_8408_length_241_cov_0.916667_g8390_i0	PRJNA1263632	8408	241	0.916667	2.20916747	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	148	1.25e-40	NR	XP_004357511.1	261658	g8390	i0	91.3	290.788381742739	80	7	99.6	0	240	1	213	292	XP_004357511.1 26S proteasome ATPase 1 subunit [Cavenderia fasciculata]	diamond	70080	149	0.993288590604027	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
18215457	18215457	PRJNA1263632_P_NODE_4895_length_285_cov_1.165094_g4877_i0	PRJNA1263632	4895	285	1.165094	3.3205179	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	118	1.49e-28	NR	PRP83857.1	1890364	g4877	i0	57.5	1.89473684210526	87	37	91.6	0	284	24	133	219	PRP83857.1 hypothetical protein PROFUN_08888 [Planoprotostelium fungivorum]	diamond	540	118	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
27516254	27516254	PRJNA1263632_P_NODE_3023_length_352_cov_1.157706_g3005_i0	PRJNA1263632	3023	352	1.157706	4.07512512	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	95.9	3.18e-20	NR	KAH3743581.1	1580589	g3005	i0	43.1	0.928977272727273	109	57	92.9	1	348	22	964	1067	KAH3743581.1 alpha-actinin A [Pelomyxa schiedti]	diamond	327	95.9	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti
28621498	28621498	PRJNA1263632_P_NODE_8227_length_242_cov_0.911243_g8209_i0	PRJNA1263632	8227	242	0.911243	2.20520806	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	56.6	4.42e-7	NR	PRP77957.1	1890364	g8209	i0	41.1	0.90495867768595	73	40	90.5	1	2	220	259	328	PRP77957.1 actin related protein 2/3 complex, subunit 1 [Planoprotostelium fungivorum]	diamond	219	56.6	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
30832148	30832148	PRJNA1263632_P_NODE_2594_length_378_cov_1.413115_g2576_i0	PRJNA1263632	2594	378	1.413115	5.3415747	Polysphondylium violaceum	133409	Evosea	other_Eukaryota	103	1.07e-22	NR	KAF2078555.1	133409	g2576	i0	48	0.992063492063492	125	44	98.4	4	6	377	272	376	KAF2078555.1 hypothetical protein CYY_000178 [Polysphondylium violaceum]	diamond	375	103	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
30863712	30863712	PRJNA1263632_P_NODE_5514_length_269_cov_1.954082_g5496_i0	PRJNA1263632	5514	269	1.954082	5.25648058	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	62.8	4.03e-10	NR	PRP84247.1	1890364	g5496	i0	73.8	0.468401486988848	42	11	46.8	0	268	143	63	104	PRP84247.1 40S ribosomal protein S26 [Planoprotostelium fungivorum]	diamond	126	62.8	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
31355819	31355819	PRJNA1263632_P_NODE_8036_length_243_cov_0.905882_g8018_i0	PRJNA1263632	8036	243	0.905882	2.20129326	Evosea	2605435	Evosea	other_Eukaryota	131	2.04e-33	NR	XP_003293579.1	5786	g8018	i0	77.2	5.8641975308642	79	17	97.5	1	2	238	1917	1994	XP_003293579.1 uncharacterized protein DICPUDRAFT_158449 [Dictyostelium purpureum]	diamond	1425	132	0.992424242424242	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
32223690	32223690	PRJNA1263632_P_NODE_7578_length_245_cov_0.895349_g7560_i0	PRJNA1263632	7578	245	0.895349	2.19360505	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	64.7	6.81e-10	NR	KYR01881.1	361077	g7560	i0	49.2	0.795918367346939	65	32	78.4	1	202	11	111	175	KYR01881.1 hypothetical protein DLAC_01903 [Tieghemostelium lacteum]	diamond	195	64.7	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
32287222	32287222	PRJNA1263632_P_NODE_3639_length_325_cov_1.142857_g3621_i0	PRJNA1263632	3639	325	1.142857	3.71428525	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	120	3.19e-30	NR	PRP77957.1	1890364	g3621	i0	53.3	0.987692307692308	107	49	97.8	1	323	6	162	268	PRP77957.1 actin related protein 2/3 complex, subunit 1 [Planoprotostelium fungivorum]	diamond	321	120	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);;