RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where bioproject = "PRJNA558770", tax_clade = "Sar" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 28 ✖

tax_clade 1

  • Sar · 28 ✖

bioproject 1

  • PRJNA558770 · 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
1814274 1814274 PRJNA558770_P_NODE_171282_length_234_cov_5.095477_g169277_i0 PRJNA558770 171282 234 5.095477 11.92341618 Coeloperix sp. QD FSP2008060904 717073 SAR_Eukaryotes SAR_Eukaryotes 97.1 9.55e-16   NTclustered gi|290581697|gb|FJ998034.1| 717073 g169277 i0 91.429 30.491452991453 70 6 30 0 3 72 1328 1259 Coeloperix sp. QD FSP2008060904 small subunit ribosomal RNA gene, partial sequence blastn 7135 97.1 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Lynchellidae Coeloperix Coeloperix sp. QD FSP2008060904
1815926 1815926 PRJNA558770_P_NODE_265182_length_234_cov_1.994975_g263177_i0 PRJNA558770 265182 234 1.994975 4.6682415 Ephelota gemmipara 398671 SAR_Eukaryotes SAR_Eukaryotes 97.1 9.55e-16   NTclustered gi|759083541|gb|KM222158.1| 398671 g263177 i0 92.537 18.7008547008547 67 5 29 0 168 234 842 908 Ephelota gemmipara voucher CXR2007051101 large subunit ribosomal RNA gene, partial sequence blastn 4376 97.1 1 Eukaryota Sar   Ciliophora Phyllopharyngea Exogenida Ephelotidae Ephelota Ephelota gemmipara
1817906 1817906 PRJNA558770_P_NODE_54062_length_287_cov_41.190476_g52058_i0 PRJNA558770 54062 287 41.190476 118.21666612 Vorticella sp. 1 2979179 SAR_Eukaryotes SAR_Eukaryotes 455 1.73e-123   NTclustered gi|2304601489|gb|OP458310.1| 2979179 g52058 i0 95.76 92.6759581881533 283 11 98 1 1 282 1508 1790 Vorticella sp. 1 large subunit ribosomal RNA gene, partial sequence blastn 26598 455 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 1
3092408 3092408 PRJNA558770_P_NODE_379783_length_218_cov_28.016393_g377778_i0 PRJNA558770 379783 218 28.016393 61.07573674 Philasterides dicentrarchi 282688 SAR_Eukaryotes SAR_Eukaryotes 158 3.969999999999999e-34   NTclustered gi|49616744|gb|AY643504.1| 282688 g377778 i0 85.621 3.0045871559633 153 19 69 3 20 170 252 101 Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence blastn 655 158 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Philasteridae Philasterides Philasterides dicentrarchi
3681152 3681152 PRJNA558770_P_NODE_384223_length_199_cov_5.914634_g382218_i0 PRJNA558770 384223 199 5.914634 11.77012166 Vorticella 60849 SAR_Eukaryotes SAR_Eukaryotes 331 1.9800000000000002e-86   NTclustered gi|512134943|gb|JX178902.1| 1295638 g382218 i0 96.954 98.7085427135678 197 6 99 0 3 199 1642 1838 Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 19643 331 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
4367677 4367677 PRJNA558770_P_NODE_268824_length_234_cov_1.929648_g266819_i0 PRJNA558770 268824 234 1.929648 4.51537632 Epistylis sp. 8 2979171 SAR_Eukaryotes SAR_Eukaryotes 126 1.22e-24   NTclustered gi|2304601484|gb|OP458305.1| 2979171 g266819 i0 100 10.1923076923077 68 0 29 0 3 70 67 134 Epistylis sp. 8 large subunit ribosomal RNA gene, partial sequence blastn 2385 126 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Epistylidae Epistylis Epistylis sp. 8
8195410 8195410 PRJNA558770_P_NODE_64587_length_259_cov_9.473214_g62582_i0 PRJNA558770 64587 259 9.473214 24.53562426 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 414 2.61e-111   NTclustered gi|10782|emb|X54004.1| 5908 g62582 i0 95.402 62.1196911196911 261 10 100 1 1 259 3231 2971 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 16089 414 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
8195454 8195454 PRJNA558770_P_NODE_66627_length_255_cov_4.845455_g64622_i0 PRJNA558770 66627 255 4.845455 12.35591025 Chlamydonellopsis calkinsi 1346244 SAR_Eukaryotes SAR_Eukaryotes 357 4.3799999999999997e-94   NTclustered gi|290581696|gb|FJ998033.1| 1346244 g64622 i0 92.095 99.156862745098 253 20 99 0 3 255 128 380 Chlamydonellopsis calkinsi strain GD-CFL08112801 small subunit ribosomal RNA gene, partial sequence blastn 25285 357 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Lynchellidae Chlamydonellopsis Chlamydonellopsis calkinsi
8782963 8782963 PRJNA558770_P_NODE_51667_length_297_cov_30.576336_g49664_i0 PRJNA558770 51667 297 30.576336 90.81171792 Vorticella 60849 SAR_Eukaryotes SAR_Eukaryotes 412 1.1e-110   NTclustered gi|300078458|gb|GU187052.1| 858372 g49664 i0 99.559 103.030303030303 227 0 100 1 72 297 1518 1292 Vorticella sp. SP-2009-5 18S ribosomal RNA gene, partial sequence blastn 30600 412 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. SP-2009-5
10747029 10747029 PRJNA558770_P_NODE_72929_length_243_cov_5.701923_g70924_i0 PRJNA558770 72929 243 5.701923 13.85567289 Kyaroikeus paracetarius 2684852 SAR_Eukaryotes SAR_Eukaryotes 206 1.59e-48   NTclustered gi|1784308422|gb|MN830170.1| 2684852 g70924 i0 82.114 2.68312757201646 246 38 100 5 1 243 41 283 Kyaroikeus paracetarius isolate LJ-I-20170502 large subunit ribosomal RNA gene, partial sequence blastn 652 206 1 Eukaryota Sar   Ciliophora Phyllopharyngea Dysteriida Kyaroikeidae Kyaroikeus Kyaroikeus paracetarius
12608929 12608929 PRJNA558770_P_NODE_42150_length_327_cov_10.291096_g40152_i0 PRJNA558770 42150 327 10.291096 33.65188392 Vorticellidae 85904 SAR_Eukaryotes SAR_Eukaryotes 366 9.67e-97   NTclustered gi|512134943|gb|JX178902.1| 1295638 g40152 i0 92.975 85.1743119266055 242 15 74 1 1 242 2077 1838 Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 27852 366 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
13883639 13883639 PRJNA558770_P_NODE_362971_length_232_cov_4.913706_g360966_i0 PRJNA558770 362971 232 4.913706 11.39979792 Frontoniidae 340079 SAR_Eukaryotes SAR_Eukaryotes 117 7.25e-22   NTclustered gi|1004125725|gb|KU761582.1| 153251 g360966 i0 94.667 32.375 75 4 32 0 2 76 5343 5417 Cryptocaryon irritans isolate ND1410 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and intergenic spacer, complete sequence blastn 7511 117 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
15844954 15844954 PRJNA558770_P_NODE_49993_length_304_cov_6.609665_g47991_i0 PRJNA558770 49993 304 6.609665 20.0933816 Philasterides dicentrarchi 282688 SAR_Eukaryotes SAR_Eukaryotes 113 1.28e-20   NTclustered gi|49616744|gb|AY643504.1| 282688 g47991 i0 90.588 9.92434210526316 85 8 28 0 1 85 210 126 Philasterides dicentrarchi 26S ribosomal RNA gene, partial sequence blastn 3017 113 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Philasteridae Philasterides Philasterides dicentrarchi
15845167 15845167 PRJNA558770_P_NODE_59333_length_271_cov_9.449153_g57329_i0 PRJNA558770 59333 271 9.449153 25.60720463 Tetrahymena chironomi 3034767 SAR_Eukaryotes SAR_Eukaryotes 416 7.649999999999999e-112   NTclustered gi|2459327221|gb|OQ626840.1| 3034767 g57329 i0 94.465 98.6789667896679 271 14 99 1 2 271 537 807 Tetrahymena chironomi isolate LLH20220320 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 26742 416 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena chironomi
17119823 17119823 PRJNA558770_P_NODE_4854_length_748_cov_102.942496_g3708_i0 PRJNA558770 4854 748 102.942496 770.00987008 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 730 0   NTclustered gi|512134943|gb|JX178902.1| 1295638 g3708 i0 97.216 55.2606951871658 431 12 58 0 2 432 988 1418 Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 41335 730 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
19668605 19668605 PRJNA558770_P_NODE_49776_length_304_cov_36.052045_g47774_i0 PRJNA558770 49776 304 36.052045 109.5982168 Carchesium polypinum 168244 SAR_Eukaryotes SAR_Eukaryotes 307 5.480000000000001e-79   NTclustered gi|2304601475|gb|OP458296.1| 168244 g47774 i0 94.898 61.1217105263158 196 10 64 0 109 304 1591 1786 Carchesium polypinum large subunit ribosomal RNA gene, partial sequence blastn 18581 307 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Carchesium Carchesium polypinum
20255865 20255865 PRJNA558770_P_NODE_253056_length_234_cov_2.241206_g251051_i0 PRJNA558770 253056 234 2.241206 5.24442204 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 62.1 3.48e-5   NTclustered gi|732689|emb|X85235.1| 5936 g251051 i0 100 15.0811965811966 33 0 14 0 198 230 1603 1635 E.crassus gamma-tubulin gene 2 blastn 3529 62.1 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
20942382 20942382 PRJNA558770_P_NODE_263677_length_234_cov_2.025126_g261672_i0 PRJNA558770 263677 234 2.025126 4.73879484 Chlamydonella irregularis 1518557 SAR_Eukaryotes SAR_Eukaryotes 80.5 9.61e-11   NTclustered gi|514227335|gb|KC753486.1| 1518557 g261672 i0 97.826 19.0299145299145 46 1 20 0 1 46 495 540 Chlamydonella irregularis isolate PHB08120201 small subunit ribosomal RNA gene, partial sequence blastn 4453 80.5 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Lynchellidae Chlamydonella Chlamydonella irregularis
22214644 22214644 PRJNA558770_P_NODE_12358_length_535_cov_153.374000_g3708_i1 PRJNA558770 12358 535 153.374 820.5509 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 854 0   NTclustered gi|512134943|gb|JX178902.1| 1295638 g3708 i1 95.506 92.7719626168224 534 24 99 0 1 534 1521 988 Vorticella sp. 4 JG-2011 clone 2 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 49633 854 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
23494103 23494103 PRJNA558770_P_NODE_389319_length_179_cov_4.298611_g387314_i0 PRJNA558770 389319 179 4.298611 7.69451369 Chilodonella piscicola 1654720 SAR_Eukaryotes SAR_Eukaryotes 302 1.36e-77   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g387314 i0 97.191 14.2849162011173 178 5 99 0 2 179 49 226 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 2557 302 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
25354877 25354877 PRJNA558770_P_NODE_120380_length_234_cov_9.165829_g118375_i0 PRJNA558770 120380 234 9.165829 21.44803986 root 1 Root_unresolved Root_unresolved 139 1.56e-28   NTclustered gi|10782|emb|X54004.1| 5908 g118375 i0 100 31.1239316239316 75 0 65 0 1 75 1235 1161 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 7283 139 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
28215680 28215680 PRJNA558770_P_NODE_258906_length_234_cov_2.120603_g256901_i0 PRJNA558770 258906 234 2.120603 4.96221102 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 46.6 0.00143   NR OMJ72952.1 5963 g256901 i0 91.3 0.294871794871795 23 2 29.5 0 70 2 497 519 OMJ72952.1 hypothetical protein SteCoe_28488 [Stentor coeruleus] diamond 69 46.6 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
28658082 28658082 PRJNA558770_P_NODE_283467_length_234_cov_1.678392_g281462_i0 PRJNA558770 283467 234 1.678392 3.92743728 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 47 9.94e-4   NR OMJ92639.1 5963 g281462 i0 79.2 0.307692307692308 24 5 30.8 0 233 162 102 125 OMJ92639.1 hypothetical protein SteCoe_4510 [Stentor coeruleus] diamond 72 47 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
28942367 28942367 PRJNA558770_P_NODE_294648_length_234_cov_1.386935_g292643_i0 PRJNA558770 294648 234 1.386935 3.2454279 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 40.8 0.0492   NR CDW75550.1 5949 g292643 i0 35.1 0.987179487179487 77 37 98.7 2 232 2 27 90 CDW75550.1 UNKNOWN [Stylonychia lemnae] diamond 231 40.8 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
30395288 30395288 PRJNA558770_P_NODE_286633_length_234_cov_1.628141_g284628_i0 PRJNA558770 286633 234 1.628141 3.80984994 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 53.9 3.8e-6   NR CAG9320844.1 1481888 g284628 i0 37.2 1 78 31 100 1 1 234 315 374 CAG9320844.1 unnamed protein product [Blepharisma stoltei] diamond 234 53.9 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
31215925 31215925 PRJNA558770_P_NODE_190875_length_234_cov_4.150754_g188870_i0 PRJNA558770 190875 234 4.150754 9.71276436 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00675   NR CDW79612.1 5949 g188870 i0 87.5 0.307692307692308 24 3 30.8 0 161 232 292 315 CDW79612.1 kelch motif family protein [Stylonychia lemnae] diamond 72 44.7 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31451963 31451963 PRJNA558770_P_NODE_134736_length_234_cov_7.663317_g132731_i0 PRJNA558770 134736 234 7.663317 17.93216178 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 51.2 3.37e-5   NR XP_001441350.1 5888 g132731 i0 84 0.641025641025641 25 4 32.1 0 76 2 688 712 XP_001441350.1 uncharacterized protein GSPATT00010186001 [Paramecium tetraurelia] diamond 150 51.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
32716568 32716568 PRJNA558770_P_NODE_202100_length_234_cov_3.703518_g200095_i0 PRJNA558770 202100 234 3.703518 8.66623212 root 1 Root_unresolved Root_unresolved 43.5 0.0172   NR CDW76703.1 5949 g200095 i0 79.2 0.923076923076923 24 5 30.8 0 232 161 76 99 CDW76703.1 peptidase c13 family protein [Stylonychia lemnae] diamond 216 43.9 0.990888382687927 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);;