RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "blastn", bioproject = "PRJEB39269" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 31 ✖

tax_clade 1

bioproject 1

  • PRJEB39269 · 31 ✖

analysis 1

  • blastn · 31 ✖

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
57081 57081 PRJEB39269_P_NODE_24801_length_280_cov_6.863071_g24396_i0 PRJEB39269 24801 280 6.863071 19.2165988 Navicula sp. 1923966 SAR_Eukaryotes SAR_Eukaryotes 422 1.71e-113   NTclustered gi|2862228860|gb|PQ645494.1| 1923966 g24396 i0 95.785 94.3071428571429 261 11 93 0 1 261 3776 3516 Navicula sp. isolate AGSB0344 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 26406 422 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
1331396 1331396 PRJEB39269_P_NODE_86522_length_154_cov_0.982609_g86117_i0 PRJEB39269 86522 154 0.982609 1.51321786 Asterionella formosa 210441 SAR_Eukaryotes SAR_Eukaryotes 268 1.15e-67   NTclustered gi|2497507841|gb|OQ694381.1| 210441 g86117 i0 98.052 99.7077922077922 154 3 100 0 1 154 6279 6432 Asterionella formosa chloroplast, complete genome blastn 15355 268 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Asterionella Asterionella formosa
2264534 2264534 PRJEB39269_P_NODE_37342_length_225_cov_2.483871_g36937_i0 PRJEB39269 37342 225 2.483871 5.58870975 root 1 Root_unresolved Root_unresolved 412 7.97e-111   NTclustered gi|2463918140|gb|OP819043.1| 2843 g36937 i0 100 125.871111111111 223 0 99 0 3 225 653 431 Skeletonema costatum strain bhl4 photosystem II protein D1 gene, partial cds; chloroplast blastn 28321 412 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema costatum
2606976 2606976 PRJEB39269_P_NODE_3683_length_682_cov_9.331260_g583_i4 PRJEB39269 3683 682 9.33126 63.6391932 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 420 1.6199999999999999e-112   NTclustered gi|657012562|gb|KF302618.1| 2850 g583 i4 81.333 73.0161290322581 525 90 76 8 1 521 256 776 Phaeodactylum tricornutum clone C537 hypothetical protein mRNA, complete cds blastn 49797 420 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
4817166 4817166 PRJEB39269_P_NODE_85004_length_155_cov_1.155172_g84599_i0 PRJEB39269 85004 155 1.155172 1.7905166 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 270 3.23e-68   NTclustered gi|2239963886|gb|MW561351.1| 67476 g84599 i0 98.065 194.541935483871 155 3 100 0 1 155 68296 68142 Haslea ostrearia strain SZCZP1883 chloroplast, complete genome blastn 30154 270 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea ostrearia
5159376 5159376 PRJEB39269_P_NODE_32825_length_241_cov_2.103960_g32420_i0 PRJEB39269 32825 241 2.10396 5.0705436 Thalassiosira profunda 376140 SAR_Eukaryotes SAR_Eukaryotes 435 1.84e-117   NTclustered gi|2055416875|ref|NC_056364.1| 376140 g32420 i0 99.17 105.311203319502 241 2 100 0 1 241 32960 32720 Thalassiosira profunda strain CNS00050 mitochondrion, complete genome blastn 25380 435 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira profunda
6092367 6092367 PRJEB39269_P_NODE_7425_length_504_cov_1.580645_g7034_i0 PRJEB39269 7425 504 1.580645 7.9664508 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 835 0   NTclustered gi|2316016826|gb|OL855988.1| 59812 g7034 i0 96.62 152.049603174603 503 17 99 0 2 504 51054 50552 Lithodesmium undulatum chloroplast, complete genome blastn 76633 841 0.992865636147443 Eukaryota Sar   Bacillariophyta Mediophyceae Lithodesmiales Lithodesmiaceae Lithodesmium Lithodesmium undulatum
6092385 6092385 PRJEB39269_P_NODE_88185_length_152_cov_2.097345_g87780_i0 PRJEB39269 88185 152 2.097345 3.1879644 Thalassiosira 35127 SAR_Eukaryotes SAR_Eukaryotes 220 3.22e-53   NTclustered gi|2862228846|gb|PQ645480.1| 1048533 g87780 i0 92.763 70.25 152 11 100 0 1 152 4171 4020 Thalassiosira bioculata isolate AGSB0307 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 10678 220 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira bioculata
6435246 6435246 PRJEB39269_P_NODE_27346_length_266_cov_3.295154_g26941_i0 PRJEB39269 27346 266 3.295154 8.76510964 Nitzschia reversa 2675857 SAR_Eukaryotes SAR_Eukaryotes 346 9.96e-91   NTclustered gi|2862228864|gb|PQ645498.1| 2675857 g26941 i0 90.189 99.3045112781955 265 26 99 0 1 265 3940 3676 Nitzschia reversa isolate AGSB0348 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 26415 346 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa
7366818 7366818 PRJEB39269_P_NODE_44926_length_204_cov_16.763636_g44521_i0 PRJEB39269 44926 204 16.763636 34.19781744 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 377 2.59e-100   NTclustered gi|98978951|gb|DQ512470.1| 29207 g44521 i0 100 100.009803921569 204 0 100 0 1 204 81 284 Stephanodiscus hantzschii strain WTC21 large subunit ribosomal RNA gene, partial sequence blastn 20402 377 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus hantzschii
7709443 7709443 PRJEB39269_P_NODE_56607_length_183_cov_1.569444_g56202_i0 PRJEB39269 56607 183 1.569444 2.87208252 Fragilaria sp. AT124.05b 432267 SAR_Eukaryotes SAR_Eukaryotes 250 5.15e-62   NTclustered gi|168145912|emb|AM710562.1| 432267 g56202 i0 91.257 57.7213114754098 183 16 100 0 1 183 481 299 Fragilaria sp. AT-124.05b partial 28S rRNA gene, strain AT-124.05b blastn 10563 250 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria sp. AT124.05b
8984125 8984125 PRJEB39269_P_NODE_2328_length_825_cov_7.291349_g583_i2 PRJEB39269 2328 825 7.291349 60.15362925 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 448 9.059999999999999e-121   NTclustered gi|657012562|gb|KF302618.1| 2850 g583 i2 81.901 44.7018181818182 547 83 65 13 1 537 663 123 Phaeodactylum tricornutum clone C537 hypothetical protein mRNA, complete cds blastn 36879 448 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
11535233 11535233 PRJEB39269_P_NODE_32850_length_241_cov_1.826733_g32445_i0 PRJEB39269 32850 241 1.826733 4.40242653 Thalassiosira nordenskioeldii 83372 SAR_Eukaryotes SAR_Eukaryotes 357 4.1099999999999997e-94   NTclustered gi|2091526160|ref|NC_057471.1| 83372 g32445 i0 93.388 93.2282157676349 242 15 100 1 1 241 38947 39188 Thalassiosira nordenskioeldii isolate CNS00052 mitochondrion, complete genome blastn 22468 357 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira nordenskioeldii
14085384 14085384 PRJEB39269_P_NODE_73312_length_164_cov_3.096000_g72907_i0 PRJEB39269 73312 164 3.096 5.07744 Cymatopleura elliptica 303462 SAR_Eukaryotes SAR_Eukaryotes 135 1.32e-27   NTclustered gi|817090523|gb|KM009321.1| 303462 g72907 i0 95.294 52.5853658536585 85 4 52 0 78 162 464 548 Cymatopleura elliptica isolate L1333 PSI P700 apoprotein A1 (psaA) gene, partial cds; chloroplast blastn 8624 135 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Surirellales Surirellaceae Cymatopleura Cymatopleura elliptica
15017071 15017071 PRJEB39269_P_NODE_3852_length_666_cov_17.503987_g3547_i0 PRJEB39269 3852 666 17.503987 116.57655342 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 1153 0   NTclustered gi|2468683651|ref|NC_072630.1| 29208 g3547 i0 97.898 200.051051051051 666 14 100 0 1 666 69923 70588 Stephanodiscus niagarae strain BB16 chloroplast, complete genome blastn 133234 1164 0.990549828178694 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus niagarae
15359192 15359192 PRJEB39269_P_NODE_15633_length_355_cov_1.291139_g15228_i0 PRJEB39269 15633 355 1.291139 4.58354345 Hemiaulus sinensis 1003062 SAR_Eukaryotes SAR_Eukaryotes 235 3.11e-57   NTclustered gi|2248495916|ref|NC_063458.1| 1003062 g15228 i0 78.83 51.4507042253521 359 68 100 7 1 355 22094 21740 Hemiaulus sinensis isolate Qingdao in China mitochondrion, complete genome blastn 18265 235 1 Eukaryota Sar   Bacillariophyta Mediophyceae Hemiaulales Hemiaulaceae Hemiaulus Hemiaulus sinensis
15359229 15359229 PRJEB39269_P_NODE_60193_length_178_cov_1.179856_g59788_i0 PRJEB39269 60193 178 1.179856 2.10014368 Navicula gregaria 355633 SAR_Eukaryotes SAR_Eukaryotes 324 2.89e-84   NTclustered gi|296065621|emb|FN397579.1| 355633 g59788 i0 99.438 100.162921348315 178 1 100 0 1 178 495 318 Navicula gregaria partial 28S rRNA gene, strain CH57 blastn 17829 324 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula gregaria
15359255 15359255 PRJEB39269_P_NODE_74733_length_163_cov_1.322581_g74328_i0 PRJEB39269 74733 163 1.322581 2.15580703 Thalassiosira rotula 49265 SAR_Eukaryotes SAR_Eukaryotes 246 5.8099999999999995e-61   NTclustered gi|2192941233|ref|NC_060383.1| 49265 g74328 i0 93.902 1.98773006134969 164 9 100 1 1 163 45525 45688 Thalassiosira rotula mitochondrion, complete sequence blastn 324 246 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira rotula
16291905 16291905 PRJEB39269_P_NODE_14553_length_367_cov_9.801829_g14148_i0 PRJEB39269 14553 367 9.801829 35.97271243 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 645 1.2599999999999995e-180   NTclustered gi|2862228846|gb|PQ645480.1| 1048533 g14148 i0 98.365 100.024523160763 367 6 100 0 1 367 3574 3940 Thalassiosira bioculata isolate AGSB0307 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 36709 645 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira bioculata
16291922 16291922 PRJEB39269_P_NODE_51413_length_191_cov_3.177632_g51008_i0 PRJEB39269 51413 191 3.177632 6.06927712 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 353 4.02e-93   NTclustered gi|817090761|gb|KM009440.1| 1003040 g51008 i0 100 140.073298429319 191 0 100 0 1 191 882 692 Cyclostephanos dubius isolate Waco5 PSII protein D1 (psbA) gene, partial cds; chloroplast blastn 26754 353 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos dubius
17908675 17908675 PRJEB39269_P_NODE_38495_length_221_cov_12.351648_g38090_i0 PRJEB39269 38495 221 12.351648 27.29714208 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 298 2.28e-76   NTclustered gi|1169296927|gb|KY364697.1| 29204 g38090 i0 91.667 84.0995475113122 216 16 98 2 6 221 5843 5630 Cyclotella cryptica 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 18586 298 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
19182530 19182530 PRJEB39269_P_NODE_24456_length_282_cov_14.551440_g24051_i0 PRJEB39269 24456 282 14.55144 41.0350608 Stephanodiscus neglectus 2904138 SAR_Eukaryotes SAR_Eukaryotes 505 1.6599999999999995e-138   NTclustered gi|2165181501|gb|OL853512.1| 2904138 g24051 i0 100 94.8368794326241 273 0 97 0 1 273 15 287 Stephanodiscus neglectus strain TO1 large subunit ribosomal RNA gene, partial sequence blastn 26744 505 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus neglectus
19182573 19182573 PRJEB39269_P_NODE_71116_length_167_cov_1.265625_g70711_i0 PRJEB39269 71116 167 1.265625 2.11359375 Coscinodiscus wailesii 671091 SAR_Eukaryotes SAR_Eukaryotes 121 3.789999999999999e-23   NTclustered gi|2088246177|ref|NC_057078.1| 671091 g70711 i0 82.836 1.64670658682635 134 23 80 0 34 167 34946 35079 Coscinodiscus wailesii mitochondrion, complete genome blastn 275 121 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Coscinodiscales Coscinodiscaceae Coscinodiscus Coscinodiscus wailesii
20457871 20457871 PRJEB39269_P_NODE_51917_length_191_cov_0.894737_g51512_i0 PRJEB39269 51917 191 0.894737 1.70894767 Nitzschia heufleriana 2683825 SAR_Eukaryotes SAR_Eukaryotes 335 1.4599999999999993e-87   NTclustered gi|1783393352|gb|MN718758.1| 2683825 g51512 i0 98.429 97.6282722513089 191 2 99 1 2 191 948 758 Nitzschia heufleriana strain BC0307 ribulose-1,5-bisphosphate carboxylase/oxygenase large subunit (rbcL) gene, partial cds; chloroplast blastn 18647 335 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia heufleriana
20457898 20457898 PRJEB39269_P_NODE_72877_length_165_cov_1.301587_g72472_i0 PRJEB39269 72877 165 1.301587 2.14761855 Acanthoceras zachariasii 451788 SAR_Eukaryotes SAR_Eukaryotes 117 4.82e-22   NTclustered gi|1418588907|ref|NC_038009.1| 451788 g72472 i0 82.707 102.266666666667 133 21 80 2 34 165 71471 71340 Acanthoceras zachariasii chloroplast, complete genome blastn 16874 117 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Acanthocerataceae Acanthoceras Acanthoceras zachariasii
21391362 21391362 PRJEB39269_P_NODE_82117_length_157_cov_1.694915_g81712_i0 PRJEB39269 82117 157 1.694915 2.66101655 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 252 1.19e-62   NTclustered gi|1209554698|gb|KX889107.1| 2014924 g81712 i0 95.541 10.2929936305732 157 7 100 0 1 157 389 545 Nitzschia dissipata var. media 28S ribosomal RNA gene, partial sequence blastn 1616 252 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia dissipata
21733802 21733802 PRJEB39269_P_NODE_3578_length_691_cov_9.098160_g583_i3 PRJEB39269 3578 691 9.09816 62.8682856 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 422 4.56e-113   NTclustered gi|657012562|gb|KF302618.1| 2850 g583 i3 81.89 85.451519536903 508 84 73 8 1 504 256 759 Phaeodactylum tricornutum clone C537 hypothetical protein mRNA, complete cds blastn 59047 422 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
23009097 23009097 PRJEB39269_P_NODE_32279_length_243_cov_2.745098_g31874_i0 PRJEB39269 32279 243 2.745098 6.6705881400000004 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 161 3.4899999999999997e-35   NTclustered gi|657012562|gb|KF302618.1| 2850 g31874 i0 79.828 14.8600823045267 233 37 93 9 1 227 621 393 Phaeodactylum tricornutum clone C537 hypothetical protein mRNA, complete cds blastn 3611 161 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
23009099 23009099 PRJEB39269_P_NODE_3779_length_673_cov_10.045741_g583_i5 PRJEB39269 3779 673 10.045741 67.60783693 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 431 7.369999999999998e-116   NTclustered gi|657012562|gb|KF302618.1| 2850 g583 i5 81.714 82.6344725111441 525 88 77 8 153 673 776 256 Phaeodactylum tricornutum clone C537 hypothetical protein mRNA, complete cds blastn 55613 431 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
25215353 25215353 PRJEB39269_P_NODE_55340_length_185_cov_1.232877_g54935_i0 PRJEB39269 55340 185 1.232877 2.28082245 Stephanodiscus 29206 SAR_Eukaryotes SAR_Eukaryotes 342 8.369999999999999e-90   NTclustered gi|2468683651|ref|NC_072630.1| 29208 g54935 i0 100 201.432432432432 185 0 100 0 1 185 69259 69075 Stephanodiscus niagarae strain BB16 chloroplast, complete genome blastn 37265 342 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus niagarae
25215372 25215372 PRJEB39269_P_NODE_72660_length_165_cov_1.595238_g72255_i0 PRJEB39269 72660 165 1.595238 2.6321427 Stephanodiscus 29206 SAR_Eukaryotes SAR_Eukaryotes 305 9.59e-79   NTclustered gi|180088888|gb|DQ514760.2| 29207 g72255 i0 100 99.9636363636364 165 0 100 0 1 165 195 359 Stephanodiscus hantzschii strain WTC21 PSbC (psbC) gene, partial cds blastn 16494 305 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus hantzschii

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