RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where bioproject = "PRJNA685607", 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 · 27 ✖

tax_clade 1

  • Sar · 27 ✖

bioproject 1

  • PRJNA685607 · 27 ✖

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
666254 666254 PRJNA685607_P_NODE_13241_length_439_cov_1.967213_g12883_i0 PRJNA685607 13241 439 1.967213 8.63606507 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 756 0   NTclustered gi|512134943|gb|JX178902.1| 1295638 g12883 i0 97.936 93.8952164009112 436 9 99 0 4 439 1449 1014 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 41220 756 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
1942373 1942373 PRJNA685607_P_NODE_67342_length_250_cov_1.553672_g66983_i0 PRJNA685607 67342 250 1.553672 3.88418 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 401 1.9499999999999994e-107   NTclustered gi|300676714|gb|GQ377691.1| 151077 g66983 i0 95.6 13.088 250 11 100 0 1 250 136 385 Chilodonella uncinata rps22a (rps22a) mRNA, complete cds blastn 3272 401 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
4494254 4494254 PRJNA685607_P_NODE_46744_length_285_cov_1.084906_g46385_i0 PRJNA685607 46744 285 1.084906 3.0919821 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 168 3.39e-49   NR CAI2375149.1 5936 g46385 i0 74.5 563.284210526316 94 24 98.9 0 4 285 99 192 CAI2375149.1 unnamed protein product [Moneuplotes crassus] diamond 160536 169 0.994082840236686 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
9594944 9594944 PRJNA685607_P_NODE_54828_length_269_cov_1.178571_g54469_i0 PRJNA685607 54828 269 1.178571 3.17035599 Chilodonella hexasticha 1938391 SAR_Eukaryotes SAR_Eukaryotes 468 2.06e-127   NTclustered gi|1389430805|gb|MH341633.1| 1938391 g54469 i0 98.134 77.5353159851301 268 5 99 0 2 269 2275 2008 Chilodonella hexasticha strain C.hexasticha AS large subunit ribosomal RNA gene, partial sequence blastn 20857 468 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella hexasticha
12145581 12145581 PRJNA685607_P_NODE_19810_length_377_cov_23.996711_g19452_i0 PRJNA685607 19810 377 23.996711 90.46760047 Chilodonella piscicola 1654720 SAR_Eukaryotes SAR_Eukaryotes 586 7.959999999999997e-163   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g19452 i0 94.709 96.1352785145889 378 18 100 2 1 377 386 10 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 36243 586 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
21068821 21068821 PRJNA685607_P_NODE_67297_length_250_cov_1.683616_g66938_i0 PRJNA685607 67297 250 1.683616 4.20904 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 115 2.85e-21   NTclustered gi|829192014|ref|XM_012799966.1| 312017 g66938 i0 88.421 1.68 95 11 38 0 48 142 125 219 Tetrahymena thermophila SB210 hypothetical protein partial mRNA blastn 420 115 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
23619241 23619241 PRJNA685607_P_NODE_6819_length_588_cov_1.302913_g6468_i0 PRJNA685607 6819 588 1.302913 7.66112844 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 315 2.0899999999999997e-106   NR OMJ67736.1 5963 g6468 i0 73.6 7.03571428571429 197 50 99.5 1 587 3 51 247 OMJ67736.1 hypothetical protein SteCoe_35015 [Stentor coeruleus] diamond 4137 317 0.993690851735016 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
24892414 24892414 PRJNA685607_P_NODE_34600_length_315_cov_1.272727_g34241_i0 PRJNA685607 34600 315 1.272727 4.00909005 Sterkiella nova 200597 SAR_Eukaryotes SAR_Eukaryotes 209 1.65e-49   NTclustered gi|1051275|gb|U37280.1|ONU37280 200597 g34241 i0 80.068 76.3746031746032 296 48 91 7 9 296 1810 1518 Oxytricha nova Hsp70 gene, complete cds blastn 24058 209 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Sterkiella Sterkiella nova
26733646 26733646 PRJNA685607_P_NODE_89001_length_243_cov_0.905882_g88642_i0 PRJNA685607 89001 243 0.905882 2.20129326 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 51.6 3.98e-6   NR KRX05651.1 266149 g88642 i0 27.8 2.95061728395062 79 57 97.5 0 242 6 6 84 KRX05651.1 hypothetical protein PPERSA_09791 [Pseudocohnilembus persalinus] diamond 717 51.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
27176864 27176864 PRJNA685607_P_NODE_89942_length_243_cov_0.905882_g89583_i0 PRJNA685607 89942 243 0.905882 2.20129326 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 97.1 2.91e-21   NR KRW98936.1 266149 g89583 i0 55.8 0.950617283950617 77 34 95.1 0 10 240 515 591 KRW98936.1 P-loop containing nucleoside triphosphate hydrolase [Pseudocohnilembus persalinus] diamond 231 97.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
27208450 27208450 PRJNA685607_P_NODE_72962_length_248_cov_1.685714_g72603_i0 PRJNA685607 72962 248 1.685714 4.18057072 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 72.8 6.65e-14   NR CAD8127098.1 65129 g72603 i0 61.2 1.66935483870968 67 25 79.8 1 246 49 90 156 CAD8127098.1 unnamed protein product [Paramecium sonneborni] diamond 414 72.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
28104344 28104344 PRJNA685607_P_NODE_77965_length_247_cov_0.885057_g77606_i0 PRJNA685607 77965 247 0.885057 2.18609079 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0297   NR CAD8109893.1 5886 g77606 i0 46.2 2.417004048583 39 19 47.4 1 38 154 914 950 CAD8109893.1 unnamed protein product [Paramecium primaurelia] diamond 597 43.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
28483456 28483456 PRJNA685607_P_NODE_66506_length_251_cov_0.865169_g66147_i0 PRJNA685607 66506 251 0.865169 2.17157419 Oligohymenophorea 6020 SAR_Eukaryotes SAR_Eukaryotes 126 1.7999999999999998e-31   NR XP_001461148.1 5888 g66147 i0 65.8 4.72111553784861 79 27 94.4 0 238 2 2564 2642 XP_001461148.1 uncharacterized protein GSPATT00026097001 [Paramecium tetraurelia] diamond 1185 127 0.992125984251969 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
28672923 28672923 PRJNA685607_P_NODE_32147_length_323_cov_0.960000_g31788_i0 PRJNA685607 32147 323 0.96 3.1008 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 155 9.169999999999998e-42   NR CAI2362588.1 5936 g31788 i0 69.4 5.01547987616099 108 32 99.4 1 323 3 371 478 CAI2362588.1 unnamed protein product [Moneuplotes crassus] diamond 1620 155 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
29198176 29198176 PRJNA685607_P_NODE_44129_length_290_cov_1.271889_g43770_i0 PRJNA685607 44129 290 1.271889 3.6884781 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 100 3.64e-22   NR KRW98191.1 266149 g43770 i0 50 0.972413793103448 94 47 97.2 0 9 290 315 408 KRW98191.1 Metalloenzyme, LuxS/M16 peptidase-like protein [Pseudocohnilembus persalinus] diamond 282 100 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
29292695 29292695 PRJNA685607_P_NODE_93889_length_242_cov_0.911243_g93530_i0 PRJNA685607 93889 242 0.911243 2.20520806 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 126 1.54e-31   NR CDW74966.1 5949 g93530 i0 71.8 0.966942148760331 78 22 96.7 0 9 242 434 511 CDW74966.1 UNKNOWN [Stylonychia lemnae] diamond 234 126 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29924372 29924372 PRJNA685607_P_NODE_85431_length_244_cov_0.900585_g85072_i0 PRJNA685607 85431 244 0.900585 2.1974274 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.00575   NR XP_004029900.1 5932 g85072 i0 30.3 0.811475409836066 66 46 81.1 0 199 2 62 127 XP_004029900.1 hypothetical protein IMG5_170860 [Ichthyophthirius multifiliis] diamond 198 43.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
30808927 30808927 PRJNA685607_P_NODE_25954_length_345_cov_1.132353_g25595_i0 PRJNA685607 25954 345 1.132353 3.90661785 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 97.4 5.5e-23   NR CDW83682.1 5949 g25595 i0 48.5 1.69565217391304 99 50 86.1 1 343 47 1 98 CDW83682.1 60s ribosomal protein [Stylonychia lemnae] diamond 585 97.4 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31124491 31124491 PRJNA685607_P_NODE_36515_length_310_cov_0.945148_g36156_i0 PRJNA685607 36515 310 0.945148 2.9299588 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 113 7.1e-30   NR XP_004035553.1 5932 g36156 i0 67.9 2.24516129032258 78 25 75.5 0 3 236 43 120 XP_004035553.1 hypothetical protein IMG5_097440 [Ichthyophthirius multifiliis] diamond 696 113 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
31421050 31421050 PRJNA685607_P_NODE_48396_length_281_cov_1.480769_g48037_i0 PRJNA685607 48396 281 1.480769 4.16096089 Oligohymenophorea 6020 SAR_Eukaryotes SAR_Eukaryotes 54.7 8.41e-7   NR KRX07275.1 266149 g48037 i0 34.8 1.99644128113879 92 60 98.2 0 277 2 7 98 KRX07275.1 hypothetical protein PPERSA_06890 [Pseudocohnilembus persalinus] diamond 561 55.1 0.992740471869329 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
31883811 31883811 PRJNA685607_P_NODE_66657_length_251_cov_0.865169_g66298_i0 PRJNA685607 66657 251 0.865169 2.17157419 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 68.9 2.08e-11   NR XP_001443975.1 5888 g66298 i0 39 3.9203187250996 82 50 98 0 248 3 261 342 XP_001443975.1 uncharacterized protein GSPATT00012130001 [Paramecium tetraurelia] diamond 984 68.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
32560233 32560233 PRJNA685607_P_NODE_86739_length_244_cov_0.900585_g86380_i0 PRJNA685607 86739 244 0.900585 2.1974274 Oligohymenophorea 6020 SAR_Eukaryotes SAR_Eukaryotes 94.7 1.9e-20   NR KAL4444766.1 5901 g86380 i0 64.6 10.9180327868852 79 22 94.7 3 3 233 3788 3862 KAL4444766.1 hypothetical protein ABPG74_015974 [Tetrahymena malaccensis] diamond 2664 94.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
32591599 32591599 PRJNA685607_P_NODE_85899_length_244_cov_0.900585_g85540_i0 PRJNA685607 85899 244 0.900585 2.1974274 root 1 Root_unresolved Root_unresolved 119 2.6e-29   NR XP_001437608.1 5888 g85540 i0 69.1 13.9426229508197 81 25 99.6 0 2 244 414 494 XP_001437608.1 uncharacterized protein GSPATT00038313001 [Paramecium tetraurelia] diamond 3402 120 0.991666666666667 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
32642631 32642631 PRJNA685607_P_NODE_94820_length_241_cov_0.916667_g94461_i0 PRJNA685607 94820 241 0.916667 2.20916747 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 60.8 1.48e-8   NR CDW77359.1 5949 g94461 i0 38 1.9792531120332 79 46 97.1 2 235 2 149 225 CDW77359.1 polygalacturonase [Stylonychia lemnae] diamond 477 60.8 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
32685799 32685799 PRJNA685607_P_NODE_19260_length_381_cov_3.496753_g18902_i0 PRJNA685607 19260 381 3.496753 13.32262893 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 117 4.76e-31   NR CDW83169.1 5949 g18902 i0 58.2 5.1259842519685 110 42 85 2 47 370 3 110 CDW83169.1 UNKNOWN [Stylonychia lemnae] diamond 1953 117 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
32717460 32717460 PRJNA685607_P_NODE_69280_length_250_cov_0.870056_g68921_i0 PRJNA685607 69280 250 0.870056 2.17514 Sporadotrichida 693921 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0296   NR CDW90428.1 5949 g68921 i0 31.7 1.968 82 56 98.4 0 2 247 236 317 CDW90428.1 UNKNOWN [Stylonychia lemnae] diamond 492 43.5 0.990804597701149 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
32800192 32800192 PRJNA685607_P_NODE_88520_length_243_cov_0.905882_g88161_i0 PRJNA685607 88520 243 0.905882 2.20129326 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 91.7 6.9e-21   NR XP_004037251.1 5932 g88161 i0 64.3 1.67901234567901 70 25 86.4 0 243 34 48 117 XP_004037251.1 hypothetical protein IMG5_057300 [Ichthyophthirius multifiliis] diamond 408 91.7 1 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);;