RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where analysis = "diamond", bioproject = "PRJNA407368" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

  • Sar · 30 ✖

bioproject 1

  • PRJNA407368 · 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
2965841 2965841 PRJNA407368_S_NODE_4803_length_256_cov_3.590308_g4701_i0 PRJNA407368 4803 256 3.590308 9.19118848 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 136 1.06e-38   NR KAJ1431215.1 483371 g4701 i0 87.3 0.92578125 79 10 92.6 0 19 255 4 82 KAJ1431215.1 CRE-RPL-12 protein [Ochromonadaceae sp. CCMP2298] diamond 237 136 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
8068451 8068451 PRJNA407368_S_NODE_6907_length_200_cov_3.602339_g6805_i0 PRJNA407368 6907 200 3.602339 7.204678 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 131 3.93e-34   NR CAI2365993.1 5936 g6805 i0 97 0.99 66 2 99 0 3 200 13 78 CAI2365993.1 unnamed protein product [Moneuplotes crassus] diamond 198 131 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
16384151 16384151 PRJNA407368_S_NODE_8953_length_169_cov_2.078571_g8851_i0 PRJNA407368 8953 169 2.078571 3.51278499 Nannochloropsis salina CCMP1776 1027361 SAR_Eukaryotes SAR_Eukaryotes 90.9 2.51e-21   NR TFJ83947.1 1027361 g8851 i0 76.9 0.923076923076923 52 12 92.3 0 158 3 117 168 TFJ83947.1 hypothetical protein NSK_005042 [Nannochloropsis salina CCMP1776] diamond 156 90.9 1 Eukaryota Sar     Eustigmatophyceae Eustigmatales Monodopsidaceae Microchloropsis Microchloropsis salina
18266640 18266640 PRJNA407368_S_NODE_2475_length_387_cov_5.385475_g2373_i0 PRJNA407368 2475 387 5.385475 20.84178825 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 123 2.7099999999999997e-32   NR CAE7473169.1 2951 g2373 i0 78.4 1.13178294573643 74 16 57.4 0 13 234 131 204 CAE7473169.1 RPS8 [Symbiodinium microadriaticum] diamond 438 123 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
22091495 22091495 PRJNA407368_S_NODE_1638_length_491_cov_5.389610_g1543_i0 PRJNA407368 1638 491 5.38961 26.4629851 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 253 6.18e-84   NR KAJ1404383.1 483371 g1543 i0 91.5 0.867617107942974 142 12 86.8 0 456 31 1 142 KAJ1404383.1 hypothetical protein B484DRAFT_457346 [Ochromonadaceae sp. CCMP2298] diamond 426 253 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
26885818 26885818 PRJNA407368_S_NODE_10241_length_154_cov_1.944000_g10139_i0 PRJNA407368 10241 154 1.944 2.99376 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 84 2.15e-17   NR CAD8145797.1 43137 g10139 i0 76 0.974025974025974 50 12 97.4 0 3 152 133 182 CAD8145797.1 unnamed protein product [Paramecium octaurelia] diamond 150 84 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
26997083 26997083 PRJNA407368_S_NODE_1762_length_470_cov_6.850340_g1665_i0 PRJNA407368 1762 470 6.85034 32.196598 root 1 Root_unresolved Root_unresolved 46.2 0.0192   NR CAL1134645.1 2562237 g1665 i0 44.7 2.23404255319149 47 26 30 0 465 325 196 242 CAL1134645.1 unnamed protein product [Cladocopium goreaui] diamond 1050 46.2 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Cladocopium Cladocopium goreaui
27218336 27218336 PRJNA407368_S_NODE_2182_length_415_cov_9.352332_g2081_i0 PRJNA407368 2182 415 9.352332 38.8121778 Ectocarpus 2879 SAR_Eukaryotes SAR_Eukaryotes 47 0.00704   NR CBN79344.1 2880 g2081 i0 55 0.867469879518072 40 15 26.7 1 2 112 389 428 CBN79344.1 conserved unknown protein [Ectocarpus siliculosus] diamond 360 47 1 Eukaryota Sar     Phaeophyceae Ectocarpales Ectocarpaceae Ectocarpus Ectocarpus siliculosus
27675949 27675949 PRJNA407368_S_NODE_2484_length_386_cov_4.890756_g2382_i0 PRJNA407368 2484 386 4.890756 18.87831816 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 87 1.6e-19   NR KAJ1408747.1 483371 g2382 i0 50.5 0.707253886010363 91 38 69.9 2 113 382 1 85 KAJ1408747.1 hypothetical protein B484DRAFT_456236 [Ochromonadaceae sp. CCMP2298] diamond 273 87 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
27833478 27833478 PRJNA407368_S_NODE_5984_length_220_cov_2.916230_g5882_i0 PRJNA407368 5984 220 2.91623 6.415706 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 127 2.12e-35   NR KAJ1419568.1 483371 g5882 i0 82.2 1.99090909090909 73 13 99.5 0 219 1 35 107 KAJ1419568.1 anion-transporting ATPase-domain-containing protein, partial [Ochromonadaceae sp. CCMP2298] diamond 438 127 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
28307199 28307199 PRJNA407368_S_NODE_1726_length_475_cov_16.056054_g1630_i0 PRJNA407368 1726 475 16.056054 76.2662565 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 268 2.349999999999999e-87   NR KAJ1409151.1 483371 g1630 i0 85.4 0.991578947368421 157 23 99.2 0 2 472 74 230 KAJ1409151.1 P-loop containing nucleoside triphosphate hydrolase protein [Ochromonadaceae sp. CCMP2298] diamond 471 268 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
28875490 28875490 PRJNA407368_S_NODE_5488_length_233_cov_3.651961_g5386_i0 PRJNA407368 5488 233 3.651961 8.50906913 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 87.4 3.59e-18   NR CAI2365923.1 5936 g5386 i0 52.6 0.978540772532189 76 35 96.6 1 227 3 178 253 CAI2365923.1 unnamed protein product [Moneuplotes crassus] diamond 228 87.4 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
29065062 29065062 PRJNA407368_S_NODE_5948_length_221_cov_2.406250_g5846_i0 PRJNA407368 5948 221 2.40625 5.3178125 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 79 1.97e-15   NR KAJ1441150.1 483371 g5846 i0 62.1 1.54751131221719 58 22 78.7 0 46 219 167 224 KAJ1441150.1 F1 complex, gamma subunit of ATPase [Ochromonadaceae sp. CCMP2298] diamond 342 79 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
29254163 29254163 PRJNA407368_S_NODE_6189_length_216_cov_1.657754_g6087_i0 PRJNA407368 6189 216 1.657754 3.58074864 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 95.1 3.19e-23   NR KAJ1426609.1 483371 g6087 i0 76.1 0.986111111111111 71 16 97.2 1 214 5 35 105 KAJ1426609.1 ribosomal L29 protein-domain-containing protein [Ochromonadaceae sp. CCMP2298] diamond 213 95.1 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
29317492 29317492 PRJNA407368_S_NODE_2109_length_424_cov_6.288608_g2008_i0 PRJNA407368 2109 424 6.288608 26.66369792 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 131 1.31e-35   NR KAJ1424879.1 483371 g2008 i0 82.7 0.530660377358491 75 13 53.1 0 227 3 70 144 KAJ1424879.1 ribosomal L18ae/LX protein domain-containing protein [Ochromonadaceae sp. CCMP2298] diamond 225 131 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
29443603 29443603 PRJNA407368_S_NODE_9450_length_162_cov_4.330827_g9348_i0 PRJNA407368 9450 162 4.330827 7.01593974 Triparma columacea 722753 SAR_Eukaryotes SAR_Eukaryotes 76.6 4.31e-15   NR GMI25974.1 722753 g9348 i0 59.2 0.907407407407407 49 20 90.7 0 2 148 216 264 GMI25974.1 hypothetical protein TrCOL_g4598 [Triparma columacea] diamond 147 76.6 1 Eukaryota Sar     Bolidophyceae Parmales Triparmaceae Triparma Triparma columacea
29632887 29632887 PRJNA407368_S_NODE_2930_length_348_cov_2.943574_g2828_i0 PRJNA407368 2930 348 2.943574 10.24363752 Ochromonas danica 2986 SAR_Eukaryotes SAR_Eukaryotes 63.2 1.62e-9   NR NP_066437.1 2986 g2828 i0 43.4 0.655172413793103 76 43 65.5 0 344 117 103 178 NP_066437.1 ribosomal protein L6 [Ochromonas danica] diamond 228 63.2 1 Eukaryota Sar     Chrysophyceae Chromulinales Chromulinaceae Ochromonas Ochromonas danica
29980715 29980715 PRJNA407368_S_NODE_1171_length_584_cov_10.252252_g1092_i0 PRJNA407368 1171 584 10.252252 59.87315168 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 182 2.77e-51   NR KAJ1433327.1 483371 g1092 i0 49.7 0.878424657534247 171 86 87.8 0 523 11 321 491 KAJ1433327.1 hypothetical protein B484DRAFT_360090, partial [Ochromonadaceae sp. CCMP2298] diamond 513 182 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
30138265 30138265 PRJNA407368_S_NODE_3972_length_291_cov_4.580153_g3870_i0 PRJNA407368 3972 291 4.580153 13.32824523 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 182 2.98e-57   NR CAE7665705.1 2951 g3870 i0 93.8 2 97 6 100 0 1 291 1 97 CAE7665705.1 atpD [Symbiodinium microadriaticum] diamond 582 182 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
30408415 30408415 PRJNA407368_S_NODE_9173_length_166_cov_2.357664_g9071_i0 PRJNA407368 9173 166 2.357664 3.91372224 root 1 Root_unresolved Root_unresolved 84.7 2.02e-19   NR NP_066444.1 2986 g9071 i0 83 3.39759036144578 47 8 84.9 0 24 164 47 93 NP_066444.1 ribosomal protein S12 [Ochromonas danica] diamond 564 84.7 1 Eukaryota Sar     Chrysophyceae Chromulinales Chromulinaceae Ochromonas Ochromonas danica
30580773 30580773 PRJNA407368_S_NODE_5373_length_236_cov_7.449275_g5271_i0 PRJNA407368 5373 236 7.449275 17.580289 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 96.7 3.01e-21   NR CAI2366155.1 5936 g5271 i0 87.3 1.5635593220339 63 8 80.1 0 219 31 195 257 CAI2366155.1 unnamed protein product [Moneuplotes crassus] diamond 369 96.7 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
30865263 30865263 PRJNA407368_S_NODE_9494_length_162_cov_2.578947_g9392_i0 PRJNA407368 9494 162 2.578947 4.17789414 Euplotes vannus 5939 SAR_Eukaryotes SAR_Eukaryotes 72.4 2.61e-14   NR CAH04404.1 5939 g9392 i0 73.2 0.759259259259259 41 11 75.9 0 123 1 1 41 CAH04404.1 ribosomal protein S13 [Euplotes vannus] diamond 123 72.4 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes vannus
30991836 30991836 PRJNA407368_S_NODE_7614_length_187_cov_3.651899_g7512_i0 PRJNA407368 7614 187 3.651899 6.82905113 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 55.5 3.28e-7   NR KAJ1425508.1 483371 g7512 i0 61.3 0.994652406417112 62 20 99.5 2 1 186 134 191 KAJ1425508.1 ribosomal protein S6, partial [Ochromonadaceae sp. CCMP2298] diamond 186 55.5 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
31212456 31212456 PRJNA407368_S_NODE_2035_length_434_cov_3.797531_g1935_i0 PRJNA407368 2035 434 3.797531 16.48128454 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 47.4 5.9e-4   NR GLD98057.1 114742 g1935 i0 42.3 1.6036866359447 52 30 35.9 0 246 91 1 52 GLD98057.1 hypothetical protein PINS_up006754 [Pythium insidiosum] diamond 696 47.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
31307701 31307701 PRJNA407368_S_NODE_2135_length_421_cov_2.543367_g2034_i0 PRJNA407368 2135 421 2.543367 10.70757507 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 110 2.3400000000000003e-27   NR KAJ1425447.1 483371 g2034 i0 61.6 0.612826603325416 86 33 61.3 0 263 6 16 101 KAJ1425447.1 aspartic peptidase domain-containing protein [Ochromonadaceae sp. CCMP2298] diamond 258 110 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
31434216 31434216 PRJNA407368_S_NODE_1936_length_445_cov_14.586538_g1836_i0 PRJNA407368 1936 445 14.586538 64.9100941 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 50.8 4.66e-4   NR CAG9323633.1 1481888 g1836 i0 42.9 0.330337078651685 49 26 33 1 69 215 118 164 CAG9323633.1 unnamed protein product [Blepharisma stoltei] diamond 147 50.8 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
31798725 31798725 PRJNA407368_S_NODE_2917_length_348_cov_8.068966_g2815_i0 PRJNA407368 2917 348 8.068966 28.08000168 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 134 1.04e-33   NR CBN74485.1 2880 g2815 i0 54 11.2672413793103 113 52 97.4 0 4 342 2498 2610 CBN74485.1 dynein heavy chain [Ectocarpus siliculosus] diamond 3921 134 1 Eukaryota Sar     Phaeophyceae Ectocarpales Ectocarpaceae Ectocarpus Ectocarpus siliculosus
31893804 31893804 PRJNA407368_S_NODE_5937_length_221_cov_3.171875_g5835_i0 PRJNA407368 5937 221 3.171875 7.00984375 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 84 1.55e-17   NR TFJ83676.1 1027361 g5835 i0 64.8 2.36199095022624 54 19 73.3 0 220 59 203 256 TFJ83676.1 hypothetical protein NSK_004780 [Nannochloropsis salina CCMP1776] diamond 522 84 1 Eukaryota Sar     Eustigmatophyceae Eustigmatales Monodopsidaceae Microchloropsis Microchloropsis salina
32003744 32003744 PRJNA407368_S_NODE_10458_length_152_cov_1.878049_g10356_i0 PRJNA407368 10458 152 1.878049 2.85463448 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 41.2 0.038   NR KAJ1412133.1 483371 g10356 i0 54.1 0.730263157894737 37 16 73 1 150 40 181 216 KAJ1412133.1 major facilitator superfamily domain-containing protein [Ochromonadaceae sp. CCMP2298] diamond 111 41.2 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
32856497 32856497 PRJNA407368_S_NODE_7820_length_184_cov_2.645161_g7718_i0 PRJNA407368 7820 184 2.645161 4.86709624 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 79 2.96e-15   NR CAG9323272.1 1481888 g7718 i0 62.3 2.98369565217391 61 23 99.5 0 184 2 780 840 CAG9323272.1 unnamed protein product [Blepharisma stoltei] diamond 549 79 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei

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