RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

30 rows where bioproject = "PRJNA270367", 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 · 30 ✖

tax_clade 1

  • Sar · 30 ✖

bioproject 1

  • PRJNA270367 · 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
2920535 2920535 PRJNA270367_P_NODE_15163_length_328_cov_1.118280_g14958_i0 PRJNA270367 15163 328 1.11828 3.6679584 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 170 6.81e-49   NR GKZ00697.1 2872254 g14958 i0 77.1 25.9207317073171 109 25 99.7 0 328 2 157 265 GKZ00697.1 translation initiation factor eIF4A [Mayamaea pseudoterrestris] diamond 8502 170 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
5473581 5473581 PRJNA270367_P_NODE_5725_length_571_cov_1.425287_g5533_i0 PRJNA270367 5725 571 1.425287 8.13838877 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 267 1.85e-66   NTclustered gi|657012367|gb|KF302531.1| 2850 g5533 i0 88.636 9.81611208406305 220 23 38 2 350 568 393 175 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 5605 267 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
6747952 6747952 PRJNA270367_P_NODE_8706_length_454_cov_2.748148_g8507_i0 PRJNA270367 8706 454 2.748148 12.47659192 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 146 1.96e-42   NR AID23594.1 2850 g8507 i0 78.3 1.18942731277533 92 20 60.8 0 452 177 6 97 AID23594.1 ubiquitin-ribosomal protein fusion S27a, partial [Phaeodactylum tricornutum] diamond 540 146 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
8023590 8023590 PRJNA270367_P_NODE_6687_length_524_cov_2.366316_g6491_i0 PRJNA270367 6687 524 2.366316 12.39949584 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 276 7.51e-91   NR KAG7353846.1 303405 g6491 i0 79.9 9.36641221374046 164 32 93.3 1 3 491 43 206 KAG7353846.1 30S ribosomal protein S2 [Nitzschia inconspicua] diamond 4908 278 0.992805755395683 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
11848800 11848800 PRJNA270367_P_NODE_42830_length_166_cov_0.888889_g42625_i0 PRJNA270367 42830 166 0.888889 1.47555574 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 75.5 4.19e-15   NR CAB9526708.1 568900 g42625 i0 79.1 8.09638554216867 43 9 77.7 0 3 131 154 196 CAB9526708.1 cis-trans isomerase [Seminavis robusta] diamond 1344 75.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
16947634 16947634 PRJNA270367_P_NODE_8894_length_449_cov_1.815000_g8695_i0 PRJNA270367 8894 449 1.815 8.14935 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 130 3.18e-35   NR KAL3823683.1 382380 g8695 i0 73.3 4.59688195991091 86 23 57.5 0 449 192 79 164 KAL3823683.1 hypothetical protein ACHAXA_007254 [Cyclostephanos tholiformis] diamond 2064 131 0.99236641221374 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
19496043 19496043 PRJNA270367_P_NODE_36056_length_180_cov_1.190840_g35851_i0 PRJNA270367 36056 180 1.19084 2.143512 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 106 2.62e-26   NR CAJ1931814.1 2856 g35851 i0 86.7 5 60 8 100 0 180 1 61 120 CAJ1931814.1 unnamed protein product [Cylindrotheca closterium] diamond 900 107 0.990654205607477 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
20771636 20771636 PRJNA270367_P_NODE_44017_length_164_cov_2.060870_g43812_i0 PRJNA270367 44017 164 2.06087 3.3798268 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 94 1.14e-20   NR CAJ1935314.1 2856 g43812 i0 81.5 128.341463414634 54 10 98.8 0 162 1 202 255 CAJ1935314.1 unnamed protein product [Cylindrotheca closterium] diamond 21048 94.4 0.995762711864407 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
26694116 26694116 PRJNA270367_P_NODE_37081_length_176_cov_1.637795_g36876_i0 PRJNA270367 37081 176 1.637795 2.8825192 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 53.1 3.17e-6   NR KAK1741741.1 267567 g36876 i0 61.4 3.03409090909091 44 17 75 0 40 171 280 323 KAK1741741.1 60S ribosomal protein L23a [Skeletonema marinoi] diamond 534 53.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
26884362 26884362 PRJNA270367_P_NODE_32481_length_193_cov_1.444444_g32276_i0 PRJNA270367 32481 193 1.444444 2.78777692 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 57 1.83e-7   NR EJK74586.1 159749 g32276 i0 46.2 1.01036269430052 65 32 96.4 3 2 187 441 505 EJK74586.1 hypothetical protein THAOC_03725 [Thalassiosira oceanica] diamond 195 57 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
27263816 27263816 PRJNA270367_P_NODE_34383_length_186_cov_1.153285_g34178_i0 PRJNA270367 34383 186 1.153285 2.1451101 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 54.7 7.53e-7   NR KAG7368691.1 303405 g34178 i0 48.1 0.838709677419355 52 27 83.9 0 178 23 173 224 KAG7368691.1 thymidylate kinase [Nitzschia inconspicua] diamond 156 54.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27281536 27281536 PRJNA270367_P_NODE_38123_length_173_cov_1.258065_g37918_i0 PRJNA270367 38123 173 1.258065 2.17645245 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 60.1 2.54e-9   NR KAL3788401.1 382360 g37918 i0 68.3 2.84393063583815 41 13 71.1 0 173 51 100 140 KAL3788401.1 hypothetical protein ACHAWO_008098 [Cyclotella atomus] diamond 492 60.5 0.993388429752066 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
27344849 27344849 PRJNA270367_P_NODE_35263_length_183_cov_1.164179_g35058_i0 PRJNA270367 35263 183 1.164179 2.13044757 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 93.2 2.78e-20   NR VEU35041.1 183589 g35058 i0 71.7 2.95081967213115 60 17 98.4 0 2 181 272 331 VEU35041.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 540 93.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
27755409 27755409 PRJNA270367_P_NODE_35104_length_183_cov_1.940299_g34899_i0 PRJNA270367 35104 183 1.940299 3.55074717 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 87.4 8.07e-20   NR CAB9513765.1 568900 g34899 i0 87.8 3.21311475409836 49 6 80.3 0 1 147 126 174 CAB9513765.1 40S ribosomal protein S13 [Seminavis robusta] diamond 588 87.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28179222 28179222 PRJNA270367_P_NODE_33866_length_188_cov_1.122302_g33661_i0 PRJNA270367 33866 188 1.122302 2.10992776 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 46.6 1.46e-4   NR OEU20465.1 635003 g33661 i0 43.9 0.654255319148936 41 22 63.8 1 60 179 4 44 OEU20465.1 hypothetical protein FRACYDRAFT_163976, partial [Fragilariopsis cylindrus CCMP1102] diamond 123 46.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
28274074 28274074 PRJNA270367_P_NODE_42786_length_166_cov_0.888889_g42581_i0 PRJNA270367 42786 166 0.888889 1.47555574 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 51.6 9.46e-6   NR CAB9525163.1 568900 g42581 i0 49 0.885542168674699 49 24 88.6 1 161 15 570 617 CAB9525163.1 Type III pantothenate kinase [Seminavis robusta] diamond 147 51.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28305747 28305747 PRJNA270367_P_NODE_16886_length_304_cov_1.439216_g16681_i0 PRJNA270367 16886 304 1.439216 4.37521664 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 128 5.27e-35   NR KAL3775733.1 382360 g16681 i0 70.3 4.98355263157895 101 30 99.7 0 1 303 59 159 KAL3775733.1 hypothetical protein ACHAWO_000819 [Cyclotella atomus] diamond 1515 128 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
28747790 28747790 PRJNA270367_P_NODE_12927_length_364_cov_1.606349_g12723_i0 PRJNA270367 12927 364 1.606349 5.84711036 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 59.3 2.19e-7   NR KAL3761494.1 259834 g12723 i0 34.4 1.39285714285714 96 45 79.1 2 21 308 272 349 KAL3761494.1 hypothetical protein ACHAWU_006524 [Discostella pseudostelligera] diamond 507 59.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
29902311 29902311 PRJNA270367_P_NODE_25451_length_227_cov_1.455056_g25246_i0 PRJNA270367 25451 227 1.455056 3.30297712 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 77.4 5.25e-16   NR EJK53176.1 159749 g25246 i0 52.4 6.81938325991189 63 30 83.3 0 6 194 46 108 EJK53176.1 hypothetical protein THAOC_27443, partial [Thalassiosira oceanica] diamond 1548 77.8 0.994858611825193 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
30073891 30073891 PRJNA270367_P_NODE_12932_length_364_cov_1.326984_g12728_i0 PRJNA270367 12932 364 1.326984 4.83022176 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 79.7 1.69e-14   NR GFH51868.1 426638 g12728 i0 37.2 0.931318681318681 113 67 89.8 3 363 37 787 899 GFH51868.1 beta subunit of tetrameric clathrin adaptor complex AP1 [Chaetoceros tenuissimus] diamond 339 79.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30516349 30516349 PRJNA270367_P_NODE_19773_length_272_cov_1.641256_g19568_i0 PRJNA270367 19773 272 1.641256 4.46421632 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 92 2.44e-19   NR CAB9506076.1 568900 g19568 i0 53.1 0.893382352941177 81 36 87.1 2 271 35 546 626 CAB9506076.1 Squalene--hopene cyclase [Seminavis robusta] diamond 243 92 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30769241 30769241 PRJNA270367_P_NODE_40674_length_168_cov_0.873950_g40469_i0 PRJNA270367 40674 168 0.87395 1.468236 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 65.5 1.23e-10   NR EJK59677.1 159749 g40469 i0 55.8 8.96428571428571 52 23 92.9 0 13 168 59 110 EJK59677.1 hypothetical protein THAOC_20072 [Thalassiosira oceanica] diamond 1506 65.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
30832315 30832315 PRJNA270367_P_NODE_5034_length_609_cov_2.212500_g4843_i0 PRJNA270367 5034 609 2.2125 13.474125 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 234 7.22e-69   NR CAB9497952.1 568900 g4843 i0 57.7 3.97044334975369 201 83 99 2 604 2 443 641 CAB9497952.1 3-hydroxyacyl-CoA dehydratase 2 [Seminavis robusta] diamond 2418 234 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30863827 30863827 PRJNA270367_P_NODE_10674_length_406_cov_1.369748_g10472_i0 PRJNA270367 10674 406 1.369748 5.56117688 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 65.5 2.88e-10   NR KAL3770335.1 259834 g10472 i0 38.6 1.22660098522167 83 51 61.3 0 149 397 78 160 KAL3770335.1 hypothetical protein ACHAWU_003555 [Discostella pseudostelligera] diamond 498 65.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
31243042 31243042 PRJNA270367_P_NODE_32275_length_194_cov_1.206897_g32070_i0 PRJNA270367 32275 194 1.206897 2.34138018 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 49.7 1.39e-5   NR AID23596.1 2850 g32070 i0 45.5 0.850515463917526 55 30 85.1 0 29 193 51 105 AID23596.1 putative voltage-dependent anion-selective channel protein, partial [Phaeodactylum tricornutum] diamond 165 49.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
31337899 31337899 PRJNA270367_P_NODE_10356_length_413_cov_1.412088_g10154_i0 PRJNA270367 10356 413 1.412088 5.83192344 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.033   NR CAB9514451.1 568900 g10154 i0 46.2 0.283292978208232 39 21 28.3 0 404 288 84 122 CAB9514451.1 EFh [Seminavis robusta] diamond 117 44.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31369862 31369862 PRJNA270367_P_NODE_31396_length_198_cov_0.953020_g31191_i0 PRJNA270367 31396 198 0.95302 1.8869796 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 57.4 1.08e-7   NR GAX25320.1 1519565 g31191 i0 45.9 0.924242424242424 61 30 92.4 1 8 190 143 200 GAX25320.1 hypothetical protein FisN_5Lh411 [Fistulifera solaris] diamond 183 57.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
32065484 32065484 PRJNA270367_P_NODE_35478_length_182_cov_1.187970_g35273_i0 PRJNA270367 35478 182 1.18797 2.1621054 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 76.3 2.5e-14   NR KAG7348810.1 303405 g35273 i0 59.6 2.73626373626374 57 23 94 0 1 171 500 556 KAG7348810.1 multidrug ABC transporter ATPase [Nitzschia inconspicua] diamond 498 76.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
32178406 32178406 PRJNA270367_P_NODE_27418_length_216_cov_1.862275_g27213_i0 PRJNA270367 27418 216 1.862275 4.022514 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 97.8 3.64e-24   NR CAJ1944271.1 2856 g27213 i0 61.1 9.61111111111111 72 26 97.2 1 215 6 2 73 CAJ1944271.1 unnamed protein product [Cylindrotheca closterium] diamond 2076 98.6 0.991886409736308 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
32255793 32255793 PRJNA270367_P_NODE_32818_length_192_cov_1.090909_g32613_i0 PRJNA270367 32818 192 1.090909 2.09454528 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 50.4 3.43e-5   NR CAB9528313.1 568900 g32613 i0 52.2 0.71875 46 22 71.9 0 38 175 21 66 CAB9528313.1 MAP kinase-activated protein kinase 2 (Fragment) [Seminavis robusta] diamond 138 50.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta

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