metadata: contig_metadata: 7 rows where bioproject = "PRJNA1074407", tax_clade = "Opisthokonta" and tax

7 rows where bioproject = "PRJNA1074407", tax_clade = "Opisthokonta" and tax_phylum = "Platyhelminthes"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
16765891	16765891	PRJNA1074407_P_NODE_148134_length_230_cov_3.165605_g144296_i0	PRJNA1074407	148134	230	3.165605	7.2808915	Fasciola gigantica	46835	Platyhelminthes	Platyhelminthes	137	8.36e-37	NR	TPP61778.1	46835	g144296	i0	89.5	2.94782608695652	76	8	99.1	0	229	2	123	198	TPP61778.1 Adenosylhomocysteinase B [Fasciola gigantica]	diamond	678	137	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciola	Fasciola gigantica
25242768	25242768	PRJNA1074407_P_NODE_84780_length_410_cov_1.323442_g80944_i0	PRJNA1074407	84780	410	1.323442	5.4261122	Metazoa	33208	Platyhelminthes	Platyhelminthes	161	6.04e-43	NR	XP_024347583.1	6210	g80944	i0	75.8	231.687804878049	95	23	69.5	0	287	3	1003	1097	XP_024347583.1 Tubulin alpha-1C chain [Echinococcus granulosus]	diamond	94992	162	0.993827160493827	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus granulosus
26742017	26742017	PRJNA1074407_P_NODE_80921_length_428_cov_3.935211_g77085_i0	PRJNA1074407	80921	428	3.935211	16.84270308	Metazoa	33208	Platyhelminthes	Platyhelminthes	184	2.81e-53	NR	CAH8558955.1	39320	g77085	i0	58.2	13.2476635514019	146	55	99.5	3	1	426	286	429	CAH8558955.1 unnamed protein product [Heterobilharzia americana]	diamond	5670	184	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Heterobilharzia	Heterobilharzia americana
29877991	29877991	PRJNA1074407_P_NODE_143311_length_242_cov_1.349112_g139473_i0	PRJNA1074407	143311	242	1.349112	3.26485104	Clonorchis sinensis	79923	Platyhelminthes	Platyhelminthes	84.7	5.24e-17	NR	KAG5450172.1	79923	g139473	i0	88.1	3.42148760330579	42	5	52.1	0	116	241	88	129	KAG5450172.1 Mannose-1-phosphate guanyltransferase beta [Clonorchis sinensis]	diamond	828	84.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Clonorchis	Clonorchis sinensis
30027450	30027450	PRJNA1074407_P_NODE_112251_length_309_cov_0.966102_g108413_i0	PRJNA1074407	112251	309	0.966102	2.98525518	Metazoa	33208	Platyhelminthes	Platyhelminthes	74.3	6.71e-13	NR	ADE34162.1	79327	g108413	i0	45.7	5.58252427184466	81	41	78.6	2	308	66	1481	1558	ADE34162.1 chromodomain helicase DNA-binding protein 4 [Schmidtea mediterranea]	diamond	1725	74.3	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
31932239	31932239	PRJNA1074407_P_NODE_121397_length_284_cov_1.028436_g117559_i0	PRJNA1074407	121397	284	1.028436	2.92075824	Echinococcus granulosus	6210	Platyhelminthes	Platyhelminthes	45.1	0.00852	NR	KAH9282946.1	6210	g117559	i0	33	0.929577464788732	88	52	93	3	1	264	11	91	KAH9282946.1 RWD domain-containing protein 2B [Echinococcus granulosus]	diamond	264	45.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus granulosus
32659367	32659367	PRJNA1074407_P_NODE_105880_length_329_cov_0.878906_g102042_i0	PRJNA1074407	105880	329	0.878906	2.89160074	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	48.9	7.3e-4	NR	PAA46628.1	282301	g102042	i0	52.6	0.693009118541033	38	16	34.7	1	329	216	1968	2003	PAA46628.1 hypothetical protein BOX15_Mlig000467g3 [Macrostomum lignano]	diamond	228	48.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano

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