RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

19 rows where analysis = "diamond", bioproject = "PRJNA404067" 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

  • PRJNA404067 · 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
22090897 22090897 PRJNA404067_P_NODE_15718_length_261_cov_22.830000_g15331_i0 PRJNA404067 15718 261 22.83 59.5863 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 119 1.47e-30   NR XP_001015941.1 312017 g15331 i0 78.8 1.50574712643678 66 14 75.9 0 2 199 254 319 XP_001015941.1 papain family cysteine protease [Tetrahymena thermophila SB210] diamond 393 120 0.991666666666667 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
24641308 24641308 PRJNA404067_P_NODE_4900_length_657_cov_7.877517_g4549_i0 PRJNA404067 4900 657 7.877517 51.75528669 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 150 2.53e-40   NR XP_001027337.1 312017 g4549 i0 83.3 0.383561643835616 84 14 38.4 0 280 531 237 320 XP_001027337.1 papain family cysteine protease [Tetrahymena thermophila SB210] diamond 252 150 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
26600308 26600308 PRJNA404067_P_NODE_7801_length_413_cov_8.105114_g7422_i0 PRJNA404067 7801 413 8.105114 33.47412082 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 72.8 6.55e-12   NR KAL4509737.1 5901 g7422 i0 68.3 0.595641646489104 41 13 29.8 0 235 357 358 398 KAL4509737.1 hypothetical protein ABPG73_022953 [Tetrahymena malaccensis] diamond 246 72.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
27233494 27233494 PRJNA404067_P_NODE_11243_length_318_cov_2.175097_g10858_i0 PRJNA404067 11243 318 2.175097 6.91680846 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 144 6.489999999999998e-42   NR XP_001025062.2 312017 g10858 i0 86.4 0.764150943396226 81 11 76.4 0 316 74 69 149 XP_001025062.2 40S ribosomal protein S24 [Tetrahymena thermophila SB210] diamond 243 144 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27991553 27991553 PRJNA404067_P_NODE_31605_length_208_cov_4.952381_g31218_i0 PRJNA404067 31605 208 4.952381 10.30095248 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 51.2 2.16e-5   NR XP_001027733.2 312017 g31218 i0 80.8 0.375 26 5 37.5 0 120 43 256 281 XP_001027733.2 FAD-binding domain oxidoreductase [Tetrahymena thermophila SB210] diamond 78 51.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28243812 28243812 PRJNA404067_P_NODE_10626_length_332_cov_3.597786_g10241_i0 PRJNA404067 10626 332 3.597786 11.94464952 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.0216   NR KAL4513026.1 2486642 g10241 i0 50 0.469879518072289 52 25 47 1 1 156 633 683 KAL4513026.1 hypothetical protein ABPG72_017711 [Tetrahymena utriculariae] diamond 156 44.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
28275454 28275454 PRJNA404067_P_NODE_14146_length_276_cov_5.604651_g13759_i0 PRJNA404067 14146 276 5.604651 15.46883676 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 101 2.95e-25   NR XP_001027647.1 312017 g13759 i0 83.6 1.19565217391304 55 9 59.8 0 276 112 85 139 XP_001027647.1 hypothetical protein TTHERM_00569430 [Tetrahymena thermophila SB210] diamond 330 101 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28765793 28765793 PRJNA404067_P_NODE_34687_length_205_cov_0.888889_g34300_i0 PRJNA404067 34687 205 0.888889 1.82222245 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 67.8 2.76e-11   NR XP_001448523.1 5888 g34300 i0 50.8 1.72682926829268 59 29 86.3 0 2 178 146 204 XP_001448523.1 uncharacterized protein GSPATT00039433001 [Paramecium tetraurelia] diamond 354 67.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
29349178 29349178 PRJNA404067_P_NODE_29909_length_211_cov_3.060000_g29522_i0 PRJNA404067 29909 211 3.06 6.4566 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0182   NR XP_001031355.1 312017 g29522 i0 76.9 0.369668246445498 26 6 37 0 210 133 162 187 XP_001031355.1 lipocalin/cytosolic fatty-acid-binding family protein [Tetrahymena thermophila SB210] diamond 78 42.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29380655 29380655 PRJNA404067_P_NODE_22129_length_230_cov_26.532544_g21742_i0 PRJNA404067 22129 230 26.532544 61.0248512 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 90.5 4.89e-19   NR XP_001019542.3 312017 g21742 i0 84.3 1.3304347826087 51 8 66.5 0 229 77 157 207 XP_001019542.3 DEAD/DEAH-box helicase family protein [Tetrahymena thermophila SB210] diamond 306 90.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29886059 29886059 PRJNA404067_P_NODE_4951_length_647_cov_82.488055_g4599_i0 PRJNA404067 4951 647 82.488055 533.69771585 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 64.3 2.76e-8   NR XP_001032335.2 312017 g4599 i0 83.8 0.343122102009274 37 6 17.2 0 238 348 66 102 XP_001032335.2 hypothetical protein TTHERM_00649410 [Tetrahymena thermophila SB210] diamond 222 64.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30534423 30534423 PRJNA404067_P_NODE_11653_length_310_cov_6.819277_g11267_i0 PRJNA404067 11653 310 6.819277 21.1397587 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 103 7.37e-24   NR XP_001008601.1 312017 g11267 i0 68.7 1.29677419354839 67 21 64.8 0 287 87 310 376 XP_001008601.1 acyltransferase [Tetrahymena thermophila SB210] diamond 402 103 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30549309 30549309 PRJNA404067_P_NODE_13333_length_286_cov_15.697778_g12946_i0 PRJNA404067 13333 286 15.697778 44.89564508 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 123 3.1299999999999997e-30   NR KAL4469333.1 2486642 g12946 i0 65.1 1.82517482517483 86 30 90.2 0 26 283 222 307 KAL4469333.1 hypothetical protein ABPG72_005969 [Tetrahymena utriculariae] diamond 522 123 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
30833717 30833717 PRJNA404067_P_NODE_23954_length_225_cov_18.646341_g23567_i0 PRJNA404067 23954 225 18.646341 41.95426725 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 82 4.18e-16   NR XP_001011033.2 312017 g23567 i0 81.8 0.733333333333333 55 10 73.3 0 3 167 214 268 XP_001011033.2 hypothetical protein TTHERM_00140960 [Tetrahymena thermophila SB210] diamond 165 82 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30945339 30945339 PRJNA404067_P_NODE_21114_length_233_cov_2.081395_g20727_i0 PRJNA404067 21114 233 2.081395 4.84965035 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 64.3 7.83e-10   NR XP_001015137.1 312017 g20727 i0 89.3 2.2274678111588 28 3 36.1 0 8 91 315 342 XP_001015137.1 papain family cysteine protease [Tetrahymena thermophila SB210] diamond 519 64.7 0.993817619783617 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31086498 31086498 PRJNA404067_P_NODE_11275_length_317_cov_14.335938_g10890_i0 PRJNA404067 11275 317 14.335938 45.44492346 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 73.9 5.39e-14   NR XP_001020023.3 312017 g10890 i0 87.2 0.369085173501577 39 5 36.9 0 15 131 119 157 XP_001020023.3 60S ribosomal protein L21 [Tetrahymena thermophila SB210] diamond 117 73.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31560996 31560996 PRJNA404067_P_NODE_34136_length_205_cov_9.625000_g33749_i0 PRJNA404067 34136 205 9.625 19.73125 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0109   NR XP_001024186.1 312017 g33749 i0 54.3 1.02439024390244 35 16 51.2 0 149 45 82 116 XP_001024186.1 transmembrane protein, putative [Tetrahymena thermophila SB210] diamond 210 42.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
32526968 32526968 PRJNA404067_P_NODE_41039_length_192_cov_3.908397_g40652_i0 PRJNA404067 41039 192 3.908397 7.50412224 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 77 1.62e-14   NR KAL4449174.1 5901 g40652 i0 90.2 1.28125 41 4 64.1 0 159 37 2822 2862 KAL4449174.1 hypothetical protein ABPG74_015556 [Tetrahymena malaccensis] diamond 246 77 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
32730676 32730676 PRJNA404067_P_NODE_25880_length_220_cov_14.446541_g25493_i0 PRJNA404067 25880 220 14.446541 31.7823902 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 58.5 4.59e-9   NR XP_001026284.1 312017 g25493 i0 67.6 0.504545454545455 37 12 50.5 0 7 117 63 99 XP_001026284.1 transmembrane protein, putative [Tetrahymena thermophila SB210] diamond 111 58.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila

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