RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA229468" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA229468 · 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
10571341 10571341 PRJNA229468_S_NODE_749_length_190_cov_1.517730_g736_i0 PRJNA229468 749 190 1.51773 2.883687 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 105 5.28e-26   NR XP_052775540.1 6604 g736 i0 78 44.8578947368421 59 13 93.2 0 13 189 166 224 XP_052775540.1 peroxiredoxin-1-like [Mya arenaria] diamond 8523 105 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
14396334 14396334 PRJNA229468_S_NODE_1032_length_168_cov_1.285714_g1019_i0 PRJNA229468 1032 168 1.285714 2.15999952 Haliotis rubra 36100 Mollusca Mollusca 107 2.66e-26   NR XP_046577959.1 36100 g1019 i0 87.3 7.85714285714286 55 7 98.2 0 2 166 120 174 XP_046577959.1 LOW QUALITY PROTEIN: glyceraldehyde-3-phosphate dehydrogenase 2-like [Haliotis rubra] diamond 1320 107 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis rubra
27755398 27755398 PRJNA229468_S_NODE_704_length_196_cov_1.319728_g691_i0 PRJNA229468 704 196 1.319728 2.58666688 root 1 Root_unresolved Root_unresolved 49.3 9.89e-5   NR XP_053394748.1 6596 g691 i0 45.2 9.79591836734694 73 29 98 2 196 5 496 566 XP_053394748.1 sterol carrier protein 2-like isoform X4 [Mercenaria mercenaria] diamond 1920 49.7 0.991951710261569 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Venerida Veneridae Mercenaria Mercenaria mercenaria
28305690 28305690 PRJNA229468_S_NODE_1186_length_163_cov_0.894737_g1173_i0 PRJNA229468 1186 163 0.894737 1.45842131 Saccostrea echinata 191078 Mollusca Mollusca 44.7 0.0027   NR XP_061173563.1 191078 g1173 i0 58.3 2.3558282208589 36 15 66.3 0 7 114 522 557 XP_061173563.1 fibropellin-1-like [Saccostrea echinata] diamond 384 44.7 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Saccostrea Saccostrea echinata
29744040 29744040 PRJNA229468_S_NODE_390_length_251_cov_1.405941_g377_i0 PRJNA229468 390 251 1.405941 3.52891191 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 121 1.02e-29   NR XP_070174385.1 31220 g377 i0 70 6.72908366533865 80 24 95.6 0 242 3 1336 1415 XP_070174385.1 multidrug resistance-associated protein 1-like [Littorina saxatilis] diamond 1689 121 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis
31970534 31970534 PRJNA229468_S_NODE_1098_length_166_cov_0.871795_g1085_i0 PRJNA229468 1098 166 0.871795 1.4471797 Physella acuta 109671 Mollusca Mollusca 42.7 0.0119   NR XP_059150767.1 109671 g1085 i0 37.3 2.7289156626506 59 32 97.6 1 3 164 129 187 XP_059150767.1 S-crystallin SL11-like isoform X1 [Physella acuta] diamond 453 42.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta

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