RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 14 ✖

bioproject 1

  • PRJNA285816 · 14 ✖

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
2334361 2334361 PRJNA285816_S_NODE_15802_length_196_cov_1.632653_g15700_i0 PRJNA285816 15802 196 1.632653 3.19999988 Cercomonadidae 45108 SAR_Eukaryotes SAR_Eukaryotes 351 1.49e-92   NTclustered gi|88792583|gb|DQ386164.1| 372086 g15700 i0 98.985 101.224489795918 197 1 100 1 1 196 1004 1200 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 19840 351 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
2334428 2334428 PRJNA285816_S_NODE_8962_length_240_cov_107.513089_g8860_i0 PRJNA285816 8962 240 107.513089 258.0314136 Paulinella 39716 SAR_Eukaryotes SAR_Eukaryotes 327 3.199999999999999e-85   NTclustered gi|238617606|gb|FJ973381.1| 39717 g8860 i0 93.636 92.2458333333333 220 13 91 1 21 239 2674 2893 Paulinella chromatophora strain FK01 28S ribosomal RNA gene, partial sequence blastn 22139 327 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Paulinellidae Paulinella Paulinella chromatophora
6749855 6749855 PRJNA285816_S_NODE_7166_length_263_cov_3.995327_g7064_i0 PRJNA285816 7166 263 3.995327 10.50771001 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 475 1.2e-129   NTclustered gi|88792583|gb|DQ386164.1| 372086 g7064 i0 99.24 98.2433460076046 263 2 100 0 1 263 1716 1978 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 25838 475 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
7437062 7437062 PRJNA285816_S_NODE_22266_length_173_cov_3.064516_g22164_i0 PRJNA285816 22266 173 3.064516 5.30161268 Cercomonadidae 45108 SAR_Eukaryotes SAR_Eukaryotes 320 3.61e-83   NTclustered gi|88792583|gb|DQ386164.1| 372086 g22164 i0 100 100.21387283237 173 0 100 0 1 173 737 909 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 17337 320 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
8025150 8025150 PRJNA285816_S_NODE_11667_length_218_cov_1.508876_g11565_i0 PRJNA285816 11667 218 1.508876 3.28934968 root 1 Root_unresolved Root_unresolved 111 1.2e-26   NR MES1916046.1 1215613 g11565 i0 73.5 6.71559633027523 68 18 93.6 0 208 5 328 395 MES1916046.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1464 111 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
9299981 9299981 PRJNA285816_S_NODE_14428_length_202_cov_3.679739_g14326_i0 PRJNA285816 14428 202 3.679739 7.43307278 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 351 1.55e-92   NTclustered gi|88792583|gb|DQ386164.1| 372086 g14326 i0 98.02 167.707920792079 202 4 100 0 1 202 2707 2506 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 33877 351 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
10576061 10576061 PRJNA285816_S_NODE_3829_length_345_cov_7.993243_g3727_i0 PRJNA285816 3829 345 7.993243 27.57668835 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 335 2.889999999999999e-87   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g3727 i0 85.337 47.9739130434783 341 30 98 11 9 345 4018 3694 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 16551 335 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
16361601 16361601 PRJNA285816_S_NODE_14633_length_201_cov_11.250000_g14531_i0 PRJNA285816 14633 201 11.25 22.6125 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 80.5 8.02e-11   NTclustered gi|238617606|gb|FJ973381.1| 39717 g14531 i0 91.379 24.4228855721393 58 5 29 0 1 58 1250 1307 Paulinella chromatophora strain FK01 28S ribosomal RNA gene, partial sequence blastn 4909 80.5 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Paulinellidae Paulinella Paulinella chromatophora
17636758 17636758 PRJNA285816_S_NODE_15734_length_196_cov_5.789116_g15632_i0 PRJNA285816 15734 196 5.789116 11.34666736 Cercomonadidae 45108 SAR_Eukaryotes SAR_Eukaryotes 363 6.899999999999998e-96   NTclustered gi|33309627|gb|AF411270.1| 100933 g15632 i0 100 100.020408163265 196 0 100 0 1 196 1640 1445 Cercomonas longicauda 18S ribosomal RNA gene, complete sequence blastn 19604 363 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas longicauda
18223776 18223776 PRJNA285816_S_NODE_4195_length_332_cov_4.060071_g4093_i0 PRJNA285816 4195 332 4.060071 13.47943572 Cercomonas sp. HFCC549 458874 SAR_Eukaryotes SAR_Eukaryotes 592 1.49e-164   NTclustered gi|161015714|gb|EF681948.1| 458874 g4093 i0 99.088 45.7198795180723 329 3 99 0 1 329 212 540 Cercomonas sp. HFCC549 28S ribosomal RNA gene, partial sequence blastn 15179 592 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas sp. HFCC549
19497898 19497898 PRJNA285816_S_NODE_20056_length_180_cov_1.786260_g19954_i0 PRJNA285816 20056 180 1.78626 3.215268 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 318 1.36e-82   NTclustered gi|88792583|gb|DQ386164.1| 372086 g19954 i0 98.361 102.716666666667 183 0 100 1 1 180 1357 1539 Paracercomonas marina 28S ribosomal RNA gene, partial sequence blastn 18489 318 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Paracercomonas Paracercomonas marina
24011080 24011080 PRJNA285816_S_NODE_30419_length_154_cov_2.904762_g30317_i0 PRJNA285816 30419 154 2.904762 4.47333348 Cercomonadidae 45108 SAR_Eukaryotes SAR_Eukaryotes 279 5.33e-71   NTclustered gi|46393903|gb|AY496047.1| 100933 g30317 i0 99.351 98.3571428571429 154 1 100 0 1 154 1390 1237 Cercomonas longicauda strain SCCAP C1 small subunit ribosomal RNA gene, partial sequence blastn 15147 279 1 Eukaryota Sar   Cercozoa   Cercomonadida Cercomonadidae Cercomonas Cercomonas longicauda
26884472 26884472 PRJNA285816_S_NODE_3821_length_346_cov_2.212121_g3719_i0 PRJNA285816 3821 346 2.212121 7.65393866 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 110 9.71e-28   NR MES1907612.1 1215613 g3719 i0 46.5 0.875722543352601 101 54 87.6 0 340 38 19 119 MES1907612.1 hypothetical protein [Cercozoa sp. M6MM] diamond 303 110 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29649221 29649221 PRJNA285816_S_NODE_17090_length_191_cov_1.000000_g16988_i0 PRJNA285816 17090 191 1 1.91 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 64.7 1.35e-10   NR MES1914924.1 1215613 g16988 i0 60 8.2303664921466 55 22 86.4 0 183 19 134 188 MES1914924.1 40S ribosomal protein S6 [Cercozoa sp. M6MM] diamond 1572 65.1 0.993855606758833 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);;