RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJNA864829", tax_clade = "Sar" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 22 ✖

tax_clade 1

  • Sar · 22 ✖

bioproject 1

  • PRJNA864829 · 22 ✖

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
847307 847307 PRJNA864829_S_NODE_9961_length_199_cov_46.233333_g9875_i0 PRJNA864829 9961 199 46.233333 92.00433267 Placocista sp. CC-Grouse Mountain 741089 SAR_Eukaryotes SAR_Eukaryotes 230 7.43e-56   NTclustered gi|290760485|gb|GQ144688.1| 741089 g9875 i0 92.994 79.8793969849246 157 11 99 0 1 157 1623 1467 Placocista sp. CC-Grouse Mountain large subunit ribosomal RNA gene, partial sequence blastn 15896 230 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Euglyphidae Placocista Placocista sp. CC-Grouse Mountain
4675712 4675712 PRJNA864829_S_NODE_16464_length_158_cov_12.633028_g16378_i0 PRJNA864829 16464 158 12.633028 19.96018424 Euglypha rotunda 39714 SAR_Eukaryotes SAR_Eukaryotes 281 1.53e-71   NTclustered gi|18075905|emb|AJ418782.1| 39714 g16378 i0 98.734 99.2405063291139 158 2 100 0 1 158 1449 1292 Euglypha rotunda 18S rRNA gene, strain Costa Rica blastn 15680 281 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Euglyphidae Euglypha Euglypha rotunda
4675760 4675760 PRJNA864829_S_NODE_944_length_493_cov_3.860360_g858_i0 PRJNA864829 944 493 3.86036 19.0315748 Chlorarachniophyceae sp. P329 467061 SAR_Eukaryotes SAR_Eukaryotes 152 4.61e-32   NTclustered gi|220983374|dbj|AB453010.1| 467061 g858 i0 89.256 25.4117647058824 121 13 25 0 78 198 1869 1749 Chlorarachniophyceae sp. P329 gene for nuclear large subunit ribosomal RNA, partial sequence blastn 12528 152 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae       Chlorarachniophyceae sp. P329
5950583 5950583 PRJNA864829_S_NODE_3325_length_305_cov_3.035156_g3239_i0 PRJNA864829 3325 305 3.035156 9.2572258 Nudifila producta 985833 SAR_Eukaryotes SAR_Eukaryotes 185 2.6899999999999998e-42   NTclustered gi|323652737|gb|HQ121434.1| 985833 g3239 i0 93.6 41.3901639344262 125 7 41 1 1 125 1580 1457 Nudifila producta strain CCAP 1911/1 18S small subunit ribosomal RNA gene, partial sequence blastn 12624 185 1 Eukaryota Sar   Cercozoa Imbricatea     Nudifila Nudifila producta
6340819 6340819 PRJNA864829_S_NODE_705_length_547_cov_15.572289_g622_i0 PRJNA864829 705 547 15.572289 85.18042083 Tremula 1938488 SAR_Eukaryotes SAR_Eukaryotes 361 7.869999999999999e-95   NTclustered gi|194272492|gb|EU567285.1| 175275 g622 i0 87.117 60.7184643510055 326 33 65 8 44 366 988 669 Uncultured cercozoan isolate db5 18S ribosomal RNA gene, partial sequence blastn 33213 364 0.991758241758242 Eukaryota Sar   Cercozoa         uncultured Cercozoa
7225454 7225454 PRJNA864829_S_NODE_1186_length_448_cov_38.080201_g1100_i0 PRJNA864829 1186 448 38.080201 170.59930048 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 291 8.44e-74   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g1100 i0 82.32 34.1808035714286 362 39 80 19 12 368 4039 3698 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 15313 291 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
7225503 7225503 PRJNA864829_S_NODE_926_length_496_cov_10.782998_g840_i0 PRJNA864829 926 496 10.782998 53.48367008 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 165 5.96e-36   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g840 i0 89.844 24.0584677419355 128 13 26 0 298 425 3829 3702 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 11933 165 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
8500185 8500185 PRJNA864829_S_NODE_15307_length_167_cov_0.872881_g15221_i0 PRJNA864829 15307 167 0.872881 1.45771127 Placocista sp. CC-Grouse Mountain 741089 SAR_Eukaryotes SAR_Eukaryotes 215 1.69e-51   NTclustered gi|290760485|gb|GQ144688.1| 741089 g15221 i0 90.303 49.2275449101796 165 15 98 1 4 167 2239 2075 Placocista sp. CC-Grouse Mountain large subunit ribosomal RNA gene, partial sequence blastn 8221 215 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Euglyphidae Placocista Placocista sp. CC-Grouse Mountain
8889856 8889856 PRJNA864829_S_NODE_987_length_482_cov_80.214781_g901_i0 PRJNA864829 987 482 80.214781 386.63524442 Euglypha 39713 SAR_Eukaryotes SAR_Eukaryotes 822 0   NTclustered gi|18075905|emb|AJ418782.1| 39714 g901 i0 99.125 94.9979253112033 457 4 95 0 26 482 600 1056 Euglypha rotunda 18S rRNA gene, strain Costa Rica blastn 45789 828 0.992753623188406 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Euglyphidae Euglypha Euglypha rotunda
9775321 9775321 PRJNA864829_S_NODE_5988_length_246_cov_9.847716_g5902_i0 PRJNA864829 5988 246 9.847716 24.22538136 Euglypha rotunda 39714 SAR_Eukaryotes SAR_Eukaryotes 375 1.16e-99   NTclustered gi|541673|emb|X77692.1| 39714 g5902 i0 100 83.280487804878 203 0 83 0 27 229 1442 1644 E.rotunda (strain CCAP 1520/1) cytoplasmic small subunit 16S-like rRNA gene blastn 20487 375 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Euglyphidae Euglypha Euglypha rotunda
11051010 11051010 PRJNA864829_S_NODE_2029_length_364_cov_12.530159_g1943_i0 PRJNA864829 2029 364 12.530159 45.60977876 uncultured Euglyphidae sp. 1764557 SAR_Eukaryotes SAR_Eukaryotes 239 2.47e-58   NTclustered gi|959360329|gb|KT272502.1| 1764557 g1943 i0 93.789 44.3626373626374 161 6 44 3 189 349 92 248 Uncultured Euglyphidae sp. clone SL1_25 18S ribosomal RNA gene, partial sequence blastn 16148 239 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Euglyphidae   uncultured Euglyphidae sp.
11051037 11051037 PRJNA864829_S_NODE_6689_length_236_cov_3.085561_g6603_i0 PRJNA864829 6689 236 3.085561 7.28192396 Mesofila limnetica 1979842 SAR_Eukaryotes SAR_Eukaryotes 124 4.42e-24   NTclustered gi|88792585|gb|DQ386166.1| 1979842 g6603 i0 87.85 6.33050847457627 107 11 45 2 1 106 2474 2579 Dimorpha-like sp. ATCC 50522 28S ribosomal RNA gene, partial sequence blastn 1494 124 1 Eukaryota Sar   Cercozoa     Mesofilidae Mesofila Mesofila limnetica
12326447 12326447 PRJNA864829_S_NODE_730_length_539_cov_64.563265_g647_i0 PRJNA864829 730 539 64.563265 347.99599835 Placocista sp. CC-Grouse Mountain 741089 SAR_Eukaryotes SAR_Eukaryotes 804 0   NTclustered gi|290760485|gb|GQ144688.1| 741089 g647 i0 94.961 94.6883116883117 516 20 95 6 27 539 1632 2144 Placocista sp. CC-Grouse Mountain large subunit ribosomal RNA gene, partial sequence blastn 51037 804 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Euglyphidae Placocista Placocista sp. CC-Grouse Mountain
12716463 12716463 PRJNA864829_S_NODE_9070_length_207_cov_46.772152_g8984_i0 PRJNA864829 9070 207 46.772152 96.81835464 Euglypha 39713 SAR_Eukaryotes SAR_Eukaryotes 346 7.420000000000001e-91   NTclustered gi|83034979|gb|DQ211608.1| 39714 g8984 i0 100 91.2028985507246 187 0 90 0 1 187 498 312 Euglypha rotunda strain Costa Rica 28S ribosomal RNA gene, partial sequence blastn 18879 346 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Euglyphidae Euglypha Euglypha rotunda
13600957 13600957 PRJNA864829_S_NODE_2151_length_356_cov_31.381107_g2065_i0 PRJNA864829 2151 356 31.381107 111.71674092 Euglypha rotunda 39714 SAR_Eukaryotes SAR_Eukaryotes 579 1.2499999999999997e-160   NTclustered gi|18075905|emb|AJ418782.1| 39714 g2065 i0 99.684 84.5112359550562 316 1 89 0 16 331 395 80 Euglypha rotunda 18S rRNA gene, strain Costa Rica blastn 30086 579 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Euglyphidae Euglypha Euglypha rotunda
13600963 13600963 PRJNA864829_S_NODE_2891_length_320_cov_13.239852_g2805_i0 PRJNA864829 2891 320 13.239852 42.3675264 Mesofila limnetica 1979842 SAR_Eukaryotes SAR_Eukaryotes 364 3.389999999999999e-96   NTclustered gi|88792585|gb|DQ386166.1| 1979842 g2805 i0 87.539 94.290625 321 32 100 5 1 320 1268 955 Dimorpha-like sp. ATCC 50522 28S ribosomal RNA gene, partial sequence blastn 30173 364 1 Eukaryota Sar   Cercozoa     Mesofilidae Mesofila Mesofila limnetica
14875305 14875305 PRJNA864829_S_NODE_5612_length_252_cov_6.630542_g5526_i0 PRJNA864829 5612 252 6.630542 16.70896584 Phytocercomonas venanatans 2065209 SAR_Eukaryotes SAR_Eukaryotes 147 1.02e-30   NTclustered gi|1315527750|gb|MF034900.1| 2065209 g5526 i0 90.265 117.611111111111 113 9 63 2 1 113 8759 8869 Phytocercomonas venanatans 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 29638 147 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Phytocercomonas Phytocercomonas venanatans
16149971 16149971 PRJNA864829_S_NODE_3573_length_297_cov_120.552419_g3487_i0 PRJNA864829 3573 297 120.552419 358.04068443 Placocista sp. CC-Grouse Mountain 741089 SAR_Eukaryotes SAR_Eukaryotes 342 1.4599999999999996e-89   NTclustered gi|290760485|gb|GQ144688.1| 741089 g3487 i0 87.625 41.4814814814815 299 31 100 5 1 297 2083 2377 Placocista sp. CC-Grouse Mountain large subunit ribosomal RNA gene, partial sequence blastn 12320 342 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Euglyphidae Placocista Placocista sp. CC-Grouse Mountain
17425435 17425435 PRJNA864829_S_NODE_10454_length_195_cov_74.554795_g10368_i0 PRJNA864829 10454 195 74.554795 145.38185025 Placocista sp. CC-Grouse Mountain 741089 SAR_Eukaryotes SAR_Eukaryotes 316 5.41e-82   NTclustered gi|290760485|gb|GQ144688.1| 741089 g10368 i0 96.373 143.85641025641 193 6 98 1 1 192 1442 1250 Placocista sp. CC-Grouse Mountain large subunit ribosomal RNA gene, partial sequence blastn 28052 316 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Euglyphidae Placocista Placocista sp. CC-Grouse Mountain
19973884 19973884 PRJNA864829_S_NODE_2356_length_344_cov_6.820339_g2270_i0 PRJNA864829 2356 344 6.820339 23.46196616 uncultured Cercozoa 175275 SAR_Eukaryotes SAR_Eukaryotes 322 2.25e-83   NTclustered gi|194272418|gb|EU567211.1| 175275 g2270 i0 87.77 79.9127906976744 278 31 80 3 69 344 676 952 Uncultured cercozoan isolate op32 18S ribosomal RNA gene, partial sequence blastn 27490 322 1 Eukaryota Sar   Cercozoa         uncultured Cercozoa
22914550 22914550 PRJNA864829_S_NODE_10698_length_193_cov_53.833333_g10612_i0 PRJNA864829 10698 193 53.833333 103.89833269 Euglypha 39713 SAR_Eukaryotes SAR_Eukaryotes 265 1.96e-66   NTclustered gi|18075905|emb|AJ418782.1| 39714 g10612 i0 100 74.1658031088083 143 0 74 0 26 168 566 424 Euglypha rotunda 18S rRNA gene, strain Costa Rica blastn 14314 265 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Euglyphidae Euglypha Euglypha rotunda
29202636 29202636 PRJNA864829_S_NODE_6769_length_235_cov_2.155914_g6683_i0 PRJNA864829 6769 235 2.155914 5.0663979 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 80.5 1.12e-16   NR MES1914713.1 1215613 g6683 i0 64.2 0.676595744680851 53 19 67.7 0 1 159 96 148 MES1914713.1 hypothetical protein [Cercozoa sp. M6MM] diamond 159 80.5 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM

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