RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA575566 · 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
28072168 28072168 PRJNA575566_P_NODE_22785_length_217_cov_1.057692_g22588_i0 PRJNA575566 22785 217 1.057692 2.29519164 Opisthokonta 33154 Mollusca Mollusca 82 1.28e-16   NR XP_050405502.1 6465 g22588 i0 68.5 35.7096774193548 54 17 74.7 0 217 56 239 292 XP_050405502.1 ATP-binding cassette sub-family C member 10 isoform X3 [Patella vulgata] diamond 7749 82.8 0.990338164251208 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata
28482727 28482727 PRJNA575566_P_NODE_17266_length_254_cov_0.917098_g17069_i0 PRJNA575566 17266 254 0.917098 2.32942892 root 1 Root_unresolved Root_unresolved 90.1 9.29e-19   NR XP_069108024.1 31199 g17069 i0 46.4 12.5433070866142 84 45 99.2 0 1 252 1137 1220 XP_069108024.1 LOW QUALITY PROTEIN: xanthine dehydrogenase/oxidase-like [Argopecten irradians] diamond 3186 90.9 0.991199119911991 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Argopecten Argopecten irradians
29321548 29321548 PRJNA575566_P_NODE_29769_length_201_cov_0.914286_g29572_i0 PRJNA575566 29769 201 0.914286 1.83771486 Elysia chlorotica 188477 Mollusca Mollusca 46.2 0.00128   NR RUS75705.1 188477 g29572 i0 43.9 2.76119402985075 57 26 76.1 2 160 8 376 432 RUS75705.1 hypothetical protein EGW08_016520 [Elysia chlorotica] diamond 555 46.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Plakobranchidae Elysia Elysia chlorotica
29700122 29700122 PRJNA575566_P_NODE_24950_length_208_cov_0.870748_g24753_i0 PRJNA575566 24950 208 0.870748 1.81115584 Gigantopelta aegis 1735272 Mollusca Mollusca 76.3 3.53e-14   NR XP_041350101.1 1735272 g24753 i0 57.4 1.96153846153846 68 27 98.1 1 206 3 462 527 XP_041350101.1 endoplasmin-like [Gigantopelta aegis] diamond 408 76.3 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Neomphalida Peltospiridae Gigantopelta Gigantopelta aegis
30219463 30219463 PRJNA575566_P_NODE_28912_length_202_cov_0.907801_g28715_i0 PRJNA575566 28912 202 0.907801 1.83375802 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 98.6 4.61e-22   NR KAH9496274.1 55810 g28715 i0 70.8 2.91089108910891 65 18 96.5 1 6 200 507 570 KAH9496274.1 hypothetical protein Btru_017966 [Bulinus truncatus] diamond 588 99.4 0.991951710261569 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Planorbidae Bulinus Bulinus truncatus
32685088 32685088 PRJNA575566_P_NODE_22300_length_220_cov_1.207547_g22103_i0 PRJNA575566 22300 220 1.207547 2.6566034 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 44.3 0.00811   NR XP_022324270.1 6565 g22103 i0 42.9 2.60454545454545 49 22 58.6 1 26 154 384 432 XP_022324270.1 von Willebrand factor D and EGF domain-containing protein-like isoform X4 [Crassostrea virginica] diamond 573 44.3 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Crassostrea Crassostrea virginica

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