RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA1068830" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 14 ✖

tax_clade 1

bioproject 1

  • PRJNA1068830 · 14 ✖

analysis 1

  • blastn · 14 ✖

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
1014299 1014299 PRJNA1068830_P_NODE_69121_length_259_cov_2.236559_g68418_i0 PRJNA1068830 69121 259 2.236559 5.79268781 Epistylis 155142 SAR_Eukaryotes SAR_Eukaryotes 368 2.06e-97   NTclustered gi|2304601480|gb|OP458301.1| 2979167 g68418 i0 92.278 74.5984555984556 259 20 100 0 1 259 593 335 Epistylis sp. 4 large subunit ribosomal RNA gene, partial sequence blastn 19321 368 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Epistylidae Epistylis Epistylis sp. 4
2289600 2289600 PRJNA1068830_P_NODE_73242_length_252_cov_20.575419_g72539_i0 PRJNA1068830 73242 252 20.575419 51.85005588 Vorticellidae 85904 SAR_Eukaryotes SAR_Eukaryotes 464 2.4799999999999998e-126   NTclustered gi|2557734683|gb|OR397926.1| 77619 g72539 i0 100 98.2023809523809 251 0 99 0 2 252 768 1018 Vorticella microstoma strain CCAP 1690/3 small subunit ribosomal RNA gene, partial sequence blastn 24747 464 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella microstoma
2732951 2732951 PRJNA1068830_P_NODE_26663_length_448_cov_5.298667_g25960_i0 PRJNA1068830 26663 448 5.298667 23.73802816 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 272 3.0599999999999993e-68   NTclustered gi|194245783|gb|EU828456.1| 5888 g25960 i0 80.533 54.7901785714286 375 55 82 17 45 411 1983 1619 Paramecium tetraurelia large subunit ribosomal RNA gene, complete sequence blastn 24546 272 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
7836075 7836075 PRJNA1068830_P_NODE_73407_length_252_cov_1.743017_g72704_i0 PRJNA1068830 73407 252 1.743017 4.39240284 Epistylis sp. 8 2979171 SAR_Eukaryotes SAR_Eukaryotes 460 3.2e-125   NTclustered gi|2304601484|gb|OP458305.1| 2979171 g72704 i0 99.603 78.2103174603175 252 1 100 0 1 252 623 372 Epistylis sp. 8 large subunit ribosomal RNA gene, partial sequence blastn 19709 460 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Epistylidae Epistylis Epistylis sp. 8
13767476 13767476 PRJNA1068830_P_NODE_37671_length_364_cov_27.553265_g36968_i0 PRJNA1068830 37671 364 27.553265 100.2938846 Sessilida 1974272 SAR_Eukaryotes SAR_Eukaryotes 667 0   NTclustered gi|115353907|gb|DQ868347.1| 77619 g36968 i0 99.725 98.9285714285714 364 1 100 0 1 364 8 371 Vorticella microstoma 18S small subunit ribosomal RNA gene, partial sequence blastn 36010 673 0.991084695393759 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella microstoma
14211128 14211128 PRJNA1068830_P_NODE_28792_length_427_cov_27.940678_g28089_i0 PRJNA1068830 28792 427 27.940678 119.30669506 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 255 2.92e-63   NTclustered gi|194245783|gb|EU828456.1| 5888 g28089 i0 79.733 54.1428571428571 375 58 86 17 24 390 1983 1619 Paramecium tetraurelia large subunit ribosomal RNA gene, complete sequence blastn 23119 255 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
14211688 14211688 PRJNA1068830_P_NODE_52512_length_301_cov_2.052632_g51809_i0 PRJNA1068830 52512 301 2.052632 6.17842232 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 422 1.85e-113   NTclustered gi|347439291|gb|JN111994.1| 151077 g51809 i0 92.256 98.9335548172757 297 23 99 0 3 299 520 816 Chilodonella uncinata strain Pol alpha-tubulin (atub) gene, partial cds; macronuclear blastn 29779 422 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
14212631 14212631 PRJNA1068830_P_NODE_88432_length_242_cov_0.923077_g87729_i0 PRJNA1068830 88432 242 0.923077 2.23384634 Chilodonella uncinata 151077 SAR_Eukaryotes SAR_Eukaryotes 287 5.49e-73   NTclustered gi|110645063|gb|DQ665311.1| 151077 g87729 i0 88.017 21.900826446281 242 29 100 0 1 242 822 581 Chilodonella uncinata clone 1 elongation factor 1-alpha (EF-1alpha) gene, partial cds; macronuclear blastn 5300 287 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella uncinata
15042004 15042004 PRJNA1068830_P_NODE_67432_length_263_cov_1.642105_g66729_i0 PRJNA1068830 67432 263 1.642105 4.31873615 Zoothamnium 168256 SAR_Eukaryotes SAR_Eukaryotes 215 2.89e-51   NTclustered gi|1251948959|gb|KY675192.1| 2042505 g66729 i0 85.714 77.2167300380228 210 22 78 7 59 263 1188 982 Zoothamnium sp. 11 JI2016 large subunit ribosomal RNA gene, partial sequence blastn 20308 215 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Zoothamnidae Zoothamnium Zoothamnium sp. 11 JI2016
20583868 20583868 PRJNA1068830_P_NODE_42337_length_340_cov_12.423221_g41634_i0 PRJNA1068830 42337 340 12.423221 42.2389514 Epistylis sp. 2509650 SAR_Eukaryotes SAR_Eukaryotes 348 3.6600000000000003e-91   NTclustered gi|1705421476|gb|MN184618.1| 2509650 g41634 i0 91.667 2.95882352941176 252 19 74 2 14 264 989 739 Epistylis sp. isolate LBR2016092802 small subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 1006 348 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Epistylidae Epistylis Epistylis sp.
21859087 21859087 PRJNA1068830_P_NODE_20178_length_531_cov_21.925764_g19478_i0 PRJNA1068830 20178 531 21.925764 116.42580684 uncultured ciliate 187299 SAR_Eukaryotes SAR_Eukaryotes 948 0   NTclustered gi|225548487|gb|FJ765384.1| 187299 g19478 i0 98.872 93.1393596986817 532 5 100 1 1 531 541 10 Uncultured ciliate clone SEO81101_26 18S ribosomal RNA gene, partial sequence blastn 49457 948 1 Eukaryota Sar   Ciliophora         uncultured ciliate
21859682 21859682 PRJNA1068830_P_NODE_47278_length_319_cov_2.487805_g46575_i0 PRJNA1068830 47278 319 2.487805 7.93609795 Tokophrya lemnarum 168139 SAR_Eukaryotes SAR_Eukaryotes 579 1.1099999999999996e-160   NTclustered gi|37703329|gb|AY332721.1| 168139 g46575 i0 99.373 93.4263322884013 319 2 100 0 1 319 441 123 Tokophrya lemnarum clone 2 small subunit ribosomal RNA gene, complete sequence blastn 29803 579 1 Eukaryota Sar   Ciliophora Phyllopharyngea Endogenida Tokophryidae Tokophrya Tokophrya lemnarum
23966760 23966760 PRJNA1068830_P_NODE_81519_length_247_cov_0.896552_g80816_i0 PRJNA1068830 81519 247 0.896552 2.21448344 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 231 2.6699999999999997e-56   NTclustered gi|92790183|emb|AJ965277.1| 300017 g80816 i0 83.951 116.429149797571 243 37 98 2 1 242 559 800 Epidinium ecaudatum partial mRNA for Polyubiqutin 2 (polyubiqutin 2 gene) blastn 28758 231 1 Eukaryota Sar   Ciliophora Litostomatea Entodiniomorphida Ophryoscolecidae Epidinium Epidinium ecaudatum
24408836 24408836 PRJNA1068830_P_NODE_49040_length_313_cov_1.300000_g48337_i0 PRJNA1068830 49040 313 1.3 4.069 Ephelota gemmipara 398671 SAR_Eukaryotes SAR_Eukaryotes 296 1.22e-75   NTclustered gi|759083541|gb|KM222158.1| 398671 g48337 i0 84.262 61.3418530351438 305 46 97 2 2 306 924 622 Ephelota gemmipara voucher CXR2007051101 large subunit ribosomal RNA gene, partial sequence blastn 19200 296 1 Eukaryota Sar   Ciliophora Phyllopharyngea Exogenida Ephelotidae Ephelota Ephelota gemmipara

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