RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA1065838" and tax_phylum = "Ciliophora"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Ciliophora · 10 ✖

tax_clade 1

bioproject 1

  • PRJNA1065838 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
179991 179991 PRJNA1065838_S_NODE_16001_length_214_cov_3.042424_g15899_i0 PRJNA1065838 16001 214 3.042424 6.51078736 Chilodonella piscicola 1654720 SAR_Eukaryotes SAR_Eukaryotes 335 1.6699999999999995e-87   NTclustered gi|1389430804|gb|MH341632.1| 1654720 g15899 i0 94.86 6.00467289719626 214 11 100 0 1 214 119 332 Chilodonella piscicola strain SC large subunit ribosomal RNA gene, partial sequence blastn 1285 335 1 Eukaryota Sar   Ciliophora Phyllopharyngea Chlamydodontida Chilodonellidae Chilodonella Chilodonella piscicola
1012786 1012786 PRJNA1065838_S_NODE_7061_length_283_cov_4235.504274_g6959_i0 PRJNA1065838 7061 283 4235.504274 11986.47709542 Vorticella 60849 SAR_Eukaryotes SAR_Eukaryotes 381 2.929999999999999e-101   NTclustered gi|363412153|gb|JN120227.1| 60850 g6959 i0 100 72.791519434629 206 0 73 0 78 283 1458 1253 Vorticella convallaria isolate 96Vorsp16 18S ribosomal RNA gene, partial sequence blastn 20600 381 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella convallaria
1454603 1454603 PRJNA1065838_S_NODE_10622_length_241_cov_3.307292_g10520_i0 PRJNA1065838 10622 241 3.307292 7.97057372 Tetrahymena pyriformis 5908 SAR_Eukaryotes SAR_Eukaryotes 418 1.8599999999999995e-112   NTclustered gi|10782|emb|X54004.1| 5908 g10520 i0 97.925 24.0912863070539 241 5 100 0 1 241 2179 1939 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 5806 418 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
1454737 1454737 PRJNA1065838_S_NODE_302_length_873_cov_24.893204_g237_i0 PRJNA1065838 302 873 24.893204 217.31767092 Vorticella sp. 4 JG-2011 1295638 SAR_Eukaryotes SAR_Eukaryotes 1543 0   NTclustered gi|512134943|gb|JX178902.1| 1295638 g237 i0 99.412 82.1237113402062 851 4 97 1 24 873 987 1837 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 71694 1543 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 4 JG-2011
6115729 6115729 PRJNA1065838_S_NODE_3025_length_398_cov_5.071633_g2923_i0 PRJNA1065838 3025 398 5.071633 20.18509934 root 1 Root_unresolved Root_unresolved 713 0   NTclustered gi|345541658|gb|JN547815.1| 5911 g2923 i0 98.995 72.0979899497487 398 4 100 0 1 398 3409 3806 Tetrahymena thermophila strain ATCC 30382 18S ribosomal RNA gene, partial sequence; and internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 26S ribosomal RNA gene, complete sequence blastn 28695 713 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
7832762 7832762 PRJNA1065838_S_NODE_4627_length_336_cov_2.783972_g4525_i0 PRJNA1065838 4627 336 2.783972 9.35414592 Thuricola similis 2784598 SAR_Eukaryotes SAR_Eukaryotes 333 1.01e-86   NTclustered gi|2088246216|ref|NC_057079.1| 2784598 g4525 i0 85.981 45.0327380952381 321 33 94 10 1 315 12694 12380 Thuricola similis strain CUIT mitochondrion, complete genome blastn 15131 333 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vaginicolidae Thuricola Thuricola similis
12491282 12491282 PRJNA1065838_S_NODE_19330_length_204_cov_1.522581_g19228_i0 PRJNA1065838 19330 204 1.522581 3.10606524 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 364 2.0099999999999998e-96   NTclustered gi|1837628855|gb|MN158348.1| 5909 g19228 i0 99.015 76.6225490196078 203 2 99 0 2 204 2897 2695 Tetrahymena rostrata strain TRAUS 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 15631 364 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
15040308 15040308 PRJNA1065838_S_NODE_3392_length_382_cov_2.804805_g3290_i0 PRJNA1065838 3392 382 2.804805 10.7143551 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 608 1.719999999999999e-169   NTclustered gi|10782|emb|X54004.1| 5908 g3290 i0 99.112 76.4083769633508 338 3 88 0 23 360 1923 1586 Tetrahymena pyriformis gene for 26S large subunit ribosomal RNA blastn 29188 608 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena pyriformis
15482927 15482927 PRJNA1065838_S_NODE_4793_length_331_cov_8.943262_g4691_i0 PRJNA1065838 4793 331 8.943262 29.60219722 Vorticella sp. 1 2979179 SAR_Eukaryotes SAR_Eukaryotes 562 1.16e-155   NTclustered gi|2304601489|gb|OP458310.1| 2979179 g4691 i0 99.355 93.583081570997 310 2 94 0 1 310 1231 922 Vorticella sp. 1 large subunit ribosomal RNA gene, partial sequence blastn 30976 562 1 Eukaryota Sar   Ciliophora Oligohymenophorea Sessilida Vorticellidae Vorticella Vorticella sp. 1
18863982 18863982 PRJNA1065838_S_NODE_20515_length_200_cov_3.807947_g20413_i0 PRJNA1065838 20515 200 3.807947 7.615894 root 1 Root_unresolved Root_unresolved 368 1.52e-97   NTclustered gi|10832|emb|X54512.1| 5911 g20413 i0 100 90.43 199 0 99 0 2 200 8316 8118 T. thermophila rdn A+ gene for pre-RNA, 17S rRNA, 5.8S rRNA, 26S rRNA blastn 18086 368 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);;