RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA849172" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA849172 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
1232265 1232265 PRJNA849172_P_NODE_21161_length_448_cov_7.880000_g20802_i0 PRJNA849172 21161 448 7.88 35.3024 root 1 Root_unresolved Root_unresolved 52.8 0.043   NTclustered gi|2912998015|dbj|AP039603.1| 145626 g20802 i0 100 0.216517857142857 28 0 6 0 120 147 51773665 51773638 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 22, sequence blastn 97 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
5938856 5938856 PRJNA849172_P_NODE_21745_length_441_cov_21.975543_g21386_i0 PRJNA849172 21745 441 21.975543 96.91214463 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.043   NTclustered gi|2912985489|dbj|AP039590.1| 145626 g21386 i0 100 0.0634920634920635 28 0 6 0 316 343 15071328 15071355 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 9, sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
8488054 8488054 PRJNA849172_P_NODE_142027_length_205_cov_5.651515_g141667_i0 PRJNA849172 142027 205 5.651515 11.58560575 Orientogalba viridis 2529401 Mollusca Mollusca 363 7.279999999999998e-96   NTclustered gi|2599450769|gb|OR728033.1| 2529401 g141667 i0 98.537 89.3951219512195 205 3 100 0 1 205 22 226 Orientogalba viridis isolate MAL_viridis_1 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 18326 363 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lymnaeidae Orientogalba Orientogalba viridis
11039482 11039482 PRJNA849172_P_NODE_25509_length_406_cov_51.126126_g25150_i0 PRJNA849172 25509 406 51.126126 207.57207156 Mytilus californianus 6549 Mollusca Mollusca 67.6 1.39e-6   NTclustered gi|2334701883|ref|XM_052243017.1| 6549 g25150 i0 90.196 0.697044334975369 51 5 13 0 313 363 165 115 PREDICTED: Mytilus californianus keratin-associated protein 19-2-like (LOC127733703), mRNA blastn 283 67.6 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus californianus
11039989 11039989 PRJNA849172_P_NODE_41689_length_320_cov_22.000000_g41329_i0 PRJNA849172 41689 320 22 70.4 Physella acuta 109671 Mollusca Mollusca 586 6.65e-163   NTclustered gi|2572275697|ref|XM_059323204.1| 109671 g41329 i0 99.688 1 320 1 100 0 1 320 901 582 PREDICTED: Physella acuta small ribosomal subunit protein eS6 (LOC131958246), mRNA blastn 320 586 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
18688069 18688069 PRJNA849172_P_NODE_59255_length_282_cov_1.755981_g58895_i0 PRJNA849172 59255 282 1.755981 4.95186642 Physella acuta 109671 Mollusca Mollusca 82.4 3.32e-11   NTclustered gi|2572282417|ref|XM_059315867.1| 109671 g58895 i0 96.078 0.180851063829787 51 1 18 1 233 282 2028 2078 PREDICTED: Physella acuta uncharacterized LOC131952927 (LOC131952927), mRNA blastn 51 82.4 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
23789409 23789409 PRJNA849172_P_NODE_69059_length_270_cov_6.659898_g68699_i0 PRJNA849172 69059 270 6.659898 17.9817246 Physella acuta 109671 Mollusca Mollusca 433 7.56e-117   NTclustered gi|2465302311|gb|OQ561514.1| 109671 g68699 i0 99.17 63.8888888888889 241 1 89 1 29 269 10677 10916 Physella acuta strain A isolate F8A6 mitochondrion, complete genome blastn 17250 433 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);;