RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA473641" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA473641 · 6 ✖

analysis 1

  • diamond · 6 ✖
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
22772474 22772474 PRJNA473641_P_NODE_18038_length_250_cov_0.870056_g17955_i0 PRJNA473641 18038 250 0.870056 2.17514 Porites lobata 104759 Cnidaria other_Eukaryota 98.2 6.16e-23   NR CAH3176710.1 104759 g17955 i0 60.2 1.98 83 33 99.6 0 1 249 155 237 CAH3176710.1 unnamed protein product [Porites lobata] diamond 495 98.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Poritidae Porites Porites lobata
27329185 27329185 PRJNA473641_P_NODE_25683_length_241_cov_0.916667_g25600_i0 PRJNA473641 25683 241 0.916667 2.20916747 Actinia tenebrosa 6105 Cnidaria other_Eukaryota 54.3 3.13e-6   NR XP_031562691.1 6105 g25600 i0 51 1.8298755186722 51 25 63.5 0 79 231 709 759 XP_031562691.1 uncharacterized protein LOC116298393 isoform X2 [Actinia tenebrosa] diamond 441 54.3 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
28260742 28260742 PRJNA473641_P_NODE_23326_length_244_cov_0.900585_g23243_i0 PRJNA473641 23326 244 0.900585 2.1974274 root 1 Root_unresolved Root_unresolved 61.2 4.25e-9   NR KAJ7380294.1 174260 g23243 i0 46.3 3.5655737704918 67 36 82.4 0 1 201 25 91 KAJ7380294.1 hypothetical protein OS493_011011 [Desmophyllum pertusum] diamond 870 61.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Caryophylliidae Desmophyllum Desmophyllum pertusum
28844472 28844472 PRJNA473641_P_NODE_25388_length_241_cov_1.375000_g25305_i0 PRJNA473641 25388 241 1.375 3.31375 Porites lobata 104759 Cnidaria other_Eukaryota 45.8 0.00313   NR CAH3170622.1 104759 g25305 i0 48.9 1.41908713692946 47 20 57.3 2 92 229 3250 3293 CAH3170622.1 unnamed protein product, partial [Porites lobata] diamond 342 45.8 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Poritidae Porites Porites lobata
29334455 29334455 PRJNA473641_P_NODE_4829_length_412_cov_0.920354_g4746_i0 PRJNA473641 4829 412 0.920354 3.79185848 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 104 4.8e-23   NR XP_031566336.1 6105 g4746 i0 40.2 19.9077669902913 122 71 88.8 2 369 4 241 360 XP_031566336.1 copine-8-like isoform X1 [Actinia tenebrosa] diamond 8202 105 0.990476190476191 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Actiniidae Actinia Actinia tenebrosa
32036028 32036028 PRJNA473641_P_NODE_11898_length_296_cov_1.914798_g11815_i0 PRJNA473641 11898 296 1.914798 5.66780208 Hydra vulgaris 6087 Cnidaria other_Eukaryota 78.2 2.37e-14   NR XP_047141988.1 6087 g11815 i0 51.2 2.12837837837838 84 35 79.1 1 60 293 18 101 XP_047141988.1 uncharacterized protein sll0103 isoform X1 [Hydra vulgaris] diamond 630 78.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Anthoathecata Hydridae Hydra Hydra vulgaris

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