RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1126661 · 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
27765484 27765484 PRJNA1126661_P_NODE_80644_length_222_cov_12.201342_g80114_i0 PRJNA1126661 80644 222 12.201342 27.08697924 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 75.5 7.09e-14   NR XP_001022598.3 312017 g80114 i0 86 0.581081081081081 43 6 58.1 0 28 156 1 43 XP_001022598.3 granule lattice protein [Tetrahymena thermophila SB210] diamond 129 75.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28460097 28460097 PRJNA1126661_P_NODE_60486_length_276_cov_6.921182_g59956_i0 PRJNA1126661 60486 276 6.921182 19.10246232 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 55.1 9.55e-7   NR XP_001032077.2 312017 g59956 i0 92.6 0.293478260869565 27 2 29.3 0 196 276 1 27 XP_001032077.2 ADP-ribosylation factor(Arf)/Arf-like (Arl) small GTPase family protein [Tetrahymena thermophila SB210] diamond 81 55.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28491569 28491569 PRJNA1126661_P_NODE_42707_length_300_cov_6.484581_g42178_i0 PRJNA1126661 42707 300 6.484581 19.453743 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 72 3.98e-12   NR XP_001015014.2 312017 g42178 i0 47.1 1.75 85 24 64 1 192 1 139 223 XP_001015014.2 hypothetical protein TTHERM_00673440 [Tetrahymena thermophila SB210] diamond 525 72 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28901768 28901768 PRJNA1126661_P_NODE_69868_length_253_cov_4.522222_g69338_i0 PRJNA1126661 69868 253 4.522222 11.44122166 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 88.2 5.28e-21   NR XP_001013338.3 312017 g69338 i0 87.5 0.569169960474308 48 6 56.9 0 86 229 5 52 XP_001013338.3 ribosome associated membrane protein RAMP4 [Tetrahymena thermophila SB210] diamond 144 88.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29091525 29091525 PRJNA1126661_P_NODE_71228_length_250_cov_3.875706_g70698_i0 PRJNA1126661 71228 250 3.875706 9.689265 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 135 9.38e-35   NR XP_012655235.1 312017 g70698 i0 88.9 0.864 72 8 86.4 0 33 248 17 88 XP_012655235.1 Dpy-30 motif protein [Tetrahymena thermophila SB210] diamond 216 135 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29249142 29249142 PRJNA1126661_P_NODE_82729_length_214_cov_14.468085_g82199_i0 PRJNA1126661 82729 214 14.468085 30.9617019 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 80.1 2.91e-17   NR XP_001021131.1 312017 g82199 i0 68 0.700934579439252 50 16 70.1 0 157 8 12 61 XP_001021131.1 transmembrane protein, putative [Tetrahymena thermophila SB210] diamond 150 80.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29438326 29438326 PRJNA1126661_P_NODE_86650_length_202_cov_7.317829_g86120_i0 PRJNA1126661 86650 202 7.317829 14.78201458 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 48.9 1.5e-4   NR KAL4511596.1 2486642 g86120 i0 75 0.831683168316832 28 7 41.6 0 59 142 913 940 KAL4511596.1 hypothetical protein ABPG72_012441 [Tetrahymena utriculariae] diamond 168 48.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
30291898 30291898 PRJNA1126661_P_NODE_62612_length_271_cov_7.979798_g62082_i0 PRJNA1126661 62612 271 7.979798 21.62525258 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 85.9 1.39e-19   NR XP_001023430.1 312017 g62082 i0 92.3 0.431734317343173 39 3 43.2 0 25 141 47 85 XP_001023430.1 hypothetical protein TTHERM_00535210 [Tetrahymena thermophila SB210] diamond 117 85.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30860227 30860227 PRJNA1126661_P_NODE_74914_length_241_cov_3.136905_g74384_i0 PRJNA1126661 74914 241 3.136905 7.55994105 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 48.1 4.76e-4   NR XP_001013394.2 312017 g74384 i0 29.5 0.970954356846473 78 53 94.6 2 232 5 2212 2289 XP_001013394.2 C2 domain protein [Tetrahymena thermophila SB210] diamond 234 48.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30891953 30891953 PRJNA1126661_P_NODE_48674_length_297_cov_6.254464_g48145_i0 PRJNA1126661 48674 297 6.254464 18.57575808 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 61.6 8.91e-10   NR XP_001025269.1 312017 g48145 i0 55 1.21212121212121 60 27 60.6 0 21 200 15 74 XP_001025269.1 60S acidic ribosomal protein [Tetrahymena thermophila SB210] diamond 360 61.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30891954 30891954 PRJNA1126661_P_NODE_48974_length_297_cov_4.205357_g48445_i0 PRJNA1126661 48974 297 4.205357 12.48991029 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 50.4 2.14e-5   NR KAL4428921.1 5901 g48445 i0 45.5 0.555555555555556 55 24 49.5 1 77 223 28 82 KAL4428921.1 hypothetical protein ABPG74_017511 [Tetrahymena malaccensis] diamond 165 50.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
30986748 30986748 PRJNA1126661_P_NODE_87314_length_200_cov_12.000000_g86784_i0 PRJNA1126661 87314 200 12 24 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 83.2 5.58e-18   NR XP_001026380.3 312017 g86784 i0 94.9 1.155 39 2 58.5 0 117 1 42 80 XP_001026380.3 ubiquitin-conjugating enzyme [Tetrahymena thermophila SB210] diamond 231 83.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31239246 31239246 PRJNA1126661_P_NODE_40015_length_301_cov_3.399123_g39486_i0 PRJNA1126661 40015 301 3.399123 10.23136023 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 66.6 2.61e-10   NR CAD8137869.1 43137 g39486 i0 34.5 1.44518272425249 145 48 99.7 5 300 1 192 334 CAD8137869.1 unnamed protein product [Paramecium octaurelia] diamond 435 66.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
31524173 31524173 PRJNA1126661_P_NODE_69396_length_254_cov_6.298343_g68866_i0 PRJNA1126661 69396 254 6.298343 15.99779122 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 103 2.21e-24   NR XP_001032358.2 312017 g68866 i0 73.8 0.94488188976378 80 19 92.1 2 235 2 239 318 XP_001032358.2 60S acidic ribosomal protein P0 [Tetrahymena thermophila SB210] diamond 240 103 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31555935 31555935 PRJNA1126661_P_NODE_57436_length_283_cov_5.680952_g56907_i0 PRJNA1126661 57436 283 5.680952 16.07709416 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 51.2 5.93e-5   NR XP_001010031.1 312017 g56907 i0 48.4 0.964664310954064 91 45 96.5 2 281 9 276 364 XP_001010031.1 Serine/Threonine kinase domain protein [Tetrahymena thermophila SB210] diamond 273 51.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31618910 31618910 PRJNA1126661_P_NODE_65076_length_266_cov_1.616580_g64546_i0 PRJNA1126661 65076 266 1.61658 4.3001028 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 78.6 8.28e-15   NR XP_001014319.1 312017 g64546 i0 66.7 0.642857142857143 57 19 64.3 0 171 1 12 68 XP_001014319.1 patatin family phospholipase [Tetrahymena thermophila SB210] diamond 171 78.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31702913 31702913 PRJNA1126661_P_NODE_70977_length_251_cov_0.876404_g70447_i0 PRJNA1126661 70977 251 0.876404 2.19977404 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 58.9 7.86e-8   NR YP_740791.1 5905 g70447 i0 93.1 0.693227091633466 29 2 34.7 0 87 1 4 32 YP_740791.1 apocytochrome b [Tetrahymena paravorax] diamond 174 58.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena paravorax
31745330 31745330 PRJNA1126661_P_NODE_37517_length_301_cov_4.447368_g36988_i0 PRJNA1126661 37517 301 4.447368 13.38657768 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 64.3 5.07e-10   NR XP_004034912.1 5932 g36988 i0 53.6 3.92691029900332 56 25 55.8 1 300 133 89 143 XP_004034912.1 hypothetical protein IMG5_109970 [Ichthyophthirius multifiliis] diamond 1182 64.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
32030267 32030267 PRJNA1126661_P_NODE_19518_length_326_cov_4.007905_g18989_i0 PRJNA1126661 19518 326 4.007905 13.0657703 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 90.9 3.96e-20   NR XP_004024111.1 5932 g18989 i0 76.9 1.75766871165644 65 13 59.8 1 2 196 118 180 XP_004024111.1 hypothetical protein IMG5_199680 [Ichthyophthirius multifiliis] diamond 573 90.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis

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