RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA478247" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 27 ✖

tax_clade 1

bioproject 1

  • PRJNA478247 · 27 ✖

analysis 1

  • diamond · 27 ✖

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
9375576 9375576 PRJNA478247_P_NODE_108_length_1371_cov_5.963487_g74_i0 PRJNA478247 108 1371 5.963487 81.75940677 Spathidium sp. 35110 SAR_Eukaryotes SAR_Eukaryotes 637 1.6e-226   NR AAD03260.1 35110 g74 i0 79 0.842450765864333 385 81 84.2 0 1262 108 22 406 AAD03260.1 translation elongation factor 1-alpha, partial [Spathidium sp.] diamond 1155 637 1 Eukaryota Sar   Ciliophora Litostomatea Haptorida Spathidiidae Spathidium Spathidium sp.
10651457 10651457 PRJNA478247_P_NODE_1169_length_365_cov_2.330357_g1063_i0 PRJNA478247 1169 365 2.330357 8.50580305 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 172 3.76e-50   NR XP_012653030.1 312017 g1063 i0 66.9 1.97260273972603 121 38 97.8 1 6 362 95 215 XP_012653030.1 papain family cysteine protease [Tetrahymena thermophila SB210] diamond 720 172 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
11926416 11926416 PRJNA478247_P_NODE_930_length_428_cov_4.488722_g824_i0 PRJNA478247 930 428 4.488722 19.21173016 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 105 3.9e-26   NR O97484.1 5936 g824 i0 76.8 3.17523364485981 69 16 48.4 0 325 119 15 83 O97484.1 RecName: Full=Histone H2B [Moneuplotes crassus] diamond 1359 105 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
19573561 19573561 PRJNA478247_P_NODE_2596_length_203_cov_1.689655_g2490_i0 PRJNA478247 2596 203 1.689655 3.42999965 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 103 5.59e-24   NR XP_001023996.2 312017 g2490 i0 72.7 0.975369458128079 66 18 97.5 0 5 202 351 416 XP_001023996.2 protein disulfide-isomerase [Tetrahymena thermophila SB210] diamond 198 103 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27297524 27297524 PRJNA478247_P_NODE_2143_length_233_cov_2.779412_g2037_i0 PRJNA478247 2143 233 2.779412 6.47602996 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 91.3 1.55e-19   NR XP_001027526.3 312017 g2037 i0 64 0.965665236051502 75 23 96.6 1 226 2 327 397 XP_001027526.3 Ndc1 protein [Tetrahymena thermophila SB210] diamond 225 91.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27802955 27802955 PRJNA478247_P_NODE_2064_length_241_cov_2.268868_g1958_i0 PRJNA478247 2064 241 2.268868 5.46797188 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 99 1.11e-22   NR XP_001029851.1 312017 g1958 i0 59.2 0.946058091286307 76 28 90.9 1 3 221 250 325 XP_001029851.1 papain family cysteine protease [Tetrahymena thermophila SB210] diamond 228 99 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27929158 27929158 PRJNA478247_P_NODE_1885_length_256_cov_1.784141_g1779_i0 PRJNA478247 1885 256 1.784141 4.56740096 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 53.1 8.77e-6   NR XP_001014438.3 312017 g1779 i0 52.9 0.59765625 51 24 59.8 0 155 3 310 360 XP_001014438.3 hypothetical protein TTHERM_00522600 [Tetrahymena thermophila SB210] diamond 153 53.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27929159 27929159 PRJNA478247_P_NODE_3205_length_167_cov_1.130435_g3099_i0 PRJNA478247 3205 167 1.130435 1.88782645 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 54.7 1.38e-7   NR KRX08905.1 266149 g3099 i0 59 0.70059880239521 39 16 70.1 0 165 49 60 98 KRX08905.1 hypothetical protein PPERSA_09009 [Pseudocohnilembus persalinus] diamond 117 54.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
28055264 28055264 PRJNA478247_P_NODE_1025_length_400_cov_2.156334_g919_i0 PRJNA478247 1025 400 2.156334 8.625336 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 69.7 6.62e-11   NR KAL4438764.1 5901 g919 i0 41.3 1.815 121 70 90.8 1 29 391 1 120 KAL4438764.1 hypothetical protein ABPG74_013437 [Tetrahymena malaccensis] diamond 726 69.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
28213012 28213012 PRJNA478247_P_NODE_3386_length_159_cov_2.423077_g3280_i0 PRJNA478247 3386 159 2.423077 3.85269243 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0161   NR KAL4438764.1 5901 g3280 i0 55 1.49056603773585 40 17 75.5 1 2 121 251 289 KAL4438764.1 hypothetical protein ABPG74_013437 [Tetrahymena malaccensis] diamond 237 42.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
28608275 28608275 PRJNA478247_P_NODE_1247_length_349_cov_3.150000_g1141_i0 PRJNA478247 1247 349 3.15 10.9935 Heterotrichida 5957 SAR_Eukaryotes SAR_Eukaryotes 48.1 0.00159   NR OMJ75904.1 5963 g1141 i0 37.7 1.89971346704871 69 28 59.3 3 333 127 394 447 OMJ75904.1 hypothetical protein SteCoe_24844 [Stentor coeruleus] diamond 663 48.5 0.991752577319588 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
28781405 28781405 PRJNA478247_P_NODE_907_length_434_cov_2.446914_g801_i0 PRJNA478247 907 434 2.446914 10.61960676 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 61.2 8.43e-8   NR TNV83405.1 5974 g801 i0 40.3 0.532258064516129 77 45 53.2 1 204 434 275 350 TNV83405.1 hypothetical protein FGO68_gene8923 [Halteria grandinella] diamond 231 61.2 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
28876272 28876272 PRJNA478247_P_NODE_568_length_596_cov_2.296296_g467_i0 PRJNA478247 568 596 2.296296 13.68592416 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 190 2.1199999999999996e-55   NR XP_001010301.1 312017 g467 i0 54.5 1.87751677852349 191 87 96.1 0 573 1 158 348 XP_001010301.1 granule lattice protein [Tetrahymena thermophila SB210] diamond 1119 190 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28907630 28907630 PRJNA478247_P_NODE_1228_length_353_cov_2.009259_g1122_i0 PRJNA478247 1228 353 2.009259 7.09268427 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 124 3.5e-31   NR XP_001028123.3 312017 g1122 i0 60.9 1.95467422096317 115 45 97.7 0 8 352 258 372 XP_001028123.3 hypothetical protein TTHERM_00527180 [Tetrahymena thermophila SB210] diamond 690 124 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29381512 29381512 PRJNA478247_P_NODE_409_length_733_cov_3.208807_g322_i0 PRJNA478247 409 733 3.208807 23.52055531 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 310 1.68e-102   NR OMJ65538.1 5963 g322 i0 63.9 1.90723055934516 233 78 92.9 3 686 6 75 307 OMJ65538.1 hypothetical protein SteCoe_38039 [Stentor coeruleus] diamond 1398 310 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
29428964 29428964 PRJNA478247_P_NODE_2669_length_198_cov_1.704142_g2563_i0 PRJNA478247 2669 198 1.704142 3.37420116 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 84.7 1.29e-18   NR CAI2381176.1 5936 g2563 i0 63.1 1.93939393939394 65 24 98.5 0 197 3 101 165 CAI2381176.1 unnamed protein product [Moneuplotes crassus] diamond 384 84.7 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
29555304 29555304 PRJNA478247_P_NODE_1570_length_294_cov_1.739623_g1464_i0 PRJNA478247 1570 294 1.739623 5.11449162 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 96.7 3.87e-21   NR KRX11205.1 266149 g1464 i0 50 2.78571428571429 84 42 85.7 0 3 254 306 389 KRX11205.1 Translation elongation factor EF1B, gamma chain, conserved [Pseudocohnilembus persalinus] diamond 819 97.4 0.992813141683778 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
30187036 30187036 PRJNA478247_P_NODE_1672_length_282_cov_1.992095_g1566_i0 PRJNA478247 1672 282 1.992095 5.6177079 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 89 1.43e-19   NR KAL4468709.1 5901 g1566 i0 45.2 4.9468085106383 93 51 98.9 0 280 2 102 194 KAL4468709.1 hypothetical protein ABPG74_005212 [Tetrahymena malaccensis] diamond 1395 89.4 0.995525727069351 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
30266126 30266126 PRJNA478247_P_NODE_3292_length_163_cov_2.201493_g3186_i0 PRJNA478247 3292 163 2.201493 3.58843359 Sterkiella histriomuscorum 94289 SAR_Eukaryotes SAR_Eukaryotes 76.3 1.94e-14   NR AEX87964.1 94289 g3186 i0 63 1.98773006134969 54 20 99.4 0 1 162 477 530 AEX87964.1 Otiwi2 [Sterkiella histriomuscorum] diamond 324 76.3 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum
30518600 30518600 PRJNA478247_P_NODE_2193_length_229_cov_1.890000_g2087_i0 PRJNA478247 2193 229 1.89 4.3281 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 75.1 1.01e-13   NR XP_001022598.3 312017 g2087 i0 81.6 0.641921397379913 49 9 64.2 0 81 227 146 194 XP_001022598.3 granule lattice protein [Tetrahymena thermophila SB210] diamond 147 75.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30581583 30581583 PRJNA478247_P_NODE_3133_length_171_cov_1.753521_g3027_i0 PRJNA478247 3133 171 1.753521 2.99852091 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 65.5 1.23e-10   NR KAL4450340.1 5901 g3027 i0 71.4 0.859649122807018 49 14 86 0 166 20 324 372 KAL4450340.1 hypothetical protein ABPG74_009046 [Tetrahymena malaccensis] diamond 147 65.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
30708124 30708124 PRJNA478247_P_NODE_854_length_449_cov_3.442857_g749_i0 PRJNA478247 854 449 3.442857 15.45842793 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 56.6 1.12e-6   NR KAL4501700.1 2486642 g749 i0 39.1 0.734966592427617 110 56 66.1 3 331 35 61 170 KAL4501700.1 hypothetical protein ABPG72_018751 [Tetrahymena utriculariae] diamond 330 56.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
31466902 31466902 PRJNA478247_P_NODE_3636_length_150_cov_1.561983_g3530_i0 PRJNA478247 3636 150 1.561983 2.3429745 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 77.8 2.48e-15   NR XP_001032358.2 312017 g3530 i0 75.5 0.98 49 12 98 0 149 3 203 251 XP_001032358.2 60S acidic ribosomal protein P0 [Tetrahymena thermophila SB210] diamond 147 77.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31814672 31814672 PRJNA478247_P_NODE_2337_length_219_cov_1.831579_g2231_i0 PRJNA478247 2337 219 1.831579 4.01115801 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 68.9 3.15e-12   NR XP_012651615.1 312017 g2231 i0 58.1 1.67123287671233 62 26 84.9 0 3 188 56 117 XP_012651615.1 granule lattice protein [Tetrahymena thermophila SB210] diamond 366 68.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
32036118 32036118 PRJNA478247_P_NODE_1598_length_291_cov_1.297710_g1492_i0 PRJNA478247 1598 291 1.29771 3.7763361 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 58.9 1.24e-7   NR CAG9326055.1 1481888 g1492 i0 29.2 0.989690721649485 96 60 99 2 3 290 170 257 CAG9326055.1 unnamed protein product [Blepharisma stoltei] diamond 288 58.9 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
32463724 32463724 PRJNA478247_P_NODE_3199_length_167_cov_1.891304_g3093_i0 PRJNA478247 3199 167 1.891304 3.15847768 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 59.7 5.41e-9   NR CAI2377055.1 5936 g3093 i0 66.7 8.08383233532934 45 15 80.8 0 3 137 159 203 CAI2377055.1 unnamed protein product [Moneuplotes crassus] diamond 1350 60.1 0.993344425956739 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
32731524 32731524 PRJNA478247_P_NODE_1820_length_264_cov_2.055319_g1714_i0 PRJNA478247 1820 264 2.055319 5.42604216 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 52.8 1.33e-5   NR KAL4450340.1 5901 g1714 i0 41.8 0.761363636363636 67 34 76.1 2 251 51 139 200 KAL4450340.1 hypothetical protein ABPG74_009046 [Tetrahymena malaccensis] diamond 201 52.8 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);;