contig_metadata
18 rows where bioproject = "PRJNA682370", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1174569 | 1174569 | PRJNA682370_S_NODE_13541_length_195_cov_1.287500_g12929_i0 | PRJNA682370 | 13541 | 195 | 1.2875 | 2.510625 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.017 | NTclustered | gi|2912998015|dbj|AP039603.1| | 145626 | g12929 | i0 | 96.774 | 0.58974358974359 | 31 | 1 | 16 | 0 | 15 | 45 | 24894104 | 24894074 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 22, sequence | blastn | 115 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 1940177 | 1940177 | PRJNA682370_S_NODE_13902_length_192_cov_3.222930_g13290_i0 | PRJNA682370 | 13902 | 192 | 3.22293 | 6.1880256 | Argopecten irradians | 31199 | Mollusca | Mollusca | 165 | 2.04e-36 | NTclustered | gi|2835362839|ref|XM_069255417.1| | 31199 | g13290 | i0 | 90.984 | 60.828125 | 122 | 11 | 64 | 0 | 71 | 192 | 1465 | 1344 | PREDICTED: Argopecten irradians tubulin alpha-1A chain (LOC138314838), transcript variant X3, mRNA | blastn | 11679 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 3214992 | 3214992 | PRJNA682370_S_NODE_14263_length_190_cov_1.348387_g13651_i0 | PRJNA682370 | 14263 | 190 | 1.348387 | 2.5619353 | root | 1 | Root_unresolved | Root_unresolved | 125 | 1.7399999999999999e-31 | NR | CAG2186962.1 | 6550 | g13651 | i0 | 95 | 457.578947368421 | 60 | 3 | 94.7 | 0 | 1 | 180 | 409 | 468 | CAG2186962.1 unnamed protein product [Mytilus edulis] | diamond | 86940 | 126 | 0.992063492063492 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 4492074 | 4492074 | PRJNA682370_S_NODE_11704_length_212_cov_1.242938_g11092_i0 | PRJNA682370 | 11704 | 212 | 1.242938 | 2.63502856 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2912998015|dbj|AP039603.1| | 145626 | g11092 | i0 | 92.5 | 0.188679245283019 | 40 | 2 | 18 | 1 | 150 | 188 | 39677782 | 39677821 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 22, sequence | blastn | 40 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 9593163 | 9593163 | PRJNA682370_S_NODE_7368_length_280_cov_1.877551_g6756_i0 | PRJNA682370 | 7368 | 280 | 1.877551 | 5.2571428 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.026 | NTclustered | gi|2913001816|dbj|AP039609.1| | 145626 | g6756 | i0 | 100 | 0.1 | 28 | 0 | 10 | 0 | 43 | 70 | 12127837 | 12127810 | 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 | |
| 10868231 | 10868231 | PRJNA682370_S_NODE_16129_length_178_cov_1.650350_g15517_i0 | PRJNA682370 | 16129 | 178 | 1.65035 | 2.937623 | Batillaria attramentaria | 370345 | Mollusca | Mollusca | 104 | 1.28e-26 | NR | KAK7500985.1 | 370345 | g15517 | i0 | 79.7 | 2.00561797752809 | 59 | 12 | 99.4 | 0 | 2 | 178 | 7 | 65 | KAK7500985.1 hypothetical protein BaRGS_00007865 [Batillaria attramentaria] | diamond | 357 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Batillariidae | Batillaria | Batillaria attramentaria | ||
| 12143553 | 12143553 | PRJNA682370_S_NODE_13650_length_194_cov_1.792453_g13038_i0 | PRJNA682370 | 13650 | 194 | 1.792453 | 3.47735882 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.017 | NTclustered | gi|2912992646|dbj|AP039597.1| | 145626 | g13038 | i0 | 100 | 0.144329896907216 | 28 | 0 | 14 | 0 | 116 | 143 | 36324007 | 36324034 | 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 | |
| 12654036 | 12654036 | PRJNA682370_S_NODE_1730_length_646_cov_2.597381_g1231_i0 | PRJNA682370 | 1730 | 646 | 2.597381 | 16.77908126 | Metazoa | 33208 | Mollusca | Mollusca | 54.7 | 0.018 | NTclustered | gi|2912998575|dbj|AP039604.1| | 145626 | g1231 | i0 | 100 | 0.0990712074303406 | 29 | 0 | 4 | 0 | 502 | 530 | 44290752 | 44290780 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 23, sequence | blastn | 64 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 15966836 | 15966836 | PRJNA682370_S_NODE_11033_length_219_cov_1.527174_g10421_i0 | PRJNA682370 | 11033 | 219 | 1.527174 | 3.34451106 | Argopecten irradians | 31199 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2671790613|gb|PP199154.1| | 31199 | g10421 | i0 | 94.595 | 0.168949771689498 | 37 | 1 | 16 | 1 | 85 | 120 | 23627 | 23663 | Argopecten irradians clone evm.model.58.139.1 spatiotemporal phototransduction pathway protein gene, complete cds | blastn | 37 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 20301038 | 20301038 | PRJNA682370_S_NODE_14136_length_191_cov_1.160256_g13524_i0 | PRJNA682370 | 14136 | 191 | 1.160256 | 2.21608896 | Metazoa | 33208 | Mollusca | Mollusca | 65.5 | 1.8e-10 | NR | XP_033762849.1 | 6579 | g13524 | i0 | 65 | 5.05759162303665 | 40 | 14 | 62.8 | 0 | 120 | 1 | 1193 | 1232 | XP_033762849.1 multiple epidermal growth factor-like domains protein 6 [Pecten maximus] | diamond | 966 | 65.9 | 0.993930197268589 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 22341466 | 22341466 | PRJNA682370_S_NODE_13458_length_195_cov_2.568750_g12846_i0 | PRJNA682370 | 13458 | 195 | 2.56875 | 5.0090625 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.005 | NTclustered | gi|2912995509|dbj|AP039600.1| | 145626 | g12846 | i0 | 100 | 1.06666666666667 | 29 | 0 | 15 | 0 | 159 | 187 | 50774929 | 50774901 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence | blastn | 208 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 23617386 | 23617386 | PRJNA682370_S_NODE_5759_length_328_cov_1.426621_g5147_i0 | PRJNA682370 | 5759 | 328 | 1.426621 | 4.67931688 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.031 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g5147 | i0 | 100 | 0.170731707317073 | 28 | 0 | 9 | 0 | 212 | 239 | 24250590 | 24250563 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 23617490 | 23617490 | PRJNA682370_S_NODE_9039_length_247_cov_1.599057_g8427_i0 | PRJNA682370 | 9039 | 247 | 1.599057 | 3.94967079 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2912995509|dbj|AP039600.1| | 145626 | g8427 | i0 | 94.444 | 0.145748987854251 | 36 | 1 | 14 | 1 | 190 | 224 | 9159878 | 9159913 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 19, sequence | blastn | 36 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 27631012 | 27631012 | PRJNA682370_S_NODE_7964_length_268_cov_1.866953_g7352_i0 | PRJNA682370 | 7964 | 268 | 1.866953 | 5.00343404 | Metazoa | 33208 | Mollusca | Mollusca | 92 | 2.25e-19 | NR | XP_021352765.1 | 6573 | g7352 | i0 | 53.1 | 24.8171641791045 | 81 | 38 | 90.7 | 0 | 245 | 3 | 318 | 398 | XP_021352765.1 leishmanolysin-like peptidase [Mizuhopecten yessoensis] | diamond | 6651 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 28609676 | 28609676 | PRJNA682370_S_NODE_16267_length_177_cov_3.225352_g15655_i0 | PRJNA682370 | 16267 | 177 | 3.225352 | 5.70887304 | root | 1 | Root_unresolved | Root_unresolved | 97.8 | 4.9e-23 | NR | GFN99063.1 | 259542 | g15655 | i0 | 74.1 | 8.84745762711864 | 58 | 15 | 98.3 | 0 | 2 | 175 | 43 | 100 | GFN99063.1 elongation factor 2 [Plakobranchus ocellatus] | diamond | 1566 | 98.2 | 0.995926680244399 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Plakobranchus | Plakobranchus ocellatus | ||
| 29671172 | 29671172 | PRJNA682370_S_NODE_850_length_914_cov_5.532423_g500_i0 | PRJNA682370 | 850 | 914 | 5.532423 | 50.56634622 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 78.2 | 2.26e-12 | NR | KAI8785498.1 | 6526 | g500 | i0 | 60.9 | 1.46389496717724 | 64 | 18 | 20.7 | 4 | 539 | 351 | 132 | 189 | KAI8785498.1 cathepsin L1 [Biomphalaria glabrata] | diamond | 1338 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 30271980 | 30271980 | PRJNA682370_S_NODE_22752_length_154_cov_1.302521_g22140_i0 | PRJNA682370 | 22752 | 154 | 1.302521 | 2.00588234 | Patella caerulea | 87958 | Mollusca | Mollusca | 62 | 1.76e-9 | NR | KAK6174818.1 | 87958 | g22140 | i0 | 76.9 | 1.53896103896104 | 39 | 9 | 76 | 0 | 37 | 153 | 334 | 372 | KAK6174818.1 hypothetical protein SNE40_013393 [Patella caerulea] | diamond | 237 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 31061845 | 31061845 | PRJNA682370_S_NODE_13555_length_195_cov_1.200000_g12943_i0 | PRJNA682370 | 13555 | 195 | 1.2 | 2.34 | Aplysia californica | 6500 | Mollusca | Mollusca | 42.4 | 0.0274 | NR | XP_005106648.1 | 6500 | g12943 | i0 | 41.7 | 2.75384615384615 | 60 | 28 | 86.2 | 3 | 189 | 22 | 264 | 320 | XP_005106648.1 cysteine-rich with EGF-like domain protein 2-A isoform X3 [Aplysia californica] | diamond | 537 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica |
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);;