RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1196384 · 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
2873458 2873458 PRJNA1196384_S_NODE_3663_length_206_cov_2.065089_g3599_i0 PRJNA1196384 3663 206 2.065089 4.25408334 Mercenaria mercenaria 6596 Mollusca Mollusca 111 2.93e-20   NTclustered gi|2160869370|ref|XM_045311120.1| 6596 g3599 i0 91.358 3.98058252427184 81 7 39 0 7 87 291 371 PREDICTED: Mercenaria mercenaria FAU ubiquitin-like and ribosomal protein S30 (LOC123530348), transcript variant X1, mRNA blastn 820 111 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Venerida Veneridae Mercenaria Mercenaria mercenaria
2873533 2873533 PRJNA1196384_S_NODE_8083_length_152_cov_3.608696_g8019_i0 PRJNA1196384 8083 152 3.608696 5.48521792 Littorina saxatilis 31220 Mollusca Mollusca 158 2.56e-34   NTclustered gi|2868618654|ref|XM_070344692.1| 31220 g8019 i0 85.526 9.78947368421053 152 20 99 2 1 151 188 338 PREDICTED: Littorina saxatilis small ribosomal subunit protein uS15 (LOC138971860), mRNA blastn 1488 158 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis
11801290 11801290 PRJNA1196384_S_NODE_790_length_432_cov_4.405063_g726_i0 PRJNA1196384 790 432 4.405063 19.02987216 Biomphalaria glabrata 6526 Mollusca Mollusca 206 3.02e-48   NTclustered gi|2502173393|ref|XM_056030510.1| 6526 g726 i0 78.616 5.0787037037037 318 62 73 5 111 425 517 203 PREDICTED: Biomphalaria glabrata 40S ribosomal protein S20-like (LOC106075322), mRNA blastn 2194 206 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Planorbidae Biomphalaria Biomphalaria glabrata
16345662 16345662 PRJNA1196384_S_NODE_3073_length_222_cov_1.248649_g3009_i0 PRJNA1196384 3073 222 1.248649 2.77200078 Metazoa 33208 Mollusca Mollusca 409 1.0100000000000001e-109   NTclustered gi|1928112764|gb|MT947788.1| 6523 g3009 i0 100 99.4324324324324 221 0 99 0 2 222 457 237 Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds blastn 22074 409 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lymnaeidae Lymnaea Lymnaea stagnalis

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