RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

17 rows where bioproject = "PRJNA681822", 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 · 17 ✖

tax_clade 1

  • Sar · 17 ✖

bioproject 1

  • PRJNA681822 · 17 ✖

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
3208375 3208375 PRJNA681822_S_NODE_2003_length_153_cov_3.040323_g1978_i0 PRJNA681822 2003 153 3.040323 4.65169419 Rosculus sp. 2231160 SAR_Eukaryotes SAR_Eukaryotes 211 1.95e-50   NTclustered gi|1402550476|gb|MH488762.1| 2231160 g1978 i0 91.558 15.718954248366 154 11 100 2 1 153 1764 1916 Rosculus sp. isolate CCAC3 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 2405 211 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp.
3208376 3208376 PRJNA681822_S_NODE_303_length_361_cov_4.572289_g278_i0 PRJNA681822 303 361 4.572289 16.50596329 Rosculus vulgaris 2231165 SAR_Eukaryotes SAR_Eukaryotes 285 3.1e-72   NTclustered gi|1402550474|gb|MH488760.1| 2231165 g278 i0 82.789 23.016620498615 337 41 92 15 29 361 2879 2556 Rosculus vulgaris isolate CCA sequence blastn 8309 285 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus vulgaris
4485504 4485504 PRJNA681822_S_NODE_2084_length_151_cov_2.286885_g2059_i0 PRJNA681822 2084 151 2.286885 3.45319635 Rosculus sp. 2231160 SAR_Eukaryotes SAR_Eukaryotes 279 5.19e-71   NTclustered gi|1402550476|gb|MH488762.1| 2231160 g2059 i0 100 36.8675496688742 151 0 100 0 1 151 1387 1537 Rosculus sp. isolate CCAC3 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 5567 279 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp.
7036087 7036087 PRJNA681822_S_NODE_566_length_273_cov_2.413934_g541_i0 PRJNA681822 566 273 2.413934 6.59003982 Rosculus sp. 2231160 SAR_Eukaryotes SAR_Eukaryotes 215 3.02e-51   NTclustered gi|1402550476|gb|MH488762.1| 2231160 g541 i0 82.692 5.56410256410256 260 27 95 7 1 259 652 894 Rosculus sp. isolate CCAC3 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 1519 215 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp.
10858196 10858196 PRJNA681822_P_NODE_317069_length_270_cov_0.832487_g315580_i0 PRJNA681822 317069 270 0.832487 2.2477149 Rosculus sp. 2231160 SAR_Eukaryotes SAR_Eukaryotes 422 1.64e-113   NTclustered gi|1402550476|gb|MH488762.1| 2231160 g315580 i0 94.834 60.7222222222222 271 12 100 2 1 270 1969 1700 Rosculus sp. isolate CCAC3 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 16395 422 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp.
15960277 15960277 PRJNA681822_S_NODE_1193_length_193_cov_3.560976_g1168_i0 PRJNA681822 1193 193 3.560976 6.87268368 Rosculus sp. 2231160 SAR_Eukaryotes SAR_Eukaryotes 233 5.539999999999999e-57   NTclustered gi|1402550476|gb|MH488762.1| 2231160 g1168 i0 88.718 17.4352331606218 195 17 100 4 1 193 1102 1293 Rosculus sp. isolate CCAC3 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 3365 233 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp.
16473640 16473640 PRJNA681822_P_NODE_437733_length_245_cov_2.622093_g436244_i0 PRJNA681822 437733 245 2.622093 6.42412785 Cercomonas 45109 SAR_Eukaryotes SAR_Eukaryotes 86.1 2.18e-12   NTclustered gi|2651357785|gb|PP174300.1| 1979794 g436244 i0 93.22 20.6408163265306 59 3 24 1 84 142 3814 3757 Cercomonas sp. isolate JGP20 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 5057 86.1 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas sp.
18505256 18505256 PRJNA681822_P_NODE_211515_length_301_cov_2.311404_g210027_i0 PRJNA681822 211515 301 2.311404 6.95732604 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 274 5.49e-69   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g210027 i0 83.828 56.4019933554817 303 34 100 12 1 301 3980 3691 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 16977 274 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
18507776 18507776 PRJNA681822_P_NODE_429435_length_246_cov_1.751445_g427946_i0 PRJNA681822 429435 246 1.751445 4.3085547 Bodomorpha minima 188950 SAR_Eukaryotes SAR_Eukaryotes 449 6.74e-122   NTclustered gi|238617602|gb|FJ973377.1| 188950 g427946 i0 99.595 1.00406504065041 247 0 100 1 1 246 510 756 Bodomorpha minima strain ATCC 50339 28S ribosomal RNA gene, partial sequence blastn 247 449 1 Eukaryota Sar   Cercozoa   Glissomonadida Viridiraptoridae Bodomorpha Bodomorpha minima
21060072 21060072 PRJNA681822_S_NODE_337_length_346_cov_5.384858_g312_i0 PRJNA681822 337 346 5.384858 18.63160868 Rosculus sp. 2231160 SAR_Eukaryotes SAR_Eukaryotes 551 2.649999999999999e-152   NTclustered gi|1402550476|gb|MH488762.1| 2231160 g312 i0 95.389 7.54624277456647 347 14 100 2 1 346 24 369 Rosculus sp. isolate CCAC3 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 2611 551 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp.
21060077 21060077 PRJNA681822_S_NODE_717_length_241_cov_4.448113_g692_i0 PRJNA681822 717 241 4.448113 10.71995233 Rosculus sp. 2231160 SAR_Eukaryotes SAR_Eukaryotes 403 5.199999999999998e-108   NTclustered gi|1402550476|gb|MH488762.1| 2231160 g692 i0 96.721 51.1327800829876 244 5 100 3 1 241 1129 886 Rosculus sp. isolate CCAC3 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence blastn 12323 403 1 Eukaryota Sar   Cercozoa     Guttulinopsidae Rosculus Rosculus sp.
22331363 22331363 PRJNA681822_P_NODE_290198_length_276_cov_3.793103_g288709_i0 PRJNA681822 290198 276 3.793103 10.46896428 Heteromita globosa 45107 SAR_Eukaryotes SAR_Eukaryotes 309 1.36e-79   NTclustered gi|238617605|gb|FJ973380.1| 45107 g288709 i0 86.972 47.2391304347826 284 25 100 7 1 276 1879 1600 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 13038 309 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
25396842 25396842 PRJNA681822_P_NODE_285380_length_278_cov_1.204878_g283891_i0 PRJNA681822 285380 278 1.204878 3.34956084 root 1 Root_unresolved Root_unresolved 89.8 1.95e-13   NTclustered gi|238617605|gb|FJ973380.1| 45107 g283891 i0 94.737 21.7338129496403 57 3 21 0 222 278 2348 2404 Heteromita globosa strain ATCC 50780 28S ribosomal RNA gene, partial sequence blastn 6042 89.8 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita globosa
27082034 27082034 PRJNA681822_P_NODE_494642_length_200_cov_4.929134_g493152_i0 PRJNA681822 494642 200 4.929134 9.858268 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 46.6 9.21e-4   NR MES1906811.1 1215613 g493152 i0 55.9 0.51 34 15 51 0 122 21 314 347 MES1906811.1 hypothetical protein [Cercozoa sp. M6MM] diamond 102 46.6 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29260739 29260739 PRJNA681822_P_NODE_280829_length_279_cov_1.368932_g279340_i0 PRJNA681822 280829 279 1.368932 3.81932028 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 130 2.71e-33   NR MES1909640.1 1215613 g279340 i0 67.7 2.97849462365591 93 29 98.9 1 278 3 272 364 MES1909640.1 hypothetical protein [Cercozoa sp. M6MM] diamond 831 130 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32528461 32528461 PRJNA681822_P_NODE_451319_length_244_cov_0.900585_g449829_i0 PRJNA681822 451319 244 0.900585 2.1974274 Viridiplantae 33090 SAR_Eukaryotes SAR_Eukaryotes 122 8.47e-32   NR MES1911029.1 1215613 g449829 i0 77.5 5.96311475409836 80 18 98.4 0 243 4 90 169 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1455 122 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32863064 32863064 PRJNA681822_P_NODE_255180_length_285_cov_1.452830_g253691_i0 PRJNA681822 255180 285 1.45283 4.1405655 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 84 1.84e-17   NR MES1908571.1 1215613 g253691 i0 61.3 0.842105263157895 80 31 84.2 0 7 246 140 219 MES1908571.1 hypothetical protein [Cercozoa sp. M6MM] diamond 240 84 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);;