RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA399133" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

  • Sar · 23 ✖

bioproject 1

  • PRJNA399133 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
1688174 1688174 PRJNA399133_P_NODE_8402_length_181_cov_1.369863_g8314_i0 PRJNA399133 8402 181 1.369863 2.47945203 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 67.8 2e-12   NR KAJ1432303.1 483371 g8314 i0 82.1 3.23204419889503 39 7 64.6 0 181 65 110 148 KAJ1432303.1 ribosomal protein L27a [Ochromonadaceae sp. CCMP2298] diamond 585 67.8 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
2964013 2964013 PRJNA399133_P_NODE_4363_length_243_cov_1.346154_g4275_i0 PRJNA399133 4363 243 1.346154 3.27115422 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 135 1.81e-38   NR KAJ1431215.1 483371 g4275 i0 85.2 1 81 12 100 0 243 1 4 84 KAJ1431215.1 CRE-RPL-12 protein [Ochromonadaceae sp. CCMP2298] diamond 243 135 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
4240317 4240317 PRJNA399133_P_NODE_2664_length_306_cov_1.538745_g2576_i0 PRJNA399133 2664 306 1.538745 4.7085597 Tribonema minus 303371 SAR_Eukaryotes SAR_Eukaryotes 159 2.589999999999999e-47   NR KAG5181400.1 303371 g2576 i0 78 0.980392156862745 100 22 98 0 306 7 18 117 KAG5181400.1 hypothetical protein JKP88DRAFT_215280 [Tribonema minus] diamond 300 159 1 Eukaryota Sar     Xanthophyceae Tribonematales Tribonemataceae Tribonema Tribonema minus
11892158 11892158 PRJNA399133_P_NODE_7710_length_189_cov_1.155844_g7622_i0 PRJNA399133 7710 189 1.155844 2.18454516 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 98.6 3.76e-22   NR KAJ1421113.1 483371 g7622 i0 82.3 0.984126984126984 62 11 98.4 0 2 187 310 371 KAJ1421113.1 hypothetical protein B484DRAFT_433346 [Ochromonadaceae sp. CCMP2298] diamond 186 98.6 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
15108642 15108642 PRJNA399133_P_NODE_5952_length_216_cov_1.767956_g5864_i0 PRJNA399133 5952 216 1.767956 3.81878496 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 121 2.13e-33   NR CAE7811383.1 2951 g5864 i0 82.9 1.95833333333333 70 12 97.2 0 215 6 72 141 CAE7811383.1 RPL9 [Symbiodinium microadriaticum] diamond 423 121 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
26839215 26839215 PRJNA399133_P_NODE_3861_length_257_cov_1.261261_g3773_i0 PRJNA399133 3861 257 1.261261 3.24144077 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 93.6 1.14e-21   NR CAE7571277.1 2951 g3773 i0 56 2.2295719844358 91 32 96.9 2 255 7 86 176 CAE7571277.1 RPL6 [Symbiodinium microadriaticum] diamond 573 94.4 0.991525423728813 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
27233463 27233463 PRJNA399133_P_NODE_6003_length_215_cov_1.777778_g5915_i0 PRJNA399133 6003 215 1.777778 3.8222227 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 111 5.51e-30   NR KAJ1409643.1 483371 g5915 i0 73.5 1.93953488372093 68 18 94.9 0 211 8 21 88 KAJ1409643.1 ribosomal protein L35A [Ochromonadaceae sp. CCMP2298] diamond 417 111 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
27328397 27328397 PRJNA399133_P_NODE_9363_length_172_cov_1.306569_g9275_i0 PRJNA399133 9363 172 1.306569 2.24729868 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 95.9 1.8300000000000003e-21   NR KAJ1435900.1 483371 g9275 i0 73.7 0.994186046511628 57 15 99.4 0 171 1 297 353 KAJ1435900.1 hypothetical protein B484DRAFT_445870 [Ochromonadaceae sp. CCMP2298] diamond 171 95.9 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
27408447 27408447 PRJNA399133_P_NODE_12163_length_152_cov_1.299145_g12075_i0 PRJNA399133 12163 152 1.299145 1.9747004 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 48.9 1.79e-5   NR KAG5186919.1 303371 g12075 i0 68.3 4.04605263157895 41 13 80.9 0 1 123 84 124 KAG5186919.1 ribosomal L29 protein-domain-containing protein [Tribonema minus] diamond 615 49.3 0.991886409736308 Eukaryota Sar     Xanthophyceae Tribonematales Tribonemataceae Tribonema Tribonema minus
27454837 27454837 PRJNA399133_P_NODE_10923_length_160_cov_1.064000_g10835_i0 PRJNA399133 10923 160 1.064 1.7024 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 76.3 5.8e-16   NR KAJ1439392.1 483371 g10835 i0 73.1 0.975 52 14 97.5 0 3 158 4 55 KAJ1439392.1 60S ribosomal protein L26 [Ochromonadaceae sp. CCMP2298] diamond 156 76.3 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
27991520 27991520 PRJNA399133_P_NODE_11305_length_157_cov_1.967213_g11217_i0 PRJNA399133 11305 157 1.967213 3.08852441 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 89 9.63e-20   NR KAJ1424048.1 483371 g11217 i0 75 0.993630573248408 52 13 99.4 0 157 2 213 264 KAJ1424048.1 ubiquinol cytochrome c reductase cytochrome c1 prec [Ochromonadaceae sp. CCMP2298] diamond 156 89 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
28134560 28134560 PRJNA399133_P_NODE_4085_length_250_cov_1.488372_g3997_i0 PRJNA399133 4085 250 1.488372 3.72093 root 1 Root_unresolved Root_unresolved 135 1.8299999999999999e-38   NR KAJ1418183.1 483371 g3997 i0 79.3 1.824 82 17 98.4 0 3 248 68 149 KAJ1418183.1 ribosomal protein S17-domain-containing protein [Ochromonadaceae sp. CCMP2298] diamond 456 135 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
28418783 28418783 PRJNA399133_P_NODE_10346_length_164_cov_1.240310_g10258_i0 PRJNA399133 10346 164 1.24031 2.0341084 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0109   NR KAG5181306.1 303371 g10258 i0 51.3 2.08536585365854 39 19 71.3 0 161 45 168 206 KAG5181306.1 ribosomal protein L13e [Tribonema minus] diamond 342 42.7 1 Eukaryota Sar     Xanthophyceae Tribonematales Tribonemataceae Tribonema Tribonema minus
28450321 28450321 PRJNA399133_P_NODE_8186_length_183_cov_2.060811_g8098_i0 PRJNA399133 8186 183 2.060811 3.77128413 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 75.1 1.99e-15   NR KAL3762786.1 2934178 g8098 i0 61.7 1.9672131147541 60 23 98.4 0 3 182 67 126 KAL3762786.1 hypothetical protein ACHAW5_001314 [Stephanodiscus triporus] diamond 360 75.5 0.994701986754967 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
28513304 28513304 PRJNA399133_P_NODE_11507_length_156_cov_1.322314_g11419_i0 PRJNA399133 11507 156 1.322314 2.06280984 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 75.1 2.08e-15   NR ACT87562.1 581008 g11419 i0 64 7.71153846153846 50 18 96.2 0 151 2 1 50 ACT87562.1 40S ribosomal protein S13 [Amoebophrya sp. ex Karlodinium veneficum] diamond 1203 75.5 0.994701986754967 Eukaryota Sar     Dinophyceae Syndiniales Amoebophryaceae Amoebophrya Amoebophrya sp. ex Karlodinium veneficum
29949092 29949092 PRJNA399133_P_NODE_8791_length_177_cov_1.380282_g8703_i0 PRJNA399133 8791 177 1.380282 2.44309914 Ochromonas danica 2986 SAR_Eukaryotes SAR_Eukaryotes 67.8 1.97e-11   NR BAH60835.1 2986 g8703 i0 62.1 0.983050847457627 58 18 96.6 2 172 2 230 284 BAH60835.1 tubular mastigoneme protein [Ochromonas danica] diamond 174 67.8 1 Eukaryota Sar     Chrysophyceae Chromulinales Chromulinaceae Ochromonas Ochromonas danica
30502927 30502927 PRJNA399133_P_NODE_8233_length_183_cov_1.081081_g8145_i0 PRJNA399133 8233 183 1.081081 1.97837823 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 81.6 2.83e-17   NR CAE7438272.1 2951 g8145 i0 71.9 3.85245901639344 57 16 93.4 0 183 13 73 129 CAE7438272.1 RpL13 [Symbiodinium microadriaticum] diamond 705 82.4 0.990291262135922 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
30738827 30738827 PRJNA399133_P_NODE_10894_length_160_cov_1.424000_g10806_i0 PRJNA399133 10894 160 1.424 2.2784 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 106 1.88e-25   NR CAE7366645.1 2951 g10806 i0 90.6 0.99375 53 5 99.4 0 2 160 338 390 CAE7366645.1 NEW1 [Symbiodinium microadriaticum] diamond 159 106 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
30770654 30770654 PRJNA399133_P_NODE_2234_length_333_cov_1.859060_g2146_i0 PRJNA399133 2234 333 1.85906 6.1906698 Pfiesteria piscicida 71001 SAR_Eukaryotes SAR_Eukaryotes 157 5.73e-47   NR ACU45118.1 71001 g2146 i0 69.4 0.972972972972973 108 33 97.3 0 9 332 4 111 ACU45118.1 40s ribosomal protein s24e, partial [Pfiesteria piscicida] diamond 324 157 1 Eukaryota Sar     Dinophyceae Peridiniales Pfiesteriaceae Pfiesteria Pfiesteria piscicida
31276035 31276035 PRJNA399133_P_NODE_8895_length_176_cov_1.418440_g8807_i0 PRJNA399133 8895 176 1.41844 2.4964544 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 105 1.16e-26   NR KAJ1430068.1 483371 g8807 i0 82.8 0.988636363636364 58 10 98.9 0 2 175 149 206 KAJ1430068.1 ribosomal protein S3 [Ochromonadaceae sp. CCMP2298] diamond 174 105 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
31971932 31971932 PRJNA399133_P_NODE_4578_length_237_cov_2.341584_g4490_i0 PRJNA399133 4578 237 2.341584 5.54955408 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 124 3.36e-33   NR CAE7329454.1 2951 g4490 i0 75 1.0126582278481 80 19 100 1 237 1 148 227 CAE7329454.1 RPL7 [Symbiodinium microadriaticum] diamond 240 124 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
32035276 32035276 PRJNA399133_P_NODE_10038_length_166_cov_1.526718_g9950_i0 PRJNA399133 10038 166 1.526718 2.53435188 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 91.7 1.08e-21   NR KAJ1428270.1 483371 g9950 i0 79.6 0.885542168674699 49 10 88.6 0 166 20 116 164 KAJ1428270.1 ribosomal protein L5 domain-containing protein [Ochromonadaceae sp. CCMP2298] diamond 147 91.7 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
32762062 32762062 PRJNA399133_P_NODE_6840_length_201_cov_1.192771_g6752_i0 PRJNA399133 6840 201 1.192771 2.39746971 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 111 8.57e-29   NR GLE08433.1 114742 g6752 i0 77.3 1.97014925373134 66 15 98.5 0 200 3 48 113 GLE08433.1 hypothetical protein PINS_up019616 [Pythium insidiosum] diamond 396 111 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum

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