RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "blastn", bioproject = "PRJNA596870" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 11 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA596870 · 11 ✖

analysis 1

  • blastn · 11 ✖
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
1844366 1844366 PRJNA596870_P_NODE_8722_length_423_cov_1.574286_g8589_i0 PRJNA596870 8722 423 1.574286 6.65922978 Physella acuta 109671 Mollusca Mollusca 782 0   NTclustered gi|2572452079|ref|XR_009385380.1| 109671 g8589 i0 100 60.8132387706856 423 0 100 0 1 423 2749 3171 PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA blastn 25724 782 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
4968586 4968586 PRJNA596870_P_NODE_15844_length_330_cov_1.198444_g15711_i0 PRJNA596870 15844 330 1.198444 3.9548652 Metazoa 33208 Mollusca Mollusca 220 8.05e-53   NTclustered gi|51105049|gb|AY577327.1| 6523 g15711 i0 83.913 60.9757575757576 230 37 70 0 6 235 257 28 Lymnaea stagnalis ADP ribosylation factor-like protein mRNA, partial cds blastn 20122 220 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lymnaeidae Lymnaea Lymnaea stagnalis
13322110 13322110 PRJNA596870_P_NODE_14991_length_337_cov_3.541667_g14858_i0 PRJNA596870 14991 337 3.541667 11.93541779 Physella acuta 109671 Mollusca Mollusca 616 8.989999999999998e-172   NTclustered gi|2572452079|ref|XR_009385380.1| 109671 g14858 i0 99.702 77.1424332344214 336 1 99 0 2 337 348 13 PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA blastn 25997 616 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
13894581 13894581 PRJNA596870_P_NODE_31991_length_249_cov_0.875000_g31858_i0 PRJNA596870 31991 249 0.875 2.17875 Opisthokonta 33154 Mollusca Mollusca 52.8 0.023   NTclustered gi|1897912320|ref|XM_005090209.3| 6500 g31858 i0 92.105 8.05220883534137 38 2 15 1 159 196 1984 1948 PREDICTED: Aplysia californica zinc finger protein rsv1 (LOC101863709), mRNA blastn 2005 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Aplysiida Aplysiidae Aplysia Aplysia californica
15168603 15168603 PRJNA596870_P_NODE_22772_length_283_cov_1.100000_g22639_i0 PRJNA596870 22772 283 1.1 3.113 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 56.5 0.002   NTclustered gi|1397715461|ref|XM_025248937.1| 400727 g22639 i0 100 1.85512367491166 30 0 11 0 123 152 864 835 PREDICTED: Pomacea canaliculata uncharacterized LOC112570499 (LOC112570499), mRNA blastn 525 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Architaenioglossa Ampullariidae Pomacea Pomacea canaliculata
15168639 15168639 PRJNA596870_P_NODE_28132_length_255_cov_1.384615_g27999_i0 PRJNA596870 28132 255 1.384615 3.53076825 Bivalvia 6544 Mollusca Mollusca 239 1.66e-58   NTclustered gi|2912438947|ref|XM_071270517.1| 6550 g27999 i0 83.594 96.8745098039216 256 41 100 1 1 255 1191 1446 PREDICTED: Mytilus edulis tubulin beta-4B chain (LOC139485869), mRNA blastn 24703 239 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus edulis
15870785 15870785 PRJNA596870_P_NODE_10013_length_399_cov_2.950920_g9880_i0 PRJNA596870 10013 399 2.95092 11.7741708 Physella acuta 109671 Mollusca Mollusca 737 0   NTclustered gi|2572452079|ref|XR_009385380.1| 109671 g9880 i0 100 51.2155388471178 399 0 100 0 1 399 1882 2280 PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA blastn 20435 737 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
15871021 15871021 PRJNA596870_P_NODE_22673_length_283_cov_1.466667_g22540_i0 PRJNA596870 22673 283 1.466667 4.15066761 Physella acuta 109671 Mollusca Mollusca 521 1.6599999999999996e-143   NTclustered gi|2572452079|ref|XR_009385380.1| 109671 g22540 i0 100 98.8021201413428 282 0 99 0 1 282 566 847 PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA blastn 27961 521 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
17145740 17145740 PRJNA596870_P_NODE_10674_length_388_cov_1.466667_g10541_i0 PRJNA596870 10674 388 1.466667 5.69066796 Ruditapes philippinarum 129788 Mollusca Mollusca 276 2.02e-69   NTclustered gi|2616582549|ref|XM_060721302.1| 129788 g10541 i0 83.333 58.430412371134 300 49 77 1 11 310 425 127 PREDICTED: Ruditapes philippinarum calmodulin (LOC132734544), transcript variant X1, mRNA blastn 22671 276 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Venerida Veneridae Ruditapes Ruditapes philippinarum
18991990 18991990 PRJNA596870_P_NODE_6555_length_478_cov_2.866667_g6422_i0 PRJNA596870 6555 478 2.866667 13.70266826 Metazoa 33208 Mollusca Mollusca 289 3.26e-73   NTclustered gi|1897919841|ref|XM_013080763.2| 6500 g6422 i0 78.889 90.0899581589958 450 77 92 17 34 474 62 502 PREDICTED: Aplysia californica 40S ribosomal protein S18 (LOC101863011), mRNA blastn 43063 289 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Aplysiida Aplysiidae Aplysia Aplysia californica
19694733 19694733 PRJNA596870_P_NODE_23536_length_279_cov_1.145631_g23403_i0 PRJNA596870 23536 279 1.145631 3.19631049 Ruditapes philippinarum 129788 Mollusca Mollusca 231 3.0699999999999996e-56   NTclustered gi|2616619385|ref|XM_060731797.1| 129788 g23403 i0 81.786 35.5878136200717 280 47 99 4 1 278 140 417 PREDICTED: Ruditapes philippinarum dynein light chain Tctex-type 1 (LOC132743263), mRNA blastn 9929 231 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Venerida Veneridae Ruditapes Ruditapes philippinarum

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