RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA768450", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 8 ✖

tax_clade 1

bioproject 1

  • PRJNA768450 · 8 ✖

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
746122 746122 PRJNA768450_S_NODE_761_length_600_cov_3.165154_g723_i0 PRJNA768450 761 600 3.165154 18.990924 Nitzschia anatoliensis 2862141 SAR_Eukaryotes SAR_Eukaryotes 867 0   NTclustered gi|2072715385|gb|MT740317.1| 2862141 g723 i0 94.211 90.1316666666667 570 29 95 4 1 568 6080 5513 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 54079 867 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia anatoliensis
3758071 3758071 PRJNA768450_S_NODE_3103_length_349_cov_6.426667_g3054_i0 PRJNA768450 3103 349 6.426667 22.42906783 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 640 5.529999999999999e-179   NTclustered gi|1134427466|gb|KX229689.1| 44446 g3054 i0 99.713 100.022922636103 349 1 100 0 1 349 9 357 Pseudo-nitzschia americana strain UNC1412 18S ribosomal RNA gene, partial sequence blastn 34908 645 0.992248062015504 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Pseudo-nitzschia Pseudo-nitzschia americana
9674034 9674034 PRJNA768450_S_NODE_16628_length_182_cov_3.992481_g16579_i0 PRJNA768450 16628 182 3.992481 7.26631542 Nitzschia sp. (in: diatoms) 1884248 SAR_Eukaryotes SAR_Eukaryotes 300 5.01e-77   NTclustered gi|2632235302|gb|OR922684.1| 1884248 g16579 i0 100 89.4395604395604 162 0 89 0 1 162 2973 2812 Nitzschia sp. (in: diatoms) strain AGSB0041 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 16278 300 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. (in: diatoms)
10134775 10134775 PRJNA768450_S_NODE_16128_length_184_cov_4.066667_g16079_i0 PRJNA768450 16128 184 4.066667 7.48266728 Bacillariaceae 33852 SAR_Eukaryotes SAR_Eukaryotes 307 3.0300000000000004e-79   NTclustered gi|2202538963|gb|OM891869.1| 2856 g16079 i0 100 90.0489130434783 166 0 90 0 1 166 3618 3453 Cylindrotheca closterium 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 16569 307 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
12225063 12225063 PRJNA768450_S_NODE_12070_length_206_cov_0.910828_g12021_i0 PRJNA768450 12070 206 0.910828 1.87630568 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 111 2.93e-20   NTclustered gi|219123891|ref|XM_002182214.1| 556484 g12021 i0 85.714 1.01941747572816 105 15 51 0 35 139 425 321 Phaeodactylum tricornutum CCAP 1055/1 ubiquitin extension protein 1/2 (UBI1/2), mRNA blastn 210 111 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
19872548 19872548 PRJNA768450_S_NODE_21536_length_166_cov_1.128205_g21487_i0 PRJNA768450 21536 166 1.128205 1.8728203 Rhoicosphenia cf. abbreviata EWT-2016 1827007 SAR_Eukaryotes SAR_Eukaryotes 302 1.2500000000000001e-77   NTclustered gi|1016106667|gb|KU965576.1| 1827007 g21487 i0 99.398 51.3674698795181 166 1 100 0 1 166 298 133 Rhoicosphenia cf. abbreviata EWT-2016 isolate 94_LSU large subunit ribosomal RNA gene, partial sequence blastn 8527 302 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Cymbellales Rhoicospheniaceae Rhoicosphenia Rhoicosphenia cf. abbreviata EWT-2016
22422794 22422794 PRJNA768450_S_NODE_14658_length_191_cov_2.873239_g14609_i0 PRJNA768450 14658 191 2.873239 5.48788649 Nitzschia anatoliensis 2862141 SAR_Eukaryotes SAR_Eukaryotes 276 8.95e-70   NTclustered gi|2072715385|gb|MT740317.1| 2862141 g14609 i0 96.951 38.979057591623 164 5 86 0 28 191 7080 7243 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 7445 276 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia anatoliensis
24972447 24972447 PRJNA768450_S_NODE_23520_length_162_cov_1.327434_g23471_i0 PRJNA768450 23520 162 1.327434 2.15044308 Proschkinia sp. SZCZR1824 2588390 SAR_Eukaryotes SAR_Eukaryotes 71.3 3.72e-8   NTclustered gi|1681061561|gb|MH800316.1| 2588390 g23471 i0 77.966 0.728395061728395 118 22 72 4 44 160 4566 4452 Proschkinia sp. SZCZR1824 mitochondrion, complete genome blastn 118 71.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Proschkiniaceae Proschkinia Proschkinia sp. SZCZR1824

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