RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA599026", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 16 ✖

tax_clade 1

  • Sar · 16 ✖

bioproject 1

  • PRJNA599026 · 16 ✖

analysis 1

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
4399083 4399083 PRJNA599026_S_NODE_17424_length_245_cov_2.413265_g16968_i0 PRJNA599026 17424 245 2.413265 5.91249925 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 101 6.989999999999999e-23   NR OEU12276.1 635003 g16968 i0 86.8 9.08571428571429 53 7 64.9 0 169 11 76 128 OEU12276.1 prolyl-tRNA synthetase [Fragilariopsis cylindrus CCMP1102] diamond 2226 101 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
27142722 27142722 PRJNA599026_S_NODE_54522_length_166_cov_0.871795_g54066_i0 PRJNA599026 54522 166 0.871795 1.4471797 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 81.6 2.46e-16   NR KAG7345865.1 303405 g54066 i0 70.4 1.93373493975904 54 16 97.6 0 3 164 732 785 KAG7345865.1 plasma-membrane proton-efflux P-type ATPase [Nitzschia inconspicua] diamond 321 81.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27237850 27237850 PRJNA599026_S_NODE_41823_length_179_cov_1.161538_g41367_i0 PRJNA599026 41823 179 1.161538 2.07915302 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.00614   NR GAX14676.1 1519565 g41367 i0 64.3 0.921787709497207 28 10 46.9 0 86 3 164 191 GAX14676.1 protein phosphatase 1B [Fistulifera solaris] diamond 165 43.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
28090494 28090494 PRJNA599026_S_NODE_56205_length_165_cov_1.551724_g55749_i0 PRJNA599026 56205 165 1.551724 2.5603446 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.00385   NR KAL3817001.1 382380 g55749 i0 41.7 1.76363636363636 48 27 85.5 1 16 156 99 146 KAL3817001.1 hypothetical protein ACHAXA_010121 [Cyclostephanos tholiformis] diamond 291 44.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
28229906 28229906 PRJNA599026_S_NODE_20926_length_229_cov_1.405556_g20470_i0 PRJNA599026 20926 229 1.405556 3.21872324 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 54.7 1.81e-6   NR KAL3804535.1 29204 g20470 i0 57.1 17.4366812227074 35 15 45.9 0 74 178 243 277 KAL3804535.1 hypothetical protein HJC23_002574 [Cyclotella cryptica] diamond 3993 55.1 0.992740471869329 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
28785018 28785018 PRJNA599026_S_NODE_28467_length_205_cov_1.762821_g28011_i0 PRJNA599026 28467 205 1.762821 3.61378305 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.00419   NR EJK73072.1 159749 g28011 i0 44.7 1.30243902439024 47 26 68.8 0 142 2 32 78 EJK73072.1 hypothetical protein THAOC_05322, partial [Thalassiosira oceanica] diamond 267 43.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
29795421 29795421 PRJNA599026_S_NODE_57591_length_165_cov_0.879310_g57135_i0 PRJNA599026 57591 165 0.87931 1.4508615 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 46.6 5.89e-4   NR CAB9500620.1 568900 g57135 i0 69 0.527272727272727 29 9 52.7 0 79 165 592 620 CAB9500620.1 eIF-2-alpha kinase GCN2 [Seminavis robusta] diamond 87 46.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
29890514 29890514 PRJNA599026_S_NODE_631_length_1103_cov_4.955408_g444_i0 PRJNA599026 631 1103 4.955408 54.65815024 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 142 2.35e-34   NR GKY94968.1 2872254 g444 i0 37 1.19129646418858 219 137 59.6 1 886 230 196 413 GKY94968.1 translation elongation factor Tu [Mayamaea pseudoterrestris] diamond 1314 142 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29985127 29985127 PRJNA599026_S_NODE_57731_length_165_cov_0.879310_g57275_i0 PRJNA599026 57731 165 0.87931 1.4508615 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 65.9 9.25e-11   NR CAB9507550.1 568900 g57275 i0 66.7 7.38181818181818 51 17 92.7 0 13 165 231 281 CAB9507550.1 Glutamyl-tRNA(Gln) amidotransferase subunit A [Seminavis robusta] diamond 1218 65.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30978018 30978018 PRJNA599026_S_NODE_35894_length_189_cov_1.378571_g35438_i0 PRJNA599026 35894 189 1.378571 2.60549919 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.00108   NR GFH60226.1 426638 g35438 i0 55.6 4.41269841269841 36 16 57.1 0 188 81 454 489 GFH60226.1 hypothetical protein CTEN210_16702 [Chaetoceros tenuissimus] diamond 834 46.6 0.991416309012876 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
31167140 31167140 PRJNA599026_S_NODE_4435_length_452_cov_4.009926_g3982_i0 PRJNA599026 4435 452 4.009926 18.12486552 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 55.1 5.63e-6   NR CAJ1959243.1 2856 g3982 i0 37.7 4.91150442477876 77 43 51.1 2 266 36 78 149 CAJ1959243.1 unnamed protein product [Cylindrotheca closterium] diamond 2220 55.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31216928 31216928 PRJNA599026_S_NODE_59915_length_164_cov_0.886957_g59459_i0 PRJNA599026 59915 164 0.886957 1.45460948 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0331   NR XP_002178757.1 556484 g59459 i0 58.1 0.786585365853659 43 15 78.7 2 156 28 335 374 XP_002178757.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 129 41.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
31407225 31407225 PRJNA599026_S_NODE_49416_length_168_cov_1.714286_g48960_i0 PRJNA599026 49416 168 1.714286 2.88000048 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0367   NR KAL3799219.1 382360 g48960 i0 43.9 0.732142857142857 41 23 73.2 0 37 159 443 483 KAL3799219.1 hypothetical protein ACHAWO_000451 [Cyclotella atomus] diamond 123 41.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
32779669 32779669 PRJNA599026_S_NODE_35080_length_190_cov_5.418440_g34624_i0 PRJNA599026 35080 190 5.41844 10.295036 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 62.8 1.96e-10   NR KAL3805660.1 29204 g34624 i0 73.2 6.45789473684211 41 11 64.7 0 189 67 7 47 KAL3805660.1 hypothetical protein HJC23_005904 [Cyclotella cryptica] diamond 1227 63.2 0.993670886075949 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
32797755 32797755 PRJNA599026_S_NODE_64760_length_163_cov_0.894737_g64304_i0 PRJNA599026 64760 163 0.894737 1.45842131 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 56.6 1.54e-7   NR KAK1740596.1 267567 g64304 i0 51.3 0.717791411042945 39 19 71.8 0 152 36 143 181 KAK1740596.1 calcium-dependent protein kinase [Skeletonema marinoi] diamond 117 56.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
32860934 32860934 PRJNA599026_S_NODE_12100_length_284_cov_2.361702_g11644_i0 PRJNA599026 12100 284 2.361702 6.70723368 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 96.7 1.92e-23   NR CAJ1934332.1 2856 g11644 i0 58.9 3.29577464788732 73 30 77.1 0 230 12 2 74 CAJ1934332.1 unnamed protein product [Cylindrotheca closterium] diamond 936 96.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium

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