RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJNA1118794" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 24 ✖

tax_clade 1

bioproject 1

  • PRJNA1118794 · 24 ✖

analysis 1

  • diamond · 24 ✖

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
2781157 2781157 PRJNA1118794_P_NODE_3203_length_811_cov_7.047425_g2522_i0 PRJNA1118794 3203 811 7.047425 57.15461675 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 246 1.26e-79   NR ADK26622.1 323453 g2522 i0 88.5 0.480887792848335 130 15 48.1 0 43 432 1 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 390 246 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
5334109 5334109 PRJNA1118794_P_NODE_7285_length_520_cov_4.067114_g6544_i0 PRJNA1118794 7285 520 4.067114 21.1489928 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 245 1.05e-80   NR ADK47156.1 323453 g6544 i0 83.4 0.836538461538462 145 24 83.7 0 27 461 1 145 ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] diamond 435 245 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
12984965 12984965 PRJNA1118794_P_NODE_9151_length_466_cov_2.938931_g8403_i0 PRJNA1118794 9151 466 2.938931 13.69541846 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 233 3.48e-76   NR ADK26622.1 323453 g8403 i0 85.4 0.836909871244635 130 19 83.7 0 423 34 1 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 390 233 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
14259596 14259596 PRJNA1118794_P_NODE_3152_length_818_cov_2.175839_g2475_i0 PRJNA1118794 3152 818 2.175839 17.79836302 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 347 1.26e-116   NR MES1911029.1 1215613 g2475 i0 66.3 6.71149144254279 264 85 95.4 1 37 816 1 264 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 5490 347 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
14260112 14260112 PRJNA1118794_P_NODE_7572_length_510_cov_3.734554_g6830_i0 PRJNA1118794 7572 510 3.734554 19.0462254 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 182 2.4099999999999995e-55   NR AAT09077.1 227086 g6830 i0 71.2 0.735294117647059 125 36 73.5 0 480 106 1 125 AAT09077.1 transcription factor BTF3 [Bigelowiella natans] diamond 375 182 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
15533543 15533543 PRJNA1118794_P_NODE_5713_length_589_cov_3.257752_g4977_i0 PRJNA1118794 5713 589 3.257752 19.18815928 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 190 3.07e-58   NR AAY21202.1 227086 g4977 i0 63.6 5.63327674023769 151 51 76.9 1 455 3 18 164 AAY21202.1 Rpl7A, partial [Bigelowiella natans] diamond 3318 190 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
19356845 19356845 PRJNA1118794_P_NODE_596_length_1802_cov_27.268363_g356_i0 PRJNA1118794 596 1802 27.268363 491.37590126 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 695 9.319999999999995e-247   NR MES1909605.1 1215613 g356 i0 77.1 4.4134295227525 433 99 72.1 0 23 1321 1 433 MES1909605.1 hypothetical protein [Cercozoa sp. M6MM] diamond 7953 701 0.991440798858773 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
21426893 21426893 PRJNA1118794_P_NODE_19457_length_342_cov_1.144981_g18707_i0 PRJNA1118794 19457 342 1.144981 3.91583502 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 156 6.94e-45   NR ADK26624.1 323453 g18707 i0 69 1.98245614035088 113 35 99.1 0 340 2 76 188 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 678 156 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
23182784 23182784 PRJNA1118794_P_NODE_27119_length_304_cov_1.333333_g26369_i0 PRJNA1118794 27119 304 1.333333 4.05333232 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 134 2.5999999999999997e-36   NR MES1911654.1 1215613 g26369 i0 68.3 0.996710526315789 101 30 98.7 2 2 301 142 241 MES1911654.1 hypothetical protein [Cercozoa sp. M6MM] diamond 303 134 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27447504 27447504 PRJNA1118794_P_NODE_22903_length_323_cov_1.224000_g22153_i0 PRJNA1118794 22903 323 1.224 3.95352 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 70.5 1.66e-11   NR MES1906893.1 1215613 g22153 i0 60.3 1.07739938080495 58 23 53.9 0 1 174 425 482 MES1906893.1 hypothetical protein [Cercozoa sp. M6MM] diamond 348 70.5 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28078661 28078661 PRJNA1118794_P_NODE_29025_length_296_cov_1.681614_g28275_i0 PRJNA1118794 29025 296 1.681614 4.97757744 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 121 1.06e-29   NR AAP34647.1 227086 g28275 i0 65.3 0.993243243243243 98 34 99.3 0 2 295 217 314 AAP34647.1 chaperonin-containing TCP-1 theta [Bigelowiella natans] diamond 294 121 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
28164545 28164545 PRJNA1118794_P_NODE_27625_length_302_cov_1.301310_g26875_i0 PRJNA1118794 27625 302 1.30131 3.9299562 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 127 1.19e-34   NR ACF24579.1 67809 g26875 i0 65 6.82450331125828 100 34 99.3 1 300 1 5 103 ACF24579.1 40S ribosomal protein S9 [Gymnochlora stellata] diamond 2061 128 0.9921875 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Gymnochlora Gymnochlora stellata
28204843 28204843 PRJNA1118794_P_NODE_29066_length_296_cov_1.381166_g28316_i0 PRJNA1118794 29066 296 1.381166 4.08825136 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 94.4 8.66e-21   NR MES1912635.1 1215613 g28316 i0 50.6 4.45945945945946 89 43 90.2 1 269 3 53 140 MES1912635.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1320 94.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29688695 29688695 PRJNA1118794_P_NODE_63170_length_245_cov_0.895349_g62420_i0 PRJNA1118794 63170 245 0.895349 2.19360505 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 78.2 1.23e-14   NR MES1910277.1 1215613 g62420 i0 46.8 0.96734693877551 79 42 96.7 0 243 7 250 328 MES1910277.1 hypothetical protein [Cercozoa sp. M6MM] diamond 237 78.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30099476 30099476 PRJNA1118794_P_NODE_23992_length_317_cov_2.831967_g23242_i0 PRJNA1118794 23992 317 2.831967 8.97733539 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 101 3.3e-25   NR MES1914864.1 1215613 g23242 i0 58 0.652996845425868 69 29 65.3 0 207 1 2 70 MES1914864.1 hypothetical protein [Cercozoa sp. M6MM] diamond 207 101 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30510352 30510352 PRJNA1118794_P_NODE_25653_length_310_cov_3.071730_g24903_i0 PRJNA1118794 25653 310 3.07173 9.522363 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 171 1.58e-49   NR MES1910618.1 1215613 g24903 i0 76.7 49.8193548387097 103 24 99.7 0 2 310 145 247 MES1910618.1 hypothetical protein [Cercozoa sp. M6MM] diamond 15444 171 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30857899 30857899 PRJNA1118794_P_NODE_62034_length_246_cov_0.890173_g61284_i0 PRJNA1118794 62034 246 0.890173 2.18982558 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 62.4 3.2e-9   NR MES1908527.1 1215613 g61284 i0 40.5 0.963414634146341 79 46 96.3 1 238 2 206 283 MES1908527.1 hypothetical protein [Cercozoa sp. M6MM] diamond 237 62.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31205031 31205031 PRJNA1118794_P_NODE_13695_length_390_cov_1.454259_g12945_i0 PRJNA1118794 13695 390 1.454259 5.6716101 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 165 7.09e-50   NR MES1914773.1 1215613 g12945 i0 70.4 0.961538461538462 125 30 93.8 2 376 11 1 121 MES1914773.1 hypothetical protein [Cercozoa sp. M6MM] diamond 375 165 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31711601 31711601 PRJNA1118794_P_NODE_71797_length_242_cov_0.911243_g71047_i0 PRJNA1118794 71797 242 0.911243 2.20520806 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 74.3 9.12e-15   NR MES1913235.1 1215613 g71047 i0 52.2 0.855371900826446 69 33 85.5 0 33 239 12 80 MES1913235.1 hypothetical protein [Cercozoa sp. M6MM] diamond 207 74.3 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31806462 31806462 PRJNA1118794_P_NODE_35817_length_278_cov_1.253659_g35067_i0 PRJNA1118794 35817 278 1.253659 3.48517202 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 72.4 1.8e-12   NR MES1907468.1 1215613 g35067 i0 37.9 0.938848920863309 87 50 93.9 2 268 8 225 307 MES1907468.1 hypothetical protein [Cercozoa sp. M6MM] diamond 261 72.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32249758 32249758 PRJNA1118794_P_NODE_23998_length_317_cov_2.565574_g23248_i0 PRJNA1118794 23998 317 2.565574 8.13286958 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 50.1 1.33e-5   NR MES1916146.1 1215613 g23248 i0 43.1 0.615141955835962 65 35 61.5 2 200 6 1 63 MES1916146.1 hypothetical protein [Cercozoa sp. M6MM] diamond 195 50.1 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32249769 32249769 PRJNA1118794_P_NODE_38758_length_271_cov_1.722222_g38008_i0 PRJNA1118794 38758 271 1.722222 4.66722162 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 133 8.819999999999998e-35   NR MES1915893.1 1215613 g38008 i0 60.7 1.99261992619926 89 35 98.5 0 269 3 311 399 MES1915893.1 hypothetical protein [Cercozoa sp. M6MM] diamond 540 133 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32566106 32566106 PRJNA1118794_P_NODE_52439_length_250_cov_0.870056_g51689_i0 PRJNA1118794 52439 250 0.870056 2.17514 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 79 2.2e-15   NR MES1912576.1 1215613 g51689 i0 66.1 0.672 56 19 67.2 0 250 83 218 273 MES1912576.1 hypothetical protein [Cercozoa sp. M6MM] diamond 168 79 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32754724 32754724 PRJNA1118794_P_NODE_17100_length_358_cov_1.364912_g16350_i0 PRJNA1118794 17100 358 1.364912 4.88638496 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 108 9.57e-28   NR AAT09085.1 227086 g16350 i0 64.6 1.97765363128492 79 28 66.2 0 2 238 32 110 AAT09085.1 ubiquitin conjugating enzyme [Bigelowiella natans] diamond 708 108 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans

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