RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 15 ✖

bioproject 1

  • PRJNA816047 · 15 ✖

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
25632727 25632727 PRJNA816047a_S_NODE_36017_length_346_cov_1.644689_g33357_i0 PRJNA816047 36017 346 1.644689 5.69062394 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 289 2.29e-73   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g33357 i0 98.182 53.1878612716763 165 3 48 0 172 336 3082 2918 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 18403 289 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
25739610 25739610 PRJNA816047d_S_NODE_29498_length_392_cov_5.657817_g27666_i0 PRJNA816047 29498 392 5.657817 22.17864264 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 233 4.26e-74   NR CAD8102823.1 5886 g27666 i0 86.8 474.076530612245 121 16 92.6 0 4 366 25 145 CAD8102823.1 unnamed protein product [Paramecium primaurelia] diamond 185838 234 0.995726495726496 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
25863527 25863527 PRJNA816047a_S_NODE_20595_length_446_cov_9.739946_g17946_i0 PRJNA816047 20595 446 9.739946 43.44015916 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 305 3e-78   NTclustered gi|11466252|ref|NC_000862.1| 5908 g17946 i0 84.326 62.6300448430493 319 42 70 7 91 404 774 1089 Tetrahymena pyriformis mitochondrion, complete genome blastn 27933 305 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
25869769 25869769 PRJNA816047b_S_NODE_22123_length_345_cov_2.779412_g19811_i0 PRJNA816047 22123 345 2.779412 9.5889714 Cyclidium glaucoma 35100 SAR_Eukaryotes SAR_Eukaryotes 616 9.229999999999999e-172   NTclustered gi|111035915|emb|AJ781092.1| 35100 g19811 i0 99.702 95.936231884058 336 1 97 0 1 336 338 3 Cyclidium glaucoma partial 23S rRNA gene, strain ATCC 30701 blastn 33098 616 1 Eukaryota Sar   Ciliophora Oligohymenophorea Pleuronematida Cyclidiidae Cyclidium Cyclidium glaucoma
26282105 26282105 PRJNA816047d_S_NODE_131982_length_229_cov_3.505682_g130147_i0 PRJNA816047 131982 229 3.505682 8.02801178 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 159 1.1699999999999999e-34   NTclustered gi|471226551|ref|XM_004032261.1| 5932 g130147 i0 84.906 46.4541484716157 159 22 69 2 1 158 638 481 Ichthyophthirius multifiliis ATP synthase alpha subunit precursor, putative (IMG5_124890) mRNA, complete cds blastn 10638 159 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
26544063 26544063 PRJNA816047a_S_NODE_21656_length_436_cov_3.305785_g19006_i0 PRJNA816047 21656 436 3.305785 14.4132226 Coleps hirtus 60000 SAR_Eukaryotes SAR_Eukaryotes 632 1.1799999999999995e-176   NTclustered gi|2026535536|gb|MW929305.1| 60000 g19006 i0 99.148 80.6215596330275 352 1 80 1 21 370 2261 2612 Coleps hirtus strain AG Berninger/Pickham Uni Salzburg 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 35151 632 1 Eukaryota Sar   Ciliophora Prostomatea Prorodontida Colepidae Coleps Coleps hirtus
26551247 26551247 PRJNA816047b_S_NODE_34456_length_287_cov_3.509346_g32144_i0 PRJNA816047 34456 287 3.509346 10.07182302 Coleps hirtus 60000 SAR_Eukaryotes SAR_Eukaryotes 510 3.64e-140   NTclustered gi|2026535536|gb|MW929305.1| 60000 g32144 i0 98.951 100.567944250871 286 1 99 1 4 287 2545 2260 Coleps hirtus strain AG Berninger/Pickham Uni Salzburg 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 28863 510 1 Eukaryota Sar   Ciliophora Prostomatea Prorodontida Colepidae Coleps Coleps hirtus
32924979 32924979 PRJNA816047d_S_NODE_17161_length_542_cov_8.670757_g15421_i0 PRJNA816047 17161 542 8.670757 46.99550294 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 76.6 6.57e-14   NR CAD8055348.1 5886 g15421 i0 31.3 3.01660516605166 134 92 74.2 0 541 140 31 164 CAD8055348.1 unnamed protein product [Paramecium primaurelia] diamond 1635 77 0.994805194805195 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
32925065 32925065 PRJNA816047d_S_NODE_76577_length_265_cov_1.136792_g74742_i0 PRJNA816047 76577 265 1.136792 3.0124988 root 1 Root_unresolved Root_unresolved 126 1.3499999999999999e-34   NR XP_001019714.4 312017 g74742 i0 75.7 5.13962264150943 74 18 83.8 0 1 222 110 183 XP_001019714.4 methionine-R-sulfoxide reductase [Tetrahymena thermophila SB210] diamond 1362 127 0.992125984251969 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
32939142 32939142 PRJNA816047d_S_NODE_44889_length_326_cov_1.461538_g43054_i0 PRJNA816047 44889 326 1.461538 4.76461388 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 54.3 8.5e-6   NR CAG9315931.1 1481888 g43054 i0 41.7 1.37116564417178 72 34 58.9 3 133 324 388 459 CAG9315931.1 unnamed protein product [Blepharisma stoltei] diamond 447 54.3 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
33024205 33024205 PRJNA816047b_S_NODE_44596_length_257_cov_2.456522_g42284_i0 PRJNA816047 44596 257 2.456522 6.31326154 Halteria grandinella 5974 SAR_Eukaryotes SAR_Eukaryotes 48.5 3.18e-4   NR TNV78266.1 5974 g42284 i0 80.8 0.607003891050584 26 5 30.4 0 5 82 214 239 TNV78266.1 hypothetical protein FGO68_gene9047 [Halteria grandinella] diamond 156 48.5 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Halteriidae Halteria Halteria grandinella
33041594 33041594 PRJNA816047d_S_NODE_45772_length_323_cov_3.462963_g43937_i0 PRJNA816047 45772 323 3.462963 11.18537049 Paramecium pentaurelia 43138 SAR_Eukaryotes SAR_Eukaryotes 63.5 3.78e-9   NR CAD8205681.1 43138 g43937 i0 36.5 0.687306501547988 74 43 65 1 300 91 257 330 CAD8205681.1 unnamed protein product [Paramecium pentaurelia] diamond 222 63.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
33061601 33061601 PRJNA816047d_S_NODE_27429_length_407_cov_8.248588_g25599_i0 PRJNA816047 27429 407 8.248588 33.57175316 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 131 9.76e-34   NR OMJ68875.1 5963 g25599 i0 63.5 7.0982800982801 96 35 70.8 0 405 118 295 390 OMJ68875.1 hypothetical protein SteCoe_33545 [Stentor coeruleus] diamond 2889 131 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
33144048 33144048 PRJNA816047d_S_NODE_62863_length_286_cov_2.085837_g61028_i0 PRJNA816047 62863 286 2.085837 5.96549382 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 53.5 9.95e-6   NR XP_004037227.1 5932 g61028 i0 50 0.912587412587413 42 21 44.1 0 29 154 543 584 XP_004037227.1 vacuolar sorting protein, putative [Ichthyophthirius multifiliis] diamond 261 53.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
33164003 33164003 PRJNA816047d_S_NODE_65792_length_281_cov_2.070175_g63957_i0 PRJNA816047 65792 281 2.070175 5.81719175 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 82.8 5e-16   NR CAD8082597.1 5886 g63957 i0 44.6 10.6975088967972 92 51 98.2 0 280 5 1438 1529 CAD8082597.1 unnamed protein product [Paramecium primaurelia] diamond 3006 82.8 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia

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