RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "blastn", bioproject = "PRJEB11523" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 17 ✖

tax_clade 1

bioproject 1

  • PRJEB11523 · 17 ✖

analysis 1

  • blastn · 17 ✖

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
982484 982484 PRJEB11523_P_NODE_4401_length_226_cov_2.858757_g4323_i0 PRJEB11523 4401 226 2.858757 6.46079082 Peniculida 33825 SAR_Eukaryotes SAR_Eukaryotes 353 4.92e-93   NTclustered gi|1910750672|gb|MW045400.1| 2775078 g4323 i0 97.585 91.8008849557522 207 4 91 1 21 226 105 311 Marituja sp. isolate SM2018082204 large subunit ribosomal RNA gene, partial sequence blastn 20747 353 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Stokesiidae Marituja Marituja sp.
4810441 4810441 PRJEB11523_P_NODE_2624_length_318_cov_40.821561_g2546_i0 PRJEB11523 2624 318 40.821561 129.81256398 root 1 Root_unresolved Root_unresolved 372 2.0099999999999998e-98   NTclustered gi|10832|emb|X54512.1| 5911 g2546 i0 100 65.811320754717 201 0 82 0 1 201 8318 8118 T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA blastn 20928 372 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
5116103 5116103 PRJEB11523_P_NODE_1685_length_432_cov_36.929504_g1607_i0 PRJEB11523 1685 432 36.929504 159.53545728 Kentrophoros sp. 1 BS-2022 2930470 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.042   NTclustered gi|2261268989|emb|OX095830.1| 2930470 g1607 i0 100 0.0648148148148148 28 0 6 0 1 28 12 39 Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) blastn 28 52.8 1 Eukaryota Sar   Ciliophora Karyorelictea Protostomatida Kentrophoridae Kentrophoros Kentrophoros sp. 1 BS-2022
5116170 5116170 PRJEB11523_P_NODE_9245_length_150_cov_4.079208_g9167_i0 PRJEB11523 9245 150 4.079208 6.118812 Sterkiella histriomuscorum 94289 SAR_Eukaryotes SAR_Eukaryotes 272 8.609999999999998e-69   NTclustered gi|220966760|gb|FJ545743.1| 94289 g9167 i0 99.333 101.073333333333 150 1 100 0 1 150 6980 7129 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 15161 272 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum
7665961 7665961 PRJEB11523_P_NODE_1847_length_405_cov_28.845506_g1769_i0 PRJEB11523 1847 405 28.845506 116.8242993 Trachelocercidae sp. 3 BS-2022 2930473 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.011   NTclustered gi|2261268975|emb|OX095823.1| 2930473 g1769 i0 100 0.140740740740741 29 0 7 0 1 29 9 37 Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) blastn 57 54.7 1 Eukaryota Sar   Ciliophora Karyorelictea Protostomatida Trachelocercidae   Trachelocercidae sp. 3 BS-2022
11491707 11491707 PRJEB11523_P_NODE_1790_length_414_cov_7.169863_g1712_i0 PRJEB11523 1790 414 7.169863 29.68323282 Halodinium verrucatum 2448773 SAR_Eukaryotes SAR_Eukaryotes 248 4.73e-61   NTclustered gi|1489895921|dbj|LC424402.1| 2448773 g1712 i0 88.263 53.5410628019324 213 18 75 7 1 209 228 19 Halodinium verrucatum KC36_KC37 gene for 28S ribosomal RNA, partial sequence blastn 22166 248 1 Eukaryota Sar   Ciliophora Prostomatea Prorodontida   Halodinium Halodinium verrucatum
12461629 12461629 PRJEB11523_P_NODE_5550_length_197_cov_6.527027_g5472_i0 PRJEB11523 5550 197 6.527027 12.85824319 root 1 Root_unresolved Root_unresolved 316 5.48e-82   NTclustered gi|10370|emb|X56167.1| 5892 g5472 i0 100 86.8020304568528 171 0 87 0 4 174 482 312 T.australis gene for small subunit ribosomal RNA (16S like rRNA) blastn 17100 316 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena australis
13735985 13735985 PRJEB11523_P_NODE_3411_length_266_cov_9.428571_g3333_i0 PRJEB11523 3411 266 9.428571 25.07999886 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 460 3.41e-125   NTclustered gi|2459327249|gb|OQ626843.1| 5908 g3333 i0 98.113 90.0902255639098 265 3 99 1 1 265 558 820 Tetrahymena pyriformis isolate LLH20220320 pop variant pop1 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 23964 460 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
13735986 13735986 PRJEB11523_P_NODE_3491_length_262_cov_31.469484_g3413_i0 PRJEB11523 3491 262 31.469484 82.45004808 Campanella 71870 SAR_Eukaryotes SAR_Eukaryotes 374 4.49e-99   NTclustered gi|2027858488|gb|MW969625.1| 2828877 g3413 i0 96.847 85.0458015267176 222 7 85 0 41 262 287 66 Campanella sinica large subunit ribosomal RNA gene, partial sequence blastn 22282 377 0.992042440318302 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Epistylidae Campanella Campanella sinica
14041812 14041812 PRJEB11523_P_NODE_5772_length_193_cov_1.562500_g5694_i0 PRJEB11523 5772 193 1.5625 3.015625 Amphileptus marinus 1197334 SAR_Eukaryotes SAR_Eukaryotes 231 1.9900000000000002e-56   NTclustered gi|375305429|gb|JF975389.1| 1197334 g5694 i0 89.617 65.3108808290155 183 17 94 2 10 191 147 328 Amphileptus marinus isolate PHB2007053102 28S ribosomal RNA gene, partial sequence blastn 12605 231 1 Eukaryota Sar   Ciliophora Litostomatea Pleurostomatida Amphileptidae Amphileptus Amphileptus marinus
15315966 15315966 PRJEB11523_P_NODE_3433_length_265_cov_4.902778_g3355_i0 PRJEB11523 3433 265 4.902778 12.9923617 uncultured Peritrichia 282477 SAR_Eukaryotes SAR_Eukaryotes 470 5.64e-128   NTclustered gi|49356811|gb|AY605215.1| 282477 g3355 i0 100 94.1018867924528 254 0 96 0 12 265 432 685 Uncultured Peritrichia clone Sey084 small subunit ribosomal RNA gene, partial sequence blastn 24937 470 1 Eukaryota Sar   Ciliophora Oligohymenophorea       uncultured Peritrichia
16590619 16590619 PRJEB11523_P_NODE_4514_length_222_cov_5.658960_g4436_i0 PRJEB11523 4514 222 5.65896 12.5628912 Planilamina ovata 2684848 SAR_Eukaryotes SAR_Eukaryotes 202 1.85e-47   NTclustered gi|1784308423|gb|MN830171.1| 2684848 g4436 i0 84.925 71.7477477477478 199 30 90 0 24 222 131 329 Planilamina ovata isolate LJ-II-20170502 large subunit ribosomal RNA gene, partial sequence blastn 15928 202 1 Eukaryota Sar   Ciliophora Phyllopharyngea Dysteriida Kyaroikeidae Planilamina Planilamina ovata
19139264 19139264 PRJEB11523_P_NODE_6376_length_182_cov_3.947368_g6298_i0 PRJEB11523 6376 182 3.947368 7.18420976 Paramecium chlorelligerum 1201934 SAR_Eukaryotes SAR_Eukaryotes 128 2.5e-25   NTclustered gi|532810519|gb|KF110708.1| 1201934 g6298 i0 83.803 47.3406593406593 142 15 74 4 30 164 672 532 Paramecium chlorelligerum strain GC 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 8616 128 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium chlorelligerum
21384672 21384672 PRJEB11523_P_NODE_8737_length_160_cov_2.414414_g8659_i0 PRJEB11523 8737 160 2.414414 3.8630624 Campanella 71870 SAR_Eukaryotes SAR_Eukaryotes 291 2.5799999999999998e-74   NTclustered gi|49356811|gb|AY605215.1| 282477 g8659 i0 99.375 100.3875 160 1 100 0 1 160 10 169 Uncultured Peritrichia clone Sey084 small subunit ribosomal RNA gene, partial sequence blastn 16062 291 1 Eukaryota Sar   Ciliophora Oligohymenophorea       uncultured Peritrichia
22965626 22965626 PRJEB11523_P_NODE_5019_length_209_cov_4.668750_g4941_i0 PRJEB11523 5019 209 4.66875 9.7576875 Kentrophoros sp. 1 BS-2022 2930470 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.005   NTclustered gi|2261268989|emb|OX095830.1| 2930470 g4941 i0 100 0.674641148325359 29 0 14 0 1 29 10 38 Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) blastn 141 54.7 1 Eukaryota Sar   Ciliophora Karyorelictea Protostomatida Kentrophoridae Kentrophoros Kentrophoros sp. 1 BS-2022
23934961 23934961 PRJEB11523_P_NODE_6619_length_178_cov_25.899225_g6541_i0 PRJEB11523 6619 178 25.899225 46.1006205 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 259 8.27e-65   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g6541 i0 96.203 8.3876404494382 158 6 89 0 21 178 199 356 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 1493 259 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
23934962 23934962 PRJEB11523_P_NODE_6839_length_175_cov_7.325397_g6761_i0 PRJEB11523 6839 175 7.325397 12.81944475 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 233 4.9099999999999994e-57   NTclustered gi|1073548544|gb|KU219950.1| 5932 g6761 i0 94.156 82.52 154 8 87 1 23 175 2099 2252 Ichthyophthirius multifiliis isolate Ich.BR 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 14441 235 0.991489361702128 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis

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