contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA1249042" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1629168 | 1629168 | PRJNA1249042_S_NODE_31222_length_239_cov_1.852041_g31008_i0 | PRJNA1249042 | 31222 | 239 | 1.852041 | 4.42637799 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 107 | 2.23e-26 | NR | XP_052242652.1 | 45954 | g31008 | i0 | 78.3 | 4.7071129707113 | 60 | 13 | 75.3 | 0 | 223 | 44 | 192 | 251 | XP_052242652.1 peroxiredoxin-like [Dreissena polymorpha] | diamond | 1125 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 27136424 | 27136424 | PRJNA1249042_S_NODE_18922_length_267_cov_4.343750_g18708_i0 | PRJNA1249042 | 18922 | 267 | 4.34375 | 11.5978125 | Haliotis asinina | 109174 | Mollusca | Mollusca | 45.1 | 0.00726 | NR | XP_067660915.1 | 109174 | g18708 | i0 | 36.2 | 0.775280898876405 | 69 | 38 | 76.4 | 2 | 241 | 38 | 144 | 207 | XP_067660915.1 uncharacterized protein [Haliotis asinina] | diamond | 207 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 27136437 | 27136437 | PRJNA1249042_S_NODE_87002_length_172_cov_1.093023_g86788_i0 | PRJNA1249042 | 87002 | 172 | 1.093023 | 1.87999956 | Mytilus edulis | 6550 | Mollusca | Mollusca | 43.5 | 0.00763 | NR | CAG2223255.1 | 6550 | g86788 | i0 | 41 | 4.5 | 39 | 23 | 68 | 0 | 120 | 4 | 174 | 212 | CAG2223255.1 unnamed protein product [Mytilus edulis] | diamond | 774 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 27263389 | 27263389 | PRJNA1249042_S_NODE_31483_length_238_cov_3.133333_g31269_i0 | PRJNA1249042 | 31483 | 238 | 3.133333 | 7.45733254 | Elysia crispata | 231223 | Mollusca | Mollusca | 47.8 | 6.01e-4 | NR | KAK3797696.1 | 231223 | g31269 | i0 | 39.8 | 1.10924369747899 | 88 | 30 | 81.9 | 4 | 2 | 196 | 321 | 408 | KAK3797696.1 hypothetical protein RRG08_054714 [Elysia crispata] | diamond | 264 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia crispata | ||
| 27358306 | 27358306 | PRJNA1249042_S_NODE_34363_length_233_cov_2.510526_g34149_i0 | PRJNA1249042 | 34363 | 233 | 2.510526 | 5.84952558 | Lottia gigantea | 225164 | Mollusca | Mollusca | 50.8 | 3.48e-5 | NR | XP_009058848.1 | 225164 | g34149 | i0 | 42.1 | 1.82832618025751 | 76 | 37 | 92.7 | 3 | 232 | 17 | 126 | 198 | XP_009058848.1 hypothetical protein LOTGIDRAFT_123325, partial [Lottia gigantea] | diamond | 426 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 28273661 | 28273661 | PRJNA1249042_S_NODE_62366_length_195_cov_2.921053_g62152_i0 | PRJNA1249042 | 62366 | 195 | 2.921053 | 5.69605335 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 45.1 | 0.00315 | NR | XP_052249965.1 | 45954 | g62152 | i0 | 40.4 | 2.16923076923077 | 47 | 28 | 72.3 | 0 | 55 | 195 | 982 | 1028 | XP_052249965.1 uncharacterized protein LOC127857563 isoform X1 [Dreissena polymorpha] | diamond | 423 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 28589699 | 28589699 | PRJNA1249042_S_NODE_48907_length_211_cov_2.797619_g48693_i0 | PRJNA1249042 | 48907 | 211 | 2.797619 | 5.90297609 | Argopecten irradians | 31199 | Mollusca | Mollusca | 44.7 | 0.00501 | NR | XP_069103066.1 | 31199 | g48693 | i0 | 61.3 | 2.58767772511848 | 31 | 12 | 44.1 | 0 | 117 | 209 | 574 | 604 | XP_069103066.1 zinc finger BED domain-containing protein 4-like [Argopecten irradians] | diamond | 546 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 29347400 | 29347400 | PRJNA1249042_S_NODE_100829_length_161_cov_1.194915_g100615_i0 | PRJNA1249042 | 100829 | 161 | 1.194915 | 1.92381315 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 41.2 | 0.00901 | NR | BFZ08107.1 | 145626 | g100615 | i0 | 73.9 | 0.857142857142857 | 23 | 4 | 39.1 | 1 | 75 | 13 | 23 | 45 | BFZ08107.1 hypothetical protein BsWGS_11146 [Bradybaena similaris] | diamond | 138 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 30610638 | 30610638 | PRJNA1249042_S_NODE_40413_length_223_cov_3.133333_g40199_i0 | PRJNA1249042 | 40413 | 223 | 3.133333 | 6.98733259 | Ostrea edulis | 37623 | Mollusca | Mollusca | 47.8 | 4.96e-4 | NR | XP_048776654.2 | 37623 | g40199 | i0 | 33.8 | 0.914798206278027 | 68 | 45 | 91.5 | 0 | 10 | 213 | 273 | 340 | XP_048776654.2 probable G-protein coupled receptor No18 [Ostrea edulis] | diamond | 204 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 30768845 | 30768845 | PRJNA1249042_S_NODE_98954_length_162_cov_1.806723_g98740_i0 | PRJNA1249042 | 98954 | 162 | 1.806723 | 2.92689126 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 41.2 | 0.0458 | NR | XP_022345146.1 | 6565 | g98740 | i0 | 48.7 | 0.722222222222222 | 39 | 20 | 72.2 | 0 | 40 | 156 | 843 | 881 | XP_022345146.1 uncharacterized protein LOC111137788 isoform X1 [Crassostrea virginica] | diamond | 117 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 30863466 | 30863466 | PRJNA1249042_S_NODE_45114_length_216_cov_3.803468_g44900_i0 | PRJNA1249042 | 45114 | 216 | 3.803468 | 8.21549088 | Lottia gigantea | 225164 | Mollusca | Mollusca | 45.8 | 1.79e-4 | NR | XP_009057813.1 | 225164 | g44900 | i0 | 39.6 | 0.736111111111111 | 53 | 28 | 70.8 | 2 | 64 | 216 | 6 | 56 | XP_009057813.1 hypothetical protein LOTGIDRAFT_76338, partial [Lottia gigantea] | diamond | 159 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 31134042 | 31134042 | PRJNA1249042_S_NODE_8795_length_319_cov_2.554348_g8581_i0 | PRJNA1249042 | 8795 | 319 | 2.554348 | 8.14837012 | Metazoa | 33208 | Mollusca | Mollusca | 80.1 | 9.85e-16 | NR | XP_045170159.2 | 6596 | g8581 | i0 | 41.1 | 5.07836990595611 | 90 | 51 | 82.8 | 1 | 317 | 54 | 114 | 203 | XP_045170159.2 uncharacterized protein LOC123532688 [Mercenaria mercenaria] | diamond | 1620 | 80.5 | 0.995031055900621 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 31305898 | 31305898 | PRJNA1249042_S_NODE_30215_length_241_cov_1.893939_g30001_i0 | PRJNA1249042 | 30215 | 241 | 1.893939 | 4.56439299 | Mytilus galloprovincialis | 29158 | Mollusca | Mollusca | 45.8 | 2.37e-4 | NR | VDI83095.1 | 29158 | g30001 | i0 | 45.3 | 0.659751037344398 | 53 | 23 | 58.5 | 1 | 231 | 91 | 3 | 55 | VDI83095.1 Hypothetical predicted protein, partial [Mytilus galloprovincialis] | diamond | 159 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus galloprovincialis | |
| 31323933 | 31323933 | PRJNA1249042_S_NODE_91895_length_167_cov_4.774194_g91681_i0 | PRJNA1249042 | 91895 | 167 | 4.774194 | 7.97290398 | Ostreidae | 6563 | Mollusca | Mollusca | 50.4 | 2.54e-5 | NR | XP_061174960.1 | 191078 | g91681 | i0 | 56.3 | 1.72455089820359 | 48 | 17 | 86.2 | 1 | 167 | 24 | 504 | 547 | XP_061174960.1 zinc finger MIZ domain-containing protein 1-like isoform X2 [Saccostrea echinata] | diamond | 288 | 50.8 | 0.992125984251969 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 31717130 | 31717130 | PRJNA1249042_S_NODE_10757_length_303_cov_2.838462_g10543_i0 | PRJNA1249042 | 10757 | 303 | 2.838462 | 8.60053986 | Elysia marginata | 1093978 | Mollusca | Mollusca | 62 | 1.15e-8 | NR | GFR79436.1 | 1093978 | g10543 | i0 | 52.3 | 1.28712871287129 | 65 | 29 | 62.4 | 2 | 265 | 77 | 112 | 176 | GFR79436.1 hypothetical protein ElyMa_005874900 [Elysia marginata] | diamond | 390 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 31812090 | 31812090 | PRJNA1249042_S_NODE_88957_length_170_cov_1.677165_g88743_i0 | PRJNA1249042 | 88957 | 170 | 1.677165 | 2.8511805 | Candidula unifasciata | 100452 | Mollusca | Mollusca | 50.1 | 2.59e-5 | NR | CAG5117123.1 | 100452 | g88743 | i0 | 61.3 | 0.547058823529412 | 31 | 12 | 54.7 | 0 | 56 | 148 | 82 | 112 | CAG5117123.1 unnamed protein product, partial [Candidula unifasciata] | diamond | 93 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata |
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);;