RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA1146029" 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

  • PRJNA1146029 · 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
3584087 3584087 PRJNA1146029_P_NODE_15323_length_255_cov_1.604396_g15042_i0 PRJNA1146029 15323 255 1.604396 4.0912098 Corymorpha 264057 Cnidaria other_Eukaryota 220 6e-53   NTclustered gi|166407147|gb|EU272563.1| 498525 g15042 i0 83.607 89.478431372549 244 30 95 7 1 242 1025 1260 Corymorpha bigelowi voucher KUNHM 2829 28S large subunit ribosomal RNA gene, partial sequence blastn 22817 220 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Corymorphidae Corymorpha Corymorpha bigelowi
6667944 6667944 PRJNA1146029_P_NODE_15366_length_255_cov_1.269231_g15085_i0 PRJNA1146029 15366 255 1.269231 3.23653905 Actinia tenebrosa 6105 Cnidaria other_Eukaryota 235 2.1399999999999997e-57   NTclustered gi|1778059731|ref|XM_031711301.1| 6105 g15085 i0 83.333 101.380392156863 252 42 99 0 1 252 356 105 PREDICTED: Actinia tenebrosa ubiquitin-40S ribosomal protein S27a (LOC116302103), mRNA blastn 25852 235 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
10493667 10493667 PRJNA1146029_P_NODE_14029_length_264_cov_1.612565_g13748_i0 PRJNA1146029 14029 264 1.612565 4.2571716 Clytia hemisphaerica 252671 Cnidaria other_Eukaryota 169 2.3e-37   NTclustered gi|2782902330|ref|XM_067068799.1| 252671 g13748 i0 79.92 36.6666666666667 249 34 91 11 21 261 414 654 PREDICTED: Clytia hemisphaerica ATP synthase subunit beta, mitochondrial-like (LOC136812302), mRNA blastn 9680 169 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
20691772 20691772 PRJNA1146029_P_NODE_8937_length_304_cov_1.363636_g8656_i0 PRJNA1146029 8937 304 1.363636 4.14545344 Dendrogramma enigmatica 1960159 Cnidaria other_Eukaryota 78.7 4.67e-10   NTclustered gi|1150186410|gb|KU716075.1| 1960159 g8656 i0 84.337 16.7532894736842 83 10 27 3 154 234 744 825 Dendrogramma enigmatica 28S ribosomal RNA gene, partial sequence blastn 5093 78.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Siphonophorae Rhodaliidae Dendrogramma Dendrogramma enigmatica

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