RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA635874 · 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
2429575 2429575 PRJNA635874_P_NODE_29582_length_304_cov_1.363636_g29435_i0 PRJNA635874 29582 304 1.363636 4.14545344 Metazoa 33208 Cnidaria other_Eukaryota 54.7 0.008   NTclustered gi|2917940696|emb|OZ237557.1| 6108 g29435 i0 100 7.37828947368421 29 0 10 0 137 165 10739329 10739301 Anemonia sulcata genome assembly, chromosome: 3 blastn 2243 54.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata
4435970 4435970 PRJNA635874_P_NODE_71064_length_242_cov_0.911243_g70917_i0 PRJNA635874 71064 242 0.911243 2.20520806 Actinia tenebrosa 6105 Cnidaria other_Eukaryota 63.9 1.01e-5   NTclustered gi|1778028274|ref|XR_004196220.1| 6105 g70917 i0 100 0.140495867768595 34 0 14 0 153 186 1230 1263 PREDICTED: Actinia tenebrosa uncharacterized LOC116288665 (LOC116288665), ncRNA blastn 34 63.9 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
5711887 5711887 PRJNA635874_P_NODE_69185_length_242_cov_0.911243_g69038_i0 PRJNA635874 69185 242 0.911243 2.20520806 Hydra vulgaris 6087 Cnidaria other_Eukaryota 52.8 0.022   NTclustered gi|2744876968|ref|XR_010640656.1| 6087 g69038 i0 96.774 0.256198347107438 31 1 13 0 85 115 774 744 PREDICTED: Hydra vulgaris uncharacterized LOC136084583 (LOC136084583), transcript variant X2, ncRNA blastn 62 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris
15910900 15910900 PRJNA635874_P_NODE_61913_length_245_cov_0.895349_g61766_i0 PRJNA635874 61913 245 0.895349 2.19360505 Anemonia sulcata 6108 Cnidaria other_Eukaryota 52.8 0.022   NTclustered gi|2917940712|emb|OZ237560.1| 6108 g61766 i0 100 2.08571428571429 28 0 11 0 115 142 8422598 8422571 Anemonia sulcata genome assembly, chromosome: 6 blastn 511 52.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Anemonia Anemonia sulcata

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