RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where bioproject = "PRJNA1093008", tax_clade = "Opisthokonta" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 30 ✖

tax_kingdom 1

tax_clade 1

  • Opisthokonta · 30 ✖

bioproject 1

  • PRJNA1093008 · 30 ✖
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
1473522 1473522 PRJNA1093008_S_NODE_87742_length_246_cov_8.219653_g87415_i0 PRJNA1093008 87742 246 8.219653 20.22034638 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 392 1.15e-104   NTclustered gi|56757963|gb|AY815390.1| 6182 g87415 i0 96.653 115.719512195122 239 2 99 2 5 243 2533 2301 Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds blastn 28467 392 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
5301478 5301478 PRJNA1093008_S_NODE_49485_length_295_cov_1.387387_g49158_i0 PRJNA1093008 49485 295 1.387387 4.09279165 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 100 9.64e-17   NTclustered gi|1124902734|gb|AY812498.2| 6182 g49158 i0 100 18.3050847457627 54 0 18 0 219 272 1107 1160 Schistosoma japonicum SJCHGC01615 protein mRNA, partial cds blastn 5400 100 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
6576244 6576244 PRJNA1093008_S_NODE_101326_length_213_cov_432.428571_g100999_i0 PRJNA1093008 101326 213 432.428571 921.07285623 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 213 8.13e-51   NTclustered gi|56757963|gb|AY815390.1| 6182 g100999 i0 100 78.4976525821596 115 0 100 0 1 115 1380 1266 Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds blastn 16720 213 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
6576246 6576246 PRJNA1093008_S_NODE_101666_length_206_cov_440.383459_g101339_i0 PRJNA1093008 101666 206 440.383459 907.18992554 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 359 9.47e-95   NTclustered gi|56757963|gb|AY815390.1| 6182 g101339 i0 98.058 124.912621359223 206 4 100 0 1 206 1715 1920 Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds blastn 25732 359 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
10401903 10401903 PRJNA1093008_S_NODE_47509_length_298_cov_2.804444_g47182_i0 PRJNA1093008 47509 298 2.804444 8.35724312 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 67.6 9.89e-7   NTclustered gi|56757963|gb|AY815390.1| 6182 g47182 i0 97.5 9.59060402684564 40 0 13 1 1 39 435 396 Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds blastn 2858 67.6 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
10402283 10402283 PRJNA1093008_S_NODE_96689_length_239_cov_163.289157_g96362_i0 PRJNA1093008 96689 239 163.289157 390.26108523 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 363 8.74e-96   NTclustered gi|56757963|gb|AY815390.1| 6182 g96362 i0 98.086 110.581589958159 209 3 90 1 32 239 1712 1920 Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds blastn 26429 363 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
15501039 15501039 PRJNA1093008_S_NODE_101373_length_212_cov_463.028777_g101046_i0 PRJNA1093008 101373 212 463.028777 981.62100724 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 387 4.5e-103   NTclustered gi|56757963|gb|AY815390.1| 6182 g101046 i0 99.531 123.646226415094 213 0 100 1 1 212 1494 1282 Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds blastn 26213 387 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
15501045 15501045 PRJNA1093008_S_NODE_11033_length_432_cov_93.479109_g10707_i0 PRJNA1093008 11033 432 93.479109 403.82975088 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 678 0   NTclustered gi|56757963|gb|AY815390.1| 6182 g10707 i0 96.181 113.263888888889 419 8 95 2 22 432 1191 1609 Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds blastn 48930 678 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
19324710 19324710 PRJNA1093008_S_NODE_96376_length_240_cov_138.125749_g96049_i0 PRJNA1093008 96376 240 138.125749 331.5017976 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 370 5.249999999999999e-98   NTclustered gi|56757963|gb|AY815390.1| 6182 g96049 i0 98.565 110.241666666667 209 3 90 0 32 240 1712 1920 Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds blastn 26458 370 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
20599393 20599393 PRJNA1093008_S_NODE_101717_length_205_cov_387.734848_g101390_i0 PRJNA1093008 101717 205 387.734848 794.8564384 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 361 2.62e-95   NTclustered gi|56757963|gb|AY815390.1| 6182 g101390 i0 98.537 125.380487804878 205 1 100 1 1 205 2028 1826 Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds blastn 25703 361 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
20599759 20599759 PRJNA1093008_S_NODE_60557_length_277_cov_2.264706_g60230_i0 PRJNA1093008 60557 277 2.264706 6.27323562 Schistosoma haematobium 6185 Platyhelminthes Platyhelminthes 54.7 0.007   NTclustered gi|2318763589|ref|XM_012939013.2| 6185 g60230 i0 92.308 0.140794223826715 39 1 13 2 108 144 480 518 Schistosoma haematobium uncharacterized protein (MS3_00006885), mRNA blastn 39 54.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma haematobium
21875212 21875212 PRJNA1093008_S_NODE_101558_length_208_cov_484.555556_g101231_i0 PRJNA1093008 101558 208 484.555556 1007.87555648 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 361 2.67e-95   NTclustered gi|56757963|gb|AY815390.1| 6182 g101231 i0 97.653 125.403846153846 213 0 100 1 1 208 1282 1494 Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds blastn 26084 361 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
23151066 23151066 PRJNA1093008_S_NODE_70099_length_264_cov_2.853403_g69772_i0 PRJNA1093008 70099 264 2.853403 7.53298392 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 359 1.27e-94   NTclustered gi|56757963|gb|AY815390.1| 6182 g69772 i0 94.468 101.643939393939 235 10 89 3 9 240 974 740 Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds blastn 26834 359 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
23151179 23151179 PRJNA1093008_S_NODE_83619_length_249_cov_6.619318_g83292_i0 PRJNA1093008 83619 249 6.619318 16.48210182 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 427 3.2e-115   NTclustered gi|60698688|gb|AY915747.1| 6182 g83292 i0 97.6 2.50602409638554 250 4 99 1 1 248 148 397 Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds blastn 624 427 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
26750688 26750688 PRJNA1093008_S_NODE_92301_length_243_cov_1.847059_g91974_i0 PRJNA1093008 92301 243 1.847059 4.48835337 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 91.3 4.32e-22   NR AAX31080.1 6182 g91974 i0 79.6 0.666666666666667 54 11 66.7 0 82 243 1 54 AAX31080.1 SJCHGC09793 protein [Schistosoma japonicum] diamond 162 91.3 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
27636408 27636408 PRJNA1093008_S_NODE_29944_length_338_cov_2.026415_g29617_i0 PRJNA1093008 29944 338 2.026415 6.8492827 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 56.2 7.11e-7   NR AAX25032.2 6182 g29617 i0 56.4 0.985207100591716 55 24 48.8 0 338 174 133 187 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 333 56.2 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
28520428 28520428 PRJNA1093008_S_NODE_40227_length_313_cov_1.283333_g39900_i0 PRJNA1093008 40227 313 1.283333 4.01683229 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 92 3.78e-19   NR AAX28387.3 6182 g39900 i0 78 3.95846645367412 59 13 56.5 0 312 136 331 389 AAX28387.3 SJCHGC01615 protein, partial [Schistosoma japonicum] diamond 1239 92 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
29530763 29530763 PRJNA1093008_S_NODE_20490_length_372_cov_1.257525_g20163_i0 PRJNA1093008 20490 372 1.257525 4.677993 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 59.3 2.11e-8   NR AAX24812.2 6182 g20163 i0 64.4 0.362903225806452 45 9 30.6 1 125 238 12 56 AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] diamond 135 59.3 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
29719882 29719882 PRJNA1093008_S_NODE_59290_length_279_cov_1.868932_g58963_i0 PRJNA1093008 59290 279 1.868932 5.21432028 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 84 6.97e-19   NR AAX30341.2 6182 g58963 i0 61 0.827956989247312 77 19 73.1 2 6 209 4 78 AAX30341.2 SJCHGC03035 protein [Schistosoma japonicum] diamond 231 84 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
29972795 29972795 PRJNA1093008_S_NODE_56751_length_283_cov_1.466667_g56424_i0 PRJNA1093008 56751 283 1.466667 4.15066761 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 72.4 6.4e-14   NR AAX24812.2 6182 g56424 i0 66 1.04946996466431 50 17 53 0 95 244 8 57 AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] diamond 297 72.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
30099026 30099026 PRJNA1093008_S_NODE_101992_length_200_cov_233.842520_g101665_i0 PRJNA1093008 101992 200 233.84252 467.68504 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 66.6 5.06e-12   NR AAW27122.1 6182 g101665 i0 90.6 1.05 32 3 48 0 17 112 18 49 AAW27122.1 SJCHGC01951 protein [Schistosoma japonicum] diamond 210 66.6 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
30415498 30415498 PRJNA1093008_S_NODE_4793_length_551_cov_2.182008_g4480_i0 PRJNA1093008 4793 551 2.182008 12.02286408 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 179 9.05e-54   NR AAX25032.2 6182 g4480 i0 85.3 0.55535390199637 102 15 55.5 0 381 76 86 187 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 306 179 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
30636105 30636105 PRJNA1093008_S_NODE_90713_length_244_cov_2.701754_g90386_i0 PRJNA1093008 90713 244 2.701754 6.59227976 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 85.5 2.7e-19   NR AAX24812.2 6182 g90386 i0 71.2 1.34016393442623 52 15 63.9 0 36 191 1 52 AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] diamond 327 85.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
30731068 30731068 PRJNA1093008_S_NODE_45434_length_302_cov_1.777293_g45107_i0 PRJNA1093008 45434 302 1.777293 5.36742486 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 112 4.65e-30   NR AAX31108.1 6182 g45107 i0 88.2 0.675496688741722 68 5 67.5 1 97 300 1 65 AAX31108.1 SJCHGC09823 protein [Schistosoma japonicum] diamond 204 112 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
30984033 30984033 PRJNA1093008_S_NODE_44234_length_304_cov_3.000000_g43907_i0 PRJNA1093008 44234 304 3 9.12 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 79.7 1.99e-16   NR AAX30334.2 6182 g43907 i0 80.4 1.01644736842105 51 10 50.3 0 77 229 94 144 AAX30334.2 SJCHGC03026 protein, partial [Schistosoma japonicum] diamond 309 79.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
31647659 31647659 PRJNA1093008_S_NODE_21817_length_366_cov_2.170648_g21490_i0 PRJNA1093008 21817 366 2.170648 7.94457168 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 123 1.1399999999999999e-32   NR AAX25032.2 6182 g21490 i0 65.7 0.811475409836066 99 34 81.1 0 341 45 89 187 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 297 123 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
32059042 32059042 PRJNA1093008_S_NODE_61838_length_275_cov_3.153465_g61511_i0 PRJNA1093008 61838 275 3.153465 8.67202875 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 112 4.24e-29   NR AAX25032.2 6182 g61511 i0 83.1 0.709090909090909 65 11 70.9 0 246 52 123 187 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 195 112 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
32090783 32090783 PRJNA1093008_S_NODE_78478_length_254_cov_1.834254_g78151_i0 PRJNA1093008 78478 254 1.834254 4.65900516 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 120 5.33e-32   NR AAX25963.2 6182 g78151 i0 93.1 0.68503937007874 58 4 68.5 0 9 182 83 140 AAX25963.2 SJCHGC04741 protein, partial [Schistosoma japonicum] diamond 174 120 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
32090786 32090786 PRJNA1093008_S_NODE_90678_length_244_cov_2.994152_g90351_i0 PRJNA1093008 90678 244 2.994152 7.30573088 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 80.5 1.21e-16   NR AAX25032.2 6182 g90351 i0 60.6 1.40163934426229 71 28 87.3 0 244 32 114 184 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 342 80.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
32691167 32691167 PRJNA1093008_S_NODE_1100_length_899_cov_9.127119_g903_i0 PRJNA1093008 1100 899 9.127119 82.05279981 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 49.7 2.97e-4   NR ABA40899.1 6182 g903 i0 59 0.13014460511679601 39 14 12.3 1 371 261 4 42 ABA40899.1 SJCHGC09658 protein, partial [Schistosoma japonicum] diamond 117 49.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum

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