RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA849172 · 19 ✖

analysis 1

  • blastn · 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
836196 836196 PRJNA849172_P_NODE_39601_length_328_cov_3.784314_g39242_i0 PRJNA849172 39601 328 3.784314 12.41254992 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 270 7.82e-68   NTclustered gi|829169821|ref|XM_012797582.1| 312017 g39242 i0 85.659 0.786585365853659 258 36 78 1 70 326 702 959 Tetrahymena thermophila SB210 papain family cysteine protease partial mRNA blastn 258 270 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
1232618 1232618 PRJNA849172_P_NODE_48101_length_301_cov_14.298246_g47741_i0 PRJNA849172 48101 301 14.298246 43.03772046 Vorticella 60849 SAR_Eukaryotes SAR_Eukaryotes 518 2.3e-142   NTclustered gi|512134943|gb|JX178902.1| 1295638 g47741 i0 97.674 100.205980066445 301 7 100 0 1 301 1325 1025 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 30162 523 0.990439770554493 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
4662522 4662522 PRJNA849172_P_NODE_101024_length_245_cov_12.668605_g100664_i0 PRJNA849172 101024 245 12.668605 31.03808225 Chilodonella piscicola 1654720 SAR_Eukaryotes SAR_Eukaryotes 442 1.1199999999999994e-119   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g100664 i0 99.187 97.3020408163265 246 1 100 1 1 245 2328 2083 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 23839 442 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
8488825 8488825 PRJNA849172_P_NODE_32547_length_359_cov_34.174825_g32188_i0 PRJNA849172 32547 359 34.174825 122.68762175 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 283 1.11e-71   NTclustered gi|829197457|ref|XM_001026661.3| 312017 g32188 i0 95 0.579387186629526 180 9 50 0 3 182 298 477 Tetrahymena thermophila SB210 60S ribosomal protein L36 partial mRNA blastn 208 283 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
8885308 8885308 PRJNA849172_P_NODE_16427_length_513_cov_21.238636_g16068_i0 PRJNA849172 16427 513 21.238636 108.95420268 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 296 2.0999999999999999e-75   NTclustered gi|10816|emb|X04755.1| 5911 g16068 i0 84.983 27.4522417153996 293 42 57 2 147 438 647 356 Tetrahymena DNA for histone H4-II blastn 14083 296 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
11037810 11037810 PRJNA849172_P_NODE_101549_length_245_cov_3.308140_g101189_i0 PRJNA849172 101549 245 3.30814 8.104943 Tetrahymena pigmentosa 5907 SAR_Eukaryotes SAR_Eukaryotes 337 5.45e-88   NTclustered gi|114329902|ref|NC_008339.1| 5907 g101189 i0 91.532 25.8816326530612 248 16 100 5 1 245 2108 2353 Tetrahymena pigmentosa mitochondrion, complete genome blastn 6341 337 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pigmentosa
11041074 11041074 PRJNA849172_P_NODE_79149_length_260_cov_4.390374_g78789_i0 PRJNA849172 79149 260 4.3903740000000004 11.4149724 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 285 2.15e-72   NTclustered gi|118385632|ref|XM_001025944.1| 312017 g78789 i0 90.654 0.823076923076923 214 20 82 0 1 214 819 1032 Tetrahymena thermophila SB210 receptor of activated kinase C 1A, component of 40S small ribosomal subunit partial mRNA blastn 214 285 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
11436321 11436321 PRJNA849172_P_NODE_43169_length_315_cov_12.739669_g42809_i0 PRJNA849172 43169 315 12.739669 40.12995735 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 488 1.8999999999999998e-133   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g42809 i0 94.603 31.8190476190476 315 17 100 0 1 315 351 37 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 10023 488 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
15260557 15260557 PRJNA849172_P_NODE_43432_length_314_cov_69.136929_g43072_i0 PRJNA849172 43432 314 69.136929 217.08995706 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 575 1.4099999999999994e-159   NTclustered gi|1837628855|gb|MN158348.1| 5909 g43072 i0 99.682 96.8726114649682 314 1 100 0 1 314 2626 2939 Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 30418 575 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
16139236 16139236 PRJNA849172_P_NODE_48033_length_302_cov_2.109170_g47673_i0 PRJNA849172 48033 302 2.10917 6.3696934 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 233 9.36e-57   NTclustered gi|829192616|ref|XM_001029813.3| 312017 g47673 i0 91.228 0.566225165562914 171 15 57 0 132 302 609 439 Tetrahymena thermophila SB210 60S ribosomal protein L15 partial mRNA blastn 171 233 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
16139292 16139292 PRJNA849172_P_NODE_4993_length_988_cov_25.084153_g4713_i0 PRJNA849172 4993 988 25.084153 247.83143164 uncultured Oligohymenophorea 300673 SAR_Eukaryotes SAR_Eukaryotes 1611 0   NTclustered gi|2006881151|emb|HG996107.1| 300673 g4713 i0 97.66 43.42004048583 940 18 95 4 45 982 1 938 uncultured Oligohymenophorea genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, clone abb336d6 blastn 42899 1611 1 Eukaryota Sar   Ciliophora Oligohymenophorea       uncultured Oligohymenophorea
17413517 17413517 PRJNA849172_P_NODE_144734_length_202_cov_5.806202_g144374_i0 PRJNA849172 144734 202 5.806202 11.72852804 Holosticha diademata 331610 SAR_Eukaryotes SAR_Eukaryotes 329 7.25e-86   NTclustered gi|653605316|gb|KF306412.1| 331610 g144374 i0 96.939 57.0891089108911 196 6 97 0 7 202 115 310 Holosticha diademata isolate JJM2007091003 large subunit ribosomal RNA gene, partial sequence blastn 11532 329 1 Eukaryota Sar   Ciliophora Spirotrichea Urostylida Holostichidae Holosticha Holosticha diademata
18685643 18685643 PRJNA849172_P_NODE_10975_length_643_cov_24.898246_g10623_i0 PRJNA849172 10975 643 24.898246 160.09572178 Colpoda sp. 41631 SAR_Eukaryotes SAR_Eukaryotes 1022 0   NTclustered gi|2651357791|gb|PP174306.1| 41631 g10623 i0 95.334 77.3281493001555 643 30 100 0 1 643 3857 3215 Colpoda sp. isolate JGP15 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 49722 1022 1 Eukaryota Sar   Ciliophora Colpodea Colpodida Colpodidae Colpoda Colpoda sp.
19963813 19963813 PRJNA849172_P_NODE_77876_length_261_cov_13.648936_g77516_i0 PRJNA849172 77876 261 13.648936 35.62372296 uncultured ciliate 187299 SAR_Eukaryotes SAR_Eukaryotes 466 7.17e-127   NTclustered gi|2006880679|emb|HG995635.1| 187299 g77516 i0 98.851 60.9846743295019 261 3 100 0 1 261 574 834 uncultured ciliate genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, clone 2f5efc6c blastn 15917 466 1 Eukaryota Sar   Ciliophora         uncultured ciliate
21634157 21634157 PRJNA849172_P_NODE_136157_length_212_cov_6.683453_g135797_i0 PRJNA849172 136157 212 6.683453 14.16892036 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 339 1.28e-88   NTclustered gi|1824640912|gb|MT247896.1| 152445 g135797 i0 99.462 87.6650943396226 186 1 88 0 1 186 286 101 Gonostomum strenuum isolate ZEK20160226 large subunit ribosomal RNA gene, partial sequence blastn 18585 339 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Gonostomatidae Gonostomum Gonostomum strenuum
23787848 23787848 PRJNA849172_P_NODE_18539_length_481_cov_4.127451_g18180_i0 PRJNA849172 18539 481 4.127451 19.85303931 Tetrahymena pigmentosa 5907 SAR_Eukaryotes SAR_Eukaryotes 771 0   NTclustered gi|114329902|ref|NC_008339.1| 5907 g18180 i0 95.634 81.5467775467775 481 19 100 2 1 481 1813 1335 Tetrahymena pigmentosa mitochondrion, complete genome blastn 39224 771 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pigmentosa
23788426 23788426 PRJNA849172_P_NODE_37759_length_335_cov_6.377863_g37400_i0 PRJNA849172 37759 335 6.377863 21.36584105 Opercularia sp. ZhW-2019a 2582953 SAR_Eukaryotes SAR_Eukaryotes 619 6.91e-173   NTclustered gi|2304601486|gb|OP458307.1| 2582953 g37400 i0 100 97.9791044776119 335 0 100 0 1 335 1446 1780 Opercularia sp. ZhW-2019a large subunit ribosomal RNA gene, partial sequence blastn 32823 619 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Operculariidae Opercularia Opercularia sp. ZhW-2019a
24183950 24183950 PRJNA849172_P_NODE_24899_length_411_cov_185.576923_g24540_i0 PRJNA849172 24899 411 185.576923 762.72115353 root 1 Root_unresolved Root_unresolved 737 0   NTclustered gi|345541658|gb|JN547815.1| 5911 g24540 i0 99.027 86.5766423357664 411 4 100 0 1 411 3811 3401 Tetrahymena thermophila strain ATCC 30382 18S ribosomal RNA gene, partial sequence; and internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence blastn 35583 737 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
25061131 25061131 PRJNA849172_P_NODE_130360_length_221_cov_4.060811_g130000_i0 PRJNA849172 130360 221 4.060811 8.97439231 Euplotes aediculatus 5940 SAR_Eukaryotes SAR_Eukaryotes 409 1.0100000000000001e-109   NTclustered gi|6980030|gb|AF223571.1|AF223571 5940 g130000 i0 100 89.9547511312217 221 0 100 0 1 221 762 542 Euplotes aediculatus internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 19880 409 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes aediculatus

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