RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 28 ✖

bioproject 1

  • PRJNA312615 · 28 ✖

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
1652611 1652611 PRJNA312615_P_NODE_15782_length_309_cov_8.484615_g15631_i0 PRJNA312615 15782 309 8.484615 26.21746035 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 85.1 1.21e-18   NR KAL3789159.1 29204 g15631 i0 59.5 3.62135922330097 74 29 71.8 1 302 81 55 127 KAL3789159.1 hypothetical protein HJC23_012248 [Cyclotella cryptica] diamond 1119 85.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
2339197 2339197 PRJNA312615_P_NODE_38142_length_199_cov_1.020000_g37991_i0 PRJNA312615 38142 199 1.02 2.0298 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 80.5 9.87e-16   NR KAK1732416.1 267567 g37991 i0 61.5 0.979899497487437 65 21 98 1 197 3 465 525 KAK1732416.1 DnaJ domain-containing protein [Skeletonema marinoi] diamond 195 80.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
5481818 5481818 PRJNA312615_P_NODE_40145_length_193_cov_2.833333_g39994_i0 PRJNA312615 40145 193 2.833333 5.46833269 Minutocellus polymorphus 265543 SAR_Eukaryotes SAR_Eukaryotes 95.3 2.73e-15   NTclustered gi|2020303798|gb|MW417227.1| 265543 g39994 i0 82.883 1.40414507772021 111 13 56 5 5 112 8590 8483 Minutocellus polymorphus isolate CNS00217 mitochondrion, complete genome blastn 271 95.3 1 Eukaryota Sar   Bacillariophyta Mediophyceae Cymatosirales Cymatosiraceae Minutocellus Minutocellus polymorphus
9992105 9992105 PRJNA312615_P_NODE_37428_length_201_cov_0.842105_g37277_i0 PRJNA312615 37428 201 0.842105 1.69263105 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 107 3.32e-25   NR CAJ1903596.1 2856 g37277 i0 77.3 49.2537313432836 66 15 98.5 0 3 200 240 305 CAJ1903596.1 unnamed protein product [Cylindrotheca closterium] diamond 9900 107 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
10582704 10582704 PRJNA312615_P_NODE_6289_length_486_cov_1.107551_g6141_i0 PRJNA312615 6289 486 1.107551 5.38269786 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 177 7.9e-53   NR CAJ1953473.1 2856 g6141 i0 59.6 3.3641975308642 136 53 84 1 409 2 72 205 CAJ1953473.1 unnamed protein product [Cylindrotheca closterium] diamond 1635 177 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
13131517 13131517 PRJNA312615_P_NODE_1291_length_901_cov_4.109155_g1184_i0 PRJNA312615 1291 901 4.109155 37.02348655 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 438 5.979999999999999e-118   NTclustered gi|657012367|gb|KF302531.1| 2850 g1184 i0 88.462 56.7269700332963 364 40 40 2 290 652 385 23 Phaeodactylum tricornutum clone C443 40S ribosomal protein mRNA, partial cds blastn 51111 438 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
18230509 18230509 PRJNA312615_P_NODE_8135_length_431_cov_8.829843_g7985_i0 PRJNA312615 8135 431 8.829843 38.05662333 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 227 4.989999999999999e-72   NR KAI2505670.1 210448 g7985 i0 74.5 8.83294663573086 141 36 98.1 0 424 2 6 146 KAI2505670.1 small subunit ribosomal protein [Fragilaria crotonensis] diamond 3807 228 0.995614035087719 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
27422128 27422128 PRJNA312615_P_NODE_25703_length_241_cov_1.750000_g25552_i0 PRJNA312615 25703 241 1.75 4.2175 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 135 1.1599999999999999e-34   NR KAL3766662.1 259834 g25552 i0 74.7 0.983402489626556 79 20 98.3 0 3 239 442 520 KAL3766662.1 hypothetical protein ACHAWU_003418 [Discostella pseudostelligera] diamond 237 135 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
27692346 27692346 PRJNA312615_P_NODE_51664_length_167_cov_0.864407_g51513_i0 PRJNA312615 51664 167 0.864407 1.44355969 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 99 1.22e-22   NR KAL3789199.1 382360 g51513 i0 81.8 1.97604790419162 55 10 98.8 0 165 1 349 403 KAL3789199.1 hypothetical protein ACHAWO_013927 [Cyclotella atomus] diamond 330 100 0.99 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
27769479 27769479 PRJNA312615_P_NODE_37284_length_201_cov_1.342105_g37133_i0 PRJNA312615 37284 201 1.342105 2.69763105 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0286   NR KAL3939524.1 3061772 g37133 i0 41.5 0.611940298507463 41 24 61.2 0 2 124 333 373 KAL3939524.1 MAG: hypothetical protein SGBAC_005774 [Bacillariaceae sp.] diamond 123 42.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
28053306 28053306 PRJNA312615_P_NODE_42485_length_188_cov_1.064748_g42334_i0 PRJNA312615 42485 188 1.064748 2.00172624 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 114 8.71e-28   NR CAB9530945.1 568900 g42334 i0 86.9 0.973404255319149 61 8 97.3 0 183 1 394 454 CAB9530945.1 Malonate-semialdehyde dehydrogenase [Seminavis robusta] diamond 183 114 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28165732 28165732 PRJNA312615_P_NODE_18725_length_282_cov_1.094421_g18574_i0 PRJNA312615 18725 282 1.094421 3.08626722 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 138 1.21e-35   NR CAJ1937784.1 2856 g18574 i0 66.3 5 95 31 100 1 282 1 252 346 CAJ1937784.1 unnamed protein product [Cylindrotheca closterium] diamond 1410 139 0.992805755395683 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
28211079 28211079 PRJNA312615_P_NODE_24546_length_247_cov_0.929293_g24395_i0 PRJNA312615 24546 247 0.929293 2.29535371 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 58.5 9.01e-8   NR KAL3769864.1 259834 g24395 i0 47.8 0.558704453441296 46 24 55.9 0 65 202 85 130 KAL3769864.1 hypothetical protein ACHAWU_007070 [Discostella pseudostelligera] diamond 138 58.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
28400715 28400715 PRJNA312615_P_NODE_27846_length_231_cov_11.780220_g27695_i0 PRJNA312615 27846 231 11.78022 27.2123082 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 89.4 5.27e-21   NR GKY97253.1 2872254 g27695 i0 67.2 0.831168831168831 64 21 83.1 0 210 19 40 103 GKY97253.1 60S ribosomal protein L38 [Mayamaea pseudoterrestris] diamond 192 89.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28621861 28621861 PRJNA312615_P_NODE_21847_length_261_cov_1.202830_g21696_i0 PRJNA312615 21847 261 1.20283 3.1393863 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 50.1 1.19e-4   NR EJK58700.1 159749 g21696 i0 52.6 0.436781609195402 38 18 43.7 0 261 148 230 267 EJK58700.1 hypothetical protein THAOC_21153 [Thalassiosira oceanica] diamond 114 50.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
28860195 28860195 PRJNA312615_P_NODE_32508_length_214_cov_3.842424_g32357_i0 PRJNA312615 32508 214 3.842424 8.22278736 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 47.8 4.23e-4   NR GFH53429.1 426638 g32357 i0 67.6 1.47196261682243 34 10 46.3 1 2 100 293 326 GFH53429.1 hypothetical protein CTEN210_09905 [Chaetoceros tenuissimus] diamond 315 47.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
29663317 29663317 PRJNA312615_P_NODE_50850_length_167_cov_2.305085_g50699_i0 PRJNA312615 50850 167 2.305085 3.84949195 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 82.4 3.61e-17   NR KAI2505670.1 210448 g50699 i0 80.9 4.22155688622755 47 9 84.4 0 27 167 6 52 KAI2505670.1 small subunit ribosomal protein [Fragilaria crotonensis] diamond 705 82.4 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29680895 29680895 PRJNA312615_P_NODE_43190_length_186_cov_1.386861_g43039_i0 PRJNA312615 43190 186 1.386861 2.57956146 root 1 Root_unresolved Root_unresolved 92.8 3.96e-20   NR VEU42702.1 183589 g43039 i0 67.8 2.91935483870968 59 19 95.2 0 179 3 342 400 VEU42702.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 543 93.6 0.991452991452991 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
29712415 29712415 PRJNA312615_P_NODE_24510_length_247_cov_1.030303_g24359_i0 PRJNA312615 24510 247 1.030303 2.54484841 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 117 2.89e-31   NR KAG7352862.1 303405 g24359 i0 64.2 17.7692307692308 81 29 98.4 0 243 1 5 85 KAG7352862.1 ubiquitin-conjugating enzyme [Nitzschia inconspicua] diamond 4389 117 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
29775816 29775816 PRJNA312615_P_NODE_23291_length_253_cov_0.995098_g23140_i0 PRJNA312615 23291 253 0.995098 2.51759794 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 98.2 1.18e-21   NR VEU41781.1 183589 g23140 i0 60 10.4940711462451 80 32 94.9 0 251 12 286 365 VEU41781.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 2655 98.6 0.995943204868154 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
30769448 30769448 PRJNA312615_P_NODE_24694_length_246_cov_1.294416_g24543_i0 PRJNA312615 24694 246 1.294416 3.18426336 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 61.6 8.58e-9   NR OEU17226.1 635003 g24543 i0 57.5 0.48780487804878 40 17 48.8 0 3 122 23 62 OEU17226.1 DUF906-domain-containing protein [Fragilariopsis cylindrus CCMP1102] diamond 120 61.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
31450804 31450804 PRJNA312615_P_NODE_56636_length_163_cov_0.894737_g56485_i0 PRJNA312615 56636 163 0.894737 1.45842131 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 67.4 2.55e-11   NR GFH49370.1 426638 g56485 i0 53.7 3.97546012269939 54 25 99.4 0 162 1 307 360 GFH49370.1 cation-transporting ATPase 13A1 [Chaetoceros tenuissimus] diamond 648 67.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
31496582 31496582 PRJNA312615_P_NODE_24276_length_248_cov_1.025126_g24125_i0 PRJNA312615 24276 248 1.025126 2.54231248 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 68.9 1.42e-11   NR CAJ1959525.1 2856 g24125 i0 56.9 1.51209677419355 58 24 69 1 175 5 154 211 CAJ1959525.1 unnamed protein product [Cylindrotheca closterium] diamond 375 68.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31893477 31893477 PRJNA312615_P_NODE_27337_length_234_cov_1.097297_g27186_i0 PRJNA312615 27337 234 1.097297 2.56767498 root 1 Root_unresolved Root_unresolved 123 4.42e-31   NR VEU34853.1 183589 g27186 i0 79.2 2.96153846153846 77 16 98.7 0 2 232 37 113 VEU34853.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 693 123 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
31939087 31939087 PRJNA312615_P_NODE_27177_length_234_cov_3.005405_g27026_i0 PRJNA312615 27177 234 3.005405 7.0326477 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 60.1 6.56e-10   NR KAL3790387.1 382360 g27026 i0 52 1.28205128205128 50 24 64.1 0 48 197 1 50 KAL3790387.1 hypothetical protein ACHAWO_011602 [Cyclotella atomus] diamond 300 60.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
32160893 32160893 PRJNA312615_P_NODE_26778_length_236_cov_1.636364_g26627_i0 PRJNA312615 26778 236 1.636364 3.86181904 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 78.2 1.13e-14   NR KAL3805512.1 2934178 g26627 i0 55.7 3.8771186440678 61 27 77.5 0 2 184 901 961 KAL3805512.1 hypothetical protein ACHAW5_011183 [Stephanodiscus triporus] diamond 915 78.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
32620928 32620928 PRJNA312615_P_NODE_38900_length_197_cov_1.033784_g38749_i0 PRJNA312615 38900 197 1.033784 2.03655448 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 97.1 1.18e-21   NR KAG7367217.1 303405 g38749 i0 79.4 5.77157360406091 63 13 95.9 0 193 5 117 179 KAG7367217.1 enolase [Nitzschia inconspicua] diamond 1137 97.4 0.996919917864476 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
32634724 32634724 PRJNA312615_P_NODE_32220_length_215_cov_3.066265_g32069_i0 PRJNA312615 32220 215 3.066265 6.59246975 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 47 3.02e-4   NR EJK74848.1 159749 g32069 i0 57.9 0.530232558139535 38 16 53 0 100 213 11 48 EJK74848.1 hypothetical protein THAOC_03450 [Thalassiosira oceanica] diamond 114 47 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);;