RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA600413 · 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
574678 574678 PRJNA600413_P_NODE_61961_length_192_cov_1.874126_g61260_i0 PRJNA600413 61961 192 1.874126 3.59832192 Octopus bimaculoides 37653 Mollusca Mollusca 54.7 0.005   NTclustered gi|2427295703|ref|XM_052977059.1| 37653 g61260 i0 100 0.604166666666667 29 0 15 0 96 124 12625 12597 PREDICTED: Octopus bimaculoides uncharacterized LOC106883967 (LOC106883967), transcript variant X4, mRNA blastn 116 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Cephalopoda Octopoda Octopodidae Octopus Octopus bimaculoides
1850917 1850917 PRJNA600413_P_NODE_83942_length_177_cov_1.593750_g83241_i0 PRJNA600413 83942 177 1.59375 2.8209375 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.015   NTclustered gi|2913000417|dbj|AP039607.1| 145626 g83241 i0 100 0.15819209039548 28 0 16 0 9 36 8953122 8953149 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
8226079 8226079 PRJNA600413_P_NODE_110707_length_166_cov_0.871795_g110006_i0 PRJNA600413 110707 166 0.871795 1.4471797 Cremnoconchus canaliculatus 2894313 Mollusca Mollusca 189 1.0199999999999999e-43   NTclustered gi|2136552443|gb|OL457881.1| 2894313 g110006 i0 99.048 60.210843373494 105 1 63 0 1 105 105 1 Cremnoconchus canaliculatus voucher ATREE Cre 18 small subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 9995 189 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Littorinimorpha Littorinidae Cremnoconchus Cremnoconchus canaliculatus
8228378 8228378 PRJNA600413_P_NODE_84827_length_177_cov_1.171875_g84126_i0 PRJNA600413 84827 177 1.171875 2.07421875 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.015   NTclustered gi|2913001816|dbj|AP039609.1| 145626 g84126 i0 100 0.15819209039548 28 0 16 0 40 67 16037287 16037314 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
8795415 8795415 PRJNA600413_P_NODE_8107_length_525_cov_1.485294_g7419_i0 PRJNA600413 8107 525 1.485294 7.7977935 Metazoa 33208 Mollusca Mollusca 54.7 0.014   NTclustered gi|2912987826|dbj|AP039592.1| 145626 g7419 i0 100 0.24952380952381 29 0 6 0 286 314 58341228 58341256 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence blastn 131 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
10777605 10777605 PRJNA600413_P_NODE_136489_length_162_cov_3.106195_g135788_i0 PRJNA600413 136489 162 3.106195 5.0320359 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.013   NTclustered gi|2913001816|dbj|AP039609.1| 145626 g135788 i0 100 0.172839506172839 28 0 17 0 128 155 23835268 23835295 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
10778118 10778118 PRJNA600413_P_NODE_23789_length_291_cov_4.793388_g23088_i0 PRJNA600413 23789 291 4.793388 13.94875908 Ruditapes philippinarum 129788 Mollusca Mollusca 52.8 0.027   NTclustered gi|2616658881|ref|XM_060747556.1| 129788 g23088 i0 100 0.0962199312714777 28 0 10 0 106 133 272 245 PREDICTED: Ruditapes philippinarum heat shock 70 kDa protein 12B-like (LOC132756477), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Bivalvia Venerida Veneridae Ruditapes Ruditapes philippinarum
10778170 10778170 PRJNA600413_P_NODE_25589_length_280_cov_2.627706_g24888_i0 PRJNA600413 25589 280 2.627706 7.3575768 Bradybaena similaris 145626 Mollusca Mollusca 202 2.42e-47   NTclustered gi|2912986657|dbj|AP039591.1| 145626 g24888 i0 80.769 5.56785714285714 260 48 93 2 1 259 47027857 47028115 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence blastn 1559 202 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
10778995 10778995 PRJNA600413_P_NODE_60089_length_194_cov_2.124138_g59388_i0 PRJNA600413 60089 194 2.124138 4.12082772 Bradybaena similaris 145626 Mollusca Mollusca 56.5 0.001   NTclustered gi|2912999222|dbj|AP039605.1| 145626 g59388 i0 90.698 2.14948453608247 43 3 22 1 58 100 54985097 54985138 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence blastn 417 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
15876285 15876285 PRJNA600413_P_NODE_151533_length_160_cov_2.666667_g150832_i0 PRJNA600413 151533 160 2.666667 4.2666672 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.004   NTclustered gi|2912999222|dbj|AP039605.1| 145626 g150832 i0 96.97 2.21875 33 0 20 1 42 73 27860414 27860446 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence blastn 355 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
19701357 19701357 PRJNA600413_P_NODE_63836_length_190_cov_2.617021_g63135_i0 PRJNA600413 63836 190 2.617021 4.9723399 Bradybaena similaris 145626 Mollusca Mollusca 56.5 0.001   NTclustered gi|2912992646|dbj|AP039597.1| 145626 g63135 i0 100 1.20526315789474 30 0 16 0 145 174 18625068 18625039 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence blastn 229 56.5 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
24800341 24800341 PRJNA600413_P_NODE_37060_length_236_cov_0.951872_g36359_i0 PRJNA600413 37060 236 0.951872 2.24641792 Biomphalaria glabrata 6526 Mollusca Mollusca 52.8 0.021   NTclustered gi|2502151953|ref|XM_056021743.1| 6526 g36359 i0 100 0.11864406779661 28 0 12 0 127 154 2522 2549 PREDICTED: Biomphalaria glabrata rhodopsin-like (LOC106062946), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda   Planorbidae Biomphalaria Biomphalaria glabrata
24800549 24800549 PRJNA600413_P_NODE_45360_length_217_cov_1.214286_g44659_i0 PRJNA600413 45360 217 1.214286 2.63500062 Bradybaena similaris 145626 Mollusca Mollusca 54.7 0.005   NTclustered gi|2912999222|dbj|AP039605.1| 145626 g44659 i0 100 0.133640552995392 29 0 13 0 169 197 34228974 34229002 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Mollusca Gastropoda Stylommatophora Camaenidae Bradybaena Bradybaena similaris
24801027 24801027 PRJNA600413_P_NODE_65260_length_189_cov_2.707143_g64559_i0 PRJNA600413 65260 189 2.707143 5.11650027 Bradybaena similaris 145626 Mollusca Mollusca 52.8 0.016   NTclustered gi|2912983111|dbj|AP039588.1| 145626 g64559 i0 100 0.296296296296296 28 0 15 0 151 178 75630753 75630780 Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence blastn 56 52.8 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);;