RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where bioproject = "PRJNA1065838" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 19 ✖

tax_clade 1

bioproject 1

  • PRJNA1065838 · 19 ✖

tax_kingdom 0

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
179991 179991 PRJNA1065838_S_NODE_16001_length_214_cov_3.042424_g15899_i0 PRJNA1065838 16001 214 3.042424 6.51078736 Chilodonella piscicola 1654720 SAR_Eukaryotes SAR_Eukaryotes 335 1.6699999999999995e-87   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g15899 i0 94.86 6.00467289719626 214 11 100 0 1 214 119 332 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 1285 335 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
1012786 1012786 PRJNA1065838_S_NODE_7061_length_283_cov_4235.504274_g6959_i0 PRJNA1065838 7061 283 4235.504274 11986.47709542 Vorticella 60849 SAR_Eukaryotes SAR_Eukaryotes 381 2.929999999999999e-101   NTclustered gi|363412153|gb|JN120227.1| 60850 g6959 i0 100 72.791519434629 206 0 73 0 78 283 1458 1253 Vorticella convallaria isolate 96Vorsp16 18S ribosomal RNA gene, partial sequence blastn 20600 381 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella convallaria
1454603 1454603 PRJNA1065838_S_NODE_10622_length_241_cov_3.307292_g10520_i0 PRJNA1065838 10622 241 3.307292 7.97057372 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 418 1.8599999999999995e-112   NTclustered gi|10782|emb|X54004.1| 5908 g10520 i0 97.925 24.0912863070539 241 5 100 0 1 241 2179 1939 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 5806 418 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
1454737 1454737 PRJNA1065838_S_NODE_302_length_873_cov_24.893204_g237_i0 PRJNA1065838 302 873 24.893204 217.31767092 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 1543 0   NTclustered gi|512134943|gb|JX178902.1| 1295638 g237 i0 99.412 82.1237113402062 851 4 97 1 24 873 987 1837 Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 71694 1543 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
6115729 6115729 PRJNA1065838_S_NODE_3025_length_398_cov_5.071633_g2923_i0 PRJNA1065838 3025 398 5.071633 20.18509934 root 1 Root_unresolved Root_unresolved 713 0   NTclustered gi|345541658|gb|JN547815.1| 5911 g2923 i0 98.995 72.0979899497487 398 4 100 0 1 398 3409 3806 Tetrahymena thermophila strain ATCC 30382 18S ribosomal RNA gene, partial sequence; and internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence blastn 28695 713 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
7832762 7832762 PRJNA1065838_S_NODE_4627_length_336_cov_2.783972_g4525_i0 PRJNA1065838 4627 336 2.783972 9.35414592 Thuricola similis 2784598 SAR_Eukaryotes SAR_Eukaryotes 333 1.01e-86   NTclustered gi|2088246216|ref|NC_057079.1| 2784598 g4525 i0 85.981 45.0327380952381 321 33 94 10 1 315 12694 12380 Thuricola similis strain CUIT mitochondrion, complete genome blastn 15131 333 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vaginicolidae Thuricola Thuricola similis
12491282 12491282 PRJNA1065838_S_NODE_19330_length_204_cov_1.522581_g19228_i0 PRJNA1065838 19330 204 1.522581 3.10606524 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 364 2.0099999999999998e-96   NTclustered gi|1837628855|gb|MN158348.1| 5909 g19228 i0 99.015 76.6225490196078 203 2 99 0 2 204 2897 2695 Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 15631 364 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
15040308 15040308 PRJNA1065838_S_NODE_3392_length_382_cov_2.804805_g3290_i0 PRJNA1065838 3392 382 2.804805 10.7143551 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 608 1.719999999999999e-169   NTclustered gi|10782|emb|X54004.1| 5908 g3290 i0 99.112 76.4083769633508 338 3 88 0 23 360 1923 1586 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 29188 608 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
15482927 15482927 PRJNA1065838_S_NODE_4793_length_331_cov_8.943262_g4691_i0 PRJNA1065838 4793 331 8.943262 29.60219722 Vorticella sp. 1 2979179 SAR_Eukaryotes SAR_Eukaryotes 562 1.16e-155   NTclustered gi|2304601489|gb|OP458310.1| 2979179 g4691 i0 99.355 93.583081570997 310 2 94 0 1 310 1231 922 Vorticella sp. 1 large subunit ribosomal RNA gene, partial sequence blastn 30976 562 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 1
18863982 18863982 PRJNA1065838_S_NODE_20515_length_200_cov_3.807947_g20413_i0 PRJNA1065838 20515 200 3.807947 7.615894 root 1 Root_unresolved Root_unresolved 368 1.52e-97   NTclustered gi|10832|emb|X54512.1| 5911 g20413 i0 100 90.43 199 0 99 0 2 200 8316 8118 T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA blastn 18086 368 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
26963771 26963771 PRJNA1065838_S_NODE_32382_length_168_cov_0.873950_g32280_i0 PRJNA1065838 32382 168 0.87395 1.468236 Tetrahymenidae 291294 SAR_Eukaryotes SAR_Eukaryotes 65.5 1.65e-11   NR XP_004040069.1 5932 g32280 i0 58.7 1.64285714285714 46 19 82.1 0 138 1 72 117 XP_004040069.1 hypothetical protein IMG5_002370 [Ichthyophthirius multifiliis] diamond 276 65.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
27635935 27635935 PRJNA1065838_S_NODE_18464_length_207_cov_0.968354_g18362_i0 PRJNA1065838 18464 207 0.968354 2.00449278 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0323   NR XP_001024687.1 312017 g18362 i0 44.4 0.652173913043478 45 25 65.2 0 70 204 61 105 XP_001024687.1 hypothetical protein TTHERM_00616170 [Tetrahymena thermophila SB210] diamond 135 42.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29214751 29214751 PRJNA1065838_S_NODE_20669_length_200_cov_1.033113_g20567_i0 PRJNA1065838 20669 200 1.033113 2.066226 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 57 1.93e-7   NR XP_001021414.1 312017 g20567 i0 46.2 0.975 65 32 97.5 2 199 5 351 412 XP_001021414.1 acid ceramidase-like protein, putative [Tetrahymena thermophila SB210] diamond 195 57 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29237932 29237932 PRJNA1065838_S_NODE_22389_length_195_cov_1.308219_g22287_i0 PRJNA1065838 22389 195 1.308219 2.55102705 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 73.6 2.11e-14   NR XP_004040150.1 5932 g22287 i0 50.8 9.96923076923077 65 32 100 0 195 1 46 110 XP_004040150.1 hypothetical protein IMG5_000740 [Ichthyophthirius multifiliis] diamond 1944 73.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
29364231 29364231 PRJNA1065838_S_NODE_29169_length_175_cov_1.507937_g29067_i0 PRJNA1065838 29169 175 1.507937 2.63888975 Sporadotrichida 693921 SAR_Eukaryotes SAR_Eukaryotes 54.3 1.2e-6   NR CDW74325.1 5949 g29067 i0 65.7 2.58857142857143 35 12 60 0 69 173 481 515 CDW74325.1 pyridine nucleotide-disulfide oxidoreductase family protein [Stylonychia lemnae] diamond 453 54.7 0.992687385740402 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
30952002 30952002 PRJNA1065838_S_NODE_28874_length_176_cov_1.228346_g28772_i0 PRJNA1065838 28874 176 1.228346 2.16188896 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 54.7 8.97e-7   NR CAD8084114.1 65129 g28772 i0 47.4 0.971590909090909 57 30 97.2 0 171 1 138 194 CAD8084114.1 unnamed protein product [Paramecium sonneborni] diamond 171 54.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
31299421 31299421 PRJNA1065838_S_NODE_31755_length_169_cov_0.866667_g31653_i0 PRJNA1065838 31755 169 0.866667 1.46466723 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 85.1 1.98e-19   NR CAD8083909.1 5886 g31653 i0 65.5 1.95266272189349 55 19 97.6 0 167 3 58 112 CAD8083909.1 unnamed protein product [Paramecium primaurelia] diamond 330 85.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
31520992 31520992 PRJNA1065838_S_NODE_29196_length_175_cov_1.238095_g29094_i0 PRJNA1065838 29196 175 1.238095 2.16666625 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 109 3.91e-26   NR KRX08977.1 266149 g29094 i0 91.4 13.92 58 5 99.4 0 174 1 561 618 KRX08977.1 P-loop containing nucleoside triphosphate hydrolase [Pseudocohnilembus persalinus] diamond 2436 109 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
32722375 32722375 PRJNA1065838_S_NODE_23220_length_193_cov_1.305556_g23118_i0 PRJNA1065838 23220 193 1.305556 2.51972308 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 62.4 2.26e-9   NR KRW98125.1 266149 g23118 i0 42.2 1.95854922279793 64 37 99.5 0 1 192 437 500 KRW98125.1 P-loop containing nucleoside triphosphate hydrolase [Pseudocohnilembus persalinus] diamond 378 62.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus

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