RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

29 rows where analysis = "diamond", bioproject = "PRJEB39269" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

  • Sar · 29 ✖

bioproject 1

  • PRJEB39269 · 29 ✖

analysis 1

  • diamond · 29 ✖

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
2606990 2606990 PRJEB39269_P_NODE_66083_length_170_cov_4.854962_g65678_i0 PRJEB39269 66083 170 4.8549620000000004 8.2534354 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 77.4 2.38e-15   NR XP_002177120.1 556484 g65678 i0 47.7 7.76470588235294 88 12 95.3 1 9 170 1 88 XP_002177120.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 1320 77.8 0.994858611825193 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
6092327 6092327 PRJEB39269_P_NODE_17745_length_333_cov_2.380952_g17340_i0 PRJEB39269 17745 333 2.380952 7.92857016 Leukarachnion sp. ATCC PRA-24 568390 SAR_Eukaryotes SAR_Eukaryotes 136 3.34e-35   NR XAL83088.1 568390 g17340 i0 84.3 0.747747747747748 83 13 74.8 0 32 280 4 86 XAL83088.1 cytochrome c oxidase subunit 1 [Leukarachnion sp. ATCC PRA-24] diamond 249 136 1 Eukaryota Sar             Leukarachnion sp. ATCC PRA-24
12810572 12810572 PRJEB39269_P_NODE_32351_length_243_cov_1.808824_g31946_i0 PRJEB39269 32351 243 1.808824 4.39544232 Chattonella marina 90936 SAR_Eukaryotes SAR_Eukaryotes 156 2.49e-44   NR YP_003434220.1 90936 g31946 i0 85 1.97530864197531 80 12 98.8 0 2 241 6 85 YP_003434220.1 cytochrome b [Chattonella marina] diamond 480 156 1 Eukaryota Sar     Raphidophyceae Chattonellales Chattonellaceae Chattonella Chattonella marina
12810607 12810607 PRJEB39269_P_NODE_71531_length_166_cov_2.070866_g71126_i0 PRJEB39269 71531 166 2.070866 3.43763756 Synura 2991 SAR_Eukaryotes SAR_Eukaryotes 98.2 2.789999999999999e-23   NR ADB04536.1 52556 g71126 i0 83.6 2.98192771084337 55 9 99.4 0 166 2 123 177 ADB04536.1 cytochrome b, partial [Synura sphagnicola] diamond 495 98.2 1 Eukaryota Sar     Synurophyceae Synurales Mallomonadaceae Synura Synura sphagnicola
15359270 15359270 PRJEB39269_P_NODE_80973_length_158_cov_1.378151_g80568_i0 PRJEB39269 80973 158 1.378151 2.17747858 root 1 Root_unresolved Root_unresolved 101 9.67e-24   NR YP_003434220.1 90936 g80568 i0 82.7 6.8924050632911404 52 9 98.7 0 157 2 19 70 YP_003434220.1 cytochrome b [Chattonella marina] diamond 1089 102 0.990196078431373 Eukaryota Sar     Raphidophyceae Chattonellales Chattonellaceae Chattonella Chattonella marina
23009132 23009132 PRJEB39269_P_NODE_73679_length_164_cov_1.312000_g73274_i0 PRJEB39269 73679 164 1.312 2.15168 root 1 Root_unresolved Root_unresolved 84 2.51e-17   NR XAL83123.1 568390 g73274 i0 68.5 2.94512195121951 54 17 98.8 0 164 3 210 263 XAL83123.1 apocytochrome b [Leukarachnion sp. ATCC PRA-24] diamond 483 84 1 Eukaryota Sar             Leukarachnion sp. ATCC PRA-24
26811859 26811859 PRJEB39269_P_NODE_60301_length_178_cov_1.129496_g59896_i0 PRJEB39269 60301 178 1.129496 2.01050288 Synura petersenii 52555 SAR_Eukaryotes SAR_Eukaryotes 60.8 7.03e-10   NR AYO28135.1 52555 g59896 i0 87.9 0.556179775280899 33 4 55.6 0 78 176 1 33 AYO28135.1 ribosomal protein S8 [Synura petersenii] diamond 99 60.8 1 Eukaryota Sar     Synurophyceae Synurales Mallomonadaceae Synura Synura petersenii
27191255 27191255 PRJEB39269_P_NODE_51222_length_192_cov_1.071895_g50817_i0 PRJEB39269 51222 192 1.071895 2.0580384 Synura uvella 52557 SAR_Eukaryotes SAR_Eukaryotes 75.5 1.62e-16   NR YP_009545243.1 52557 g50817 i0 94.6 0.578125 37 2 57.8 0 113 3 1 37 YP_009545243.1 photosystem II protein VI [Synura uvella] diamond 111 75.5 1 Eukaryota Sar     Synurophyceae Synurales Mallomonadaceae Synura Synura uvella
27343087 27343087 PRJEB39269_P_NODE_91883_length_150_cov_1.099099_g91478_i0 PRJEB39269 91883 150 1.099099 1.6486485 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 88.6 3.99e-20   NR CAA68028.1 2829 g91478 i0 83.7 11.64 49 8 98 0 147 1 33 81 CAA68028.1 fucoxanthin chlorophyll a /c binding protein [Heterosigma akashiwo] diamond 1746 88.6 1 Eukaryota Sar     Raphidophyceae Chattonellales Chattonellaceae Heterosigma Heterosigma akashiwo
27507519 27507519 PRJEB39269_P_NODE_66663_length_170_cov_3.229008_g66258_i0 PRJEB39269 66663 170 3.229008 5.4893136 Synura synuroidea 47573 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00113   NR NP_038177.1 47573 g66258 i0 76.9 0.458823529411765 26 6 45.9 0 80 3 134 159 NP_038177.1 NADH dehydrogenase subunit 2 [Synura synuroidea] diamond 78 45.8 1 Eukaryota Sar     Synurophyceae Synurales Mallomonadaceae Synura Synura synuroidea
27697145 27697145 PRJEB39269_P_NODE_86584_length_153_cov_6.017544_g86179_i0 PRJEB39269 86584 153 6.017544 9.20684232 Triparma laevis f. inornata 1714386 SAR_Eukaryotes SAR_Eukaryotes 58.9 1.82e-9   NR GMH96503.1 1714386 g86179 i0 41.5 1.6078431372549 82 15 96.1 1 148 2 29 110 GMH96503.1 hypothetical protein TL16_g13307, partial [Triparma laevis f. inornata] diamond 246 58.9 1 Eukaryota Sar     Bolidophyceae Parmales Triparmaceae Triparma Triparma laevis
28139078 28139078 PRJEB39269_P_NODE_80565_length_158_cov_2.823529_g80160_i0 PRJEB39269 80565 158 2.823529 4.46117582 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 46.2 6.91e-4   NR KAI2500240.1 210448 g80160 i0 84.6 0.493670886075949 26 4 49.4 0 157 80 244 269 KAI2500240.1 Glyceraldehyde-3-phosphate dehydrogenase [Fragilaria crotonensis] diamond 78 46.2 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28391383 28391383 PRJEB39269_P_NODE_60306_length_178_cov_1.115108_g59901_i0 PRJEB39269 60306 178 1.115108 1.98489224 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 84 9.53e-18   NR KAJ1415384.1 483371 g59901 i0 84.9 3.53932584269663 53 7 89.3 1 2 160 215 266 KAJ1415384.1 ribosomal protein S3Ae [Ochromonadaceae sp. CCMP2298] diamond 630 84 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
28700682 28700682 PRJEB39269_P_NODE_60267_length_178_cov_1.179856_g59862_i0 PRJEB39269 60267 178 1.179856 2.10014368 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 55.5 2.84e-7   NR KAJ1428526.1 483371 g59862 i0 41.3 2.03932584269663 63 32 97.8 1 176 3 16 78 KAJ1428526.1 chlorophyll a/b-binding protein domain-containing protein [Ochromonadaceae sp. CCMP2298] diamond 363 55.5 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
28700683 28700683 PRJEB39269_P_NODE_85807_length_154_cov_1.486957_g85402_i0 PRJEB39269 85807 154 1.486957 2.28991378 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 93.6 1.33e-20   NR YP_009545382.1 52552 g85402 i0 86.3 2.98051948051948 51 7 99.4 0 1 153 327 377 YP_009545382.1 cell division protein [Mallomonas splendens] diamond 459 94.4 0.991525423728813 Eukaryota Sar     Synurophyceae Synurales Mallomonadaceae Mallomonas Mallomonas splendens
28770232 28770232 PRJEB39269_P_NODE_42947_length_209_cov_3.135294_g42542_i0 PRJEB39269 42947 209 3.135294 6.55276446 Synura synuroidea 47573 SAR_Eukaryotes SAR_Eukaryotes 101 2.74e-26   NR NP_038183.1 47573 g42542 i0 86.9 1.7511961722488 61 8 87.6 0 26 208 1 61 NP_038183.1 ATP synthase F0 subunit 9 [Synura synuroidea] diamond 366 101 1 Eukaryota Sar     Synurophyceae Synurales Mallomonadaceae Synura Synura synuroidea
29306987 29306987 PRJEB39269_P_NODE_90269_length_151_cov_1.098214_g89864_i0 PRJEB39269 90269 151 1.098214 1.65830314 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 75.1 3.87e-14   NR KAJ1427338.1 483371 g89864 i0 77.6 0.973509933774834 49 10 97.4 1 149 3 309 356 KAJ1427338.1 serine hydroxymethyltransferase [Ochromonadaceae sp. CCMP2298] diamond 147 75.1 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
30064838 30064838 PRJEB39269_P_NODE_83392_length_156_cov_1.666667_g82987_i0 PRJEB39269 83392 156 1.666667 2.60000052 Ochromonas sp. CCMP1393 420556 SAR_Eukaryotes SAR_Eukaryotes 65.5 2.98e-12   NR AIM52723.1 420556 g82987 i0 93.5 1.78846153846154 31 2 59.6 0 2 94 62 92 AIM52723.1 30S ribosomal protein S19 [Ochromonas sp. CCMP1393] diamond 279 65.5 1 Eukaryota Sar     Chrysophyceae Chromulinales Chromulinaceae Ochromonas Ochromonas sp. CCMP1393
30216193 30216193 PRJEB39269_P_NODE_22672_length_294_cov_2.580392_g22267_i0 PRJEB39269 22672 294 2.580392 7.58635248 Streptophyta 35493 SAR_Eukaryotes SAR_Eukaryotes 74.3 7.22e-14   NR ADB04436.1 52557 g22267 i0 46.5 2.30612244897959 86 28 87.8 1 2 259 81 148 ADB04436.1 cytochrome oxidase subunit 3, partial [Synura uvella] diamond 678 74.3 1 Eukaryota Sar     Synurophyceae Synurales Mallomonadaceae Synura Synura uvella
30311646 30311646 PRJEB39269_P_NODE_64512_length_172_cov_1.849624_g64107_i0 PRJEB39269 64512 172 1.849624 3.18135328 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 111 3.1699999999999998e-28   NR KAJ1432209.1 483371 g64107 i0 87.7 2.98255813953488 57 7 99.4 0 172 2 98 154 KAJ1432209.1 ribosomal protein S2, flavodoxin-like domain-containing protein [Ochromonadaceae sp. CCMP2298] diamond 513 111 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
30538839 30538839 PRJEB39269_P_NODE_16253_length_348_cov_2.135922_g15848_i0 PRJEB39269 16253 348 2.135922 7.43300856 Synura synuroidea 47573 SAR_Eukaryotes SAR_Eukaryotes 117 9.57e-32   NR NP_038183.1 47573 g15848 i0 86.5 1.26724137931034 74 10 63.8 0 344 123 1 74 NP_038183.1 ATP synthase F0 subunit 9 [Synura synuroidea] diamond 441 117 1 Eukaryota Sar     Synurophyceae Synurales Mallomonadaceae Synura Synura synuroidea
30760129 30760129 PRJEB39269_P_NODE_88554_length_152_cov_1.451327_g88149_i0 PRJEB39269 88554 152 1.451327 2.20601704 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 52 1.45e-6   NR KAJ1439767.1 483371 g88149 i0 48.9 0.927631578947368 47 24 92.8 0 146 6 57 103 KAJ1439767.1 hypothetical protein B484DRAFT_443762 [Ochromonadaceae sp. CCMP2298] diamond 141 52 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
30911583 30911583 PRJEB39269_P_NODE_78674_length_159_cov_3.866667_g78269_i0 PRJEB39269 78674 159 3.866667 6.14800053 Aureococcus 44055 SAR_Eukaryotes SAR_Eukaryotes 50.8 1.62e-5   NR KAH8055084.1 44056 g78269 i0 96.3 2.0377358490566 27 1 50.9 0 158 78 638 664 KAH8055084.1 translation release factor [Aureococcus anophagefferens] diamond 324 50.8 1 Eukaryota Sar     Pelagophyceae Pelagomonadales Pelagomonadaceae Aureococcus Aureococcus anophagefferens
31265656 31265656 PRJEB39269_P_NODE_89095_length_152_cov_0.938053_g88690_i0 PRJEB39269 89095 152 0.938053 1.42584056 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 51.6 7.97e-6   NR KAJ1437181.1 483371 g88690 i0 54.7 1.04605263157895 53 18 92.8 1 2 142 268 320 KAJ1437181.1 ferredoxin-dependent glutamate synthase [Ochromonadaceae sp. CCMP2298] diamond 159 51.6 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
31353996 31353996 PRJEB39269_P_NODE_81716_length_157_cov_3.423729_g81311_i0 PRJEB39269 81716 157 3.423729 5.37525453 Synura 2991 SAR_Eukaryotes SAR_Eukaryotes 53.1 1.19e-6   NR AYO28243.1 52556 g81311 i0 80.8 1.49044585987261 26 5 49.7 0 155 78 165 190 AYO28243.1 photosystem I subunit III [Synura sphagnicola] diamond 234 53.1 1 Eukaryota Sar     Synurophyceae Synurales Mallomonadaceae Synura Synura sphagnicola
32176631 32176631 PRJEB39269_P_NODE_58478_length_180_cov_1.744681_g58073_i0 PRJEB39269 58478 180 1.744681 3.1404258 root 1 Root_unresolved Root_unresolved 63.2 1.02e-9   NR CAH0369292.1 35677 g58073 i0 58.2 7.6 55 23 91.7 0 165 1 250 304 CAH0369292.1 unnamed protein product [Pelagomonas calceolata] diamond 1368 63.5 0.995275590551181 Eukaryota Sar     Pelagophyceae Pelagomonadales Pelagomonadaceae Pelagomonas Pelagomonas calceolata
32429643 32429643 PRJEB39269_P_NODE_87439_length_153_cov_1.298246_g87034_i0 PRJEB39269 87439 153 1.298246 1.98631638 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 87.8 6.72e-19   NR EWM27207.1 72520 g87034 i0 78.4 3 51 11 100 0 153 1 105 155 EWM27207.1 mitochondrial phosphate transporter [Nannochloropsis gaditana] diamond 459 87.8 1 Eukaryota Sar     Eustigmatophyceae Eustigmatales Monodopsidaceae Nannochloropsis Nannochloropsis gaditana
32468042 32468042 PRJEB39269_P_NODE_71179_length_167_cov_1.054688_g70774_i0 PRJEB39269 71179 167 1.054688 1.76132896 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 107 2.03e-28   NR KAJ1405287.1 483371 g70774 i0 87.3 0.988023952095808 55 7 98.8 0 3 167 68 122 KAJ1405287.1 plastid ferredoxin-NADP reductase, partial [Ochromonadaceae sp. CCMP2298] diamond 165 107 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
32688542 32688542 PRJEB39269_P_NODE_49160_length_196_cov_1.044586_g48755_i0 PRJEB39269 49160 196 1.044586 2.04738856 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 42 0.00509   NR XP_009842177.1 112090 g48755 i0 50 0.933673469387755 32 16 49 0 53 148 3 34 XP_009842177.1 hypothetical protein H257_15698 [Aphanomyces astaci] diamond 183 42 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci

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