RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where analysis = "diamond", bioproject = "PRJNA1160211" 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

  • PRJNA1160211 · 17 ✖

analysis 1

  • diamond · 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
10513210 10513210 PRJNA1160211_S_NODE_170309_length_347_cov_1.686131_g169076_i0 PRJNA1160211 170309 347 1.686131 5.85087457 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 119 3.14e-32   NR XP_001014235.1 312017 g169076 i0 91.4 0.501440922190202 58 5 50.1 0 6 179 23 80 XP_001014235.1 peptidyl-prolyl cis-trans isomerase [Tetrahymena thermophila SB210] diamond 174 119 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
16340699 16340699 PRJNA1160211_S_NODE_133413_length_399_cov_19.042945_g132181_i0 PRJNA1160211 133413 399 19.042945 75.98135055 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 180 4.01e-54   NR CDW89314.1 5949 g132181 i0 70.4 9.25563909774436 125 36 93.2 1 377 6 127 251 CDW89314.1 60s ribosomal protein l8 [Stylonychia lemnae] diamond 3693 180 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
18160628 18160628 PRJNA1160211_S_NODE_105415_length_447_cov_3.211230_g104187_i0 PRJNA1160211 105415 447 3.21123 14.3541981 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 229 1.1899999999999998e-66   NR XP_001009034.2 312017 g104187 i0 82.1 1.79865771812081 134 24 89.9 0 46 447 592 725 XP_001009034.2 hypothetical protein TTHERM_00261860 [Tetrahymena thermophila SB210] diamond 804 229 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
26596899 26596899 PRJNA1160211_S_NODE_114081_length_431_cov_10.907821_g112852_i0 PRJNA1160211 114081 431 10.907821 47.01270851 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 98.6 9.55e-21   NR CAG9335542.1 1481888 g112852 i0 51.3 0.529002320185615 76 37 52.9 0 10 237 672 747 CAG9335542.1 unnamed protein product [Blepharisma stoltei] diamond 228 98.6 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
26913703 26913703 PRJNA1160211_S_NODE_12282_length_782_cov_17.843441_g11436_i0 PRJNA1160211 12282 782 17.843441 139.53570862 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 175 1.85e-50   NR XP_001013080.1 312017 g11436 i0 49.1 1.21994884910486 159 80 60.6 1 779 306 74 232 XP_001013080.1 cyclin-dependent kinase inhibitor 3 [Tetrahymena thermophila SB210] diamond 954 175 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27723503 27723503 PRJNA1160211_S_NODE_124884_length_413_cov_3.850000_g123655_i0 PRJNA1160211 124884 413 3.85 15.9005 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 95.1 2.47e-21   NR CAD8084187.1 5886 g123655 i0 78 4.12590799031477 59 10 42.9 1 135 311 74 129 CAD8084187.1 unnamed protein product [Paramecium primaurelia] diamond 1704 95.9 0.991657977059437 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
28398404 28398404 PRJNA1160211_S_NODE_104526_length_448_cov_44.448000_g103299_i0 PRJNA1160211 104526 448 44.448 199.12704 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 62.8 2.98e-8   NR KRX00302.1 266149 g103299 i0 54.2 0.321428571428571 48 22 32.1 0 422 279 345 392 KRX00302.1 hypothetical protein PPERSA_10801 [Pseudocohnilembus persalinus] diamond 144 62.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
28556517 28556517 PRJNA1160211_S_NODE_260467_length_253_cov_4.700000_g259234_i0 PRJNA1160211 260467 253 4.7 11.891 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 143 2.11e-37   NR XP_001011300.3 312017 g259234 i0 94.7 2.65612648221344 75 4 88.9 0 22 246 187 261 XP_001011300.3 Myb-like DNA-binding domain protein [Tetrahymena thermophila SB210] diamond 672 143 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29870163 29870163 PRJNA1160211_S_NODE_114351_length_431_cov_3.483240_g113122_i0 PRJNA1160211 114351 431 3.48324 15.0127644 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 62.8 2.68e-8   NR XP_004030597.1 5932 g113122 i0 44.8 0.877030162412993 67 37 46.6 0 1 201 423 489 XP_004030597.1 hypothetical protein IMG5_157340 [Ichthyophthirius multifiliis] diamond 378 63.2 0.993670886075949 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
30040410 30040410 PRJNA1160211_S_NODE_225891_length_283_cov_7.957143_g224658_i0 PRJNA1160211 225891 283 7.957143 22.51871469 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.0222   NR XP_001014534.3 312017 g224658 i0 30.2 0.911660777385159 86 59 91.2 1 11 268 148 232 XP_001014534.3 senescence-associated protein [Tetrahymena thermophila SB210] diamond 258 43.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30767140 30767140 PRJNA1160211_S_NODE_46434_length_588_cov_1.768932_g45278_i0 PRJNA1160211 46434 588 1.768932 10.40132016 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 106 3.649999999999999e-23   NR XP_001020602.2 312017 g45278 i0 87.3 0.321428571428571 63 8 32.1 0 572 384 314 376 XP_001020602.2 PX-SNX8-Mvp1p-like protein [Tetrahymena thermophila SB210] diamond 189 106 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30988397 30988397 PRJNA1160211_S_NODE_200814_length_310_cov_1.299578_g199581_i0 PRJNA1160211 200814 310 1.299578 4.0286918 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 89 3.64e-18   NR KAL4427057.1 5901 g199581 i0 48.6 1.01612903225806 105 49 99.7 4 1 309 171 272 KAL4427057.1 hypothetical protein ABPG74_021164 [Tetrahymena malaccensis] diamond 315 89 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
31114429 31114429 PRJNA1160211_S_NODE_140335_length_389_cov_1.968354_g139102_i0 PRJNA1160211 140335 389 1.968354 7.65689706 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 64.3 5.2e-9   NR XP_001033196.1 312017 g139102 i0 39.5 0.624678663239075 81 48 62.5 1 244 2 92 171 XP_001033196.1 kinase domain protein [Tetrahymena thermophila SB210] diamond 243 64.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31272724 31272724 PRJNA1160211_S_NODE_117635_length_425_cov_5.767045_g116406_i0 PRJNA1160211 117635 425 5.767045 24.50994125 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 54.7 1.74e-5   NR CDW76160.1 5949 g116406 i0 37.9 0.931764705882353 66 40 46.6 1 320 123 53 117 CDW76160.1 UNKNOWN [Stylonychia lemnae] diamond 396 54.7 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31291903 31291903 PRJNA1160211_S_NODE_91715_length_474_cov_1.558603_g90492_i0 PRJNA1160211 91715 474 1.558603 7.38777822 root 1 Root_unresolved Root_unresolved 150 1.18e-40   NR CDW89125.1 5949 g90492 i0 62 1.26582278481013 100 38 63.3 0 471 172 291 390 CDW89125.1 UNKNOWN [Stylonychia lemnae] diamond 600 150 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
32285330 32285330 PRJNA1160211_S_NODE_209819_length_300_cov_1.696035_g208586_i0 PRJNA1160211 209819 300 1.696035 5.088105 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 49.7 1.18e-4   NR CAD8082166.1 5886 g208586 i0 66.7 0.42 42 13 41 1 298 176 134 175 CAD8082166.1 unnamed protein product [Paramecium primaurelia] diamond 126 49.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
32316962 32316962 PRJNA1160211_S_NODE_185599_length_327_cov_9.251969_g184366_i0 PRJNA1160211 185599 327 9.251969 30.25393863 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 51.2 5.3e-5   NR XP_001030502.1 312017 g184366 i0 84.6 1.64220183486239 26 4 23.9 0 240 317 113 138 XP_001030502.1 isochorismatase hydrolase [Tetrahymena thermophila SB210] diamond 537 51.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila

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