RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where bioproject = "PRJNA1061474", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 23 ✖

tax_clade 1

  • Sar · 23 ✖

bioproject 1

  • PRJNA1061474 · 23 ✖

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
6555919 6555919 PRJNA1061474_P_NODE_19926_length_440_cov_1.049046_g19680_i0 PRJNA1061474 19926 440 1.049046 4.6158024 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 167 2.95e-49   NR KAK1746763.1 267567 g19680 i0 73.6 4.40454545454545 106 28 72.3 0 123 440 36 141 KAK1746763.1 NADH dehydrogenase [ubiquinone] iron-sulfur protein 8 [Skeletonema marinoi] diamond 1938 167 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
15480520 15480520 PRJNA1061474_P_NODE_12253_length_595_cov_2.193487_g12016_i0 PRJNA1061474 12253 595 2.193487 13.05124765 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 290 4.82e-97   NR CAJ1953473.1 2856 g12016 i0 88.4 3.70588235294118 147 17 74.1 0 75 515 70 216 CAJ1953473.1 unnamed protein product [Cylindrotheca closterium] diamond 2205 290 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
15482066 15482066 PRJNA1061474_P_NODE_9813_length_682_cov_2.201970_g9583_i0 PRJNA1061474 9813 682 2.20197 15.0174354 Cyclotella 29203 SAR_Eukaryotes SAR_Eukaryotes 213 2.36e-61   NR KAL3788351.1 29204 g9583 i0 60.8 2.19061583577713 166 64 72.6 1 2 496 502 667 KAL3788351.1 hypothetical protein HJC23_009157 [Cyclotella cryptica] diamond 1494 213 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
16754771 16754771 PRJNA1061474_P_NODE_15974_length_505_cov_1.527778_g15728_i0 PRJNA1061474 15974 505 1.527778 7.7152789 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 126 3.7299999999999998e-31   NR KAI2514036.1 210448 g15728 i0 71 6.00594059405941 169 48 99.8 1 504 1 187 355 KAI2514036.1 Calreticulin family [Fragilaria crotonensis] diamond 3033 127 0.992125984251969 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
17589506 17589506 PRJNA1061474_P_NODE_52414_length_245_cov_0.895349_g52168_i0 PRJNA1061474 52414 245 0.895349 2.19360505 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 129 1.36e-32   NR GFH54677.1 426638 g52168 i0 76.5 17.8530612244898 81 18 99.2 1 2 244 1048 1127 GFH54677.1 DNA directed RNA polymerase II, second largest subunit [Chaetoceros tenuissimus] diamond 4374 129 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
19303739 19303739 PRJNA1061474_P_NODE_21296_length_422_cov_1.103152_g21050_i0 PRJNA1061474 21296 422 1.103152 4.65530144 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 149 4.59e-41   NR GFH51221.1 426638 g21050 i0 57.3 3.02843601895735 143 40 99.5 2 1 420 170 294 GFH51221.1 hypothetical protein CTEN210_07697 [Chaetoceros tenuissimus] diamond 1278 149 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
20579962 20579962 PRJNA1061474_P_NODE_5097_length_975_cov_10.563193_g4920_i0 PRJNA1061474 5097 975 10.563193 102.99113175 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 350 1.31e-118   NR XP_002181180.1 556484 g4920 i0 79.2 7.16307692307692 212 44 65.2 0 47 682 6 217 XP_002181180.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 6984 350 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
23129901 23129901 PRJNA1061474_P_NODE_10079_length_672_cov_1.160267_g9846_i0 PRJNA1061474 10079 672 1.160267 7.79699424 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 254 2.6e-82   NR GFH59861.1 426638 g9846 i0 78.3 1.37946428571429 152 33 67.9 0 216 671 39 190 GFH59861.1 ubiquitin-conjugating enzyme E2 M [Chaetoceros tenuissimus] diamond 927 254 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
27256696 27256696 PRJNA1061474_P_NODE_50543_length_247_cov_0.885057_g50297_i0 PRJNA1061474 50543 247 0.885057 2.18609079 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 92 8.390000000000001e-21   NR CAJ1950626.1 2856 g50297 i0 57.3 0.995951417004049 82 33 97.2 2 6 245 99 180 CAJ1950626.1 unnamed protein product [Cylindrotheca closterium] diamond 246 92 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
27446551 27446551 PRJNA1061474_P_NODE_49163_length_248_cov_0.880000_g48917_i0 PRJNA1061474 49163 248 0.88 2.1824 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 55.1 1.67e-7   NR XP_002288590.1 296543 g48917 i0 44.8 0.701612903225806 58 32 70.2 0 179 6 23 80 XP_002288590.1 predicted protein [Thalassiosira pseudonana CCMP1335] diamond 174 55.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
27785618 27785618 PRJNA1061474_P_NODE_54464_length_244_cov_0.900585_g54218_i0 PRJNA1061474 54464 244 0.900585 2.1974274 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 75.1 1.45e-13   NR XP_002181727.1 556484 g54218 i0 45.5 3.78688524590164 77 42 94.7 0 242 12 203 279 XP_002181727.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 924 75.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
28100994 28100994 PRJNA1061474_P_NODE_56245_length_242_cov_0.911243_g55999_i0 PRJNA1061474 56245 242 0.911243 2.20520806 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 64.7 6.33e-10   NR KAL3796267.1 29204 g55999 i0 39.8 2.02066115702479 83 47 99.2 1 1 240 138 220 KAL3796267.1 hypothetical protein HJC23_008587 [Cyclotella cryptica] diamond 489 64.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
28227161 28227161 PRJNA1061474_P_NODE_21166_length_423_cov_1.760000_g20920_i0 PRJNA1061474 21166 423 1.76 7.4448 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 225 1.89e-70   NR KAI2502521.1 210448 g20920 i0 78.6 9.90780141843972 140 29 98.6 1 418 2 97 236 KAI2502521.1 cysteine synthase [Fragilaria crotonensis] diamond 4191 226 0.995575221238938 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28803752 28803752 PRJNA1061474_P_NODE_12068_length_601_cov_2.634470_g11831_i0 PRJNA1061474 12068 601 2.63447 15.8331647 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 149 1.45e-41   NR KAI2494838.1 210448 g11831 i0 51.1 0.878535773710483 176 84 87.4 2 525 1 24 198 KAI2494838.1 ATP synthase delta (OSCP) subunit [Fragilaria crotonensis] diamond 528 149 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28962104 28962104 PRJNA1061474_P_NODE_55768_length_243_cov_0.905882_g55522_i0 PRJNA1061474 55768 243 0.905882 2.20129326 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 53.5 5.53e-6   NR XP_002180996.1 556484 g55522 i0 56.4 0.481481481481481 39 17 48.1 0 9 125 238 276 XP_002180996.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 117 53.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29395672 29395672 PRJNA1061474_P_NODE_21769_length_416_cov_1.600583_g21523_i0 PRJNA1061474 21769 416 1.600583 6.65842528 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 114 3.37e-29   NR KAI2491899.1 210448 g21523 i0 48.8 3.17307692307692 121 60 85.8 2 58 414 1 121 KAI2491899.1 ATP synthase [Fragilaria crotonensis] diamond 1320 115 0.991304347826087 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29719358 29719358 PRJNA1061474_P_NODE_45210_length_251_cov_1.297753_g44964_i0 PRJNA1061474 45210 251 1.297753 3.25736003 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 70.9 2.79e-13   NR GAX22470.1 1519565 g44964 i0 53.8 1.99601593625498 80 32 95.6 1 249 10 44 118 GAX22470.1 hypothetical protein FisN_14Hh085 [Fistulifera solaris] diamond 501 70.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
30129918 30129918 PRJNA1061474_P_NODE_55492_length_243_cov_0.905882_g55246_i0 PRJNA1061474 55492 243 0.905882 2.20129326 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 71.2 2.39e-12   NR KAL3775731.1 382360 g55246 i0 61.9 0.777777777777778 63 23 76.5 1 2 187 258 320 KAL3775731.1 hypothetical protein ACHAWO_000817 [Cyclotella atomus] diamond 189 71.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
30280425 30280425 PRJNA1061474_P_NODE_54932_length_243_cov_0.905882_g54686_i0 PRJNA1061474 54932 243 0.905882 2.20129326 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 122 1.19e-31   NR CAJ1951684.1 2856 g54686 i0 75.3 8.97530864197531 81 19 100 1 243 1 161 240 CAJ1951684.1 unnamed protein product [Cylindrotheca closterium] diamond 2181 123 0.991869918699187 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
30572366 30572366 PRJNA1061474_P_NODE_42613_length_265_cov_1.416667_g42367_i0 PRJNA1061474 42613 265 1.416667 3.75416755 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 89.7 1.41e-18   NR CAB9525872.1 568900 g42367 i0 57.6 0.962264150943396 85 36 96.2 0 3 257 534 618 CAB9525872.1 Methylmalonyl-CoA mutase large subunit [Seminavis robusta] diamond 255 89.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31457674 31457674 PRJNA1061474_P_NODE_41776_length_270_cov_1.172589_g41530_i0 PRJNA1061474 41776 270 1.172589 3.1659903 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 112 2.0800000000000004e-27   NR KAL3767548.1 259834 g41530 i0 61 0.911111111111111 82 32 91.1 0 5 250 277 358 KAL3767548.1 hypothetical protein ACHAWU_000211 [Discostella pseudostelligera] diamond 246 112 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
32375088 32375088 PRJNA1061474_P_NODE_24799_length_384_cov_0.990354_g24553_i0 PRJNA1061474 24799 384 0.990354 3.80295936 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 91.3 2.08e-20   NR XP_002292923.1 296543 g24553 i0 40.6 1.0390625 133 73 99.2 2 383 3 12 144 XP_002292923.1 predicted protein, partial [Thalassiosira pseudonana CCMP1335] diamond 399 91.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
32596445 32596445 PRJNA1061474_P_NODE_39000_length_285_cov_1.254717_g38754_i0 PRJNA1061474 39000 285 1.254717 3.57594345 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 47 3.72e-4   NR OEU12290.1 635003 g38754 i0 60.5 0.4 38 15 40 0 283 170 9 46 OEU12290.1 ankyrin, partial [Fragilariopsis cylindrus CCMP1102] diamond 114 47 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus

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