RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA473641" and tax_phylum = "Platyhelminthes"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Platyhelminthes · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA473641 · 15 ✖

analysis 1

  • diamond · 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
2370903 2370903 PRJNA473641_P_NODE_21042_length_247_cov_0.885057_g20959_i0 PRJNA473641 21042 247 0.885057 2.18609079 Platyhelminthes 6157 Platyhelminthes Platyhelminthes 159 7.809999999999999e-46   NR KAH8853046.1 6182 g20959 i0 95.1 7.87044534412955 81 4 98.4 0 245 3 71 151 KAH8853046.1 26S proteasome regulatory subunit 7 [Schistosoma japonicum] diamond 1944 159 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
8748434 8748434 PRJNA473641_P_NODE_15627_length_262_cov_1.629630_g15544_i0 PRJNA473641 15627 262 1.62963 4.2696306 Metazoa 33208 Platyhelminthes Platyhelminthes 143 1.22e-39   NR AWM96389.1 6161 g15544 i0 78.2 1.99236641221374 87 19 99.6 0 261 1 134 220 AWM96389.1 cathepsin L2 [Dugesia japonica] diamond 522 144 0.993055555555556 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Dugesia Dugesia japonica
11923753 11923753 PRJNA473641_P_NODE_23150_length_244_cov_0.900585_g23067_i0 PRJNA473641 23150 244 0.900585 2.1974274 Dugesia japonica 6161 Platyhelminthes Platyhelminthes 145 2.0599999999999998e-38   NR ACM91724.1 6161 g23067 i0 87.7 0.995901639344262 81 10 99.6 0 243 1 615 695 ACM91724.1 90 kDa heat shock protein [Dugesia japonica] diamond 243 145 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Dugesia Dugesia japonica
13198454 13198454 PRJNA473641_P_NODE_13871_length_278_cov_1.126829_g13788_i0 PRJNA473641 13871 278 1.126829 3.13258462 Schmidtea mediterranea 79327 Platyhelminthes Platyhelminthes 159 5.559999999999999e-46   NR AKN21598.1 79327 g13788 i0 87 0.992805755395683 92 12 99.3 0 2 277 89 180 AKN21598.1 slc25a-30 [Schmidtea mediterranea] diamond 276 159 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Schmidtea Schmidtea mediterranea
20846543 20846543 PRJNA473641_P_NODE_17497_length_251_cov_0.865169_g17414_i0 PRJNA473641 17497 251 0.865169 2.17157419 Trematoda 6178 Platyhelminthes Platyhelminthes 140 4.71e-41   NR KAH8872773.1 6182 g17414 i0 88 3.95617529880478 83 9 98 1 5 250 1 83 KAH8872773.1 40S ribosomal protein S14 [Schistosoma japonicum] diamond 993 140 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
26807638 26807638 PRJNA473641_P_NODE_9041_length_327_cov_1.818898_g8958_i0 PRJNA473641 9041 327 1.818898 5.94779646 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 61.6 1.68e-9   NR VDL93960.1 70667 g8958 i0 42 2.90825688073395 81 46 74.3 1 6 248 38 117 VDL93960.1 unnamed protein product [Schistocephalus solidus] diamond 951 61.6 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Schistocephalus Schistocephalus solidus
28402637 28402637 PRJNA473641_P_NODE_20926_length_247_cov_0.885057_g20843_i0 PRJNA473641 20926 247 0.885057 2.18609079 Cichlidogyrus casuarinus 1844966 Platyhelminthes Platyhelminthes 65.5 3.36e-10   NR KAL3311558.1 1844966 g20843 i0 44.4 1.73684210526316 72 38 85 2 221 12 1 72 KAL3311558.1 cAMP-dependent protein kinase type II-beta regulatory subunit [Cichlidogyrus casuarinus] diamond 429 65.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Monogenea Dactylogyridea Ancyrocephalidae Cichlidogyrus Cichlidogyrus casuarinus
28640032 28640032 PRJNA473641_P_NODE_20127_length_248_cov_0.880000_g20044_i0 PRJNA473641 20127 248 0.88 2.1824 Metazoa 33208 Platyhelminthes Platyhelminthes 97.4 2.33e-21   NR XP_018653986.1 6183 g20044 i0 56.3 11.9153225806452 80 32 93.1 1 248 18 506 585 XP_018653986.1 putative tolloid [Schistosoma mansoni] diamond 2955 97.4 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma mansoni
29081947 29081947 PRJNA473641_P_NODE_22668_length_245_cov_0.895349_g22585_i0 PRJNA473641 22668 245 0.895349 2.19360505 Fasciola 6191 Platyhelminthes Platyhelminthes 63.5 1.78e-9   NR THD24110.1 6192 g22585 i0 48.6 2.63265306122449 70 35 84.5 1 1 207 359 428 THD24110.1 Prominin-1-A [Fasciola hepatica] diamond 645 63.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Plagiorchiida Fasciolidae Fasciola Fasciola hepatica
29318194 29318194 PRJNA473641_P_NODE_23869_length_243_cov_0.905882_g23786_i0 PRJNA473641 23869 243 0.905882 2.20129326 Schmidtea mediterranea 79327 Platyhelminthes Platyhelminthes 55.5 5.93e-7   NR AFJ24792.1 79327 g23786 i0 32.9 1.4320987654321 73 45 90.1 1 220 2 79 147 AFJ24792.1 TNF receptor associated factor-2, partial [Schmidtea mediterranea] diamond 348 55.5 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Schmidtea Schmidtea mediterranea
29444329 29444329 PRJNA473641_P_NODE_15390_length_264_cov_1.612565_g15307_i0 PRJNA473641 15390 264 1.612565 4.2571716 Spirometra erinaceieuropaei 99802 Platyhelminthes Platyhelminthes 101 1.5199999999999995e-23   NR VZH89404.1 99802 g15307 i0 73.4 0.727272727272727 64 17 72.7 0 1 192 244 307 VZH89404.1 unnamed protein product [Spirometra erinaceieuropaei] diamond 192 101 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Cestoda Diphyllobothriidea Diphyllobothriidae Spirometra Spirometra erinaceieuropaei
30107694 30107694 PRJNA473641_P_NODE_4292_length_432_cov_2.339833_g4209_i0 PRJNA473641 4292 432 2.339833 10.10807856 Schistosoma japonicum 6182 Platyhelminthes Platyhelminthes 153 1.0099999999999999e-42   NR TNN11975.1 6182 g4209 i0 49.7 4.90277777777778 143 71 98.6 1 2 427 161 303 TNN11975.1 DM9 domain-containing protein [Schistosoma japonicum] diamond 2118 153 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Trematoda Strigeidida Schistosomatidae Schistosoma Schistosoma japonicum
31040504 31040504 PRJNA473641_P_NODE_22335_length_245_cov_0.895349_g22252_i0 PRJNA473641 22335 245 0.895349 2.19360505 Schmidtea 55270 Platyhelminthes Platyhelminthes 164 5.89e-46   NR ADC32283.1 50054 g22252 i0 100 1.98367346938776 81 0 99.2 0 3 245 439 519 ADC32283.1 dishevelled, partial [Schmidtea polychroa] diamond 486 164 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Tricladida Dugesiidae Schmidtea Schmidtea polychroa
31498467 31498467 PRJNA473641_P_NODE_2916_length_503_cov_1.830233_g2833_i0 PRJNA473641 2916 503 1.830233 9.20607199 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 71.6 2.11e-11   NR PAA76741.1 282301 g2833 i0 31.7 0.829025844930418 139 81 76.3 5 471 88 59 194 PAA76741.1 hypothetical protein BOX15_Mlig004002g2, partial [Macrostomum lignano] diamond 417 71.6 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano
32321148 32321148 PRJNA473641_P_NODE_14359_length_273_cov_2.300000_g14276_i0 PRJNA473641 14359 273 2.3 6.279 Macrostomum lignano 282301 Platyhelminthes Platyhelminthes 119 1.11e-32   NR PAA53120.1 282301 g14276 i0 55.6 0.989010989010989 90 40 98.9 0 3 272 9 98 PAA53120.1 hypothetical protein BOX15_Mlig018526g3 [Macrostomum lignano] diamond 270 119 1 Eukaryota Opisthokonta Metazoa Platyhelminthes Rhabditophora Macrostomida Macrostomidae Macrostomum Macrostomum lignano

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