RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA1186363" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1186363 · 14 ✖

analysis 1

  • blastn · 14 ✖
Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag 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
2870569 2870569 PRJNA1186363_P_NODE_3283_length_1137_cov_8.645677_g2789_i0 PRJNA1186363 3283 1137 8.645677 98.30134749 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 1301 0   NTclustered gi|1369885|gb|L78441.1|SCM14332R 6183 g2789 i0 91 10.9384344766931 1000 39 84 18 1 960 989 1 Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds blastn 12437 1301 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
3592476 3592476 PRJNA1186363_P_NODE_25183_length_362_cov_0.972318_g24295_i0 PRJNA1186363 25183 362 0.972318 3.51979116 Opisthokonta 33154 Platyhelminthes Platyhelminthes 52.8 0.034   NTclustered gi|690586838|emb|LN138970.1| 99802 g24295 i0 100 0.165745856353591 28 0 8 0 311 338 768 795 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0127526 blastn 60 52.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
7972931 7972931 PRJNA1186363_P_NODE_18907_length_440_cov_1.073569_g18019_i0 PRJNA1186363 18907 440 1.073569 4.7237036 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 398 4.739999999999997e-106   NTclustered gi|226478901|emb|FN317215.1| 6182 g18019 i0 83.333 90.0795454545455 432 70 98 2 4 434 924 1354 Schistosoma japonicum isolate Anhui full length mRNA clone SJFCE0797|FSE_080_96_H12, complete sequence blastn 39635 398 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
7973045 7973045 PRJNA1186363_P_NODE_37187_length_260_cov_2.556150_g36299_i0 PRJNA1186363 37187 260 2.55615 6.64599 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 254 6.05e-63   NTclustered gi|1116517974|gb|AY485340.2| 6183 g36299 i0 87.33 142.819230769231 221 28 85 0 1 221 221 1 Schistosoma mansoni ubiquitin mRNA, partial cds blastn 37133 254 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
9247526 9247526 PRJNA1186363_P_NODE_11708_length_598_cov_1.036190_g10826_i0 PRJNA1186363 11708 598 1.03619 6.1964162 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 366 1.8599999999999993e-96   NTclustered gi|1369885|gb|L78441.1|SCM14332R 6183 g10826 i0 84.848 1.17725752508361 363 55 61 0 234 596 652 290 Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds blastn 704 366 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
10523346 10523346 PRJNA1186363_P_NODE_16309_length_484_cov_2.839416_g15422_i0 PRJNA1186363 16309 484 2.839416 13.74277344 Fasciola hepatica 6192 Platyhelminthes Platyhelminthes 392 2.4499999999999998e-104   NTclustered gi|323363238|emb|AM933586.2| 6192 g15422 i0 82.916 89.5681818181818 439 71 90 3 47 483 56 492 Fasciola hepatica mRNA for tubulin beta-2 (beta-tub2 gene) blastn 43351 392 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Fasciolidae Fasciola Fasciola hepatica
10523557 10523557 PRJNA1186363_P_NODE_6089_length_864_cov_1.908976_g5361_i0 PRJNA1186363 6089 864 1.908976 16.49355264 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 1040 0   NTclustered gi|1369885|gb|L78441.1|SCM14332R 6183 g5361 i0 88.354 52.8113425925926 893 68 100 14 1 864 895 10 Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds blastn 45629 1040 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
13795374 13795374 PRJNA1186363_P_NODE_35991_length_269_cov_1.653061_g35103_i0 PRJNA1186363 35991 269 1.653061 4.44673409 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 62.1 4.09e-5   NTclustered gi|690848374|emb|LN347297.1| 99802 g35103 i0 88.679 0.576208178438662 53 3 20 3 98 150 144 193 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0119228 blastn 155 62.1 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
15622566 15622566 PRJNA1186363_P_NODE_38193_length_253_cov_1.300000_g37305_i0 PRJNA1186363 38193 253 1.3 3.289 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 67.6 8.2e-7   NTclustered gi|1084305361|ref|XM_018790074.1| 6183 g37305 i0 95.238 3.57312252964427 42 2 17 0 170 211 936 895 Schistosoma mansoni putative rap gtpase-activating protein partial mRNA blastn 904 67.6 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
18171237 18171237 PRJNA1186363_P_NODE_11795_length_595_cov_1.408046_g10913_i0 PRJNA1186363 11795 595 1.408046 8.3778737 Schistosoma turkestanicum 1163369 Platyhelminthes Platyhelminthes 503 1.35e-137   NTclustered gi|66732686|gb|DQ017265.1| 1163369 g10913 i0 82.676 98.9865546218487 583 85 97 13 19 593 1171 597 Orientobilharzia turkestanicum actin mRNA, complete cds blastn 58897 503 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma turkestanicum
19445626 19445626 PRJNA1186363_P_NODE_10956_length_623_cov_1.681818_g10074_i0 PRJNA1186363 10956 623 1.681818 10.47772614 Schmidtea mediterranea 79327 Platyhelminthes Platyhelminthes 497 6.5999999999999996e-136   NTclustered gi|1929250148|gb|MT664960.1| 79327 g10074 i0 81.12 61.7223113964687 625 114 100 4 1 623 137 759 Schmidtea mediterranea protein phosphatase 1 catalytic subunit alpha (PPP1CA) mRNA, complete cds blastn 38453 497 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Schmidtea Schmidtea mediterranea
19445860 19445860 PRJNA1186363_P_NODE_4416_length_1000_cov_1.366775_g3809_i0 PRJNA1186363 4416 1000 1.366775 13.66775 Schistosoma mansoni 6183 Platyhelminthes Platyhelminthes 662 0   NTclustered gi|1369885|gb|L78441.1|SCM14332R 6183 g3809 i0 85.038 36.4 655 92 65 5 138 789 1 652 Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds blastn 36400 662 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
20721121 20721121 PRJNA1186363_P_NODE_29357_length_322_cov_1.164659_g28469_i0 PRJNA1186363 29357 322 1.1646590000000001 3.75020198 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 56.5 0.002   NTclustered gi|687181912|emb|LN133346.1| 99802 g28469 i0 100 0.180124223602484 30 0 9 0 33 62 1050 1079 Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0122998 blastn 58 56.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
21443929 21443929 PRJNA1186363_P_NODE_26317_length_350_cov_1.407942_g25429_i0 PRJNA1186363 26317 350 1.407942 4.927797 Metazoa 33208 Platyhelminthes Platyhelminthes 52.8 0.033   NTclustered gi|2318764739|ref|XM_012945703.3| 6185 g25429 i0 100 0.4 28 0 8 0 191 218 247 220 Schistosoma haematobium uncharacterized protein (MS3_00004896), partial mRNA blastn 140 52.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma haematobium

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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