metadata: contig_metadata: 9 rows where bioproject = "PRJNA1082072", tax_kingdom = "Metazoa" and tax

9 rows where bioproject = "PRJNA1082072", tax_kingdom = "Metazoa" 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
27162079	27162079	PRJNA1082072_P_NODE_2562_length_246_cov_0.890173_g2555_i0	PRJNA1082072	2562	246	0.890173	2.18982558	Fasciola hepatica	6192	Platyhelminthes	Platyhelminthes	87	9.75e-18	NR	THD19653.1	6192	g2555	i0	50.6	1.92682926829268	79	39	96.3	0	244	8	83	161	THD19653.1 Major vault protein isoform A [Fasciola hepatica]	diamond	474	87	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciola	Fasciola hepatica
27352205	27352205	PRJNA1082072_P_NODE_2343_length_248_cov_0.880000_g2336_i0	PRJNA1082072	2343	248	0.88	2.1824	Calicophoron daubneyi	300641	Platyhelminthes	Platyhelminthes	133	1.93e-36	NR	CAL5131531.1	300641	g2336	i0	78	11.9032258064516	82	18	99.2	0	246	1	104	185	CAL5131531.1 unnamed protein product [Calicophoron daubneyi]	diamond	2952	133	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Paramphistomidae	Calicophoron	Calicophoron daubneyi
28141593	28141593	PRJNA1082072_P_NODE_465_length_452_cov_1.408971_g458_i0	PRJNA1082072	465	452	1.408971	6.36854892	Fasciolopsis buskii	27845	Platyhelminthes	Platyhelminthes	54.7	2.14e-5	NR	KAA0197080.1	27845	g458	i0	45.3	0.942477876106195	53	29	35.2	0	452	294	4	56	KAA0197080.1 hypothetical protein FBUS_05350 [Fasciolopsis buskii]	diamond	426	54.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciolopsis	Fasciolopsis buskii
28551968	28551968	PRJNA1082072_P_NODE_2687_length_244_cov_0.900585_g2680_i0	PRJNA1082072	2687	244	0.900585	2.1974274	Trichobilharzia szidati	157070	Platyhelminthes	Platyhelminthes	74.7	2.08e-13	NR	CAH8869047.1	157070	g2680	i0	50	0.909836065573771	74	35	91	1	243	22	196	267	CAH8869047.1 unnamed protein product [Trichobilharzia szidati]	diamond	222	74.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Trichobilharzia	Trichobilharzia szidati
29909692	29909692	PRJNA1082072_P_NODE_1991_length_255_cov_1.269231_g1984_i0	PRJNA1082072	1991	255	1.269231	3.23653905	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	48.9	2.79e-4	NR	PAA86220.1	282301	g1984	i0	29.6	3.57647058823529	81	56	94.1	1	242	3	131	211	PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano]	diamond	912	48.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
30730989	30730989	PRJNA1082072_P_NODE_1634_length_278_cov_1.502439_g1627_i0	PRJNA1082072	1634	278	1.502439	4.17678042	Cichlidogyrus casuarinus	1844966	Platyhelminthes	Platyhelminthes	87	1.27e-17	NR	KAL3318623.1	1844966	g1627	i0	48.4	9.96043165467626	95	45	98.2	2	273	1	63	157	KAL3318623.1 hypothetical protein Ciccas_002713 [Cichlidogyrus casuarinus]	diamond	2769	87	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Dactylogyridea	Ancyrocephalidae	Cichlidogyrus	Cichlidogyrus casuarinus
30762684	30762684	PRJNA1082072_P_NODE_414_length_478_cov_1.575309_g407_i0	PRJNA1082072	414	478	1.575309	7.52997702	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	56.2	7.52e-6	NR	PAA86220.1	282301	g407	i0	28.9	1.99581589958159	159	105	97.3	5	476	12	257	411	PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano]	diamond	954	56.2	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
31268223	31268223	PRJNA1082072_P_NODE_335_length_523_cov_1.246667_g328_i0	PRJNA1082072	335	523	1.246667	6.52006841	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	61.6	1.53e-7	NR	PAA93605.1	282301	g328	i0	28	2.08795411089866	182	106	98.1	5	11	523	255	422	PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano]	diamond	1092	61.6	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
32556976	32556976	PRJNA1082072_P_NODE_819_length_366_cov_1.576792_g812_i0	PRJNA1082072	819	366	1.576792	5.77105872	Opisthokonta	33154	Platyhelminthes	Platyhelminthes	43.1	0.0175	NR	XP_024354019.1	6210	g812	i0	39.6	1.45901639344262	53	31	43.4	1	177	19	40	91	XP_024354019.1 Dynein light chain 1, cytoplasmic [Echinococcus granulosus]	diamond	534	43.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus granulosus

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