RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA380660" 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

bioproject 1

  • PRJNA380660 · 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
2349566 2349566 PRJNA380660_P_NODE_7582_length_260_cov_2.038961_g7182_i0 PRJNA380660 7582 260 2.038961 5.3012986 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 470 5.519999999999998e-128   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g7182 i0 99.231 98.6692307692308 260 2 100 0 1 260 1486 1745 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 25654 470 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
6779984 6779984 PRJNA380660_P_NODE_4486_length_380_cov_228.387464_g4089_i0 PRJNA380660 4486 380 228.387464 867.8723632 Caryotricha minuta 1004043 SAR_Eukaryotes SAR_Eukaryotes 204 9.449999999999999e-48   NTclustered gi|759083508|gb|KM222125.1| 1004043 g4089 i0 93.431 36.3289473684211 137 9 36 0 179 315 1148 1284 Caryotricha minuta voucher LWW07112802 large subunit ribosomal RNA gene, partial sequence blastn 13805 204 1 Eukaryota Sar   Ciliophora Spirotrichea Kiitrichida Kiitrichidae Caryotricha Caryotricha minuta
8055502 8055502 PRJNA380660_P_NODE_2147_length_577_cov_207.430657_g1808_i0 PRJNA380660 2147 577 207.430657 1196.87489089 Caryotricha minuta 1004043 SAR_Eukaryotes SAR_Eukaryotes 204 1.4899999999999999e-47   NTclustered gi|759083508|gb|KM222125.1| 1004043 g1808 i0 93.431 25.3726169844021 137 9 24 0 179 315 1148 1284 Caryotricha minuta voucher LWW07112802 large subunit ribosomal RNA gene, partial sequence blastn 14640 204 1 Eukaryota Sar   Ciliophora Spirotrichea Kiitrichida Kiitrichidae Caryotricha Caryotricha minuta
9330315 9330315 PRJNA380660_P_NODE_1628_length_662_cov_25.099526_g1311_i0 PRJNA380660 1628 662 25.099526 166.15886212 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 411 9.44e-110   NTclustered gi|1004125725|gb|KU761582.1| 153251 g1311 i0 82.136 66.3444108761329 487 79 79 7 22 503 5873 6356 Cryptocaryon irritans isolate ND1410 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, and intergenic spacer, complete sequence blastn 43920 411 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
10606014 10606014 PRJNA380660_P_NODE_9109_length_223_cov_1.963918_g8709_i0 PRJNA380660 9109 223 1.963918 4.37953714 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 313 8.23e-81   NTclustered gi|110645063|gb|DQ665311.1| 151077 g8709 i0 91.964 76.6188340807175 224 16 100 2 1 223 1120 898 Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear blastn 17086 313 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
11277446 11277446 PRJNA380660_P_NODE_5529_length_331_cov_2.937086_g5130_i0 PRJNA380660 5529 331 2.937086 9.72175466 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 527 4.249999999999999e-145   NTclustered gi|1389430796|gb|MH341624.1| 1654720 g5130 i0 98.333 93.1389728096677 300 5 100 0 32 331 47 346 Chilodonella piscicola strain C.piscicola SC small subunit ribosomal RNA gene, partial sequence blastn 30829 527 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
11880938 11880938 PRJNA380660_P_NODE_2870_length_494_cov_222.763441_g2501_i0 PRJNA380660 2870 494 222.763441 1100.45139854 Caryotricha minuta 1004043 SAR_Eukaryotes SAR_Eukaryotes 204 1.26e-47   NTclustered gi|759083508|gb|KM222125.1| 1004043 g2501 i0 93.431 29.748987854251 137 9 28 0 90 226 1148 1284 Caryotricha minuta voucher LWW07112802 large subunit ribosomal RNA gene, partial sequence blastn 14696 204 1 Eukaryota Sar   Ciliophora Spirotrichea Kiitrichida Kiitrichidae Caryotricha Caryotricha minuta
11880946 11880946 PRJNA380660_P_NODE_3810_length_418_cov_5.578406_g3419_i0 PRJNA380660 3810 418 5.578406 23.31773708 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 182 7.52e-53   NR CDW84941.1 5949 g3419 i0 82.6 2.34688995215311 109 19 78.2 0 418 92 321 429 CDW84941.1 26s protease regulatory subunit 6a [Stylonychia lemnae] diamond 981 182 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
13155997 13155997 PRJNA380660_P_NODE_6591_length_291_cov_2.351145_g6191_i0 PRJNA380660 6591 291 2.351145 6.84183195 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 429 1.07e-115   NTclustered gi|110645063|gb|DQ665311.1| 151077 g6191 i0 95.522 34.254295532646 268 12 100 0 1 268 899 632 Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear blastn 9968 429 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
22751048 22751048 PRJNA380660_P_NODE_4018_length_406_cov_6.880637_g3623_i0 PRJNA380660 4018 406 6.880637 27.93538622 Chilodonella 151076 SAR_Eukaryotes SAR_Eukaryotes 704 0   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g3623 i0 98.982 94.85960591133 393 4 97 0 1 393 2359 2751 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 38513 704 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
27123324 27123324 PRJNA380660_P_NODE_6202_length_305_cov_2.532609_g5802_i0 PRJNA380660 6202 305 2.532609 7.72445745 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 74.3 5.75e-13   NR OMJ78067.1 5963 g5802 i0 49.3 2.67540983606557 67 33 65.9 1 3 203 381 446 OMJ78067.1 hypothetical protein SteCoe_22223 [Stentor coeruleus] diamond 816 74.7 0.994645247657296 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
27391257 27391257 PRJNA380660_P_NODE_8923_length_226_cov_3.573604_g8523_i0 PRJNA380660 8923 226 3.573604 8.07634504 Paramecium pentaurelia 43138 SAR_Eukaryotes SAR_Eukaryotes 56.2 3.48e-8   NR CAD8136753.1 43138 g8523 i0 34.8 0.915929203539823 69 42 87.6 1 198 1 17 85 CAD8136753.1 unnamed protein product [Paramecium pentaurelia] diamond 207 56.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia
28702748 28702748 PRJNA380660_P_NODE_8687_length_231_cov_3.262376_g8287_i0 PRJNA380660 8687 231 3.262376 7.53608856 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 65.1 4.39e-10   NR OMJ88878.1 5963 g8287 i0 42.7 2.94805194805195 75 36 97.4 1 225 1 855 922 OMJ88878.1 hypothetical protein SteCoe_9082 [Stentor coeruleus] diamond 681 65.1 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
29822059 29822059 PRJNA380660_P_NODE_6651_length_289_cov_2.142308_g6251_i0 PRJNA380660 6651 289 2.142308 6.19127012 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 54.7 4.14e-6   NR OMJ86545.1 5963 g6251 i0 67.7 1.80622837370242 31 10 32.2 0 182 90 243 273 OMJ86545.1 hypothetical protein SteCoe_11896 [Stentor coeruleus] diamond 522 54.7 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
31086098 31086098 PRJNA380660_P_NODE_3855_length_416_cov_2.607235_g3464_i0 PRJNA380660 3855 416 2.607235 10.8460976 Paramecium pentaurelia 43138 SAR_Eukaryotes SAR_Eukaryotes 60.1 1.54e-7   NR CAD8163894.1 43138 g3464 i0 33.7 4.22596153846154 98 61 70.7 2 414 121 136 229 CAD8163894.1 unnamed protein product [Paramecium pentaurelia] diamond 1758 60.1 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium pentaurelia

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