RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJNA560932" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 30 ✖

tax_clade 1

bioproject 1

  • PRJNA560932 · 30 ✖

analysis 1

  • diamond · 30 ✖

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
3095736 3095736 PRJNA560932_P_NODE_51543_length_252_cov_1.290503_g51187_i0 PRJNA560932 51543 252 1.290503 3.25206756 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 129 1.37e-34   NR MES1911029.1 1215613 g51187 i0 75.9 0.988095238095238 83 20 98.8 0 2 250 89 171 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 249 129 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
4958689 4958689 PRJNA560932_P_NODE_9604_length_562_cov_1.417178_g9250_i0 PRJNA560932 9604 562 1.417178 7.96454036 Cercozoa sp. DMV 1342330 SAR_Eukaryotes SAR_Eukaryotes 290 1.08e-93   NR BAN37425.1 1342330 g9250 i0 73.1 5.95729537366548 186 50 99.3 0 3 560 202 387 BAN37425.1 elongation factor 1-alpha [Cercozoa sp. DMV] diamond 3348 290 1 Eukaryota Sar   Cercozoa         Cercozoa sp. DMV
6922728 6922728 PRJNA560932_P_NODE_45686_length_270_cov_1.807107_g45330_i0 PRJNA560932 45686 270 1.807107 4.8791889 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 135 9.66e-37   NR MES1907458.1 1215613 g45330 i0 73.6 0.966666666666667 87 23 96.7 0 268 8 48 134 MES1907458.1 hypothetical protein [Cercozoa sp. M6MM] diamond 261 135 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
10748786 10748786 PRJNA560932_P_NODE_14029_length_467_cov_3.058376_g13674_i0 PRJNA560932 14029 467 3.058376 14.28261592 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 249 3.3000000000000003e-80   NR MES1911029.1 1215613 g13674 i0 77.4 0.995717344753747 155 35 99.6 0 2 466 2 156 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 465 249 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
12023886 12023886 PRJNA560932_P_NODE_54790_length_249_cov_1.312500_g54434_i0 PRJNA560932 54790 249 1.3125 3.268125 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 130 9.04e-37   NR ADK26622.1 323453 g54434 i0 94.1 0.819277108433735 68 4 81.9 0 46 249 1 68 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 204 130 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
15847308 15847308 PRJNA560932_P_NODE_15113_length_451_cov_1.552910_g14758_i0 PRJNA560932 15113 451 1.55291 7.0036241 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 237 6.6899999999999995e-78   NR ADK47156.1 323453 g14758 i0 82.5 0.951219512195122 143 25 95.1 0 21 449 1 143 ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] diamond 429 237 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
20946870 20946870 PRJNA560932_P_NODE_40937_length_285_cov_1.179245_g40581_i0 PRJNA560932 40937 285 1.179245 3.36084825 Amorphochlora amoebiformis 1561963 SAR_Eukaryotes SAR_Eukaryotes 78.2 1.7e-14   NR ACO54851.1 1561963 g40581 i0 52.1 1.32631578947368 71 34 74.7 0 284 72 296 366 ACO54851.1 calreticulin [Amorphochlora amoebiformis] diamond 378 78.2 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Amorphochlora Amorphochlora amoebiformis
26603976 26603976 PRJNA560932_P_NODE_49761_length_257_cov_2.092391_g49405_i0 PRJNA560932 49761 257 2.092391 5.37744487 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 67 1.59e-11   NR AAY21202.1 227086 g49405 i0 71.1 1.68093385214008 45 12 52.5 1 121 255 18 61 AAY21202.1 Rpl7A, partial [Bigelowiella natans] diamond 432 67 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
26635782 26635782 PRJNA560932_P_NODE_42581_length_280_cov_1.115942_g42225_i0 PRJNA560932 42581 280 1.115942 3.1246376 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 47.8 5.93e-5   NR MES1913692.1 1215613 g42225 i0 53.3 0.792857142857143 30 14 32.1 0 263 174 18 47 MES1913692.1 hypothetical protein [Cercozoa sp. M6MM] diamond 222 47.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26857863 26857863 PRJNA560932_P_NODE_21521_length_381_cov_0.870130_g21165_i0 PRJNA560932 21521 381 0.87013 3.3151953 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 98.6 1.62e-21   NR MES1914608.1 1215613 g21165 i0 53.8 0.614173228346457 78 36 61.4 0 261 28 260 337 MES1914608.1 hypothetical protein [Cercozoa sp. M6MM] diamond 234 98.6 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26984106 26984106 PRJNA560932_P_NODE_68162_length_198_cov_6.416000_g67806_i0 PRJNA560932 68162 198 6.416 12.70368 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 81.6 7.93e-19   NR MES1911722.1 1215613 g67806 i0 69.2 0.787878787878788 52 16 78.8 0 185 30 1 52 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 156 81.6 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27015703 27015703 PRJNA560932_P_NODE_44942_length_273_cov_0.935000_g44586_i0 PRJNA560932 44942 273 0.935 2.55255 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 73.2 9.77e-13   NR MES1909298.1 1215613 g44586 i0 40.4 1.95604395604396 89 50 94.5 2 272 15 85 173 MES1909298.1 hypothetical protein [Cercozoa sp. M6MM] diamond 534 73.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27395283 27395283 PRJNA560932_P_NODE_28543_length_336_cov_1.653992_g28187_i0 PRJNA560932 28543 336 1.653992 5.55741312 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 91.7 1.48e-19   NR MES1912635.1 1215613 g28187 i0 45.7 3.10714285714286 116 57 99.1 3 3 335 6 120 MES1912635.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1044 91.7 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27868589 27868589 PRJNA560932_P_NODE_52265_length_251_cov_0.865169_g51909_i0 PRJNA560932 52265 251 0.865169 2.17157419 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 129 6.919999999999999e-34   NR MES1914608.1 1215613 g51909 i0 63.4 6.84860557768924 82 30 98 0 247 2 225 306 MES1914608.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1719 129 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27963438 27963438 PRJNA560932_P_NODE_50945_length_254_cov_1.077348_g50589_i0 PRJNA560932 50945 254 1.077348 2.73646392 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 57.8 2.14e-7   NR MES1911564.1 1215613 g50589 i0 55.1 0.578740157480315 49 22 57.9 0 253 107 368 416 MES1911564.1 hypothetical protein [Cercozoa sp. M6MM] diamond 147 57.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28135373 28135373 PRJNA560932_P_NODE_36385_length_301_cov_1.750000_g36029_i0 PRJNA560932 36385 301 1.75 5.2675 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 93.6 3.9200000000000006e-21   NR MES1914368.1 1215613 g36029 i0 61 2.21262458471761 77 29 75.7 1 70 297 4 80 MES1914368.1 hypothetical protein [Cercozoa sp. M6MM] diamond 666 93.6 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28437161 28437161 PRJNA560932_P_NODE_26846_length_345_cov_2.422794_g26490_i0 PRJNA560932 26846 345 2.422794 8.3586393 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 84.7 2.1e-16   NR MES1913050.1 1215613 g26490 i0 41.4 0.860869565217391 99 57 86.1 1 40 336 190 287 MES1913050.1 hypothetical protein [Cercozoa sp. M6MM] diamond 297 84.7 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28468855 28468855 PRJNA560932_P_NODE_65586_length_242_cov_0.911243_g65230_i0 PRJNA560932 65586 242 0.911243 2.20520806 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 81.6 1.09e-16   NR AAT09082.1 227086 g65230 i0 48.8 0.991735537190083 80 39 96.7 2 236 3 4 83 AAT09082.1 glutathione-s-transferase [Bigelowiella natans] diamond 240 81.6 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
29037184 29037184 PRJNA560932_P_NODE_41908_length_282_cov_1.334928_g41552_i0 PRJNA560932 41908 282 1.334928 3.76449696 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 130 6.07e-36   NR MES1910907.1 1215613 g41552 i0 71 2.9468085106383 93 27 98.9 0 2 280 9 101 MES1910907.1 hypothetical protein [Cercozoa sp. M6MM] diamond 831 130 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29384380 29384380 PRJNA560932_P_NODE_56589_length_248_cov_0.880000_g56233_i0 PRJNA560932 56589 248 0.88 2.1824 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 59.7 2.95e-8   NR MES1908401.1 1215613 g56233 i0 46.3 2.46774193548387 54 29 65.3 0 227 66 202 255 MES1908401.1 hypothetical protein [Cercozoa sp. M6MM] diamond 612 59.7 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29604974 29604974 PRJNA560932_P_NODE_53630_length_250_cov_0.870056_g53274_i0 PRJNA560932 53630 250 0.870056 2.17514 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 136 2.5799999999999996e-35   NR MES1909922.1 1215613 g53274 i0 78.8 0.96 80 17 96 0 250 11 435 514 MES1909922.1 hypothetical protein [Cercozoa sp. M6MM] diamond 240 136 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30047254 30047254 PRJNA560932_P_NODE_41331_length_284_cov_1.094787_g40975_i0 PRJNA560932 41331 284 1.094787 3.10919508 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 74.7 3.44e-13   NR MES1911564.1 1215613 g40975 i0 53.3 0.792253521126761 75 35 79.2 0 226 2 341 415 MES1911564.1 hypothetical protein [Cercozoa sp. M6MM] diamond 225 74.7 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30552801 30552801 PRJNA560932_P_NODE_27013_length_345_cov_0.819853_g26657_i0 PRJNA560932 27013 345 0.819853 2.82849285 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.0443   NR MES1906780.1 1215613 g26657 i0 33.8 0.643478260869565 74 47 64.3 2 73 294 99 170 MES1906780.1 hypothetical protein [Cercozoa sp. M6MM] diamond 222 43.9 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31103913 31103913 PRJNA560932_P_NODE_32155_length_319_cov_1.593496_g31799_i0 PRJNA560932 32155 319 1.593496 5.08325224 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 73.2 1.81e-12   NR MES1911260.1 1215613 g31799 i0 37.9 2.63322884012539 103 52 85.6 2 302 30 326 428 MES1911260.1 hypothetical protein [Cercozoa sp. M6MM] diamond 840 73.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31152915 31152915 PRJNA560932_P_NODE_63855_length_243_cov_0.905882_g63499_i0 PRJNA560932 63855 243 0.905882 2.20129326 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 107 4.92e-28   NR MES1914773.1 1215613 g63499 i0 77.3 0.814814814814815 66 15 81.5 0 243 46 56 121 MES1914773.1 hypothetical protein [Cercozoa sp. M6MM] diamond 198 107 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31469685 31469685 PRJNA560932_P_NODE_38296_length_294_cov_1.045249_g37940_i0 PRJNA560932 38296 294 1.045249 3.07303206 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 52 1.37e-5   NR MES1911919.1 1215613 g37940 i0 55.6 0.36734693877551 36 15 36.7 1 6 113 135 169 MES1911919.1 hypothetical protein [Cercozoa sp. M6MM] diamond 108 52 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31546903 31546903 PRJNA560932_P_NODE_14896_length_454_cov_1.895013_g14541_i0 PRJNA560932 14896 454 1.895013 8.60335902 root 1 Root_unresolved Root_unresolved 125 1.24e-33   NR MES1911547.1 1215613 g14541 i0 49.2 8.27312775330397 120 61 79.3 0 371 12 12 131 MES1911547.1 hypothetical protein [Cercozoa sp. M6MM] diamond 3756 126 0.992063492063492 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31690872 31690872 PRJNA560932_P_NODE_47877_length_263_cov_2.900000_g47521_i0 PRJNA560932 47877 263 2.9 7.627 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 112 2e-29   NR AAT09077.1 227086 g47521 i0 72.7 0.878326996197719 77 20 86.7 1 229 2 1 77 AAT09077.1 transcription factor BTF3 [Bigelowiella natans] diamond 231 112 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
32007261 32007261 PRJNA560932_P_NODE_27758_length_340_cov_5.202247_g27402_i0 PRJNA560932 27758 340 5.202247 17.6876398 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 84 3.96e-18   NR MES1912234.1 1215613 g27402 i0 54.7 1.32352941176471 75 31 66.2 2 20 244 49 120 MES1912234.1 hypothetical protein [Cercozoa sp. M6MM] diamond 450 84 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32165693 32165693 PRJNA560932_P_NODE_65598_length_242_cov_0.911243_g65242_i0 PRJNA560932 65598 242 0.911243 2.20520806 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 88.2 3.77e-19   NR MES1910933.1 1215613 g65242 i0 64.2 0.830578512396694 67 24 83.1 0 201 1 14 80 MES1910933.1 hypothetical protein [Cercozoa sp. M6MM] diamond 201 88.2 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);;