contig_metadata
25 rows where analysis = "blastn", bioproject = "PRJNA1122875" and tax_phylum = "Mollusca"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 278027 | 278027 | PRJNA1122875_P_NODE_9401_length_537_cov_2.398707_g9182_i0 | PRJNA1122875 | 9401 | 537 | 2.398707 | 12.88105659 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 65.8 | 6.78e-6 | NTclustered | gi|2913001816|dbj|AP039609.1| | 145626 | g9182 | i0 | 97.368 | 0.337057728119181 | 38 | 1 | 7 | 0 | 295 | 332 | 32069438 | 32069475 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence | blastn | 181 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 1028744 | 1028744 | PRJNA1122875_P_NODE_30301_length_297_cov_1.741071_g30077_i0 | PRJNA1122875 | 30301 | 297 | 1.741071 | 5.17098087 | Opisthokonta | 33154 | Mollusca | Mollusca | 52.8 | 0.028 | NTclustered | gi|2334716057|ref|XR_007998680.1| | 6549 | g30077 | i0 | 100 | 0.942760942760943 | 28 | 0 | 9 | 0 | 193 | 220 | 99 | 72 | PREDICTED: Mytilus californianus keratin-associated protein 19-2-like (LOC127735973), transcript variant X6, misc_RNA | blastn | 280 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 1552072 | 1552072 | PRJNA1122875_P_NODE_18882_length_384_cov_1.405145_g18658_i0 | PRJNA1122875 | 18882 | 384 | 1.405145 | 5.3957568 | Lottia gigantea | 225164 | Mollusca | Mollusca | 276 | 2e-69 | NTclustered | gi|676489286|ref|XM_009066636.1| | 225164 | g18658 | i0 | 83.838 | 66.6979166666667 | 297 | 40 | 77 | 6 | 89 | 384 | 1460 | 1171 | Lottia gigantea hypothetical protein mRNA | blastn | 25612 | 276 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 1552548 | 1552548 | PRJNA1122875_P_NODE_7122_length_603_cov_3.279245_g6905_i0 | PRJNA1122875 | 7122 | 603 | 3.279245 | 19.77384735 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 60.2 | 3.57e-4 | NTclustered | gi|2912983111|dbj|AP039588.1| | 145626 | g6905 | i0 | 90.909 | 0.0729684908789386 | 44 | 4 | 7 | 0 | 183 | 226 | 3620068 | 3620111 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence | blastn | 44 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 2304148 | 2304148 | PRJNA1122875_P_NODE_7342_length_596_cov_1.810707_g7125_i0 | PRJNA1122875 | 7342 | 596 | 1.810707 | 10.79181372 | Opisthokonta | 33154 | Mollusca | Mollusca | 56.5 | 0.005 | NTclustered | gi|2913001038|dbj|AP039608.1| | 145626 | g7125 | i0 | 89.13 | 0.189597315436242 | 46 | 4 | 8 | 1 | 85 | 130 | 40441276 | 40441232 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 27, sequence | blastn | 113 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 2828444 | 2828444 | PRJNA1122875_P_NODE_42263_length_253_cov_2.194444_g42039_i0 | PRJNA1122875 | 42263 | 253 | 2.194444 | 5.55194332 | Ambigolimax valentianus | 1338344 | Mollusca | Mollusca | 60.2 | 1.37e-4 | NTclustered | gi|1751370056|dbj|LC498985.1| | 1338344 | g42039 | i0 | 88.462 | 0.205533596837945 | 52 | 2 | 20 | 4 | 114 | 163 | 3590 | 3639 | Ambigolimax valentianus mRNA for enterin precursor, complete cds | blastn | 52 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Limacidae | Ambigolimax | Ambigolimax valentianus | |
| 4104940 | 4104940 | PRJNA1122875_P_NODE_49744_length_245_cov_0.895349_g49520_i0 | PRJNA1122875 | 49744 | 245 | 0.895349 | 2.19360505 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912996298|dbj|AP039601.1| | 145626 | g49520 | i0 | 87.755 | 0.371428571428571 | 49 | 4 | 19 | 2 | 60 | 106 | 39706816 | 39706768 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 20, sequence | blastn | 91 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 5380661 | 5380661 | PRJNA1122875_P_NODE_21245_length_361_cov_0.788194_g21021_i0 | PRJNA1122875 | 21245 | 361 | 0.788194 | 2.84538034 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.003 | NTclustered | gi|2912994531|dbj|AP039599.1| | 145626 | g21021 | i0 | 100 | 0.337950138504155 | 30 | 0 | 8 | 0 | 70 | 99 | 48365137 | 48365108 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 18, sequence | blastn | 122 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 6655578 | 6655578 | PRJNA1122875_P_NODE_40726_length_259_cov_1.887097_g40502_i0 | PRJNA1122875 | 40726 | 259 | 1.887097 | 4.88758123 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912998575|dbj|AP039604.1| | 145626 | g40502 | i0 | 96.97 | 0.482625482625483 | 33 | 1 | 13 | 0 | 177 | 209 | 12326307 | 12326339 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 23, sequence | blastn | 125 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 6655837 | 6655837 | PRJNA1122875_P_NODE_8986_length_549_cov_4.735294_g8767_i0 | PRJNA1122875 | 8986 | 549 | 4.735294 | 25.99676406 | Saccostrea echinata | 191078 | Mollusca | Mollusca | 254 | 1.38e-62 | NTclustered | gi|2628507157|ref|XM_061331423.1| | 191078 | g8767 | i0 | 81.908 | 22.6593806921676 | 304 | 51 | 55 | 4 | 96 | 397 | 512 | 211 | PREDICTED: Saccostrea echinata small ribosomal subunit protein uS12 (LOC133195548), mRNA | blastn | 12440 | 254 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 9205863 | 9205863 | PRJNA1122875_P_NODE_51088_length_243_cov_2.088235_g50864_i0 | PRJNA1122875 | 51088 | 243 | 2.088235 | 5.07441105 | Purpuradusta gracilis | 218390 | Mollusca | Mollusca | 100 | 7.71e-17 | NTclustered | gi|2459373550|ref|NC_072228.1| | 218390 | g50864 | i0 | 93.939 | 27.8971193415638 | 66 | 4 | 27 | 0 | 1 | 66 | 11656 | 11721 | Purpuradusta gracilis mitochondrion, complete genome | blastn | 6779 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Cypraeidae | Purpuradusta | Purpuradusta gracilis | |
| 13031068 | 13031068 | PRJNA1122875_P_NODE_10831_length_504_cov_3.524362_g10610_i0 | PRJNA1122875 | 10831 | 504 | 3.524362 | 17.76278448 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 63.9 | 2.28e-5 | NTclustered | gi|2912988862|dbj|AP039593.1| | 145626 | g10610 | i0 | 97.297 | 0.240079365079365 | 37 | 1 | 7 | 0 | 213 | 249 | 49193876 | 49193840 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence | blastn | 121 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 13031180 | 13031180 | PRJNA1122875_P_NODE_19271_length_380_cov_1.205212_g19047_i0 | PRJNA1122875 | 19271 | 380 | 1.205212 | 4.5798056 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 54.7 | 0.01 | NTclustered | gi|2427287125|ref|XM_052975855.1| | 37653 | g19047 | i0 | 100 | 0.0763157894736842 | 29 | 0 | 8 | 0 | 36 | 64 | 147 | 119 | PREDICTED: Octopus bimaculoides uncharacterized LOC106869634 (LOC106869634), transcript variant X2, mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 14306420 | 14306420 | PRJNA1122875_P_NODE_23272_length_345_cov_1.981618_g23048_i0 | PRJNA1122875 | 23272 | 345 | 1.981618 | 6.8365821 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 7.02e-4 | NTclustered | gi|2912983111|dbj|AP039588.1| | 145626 | g23048 | i0 | 97.059 | 0.368115942028986 | 34 | 1 | 10 | 0 | 277 | 310 | 87240492 | 87240459 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence | blastn | 127 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 15580325 | 15580325 | PRJNA1122875_P_NODE_17853_length_395_cov_1.630435_g17629_i0 | PRJNA1122875 | 17853 | 395 | 1.630435 | 6.44021825 | Ylistrum balloti | 509963 | Mollusca | Mollusca | 387 | 9.12e-103 | NTclustered | gi|2592096127|ref|XM_060229070.1| | 509963 | g17629 | i0 | 84.343 | 98.6 | 396 | 60 | 100 | 2 | 1 | 395 | 1348 | 954 | PREDICTED: Ylistrum balloti tubulin alpha chain, testis-specific (LOC132564419), mRNA | blastn | 38947 | 387 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 15580642 | 15580642 | PRJNA1122875_P_NODE_45153_length_249_cov_0.875000_g44929_i0 | PRJNA1122875 | 45153 | 249 | 0.875 | 2.17875 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 52.8 | 0.023 | NTclustered | gi|2502171040|ref|XM_056029593.1| | 6526 | g44929 | i0 | 100 | 0.112449799196787 | 28 | 0 | 11 | 0 | 54 | 81 | 313 | 340 | PREDICTED: Biomphalaria glabrata protein DEK-like (LOC106058905), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 16854816 | 16854816 | PRJNA1122875_P_NODE_25294_length_330_cov_1.175097_g25070_i0 | PRJNA1122875 | 25294 | 330 | 1.175097 | 3.8778201 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.009 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g25070 | i0 | 100 | 0.439393939393939 | 29 | 0 | 9 | 0 | 152 | 180 | 39991672 | 39991644 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 145 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 16855087 | 16855087 | PRJNA1122875_P_NODE_48574_length_246_cov_0.890173_g48350_i0 | PRJNA1122875 | 48574 | 246 | 0.890173 | 2.18982558 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 62.1 | 3.69e-5 | NTclustered | gi|2912999222|dbj|AP039605.1| | 145626 | g48350 | i0 | 100 | 4.17886178861789 | 33 | 0 | 14 | 0 | 186 | 218 | 39545976 | 39545944 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence | blastn | 1028 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 16855156 | 16855156 | PRJNA1122875_P_NODE_53594_length_241_cov_0.916667_g53370_i0 | PRJNA1122875 | 53594 | 241 | 0.916667 | 2.20916747 | Lottia gigantea | 225164 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|676481244|ref|XM_009064063.1| | 225164 | g53370 | i0 | 100 | 0.116182572614108 | 28 | 0 | 12 | 0 | 89 | 116 | 107 | 80 | Lottia gigantea hypothetical protein mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 17606384 | 17606384 | PRJNA1122875_P_NODE_19694_length_376_cov_0.950495_g19470_i0 | PRJNA1122875 | 19694 | 376 | 0.950495 | 3.5738612 | Metazoa | 33208 | Mollusca | Mollusca | 52.8 | 0.036 | NTclustered | gi|2912986657|dbj|AP039591.1| | 145626 | g19470 | i0 | 100 | 0.148936170212766 | 28 | 0 | 7 | 0 | 1 | 28 | 30599161 | 30599188 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 18129373 | 18129373 | PRJNA1122875_P_NODE_31335_length_291_cov_2.963303_g31111_i0 | PRJNA1122875 | 31335 | 291 | 2.963303 | 8.62321173 | Haliotis rubra | 36100 | Mollusca | Mollusca | 52.8 | 0.027 | NTclustered | gi|2194121130|ref|XM_046716567.1| | 36100 | g31111 | i0 | 100 | 0.0962199312714777 | 28 | 0 | 10 | 0 | 222 | 249 | 497 | 524 | PREDICTED: Haliotis rubra WASH complex subunit 3-like (LOC124280592), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 19403467 | 19403467 | PRJNA1122875_P_NODE_28016_length_311_cov_1.172269_g27792_i0 | PRJNA1122875 | 28016 | 311 | 1.172269 | 3.64575659 | Mytilus edulis | 6550 | Mollusca | Mollusca | 52.8 | 0.029 | NTclustered | gi|2912377197|ref|XM_071300773.1| | 6550 | g27792 | i0 | 100 | 0.090032154340836 | 28 | 0 | 9 | 0 | 41 | 68 | 1206 | 1233 | PREDICTED: Mytilus edulis spidroin-1-like (LOC139512840), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 24503628 | 24503628 | PRJNA1122875_P_NODE_37640_length_270_cov_2.944162_g37416_i0 | PRJNA1122875 | 37640 | 270 | 2.944162 | 7.9492374 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 95.3 | 4.05e-15 | NTclustered | gi|2442026057|ref|XR_006683978.2| | 6596 | g37416 | i0 | 93.75 | 22.5333333333333 | 64 | 3 | 24 | 1 | 1 | 64 | 96 | 158 | PREDICTED: Mercenaria mercenaria uncharacterized LOC123539447 (LOC123539447), ncRNA | blastn | 6084 | 95.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 24503640 | 24503640 | PRJNA1122875_P_NODE_38720_length_267_cov_1.190722_g38496_i0 | PRJNA1122875 | 38720 | 267 | 1.190722 | 3.17922774 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 58.4 | 5.25e-4 | NTclustered | gi|2441976649|ref|XM_045354458.2| | 6596 | g38496 | i0 | 92.683 | 3.2247191011236 | 41 | 2 | 15 | 1 | 70 | 110 | 5708 | 5747 | PREDICTED: Mercenaria mercenaria rho guanine nucleotide exchange factor 12-like (LOC123561834), transcript variant X1, mRNA | blastn | 861 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 24503803 | 24503803 | PRJNA1122875_P_NODE_50060_length_244_cov_2.111111_g49836_i0 | PRJNA1122875 | 50060 | 244 | 2.111111 | 5.15111084 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 62.1 | 3.66e-5 | NTclustered | gi|2913000417|dbj|AP039607.1| | 145626 | g49836 | i0 | 88.235 | 4.67213114754098 | 51 | 6 | 21 | 0 | 168 | 218 | 14281830 | 14281780 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 26, sequence | blastn | 1140 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris |
Advanced export
JSON shape: default, array, newline-delimited
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);;