contig_metadata
23 rows where analysis = "diamond", bioproject = "PRJEB6584" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25752078 | 25752078 | PRJEB6584e_S_NODE_498_length_318_cov_8.194346_g483_i0 | PRJEB6584 | 498 | 318 | 8.194346 | 26.05802028 | Mytilus californianus | 6549 | Mollusca | Mollusca | 96.7 | 4.9e-23 | NR | XP_052063403.1 | 6549 | g483 | i0 | 63.5 | 0.69811320754717 | 74 | 27 | 69.8 | 0 | 3 | 224 | 67 | 140 | XP_052063403.1 coactosin-like protein [Mytilus californianus] | diamond | 222 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 25932708 | 25932708 | PRJEB6584o_S_NODE_15164_length_227_cov_2.062500_g15056_i0 | PRJEB6584 | 15164 | 227 | 2.0625 | 4.681875 | Candidula unifasciata | 100452 | Mollusca | Mollusca | 90.5 | 3.7e-19 | NR | CAG5118438.1 | 100452 | g15056 | i0 | 69.1 | 2.16740088105727 | 55 | 16 | 71.4 | 1 | 224 | 63 | 401 | 455 | CAG5118438.1 unnamed protein product [Candidula unifasciata] | diamond | 492 | 90.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 32929131 | 32929131 | PRJEB6584e_S_NODE_89_length_525_cov_7.428571_g74_i0 | PRJEB6584 | 89 | 525 | 7.428571 | 38.99999775 | Batillaria attramentaria | 370345 | Mollusca | Mollusca | 151 | 1.3699999999999999e-42 | NR | KAK7498057.1 | 370345 | g74 | i0 | 58.4 | 0.851428571428571 | 149 | 55 | 85.1 | 2 | 2 | 448 | 55 | 196 | KAK7498057.1 hypothetical protein BaRGS_00010645 [Batillaria attramentaria] | diamond | 447 | 151 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Batillariidae | Batillaria | Batillaria attramentaria | ||
| 32929144 | 32929144 | PRJEB6584h_S_NODE_26897_length_173_cov_4.253623_g26835_i0 | PRJEB6584 | 26897 | 173 | 4.253623 | 7.35876779 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 57.4 | 9.15e-8 | NR | XP_013066355.1 | 6526 | g26835 | i0 | 88.9 | 0.936416184971098 | 27 | 3 | 46.8 | 0 | 173 | 93 | 303 | 329 | XP_013066355.1 procathepsin L-like [Biomphalaria glabrata] | diamond | 162 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 32940206 | 32940206 | PRJEB6584e_S_NODE_3665_length_161_cov_1.269841_g3650_i0 | PRJEB6584 | 3665 | 161 | 1.269841 | 2.04444401 | Mollusca | 6447 | Mollusca | Mollusca | 47.8 | 2.09e-4 | NR | XP_064612151.1 | 13599 | g3650 | i0 | 44.2 | 2.59006211180124 | 43 | 24 | 80.1 | 0 | 28 | 156 | 205 | 247 | XP_064612151.1 rasGAP-activating-like protein 1 [Liolophura japonica] | diamond | 417 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 32940210 | 32940210 | PRJEB6584h_S_NODE_49569_length_164_cov_1.449612_g49507_i0 | PRJEB6584 | 49569 | 164 | 1.449612 | 2.37736368 | Octopus | 6643 | Mollusca | Mollusca | 69.3 | 4.99e-12 | NR | CAI9734609.1 | 6645 | g49507 | i0 | 59.6 | 2.85365853658537 | 52 | 21 | 95.1 | 0 | 1 | 156 | 82 | 133 | CAI9734609.1 RNA-binding protein Nova-1-like isoform X2 [Octopus vulgaris] | diamond | 468 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus vulgaris | |
| 32940288 | 32940288 | PRJEB6584o_S_NODE_5153_length_356_cov_7.408100_g5045_i0 | PRJEB6584 | 5153 | 356 | 7.4081 | 26.372836 | Littorinimorpha | 216294 | Mollusca | Mollusca | 94.7 | 6.95e-21 | NR | XP_070209641.1 | 31220 | g5045 | i0 | 49.4 | 5.25 | 89 | 43 | 75 | 1 | 342 | 76 | 177 | 263 | XP_070209641.1 elongation factor 1-beta-like isoform X1 [Littorina saxatilis] | diamond | 1869 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 32946242 | 32946242 | PRJEB6584e_S_NODE_834_length_272_cov_46.455696_g819_i0 | PRJEB6584 | 834 | 272 | 46.455696 | 126.35949312 | Haliotis asinina | 109174 | Mollusca | Mollusca | 43.5 | 0.0267 | NR | XP_067657806.1 | 109174 | g819 | i0 | 35.4 | 1.41176470588235 | 65 | 36 | 70.6 | 2 | 35 | 226 | 144 | 203 | XP_067657806.1 uncharacterized protein [Haliotis asinina] | diamond | 384 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 32946523 | 32946523 | PRJEB6584o_S_NODE_20706_length_200_cov_2.521212_g20598_i0 | PRJEB6584 | 20706 | 200 | 2.521212 | 5.042424 | Saccostrea echinata | 191078 | Mollusca | Mollusca | 54.7 | 2.73e-7 | NR | XP_061197718.1 | 191078 | g20598 | i0 | 52.3 | 1.32 | 44 | 21 | 66 | 0 | 27 | 158 | 96 | 139 | XP_061197718.1 coactosin-like protein [Saccostrea echinata] | diamond | 264 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 32957433 | 32957433 | PRJEB6584h_S_NODE_19186_length_180_cov_6.972414_g19124_i0 | PRJEB6584 | 19186 | 180 | 6.972414 | 12.5503452 | Metazoa | 33208 | Mollusca | Mollusca | 47 | 5.02e-4 | NR | XP_046581465.1 | 36100 | g19124 | i0 | 73.3 | 2.88333333333333 | 30 | 6 | 46.7 | 1 | 158 | 75 | 463 | 492 | XP_046581465.1 protein disulfide-isomerase A3-like [Haliotis rubra] | diamond | 519 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 32957496 | 32957496 | PRJEB6584o_S_NODE_4946_length_360_cov_262.901538_g4838_i0 | PRJEB6584 | 4946 | 360 | 262.901538 | 946.4455368 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 124 | 1.89e-33 | NR | XP_009051644.1 | 225164 | g4838 | i0 | 67.4 | 2.2 | 86 | 28 | 71.7 | 0 | 44 | 301 | 66 | 151 | XP_009051644.1 hypothetical protein LOTGIDRAFT_181799 [Lottia gigantea] | diamond | 792 | 125 | 0.992 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 32963966 | 32963966 | PRJEB6584o_S_NODE_58242_length_163_cov_1.750000_g58134_i0 | PRJEB6584 | 58242 | 163 | 1.75 | 2.8525 | Haliotis asinina | 109174 | Mollusca | Mollusca | 57 | 1.17e-7 | NR | XP_067651737.1 | 109174 | g58134 | i0 | 69.4 | 6.88343558282209 | 36 | 11 | 66.3 | 0 | 151 | 44 | 436 | 471 | XP_067651737.1 lysosomal protective protein-like [Haliotis asinina] | diamond | 1122 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 32974554 | 32974554 | PRJEB6584o_S_NODE_17290_length_214_cov_812.519553_g17182_i0 | PRJEB6584 | 17290 | 214 | 812.519553 | 1738.79184342 | root | 1 | Root_unresolved | Root_unresolved | 47 | 4.08e-4 | NR | XP_046341968.1 | 6454 | g17182 | i0 | 94.4 | 30.5327102803738 | 18 | 1 | 25.2 | 0 | 23 | 76 | 148 | 165 | XP_046341968.1 adenosine 5'-monophosphoramidase HINT2-like isoform X2 [Haliotis rufescens] | diamond | 6534 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 32998003 | 32998003 | PRJEB6584o_S_NODE_70827_length_157_cov_4.778689_g70719_i0 | PRJEB6584 | 70827 | 157 | 4.778689 | 7.50254173 | Batillaria attramentaria | 370345 | Mollusca | Mollusca | 68.2 | 1.88e-13 | NR | KAK7487531.1 | 370345 | g70719 | i0 | 76.2 | 0.802547770700637 | 42 | 10 | 80.3 | 0 | 2 | 127 | 33 | 74 | KAK7487531.1 hypothetical protein BaRGS_00021233 [Batillaria attramentaria] | diamond | 126 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Batillariidae | Batillaria | Batillaria attramentaria | ||
| 33008525 | 33008525 | PRJEB6584o_S_NODE_11563_length_258_cov_4.026906_g11455_i0 | PRJEB6584 | 11563 | 258 | 4.026906 | 10.38941748 | Opisthokonta | 33154 | Mollusca | Mollusca | 114 | 5.739999999999999e-31 | NR | XP_045157640.1 | 6596 | g11455 | i0 | 68.9 | 3.46511627906977 | 74 | 23 | 86 | 0 | 254 | 33 | 31 | 104 | XP_045157640.1 thioredoxin-like [Mercenaria mercenaria] | diamond | 894 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 33042626 | 33042626 | PRJEB6584e_S_NODE_4260_length_152_cov_1.025641_g4245_i0 | PRJEB6584 | 4260 | 152 | 1.025641 | 1.55897432 | Metazoa | 33208 | Mollusca | Mollusca | 55.8 | 2.54e-7 | NR | KAK3103875.1 | 66713 | g4245 | i0 | 60 | 5.40789473684211 | 45 | 17 | 88.8 | 1 | 2 | 136 | 439 | 482 | KAK3103875.1 hypothetical protein FSP39_022581 [Pinctada imbricata] | diamond | 822 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 33048540 | 33048540 | PRJEB6584e_S_NODE_4381_length_150_cov_1.739130_g4366_i0 | PRJEB6584 | 4381 | 150 | 1.73913 | 2.608695 | Haliotis fulgens | 6456 | Mollusca | Mollusca | 70.5 | 1.68e-12 | NR | AXR98611.1 | 6456 | g4366 | i0 | 73.5 | 1.94 | 49 | 13 | 98 | 0 | 3 | 149 | 475 | 523 | AXR98611.1 inducible heat shock protein 70 kDa [Haliotis fulgens] | diamond | 291 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis fulgens | |
| 33065624 | 33065624 | PRJEB6584e_S_NODE_861_length_271_cov_4.394068_g846_i0 | PRJEB6584 | 861 | 271 | 4.394068 | 11.90792428 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 79 | 5.49e-15 | NR | XP_025107195.1 | 400727 | g846 | i0 | 52.5 | 1.30627306273063 | 59 | 28 | 65.3 | 0 | 270 | 94 | 237 | 295 | XP_025107195.1 calcium/calmodulin-dependent protein kinase type 1-like [Pomacea canaliculata] | diamond | 354 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 33065953 | 33065953 | PRJEB6584o_S_NODE_2501_length_446_cov_15.233577_g2402_i0 | PRJEB6584 | 2501 | 446 | 15.233577 | 67.94175342 | Mytilus edulis | 6550 | Mollusca | Mollusca | 48.5 | 0.00291 | NR | CAG2212025.1 | 6550 | g2402 | i0 | 28.1 | 1.62107623318386 | 128 | 73 | 80.7 | 4 | 2 | 361 | 620 | 736 | CAG2212025.1 unnamed protein product [Mytilus edulis] | diamond | 723 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 33082942 | 33082942 | PRJEB6584o_S_NODE_15862_length_222_cov_108.155080_g15754_i0 | PRJEB6584 | 15862 | 222 | 108.15508 | 240.1042776 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 53.5 | 3.34e-6 | NR | XP_070205842.1 | 31220 | g15754 | i0 | 43.6 | 2.2027027027027 | 55 | 30 | 74.3 | 1 | 26 | 190 | 47 | 100 | XP_070205842.1 antistasin-like isoform X2 [Littorina saxatilis] | diamond | 489 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 33093892 | 33093892 | PRJEB6584h_S_NODE_14878_length_187_cov_330.901316_g14816_i0 | PRJEB6584 | 14878 | 187 | 330.901316 | 618.78546092 | Metazoa | 33208 | Mollusca | Mollusca | 57.8 | 8.97e-8 | NR | XP_052078890.1 | 6549 | g14816 | i0 | 87.1 | 3.48128342245989 | 31 | 4 | 49.7 | 0 | 38 | 130 | 1206 | 1236 | XP_052078890.1 eukaryotic translation initiation factor 5B-like [Mytilus californianus] | diamond | 651 | 58.2 | 0.993127147766323 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 33162051 | 33162051 | PRJEB6584o_S_NODE_2984_length_422_cov_10.051680_g2877_i0 | PRJEB6584 | 2984 | 422 | 10.05168 | 42.4180896 | Metazoa | 33208 | Mollusca | Mollusca | 126 | 9.53e-33 | NR | XP_052087583.1 | 6549 | g2877 | i0 | 72.8 | 3.94549763033175 | 81 | 22 | 57.6 | 0 | 4 | 246 | 175 | 255 | XP_052087583.1 40S ribosomal protein S4-like isoform X1 [Mytilus californianus] | diamond | 1665 | 127 | 0.992125984251969 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 33179280 | 33179280 | PRJEB6584o_S_NODE_10272_length_272_cov_6.953586_g10164_i0 | PRJEB6584 | 10272 | 272 | 6.953586 | 18.91375392 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 76.6 | 7.01e-16 | NR | XP_022317179.1 | 6565 | g10164 | i0 | 75.6 | 3.02205882352941 | 45 | 11 | 49.6 | 0 | 252 | 118 | 47 | 91 | XP_022317179.1 probable 60S ribosomal protein L37-A [Crassostrea virginica] | diamond | 822 | 77 | 0.994805194805195 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica |
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);;