RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA613025" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA613025 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
591594 591594 PRJNA613025_S_NODE_14321_length_290_cov_6.564315_g14167_i0 PRJNA613025 14321 290 6.564315 19.0365135 Rhopilema esculentum 499914 Cnidaria other_Eukaryota 76.8 1.59e-9   NTclustered gi|2729058829|ref|XR_010517322.1| 499914 g14167 i0 92.453 15.7310344827586 53 4 18 0 33 85 3608 3556 PREDICTED: Rhopilema esculentum large subunit ribosomal RNA (LOC135695981), rRNA blastn 4562 76.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Rhizostomeae Rhizostomatidae Rhopilema Rhopilema esculentum
14620777 14620777 PRJNA613025_S_NODE_24612_length_190_cov_2.531915_g24458_i0 PRJNA613025 24612 190 2.531915 4.8106385 Ceratomyxa leatherjacketi 1579382 Cnidaria other_Eukaryota 115 2.0500000000000003e-21   NTclustered gi|730837044|gb|KM392428.1| 1579382 g24458 i0 90 19.3210526315789 90 8 47 1 99 188 380 468 Ceratomyxa leatherjacketi isolate LJ-GB-B 28S ribosomal RNA gene, partial sequence blastn 3671 115 1 Eukaryota Opisthokonta Metazoa Cnidaria Myxozoa Bivalvulida Ceratomyxidae Ceratomyxa Ceratomyxa leatherjacketi
16451742 16451742 PRJNA613025_S_NODE_9113_length_427_cov_13.955026_g8961_i0 PRJNA613025 9113 427 13.955026 59.58796102 Rhizostomeae 37535 Cnidaria other_Eukaryota 145 6.6e-30   NTclustered gi|2862235116|gb|PQ647263.1| 880218 g8961 i0 87.5 25.1381733021077 128 12 30 4 1 127 6904 6780 Cephea cephea isolate AGC18069 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 10734 145 1 Eukaryota Opisthokonta Metazoa Cnidaria Scyphozoa Rhizostomeae Cepheidae Cephea Cephea cephea
18443901 18443901 PRJNA613025_S_NODE_26275_length_182_cov_1.526316_g26121_i0 PRJNA613025 26275 182 1.526316 2.77789512 Hydractinia symbiolongicarpus 13093 Cnidaria other_Eukaryota 52.8 0.015   NTclustered gi|2518997299|ref|XM_057450091.1| 13093 g26121 i0 100 0.307692307692308 28 0 15 0 85 112 3028 3055 PREDICTED: Hydractinia symbiolongicarpus AT-rich interactive domain-containing protein 1A-like (LOC130644467), transcript variant X2, mRNA blastn 56 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydractiniidae Hydractinia Hydractinia symbiolongicarpus

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