metadata: contig_metadata: 13 rows where bioproject = "PRJEB11748", tax_kingdom = "Metazoa" and tax

13 rows where bioproject = "PRJEB11748", tax_kingdom = "Metazoa" 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
16430	16430	PRJEB11748_P_NODE_228561_length_261_cov_3.505000_g226378_i0	PRJEB11748	228561	261	3.505	9.14805	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	54.7	0.007	NTclustered	gi\|1084295050\|ref\|XM_018796411.1\|	6183	g226378	i0	100	0.659003831417625	29	0	11	0	98	126	352	324	Schistosoma mansoni hypothetical protein partial mRNA	blastn	172	54.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
4811996	4811996	PRJEB11748_P_NODE_279984_length_229_cov_10.851190_g277801_i0	PRJEB11748	279984	229	10.85119	24.8492251	Metazoa	33208	Platyhelminthes	Platyhelminthes	394	2.9499999999999995e-105	NTclustered	gi\|60687563\|gb\|AY914894.1\|	6182	g277801	i0	100	93.0131004366812	213	0	93	0	17	229	666	454	Schistosoma japonicum unknown mRNA	blastn	21300	394	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
6396158	6396158	PRJEB11748_P_NODE_316086_length_212_cov_2.317881_g313903_i0	PRJEB11748	316086	212	2.317881	4.91390772	Dicrocoelium dendriticum	57078	Platyhelminthes	Platyhelminthes	52.8	0.019	NTclustered	gi\|687302522\|emb\|LK393723.1\|	57078	g313903	i0	100	0.132075471698113	28	0	13	0	7	34	5619	5646	Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0000604	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Dicrocoeliidae	Dicrocoelium	Dicrocoelium dendriticum
7361615	7361615	PRJEB11748_P_NODE_260486_length_240_cov_10.217877_g258303_i0	PRJEB11748	260486	240	10.217877	24.5229048	Metazoa	33208	Platyhelminthes	Platyhelminthes	396	8.659999999999997e-106	NTclustered	gi\|60687563\|gb\|AY914894.1\|	6182	g258303	i0	99.539	90.425	217	1	90	0	2	218	256	472	Schistosoma japonicum unknown mRNA	blastn	21702	398	0.994974874371859	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
12463873	12463873	PRJEB11748_P_NODE_377110_length_181_cov_18.958333_g374927_i0	PRJEB11748	377110	181	18.958333	34.31458273	Opisthokonta	33154	Platyhelminthes	Platyhelminthes	52.8	0.015	NTclustered	gi\|1084299672\|ref\|XM_018797938.1\|	6183	g374927	i0	100	0.30939226519337	28	0	15	0	6	33	1246	1219	Schistosoma mansoni hypothetical protein partial mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
17868773	17868773	PRJEB11748_P_NODE_259435_length_241_cov_2.777778_g257252_i0	PRJEB11748	259435	241	2.777778	6.69444498	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	54.7	0.006	NTclustered	gi\|690643716\|emb\|LN190579.1\|	99802	g257252	i0	96.875	0.597510373443983	32	1	13	0	116	147	523	492	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0164564	blastn	144	54.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
21692741	21692741	PRJEB11748_P_NODE_209698_length_275_cov_36.794393_g207515_i0	PRJEB11748	209698	275	36.794393	101.18458075	Dugesia japonica	6161	Platyhelminthes	Platyhelminthes	54.7	0.007	NTclustered	gi\|1240504568\|gb\|MF667538.1\|	6161	g207515	i0	100	0.105454545454545	29	0	11	0	4	32	1	29	Dugesia japonica 14-3-3 epsilon mRNA, complete cds	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
21692790	21692790	PRJEB11748_P_NODE_212378_length_273_cov_8.108491_g210195_i0	PRJEB11748	212378	273	8.108491	22.13618043	Promesostoma cochleare	1311875	Platyhelminthes	Platyhelminthes	132	3.1300000000000003e-26	NTclustered	gi\|588313926\|gb\|KC869884.1\|	1311875	g210195	i0	86.29	40.9230769230769	124	14	44	1	110	230	1700	1577	Promesostoma cochleare 28S ribosomal RNA gene, partial sequence	blastn	11172	132	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Rhabdocoela	Promesostomidae	Promesostoma	Promesostoma cochleare
21693405	21693405	PRJEB11748_P_NODE_244478_length_250_cov_6.280423_g242295_i0	PRJEB11748	244478	250	6.280423	15.7010575	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	165	2.79e-36	NTclustered	gi\|690647901\|emb\|LN195382.1\|	99802	g242295	i0	80	0.92	230	41	92	3	1	230	1226	1002	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei, scaffold SPER_scaffold0167598	blastn	230	165	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
22971122	22971122	PRJEB11748_P_NODE_397919_length_167_cov_4.283019_g395736_i0	PRJEB11748	397919	167	4.283019	7.15264173	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	52.8	0.014	NTclustered	gi\|690488728\|emb\|LN033330.1\|	99802	g395736	i0	100	0.67065868263473	28	0	17	0	22	49	3377	3350	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0032646	blastn	112	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
27696681	27696681	PRJEB11748_P_NODE_332484_length_205_cov_4.722222_g330301_i0	PRJEB11748	332484	205	4.722222	9.6805551	Hydatigera taeniaeformis	6205	Platyhelminthes	Platyhelminthes	42	0.0418	NR	VDM24294.1	6205	g330301	i0	43.4	0.775609756097561	53	26	71.7	1	169	23	260	312	VDM24294.1 unnamed protein product [Hydatigera taeniaeformis]	diamond	159	42	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Hydatigera	Hydatigera taeniaeformis
28959593	28959593	PRJEB11748_P_NODE_44508_length_647_cov_40.841297_g42431_i0	PRJEB11748	44508	647	40.841297	264.24319159	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	287	2.48e-91	NR	AAX28387.3	6182	g42431	i0	98.7	4.96599690880989	153	2	70.9	0	142	600	299	451	AAX28387.3 SJCHGC01615 protein, partial [Schistosoma japonicum]	diamond	3213	287	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
30254213	30254213	PRJEB11748_P_NODE_116712_length_384_cov_10.390093_g114538_i0	PRJEB11748	116712	384	10.390093	39.89795712	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	76.3	6.26e-15	NR	AAX24812.2	6182	g114538	i0	70.6	1.1640625	51	10	39.8	1	38	190	11	56	AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum]	diamond	447	76.3	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);;