RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "blastn", bioproject = "PRJNA1000943" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 23 ✖

tax_clade 1

bioproject 1

  • PRJNA1000943 · 23 ✖

analysis 1

  • blastn · 23 ✖

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
145151 145151 PRJNA1000943_P_NODE_15061_length_243_cov_0.917647_g14923_i0 PRJNA1000943 15061 243 0.917647 2.22988221 Pseudokeronopsis erythrina 1230127 SAR_Eukaryotes SAR_Eukaryotes 97.1 9.98e-16   NTclustered gi|2889127627|gb|PQ685978.1| 1230127 g14923 i0 78.431 25.0329218106996 153 29 62 4 93 243 315 165 Pseudokeronopsis erythrina isolate CUI1 mitochondrion, partial genome blastn 6083 97.1 1 Eukaryota Sar   Ciliophora Spirotrichea Urostylida Pseudokeronopsidae Pseudokeronopsis Pseudokeronopsis erythrina
999269 999269 PRJNA1000943_P_NODE_4741_length_364_cov_3.694158_g4604_i0 PRJNA1000943 4741 364 3.694158 13.44673512 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 311 5.16e-80   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g4604 i0 95.385 60.2912087912088 195 9 54 0 1 195 2888 3082 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 21946 311 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
2274392 2274392 PRJNA1000943_P_NODE_6842_length_311_cov_2.449580_g6704_i0 PRJNA1000943 6842 311 2.44958 7.6181938 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 564 3.02e-156   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g6704 i0 99.357 10.0900321543408 311 2 100 0 1 311 1834 1524 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 3138 564 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
2274401 2274401 PRJNA1000943_P_NODE_8982_length_277_cov_4.411765_g8844_i0 PRJNA1000943 8982 277 4.411765 12.22058905 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 496 9.8e-136   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g8844 i0 98.917 98.2057761732852 277 3 100 0 1 277 1219 1495 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 27203 496 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
2695369 2695369 PRJNA1000943_P_NODE_5103_length_353_cov_1.417857_g4966_i0 PRJNA1000943 5103 353 1.417857 5.00503521 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 484 2.7799999999999996e-132   NTclustered gi|347439295|gb|JN111996.1| 151077 g4966 i0 91.477 99.6685552407932 352 30 99 0 1 352 360 711 Chilodonella uncinata strain USA_SC2 alpha-tubulin (atub) gene, partial cds; macronuclear blastn 35183 484 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
6523444 6523444 PRJNA1000943_P_NODE_14946_length_243_cov_0.917647_g14808_i0 PRJNA1000943 14946 243 0.917647 2.22988221 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 189 1.6e-43   NTclustered gi|118358269|ref|XM_001012381.1| 312017 g14808 i0 85.876 160.950617283951 177 25 73 0 55 231 576 400 Tetrahymena thermophila SB210 polyubiquitin partial mRNA blastn 39111 189 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
7797719 7797719 PRJNA1000943_P_NODE_987_length_750_cov_2.335303_g861_i0 PRJNA1000943 987 750 2.335303 17.5147725 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 597 7.699999999999999e-166   NTclustered gi|162708054|gb|EU047827.1| 151077 g861 i0 88.485 8.20133333333333 495 55 66 2 12 505 494 1 Chilodonella uncinata clone Blue actin gene, partial cds blastn 6151 597 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
9072615 9072615 PRJNA1000943_P_NODE_3628_length_408_cov_4.411940_g3491_i0 PRJNA1000943 3628 408 4.41194 18.0007152 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 484 3.259999999999999e-132   NTclustered gi|301014695|gb|GQ377692.1| 151077 g3491 i0 88.337 64.3406862745098 403 47 99 0 1 403 35 437 Chilodonella uncinata ribosomal protein S23a-like (rps23a) mRNA, complete sequence blastn 26251 484 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
9927215 9927215 PRJNA1000943_P_NODE_10688_length_256_cov_2.704918_g10550_i0 PRJNA1000943 10688 256 2.704918 6.92459008 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 473 4.189999999999999e-129   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g10550 i0 100 99.3828125 256 0 100 0 1 256 2536 2791 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 25442 473 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
10348292 10348292 PRJNA1000943_P_NODE_4229_length_382_cov_2.019417_g4092_i0 PRJNA1000943 4229 382 2.019417 7.71417294 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 425 1.86e-114   NTclustered gi|300521444|gb|GQ377690.1| 151077 g4092 i0 87.534 0.965968586387435 369 44 96 2 1 368 545 178 Chilodonella uncinata 14-3-3 protein-like mRNA, partial sequence blastn 369 425 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
12898746 12898746 PRJNA1000943_P_NODE_10491_length_258_cov_4.297297_g10353_i0 PRJNA1000943 10491 258 4.297297 11.08702626 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 320 5.83e-83   NTclustered gi|110645063|gb|DQ665311.1| 151077 g10353 i0 93.868 6.62403100775194 212 13 82 0 1 212 212 1 Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear blastn 1709 320 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
15447878 15447878 PRJNA1000943_P_NODE_5033_length_355_cov_1.326241_g4896_i0 PRJNA1000943 5033 355 1.326241 4.70815555 Isotricha prostoma 5987 SAR_Eukaryotes SAR_Eukaryotes 366 1.0599999999999996e-96   NTclustered gi|92790159|emb|AJ965265.1| 5987 g4896 i0 85.352 184.49014084507 355 51 100 1 1 355 17 370 Isotricha prostoma partial mRNA for Polyubiqutin 3 (polyubiqutin 3 gene) blastn 65494 366 1 Eukaryota Sar   Ciliophora Litostomatea Vestibuliferida Isotrichidae Isotricha Isotricha prostoma
16722032 16722032 PRJNA1000943_P_NODE_414_length_1075_cov_4.995010_g341_i0 PRJNA1000943 414 1075 4.99501 53.6963575 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 979 0   NTclustered gi|110645063|gb|DQ665311.1| 151077 g341 i0 84.939 28.2660465116279 976 137 90 7 105 1075 1205 235 Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear blastn 30386 979 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
17996838 17996838 PRJNA1000943_P_NODE_15975_length_228_cov_2.012903_g15837_i0 PRJNA1000943 15975 228 2.012903 4.5894188400000004 Sterkiella histriomuscorum 94289 SAR_Eukaryotes SAR_Eukaryotes 156 1.51e-33   NTclustered gi|47176538|gb|AY618118.1| 94289 g15837 i0 81.579 53.2763157894737 190 33 83 2 3 191 549 361 Sterkiella histriomuscorum clone UGC1O0005_M17_R genomic sequence blastn 12147 156 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella histriomuscorum
19270681 19270681 PRJNA1000943_P_NODE_1476_length_625_cov_4.503623_g1342_i0 PRJNA1000943 1476 625 4.503623 28.14764375 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 577 8.279999999999998e-160   NTclustered gi|300676719|gb|GQ377693.1| 151077 g1342 i0 86.59 13.6128 522 70 84 0 1 522 18 539 Chilodonella uncinata gcr5-like mRNA, partial sequence blastn 8508 577 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
19270725 19270725 PRJNA1000943_P_NODE_4336_length_378_cov_3.288525_g4199_i0 PRJNA1000943 4336 378 3.288525 12.4306245 Isotricha intestinalis 47897 SAR_Eukaryotes SAR_Eukaryotes 261 5.5e-65   NTclustered gi|92790153|emb|AJ965262.1| 47897 g4199 i0 80.055 101.677248677249 366 61 95 12 1 360 414 55 Isotricha intestinalis partial mRNA for Polyubiqutin 2 (polyubiqutin 2 gene) blastn 38434 261 1 Eukaryota Sar   Ciliophora Litostomatea Vestibuliferida Isotrichidae Isotricha Isotricha intestinalis
19270762 19270762 PRJNA1000943_P_NODE_756_length_842_cov_4.958388_g649_i0 PRJNA1000943 756 842 4.958388 41.74962696 Chilodonella piscicola 1654720 SAR_Eukaryotes SAR_Eukaryotes 1094 0   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g649 i0 90.235 57.2517814726841 850 65 100 15 1 842 2322 1483 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 48206 1094 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
20546298 20546298 PRJNA1000943_P_NODE_2357_length_497_cov_1.363208_g2220_i0 PRJNA1000943 2357 497 1.363208 6.77514376 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 673 0   NTclustered gi|110644972|gb|DQ665918.1| 151077 g2220 i0 91.278 97.102615694165 493 43 99 0 5 497 146 638 Chilodonella uncinata clone 1 beta-tubulin gene, partial cds blastn 48260 673 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
21401346 21401346 PRJNA1000943_P_NODE_1217_length_682_cov_5.791461_g1086_i0 PRJNA1000943 1217 682 5.791461 39.49776402 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 1107 0   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g1086 i0 96.557 59.7741935483871 668 23 98 0 1 668 668 1 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 40766 1107 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
21822004 21822004 PRJNA1000943_P_NODE_4538_length_371_cov_1.986577_g4401_i0 PRJNA1000943 4538 371 1.986577 7.37020067 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 647 0   NTclustered gi|110645063|gb|DQ665311.1| 151077 g4401 i0 98.113 49.8948787061995 371 7 100 0 1 371 634 1004 Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear blastn 18511 647 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
23097348 23097348 PRJNA1000943_P_NODE_6159_length_326_cov_0.984190_g6021_i0 PRJNA1000943 6159 326 0.98419 3.2084594 Isotricha intestinalis 47897 SAR_Eukaryotes SAR_Eukaryotes 339 2.0999999999999997e-88   NTclustered gi|92790151|emb|AJ965261.1| 47897 g6021 i0 85.714 238.444785276074 322 45 98 1 1 321 148 469 Isotricha intestinalis partial mRNA for Polyubiqutin 1 (polyubiqutin 1 gene) blastn 77733 339 1 Eukaryota Sar   Ciliophora Litostomatea Vestibuliferida Isotrichidae Isotricha Isotricha intestinalis
24371000 24371000 PRJNA1000943_P_NODE_14800_length_243_cov_2.564706_g14662_i0 PRJNA1000943 14800 243 2.564706 6.23223558 Dasytricha ruminantium 40806 SAR_Eukaryotes SAR_Eukaryotes 254 5.59e-63   NTclustered gi|92790145|emb|AJ965258.1| 40806 g14662 i0 85.537 113.526748971193 242 35 99 0 2 243 133 374 Dasytricha ruminantium partial mRNA for Polyubiquitin 2 (polyubiquitin 2 gene) blastn 27587 254 1 Eukaryota Sar   Ciliophora Litostomatea Vestibuliferida Isotrichidae Dasytricha Dasytricha ruminantium
24371055 24371055 PRJNA1000943_P_NODE_520_length_980_cov_9.252481_g436_i0 PRJNA1000943 520 980 9.252481 90.6743138 Caryotricha sinica 2652903 SAR_Eukaryotes SAR_Eukaryotes 154 2.65e-32   NTclustered gi|2328859121|gb|OP828526.1| 2652903 g436 i0 97.753 9.19183673469388 89 2 9 0 892 980 982 894 Caryotricha sinica isolate LCY2018041109 large subunit ribosomal RNA gene, partial sequence blastn 9008 154 1 Eukaryota Sar   Ciliophora Spirotrichea Kiitrichida Kiitrichidae Caryotricha Caryotricha sinica

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