RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "diamond", bioproject = "PRJNA1092581" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 26 ✖

tax_clade 1

bioproject 1

  • PRJNA1092581 · 26 ✖

analysis 1

  • diamond · 26 ✖

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
24422805 24422805 PRJNA1092581_P_NODE_42840_length_416_cov_1.673469_g42307_i0 PRJNA1092581 42840 416 1.673469 6.96163104 Tetrahymenidae 291294 SAR_Eukaryotes SAR_Eukaryotes 157 8.729999999999999e-45   NR XP_004039688.1 5932 g42307 i0 69.8 3.81490384615385 106 32 76.4 0 414 97 156 261 XP_004039688.1 hypothetical protein IMG5_013680 [Ichthyophthirius multifiliis] diamond 1587 158 0.993670886075949 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
26615667 26615667 PRJNA1092581_P_NODE_31501_length_493_cov_2.890476_g30969_i0 PRJNA1092581 31501 493 2.890476 14.25004668 Tetrahymenidae 291294 SAR_Eukaryotes SAR_Eukaryotes 146 6.25e-42   NR 2XZN_J 5911 g30969 i0 64.7 1.85598377281947 102 36 62.1 0 493 188 19 120 2XZN_J Chain J, Ribosomal Protein S10 Containing Protein [Tetrahymena thermophila] diamond 915 147 0.993197278911565 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
26774249 26774249 PRJNA1092581_P_NODE_16901_length_675_cov_1.867110_g16392_i0 PRJNA1092581 16901 675 1.86711 12.6029925 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 254 2.06e-77   NR CAD8068023.1 65129 g16392 i0 64.3 5.84444444444444 213 67 94.7 3 639 1 361 564 CAD8068023.1 unnamed protein product [Paramecium sonneborni] diamond 3945 254 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
27090621 27090621 PRJNA1092581_P_NODE_122422_length_214_cov_10.851064_g121889_i0 PRJNA1092581 122422 214 10.851064 23.22127696 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 50.4 4.55e-5   NR CAD8134336.1 43138 g121889 i0 50 1.61214953271028 38 19 53.3 0 148 35 232 269 CAD8134336.1 unnamed protein product [Paramecium pentaurelia] diamond 345 50.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
27185247 27185247 PRJNA1092581_P_NODE_53302_length_366_cov_5.812287_g52769_i0 PRJNA1092581 53302 366 5.812287 21.27297042 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 112 2.6600000000000003e-27   NR XP_001455841.1 5888 g52769 i0 55 3.27868852459016 100 43 80.3 2 358 65 196 295 XP_001455841.1 uncharacterized protein GSPATT00021611001 [Paramecium tetraurelia] diamond 1200 112 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
27469886 27469886 PRJNA1092581_P_NODE_114183_length_233_cov_3.437500_g113650_i0 PRJNA1092581 114183 233 3.4375 8.009375 Oligohymenophorea 6020 SAR_Eukaryotes SAR_Eukaryotes 97.8 1.36e-21   NR XP_004036634.1 5932 g113650 i0 55.9 4.39055793991416 68 30 87.6 0 214 11 187 254 XP_004036634.1 SET domain protein [Ichthyophthirius multifiliis] diamond 1023 98.6 0.991886409736308 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
27478378 27478378 PRJNA1092581_P_NODE_62243_length_335_cov_4.980916_g61710_i0 PRJNA1092581 62243 335 4.980916 16.6860686 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 98.6 2.8199999999999994e-24   NR XP_001024162.1 312017 g61710 i0 57.3 0.797014925373134 89 37 78.8 1 1 264 6 94 XP_001024162.1 transmembrane protein, putative [Tetrahymena thermophila SB210] diamond 267 98.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28078197 28078197 PRJNA1092581_P_NODE_62285_length_335_cov_3.900763_g61752_i0 PRJNA1092581 62285 335 3.900763 13.06755605 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 77.4 1.66e-14   NR CAD8088320.1 65129 g61752 i0 39.1 0.77910447761194 87 49 77.9 1 266 6 6 88 CAD8088320.1 unnamed protein product [Paramecium sonneborni] diamond 261 77.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
28109699 28109699 PRJNA1092581_P_NODE_114165_length_233_cov_3.525000_g113632_i0 PRJNA1092581 114165 233 3.525 8.21325 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 105 9.12e-28   NR OMJ77299.1 5963 g113632 i0 85.1 1.72532188841202 67 10 86.3 0 212 12 1 67 OMJ77299.1 hypothetical protein SteCoe_23122 [Stentor coeruleus] diamond 402 105 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
28543515 28543515 PRJNA1092581_P_NODE_47227_length_393_cov_3.021875_g46694_i0 PRJNA1092581 47227 393 3.021875 11.87596875 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 75.5 2.73e-14   NR Q00454.1 5911 g46694 i0 76.2 0.641221374045801 42 10 32.1 0 1 126 69 110 Q00454.1 RecName: Full=Large ribosomal subunit protein uL15; AltName: Full=60S ribosomal protein L27a [Tetrahymena thermophila] diamond 252 75.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28772824 28772824 PRJNA1092581_P_NODE_57447_length_351_cov_2.420863_g56914_i0 PRJNA1092581 57447 351 2.420863 8.49722913 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 50.8 1.27e-4   NR CAD8111863.1 65129 g56914 i0 67.9 0.239316239316239 28 9 23.9 0 331 248 71 98 CAD8111863.1 unnamed protein product [Paramecium sonneborni] diamond 84 50.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
28804246 28804246 PRJNA1092581_P_NODE_58328_length_348_cov_3.058182_g57795_i0 PRJNA1092581 58328 348 3.058182 10.64247336 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 154 1.4099999999999999e-42   NR XP_001023112.2 312017 g57795 i0 66 0.913793103448276 106 36 91.4 0 31 348 260 365 XP_001023112.2 hypothetical protein TTHERM_00353560 [Tetrahymena thermophila SB210] diamond 318 154 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29143474 29143474 PRJNA1092581_P_NODE_47809_length_390_cov_4.444795_g47276_i0 PRJNA1092581 47809 390 4.444795 17.3347005 Tetrahymenidae 291294 SAR_Eukaryotes SAR_Eukaryotes 94.7 6.46e-23   NR AGE89260.1 153251 g47276 i0 76.4 1.26923076923077 55 13 42.3 0 330 166 1 55 AGE89260.1 40S ribosomal protein S29 [Cryptocaryon irritans] diamond 495 94.7 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
29246449 29246449 PRJNA1092581_P_NODE_19829_length_625_cov_3.974638_g19310_i0 PRJNA1092581 19829 625 3.974638 24.8414875 Paramecium pentaurelia 43138 SAR_Eukaryotes SAR_Eukaryotes 96.7 2.4900000000000004e-21   NR CAD8192802.1 43138 g19310 i0 40.9 0.7632 159 83 75.4 5 614 144 13 162 CAD8192802.1 unnamed protein product [Paramecium pentaurelia] diamond 477 96.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
29837726 29837726 PRJNA1092581_P_NODE_96731_length_258_cov_2.356757_g96198_i0 PRJNA1092581 96731 258 2.356757 6.08043306 root 1 Root_unresolved Root_unresolved 65.9 1.43e-10   NR CAD8088320.1 65129 g96198 i0 41.2 1.97674418604651 85 49 98.8 1 257 3 105 188 CAD8088320.1 unnamed protein product [Paramecium sonneborni] diamond 510 65.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
30289111 30289111 PRJNA1092581_P_NODE_38592_length_441_cov_5.184783_g38059_i0 PRJNA1092581 38592 441 5.184783 22.86489303 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 104 7.019999999999999e-23   NR XP_001015534.2 312017 g38059 i0 40.6 0.938775510204082 138 54 75.5 3 48 380 593 729 XP_001015534.2 kelch motif protein [Tetrahymena thermophila SB210] diamond 414 104 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30731032 30731032 PRJNA1092581_P_NODE_100514_length_252_cov_2.592179_g99981_i0 PRJNA1092581 100514 252 2.592179 6.53229108 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 65.5 2.18e-10   NR CDW86680.1 5949 g99981 i0 77.8 0.428571428571429 36 8 42.9 0 91 198 226 261 CDW86680.1 probable u3 small nucleolar rna-associated protein 11-like [Stylonychia lemnae] diamond 108 65.5 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
30785633 30785633 PRJNA1092581_P_NODE_22254_length_590_cov_2.903288_g21732_i0 PRJNA1092581 22254 590 2.903288 17.1293992 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 122 2.09e-29   NR KAL4476572.1 5901 g21732 i0 46.3 2.07457627118644 123 65 62.5 1 590 222 217 338 KAL4476572.1 hypothetical protein ABPG74_010305 [Tetrahymena malaccensis] diamond 1224 123 0.991869918699187 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
30889106 30889106 PRJNA1092581_P_NODE_81934_length_285_cov_2.679245_g81401_i0 PRJNA1092581 81934 285 2.679245 7.63584825 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 95.5 1.85e-22   NR XP_001456963.1 5888 g81401 i0 60.9 1.89473684210526 87 34 91.6 0 284 24 35 121 XP_001456963.1 uncharacterized protein GSPATT00022738001 [Paramecium tetraurelia] diamond 540 95.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
31015448 31015448 PRJNA1092581_P_NODE_8995_length_892_cov_4.515263_g8581_i0 PRJNA1092581 8995 892 4.515263 40.27614596 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 225 7.75e-69   NR XP_001032769.1 312017 g8581 i0 52.2 0.823991031390135 245 114 81.7 3 5 733 31 274 XP_001032769.1 TLC domain protein [Tetrahymena thermophila SB210] diamond 735 225 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31616146 31616146 PRJNA1092581_P_NODE_101776_length_250_cov_4.463277_g101243_i0 PRJNA1092581 101776 250 4.463277 11.1581925 Paramecium tetraurelia strain d4-2 412030 SAR_Eukaryotes SAR_Eukaryotes 92.4 1.86e-20   NR XP_001347021.1 412030 g101243 i0 52.7 0.888 74 34 88.8 1 245 24 210 282 XP_001347021.1 Oxidoreductase [Paramecium tetraurelia strain d4-2] diamond 222 92.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
31733897 31733897 PRJNA1092581_P_NODE_8417_length_917_cov_3.233412_g8016_i0 PRJNA1092581 8417 917 3.233412 29.65038804 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 344 9.780000000000001e-110   NR XP_001439148.1 5888 g8016 i0 57.1 4.93675027262814 303 126 97.8 1 900 4 208 510 XP_001439148.1 uncharacterized protein GSPATT00038676001, partial [Paramecium tetraurelia] diamond 4527 346 0.994219653179191 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
32375606 32375606 PRJNA1092581_P_NODE_20919_length_608_cov_2.254206_g20397_i0 PRJNA1092581 20919 608 2.254206 13.70557248 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 98.6 1.7e-20   NR CDW82988.1 5949 g20397 i0 42.9 0.518092105263158 105 54 51.8 1 2 316 254 352 CDW82988.1 UNKNOWN [Stylonychia lemnae] diamond 315 98.6 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
32596958 32596958 PRJNA1092581_P_NODE_65180_length_326_cov_3.992095_g64647_i0 PRJNA1092581 65180 326 3.992095 13.0142297 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 81.6 6.02e-18   NR XP_001441125.1 5888 g64647 i0 60.3 1.06748466257669 58 23 53.4 0 71 244 3 60 XP_001441125.1 uncharacterized protein GSPATT00010000001 [Paramecium tetraurelia] diamond 348 81.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
32650918 32650918 PRJNA1092581_P_NODE_11280_length_811_cov_4.554201_g10822_i0 PRJNA1092581 11280 811 4.554201 36.93457011 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 76.6 1.93e-12   NR CAD8154896.1 43137 g10822 i0 28.6 1.57583230579531 213 142 76.9 6 173 796 32 239 CAD8154896.1 unnamed protein product [Paramecium octaurelia] diamond 1278 76.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
32808575 32808575 PRJNA1092581_P_NODE_109720_length_240_cov_50.970060_g109187_i0 PRJNA1092581 109720 240 50.97006 122.328144 Heterotrichida 5957 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0174   NR OMJ65575.1 5963 g109187 i0 59.3 1.0125 27 11 33.8 0 22 102 56 82 OMJ65575.1 hypothetical protein SteCoe_37970 [Stentor coeruleus] diamond 243 41.6 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);;