contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA638138" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5712904 | 5712904 | PRJNA638138_P_NODE_14025_length_290_cov_1.419355_g13810_i0 | PRJNA638138 | 14025 | 290 | 1.419355 | 4.1161295 | Pectinidae | 6566 | Mollusca | Mollusca | 154 | 1.16e-46 | NR | XP_021365005.1 | 6573 | g13810 | i0 | 85.9 | 4.32413793103448 | 85 | 12 | 87.9 | 0 | 8 | 262 | 18 | 102 | XP_021365005.1 40S ribosomal protein S21-like [Mizuhopecten yessoensis] | diamond | 1254 | 155 | 0.993548387096774 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 6988097 | 6988097 | PRJNA638138_P_NODE_9306_length_340_cov_1.112360_g9091_i0 | PRJNA638138 | 9306 | 340 | 1.11236 | 3.782024 | Magallana gigas | 29159 | Mollusca | Mollusca | 167 | 3.79e-51 | NR | XP_011442817.1 | 29159 | g9091 | i0 | 89.4 | 0.997058823529412 | 113 | 10 | 98.8 | 2 | 340 | 5 | 4 | 115 | XP_011442817.1 small ribosomal subunit protein eS25 [Magallana gigas] | diamond | 339 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 8262655 | 8262655 | PRJNA638138_P_NODE_27247_length_246_cov_0.890173_g27032_i0 | PRJNA638138 | 27247 | 246 | 0.890173 | 2.18982558 | Pinctada | 50425 | Mollusca | Mollusca | 153 | 1.22e-44 | NR | AAN85578.1 | 50426 | g27032 | i0 | 92.5 | 1.95121951219512 | 80 | 6 | 97.6 | 0 | 244 | 5 | 125 | 204 | AAN85578.1 QM protein [Pinctada fucata] | diamond | 480 | 153 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada fucata | |
| 12088706 | 12088706 | PRJNA638138_P_NODE_17130_length_265_cov_2.005208_g16915_i0 | PRJNA638138 | 17130 | 265 | 2.005208 | 5.3138012 | Ostrea edulis | 37623 | Mollusca | Mollusca | 145 | 5.05e-42 | NR | XP_048773811.1 | 37623 | g16915 | i0 | 79.5 | 2.98867924528302 | 88 | 18 | 99.6 | 0 | 2 | 265 | 2 | 89 | XP_048773811.1 60S ribosomal protein L9-like [Ostrea edulis] | diamond | 792 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 13363465 | 13363465 | PRJNA638138_P_NODE_15431_length_279_cov_1.121359_g15216_i0 | PRJNA638138 | 15431 | 279 | 1.121359 | 3.12859161 | Metazoa | 33208 | Mollusca | Mollusca | 141 | 4.3e-39 | NR | AFS50755.1 | 13268 | g15216 | i0 | 75.3 | 11 | 93 | 20 | 100 | 1 | 1 | 279 | 114 | 203 | AFS50755.1 elongation factor 1 alpha, partial [Solemya velum] | diamond | 3069 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 18461391 | 18461391 | PRJNA638138_P_NODE_17875_length_260_cov_1.470588_g17660_i0 | PRJNA638138 | 17875 | 260 | 1.470588 | 3.8235288 | Bivalvia | 6544 | Mollusca | Mollusca | 102 | 1.54e-26 | NR | OWF50552.1 | 6573 | g17660 | i0 | 100 | 1.17692307692308 | 50 | 0 | 57.7 | 0 | 7 | 156 | 31 | 80 | OWF50552.1 60S ribosomal protein L39 [Mizuhopecten yessoensis] | diamond | 306 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 23562180 | 23562180 | PRJNA638138_P_NODE_8459_length_352_cov_1.103943_g8244_i0 | PRJNA638138 | 8459 | 352 | 1.103943 | 3.88587936 | Argopecten irradians | 31199 | Mollusca | Mollusca | 187 | 1.92e-58 | NR | XP_069129600.1 | 31199 | g8244 | i0 | 77.2 | 4.91761363636364 | 114 | 26 | 97.2 | 0 | 349 | 8 | 22 | 135 | XP_069129600.1 large ribosomal subunit protein eL21-like [Argopecten irradians] | diamond | 1731 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 27428908 | 27428908 | PRJNA638138_P_NODE_33843_length_242_cov_0.911243_g33628_i0 | PRJNA638138 | 33843 | 242 | 0.911243 | 2.20520806 | Elysia marginata | 1093978 | Mollusca | Mollusca | 54.3 | 2.7e-6 | NR | GFS00228.1 | 1093978 | g33628 | i0 | 46.7 | 1.11570247933884 | 45 | 24 | 55.8 | 0 | 145 | 11 | 194 | 238 | GFS00228.1 Pol polyprotein [Elysia marginata] | diamond | 270 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 27725662 | 27725662 | PRJNA638138_P_NODE_16004_length_274_cov_1.532338_g15789_i0 | PRJNA638138 | 16004 | 274 | 1.532338 | 4.19860612 | Bivalvia | 6544 | Mollusca | Mollusca | 142 | 9.59e-41 | NR | XP_033745912.1 | 6579 | g15789 | i0 | 84.8 | 2.59489051094891 | 79 | 12 | 86.5 | 0 | 2 | 238 | 98 | 176 | XP_033745912.1 60S ribosomal protein L18a-like [Pecten maximus] | diamond | 711 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 28375798 | 28375798 | PRJNA638138_P_NODE_35926_length_241_cov_0.916667_g35711_i0 | PRJNA638138 | 35926 | 241 | 0.916667 | 2.20916747 | Pinctada imbricata | 66713 | Mollusca | Mollusca | 52.4 | 1.43e-5 | NR | KAK3093097.1 | 66713 | g35711 | i0 | 77.8 | 0.448132780082988 | 36 | 7 | 44.8 | 1 | 3 | 110 | 250 | 284 | KAK3093097.1 hypothetical protein FSP39_011036 [Pinctada imbricata] | diamond | 108 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 28735660 | 28735660 | PRJNA638138_P_NODE_33507_length_242_cov_0.911243_g33292_i0 | PRJNA638138 | 33507 | 242 | 0.911243 | 2.20520806 | Ostreidae | 6563 | Mollusca | Mollusca | 48.1 | 4.26e-4 | NR | XP_011433036.3 | 29159 | g33292 | i0 | 38.3 | 2.02066115702479 | 81 | 44 | 99.2 | 2 | 1 | 240 | 47 | 122 | XP_011433036.3 NADH-ubiquinone oxidoreductase 20 kDa subunit [Magallana gigas] | diamond | 489 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 28817571 | 28817571 | PRJNA638138_P_NODE_15748_length_276_cov_1.517241_g15533_i0 | PRJNA638138 | 15748 | 276 | 1.517241 | 4.18758516 | Ostrea edulis | 37623 | Mollusca | Mollusca | 162 | 6.49e-49 | NR | AFJ91753.1 | 37623 | g15533 | i0 | 84.6 | 1.97826086956522 | 91 | 14 | 98.9 | 0 | 3 | 275 | 37 | 127 | AFJ91753.1 ribosomal protein L18, partial [Ostrea edulis] | diamond | 546 | 162 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 29020111 | 29020111 | PRJNA638138_P_NODE_15548_length_278_cov_1.126829_g15333_i0 | PRJNA638138 | 15548 | 278 | 1.126829 | 3.13258462 | Bivalvia | 6544 | Mollusca | Mollusca | 102 | 3.9e-24 | NR | OWF44472.1 | 6573 | g15333 | i0 | 50.5 | 2.94604316546763 | 91 | 45 | 98.2 | 0 | 274 | 2 | 61 | 151 | OWF44472.1 Sphingomyelin synthase-related protein 1 [Mizuhopecten yessoensis] | diamond | 819 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 29764971 | 29764971 | PRJNA638138_P_NODE_22531_length_249_cov_0.875000_g22316_i0 | PRJNA638138 | 22531 | 249 | 0.875 | 2.17875 | Tegillarca granosa | 220873 | Mollusca | Mollusca | 72 | 4.08e-14 | NR | KAJ8320407.1 | 220873 | g22316 | i0 | 81 | 1.01204819277108 | 42 | 8 | 50.6 | 0 | 3 | 128 | 67 | 108 | KAJ8320407.1 hypothetical protein KUTeg_001994 [Tegillarca granosa] | diamond | 252 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Tegillarca | Tegillarca granosa | |
| 30504278 | 30504278 | PRJNA638138_P_NODE_28773_length_245_cov_0.895349_g28558_i0 | PRJNA638138 | 28773 | 245 | 0.895349 | 2.19360505 | Bivalvia | 6544 | Mollusca | Mollusca | 55.1 | 1.73e-6 | NR | XP_053372623.1 | 6596 | g28558 | i0 | 49.1 | 2.33877551020408 | 57 | 28 | 69.8 | 1 | 74 | 244 | 753 | 808 | XP_053372623.1 nodal modulator 2-like [Mercenaria mercenaria] | diamond | 573 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 30693785 | 30693785 | PRJNA638138_P_NODE_29913_length_244_cov_0.900585_g29698_i0 | PRJNA638138 | 29913 | 244 | 0.900585 | 2.1974274 | Lepetellida | 2315723 | Mollusca | Mollusca | 103 | 1.5099999999999998e-23 | NR | KAK6178302.1 | 87958 | g29698 | i0 | 61.7 | 1.99180327868852 | 81 | 31 | 99.6 | 0 | 2 | 244 | 571 | 651 | KAK6178302.1 hypothetical protein SNE40_013103 [Patella caerulea] | diamond | 486 | 104 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 31756142 | 31756142 | PRJNA638138_P_NODE_32337_length_243_cov_0.905882_g32122_i0 | PRJNA638138 | 32337 | 243 | 0.905882 | 2.20129326 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 68.6 | 3.12e-11 | NR | BFY97169.1 | 145626 | g32122 | i0 | 42.7 | 4.03703703703704 | 82 | 46 | 100 | 1 | 1 | 243 | 41 | 122 | BFY97169.1 hypothetical protein BsWGS_00209 [Bradybaena similaris] | diamond | 981 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 31914325 | 31914325 | PRJNA638138_P_NODE_30237_length_244_cov_0.900585_g30022_i0 | PRJNA638138 | 30237 | 244 | 0.900585 | 2.1974274 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 75.9 | 8.3e-14 | NR | KAK7093131.1 | 31220 | g30022 | i0 | 47.6 | 2.76639344262295 | 84 | 36 | 93.4 | 1 | 8 | 235 | 292 | 375 | KAK7093131.1 hypothetical protein V1264_008778 [Littorina saxatilis] | diamond | 675 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 32338371 | 32338371 | PRJNA638138_P_NODE_29639_length_245_cov_0.895349_g29424_i0 | PRJNA638138 | 29639 | 245 | 0.895349 | 2.19360505 | Opisthokonta | 33154 | Mollusca | Mollusca | 52 | 2.06e-5 | NR | XP_052065948.1 | 6549 | g29424 | i0 | 50 | 14.5224489795918 | 46 | 23 | 56.3 | 0 | 167 | 30 | 175 | 220 | XP_052065948.1 actin nucleation-promoting factor WASL-like isoform X2 [Mytilus californianus] | diamond | 3558 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus |
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);;