RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJDB14274" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJDB14274 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
11486476 11486476 PRJDB14274_S_NODE_9270_length_209_cov_1.256757_g9192_i0 PRJDB14274 9270 209 1.256757 2.62662213 Mya arenaria 6604 Mollusca Mollusca 121 4.949999999999999e-23   NTclustered gi|2427374343|ref|XM_052912808.1| 6604 g9192 i0 81.046 2.92822966507177 153 27 73 2 37 188 11250 11401 PREDICTED: Mya arenaria cytoplasmic dynein 1 heavy chain 1-like (LOC128209011), mRNA blastn 612 121 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
12762067 12762067 PRJDB14274_S_NODE_1931_length_437_cov_5.523936_g1853_i0 PRJDB14274 1931 437 5.523936 24.13960032 Littorina saxatilis 31220 Mollusca Mollusca 268 3.849999999999999e-67   NTclustered gi|2868636719|ref|XM_070321030.1| 31220 g1853 i0 79.082 44.7299771167048 392 81 90 1 1 392 313 703 PREDICTED: Littorina saxatilis small ribosomal subunit protein uS7 (LOC138949251), mRNA blastn 19547 268 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis
20409163 20409163 PRJDB14274_S_NODE_2757_length_368_cov_5.449511_g2679_i0 PRJDB14274 2757 368 5.449511 20.05420048 Mya arenaria 6604 Mollusca Mollusca 189 2.55e-43   NTclustered gi|2427451705|ref|XM_052935167.1| 6604 g2679 i0 79.273 7.73097826086957 275 53 74 4 94 366 157 429 PREDICTED: Mya arenaria 40S ribosomal protein S2 (LOC128225132), mRNA blastn 2845 189 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
21383122 21383122 PRJDB14274_S_NODE_1877_length_443_cov_2.342932_g1799_i0 PRJDB14274 1877 443 2.342932 10.37918876 Metazoa 33208 Mollusca Mollusca 178 6.78e-40   NTclustered gi|2868663362|ref|XM_070355825.1| 31220 g1799 i0 87.582 27.9751693002257 153 19 35 0 291 443 1499 1347 PREDICTED: Littorina saxatilis tubulin alpha-1 chain-like (LOC138982521), transcript variant X1, mRNA blastn 12393 178 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis
21685145 21685145 PRJDB14274_S_NODE_6698_length_244_cov_1.836066_g6620_i0 PRJDB14274 6698 244 1.836066 4.48000104 Littorina saxatilis 31220 Mollusca Mollusca 156 1.63e-33   NTclustered gi|2868678165|ref|XM_070323641.1| 31220 g6620 i0 78.814 91.0860655737705 236 46 96 4 11 244 1669 1436 PREDICTED: Littorina saxatilis spectrin beta chain-like (LOC138952069), transcript variant X1, mRNA blastn 22225 156 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis
22960476 22960476 PRJDB14274_S_NODE_1899_length_441_cov_9.715789_g1821_i0 PRJDB14274 1899 441 9.715789 42.84662949 Mollusca environmental sample 653389 Mollusca Mollusca 326 2.28e-84   NTclustered gi|156254524|gb|EF528299.1| 653389 g1821 i0 81.264 54.6780045351474 443 48 100 20 1 441 991 582 Uncultured mollusc isolate XenLSU7 28S ribosomal RNA gene, partial sequence blastn 24113 326 1 Eukaryota Opisthokonta Metazoa Mollusca         Mollusca environmental sample

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