RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

33 rows where bioproject = "PRJNA407886", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 33 ✖

tax_clade 1

  • Sar · 33 ✖

bioproject 1

  • PRJNA407886 · 33 ✖

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
417161 417161 PRJNA407886_P_NODE_31041_length_408_cov_1.835821_g29347_i0 PRJNA407886 31041 408 1.835821 7.49014968 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 132 7.75e-37   NR EJK75259.1 159749 g29347 i0 63.1 0.757352941176471 103 37 75 1 67 372 9 111 EJK75259.1 hypothetical protein THAOC_03022 [Thalassiosira oceanica] diamond 309 132 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
4244551 4244551 PRJNA407886_P_NODE_45444_length_322_cov_1.004016_g43750_i0 PRJNA407886 45444 322 1.004016 3.23293152 root 1 Root_unresolved Root_unresolved 171 1.0599999999999999e-48   NR GAX14462.1 1519565 g43750 i0 80.4 14.9347826086957 107 21 99.7 0 321 1 149 255 GAX14462.1 UDPglucose 6-dehydrogenase [Fistulifera solaris] diamond 4809 171 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
4245125 4245125 PRJNA407886_P_NODE_74584_length_247_cov_0.885057_g72890_i0 PRJNA407886 74584 247 0.885057 2.18609079 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 111 1.14e-26   NR KAL3760947.1 259834 g72890 i0 65 1.94331983805668 80 28 97.2 0 245 6 277 356 KAL3760947.1 hypothetical protein ACHAWU_009626 [Discostella pseudostelligera] diamond 480 111 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
5521367 5521367 PRJNA407886_P_NODE_50725_length_301_cov_2.881579_g49031_i0 PRJNA407886 50725 301 2.881579 8.67355279 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 156 4.22e-45   NR KAI2505670.1 210448 g49031 i0 73 1.99335548172757 100 27 99.7 0 2 301 6 105 KAI2505670.1 small subunit ribosomal protein [Fragilaria crotonensis] diamond 600 157 0.993630573248408 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
10621651 10621651 PRJNA407886_P_NODE_58429_length_278_cov_3.526829_g56735_i0 PRJNA407886 58429 278 3.526829 9.80458462 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 136 6.899999999999999e-38   NR CAJ1950794.1 2856 g56735 i0 77.8 4.43525179856115 81 18 87.4 0 36 278 69 149 CAJ1950794.1 unnamed protein product [Cylindrotheca closterium] diamond 1233 136 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
11895624 11895624 PRJNA407886_P_NODE_13330_length_792_cov_2.489569_g11819_i0 PRJNA407886 13330 792 2.489569 19.71738648 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 350 1.3599999999999998e-119   NR XP_002181180.1 556484 g11819 i0 79.2 7.48106060606061 212 44 80.3 0 13 648 6 217 XP_002181180.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 5925 350 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
11896823 11896823 PRJNA407886_P_NODE_68930_length_252_cov_1.720670_g67236_i0 PRJNA407886 68930 252 1.72067 4.3360884 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 126 3.0599999999999996e-32   NR KAG7341965.1 303405 g67236 i0 75 7.53571428571429 80 19 95.2 1 251 12 325 403 KAG7341965.1 preprotein translocase subunit Sec& domain containing protein [Nitzschia inconspicua] diamond 1899 127 0.992125984251969 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
18268931 18268931 PRJNA407886_P_NODE_38915_length_352_cov_2.347670_g37221_i0 PRJNA407886 38915 352 2.34767 8.2637984 root 1 Root_unresolved Root_unresolved 188 8.66e-59   NR XP_002288188.1 296543 g37221 i0 72.7 17.9318181818182 110 30 93.8 0 1 330 59 168 XP_002288188.1 rieske iron-sulfur protein 1, partial [Thalassiosira pseudonana CCMP1335] diamond 6312 188 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
24643173 24643173 PRJNA407886_P_NODE_11660_length_878_cov_3.623602_g10260_i0 PRJNA407886 11660 878 3.623602 31.81522556 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 438 5.819999999999999e-118   NTclustered gi|657012367|gb|KF302531.1| 2850 g10260 i0 88.462 59.1138952164009 364 40 41 2 238 600 23 385 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 51902 438 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
25308470 25308470 PRJNA407886_P_NODE_48680_length_309_cov_1.508475_g46986_i0 PRJNA407886 48680 309 1.508475 4.66118775 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 208 1.96e-60   NR KAI2512956.1 210448 g46986 i0 96.1 73 103 4 100 0 1 309 466 568 KAI2512956.1 Aconitate B N-terminal domain [Fragilaria crotonensis] diamond 22557 208 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
26600353 26600353 PRJNA407886_P_NODE_28561_length_432_cov_2.122563_g26868_i0 PRJNA407886 28561 432 2.122563 9.16947216 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 123 2.04e-30   NR XP_002178302.1 556484 g26868 i0 53.2 0.770833333333333 111 52 77.1 0 423 91 104 214 XP_002178302.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 333 123 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
26948855 26948855 PRJNA407886_P_NODE_59742_length_275_cov_1.371287_g58048_i0 PRJNA407886 59742 275 1.371287 3.77103925 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 151 4.04e-41   NR CAB9530945.1 568900 g58048 i0 79.1 2.97818181818182 91 19 99.3 0 3 275 380 470 CAB9530945.1 Malonate-semialdehyde dehydrogenase [Seminavis robusta] diamond 819 151 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27012161 27012161 PRJNA407886_P_NODE_34502_length_381_cov_0.961039_g32808_i0 PRJNA407886 34502 381 0.961039 3.66155859 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.0364   NR CAB9520060.1 568900 g32808 i0 65.4 0.204724409448819 26 9 20.5 0 10 87 14 39 CAB9520060.1 domain protein [Seminavis robusta] diamond 78 44.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
27408477 27408477 PRJNA407886_P_NODE_44863_length_324_cov_1.227092_g43169_i0 PRJNA407886 44863 324 1.227092 3.97577808 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 107 7.43e-25   NR KAL3799801.1 29204 g43169 i0 77.1 1.9537037037037 105 23 96.3 1 2 313 264 368 KAL3799801.1 hypothetical protein HJC23_010451 [Cyclotella cryptica] diamond 633 107 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
27833535 27833535 PRJNA407886_P_NODE_72844_length_248_cov_1.760000_g71150_i0 PRJNA407886 72844 248 1.76 4.3648 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 50.8 5.23e-5   NR KAL3938366.1 3061772 g71150 i0 48.3 0.725806451612903 60 29 70.2 1 248 75 270 329 KAL3938366.1 MAG: hypothetical protein SGBAC_006716 [Bacillariaceae sp.] diamond 180 50.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
27850132 27850132 PRJNA407886_P_NODE_62744_length_267_cov_1.587629_g61050_i0 PRJNA407886 62744 267 1.587629 4.23896943 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 65.5 4.74e-10   NR KAL3804381.1 29204 g61050 i0 43.1 1.58426966292135 72 38 77.5 2 226 20 373 444 KAL3804381.1 hypothetical protein HJC23_011309 [Cyclotella cryptica] diamond 423 65.9 0.993930197268589 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
27865022 27865022 PRJNA407886_P_NODE_36085_length_370_cov_0.794613_g34391_i0 PRJNA407886 36085 370 0.794613 2.9400681 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 163 9.25e-45   NR KAL3780902.1 2934178 g34391 i0 65.6 1.97837837837838 122 42 98.9 0 370 5 46 167 KAL3780902.1 hypothetical protein ACHAW5_010737 [Stephanodiscus triporus] diamond 732 163 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
28023154 28023154 PRJNA407886_P_NODE_48345_length_310_cov_1.797468_g46651_i0 PRJNA407886 48345 310 1.797468 5.5721508 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 70.9 3.13e-13   NR AID23596.1 2850 g46651 i0 48.7 0.735483870967742 76 39 73.5 0 306 79 42 117 AID23596.1 putative voltage-dependent anion-selective channel protein, partial [Phaeodactylum tricornutum] diamond 228 70.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
28054536 28054536 PRJNA407886_P_NODE_48985_length_308_cov_1.310638_g47291_i0 PRJNA407886 48985 308 1.310638 4.03676504 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 69.7 1.67e-11   NR KAI2499099.1 210448 g47291 i0 41.7 2.00649350649351 103 55 97.4 3 301 2 82 182 KAI2499099.1 hypothetical protein MHU86_15369 [Fragilaria crotonensis] diamond 618 69.7 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28875554 28875554 PRJNA407886_P_NODE_63648_length_265_cov_1.255208_g61954_i0 PRJNA407886 63648 265 1.255208 3.3263012 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 111 2.9200000000000003e-26   NR GFH53639.1 426638 g61954 i0 59.1 0.99622641509434 88 36 99.6 0 264 1 483 570 GFH53639.1 hypothetical protein CTEN210_10115 [Chaetoceros tenuissimus] diamond 264 111 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
29223072 29223072 PRJNA407886_P_NODE_71349_length_250_cov_0.870056_g69655_i0 PRJNA407886 71349 250 0.870056 2.17514 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 72.8 1.02e-12   NR KAI2512337.1 210448 g69655 i0 61.3 0.744 62 24 74.4 0 228 43 184 245 KAI2512337.1 RNA binding-protein [Fragilaria crotonensis] diamond 186 72.8 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29776172 29776172 PRJNA407886_P_NODE_43611_length_329_cov_1.800781_g41917_i0 PRJNA407886 43611 329 1.800781 5.92456949 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 85.5 6.72e-17   NR KAL3809872.1 382380 g41917 i0 48.5 3.88449848024316 101 45 85.7 3 306 25 6 106 KAL3809872.1 hypothetical protein ACHAXA_001297 [Cyclostephanos tholiformis] diamond 1278 86.3 0.990730011587486 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
30597555 30597555 PRJNA407886_P_NODE_79233_length_243_cov_0.905882_g77539_i0 PRJNA407886 79233 243 0.905882 2.20129326 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 104 3.689999999999999e-24   NR GFH59800.1 426638 g77539 i0 53.2 2.92592592592593 79 37 97.5 0 239 3 187 265 GFH59800.1 molecular chaperone DnaJ [Chaetoceros tenuissimus] diamond 711 104 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
31008462 31008462 PRJNA407886_P_NODE_50434_length_302_cov_3.454148_g48740_i0 PRJNA407886 50434 302 3.454148 10.43152696 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 76.3 1.19e-14   NR GFH57373.1 426638 g48740 i0 52.9 1.72847682119205 87 41 86.4 0 3 263 106 192 GFH57373.1 hypothetical protein CTEN210_13849 [Chaetoceros tenuissimus] diamond 522 76.6 0.996083550913838 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
31592698 31592698 PRJNA407886_P_NODE_54056_length_291_cov_1.408257_g52362_i0 PRJNA407886 54056 291 1.408257 4.09802787 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 57.8 3.32e-7   NR KAK1735154.1 267567 g52362 i0 37 0.948453608247423 92 53 89.7 2 287 27 464 555 KAK1735154.1 hypothetical protein QTG54_014220 [Skeletonema marinoi] diamond 276 57.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
31624069 31624069 PRJNA407886_P_NODE_42256_length_335_cov_1.721374_g40562_i0 PRJNA407886 42256 335 1.721374 5.7666029 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 107 9.14e-25   NR KAI2503849.1 210448 g40562 i0 49.1 0.985074626865672 110 54 98.5 1 335 6 297 404 KAI2503849.1 RNA binding-protein [Fragilaria crotonensis] diamond 330 107 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
31624085 31624085 PRJNA407886_P_NODE_65956_length_259_cov_1.655914_g64262_i0 PRJNA407886 65956 259 1.655914 4.28881726 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 129 5.04e-33   NR XP_002295853.1 296543 g64262 i0 70.9 2.75675675675676 79 23 91.5 0 254 18 381 459 XP_002295853.1 predicted protein [Thalassiosira pseudonana CCMP1335] diamond 714 129 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
31719037 31719037 PRJNA407886_P_NODE_81337_length_241_cov_0.916667_g79643_i0 PRJNA407886 81337 241 0.916667 2.20916747 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 131 1.59e-37   NR GFH59340.1 426638 g79643 i0 78.8 10.954356846473 80 17 99.6 0 240 1 9 88 GFH59340.1 ribosomal protein S17 component of cytosolic 80S ribosome and 40S small subunit [Chaetoceros tenuissimus] diamond 2640 131 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
31782108 31782108 PRJNA407886_P_NODE_68137_length_254_cov_1.701657_g66443_i0 PRJNA407886 68137 254 1.701657 4.32220878 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 84.7 1.14e-17   NR XP_002296525.1 296543 g66443 i0 48.2 1.00393700787402 85 38 95.7 2 254 12 68 150 XP_002296525.1 hypothetical protein THAPSDRAFT_269557 [Thalassiosira pseudonana CCMP1335] diamond 255 84.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
31940276 31940276 PRJNA407886_P_NODE_48097_length_311_cov_1.852941_g46403_i0 PRJNA407886 48097 311 1.852941 5.76264651 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 77.4 5.58e-14   NR GFH53639.1 426638 g46403 i0 45.3 0.829581993569132 86 47 83 0 54 311 357 442 GFH53639.1 hypothetical protein CTEN210_10115 [Chaetoceros tenuissimus] diamond 258 77.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
31972069 31972069 PRJNA407886_P_NODE_82718_length_236_cov_2.895706_g81024_i0 PRJNA407886 82718 236 2.895706 6.83386616 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 81.6 6.4e-16   NR GFH57686.1 426638 g81024 i0 44.9 0.991525423728814 78 43 99.2 0 2 235 138 215 GFH57686.1 hypothetical protein CTEN210_14162 [Chaetoceros tenuissimus] diamond 234 81.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
32225338 32225338 PRJNA407886_P_NODE_71118_length_250_cov_0.870056_g69424_i0 PRJNA407886 71118 250 0.870056 2.17514 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 51.2 3.36e-5   NR GFH58596.1 426638 g69424 i0 56.1 0.492 41 15 49.2 1 198 76 209 246 GFH58596.1 hypothetical protein CTEN210_15072 [Chaetoceros tenuissimus] diamond 123 51.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
32478604 32478604 PRJNA407886_P_NODE_81019_length_241_cov_1.833333_g79325_i0 PRJNA407886 81019 241 1.833333 4.41833253 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 74.7 2.04e-13   NR KAL3791062.1 382360 g79325 i0 48.8 1.99170124481328 80 29 99.6 1 241 2 792 859 KAL3791062.1 hypothetical protein ACHAWO_013015 [Cyclotella atomus] diamond 480 74.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus

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