metadata: contig_metadata: 14 rows where bioproject = "PRJNA662254" and tax

14 rows where bioproject = "PRJNA662254" 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
7006902	7006902	PRJNA662254_P_NODE_36506_length_277_cov_1.509804_g35855_i0	PRJNA662254	36506	277	1.509804	4.18215708	Cichlidogyrus casuarinus	1844966	Platyhelminthes	Platyhelminthes	132	2.84e-36	NR	KAL3320624.1	1844966	g35855	i0	77.8	0.974729241877256	90	20	97.5	0	277	8	89	178	KAL3320624.1 60S ribosomal protein L19 [Cichlidogyrus casuarinus]	diamond	270	132	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Dactylogyridea	Ancyrocephalidae	Cichlidogyrus	Cichlidogyrus casuarinus
8814908	8814908	PRJNA662254_P_NODE_27227_length_317_cov_1.577869_g26576_i0	PRJNA662254	27227	317	1.577869	5.00184473	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	143	5.62e-42	NR	PAA77179.1	282301	g26576	i0	66.3	15.5488958990536	101	33	95.6	1	308	6	10	109	PAA77179.1 hypothetical protein BOX15_Mlig006898g2, partial [Macrostomum lignano]	diamond	4929	144	0.993055555555556	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
9556750	9556750	PRJNA662254_P_NODE_26248_length_323_cov_0.924000_g25597_i0	PRJNA662254	26248	323	0.924	2.98452	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	62.1	5.04e-5	NTclustered	gi\|684381132\|ref\|XM_009168573.1\|	6198	g25597	i0	100	0.102167182662539	33	0	10	0	161	193	2769	2801	Opisthorchis viverrini hypothetical protein partial mRNA	blastn	33	62.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
13382340	13382340	PRJNA662254_P_NODE_35811_length_280_cov_0.908213_g35160_i0	PRJNA662254	35811	280	0.908213	2.5429964	Opisthokonta	33154	Platyhelminthes	Platyhelminthes	134	2.44e-35	NR	CAL5137843.1	300641	g35160	i0	71	8.97857142857143	93	27	99.6	0	280	2	10	102	CAL5137843.1 unnamed protein product [Calicophoron daubneyi]	diamond	2514	135	0.992592592592593	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Paramphistomidae	Calicophoron	Calicophoron daubneyi
27018134	27018134	PRJNA662254_P_NODE_52062_length_248_cov_0.880000_g51411_i0	PRJNA662254	52062	248	0.88	2.1824	Trichobilharzia szidati	157070	Platyhelminthes	Platyhelminthes	57.4	2.52e-7	NR	CAH8831712.1	157070	g51411	i0	40.9	4.125	66	37	79.8	2	198	1	148	211	CAH8831712.1 unnamed protein product [Trichobilharzia szidati]	diamond	1023	57.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Trichobilharzia	Trichobilharzia szidati
27523775	27523775	PRJNA662254_P_NODE_37243_length_275_cov_1.138614_g36592_i0	PRJNA662254	37243	275	1.138614	3.1311885	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	53.1	7.81e-6	NR	AAW26162.1	6182	g36592	i0	51.2	1.40727272727273	43	21	46.9	0	145	273	100	142	AAW26162.1 SJCHGC06439 protein [Schistosoma japonicum]	diamond	387	53.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
27536037	27536037	PRJNA662254_P_NODE_19583_length_370_cov_1.723906_g18932_i0	PRJNA662254	19583	370	1.723906	6.3784522	Hymenolepididae	6214	Platyhelminthes	Platyhelminthes	95.1	8.28e-22	NR	CDS26983.2	85433	g18932	i0	46.2	5.82162162162162	117	54	90	2	333	1	2	115	CDS26983.2 RNA and export factor binding protein 2 [Hymenolepis microstoma]	diamond	2154	95.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Hymenolepididae	Hymenolepis	Hymenolepis microstoma
29493548	29493548	PRJNA662254_P_NODE_15430_length_418_cov_1.086957_g14779_i0	PRJNA662254	15430	418	1.086957	4.54348026	Schistosoma	6181	Platyhelminthes	Platyhelminthes	119	9.52e-30	NR	CAH8671007.1	6185	g14779	i0	45	2.7488038277512	129	69	92.6	2	30	416	96	222	CAH8671007.1 unnamed protein product [Schistosoma haematobium]	diamond	1149	120	0.991666666666667	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma haematobium
30239408	30239408	PRJNA662254_P_NODE_48972_length_249_cov_0.875000_g48321_i0	PRJNA662254	48972	249	0.875	2.17875	Cichlidogyrus casuarinus	1844966	Platyhelminthes	Platyhelminthes	57	1.5e-7	NR	KAL3319087.1	1844966	g48321	i0	35.6	0.879518072289157	73	47	88	0	249	31	88	160	KAL3319087.1 hypothetical protein Ciccas_002236 [Cichlidogyrus casuarinus]	diamond	219	57	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Dactylogyridea	Ancyrocephalidae	Cichlidogyrus	Cichlidogyrus casuarinus
30586803	30586803	PRJNA662254_P_NODE_59033_length_244_cov_0.900585_g58382_i0	PRJNA662254	59033	244	0.900585	2.1974274	Cichlidogyrus casuarinus	1844966	Platyhelminthes	Platyhelminthes	81.3	1.05e-15	NR	KAL3314572.1	1844966	g58382	i0	44.4	0.995901639344262	81	44	99.6	1	243	1	846	925	KAL3314572.1 hypothetical protein Ciccas_006805, partial [Cichlidogyrus casuarinus]	diamond	243	81.3	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Dactylogyridea	Ancyrocephalidae	Cichlidogyrus	Cichlidogyrus casuarinus
30883440	30883440	PRJNA662254_P_NODE_65834_length_241_cov_0.916667_g65183_i0	PRJNA662254	65834	241	0.916667	2.20916747	Metazoa	33208	Platyhelminthes	Platyhelminthes	63.2	2.33e-9	NR	VZI22549.1	99802	g65183	i0	60.4	23.5269709543568	48	19	59.8	0	2	145	91	138	VZI22549.1 unnamed protein product [Spirometra erinaceieuropaei]	diamond	5670	63.2	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
31503681	31503681	PRJNA662254_P_NODE_24276_length_335_cov_0.881679_g23625_i0	PRJNA662254	24276	335	0.881679	2.95362465	Fasciolopsis buskii	27845	Platyhelminthes	Platyhelminthes	62.4	1.4e-8	NR	KAA0195121.1	27845	g23625	i0	34.9	3.38507462686567	126	53	93.1	7	3	314	484	602	KAA0195121.1 Integrin beta [Fasciolopsis buskii]	diamond	1134	62.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciolopsis	Fasciolopsis buskii
31515978	31515978	PRJNA662254_P_NODE_32176_length_293_cov_1.350000_g31525_i0	PRJNA662254	32176	293	1.35	3.9555	Opisthokonta	33154	Platyhelminthes	Platyhelminthes	120	2.8799999999999997e-32	NR	QGZ10483.1	6161	g31525	i0	60.2	2.87713310580205	93	37	95.2	0	5	283	5	97	QGZ10483.1 copper zinc superoxide dismutase [Dugesia japonica]	diamond	843	120	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
32180205	32180205	PRJNA662254_P_NODE_53898_length_247_cov_0.885057_g53247_i0	PRJNA662254	53898	247	0.885057	2.18609079	Metazoa	33208	Platyhelminthes	Platyhelminthes	47.4	8.88e-4	NR	VDN15166.1	60516	g53247	i0	33	4.09311740890688	91	50	97.2	3	243	4	210	300	VDN15166.1 unnamed protein product, partial [Dibothriocephalus latus]	diamond	1011	47.8	0.99163179916318	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Dibothriocephalus	Dibothriocephalus latus

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