RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

  • Sar · 17 ✖

bioproject 1

  • PRJNA1013345 · 17 ✖

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
2708881 2708881 PRJNA1013345_P_NODE_6743_length_238_cov_8.020942_g6613_i0 PRJNA1013345 6743 238 8.020942 19.08984196 Navicula tripunctata 431568 SAR_Eukaryotes SAR_Eukaryotes 429 8.45e-116   NTclustered gi|168145932|emb|AM710584.1| 431568 g6613 i0 99.16 99.5126050420168 238 2 100 0 1 238 51 288 Navicula tripunctata partial 28S rRNA gene, strain AT-202.01 blastn 23684 429 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula tripunctata
2708898 2708898 PRJNA1013345_P_NODE_7383_length_230_cov_1.732240_g7253_i0 PRJNA1013345 7383 230 1.73224 3.984152 Psammodictyon constrictum 515483 SAR_Eukaryotes SAR_Eukaryotes 298 2.39e-76   NTclustered gi|2202538965|gb|OM891871.1| 515483 g7253 i0 90.086 80.3826086956522 232 20 100 3 1 230 4255 4485 Psammodictyon constrictum 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 18488 298 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Psammodictyon Psammodictyon constrictum
3553048 3553048 PRJNA1013345_P_NODE_1823_length_417_cov_5.878378_g1699_i0 PRJNA1013345 1823 417 5.878378 24.51283626 Fragilaria 33644 SAR_Eukaryotes SAR_Eukaryotes 566 1.16e-156   NTclustered gi|18698483|gb|AF417684.1| 185980 g1699 i0 95.751 84.6019184652278 353 11 84 4 66 417 384 35 Fragilaria capucina strain M1767 large subunit ribosomal RNA gene, partial sequence blastn 35279 566 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria capucina
6536339 6536339 PRJNA1013345_P_NODE_14126_length_184_cov_2.722628_g13996_i0 PRJNA1013345 14126 184 2.722628 5.00963552 Fragilaria famelica 1003135 SAR_Eukaryotes SAR_Eukaryotes 230 6.749999999999998e-56   NTclustered gi|2862228909|gb|PQ645543.1| 1003135 g13996 i0 90.27 99.8858695652174 185 4 100 6 1 184 3402 3231 Fragilaria famelica isolate AGSB0425 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 18379 230 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria famelica
7380111 7380111 PRJNA1013345_P_NODE_17226_length_177_cov_3.353846_g17096_i0 PRJNA1013345 17226 177 3.353846 5.93630742 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 248 1.7799999999999998e-61   NTclustered gi|1862846707|emb|LR812489.1| 186038 g17096 i0 92.655 100.994350282486 177 6 100 1 1 177 7745 7914 Fragilariopsis kerguelensis, rDNA tandem repeat intergenic spacer region, 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 17876 248 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis kerguelensis
7380146 7380146 PRJNA1013345_P_NODE_22126_length_167_cov_1.500000_g21996_i0 PRJNA1013345 22126 167 1.5 2.505 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 309 7.53e-80   NTclustered gi|1530728959|gb|MH356727.1| 568900 g21996 i0 100 198 167 0 100 0 1 167 76017 75851 Seminavis robusta strain D6 chloroplast, complete genome blastn 33066 309 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
9930651 9930651 PRJNA1013345_P_NODE_9348_length_209_cov_4.870370_g9218_i0 PRJNA1013345 9348 209 4.87037 10.1790733 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 377 2.66e-100   NTclustered gi|2202538974|gb|OM891880.1| 355634 g9218 i0 99.517 98.799043062201 207 1 99 0 1 207 3751 3957 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 20649 377 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula arenaria
11205711 11205711 PRJNA1013345_P_NODE_10809_length_199_cov_8.171053_g10679_i0 PRJNA1013345 10809 199 8.171053 16.26039547 Fragilariophyceae 33853 SAR_Eukaryotes SAR_Eukaryotes 368 1.51e-97   NTclustered gi|1389852305|gb|MH356257.1| 185980 g10679 i0 100 100.005025125628 199 0 100 0 1 199 333 135 Fragilaria capucina isolate HYU-D008 small subunit ribosomal RNA gene, partial sequence blastn 19901 368 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria capucina
16304959 16304959 PRJNA1013345_P_NODE_19873_length_171_cov_4.653226_g19743_i0 PRJNA1013345 19873 171 4.653226 7.95701646 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 316 4.6e-82   NTclustered gi|1169296927|gb|KY364697.1| 29204 g19743 i0 100 100 171 0 100 0 1 171 5289 5119 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 17100 316 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
18009891 18009891 PRJNA1013345_P_NODE_10035_length_205_cov_5.151899_g9905_i0 PRJNA1013345 10035 205 5.151899 10.56139295 Tabularia sp. 2508070 SAR_Eukaryotes SAR_Eukaryotes 335 1.5899999999999992e-87   NTclustered gi|2862228887|gb|PQ645521.1| 2508070 g9905 i0 96.098 65.9268292682927 205 8 100 0 1 205 3893 4097 Tabularia sp. isolate AGSB0382 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 13515 335 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Tabularia Tabularia sp.
20128965 20128965 PRJNA1013345_P_NODE_5976_length_250_cov_4.310345_g5846_i0 PRJNA1013345 5976 250 4.310345 10.7758625 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 451 1.91e-122   NTclustered gi|268633306|gb|GQ844874.1| 29207 g5846 i0 99.2 100 250 2 100 0 1 250 167 416 Stephanodiscus hantzschii isolate UTCC 267 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 25000 451 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus hantzschii
23954837 23954837 PRJNA1013345_P_NODE_23919_length_164_cov_2.461538_g23789_i0 PRJNA1013345 23919 164 2.461538 4.03692232 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 294 2.06e-75   NTclustered gi|2194766164|gb|OK505009.1| 2856 g23789 i0 99.383 195.878048780488 162 1 99 0 3 164 19736 19575 Cylindrotheca closterium chloroplast, complete genome blastn 32124 294 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
23954840 23954840 PRJNA1013345_P_NODE_24779_length_163_cov_6.250000_g24649_i0 PRJNA1013345 24779 163 6.25 10.1875 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 302 1.22e-77   NTclustered gi|2468683651|ref|NC_072630.1| 29208 g24649 i0 100 198.343558282209 163 0 100 0 1 163 70099 70261 Stephanodiscus niagarae strain BB16 chloroplast, complete genome blastn 32330 302 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus niagarae
25228701 25228701 PRJNA1013345_P_NODE_13340_length_186_cov_1.856115_g13210_i0 PRJNA1013345 13340 186 1.856115 3.4523739 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 333 5.069999999999999e-87   NTclustered gi|2202538974|gb|OM891880.1| 355634 g13210 i0 98.93 82.4247311827957 187 1 100 1 1 186 4385 4199 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 15331 333 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula arenaria
25228798 25228798 PRJNA1013345_P_NODE_4500_length_282_cov_3.510638_g4371_i0 PRJNA1013345 4500 282 3.510638 9.89999916 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 505 1.6599999999999995e-138   NTclustered gi|768321723|gb|KJ961668.1| 355634 g4371 i0 99.283 98.3794326241135 279 2 99 0 4 282 291 13 Navicula arenaria 18S ribosomal RNA gene, partial sequence blastn 27743 510 0.990196078431373 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula arenaria
31172036 31172036 PRJNA1013345_P_NODE_30475_length_158_cov_1.837838_g30345_i0 PRJNA1013345 30475 158 1.837838 2.90378404 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 66.2 5.95e-11   NR CAJ1946243.1 2856 g30345 i0 67.3 1.93670886075949 52 16 98.7 1 2 157 355 405 CAJ1946243.1 unnamed protein product [Cylindrotheca closterium] diamond 306 66.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
32311419 32311419 PRJNA1013345_P_NODE_28999_length_160_cov_0.902655_g28869_i0 PRJNA1013345 28999 160 0.902655 1.444248 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 105 6.81e-25   NR CAB9506846.1 568900 g28869 i0 97.8 0.8625 46 1 86.3 0 138 1 298 343 CAB9506846.1 protein ligase MARCH7 [Seminavis robusta] diamond 138 105 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta

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