RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJNA436017" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 24 ✖

tax_clade 1

bioproject 1

  • PRJNA436017 · 24 ✖

analysis 1

  • diamond · 24 ✖

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
430674 430674 PRJNA436017_P_NODE_1581_length_751_cov_2.628852_g1371_i0 PRJNA436017 1581 751 2.628852 19.74267852 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 198 3.6e-60   NR GFH59293.1 426638 g1371 i0 53.6 3.73102529960053 181 83 72.3 1 734 192 1 180 GFH59293.1 RL9, ribosomal protein 9 [Chaetoceros tenuissimus] diamond 2802 198 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
4257555 4257555 PRJNA436017_P_NODE_10384_length_267_cov_2.521739_g10086_i0 PRJNA436017 10384 267 2.521739 6.73304313 root 1 Root_unresolved Root_unresolved 147 1.31e-43   NR AID23573.1 2850 g10086 i0 76.1 3.95505617977528 88 21 98.9 0 266 3 5 92 AID23573.1 ribosomal protein, partial [Phaeodactylum tricornutum] diamond 1056 147 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
4257769 4257769 PRJNA436017_P_NODE_20864_length_179_cov_1.373239_g20566_i0 PRJNA436017 20864 179 1.373239 2.45809781 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 110 3.01e-26   NR KAK1744626.1 267567 g20566 i0 89.8 9.88826815642458 59 6 98.9 0 178 2 2047 2105 KAK1744626.1 methionine synthase, vitamin B12-dependent, partial [Skeletonema marinoi] diamond 1770 110 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
5534467 5534467 PRJNA436017_P_NODE_19405_length_186_cov_1.033557_g19107_i0 PRJNA436017 19405 186 1.033557 1.92241602 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 134 6.47e-38   NR CAJ1953473.1 2856 g19107 i0 93.4 8.85483870967742 61 4 98.4 0 2 184 91 151 CAJ1953473.1 unnamed protein product [Cylindrotheca closterium] diamond 1647 135 0.992592592592593 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
11292208 11292208 PRJNA436017_P_NODE_20449_length_181_cov_1.076389_g20151_i0 PRJNA436017 20449 181 1.076389 1.94826409 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 87.4 2.18e-18   NR KAI2508213.1 210448 g20151 i0 62.5 8.10497237569061 64 19 97.8 1 179 3 6 69 KAI2508213.1 Type III restriction enzyme [Fragilaria crotonensis] diamond 1467 88.2 0.99092970521542 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
13184474 13184474 PRJNA436017_P_NODE_2311_length_624_cov_1.691652_g2062_i0 PRJNA436017 2311 624 1.691652 10.55590848 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 214 8.13e-62   NR CAB9526840.1 568900 g2062 i0 59.6 1.85576923076923 193 72 92.8 3 579 1 5 191 CAB9526840.1 shock protein 81-1 [Seminavis robusta] diamond 1158 214 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
14459852 14459852 PRJNA436017_P_NODE_9112_length_289_cov_1.472222_g8814_i0 PRJNA436017 9112 289 1.472222 4.25472158 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 189 1.58e-57   NR AAX09600.1 29204 g8814 i0 91.7 0.996539792387543 96 8 99.7 0 1 288 220 315 AAX09600.1 elongation factor 1 alpha, partial [Cyclotella cryptica] diamond 288 189 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
22107610 22107610 PRJNA436017_P_NODE_7678_length_320_cov_1.240283_g7381_i0 PRJNA436017 7678 320 1.240283 3.9689056 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 130 1.98e-32   NR ANG60896.1 267567 g7381 i0 64.1 3.721875 92 33 86.3 0 43 318 71 162 ANG60896.1 heat shock protein 90 [Skeletonema marinoi] diamond 1191 131 0.99236641221374 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
26759221 26759221 PRJNA436017_P_NODE_21561_length_176_cov_1.402878_g21263_i0 PRJNA436017 21561 176 1.402878 2.46906528 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 61.6 3.27e-9   NR GFH51745.1 426638 g21263 i0 54.1 2.01136363636364 61 22 95.5 3 168 1 480 539 GFH51745.1 t-complex protein 1 gamma subunit [Chaetoceros tenuissimus] diamond 354 61.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
26791106 26791106 PRJNA436017_P_NODE_27541_length_156_cov_0.857143_g27243_i0 PRJNA436017 27541 156 0.857143 1.33714308 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 97.8 2.03e-22   NR XP_002287004.1 296543 g27243 i0 86.3 1.96153846153846 51 7 98.1 0 2 154 287 337 XP_002287004.1 predicted protein [Thalassiosira pseudonana CCMP1335] diamond 306 97.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
26902601 26902601 PRJNA436017_P_NODE_10141_length_271_cov_1.393162_g9843_i0 PRJNA436017 10141 271 1.393162 3.77546902 Cylindrotheca 2852 SAR_Eukaryotes SAR_Eukaryotes 63.2 3.41e-9   NR CAJ1939047.1 2856 g9843 i0 44.9 1.52767527675277 69 34 72 1 77 271 386 454 CAJ1939047.1 unnamed protein product [Cylindrotheca closterium] diamond 414 63.5 0.995275590551181 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
27581291 27581291 PRJNA436017_P_NODE_21144_length_178_cov_1.106383_g20846_i0 PRJNA436017 21144 178 1.106383 1.96936174 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 58.5 4.1e-8   NR XP_002183371.1 556484 g20846 i0 46.6 0.97752808988764 58 31 97.8 0 177 4 243 300 XP_002183371.1 reductase with NAD or NADP as acceptor [Phaeodactylum tricornutum CCAP 1055/1] diamond 174 58.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27644736 27644736 PRJNA436017_P_NODE_14884_length_215_cov_2.191011_g14586_i0 PRJNA436017 14884 215 2.191011 4.71067365 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 48.9 1.45e-4   NR KAL3780735.1 29204 g14586 i0 41.5 1.78604651162791 65 36 89.3 2 192 1 28 91 KAL3780735.1 hypothetical protein HJC23_001017 [Cyclotella cryptica] diamond 384 48.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
28071316 28071316 PRJNA436017_P_NODE_9425_length_283_cov_1.556911_g9127_i0 PRJNA436017 9425 283 1.556911 4.40605813 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 88.6 5.49e-20   NR EJK58599.1 159749 g9127 i0 60.8 4.72791519434629 74 23 72.1 1 283 80 71 144 EJK58599.1 hypothetical protein THAOC_21264 [Thalassiosira oceanica] diamond 1338 88.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
28260652 28260652 PRJNA436017_P_NODE_9086_length_289_cov_3.154762_g8788_i0 PRJNA436017 9086 289 3.154762 9.11726218 root 1 Root_unresolved Root_unresolved 81.3 2.56e-17   NR YP_010047250.1 444606 g8788 i0 43.6 4.91003460207612 94 52 97.6 1 283 2 20 112 YP_010047250.1 ribosomal protein L14 [Eucampia zodiacus] diamond 1419 81.3 1 Eukaryota Sar   Bacillariophyta Mediophyceae Hemiaulales Hemiaulaceae Eucampia Eucampia zodiacus
28528763 28528763 PRJNA436017_P_NODE_24147_length_166_cov_1.209302_g23849_i0 PRJNA436017 24147 166 1.209302 2.00744132 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 86.7 3.52e-18   NR KAL3904963.1 3061772 g23849 i0 74.5 3.97590361445783 55 14 99.4 0 2 166 332 386 KAL3904963.1 MAG: hypothetical protein SGARI_004678 [Bacillariaceae sp.] diamond 660 86.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
28812417 28812417 PRJNA436017_P_NODE_24768_length_164_cov_1.212598_g24470_i0 PRJNA436017 24768 164 1.212598 1.98866072 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 85.9 7.96e-18   NR GFH45451.1 426638 g24470 i0 72.2 1.97560975609756 54 15 98.8 0 3 164 564 617 GFH45451.1 PLP-dependent transferase [Chaetoceros tenuissimus] diamond 324 85.9 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
28844139 28844139 PRJNA436017_P_NODE_16308_length_204_cov_1.634731_g16010_i0 PRJNA436017 16308 204 1.634731 3.33485124 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 61.6 3.55e-10   NR AID23596.1 2850 g16010 i0 49.2 0.897058823529412 61 31 89.7 0 204 22 57 117 AID23596.1 putative voltage-dependent anion-selective channel protein, partial [Phaeodactylum tricornutum] diamond 183 61.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29191751 29191751 PRJNA436017_P_NODE_27189_length_156_cov_2.571429_g26891_i0 PRJNA436017 27189 156 2.571429 4.01142924 Melosira undulata 2133757 SAR_Eukaryotes SAR_Eukaryotes 68.6 7.08e-12   NR YP_009485500.1 2133757 g26891 i0 66.7 2.75 48 16 92.3 0 144 1 3 50 YP_009485500.1 NADH dehydrogenase subunit 1 [Melosira undulata] diamond 429 68.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Melosirales Melosiraceae Melosira Melosira undulata
29443987 29443987 PRJNA436017_P_NODE_23090_length_170_cov_1.157895_g22792_i0 PRJNA436017 23090 170 1.157895 1.9684215 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 60.1 9.49e-9   NR XP_002183496.1 556484 g22792 i0 57.8 3.28235294117647 45 19 79.4 0 145 11 92 136 XP_002183496.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 558 60.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29934473 29934473 PRJNA436017_P_NODE_28751_length_152_cov_1.356522_g28453_i0 PRJNA436017 28751 152 1.356522 2.06191344 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 46.2 6.39e-4   NR KAL3760247.1 259834 g28453 i0 51.3 1.5 39 19 77 0 151 35 295 333 KAL3760247.1 hypothetical protein ACHAWU_001757 [Discostella pseudostelligera] diamond 228 46.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
29981102 29981102 PRJNA436017_P_NODE_18931_length_188_cov_1.549669_g18633_i0 PRJNA436017 18931 188 1.549669 2.91337772 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 57 1.66e-7   NR CAJ1936289.1 2856 g18633 i0 46.8 2.96808510638298 62 33 98.9 0 186 1 273 334 CAJ1936289.1 unnamed protein product [Cylindrotheca closterium] diamond 558 57 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
30692517 30692517 PRJNA436017_P_NODE_25053_length_163_cov_1.230159_g24755_i0 PRJNA436017 25053 163 1.230159 2.00515917 Cyclotella 29203 SAR_Eukaryotes SAR_Eukaryotes 57.4 8.28e-8   NR KAL3805288.1 29204 g24755 i0 52.9 1.87730061349693 51 24 93.9 0 163 11 177 227 KAL3805288.1 hypothetical protein HJC23_008995 [Cyclotella cryptica] diamond 306 57.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
30897500 30897500 PRJNA436017_P_NODE_26634_length_158_cov_1.289256_g26336_i0 PRJNA436017 26634 158 1.289256 2.03702448 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 55.5 3.78e-7   NR GFH60747.1 426638 g26336 i0 51 1.91772151898734 49 24 93 0 148 2 142 190 GFH60747.1 hypothetical protein CTEN210_17223 [Chaetoceros tenuissimus] diamond 303 55.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus

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