contig_metadata
23 rows where bioproject = "PRJEB81327", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 139853 | 139853 | PRJEB81327_P_NODE_40441_length_260_cov_2.326203_g39833_i0 | PRJEB81327 | 40441 | 260 | 2.326203 | 6.0481278 | Argopecten irradians | 31199 | Mollusca | Mollusca | 115 | 4.08e-29 | NR | XP_069125987.1 | 31199 | g39833 | i0 | 61.2 | 1.88076923076923 | 85 | 33 | 98.1 | 0 | 6 | 260 | 5 | 89 | XP_069125987.1 palmitoyl-protein thioesterase 1-like [Argopecten irradians] | diamond | 489 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 2689627 | 2689627 | PRJEB81327_P_NODE_15083_length_347_cov_1.624088_g14475_i0 | PRJEB81327 | 15083 | 347 | 1.624088 | 5.63558536 | Opisthokonta | 33154 | Mollusca | Mollusca | 152 | 7.85e-45 | NR | XP_022289768.1 | 6565 | g14475 | i0 | 64 | 14.5158501440922 | 114 | 41 | 98.6 | 0 | 344 | 3 | 1 | 114 | XP_022289768.1 60S ribosomal protein L32-like [Crassostrea virginica] | diamond | 5037 | 153 | 0.993464052287582 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 6100155 | 6100155 | PRJEB81327_P_NODE_39465_length_262_cov_1.603175_g38857_i0 | PRJEB81327 | 39465 | 262 | 1.603175 | 4.2003185 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 0.024 | NTclustered | gi|1207978941|ref|XM_021483260.1| | 6573 | g38857 | i0 | 100 | 2.06870229007634 | 28 | 0 | 11 | 0 | 188 | 215 | 4365 | 4392 | PREDICTED: Mizuhopecten yessoensis uncharacterized LOC110440287 (LOC110440287), mRNA | blastn | 542 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 12893077 | 12893077 | PRJEB81327_P_NODE_17371_length_324_cov_1.422311_g16763_i0 | PRJEB81327 | 17371 | 324 | 1.422311 | 4.60828764 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 154 | 9.79e-46 | NR | XP_025086345.1 | 400727 | g16763 | i0 | 67 | 4.94444444444444 | 106 | 35 | 98.1 | 0 | 318 | 1 | 1 | 106 | XP_025086345.1 LOW QUALITY PROTEIN: 40S ribosomal protein S11-like [Pomacea canaliculata] | diamond | 1602 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 17991140 | 17991140 | PRJEB81327_P_NODE_18335_length_315_cov_3.219008_g17727_i0 | PRJEB81327 | 18335 | 315 | 3.219008 | 10.1398752 | Magallana angulata | 2784310 | Mollusca | Mollusca | 198 | 3.58e-46 | NTclustered | gi|2416916068|ref|XM_052845461.1| | 2784310 | g17727 | i0 | 78.165 | 10.8285714285714 | 316 | 65 | 99 | 3 | 2 | 315 | 438 | 125 | PREDICTED: Crassostrea angulata proteasome subunit alpha type-6-like (LOC128178343), mRNA | blastn | 3411 | 198 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana angulata | |
| 17991540 | 17991540 | PRJEB81327_P_NODE_48375_length_250_cov_0.870056_g47767_i0 | PRJEB81327 | 48375 | 250 | 0.870056 | 2.17514 | Aplysia californica | 6500 | Mollusca | Mollusca | 318 | 2.02e-82 | NTclustered | gi|325297131|ref|NM_001204646.1| | 6500 | g47767 | i0 | 90 | 87.064 | 250 | 20 | 100 | 1 | 1 | 250 | 405 | 161 | Aplysia californica polyubiquitin-C (LOC101860494), mRNA | blastn | 21766 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 17991795 | 17991795 | PRJEB81327_P_NODE_69035_length_216_cov_5.489510_g68427_i0 | PRJEB81327 | 69035 | 216 | 5.48951 | 11.8573416 | Ostrea edulis | 37623 | Mollusca | Mollusca | 104 | 5.19e-18 | NTclustered | gi|2507442068|ref|XM_048889000.2| | 37623 | g68427 | i0 | 80.42 | 1.98611111111111 | 143 | 23 | 64 | 5 | 1 | 138 | 5516 | 5658 | PREDICTED: Ostrea edulis E3 ubiquitin-protein ligase RNF38-like (LOC125657998), transcript variant X6, mRNA | blastn | 429 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 19265057 | 19265057 | PRJEB81327_P_NODE_12216_length_387_cov_2.082803_g11608_i0 | PRJEB81327 | 12216 | 387 | 2.082803 | 8.06044761 | Ostrea edulis | 37623 | Mollusca | Mollusca | 156 | 2.74e-33 | NTclustered | gi|2507440729|ref|XM_056150217.1| | 37623 | g11608 | i0 | 89.516 | 30.2041343669251 | 124 | 11 | 32 | 2 | 240 | 362 | 795 | 673 | PREDICTED: Ostrea edulis 60S ribosomal protein L8-like (LOC130050350), transcript variant X2, mRNA | blastn | 11689 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 19265362 | 19265362 | PRJEB81327_P_NODE_36116_length_268_cov_1.184615_g35508_i0 | PRJEB81327 | 36116 | 268 | 1.184615 | 3.1747682 | Physella acuta | 109671 | Mollusca | Mollusca | 252 | 2.25e-62 | NTclustered | gi|2572439903|ref|XM_059287523.1| | 109671 | g35508 | i0 | 85.081 | 85.1492537313433 | 248 | 36 | 93 | 1 | 17 | 264 | 716 | 962 | PREDICTED: Physella acuta endoplasmic reticulum chaperone BiP (LOC131930863), mRNA | blastn | 22820 | 252 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 24365492 | 24365492 | PRJEB81327_P_NODE_24260_length_289_cov_1.226852_g23652_i0 | PRJEB81327 | 24260 | 289 | 1.226852 | 3.54560228 | Metazoa | 33208 | Mollusca | Mollusca | 144 | 9.8e-38 | NR | GFO14578.1 | 259542 | g23652 | i0 | 75.8 | 12.8200692041522 | 95 | 23 | 98.6 | 0 | 3 | 287 | 558 | 652 | GFO14578.1 multidrug resistance protein 1 [Plakobranchus ocellatus] | diamond | 3705 | 145 | 0.993103448275862 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Plakobranchus | Plakobranchus ocellatus | ||
| 24365749 | 24365749 | PRJEB81327_P_NODE_4520_length_692_cov_1.794830_g3952_i0 | PRJEB81327 | 4520 | 692 | 1.79483 | 12.4202236 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.019 | NTclustered | gi|2912997258|dbj|AP039602.1| | 145626 | g3952 | i0 | 100 | 0.226878612716763 | 29 | 0 | 4 | 0 | 491 | 519 | 59809024 | 59809052 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence | blastn | 157 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 26995051 | 26995051 | PRJEB81327_P_NODE_36042_length_268_cov_1.384615_g35434_i0 | PRJEB81327 | 36042 | 268 | 1.384615 | 3.7107682 | Mytilus | 6548 | Mollusca | Mollusca | 107 | 7.750000000000001e-27 | NR | XP_071163447.1 | 6550 | g35434 | i0 | 64.3 | 1.65671641791045 | 70 | 25 | 78.4 | 0 | 213 | 4 | 13 | 82 | XP_071163447.1 putative glutathione-specific gamma-glutamylcyclotransferase 2 [Mytilus edulis] | diamond | 444 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 27413797 | 27413797 | PRJEB81327_P_NODE_35983_length_268_cov_1.482051_g35375_i0 | PRJEB81327 | 35983 | 268 | 1.482051 | 3.97189668 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 48.1 | 6.47e-4 | NR | KAK3584442.1 | 2493646 | g35375 | i0 | 40.4 | 1.16417910447761 | 52 | 31 | 58.2 | 0 | 76 | 231 | 216 | 267 | KAK3584442.1 hypothetical protein CHS0354_006061 [Potamilus streckersoni] | diamond | 312 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni | |
| 27571382 | 27571382 | PRJEB81327_P_NODE_44324_length_254_cov_1.337017_g43716_i0 | PRJEB81327 | 44324 | 254 | 1.337017 | 3.39602318 | Candidula unifasciata | 100452 | Mollusca | Mollusca | 83.6 | 7.54e-17 | NR | CAG5124320.1 | 100452 | g43716 | i0 | 47.6 | 0.968503937007874 | 82 | 40 | 96.9 | 2 | 253 | 8 | 223 | 301 | CAG5124320.1 unnamed protein product [Candidula unifasciata] | diamond | 246 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 27634683 | 27634683 | PRJEB81327_P_NODE_31684_length_275_cov_1.965347_g31076_i0 | PRJEB81327 | 31684 | 275 | 1.965347 | 5.40470425 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 43.5 | 0.03 | NR | XP_025098712.1 | 400727 | g31076 | i0 | 35.1 | 0.84 | 77 | 37 | 78.5 | 2 | 31 | 246 | 328 | 396 | XP_025098712.1 gamma-aminobutyric acid type B receptor subunit 1-like [Pomacea canaliculata] | diamond | 231 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 28202661 | 28202661 | PRJEB81327_P_NODE_20246_length_309_cov_0.978814_g19638_i0 | PRJEB81327 | 20246 | 309 | 0.978814 | 3.02453526 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 75.5 | 1.95e-13 | NR | CAE1291868.1 | 158019 | g19638 | i0 | 76.7 | 2.11650485436893 | 43 | 10 | 41.7 | 0 | 1 | 129 | 325 | 367 | CAE1291868.1 ALDH18A1 [Acanthosepion pharaonis] | diamond | 654 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 28550388 | 28550388 | PRJEB81327_P_NODE_4127_length_735_cov_1.203927_g3574_i0 | PRJEB81327 | 4127 | 735 | 1.203927 | 8.84886345 | Pecten maximus | 6579 | Mollusca | Mollusca | 47.8 | 0.0355 | NR | XP_033732292.1 | 6579 | g3574 | i0 | 32 | 0.420408163265306 | 103 | 65 | 40 | 2 | 49 | 342 | 1800 | 1902 | XP_033732292.1 uncharacterized protein LOC117321818 [Pecten maximus] | diamond | 309 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 28669331 | 28669331 | PRJEB81327_P_NODE_37827_length_265_cov_1.203125_g37219_i0 | PRJEB81327 | 37827 | 265 | 1.203125 | 3.18828125 | Saccostrea | 33508 | Mollusca | Mollusca | 147 | 6.2e-39 | NR | XP_062582500.1 | 36930 | g37219 | i0 | 67 | 37.1547169811321 | 88 | 29 | 99.6 | 0 | 2 | 265 | 273 | 360 | XP_062582500.1 beta-hexosaminidase subunit alpha-like [Saccostrea cuccullata] | diamond | 9846 | 148 | 0.993243243243243 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 28676618 | 28676618 | PRJEB81327_P_NODE_2647_length_942_cov_2.542002_g2192_i0 | PRJEB81327 | 2647 | 942 | 2.542002 | 23.94565884 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 207 | 2.3600000000000007e-59 | NR | KAK3589030.1 | 2493646 | g2192 | i0 | 55.2 | 3.10509554140127 | 172 | 76 | 54.5 | 1 | 102 | 614 | 27 | 198 | KAK3589030.1 hypothetical protein CHS0354_007978 [Potamilus streckersoni] | diamond | 2925 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni | |
| 30974964 | 30974964 | PRJEB81327_P_NODE_44354_length_254_cov_1.276243_g43746_i0 | PRJEB81327 | 44354 | 254 | 1.276243 | 3.24165722 | Metazoa | 33208 | Mollusca | Mollusca | 107 | 2.45e-27 | NR | XP_052243918.1 | 45954 | g43746 | i0 | 63.8 | 7.55905511811024 | 80 | 29 | 94.5 | 0 | 2 | 241 | 8 | 87 | XP_052243918.1 60S ribosomal protein L24-like [Dreissena polymorpha] | diamond | 1920 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 32437346 | 32437346 | PRJEB81327_P_NODE_59839_length_244_cov_0.900585_g59231_i0 | PRJEB81327 | 59839 | 244 | 0.900585 | 2.1974274 | Physella acuta | 109671 | Mollusca | Mollusca | 109 | 8.35e-26 | NR | XP_059148773.1 | 109671 | g59231 | i0 | 65.4 | 2.93852459016393 | 81 | 28 | 99.6 | 0 | 244 | 2 | 164 | 244 | XP_059148773.1 cytosol aminopeptidase-like isoform X2 [Physella acuta] | diamond | 717 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 32493178 | 32493178 | PRJEB81327_P_NODE_39399_length_262_cov_1.629630_g38791_i0 | PRJEB81327 | 39399 | 262 | 1.62963 | 4.2696306 | Mytilus | 6548 | Mollusca | Mollusca | 72.4 | 2.24e-13 | NR | VDI10222.1 | 29158 | g38791 | i0 | 55.4 | 1.91221374045802 | 56 | 25 | 64.1 | 0 | 6 | 173 | 25 | 80 | VDI10222.1 Hypothetical predicted protein [Mytilus galloprovincialis] | diamond | 501 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus galloprovincialis | |
| 32721097 | 32721097 | PRJEB81327_P_NODE_40760_length_260_cov_1.454545_g40152_i0 | PRJEB81327 | 40760 | 260 | 1.454545 | 3.781817 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 55.5 | 1.47e-6 | NR | XP_029641617.1 | 2607531 | g40152 | i0 | 38.5 | 10.3153846153846 | 91 | 43 | 90 | 3 | 27 | 260 | 10 | 100 | XP_029641617.1 acid phosphatase type 7 [Octopus sinensis] | diamond | 2682 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis |
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);;