RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA293022" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA293022 · 14 ✖

analysis 1

  • blastn · 14 ✖
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
1647915 1647915 PRJNA293022_P_NODE_1342_length_1087_cov_4.688825_g1002_i0 PRJNA293022 1342 1087 4.688825 50.96752775 Gigantopelta aegis 1735272 Mollusca Mollusca 63.9 5.11e-5   NTclustered gi|2034306571|ref|XM_041494631.1| 1735272 g1002 i0 95 0.263109475620975 40 2 4 0 1048 1087 2453 2492 PREDICTED: Gigantopelta aegis glycosyltransferase family 92 protein F13G3.3-like (LOC121369521), mRNA blastn 286 63.9 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Neomphalida Peltospiridae Gigantopelta Gigantopelta aegis
2334901 2334901 PRJNA293022_P_NODE_16702_length_349_cov_2.283333_g15965_i0 PRJNA293022 16702 349 2.283333 7.96883217 Metazoa 33208 Mollusca Mollusca 52.8 0.033   NTclustered gi|2427390617|ref|XM_052917999.1| 6604 g15965 i0 100 1.59885386819484 28 0 8 0 247 274 5153 5126 PREDICTED: Mya arenaria protein mono-ADP-ribosyltransferase PARP14-like (LOC128212513), mRNA blastn 558 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Myida Myidae Mya Mya arenaria
4200579 4200579 PRJNA293022_P_NODE_71344_length_166_cov_6.017094_g70607_i0 PRJNA293022 71344 166 6.017094 9.98837604 Bradybaena similaris 145626 Mollusca Mollusca 71.3 3.84e-8   NTclustered gi|2912997258|dbj|AP039602.1| 145626 g70607 i0 79.798 9.59036144578313 99 19 60 1 52 150 1526015 1526112 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence blastn 1592 71.3 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
6750867 6750867 PRJNA293022_P_NODE_17946_length_337_cov_2.760417_g17209_i0 PRJNA293022 17946 337 2.760417 9.30260529 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.032   NTclustered gi|2912999747|dbj|AP039606.1| 145626 g17209 i0 100 0.0830860534124629 28 0 8 0 89 116 2800657 2800684 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
10577288 10577288 PRJNA293022_P_NODE_55309_length_187_cov_2.079710_g54572_i0 PRJNA293022 55309 187 2.07971 3.8890577 Bradybaena similaris 145626 Mollusca Mollusca 73.1 1.23e-8   NTclustered gi|2912989933|dbj|AP039594.1| 145626 g54572 i0 92.157 26.7272727272727 51 4 27 0 137 187 40994331 40994381 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence blastn 4998 73.1 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
11851926 11851926 PRJNA293022_P_NODE_36150_length_232_cov_3.191257_g35413_i0 PRJNA293022 36150 232 3.191257 7.40371624 Aplysia californica 6500 Mollusca Mollusca 52.8 0.021   NTclustered gi|1897936549|ref|XM_005106389.3| 6500 g35413 i0 100 0.120689655172414 28 0 12 0 23 50 3646 3673 PREDICTED: Aplysia californica RRP12-like protein (LOC101856684), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Aplysiida Aplysiidae Aplysia Aplysia californica
16950700 16950700 PRJNA293022_P_NODE_45734_length_206_cov_2.337580_g44997_i0 PRJNA293022 45734 206 2.33758 4.8154148 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.005   NTclustered gi|2912988862|dbj|AP039593.1| 145626 g44997 i0 100 0.140776699029126 29 0 14 0 172 200 34542891 34542863 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
16950856 16950856 PRJNA293022_P_NODE_78594_length_162_cov_1.486726_g77857_i0 PRJNA293022 78594 162 1.486726 2.40849612 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.004   NTclustered gi|2912987826|dbj|AP039592.1| 145626 g77857 i0 100 0.358024691358025 29 0 18 0 110 138 12703195 12703167 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
18225008 18225008 PRJNA293022_P_NODE_50655_length_196_cov_1.000000_g49918_i0 PRJNA293022 50655 196 1 1.96 Bradybaena similaris 145626 Mollusca Mollusca 80.5 7.78e-11   NTclustered gi|2912984370|dbj|AP039589.1| 145626 g49918 i0 84.146 4.04591836734694 82 13 42 0 83 164 74259630 74259711 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 8, sequence blastn 793 80.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
19499173 19499173 PRJNA293022_P_NODE_35836_length_233_cov_3.347826_g35099_i0 PRJNA293022 35836 233 3.347826 7.80043458 Bradybaena similaris 145626 Mollusca Mollusca 71.3 5.76e-8   NTclustered gi|2912999747|dbj|AP039606.1| 145626 g35099 i0 77.099 2.4206008583691 131 25 55 5 104 232 52173515 52173388 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence blastn 564 71.3 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
20774780 20774780 PRJNA293022_P_NODE_44737_length_208_cov_5.119497_g44000_i0 PRJNA293022 44737 208 5.119497 10.64855376 Bradybaena similaris 145626 Mollusca Mollusca 63.9 8.42e-6   NTclustered gi|2912990805|dbj|AP039595.1| 145626 g44000 i0 100 16.4759615384615 34 0 21 0 58 91 25479221 25479254 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence blastn 3427 63.9 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
22049673 22049673 PRJNA293022_P_NODE_31058_length_251_cov_4.410891_g30321_i0 PRJNA293022 31058 251 4.410891 11.07133641 Bradybaena similaris 145626 Mollusca Mollusca 104 6.19e-18   NTclustered gi|2912992646|dbj|AP039597.1| 145626 g30321 i0 74.79 11.199203187251 238 56 94 4 14 250 2531839 2531605 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence blastn 2811 104 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
23325377 23325377 PRJNA293022_P_NODE_54959_length_188_cov_1.345324_g54222_i0 PRJNA293022 54959 188 1.345324 2.52920912 Bradybaena similaris 145626 Mollusca Mollusca 67.6 5.75e-7   NTclustered gi|2912989933|dbj|AP039594.1| 145626 g54222 i0 93.478 43.9521276595745 46 1 29 1 3 48 38292041 38292084 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence blastn 8263 67.6 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
24599287 24599287 PRJNA293022_P_NODE_18220_length_334_cov_3.368421_g17483_i0 PRJNA293022 18220 334 3.368421 11.25052614 Bradybaena similaris 145626 Mollusca Mollusca 62.1 5.23e-5   NTclustered gi|2912990805|dbj|AP039595.1| 145626 g17483 i0 77.57 0.82934131736527 107 21 31 2 119 223 8051560 8051665 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence blastn 277 62.1 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris

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