RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where bioproject = "PRJNA682370" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 23 ✖

tax_clade 1

bioproject 1

  • PRJNA682370 · 23 ✖

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
664141 664141 PRJNA682370_S_NODE_11741_length_211_cov_2.607955_g11129_i0 PRJNA682370 11741 211 2.607955 5.50278505 Cymbella cistula 930063 SAR_Eukaryotes SAR_Eukaryotes 363 7.539999999999999e-96   NTclustered gi|725654813|gb|KJ011563.1| 930063 g11129 i0 97.63 86.5545023696682 211 5 100 0 1 211 80 290 Cymbella cistula strain CH020 28S ribosomal RNA gene, partial sequence blastn 18263 363 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Cymbellaceae Cymbella Cymbella cistula
664188 664188 PRJNA682370_S_NODE_13901_length_192_cov_3.229299_g13289_i0 PRJNA682370 13901 192 3.229299 6.20025408 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 309 8.890000000000001e-80   NTclustered gi|74325165|ref|NC_007405.1| 35128 g13289 i0 95.833 24.3958333333333 192 7 100 1 1 192 11937 12127 Thalassiosira pseudonana mitochondrion, complete genome blastn 4684 309 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
2449933 2449933 PRJNA682370_S_NODE_19502_length_163_cov_23.390625_g18890_i0 PRJNA682370 19502 163 23.390625 38.12671875 Navicula 50949 SAR_Eukaryotes SAR_Eukaryotes 302 1.22e-77   NTclustered gi|831437048|gb|KR089908.1| 137771 g18890 i0 100 99.9815950920245 163 0 100 0 1 163 176 14 Uncultured diatom clone 118172_TP_4e_D4 18S ribosomal RNA gene, partial sequence blastn 16297 302 1 Eukaryota Sar   Bacillariophyta         uncultured diatom
3215162 3215162 PRJNA682370_S_NODE_2443_length_536_cov_18.113772_g1863_i0 PRJNA682370 2443 536 18.113772 97.08981792 Navicula capitatoradiata 431397 SAR_Eukaryotes SAR_Eukaryotes 955 0   NTclustered gi|168145917|emb|AM710568.1| 431397 g1863 i0 99.807 97.0242537313433 519 1 97 0 1 519 18 536 Navicula capitatoradiata partial 28S rRNA gene, strain AT-212Gel07 blastn 52005 955 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula capitatoradiata
4492395 4492395 PRJNA682370_S_NODE_5064_length_354_cov_6.846395_g4452_i0 PRJNA682370 5064 354 6.846395 24.2362383 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 564 3.479999999999999e-156   NTclustered gi|74325165|ref|NC_007405.1| 35128 g4452 i0 95.714 104.584745762712 350 15 99 0 3 352 12312 12661 Thalassiosira pseudonana mitochondrion, complete genome blastn 37023 564 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
6278666 6278666 PRJNA682370_S_NODE_20745_length_159_cov_5.693548_g20133_i0 PRJNA682370 20745 159 5.693548 9.05274132 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 283 4.29e-72   NTclustered gi|2728412634|gb|OR666648.1| 29205 g20133 i0 99.359 196.006289308176 156 1 100 0 4 159 69123 68968 Stephanocyclus meneghinianus chloroplast, complete genome blastn 31165 283 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
7552494 7552494 PRJNA682370_S_NODE_15686_length_180_cov_4.006897_g15074_i0 PRJNA682370 15686 180 4.006897 7.2124146 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 316 4.899999999999999e-82   NTclustered gi|2202538974|gb|OM891880.1| 355634 g15074 i0 98.333 100.811111111111 180 3 100 0 1 180 4702 4881 Navicula arenaria 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 18146 316 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula arenaria
7552586 7552586 PRJNA682370_S_NODE_9546_length_238_cov_6.940887_g8934_i0 PRJNA682370 9546 238 6.940887 16.51931106 Naviculaceae 67474 SAR_Eukaryotes SAR_Eukaryotes 396 8.5699999999999955e-106   NTclustered gi|330850815|ref|NC_015403.1| 1519565 g8934 i0 99.539 181.457983193277 217 1 91 0 22 238 36825 36609 Fistulifera solaris chloroplast, complete genome blastn 43187 396 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
10103231 10103231 PRJNA682370_S_NODE_11548_length_213_cov_2.741573_g10936_i0 PRJNA682370 11548 213 2.741573 5.83955049 Naviculaceae 67474 SAR_Eukaryotes SAR_Eukaryotes 375 9.79e-100   NTclustered gi|1442831292|gb|MH017642.1| 1923966 g10936 i0 98.585 99.5211267605634 212 3 99 0 2 213 1405 1616 Navicula sp. strain ECT3499 tubedweller small subunit ribosomal RNA gene, partial sequence blastn 21198 375 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
12143476 12143476 PRJNA682370_S_NODE_10330_length_227_cov_2.890625_g9718_i0 PRJNA682370 10330 227 2.890625 6.56171875 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 130 9.08e-26   NTclustered gi|74325165|ref|NC_007405.1| 35128 g9718 i0 97.368 9.62114537444934 76 2 56 0 2 77 12652 12727 Thalassiosira pseudonana mitochondrion, complete genome blastn 2184 130 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
12143759 12143759 PRJNA682370_S_NODE_3010_length_476_cov_16.716553_g2410_i0 PRJNA682370 3010 476 16.716553 79.57079228 Navicula capitatoradiata 431397 SAR_Eukaryotes SAR_Eukaryotes 599 1.3199999999999995e-166   NTclustered gi|168145917|emb|AM710568.1| 431397 g2410 i0 99.096 76.5882352941177 332 3 70 0 128 459 205 536 Navicula capitatoradiata partial 28S rRNA gene, strain AT-212Gel07 blastn 36456 599 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula capitatoradiata
14693317 14693317 PRJNA682370_S_NODE_23372_length_152_cov_3.188034_g22760_i0 PRJNA682370 23372 152 3.188034 4.84581168 Navicula veneta 138539 SAR_Eukaryotes SAR_Eukaryotes 259 6.82e-65   NTclustered gi|2088232805|ref|NC_056793.1| 138539 g22760 i0 97.368 99.875 152 4 100 0 1 152 22376 22527 Navicula veneta isolate SZCZR1826 mitochondrion, complete genome blastn 15181 259 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula veneta
14693519 14693519 PRJNA682370_S_NODE_7732_length_273_cov_1.420168_g7120_i0 PRJNA682370 7732 273 1.420168 3.87705864 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 231 3e-56   NTclustered gi|2996370|emb|AJ000967.1| 29204 g7120 i0 89.944 7.6043956043956 179 18 66 0 1 179 471 649 Cyclotella cryptica mRNA for fucoxanthin chlorophyll a/c binding protein, fcp5 blastn 2076 231 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
19791090 19791090 PRJNA682370_S_NODE_11876_length_210_cov_1.388571_g11264_i0 PRJNA682370 11876 210 1.388571 2.9159991 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 120 3.0899999999999997e-32   NR KAL3762341.1 259834 g11264 i0 84.1 5.91428571428571 69 11 98.6 0 3 209 40 108 KAL3762341.1 hypothetical protein ACHAWU_003846 [Discostella pseudostelligera] diamond 1242 121 0.991735537190083 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella pseudostelligera
19791317 19791317 PRJNA682370_S_NODE_24336_length_150_cov_2.582609_g23724_i0 PRJNA682370 24336 150 2.582609 3.8739135 Halamphora coffeiformis 1487565 SAR_Eukaryotes SAR_Eukaryotes 128 1.97e-25   NTclustered gi|1418576889|ref|NC_037727.1| 1487565 g23724 i0 87.963 78.8533333333333 108 13 72 0 22 129 30830 30937 Halamphora coffeaeformis mitochondrion, complete genome blastn 11828 128 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora coffeiformis
19791451 19791451 PRJNA682370_S_NODE_6416_length_307_cov_7.838235_g5804_i0 PRJNA682370 6416 307 7.838235 24.06338145 Navicula ramosissima 265559 SAR_Eukaryotes SAR_Eukaryotes 388 1.92e-103   NTclustered gi|1102548834|ref|NC_031848.1| 265559 g5804 i0 89.61 104.934853420195 308 28 100 3 1 307 22440 22744 Navicula ramosissima voucher 10.TA439.Nram.mt mitochondrion, complete genome blastn 32215 388 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula ramosissima
19791481 19791481 PRJNA682370_S_NODE_7396_length_279_cov_5.274590_g6784_i0 PRJNA682370 7396 279 5.27459 14.7161061 Cymbella tumida 882190 SAR_Eukaryotes SAR_Eukaryotes 468 2.15e-127   NTclustered gi|2162236538|gb|OL780393.1| 882190 g6784 i0 99.228 74.1971326164875 259 2 93 0 21 279 65 323 Cymbella tumida strain CBac2019069 large subunit ribosomal RNA gene, partial sequence blastn 20701 468 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Cymbellaceae Cymbella Cymbella tumida
23617068 23617068 PRJNA682370_S_NODE_13819_length_193_cov_1.449367_g13207_i0 PRJNA682370 13819 193 1.449367 2.79727831 Helicotheca tamesis 374047 SAR_Eukaryotes SAR_Eukaryotes 111 2.71e-20   NTclustered gi|2248495790|ref|NC_063455.1| 374047 g13207 i0 83.74 5.23834196891192 123 15 64 3 6 128 7036 6919 Helicotheca tamesis isolate Qingdao in China mitochondrion, complete genome blastn 1011 111 1 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Helicotheca Helicotheca tamesis
23617168 23617168 PRJNA682370_S_NODE_18959_length_165_cov_2.269231_g18347_i0 PRJNA682370 18959 165 2.269231 3.74423115 Thalassiosira pseudonana 35128 SAR_Eukaryotes SAR_Eukaryotes 244 2.12e-60   NTclustered gi|74325165|ref|NC_007405.1| 35128 g18347 i0 93.333 102.278787878788 165 11 100 0 1 165 13260 13096 Thalassiosira pseudonana mitochondrion, complete genome blastn 16876 244 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
24890714 24890714 PRJNA682370_S_NODE_7760_length_272_cov_3.033755_g7148_i0 PRJNA682370 7760 272 3.033755 8.2518136 Navicula sp. 1923966 SAR_Eukaryotes SAR_Eukaryotes 195 3.92e-45   NTclustered gi|2633304248|gb|OR795084.1| 1923966 g7148 i0 84.507 6.23161764705882 213 15 77 10 4 212 9761 9563 Navicula sp. strain SZCZEY2262 mitochondrion, complete genome blastn 1695 195 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
27441658 27441658 PRJNA682370_S_NODE_13243_length_197_cov_1.660494_g12631_i0 PRJNA682370 13243 197 1.660494 3.27117318 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 74.7 1.08e-13   NR CAJ1961665.1 2856 g12631 i0 61.5 4.90355329949239 65 24 99 1 3 197 172 235 CAJ1961665.1 unnamed protein product [Cylindrotheca closterium] diamond 966 74.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
31990299 31990299 PRJNA682370_S_NODE_13978_length_192_cov_1.299363_g13366_i0 PRJNA682370 13978 192 1.299363 2.49477696 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 53.9 9.97e-7   NR KAI2506646.1 210448 g13366 i0 47.8 2.171875 46 24 71.9 0 187 50 143 188 KAI2506646.1 calcineurin-like phosphoesterase-like protein [Fragilaria crotonensis] diamond 417 54.3 0.992633517495396 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
32105251 32105251 PRJNA682370_S_NODE_3678_length_427_cov_2.400510_g3072_i0 PRJNA682370 3678 427 2.40051 10.2501777 Thalassiosira oceanica 159749 SAR_Eukaryotes SAR_Eukaryotes 132 1.75e-36   NR EJK48333.1 159749 g3072 i0 57.8 6.0983606557377 116 48 81.5 1 427 80 27 141 EJK48333.1 hypothetical protein THAOC_32880, partial [Thalassiosira oceanica] diamond 2604 132 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);;