contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA951810" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 937014 | 937014 | PRJNA951810_P_NODE_24861_length_403_cov_3.963636_g24520_i0 | PRJNA951810 | 24861 | 403 | 3.963636 | 15.97345308 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.003 | NTclustered | gi|2912995509|dbj|AP039600.1| | 145626 | g24520 | i0 | 92.308 | 1.35483870967742 | 39 | 3 | 10 | 0 | 65 | 103 | 37537090 | 37537052 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence | blastn | 546 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 2211470 | 2211470 | PRJNA951810_P_NODE_150122_length_258_cov_2.118919_g149777_i0 | PRJNA951810 | 150122 | 258 | 2.118919 | 5.46681102 | Mya arenaria | 6604 | Mollusca | Mollusca | 241 | 4.67e-59 | NTclustered | gi|2427418595|ref|XM_052927431.1| | 6604 | g149777 | i0 | 83.594 | 23.4031007751938 | 256 | 42 | 99 | 0 | 1 | 256 | 1400 | 1145 | PREDICTED: Mya arenaria propionyl-CoA carboxylase beta chain, mitochondrial-like (LOC128219598), transcript variant X1, mRNA | blastn | 6038 | 241 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 4764368 | 4764368 | PRJNA951810_P_NODE_140524_length_265_cov_4.187500_g140179_i0 | PRJNA951810 | 140524 | 265 | 4.1875 | 11.096875 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 276 | 1.32e-69 | NTclustered | gi|2364396425|ref|XM_052409548.1| | 45954 | g140179 | i0 | 87.19 | 2.78490566037736 | 242 | 31 | 91 | 0 | 24 | 265 | 2357 | 2116 | PREDICTED: Dreissena polymorpha netrin-1-like (LOC127868000), transcript variant X2, mRNA | blastn | 738 | 276 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 6041231 | 6041231 | PRJNA951810_P_NODE_8345_length_648_cov_20.982609_g8053_i0 | PRJNA951810 | 8345 | 648 | 20.982609 | 135.96730632 | Potamocorbula amurensis | 410346 | Mollusca | Mollusca | 725 | 0 | NTclustered | gi|633675264|gb|KJ522927.1| | 410346 | g8053 | i0 | 100 | 34.1033950617284 | 392 | 0 | 60 | 0 | 257 | 648 | 1 | 392 | Corbula amurensis haplotype 3 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 22099 | 725 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Corbulidae | Potamocorbula | Potamocorbula amurensis | |
| 6367530 | 6367530 | PRJNA951810_P_NODE_182625_length_229_cov_2.820513_g182280_i0 | PRJNA951810 | 182625 | 229 | 2.820513 | 6.45897477 | Bivalvia | 6544 | Mollusca | Mollusca | 424 | 3.76e-114 | NTclustered | gi|633675274|gb|KJ522933.1| | 410346 | g182280 | i0 | 100 | 95.9825327510917 | 229 | 0 | 100 | 0 | 1 | 229 | 94 | 322 | Corbula amurensis haplotype 5 cytochrome oxidase subunit 1 (COI) gene, partial cds; mitochondrial | blastn | 21980 | 424 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Corbulidae | Potamocorbula | Potamocorbula amurensis | |
| 8589179 | 8589179 | PRJNA951810_P_NODE_150887_length_257_cov_4.255435_g150542_i0 | PRJNA951810 | 150887 | 257 | 4.255435 | 10.93646795 | Mya arenaria | 6604 | Mollusca | Mollusca | 252 | 2.15e-62 | NTclustered | gi|2427413410|ref|XM_052925714.1| | 6604 | g150542 | i0 | 89.109 | 7.07392996108949 | 202 | 22 | 79 | 0 | 56 | 257 | 601 | 400 | PREDICTED: Mya arenaria protein polybromo-1-like (LOC128218150), transcript variant X6, mRNA | blastn | 1818 | 252 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 9865315 | 9865315 | PRJNA951810_P_NODE_34388_length_338_cov_5.818868_g34045_i0 | PRJNA951810 | 34388 | 338 | 5.818868 | 19.66777384 | Potamocorbula amurensis | 410346 | Mollusca | Mollusca | 348 | 3.63e-91 | NTclustered | gi|2165767117|gb|OL877081.1| | 410346 | g34045 | i0 | 98.969 | 50.7840236686391 | 194 | 2 | 57 | 0 | 1 | 194 | 515 | 708 | Potamocorbula amurensis voucher NSMK-MS-0025178 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial | blastn | 17165 | 348 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Corbulidae | Potamocorbula | Potamocorbula amurensis | |
| 12416784 | 12416784 | PRJNA951810_P_NODE_60850_length_310_cov_3.443038_g60507_i0 | PRJNA951810 | 60850 | 310 | 3.443038 | 10.6734178 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 198 | 3.5199999999999995e-46 | NTclustered | gi|2364381831|ref|XM_052400736.1| | 45954 | g60507 | i0 | 90.604 | 3.39354838709677 | 149 | 14 | 48 | 0 | 2 | 150 | 655 | 507 | PREDICTED: Dreissena polymorpha 40S ribosomal protein S7-like (LOC127861959), mRNA | blastn | 1052 | 198 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 12417381 | 12417381 | PRJNA951810_P_NODE_95410_length_295_cov_4.581081_g95066_i0 | PRJNA951810 | 95410 | 295 | 4.581081 | 13.51418895 | Argopecten irradians | 31199 | Mollusca | Mollusca | 54.7 | 0.008 | NTclustered | gi|2835376171|ref|XM_069262495.1| | 31199 | g95066 | i0 | 100 | 0.0983050847457627 | 29 | 0 | 10 | 0 | 152 | 180 | 1079 | 1051 | PREDICTED: Argopecten irradians uncharacterized protein (LOC138319394), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 18788060 | 18788060 | PRJNA951810_P_NODE_157915_length_251_cov_5.780899_g157570_i0 | PRJNA951810 | 157915 | 251 | 5.780899 | 14.51005649 | Corbicula fluminea | 45949 | Mollusca | Mollusca | 265 | 2.68e-66 | NTclustered | gi|406679533|gb|JQ781172.1| | 45949 | g157570 | i0 | 86 | 97.0358565737052 | 250 | 31 | 99 | 4 | 3 | 250 | 488 | 241 | Corbicula fluminea voucher BATOL 242.1A elongation factor 1 alpha gene, partial cds | blastn | 24356 | 265 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Cyrenidae | Corbicula | Corbicula fluminea | |
| 21338151 | 21338151 | PRJNA951810_P_NODE_143757_length_263_cov_1.621053_g143412_i0 | PRJNA951810 | 143757 | 263 | 1.621053 | 4.26336939 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 274 | 4.71e-69 | NTclustered | gi|2364455822|ref|XM_052426037.1| | 45954 | g143412 | i0 | 85.502 | 85.4144486692015 | 269 | 31 | 99 | 4 | 2 | 262 | 559 | 291 | PREDICTED: Dreissena polymorpha 40S ribosomal protein S15-like (LOC127879267), transcript variant X2, mRNA | blastn | 22464 | 274 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 21338818 | 21338818 | PRJNA951810_P_NODE_185177_length_225_cov_22.440789_g184832_i0 | PRJNA951810 | 185177 | 225 | 22.440789 | 50.49177525 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912999222|dbj|AP039605.1| | 145626 | g184832 | i0 | 100 | 1.06222222222222 | 30 | 0 | 13 | 0 | 127 | 156 | 52300906 | 52300935 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence | blastn | 239 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 25161600 | 25161600 | PRJNA951810_P_NODE_109880_length_287_cov_1.817757_g109536_i0 | PRJNA951810 | 109880 | 287 | 1.817757 | 5.21696259 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 270 | 6.7299999999999984e-68 | NTclustered | gi|2427300539|ref|XM_052977953.1| | 37653 | g109536 | i0 | 83.959 | 95.8606271777004 | 293 | 36 | 99 | 8 | 2 | 286 | 4472 | 4761 | PREDICTED: Octopus bimaculoides zinc finger protein 91 (LOC106878253), mRNA | blastn | 27512 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 25161814 | 25161814 | PRJNA951810_P_NODE_123760_length_277_cov_5.431373_g123415_i0 | PRJNA951810 | 123760 | 277 | 5.431373 | 15.04490321 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 134 | 8.850000000000001e-27 | NTclustered | gi|2442071490|ref|XM_053546789.1| | 6596 | g123415 | i0 | 75.547 | 0.989169675090253 | 274 | 65 | 99 | 2 | 5 | 277 | 11176 | 10904 | PREDICTED: Mercenaria mercenaria uncharacterized LOC123550515 (LOC123550515), mRNA | blastn | 274 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 25162942 | 25162942 | PRJNA951810_P_NODE_193740_length_207_cov_5.358209_g193395_i0 | PRJNA951810 | 193740 | 207 | 5.3582090000000004 | 11.09149263 | Mya arenaria | 6604 | Mollusca | Mollusca | 254 | 4.63e-63 | NTclustered | gi|2427466027|ref|XM_052939539.1| | 6604 | g193395 | i0 | 88.835 | 5.58937198067633 | 206 | 23 | 99 | 0 | 2 | 207 | 93 | 298 | PREDICTED: Mya arenaria 40S ribosomal protein S3 (LOC128228303), mRNA | blastn | 1157 | 254 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 25164016 | 25164016 | PRJNA951810_P_NODE_70860_length_303_cov_12.317391_g70516_i0 | PRJNA951810 | 70860 | 303 | 12.317391 | 37.32169473 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 60.2 | 1.69e-4 | NTclustered | gi|2912986657|dbj|AP039591.1| | 145626 | g70516 | i0 | 94.737 | 15.2607260726073 | 38 | 2 | 13 | 0 | 233 | 270 | 30471117 | 30471080 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence | blastn | 4624 | 60.2 | 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);;