RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA315314" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 8 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA315314 · 8 ✖

analysis 1

  • blastn · 8 ✖
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
5484504 5484504 PRJNA315314_S_NODE_5185_length_352_cov_121.284830_g4864_i0 PRJNA315314 5185 352 121.28483 426.9226016 Physella acuta 109671 Mollusca Mollusca 636 7.219999999999999e-178   NTclustered gi|2572452079|ref|XR_009385380.1| 109671 g4864 i0 99.712 75.9261363636364 347 1 99 0 5 351 10 356 PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA blastn 26726 636 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
9309126 9309126 PRJNA315314_S_NODE_908_length_804_cov_105.771613_g714_i0 PRJNA315314 908 804 105.771613 850.40376852 Physella acuta 109671 Mollusca Mollusca 1423 0   NTclustered gi|2572452079|ref|XR_009385380.1| 109671 g714 i0 99.363 92.2599502487562 785 5 98 0 2 786 363 1147 PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA blastn 74177 1423 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
13134542 13134542 PRJNA315314_S_NODE_22211_length_176_cov_3.680272_g21890_i0 PRJNA315314 22211 176 3.680272 6.47727872 Bradybaena similaris 145626 Mollusca Mollusca 58.4 3.19e-4   NTclustered gi|2912983111|dbj|AP039588.1| 145626 g21890 i0 90.698 0.244318181818182 43 4 24 0 37 79 53618218 53618260 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence blastn 43 58.4 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
14409532 14409532 PRJNA315314_S_NODE_12232_length_232_cov_5.605911_g11911_i0 PRJNA315314 12232 232 5.605911 13.00571352 Ctena cf. galapagana NHMUK 20210086 2892552 Mollusca Mollusca 134 7.2e-27   NTclustered gi|2129023951|gb|OL361786.1| 2892552 g11911 i0 91.667 9.08189655172414 96 8 41 0 133 228 4053 4148 Ctena cf. galapagana NHMUK 20210086 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 2107 134 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Lucinida Lucinidae Ctena Ctena cf. galapagana NHMUK 20210086
15683328 15683328 PRJNA315314_S_NODE_13613_length_221_cov_3.760417_g13292_i0 PRJNA315314 13613 221 3.760417 8.31052157 Ctena cf. galapagana NHMUK 20210086 2892552 Mollusca Mollusca 134 6.800000000000001e-27   NTclustered gi|2129023951|gb|OL361786.1| 2892552 g13292 i0 91.667 8.47058823529412 96 8 43 0 122 217 4053 4148 Ctena cf. galapagana NHMUK 20210086 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 1872 134 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Lucinida Lucinidae Ctena Ctena cf. galapagana NHMUK 20210086
16958451 16958451 PRJNA315314_S_NODE_6894_length_308_cov_3.652330_g6573_i0 PRJNA315314 6894 308 3.65233 11.2491764 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.029   NTclustered gi|2912997258|dbj|AP039602.1| 145626 g6573 i0 100 0.0909090909090909 28 0 9 0 174 201 14165358 14165331 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
16958456 16958456 PRJNA315314_S_NODE_7054_length_304_cov_5.989091_g6733_i0 PRJNA315314 7054 304 5.989091 18.20683664 Bradybaena similaris 145626 Mollusca Mollusca 60.2 1.69e-4   NTclustered gi|2912991694|dbj|AP039596.1| 145626 g6733 i0 100 0.210526315789474 32 0 11 0 189 220 60683806 60683837 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence blastn 64 60.2 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
22057215 22057215 PRJNA315314_S_NODE_16398_length_202_cov_24.115607_g16077_i0 PRJNA315314 16398 202 24.115607 48.71352614 Physella acuta 109671 Mollusca Mollusca 289 1.23e-73   NTclustered gi|2572452079|ref|XR_009385380.1| 109671 g16077 i0 92.929 61.0346534653465 198 14 98 0 1 198 207 10 PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA blastn 12329 289 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta

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