RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 27 ✖

bioproject 1

  • PRJEB17675 · 27 ✖

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
2571536 2571536 PRJEB17675_P_NODE_223_length_1662_cov_13.105716_g179_i0 PRJEB17675 223 1662 13.105716 217.81699992 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 316 5.49e-81   NTclustered gi|2074156200|gb|MW413905.1| 216802 g179 i0 75.099 38.384476534296 755 149 44 29 190 922 23865 24602 Guinardia delicatula mitochondrion, complete genome blastn 63795 316 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
10224429 10224429 PRJEB17675_P_NODE_25629_length_150_cov_1.026087_g25325_i0 PRJEB17675 25629 150 1.026087 1.5391305 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 92.8 2.44e-20   NR KAL3826939.1 382380 g25325 i0 84 2.96 50 8 100 0 150 1 67 116 KAL3826939.1 hypothetical protein ACHAXA_006019 [Cyclostephanos tholiformis] diamond 444 92.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
20422389 20422389 PRJEB17675_P_NODE_3557_length_520_cov_5.338144_g3274_i0 PRJEB17675 3557 520 5.338144 27.7583488 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 259 1.04e-85   NR GFH58715.1 426638 g3274 i0 85.5 6.99230769230769 152 22 87.7 0 499 44 15 166 GFH58715.1 small subunit ribosomal protein S13e [Chaetoceros tenuissimus] diamond 3636 259 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
24247536 24247536 PRJEB17675_P_NODE_600_length_1169_cov_6.547619_g179_i1 PRJEB17675 600 1169 6.547619 76.54166611 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 237 3.0699999999999995e-57   NTclustered gi|2074156200|gb|MW413905.1| 216802 g179 i1 78.701 32.8023952095808 385 61 32 15 741 1115 24602 24229 Guinardia delicatula mitochondrion, complete genome blastn 38346 237 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
26805112 26805112 PRJEB17675_P_NODE_11001_length_259_cov_1.638393_g10697_i0 PRJEB17675 11001 259 1.638393 4.24343787 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 58.9 1.55e-8   NR KAG7338878.1 303405 g10697 i0 45.8 4.91119691119691 48 26 55.6 0 257 114 103 150 KAG7338878.1 cytochrome oxidase c subunit VIb [Nitzschia inconspicua] diamond 1272 58.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
26906593 26906593 PRJEB17675_P_NODE_17682_length_188_cov_1.875817_g17378_i0 PRJEB17675 17682 188 1.875817 3.52653596 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 79.7 1.04e-15   NR KAG7374229.1 303405 g17378 i0 59.7 2.96808510638298 62 24 98.9 1 188 3 198 258 KAG7374229.1 pirin-like protein [Nitzschia inconspicua] diamond 558 79.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27191073 27191073 PRJEB17675_P_NODE_23422_length_158_cov_0.934959_g23118_i0 PRJEB17675 23422 158 0.934959 1.47723522 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.00745   NR KAI2494408.1 210448 g23118 i0 48.1 3.81645569620253 52 19 98.7 1 157 2 166 209 KAI2494408.1 hypothetical protein MHU86_20137 [Fragilaria crotonensis] diamond 603 43.1 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
27381027 27381027 PRJEB17675_P_NODE_4563_length_455_cov_6.980952_g4266_i0 PRJEB17675 4563 455 6.980952 31.7633316 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 183 1.06e-56   NR KAK1745333.1 267567 g4266 i0 65.7 4.39120879120879 134 46 88.4 0 438 37 1 134 KAK1745333.1 60S ribosomal protein L14 [Skeletonema marinoi] diamond 1998 183 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
27633560 27633560 PRJEB17675_P_NODE_6444_length_370_cov_2.552239_g6141_i0 PRJEB17675 6444 370 2.552239 9.4432843 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 142 5.599999999999998e-41   NR GAX27651.1 1519565 g6141 i0 56.2 1.91351351351351 121 50 98.1 1 4 366 1 118 GAX27651.1 hypothetical protein FisN_13Hh257 [Fistulifera solaris] diamond 708 142 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
27728534 27728534 PRJEB17675_P_NODE_22524_length_161_cov_1.484127_g22220_i0 PRJEB17675 22524 161 1.484127 2.38944447 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 56.2 2.12e-7   NR XP_002293192.1 296543 g22220 i0 51.9 1.93788819875776 52 25 96.9 0 156 1 790 841 XP_002293192.1 predicted protein [Thalassiosira pseudonana CCMP1335] diamond 312 56.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
27791425 27791425 PRJEB17675_P_NODE_3884_length_496_cov_3.286334_g3595_i0 PRJEB17675 3884 496 3.286334 16.30021664 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 142 2.3699999999999998e-40   NR GAX20915.1 1519565 g3595 i0 53.9 7.13709677419355 128 58 76.8 1 69 449 7 134 GAX20915.1 large subunit ribosomal protein L32e [Fistulifera solaris] diamond 3540 142 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
28574179 28574179 PRJEB17675_P_NODE_6547_length_367_cov_1.530120_g6244_i0 PRJEB17675 6547 367 1.53012 5.6155404 root 1 Root_unresolved Root_unresolved 55.5 5.11e-6   NR CAB9500082.1 568900 g6244 i0 40 3.03269754768392 60 30 49 1 1 180 324 377 CAB9500082.1 expressed unknown protein [Seminavis robusta] diamond 1113 55.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28580775 28580775 PRJEB17675_P_NODE_22027_length_163_cov_2.179688_g21723_i0 PRJEB17675 22027 163 2.179688 3.55289144 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 56.6 1.51e-7   NR KAL3762188.1 2934178 g21723 i0 47.5 3.05521472392638 59 24 95.7 1 2 157 87 145 KAL3762188.1 hypothetical protein ACHAW5_002776 [Stephanodiscus triporus] diamond 498 56.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
29338514 29338514 PRJEB17675_P_NODE_1209_length_880_cov_2.790533_g1039_i0 PRJEB17675 1209 880 2.790533 24.5566904 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 153 2.77e-39   NR KAL3914052.1 3061772 g1039 i0 39.1 2.325 225 113 76.7 2 50 724 64 264 KAL3914052.1 MAG: hypothetical protein SGARI_000331 [Bacillariaceae sp.] diamond 2046 153 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
29363700 29363700 PRJEB17675_P_NODE_14509_length_214_cov_2.011173_g14205_i0 PRJEB17675 14509 214 2.011173 4.30391022 root 1 Root_unresolved Root_unresolved 60.1 1.98e-8   NR KAI2488745.1 210448 g14205 i0 35.2 3.96728971962617 71 46 99.5 0 214 2 306 376 KAI2488745.1 Phosphatidylinositol 3- and 4-kinase [Fragilaria crotonensis] diamond 849 60.5 0.993388429752066 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29426542 29426542 PRJEB17675_P_NODE_17909_length_187_cov_1.052632_g17605_i0 PRJEB17675 17909 187 1.052632 1.96842184 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 76.3 1.36e-14   NR XP_002176750.1 556484 g17605 i0 66.1 7.81283422459893 62 19 99.5 1 2 187 71 130 XP_002176750.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 1461 77 0.990909090909091 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
29521429 29521429 PRJEB17675_P_NODE_13210_length_229_cov_1.030928_g12906_i0 PRJEB17675 13210 229 1.030928 2.36082512 root 1 Root_unresolved Root_unresolved 51.6 1.07e-5   NR XP_002287520.1 296543 g12906 i0 60 2.17467248908297 50 20 65.5 0 3 152 133 182 XP_002287520.1 RL19, ribosomal protein 19 60S large ribosomal subunit [Thalassiosira pseudonana CCMP1335] diamond 498 51.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
29685409 29685409 PRJEB17675_P_NODE_10990_length_259_cov_1.821429_g10686_i0 PRJEB17675 10990 259 1.821429 4.71750111 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 100 8.19e-24   NR KAI2510725.1 210448 g10686 i0 64.7 1.45945945945946 68 24 78.8 0 2 205 158 225 KAI2510725.1 Redoxin [Fragilaria crotonensis] diamond 378 100 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29685410 29685410 PRJEB17675_P_NODE_11330_length_253_cov_2.064220_g11026_i0 PRJEB17675 11330 253 2.06422 5.2224766 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 64.3 1.1e-9   NR CAB9497050.1 568900 g11026 i0 36.8 1.03162055335968 87 48 94.9 1 13 252 148 234 CAB9497050.1 expressed unknown protein [Seminavis robusta] diamond 261 64.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
29932174 29932174 PRJEB17675_P_NODE_18811_length_181_cov_1.643836_g18507_i0 PRJEB17675 18811 181 1.643836 2.97534316 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 79.7 1.24e-17   NR EJK75661.1 159749 g18507 i0 85.7 2.78453038674033 42 6 69.6 0 2 127 58 99 EJK75661.1 hypothetical protein THAOC_02610 [Thalassiosira oceanica] diamond 504 79.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
29938504 29938504 PRJEB17675_P_NODE_9371_length_288_cov_1.833992_g9067_i0 PRJEB17675 9371 288 1.833992 5.28189696 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 75.5 2.01e-13   NR GAX27417.1 1519565 g9067 i0 56.5 0.645833333333333 62 27 64.6 0 288 103 610 671 GAX27417.1 glycyl-tRNA synthetase [Fistulifera solaris] diamond 186 75.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
30191032 30191032 PRJEB17675_P_NODE_6432_length_371_cov_1.276786_g6129_i0 PRJEB17675 6432 371 1.276786 4.73687606 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 52 8.97e-5   NR CAB9499583.1 568900 g6129 i0 50 0.857142857142857 50 25 40.4 0 168 317 96 145 CAB9499583.1 MAP kinase-activated protein kinase 2 (Fragment) [Seminavis robusta] diamond 318 52 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31708260 31708260 PRJEB17675_P_NODE_9277_length_290_cov_1.364706_g8973_i0 PRJEB17675 9277 290 1.364706 3.9576474 Chaetoceros tenuissimus 426638 SAR_Eukaryotes SAR_Eukaryotes 62.4 9.17e-10   NR GFH60095.1 426638 g8973 i0 51.5 1.24137931034483 66 32 68.3 0 91 288 11 76 GFH60095.1 hypothetical protein CTEN210_16571 [Chaetoceros tenuissimus] diamond 360 62.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros tenuissimus
31739739 31739739 PRJEB17675_P_NODE_5897_length_391_cov_1.629213_g5597_i0 PRJEB17675 5897 391 1.629213 6.37022283 Pseudo-nitzschia multistriata 183589 SAR_Eukaryotes SAR_Eukaryotes 54.7 1.15e-5   NR VEU38093.1 183589 g5597 i0 43.1 0.498721227621483 65 34 49.9 1 239 45 20 81 VEU38093.1 unnamed protein product [Pseudo-nitzschia multistriata] diamond 195 54.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia multistriata
32056211 32056211 PRJEB17675_P_NODE_15038_length_209_cov_1.839080_g14734_i0 PRJEB17675 15038 209 1.83908 3.8436772 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 125 8.210000000000001e-33   NR GAX20021.1 1519565 g14734 i0 79.7 2.95693779904306 69 14 99 0 208 2 97 165 GAX20021.1 uncharacterized protein FisN_1Lu502 [Fistulifera solaris] diamond 618 125 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
32087897 32087897 PRJEB17675_P_NODE_2858_length_583_cov_1.531022_g2598_i0 PRJEB17675 2858 583 1.531022 8.92585826 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 73.9 1.44e-11   NR XP_002182848.1 556484 g2598 i0 26.6 1.9811320754717 177 125 88.5 2 62 577 241 417 XP_002182848.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 1155 73.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
32341245 32341245 PRJEB17675_P_NODE_18619_length_182_cov_1.904762_g18315_i0 PRJEB17675 18619 182 1.904762 3.46666684 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 50.8 2.29e-5   NR KAL3785445.1 2934178 g18315 i0 52.9 1.68131868131868 51 24 84.1 0 2 154 594 644 KAL3785445.1 hypothetical protein ACHAW5_010925 [Stephanodiscus triporus] diamond 306 50.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);;