RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA278119" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 28 ✖

tax_clade 1

bioproject 1

  • PRJNA278119 · 28 ✖

analysis 1

  • diamond · 28 ✖

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
5474658 5474658 PRJNA278119_P_NODE_28585_length_185_cov_1.257353_g28336_i0 PRJNA278119 28585 185 1.257353 2.32610305 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 68.6 1.32e-11   NR CDW71228.1 5949 g28336 i0 64.2 0.859459459459459 53 19 85.9 0 25 183 98 150 CDW71228.1 26s protease regulatory subunit 4 [Stylonychia lemnae] diamond 159 68.6 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
16948651 16948651 PRJNA278119_P_NODE_27574_length_188_cov_1.661871_g27325_i0 PRJNA278119 27574 188 1.661871 3.12431748 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 110 2.6e-26   NR OMJ90295.1 5963 g27325 i0 87.1 18.718085106383 62 8 98.9 0 187 2 49 110 OMJ90295.1 hypothetical protein SteCoe_7314 [Stentor coeruleus] diamond 3519 110 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
22047799 22047799 PRJNA278119_P_NODE_31698_length_176_cov_1.377953_g31449_i0 PRJNA278119 31698 176 1.377953 2.42519728 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 91.3 1.21e-19   NR CAD8089050.1 65129 g31449 i0 69 4.94318181818182 58 18 98.9 0 2 175 969 1026 CAD8089050.1 unnamed protein product [Paramecium sonneborni] diamond 870 91.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
26838857 26838857 PRJNA278119_P_NODE_13361_length_306_cov_2.054475_g13113_i0 PRJNA278119 13361 306 2.054475 6.2866935 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00602   NR OMJ88920.1 5963 g13113 i0 50 1.83333333333333 40 20 39.2 0 256 137 1 40 OMJ88920.1 hypothetical protein SteCoe_9025 [Stentor coeruleus] diamond 561 46.2 0.991341991341991 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
26915865 26915865 PRJNA278119_P_NODE_31862_length_176_cov_1.125984_g31613_i0 PRJNA278119 31862 176 1.125984 1.98173184 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 57.8 7.48e-8   NR XP_001022585.1 312017 g31613 i0 60.4 0.818181818181818 48 19 81.8 0 149 6 117 164 XP_001022585.1 ABC-type transport system protein [Tetrahymena thermophila SB210] diamond 144 57.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27249808 27249808 PRJNA278119_P_NODE_41163_length_165_cov_1.344828_g40914_i0 PRJNA278119 41163 165 1.344828 2.2189662 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 48.5 3.25e-5   NR XP_004025032.1 5932 g40914 i0 60 9.21818181818182 40 16 72.7 0 44 163 76 115 XP_004025032.1 ubiquitin, putative [Ichthyophthirius multifiliis] diamond 1521 48.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
27281543 27281543 PRJNA278119_P_NODE_16123_length_264_cov_1.544186_g15874_i0 PRJNA278119 16123 264 1.544186 4.07665104 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 75.5 1.38e-13   NR KAL4445467.1 5901 g15874 i0 81.3 1.09090909090909 48 9 54.5 0 3 146 341 388 KAL4445467.1 hypothetical protein ABPG74_004541 [Tetrahymena malaccensis] diamond 288 75.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
27295341 27295341 PRJNA278119_P_NODE_17883_length_243_cov_1.340206_g17634_i0 PRJNA278119 17883 243 1.340206 3.25670058 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 94.7 1.46e-21   NR XP_001031587.2 312017 g17634 i0 62.5 0.987654320987654 80 30 98.8 0 243 4 40 119 XP_001031587.2 60S ribosomal L7Ae-like protein [Tetrahymena thermophila SB210] diamond 240 94.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27769311 27769311 PRJNA278119_P_NODE_44864_length_163_cov_0.991228_g44615_i0 PRJNA278119 44864 163 0.991228 1.61570164 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 52.4 2.53e-6   NR XP_001025178.1 312017 g44615 i0 50 3.51533742331288 50 23 92 2 152 3 57 104 XP_001025178.1 hypothetical protein TTHERM_00684770 [Tetrahymena thermophila SB210] diamond 573 52.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27926936 27926936 PRJNA278119_P_NODE_38005_length_167_cov_1.067797_g37756_i0 PRJNA278119 38005 167 1.067797 1.78322099 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.00384   NR CDW78536.1 5949 g37756 i0 54.1 0.664670658682635 37 17 66.5 0 162 52 333 369 CDW78536.1 UNKNOWN [Stylonychia lemnae] diamond 111 44.3 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
28210929 28210929 PRJNA278119_P_NODE_6786_length_457_cov_1.894608_g6540_i0 PRJNA278119 6786 457 1.894608 8.65835856 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 88.6 1.82e-18   NR XP_001014308.1 312017 g6540 i0 50 2.40262582056893 92 45 60.4 1 179 454 117 207 XP_001014308.1 eukaryotic translation initiation factor 5A [Tetrahymena thermophila SB210] diamond 1098 88.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28355003 28355003 PRJNA278119_P_NODE_46306_length_162_cov_1.380531_g46057_i0 PRJNA278119 46306 162 1.380531 2.23646022 root 1 Root_unresolved Root_unresolved 53.1 2.63e-6   NR CAD8206644.1 43137 g46057 i0 49 3.46296296296296 49 24 90.7 1 150 4 208 255 CAD8206644.1 unnamed protein product [Paramecium octaurelia] diamond 561 53.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
28432122 28432122 PRJNA278119_P_NODE_10186_length_366_cov_1.410095_g9939_i0 PRJNA278119 10186 366 1.410095 5.1609477 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 85.5 3.9e-17   NR XP_977138.3 312017 g9939 i0 51.3 0.622950819672131 76 37 62.3 0 338 111 175 250 XP_977138.3 D-mannose-binding lectin [Tetrahymena thermophila SB210] diamond 228 85.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28923275 28923275 PRJNA278119_P_NODE_14848_length_282_cov_1.562232_g14599_i0 PRJNA278119 14848 282 1.562232 4.40549424 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 60.5 3.62e-8   NR KAL4428932.1 5901 g14599 i0 37.2 1.6595744680851101 78 48 81.9 1 1 231 608 685 KAL4428932.1 hypothetical protein ABPG74_017522 [Tetrahymena malaccensis] diamond 468 60.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
29410778 29410778 PRJNA278119_P_NODE_27009_length_190_cov_1.475177_g26760_i0 PRJNA278119 27009 190 1.475177 2.8028363 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 55.5 5.94e-7   NR XP_001027526.3 312017 g26760 i0 57.1 0.773684210526316 49 17 71.1 1 172 38 1 49 XP_001027526.3 Ndc1 protein [Tetrahymena thermophila SB210] diamond 147 55.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29789623 29789623 PRJNA278119_P_NODE_1431_length_1021_cov_3.013374_g1248_i0 PRJNA278119 1431 1021 3.013374 30.76654854 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 52 5.5e-4   NR CAG9321912.1 1481888 g1248 i0 37.5 0.329089128305583 112 60 32.9 1 82 417 2 103 CAG9321912.1 unnamed protein product [Blepharisma stoltei] diamond 336 52 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
30011057 30011057 PRJNA278119_P_NODE_45951_length_163_cov_0.894737_g45702_i0 PRJNA278119 45951 163 0.894737 1.45842131 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 92.4 3.87e-20   NR CDW73046.1 5949 g45702 i0 74.1 3.92024539877301 54 14 99.4 0 2 163 195 248 CDW73046.1 gtp-binding protein 1-like [Stylonychia lemnae] diamond 639 92.4 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
30123228 30123228 PRJNA278119_P_NODE_14672_length_285_cov_1.296610_g14423_i0 PRJNA278119 14672 285 1.29661 3.6953385 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 108 4.06e-25   NR KAL4445467.1 5901 g14423 i0 56.8 2 95 41 100 0 1 285 142 236 KAL4445467.1 hypothetical protein ABPG74_004541 [Tetrahymena malaccensis] diamond 570 109 0.990825688073395 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
30408050 30408050 PRJNA278119_P_NODE_6693_length_461_cov_1.412621_g6447_i0 PRJNA278119 6693 461 1.412621 6.51218281 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 55.1 1.69e-5   NR XP_976682.2 312017 g6447 i0 58.7 0.598698481561822 46 19 29.9 0 33 170 60 105 XP_976682.2 hypothetical protein TTHERM_00548340 [Tetrahymena thermophila SB210] diamond 276 55.5 0.992792792792793 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30547990 30547990 PRJNA278119_P_NODE_36193_length_168_cov_1.310924_g35944_i0 PRJNA278119 36193 168 1.310924 2.20235232 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 58.2 4.75e-8   NR XP_001027526.3 312017 g35944 i0 62.8 0.767857142857143 43 16 76.8 0 145 17 309 351 XP_001027526.3 Ndc1 protein [Tetrahymena thermophila SB210] diamond 129 58.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30597174 30597174 PRJNA278119_P_NODE_6613_length_464_cov_1.804819_g6367_i0 PRJNA278119 6613 464 1.804819 8.37436016 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 170 2.52e-51   NR OMJ92653.1 5963 g6367 i0 66.7 1.43534482758621 111 33 71.8 1 462 130 21 127 OMJ92653.1 hypothetical protein SteCoe_4526 [Stentor coeruleus] diamond 666 171 0.994152046783626 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
30755338 30755338 PRJNA278119_P_NODE_35994_length_168_cov_1.621849_g35745_i0 PRJNA278119 35994 168 1.621849 2.72470632 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 79 8.45e-17   NR CAD8059638.1 5886 g35745 i0 65.4 4.60714285714286 52 18 92.9 0 3 158 28 79 CAD8059638.1 unnamed protein product [Paramecium primaurelia] diamond 774 79 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
31432900 31432900 PRJNA278119_P_NODE_47456_length_162_cov_0.920354_g47207_i0 PRJNA278119 47456 162 0.920354 1.49097348 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 52.8 3.7e-6   NR XP_001007447.2 312017 g47207 i0 92.3 0.481481481481481 26 2 48.1 0 28 105 647 672 XP_001007447.2 transitional endoplasmic reticulum ATPase, putative [Tetrahymena thermophila SB210] diamond 78 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31482554 31482554 PRJNA278119_P_NODE_13336_length_307_cov_1.155039_g13088_i0 PRJNA278119 13336 307 1.155039 3.54596973 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 49.7 2.68e-4   NR XP_001025944.1 312017 g13088 i0 31.6 2.00325732899023 79 51 77.2 1 13 249 239 314 XP_001025944.1 receptor of activated kinase C 1A, component of 40S small ribosomal subunit [Tetrahymena thermophila SB210] diamond 615 49.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31938866 31938866 PRJNA278119_P_NODE_12297_length_325_cov_1.456522_g12049_i0 PRJNA278119 12297 325 1.456522 4.7336965 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 164 4.79e-49   NR CDW89587.1 5949 g12049 i0 77.6 0.987692307692308 107 24 98.8 0 323 3 53 159 CDW89587.1 UNKNOWN [Stylonychia lemnae] diamond 321 164 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31970623 31970623 PRJNA278119_P_NODE_18538_length_236_cov_1.641711_g18289_i0 PRJNA278119 18538 236 1.641711 3.87443796 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 80.1 6.39e-16   NR XP_004031019.1 5932 g18289 i0 53.8 0.991525423728814 78 35 97.9 1 4 234 65 142 XP_004031019.1 ribosomal protein, putative [Ichthyophthirius multifiliis] diamond 234 80.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
32065524 32065524 PRJNA278119_P_NODE_35198_length_169_cov_0.866667_g34949_i0 PRJNA278119 35198 169 0.866667 1.46466723 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 54.7 6.33e-7   NR XP_976672.2 312017 g34949 i0 65.7 0.621301775147929 35 12 62.1 0 2 106 53 87 XP_976672.2 proteasome subunit beta type protein [Tetrahymena thermophila SB210] diamond 105 54.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
32287403 32287403 PRJNA278119_P_NODE_26899_length_191_cov_0.929577_g26650_i0 PRJNA278119 26899 191 0.929577 1.77549207 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 64.7 2.88e-10   NR OMJ84051.1 5963 g26650 i0 46.6 0.910994764397906 58 31 91.1 0 191 18 51 108 OMJ84051.1 hypothetical protein SteCoe_14922 [Stentor coeruleus] diamond 174 64.7 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus

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