RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where bioproject = "PRJNA799842" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 21 ✖

tax_clade 1

bioproject 1

  • PRJNA799842 · 21 ✖

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
7173061 7173061 PRJNA799842_P_NODE_37146_length_470_cov_2.314861_g35575_i0 PRJNA799842 37146 470 2.314861 10.8798467 Colpoda sp. 41631 SAR_Eukaryotes SAR_Eukaryotes 850 0   NTclustered gi|2651357788|gb|PP174303.1| 41631 g35575 i0 99.36 67.136170212766 469 3 99 0 2 470 3982 3514 Colpoda sp. isolate CIL1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 31554 850 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
13547598 13547598 PRJNA799842_P_NODE_170831_length_244_cov_0.970760_g169258_i0 PRJNA799842 170831 244 0.97076 2.3686544 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 303 5.5e-78   NTclustered gi|829160170|ref|XM_001012263.3| 312017 g169258 i0 89.388 59.7663934426229 245 20 99 6 3 244 869 628 Tetrahymena thermophila SB210 heat shock 70 kDa protein partial mRNA blastn 14583 303 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
14821805 14821805 PRJNA799842_P_NODE_139532_length_250_cov_1.305085_g137959_i0 PRJNA799842 139532 250 1.305085 3.2627125 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 145 1.4e-42   NR KAL4468593.1 5901 g137959 i0 83.8 2.904 80 13 96 0 9 248 60 139 KAL4468593.1 hypothetical protein ABPG74_005096 [Tetrahymena malaccensis] diamond 726 145 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
14822412 14822412 PRJNA799842_P_NODE_174852_length_244_cov_0.900585_g173279_i0 PRJNA799842 174852 244 0.900585 2.1974274 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.006   NTclustered gi|145504323|ref|XM_001438097.1| 5888 g173279 i0 100 0.118852459016393 29 0 12 0 76 104 643 671 Paramecium tetraurelia uncharacterized protein (GSPATT00007872001), partial mRNA blastn 29 54.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
19920553 19920553 PRJNA799842_P_NODE_155656_length_247_cov_0.885057_g154083_i0 PRJNA799842 155656 247 0.885057 2.18609079 Gruberia lanceolata 1978530 SAR_Eukaryotes SAR_Eukaryotes 169 2.1199999999999996e-37   NTclustered gi|1810665267|gb|MK301177.1| 1978530 g154083 i0 86.164 20.6558704453441 159 19 64 2 88 245 4117 3961 Gruberia lanceolata strain Gben1 mitochondrion blastn 5102 169 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Spirostomidae Gruberia Gruberia lanceolata
21195330 21195330 PRJNA799842_P_NODE_112857_length_276_cov_1.054187_g111284_i0 PRJNA799842 112857 276 1.054187 2.90955612 Sterkiella histriomuscorum 94289 SAR_Eukaryotes SAR_Eukaryotes 488 1.6299999999999995e-133   NTclustered gi|220966760|gb|FJ545743.1| 94289 g111284 i0 98.551 100.144927536232 276 4 100 0 1 276 5376 5651 Sterkiella histriomuscorum 17S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence; macronuclear blastn 27640 488 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum
21196718 21196718 PRJNA799842_P_NODE_187477_length_241_cov_0.916667_g185904_i0 PRJNA799842 187477 241 0.916667 2.20916747 Eudiplodinium maggii 47892 SAR_Eukaryotes SAR_Eukaryotes 226 1.2099999999999997e-54   NTclustered gi|92790165|emb|AJ965268.1| 47892 g185904 i0 83.75 131.165975103734 240 37 99 2 3 241 428 190 Eudiplodinium maggii partial mRNA for Polyubiqutin 1 (polyubiqutin 1 gene) blastn 31611 226 1 Eukaryota Sar   Ciliophora Litostomatea Entodiniomorphida Ophryoscolecidae Eudiplodinium Eudiplodinium maggii
23745633 23745633 PRJNA799842_P_NODE_111939_length_277_cov_1.127451_g110366_i0 PRJNA799842 111939 277 1.127451 3.12303927 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.025   NTclustered gi|829187266|ref|XM_001033288.2| 312017 g110366 i0 100 0.101083032490975 28 0 10 0 196 223 1584 1611 Tetrahymena thermophila SB210 hypothetical protein partial mRNA blastn 28 52.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
24170735 24170735 PRJNA799842_P_NODE_21879_length_640_cov_1.144621_g20358_i0 PRJNA799842 21879 640 1.1446210000000001 7.3255744 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 793 0   NTclustered gi|10790|emb|X12767.1| 5908 g20358 i0 90.894 75.5609375 593 50 92 4 50 640 301 891 Tetrahymena pyriformis alpha-tubulin gene blastn 48359 798 0.993734335839599 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
26841725 26841725 PRJNA799842_P_NODE_37221_length_470_cov_1.163728_g35650_i0 PRJNA799842 37221 470 1.163728 5.4695216 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 146 5.44e-39   NR TNV79671.1 5974 g35650 i0 54.5 8.68723404255319 134 61 85.5 0 59 460 249 382 TNV79671.1 hypothetical protein FGO68_gene6240 [Halteria grandinella] diamond 4083 147 0.993197278911565 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
27527915 27527915 PRJNA799842_P_NODE_151403_length_248_cov_0.880000_g149830_i0 PRJNA799842 151403 248 0.88 2.1824 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0292   NR KRX02482.1 266149 g149830 i0 60 0.423387096774194 35 14 42.3 0 129 25 733 767 KRX02482.1 P-loop containing nucleoside triphosphate hydrolase [Pseudocohnilembus persalinus] diamond 105 43.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
27591329 27591329 PRJNA799842_P_NODE_138224_length_251_cov_0.865169_g136651_i0 PRJNA799842 138224 251 0.865169 2.17157419 Tetrahymena utriculariae 2486642 SAR_Eukaryotes SAR_Eukaryotes 69.3 1.25e-11   NR KAL4508206.1 2486642 g136651 i0 38.6 2.41434262948207 101 44 99.2 2 3 251 163 263 KAL4508206.1 hypothetical protein ABPG72_021579 [Tetrahymena utriculariae] diamond 606 69.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena utriculariae
28822216 28822216 PRJNA799842_P_NODE_166748_length_245_cov_0.895349_g165175_i0 PRJNA799842 166748 245 0.895349 2.19360505 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 57.4 2.19e-7   NR XP_001027167.2 312017 g165175 i0 37.5 0.783673469387755 64 40 78.4 0 244 53 230 293 XP_001027167.2 carrier protein [Tetrahymena thermophila SB210] diamond 192 57.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29233095 29233095 PRJNA799842_P_NODE_11949_length_907_cov_1.780576_g10710_i0 PRJNA799842 11949 907 1.780576 16.14982432 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 257 1.66e-81   NR CAD8068969.1 5886 g10710 i0 50.2 1.83241455347299 277 130 91.3 4 851 24 2 271 CAD8068969.1 unnamed protein product [Paramecium primaurelia] diamond 1662 257 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
29832856 29832856 PRJNA799842_P_NODE_108691_length_281_cov_0.879808_g107118_i0 PRJNA799842 108691 281 0.879808 2.47226048 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 55.5 1.86e-6   NR OMJ69762.1 5963 g107118 i0 38.2 1.65480427046263 76 40 75.8 3 57 269 182 255 OMJ69762.1 hypothetical protein SteCoe_32427 [Stentor coeruleus] diamond 465 55.5 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
30085527 30085527 PRJNA799842_P_NODE_177472_length_243_cov_0.905882_g175899_i0 PRJNA799842 177472 243 0.905882 2.20129326 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 74.3 2.72e-13   NR KRX01196.1 266149 g175899 i0 57.4 0.839506172839506 68 29 84 0 237 34 128 195 KRX01196.1 hypothetical protein PPERSA_03700 [Pseudocohnilembus persalinus] diamond 204 74.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
30117069 30117069 PRJNA799842_P_NODE_153292_length_248_cov_0.880000_g151719_i0 PRJNA799842 153292 248 0.88 2.1824 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 117 1.34e-28   NR XP_001025237.2 312017 g151719 i0 62.2 0.991935483870968 82 31 99.2 0 248 3 511 592 XP_001025237.2 WD repeat protein [Tetrahymena thermophila SB210] diamond 246 117 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31159464 31159464 PRJNA799842_P_NODE_135195_length_251_cov_0.865169_g133622_i0 PRJNA799842 135195 251 0.865169 2.17157419 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 127 9.18e-32   NR XP_004030488.1 5932 g133622 i0 84.6 11.6294820717131 65 10 77.7 0 230 36 514 578 XP_004030488.1 snf2 family n-terminal domain protein [Ichthyophthirius multifiliis] diamond 2919 127 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
31159519 31159519 PRJNA799842_P_NODE_81735_length_319_cov_1.252033_g80162_i0 PRJNA799842 81735 319 1.252033 3.99398527 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 50.4 1.88e-4   NR CAD8169680.1 43137 g80162 i0 36 0.705329153605016 75 38 67.7 3 318 103 867 934 CAD8169680.1 unnamed protein product [Paramecium octaurelia] diamond 225 50.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
31665777 31665777 PRJNA799842_P_NODE_171257_length_244_cov_0.900585_g169684_i0 PRJNA799842 171257 244 0.900585 2.1974274 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 64.3 9.79e-10   NR KRX05725.1 266149 g169684 i0 54.4 0.700819672131147 57 26 70.1 0 244 74 657 713 KRX05725.1 WD40-repeat-containing domain [Pseudocohnilembus persalinus] diamond 171 64.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
32645920 32645920 PRJNA799842_P_NODE_108420_length_281_cov_1.110577_g106847_i0 PRJNA799842 108420 281 1.110577 3.12072137 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 53.9 6.88e-6   NR CDW79198.1 5949 g106847 i0 28 0.875444839857651 82 59 87.5 0 276 31 484 565 CDW79198.1 cullin c [Stylonychia lemnae] diamond 246 53.9 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae

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