RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "blastn", bioproject = "PRJNA689790" and tax_phylum = "Mollusca"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Mollusca · 16 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA689790 · 16 ✖

analysis 1

  • blastn · 16 ✖
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
668749 668749 PRJNA689790_S_NODE_4181_length_298_cov_2.735632_g4066_i0 PRJNA689790 4181 298 2.735632 8.15218336 Mytilus californianus 6549 Mollusca Mollusca 54.7 0.008   NTclustered gi|2334713181|ref|XM_052245670.1| 6549 g4066 i0 100 0.0973154362416107 29 0 10 0 188 216 7374 7402 PREDICTED: Mytilus californianus protrudin-like (LOC127735490), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus californianus
3219622 3219622 PRJNA689790_S_NODE_6583_length_232_cov_3.174359_g6468_i0 PRJNA689790 6583 232 3.174359 7.36451288 Ctena cf. galapagana NHMUK 20210086 2892552 Mollusca Mollusca 134 7.2e-27   NTclustered gi|2129023951|gb|OL361786.1| 2892552 g6468 i0 91.667 8.03879310344828 96 8 41 0 132 227 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 1865 134 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Lucinida Lucinidae Ctena Ctena cf. galapagana NHMUK 20210086
5006457 5006457 PRJNA689790_S_NODE_16684_length_151_cov_0.894737_g16569_i0 PRJNA689790 16684 151 0.894737 1.35105287 Metazoa 33208 Mollusca Mollusca 56.5 0.001   NTclustered gi|2572366619|ref|XM_059308391.1| 109671 g16569 i0 100 11.3377483443709 30 0 20 0 13 42 1245 1274 PREDICTED: Physella acuta uncharacterized LOC131947244 (LOC131947244), mRNA blastn 1712 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Physidae Physella Physella acuta
6282122 6282122 PRJNA689790_S_NODE_12825_length_167_cov_2.361538_g12710_i0 PRJNA689790 12825 167 2.361538 3.94376846 root 1 Root_unresolved Root_unresolved 54.7 0.004   NTclustered gi|1207976027|ref|XM_021523252.1| 6573 g12710 i0 94.444 8.26347305389222 36 1 22 1 9 44 1352 1386 PREDICTED: Mizuhopecten yessoensis polypyrimidine tract-binding protein 1-like (LOC110466629), transcript variant X12, mRNA blastn 1380 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Mizuhopecten Mizuhopecten yessoensis
8321831 8321831 PRJNA689790_S_NODE_11607_length_175_cov_1.108696_g11492_i0 PRJNA689790 11607 175 1.108696 1.940218 Lottia gigantea 225164 Mollusca Mollusca 159 8.44e-35   NTclustered gi|676493537|ref|XM_009068023.1| 225164 g11492 i0 83.237 6.07428571428571 173 29 99 0 1 173 417 589 Lottia gigantea hypothetical protein mRNA blastn 1063 159 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Lottiidae Lottia Lottia gigantea
8321899 8321899 PRJNA689790_S_NODE_8167_length_207_cov_1.088235_g8052_i0 PRJNA689790 8167 207 1.088235 2.25264645 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.005   NTclustered gi|2912995509|dbj|AP039600.1| 145626 g8052 i0 100 1.91304347826087 29 0 14 0 154 182 5785038 5785066 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence blastn 396 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
8831100 8831100 PRJNA689790_S_NODE_7907_length_210_cov_1.820809_g7792_i0 PRJNA689790 7907 210 1.820809 3.8236989 Metazoa 33208 Mollusca Mollusca 283 6e-72   NTclustered gi|1835468114|ref|XM_033906027.1| 6579 g7792 i0 90.952 98.4571428571429 210 19 100 0 1 210 1233 1024 PREDICTED: Pecten maximus tubulin alpha-1A chain-like (LOC117343596), mRNA blastn 20676 283 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Pecten Pecten maximus
9597287 9597287 PRJNA689790_S_NODE_4928_length_272_cov_2.310638_g4813_i0 PRJNA689790 4928 272 2.310638 6.28493536 Littorina saxatilis 31220 Mollusca Mollusca 315 2.88e-81   NTclustered gi|2868673156|ref|XM_070345742.1| 31220 g4813 i0 88.462 98.0404411764706 260 30 96 0 13 272 2536 2795 PREDICTED: Littorina saxatilis sodium/potassium-transporting ATPase subunit alpha-like (LOC138973083), mRNA blastn 26667 315 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Littorina Littorina saxatilis
13422628 13422628 PRJNA689790_S_NODE_2931_length_368_cov_147.731118_g2816_i0 PRJNA689790 2931 368 147.731118 543.65051424 Gigantopelta aegis 1735272 Mollusca Mollusca 102 3.42e-17   NTclustered gi|2034271035|ref|XR_005960499.1| 1735272 g2816 i0 78.363 7.14945652173913 171 27 46 8 1 168 3523 3686 PREDICTED: Gigantopelta aegis large subunit ribosomal RNA (LOC121392465), rRNA blastn 2631 102 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Neomphalida Peltospiridae Gigantopelta Gigantopelta aegis
13422656 13422656 PRJNA689790_S_NODE_771_length_766_cov_5.027435_g697_i0 PRJNA689790 771 766 5.027435 38.5101521 Mya arenaria 6604 Mollusca Mollusca 54.7 0.021   NTclustered gi|2427467042|ref|XM_052939866.1| 6604 g697 i0 100 0.0757180156657963 29 0 4 0 149 177 966 938 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
14697692 14697692 PRJNA689790_S_NODE_5832_length_248_cov_1.805687_g5717_i0 PRJNA689790 5832 248 1.805687 4.47810376 Magallana angulata 2784310 Mollusca Mollusca 340 4.27e-89   NTclustered gi|2416973853|ref|XM_052826409.1| 2784310 g5717 i0 91.803 98.991935483871 244 20 98 0 5 248 447 204 PREDICTED: Crassostrea angulata tubulin alpha-1A chain (LOC128162967), mRNA blastn 24550 340 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Magallana Magallana angulata
19795694 19795694 PRJNA689790_S_NODE_8676_length_200_cov_3.018405_g8561_i0 PRJNA689790 8676 200 3.018405 6.03681 Biomphalaria glabrata 6526 Mollusca Mollusca 73.1 1.33e-8   NTclustered gi|256014578|gb|AC235814.4| 6526 g8561 i0 89.474 0.855 57 6 29 0 1 57 23551 23495 Biomphalaria glabrata BAC clone BG_BBa-11C17 from chromosome unknown, complete sequence blastn 171 73.1 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Planorbidae Biomphalaria Biomphalaria glabrata
22346116 22346116 PRJNA689790_S_NODE_5678_length_251_cov_2.640187_g5563_i0 PRJNA689790 5678 251 2.640187 6.62686937 Haliotis rufescens 6454 Mollusca Mollusca 224 4.5599999999999996e-54   NTclustered gi|2187522883|ref|XM_046511445.1| 6454 g5563 i0 82.869 85.1354581673307 251 41 99 2 1 250 344 95 PREDICTED: Haliotis rufescens tubulin beta chain-like (LOC124142786), mRNA blastn 21369 224 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Lepetellida Haliotidae Haliotis Haliotis rufescens
23621642 23621642 PRJNA689790_S_NODE_9079_length_196_cov_2.742138_g8964_i0 PRJNA689790 9079 196 2.742138 5.37459048 Ylistrum balloti 509963 Mollusca Mollusca 126 9.85e-25   NTclustered gi|2592057441|ref|XM_060208008.1| 509963 g8964 i0 85.366 21.3826530612245 123 17 62 1 1 122 673 795 PREDICTED: Ylistrum balloti large ribosomal subunit protein uL2-like (LOC132544417), mRNA blastn 4191 126 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Pectinida Pectinidae Ylistrum Ylistrum balloti
24894940 24894940 PRJNA689790_S_NODE_3900_length_311_cov_5.310219_g3785_i0 PRJNA689790 3900 311 5.310219 16.51478109 Saccostrea cuccullata 36930 Mollusca Mollusca 113 1.31e-20   NTclustered gi|2669038676|ref|XM_062744390.1| 36930 g3785 i0 87.755 17.903536977492 98 11 32 1 1 98 1420 1516 PREDICTED: Saccostrea cucullata tubulin alpha-1A chain (LOC134262006), mRNA blastn 5568 113 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Ostreida Ostreidae Saccostrea Saccostrea cuccullata
24894975 24894975 PRJNA689790_S_NODE_7900_length_210_cov_2.242775_g7785_i0 PRJNA689790 7900 210 2.242775 4.7098275 Mytilus trossulus 6551 Mollusca Mollusca 196 8.049999999999999e-46   NTclustered gi|2693941616|ref|XM_063558252.1| 6551 g7785 i0 91.034 68.5047619047619 145 13 69 0 66 210 1459 1315 PREDICTED: Mytilus trossulus tubulin beta-4B chain-like (LOC134696439), mRNA blastn 14386 196 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Mytilida Mytilidae Mytilus Mytilus trossulus

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