metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA944406" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA944406" 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
924694	924694	PRJNA944406_P_NODE_56861_length_257_cov_1.255435_g55902_i0	PRJNA944406	56861	257	1.255435	3.22646795	Monotoplana cf. diorchis	104924	Platyhelminthes	Platyhelminthes	73.1	1.79e-8	NTclustered	gi\|10944981\|emb\|AJ270174.1\|	104924	g55902	i0	100	20.3073929961089	39	0	15	0	132	170	1595	1633	Monotoplana cf. diorchis partial 28S rRNA gene	blastn	5219	73.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Proseriata	Monotoplanidae	Monotoplana	Monotoplana cf. diorchis
3474855	3474855	PRJNA944406_P_NODE_10523_length_384_cov_2.131833_g9564_i0	PRJNA944406	10523	384	2.131833	8.18623872	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	292	1.98e-74	NTclustered	gi\|60700756\|gb\|AY915859.1\|	6182	g9564	i0	89.407	0.856770833333333	236	20	60	1	1	231	237	2	Schistosoma japonicum SJCHGC09793 protein mRNA, complete cds	blastn	329	292	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
3474885	3474885	PRJNA944406_P_NODE_107963_length_241_cov_0.916667_g107004_i0	PRJNA944406	107963	241	0.916667	2.20916747	Diplorchis hangzhouensis	1131906	Platyhelminthes	Platyhelminthes	54.7	0.006	NTclustered	gi\|379771686\|gb\|JQ038227.1\|	1131906	g107004	i0	100	0.120331950207469	29	0	12	0	93	121	5361	5389	Diplorchis hangzhouensis mitochondrion sequence	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Polystomatidea	Polystomatidae	Diplorchis	Diplorchis hangzhouensis
3474894	3474894	PRJNA944406_P_NODE_10923_length_377_cov_187.901316_g9964_i0	PRJNA944406	10923	377	187.901316	708.38796132	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	529	1.3599999999999995e-145	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g9964	i0	97.72	119.299734748011	307	7	100	0	1	307	1146	1452	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	44976	529	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
3475432	3475432	PRJNA944406_P_NODE_54883_length_258_cov_2.805405_g53924_i0	PRJNA944406	54883	258	2.805405	7.2379449	Stenostomum leucops	52061	Platyhelminthes	Platyhelminthes	440	4.2899999999999984e-119	NTclustered	gi\|28273263\|gb\|AY157151.1\|	52061	g53924	i0	97.308	61.1434108527132	260	5	100	2	1	258	272	13	Stenostomum leucops 28S large subunit ribosomal RNA gene, partial sequence	blastn	15775	440	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes			Stenostomidae	Stenostomum	Stenostomum leucops
4752967	4752967	PRJNA944406_P_NODE_44144_length_268_cov_3.841026_g43185_i0	PRJNA944406	44144	268	3.841026	10.29394968	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	433	7.499999999999998e-117	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g43185	i0	95.604	123.966417910448	273	7	100	4	1	268	1270	1542	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	33223	433	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
6027405	6027405	PRJNA944406_P_NODE_15605_length_326_cov_0.944664_g14646_i0	PRJNA944406	15605	326	0.944664	3.07960464	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	429	1.2099999999999999e-115	NTclustered	gi\|56754081\|gb\|AY813498.1\|	6182	g14646	i0	92.434	93.9386503067485	304	17	92	6	2	301	53	354	Schistosoma japonicum SJCHGC04882 protein mRNA, complete cds	blastn	30624	429	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
7302381	7302381	PRJNA944406_P_NODE_2286_length_921_cov_108.995283_g1555_i0	PRJNA944406	2286	921	108.995283	1003.84655643	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	1467	0	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g1555	i0	95.847	125.976112920738	915	24	100	7	15	921	2169	1261	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	116024	1467	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
7302620	7302620	PRJNA944406_P_NODE_43806_length_269_cov_1.382653_g42847_i0	PRJNA944406	43806	269	1.382653	3.71933657	Procerodes plebeja	391280	Platyhelminthes	Platyhelminthes	126	1.43e-24	NTclustered	gi\|109631067\|gb\|DQ665987.1\|	391280	g42847	i0	76.19	32.2676579925651	273	46	100	14	1	269	1290	1033	Procerodes plebeja 28S ribosomal RNA gene, partial sequence	blastn	8680	126	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Procerodidae	Procerodes	Procerodes plebeja
8577191	8577191	PRJNA944406_P_NODE_18127_length_308_cov_1.310638_g17168_i0	PRJNA944406	18127	308	1.310638	4.03676504	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	329	1.1899999999999998e-85	NTclustered	gi\|20977173\|gb\|AF503445.1\|	6182	g17168	i0	87.5	3.65584415584416	304	14	91	11	29	308	2	305	Schistosoma japonicum Mf9 protein mRNA, complete cds	blastn	1126	329	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
8577618	8577618	PRJNA944406_P_NODE_56947_length_257_cov_0.836957_g55988_i0	PRJNA944406	56947	257	0.836957	2.15097949	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	132	2.9200000000000003e-26	NTclustered	gi\|56753506\|gb\|AY813225.1\|	6182	g55988	i0	98.649	28.3774319066148	74	1	29	0	1	74	660	587	Schistosoma japonicum SJCHGC06004 protein mRNA, complete cds	blastn	7293	132	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
9852144	9852144	PRJNA944406_P_NODE_107008_length_241_cov_0.952381_g106049_i0	PRJNA944406	107008	241	0.952381	2.29523821	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	368	1.9e-97	NTclustered	gi\|60602499\|gb\|AY811818.1\|	6182	g106049	i0	94.191	12.8921161825726	241	14	100	0	1	241	398	158	Schistosoma japonicum SJCHGC07889 protein mRNA, partial cds	blastn	3107	368	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
11128389	11128389	PRJNA944406_P_NODE_56509_length_257_cov_1.554348_g55550_i0	PRJNA944406	56509	257	1.554348	3.99467436	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	134	8.12e-27	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g55550	i0	98.667	23.9571984435798	75	1	29	0	183	257	1988	1914	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	6157	134	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
12403700	12403700	PRJNA944406_P_NODE_4330_length_635_cov_20.946619_g3414_i0	PRJNA944406	4330	635	20.946619	133.01103065	Stenostomum sthenum	1611831	Platyhelminthes	Platyhelminthes	1079	0	NTclustered	gi\|1215837197\|ref\|NC_035256.1\|	1611831	g3414	i0	97.323	32.9196850393701	635	17	100	0	1	635	8330	8964	Stenostomum sthenum mitochondrion, complete genome	blastn	20904	1079	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes			Stenostomidae	Stenostomum	Stenostomum sthenum
16227456	16227456	PRJNA944406_P_NODE_39633_length_273_cov_1.270000_g38674_i0	PRJNA944406	39633	273	1.27	3.4671	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	183	8.519999999999997e-42	NTclustered	gi\|60700756\|gb\|AY915859.1\|	6182	g38674	i0	88.05	0.769230769230769	159	13	75	1	6	158	219	61	Schistosoma japonicum SJCHGC09793 protein mRNA, complete cds	blastn	210	183	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
16227786	16227786	PRJNA944406_P_NODE_70833_length_250_cov_0.870056_g69874_i0	PRJNA944406	70833	250	0.870056	2.17514	Ameloblastella sp. 8 IBC-2015	1640893	Platyhelminthes	Platyhelminthes	145	3.63e-30	NTclustered	gi\|806825022\|gb\|KP056254.1\|	1640893	g69874	i0	78.226	41.472	248	39	95	12	12	249	1031	1273	Ameloblastella sp. 8 IBC-2015 isolate Am8Sl 28S ribosomal RNA gene, partial sequence	blastn	10368	145	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Monogenea	Dactylogyridea	Ancylodiscoididae	Ameloblastella	Ameloblastella sp. 8 IBC-2015
17502446	17502446	PRJNA944406_P_NODE_15294_length_329_cov_0.945312_g14335_i0	PRJNA944406	15294	329	0.945312	3.11007648	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	468	2.59e-127	NTclustered	gi\|56754081\|gb\|AY813498.1\|	6182	g14335	i0	92.705	100.908814589666	329	17	100	3	1	329	439	118	Schistosoma japonicum SJCHGC04882 protein mRNA, complete cds	blastn	33199	468	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
17502573	17502573	PRJNA944406_P_NODE_26094_length_286_cov_1.107981_g25135_i0	PRJNA944406	26094	286	1.107981	3.16882566	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	283	8.609999999999999e-72	NTclustered	gi\|60689342\|gb\|AY915233.1\|	6182	g25135	i0	96	1.83216783216783	175	6	61	1	113	286	277	103	Schistosoma japonicum SJCHGC03747 protein mRNA, complete cds	blastn	524	283	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
18775996	18775996	PRJNA944406_P_NODE_14755_length_333_cov_3.500000_g13796_i0	PRJNA944406	14755	333	3.5	11.655	Taenia asiatica	60517	Platyhelminthes	Platyhelminthes	84.2	1.11e-11	NTclustered	gi\|124784834\|gb\|EF201974.1\|	60517	g13796	i0	82.796	15.4084084084084	93	16	28	0	241	333	283	191	Taenia asiatica clone HC2-A10 cytoplasmic antigen 1 mRNA, complete cds	blastn	5131	84.2	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Taenia	Taenia asiatica
22601364	22601364	PRJNA944406_P_NODE_2098_length_959_cov_202.493228_g1407_i0	PRJNA944406	2098	959	202.493228	1941.91005652	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	1539	0	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g1407	i0	95.675	127.803962460897	971	19	100	11	1	959	1146	2105	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	122564	1539	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
22602089	22602089	PRJNA944406_P_NODE_85218_length_246_cov_0.890173_g84259_i0	PRJNA944406	85218	246	0.890173	2.18982558	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	143	1.28e-29	NTclustered	gi\|56758417\|gb\|AY815617.1\|	6182	g84259	i0	96.512	21.8943089430894	86	3	35	0	1	86	104	19	Schistosoma japonicum SJCHGC04625 protein mRNA, complete cds	blastn	5386	143	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
23877689	23877689	PRJNA944406_P_NODE_9059_length_413_cov_202.755882_g8100_i0	PRJNA944406	9059	413	202.755882	837.38179266	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	640	6.66e-179	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g8100	i0	94.498	125.854721549637	418	18	100	4	1	413	1654	1237	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	51978	643	0.995334370139969	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum

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