RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA529924" 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

  • PRJNA529924 · 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
2392721 2392721 PRJNA529924_P_NODE_2342_length_311_cov_7.134752_g2168_i0 PRJNA529924 2342 311 7.134752 22.18907872 Metazoa 33208 Mollusca Mollusca 158 5.9899999999999985e-34   NTclustered gi|2334673389|ref|XM_052235946.1| 6549 g2168 i0 87.97 40.8102893890675 133 16 43 0 1 133 1351 1483 PREDICTED: Mytilus californianus tubulin alpha-1A chain-like (LOC127728525), mRNA blastn 12692 158 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus californianus
4330193 4330193 PRJNA529924_P_NODE_1224_length_515_cov_9.386831_g1059_i0 PRJNA529924 1224 515 9.386831 48.34217965 Aplysia californica 6500 Mollusca Mollusca 289 3.53e-73   NTclustered gi|1897919841|ref|XM_013080763.2| 6500 g1059 i0 78.936 83.2466019417476 451 75 86 19 17 457 502 62 PREDICTED: Aplysia californica 40S ribosomal protein S18 (LOC101863011), mRNA blastn 42872 289 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Aplysiida Aplysiidae Aplysia Aplysia californica
4330197 4330197 PRJNA529924_P_NODE_2584_length_288_cov_2.945946_g2410_i0 PRJNA529924 2584 288 2.945946 8.48432448 Lottia gigantea 225164 Mollusca Mollusca 289 1.87e-73   NTclustered gi|676453046|ref|XM_009054981.1| 225164 g2410 i0 88.382 45.6840277777778 241 27 84 1 1 241 359 120 Lottia gigantea hypothetical protein mRNA blastn 13157 289 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea
4330205 4330205 PRJNA529924_P_NODE_3604_length_211_cov_1.615385_g3430_i0 PRJNA529924 3604 211 1.615385 3.40846235 Physella acuta 109671 Mollusca Mollusca 385 1.61e-102   NTclustered gi|2572452079|ref|XR_009385380.1| 109671 g3430 i0 99.526 97.9857819905213 211 1 100 0 1 211 841 1051 PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA blastn 20675 385 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
4330212 4330212 PRJNA529924_P_NODE_4884_length_156_cov_2.425197_g4710_i0 PRJNA529924 4884 156 2.425197 3.78330732 Physella acuta 109671 Mollusca Mollusca 237 3.31e-58   NTclustered gi|2572452079|ref|XR_009385380.1| 109671 g4710 i0 93.413 85.8782051282051 167 0 100 1 1 156 683 849 PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA blastn 13397 237 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
8770277 8770277 PRJNA529924_P_NODE_3407_length_221_cov_1.927083_g3233_i0 PRJNA529924 3407 221 1.927083 4.25885343 Metazoa 33208 Mollusca Mollusca 159 1.12e-34   NTclustered gi|2912449415|ref|XM_071275985.1| 6550 g3233 i0 80.374 6.14027149321267 214 38 96 4 10 221 652 863 PREDICTED: Mytilus edulis aconitate hydratase, mitochondrial-like (LOC139489502), mRNA blastn 1357 159 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus edulis
22179920 22179920 PRJNA529924_P_NODE_2478_length_297_cov_4.164179_g2304_i0 PRJNA529924 2478 297 4.164179 12.36761163 Patella vulgata 6465 Mollusca Mollusca 172 2.03e-38   NTclustered gi|2506339511|ref|XM_050561182.2| 6465 g2304 i0 90.299 42.7979797979798 134 10 44 1 1 131 1311 1444 PREDICTED: Patella vulgata tubulin alpha-2/alpha-4 chain (LOC126830781), mRNA blastn 12711 172 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Patellidae Patella Patella vulgata

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