RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where bioproject = "PRJNA857143", tax_clade = "Sar" and tax_phylum = "Foraminifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Foraminifera · 23 ✖

tax_clade 1

  • Sar · 23 ✖

bioproject 1

  • PRJNA857143 · 23 ✖

analysis 1

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
2510878 2510878 PRJNA857143_S_NODE_56502_length_381_cov_1.012987_g55409_i0 PRJNA857143 56502 381 1.012987 3.85948047 Opalinata 42740 SAR_Eukaryotes SAR_Eukaryotes 90.5 1.1e-20   NR ETO12634.1 46433 g55409 i0 59.3 4.31496062992126 91 33 68.5 1 380 120 17 107 ETO12634.1 rab-type small G protein, partial [Reticulomyxa filosa] diamond 1644 91.3 0.991237677984666 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
5947242 5947242 PRJNA857143_S_NODE_34645_length_444_cov_3.665768_g33553_i0 PRJNA857143 34645 444 3.665768 16.27600992 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 149 1.1099999999999999e-42   NR ETO03070.1 46433 g33553 i0 79.8 1.27027027027027 94 19 63.5 0 442 161 93 186 ETO03070.1 hypothetical protein RFI_34341 [Reticulomyxa filosa] diamond 564 149 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
8495742 8495742 PRJNA857143_S_NODE_101867_length_311_cov_1.638655_g100774_i0 PRJNA857143 101867 311 1.638655 5.09621705 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 124 4.92e-31   NR ETO16550.1 46433 g100774 i0 75.7 0.713826366559486 74 18 71.4 0 3 224 325 398 ETO16550.1 methionine aminopeptidase [Reticulomyxa filosa] diamond 222 124 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
11046689 11046689 PRJNA857143_S_NODE_121749_length_291_cov_1.027523_g120656_i0 PRJNA857143 121749 291 1.027523 2.99009193 Viridiplantae 33090 SAR_Eukaryotes SAR_Eukaryotes 107 9.61e-27   NR ETO22649.1 46433 g120656 i0 59.5 3.18556701030928 79 31 81.4 1 291 55 109 186 ETO22649.1 superoxide dismutase [Reticulomyxa filosa] diamond 927 108 0.990740740740741 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
26738102 26738102 PRJNA857143_S_NODE_69441_length_355_cov_5.003546_g68348_i0 PRJNA857143 69441 355 5.003546 17.7625883 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 67.8 2.53e-11   NR ETO36728.1 46433 g68348 i0 36.9 0.709859154929578 84 53 71 0 354 103 85 168 ETO36728.1 hypothetical protein RFI_00333 [Reticulomyxa filosa] diamond 252 67.8 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
26991581 26991581 PRJNA857143_S_NODE_73102_length_349_cov_3.318841_g72009_i0 PRJNA857143 73102 349 3.318841 11.58275509 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 61.2 1.95e-8   NR ETO14711.1 46433 g72009 i0 48.4 0.532951289398281 62 31 52.4 1 349 167 66 127 ETO14711.1 hypothetical protein RFI_22657, partial [Reticulomyxa filosa] diamond 186 61.2 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
27055167 27055167 PRJNA857143_S_NODE_172562_length_251_cov_2.269663_g171469_i0 PRJNA857143 172562 251 2.269663 5.69685413 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 92.4 1.33e-19   NR ETO08449.1 46433 g171469 i0 56.9 5.12749003984064 72 31 86.1 0 250 35 529 600 ETO08449.1 hypothetical protein RFI_28936 [Reticulomyxa filosa] diamond 1287 92.4 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
27181318 27181318 PRJNA857143_S_NODE_134022_length_279_cov_4.165049_g132929_i0 PRJNA857143 134022 279 4.165049 11.62048671 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.00318   NR ETO23455.1 46433 g132929 i0 63 0.290322580645161 27 10 29 0 1 81 72 98 ETO23455.1 hypothetical protein RFI_13723 [Reticulomyxa filosa] diamond 81 45.1 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
27631996 27631996 PRJNA857143_S_NODE_58584_length_376_cov_3.079208_g57491_i0 PRJNA857143 58584 376 3.079208 11.57782208 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 60.8 8.5e-9   NR ETO23065.1 46433 g57491 i0 35.2 5.25797872340426 91 43 72.6 2 19 291 65 139 ETO23065.1 acid phosphatase AphA [Reticulomyxa filosa] diamond 1977 60.8 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
27876281 27876281 PRJNA857143_S_NODE_72345_length_351_cov_1.053957_g71252_i0 PRJNA857143 72345 351 1.053957 3.69938907 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 140 6.54e-36   NR ETO28518.1 46433 g71252 i0 57 0.974358974358974 114 47 97.4 1 2 343 438 549 ETO28518.1 axonemal dynein gamma heavy chain [Reticulomyxa filosa] diamond 342 140 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
28286588 28286588 PRJNA857143_S_NODE_51146_length_393_cov_2.425000_g50053_i0 PRJNA857143 51146 393 2.425 9.53025 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 54.7 7.27e-7   NR ETO15938.1 46433 g50053 i0 48.3 0.916030534351145 60 30 45.8 1 2 181 6 64 ETO15938.1 hypothetical protein RFI_21422 [Reticulomyxa filosa] diamond 360 54.7 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
28760318 28760318 PRJNA857143_S_NODE_191367_length_243_cov_1.794118_g190274_i0 PRJNA857143 191367 243 1.794118 4.35970674 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 80.9 8.16e-16   NR ETO18101.1 46433 g190274 i0 50.7 1.65432098765432 69 34 85.2 0 3 209 282 350 ETO18101.1 hypothetical protein RFI_19189 [Reticulomyxa filosa] diamond 402 80.9 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
29738922 29738922 PRJNA857143_S_NODE_185490_length_246_cov_0.901734_g184397_i0 PRJNA857143 185490 246 0.901734 2.21826564 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 47.8 4.98e-4   NR ETO24401.1 46433 g184397 i0 64.3 0.341463414634146 28 10 34.1 0 244 161 199 226 ETO24401.1 hypothetical protein RFI_12758 [Reticulomyxa filosa] diamond 84 47.8 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
30149658 30149658 PRJNA857143_S_NODE_97552_length_316_cov_1.559671_g96459_i0 PRJNA857143 97552 316 1.559671 4.92856036 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 124 6.64e-34   NR ETO06965.1 46433 g96459 i0 54 0.949367088607595 100 44 93 2 314 21 47 146 ETO06965.1 hypothetical protein RFI_30425 [Reticulomyxa filosa] diamond 300 124 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
30403067 30403067 PRJNA857143_S_NODE_194213_length_242_cov_1.384615_g193120_i0 PRJNA857143 194213 242 1.384615 3.3507683 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 94 3.45e-20   NR ETO35939.1 46433 g193120 i0 46.3 0.991735537190083 80 42 97.9 1 3 239 179 258 ETO35939.1 hypothetical protein RFI_01125, partial [Reticulomyxa filosa] diamond 240 94 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
30466089 30466089 PRJNA857143_S_NODE_159013_length_260_cov_1.251337_g157920_i0 PRJNA857143 159013 260 1.251337 3.2534762 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.0135   NR ETO28912.1 46433 g157920 i0 38.8 0.565384615384615 49 28 54.2 1 5 145 984 1032 ETO28912.1 hypothetical protein RFI_08214 [Reticulomyxa filosa] diamond 147 44.3 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
30750212 30750212 PRJNA857143_S_NODE_109534_length_303_cov_1.017391_g108441_i0 PRJNA857143 109534 303 1.017391 3.08269473 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 114 2.74e-28   NR ETO08971.1 46433 g108441 i0 61.9 1.82178217821782 97 36 95 1 298 11 42 138 ETO08971.1 Arf GTPase activating protein [Reticulomyxa filosa] diamond 552 114 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
30908299 30908299 PRJNA857143_S_NODE_68554_length_357_cov_2.116197_g67461_i0 PRJNA857143 68554 357 2.116197 7.55482329 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 130 1.93e-35   NR ETO03070.1 46433 g67461 i0 85.1 1.86554621848739 74 11 62.2 0 355 134 113 186 ETO03070.1 hypothetical protein RFI_34341 [Reticulomyxa filosa] diamond 666 130 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
31003009 31003009 PRJNA857143_S_NODE_134494_length_279_cov_1.776699_g133401_i0 PRJNA857143 134494 279 1.776699 4.95699021 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 82 5.88e-17   NR ETO34651.1 46433 g133401 i0 63.2 1.83870967741935 57 21 61.3 0 3 173 139 195 ETO34651.1 beta-hexosaminidase [Reticulomyxa filosa] diamond 513 82 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
31255744 31255744 PRJNA857143_S_NODE_75895_length_345_cov_1.345588_g74802_i0 PRJNA857143 75895 345 1.345588 4.6422786 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 52.4 4.69e-5   NR ETO29292.1 46433 g74802 i0 46.2 0.565217391304348 65 33 54.8 1 323 135 374 438 ETO29292.1 hypothetical protein RFI_07831 [Reticulomyxa filosa] diamond 195 52.4 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
31287257 31287257 PRJNA857143_S_NODE_186935_length_245_cov_1.360465_g185842_i0 PRJNA857143 186935 245 1.360465 3.33313925 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 49.3 1.62e-4   NR ETO20168.1 46433 g185842 i0 31.6 0.96734693877551 79 54 96.7 0 6 242 28 106 ETO20168.1 hypothetical protein RFI_17050 [Reticulomyxa filosa] diamond 237 49.3 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
31413930 31413930 PRJNA857143_S_NODE_143916_length_271_cov_2.121212_g142823_i0 PRJNA857143 143916 271 2.121212 5.74848452 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 91.3 3.71e-19   NR ETO16550.1 46433 g142823 i0 76.5 0.564575645756458 51 12 56.5 0 252 100 348 398 ETO16550.1 methionine aminopeptidase [Reticulomyxa filosa] diamond 153 91.3 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
31856636 31856636 PRJNA857143_S_NODE_65137_length_363_cov_3.624138_g64044_i0 PRJNA857143 65137 363 3.624138 13.15562094 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 63.5 2.07e-9   NR ETO30544.1 46433 g64044 i0 66.7 0.652892561983471 39 10 32.2 1 5 121 169 204 ETO30544.1 methylmalonate semialdhyde dehydrogenase [Reticulomyxa filosa] diamond 237 63.5 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa

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