RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA1068830" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 19 ✖

tax_clade 1

bioproject 1

  • PRJNA1068830 · 19 ✖

analysis 1

  • diamond · 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
2733395 2733395 PRJNA1068830_P_NODE_46103_length_324_cov_1.629482_g45400_i0 PRJNA1068830 46103 324 1.629482 5.27952168 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 112 2.19e-28   NR CAD8124998.1 65129 g45400 i0 59.8 1.81481481481481 97 39 89.8 0 323 33 96 192 CAD8124998.1 unnamed protein product [Paramecium sonneborni] diamond 588 112 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
21859487 21859487 PRJNA1068830_P_NODE_38918_length_358_cov_1.094737_g38215_i0 PRJNA1068830 38918 358 1.094737 3.91915846 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 177 6.8999999999999985e-53   NR XP_004034809.1 5932 g38215 i0 69.8 4.89385474860335 116 35 97.2 0 4 351 3 118 XP_004034809.1 ser thr protein phosphatase family protein, putative [Ichthyophthirius multifiliis] diamond 1752 178 0.99438202247191 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
26687457 26687457 PRJNA1068830_P_NODE_87341_length_243_cov_0.917647_g86638_i0 PRJNA1068830 87341 243 0.917647 2.22988221 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 69.3 1.54e-11   NR CDW78166.1 5949 g86638 i0 40.8 0.938271604938272 76 45 93.8 0 239 12 281 356 CDW78166.1 UNKNOWN [Stylonychia lemnae] diamond 228 69.3 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
26750435 26750435 PRJNA1068830_P_NODE_81941_length_246_cov_1.387283_g81238_i0 PRJNA1068830 81941 246 1.387283 3.41271618 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 42 0.0254   NR CAD8068247.1 5886 g81238 i0 63.6 0.536585365853659 22 8 26.8 0 121 56 80 101 CAD8068247.1 unnamed protein product [Paramecium primaurelia] diamond 132 42 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
26940676 26940676 PRJNA1068830_P_NODE_61242_length_278_cov_1.312195_g60539_i0 PRJNA1068830 61242 278 1.312195 3.6479021 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 60.1 4.21e-8   NR KRX04206.1 266149 g60539 i0 55.8 0.561151079136691 52 22 56.1 1 157 2 49 99 KRX04206.1 hypothetical protein PPERSA_11330 [Pseudocohnilembus persalinus] diamond 156 60.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
27225199 27225199 PRJNA1068830_P_NODE_78283_length_249_cov_0.886364_g77580_i0 PRJNA1068830 78283 249 0.886364 2.20704636 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 48.5 2.14e-4   NR CDW89587.1 5949 g77580 i0 31.8 1.02409638554217 85 54 98.8 3 248 3 64 147 CDW89587.1 UNKNOWN [Stylonychia lemnae] diamond 255 48.5 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
27256978 27256978 PRJNA1068830_P_NODE_82723_length_246_cov_0.901734_g82020_i0 PRJNA1068830 82723 246 0.901734 2.21826564 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 108 8.17e-26   NR XP_001021714.2 312017 g82020 i0 61.7 0.98780487804878 81 31 98.8 0 245 3 230 310 XP_001021714.2 elongation factor Tu protein [Tetrahymena thermophila SB210] diamond 243 108 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28772597 28772597 PRJNA1068830_P_NODE_77107_length_250_cov_0.881356_g76404_i0 PRJNA1068830 77107 250 0.881356 2.20339 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 82 1.56e-17   NR XP_001031069.1 312017 g76404 i0 48.8 0.984 82 42 98.4 0 249 4 29 110 XP_001031069.1 transmembrane protein, putative [Tetrahymena thermophila SB210] diamond 246 82 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29025589 29025589 PRJNA1068830_P_NODE_41648_length_344_cov_1.132841_g40945_i0 PRJNA1068830 41648 344 1.132841 3.8969730400000002 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 112 1.41e-27   NR XP_001011598.2 312017 g40945 i0 50.4 1.0203488372093 117 50 97.7 3 340 5 149 262 XP_001011598.2 60S ribosomal protein L5 [Tetrahymena thermophila SB210] diamond 351 112 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29521962 29521962 PRJNA1068830_P_NODE_77970_length_249_cov_0.886364_g77267_i0 PRJNA1068830 77970 249 0.886364 2.20704636 root 1 Root_unresolved Root_unresolved 106 9.85e-28   NR XP_004039035.1 5932 g77267 i0 62.2 2.96385542168675 82 31 98.8 0 247 2 4 85 XP_004039035.1 ribosomal protein, putative [Ichthyophthirius multifiliis] diamond 738 107 0.990654205607477 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
29530491 29530491 PRJNA1068830_P_NODE_38850_length_358_cov_1.684211_g38147_i0 PRJNA1068830 38850 358 1.684211 6.02947538 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 58.9 1.62e-7   NR CAG9310866.1 1481888 g38147 i0 42.5 0.888268156424581 106 51 85.5 3 2 307 145 244 CAG9310866.1 unnamed protein product [Blepharisma stoltei] diamond 318 58.9 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
30130178 30130178 PRJNA1068830_P_NODE_75692_length_251_cov_0.876404_g74989_i0 PRJNA1068830 75692 251 0.876404 2.19977404 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 54.7 1.18e-6   NR XP_001026391.1 312017 g74989 i0 39.5 1.93625498007968 81 46 93.2 1 234 1 25 105 XP_001026391.1 UPF0428 protein CXorf56-like protein, putative [Tetrahymena thermophila SB210] diamond 486 54.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30730823 30730823 PRJNA1068830_P_NODE_86734_length_243_cov_0.917647_g86031_i0 PRJNA1068830 86734 243 0.917647 2.22988221 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 63.5 9.99e-10   NR CAG9319054.1 1481888 g86031 i0 33.8 3.92592592592593 80 53 98.8 0 3 242 36 115 CAG9319054.1 unnamed protein product [Blepharisma stoltei] diamond 954 63.5 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
30943711 30943711 PRJNA1068830_P_NODE_85274_length_244_cov_0.912281_g84571_i0 PRJNA1068830 85274 244 0.912281 2.22596564 Oligohymenophorea 6020 SAR_Eukaryotes SAR_Eukaryotes 120 4.24e-30   NR CAD8187126.1 43138 g84571 i0 64.2 2.97540983606557 81 29 99.6 0 243 1 112 192 CAD8187126.1 unnamed protein product [Paramecium pentaurelia] diamond 726 120 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
30952178 30952178 PRJNA1068830_P_NODE_44074_length_333_cov_1.196154_g43371_i0 PRJNA1068830 44074 333 1.196154 3.98319282 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 92.8 4.48e-20   NR KAL4512784.1 2486642 g43371 i0 37.3 3.7027027027027 102 64 91.9 0 2 307 22 123 KAL4512784.1 hypothetical protein ABPG72_017469 [Tetrahymena utriculariae] diamond 1233 92.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
31006750 31006750 PRJNA1068830_P_NODE_42734_length_339_cov_1.172932_g42031_i0 PRJNA1068830 42734 339 1.172932 3.97623948 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 95.5 2.98e-22   NR KRX10976.1 266149 g42031 i0 47.8 12.7433628318584 113 47 99.1 3 337 2 46 147 KRX10976.1 hypothetical protein PPERSA_12100 [Pseudocohnilembus persalinus] diamond 4320 96.3 0.991692627206646 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
31837178 31837178 PRJNA1068830_P_NODE_70137_length_257_cov_1.695652_g69434_i0 PRJNA1068830 70137 257 1.695652 4.35782564 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 78.2 4.17e-16   NR XP_001025224.2 312017 g69434 i0 52.9 0.992217898832685 85 39 98.1 1 253 2 1 85 XP_001025224.2 S25 ribosomal protein [Tetrahymena thermophila SB210] diamond 255 78.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
32375353 32375353 PRJNA1068830_P_NODE_48399_length_315_cov_1.933884_g47696_i0 PRJNA1068830 48399 315 1.933884 6.0917346 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 56.6 5.15e-7   NR CAD8046340.1 5886 g47696 i0 34.9 0.79047619047619 83 54 79 0 302 54 89 171 CAD8046340.1 unnamed protein product [Paramecium primaurelia] diamond 249 56.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
32438791 32438791 PRJNA1068830_P_NODE_85919_length_244_cov_0.912281_g85216_i0 PRJNA1068830 85919 244 0.912281 2.22596564 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 63.5 1.72e-9   NR OMJ88349.1 5963 g85216 i0 49.3 0.872950819672131 71 33 87.3 1 1 213 19 86 OMJ88349.1 hypothetical protein SteCoe_9764 [Stentor coeruleus] diamond 213 63.5 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus

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