metadata: contig_metadata: 21 rows where bioproject = "PRJNA795983" and tax

21 rows where bioproject = "PRJNA795983" 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
2055867	2055867	PRJNA795983_S_NODE_11562_length_369_cov_1.239865_g11437_i0	PRJNA795983	11562	369	1.239865	4.57510185	Dicrocoelium dendriticum	57078	Platyhelminthes	Platyhelminthes	100	6.92e-22	NR	CAH8562660.1	57078	g11437	i0	64.7	2.84552845528455	68	24	55.3	0	93	296	24	91	CAH8562660.1 unnamed protein product [Dicrocoelium dendriticum]	diamond	1050	100	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Dicrocoeliidae	Dicrocoelium	Dicrocoelium dendriticum
4608605	4608605	PRJNA795983_S_NODE_40684_length_244_cov_0.900585_g40559_i0	PRJNA795983	40684	244	0.900585	2.1974274	Metazoa	33208	Platyhelminthes	Platyhelminthes	110	2.19e-29	NR	VDM02420.1	70667	g40559	i0	70.7	8.22540983606557	75	20	92.2	1	226	2	1	73	VDM02420.1 unnamed protein product [Schistocephalus solidus]	diamond	2007	110	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Schistocephalus	Schistocephalus solidus
4608682	4608682	PRJNA795983_S_NODE_784_length_1033_cov_3.650000_g721_i0	PRJNA795983	784	1033	3.65	37.7045	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	1157	0	NTclustered	gi\|1369885\|gb\|L78441.1\|SCM14332R	6183	g721	i0	91.349	14.1926427879961	867	44	82	13	12	856	858	1	Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds	blastn	14661	1157	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
7158377	7158377	PRJNA795983_S_NODE_16606_length_326_cov_2.549407_g16481_i0	PRJNA795983	16606	326	2.549407	8.31106682	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	146	4.1199999999999997e-38	NR	PAA64048.1	282301	g16481	i0	69.4	8.87116564417178	108	29	97.5	3	320	3	137	242	PAA64048.1 hypothetical protein BOX15_Mlig024523g3 [Macrostomum lignano]	diamond	2892	146	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
7594624	7594624	PRJNA795983_S_NODE_24866_length_285_cov_2.919811_g24741_i0	PRJNA795983	24866	285	2.919811	8.32146135	Metazoa	33208	Platyhelminthes	Platyhelminthes	91.7	3.53e-22	NR	PAA52392.1	282301	g24741	i0	80	4.97894736842105	50	10	52.6	0	243	94	1	50	PAA52392.1 hypothetical protein BOX15_Mlig007628g1 [Macrostomum lignano]	diamond	1419	92	0.996739130434783	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
8869724	8869724	PRJNA795983_S_NODE_8887_length_405_cov_1.750000_g8762_i0	PRJNA795983	8887	405	1.75	7.0875	Opisthorchiidae	6196	Platyhelminthes	Platyhelminthes	248	1.4e-79	NR	GAA52499.1	79923	g8762	i0	85.9	25	135	19	100	0	405	1	194	328	GAA52499.1 isocitrate dehydrogenase [Clonorchis sinensis]	diamond	10125	248	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Clonorchis	Clonorchis sinensis
9708517	9708517	PRJNA795983_S_NODE_6988_length_443_cov_4.143243_g6863_i0	PRJNA795983	6988	443	4.143243	18.35456649	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	730	0	NTclustered	gi\|68479954\|gb\|DQ076149.1\|	6182	g6863	i0	96.804	0.988713318284424	438	13	99	1	2	439	449	13	Schistosoma japonicum clone 1XA1 unknown mRNA	blastn	438	730	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
10144981	10144981	PRJNA795983_S_NODE_15328_length_335_cov_1.564885_g15203_i0	PRJNA795983	15328	335	1.564885	5.24236475	Metazoa	33208	Platyhelminthes	Platyhelminthes	243	1.75e-59	NTclustered	gi\|359318420\|gb\|JN968463.2\|	6161	g15203	i0	80.061	25.1970149253731	326	65	97	0	3	328	1606	1281	Dugesia japonica glucose-regulated protein 78 (grp78) mRNA, complete cds	blastn	8441	243	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
14808706	14808706	PRJNA795983_S_NODE_31412_length_263_cov_1.721053_g31287_i0	PRJNA795983	31412	263	1.721053	4.52636939	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	220	6.22e-53	NTclustered	gi\|2029882162\|gb\|MT411562.1\|	79327	g31287	i0	84.375	51.8326996197719	224	35	85	0	38	261	496	273	Schmidtea mediterranea BIP-1 (bip-1) mRNA, partial cds	blastn	13632	220	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
16082508	16082508	PRJNA795983_S_NODE_1833_length_746_cov_4.548291_g1734_i0	PRJNA795983	1833	746	4.548291	33.93025086	Schistosoma turkestanicum	1163369	Platyhelminthes	Platyhelminthes	656	0	NTclustered	gi\|66732686\|gb\|DQ017265.1\|	1163369	g1734	i0	83.764	89.0187667560322	696	109	93	4	52	745	1200	507	Orientobilharzia turkestanicum actin mRNA, complete cds	blastn	66408	656	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma turkestanicum
18631610	18631610	PRJNA795983_S_NODE_27035_length_277_cov_2.598039_g26910_i0	PRJNA795983	27035	277	2.598039	7.19656803	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	139	3.65e-36	NR	ALJ32180.1	6182	g26910	i0	75.8	219.779783393502	91	22	98.6	0	3	275	369	459	ALJ32180.1 heat shock protein 70 [Schistosoma japonicum]	diamond	60879	139	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
22457402	22457402	PRJNA795983_S_NODE_4018_length_546_cov_1.959831_g3896_i0	PRJNA795983	4018	546	1.959831	10.70067726	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	409	2.7699999999999997e-109	NTclustered	gi\|226478901\|emb\|FN317215.1\|	6182	g3896	i0	81.653	48.029304029304	496	87	90	3	50	543	58	551	Schistosoma japonicum isolate Anhui full length mRNA clone SJFCE0797\|FSE_080_96_H12, complete sequence	blastn	26224	409	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
22894140	22894140	PRJNA795983_S_NODE_5558_length_481_cov_4.909314_g5433_i0	PRJNA795983	5558	481	4.909314	23.61380034	Metazoa	33208	Platyhelminthes	Platyhelminthes	394	6.76e-105	NTclustered	gi\|21308066\|gb\|AY067433.1\|	79327	g5433	i0	83.61	88.2661122661123	421	67	87	2	59	478	1	420	Schmidtea mediterranea unknown mRNA sequence	blastn	42456	394	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
27316023	27316023	PRJNA795983_S_NODE_43163_length_241_cov_0.916667_g43038_i0	PRJNA795983	43163	241	0.916667	2.20916747	Platyhelminthes	6157	Platyhelminthes	Platyhelminthes	73.9	3.54e-13	NR	PAA51975.1	282301	g43038	i0	47.5	7.9045643153527	80	40	97.1	1	236	3	172	251	PAA51975.1 hypothetical protein BOX15_Mlig007695g2, partial [Macrostomum lignano]	diamond	1905	73.9	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
27496283	27496283	PRJNA795983_S_NODE_3903_length_552_cov_1.741127_g3781_i0	PRJNA795983	3903	552	1.741127	9.61102104	Rodentolepis nana	102285	Platyhelminthes	Platyhelminthes	77.8	2.95e-14	NR	VDO01380.1	102285	g3781	i0	37.9	1.33695652173913	132	69	64.7	5	37	393	32	163	VDO01380.1 unnamed protein product [Rodentolepis nana]	diamond	738	77.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Hymenolepididae	Rodentolepis	Rodentolepis nana
30116888	30116888	PRJNA795983_S_NODE_28572_length_272_cov_2.100503_g28447_i0	PRJNA795983	28572	272	2.100503	5.71336816	Hymenolepis diminuta	6216	Platyhelminthes	Platyhelminthes	137	4.33e-36	NR	VDL16193.1	6216	g28447	i0	69.7	0.981617647058823	89	27	98.2	0	4	270	266	354	VDL16193.1 unnamed protein product [Hymenolepis diminuta]	diamond	267	137	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Hymenolepididae	Hymenolepis	Hymenolepis diminuta
31065134	31065134	PRJNA795983_S_NODE_30415_length_266_cov_1.829016_g30290_i0	PRJNA795983	30415	266	1.829016	4.86518256	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	86.7	1.87e-19	NR	AAW26362.1	6182	g30290	i0	50	4.48872180451128	76	33	81.2	2	50	265	19	93	AAW26362.1 SJCHGC08585 protein [Schistosoma japonicum]	diamond	1194	86.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
31381199	31381199	PRJNA795983_S_NODE_2616_length_647_cov_4.562718_g2502_i0	PRJNA795983	2616	647	4.562718	29.52078546	Mesocestoides corti	53468	Platyhelminthes	Platyhelminthes	260	1.08e-83	NR	VDD81745.1	53468	g2502	i0	64.7	5.97217928902628	215	61	99.7	1	646	2	1	200	VDD81745.1 unnamed protein product, partial [Mesocestoides corti]	diamond	3864	260	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Mesocestoididae	Mesocestoides	Mesocestoides corti
32172092	32172092	PRJNA795983_S_NODE_36718_length_250_cov_0.864407_g36593_i0	PRJNA795983	36718	250	0.864407	2.1610175	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	67.4	6.89e-11	NR	VZI39338.1	99802	g36593	i0	41.8	0.948	79	42	94.8	2	5	241	50	124	VZI39338.1 unnamed protein product [Spirometra erinaceieuropaei]	diamond	237	67.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
32465999	32465999	PRJNA795983_S_NODE_40879_length_244_cov_0.888889_g40754_i0	PRJNA795983	40879	244	0.888889	2.16888916	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	124	7.519999999999999e-31	NR	OON18522.1	6198	g40754	i0	69.6	36.5655737704918	79	22	94.7	1	244	14	178	256	OON18522.1 kinase domain protein, partial [Opisthorchis viverrini]	diamond	8922	124	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
32488449	32488449	PRJNA795983_S_NODE_10299_length_385_cov_0.951923_g10174_i0	PRJNA795983	10299	385	0.951923	3.66490355	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	55.5	6.02e-6	NR	PAA93605.1	282301	g10174	i0	28.9	1.77662337662338	114	75	88.8	2	379	38	327	434	PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano]	diamond	684	55.5	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);;