RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJNA1111077" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 31 ✖

tax_clade 1

bioproject 1

  • PRJNA1111077 · 31 ✖

analysis 1

  • diamond · 31 ✖

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
14243376 14243376 PRJNA1111077_P_NODE_18752_length_291_cov_1.798165_g18531_i0 PRJNA1111077 18752 291 1.798165 5.23266015 Tetrahymenidae 291294 SAR_Eukaryotes SAR_Eukaryotes 100 3.799999999999999e-24   NR XP_004036474.1 5932 g18531 i0 84.2 1.5360824742268 57 9 58.8 0 290 120 73 129 XP_004036474.1 hypothetical protein IMG5_081220 [Ichthyophthirius multifiliis] diamond 447 100 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
27478543 27478543 PRJNA1111077_P_NODE_18483_length_292_cov_2.378995_g18262_i0 PRJNA1111077 18483 292 2.378995 6.9466654 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 49.3 1.43e-4   NR KAL4476154.1 5901 g18262 i0 80.8 0.267123287671233 26 5 26.7 0 1 78 143 168 KAL4476154.1 hypothetical protein ABPG74_009887 [Tetrahymena malaccensis] diamond 78 49.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
27636589 27636589 PRJNA1111077_P_NODE_34944_length_244_cov_0.900585_g34723_i0 PRJNA1111077 34944 244 0.900585 2.1974274 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 110 4.15e-26   NR KAL4440938.1 5901 g34723 i0 71.8 1.74590163934426 71 20 87.3 0 244 32 1032 1102 KAL4440938.1 hypothetical protein ABPG74_009351 [Tetrahymena malaccensis] diamond 426 110 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
27794455 27794455 PRJNA1111077_P_NODE_18224_length_293_cov_6.268182_g18003_i0 PRJNA1111077 18224 293 6.268182 18.36577326 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 85.1 9.13e-17   NR XP_001017190.2 312017 g18003 i0 70 0.511945392491468 50 15 51.2 0 279 130 2738 2787 XP_001017190.2 cation channel family protein [Tetrahymena thermophila SB210] diamond 150 85.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27911604 27911604 PRJNA1111077_P_NODE_24285_length_272_cov_2.115578_g24064_i0 PRJNA1111077 24285 272 2.115578 5.75437216 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 128 8.689999999999998e-35   NR KAL4432936.1 5901 g24064 i0 52.4 4.10294117647059 124 21 94.9 1 271 14 50 173 KAL4432936.1 hypothetical protein ABPG74_014450 [Tetrahymena malaccensis] diamond 1116 128 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
28204580 28204580 PRJNA1111077_P_NODE_36446_length_241_cov_1.666667_g36225_i0 PRJNA1111077 36446 241 1.666667 4.01666747 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0374   NR KAL4484314.1 2486642 g36225 i0 36.2 0.5850622406639 47 30 58.5 0 32 172 98 144 KAL4484314.1 hypothetical protein ABPG72_006425 [Tetrahymena utriculariae] diamond 141 42.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
28488989 28488989 PRJNA1111077_P_NODE_27627_length_260_cov_1.973262_g27406_i0 PRJNA1111077 27627 260 1.973262 5.1304812 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 49.7 1.65e-4   NR KAL4508465.1 2486642 g27406 i0 51.3 0.45 39 19 45 0 229 113 667 705 KAL4508465.1 hypothetical protein ABPG72_003769 [Tetrahymena utriculariae] diamond 117 49.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
28574870 28574870 PRJNA1111077_P_NODE_36767_length_241_cov_0.916667_g36546_i0 PRJNA1111077 36767 241 0.916667 2.20916747 Oligohymenophorea 6020 SAR_Eukaryotes SAR_Eukaryotes 107 7.54e-25   NR KAL4460894.1 5901 g36546 i0 65.4 4.9045643153527 78 27 97.1 0 3 236 440 517 KAL4460894.1 hypothetical protein ABPG74_016366 [Tetrahymena malaccensis] diamond 1182 107 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
28615317 28615317 PRJNA1111077_P_NODE_7467_length_425_cov_2.127841_g7246_i0 PRJNA1111077 7467 425 2.127841 9.04332425 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 185 4.49e-51   NR XP_001015953.2 312017 g7246 i0 69.4 0.875294117647059 124 37 86.8 1 5 373 1232 1355 XP_001015953.2 Na,H/K antiporter P-type ATPase alpha subunit family protein [Tetrahymena thermophila SB210] diamond 372 185 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28867780 28867780 PRJNA1111077_P_NODE_15068_length_310_cov_3.814346_g14847_i0 PRJNA1111077 15068 310 3.814346 11.8244726 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 64.7 8e-11   NR XP_004030095.1 5932 g14847 i0 68 0.483870967741935 50 15 48.4 1 310 161 28 76 XP_004030095.1 hypothetical protein IMG5_167680 [Ichthyophthirius multifiliis] diamond 150 64.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
28985662 28985662 PRJNA1111077_P_NODE_34108_length_245_cov_0.895349_g33887_i0 PRJNA1111077 34108 245 0.895349 2.19360505 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 89.4 1.55e-18   NR KAL4471358.1 5901 g33887 i0 61.3 1.95918367346939 80 31 98 0 245 6 3066 3145 KAL4471358.1 hypothetical protein ABPG74_008251 [Tetrahymena malaccensis] diamond 480 89.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
29017296 29017296 PRJNA1111077_P_NODE_15928_length_310_cov_2.578059_g15707_i0 PRJNA1111077 15928 310 2.578059 7.9919829 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 68.6 7.07e-11   NR KAL4470032.1 5901 g15707 i0 71.4 0.948387096774194 49 14 47.4 0 308 162 981 1029 KAL4470032.1 hypothetical protein ABPG73_016768 [Tetrahymena malaccensis] diamond 294 68.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
29175014 29175014 PRJNA1111077_P_NODE_32129_length_248_cov_0.880000_g31908_i0 PRJNA1111077 32129 248 0.88 2.1824 Oligohymenophorea 6020 SAR_Eukaryotes SAR_Eukaryotes 82 6.02e-16   NR CAD8066002.1 5886 g31908 i0 59 1.4758064516129 61 25 73.8 0 3 185 3811 3871 CAD8066002.1 unnamed protein product [Paramecium primaurelia] diamond 366 82.8 0.990338164251208 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
29373043 29373043 PRJNA1111077_P_NODE_20149_length_286_cov_1.981221_g19928_i0 PRJNA1111077 20149 286 1.981221 5.66629206 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 61.2 1.19e-9   NR Q22DH9.1 312017 g19928 i0 90.6 0.671328671328671 32 3 33.6 0 285 190 80 111 Q22DH9.1 RecName: Full=Large ribosomal subunit protein eL31; AltName: Full=60S ribosomal protein L31 [Tetrahymena thermophila SB210] diamond 192 61.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29720069 29720069 PRJNA1111077_P_NODE_30270_length_251_cov_0.865169_g30049_i0 PRJNA1111077 30270 251 0.865169 2.17157419 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 63.2 6.4e-10   NR P0DJ18.1 5911 g30049 i0 73 0.442231075697211 37 10 44.2 0 246 136 153 189 P0DJ18.1 RecName: Full=Large ribosomal subunit protein eL20; AltName: Full=60S ribosomal protein L18a [Tetrahymena thermophila] diamond 111 63.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29720075 29720075 PRJNA1111077_P_NODE_36070_length_242_cov_0.911243_g35849_i0 PRJNA1111077 36070 242 0.911243 2.20520806 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 142 1.44e-38   NR XP_001023266.1 312017 g35849 i0 93.2 0.91735537190082606 74 5 91.7 0 240 19 309 382 XP_001023266.1 hypothetical protein TTHERM_00494830 [Tetrahymena thermophila SB210] diamond 222 142 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30004676 30004676 PRJNA1111077_P_NODE_30871_length_250_cov_0.870056_g30650_i0 PRJNA1111077 30871 250 0.870056 2.17514 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 50.4 7.95e-5   NR KAL4488388.1 2486642 g30650 i0 33.3 1.656 69 46 82.8 0 241 35 47 115 KAL4488388.1 hypothetical protein ABPG72_019238 [Tetrahymena utriculariae] diamond 414 50.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
30289299 30289299 PRJNA1111077_P_NODE_13552_length_322_cov_1.361446_g13331_i0 PRJNA1111077 13552 322 1.361446 4.38385612 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 191 4.95e-57   NR XP_001017488.2 312017 g13331 i0 86.9 0.996894409937888 107 14 99.7 0 2 322 228 334 XP_001017488.2 60S ribosomal protein L4 [Tetrahymena thermophila SB210] diamond 321 191 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30352677 30352677 PRJNA1111077_P_NODE_34792_length_244_cov_0.900585_g34571_i0 PRJNA1111077 34792 244 0.900585 2.1974274 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 48.5 3.55e-4   NR XP_976973.2 312017 g34571 i0 100 0.282786885245902 23 0 28.3 0 201 133 964 986 XP_976973.2 ATPase, histidine kinase-, DNA gyrase B [Tetrahymena thermophila SB210] diamond 69 48.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30447085 30447085 PRJNA1111077_P_NODE_36253_length_242_cov_0.911243_g36032_i0 PRJNA1111077 36253 242 0.911243 2.20520806 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 137 1.4e-35   NR XP_001030432.2 312017 g36032 i0 87.3 0.979338842975207 79 10 97.9 0 242 6 954 1032 XP_001030432.2 sarco/endoplasmic reticulum calcium-translocating P-type ATPase [Tetrahymena thermophila SB210] diamond 237 137 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30510052 30510052 PRJNA1111077_P_NODE_17833_length_296_cov_2.919283_g17612_i0 PRJNA1111077 17833 296 2.919283 8.64107768 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 113 8.539999999999998e-30   NR XP_004037451.1 5932 g17612 i0 54.3 2.36148648648649 116 33 98.3 2 6 296 1 115 XP_004037451.1 hypothetical protein IMG5_051430 [Ichthyophthirius multifiliis] diamond 699 113 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
30510073 30510073 PRJNA1111077_P_NODE_38053_length_226_cov_3.313725_g37832_i0 PRJNA1111077 38053 226 3.313725 7.4890185 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 80.1 1.92e-15   NR XP_004027364.1 5932 g37832 i0 54.5 2.04424778761062 77 32 98.2 1 3 224 327 403 XP_004027364.1 npl4 family protein, putative [Ichthyophthirius multifiliis] diamond 462 80.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
30636301 30636301 PRJNA1111077_P_NODE_37853_length_229_cov_2.852564_g37632_i0 PRJNA1111077 37853 229 2.852564 6.53237156 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 134 7.279999999999998e-35   NR XP_001024536.1 312017 g37632 i0 83.3 0.943231441048035 72 12 94.3 0 12 227 427 498 XP_001024536.1 membrane protein, putative [Tetrahymena thermophila SB210] diamond 216 134 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30636302 30636302 PRJNA1111077_P_NODE_38513_length_196_cov_5.634146_g38292_i0 PRJNA1111077 38513 196 5.634146 11.04292616 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 60.1 1.55e-8   NR XP_001010914.2 312017 g38292 i0 93.1 0.443877551020408 29 2 44.4 0 109 195 717 745 XP_001010914.2 hypothetical protein TTHERM_01094820 [Tetrahymena thermophila SB210] diamond 87 60.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31236718 31236718 PRJNA1111077_P_NODE_36115_length_242_cov_0.911243_g35894_i0 PRJNA1111077 36115 242 0.911243 2.20520806 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 60.5 2.08e-8   NR KAL4511700.1 2486642 g35894 i0 58.2 1.36363636363636 55 23 68.2 0 77 241 685 739 KAL4511700.1 hypothetical protein ABPG72_012545 [Tetrahymena utriculariae] diamond 330 60.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
31259725 31259725 PRJNA1111077_P_NODE_5915_length_472_cov_3.250627_g5694_i0 PRJNA1111077 5915 472 3.250627 15.34295944 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 52.4 5.66e-5   NR OMJ89086.1 5963 g5694 i0 34.7 0.838983050847458 98 64 62.3 0 328 35 11 108 OMJ89086.1 hypothetical protein SteCoe_8807 [Stentor coeruleus] diamond 396 52.8 0.992424242424242 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
31291198 31291198 PRJNA1111077_P_NODE_35335_length_243_cov_0.905882_g35114_i0 PRJNA1111077 35335 243 0.905882 2.20129326 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 115 9.52e-30   NR CAD8161119.1 43137 g35114 i0 68.7 8.12345679012346 83 24 100 1 1 243 72 154 CAD8161119.1 unnamed protein product [Paramecium octaurelia] diamond 1974 116 0.991379310344828 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
31553370 31553370 PRJNA1111077_P_NODE_24536_length_271_cov_3.590909_g24315_i0 PRJNA1111077 24536 271 3.590909 9.73136339 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.038   NR CAI2378713.1 5936 g24315 i0 48.9 0.520295202952029 47 24 52 0 18 158 608 654 CAI2378713.1 unnamed protein product [Moneuplotes crassus] diamond 141 43.1 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
31679503 31679503 PRJNA1111077_P_NODE_32297_length_248_cov_0.880000_g32076_i0 PRJNA1111077 32297 248 0.88 2.1824 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 112 1.25e-26   NR XP_001024024.1 312017 g32076 i0 73.8 0.967741935483871 80 21 96.8 0 2 241 685 764 XP_001024024.1 amine-terminal domain guanylate-binding protein [Tetrahymena thermophila SB210] diamond 240 112 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31742773 31742773 PRJNA1111077_P_NODE_30877_length_250_cov_0.870056_g30656_i0 PRJNA1111077 30877 250 0.870056 2.17514 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 54.3 2.53e-6   NR CAD8055898.1 65129 g30656 i0 32.5 1.848 77 52 92.4 0 247 17 19 95 CAD8055898.1 unnamed protein product [Paramecium sonneborni] diamond 462 54.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
32312684 32312684 PRJNA1111077_P_NODE_14839_length_310_cov_4.691983_g14618_i0 PRJNA1111077 14839 310 4.691983 14.5451473 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 62.4 5.47e-9   NR KAL4441735.1 5901 g14618 i0 55.3 0.948387096774194 47 21 45.5 0 310 170 183 229 KAL4441735.1 hypothetical protein ABPG74_008732 [Tetrahymena malaccensis] diamond 294 62.4 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);;