metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA675331" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA675331" 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
647701	647701	PRJNA675331_P_NODE_3261_length_517_cov_1.819820_g3091_i0	PRJNA675331	3261	517	1.81982	9.4084694	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	418	4.329999999999999e-112	NTclustered	gi\|684405427\|ref\|XM_009176183.1\|	6198	g3091	i0	81.395	11.7040618955513	516	92	99	4	4	517	1114	601	Opisthorchis viverrini hypothetical protein partial mRNA	blastn	6051	418	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
1923844	1923844	PRJNA675331_P_NODE_15602_length_267_cov_2.453608_g15430_i0	PRJNA675331	15602	267	2.453608	6.55113336	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	174	5e-39	NTclustered	gi\|161084\|gb\|M94045.1\|SCMSM20	6183	g15430	i0	81.604	2.38202247191011	212	37	79	2	38	248	103	313	Schistosoma mansoni calcium binding protein (Sm20) mRNA, complete cds	blastn	636	174	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
3198625	3198625	PRJNA675331_P_NODE_143_length_2029_cov_2.451431_g112_i0	PRJNA675331	143	2029	2.451431	49.73953499	Schistosoma haematobium	6185	Platyhelminthes	Platyhelminthes	1482	0	NTclustered	gi\|2318771470\|ref\|XM_051217536.1\|	6185	g112	i0	82.622	1.04829965500246	1686	283	83	9	16	1696	4822	6502	Schistosoma haematobium Myosin heavy chain (MYH15), mRNA	blastn	2127	1482	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma haematobium
4475800	4475800	PRJNA675331_P_NODE_524_length_1216_cov_3.532808_g420_i0	PRJNA675331	524	1216	3.532808	42.95894528	Fasciola hepatica	6192	Platyhelminthes	Platyhelminthes	375	6.479999999999998e-99	NTclustered	gi\|262213551\|gb\|GU059940.1\|	6192	g420	i0	83.092	0.340460526315789	414	68	34	2	1	413	247	659	Fasciola hepatica myosin regulatory light chain mRNA, complete cds	blastn	414	375	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciola	Fasciola hepatica
5751330	5751330	PRJNA675331_P_NODE_23125_length_242_cov_2.366864_g22953_i0	PRJNA675331	23125	242	2.366864	5.72781088	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	145	3.5e-30	NTclustered	gi\|408408004\|gb\|AY810159.2\|	6182	g22953	i0	84.459	1.16115702479339	148	21	60	2	1	146	398	545	Schistosoma japonicum clone SJCHGC00405 unknown mRNA	blastn	281	145	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
8301110	8301110	PRJNA675331_P_NODE_2247_length_613_cov_1.961111_g2081_i0	PRJNA675331	2247	613	1.961111	12.02161043	Ogmocotyle ailuri	2935503	Platyhelminthes	Platyhelminthes	187	1.6e-42	NTclustered	gi\|2452632789\|ref\|NC_071931.1\|	2935503	g2081	i0	83.5	6.67862969004894	200	33	33	0	193	392	10924	10725	Ogmocotyle ailuri isolate Heilongjiang mitochondrion, complete genome	blastn	4094	187	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Notocotylidae	Ogmocotyle	Ogmocotyle ailuri
8301137	8301137	PRJNA675331_P_NODE_607_length_1120_cov_228.390640_g499_i0	PRJNA675331	607	1120	228.39064	2557.975168	Paragonimus heterotremus	100268	Platyhelminthes	Platyhelminthes	340	2.17e-88	NTclustered	gi\|1488177190\|ref\|NC_039430.1\|	100268	g499	i0	77.778	51.8919642857143	603	101	52	21	101	687	9410	8825	Paragonimus heterotremus mitochondrion, complete genome	blastn	58119	340	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Troglotrematidae	Paragonimus	Paragonimus heterotremus
9576295	9576295	PRJNA675331_P_NODE_1448_length_754_cov_2.392070_g1291_i0	PRJNA675331	1448	754	2.39207	18.0362078	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	97.1	3.44e-15	NTclustered	gi\|2784095350\|emb\|OZ171481.1\|	6198	g1291	i0	81.481	1.89389920424403	135	9	17	11	630	754	6753	6881	Opisthorchis viverrini genome assembly, organelle: mitochondrion	blastn	1428	97.1	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
9576330	9576330	PRJNA675331_P_NODE_2028_length_643_cov_1.622807_g1862_i0	PRJNA675331	2028	643	1.6228070000000001	10.43464901	Schistosoma haematobium	6185	Platyhelminthes	Platyhelminthes	451	5.39e-122	NTclustered	gi\|532647\|gb\|L34660.1\|SCMTROPOMY	6185	g1862	i0	81.903	4.94245723172628	536	95	83	2	1	535	425	959	Schistosoma haematobium tropomyosin mRNA	blastn	3178	451	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma haematobium
9576367	9576367	PRJNA675331_P_NODE_4208_length_461_cov_1.190722_g4036_i0	PRJNA675331	4208	461	1.190722	5.48922842	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	178	7.08e-40	NTclustered	gi\|56759043\|gb\|AY815930.1\|	6182	g4036	i0	73.913	7.60303687635575	460	112	99	8	3	458	780	325	Schistosoma japonicum SJCHGC09280 protein mRNA, complete cds	blastn	3505	178	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
12127127	12127127	PRJNA675331_P_NODE_990_length_898_cov_1.530909_g853_i0	PRJNA675331	990	898	1.530909	13.74756282	Opisthorchis viverrini	6198	Platyhelminthes	Platyhelminthes	460	1.27e-124	NTclustered	gi\|684401352\|ref\|XM_009174862.1\|	6198	g853	i0	80.293	0.683741648106904	614	117	68	4	27	638	94	705	Opisthorchis viverrini hypothetical protein partial mRNA	blastn	614	460	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Opisthorchiida	Opisthorchiidae	Opisthorchis	Opisthorchis viverrini
13922451	13922451	PRJNA675331_P_NODE_9731_length_318_cov_1.257143_g9559_i0	PRJNA675331	9731	318	1.257143	3.99771474	Plagiorchiida	27871	Platyhelminthes	Platyhelminthes	300	9.64e-77	NTclustered	gi\|28273287\|gb\|AY157175.1\|	116879	g9559	i0	84.112	100.210691823899	321	39	100	9	1	318	2708	2397	Lepidophyllum steenstrupi 28S large subunit ribosomal RNA gene, partial sequence	blastn	31867	302	0.993377483443709	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Zoogonidae	Lepidophyllum	Lepidophyllum steenstrupi
14676800	14676800	PRJNA675331_P_NODE_132_length_2076_cov_11.943585_g102_i0	PRJNA675331	132	2076	11.943585	247.9488246	Dicrocoelium dendriticum	57078	Platyhelminthes	Platyhelminthes	1266	0	NTclustered	gi\|687278702\|emb\|LK452950.1\|	57078	g102	i0	80.046	80.1247591522158	1739	322	83	20	226	1950	1762	35	Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0002376	blastn	166339	1266	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Dicrocoeliidae	Dicrocoelium	Dicrocoelium dendriticum
17225747	17225747	PRJNA675331_P_NODE_1154_length_838_cov_2.550327_g1008_i0	PRJNA675331	1154	838	2.550327	21.37174026	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	425	4.31e-114	NTclustered	gi\|1084312710\|ref\|XM_018793798.1\|	6183	g1008	i0	80.492	1.35680190930788	569	99	67	11	231	793	625	63	Schistosoma mansoni calponin-related partial mRNA	blastn	1137	425	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
17746399	17746399	PRJNA675331_P_NODE_674_length_1079_cov_2.853877_g560_i0	PRJNA675331	674	1079	2.853877	30.79333283	Schistosoma	6181	Platyhelminthes	Platyhelminthes	723	0	NTclustered	gi\|226478053\|emb\|FN316989.1\|	6182	g560	i0	81.377	82.5718257645969	886	165	82	0	16	901	1225	340	Schistosoma japonicum isolate Anhui full length mRNA clone SJFCA4084\|FSA001-P00008-O14, complete sequence	blastn	89095	728	0.993131868131868	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
18500055	18500055	PRJNA675331_P_NODE_3355_length_510_cov_1.762014_g3185_i0	PRJNA675331	3355	510	1.762014	8.9862714	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	283	1.63e-71	NTclustered	gi\|1084294336\|ref\|XM_018796014.1\|	6183	g3185	i0	78.44	9.24509803921569	436	93	85	1	35	469	535	100	Schistosoma mansoni putative o-linked n-acetylglucosamine transferase, ogt partial mRNA	blastn	4715	283	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
21050231	21050231	PRJNA675331_P_NODE_11937_length_293_cov_1.050000_g11765_i0	PRJNA675331	11937	293	1.05	3.0765	Schistosoma haematobium	6185	Platyhelminthes	Platyhelminthes	219	2.5299999999999993e-52	NTclustered	gi\|2318755668\|ref\|XM_051211895.1\|	6185	g11765	i0	80.634	0.969283276450512	284	53	97	2	9	291	776	1058	Schistosoma haematobium Splicing factor 3B subunit 2 (SF3B2), mRNA	blastn	284	219	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma haematobium
23600610	23600610	PRJNA675331_P_NODE_3699_length_488_cov_2.202410_g3527_i0	PRJNA675331	3699	488	2.20241	10.7477608	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	375	2.4899999999999997e-99	NTclustered	gi\|56758675\|gb\|AY815746.1\|	6182	g3527	i0	80.533	44.2172131147541	488	95	100	0	1	488	975	488	Schistosoma japonicum SJCHGC00301 protein mRNA, complete cds	blastn	21578	375	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
25394943	25394943	PRJNA675331_P_NODE_4720_length_438_cov_1.536986_g4548_i0	PRJNA675331	4720	438	1.536986	6.73199868	Plagiorchiida	27871	Platyhelminthes	Platyhelminthes	597	4.3399999999999983e-166	NTclustered	gi\|1799639270\|gb\|MN970007.1\|	6192	g4548	i0	91.344	92.7488584474886	439	35	100	2	1	438	7040	6604	Fasciola hepatica isolate Geelong small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence; and non-transcribed intergenic spacer, partial sequence	blastn	40624	603	0.990049751243781	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Fasciolidae	Fasciola	Fasciola hepatica

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