RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA999747" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA999747 · 4 ✖

analysis 1

  • diamond · 4 ✖
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
16576815 16576815 PRJNA999747_S_NODE_3113_length_177_cov_3.041096_g3081_i0 PRJNA999747 3113 177 3.041096 5.38273992 Metazoa 33208 Mollusca Mollusca 100 3.8299999999999997e-23   NR KAK3088013.1 66713 g3081 i0 82.5 25.1525423728814 57 10 96.6 0 2 172 193 249 KAK3088013.1 hypothetical protein FSP39_013455 [Pinctada imbricata] diamond 4452 101 0.99009900990099 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pterioida Pteriidae Pinctada Pinctada imbricata
29016398 29016398 PRJNA999747_S_NODE_3968_length_159_cov_1.671875_g3936_i0 PRJNA999747 3968 159 1.671875 2.65828125 Liolophura japonica 13599 Mollusca Mollusca 89.7 2.23e-19   NR XP_064595148.1 13599 g3936 i0 78.8 3.77358490566038 52 11 98.1 0 4 159 181 232 XP_064595148.1 S-adenosylmethionine synthase-like [Liolophura japonica] diamond 600 89.7 1 Eukaryota Opisthokonta Metazoa Mollusca Polyplacophora Chitonida Chitonidae Liolophura Liolophura japonica
29426333 29426333 PRJNA999747_S_NODE_1049_length_287_cov_144.437500_g1017_i0 PRJNA999747 1049 287 144.4375 414.535625 Potamilus streckersoni 2493646 Mollusca Mollusca 43.5 0.00772   NR KAK3580123.1 2493646 g1017 i0 45.5 0.888501742160279 44 24 46 0 248 117 4 47 KAK3580123.1 hypothetical protein CHS0354_034063 [Potamilus streckersoni] diamond 255 43.5 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Unionida Unionidae Potamilus Potamilus streckersoni
30000944 30000944 PRJNA999747_S_NODE_3591_length_166_cov_2.185185_g3559_i0 PRJNA999747 3591 166 2.185185 3.6274071 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 81.6 2.55e-16   NR KAK3762911.1 231223 g3559 i0 75.9 15.6686746987952 54 13 97.6 0 162 1 241 294 KAK3762911.1 hypothetical protein RRG08_008129 [Elysia crispata] diamond 2601 82.4 0.990291262135922 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Plakobranchidae Elysia Elysia crispata

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