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

8 rows where analysis = "diamond", bioproject = "PRJNA635874" 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
9536527	9536527	PRJNA635874_P_NODE_60448_length_246_cov_0.890173_g60301_i0	PRJNA635874	60448	246	0.890173	2.18982558	Acytosteliales	2058181	Evosea	other_Eukaryota	136	5.06e-35	NR	XP_004360305.1	261658	g60301	i0	84.6	2.91463414634146	78	12	95.1	0	12	245	1063	1140	XP_004360305.1 acetyl-CoA C-acyltransferase [Cavenderia fasciculata]	diamond	717	137	0.992700729927007	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
27523300	27523300	PRJNA635874_P_NODE_48803_length_250_cov_0.870056_g48656_i0	PRJNA635874	48803	250	0.870056	2.17514	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	54.3	3.38e-6	NR	KAH3766129.1	1580589	g48656	i0	34.9	1.896	83	52	97.2	1	248	6	932	1014	KAH3766129.1 Ubiquitin activating enzyme [Pelomyxa schiedti]	diamond	474	54.3	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti
29051580	29051580	PRJNA635874_P_NODE_13168_length_415_cov_1.035088_g13021_i0	PRJNA635874	13168	415	1.035088	4.2956152	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	67.8	4.34e-10	NR	KYQ89057.1	361077	g13021	i0	39.4	1.57590361445783	109	66	78.8	0	3	329	676	784	KYQ89057.1 major vault protein [Tieghemostelium lacteum]	diamond	654	67.8	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
29291448	29291448	PRJNA635874_P_NODE_57189_length_247_cov_0.885057_g57042_i0	PRJNA635874	57189	247	0.885057	2.18609079	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	92.4	1.27e-19	NR	XP_004359266.1	261658	g57042	i0	52.6	3.69230769230769	76	36	92.3	0	246	19	454	529	XP_004359266.1 Physaropepsin [Cavenderia fasciculata]	diamond	912	92.4	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
29764944	29764944	PRJNA635874_P_NODE_60891_length_245_cov_1.848837_g60744_i0	PRJNA635874	60891	245	1.848837	4.52965065	Pelomyxa schiedti	1580589	Evosea	other_Eukaryota	67	1.08e-10	NR	KAH3756653.1	1580589	g60744	i0	44.4	0.991836734693878	81	45	99.2	0	244	2	521	601	KAH3756653.1 glycosyl hydrolase [Pelomyxa schiedti]	diamond	243	67	1	Eukaryota	Amoebozoa	Evosea		Pelobiontida	Pelomyxidae	Pelomyxa	Pelomyxa schiedti
30378200	30378200	PRJNA635874_P_NODE_71352_length_242_cov_0.881657_g71205_i0	PRJNA635874	71352	242	0.881657	2.13360994	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	80.9	1.35e-15	NR	KAF2074760.1	133409	g71205	i0	46.8	5.31818181818182	77	41	95.5	0	7	237	397	473	KAF2074760.1 hypothetical protein CYY_003948 [Polysphondylium violaceum]	diamond	1287	80.9	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Polysphondylium	Polysphondylium violaceum
30978294	30978294	PRJNA635874_P_NODE_14054_length_404_cov_1.250755_g13907_i0	PRJNA635874	14054	404	1.250755	5.0530502	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	130	3.33e-32	NR	XP_003284160.1	5786	g13907	i0	48.1	4.92326732673267	133	69	98.8	0	5	403	416	548	XP_003284160.1 uncharacterized protein DICPUDRAFT_27222 [Dictyostelium purpureum]	diamond	1989	130	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Dictyosteliaceae	Dictyostelium	Dictyostelium purpureum
31977525	31977525	PRJNA635874_P_NODE_60618_length_246_cov_0.890173_g60471_i0	PRJNA635874	60618	246	0.890173	2.18982558	Acytostelium subglobosum LB1	1410327	Evosea	other_Eukaryota	89	2.06e-18	NR	XP_012754660.1	1410327	g60471	i0	58	0.841463414634146	69	29	84.1	0	2	208	250	318	XP_012754660.1 hypothetical protein SAMD00019534_057150 [Acytostelium subglobosum LB1]	diamond	207	89	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Acytostelium	Acytostelium subglobosum

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