RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA1093008" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1093008 · 16 ✖

analysis 1

  • diamond · 16 ✖
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
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);;