RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

  • Sar · 20 ✖

bioproject 1

  • PRJNA415636 · 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
1083271 1083271 PRJNA415636_S_NODE_5781_length_215_cov_0.910714_g5734_i0 PRJNA415636 5781 215 0.910714 1.9580351 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 191 3.85e-44   NTclustered gi|1236613276|gb|KX785362.1| 5894 g5734 i0 100 44.5302325581395 103 0 48 0 1 103 401 503 Tetrahymena canadensis voucher 50099 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence; macronuclear blastn 9574 191 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena canadensis
5522882 5522882 PRJNA415636_S_NODE_25_length_1226_cov_9.717557_g19_i0 PRJNA415636 25 1226 9.717557 119.13724882 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 1282 0   NTclustered gi|756877536|ref|NC_026310.1| 372086 g19 i0 85.692 11.3319738988581 1258 132 100 37 1 1226 105 1346 Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome blastn 13893 1282 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
6796856 6796856 PRJNA415636_S_NODE_1026_length_404_cov_13.459384_g979_i0 PRJNA415636 1026 404 13.459384 54.37591136 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 375 2.0199999999999996e-99   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g979 i0 85.34 54.5 382 34 93 13 1 377 3675 4039 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 22018 375 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
6796863 6796863 PRJNA415636_S_NODE_5906_length_213_cov_1.530120_g5859_i0 PRJNA415636 5906 213 1.53012 3.2591556 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 230 8.069999999999998e-56   NTclustered gi|829195198|ref|XM_001025389.3| 312017 g5859 i0 97.059 5.60093896713615 136 4 64 0 17 152 321 456 Tetrahymena thermophila SB210 40S ribosomal protein S14 partial mRNA blastn 1193 230 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
9347243 9347243 PRJNA415636_S_NODE_1588_length_351_cov_2.088816_g1541_i0 PRJNA415636 1588 351 2.088816 7.33174416 Remanella sp. 1 BS-2022 2930476 SAR_Eukaryotes SAR_Eukaryotes 56.5 0.003   NTclustered gi|2261269021|emb|OX095846.1| 2930476 g1541 i0 100 0.327635327635328 30 0 9 0 1 30 12 41 Remanella sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863273, clone N44:18S_rRNA::TRINITY_DN644_c0_g1_i12:99-1693(+) blastn 115 56.5 1 Eukaryota Sar   Ciliophora Karyorelictea Loxodida Loxodidae Remanella Remanella sp. 1 BS-2022
9347244 9347244 PRJNA415636_S_NODE_1848_length_333_cov_2.632867_g1801_i0 PRJNA415636 1848 333 2.632867 8.76744711 Kentrophoros sp. 1 BS-2022 2930470 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.009   NTclustered gi|2261268989|emb|OX095830.1| 2930470 g1801 i0 100 0.423423423423423 29 0 9 0 1 29 10 38 Kentrophoros sp. 1 BS-2022 partial 18S rRNA gene, isolate SAMEA13863266, clone N10:18S_rRNA::TRINITY_DN246_c0_g1_i2:46-1672(+) blastn 141 54.7 1 Eukaryota Sar   Ciliophora Karyorelictea Protostomatida Kentrophoridae Kentrophoros Kentrophoros sp. 1 BS-2022
9347245 9347245 PRJNA415636_S_NODE_3468_length_263_cov_1.712963_g3421_i0 PRJNA415636 3468 263 1.712963 4.50509269 Chattonella marina 90936 SAR_Eukaryotes SAR_Eukaryotes 87.9 6.58e-13   NTclustered gi|289065155|ref|NC_013837.1| 90936 g3421 i0 88.312 0.536121673003802 77 3 28 4 43 116 11940 12013 Chattonella marina strain KA11-m-1 mitochondrion, complete genome blastn 141 87.9 1 Eukaryota Sar     Raphidophyceae Chattonellales Chattonellaceae Chattonella Chattonella marina
10011370 10011370 PRJNA415636_S_NODE_3448_length_263_cov_7.550926_g3401_i0 PRJNA415636 3448 263 7.550926 19.85893538 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 475 1.2e-129   NTclustered gi|1837628855|gb|MN158348.1| 5909 g3401 i0 99.24 99.2433460076046 263 2 100 0 1 263 2922 2660 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 26101 475 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
11286558 11286558 PRJNA415636_S_NODE_6189_length_209_cov_2.191358_g6142_i0 PRJNA415636 6189 209 2.191358 4.57993822 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 387 4.42e-103   NTclustered gi|1172880852|gb|KY864168.1| 5909 g6142 i0 100 99.9712918660287 209 0 100 0 1 209 153 361 Tetrahymena rostrata isolate TR 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 20894 387 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena rostrata
11897953 11897953 PRJNA415636_S_NODE_3270_length_269_cov_5.022523_g3223_i0 PRJNA415636 3270 269 5.022523 13.51058687 Developayella elegans 42750 SAR_Eukaryotes SAR_Eukaryotes 239 1.7600000000000003e-58   NTclustered gi|223029652|gb|FJ030882.1| 42750 g3223 i0 83.088 101.405204460967 272 36 99 10 2 269 327 62 Developayella elegans strain CCAP1917/1 28S ribosomal RNA gene, partial sequence blastn 27278 239 1 Eukaryota Sar     Developea   Developayellaceae Developayella Developayella elegans
13172879 13172879 PRJNA415636_S_NODE_131_length_794_cov_11.133869_g106_i0 PRJNA415636 131 794 11.133869 88.40291986 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 1018 0   NTclustered gi|756877536|ref|NC_026310.1| 372086 g106 i0 89.668 1.0919395465995 813 65 100 11 1 794 18440 17628 Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome blastn 867 1018 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
13172885 13172885 PRJNA415636_S_NODE_631_length_473_cov_4.497653_g586_i0 PRJNA415636 631 473 4.497653 21.27389869 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 483 1.38e-131   NTclustered gi|756877536|ref|NC_026310.1| 372086 g586 i0 85.714 2.2093023255814 462 61 97 4 1 458 25679 25219 Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome blastn 1045 483 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
15721781 15721781 PRJNA415636_S_NODE_5333_length_222_cov_1.674286_g5286_i0 PRJNA415636 5333 222 1.674286 3.71691492 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 405 1.31e-108   NTclustered gi|88792583|gb|DQ386164.1| 372086 g5286 i0 99.55 92.6126126126126 222 1 100 0 1 222 1609 1830 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 20560 405 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
15721786 15721786 PRJNA415636_S_NODE_813_length_433_cov_3.914508_g766_i0 PRJNA415636 813 433 3.914508 16.94981964 Trachelocercidae sp. 3 BS-2022 2930473 SAR_Eukaryotes SAR_Eukaryotes 54.7 0.012   NTclustered gi|2261268975|emb|OX095823.1| 2930473 g766 i0 100 0.131639722863741 29 0 7 0 1 29 9 37 Trachelocercidae sp. 3 BS-2022 partial 18S rRNA gene, isolate SAMEA13863269, clone N34:18S_rRNA::TRINITY_DN3988_c0_g1_i52:177-1769(-) blastn 57 54.7 1 Eukaryota Sar   Ciliophora Karyorelictea Protostomatida Trachelocercidae   Trachelocercidae sp. 3 BS-2022
19544932 19544932 PRJNA415636_S_NODE_256_length_636_cov_12.604414_g226_i0 PRJNA415636 256 636 12.604414 80.16407304 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 396 2.53e-105   NTclustered gi|756877536|ref|NC_026310.1| 372086 g226 i0 92.446 0.860062893081761 278 20 74 1 359 636 18795 19071 Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome blastn 547 396 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
21485000 21485000 PRJNA415636_S_NODE_2037_length_321_cov_6.153285_g1990_i0 PRJNA415636 2037 321 6.153285 19.75204485 root 1 Root_unresolved Root_unresolved 577 4.02e-160   NTclustered gi|345541658|gb|JN547815.1| 5911 g1990 i0 99.065 73.1183800623053 321 3 100 0 1 321 3487 3807 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 23471 577 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
22095528 22095528 PRJNA415636_S_NODE_2998_length_278_cov_2.064935_g2951_i0 PRJNA415636 2998 278 2.064935 5.7405193 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 93.5 1.51e-14   NTclustered gi|302026200|gb|GQ377710.1| 323453 g2951 i0 79.412 0.784172661870504 136 24 48 4 14 147 152 285 Heteromita sp. PRA-74 40S ribosomal protein-like mRNA, partial sequence blastn 218 93.5 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
22095529 22095529 PRJNA415636_S_NODE_3498_length_262_cov_1.423256_g3451_i0 PRJNA415636 3498 262 1.423256 3.72893072 Sticholonche zanclea 1054997 SAR_Eukaryotes SAR_Eukaryotes 104 6.51e-18   NTclustered gi|1133508221|emb|LT673680.1| 1054997 g3451 i0 91.026 2.69083969465649 78 5 29 2 1 77 733 809 Sticholonche zanclea partial mRNA for Ribosomal Protein L3 (rpl3 gene), isolate AKK-51 2016 blastn 705 104 1 Eukaryota Sar       Sticholonchida Sticholonchidae Sticholonche Sticholonche zanclea
22760246 22760246 PRJNA415636_S_NODE_7598_length_176_cov_5.728682_g7551_i0 PRJNA415636 7598 176 5.728682 10.08248032 Cercomonadidae 45108 SAR_Eukaryotes SAR_Eukaryotes 326 7.92e-85   NTclustered gi|33309627|gb|AF411270.1| 100933 g7551 i0 100 99.9375 176 0 100 0 1 176 1634 1459 Cercomonas longicauda 18S ribosomal RNA gene, complete sequence blastn 17589 326 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas longicauda
23371222 23371222 PRJNA415636_S_NODE_259_length_630_cov_9.656947_g229_i0 PRJNA415636 259 630 9.656947 60.8387661 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 837 0   NTclustered gi|756877536|ref|NC_026310.1| 372086 g229 i0 91.011 2.62539682539683 623 52 99 4 9 630 1988 1369 Paracercomonas marina strain ATCC 50344 mitochondrion, complete genome blastn 1654 837 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina

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