RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJNA1073183", 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

  • PRJNA1073183 · 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
1462012 1462012 PRJNA1073183_P_NODE_6842_length_486_cov_1.677966_g6748_i0 PRJNA1073183 6842 486 1.677966 8.15491476 Mesofila sp. ATCC PRA-54 439948 SAR_Eukaryotes SAR_Eukaryotes 425 2.42e-114   NTclustered gi|160337355|gb|EF455774.1| 439948 g6748 i0 84.127 98.9423868312757 441 68 91 2 11 450 440 1 Dimorpha sp. ATCC PRA-54 beta-tubulin (btub) gene, partial cds blastn 48086 425 1 Eukaryota Sar   Cercozoa     Mesofilidae Mesofila Mesofila sp. ATCC PRA-54
4844121 4844121 PRJNA1073183_P_NODE_21904_length_280_cov_1.265700_g21809_i0 PRJNA1073183 21904 280 1.2657 3.5439600000000002 Viridiplantae 33090 SAR_Eukaryotes SAR_Eukaryotes 222 1.86e-53   NTclustered gi|31982985|gb|AY236717.1| 188940 g21809 i0 83.133 78.3964285714286 249 36 89 3 2 250 1223 1465 Thaumatomonas sp. (SA) heat shock protein 90 (Hsp90) gene, partial cds blastn 21951 224 0.991071428571429 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas sp. (SA)
5289887 5289887 PRJNA1073183_P_NODE_15845_length_328_cov_1.207843_g15750_i0 PRJNA1073183 15845 328 1.207843 3.96172504 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 156 2.29e-33   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g15750 i0 87.5 27.7256097560976 136 15 41 2 1 136 3719 3852 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 9094 156 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
15489842 15489842 PRJNA1073183_P_NODE_2373_length_801_cov_1.476648_g2296_i0 PRJNA1073183 2373 801 1.476648 11.82795048 Cercozoa sp. DMV 1342330 SAR_Eukaryotes SAR_Eukaryotes 412 2.6099999999999997e-140   NR BAN37425.1 1342330 g2296 i0 71.8 5.97752808988764 266 75 99.6 0 3 800 141 406 BAN37425.1 elongation factor 1-alpha [Cercozoa sp. DMV] diamond 4788 412 1 Eukaryota Sar   Cercozoa         Cercozoa sp. DMV
15489880 15489880 PRJNA1073183_P_NODE_2593_length_771_cov_1.954155_g2513_i0 PRJNA1073183 2593 771 1.954155 15.06653505 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 286 2e-95   NR ADK47156.1 323453 g2513 i0 96.6 0.56420233463035 145 5 56.4 0 726 292 1 145 ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] diamond 435 286 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
16764364 16764364 PRJNA1073183_P_NODE_4494_length_596_cov_2.279159_g4402_i0 PRJNA1073183 4494 596 2.279159 13.58378764 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 256 1.36e-84   NR ADK26622.1 323453 g4402 i0 94.6 0.654362416107383 130 7 65.4 0 30 419 1 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 390 256 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
19312699 19312699 PRJNA1073183_P_NODE_11636_length_378_cov_1.498361_g11541_i0 PRJNA1073183 11636 378 1.498361 5.66380458 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 194 2.08e-61   NR ADK47156.1 323453 g11541 i0 80.5 1.87301587301587 118 23 93.7 0 355 2 1 118 ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] diamond 708 194 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
21864040 21864040 PRJNA1073183_P_NODE_2298_length_815_cov_1.877358_g2221_i0 PRJNA1073183 2298 815 1.877358 15.3004677 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 297 4.59e-97   NR MES1911029.1 1215613 g2221 i0 59.5 1.00858895705521 274 96 99 5 814 8 42 305 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 822 297 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
24412958 24412958 PRJNA1073183_P_NODE_13460_length_353_cov_2.678571_g13365_i0 PRJNA1073183 13460 353 2.678571 9.45535563 Esquamula lacrimiformis 1176540 SAR_Eukaryotes SAR_Eukaryotes 387 8.06e-103   NTclustered gi|409971369|dbj|AB714271.1| 1176540 g13365 i0 86.761 61.5580736543909 355 37 99 10 4 353 4008 3659 Esquamula lacrimiformis gene for 28S ribosomal RNA, partial sequence blastn 21730 387 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida   Esquamula Esquamula lacrimiformis
26846161 26846161 PRJNA1073183_P_NODE_20401_length_289_cov_1.421296_g20306_i0 PRJNA1073183 20401 289 1.421296 4.10754544 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 115 5.18e-29   NR MES1907458.1 1215613 g20306 i0 72 2.60553633217993 75 21 77.9 0 226 2 4 78 MES1907458.1 hypothetical protein [Cercozoa sp. M6MM] diamond 753 115 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29624755 29624755 PRJNA1073183_P_NODE_9850_length_408_cov_2.752239_g9756_i0 PRJNA1073183 9850 408 2.752239 11.22913512 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 134 3.38e-37   NR AAY21202.1 227086 g9756 i0 68 2.875 97 31 71.3 0 312 22 17 113 AAY21202.1 Rpl7A, partial [Bigelowiella natans] diamond 1173 134 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
30825637 30825637 PRJNA1073183_P_NODE_34094_length_241_cov_0.916667_g33999_i0 PRJNA1073183 34094 241 0.916667 2.20916747 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 107 2.21e-25   NR MES1910618.1 1215613 g33999 i0 66.7 2.9253112033195 78 26 97.1 0 239 6 105 182 MES1910618.1 hypothetical protein [Cercozoa sp. M6MM] diamond 705 107 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30983842 30983842 PRJNA1073183_P_NODE_30754_length_246_cov_0.890173_g30659_i0 PRJNA1073183 30754 246 0.890173 2.18982558 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 62.4 7.41e-10   NR MES1908819.1 1215613 g30659 i0 43.6 1.81707317073171 78 42 93.9 2 246 16 81 157 MES1908819.1 hypothetical protein [Cercozoa sp. M6MM] diamond 447 62.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31204372 31204372 PRJNA1073183_P_NODE_20215_length_290_cov_2.129032_g20120_i0 PRJNA1073183 20215 290 2.129032 6.1741928 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 133 7.49e-36   NR MES1911029.1 1215613 g20120 i0 69.1 5.03793103448276 97 29 99.3 1 2 289 59 155 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1461 133 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);;