RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where bioproject = "PRJNA691918" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 10 ✖

tax_clade 1

bioproject 1

  • PRJNA691918 · 10 ✖

analysis 1

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
3223375 3223375 PRJNA691918_S_NODE_103_length_223_cov_15840.041667_g102_i0 PRJNA691918 103 223 15840.041667 35323.29291741 Halamphora coffeiformis 1487565 SAR_Eukaryotes SAR_Eukaryotes 196 8.64e-46   NTclustered gi|1418576889|ref|NC_037727.1| 1487565 g102 i0 86.264 44.7264573991031 182 24 81 1 43 223 31076 30895 Halamphora coffeaeformis mitochondrion, complete genome blastn 9974 196 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Amphipleuraceae Halamphora Halamphora coffeiformis
5007570 5007570 PRJNA691918_S_NODE_364_length_168_cov_96.627737_g363_i0 PRJNA691918 364 168 96.627737 162.33459816 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 279 5.95e-71   NTclustered gi|952988067|gb|KT072974.1| 85094 g363 i0 99.351 93.5595238095238 154 1 92 0 14 167 700 547 Nitzschia frustulum isolate TCC551 18S ribosomal RNA gene, partial sequence blastn 15718 279 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia frustulum
5775983 5775983 PRJNA691918_S_NODE_225_length_191_cov_100.625000_g224_i0 PRJNA691918 225 191 100.625 192.19375 Discostella nipponica 1365926 SAR_Eukaryotes SAR_Eukaryotes 337 4.05e-88   NTclustered gi|1041923292|dbj|AB831889.1| 1365926 g224 i0 98.429 100.010471204188 191 3 100 0 1 191 2873 2683 Discostella nipponica genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2 and 28S rRNA, partial sequence blastn 19102 337 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella nipponica
8325605 8325605 PRJNA691918_S_NODE_187_length_198_cov_95.167665_g186_i0 PRJNA691918 187 198 95.167665 188.4319767 Diatoma moniliforme 515476 SAR_Eukaryotes SAR_Eukaryotes 294 2.58e-75   NTclustered gi|370991548|dbj|AB430635.1| 515476 g186 i0 94.271 96.2676767676768 192 11 97 0 7 198 130 321 Diatoma moniliforme gene for 28S rRNA, partial sequence, strain: s0383 blastn 19061 294 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Diatoma Diatoma moniliforme
11382745 11382745 PRJNA691918_S_NODE_69_length_242_cov_14672.004739_g68_i0 PRJNA691918 69 242 14672.004739 35506.251468379996 Cocconeis 216715 SAR_Eukaryotes SAR_Eukaryotes 333 6.949999999999999e-87   NTclustered gi|1293315594|gb|KY650805.1| 431340 g68 i0 98.925 77.6280991735537 186 2 77 0 5 190 857 1042 Cocconeis pediculus strain D36_020 18S ribosomal RNA gene, partial sequence blastn 18786 333 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cocconeidales Cocconeidaceae Cocconeis Cocconeis pediculus
13933206 13933206 PRJNA691918_S_NODE_71_length_241_cov_14435.828571_g70_i0 PRJNA691918 71 241 14435.828571 34790.34685611 Cocconeis 216715 SAR_Eukaryotes SAR_Eukaryotes 333 6.919999999999998e-87   NTclustered gi|1293315594|gb|KY650805.1| 431340 g70 i0 98.925 77.9502074688797 186 2 77 0 52 237 1042 857 Cocconeis pediculus strain D36_020 18S ribosomal RNA gene, partial sequence blastn 18786 333 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cocconeidales Cocconeidaceae Cocconeis Cocconeis pediculus
15207816 15207816 PRJNA691918_S_NODE_92_length_226_cov_15767.112821_g91_i0 PRJNA691918 92 226 15767.112821 35633.67497546 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 279 8.48e-71   NTclustered gi|98978936|gb|DQ512455.1| 382379 g91 i0 95.93 76.1150442477876 172 7 76 0 55 226 287 116 Cyclostephanos invisitatus strain FHTC26 large subunit ribosomal RNA gene, partial sequence blastn 17202 279 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclostephanos Cyclostephanos invisitatus
18524466 18524466 PRJNA691918_S_NODE_135_length_214_cov_16765.114754_g134_i0 PRJNA691918 135 214 16765.114754 35877.34557356 Nitzschia reversa 2675857 SAR_Eukaryotes SAR_Eukaryotes 246 8.06e-61   NTclustered gi|2862228864|gb|PQ645498.1| 2675857 g134 i0 93.865 76.3411214953271 163 10 76 0 51 213 3944 3782 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 16337 246 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia reversa
19799400 19799400 PRJNA691918_S_NODE_116_length_219_cov_15179.015957_g115_i0 PRJNA691918 116 219 15179.015957 33242.04494583 Pleurosigma sp. 1960768 SAR_Eukaryotes SAR_Eukaryotes 191 3.94e-44   NTclustered gi|1341034628|gb|MG914027.1| 1960768 g115 i0 97.321 52.7671232876712 112 3 51 0 62 173 621 732 Pleurosigma sp. isolate SKLMP_Sh005 large subunit ribosomal RNA gene, partial sequence blastn 11556 191 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Pleurosigmataceae Pleurosigma Pleurosigma sp.
21581449 21581449 PRJNA691918_S_NODE_377_length_166_cov_83.651852_g376_i0 PRJNA691918 377 166 83.651852 138.86207432 Cocconeis 216715 SAR_Eukaryotes SAR_Eukaryotes 272 9.8e-69   NTclustered gi|831437175|gb|KR090035.1| 137771 g376 i0 98.693 93.0301204819277 153 2 92 0 1 153 7 159 Uncultured diatom clone 118292_TP_16_e_D4 18S ribosomal RNA gene, partial sequence blastn 15443 272 1 Eukaryota Sar   Bacillariophyta         uncultured diatom

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