RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 18 ✖

bioproject 1

  • PRJNA315399 · 18 ✖

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
5488691 5488691 PRJNA315399_S_NODE_30645_length_246_cov_16.770335_g30444_i0 PRJNA315399 30645 246 16.770335 41.2550241 Fragilariopsis cylindrus 186039 SAR_Eukaryotes SAR_Eukaryotes 344 3.27e-90   NTclustered gi|1783488149|ref|NC_045244.1| 186039 g30444 i0 95.37 170.50406504065 216 10 88 0 15 230 4488 4703 Fragilariopsis cylindrus chloroplast, complete genome blastn 41944 344 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
5489018 5489018 PRJNA315399_S_NODE_56025_length_208_cov_4.467836_g55824_i0 PRJNA315399 56025 208 4.467836 9.29309888 Coscinodiscus granii 265552 SAR_Eukaryotes SAR_Eukaryotes 69.4 1.81e-7   NTclustered gi|2192941198|ref|NC_060315.1| 265552 g55824 i0 81.522 3.78365384615385 92 10 41 7 109 194 24555 24645 Coscinodiscus granii mitochondrion, complete sequence blastn 787 69.4 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus granii
6760520 6760520 PRJNA315399_P_NODE_371886_length_165_cov_3.945312_g371438_i0 PRJNA315399 371886 165 3.945312 6.5097648 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 68.6 1.5e-12   NR QXE46253.1 303405 g371438 i0 73.1 1.89090909090909 52 8 83.6 1 14 151 42 93 QXE46253.1 50S ribosomal protein L5 [Nitzschia inconspicua] diamond 312 68.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
8035023 8035023 PRJNA315399_P_NODE_197227_length_185_cov_3.405405_g196779_i0 PRJNA315399 197227 185 3.405405 6.29999925 Navicula sp. 1923966 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.016   NTclustered gi|2633304288|gb|OR795085.1| 1923966 g196779 i0 100 0.302702702702703 28 0 15 0 152 179 15149 15176 Navicula sp. strain SZCZEY2262 plastid, complete genome blastn 56 52.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
8038027 8038027 PRJNA315399_S_NODE_182027_length_153_cov_4.120690_g181826_i0 PRJNA315399 182027 153 4.12069 6.3046557 Luticola goeppertiana 431370 SAR_Eukaryotes SAR_Eukaryotes 128 2.02e-25   NTclustered gi|167891911|emb|AM710522.1| 431370 g181826 i0 84.444 43.5294117647059 135 15 86 5 20 150 334 466 Luticola goeppertiana partial 28S rRNA gene, strain AT-104Gel12a blastn 6660 128 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Diadesmidaceae Luticola Luticola goeppertiana
12545114 12545114 PRJNA315399_S_NODE_148870_length_161_cov_3.346774_g148669_i0 PRJNA315399 148870 161 3.346774 5.38830614 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 85.5 4.1e-18   NR KAG7367615.1 303405 g148669 i0 87 1.75155279503106 46 6 85.7 0 153 16 233 278 KAG7367615.1 acidic ribosomal protein P0 RplPO [Nitzschia inconspicua] diamond 282 85.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
15685462 15685462 PRJNA315399_P_NODE_367053_length_166_cov_2.782946_g366605_i0 PRJNA315399 367053 166 2.782946 4.61969036 Tryblionella apiculata 1003145 SAR_Eukaryotes SAR_Eukaryotes 89.8 1.06e-13   NTclustered gi|2088232623|ref|NC_056791.1| 1003145 g366605 i0 88 2.49397590361446 75 9 45 0 76 150 4346 4272 Tryblionella apiculata isolate SZCZR1825 chloroplast, complete genome blastn 414 89.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Tryblionella Tryblionella apiculata
19511285 19511285 PRJNA315399_S_NODE_43636_length_223_cov_2.930108_g43435_i0 PRJNA315399 43636 223 2.930108 6.53414084 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.02   NTclustered gi|224013871|ref|XM_002296564.1| 296543 g43435 i0 100 0.125560538116592 28 0 13 0 126 153 217 190 Thalassiosira pseudonana CCMP1335 predicted protein partial mRNA blastn 28 52.8 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
23333678 23333678 PRJNA315399_P_NODE_180839_length_186_cov_4.087248_g180391_i0 PRJNA315399 180839 186 4.087248 7.60228128 Navicula tsukamotoi 2018706 SAR_Eukaryotes SAR_Eukaryotes 58.4 3.42e-4   NTclustered gi|2288719593|gb|OL415007.1| 2018706 g180391 i0 94.595 0.763440860215054 37 2 20 0 149 185 67203 67167 Haslea tsukamotoi isolate Jiaozhou Bay in China chloroplast, complete genome blastn 142 58.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula tsukamotoi
27169022 27169022 PRJNA315399_P_NODE_456562_length_155_cov_6.449153_g456114_i0 PRJNA315399 456562 155 6.449153 9.99618715 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0155   NR CAB9502967.1 568900 g456114 i0 57.7 1.50967741935484 26 11 50.3 0 155 78 291 316 CAB9502967.1 expressed unknown protein [Seminavis robusta] diamond 234 42.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
28653465 28653465 PRJNA315399_P_NODE_221507_length_183_cov_7.691781_g221059_i0 PRJNA315399 221507 183 7.691781 14.07595923 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0129   NR KAL3920403.1 3061772 g221059 i0 81.8 0.360655737704918 22 4 36.1 0 75 10 49 70 KAL3920403.1 MAG: hypothetical protein SGILL_003281 [Bacillariaceae sp.] diamond 66 43.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
30579684 30579684 PRJNA315399_P_NODE_446993_length_156_cov_7.436975_g446545_i0 PRJNA315399 446993 156 7.436975 11.601681 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 46.2 6.74e-4   NR KAI2510797.1 210448 g446545 i0 48.8 0.788461538461538 41 21 78.8 0 148 26 1311 1351 KAI2510797.1 AMP-binding enzyme [Fragilaria crotonensis] diamond 123 46.2 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30786985 30786985 PRJNA315399_S_NODE_189254_length_152_cov_1.573913_g189053_i0 PRJNA315399 189254 152 1.573913 2.39234776 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 89.4 1.31e-19   NR KAK1741393.1 267567 g189053 i0 87 1.81578947368421 46 6 90.8 0 140 3 258 303 KAK1741393.1 soluble NSF attachment protein [Skeletonema marinoi] diamond 276 90.1 0.992230854605993 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
30801033 30801033 PRJNA315399_S_NODE_121274_length_170_cov_1.736842_g121073_i0 PRJNA315399 121274 170 1.736842 2.9526314 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 53.9 1.58e-6   NR GAX27613.1 1519565 g121073 i0 51 1.8 51 25 90 0 158 6 601 651 GAX27613.1 hypothetical protein FisN_13Hh298 [Fistulifera solaris] diamond 306 53.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
31179936 31179936 PRJNA315399_P_NODE_44655_length_245_cov_3.331731_g44207_i0 PRJNA315399 44655 245 3.331731 8.16274095 Craticula sp. 2862135 SAR_Eukaryotes SAR_Eukaryotes 97.8 1.1499999999999999e-23   NR XOB89985.1 2862135 g44207 i0 79.3 2.13061224489796 58 12 71 0 11 184 105 162 XOB89985.1 hypothetical chloroplast RF88 [Craticula sp.] diamond 522 97.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Craticula Craticula sp.
31243451 31243451 PRJNA315399_P_NODE_495255_length_151_cov_10.052632_g494807_i0 PRJNA315399 495255 151 10.052632 15.17947432 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 48.9 6.79e-5   NR KAL3938584.1 3061772 g494807 i0 87.5 0.47682119205298 24 3 47.7 0 146 75 285 308 KAL3938584.1 MAG: hypothetical protein SGARI_001684 [Bacillariaceae sp.] diamond 72 48.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
32097544 32097544 PRJNA315399_S_NODE_133118_length_166_cov_1.728682_g132917_i0 PRJNA315399 133118 166 1.728682 2.86961212 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 52.8 3.58e-6   NR KAL3906936.1 3061772 g132917 i0 49 5.53012048192771 51 26 92.2 0 153 1 234 284 KAL3906936.1 MAG: hypothetical protein SGILL_009075, partial [Bacillariaceae sp.] diamond 918 52.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
32855451 32855451 PRJNA315399_P_NODE_496440_length_151_cov_6.719298_g495992_i0 PRJNA315399 496440 151 6.719298 10.14613998 Asterionellopsis glacialis 33640 SAR_Eukaryotes SAR_Eukaryotes 68.6 8.1e-12   NR YP_009028828.1 33640 g495992 i0 72.1 1.70860927152318 43 12 85.4 0 13 141 206 248 YP_009028828.1 c-type cytochrome biogenesis protein [Asterionellopsis glacialis] diamond 258 68.6 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionellopsis Asterionellopsis glacialis

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