metadata: contig_metadata: 17 rows where bioproject = "PRJNA896758" and tax

17 rows where bioproject = "PRJNA896758" 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
872937	872937	PRJNA896758_P_NODE_6961_length_429_cov_2.474719_g6571_i0	PRJNA896758	6961	429	2.474719	10.61654451	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	490	7.399999999999999e-134	NTclustered	gi\|1369885\|gb\|L78441.1\|SCM14332R	6183	g6571	i0	87.281	1.68997668997669	456	24	99	13	3	429	1005	555	Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds	blastn	725	490	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
2148268	2148268	PRJNA896758_P_NODE_7462_length_415_cov_1.625731_g7072_i0	PRJNA896758	7462	415	1.625731	6.74678365	Metazoa	33208	Platyhelminthes	Platyhelminthes	168	6.57e-47	NR	VDD74032.1	53468	g7072	i0	63.5	3.96867469879518	137	45	99	1	415	5	367	498	VDD74032.1 unnamed protein product [Mesocestoides corti]	diamond	1647	168	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Mesocestoididae	Mesocestoides	Mesocestoides corti
8525610	8525610	PRJNA896758_P_NODE_19447_length_264_cov_1.130890_g19057_i0	PRJNA896758	19447	264	1.13089	2.9855496	Dicrocoelium dendriticum	57078	Platyhelminthes	Platyhelminthes	80.5	1.11e-10	NTclustered	gi\|687324330\|emb\|LK450395.1\|	57078	g19057	i0	85.526	0.287878787878788	76	11	29	0	171	246	988	913	Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0055049	blastn	76	80.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Dicrocoeliidae	Dicrocoelium	Dicrocoelium dendriticum
11076441	11076441	PRJNA896758_P_NODE_5609_length_480_cov_2.061425_g5220_i0	PRJNA896758	5609	480	2.061425	9.89484	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	326	2.49e-84	NTclustered	gi\|226473513\|emb\|FN315710.1\|	6182	g5220	i0	81.865	60.45	386	70	80	0	17	402	446	61	Schistosoma japonicum isolate Anhui full length mRNA clone SJFCA3771.015\|FSA001-P00005-L14, complete sequence	blastn	29016	326	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
12351747	12351747	PRJNA896758_P_NODE_13470_length_313_cov_2.225000_g13080_i0	PRJNA896758	13470	313	2.225	6.96425	Echinococcus granulosus	6210	Platyhelminthes	Platyhelminthes	52.8	0.029	NTclustered	gi\|1373862076\|ref\|XM_024497415.1\|	6210	g13080	i0	100	0.0894568690095847	28	0	9	0	155	182	2526	2553	Echinococcus granulosus Dual specificity protein kinase CLK2 (EGR_08166), partial mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus granulosus
13626652	13626652	PRJNA896758_P_NODE_3271_length_638_cov_2.233628_g2893_i0	PRJNA896758	3271	638	2.233628	14.25054664	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	739	0	NTclustered	gi\|1369885\|gb\|L78441.1\|SCM14332R	6183	g2893	i0	91.45	54.5391849529781	538	46	84	0	1	538	538	1	Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds	blastn	34796	739	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
19999443	19999443	PRJNA896758_P_NODE_23916_length_246_cov_0.890173_g23526_i0	PRJNA896758	23916	246	0.890173	2.18982558	Metazoa	33208	Platyhelminthes	Platyhelminthes	157	3.22e-44	NR	VDM19838.1	6205	g23526	i0	89	134.987804878049	82	9	100	0	246	1	275	356	VDM19838.1 unnamed protein product, partial [Hydatigera taeniaeformis]	diamond	33207	157	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Hydatigera	Hydatigera taeniaeformis
26683446	26683446	PRJNA896758_P_NODE_2601_length_716_cov_2.475894_g2238_i0	PRJNA896758	2601	716	2.475894	17.72740104	Metazoa	33208	Platyhelminthes	Platyhelminthes	52.4	7.47e-4	NR	KAH8857708.1	6182	g2238	i0	25.9	6.41061452513966	170	109	70	5	673	173	90	245	KAH8857708.1 Phosphatidate cytidylyltransferase, photoreceptor-specific [Schistosoma japonicum]	diamond	4590	52.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
27308763	27308763	PRJNA896758_P_NODE_25863_length_242_cov_0.911243_g25473_i0	PRJNA896758	25863	242	0.911243	2.20520806	Schistosoma turkestanicum	1163369	Platyhelminthes	Platyhelminthes	47.8	1.64e-4	NR	CAH8445771.1	1163369	g25473	i0	43.5	0.768595041322314	62	29	70.7	3	13	183	66	126	CAH8445771.1 unnamed protein product [Schistosoma turkestanicum]	diamond	186	47.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma turkestanicum
27403478	27403478	PRJNA896758_P_NODE_25443_length_243_cov_0.905882_g25053_i0	PRJNA896758	25443	243	0.905882	2.20129326	Trichobilharzia szidati	157070	Platyhelminthes	Platyhelminthes	70.5	6.5e-12	NR	CAH8856662.1	157070	g25053	i0	40.5	0.91358024691358	74	44	91.4	0	234	13	338	411	CAH8856662.1 unnamed protein product [Trichobilharzia szidati]	diamond	222	70.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Trichobilharzia	Trichobilharzia szidati
27466640	27466640	PRJNA896758_P_NODE_12783_length_321_cov_8.568548_g12393_i0	PRJNA896758	12783	321	8.568548	27.50503908	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	93.6	9.27e-23	NR	PAA52392.1	282301	g12393	i0	84	2.91588785046729	50	8	46.7	0	286	137	1	50	PAA52392.1 hypothetical protein BOX15_Mlig007628g1 [Macrostomum lignano]	diamond	936	93.6	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
30372046	30372046	PRJNA896758_P_NODE_16992_length_280_cov_1.966184_g16602_i0	PRJNA896758	16992	280	1.966184	5.5053152	Opisthorchis felineus	147828	Platyhelminthes	Platyhelminthes	46.2	0.00343	NR	TGZ71642.1	147828	g16602	i0	71.9	0.342857142857143	32	9	34.3	0	200	105	258	289	TGZ71642.1 hypothetical protein CRM22_002525 [Opisthorchis felineus]	diamond	96	46.2	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis felineus
30687485	30687485	PRJNA896758_P_NODE_12953_length_319_cov_3.386179_g12563_i0	PRJNA896758	12953	319	3.386179	10.80191101	Echinococcus multilocularis	6211	Platyhelminthes	Platyhelminthes	61.2	2.76e-8	NR	CDI98749.1	6211	g12563	i0	33.3	1.01567398119122	108	57	91.2	2	293	3	333	436	CDI98749.1 granulins [Echinococcus multilocularis]	diamond	324	61.2	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus multilocularis
30884888	30884888	PRJNA896758_P_NODE_24114_length_246_cov_0.890173_g23724_i0	PRJNA896758	24114	246	0.890173	2.18982558	Plagiorchiida	27871	Platyhelminthes	Platyhelminthes	87.8	7.06e-19	NR	THD23178.1	6192	g23724	i0	50	5.03658536585366	78	38	95.1	1	237	4	40	116	THD23178.1 Biotin-protein ligase [Fasciola hepatica]	diamond	1239	87.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciola	Fasciola hepatica
30972086	30972086	PRJNA896758_P_NODE_19014_length_267_cov_1.103093_g18624_i0	PRJNA896758	19014	267	1.103093	2.94525831	Fasciola gigantica	46835	Platyhelminthes	Platyhelminthes	170	9.189999999999999e-47	NR	TPP65108.1	46835	g18624	i0	93.2	0.98876404494382	88	6	98.9	0	2	265	1083	1170	TPP65108.1 Splicing factor 3B subunit [Fasciola gigantica]	diamond	264	170	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciola	Fasciola gigantica
31256344	31256344	PRJNA896758_P_NODE_13355_length_315_cov_1.103306_g12965_i0	PRJNA896758	13355	315	1.103306	3.4754139	Fasciolopsis buskii	27845	Platyhelminthes	Platyhelminthes	72.4	3.49e-12	NR	KAA0197196.1	27845	g12965	i0	37.4	0.942857142857143	99	55	93.3	3	315	22	81	173	KAA0197196.1 Jagged, partial [Fasciolopsis buskii]	diamond	297	72.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciolopsis	Fasciolopsis buskii
31319582	31319582	PRJNA896758_P_NODE_17155_length_279_cov_1.509709_g16765_i0	PRJNA896758	17155	279	1.509709	4.21208811	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	94.7	2.91e-20	NR	PAA92817.1	282301	g16765	i0	55.4	5.45161290322581	74	31	77.4	1	218	3	4	77	PAA92817.1 hypothetical protein BOX15_Mlig013387g3 [Macrostomum lignano]	diamond	1521	94.7	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);;