metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJNA690234" and tax

20 rows where analysis = "blastn", bioproject = "PRJNA690234" 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
670524	670524	PRJNA690234_P_NODE_8981_length_427_cov_1.672316_g8615_i0	PRJNA690234	8981	427	1.672316	7.14078932	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	442	2.089999999999999e-119	NTclustered	gi\|684391908\|ref\|XM_009171858.1\|	6198	g8615	i0	85.579	1.25058548009368	423	59	99	2	1	422	861	440	Opisthorchis viverrini hypothetical protein partial mRNA	blastn	534	442	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
3220735	3220735	PRJNA690234_P_NODE_10323_length_397_cov_1.382716_g9957_i0	PRJNA690234	10323	397	1.382716	5.48938252	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	422	2.51e-113	NTclustered	gi\|684370736\|ref\|XM_009165286.1\|	6198	g9957	i0	89.286	0.846347607052897	336	36	85	0	1	336	336	1	Opisthorchis viverrini hypothetical protein partial mRNA	blastn	336	422	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
7048681	7048681	PRJNA690234_P_NODE_19846_length_285_cov_1.160377_g19479_i0	PRJNA690234	19846	285	1.160377	3.30707445	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	104	7.17e-18	NTclustered	gi\|1369885\|gb\|L78441.1\|SCM14332R	6183	g19479	i0	78.652	0.624561403508772	178	22	59	10	8	175	865	694	Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds	blastn	178	104	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
7048847	7048847	PRJNA690234_P_NODE_27326_length_249_cov_1.329545_g26959_i0	PRJNA690234	27326	249	1.329545	3.31056705	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	235	2.08e-57	NTclustered	gi\|684392139\|ref\|XM_009171929.1\|	6198	g26959	i0	87.379	0.827309236947791	206	25	82	1	22	226	1234	1029	Opisthorchis viverrini hypothetical protein partial mRNA	blastn	206	235	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
8323127	8323127	PRJNA690234_P_NODE_16467_length_313_cov_1.950000_g16100_i0	PRJNA690234	16467	313	1.95	6.1035	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	174	5.99e-39	NTclustered	gi\|684365574\|ref\|XM_009163662.1\|	6198	g16100	i0	80.851	0.750798722044728	235	34	72	4	87	310	790	1024	Opisthorchis viverrini hypothetical protein partial mRNA	blastn	235	174	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
9598495	9598495	PRJNA690234_P_NODE_14708_length_331_cov_1.596899_g14341_i0	PRJNA690234	14708	331	1.596899	5.28573569	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	309	1.68e-79	NTclustered	gi\|684398119\|ref\|XM_009173806.1\|	6198	g14341	i0	84.918	4.55287009063444	305	46	92	0	25	329	863	559	Opisthorchis viverrini hypothetical protein partial mRNA	blastn	1507	309	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
10874251	10874251	PRJNA690234_P_NODE_25709_length_252_cov_0.871508_g25342_i0	PRJNA690234	25709	252	0.871508	2.19620016	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	104	6.22e-18	NTclustered	gi\|684393807\|ref\|XM_009172444.1\|	6198	g25342	i0	90.909	0.305555555555556	77	7	31	0	32	108	1660	1736	Opisthorchis viverrini hypothetical protein partial mRNA	blastn	77	104	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
10874446	10874446	PRJNA690234_P_NODE_4549_length_613_cov_2.453704_g4190_i0	PRJNA690234	4549	613	2.453704	15.04120552	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	394	8.76e-105	NTclustered	gi\|684406876\|ref\|XM_009176659.1\|	6198	g4190	i0	82.658	7.02610114192496	444	77	72	0	170	613	746	303	Opisthorchis viverrini hypothetical protein partial mRNA	blastn	4307	394	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
10874537	10874537	PRJNA690234_P_NODE_8789_length_432_cov_2.075209_g8423_i0	PRJNA690234	8789	432	2.075209	8.96490288	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	335	3.7e-87	NTclustered	gi\|684407923\|ref\|XM_009176992.1\|	6198	g8423	i0	83.198	13	369	59	85	3	55	420	224	592	Opisthorchis viverrini hypothetical protein partial mRNA	blastn	5616	335	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
12149752	12149752	PRJNA690234_P_NODE_6570_length_504_cov_2.313225_g6205_i0	PRJNA690234	6570	504	2.313225	11.658654	Fasciola hepatica	6192	Platyhelminthes	Platyhelminthes	276	2.69e-69	NTclustered	gi\|262213551\|gb\|GU059940.1\|	6192	g6205	i0	82.298	3.36706349206349	322	54	64	3	2	322	491	172	Fasciola hepatica myosin regulatory light chain mRNA, complete cds	blastn	1697	276	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciola	Fasciola hepatica
13423897	13423897	PRJNA690234_P_NODE_18451_length_295_cov_1.405405_g18084_i0	PRJNA690234	18451	295	1.405405	4.14594475	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	204	7.139999999999998e-48	NTclustered	gi\|684371787\|ref\|XM_009165626.1\|	6198	g18084	i0	79.381	0.986440677966102	291	58	98	2	6	295	890	601	Opisthorchis viverrini hypothetical protein partial mRNA	blastn	291	204	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
15973171	15973171	PRJNA690234_P_NODE_5133_length_576_cov_1.439364_g4771_i0	PRJNA690234	5133	576	1.439364	8.29073664	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	457	1.03e-123	NTclustered	gi\|684403082\|ref\|XM_009175419.1\|	6198	g4771	i0	81.636	13.2916666666667	550	101	95	0	23	572	114	663	Opisthorchis viverrini hypothetical protein partial mRNA	blastn	7656	457	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
15973251	15973251	PRJNA690234_P_NODE_9253_length_420_cov_2.481268_g8887_i0	PRJNA690234	9253	420	2.481268	10.4213256	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	283	1.32e-71	NTclustered	gi\|684398518\|ref\|XM_009173939.1\|	6198	g8887	i0	79.744	0.928571428571429	390	79	93	0	31	420	1	390	Opisthorchis viverrini hypothetical protein partial mRNA	blastn	390	283	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
17248129	17248129	PRJNA690234_P_NODE_25734_length_252_cov_0.871508_g25367_i0	PRJNA690234	25734	252	0.871508	2.19620016	Clonorchis sinensis	79923	Platyhelminthes	Platyhelminthes	326	1.22e-84	NTclustered	gi\|209402524\|gb\|EU780135.1\|	79923	g25367	i0	90.947	103.06746031746	243	21	96	1	1	243	1016	775	Clonorchis sinensis clone ACP-2D-70	blastn	25973	326	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Clonorchis	Clonorchis sinensis
17248385	17248385	PRJNA690234_P_NODE_8454_length_441_cov_1.380435_g8088_i0	PRJNA690234	8454	441	1.380435	6.08771835	Schistosoma haematobium	6185	Platyhelminthes	Platyhelminthes	259	2.34e-64	NTclustered	gi\|2318774665\|ref\|XM_051218133.1\|	6185	g8088	i0	77.83	1.92290249433107	424	90	96	4	2	423	930	1351	Schistosoma haematobium Calponin-3, variant 2 (CNN3_3), mRNA	blastn	848	259	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma haematobium
18522451	18522451	PRJNA690234_P_NODE_5895_length_533_cov_3.095652_g5532_i0	PRJNA690234	5895	533	3.095652	16.49982516	Clonorchis sinensis	79923	Platyhelminthes	Platyhelminthes	368	4.57e-97	NTclustered	gi\|1837630629\|gb\|MT292217.1\|	79923	g5532	i0	79.444	86.4127579737336	540	96	100	11	1	533	7913	7382	Clonorchis sinensis isolate Cs138 mitochondrion, partial genome	blastn	46058	368	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Clonorchis	Clonorchis sinensis
19797278	19797278	PRJNA690234_P_NODE_30856_length_243_cov_1.558824_g30489_i0	PRJNA690234	30856	243	1.558824	3.78794232	Echinostoma miyagawai	1579201	Platyhelminthes	Platyhelminthes	209	1.23e-49	NTclustered	gi\|1727111759\|gb\|MN116740.1\|	1579201	g30489	i0	83.333	14.9794238683128	228	36	93	2	10	236	5268	5494	Echinostoma miyagawai isolate Hunan mitochondrion, complete genome	blastn	3640	209	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Echinostomatidae	Echinostoma	Echinostoma miyagawai
22347315	22347315	PRJNA690234_P_NODE_13798_length_341_cov_2.037313_g13431_i0	PRJNA690234	13798	341	2.037313	6.94723733	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	285	2.92e-72	NTclustered	gi\|684370736\|ref\|XM_009165286.1\|	6198	g13431	i0	83.66	0.897360703812317	306	46	90	4	1	306	559	860	Opisthorchis viverrini hypothetical protein partial mRNA	blastn	306	285	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
24896525	24896525	PRJNA690234_P_NODE_28240_length_248_cov_0.891429_g27873_i0	PRJNA690234	28240	248	0.891429	2.21074392	Cryptocotyle lingua	66766	Platyhelminthes	Platyhelminthes	309	1.21e-79	NTclustered	gi\|1964739281\|gb\|MW361175.1\|	66766	g27873	i0	89.958	11.2298387096774	239	24	96	0	9	247	132	370	Cryptocotyle lingua Ras-related protein rab7 (RAB7A) mRNA, complete cds	blastn	2785	309	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Heterophyidae	Cryptocotyle	Cryptocotyle lingua
25405308	25405308	PRJNA690234_P_NODE_1820_length_979_cov_120.354305_g1563_i0	PRJNA690234	1820	979	120.354305	1178.26864595	Opisthorchiidae	6196	Platyhelminthes	Platyhelminthes	604	6.069999999999998e-168	NTclustered	gi\|937546747\|ref\|NC_028008.1\|	674132	g1563	i0	78.71	59.0480081716037	977	157	97	45	18	968	8565	9516	Metorchis orientalis mitochondrion, complete genome	blastn	57808	604	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Metorchis	Metorchis orientalis

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