RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where bioproject = "PRJNA599208", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 11 ✖

tax_clade 1

  • Sar · 11 ✖

bioproject 1

  • PRJNA599208 · 11 ✖

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
6950541 6950541 PRJNA599208_P_NODE_6626_length_293_cov_4.445312_g6430_i0 PRJNA599208 6626 293 4.445312 13.02476416 Tabularia sp. 2508070 SAR_Eukaryotes SAR_Eukaryotes 233 9.04e-57   NTclustered gi|2862228866|gb|PQ645500.1| 2508070 g6430 i0 85.47 60.6245733788396 234 22 78 11 66 293 2665 2892 Tabularia sp. isolate AGSB0351 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 17763 233 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Tabularia Tabularia sp.
8225374 8225374 PRJNA599208_P_NODE_15107_length_161_cov_1.064516_g14911_i0 PRJNA599208 15107 161 1.064516 1.71387076 Pseudo-nitzschia hainanensis 2775602 SAR_Eukaryotes SAR_Eukaryotes 213 5.8e-51   NTclustered gi|2839792208|gb|PQ512806.1| 2775602 g14911 i0 90.683 33.0496894409938 161 14 100 1 1 161 6024 5865 Pseudo-nitzschia hainanensis isolate CNS00090 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 5321 213 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia hainanensis
9500633 9500633 PRJNA599208_P_NODE_12388_length_184_cov_2.095238_g12192_i0 PRJNA599208 12388 184 2.095238 3.85523792 Discostella nipponica 1365926 SAR_Eukaryotes SAR_Eukaryotes 335 1.3899999999999996e-87   NTclustered gi|1041923292|dbj|AB831889.1| 1365926 g12192 i0 100 98.4076086956522 181 0 98 0 4 184 2829 2649 Discostella nipponica genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2 and 28S rRNA, partial sequence blastn 18107 335 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella nipponica
10776578 10776578 PRJNA599208_P_NODE_6629_length_293_cov_3.546875_g6433_i0 PRJNA599208 6629 293 3.546875 10.39234375 Discostella guiyangensis 3145224 SAR_Eukaryotes SAR_Eukaryotes 520 6.2e-143   NTclustered gi|2728413627|gb|OR666655.1| 3145224 g6433 i0 98.639 198.351535836177 294 3 100 1 1 293 69370 69663 Discostella guiyangensis strain GY168 chloroplast, complete genome blastn 58117 520 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella guiyangensis
10776599 10776599 PRJNA599208_P_NODE_7929_length_257_cov_1.168182_g7733_i0 PRJNA599208 7929 257 1.168182 3.00222774 Nitzschia anatoliensis 2862141 SAR_Eukaryotes SAR_Eukaryotes 392 1.21e-104   NTclustered gi|2072715385|gb|MT740317.1| 2862141 g7733 i0 94.163 100.891050583658 257 15 100 0 1 257 5463 5719 Nitzschia anatoliensis clone SZCZ E372 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 25929 392 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia anatoliensis
10776607 10776607 PRJNA599208_P_NODE_8329_length_248_cov_1.781991_g8133_i0 PRJNA599208 8329 248 1.781991 4.41933768 Discostella sp. 2728207 SAR_Eukaryotes SAR_Eukaryotes 448 2.4499999999999996e-121   NTclustered gi|2632235294|gb|OR922676.1| 2728207 g8133 i0 99.194 97.6854838709677 248 2 100 0 1 248 3713 3466 Discostella sp. strain AGSB0027 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 24226 448 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella sp.
13895519 13895519 PRJNA599208_P_NODE_4831_length_368_cov_5.567976_g4636_i0 PRJNA599208 4831 368 5.567976 20.49015168 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 630 3.5299999999999985e-176   NTclustered gi|2194766164|gb|OK505009.1| 2856 g4636 i0 97.554 199.051630434783 368 9 100 0 1 368 19436 19069 Cylindrotheca closterium chloroplast, complete genome blastn 73251 636 0.990566037735849 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
14601171 14601171 PRJNA599208_P_NODE_5712_length_327_cov_2.262069_g5516_i0 PRJNA599208 5712 327 2.262069 7.39696563 uncultured Bacillariales 376604 SAR_Eukaryotes SAR_Eukaryotes 566 8.879999999999998e-157   NTclustered gi|1833330042|gb|MT361454.1| 376604 g5516 i0 97.859 99.9938837920489 327 7 100 0 1 327 53 379 Uncultured Bacillariales clone SmS655 small subunit ribosomal RNA gene, partial sequence blastn 32698 566 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales     uncultured Bacillariales
18992903 18992903 PRJNA599208_P_NODE_6475_length_297_cov_5.042308_g6279_i0 PRJNA599208 6475 297 5.042308 14.97565476 Thalassiosiraceae 29202 SAR_Eukaryotes SAR_Eukaryotes 470 6.43e-128   NTclustered gi|2127884309|ref|NC_058875.1| 376140 g6279 i0 95.27 196.313131313131 296 14 99 0 1 296 14949 15244 Thalassiosira profunda isolate CNS00050 chloroplast, complete genome blastn 58305 470 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira profunda
18992905 18992905 PRJNA599208_P_NODE_6815_length_288_cov_1.880478_g6619_i0 PRJNA599208 6815 288 1.880478 5.41577664 Bacillariophyceae 33849 SAR_Eukaryotes SAR_Eukaryotes 475 1.3299999999999996e-129   NTclustered gi|2202538960|gb|OM891866.1| 1003048 g6619 i0 96.528 100.090277777778 288 8 100 2 1 288 3471 3756 Entomoneis ornata 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 28826 475 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis ornata
25367799 25367799 PRJNA599208_P_NODE_16000_length_155_cov_0.983051_g15804_i0 PRJNA599208 16000 155 0.983051 1.52372905 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 115 1.6e-21   NTclustered gi|2444483253|gb|OP718170.1| 97227 g15804 i0 86.486 36.9548387096774 111 8 69 6 1 107 5581 5688 Gomphonema parvulum mitochondrion, complete genome blastn 5728 115 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Gomphonemataceae Gomphonema Gomphonema parvulum

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