RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

29 rows where analysis = "diamond", bioproject = "PRJEB6584" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 29 ✖

tax_clade 1

bioproject 1

  • PRJEB6584 · 29 ✖

analysis 1

  • diamond · 29 ✖

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
25524257 25524257 PRJEB6584o_S_NODE_10969_length_264_cov_4.877729_g10861_i0 PRJEB6584 10969 264 4.877729 12.87720456 Thuricola similis 2784598 SAR_Eukaryotes SAR_Eukaryotes 57.8 1.54e-7   NR YP_010147339.1 2784598 g10861 i0 40.5 0.954545454545455 84 43 87.5 1 247 17 116 199 YP_010147339.1 30S ribosomal protein S13 [Thuricola similis] diamond 252 57.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vaginicolidae Thuricola Thuricola similis
25660950 25660950 PRJEB6584o_S_NODE_37202_length_174_cov_1.856115_g37094_i0 PRJEB6584 37202 174 1.856115 3.2296401 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 61.2 2.12e-10   NR XP_001026284.1 312017 g37094 i0 56 0.862068965517241 50 18 86.2 1 23 172 41 86 XP_001026284.1 transmembrane protein, putative [Tetrahymena thermophila SB210] diamond 150 61.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
25752080 25752080 PRJEB6584e_S_NODE_74_length_563_cov_10.174242_g61_i0 PRJEB6584 74 563 10.174242 57.28098246 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 61.2 1.02e-7   NR OMJ75548.1 5963 g61 i0 41.1 0.596802841918295 56 33 29.8 0 473 306 123 178 OMJ75548.1 hypothetical protein SteCoe_25282 [Stentor coeruleus] diamond 336 61.2 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
26068081 26068081 PRJEB6584h_S_NODE_941_length_402_cov_1642.694823_g879_i0 PRJEB6584 941 402 1642.694823 6603.63318846 Paramecium caudatum 5885 SAR_Eukaryotes SAR_Eukaryotes 83.6 9.08e-18   NR YP_003734457.1 5885 g879 i0 68.4 0.567164179104478 76 22 55.2 1 181 402 38 113 YP_003734457.1 NADH dehydrogenase subunit 4L [Paramecium caudatum] diamond 228 83.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium caudatum
32911964 32911964 PRJEB6584j_S_NODE_27113_length_157_cov_1.311475_g27084_i0 PRJEB6584 27113 157 1.311475 2.05901575 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.00334   NR KRX04442.1 266149 g27084 i0 38 1.77707006369427 50 31 95.5 0 156 7 364 413 KRX04442.1 Translation elongation factor EF1B, gamma chain, conserved [Pseudocohnilembus persalinus] diamond 279 44.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
32912096 32912096 PRJEB6584o_S_NODE_13249_length_242_cov_2.357488_g13141_i0 PRJEB6584 13249 242 2.357488 5.70512096 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 47.4 3.53e-4   NR TNV75462.1 5974 g13141 i0 71.4 0.347107438016529 28 8 34.7 0 2 85 126 153 TNV75462.1 hypothetical protein FGO68_gene13790 [Halteria grandinella] diamond 84 47.4 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
32912410 32912410 PRJEB6584o_S_NODE_5433_length_349_cov_142.038217_g5325_i0 PRJEB6584 5433 349 142.038217 495.71337733 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 50.1 3.08e-4   NR CAD8153504.1 43137 g5325 i0 29.5 1.0487106017192 61 43 52.4 0 45 227 355 415 CAD8153504.1 unnamed protein product [Paramecium octaurelia] diamond 366 50.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
32922991 32922991 PRJEB6584d_S_NODE_15417_length_163_cov_2.406250_g15349_i0 PRJEB6584 15417 163 2.40625 3.9221875 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00217   NR OMJ83458.1 5963 g15349 i0 40 2.55828220858896 45 27 82.8 0 161 27 134 178 OMJ83458.1 hypothetical protein SteCoe_15627 [Stentor coeruleus] diamond 417 45.1 0.991130820399113 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
32923096 32923096 PRJEB6584o_S_NODE_76745_length_154_cov_1.571429_g76637_i0 PRJEB6584 76745 154 1.571429 2.42000066 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 93.6 3.9e-23   NR OMJ66244.1 5963 g76637 i0 90.2 619.948051948052 51 5 99.4 0 153 1 56 106 OMJ66244.1 hypothetical protein SteCoe_36987 [Stentor coeruleus] diamond 95472 94.4 0.991525423728813 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
32929132 32929132 PRJEB6584g_S_NODE_1017_length_292_cov_3.097276_g1005_i0 PRJEB6584 1017 292 3.097276 9.04404592 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 49.7 2.46e-4   NR CDW75723.1 5949 g1005 i0 38.5 0.934931506849315 91 54 93.5 1 18 290 1355 1443 CDW75723.1 UNKNOWN [Stylonychia lemnae] diamond 273 49.7 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
32929167 32929167 PRJEB6584j_S_NODE_1329_length_280_cov_2.861224_g1300_i0 PRJEB6584 1329 280 2.861224 8.0114272 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 48.1 7.71e-4   NR CDW75723.1 5949 g1300 i0 39 0.825 77 45 82.5 1 26 256 1348 1422 CDW75723.1 UNKNOWN [Stylonychia lemnae] diamond 231 48.1 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
32929357 32929357 PRJEB6584o_S_NODE_16313_length_220_cov_2.054054_g16205_i0 PRJEB6584 16313 220 2.054054 4.5189188 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 75.5 3.17e-15   NR CAD8050189.1 65129 g16205 i0 64 0.681818181818182 50 18 68.2 0 220 71 97 146 CAD8050189.1 unnamed protein product [Paramecium sonneborni] diamond 150 75.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
32946236 32946236 PRJEB6584e_S_NODE_2138_length_197_cov_3.351852_g2123_i0 PRJEB6584 2138 197 3.351852 6.60314844 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 79.3 2.33e-16   NR OMJ89280.1 5963 g2123 i0 59.4 0.974619289340102 64 26 97.5 0 197 6 100 163 OMJ89280.1 hypothetical protein SteCoe_8577 [Stentor coeruleus] diamond 192 79.3 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
32964010 32964010 PRJEB6584o_S_NODE_68842_length_158_cov_2.357724_g68734_i0 PRJEB6584 68842 158 2.357724 3.72520392 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00246   NR XP_001023200.2 312017 g68734 i0 90.5 0.39873417721519 21 2 39.9 0 100 38 275 295 XP_001023200.2 ZZ-type zinc finger protein [Tetrahymena thermophila SB210] diamond 63 44.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
32974548 32974548 PRJEB6584o_S_NODE_14394_length_232_cov_7299.517766_g14286_i0 PRJEB6584 14394 232 7299.517766 16934.88121712 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 45.4 4.14e-4   NR OMJ91894.1 5963 g14286 i0 52.8 1.42241379310345 36 17 46.6 0 47 154 39 74 OMJ91894.1 hypothetical protein SteCoe_5452 [Stentor coeruleus] diamond 330 45.4 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
32974553 32974553 PRJEB6584o_S_NODE_17026_length_216_cov_1.651934_g16918_i0 PRJEB6584 17026 216 1.651934 3.56817744 root 1 Root_unresolved Root_unresolved 88.2 8.85e-19   NR CAG9328608.1 1481888 g16918 i0 64.8 4.09722222222222 54 19 75 0 206 45 259 312 CAG9328608.1 unnamed protein product [Blepharisma stoltei] diamond 885 88.2 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
32980519 32980519 PRJEB6584e_S_NODE_35_length_705_cov_8.655224_g27_i0 PRJEB6584 35 705 8.655224 61.0193292 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 57.4 5.56e-6   NR OMJ75548.1 5963 g27 i0 38.5 0.553191489361702 65 38 26.8 1 494 306 114 178 OMJ75548.1 hypothetical protein SteCoe_25282 [Stentor coeruleus] diamond 390 57.4 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
32997433 32997433 PRJEB6584e_S_NODE_1027_length_255_cov_2.222727_g1012_i0 PRJEB6584 1027 255 2.222727 5.66795385 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 111 1.2499999999999998e-29   NR CDW83169.1 5949 g1012 i0 69.7 0.894117647058824 76 23 89.4 0 11 238 14 89 CDW83169.1 UNKNOWN [Stylonychia lemnae] diamond 228 111 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
33008500 33008500 PRJEB6584h_S_NODE_9427_length_206_cov_2.163743_g9365_i0 PRJEB6584 9427 206 2.163743 4.45731058 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 53.5 3.63e-6   NR CAD8082597.1 5886 g9365 i0 86.7 1.74757281553398 30 4 43.7 0 125 36 292 321 CAD8082597.1 unnamed protein product [Paramecium primaurelia] diamond 360 53.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
33048553 33048553 PRJEB6584h_S_NODE_28533_length_172_cov_4.364964_g28471_i0 PRJEB6584 28533 172 4.364964 7.50773808 Paramecium caudatum 5885 SAR_Eukaryotes SAR_Eukaryotes 46.6 3.23e-4   NR YP_003734453.1 5885 g28471 i0 84 0.436046511627907 25 4 43.6 0 57 131 35 59 YP_003734453.1 ribosomal protein L16 [Paramecium caudatum] diamond 75 46.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium caudatum
33048944 33048944 PRJEB6584o_S_NODE_34845_length_176_cov_3.382979_g34737_i0 PRJEB6584 34845 176 3.382979 5.95404304 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 92 1.71e-22   NR XP_001015607.1 312017 g34737 i0 91.8 0.835227272727273 49 4 83.5 0 153 7 55 103 XP_001015607.1 60S ribosomal protein L37a [Tetrahymena thermophila SB210] diamond 147 92 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
33059664 33059664 PRJEB6584f_S_NODE_4229_length_176_cov_2.780142_g4223_i0 PRJEB6584 4229 176 2.780142 4.89304992 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 42 0.0253   NR OMJ83458.1 5963 g4223 i0 41 2.0625 39 23 66.5 0 173 57 140 178 OMJ83458.1 hypothetical protein SteCoe_15627 [Stentor coeruleus] diamond 363 42 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
33059666 33059666 PRJEB6584h_S_NODE_28573_length_172_cov_1.459854_g28511_i0 PRJEB6584 28573 172 1.459854 2.51094888 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 55.5 6.14e-8   NR CDW88910.1 5949 g28511 i0 69.4 3.94186046511628 36 11 62.8 0 170 63 43 78 CDW88910.1 60s acidic ribosomal protein p1 [Stylonychia lemnae] diamond 678 55.5 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
33059668 33059668 PRJEB6584h_S_NODE_5605_length_238_cov_4.221675_g5543_i0 PRJEB6584 5605 238 4.221675 10.0475865 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 75.9 9.5e-16   NR YP_003734441.1 5885 g5543 i0 84.6 1.03361344537815 39 6 49.2 0 225 109 63 101 YP_003734441.1 ribosomal protein S14 [Paramecium caudatum] diamond 246 75.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium caudatum
33082747 33082747 PRJEB6584h_S_NODE_66238_length_159_cov_1.290323_g66176_i0 PRJEB6584 66238 159 1.290323 2.05161357 Paramecium caudatum 5885 SAR_Eukaryotes SAR_Eukaryotes 94.7 3.34e-21   NR YP_003734417.1 5885 g66176 i0 88.7 1 53 6 100 0 159 1 249 301 YP_003734417.1 Ymf66 [Paramecium caudatum] diamond 159 94.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium caudatum
33100248 33100248 PRJEB6584o_S_NODE_48550_length_167_cov_3.666667_g48442_i0 PRJEB6584 48550 167 3.666667 6.12333389 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 70.9 7.8e-13   NR NP_149367.1 5911 g48442 i0 89.5 0.682634730538922 38 4 68.3 0 144 31 219 256 NP_149367.1 ribosomal protein S13 [Tetrahymena thermophila] diamond 114 70.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
33116825 33116825 PRJEB6584h_S_NODE_24279_length_175_cov_1.428571_g24217_i0 PRJEB6584 24279 175 1.428571 2.49999925 Paramecium caudatum 5885 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.0051   NR YP_003734439.1 5885 g24217 i0 46.6 0.994285714285714 58 30 99.4 1 1 174 72 128 YP_003734439.1 NADH dehydrogenase subunit 2 [Paramecium caudatum] diamond 174 43.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium caudatum
33162008 33162008 PRJEB6584j_S_NODE_3096_length_227_cov_1.250000_g3067_i0 PRJEB6584 3096 227 1.25 2.8375 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 47.4 6.2e-4   NR CAD8154989.1 43138 g3067 i0 41.3 4.14977973568282 63 37 83.3 0 227 39 196 258 CAD8154989.1 unnamed protein product [Paramecium pentaurelia] diamond 942 47.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
33162010 33162010 PRJEB6584j_S_NODE_8616_length_182_cov_1.918367_g8587_i0 PRJEB6584 8616 182 1.918367 3.49142794 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 50.4 6.8e-6   NR XP_001437354.1 5888 g8587 i0 58.7 4.35164835164835 46 19 75.8 0 30 167 78 123 XP_001437354.1 uncharacterized protein GSPATT00007397001 [Paramecium tetraurelia] diamond 792 50.8 0.992125984251969 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia

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