RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA1069776", 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 · 18 ✖

tax_kingdom 1

tax_clade 1

  • Opisthokonta · 18 ✖

bioproject 1

  • PRJNA1069776 · 18 ✖
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
2735654 2735654 PRJNA1069776_S_NODE_6443_length_348_cov_962.157377_g6129_i0 PRJNA1069776 6443 348 962.157377 3348.30767196 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 320 8.18e-83   NTclustered gi|56757963|gb|AY815390.1| 6182 g6129 i0 97.849 129.295977011494 186 3 100 1 164 348 1720 1905 Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds blastn 44995 320 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
4011058 4011058 PRJNA1069776_S_NODE_16184_length_257_cov_3.682243_g15870_i0 PRJNA1069776 16184 257 3.682243 9.46336451 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 263 9.92e-66   NTclustered gi|60700756|gb|AY915859.1| 6182 g15870 i0 91.192 2.22178988326848 193 17 75 0 40 232 193 1 Schistosoma japonicum SJCHGC09793 protein mRNA, complete cds blastn 571 263 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
5287613 5287613 PRJNA1069776_S_NODE_33165_length_188_cov_6.179310_g32851_i0 PRJNA1069776 33165 188 6.17931 11.6171028 Monotoplana cf. diorchis 104924 Platyhelminthes Platyhelminthes 73.1 1.24e-8   NTclustered gi|10944981|emb|AJ270174.1| 104924 g32851 i0 100 20.7340425531915 39 0 21 0 85 123 1633 1595 Monotoplana cf. diorchis partial 28S rRNA gene blastn 3898 73.1 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Proseriata Monotoplanidae Monotoplana Monotoplana cf. diorchis
9112661 9112661 PRJNA1069776_S_NODE_6728_length_344_cov_1245.382060_g6414_i0 PRJNA1069776 6728 344 1245.38206 4284.1142864 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 318 2.909999999999999e-82   NTclustered gi|56757963|gb|AY815390.1| 6182 g6414 i0 98.352 132.212209302326 182 2 100 1 1 181 1905 1724 Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds blastn 45481 318 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
10388151 10388151 PRJNA1069776_S_NODE_41349_length_170_cov_4.535433_g41035_i0 PRJNA1069776 41349 170 4.535433 7.7102361 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 215 1.71e-51   NTclustered gi|60691997|gb|AY915382.1| 6182 g41035 i0 89.412 23.1882352941176 170 18 100 0 1 170 183 352 Schistosoma japonicum SJCHGC05510 protein mRNA, partial cds blastn 3942 215 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
12938425 12938425 PRJNA1069776_S_NODE_22711_length_222_cov_7.178771_g22397_i0 PRJNA1069776 22711 222 7.178771 15.93687162 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 315 2.27e-81   NTclustered gi|60698688|gb|AY915747.1| 6182 g22397 i0 93.81 2.28378378378378 210 12 96 1 14 222 296 87 Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds blastn 507 315 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
26877771 26877771 PRJNA1069776_S_NODE_45941_length_162_cov_4.436975_g45627_i0 PRJNA1069776 45941 162 4.436975 7.1878995 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 70.9 7.31e-14   NR AAX28478.2 6182 g45627 i0 74.5 2.53703703703704 47 11 85.2 1 24 161 78 124 AAX28478.2 SJCHGC03032 protein, partial [Schistosoma japonicum] diamond 411 71.6 0.990223463687151 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
26909205 26909205 PRJNA1069776_S_NODE_5842_length_358_cov_16.076190_g5528_i0 PRJNA1069776 5842 358 16.07619 57.5527602 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 49.7 2.62e-5   NR ABA40899.1 6182 g5528 i0 59 0.326815642458101 39 14 31 1 98 208 4 42 ABA40899.1 SJCHGC09658 protein, partial [Schistosoma japonicum] diamond 117 49.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
27288578 27288578 PRJNA1069776_S_NODE_9123_length_316_cov_4.043956_g8809_i0 PRJNA1069776 9123 316 4.043956 12.77890096 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 95.9 8.6e-23   NR AAX28478.2 6182 g8809 i0 60.7 0.79746835443038 84 28 75 1 19 255 11 94 AAX28478.2 SJCHGC03032 protein, partial [Schistosoma japonicum] diamond 252 95.9 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
27699505 27699505 PRJNA1069776_S_NODE_23864_length_218_cov_2.971429_g23550_i0 PRJNA1069776 23864 218 2.971429 6.47771522 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 134 2.14e-39   NR AAX31108.1 6182 g23550 i0 95.8 0.990825688073395 72 0 99.1 1 3 218 8 76 AAX31108.1 SJCHGC09823 protein [Schistosoma japonicum] diamond 216 134 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
27699507 27699507 PRJNA1069776_S_NODE_41484_length_170_cov_3.023622_g41170_i0 PRJNA1069776 41484 170 3.023622 5.1401574 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 42 0.0263   NR AAX28387.3 6182 g41170 i0 73.1 2.27647058823529 26 7 45.9 0 82 5 93 118 AAX28387.3 SJCHGC01615 protein, partial [Schistosoma japonicum] diamond 387 42 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
28046441 28046441 PRJNA1069776_S_NODE_42945_length_167_cov_5.322581_g42631_i0 PRJNA1069776 42945 167 5.322581 8.88871027 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 72.4 1.38e-14   NR AAX24812.2 6182 g42631 i0 79.5 0.70059880239521 39 8 70.1 0 163 47 19 57 AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] diamond 117 72.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
29435449 29435449 PRJNA1069776_S_NODE_41910_length_169_cov_4.571429_g41596_i0 PRJNA1069776 41910 169 4.571429 7.72571501 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 61.6 1.51e-10   NR AAX30331.2 6182 g41596 i0 70 1.66863905325444 40 12 71 0 2 121 15 54 AAX30331.2 SJCHGC03022 protein, partial [Schistosoma japonicum] diamond 282 61.6 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
29498834 29498834 PRJNA1069776_S_NODE_32030_length_191_cov_4.750000_g31716_i0 PRJNA1069776 32030 191 4.75 9.0725 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 62.4 5.63e-10   NR AAX25032.2 6182 g31716 i0 58.9 1.71204188481675 56 23 88 0 14 181 120 175 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 327 62.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
30225295 30225295 PRJNA1069776_S_NODE_16212_length_257_cov_3.168224_g15898_i0 PRJNA1069776 16212 257 3.168224 8.14233568 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 59.3 1.96e-8   NR AAX25032.2 6182 g15898 i0 58.3 1.03891050583658 48 20 56 0 155 12 121 168 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 267 59.7 0.993299832495812 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
30572628 30572628 PRJNA1069776_S_NODE_30633_length_195_cov_3.289474_g30319_i0 PRJNA1069776 30633 195 3.289474 6.4144743 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 80.9 9.35e-18   NR AAX24812.2 6182 g30319 i0 78.7 2.26153846153846 47 10 72.3 0 193 53 12 58 AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] diamond 441 80.9 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
31932173 31932173 PRJNA1069776_S_NODE_34857_length_184_cov_3.404255_g34543_i0 PRJNA1069776 34857 184 3.404255 6.2638292 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 75.9 1.58e-15   NR AAX25839.2 6182 g34543 i0 66.7 0.880434782608696 54 17 88 1 163 2 40 92 AAX25839.2 SJCHGC09516 protein, partial [Schistosoma japonicum] diamond 162 75.9 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
32185507 32185507 PRJNA1069776_S_NODE_19678_length_237_cov_2.943299_g19364_i0 PRJNA1069776 19678 237 2.943299 6.97561863 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 56.2 2.32e-7   NR AAX25032.2 6182 g19364 i0 85.2 0.341772151898734 27 4 34.2 0 67 147 91 117 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 81 56.2 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);;