RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJEB7366" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 32 ✖

tax_clade 1

bioproject 1

  • PRJEB7366 · 32 ✖

analysis 1

  • diamond · 32 ✖

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
135282 135282 PRJEB7366_P_NODE_4161_length_457_cov_1.706161_g3736_i0 PRJEB7366 4161 457 1.706161 7.79715577 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 209 8.52e-65   NR OMJ93521.1 5963 g3736 i0 68 1.96936542669584 150 47 98.5 1 3 452 45 193 OMJ93521.1 hypothetical protein SteCoe_3497 [Stentor coeruleus] diamond 900 209 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
17986837 17986837 PRJEB7366_P_NODE_19415_length_173_cov_1.449275_g18981_i0 PRJEB7366 19415 173 1.449275 2.50724575 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 68.2 1.15e-11   NR XP_001013459.1 312017 g18981 i0 60 3.6242774566474 50 20 86.7 0 172 23 181 230 XP_001013459.1 papain family cysteine protease [Tetrahymena thermophila SB210] diamond 627 68.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27216335 27216335 PRJEB7366_P_NODE_24342_length_152_cov_1.025641_g23908_i0 PRJEB7366 24342 152 1.025641 1.55897432 Heterotrichida 5957 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.00574   NR OMJ71203.1 5963 g23908 i0 36 2.92105263157895 50 32 98.7 0 152 3 120 169 OMJ71203.1 hypothetical protein SteCoe_30645 [Stentor coeruleus] diamond 444 43.5 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
27374946 27374946 PRJEB7366_P_NODE_17843_length_182_cov_1.088435_g17409_i0 PRJEB7366 17843 182 1.088435 1.9809517 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 68.2 8.81e-12   NR AAA29445.1 5886 g17409 i0 84.6 1.96153846153846 39 6 64.3 0 19 135 35 73 AAA29445.1 G surface antigen, partial [Paramecium primaurelia] diamond 357 68.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
27571223 27571223 PRJEB7366_P_NODE_15364_length_199_cov_1.707317_g14930_i0 PRJEB7366 15364 199 1.707317 3.39756083 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.00122   NR OMJ65255.1 5963 g14930 i0 41.5 0.979899497487437 65 36 96.5 2 197 6 420 483 OMJ65255.1 hypothetical protein SteCoe_38688 [Stentor coeruleus] diamond 195 46.2 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
27729520 27729520 PRJEB7366_P_NODE_484_length_1333_cov_4.728043_g345_i0 PRJEB7366 484 1333 4.728043 63.02481319 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 83.6 3.65e-13   NR TNV79765.1 5974 g345 i0 25.1 0.762940735183796 339 210 70 6 953 21 151 473 TNV79765.1 hypothetical protein FGO68_gene6404 [Halteria grandinella] diamond 1017 83.6 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
27824022 27824022 PRJEB7366_P_NODE_13764_length_214_cov_1.117318_g13330_i0 PRJEB7366 13764 214 1.117318 2.39106052 Paramecium pentaurelia 43138 SAR_Eukaryotes SAR_Eukaryotes 65.1 1.7e-10   NR CAD8136588.1 43138 g13330 i0 48.6 0.981308411214953 70 36 98.1 0 210 1 128 197 CAD8136588.1 unnamed protein product [Paramecium pentaurelia] diamond 210 65.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
27886926 27886926 PRJEB7366_P_NODE_16085_length_194_cov_1.257862_g15651_i0 PRJEB7366 16085 194 1.257862 2.44025228 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 82.8 4.92e-17   NR XP_001454812.1 5888 g15651 i0 75 0.742268041237113 48 12 74.2 0 145 2 159 206 XP_001454812.1 uncharacterized protein GSPATT00021058001 [Paramecium tetraurelia] diamond 144 82.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
28100670 28100670 PRJEB7366_P_NODE_20825_length_166_cov_1.526718_g20391_i0 PRJEB7366 20825 166 1.526718 2.53435188 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.00713   NR CAD8049727.1 5886 g20391 i0 100 1.08433734939759 20 0 36.1 0 99 40 334 353 CAD8049727.1 unnamed protein product [Paramecium primaurelia] diamond 180 43.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
28139862 28139862 PRJEB7366_P_NODE_19165_length_174_cov_2.014388_g18731_i0 PRJEB7366 19165 174 2.014388 3.50503512 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 65.9 1.05e-10   NR OMJ65255.1 5963 g18731 i0 50 0.96551724137931 56 28 96.6 0 1 168 533 588 OMJ65255.1 hypothetical protein SteCoe_38688 [Stentor coeruleus] diamond 168 65.9 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
28644906 28644906 PRJEB7366_P_NODE_19467_length_173_cov_1.159420_g19033_i0 PRJEB7366 19467 173 1.15942 2.0057966 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 52 7.87e-6   NR OMJ65255.1 5963 g19033 i0 40.4 0.815028901734104 47 28 81.5 0 30 170 495 541 OMJ65255.1 hypothetical protein SteCoe_38688 [Stentor coeruleus] diamond 141 52 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
28826804 28826804 PRJEB7366_P_NODE_9228_length_277_cov_1.652893_g8794_i0 PRJEB7366 9228 277 1.652893 4.57851361 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 53.1 1.13e-5   NR CDW80184.1 5949 g8794 i0 56.8 1.09386281588448 37 16 40.1 0 111 1 88 124 CDW80184.1 zinc finger protein [Stylonychia lemnae] diamond 303 53.5 0.992523364485981 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
28960816 28960816 PRJEB7366_P_NODE_6488_length_346_cov_2.186495_g6054_i0 PRJEB7366 6488 346 2.186495 7.5652727 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 122 1.2499999999999998e-29   NR CAI2363325.1 5936 g6054 i0 49.6 10.6473988439306 113 56 97.1 1 344 9 92 204 CAI2363325.1 unnamed protein product [Moneuplotes crassus] diamond 3684 122 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
28992414 28992414 PRJEB7366_P_NODE_23448_length_155_cov_1.333333_g23014_i0 PRJEB7366 23448 155 1.333333 2.06666615 Paramecium pentaurelia 43138 SAR_Eukaryotes SAR_Eukaryotes 86.3 4.52e-18   NR CAD8132960.1 43138 g23014 i0 85.4 0.793548387096774 41 6 79.4 0 1 123 304 344 CAD8132960.1 unnamed protein product [Paramecium pentaurelia] diamond 123 86.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
29181717 29181717 PRJEB7366_P_NODE_16489_length_191_cov_1.282051_g16055_i0 PRJEB7366 16489 191 1.282051 2.44871741 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 87 7.580000000000001e-21   NR CAD8098889.1 65129 g16055 i0 75 1.8848167539267 60 15 94.2 0 190 11 1 60 CAD8098889.1 unnamed protein product [Paramecium sonneborni] diamond 360 87 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
29623067 29623067 PRJEB7366_P_NODE_19470_length_173_cov_1.159420_g19036_i0 PRJEB7366 19470 173 1.15942 2.0057966 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 86.3 4.02e-20   NR CAD8116882.1 65129 g19036 i0 83.3 3.32947976878613 48 8 83.2 0 3 146 52 99 CAD8116882.1 unnamed protein product [Paramecium sonneborni] diamond 576 86.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
29710727 29710727 PRJEB7366_P_NODE_23510_length_155_cov_1.033333_g23076_i0 PRJEB7366 23510 155 1.033333 1.60166615 Heterotrichida 5957 SAR_Eukaryotes SAR_Eukaryotes 72.8 3.76e-14   NR OMJ91927.1 5963 g23076 i0 68.6 6.90967741935484 51 16 98.7 0 2 154 72 122 OMJ91927.1 hypothetical protein SteCoe_5491 [Stentor coeruleus] diamond 1071 72.8 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
30255648 30255648 PRJEB7366_P_NODE_8792_length_285_cov_1.884000_g8358_i0 PRJEB7366 8792 285 1.884 5.3694 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 52.8 1.77e-5   NR KRX01717.1 266149 g8358 i0 33.8 1.71578947368421 80 44 81.1 3 268 38 34 107 KRX01717.1 hypothetical protein PPERSA_01587 [Pseudocohnilembus persalinus] diamond 489 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
30469537 30469537 PRJEB7366_P_NODE_17993_length_181_cov_1.095890_g17559_i0 PRJEB7366 17993 181 1.09589 1.9835609 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 84.7 8.98e-18   NR CAD8100487.1 5886 g17559 i0 66.7 2.98342541436464 60 20 99.4 0 180 1 54 113 CAD8100487.1 unnamed protein product [Paramecium primaurelia] diamond 540 85.5 0.990643274853801 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
30508068 30508068 PRJEB7366_P_NODE_17693_length_183_cov_1.040541_g17259_i0 PRJEB7366 17693 183 1.040541 1.90419003 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 77.8 2.74e-15   NR CAG9321811.1 1481888 g17259 i0 55.2 0.950819672131147 58 26 95.1 0 9 182 169 226 CAG9321811.1 unnamed protein product [Blepharisma stoltei] diamond 174 77.8 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
30658834 30658834 PRJEB7366_P_NODE_22553_length_159_cov_0.967742_g22119_i0 PRJEB7366 22553 159 0.967742 1.53870978 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 91.7 6.82e-20   NR CAD8108961.1 5886 g22119 i0 93.2 11.622641509434 44 3 83 0 157 26 1972 2015 CAD8108961.1 unnamed protein product [Paramecium primaurelia] diamond 1848 92 0.996739130434783 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
31227446 31227446 PRJEB7366_P_NODE_14595_length_206_cov_1.584795_g14161_i0 PRJEB7366 14595 206 1.584795 3.2646777 Oligohymenophorea 6020 SAR_Eukaryotes SAR_Eukaryotes 65.5 1.89e-11   NR CAD8206115.1 43137 g14161 i0 56.5 3.01456310679612 69 29 99 1 205 2 2 70 CAD8206115.1 unnamed protein product [Paramecium octaurelia] diamond 621 65.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
31266464 31266464 PRJEB7366_P_NODE_12015_length_233_cov_1.818182_g11581_i0 PRJEB7366 12015 233 1.818182 4.23636406 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 121 1.4799999999999998e-31   NR CAD8068855.1 65129 g11581 i0 91.4 0.746781115879828 58 5 74.7 0 202 29 229 286 CAD8068855.1 unnamed protein product [Paramecium sonneborni] diamond 174 121 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
31361475 31361475 PRJEB7366_P_NODE_23816_length_154_cov_1.008403_g23382_i0 PRJEB7366 23816 154 1.008403 1.55294062 Paramecium pentaurelia 43138 SAR_Eukaryotes SAR_Eukaryotes 59.3 1.52e-8   NR CAD8193746.1 43138 g23382 i0 58.5 0.798701298701299 41 17 79.9 0 128 6 617 657 CAD8193746.1 unnamed protein product [Paramecium pentaurelia] diamond 123 59.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
31393106 31393106 PRJEB7366_P_NODE_12476_length_228_cov_1.098446_g12042_i0 PRJEB7366 12476 228 1.098446 2.50445688 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 58.5 8.03e-8   NR KAL4470667.1 2486642 g12042 i0 41.8 1.67105263157895 67 38 88.2 1 3 203 206 271 KAL4470667.1 hypothetical protein ABPG72_001778 [Tetrahymena utriculariae] diamond 381 58.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
31645823 31645823 PRJEB7366_P_NODE_20277_length_169_cov_1.194030_g19843_i0 PRJEB7366 20277 169 1.19403 2.0179107 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 56.2 2.41e-7   NR CAG9323272.1 1481888 g19843 i0 58.2 1.95266272189349 55 23 97.6 0 5 169 762 816 CAG9323272.1 unnamed protein product [Blepharisma stoltei] diamond 330 56.2 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
31962272 31962272 PRJEB7366_P_NODE_17238_length_186_cov_1.059603_g16804_i0 PRJEB7366 17238 186 1.059603 1.97086158 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 65.9 1.05e-10   NR KRX10567.1 266149 g16804 i0 58.1 1 62 24 100 1 186 1 278 337 KRX10567.1 hypothetical protein PPERSA_05387 [Pseudocohnilembus persalinus] diamond 186 65.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
32215530 32215530 PRJEB7366_P_NODE_24018_length_153_cov_1.355932_g23584_i0 PRJEB7366 24018 153 1.355932 2.07457596 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 47 3.42e-4   NR OMJ83634.1 5963 g23584 i0 44 0.980392156862745 50 28 98 0 151 2 274 323 OMJ83634.1 hypothetical protein SteCoe_15423 [Stentor coeruleus] diamond 150 47 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
32437215 32437215 PRJEB7366_P_NODE_24099_length_153_cov_0.966102_g23665_i0 PRJEB7366 24099 153 0.966102 1.47813606 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 53.9 1.21e-6   NR CAG9322258.1 1481888 g23665 i0 48 0.980392156862745 50 24 98 1 2 151 233 280 CAG9322258.1 unnamed protein product [Blepharisma stoltei] diamond 150 53.9 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
32689327 32689327 PRJEB7366_P_NODE_13220_length_219_cov_1.923913_g12786_i0 PRJEB7366 13220 219 1.923913 4.21336947 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 65.9 1.34e-10   NR CDW85383.1 5949 g12786 i0 47 0.904109589041096 66 35 90.4 0 217 20 141 206 CDW85383.1 high mobility group protein b2 [Stylonychia lemnae] diamond 198 65.9 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
32720966 32720966 PRJEB7366_P_NODE_17060_length_187_cov_1.315789_g16626_i0 PRJEB7366 17060 187 1.315789 2.46052543 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 46.6 7.39e-4   NR XP_001019547.3 312017 g16626 i0 38.2 1.09090909090909 68 29 97.9 3 185 3 75 136 XP_001019547.3 papain family cysteine protease [Tetrahymena thermophila SB210] diamond 204 46.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
32902536 32902536 PRJEB7366_P_NODE_7040_length_329_cov_1.418367_g6606_i0 PRJEB7366 7040 329 1.418367 4.66642743 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.0162   NR KAL4434732.1 5901 g6606 i0 32.9 1.38601823708207 76 39 66.6 2 12 230 2148 2214 KAL4434732.1 hypothetical protein ABPG74_017152 [Tetrahymena malaccensis] diamond 456 45.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis

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