RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA975724" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 28 ✖

tax_clade 1

bioproject 1

  • PRJNA975724 · 28 ✖

analysis 1

  • diamond · 28 ✖

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
946967 946967 PRJNA975724_S_NODE_7141_length_483_cov_10.075610_g6960_i0 PRJNA975724 7141 483 10.07561 48.6651963 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 154 8.63e-45   NR ACF24571.1 67809 g6960 i0 71.3 22.1180124223602 101 29 62.7 0 456 154 47 147 ACF24571.1 ubiquitin-conjugating enzyme 2 [Gymnochlora stellata] diamond 10683 154 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Gymnochlora Gymnochlora stellata
2222926 2222926 PRJNA975724_S_NODE_962_length_813_cov_13.633784_g823_i0 PRJNA975724 962 813 13.633784 110.84266392 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 209 1.34e-58   NR MES1908290.1 1215613 g823 i0 77.4 1.47232472324723 133 30 49.1 0 3 401 617 749 MES1908290.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1197 209 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
4775579 4775579 PRJNA975724_S_NODE_8424_length_467_cov_2.890863_g8243_i0 PRJNA975724 8424 467 2.890863 13.50033021 Thaumatomonas 45099 SAR_Eukaryotes SAR_Eukaryotes 229 1.12e-69   NR AAP72162.1 188940 g8243 i0 76.6 8.90364025695932 154 36 98.9 0 462 1 356 509 AAP72162.1 heat shock protein 90, partial [Thaumatomonas sp. (SA)] diamond 4158 231 0.991341991341991 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas sp. (SA)
8599804 8599804 PRJNA975724_S_NODE_69367_length_263_cov_2.578947_g69186_i0 PRJNA975724 69367 263 2.578947 6.78263061 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 73.9 2.11e-15   NR MES1916766.1 1215613 g69186 i0 75.6 0.992395437262357 45 11 51.3 0 3 137 8 52 MES1916766.1 hypothetical protein [Cercozoa sp. M6MM] diamond 261 73.9 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
14973301 14973301 PRJNA975724_S_NODE_1172_length_769_cov_24.719828_g1026_i0 PRJNA975724 1172 769 24.719828 190.09547732 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 140 2.94e-36   NR MES1911029.1 1215613 g1026 i0 67 0.390117035110533 100 33 39 0 3 302 53 152 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 300 140 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
17525371 17525371 PRJNA975724_S_NODE_85714_length_245_cov_1.354651_g85533_i0 PRJNA975724 85714 245 1.354651 3.31889495 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 94 1.19e-21   NR MES1906886.1 1215613 g85533 i0 70.6 0.83265306122449 68 20 83.3 0 1 204 143 210 MES1906886.1 hypothetical protein [Cercozoa sp. M6MM] diamond 204 94 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28163156 28163156 PRJNA975724_S_NODE_16625_length_403_cov_5.281818_g16444_i0 PRJNA975724 16625 403 5.281818 21.28572654 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00406   NR MES1914340.1 1215613 g16444 i0 50 0.267990074441687 36 18 26.8 0 93 200 28 63 MES1914340.1 hypothetical protein [Cercozoa sp. M6MM] diamond 108 44.7 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28225922 28225922 PRJNA975724_S_NODE_34366_length_334_cov_3.532567_g34185_i0 PRJNA975724 34366 334 3.532567 11.79877378 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 75.5 3.56e-14   NR MES1917360.1 1215613 g34185 i0 38.1 0.754491017964072 84 50 73.7 1 327 82 108 191 MES1917360.1 hypothetical protein [Cercozoa sp. M6MM] diamond 252 75.5 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28352442 28352442 PRJNA975724_S_NODE_40486_length_318_cov_3.134694_g40305_i0 PRJNA975724 40486 318 3.134694 9.96832692 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 128 1.31e-35   NR ADK26622.1 323453 g40305 i0 79.7 1.39622641509434 74 15 69.8 0 1 222 57 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 444 128 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
28447388 28447388 PRJNA975724_S_NODE_60186_length_278_cov_2.253659_g60005_i0 PRJNA975724 60186 278 2.253659 6.26517202 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 124 1.2199999999999999e-32   NR ADK26624.1 323453 g60005 i0 77.3 0.809352517985611 75 17 80.9 0 273 49 202 276 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 225 124 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
28605106 28605106 PRJNA975724_S_NODE_60827_length_277_cov_1.887255_g60646_i0 PRJNA975724 60827 277 1.887255 5.22769635 Gymnochlora stellata 67809 SAR_Eukaryotes SAR_Eukaryotes 48.1 5.45e-4   NR ACF24562.1 67809 g60646 i0 50 0.877256317689531 42 21 45.5 0 275 150 200 241 ACF24562.1 proteasome alpha 5 subunit [Gymnochlora stellata] diamond 243 48.1 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Gymnochlora Gymnochlora stellata
28857554 28857554 PRJNA975724_S_NODE_37388_length_326_cov_2.458498_g37207_i0 PRJNA975724 37388 326 2.458498 8.01470348 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 100 1.5799999999999998e-23   NR MES1916034.1 1215613 g37207 i0 72.7 0.607361963190184 66 17 59.8 1 9 203 158 223 MES1916034.1 hypothetical protein [Cercozoa sp. M6MM] diamond 198 100 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29078848 29078848 PRJNA975724_S_NODE_23188_length_372_cov_5.100334_g23007_i0 PRJNA975724 23188 372 5.100334 18.97324248 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.0413   NR MES1916247.1 1215613 g23007 i0 42.6 0.548387096774194 68 37 54.8 2 3 206 403 468 MES1916247.1 hypothetical protein [Cercozoa sp. M6MM] diamond 204 44.3 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29331271 29331271 PRJNA975724_S_NODE_93389_length_230_cov_4.019108_g93208_i0 PRJNA975724 93389 230 4.019108 9.2439484 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0398   NR MES1914805.1 1215613 g93208 i0 65.4 0.339130434782609 26 9 33.9 0 135 212 236 261 MES1914805.1 hypothetical protein [Cercozoa sp. M6MM] diamond 78 42.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29583546 29583546 PRJNA975724_S_NODE_74530_length_256_cov_1.524590_g74349_i0 PRJNA975724 74530 256 1.52459 3.9029504 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 70.5 3.15e-13   NR ADK26622.1 323453 g74349 i0 87.9 0.38671875 33 4 38.7 0 232 134 98 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 99 70.5 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
29615118 29615118 PRJNA975724_S_NODE_24830_length_366_cov_2.938567_g24649_i0 PRJNA975724 24830 366 2.938567 10.75515522 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 87 4.61e-17   NR MES1908640.1 1215613 g24649 i0 45.2 0.852459016393443 104 53 83.6 2 350 45 773 874 MES1908640.1 hypothetical protein [Cercozoa sp. M6MM] diamond 312 87 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29615122 29615122 PRJNA975724_S_NODE_54610_length_288_cov_2.455814_g54429_i0 PRJNA975724 54610 288 2.455814 7.07274432 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 60.1 5.07e-8   NR MES1912280.1 1215613 g54429 i0 57.8 0.9375 45 19 46.9 0 37 171 457 501 MES1912280.1 hypothetical protein [Cercozoa sp. M6MM] diamond 270 60.1 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30594591 30594591 PRJNA975724_S_NODE_6793_length_489_cov_4.038462_g6612_i0 PRJNA975724 6793 489 4.038462 19.74807918 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 62.8 8.07e-9   NR MES1913617.1 1215613 g6612 i0 29.6 0.932515337423313 152 67 90.2 4 487 47 58 174 MES1913617.1 hypothetical protein [Cercozoa sp. M6MM] diamond 456 62.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30847505 30847505 PRJNA975724_S_NODE_21254_length_380_cov_13.739414_g21073_i0 PRJNA975724 21254 380 13.739414 52.2097732 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 88.6 1.55e-20   NR MES1917015.1 1215613 g21073 i0 68.5 0.426315789473684 54 17 42.6 0 315 154 3 56 MES1917015.1 ribosomal 40S subunit protein S29B [Cercozoa sp. M6MM] diamond 162 88.6 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31100105 31100105 PRJNA975724_S_NODE_74495_length_256_cov_1.650273_g74314_i0 PRJNA975724 74495 256 1.650273 4.22469888 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 64.7 7.76e-10   NR MES1909105.1 1215613 g74314 i0 43.9 0.9609375 82 37 87.9 3 2 226 11 90 MES1909105.1 hypothetical protein [Cercozoa sp. M6MM] diamond 246 64.7 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31163176 31163176 PRJNA975724_S_NODE_8115_length_470_cov_14.314861_g7934_i0 PRJNA975724 8115 470 14.314861 67.2798467 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 58.2 1.5e-6   NR MES1909105.1 1215613 g7934 i0 47.6 0.536170212765957 84 44 53.6 0 95 346 325 408 MES1909105.1 hypothetical protein [Cercozoa sp. M6MM] diamond 252 58.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31194640 31194640 PRJNA975724_S_NODE_40615_length_318_cov_1.885714_g40434_i0 PRJNA975724 40615 318 1.885714 5.99657052 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 68.9 3.47e-11   NR AAT09089.1 227086 g40434 i0 43.2 0.69811320754717 74 42 69.8 0 2 223 87 160 AAT09089.1 calmodulin like myosin light chain [Bigelowiella natans] diamond 222 68.9 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
31289802 31289802 PRJNA975724_S_NODE_66135_length_268_cov_4.148718_g65954_i0 PRJNA975724 66135 268 4.148718 11.11856424 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 73.6 3.4e-14   NR MES1912224.1 1215613 g65954 i0 47.9 0.794776119402985 71 34 76.1 1 226 23 68 138 MES1912224.1 hypothetical protein [Cercozoa sp. M6MM] diamond 213 73.6 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31574760 31574760 PRJNA975724_S_NODE_71536_length_260_cov_2.058824_g71355_i0 PRJNA975724 71536 260 2.058824 5.3529424 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 51.6 3.25e-5   NR MES1917378.1 1215613 g71355 i0 35.6 0.842307692307692 73 47 84.2 0 3 221 71 143 MES1917378.1 hypothetical protein [Cercozoa sp. M6MM] diamond 219 51.6 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31827439 31827439 PRJNA975724_S_NODE_33617_length_337_cov_1.166667_g33436_i0 PRJNA975724 33617 337 1.166667 3.93166779 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 115 1.93e-29   NR MES1916034.1 1215613 g33436 i0 57.7 0.863501483679525 97 36 82.8 2 318 40 138 233 MES1916034.1 hypothetical protein [Cercozoa sp. M6MM] diamond 291 115 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32049066 32049066 PRJNA975724_S_NODE_13398_length_423_cov_2.774286_g13217_i0 PRJNA975724 13398 423 2.774286 11.73522978 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 73.2 6.24e-12   NR MES1912797.1 1215613 g13217 i0 40 0.673758865248227 95 56 66.7 1 1 282 535 629 MES1912797.1 hypothetical protein [Cercozoa sp. M6MM] diamond 285 73.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32492280 32492280 PRJNA975724_S_NODE_56139_length_285_cov_6.292453_g55958_i0 PRJNA975724 56139 285 6.292453 17.93349105 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 48.9 3.47e-4   NR MES1910742.1 1215613 g55958 i0 40.3 0.652631578947368 62 37 65.3 0 38 223 201 262 MES1910742.1 hypothetical protein [Cercozoa sp. M6MM] diamond 186 48.9 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32807269 32807269 PRJNA975724_S_NODE_4840_length_526_cov_11.216336_g4661_i0 PRJNA975724 4840 526 11.216336 58.99792736 Paracercomonas marina 372086 SAR_Eukaryotes SAR_Eukaryotes 157 5.87e-46   NR YP_009118075.1 372086 g4661 i0 72.4 0.661596958174905 116 32 66.2 0 465 118 3 118 YP_009118075.1 NADH dehydrogenase subunit 3 [Paracercomonas marina] diamond 348 157 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);;