RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "blastn", bioproject = "PRJEB1404" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 28 ✖

tax_clade 1

bioproject 1

  • PRJEB1404 · 28 ✖

analysis 1

  • blastn · 28 ✖

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
2260995 2260995 PRJEB1404_P_NODE_242_length_479_cov_35.625000_g224_i0 PRJEB1404 242 479 35.625 170.64375 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 852 0   NTclustered gi|1837628855|gb|MN158348.1| 5909 g224 i0 99.154 92.4843423799582 473 4 99 0 5 477 3076 2604 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 44300 859 0.991850989522701 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
2261001 2261001 PRJEB1404_S_NODE_362_length_371_cov_499.220238_g342_i0 PRJEB1404 362 371 499.220238 1852.10708298 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 579 1.3099999999999997e-160   NTclustered gi|1837628855|gb|MN158348.1| 5909 g342 i0 99.684 84.088948787062 316 1 85 0 1 316 2652 2967 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 31197 579 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
3847308 3847308 PRJEB1404_S_NODE_1324_length_257_cov_11.662162_g1304_i0 PRJEB1404 1324 257 11.662162 29.97175634 Tetrahymena pigmentosa 5907 SAR_Eukaryotes SAR_Eukaryotes 346 9.579999999999999e-91   NTclustered gi|114329902|ref|NC_008339.1| 5907 g1304 i0 91.085 24.6575875486381 258 19 100 3 1 257 1628 1882 Tetrahymena pigmentosa mitochondrion, complete genome blastn 6337 346 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pigmentosa
4813562 4813562 PRJEB1404_S_NODE_2264_length_212_cov_27.497175_g2244_i0 PRJEB1404 2264 212 27.497175 58.294011 root 1 Root_unresolved Root_unresolved 298 2.17e-76   NTclustered gi|1837628855|gb|MN158348.1| 5909 g2244 i0 100 76.7264150943396 161 0 76 0 52 212 4079 3919 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 16266 298 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
4813564 4813564 PRJEB1404_S_NODE_3764_length_167_cov_2.424242_g3744_i0 PRJEB1404 3764 167 2.424242 4.04848414 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 291 2.7299999999999993e-74   NTclustered gi|114329902|ref|NC_008339.1| 5907 g3744 i0 98.204 83.9281437125749 167 2 100 1 1 167 1504 1339 Tetrahymena pigmentosa mitochondrion, complete genome blastn 14016 292 0.996575342465753 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pigmentosa
4813565 4813565 PRJEB1404_S_NODE_384_length_367_cov_499.478916_g364_i0 PRJEB1404 384 367 499.478916 1833.08762172 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 588 2.1499999999999994e-163   NTclustered gi|1837628855|gb|MN158348.1| 5909 g364 i0 97.935 91.149863760218 339 7 92 0 1 339 2652 2990 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 33452 588 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
5123491 5123491 PRJEB1404_S_NODE_25_length_680_cov_75.176744_g13_i0 PRJEB1404 25 680 75.176744 511.2018592 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 824 0   NTclustered gi|512134943|gb|JX178902.1| 1295638 g13 i0 98.298 65.0044117647059 470 8 69 0 211 680 1416 947 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 44203 824 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
5123495 5123495 PRJEB1404_S_NODE_3085_length_184_cov_1.255034_g3065_i0 PRJEB1404 3085 184 1.255034 2.30926256 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 217 5.26e-52   NTclustered gi|829169862|ref|XM_001015607.3| 312017 g3065 i0 92.208 0.83695652173913 154 10 83 2 31 183 294 142 Tetrahymena thermophila SB210 60S ribosomal protein L37a partial mRNA blastn 154 217 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
6399234 6399234 PRJEB1404_P_NODE_246_length_477_cov_29.715247_g228_i0 PRJEB1404 246 477 29.715247 141.74172819 Chilodonella piscicola 1654720 SAR_Eukaryotes SAR_Eukaryotes 649 0   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g228 i0 94.737 90.4465408805032 418 20 87 2 59 475 417 1 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 43143 649 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
6399239 6399239 PRJEB1404_S_NODE_2886_length_189_cov_626.240260_g2866_i0 PRJEB1404 2886 189 626.24026 1183.5940914 Tetrahymena pigmentosa 5907 SAR_Eukaryotes SAR_Eukaryotes 233 5.399999999999999e-57   NTclustered gi|114329902|ref|NC_008339.1| 5907 g2866 i0 96.454 32.8518518518519 141 5 75 0 1 141 1812 1672 Tetrahymena pigmentosa mitochondrion, complete genome blastn 6209 233 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pigmentosa
7673302 7673302 PRJEB1404_S_NODE_427_length_357_cov_224.531056_g407_i0 PRJEB1404 427 357 224.531056 801.57586992 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 623 5.709999999999999e-174   NTclustered gi|10782|emb|X54004.1| 5908 g407 i0 99.706 57.375350140056 340 1 95 0 1 340 3284 2945 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 20483 623 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
8638796 8638796 PRJEB1404_P_NODE_4547_length_161_cov_1.723077_g4521_i0 PRJEB1404 4547 161 1.723077 2.77415397 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 198 1.6199999999999999e-46   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g4521 i0 97.414 3.83850931677019 116 3 72 0 46 161 3082 2967 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 618 198 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
8638801 8638801 PRJEB1404_S_NODE_287_length_391_cov_19.727528_g267_i0 PRJEB1404 287 391 19.727528 77.13463448 root 1 Root_unresolved Root_unresolved 701 0   NTclustered gi|345541658|gb|JN547815.1| 5911 g267 i0 98.977 69.6010230179028 391 4 100 0 1 391 3417 3807 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 27214 701 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
8948074 8948074 PRJEB1404_S_NODE_2748_length_194_cov_3.672956_g2728_i0 PRJEB1404 2748 194 3.672956 7.12553464 Tetrahymena rostrata 5909 SAR_Eukaryotes SAR_Eukaryotes 326 8.94e-85   NTclustered gi|1837628855|gb|MN158348.1| 5909 g2728 i0 96.907 84.3556701030928 194 6 100 0 1 194 2010 2203 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 16365 326 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
11189049 11189049 PRJEB1404_S_NODE_1849_length_231_cov_10.214286_g1829_i0 PRJEB1404 1849 231 10.214286 23.59500066 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 427 2.9399999999999998e-115   NTclustered gi|1172880852|gb|KY864168.1| 5909 g1829 i0 100 99.995670995671 231 0 100 0 1 231 141 371 Tetrahymena rostrata isolate TR small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 23099 427 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
13739145 13739145 PRJEB1404_P_NODE_3911_length_178_cov_2.605442_g3885_i0 PRJEB1404 3911 178 2.605442 4.63768676 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 309 8.09e-80   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g3885 i0 98.844 69.4606741573034 173 2 97 0 6 178 2649 2477 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 12364 309 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
14049216 14049216 PRJEB1404_P_NODE_372_length_430_cov_7.882206_g352_i0 PRJEB1404 372 430 7.882206 33.8934858 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 518 3.3999999999999996e-142   NTclustered gi|512134943|gb|JX178902.1| 1295638 g352 i0 97.987 69.7255813953488 298 6 69 0 3 300 1119 1416 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 29982 518 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
15013562 15013562 PRJEB1404_S_NODE_2332_length_210_cov_4.365714_g2312_i0 PRJEB1404 2332 210 4.365714 9.1679994 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 388 1.24e-103   NTclustered gi|10853|emb|X56168.1| 5912 g2312 i0 100 99.9952380952381 210 0 100 0 1 210 816 607 T.tropicalis gene for small subunit ribosomal RNA (16S like rRNA) blastn 20999 388 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena tropicalis
16288412 16288412 PRJEB1404_S_NODE_4593_length_153_cov_1.016949_g4573_i0 PRJEB1404 4593 153 1.016949 1.55593197 Sessilida 1974272 SAR_Eukaryotes SAR_Eukaryotes 283 4.0799999999999995e-72   NTclustered gi|363412153|gb|JN120227.1| 60850 g4573 i0 100 100 153 0 100 0 1 153 612 764 Vorticella convallaria isolate 96Vorsp16 18S ribosomal RNA gene, partial sequence blastn 15300 283 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella convallaria
17563559 17563559 PRJEB1404_S_NODE_1094_length_272_cov_303.518987_g1074_i0 PRJEB1404 1094 272 303.518987 825.57164464 root 1 Root_unresolved Root_unresolved 388 1.67e-103   NTclustered gi|10832|emb|X54512.1| 5911 g1074 i0 99.078 68.9227941176471 217 1 79 1 40 255 8331 8115 T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA blastn 18747 388 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
19146613 19146613 PRJEB1404_S_NODE_3916_length_164_cov_2.620155_g3896_i0 PRJEB1404 3916 164 2.620155 4.2970542 Tetrahymena furgasoni 5898 SAR_Eukaryotes SAR_Eukaryotes 279 5.77e-71   NTclustered gi|1268580094|gb|KY218574.1| 5898 g3896 i0 100 87.5060975609756 151 0 92 0 14 164 565 415 Tetrahymena furgasoni isolate 20749-1 small subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 14351 279 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena furgasoni
20112289 20112289 PRJEB1404_S_NODE_2356_length_209_cov_52.706897_g2336_i0 PRJEB1404 2356 209 52.706897 110.15741473 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 383 5.72e-102   NTclustered gi|1621572405|gb|MH051920.1| 5893 g2336 i0 100 99.0478468899522 207 0 99 0 3 209 262 468 Tetrahymena borealis strain 1630/5A small subunit ribosomal RNA gene, partial sequence blastn 20701 383 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena borealis
20421773 20421773 PRJEB1404_S_NODE_2277_length_212_cov_2.033898_g2257_i0 PRJEB1404 2277 212 2.033898 4.31186376 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 259 1.02e-64   NTclustered gi|10790|emb|X12767.1| 5908 g2257 i0 88.991 13.0330188679245 218 13 100 10 1 212 1536 1748 Tetrahymena pyriformis alpha-tubulin gene blastn 2763 259 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
21387839 21387839 PRJEB1404_S_NODE_1797_length_233_cov_1126.136364_g1777_i0 PRJEB1404 1797 233 1126.136364 2623.89772812 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 287 5.25e-73   NTclustered gi|2001232452|gb|MW727123.1| 5893 g1777 i0 100 66.5236051502146 155 0 67 0 79 233 286 132 Tetrahymena borealis isolate 20766-1 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene, complete sequence; and internal transcribed spacer 2, partial sequence; macronuclear blastn 15500 287 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena borealis
21387841 21387841 PRJEB1404_S_NODE_2417_length_207_cov_2.040698_g2397_i0 PRJEB1404 2417 207 2.040698 4.22424486 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 209 1.02e-49   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g2397 i0 96.8 1.81159420289855 125 4 60 0 1 125 2958 3082 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 375 209 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
23938064 23938064 PRJEB1404_P_NODE_2879_length_209_cov_25.331461_g2853_i0 PRJEB1404 2879 209 25.331461 52.94275349 root 1 Root_unresolved Root_unresolved 381 2.0599999999999996e-101   NTclustered gi|10782|emb|X54004.1| 5908 g2853 i0 99.522 89.1578947368421 209 1 100 0 1 209 3161 2953 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 18634 381 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
23938068 23938068 PRJEB1404_S_NODE_179_length_430_cov_5079.470886_g159_i0 PRJEB1404 179 430 5079.470886 21841.724809799998 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 582 1.19e-161   NTclustered gi|1837628855|gb|MN158348.1| 5909 g159 i0 98.198 76.2581395348837 333 6 77 0 98 430 2984 2652 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 32791 582 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
24246919 24246919 PRJEB1404_S_NODE_80_length_499_cov_19.237069_g63_i0 PRJEB1404 80 499 19.237069 95.99297431 Chilodonella piscicola 1654720 SAR_Eukaryotes SAR_Eukaryotes 737 0   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g63 i0 95.085 80.5991983967936 468 23 94 0 3 470 1 468 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 40219 737 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola

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