RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA453111 · 4 ✖

analysis 1

  • blastn · 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
4268513 4268513 PRJNA453111_P_NODE_8364_length_279_cov_1.951456_g8272_i0 PRJNA453111 8364 279 1.951456 5.44456224 Mytilus edulis 6550 Mollusca Mollusca 200 8.67e-47   NTclustered gi|2912449752|ref|XM_071276167.1| 6550 g8272 i0 80.608 5.73835125448029 263 48 94 3 1 261 400 661 PREDICTED: Mytilus edulis small ribosomal subunit protein uS4 (LOC139489589), mRNA blastn 1601 200 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus edulis
11920195 11920195 PRJNA453111_P_NODE_2330_length_539_cov_1.487124_g2238_i0 PRJNA453111 2330 539 1.487124 8.01559836 Mytilus trossulus 6551 Mollusca Mollusca 497 5.66e-136   NTclustered gi|2694002732|ref|XM_063566204.1| 6551 g2238 i0 83.333 100.73840445269 540 88 100 2 1 539 1169 631 PREDICTED: Mytilus trossulus tubulin alpha-1A chain (LOC134706872), mRNA blastn 54298 497 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus trossulus
19567195 19567195 PRJNA453111_P_NODE_11976_length_245_cov_0.895349_g11884_i0 PRJNA453111 11976 245 0.895349 2.19360505 Gigantopelta aegis 1735272 Mollusca Mollusca 52.8 0.022   NTclustered gi|2034326628|ref|XM_041505288.1| 1735272 g11884 i0 100 0.114285714285714 28 0 11 0 104 131 5799 5772 PREDICTED: Gigantopelta aegis uncharacterized LOC121377339 (LOC121377339), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Neomphalida Peltospiridae Gigantopelta Gigantopelta aegis
19567245 19567245 PRJNA453111_P_NODE_6176_length_325_cov_2.841270_g6084_i0 PRJNA453111 6176 325 2.84127 9.2341275 Littorina saxatilis 31220 Mollusca Mollusca 215 3.68e-51   NTclustered gi|2868633896|ref|XM_070320054.1| 31220 g6084 i0 81.041 41.5446153846154 269 51 83 0 1 269 539 807 PREDICTED: Littorina saxatilis small ribosomal subunit protein uS7-like (LOC138948500), mRNA blastn 13502 215 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis

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