contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJEB81327" 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 | |
| 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 | |
| 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 | ||
| 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);;