RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where bioproject = "PRJNA380660" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 22 ✖

tax_clade 1

bioproject 1

  • PRJNA380660 · 22 ✖

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
1677019 1677019 PRJNA380660_P_NODE_6982_length_278_cov_1.927711_g6582_i0 PRJNA380660 6982 278 1.927711 5.35903658 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 132 1.17e-37   NR CAJ1936351.1 2856 g6582 i0 74.4 12.6151079136691 78 20 84.2 0 43 276 6 83 CAJ1936351.1 unnamed protein product [Cylindrotheca closterium] diamond 3507 132 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
4229405 4229405 PRJNA380660_P_NODE_1504_length_690_cov_4.523449_g1197_i0 PRJNA380660 1504 690 4.523449 31.2117981 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 354 3.4299999999999995e-121   NR KAL3772391.1 259834 g1197 i0 79.2 14.7086956521739 212 44 92.2 0 26 661 33 244 KAL3772391.1 hypothetical protein ACHAWU_005568 [Discostella pseudostelligera] diamond 10149 354 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
4902183 4902183 PRJNA380660_P_NODE_7024_length_276_cov_15.834008_g6624_i0 PRJNA380660 7024 276 15.834008 43.70186208 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 414 2.81e-111   NTclustered gi|98978883|gb|DQ512402.1| 29205 g6624 i0 96.109 92.5869565217391 257 5 93 2 20 276 115 366 Cyclotella menegheniana strain F8 large subunit ribosomal RNA gene, partial sequence blastn 25554 414 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
6779961 6779961 PRJNA380660_P_NODE_10046_length_206_cov_333.847458_g9646_i0 PRJNA380660 10046 206 333.847458 687.72576348 Attheya ussurensis 451787 SAR_Eukaryotes SAR_Eukaryotes 161 2.87e-35   NTclustered gi|1569270389|gb|MH367507.1| 451787 g9646 i0 92.793 54.5873786407767 111 8 54 0 53 163 386 496 Attheya ussurensis strain MBRU_AU-01 28S ribosomal RNA gene, partial sequence blastn 11245 161 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Attheyaceae Attheya Attheya ussurensis
6779965 6779965 PRJNA380660_P_NODE_12246_length_163_cov_7.716418_g11846_i0 PRJNA380660 12246 163 7.716418 12.57776134 Stephanocyclus meneghinianus 29205 SAR_Eukaryotes SAR_Eukaryotes 292 7.35e-75   NTclustered gi|1169296926|gb|KY364696.1| 29205 g11846 i0 99.379 90.4355828220859 161 1 99 0 1 161 5609 5769 Cyclotella meneghiniana 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 14741 292 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
7452207 7452207 PRJNA380660_P_NODE_8266_length_241_cov_3.179245_g7866_i0 PRJNA380660 8266 241 3.179245 7.66198045 Stephanocyclus 2818153 SAR_Eukaryotes SAR_Eukaryotes 446 8.519999999999999e-121   NTclustered gi|40557157|gb|AY496213.1| 29205 g7866 i0 100 100 241 0 100 0 1 241 147 387 Cyclotella meneghiniana strain G17W8 18S ribosomal RNA gene, partial sequence blastn 24100 446 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
8726933 8726933 PRJNA380660_P_NODE_12727_length_154_cov_1.840000_g12327_i0 PRJNA380660 12727 154 1.84 2.8336 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 257 2.5e-64   NTclustered gi|2429803054|ref|NC_069610.1| 216927 g12327 i0 99.296 181.779220779221 142 1 92 0 12 153 52066 51925 Paralia sulcata chloroplast, complete genome blastn 27994 257 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Paraliales Paraliaceae Paralia Paralia sulcata
9330319 9330319 PRJNA380660_P_NODE_2908_length_490_cov_1.921909_g2538_i0 PRJNA380660 2908 490 1.921909 9.4173541 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 178 1.77e-50   NR GAX24377.1 1519565 g2538 i0 65.5 24.0918367346939 145 39 82.7 4 488 84 339 482 GAX24377.1 peptidyl-prolyl isomerase D [Fistulifera solaris] diamond 11805 179 0.994413407821229 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
10002341 10002341 PRJNA380660_P_NODE_10448_length_200_cov_1.812865_g10048_i0 PRJNA380660 10448 200 1.812865 3.62573 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 303 4.34e-78   NTclustered gi|2589355395|ref|NC_077461.1| 29204 g10048 i0 95.288 191.46 191 9 96 0 10 200 69740 69550 Cyclotella cryptica chloroplast, complete genome blastn 38292 303 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
14430980 14430980 PRJNA380660_P_NODE_172_length_1966_cov_164.566340_g41_i2 PRJNA380660 172 1966 164.56634 3235.3742444 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 316 6.52e-81   NTclustered gi|2074156200|gb|MW413905.1| 216802 g41 i2 75.099 65.6454730417091 755 149 78 29 1233 1965 23865 24602 Guinardia delicatula mitochondrion, complete genome blastn 129059 316 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
16376715 16376715 PRJNA380660_P_NODE_3653_length_429_cov_555.505000_g3265_i0 PRJNA380660 3653 429 555.505 2383.11645 Ulnaria 426668 SAR_Eukaryotes SAR_Eukaryotes 654 0   NTclustered gi|2199610541|gb|OM837375.1| 426669 g3265 i0 95.588 87.4522144522144 408 18 95 0 3 410 599 1006 Ulnaria ulna strain XZ4.7 small subunit ribosomal RNA gene, partial sequence blastn 37517 654 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria ulna
16376721 16376721 PRJNA380660_P_NODE_7313_length_267_cov_12.878151_g6913_i0 PRJNA380660 7313 267 12.878151 34.38466317 Fragilariophyceae 33853 SAR_Eukaryotes SAR_Eukaryotes 311 3.65e-80   NTclustered gi|18698484|gb|AF417685.1| 186020 g6913 i0 88.346 92.4943820224719 266 21 99 7 4 267 93 350 Synedropsis hyperboreoides strain 5-15 large subunit ribosomal RNA gene, partial sequence blastn 24696 311 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Synedropsis Synedropsis hyperboreoides
20803747 20803747 PRJNA380660_P_NODE_9477_length_216_cov_2.614973_g9077_i0 PRJNA380660 9477 216 2.614973 5.64834168 Stephanocyclus meneghinianus 29205 SAR_Eukaryotes SAR_Eukaryotes 375 9.96e-100   NTclustered gi|1169296926|gb|KY364696.1| 29205 g9077 i0 99.048 94.2638888888889 210 1 97 1 2 210 4154 4363 Cyclotella meneghiniana 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 20361 375 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
26980024 26980024 PRJNA380660_P_NODE_12262_length_163_cov_2.052239_g11862_i0 PRJNA380660 12262 163 2.052239 3.34514957 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 50.8 1.7e-5   NR KAI2505119.1 210448 g11862 i0 52.2 3.38650306748466 46 22 84.7 0 25 162 235 280 KAI2505119.1 Prokaryotic homologs of the JAB domain [Fragilaria crotonensis] diamond 552 50.8 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
27092040 27092040 PRJNA380660_P_NODE_8802_length_229_cov_2.085000_g8402_i0 PRJNA380660 8802 229 2.085 4.77465 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 99 2.1599999999999998e-23   NR KAK1742225.1 267567 g8402 i0 68 6.83842794759825 75 24 98.3 0 228 4 114 188 KAK1742225.1 40S ribosomal protein S6, partial [Skeletonema marinoi] diamond 1566 100 0.99 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
27345098 27345098 PRJNA380660_P_NODE_8083_length_246_cov_1.857143_g7683_i0 PRJNA380660 8083 246 1.857143 4.56857178 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 92.4 9.14e-20   NR KAG7362797.1 303405 g7683 i0 53.8 6.91463414634146 80 35 97.6 1 245 6 301 378 KAG7362797.1 cell division cycle protein 48 [Nitzschia inconspicua] diamond 1701 92.8 0.995689655172414 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27755680 27755680 PRJNA380660_P_NODE_5124_length_348_cov_2.943574_g4726_i0 PRJNA380660 5124 348 2.943574 10.24363752 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 83.2 8.43e-16   NR CAJ1946726.1 2856 g4726 i0 56.9 6.8448275862069 72 28 60.3 2 217 8 483 553 CAJ1946726.1 unnamed protein product [Cylindrotheca closterium] diamond 2382 84 0.990476190476191 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
29285404 29285404 PRJNA380660_P_NODE_7889_length_251_cov_1.585586_g7489_i0 PRJNA380660 7889 251 1.585586 3.97982086 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 97.1 2.4e-21   NR GKY97741.1 2872254 g7489 i0 74.1 6.800796812749 58 15 69.3 0 250 77 418 475 GKY97741.1 eukaryotic translation initiation factor 2 subunit 3, Y-linked [Mayamaea pseudoterrestris] diamond 1707 97.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29474696 29474696 PRJNA380660_P_NODE_7810_length_253_cov_2.455357_g7410_i0 PRJNA380660 7810 253 2.455357 6.21205321 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 134 8.349999999999998e-37   NR KAL3788529.1 29204 g7410 i0 71.8 2.00395256916996 85 23 99.6 1 2 253 70 154 KAL3788529.1 hypothetical protein HJC23_006567 [Cyclotella cryptica] diamond 507 134 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
29712629 29712629 PRJNA380660_P_NODE_5710_length_324_cov_2.206780_g5311_i0 PRJNA380660 5710 324 2.20678 7.1499672 Naviculaceae 67474 SAR_Eukaryotes SAR_Eukaryotes 80.1 7.39e-15   NR GAX29329.1 1519565 g5311 i0 41.2 3.08333333333333 85 50 78.7 0 15 269 798 882 GAX29329.1 puromycin-sensitive aminopeptidase [Fistulifera solaris] diamond 999 80.5 0.995031055900621 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
32161647 32161647 PRJNA380660_P_NODE_3158_length_465_cov_5.451835_g2782_i0 PRJNA380660 3158 465 5.451835 25.35103275 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 63.9 1.48e-8   NR CAB9505022.1 568900 g2782 i0 35.7 0.72258064516129 112 56 72.3 4 94 429 345 440 CAB9505022.1 activated protein kinase catalytic subunit alpha-1 [Seminavis robusta] diamond 336 63.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32210161 32210161 PRJNA380660_P_NODE_9418_length_217_cov_2.930851_g9018_i0 PRJNA380660 9418 217 2.930851 6.35994667 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 77.8 1.17e-14   NR EJK65674.1 159749 g9018 i0 56.5 2.91705069124424 69 29 94 1 14 217 278 346 EJK65674.1 hypothetical protein THAOC_13441, partial [Thalassiosira oceanica] diamond 633 77.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica

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