RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 21 ✖

bioproject 1

  • PRJNA704949 · 21 ✖

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
5013744 5013744 PRJNA704949_P_NODE_1067264_length_250_cov_1.467662_g1051928_i0 PRJNA704949 1067264 250 1.467662 3.669155 Navicula 50949 SAR_Eukaryotes SAR_Eukaryotes 97.1 1.03e-15   NTclustered gi|311700481|gb|HQ396813.1| 908856 g1051928 i0 79.577 19.76 142 23 55 4 15 152 696 557 Navicula sp. CCMP544 28S ribosomal RNA gene, partial sequence blastn 4940 97.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp. BOLD:AAO6949
17271200 17271200 PRJNA704949_P_NODE_1920314_length_169_cov_1.733333_g1904975_i0 PRJNA704949 1920314 169 1.733333 2.92933277 Nitzschia dissipatoides 3068544 SAR_Eukaryotes SAR_Eukaryotes 209 7.9100000000000005e-50   NTclustered gi|2721954655|gb|OR464351.1| 3068544 g1904975 i0 92.466 11.4378698224852 146 11 86 0 21 166 68411 68556 Nitzschia dissipatoides plastid, complete genome blastn 1933 209 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia dissipatoides
22862806 22862806 PRJNA704949_P_NODE_1010538_length_258_cov_6.952153_g995203_i0 PRJNA704949 1010538 258 6.952153 17.93655474 Entomoneis 186042 SAR_Eukaryotes SAR_Eukaryotes 250 7.76e-62   NTclustered gi|2202538958|gb|OM891864.1| 216750 g995203 i0 86.726 9.72480620155039 226 28 87 2 13 237 4053 3829 Entomoneis cf. alata small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 2509 250 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis cf. alata
23646493 23646493 PRJNA704949_P_NODE_1932279_length_169_cov_0.866667_g1916940_i0 PRJNA704949 1932279 169 0.866667 1.46466723 Cocconeis placentula 431341 SAR_Eukaryotes SAR_Eukaryotes 104 3.84e-18   NTclustered gi|168145918|emb|AM710569.1| 431341 g1916940 i0 78.846 0.923076923076923 156 31 92 2 7 161 521 367 Cocconeis placentula partial 28S rRNA gene, strain AT-212Gel11 blastn 156 104 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cocconeidales Cocconeidaceae Cocconeis Cocconeis placentula
26777673 26777673 PRJNA704949_P_NODE_1493541_length_201_cov_2.131579_g1478203_i0 PRJNA704949 1493541 201 2.131579 4.28447379 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 90.9 2.32e-19   NR KAL3758828.1 259834 g1478203 i0 77.2 1.71641791044776 57 13 85.1 0 9 179 615 671 KAL3758828.1 hypothetical protein ACHAWU_007945 [Discostella pseudostelligera] diamond 345 90.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
26925127 26925127 PRJNA704949_P_NODE_298742_length_492_cov_1.521445_g283950_i0 PRJNA704949 298742 492 1.521445 7.4855094 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 60.8 2.5e-7   NR KAI2513198.1 210448 g283950 i0 37.6 1.6890243902439 101 51 59.8 4 198 491 701 792 KAI2513198.1 Pfam:DUF3608 [Fragilaria crotonensis] diamond 831 60.8 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
27114412 27114412 PRJNA704949_P_NODE_1403842_length_210_cov_1.161491_g1388504_i0 PRJNA704949 1403842 210 1.161491 2.4391311 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 77.8 1.05e-14   NR GAX29364.1 1519565 g1388504 i0 51.5 3.77142857142857 66 32 94.3 0 12 209 314 379 GAX29364.1 hypothetical protein FisN_16Hh199 [Fistulifera solaris] diamond 792 77.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
27156828 27156828 PRJNA704949_P_NODE_1236962_length_228_cov_1.128492_g1221625_i0 PRJNA704949 1236962 228 1.128492 2.57296176 Pseudo-nitzschia 41953 SAR_Eukaryotes SAR_Eukaryotes 110 2.37e-26   NR VEU37521.1 183589 g1221625 i0 84.2 4.59210526315789 57 9 75 0 35 205 367 423 VEU37521.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 1047 110 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
27209223 27209223 PRJNA704949_P_NODE_1432042_length_207_cov_1.417722_g1416704_i0 PRJNA704949 1432042 207 1.417722 2.93468454 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 51.2 2.31e-5   NR KAK1748342.1 267567 g1416704 i0 72.4 0.420289855072464 29 8 42 0 2 88 451 479 KAK1748342.1 serine/threonine-protein phosphatase 2A activator [Skeletonema marinoi] diamond 87 51.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
27251959 27251959 PRJNA704949_P_NODE_1248783_length_226_cov_1.977401_g1233446_i0 PRJNA704949 1248783 226 1.977401 4.46892626 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 107 3.91e-25   NR KAL3805665.1 29204 g1233446 i0 72 5.97345132743363 75 21 99.6 0 2 226 3778 3852 KAL3805665.1 hypothetical protein HJC23_005909 [Cyclotella cryptica] diamond 1350 108 0.990740740740741 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
28030883 28030883 PRJNA704949_P_NODE_287025_length_501_cov_1.325221_g272291_i0 PRJNA704949 287025 501 1.325221 6.63935721 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 104 1.95e-22   NR CAB9509343.1 568900 g272291 i0 59.3 0.48502994011976 81 32 48.5 1 408 166 614 693 CAB9509343.1 expressed unknown protein [Seminavis robusta] diamond 243 104 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28673116 28673116 PRJNA704949_P_NODE_1951927_length_168_cov_1.747899_g1936588_i0 PRJNA704949 1951927 168 1.747899 2.93647032 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 48.9 3.3e-5   NR GKY91394.1 2872254 g1936588 i0 51.1 3.85714285714286 45 22 80.4 0 29 163 9 53 GKY91394.1 60S ribosomal protein L23A [Mayamaea pseudoterrestris] diamond 648 48.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28819452 28819452 PRJNA704949_P_NODE_1094308_length_246_cov_1.583756_g1078972_i0 PRJNA704949 1094308 246 1.583756 3.89603976 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00781   NR OEU21297.1 635003 g1078972 i0 50 0.414634146341463 34 17 41.5 0 156 55 123 156 OEU21297.1 hypothetical protein FRACYDRAFT_180338, partial [Fragilariopsis cylindrus CCMP1102] diamond 102 44.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
29136082 29136082 PRJNA704949_P_NODE_1977329_length_168_cov_0.873950_g1961990_i0 PRJNA704949 1977329 168 0.87395 1.468236 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.00207   NR KAG7366792.1 303405 g1961990 i0 53.1 2.30357142857143 32 15 57.1 0 167 72 1107 1138 KAG7366792.1 reverse transcriptase RNA-dependent DNA polymerase [Nitzschia inconspicua] diamond 387 45.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
29293811 29293811 PRJNA704949_P_NODE_464229_length_400_cov_1.259259_g449016_i0 PRJNA704949 464229 400 1.259259 5.037036 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 104 1.29e-24   NR GKY93911.1 2872254 g449016 i0 87 0.405 54 7 40.5 0 162 1 48 101 GKY93911.1 hypothetical protein MPSEU_000358000 [Mayamaea pseudoterrestris] diamond 162 104 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
30936233 30936233 PRJNA704949_P_NODE_1640374_length_189_cov_2.200000_g1625035_i0 PRJNA704949 1640374 189 2.2 4.158 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.00474   NR CAB9517886.1 568900 g1625035 i0 30.4 2.66666666666667 56 39 88.9 0 187 20 146 201 CAB9517886.1 Retrotransposon protein [Seminavis robusta] diamond 504 44.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31031396 31031396 PRJNA704949_P_NODE_362435_length_450_cov_2.436409_g347412_i0 PRJNA704949 362435 450 2.436409 10.9638405 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 203 1.2600000000000001e-59   NR KAG7344014.1 303405 g347412 i0 62.8 0.986666666666667 148 54 98.7 1 449 6 273 419 KAG7344014.1 procollagen-proline dioxygenase [Nitzschia inconspicua] diamond 444 203 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
31283470 31283470 PRJNA704949_P_NODE_1022875_length_257_cov_0.990385_g1007540_i0 PRJNA704949 1022875 257 0.990385 2.54528945 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0442   NR EJK74618.1 159749 g1007540 i0 39.4 0.770428015564202 66 35 77 2 6 203 127 187 EJK74618.1 hypothetical protein THAOC_03694 [Thalassiosira oceanica] diamond 198 42.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
31347359 31347359 PRJNA704949_P_NODE_299536_length_491_cov_2.300905_g284737_i0 PRJNA704949 299536 491 2.300905 11.29744355 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 49.7 0.00175   NR KAL3769038.1 2934178 g284737 i0 45.7 0.281059063136456 46 25 28.1 0 273 410 94 139 KAL3769038.1 hypothetical protein ACHAW5_005154 [Stephanodiscus triporus] diamond 138 49.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
31853130 31853130 PRJNA704949_P_NODE_2042197_length_166_cov_0.888889_g2026858_i0 PRJNA704949 2042197 166 0.888889 1.47555574 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 41.2 0.0418   NR OEU10819.1 635003 g2026858 i0 34 0.903614457831325 50 31 88.6 2 158 12 154 202 OEU10819.1 aPHC-domain-containing protein [Fragilariopsis cylindrus CCMP1102] diamond 150 41.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
32675227 32675227 PRJNA704949_P_NODE_2159980_length_162_cov_1.380531_g2144641_i0 PRJNA704949 2159980 162 1.380531 2.23646022 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 87.8 1.59e-18   NR KAL3792465.1 2934178 g2144641 i0 92.5 1.48148148148148 40 3 74.1 0 2 121 552 591 KAL3792465.1 hypothetical protein ACHAW5_010942 [Stephanodiscus triporus] diamond 240 87.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus

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