metadata: contig_metadata: 24 rows where analysis = "blastn", bioproject = "PRJNA1150539" and tax

24 rows where analysis = "blastn", bioproject = "PRJNA1150539" 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
301010	301010	PRJNA1150539_S_NODE_2421_length_813_cov_6.543243_g1912_i0	PRJNA1150539	2421	813	6.543243	53.19656559	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	193	4.61e-44	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g1912	i0	95.833	2.39729397293973	120	4	15	1	692	811	869	987	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	1949	193	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
301454	301454	PRJNA1150539_S_NODE_63101_length_289_cov_175.587963_g62505_i0	PRJNA1150539	63101	289	175.587963	507.44921307	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	492	1.33e-134	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g62505	i0	97.578	127.660899653979	289	4	100	2	1	289	1741	2026	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	36894	492	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
301539	301539	PRJNA1150539_S_NODE_71341_length_277_cov_93.715686_g70745_i0	PRJNA1150539	71341	277	93.715686	259.59245022	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	453	5.98e-123	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g70745	i0	96.403	126.801444043321	278	5	100	2	1	277	1990	1717	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	35124	457	0.991247264770241	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
1575537	1575537	PRJNA1150539_S_NODE_112662_length_206_cov_28.203008_g112066_i0	PRJNA1150539	112662	206	28.203008	58.09819648	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	348	2.05e-91	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g112066	i0	97.101	124.436893203883	207	5	100	1	1	206	1920	1714	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	25634	348	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
2852283	2852283	PRJNA1150539_S_NODE_46783_length_316_cov_155.629630_g46187_i0	PRJNA1150539	46783	316	155.62963	491.7896308	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	520	6.75e-143	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g46187	i0	96.519	126.661392405063	316	8	100	2	1	316	1714	2026	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	40025	520	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
4128027	4128027	PRJNA1150539_S_NODE_26264_length_362_cov_7.927336_g25668_i0	PRJNA1150539	26264	362	7.927336	28.69695632	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	135	3.31e-27	NTclustered	gi\|1124902734\|gb\|AY812498.2\|	6182	g25668	i0	100	21.9806629834254	73	0	20	0	290	362	848	920	Schistosoma japonicum SJCHGC01615 protein mRNA, partial cds	blastn	7957	135	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
5404595	5404595	PRJNA1150539_S_NODE_63765_length_288_cov_160.330233_g63169_i0	PRJNA1150539	63765	288	160.330233	461.75107104	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	497	2.85e-136	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g63169	i0	97.917	127.975694444444	288	4	100	1	1	288	1741	2026	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	36857	497	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
6679488	6679488	PRJNA1150539_S_NODE_75266_length_272_cov_2.080402_g74670_i0	PRJNA1150539	75266	272	2.080402	5.65869344	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	119	2.43e-22	NTclustered	gi\|56753506\|gb\|AY813225.1\|	6182	g74670	i0	98.507	25.6176470588235	67	1	25	0	206	272	363	429	Schistosoma japonicum SJCHGC06004 protein mRNA, complete cds	blastn	6968	119	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
7954044	7954044	PRJNA1150539_S_NODE_113967_length_198_cov_7.904000_g113371_i0	PRJNA1150539	113967	198	7.904	15.64992	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	267	5.63e-67	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g113371	i0	93.923	109.272727272727	181	3	87	3	1	173	1483	1303	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	21636	267	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
7954661	7954661	PRJNA1150539_S_NODE_67907_length_282_cov_4.287081_g67311_i0	PRJNA1150539	67907	282	4.287081	12.08956842	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	178	4.109999999999999e-40	NTclustered	gi\|60694936\|gb\|AY915536.1\|	6182	g67311	i0	91.473	1.1241134751773	129	11	56	0	20	148	1	129	Schistosoma japonicum SJCHGC07523 protein mRNA, partial cds	blastn	317	178	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
7954913	7954913	PRJNA1150539_S_NODE_9467_length_445_cov_27.021505_g8872_i0	PRJNA1150539	9467	445	27.021505	120.24569725	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	460	6.039999999999998e-125	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g8872	i0	94.118	121.716853932584	306	13	100	4	1	306	1677	1977	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	54164	460	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
9228920	9228920	PRJNA1150539_S_NODE_112508_length_207_cov_430.910448_g111912_i0	PRJNA1150539	112508	207	430.910448	891.98462736	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	361	2.65e-95	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g111912	i0	98.068	124.80193236715	207	4	100	0	1	207	1714	1920	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	25834	361	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
9228999	9228999	PRJNA1150539_S_NODE_18568_length_387_cov_9.133758_g17972_i0	PRJNA1150539	18568	387	9.133758	35.34764346	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	333	1.1800000000000001e-86	NTclustered	gi\|60600058\|gb\|AY810684.1\|	6182	g17972	i0	90.873	5.3953488372093	252	18	64	1	141	387	97	348	Schistosoma japonicum SJCHGC04723 protein mRNA, partial cds	blastn	2088	333	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
10505159	10505159	PRJNA1150539_S_NODE_47949_length_314_cov_178.452282_g47353_i0	PRJNA1150539	47949	314	178.452282	560.34016548	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	523	5.18e-144	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g47353	i0	96.825	126.78025477707	315	6	100	2	1	314	2028	1717	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	39809	523	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
10505185	10505185	PRJNA1150539_S_NODE_50229_length_311_cov_0.970588_g49633_i0	PRJNA1150539	50229	311	0.970588	3.01852868	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	117	1.02e-21	NTclustered	gi\|21434882\|gb\|AF502581.1\|	6182	g49633	i0	91.667	25.6559485530547	84	7	27	0	206	289	154	71	Schistosoma japonicum schistosomula protein-like (M12) gene, partial sequence	blastn	7979	117	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
11779549	11779549	PRJNA1150539_S_NODE_111550_length_213_cov_144.685714_g110954_i0	PRJNA1150539	111550	213	144.685714	308.18057082	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	383	5.8499999999999996e-102	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g110954	i0	99.065	123.638497652582	214	1	100	1	1	213	1818	1605	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	26335	383	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
14329943	14329943	PRJNA1150539_S_NODE_110532_length_220_cov_29.380952_g109936_i0	PRJNA1150539	110532	220	29.380952	64.6380944	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	366	6.13e-97	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g109936	i0	96.818	122.422727272727	220	6	100	1	1	220	1124	1342	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	26933	366	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
15603762	15603762	PRJNA1150539_S_NODE_112513_length_207_cov_36.932836_g111917_i0	PRJNA1150539	112513	207	36.932836	76.45097052	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	348	2.06e-91	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g111917	i0	97.101	124.628019323671	207	4	100	1	1	207	2032	1828	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	25798	348	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
16878882	16878882	PRJNA1150539_S_NODE_91534_length_251_cov_6.814607_g90938_i0	PRJNA1150539	91534	251	6.814607	17.10466357	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	431	2.4999999999999996e-116	NTclustered	gi\|60698688\|gb\|AY915747.1\|	6182	g90938	i0	97.61	2.33067729083665	251	6	100	0	1	251	125	375	Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds	blastn	585	431	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
19427817	19427817	PRJNA1150539_S_NODE_83236_length_261_cov_52.702128_g82640_i0	PRJNA1150539	83236	261	52.702128	137.55255408	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	442	1.2099999999999994e-119	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g82640	i0	97.318	128.616858237548	261	5	100	1	1	261	1768	2026	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	33569	442	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
20702778	20702778	PRJNA1150539_S_NODE_49277_length_312_cov_3.510460_g48681_i0	PRJNA1150539	49277	312	3.51046	10.9526352	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	366	9.169999999999999e-97	NTclustered	gi\|60698656\|gb\|AY915745.1\|	6182	g48681	i0	97.664	7.21153846153846	214	4	69	1	99	312	467	255	Schistosoma japonicum SJCHGC09658 protein mRNA, partial cds	blastn	2250	366	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
21977835	21977835	PRJNA1150539_S_NODE_18638_length_387_cov_4.831210_g18042_i0	PRJNA1150539	18638	387	4.83121	18.6967827	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	108	7.78e-19	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g18042	i0	98.387	14.4418604651163	62	0	17	1	327	387	926	987	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	5589	108	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
23253191	23253191	PRJNA1150539_S_NODE_105139_length_236_cov_3.000000_g104543_i0	PRJNA1150539	105139	236	3	7.08	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	351	1.86e-92	NTclustered	gi\|56757963\|gb\|AY815390.1\|	6182	g104543	i0	94.372	105.220338983051	231	9	97	3	1	229	1541	1769	Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds	blastn	24832	351	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
23253232	23253232	PRJNA1150539_S_NODE_112179_length_210_cov_4.051095_g111583_i0	PRJNA1150539	112179	210	4.051095	8.5072995	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	368	1.61e-97	NTclustered	gi\|60598655\|gb\|AY809988.1\|	6182	g111583	i0	100	105.185714285714	199	0	95	0	12	210	450	648	Schistosoma japonicum SJCHGC09533 protein mRNA, partial cds	blastn	22089	368	1	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);;