metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA1174234" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA1174234" 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
316133	316133	PRJNA1174234_P_NODE_14801_length_358_cov_1.333333_g14605_i0	PRJNA1174234	14801	358	1.333333	4.77333214	Schistosoma haematobium	6185	Platyhelminthes	Platyhelminthes	224	6.789999999999999e-54	NTclustered	gi\|2318754919\|ref\|XM_051217084.1\|	6185	g14605	i0	85.253	56.2458100558659	217	32	61	0	9	225	1145	1361	Schistosoma haematobium Tubulin alpha-3C/D chain (TUBA3D_5), mRNA	blastn	20136	224	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma haematobium
316168	316168	PRJNA1174234_P_NODE_20761_length_303_cov_1.330435_g20565_i0	PRJNA1174234	20761	303	1.330435	4.03121805	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	279	1.19e-70	NTclustered	gi\|226469103\|emb\|FN314298.1\|	6182	g20565	i0	83.444	33.1023102310231	302	48	99	2	1	301	499	199	Schistosoma japonicum isolate Anhui full length mRNA clone SJFCA2796.003\|FSA001-P00024-H02, complete sequence	blastn	10030	279	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
2316231	2316231	PRJNA1174234_P_NODE_32362_length_246_cov_0.890173_g32166_i0	PRJNA1174234	32362	246	0.890173	2.18982558	Metazoa	33208	Platyhelminthes	Platyhelminthes	52.8	0.022	NTclustered	gi\|690481491\|emb\|LN023893.1\|	99802	g32166	i0	100	0.227642276422764	28	0	11	0	49	76	1102	1075	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0023475	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
2316245	2316245	PRJNA1174234_P_NODE_802_length_1238_cov_3.829185_g713_i0	PRJNA1174234	802	1238	3.829185	47.4053103	Metazoa	33208	Platyhelminthes	Platyhelminthes	449	3.839999999999999e-121	NTclustered	gi\|58197522\|dbj\|AB200392.1\|	6161	g713	i0	84.498	27.5008077544427	458	68	37	3	731	1186	495	39	Dugesia japonica CaM mRNA for calmodulin, complete cds	blastn	34046	449	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
5419300	5419300	PRJNA1174234_P_NODE_9665_length_443_cov_10.929730_g9469_i0	PRJNA1174234	9665	443	10.92973	48.4187039	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	725	0	NTclustered	gi\|68479954\|gb\|DQ076149.1\|	6182	g9469	i0	96.782	0.981941309255079	435	13	98	1	1	435	445	12	Schistosoma japonicum clone 1XA1 unknown mRNA	blastn	435	725	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
7418806	7418806	PRJNA1174234_P_NODE_6326_length_542_cov_2.010661_g6130_i0	PRJNA1174234	6326	542	2.010661	10.89778262	Metazoa	33208	Platyhelminthes	Platyhelminthes	350	1.6900000000000002e-91	NTclustered	gi\|1842149\|dbj\|AB001051.1\|	6161	g6130	i0	80.603	84.4428044280443	464	80	85	10	11	469	542	84	Dugesia japonica mRNA for ADP-ribosylation factor, complete cds	blastn	45768	351	0.997150997150997	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
7969308	7969308	PRJNA1174234_P_NODE_1167_length_1080_cov_9.839126_g1050_i0	PRJNA1174234	1167	1080	9.839126	106.2625608	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	678	0	NTclustered	gi\|1369885\|gb\|L78441.1\|SCM14332R	6183	g1050	i0	85.429	17.2305555555556	652	95	60	0	271	922	652	1	Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds	blastn	18609	678	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
9244033	9244033	PRJNA1174234_P_NODE_21848_length_295_cov_1.585586_g21652_i0	PRJNA1174234	21848	295	1.585586	4.6774787	Cryptocotyle lingua	66766	Platyhelminthes	Platyhelminthes	124	5.72e-24	NTclustered	gi\|1964739149\|gb\|MW361138.1\|	66766	g21652	i0	86.607	10.0440677966102	112	15	38	0	184	295	252	363	Cryptocotyle lingua calmodulin 1 (CALM1) mRNA, complete cds	blastn	2963	124	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Heterophyidae	Cryptocotyle	Cryptocotyle lingua
9969059	9969059	PRJNA1174234_P_NODE_34128_length_243_cov_0.905882_g33932_i0	PRJNA1174234	34128	243	0.905882	2.20129326	Platyhelminthes	6157	Platyhelminthes	Platyhelminthes	58.4	4.71e-4	NTclustered	gi\|687745593\|emb\|LK441680.1\|	57078	g33932	i0	90.909	2.61316872427984	44	3	18	1	63	105	558	601	Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0046783	blastn	635	58.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Dicrocoeliidae	Dicrocoelium	Dicrocoelium dendriticum
19442149	19442149	PRJNA1174234_P_NODE_27216_length_261_cov_1.638298_g27020_i0	PRJNA1174234	27216	261	1.638298	4.27595778	Spirometra erinaceieuropaei	99802	Platyhelminthes	Platyhelminthes	58.4	5.12e-4	NTclustered	gi\|690491100\|emb\|LN036181.1\|	99802	g27020	i0	97.059	0.344827586206897	34	1	13	0	126	159	3522	3489	Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0035393	blastn	90	58.4	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Diphyllobothriidea	Diphyllobothriidae	Spirometra	Spirometra erinaceieuropaei
21992788	21992788	PRJNA1174234_P_NODE_33518_length_244_cov_0.900585_g33322_i0	PRJNA1174234	33518	244	0.900585	2.1974274	Dicrocoelium dendriticum	57078	Platyhelminthes	Platyhelminthes	54.7	0.006	NTclustered	gi\|687611900\|emb\|LK523872.1\|	57078	g33322	i0	100	0.352459016393443	29	0	12	0	208	236	310	282	Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0123249	blastn	86	54.7	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Dicrocoeliidae	Dicrocoelium	Dicrocoelium dendriticum
23993136	23993136	PRJNA1174234_P_NODE_819_length_1232_cov_4.060397_g713_i1	PRJNA1174234	819	1232	4.060397	50.02409104	Metazoa	33208	Platyhelminthes	Platyhelminthes	449	3.8199999999999997e-121	NTclustered	gi\|58197522\|dbj\|AB200392.1\|	6161	g713	i1	84.498	27.6347402597403	458	68	37	3	53	508	39	495	Dugesia japonica CaM mRNA for calmodulin, complete cds	blastn	34046	449	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
24542099	24542099	PRJNA1174234_P_NODE_27080_length_262_cov_1.576720_g26884_i0	PRJNA1174234	27080	262	1.57672	4.1310064	Echinococcus granulosus	6210	Platyhelminthes	Platyhelminthes	178	3.78e-40	NTclustered	gi\|1373856714\|ref\|XM_024494734.1\|	6210	g26884	i0	84.409	21.1221374045802	186	23	70	6	8	190	659	477	Echinococcus granulosus 60S ribosomal protein L8 (EGR_05485), partial mRNA	blastn	5534	178	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Taeniidae	Echinococcus	Echinococcus granulosus

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