RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 30 ✖

bioproject 1

  • PRJNA495391 · 30 ✖

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
4935666 4935666 PRJNA495391_S_NODE_48884_length_176_cov_18.085106_g47832_i0 PRJNA495391 48884 176 18.085106 31.82978656 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 318 1.3299999999999995e-82   NTclustered gi|72398633|gb|DQ093370.1| 29207 g47832 i0 99.432 99.9261363636364 176 0 100 1 1 176 785 611 Stephanodiscus hantzschii strain CCAP 1079/4 18S small subunit ribosomal RNA gene, partial sequence blastn 17587 318 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus hantzschii
5579472 5579472 PRJNA495391_S_NODE_19825_length_269_cov_8.927350_g18773_i0 PRJNA495391 19825 269 8.92735 24.0145715 Encyonema minutum 431330 SAR_Eukaryotes SAR_Eukaryotes 497 2.63e-136   NTclustered gi|168145881|emb|AM710515.1| 431330 g18773 i0 100 100.762081784387 269 0 100 0 1 269 25 293 Encyonema minutum partial 28S rRNA gene, strain AT-137.13 blastn 27105 497 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Cymbellaceae Encyonema Encyonema minutum
6854747 6854747 PRJNA495391_S_NODE_64446_length_156_cov_2.471074_g63394_i0 PRJNA495391 64446 156 2.471074 3.85487544 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 161 2.05e-35   NTclustered gi|2620230846|gb|OR797295.1| 2126271 g63394 i0 85.987 68.5641025641026 157 15 100 6 1 156 4851 4701 Naviculales sp. strain SZCZO2114 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 10696 161 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
11310644 11310644 PRJNA495391_S_NODE_51469_length_172_cov_2.715328_g50417_i0 PRJNA495391 51469 172 2.715328 4.67036416 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 246 6.17e-61   NTclustered gi|2632235341|gb|OR922723.1| 35128 g50417 i0 96.026 87.5930232558139 151 6 88 0 1 151 3829 3679 Thalassiosira pseudonana strain AGSB0188 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 15066 246 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
12586201 12586201 PRJNA495391_S_NODE_34690_length_207_cov_1.622093_g33638_i0 PRJNA495391 34690 207 1.622093 3.35773251 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 383 5.65e-102   NTclustered gi|2468683651|ref|NC_072630.1| 29208 g33638 i0 100 198.400966183575 207 0 100 0 1 207 69399 69605 Stephanodiscus niagarae strain BB16 chloroplast, complete genome blastn 41069 383 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus niagarae
15778946 15778946 PRJNA495391_S_NODE_34093_length_208_cov_4.815029_g33041_i0 PRJNA495391 34093 208 4.815029 10.01526032 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 252 1.67e-62   NTclustered gi|146762526|gb|EF553458.1| 2850 g33041 i0 88.517 100.302884615385 209 23 100 1 1 208 4342 4134 Phaeodactylum tricornutum strain CCAP 1055/1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 20863 252 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
17685010 17685010 PRJNA495391_S_NODE_31494_length_216_cov_2.259669_g30442_i0 PRJNA495391 31494 216 2.259669 4.88088504 root 1 Root_unresolved Root_unresolved 348 2.1700000000000002e-91   NTclustered gi|74325165|ref|NC_007405.1| 35128 g30442 i0 96.244 92.6296296296296 213 7 98 1 1 212 14881 15093 Thalassiosira pseudonana mitochondrion, complete genome blastn 20008 348 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
18327417 18327417 PRJNA495391_S_NODE_13535_length_325_cov_2.289655_g12483_i0 PRJNA495391 13535 325 2.289655 7.44137875 Nitzschia palea 303400 SAR_Eukaryotes SAR_Eukaryotes 416 9.399999999999999e-112   NTclustered gi|1419234869|dbj|AP018512.1| 303400 g12483 i0 94.776 98.1261538461538 268 13 82 1 55 322 4800 5066 Nitzschia palea NIES-2729 mitochondrial DNA, nearly complete genome blastn 31891 416 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia palea
19602647 19602647 PRJNA495391_S_NODE_49596_length_175_cov_2.628571_g48544_i0 PRJNA495391 49596 175 2.628571 4.59999925 Navicula tsukamotoi 2018706 SAR_Eukaryotes SAR_Eukaryotes 307 2.8500000000000004e-79   NTclustered gi|2288719593|gb|OL415007.1| 2018706 g48544 i0 98.286 99.2857142857143 175 3 100 0 1 175 16729 16903 Haslea tsukamotoi isolate Jiaozhou Bay in China chloroplast, complete genome blastn 17375 307 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula tsukamotoi
22152422 22152422 PRJNA495391_S_NODE_17118_length_289_cov_5.413386_g16066_i0 PRJNA495391 17118 289 5.413386 15.64468554 Gomphonema parvulum 97227 SAR_Eukaryotes SAR_Eukaryotes 381 2.9999999999999997e-101   NTclustered gi|2444483253|gb|OP718170.1| 97227 g16066 i0 91.135 100.515570934256 282 24 98 1 8 289 5476 5196 Gomphonema parvulum mitochondrion, complete genome blastn 29049 381 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum
24701842 24701842 PRJNA495391_S_NODE_17840_length_283_cov_5.697581_g16788_i0 PRJNA495391 17840 283 5.697581 16.12415423 Skeletonema grevillei 371681 SAR_Eukaryotes SAR_Eukaryotes 472 1.6899999999999998e-128   NTclustered gi|2739942915|dbj|LC814775.1| 371681 g16788 i0 97.143 104.247349823322 280 7 99 1 1 280 33184 33462 Skeletonema grevillei NIES-2840 mitochondrial DNA, complete genome blastn 29502 472 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema grevillei
27123817 27123817 PRJNA495391_S_NODE_64222_length_157_cov_1.114754_g63170_i0 PRJNA495391 64222 157 1.114754 1.75016378 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 70.9 1.33e-12   NR KAI2503052.1 210448 g63170 i0 78.9 2.92356687898089 38 8 72.6 0 3 116 454 491 KAI2503052.1 NADH dehydrogenase flavoprotein [Fragilaria crotonensis] diamond 459 71.2 0.995786516853933 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
27361684 27361684 PRJNA495391_S_NODE_22483_length_253_cov_2.509174_g21431_i0 PRJNA495391 22483 253 2.509174 6.34821022 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 148 2.01e-42   NR KAL3785988.1 2934178 g21431 i0 98.6 1.69565217391304 72 1 85.4 0 251 36 33 104 KAL3785988.1 hypothetical protein ACHAW5_005367 [Stephanodiscus triporus] diamond 429 148 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
27834965 27834965 PRJNA495391_S_NODE_50004_length_175_cov_1.400000_g48952_i0 PRJNA495391 50004 175 1.4 2.45 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 70.5 2.05e-12   NR CAJ1924624.1 2856 g48952 i0 65.3 1.68 49 16 84 1 3 149 320 367 CAJ1924624.1 unnamed protein product [Cylindrotheca closterium] diamond 294 70.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
28182153 28182153 PRJNA495391_S_NODE_41766_length_190_cov_1.561290_g40714_i0 PRJNA495391 41766 190 1.56129 2.966451 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.00111   NR GAX24279.1 1519565 g40714 i0 56.7 0.473684210526316 30 13 47.4 0 2 91 492 521 GAX24279.1 hypothetical protein FisN_4Lh018 [Fistulifera solaris] diamond 90 46.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
28276980 28276980 PRJNA495391_S_NODE_63766_length_157_cov_1.819672_g62714_i0 PRJNA495391 63766 157 1.819672 2.85688504 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 53.5 1.82e-6   NR XP_002183882.1 556484 g62714 i0 74.2 1.77707006369427 31 8 59.2 0 1 93 211 241 XP_002183882.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 279 53.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
28450711 28450711 PRJNA495391_S_NODE_32206_length_214_cov_2.016760_g31154_i0 PRJNA495391 32206 214 2.01676 4.3158664 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 50.4 4.78e-5   NR KAL3756442.1 259834 g31154 i0 86.2 1.2196261682243 29 4 40.7 0 176 90 945 973 KAL3756442.1 hypothetical protein ACHAWU_001348 [Discostella pseudostelligera] diamond 261 50.8 0.992125984251969 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
28466705 28466705 PRJNA495391_S_NODE_17486_length_286_cov_4.314741_g16434_i0 PRJNA495391 17486 286 4.314741 12.34015926 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 109 6e-28   NR KAL3810767.1 382380 g16434 i0 100 1.08041958041958 52 0 54.5 0 1 156 125 176 KAL3810767.1 hypothetical protein ACHAXA_001592 [Cyclostephanos tholiformis] diamond 309 109 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
28466720 28466720 PRJNA495391_S_NODE_52766_length_171_cov_1.147059_g51714_i0 PRJNA495391 52766 171 1.147059 1.96147089 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 106 3.46e-25   NR KAL3816450.1 382380 g51714 i0 96 0.87719298245614 50 2 87.7 0 169 20 426 475 KAL3816450.1 hypothetical protein ACHAXA_001032, partial [Cyclostephanos tholiformis] diamond 150 106 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
28656093 28656093 PRJNA495391_S_NODE_35167_length_205_cov_3.464706_g34115_i0 PRJNA495391 35167 205 3.464706 7.1026473 Skeletonema marinoi 267567 SAR_Eukaryotes SAR_Eukaryotes 57 5.8e-9   NR KAK1739605.1 267567 g34115 i0 75 0.936585365853659 32 8 46.8 0 200 105 26 57 KAK1739605.1 hypothetical protein QTG54_009364 [Skeletonema marinoi] diamond 192 57 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema marinoi
28671680 28671680 PRJNA495391_S_NODE_63987_length_157_cov_1.483607_g62935_i0 PRJNA495391 63987 157 1.483607 2.32926299 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 79.7 1.03e-15   NR KAL3811474.1 382380 g62935 i0 85.4 1.56687898089172 41 6 78.3 0 3 125 1169 1209 KAL3811474.1 hypothetical protein ACHAXA_010726 [Cyclostephanos tholiformis] diamond 246 79.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
28782123 28782123 PRJNA495391_S_NODE_39207_length_195_cov_3.043750_g38155_i0 PRJNA495391 39207 195 3.04375 5.9353125 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 64.7 3.63e-10   NR GKY99352.1 2872254 g38155 i0 61 0.630769230769231 41 16 63.1 0 195 73 750 790 GKY99352.1 hypothetical protein MPSEU_000890300 [Mayamaea pseudoterrestris] diamond 123 64.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
28845282 28845282 PRJNA495391_S_NODE_51248_length_173_cov_1.427536_g50196_i0 PRJNA495391 51248 173 1.427536 2.46963728 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00118   NR CAB9504874.1 568900 g50196 i0 46 0.867052023121387 50 27 86.7 0 173 24 7 56 CAB9504874.1 receptor kinase [Seminavis robusta] diamond 150 45.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30487740 30487740 PRJNA495391_S_NODE_28193_length_227_cov_2.692708_g27141_i0 PRJNA495391 28193 227 2.692708 6.11244716 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 74.3 4.19e-14   NR XP_002179786.1 556484 g27141 i0 51.4 0.977973568281938 74 31 97.8 1 222 1 64 132 XP_002179786.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 222 74.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
31119350 31119350 PRJNA495391_S_NODE_55115_length_167_cov_2.113636_g54063_i0 PRJNA495391 55115 167 2.113636 3.52977212 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 96.3 1.84e-22   NR KAL3792277.1 2934178 g54063 i0 83.6 0.988023952095808 55 9 98.8 0 166 2 209 263 KAL3792277.1 hypothetical protein ACHAW5_001103 [Stephanodiscus triporus] diamond 165 96.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus
31499253 31499253 PRJNA495391_S_NODE_46116_length_181_cov_2.623288_g45064_i0 PRJNA495391 46116 181 2.623288 4.74815128 Discostella pseudostelligera 259834 SAR_Eukaryotes SAR_Eukaryotes 85.5 2.28e-19   NR KAL3762944.1 259834 g45064 i0 93.2 0.729281767955801 44 3 72.9 0 178 47 104 147 KAL3762944.1 hypothetical protein ACHAWU_001091 [Discostella pseudostelligera] diamond 132 85.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
32258696 32258696 PRJNA495391_S_NODE_42318_length_189_cov_1.285714_g41266_i0 PRJNA495391 42318 189 1.285714 2.42999946 Navicula sp. 1923966 SAR_Eukaryotes SAR_Eukaryotes 73.2 8.07e-15   NR UXN44176.1 1923966 g41266 i0 80.5 1.93650793650794 41 8 65.1 0 1 123 75 115 UXN44176.1 ribosomal protein S13 [Navicula sp.] diamond 366 73.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
32400611 32400611 PRJNA495391_S_NODE_15499_length_304_cov_2.405204_g14447_i0 PRJNA495391 15499 304 2.405204 7.31182016 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.0086   NR CAJ1967358.1 2856 g14447 i0 31.5 1.51973684210526 89 58 86.8 2 275 12 685 771 CAJ1967358.1 unnamed protein product [Cylindrotheca closterium] diamond 462 45.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
32448414 32448414 PRJNA495391_S_NODE_22139_length_255_cov_2.227273_g21087_i0 PRJNA495391 22139 255 2.227273 5.67954615 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 86.3 7.77e-18   NR KAL3808307.1 382380 g21087 i0 86 0.588235294117647 50 6 58.8 1 255 106 276 324 KAL3808307.1 hypothetical protein ACHAXA_001924 [Cyclostephanos tholiformis] diamond 150 86.3 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis
32794860 32794860 PRJNA495391_S_NODE_45480_length_182_cov_3.666667_g44428_i0 PRJNA495391 45480 182 3.666667 6.67333394 Cyclostephanos tholiformis 382380 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0119   NR KAL3826492.1 382380 g44428 i0 91.3 0.741758241758242 23 2 37.9 0 181 113 311 333 KAL3826492.1 hypothetical protein ACHAXA_004329 [Cyclostephanos tholiformis] diamond 135 43.1 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos tholiformis

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