RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_clade 1

bioproject 1

  • PRJNA283169 · 7 ✖

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
8711672 8711672 PRJNA283169_S_NODE_1847_length_206_cov_0.267516_g1833_i0 PRJNA283169 1847 206 0.267516 0.55108296 Ulnaria 426668 SAR_Eukaryotes SAR_Eukaryotes 340 3.429999999999999e-89   NTclustered gi|187957792|emb|AM497727.1| 426669 g1833 i0 100 89.3203883495146 184 0 89 0 12 195 1613 1430 Synedra ulna 18S rRNA gene, strain AtFULN1 blastn 18400 340 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria ulna
8711675 8711675 PRJNA283169_S_NODE_3267_length_164_cov_0.191304_g3253_i0 PRJNA283169 3267 164 0.191304 0.31373856 Naviculales 38748 SAR_Eukaryotes SAR_Eukaryotes 241 2.72e-59   NTclustered gi|146762526|gb|EF553458.1| 2850 g3253 i0 94.268 94.8963414634146 157 9 96 0 1 157 3912 4068 Phaeodactylum tricornutum strain CCAP 1055/1 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 15563 241 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
18910431 18910431 PRJNA283169_P_NODE_7055_length_166_cov_0.880342_g6992_i0 PRJNA283169 7055 166 0.880342 1.46136772 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 268 1.27e-67   NTclustered gi|946969524|gb|KP400274.1| 2850 g6992 i0 98.065 93.3734939759036 155 2 93 1 12 166 260 413 Phaeodactylum tricornutum strain ROS_KABB1 18S ribosomal RNA gene, partial sequence blastn 15500 268 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
20773315 20773315 PRJNA283169_S_NODE_1377_length_232_cov_0.147541_g1363_i0 PRJNA283169 1377 232 0.147541 0.34229512 Ulnaria ulna 426669 SAR_Eukaryotes SAR_Eukaryotes 416 6.389999999999998e-112   NTclustered gi|2579686273|ref|NC_082433.1| 426669 g1363 i0 99.563 195.711206896552 229 0 98 1 5 232 66974 67202 Ulnaria ulna chloroplast, complete genome blastn 45405 416 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria ulna
22735824 22735824 PRJNA283169_S_NODE_1198_length_247_cov_0.095960_g1184_i0 PRJNA283169 1198 247 0.09596 0.2370212 Ulnaria 426668 SAR_Eukaryotes SAR_Eukaryotes 451 1.88e-122   NTclustered gi|2579686273|ref|NC_082433.1| 426669 g1184 i0 99.595 199.939271255061 247 1 100 0 1 247 65626 65872 Ulnaria ulna chloroplast, complete genome blastn 49385 451 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Licmophorales Ulnariaceae Ulnaria Ulnaria ulna
30502565 30502565 PRJNA283169_S_NODE_3133_length_166_cov_0.863248_g3119_i0 PRJNA283169 3133 166 0.863248 1.43299168 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 92.4 3.6e-20   NR EJK66451.1 159749 g3119 i0 88.7 8.51204819277108 53 6 95.8 0 161 3 378 430 EJK66451.1 hypothetical protein THAOC_12633 [Thalassiosira oceanica] diamond 1413 92.8 0.995689655172414 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira oceanica
31622696 31622696 PRJNA283169_P_NODE_6516_length_169_cov_0.866667_g6453_i0 PRJNA283169 6516 169 0.866667 1.46466723 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 46.6 6.1e-4   NR CAJ1964303.1 2856 g6453 i0 42.6 1.20710059171598 68 20 94.1 3 160 2 246 309 CAJ1964303.1 unnamed protein product [Cylindrotheca closterium] diamond 204 46.6 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium

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