RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", bioproject = "PRJNA1065838" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

  • Sar · 20 ✖

bioproject 1

  • PRJNA1065838 · 20 ✖

analysis 1

  • blastn · 20 ✖

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
2730701 2730701 PRJNA1065838_S_NODE_783_length_633_cov_1677.873288_g690_i0 PRJNA1065838 783 633 1677.873288 10620.93791304 uncultured Sandonidae 1938448 SAR_Eukaryotes SAR_Eukaryotes 121 1.7000000000000002e-22   NTclustered gi|1915674532|emb|LR868151.1| 1938448 g690 i0 97.183 108.862559241706 71 2 11 0 556 626 220 290 uncultured Sandonidae partial 18S rRNA gene blastn 68910 121 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae   uncultured Sandonidae
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
7390276 7390276 PRJNA1065838_S_NODE_29166_length_175_cov_1.515873_g29064_i0 PRJNA1065838 29166 175 1.515873 2.65277775 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 324 2.83e-84   NTclustered gi|323690576|gb|GU935635.1| 88167 g29064 i0 100 99.4171428571429 175 0 100 0 1 175 549 723 Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence blastn 17398 324 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
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
9107584 9107584 PRJNA1065838_S_NODE_14908_length_218_cov_1.355030_g14806_i0 PRJNA1065838 14908 218 1.35503 2.9539654 Poterioochromonas malhamensis 88167 SAR_Eukaryotes SAR_Eukaryotes 403 4.62e-108   NTclustered gi|323690576|gb|GU935635.1| 88167 g14806 i0 100 41.0412844036697 218 0 100 0 1 218 1797 2014 Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence blastn 8947 403 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
9940638 9940638 PRJNA1065838_S_NODE_2588_length_421_cov_12.814516_g2486_i0 PRJNA1065838 2588 421 12.814516 53.94911236 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 80.5 1.86e-10   NTclustered gi|1915673095|emb|LR866708.1| 1938448 g2486 i0 95.918 108.55106888361 49 2 12 0 373 421 219 267 uncultured Sandonidae partial 18S rRNA gene blastn 45700 80.5 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae   uncultured Sandonidae
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
12491735 12491735 PRJNA1065838_S_NODE_9350_length_253_cov_97.446078_g9248_i0 PRJNA1065838 9350 253 97.446078 246.53857734 root 1 Root_unresolved Root_unresolved 102 2.25e-17   NTclustered gi|1915673792|emb|LR867411.1| 1821250 g9248 i0 92.958 313.221343873518 71 3 41 2 5 74 290 221 uncultured Glissomonadida partial 18S rRNA gene blastn 79245 102 1 Eukaryota Sar   Cercozoa   Glissomonadida     uncultured Glissomonadida
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
18031748 18031748 PRJNA1065838_S_NODE_25055_length_188_cov_1.122302_g24953_i0 PRJNA1065838 25055 188 1.122302 2.10992776 Cryptosporidium muris 5808 SAR_Eukaryotes SAR_Eukaryotes 298 1.87e-76   NTclustered gi|209883104|ref|XM_002142938.1| 441375 g24953 i0 95.213 1 188 9 100 0 1 188 570 383 Cryptosporidium muris RN66 uncharacterized protein (CMU_004200), partial mRNA blastn 188 298 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium muris
18031868 18031868 PRJNA1065838_S_NODE_6155_length_299_cov_3935.128000_g6053_i0 PRJNA1065838 6155 299 3935.128 11766.03272 uncultured Sandonidae 1938448 SAR_Eukaryotes SAR_Eukaryotes 119 2.7e-22   NTclustered gi|1915674532|emb|LR868151.1| 1938448 g6053 i0 97.143 331.163879598662 70 2 37 0 223 292 221 290 uncultured Sandonidae partial 18S rRNA gene blastn 99018 119 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae   uncultured Sandonidae
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
20581206 20581206 PRJNA1065838_S_NODE_3497_length_377_cov_2986.810976_g3395_i0 PRJNA1065838 3497 377 2986.810976 11260.27737952 uncultured Sandonidae 1938448 SAR_Eukaryotes SAR_Eukaryotes 121 9.7e-23   NTclustered gi|1915674532|emb|LR868151.1| 1938448 g3395 i0 97.183 182.779840848806 71 2 19 0 300 370 220 290 uncultured Sandonidae partial 18S rRNA gene blastn 68908 121 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae   uncultured Sandonidae
21414399 21414399 PRJNA1065838_S_NODE_1617_length_498_cov_91.975501_g1515_i0 PRJNA1065838 1617 498 91.975501 458.03799498 Poterioochromonas 88166 SAR_Eukaryotes SAR_Eukaryotes 787 0   NTclustered gi|323690576|gb|GU935635.1| 88167 g1515 i0 100 85.921686746988 426 0 86 0 73 498 1785 1360 Poteriochroomonas malhamensis strain SAG 933.1c 28S ribosomal RNA gene, partial sequence blastn 42789 787 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae Poterioochromonas Poterioochromonas malhamensis
22689665 22689665 PRJNA1065838_S_NODE_9458_length_252_cov_35.192118_g9356_i0 PRJNA1065838 9458 252 35.192118 88.68413736 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 78.7 3.77e-10   NTclustered gi|1915673095|emb|LR866708.1| 1938448 g9356 i0 95.833 185.325396825397 48 2 19 0 205 252 221 268 uncultured Sandonidae partial 18S rRNA gene blastn 46702 78.7 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae   uncultured Sandonidae

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