metadata: contig_metadata: 25 rows where analysis = "blastn", bioproject = "PRJNA994052" and tax

25 rows where analysis = "blastn", bioproject = "PRJNA994052" 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
976405	976405	PRJNA994052_P_NODE_39301_length_260_cov_18.844920_g38055_i0	PRJNA994052	39301	260	18.84492	48.996792	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	54.7	0.007	NTclustered	gi\|690645407\|emb\|LN192580.1\|	99802	g38055	i0	100	0.223076923076923	29	0	11	0	185	213	1169	1197	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0165854	blastn	58	54.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
2251732	2251732	PRJNA994052_P_NODE_43702_length_251_cov_2369.786517_g42454_i0	PRJNA994052	43702	251	2369.786517	5948.16415767	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	150	7.84e-32	NTclustered	gi\|21308651\|gb\|AY068018.1\|	79327	g42454	i0	79.825	2.18326693227092	228	28	96	10	18	245	2	211	Schmidtea mediterranea clone H.58.9f(T3) unknown mRNA sequence	blastn	548	150	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
5101213	5101213	PRJNA994052_P_NODE_11744_length_324_cov_159.302789_g10526_i0	PRJNA994052	11744	324	159.302789	516.14103636	Platyhelminthes	6157	Platyhelminthes	Platyhelminthes	80.5	1.4e-10	NTclustered	gi\|117184141\|gb\|AF286950.2\|	70678	g10526	i0	74.737	22.7623456790123	190	42	57	6	1	186	4124	4311	Tetrabothrius erostris 28S ribosomal RNA gene, complete sequence	blastn	7375	80.5	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Tetrabothriidea	Tetrabothriidae	Tetrabothrius	Tetrabothrius erostris
6079914	6079914	PRJNA994052_P_NODE_67445_length_215_cov_2304.591549_g66189_i0	PRJNA994052	67445	215	2304.591549	4954.87183035	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	385	1.65e-102	NTclustered	gi\|24796514\|gb\|AY067047.1\|	79327	g66189	i0	99.524	1.96279069767442	210	1	98	0	1	210	256	465	Schmidtea mediterranea clone H.2.12a unknown mRNA sequence	blastn	422	385	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
7353939	7353939	PRJNA994052_P_NODE_19026_length_310_cov_873.025316_g17804_i0	PRJNA994052	19026	310	873.025316	2706.3784796	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	268	2.64e-67	NTclustered	gi\|62199164\|gb\|AY967534.1\|	79327	g17804	i0	98.675	0.487096774193548	151	1	48	1	1	150	462	612	Schmidtea mediterranea clone HE.4.01H mRNA sequence	blastn	151	268	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
9904573	9904573	PRJNA994052_P_NODE_34808_length_270_cov_3.223350_g33564_i0	PRJNA994052	34808	270	3.22335	8.703045	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	496	9.51e-136	NTclustered	gi\|24796399\|gb\|AY066907.1\|	79327	g33564	i0	99.63	1	270	1	100	0	1	270	434	165	Schmidtea mediterranea clone H.17.7f unknown mRNA sequence	blastn	270	496	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
9904651	9904651	PRJNA994052_P_NODE_39588_length_259_cov_103.602151_g38342_i0	PRJNA994052	39588	259	103.602151	268.32957109	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	267	7.739999999999999e-67	NTclustered	gi\|733515707\|gb\|KP003814.1\|	79327	g38342	i0	98.667	0.934362934362934	150	2	93	0	1	150	425	276	Schmidtea mediterranea Rapunzel mRNA, partial cds	blastn	242	267	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
9904784	9904784	PRJNA994052_P_NODE_51548_length_238_cov_5638.757576_g50293_i0	PRJNA994052	51548	238	5638.757576	13420.24303088	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	167	7.319999999999999e-37	NTclustered	gi\|21308651\|gb\|AY068018.1\|	79327	g50293	i0	81.14	3.0546218487395	228	25	97	10	5	232	2	211	Schmidtea mediterranea clone H.58.9f(T3) unknown mRNA sequence	blastn	727	167	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
10201780	10201780	PRJNA994052_P_NODE_44248_length_250_cov_611.129944_g43000_i0	PRJNA994052	44248	250	611.129944	1527.82486	Schmidtea	55270	Platyhelminthes	Platyhelminthes	420	5.389999999999998e-113	NTclustered	gi\|4102590\|gb\|AF013152.1\|AF013152	50054	g43000	i0	97.934	95.16	242	5	97	0	1	242	363	122	Schmidtea polychroa 18S type I ribosomal RNA gene, complete sequence	blastn	23790	424	0.990566037735849	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea polychroa
11179996	11179996	PRJNA994052_P_NODE_61509_length_223_cov_1710.240000_g60253_i0	PRJNA994052	61509	223	1710.24	3813.8352	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	399	6.139999999999999e-107	NTclustered	gi\|21308890\|gb\|AY068257.1\|	79327	g60253	i0	99.543	0.982062780269058	219	1	98	0	1	219	228	446	Schmidtea mediterranea clone H.8.10c unknown mRNA sequence	blastn	219	399	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
12455572	12455572	PRJNA994052_P_NODE_37070_length_264_cov_1147.979058_g35824_i0	PRJNA994052	37070	264	1147.979058	3030.66471312	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	220	6.25e-53	NTclustered	gi\|21308729\|gb\|AY068096.1\|	79327	g35824	i0	88.398	0.685606060606061	181	9	64	1	76	244	423	603	Schmidtea mediterranea clone H.101.9c unknown mRNA sequence	blastn	181	220	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
12455850	12455850	PRJNA994052_P_NODE_6190_length_388_cov_3856.339683_g5191_i0	PRJNA994052	6190	388	3856.339683	14962.59797004	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	717	0	NTclustered	gi\|753176482\|gb\|KM821047.2\|	79327	g5191	i0	100	23.2809278350515	388	0	100	0	1	388	13383	12996	Schmidtea mediterranea mitochondrion, complete genome	blastn	9033	717	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
12455861	12455861	PRJNA994052_P_NODE_63490_length_221_cov_15.614865_g62234_i0	PRJNA994052	63490	221	15.614865	34.50885165	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	250	6.47e-62	NTclustered	gi\|21307902\|gb\|AY067269.1\|	79327	g62234	i0	89.231	0.882352941176471	195	14	86	7	33	221	705	512	Schmidtea mediterranea clone HB.10.10a unknown mRNA sequence	blastn	195	250	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
12456031	12456031	PRJNA994052_P_NODE_79730_length_201_cov_12.945312_g78473_i0	PRJNA994052	79730	201	12.945312	26.02007712	Schistosoma haematobium	6185	Platyhelminthes	Platyhelminthes	52.8	0.017	NTclustered	gi\|2318755108\|ref\|XM_051218379.1\|	6185	g78473	i0	100	0.139303482587065	28	0	14	0	98	125	3817	3844	Schistosoma haematobium Baculoviral IAP repeat-containing protein 6 (BIRC6_1), partial mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma haematobium
15004378	15004378	PRJNA994052_P_NODE_38492_length_261_cov_2906.186170_g37246_i0	PRJNA994052	38492	261	2906.18617	7585.1459037	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	427	3.38e-115	NTclustered	gi\|24796159\|gb\|AY066618.1\|	79327	g37246	i0	97.6	0.957854406130268	250	5	96	1	10	259	663	415	Schmidtea mediterranea clone H.14.10e unknown mRNA sequence	blastn	250	427	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
16279009	16279009	PRJNA994052_P_NODE_18073_length_311_cov_2211.462185_g16852_i0	PRJNA994052	18073	311	2211.462185	6877.64739535	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	274	5.699999999999999e-69	NTclustered	gi\|21308072\|gb\|AY067439.1\|	79327	g16852	i0	99.338	6.5016077170418	151	1	95	0	161	311	290	140	Schmidtea mediterranea clone H.100.10g unknown mRNA sequence	blastn	2022	274	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
16279678	16279678	PRJNA994052_P_NODE_79933_length_200_cov_2158.992126_g78676_i0	PRJNA994052	79933	200	2158.992126	4317.984252	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	255	1.23e-63	NTclustered	gi\|21308428\|gb\|AY067795.1\|	79327	g78676	i0	100	0.69	138	0	69	0	1	138	467	604	Schmidtea mediterranea clone H.101.8d unknown mRNA sequence	blastn	138	255	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
17554383	17554383	PRJNA994052_P_NODE_45414_length_248_cov_1705.862857_g44164_i0	PRJNA994052	45414	248	1705.862857	4230.53988536	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	374	4.2099999999999995e-99	NTclustered	gi\|21308717\|gb\|AY068084.1\|	79327	g44164	i0	98.14	1.79032258064516	215	2	86	2	3	215	216	2	Schmidtea mediterranea clone HB.22.6h unknown mRNA sequence	blastn	444	374	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
18827962	18827962	PRJNA994052_P_NODE_21055_length_306_cov_1186.248927_g19828_i0	PRJNA994052	21055	306	1186.248927	3629.92171662	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	425	1.46e-114	NTclustered	gi\|21308566\|gb\|AY067933.1\|	79327	g19828	i0	90.397	0.986928104575163	302	29	99	0	5	306	124	425	Schmidtea mediterranea clone H.34.4b unknown mRNA sequence	blastn	302	425	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
18828664	18828664	PRJNA994052_P_NODE_80875_length_199_cov_1377.809524_g79618_i0	PRJNA994052	80875	199	1377.809524	2741.84095276	Dugesia japonica	6161	Platyhelminthes	Platyhelminthes	252	1.59e-62	NTclustered	gi\|393794039\|dbj\|AK388636.1\|	6161	g79618	i0	90.526	93.713567839196	190	18	95	0	8	197	366	555	Dugesia japonica cDNA, clone: Dj_aH_000_00546HH.full, full-insert sequence, expressed in adult head	blastn	18649	252	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
21378592	21378592	PRJNA994052_P_NODE_40797_length_257_cov_21.913043_g39550_i0	PRJNA994052	40797	257	21.913043	56.31652051	Macrostomum poznaniense	2614303	Platyhelminthes	Platyhelminthes	67.6	8.35e-7	NTclustered	gi\|1995044789\|gb\|MW245835.1\|	2614303	g39550	i0	95.238	0.163424124513619	42	2	16	0	213	254	5491	5450	Macrostomum poznaniense adhesion protein 1 mRNA, partial cds	blastn	42	67.6	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum poznaniense
22653374	22653374	PRJNA994052_P_NODE_27738_length_287_cov_2060.943925_g26497_i0	PRJNA994052	27738	287	2060.943925	5914.90906475	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	427	3.7699999999999997e-115	NTclustered	gi\|24796576\|gb\|AY067117.1\|	79327	g26497	i0	93.023	1.04878048780488	301	3	99	5	4	286	25	325	Schmidtea mediterranea clone H.83.3g unknown mRNA sequence	blastn	301	427	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
22653555	22653555	PRJNA994052_P_NODE_42038_length_254_cov_1549.624309_g40791_i0	PRJNA994052	42038	254	1549.624309	3936.04574486	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	411	3.3e-110	NTclustered	gi\|62199260\|gb\|AY967630.1\|	79327	g40791	i0	97.863	8.18110236220472	234	5	92	0	21	254	632	399	Schmidtea mediterranea clone NBE.5.04H mRNA sequence	blastn	2078	411	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
23928845	23928845	PRJNA994052_P_NODE_31579_length_277_cov_6444.357843_g30335_i0	PRJNA994052	31579	277	6444.357843	17850.87122511	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	167	8.719999999999998e-37	NTclustered	gi\|21308651\|gb\|AY068018.1\|	79327	g30335	i0	81.14	3.02527075812274	228	25	98	9	7	234	211	2	Schmidtea mediterranea clone H.58.9f(T3) unknown mRNA sequence	blastn	838	167	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
25202445	25202445	PRJNA994052_P_NODE_31580_length_277_cov_6412.813725_g30336_i0	PRJNA994052	31580	277	6412.813725	17763.49401825	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	161	4.06e-35	NTclustered	gi\|21308651\|gb\|AY068018.1\|	79327	g30336	i0	80.702	3.02527075812274	228	26	98	10	5	232	2	211	Schmidtea mediterranea clone H.58.9f(T3) unknown mRNA sequence	blastn	838	161	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea

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