RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "blastn", bioproject = "PRJNA977246" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 24 ✖

tax_clade 1

bioproject 1

  • PRJNA977246 · 24 ✖

analysis 1

  • blastn · 24 ✖

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
950830 950830 PRJNA977246_S_NODE_13801_length_398_cov_4951.300813_g12818_i0 PRJNA977246 13801 398 4951.300813 19706.17723574 Navicula veneta 138539 SAR_Eukaryotes SAR_Eukaryotes 555 2.3799999999999994e-153   NTclustered gi|2088232843|ref|NC_056794.1| 138539 g12818 i0 95.415 172.412060301508 349 14 87 2 51 398 84930 85277 Navicula veneta isolate SZCZR1826 chloroplast, complete genome blastn 68620 555 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula veneta
2226326 2226326 PRJNA977246_S_NODE_17802_length_335_cov_24.470588_g16810_i0 PRJNA977246 17802 335 24.470588 81.9764698 Nitzschia sp. (in: diatoms) 1884248 SAR_Eukaryotes SAR_Eukaryotes 475 1.5799999999999994e-129   NTclustered gi|2862228875|gb|PQ645509.1| 1884248 g16810 i0 92.239 100.197014925373 335 26 100 0 1 335 3679 4013 Nitzschia sp. (in: diatoms) isolate AGSB0363 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 33566 475 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. (in: diatoms)
2226624 2226624 PRJNA977246_S_NODE_28402_length_236_cov_15.893720_g27410_i0 PRJNA977246 28402 236 15.89372 37.5091792 Nanofrustulum shiloi 210602 SAR_Eukaryotes SAR_Eukaryotes 364 2.39e-96   NTclustered gi|1783235058|gb|MN276191.1| 210602 g27410 i0 95.217 191.576271186441 230 11 97 0 7 236 98445 98216 Nanofrustulum shiloi strain SZCZM404 chloroplast, complete genome blastn 45212 364 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Staurosiraceae Nanofrustulum Nanofrustulum shiloi
3502231 3502231 PRJNA977246_S_NODE_44363_length_168_cov_1.589928_g43371_i0 PRJNA977246 44363 168 1.589928 2.67107904 Guinardia delicatula 1244696 SAR_Eukaryotes SAR_Eukaryotes 100 4.97e-17   NTclustered gi|2074156200|gb|MW413905.1| 216802 g43371 i0 85.149 0.601190476190476 101 12 58 3 49 146 23981 23881 Guinardia delicatula mitochondrion, complete genome blastn 101 100 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Rhizosoleniales Rhizosoleniaceae Guinardia Guinardia delicatula
4779952 4779952 PRJNA977246_S_NODE_51524_length_150_cov_5.735537_g50532_i0 PRJNA977246 51524 150 5.735537 8.6033055 Navicula sp. 1923966 SAR_Eukaryotes SAR_Eukaryotes 259 6.71e-65   NTclustered gi|2620230842|gb|OR797293.1| 1923966 g50532 i0 97.987 99.2066666666667 149 3 99 0 2 150 3780 3632 Navicula sp. strain SZCZEY2262 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 14881 259 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula sp.
5097351 5097351 PRJNA977246_S_NODE_44824_length_166_cov_10.131387_g43832_i0 PRJNA977246 44824 166 10.131387 16.81810242 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 189 1.0199999999999999e-43   NTclustered gi|2202538966|gb|OM891872.1| 3003 g43832 i0 87.349 78.3795180722892 166 20 100 1 1 166 4534 4698 Bacillaria paxillifer 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 13011 189 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Bacillaria Bacillaria paxillifer
6054550 6054550 PRJNA977246_S_NODE_27545_length_242_cov_8888.854460_g26553_i0 PRJNA977246 27545 242 8888.85446 21511.0277932 Nitzschia anatoliensis 2862141 SAR_Eukaryotes SAR_Eukaryotes 200 7.359999999999999e-47   NTclustered gi|2072316717|gb|MT742552.1| 2862141 g26553 i0 88.69 83.6157024793388 168 13 68 5 78 242 36536 36372 Nitzschia anatoliensis mitochondrion clone SZCZ E372, complete genome blastn 20235 200 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia anatoliensis
6054804 6054804 PRJNA977246_S_NODE_37825_length_189_cov_6.625000_g36833_i0 PRJNA977246 37825 189 6.625 12.52125 Licmophora juergensii 210598 SAR_Eukaryotes SAR_Eukaryotes 327 2.41e-85   NTclustered gi|2862228907|gb|PQ645541.1| 210598 g36833 i0 97.884 99.994708994709 189 4 100 0 1 189 3072 3260 Licmophora juergensii isolate AGSB0420 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 18899 327 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Licmophoraceae Licmophora Licmophora juergensii
7329384 7329384 PRJNA977246_S_NODE_45006_length_166_cov_2.700730_g44014_i0 PRJNA977246 45006 166 2.70073 4.4832118 Gomphoneis minuta 1115528 SAR_Eukaryotes SAR_Eukaryotes 128 2.25e-25   NTclustered gi|1268890791|gb|KY499654.1| 1142141 g44014 i0 88.679 1.25301204819277 106 11 64 1 3 108 90443 90547 Gomphoneis minuta var. cassieae chloroplast, complete genome blastn 208 128 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphoneis Gomphoneis minuta
8921837 8921837 PRJNA977246_S_NODE_34727_length_202_cov_38.335260_g33735_i0 PRJNA977246 34727 202 38.33526 77.4372252 root 1 Root_unresolved Root_unresolved 255 1.25e-63   NTclustered gi|2620230846|gb|OR797295.1| 2126271 g33735 i0 89.604 69.539603960396 202 20 100 1 1 202 4846 4646 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 14047 255 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
9879281 9879281 PRJNA977246_S_NODE_26168_length_252_cov_305.991031_g25176_i0 PRJNA977246 26168 252 305.991031 771.09739812 Mayamaea permitis 1302819 SAR_Eukaryotes SAR_Eukaryotes 344 3.37e-90   NTclustered gi|168145888|emb|AM710524.1| 1302819 g25176 i0 91.27 100.535714285714 252 22 100 0 1 252 321 70 Mayamaea atomus var. permitis partial 28S rRNA gene, strain AT-101Gel04 blastn 25335 344 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea permitis
9879525 9879525 PRJNA977246_S_NODE_34968_length_201_cov_8.168605_g33976_i0 PRJNA977246 34968 201 8.168605 16.41889605 Achnanthes inflata 2267512 SAR_Eukaryotes SAR_Eukaryotes 333 5.569999999999999e-87   NTclustered gi|2162236505|gb|OL780360.1| 2267512 g33976 i0 96.517 100.044776119403 201 7 100 0 1 201 12 212 Achnanthes inflata strain CBac2019002 large subunit ribosomal RNA gene, partial sequence blastn 20109 333 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Mastogloiales Achnanthaceae Achnanthes Achnanthes inflata
9879938 9879938 PRJNA977246_S_NODE_7748_length_563_cov_16.279026_g6922_i0 PRJNA977246 7748 563 16.279026000000002 91.65091638 Nitzschia sp. (in: diatoms) 1884248 SAR_Eukaryotes SAR_Eukaryotes 691 0   NTclustered gi|2862228875|gb|PQ645509.1| 1884248 g6922 i0 88.85 100.868561278863 565 59 100 4 1 563 3389 3951 Nitzschia sp. (in: diatoms) isolate AGSB0363 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 56789 691 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. (in: diatoms)
12748280 12748280 PRJNA977246_S_NODE_6510_length_625_cov_22.030201_g5744_i0 PRJNA977246 6510 625 22.030201 137.68875625 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 811 0   NTclustered gi|2202538974|gb|OM891880.1| 355634 g5744 i0 90.096 100.7504 626 60 100 2 1 625 4214 3590 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 62969 811 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula arenaria
14022941 14022941 PRJNA977246_S_NODE_46011_length_163_cov_3.813433_g45019_i0 PRJNA977246 46011 163 3.813433 6.21589579 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 134 4.72e-27   NTclustered gi|2778381911|gb|PQ010276.1| 189737 g45019 i0 81.595 5.70552147239264 163 29 100 1 1 163 27367 27528 Pseudo-nitzschia galaxiae isolate CNS01103 chloroplast, complete genome blastn 930 135 0.992592592592593 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia galaxiae
16254480 16254480 PRJNA977246_S_NODE_43673_length_170_cov_1.822695_g42681_i0 PRJNA977246 43673 170 1.822695 3.0985815 Nitzschia laevis 186029 SAR_Eukaryotes SAR_Eukaryotes 204 3.71e-48   NTclustered gi|327258965|gb|HQ263198.1| 186029 g42681 i0 89.441 49.3470588235294 161 17 95 0 10 170 285 125 Nitzschia laevis ribulose-1,5-biphosphate carboxylase/oxygenase small subunit (rbcS) gene, partial cds; chloroplast blastn 8389 204 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia laevis
18802765 18802765 PRJNA977246_S_NODE_20015_length_309_cov_8.725000_g19023_i0 PRJNA977246 20015 309 8.725 26.96025 Nanofrustulum shiloi 210602 SAR_Eukaryotes SAR_Eukaryotes 340 5.499999999999999e-89   NTclustered gi|1783235058|gb|MN276191.1| 210602 g19023 i0 88.112 179.663430420712 286 34 93 0 7 292 98445 98160 Nanofrustulum shiloi strain SZCZM404 chloroplast, complete genome blastn 55516 340 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Staurosiraceae Nanofrustulum Nanofrustulum shiloi
18803292 18803292 PRJNA977246_S_NODE_41335_length_177_cov_2.614865_g40343_i0 PRJNA977246 41335 177 2.614865 4.62831105 Achnanthes inflata 2267512 SAR_Eukaryotes SAR_Eukaryotes 294 2.25e-75   NTclustered gi|2162236505|gb|OL780360.1| 2267512 g40343 i0 96.61 99.7796610169491 177 6 100 0 1 177 350 526 Achnanthes inflata strain CBac2019002 large subunit ribosomal RNA gene, partial sequence blastn 17661 294 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Mastogloiales Achnanthaceae Achnanthes Achnanthes inflata
18803427 18803427 PRJNA977246_S_NODE_49715_length_154_cov_6.320000_g48723_i0 PRJNA977246 49715 154 6.32 9.7328 Achnanthes coarctata 1003012 SAR_Eukaryotes SAR_Eukaryotes 274 2.48e-69   NTclustered gi|329343423|gb|HQ912594.1| 1003012 g48723 i0 98.701 100.006493506494 154 2 100 0 1 154 588 741 Achnanthidium coarctatum strain UTEX FD185 18S small subunit ribosomal RNA gene, partial sequence blastn 15401 274 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Mastogloiales Achnanthaceae Achnanthes Achnanthes coarctata
20395460 20395460 PRJNA977246_S_NODE_48436_length_157_cov_4.031250_g47444_i0 PRJNA977246 48436 157 4.03125 6.3290625 Fistulifera 880756 SAR_Eukaryotes SAR_Eukaryotes 268 1.1799999999999998e-67   NTclustered gi|2088232451|ref|NC_056789.1| 880757 g47444 i0 97.452 11.0636942675159 157 4 100 0 1 157 5885 5729 Fistulifera saprophila isolate SZCZR1829 mitochondrion, complete genome blastn 1737 268 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera saprophila
21352882 21352882 PRJNA977246_S_NODE_12437_length_426_cov_3.345088_g11466_i0 PRJNA977246 12437 426 3.345088 14.25007488 Chaetoceros costatus 426630 SAR_Eukaryotes SAR_Eukaryotes 84.2 1.46e-11   NTclustered gi|2043890828|gb|MZ267683.1| 426630 g11466 i0 89.394 4.72065727699531 66 7 15 0 354 419 1534 1469 Chaetoceros costatus isolate CNS00386 internal transcribed spacer 2 and large subunit ribosomal RNA gene, partial sequence blastn 2011 84.2 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Chaetocerotales Chaetocerotaceae Chaetoceros Chaetoceros costatus
22628793 22628793 PRJNA977246_S_NODE_47658_length_159_cov_3.200000_g46666_i0 PRJNA977246 47658 159 3.2 5.088 Nitzschia dissipata 303402 SAR_Eukaryotes SAR_Eukaryotes 185 1.2399999999999997e-42   NTclustered gi|2248495830|ref|NC_063456.1| 303402 g46666 i0 89.189 20.4905660377358 148 16 93 0 1 148 18874 18727 Nitzschia dissipata isolate Qingdao in China mitochondrion, complete genome blastn 3258 185 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia dissipata
24220494 24220494 PRJNA977246_S_NODE_25799_length_255_cov_12.920354_g24807_i0 PRJNA977246 25799 255 12.920354 32.9469027 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 433 7.08e-117   NTclustered gi|1803023461|gb|MN937452.1| 2850 g24807 i0 97.255 196.964705882353 255 7 100 0 1 255 68405 68151 Phaeodactylum tricornutum strain ICE-H chloroplast, complete genome blastn 50226 435 0.995402298850575 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
25495450 25495450 PRJNA977246_S_NODE_37660_length_190_cov_3.229814_g36668_i0 PRJNA977246 37660 190 3.229814 6.1366466 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 193 9.22e-45   NTclustered gi|2579686273|ref|NC_082433.1| 426669 g36668 i0 87.425 86.1315789473684 167 21 88 0 1 167 4539 4373 Ulnaria ulna chloroplast, complete genome blastn 16365 193 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria ulna

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