RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1196438 · 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
5426874 5426874 PRJNA1196438_P_NODE_83045_length_227_cov_6.396104_g82618_i0 PRJNA1196438 83045 227 6.396104 14.51915608 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.02   NTclustered gi|2913001816|dbj|AP039609.1| 145626 g82618 i0 100 0.123348017621145 28 0 12 0 63 90 48008488 48008461 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
6700872 6700872 PRJNA1196438_P_NODE_3026_length_557_cov_1.723140_g2622_i0 PRJNA1196438 3026 557 1.72314 9.5978898 Ylistrum balloti 509963 Mollusca Mollusca 420 1.3099999999999998e-112   NTclustered gi|2592059858|ref|XM_060209328.1| 509963 g2622 i0 81.569 94.4398563734291 510 92 91 2 26 534 530 22 PREDICTED: Ylistrum balloti actin-2-like (LOC132545630), mRNA blastn 52603 420 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Ylistrum Ylistrum balloti
6701275 6701275 PRJNA1196438_P_NODE_62946_length_254_cov_1.585635_g62519_i0 PRJNA1196438 62946 254 1.585635 4.0275129 Haliotis rubra 36100 Mollusca Mollusca 91.6 4.89e-14   NTclustered gi|2194081198|ref|XR_006896929.1| 36100 g62519 i0 94.828 0.228346456692913 58 3 23 0 53 110 2786 2729 PREDICTED: Haliotis rubra uncharacterized LOC124271049 (LOC124271049), ncRNA blastn 58 91.6 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis rubra
18174499 18174499 PRJNA1196438_P_NODE_14835_length_312_cov_4.267782_g14409_i0 PRJNA1196438 14835 312 4.267782 13.31547984 Haliotis rufescens 6454 Mollusca Mollusca 52.8 0.029   NTclustered gi|2245624946|ref|XM_048386631.1| 6454 g14409 i0 96.774 0.496794871794872 31 1 10 0 25 55 10816 10846 PREDICTED: Haliotis rufescens RNA-binding protein 33-like (LOC124145510), transcript variant X1, mRNA blastn 155 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis rufescens
19449367 19449367 PRJNA1196438_P_NODE_58536_length_260_cov_2.336898_g58109_i0 PRJNA1196438 58536 260 2.336898 6.0759348 Pomacea canaliculata 400727 Mollusca Mollusca 54.7 0.007   NTclustered gi|1397648266|ref|XM_025224619.1| 400727 g58109 i0 96.97 3.75 33 0 13 1 188 220 881 912 PREDICTED: Pomacea canaliculata calumenin-like (LOC112556018), transcript variant X1, mRNA blastn 975 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Architaenioglossa Ampullariidae Pomacea Pomacea canaliculata
19449442 19449442 PRJNA1196438_P_NODE_6396_length_399_cov_2.251534_g5974_i0 PRJNA1196438 6396 399 2.251534 8.98362066 Mercenaria mercenaria 6596 Mollusca Mollusca 52.8 0.038   NTclustered gi|2442020962|ref|XM_053528760.1| 6596 g5974 i0 100 0.0701754385964912 28 0 7 0 97 124 1657 1684 PREDICTED: Mercenaria mercenaria uncharacterized LOC123539826 (LOC123539826), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Venerida Veneridae Mercenaria Mercenaria mercenaria
23275658 23275658 PRJNA1196438_P_NODE_6639_length_393_cov_3.021875_g6217_i0 PRJNA1196438 6639 393 3.021875 11.87596875 Mya arenaria 6604 Mollusca Mollusca 54.7 0.01   NTclustered gi|2427467042|ref|XM_052939866.1| 6604 g6217 i0 100 0.147582697201018 29 0 7 0 255 283 938 966 PREDICTED: Mya arenaria cell division control protein 42 homolog (LOC128228518), transcript variant X1, mRNA blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria

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