RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJDB12578" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 5 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJDB12578 · 5 ✖

analysis 1

  • diamond · 5 ✖
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
29085224 29085224 PRJDB12578_S_NODE_93688_length_315_cov_1.541353_g70630_i0 PRJDB12578 93688 315 1.541353 4.85526195 Biomphalaria glabrata 6526 Mollusca Mollusca 42.7 0.0386   NR KAI8772923.1 6526 g70630 i0 27.8 0.685714285714286 72 51 67.6 1 28 240 35 106 KAI8772923.1 lactase-phlorizin hydrolase [Biomphalaria glabrata] diamond 216 42.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Planorbidae Biomphalaria Biomphalaria glabrata
29558577 29558577 PRJDB12578_S_NODE_100350_length_290_cov_2.136929_g77292_i0 PRJDB12578 100350 290 2.136929 6.1970941 Aplysia californica 6500 Mollusca Mollusca 45.1 0.0104   NR XP_005110315.2 6500 g77292 i0 38.6 0.455172413793103 44 27 45.5 0 214 83 844 887 XP_005110315.2 uncharacterized protein LOC101864487 [Aplysia californica] diamond 132 45.1 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Aplysiida Aplysiidae Aplysia Aplysia californica
29931953 29931953 PRJDB12578_S_NODE_178851_length_179_cov_1.084615_g155793_i0 PRJDB12578 178851 179 1.084615 1.94146085 Metazoa 33208 Mollusca Mollusca 55.1 7.05e-7   NR XP_046337764.1 6454 g155793 i0 74.3 37.5251396648045 35 9 58.7 0 25 129 144 178 XP_046337764.1 RNA polymerase-associated protein CTR9 homolog [Haliotis rufescens] diamond 6717 55.1 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis rufescens
30126910 30126910 PRJDB12578_S_NODE_137712_length_216_cov_2.844311_g114654_i0 PRJDB12578 137712 216 2.844311 6.14371176 Elysia marginata 1093978 Mollusca Mollusca 43.9 0.00377   NR GFR62198.1 1093978 g114654 i0 69.2 0.361111111111111 26 8 36.1 0 97 20 2 27 GFR62198.1 histone-lysine n-methyltransferase [Elysia marginata] diamond 78 43.9 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Plakobranchidae Elysia Elysia marginata
31992179 31992179 PRJDB12578_S_NODE_152718_length_200_cov_2.205298_g129660_i0 PRJDB12578 152718 200 2.205298 4.410596 Bulinus truncatus 55810 Mollusca Mollusca 42 0.0408   NR KAH9495934.1 55810 g129660 i0 33.9 0.885 59 37 87 2 185 12 1162 1219 KAH9495934.1 hypothetical protein Btru_013709 [Bulinus truncatus] diamond 177 42 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Planorbidae Bulinus Bulinus truncatus

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