RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA900028", tax_kingdom = "Metazoa" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 15 ✖

tax_kingdom 1

  • Metazoa · 15 ✖

tax_clade 1

bioproject 1

  • PRJNA900028 · 15 ✖
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
2150049 2150049 PRJNA900028_P_NODE_151922_length_164_cov_97.652174_g151173_i0 PRJNA900028 151922 164 97.652174 160.14956536 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 292 7.41e-75   NTclustered gi|56757963|gb|AY815390.1| 6182 g151173 i0 98.788 125.378048780488 165 1 100 1 1 164 1637 1801 Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds blastn 20562 292 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
7253455 7253455 PRJNA900028_P_NODE_26286_length_249_cov_1.495000_g25537_i0 PRJNA900028 26286 249 1.495 3.72255 Hymenolepis diminuta 6216 Platyhelminthes Platyhelminthes 416 6.939999999999999e-112   NTclustered gi|28273293|gb|AY157181.1| 6216 g25537 i0 97.177 72.6385542168675 248 4 99 1 2 249 2626 2382 Hymenolepis diminuta 28S large subunit ribosomal RNA gene, partial sequence blastn 18087 416 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Cyclophyllidea Hymenolepididae Hymenolepis Hymenolepis diminuta
12724883 12724883 PRJNA900028_P_NODE_40690_length_220_cov_1.175439_g39941_i0 PRJNA900028 40690 220 1.175439 2.5859658 Rhabdocoela 27901 Platyhelminthes Platyhelminthes 89.8 1.48e-13   NTclustered gi|14530151|emb|AJ315645.1| 84153 g39941 i0 86.585 16.6363636363636 82 10 37 1 69 149 837 918 Maehrenthalia agilis partial 28S rRNA gene blastn 3660 89.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Rhabdocoela Byrsophlebidae Maehrenthalia Maehrenthalia agilis
14903532 14903532 PRJNA900028_P_NODE_47652_length_211_cov_0.790123_g46903_i0 PRJNA900028 47652 211 0.790123 1.66715953 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 217 6.209999999999999e-52   NTclustered gi|60687997|gb|AY915111.1| 6182 g46903 i0 98.374 22.1611374407583 123 2 100 0 89 211 147 269 Schistosoma japonicum SJCHGC03023 protein mRNA, complete cds blastn 4676 217 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
17453551 17453551 PRJNA900028_P_NODE_2474_length_703_cov_2.207951_g1802_i0 PRJNA900028 2474 703 2.207951 15.52189553 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 590 1.1999999999999999e-163   NTclustered gi|60698656|gb|AY915745.1| 6182 g1802 i0 98.22 8.46799431009957 337 6 48 0 7 343 131 467 Schistosoma japonicum SJCHGC09658 protein mRNA, partial cds blastn 5953 590 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
23828190 23828190 PRJNA900028_P_NODE_799_length_1500_cov_12.394900_g108_i1 PRJNA900028 799 1500 12.3949 185.9235 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 1779 0   NTclustered gi|1124902734|gb|AY812498.2| 6182 g108 i1 98.801 56.7646666666667 1001 8 67 4 319 1318 1087 90 Schistosoma japonicum SJCHGC01615 protein mRNA, partial cds blastn 85147 1786 0.996080627099664 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
26675595 26675595 PRJNA900028_P_NODE_1141_length_1177_cov_2.769504_g631_i0 PRJNA900028 1141 1177 2.769504 32.59706208 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 208 3.85e-62   NR AAX25032.2 6182 g631 i0 60.4 0.502124044180119 197 68 50.2 3 680 90 1 187 AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] diamond 591 208 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
29045449 29045449 PRJNA900028_P_NODE_60728_length_196_cov_1.496599_g59979_i0 PRJNA900028 60728 196 1.496599 2.93333404 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 47.8 1.28e-4   NR AAX30334.2 6182 g59979 i0 75 0.489795918367347 32 8 49 0 101 196 1 32 AAX30334.2 SJCHGC03026 protein, partial [Schistosoma japonicum] diamond 96 47.8 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
30118878 30118878 PRJNA900028_P_NODE_6712_length_416_cov_3.125341_g5967_i0 PRJNA900028 6712 416 3.125341 13.00141856 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 49.7 4.25e-5   NR ABA40899.1 6182 g5967 i0 59 0.28125 39 14 26.7 1 43 153 4 42 ABA40899.1 SJCHGC09658 protein, partial [Schistosoma japonicum] diamond 117 49.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
30435213 30435213 PRJNA900028_P_NODE_153153_length_164_cov_1.400000_g152404_i0 PRJNA900028 153153 164 1.4 2.296 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 49.7 3.9e-6   NR AAX30332.1 6182 g152404 i0 58.1 0.567073170731707 31 13 56.7 0 70 162 12 42 AAX30332.1 SJCHGC03023 protein [Schistosoma japonicum] diamond 93 49.7 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
30940644 30940644 PRJNA900028_P_NODE_36694_length_226_cov_1.322034_g35945_i0 PRJNA900028 36694 226 1.322034 2.98779684 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 51.2 2.33e-6   NR AAX30968.2 6182 g35945 i0 74.2 0.411504424778761 31 8 41.2 0 226 134 48 78 AAX30968.2 SJCHGC09661 protein, partial [Schistosoma japonicum] diamond 93 51.2 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
31770137 31770137 PRJNA900028_P_NODE_113317_length_169_cov_1.700000_g112568_i0 PRJNA900028 113317 169 1.7 2.873 Metazoa 33208 Platyhelminthes Platyhelminthes 55.5 4.39e-7   NR VDN41092.1 60516 g112568 i0 59.5 3.17751479289941 42 17 74.6 0 160 35 129 170 VDN41092.1 unnamed protein product, partial [Dibothriocephalus latus] diamond 537 55.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Dibothriocephalus Dibothriocephalus latus
31801622 31801622 PRJNA900028_P_NODE_139977_length_166_cov_0.871795_g139228_i0 PRJNA900028 139977 166 0.871795 1.4471797 Metazoa 33208 Platyhelminthes Platyhelminthes 50.4 2.05e-5   NR KAF5399264.1 100268 g139228 i0 54.1 3.36144578313253 37 17 66.9 0 3 113 201 237 KAF5399264.1 Isochorismatase domain-containing protein 2 mitochondrial [Paragonimus heterotremus] diamond 558 50.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Troglotrematidae Paragonimus Paragonimus heterotremus
32174066 32174066 PRJNA900028_P_NODE_158198_length_164_cov_0.886957_g157449_i0 PRJNA900028 158198 164 0.886957 1.45460948 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 48.1 5.22e-5   NR AAX28478.2 6182 g157449 i0 91.3 1.68292682926829 23 2 42.1 0 70 2 78 100 AAX28478.2 SJCHGC03032 protein, partial [Schistosoma japonicum] diamond 276 48.1 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
32750127 32750127 PRJNA900028_P_NODE_70620_length_189_cov_1.392857_g69871_i0 PRJNA900028 70620 189 1.392857 2.63249973 Metazoa 33208 Platyhelminthes Platyhelminthes 42.4 0.0257   NR TNN18983.1 6182 g69871 i0 31.4 5.01587301587302 51 35 81 0 159 7 464 514 TNN18983.1 Serine/threonine-protein phosphatase with EF-hands 1 [Schistosoma japonicum] diamond 948 42.4 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);;