RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA883229" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 14 ✖

tax_clade 1

bioproject 1

  • PRJNA883229 · 14 ✖

analysis 1

  • diamond · 14 ✖

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
3410776 3410776 PRJNA883229_P_NODE_723_length_708_cov_1.565354_g681_i0 PRJNA883229 723 708 1.565354 11.08270632 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 387 3.6399999999999998e-124   NR KAG7353554.1 303405 g681 i0 83.1 3 236 38 100 1 708 1 578 811 KAG7353554.1 HAD superfamily P-type ATPase [Nitzschia inconspicua] diamond 2124 387 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
26991898 26991898 PRJNA883229_P_NODE_5342_length_300_cov_2.951542_g5296_i0 PRJNA883229 5342 300 2.951542 8.854626 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 55.1 3.53e-6   NR KAL3766974.1 2934178 g5296 i0 96.3 0.27 27 1 27 0 282 202 340 366 KAL3766974.1 hypothetical protein ACHAW5_002882 [Stephanodiscus triporus] diamond 81 55.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
28034644 28034644 PRJNA883229_P_NODE_10305_length_251_cov_0.876404_g10259_i0 PRJNA883229 10305 251 0.876404 2.19977404 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 84.7 1.74e-17   NR KAI2503317.1 210448 g10259 i0 75.4 1.45816733067729 61 8 64.5 2 90 251 1 61 KAI2503317.1 Type III restriction enzyme [Fragilaria crotonensis] diamond 366 84.7 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28350212 28350212 PRJNA883229_P_NODE_13346_length_246_cov_0.901734_g13300_i0 PRJNA883229 13346 246 0.901734 2.21826564 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 52.4 7.91e-6   NR CAB9528440.1 568900 g13300 i0 43.4 1.01219512195122 83 45 98.8 2 246 4 25 107 CAB9528440.1 expressed unknown protein [Seminavis robusta] diamond 249 52.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28634655 28634655 PRJNA883229_P_NODE_15187_length_244_cov_0.912281_g15141_i0 PRJNA883229 15187 244 0.912281 2.22596564 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 89 1.08e-18   NR GAX23227.1 1519565 g15141 i0 51.9 1.9672131147541 81 39 99.6 0 2 244 190 270 GAX23227.1 hypothetical protein FisN_21Hh091 [Fistulifera solaris] diamond 480 89 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
29139853 29139853 PRJNA883229_P_NODE_16769_length_237_cov_4.646341_g16723_i0 PRJNA883229 16769 237 4.646341 11.01182817 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 53.1 6.81e-7   NR GAX28375.1 1519565 g16723 i0 78.4 0.645569620253165 51 11 64.6 0 1 153 45 95 GAX28375.1 hypothetical protein FisN_4Hh037 [Fistulifera solaris] diamond 153 53.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
29707500 29707500 PRJNA883229_P_NODE_8810_length_253_cov_0.866667_g8764_i0 PRJNA883229 8810 253 0.866667 2.19266751 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 100 2.84e-22   NR GAX09682.1 1519565 g8764 i0 52.4 1.94466403162055 82 39 97.2 0 7 252 761 842 GAX09682.1 elongator complex protein 1 [Fistulifera solaris] diamond 492 100 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
29960589 29960589 PRJNA883229_P_NODE_8851_length_253_cov_0.866667_g8805_i0 PRJNA883229 8851 253 0.866667 2.19266751 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 168 2.58e-46   NR KAL3761326.1 2934178 g8805 i0 100 0.948616600790514 80 0 94.9 0 3 242 221 300 KAL3761326.1 hypothetical protein ACHAW5_001758 [Stephanodiscus triporus] diamond 240 168 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
30466441 30466441 PRJNA883229_P_NODE_753_length_696_cov_1.898876_g710_i0 PRJNA883229 753 696 1.898876 13.21617696 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 224 1.11e-63   NR KAG7353554.1 303405 g710 i0 69.1 1.55172413793103 178 51 76.7 3 696 163 887 1060 KAG7353554.1 HAD superfamily P-type ATPase [Nitzschia inconspicua] diamond 1080 224 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31192426 31192426 PRJNA883229_P_NODE_1675_length_481_cov_1.129902_g1629_i0 PRJNA883229 1675 481 1.129902 5.43482862 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 259 6.840000000000001e-77   NR ACA60906.1 2850 g1629 i0 81.5 0.979209979209979 157 29 97.9 0 472 2 326 482 ACA60906.1 gag-pol polyprotein [Phaeodactylum tricornutum] diamond 471 259 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
31232168 31232168 PRJNA883229_P_NODE_9355_length_252_cov_0.871508_g9309_i0 PRJNA883229 9355 252 0.871508 2.19620016 Naviculaceae 67474 SAR_Eukaryotes SAR_Eukaryotes 150 6.369999999999999e-40   NR GAX17005.1 1519565 g9309 i0 86.6 2.94047619047619 82 11 97.6 0 6 251 549 630 GAX17005.1 exocyst complex component 7 [Fistulifera solaris] diamond 741 150 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
31983498 31983498 PRJNA883229_P_NODE_1498_length_502_cov_1.701632_g1452_i0 PRJNA883229 1498 502 1.701632 8.54219264 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 131 3.68e-33   NR XP_002183887.1 556484 g1452 i0 50.6 0.968127490039841 162 69 95 4 1 477 141 294 XP_002183887.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 486 131 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
32110149 32110149 PRJNA883229_P_NODE_15238_length_244_cov_0.912281_g15192_i0 PRJNA883229 15238 244 0.912281 2.22596564 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 53.1 7.55e-7   NR GFH60246.1 426638 g15192 i0 67.6 0.836065573770492 34 11 41.8 0 138 239 18 51 GFH60246.1 hypothetical protein CTEN210_16722 [Chaetoceros tenuissimus] diamond 204 53.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
32458334 32458334 PRJNA883229_P_NODE_16299_length_242_cov_0.923077_g16253_i0 PRJNA883229 16299 242 0.923077 2.23384634 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 75.9 7.87e-14   NR XP_002182641.1 556484 g16253 i0 52.5 1.92148760330579 80 31 99.2 2 241 2 538 610 XP_002182641.1 P1B, P type ATPase, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 465 75.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum

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