RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "diamond", bioproject = "PRJNA168635" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 26 ✖

tax_clade 1

bioproject 1

  • PRJNA168635 · 26 ✖

analysis 1

  • diamond · 26 ✖

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
15667281 15667281 PRJNA168635_P_NODE_20573_length_180_cov_3.114504_g20157_i0 PRJNA168635 20573 180 3.114504 5.6061072 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 113 6.25e-29   NR GKY92018.1 2872254 g20157 i0 84.5 0.966666666666667 58 9 96.7 0 5 178 81 138 GKY92018.1 hypothetical protein MPSEU_000173400 [Mayamaea pseudoterrestris] diamond 174 113 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
26725321 26725321 PRJNA168635_P_NODE_30001_length_164_cov_0.904348_g29585_i0 PRJNA168635 30001 164 0.904348 1.48313072 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 64.3 2.65e-11   NR KAL3896514.1 3061772 g29585 i0 54 1.68292682926829 50 23 91.5 0 161 12 40 89 KAL3896514.1 MAG: hypothetical protein SGARI_007148, partial [Bacillariaceae sp.] diamond 276 64.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
26915698 26915698 PRJNA168635_P_NODE_34942_length_153_cov_2.951923_g34526_i0 PRJNA168635 34942 153 2.951923 4.51644219 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 78.2 8.48e-17   NR CAJ1960062.1 2856 g34526 i0 72.9 0.941176470588235 48 13 94.1 0 6 149 9 56 CAJ1960062.1 unnamed protein product [Cylindrotheca closterium] diamond 144 78.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
27105331 27105331 PRJNA168635_P_NODE_20002_length_182_cov_2.278195_g19586_i0 PRJNA168635 20002 182 2.278195 4.1463149 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 57 1.73e-8   NR KAG7349292.1 303405 g19586 i0 60.8 0.840659340659341 51 20 84.1 0 25 177 49 99 KAG7349292.1 hypothetical protein IV203_011889 [Nitzschia inconspicua] diamond 153 57 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27263659 27263659 PRJNA168635_P_NODE_20423_length_181_cov_1.416667_g20007_i0 PRJNA168635 20423 181 1.416667 2.56416727 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 115 2.94e-28   NR OEU07301.1 635003 g20007 i0 81.7 1.98895027624309 60 11 99.4 0 180 1 495 554 OEU07301.1 hypothetical protein FRACYDRAFT_264923 [Fragilariopsis cylindrus CCMP1102] diamond 360 115 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
27390171 27390171 PRJNA168635_P_NODE_22023_length_176_cov_2.417323_g21607_i0 PRJNA168635 22023 176 2.417323 4.25448848 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 87.4 1.2e-18   NR OEU17324.1 635003 g21607 i0 75 0.886363636363636 52 13 88.6 0 20 175 235 286 OEU17324.1 S-adenosyl-L-methionine-dependent methyltransferase [Fragilariopsis cylindrus CCMP1102] diamond 156 87.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
27769120 27769120 PRJNA168635_P_NODE_24204_length_171_cov_1.672131_g23788_i0 PRJNA168635 24204 171 1.672131 2.85934401 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 83.6 4.97e-17   NR XP_002286567.1 296543 g23788 i0 76.4 4.82456140350877 55 13 96.5 0 167 3 46 100 XP_002286567.1 hydroxymethylglutaryl-coa synthase, partial [Thalassiosira pseudonana CCMP1335] diamond 825 83.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
28007870 28007870 PRJNA168635_P_NODE_33725_length_157_cov_2.537037_g33309_i0 PRJNA168635 33725 157 2.537037 3.98314809 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 57.4 7.89e-8   NR CAJ1952653.1 2856 g33309 i0 50 3.97452229299363 52 26 99.4 0 2 157 466 517 CAJ1952653.1 unnamed protein product [Cylindrotheca closterium] diamond 624 57.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
28210738 28210738 PRJNA168635_P_NODE_30046_length_164_cov_0.904348_g29630_i0 PRJNA168635 30046 164 0.904348 1.48313072 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 87.8 1.68e-18   NR GAX27530.1 1519565 g29630 i0 72.2 0.98780487804878 54 15 98.8 0 1 162 545 598 GAX27530.1 hypothetical protein FisN_UnNu102, partial [Fistulifera solaris] diamond 162 87.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
28747663 28747663 PRJNA168635_P_NODE_19867_length_183_cov_1.276119_g19451_i0 PRJNA168635 19867 183 1.276119 2.33529777 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 105 6.91e-25   NR KAL3917766.1 3061772 g19451 i0 76.7 0.983606557377049 60 14 98.4 0 1 180 353 412 KAL3917766.1 MAG: hypothetical protein SGILL_004554 [Bacillariaceae sp.] diamond 180 105 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
29095108 29095108 PRJNA168635_P_NODE_31608_length_162_cov_1.831858_g31192_i0 PRJNA168635 31608 162 1.831858 2.96760996 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 53.1 2.71e-6   NR KAG7359120.1 303405 g31192 i0 45.5 1.62962962962963 44 24 81.5 0 132 1 522 565 KAG7359120.1 glutamate-cysteine ligase [Nitzschia inconspicua] diamond 264 53.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
29189865 29189865 PRJNA168635_P_NODE_22889_length_174_cov_1.656000_g22473_i0 PRJNA168635 22889 174 1.656 2.88144 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 96.7 1.55e-21   NR KAL3923591.1 3061772 g22473 i0 70.2 0.982758620689655 57 17 98.3 0 171 1 860 916 KAL3923591.1 MAG: hypothetical protein SGILL_001571 [Bacillariaceae sp.] diamond 171 96.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
29473598 29473598 PRJNA168635_P_NODE_34530_length_154_cov_3.847619_g34114_i0 PRJNA168635 34530 154 3.847619 5.92533326 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 74.7 5.87e-14   NR KAL3940111.1 3061772 g34114 i0 69.4 3.81818181818182 49 15 95.5 0 148 2 376 424 KAL3940111.1 MAG: hypothetical protein SGARI_001119 [Bacillariaceae sp.] diamond 588 74.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
29631454 29631454 PRJNA168635_P_NODE_32290_length_162_cov_0.920354_g31874_i0 PRJNA168635 32290 162 0.920354 1.49097348 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 75.9 2.65e-14   NR KAL3925589.1 3061772 g31874 i0 66 0.981481481481482 53 18 98.1 0 4 162 851 903 KAL3925589.1 MAG: hypothetical protein SGILL_000312 [Bacillariaceae sp.] diamond 159 75.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30327184 30327184 PRJNA168635_P_NODE_22892_length_174_cov_1.656000_g22476_i0 PRJNA168635 22892 174 1.656 2.88144 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 53.1 3.24e-6   NR OEU14563.1 635003 g22476 i0 71.4 1.81034482758621 35 10 60.3 0 7 111 908 942 OEU14563.1 SNF2_N-domain-containing protein [Fragilariopsis cylindrus CCMP1102] diamond 315 53.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
30484721 30484721 PRJNA168635_P_NODE_6233_length_339_cov_1.786207_g5823_i0 PRJNA168635 6233 339 1.786207 6.05524173 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 84.3 4.8e-17   NR GFH50808.1 426638 g5823 i0 36.6 1.88495575221239 101 64 89.4 0 335 33 95 195 GFH50808.1 hypothetical protein CTEN210_07284 [Chaetoceros tenuissimus] diamond 639 84.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
30579201 30579201 PRJNA168635_P_NODE_27973_length_166_cov_0.888889_g27557_i0 PRJNA168635 27973 166 0.888889 1.47555574 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 60.5 7.3e-9   NR KAL3770835.1 259834 g27557 i0 61.5 0.939759036144578 52 20 94 0 166 11 40 91 KAL3770835.1 hypothetical protein ACHAWU_006394 [Discostella pseudostelligera] diamond 156 60.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
30705711 30705711 PRJNA168635_P_NODE_32174_length_162_cov_0.920354_g31758_i0 PRJNA168635 32174 162 0.920354 1.49097348 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 64.3 2.98e-10   NR VEU39619.1 183589 g31758 i0 73.8 1.42592592592593 42 11 77.8 0 5 130 821 862 VEU39619.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 231 64.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
30895563 30895563 PRJNA168635_P_NODE_22934_length_174_cov_1.632000_g22518_i0 PRJNA168635 22934 174 1.632 2.83968 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 48.5 8.53e-5   NR KAL3799597.1 2934178 g22518 i0 71 0.53448275862069 31 9 53.4 0 173 81 132 162 KAL3799597.1 hypothetical protein ACHAW5_006579 [Stephanodiscus triporus] diamond 93 48.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
30895572 30895572 PRJNA168635_P_NODE_33674_length_157_cov_2.842593_g33258_i0 PRJNA168635 33674 157 2.842593 4.46287101 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00126   NR GAX22114.1 1519565 g33258 i0 48 1.89171974522293 50 26 95.5 0 6 155 380 429 GAX22114.1 hypothetical protein FisN_6Hh363 [Fistulifera solaris] diamond 297 45.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
31134079 31134079 PRJNA168635_P_NODE_31255_length_163_cov_0.912281_g30839_i0 PRJNA168635 31255 163 0.912281 1.48701803 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 80.9 4.6e-16   NR ACA60877.1 2850 g30839 i0 71.2 9.79141104294479 52 15 95.7 0 7 162 1392 1443 ACA60877.1 gag-pol polyprotein [Phaeodactylum tricornutum] diamond 1596 80.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
31527745 31527745 PRJNA168635_P_NODE_18616_length_187_cov_1.971014_g18200_i0 PRJNA168635 18616 187 1.971014 3.68579618 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 86.3 1.89e-18   NR KAI2496375.1 210448 g18200 i0 67.7 0.994652406417112 62 20 99.5 0 186 1 82 143 KAI2496375.1 hypothetical protein MHU86_18111 [Fragilaria crotonensis] diamond 186 86.3 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
31622474 31622474 PRJNA168635_P_NODE_4856_length_383_cov_7.877246_g4452_i0 PRJNA168635 4856 383 7.877246 30.16985218 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00386   NR EJK58442.1 159749 g4452 i0 51.9 0.407310704960835 52 25 40.7 0 158 3 21 72 EJK58442.1 hypothetical protein THAOC_21444 [Thalassiosira oceanica] diamond 156 44.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
31717405 31717405 PRJNA168635_P_NODE_18897_length_186_cov_1.693431_g18481_i0 PRJNA168635 18897 186 1.693431 3.14978166 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 98.6 3.700000000000001e-22   NR GKY97978.1 2872254 g18481 i0 100 4.74193548387097 49 0 79 0 185 39 193 241 GKY97978.1 hypothetical protein MPSEU_000755900 [Mayamaea pseudoterrestris] diamond 882 98.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
32128914 32128914 PRJNA168635_P_NODE_34538_length_154_cov_3.809524_g34122_i0 PRJNA168635 34538 154 3.809524 5.86666696 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 79.7 1.03e-15   NR CAB9524542.1 568900 g34122 i0 66.7 0.993506493506494 51 17 99.4 0 154 2 934 984 CAB9524542.1 Esterase OVCA2 [Seminavis robusta] diamond 153 79.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
32350394 32350394 PRJNA168635_P_NODE_35559_length_150_cov_5.831683_g35143_i0 PRJNA168635 35559 150 5.831683 8.7475245 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.00179   NR EJK58442.1 159749 g35143 i0 59.1 1.7 44 18 88 0 18 149 16 59 EJK58442.1 hypothetical protein THAOC_21444 [Thalassiosira oceanica] diamond 255 42.7 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);;