RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA902848" 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

  • PRJNA902848 · 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
8534841 8534841 PRJNA902848_P_NODE_14007_length_252_cov_0.871508_g13957_i0 PRJNA902848 14007 252 0.871508 2.19620016 Exaiptasia diaphana 2652724 Cnidaria other_Eukaryota 61.2 1.24e-8   NR KXJ08354.1 2652724 g13957 i0 55 0.476190476190476 40 18 47.6 0 56 175 42 81 KXJ08354.1 Prolow-density lipoprotein receptor-related protein 1 [Exaiptasia diaphana] diamond 120 61.2 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Actiniaria Aiptasiidae Exaiptasia Exaiptasia diaphana
12361161 12361161 PRJNA902848_P_NODE_8150_length_309_cov_1.652542_g8100_i0 PRJNA902848 8150 309 1.652542 5.10635478 root 1 Root_unresolved Root_unresolved 183 2.94e-56   NR XP_066925013.1 252671 g8100 i0 83.3 4.95145631067961 102 17 99 0 307 2 43 144 XP_066925013.1 GTP-binding nuclear protein Ran-like [Clytia hemisphaerica] diamond 1530 184 0.994565217391304 Eukaryota Opisthokonta Metazoa Cnidaria Hydrozoa Leptothecata Clytiidae Clytia Clytia hemisphaerica
28824074 28824074 PRJNA902848_P_NODE_20408_length_242_cov_0.923077_g20358_i0 PRJNA902848 20408 242 0.923077 2.23384634 Desmophyllum pertusum 174260 Cnidaria other_Eukaryota 50.4 1.47e-5   NR KAJ7377012.1 174260 g20358 i0 41.5 4.21487603305785 82 44 96.7 4 237 4 6 87 KAJ7377012.1 hypothetical protein OS493_031285 [Desmophyllum pertusum] diamond 1020 50.4 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Caryophylliidae Desmophyllum Desmophyllum pertusum
29392781 29392781 PRJNA902848_P_NODE_11049_length_273_cov_1.340000_g10999_i0 PRJNA902848 11049 273 1.34 3.6582 Orbicella faveolata 48498 Cnidaria other_Eukaryota 66.6 1.99e-10   NR XP_020631452.1 48498 g10999 i0 43 0.868131868131868 79 40 81.3 1 1 222 292 370 XP_020631452.1 uncharacterized protein LOC110068417 [Orbicella faveolata] diamond 237 66.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Merulinidae Orbicella Orbicella faveolata
30624414 30624414 PRJNA902848_P_NODE_13173_length_253_cov_0.866667_g13123_i0 PRJNA902848 13173 253 0.866667 2.19266751 Xenia sp. Carnegie-2 86540 Cnidaria other_Eukaryota 73.6 1.37e-13   NR XP_046847902.1 2897299 g13123 i0 49.3 4.43478260869565 73 37 86.6 0 252 34 60 132 XP_046847902.1 ribosomal RNA processing protein 36 homolog [Xenia sp. Carnegie-2017] diamond 1122 73.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Malacalcyonacea Xeniidae Xenia Xenia sp. Carnegie-2017
32718689 32718689 PRJNA902848_P_NODE_1780_length_544_cov_2.382166_g1731_i0 PRJNA902848 1780 544 2.382166 12.95898304 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 112 3.76e-28   NR XP_029195141.1 45264 g1731 i0 49.6 5.63051470588235 133 66 72.8 1 531 136 2 134 XP_029195141.1 60S ribosomal protein L14-like [Acropora millepora] diamond 3063 112 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora

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