contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA1022139" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 161560 | 161560 | PRJNA1022139_P_NODE_18561_length_323_cov_1.232000_g18456_i0 | PRJNA1022139 | 18561 | 323 | 1.232 | 3.97936 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 89.8 | 2.31e-13 | NTclustered | gi|1207980183|ref|XM_021483941.1| | 6573 | g18456 | i0 | 89.855 | 2.1671826625387 | 69 | 7 | 21 | 0 | 254 | 322 | 948 | 880 | PREDICTED: Mizuhopecten yessoensis 60S ribosomal protein L3-B-like (LOC110440810), mRNA | blastn | 700 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 2711959 | 2711959 | PRJNA1022139_P_NODE_19343_length_317_cov_1.704918_g19238_i0 | PRJNA1022139 | 19343 | 317 | 1.704918 | 5.40459006 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 102 | 2.91e-17 | NTclustered | gi|2502151277|ref|XM_013230836.2| | 6526 | g19238 | i0 | 80 | 0.829652996845426 | 140 | 26 | 44 | 2 | 155 | 293 | 583 | 445 | PREDICTED: Biomphalaria glabrata histone H3.3A (LOC106070825), mRNA | blastn | 263 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 2712000 | 2712000 | PRJNA1022139_P_NODE_23663_length_289_cov_2.393519_g23558_i0 | PRJNA1022139 | 23663 | 289 | 2.393519 | 6.91726991 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.027 | NTclustered | gi|2913001038|dbj|AP039608.1| | 145626 | g23558 | i0 | 100 | 0.0968858131487889 | 28 | 0 | 10 | 0 | 1 | 28 | 37708390 | 37708417 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 27, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 7814179 | 7814179 | PRJNA1022139_P_NODE_19487_length_316_cov_1.823045_g19382_i0 | PRJNA1022139 | 19487 | 316 | 1.823045 | 5.7608222 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 52.8 | 0.03 | NTclustered | gi|2694106933|ref|XM_063588469.1| | 6551 | g19382 | i0 | 100 | 0.177215189873418 | 28 | 0 | 9 | 0 | 282 | 309 | 1200 | 1173 | PREDICTED: Mytilus trossulus uncharacterized LOC134725015 (LOC134725015), transcript variant X1, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 9089311 | 9089311 | PRJNA1022139_P_NODE_39228_length_245_cov_1.645349_g39123_i0 | PRJNA1022139 | 39228 | 245 | 1.645349 | 4.03110505 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912993551|dbj|AP039598.1| | 145626 | g39123 | i0 | 100 | 1.10612244897959 | 30 | 0 | 15 | 0 | 196 | 225 | 40858944 | 40858973 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 17, sequence | blastn | 271 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 10364742 | 10364742 | PRJNA1022139_P_NODE_14489_length_359_cov_1.076923_g14384_i0 | PRJNA1022139 | 14489 | 359 | 1.076923 | 3.86615357 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 60.2 | 2.03e-4 | NTclustered | gi|2912981848|dbj|AP039587.1| | 145626 | g14384 | i0 | 94.872 | 0.481894150417827 | 39 | 1 | 12 | 1 | 99 | 136 | 69811701 | 69811663 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence | blastn | 173 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 10364846 | 10364846 | PRJNA1022139_P_NODE_28289_length_273_cov_1.400000_g28184_i0 | PRJNA1022139 | 28289 | 273 | 1.4 | 3.822 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.025 | NTclustered | gi|2912993551|dbj|AP039598.1| | 145626 | g28184 | i0 | 100 | 0.102564102564103 | 28 | 0 | 10 | 0 | 37 | 64 | 33147612 | 33147639 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 17, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 10364923 | 10364923 | PRJNA1022139_P_NODE_39269_length_245_cov_1.430233_g39164_i0 | PRJNA1022139 | 39269 | 245 | 1.430233 | 3.50407085 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2912992646|dbj|AP039597.1| | 145626 | g39164 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 86 | 113 | 38233698 | 38233671 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 12915476 | 12915476 | PRJNA1022139_P_NODE_4411_length_610_cov_1.620112_g4307_i0 | PRJNA1022139 | 4411 | 610 | 1.620112 | 9.8826832 | Magallana gigas | 29159 | Mollusca | Mollusca | 154 | 1.61e-32 | NTclustered | gi|2751227510|ref|XM_011429552.4| | 29159 | g4307 | i0 | 72.059 | 0.891803278688525 | 544 | 143 | 89 | 9 | 18 | 557 | 184 | 722 | PREDICTED: Magallana gigas sperm-associated antigen 6 (LOC105328603), mRNA | blastn | 544 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 14190187 | 14190187 | PRJNA1022139_P_NODE_14692_length_357_cov_0.968310_g14587_i0 | PRJNA1022139 | 14692 | 357 | 0.96831 | 3.4568667 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 52.8 | 0.034 | NTclustered | gi|1242761553|ref|XM_022464232.1| | 6565 | g14587 | i0 | 100 | 0.156862745098039 | 28 | 0 | 8 | 0 | 133 | 160 | 352 | 379 | PREDICTED: Crassostrea virginica YTH domain-containing protein 1-like (LOC111122436), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 15031298 | 15031298 | PRJNA1022139_P_NODE_20232_length_311_cov_0.983193_g20127_i0 | PRJNA1022139 | 20232 | 311 | 0.983193 | 3.05773023 | Metazoa | 33208 | Mollusca | Mollusca | 63.9 | 1.34e-5 | NTclustered | gi|2911841197|ref|XM_071248709.1| | 6455 | g20127 | i0 | 97.368 | 11.7202572347267 | 38 | 0 | 12 | 1 | 103 | 139 | 1914 | 1951 | PREDICTED: Haliotis cracherodii uncharacterized protein (LOC139467002), mRNA | blastn | 3645 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis cracherodii | |
| 18013642 | 18013642 | PRJNA1022139_P_NODE_7475_length_480_cov_2.184275_g7370_i0 | PRJNA1022139 | 7475 | 480 | 2.184275 | 10.48452 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 56.5 | 0.004 | NTclustered | gi|1397713694|ref|XM_025248202.1| | 400727 | g7370 | i0 | 100 | 0.125 | 30 | 0 | 6 | 0 | 260 | 289 | 1400 | 1429 | PREDICTED: Pomacea canaliculata nesprin-1-like (LOC112570022), transcript variant X1, mRNA | blastn | 60 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 19287217 | 19287217 | PRJNA1022139_P_NODE_12016_length_388_cov_1.222222_g11911_i0 | PRJNA1022139 | 12016 | 388 | 1.222222 | 4.74222136 | Pecten maximus | 6579 | Mollusca | Mollusca | 60.2 | 2.21e-4 | NTclustered | gi|1835526799|ref|XM_033896361.1| | 6579 | g11911 | i0 | 97.143 | 0.0902061855670103 | 35 | 1 | 9 | 0 | 352 | 386 | 900 | 934 | PREDICTED: Pecten maximus protein PIF-like (LOC117336030), mRNA | blastn | 35 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 19287427 | 19287427 | PRJNA1022139_P_NODE_38376_length_246_cov_1.780347_g38271_i0 | PRJNA1022139 | 38376 | 246 | 1.780347 | 4.37965362 | Pecten maximus | 6579 | Mollusca | Mollusca | 60.2 | 1.33e-4 | NTclustered | gi|1835526799|ref|XM_033896361.1| | 6579 | g38271 | i0 | 94.872 | 0.329268292682927 | 39 | 1 | 16 | 1 | 206 | 244 | 937 | 900 | PREDICTED: Pecten maximus protein PIF-like (LOC117336030), mRNA | blastn | 81 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 20562962 | 20562962 | PRJNA1022139_P_NODE_7857_length_469_cov_6.671717_g7752_i0 | PRJNA1022139 | 7857 | 469 | 6.671717 | 31.29035273 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 52.8 | 0.046 | NTclustered | gi|1207953555|ref|XM_021511204.1| | 6573 | g7752 | i0 | 100 | 0.0597014925373134 | 28 | 0 | 6 | 0 | 172 | 199 | 3261 | 3288 | PREDICTED: Mizuhopecten yessoensis uncharacterized LOC110459108 (LOC110459108), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 23113866 | 23113866 | PRJNA1022139_P_NODE_19039_length_319_cov_2.447154_g18934_i0 | PRJNA1022139 | 19039 | 319 | 2.447154 | 7.80642126 | Elisolimax flavescens | 424226 | Mollusca | Mollusca | 119 | 2.91e-22 | NTclustered | gi|145652941|gb|EF015440.1| | 424226 | g18934 | i0 | 82.857 | 38.7868338557994 | 140 | 17 | 43 | 6 | 174 | 309 | 1555 | 1419 | Elisolimax flavescens cytochrome oxidase subunit I (COI) gene, partial cds; tRNA-Val gene, complete sequence; and 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 12373 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Urocyclidae | Elisolimax | Elisolimax flavescens | |
| 25229814 | 25229814 | PRJNA1022139_P_NODE_37260_length_248_cov_0.880000_g37155_i0 | PRJNA1022139 | 37260 | 248 | 0.88 | 2.1824 | Mollusca | 6447 | Mollusca | Mollusca | 60.2 | 1.34e-4 | NTclustered | gi|2912993551|dbj|AP039598.1| | 145626 | g37155 | i0 | 97.143 | 2.19758064516129 | 35 | 1 | 14 | 0 | 129 | 163 | 48970918 | 48970884 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 17, sequence | blastn | 545 | 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);;