contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA981359" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16266479 | 16266479 | PRJNA981359_S_NODE_9533_length_424_cov_4.133903_g9433_i0 | PRJNA981359 | 9533 | 424 | 4.133903 | 17.52774872 | Ostrea edulis | 37623 | Mollusca | Mollusca | 63.9 | 6.79e-9 | NR | XP_048752590.2 | 37623 | g9433 | i0 | 45.6 | 1.27358490566038 | 90 | 38 | 60.1 | 2 | 256 | 2 | 1 | 84 | XP_048752590.2 CD2 antigen cytoplasmic tail-binding protein 2-like isoform X2 [Ostrea edulis] | diamond | 540 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 25188580 | 25188580 | PRJNA981359_S_NODE_35280_length_313_cov_4.825000_g35180_i0 | PRJNA981359 | 35280 | 313 | 4.825 | 15.10225 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 79.7 | 9.12e-15 | NR | XP_045180553.2 | 6596 | g35180 | i0 | 55.4 | 1.24600638977636 | 65 | 29 | 62.3 | 0 | 204 | 10 | 94 | 158 | XP_045180553.2 uncharacterized protein K02A2.6-like [Mercenaria mercenaria] | diamond | 390 | 79.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 26677825 | 26677825 | PRJNA981359_S_NODE_32681_length_320_cov_2.627530_g32581_i0 | PRJNA981359 | 32681 | 320 | 2.62753 | 8.408096 | Pinctada imbricata | 66713 | Mollusca | Mollusca | 48.9 | 6.26e-4 | NR | KAK3099864.1 | 66713 | g32581 | i0 | 58.5 | 1.153125 | 41 | 17 | 38.4 | 0 | 29 | 151 | 606 | 646 | KAK3099864.1 hypothetical protein FSP39_010887 [Pinctada imbricata] | diamond | 369 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 26994400 | 26994400 | PRJNA981359_S_NODE_31722_length_323_cov_1.536000_g31622_i0 | PRJNA981359 | 31722 | 323 | 1.536 | 4.96128 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 88.6 | 8.03e-18 | NR | XP_055871668.1 | 6526 | g31622 | i0 | 67.9 | 4.64396284829721 | 56 | 18 | 52 | 0 | 242 | 75 | 1179 | 1234 | XP_055871668.1 uncharacterized protein LOC129923663 [Biomphalaria glabrata] | diamond | 1500 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 27000483 | 27000483 | PRJNA981359_S_NODE_35422_length_313_cov_2.600000_g35322_i0 | PRJNA981359 | 35422 | 313 | 2.6 | 8.138 | Metazoa | 33208 | Mollusca | Mollusca | 48.1 | 0.00111 | NR | WAR13570.1 | 6604 | g35322 | i0 | 55.1 | 2.3482428115016 | 49 | 21 | 47 | 1 | 219 | 73 | 370 | 417 | WAR13570.1 hypothetical protein MAR_027750 [Mya arenaria] | diamond | 735 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 27215748 | 27215748 | PRJNA981359_S_NODE_50562_length_279_cov_3.305825_g50462_i0 | PRJNA981359 | 50562 | 279 | 3.305825 | 9.22325175 | Pinctada imbricata | 66713 | Mollusca | Mollusca | 55.1 | 2.78e-6 | NR | KAK3092425.1 | 66713 | g50462 | i0 | 51 | 1.58064516129032 | 49 | 23 | 52.7 | 1 | 49 | 195 | 127 | 174 | KAK3092425.1 hypothetical protein FSP39_002670 [Pinctada imbricata] | diamond | 441 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 27563161 | 27563161 | PRJNA981359_S_NODE_67284_length_249_cov_2.278409_g67184_i0 | PRJNA981359 | 67284 | 249 | 2.278409 | 5.67323841 | Pinctada imbricata | 66713 | Mollusca | Mollusca | 52.4 | 1.62e-5 | NR | KAK3105198.1 | 66713 | g67184 | i0 | 42.1 | 2.66265060240964 | 57 | 33 | 68.7 | 0 | 66 | 236 | 814 | 870 | KAK3105198.1 hypothetical protein FSP39_019583 [Pinctada imbricata] | diamond | 663 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 27664361 | 27664361 | PRJNA981359_S_NODE_2004_length_646_cov_10.565445_g1915_i0 | PRJNA981359 | 2004 | 646 | 10.565445 | 68.2527747 | Metazoa | 33208 | Mollusca | Mollusca | 129 | 1.5899999999999998e-31 | NR | XP_045171831.2 | 6596 | g1915 | i0 | 42.6 | 6.90557275541796 | 195 | 92 | 83.1 | 5 | 5 | 541 | 177 | 367 | XP_045171831.2 GPN-loop GTPase 1-like [Mercenaria mercenaria] | diamond | 4461 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 27973904 | 27973904 | PRJNA981359_S_NODE_42805_length_296_cov_1.672646_g42705_i0 | PRJNA981359 | 42805 | 296 | 1.672646 | 4.95103216 | Mytilus galloprovincialis | 29158 | Mollusca | Mollusca | 85.5 | 1.56e-17 | NR | VDI07802.1 | 29158 | g42705 | i0 | 48.8 | 0.831081081081081 | 82 | 41 | 83.1 | 1 | 292 | 47 | 159 | 239 | VDI07802.1 4'-phosphopantetheinyl transferase [Mytilus galloprovincialis] | diamond | 246 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus galloprovincialis | |
| 28422145 | 28422145 | PRJNA981359_S_NODE_55626_length_269_cov_2.785714_g55526_i0 | PRJNA981359 | 55626 | 269 | 2.785714 | 7.49357066 | Metazoa | 33208 | Mollusca | Mollusca | 51.2 | 5.34e-5 | NR | CAC5403501.1 | 42192 | g55526 | i0 | 69.7 | 3.42379182156134 | 33 | 10 | 36.8 | 0 | 107 | 9 | 842 | 874 | CAC5403501.1 unnamed protein product [Mytilus coruscus] | diamond | 921 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 28510682 | 28510682 | PRJNA981359_S_NODE_31167_length_324_cov_2.796813_g31067_i0 | PRJNA981359 | 31167 | 324 | 2.796813 | 9.06167412 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 67.4 | 2.1e-10 | NR | KAK7090700.1 | 31220 | g31067 | i0 | 44.4 | 7.5 | 81 | 45 | 75 | 0 | 16 | 258 | 230 | 310 | KAK7090700.1 hypothetical protein V1264_010462 [Littorina saxatilis] | diamond | 2430 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 28605383 | 28605383 | PRJNA981359_S_NODE_14147_length_389_cov_2.715190_g14047_i0 | PRJNA981359 | 14147 | 389 | 2.71519 | 10.5620891 | Solemya velum | 13268 | Mollusca | Mollusca | 121 | 4.65e-29 | NR | KAL5010020.1 | 13268 | g14047 | i0 | 52.9 | 0.802056555269923 | 104 | 49 | 80.2 | 0 | 315 | 4 | 140 | 243 | KAL5010020.1 hypothetical protein ScPMuIL_012325 [Solemya velum] | diamond | 312 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 28737754 | 28737754 | PRJNA981359_S_NODE_58827_length_263_cov_2.347368_g58727_i0 | PRJNA981359 | 58827 | 263 | 2.347368 | 6.17357784 | Biomphalaria | 6525 | Mollusca | Mollusca | 43.1 | 0.0349 | NR | XP_013077315.2 | 6526 | g58727 | i0 | 45.1 | 1.16349809885932 | 51 | 28 | 58.2 | 0 | 247 | 95 | 570 | 620 | XP_013077315.2 uncharacterized protein LOC106063478 [Biomphalaria glabrata] | diamond | 306 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 30063823 | 30063823 | PRJNA981359_S_NODE_75611_length_232_cov_2.943396_g75511_i0 | PRJNA981359 | 75611 | 232 | 2.943396 | 6.82867872 | Metazoa | 33208 | Mollusca | Mollusca | 50.1 | 3.17e-5 | NR | CAE1304774.1 | 158019 | g75511 | i0 | 74.3 | 4.08620689655172 | 35 | 9 | 45.3 | 0 | 2 | 106 | 59 | 93 | CAE1304774.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 948 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 30374285 | 30374285 | PRJNA981359_S_NODE_28032_length_333_cov_2.450000_g27932_i0 | PRJNA981359 | 28032 | 333 | 2.45 | 8.1585 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 43.9 | 0.0431 | NR | XP_021341230.1 | 6573 | g27932 | i0 | 30.4 | 2.52252252252252 | 56 | 39 | 50.5 | 0 | 245 | 78 | 1311 | 1366 | XP_021341230.1 E3 ubiquitin-protein ligase HUWE1-like isoform X4 [Mizuhopecten yessoensis] | diamond | 840 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 30658214 | 30658214 | PRJNA981359_S_NODE_51133_length_278_cov_2.663415_g51033_i0 | PRJNA981359 | 51133 | 278 | 2.663415 | 7.4042937 | Argopecten irradians | 31199 | Mollusca | Mollusca | 44.7 | 0.0108 | NR | XP_069122448.1 | 31199 | g51033 | i0 | 59.4 | 0.345323741007194 | 32 | 13 | 34.5 | 0 | 274 | 179 | 245 | 276 | XP_069122448.1 uncharacterized protein [Argopecten irradians] | diamond | 96 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 31732907 | 31732907 | PRJNA981359_S_NODE_50137_length_280_cov_2.637681_g50037_i0 | PRJNA981359 | 50137 | 280 | 2.637681 | 7.3855068 | Argopecten irradians | 31199 | Mollusca | Mollusca | 47.8 | 9.63e-4 | NR | XP_069119330.1 | 31199 | g50037 | i0 | 41.4 | 0.621428571428571 | 58 | 34 | 62.1 | 0 | 255 | 82 | 334 | 391 | XP_069119330.1 uncharacterized protein [Argopecten irradians] | diamond | 174 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 31770630 | 31770630 | PRJNA981359_S_NODE_24657_length_343_cov_3.755556_g24557_i0 | PRJNA981359 | 24657 | 343 | 3.755556 | 12.88155708 | root | 1 | Root_unresolved | Root_unresolved | 58.9 | 7.6e-8 | NR | BFY97907.1 | 145626 | g24557 | i0 | 46.8 | 2.17784256559767 | 62 | 25 | 54.2 | 2 | 191 | 6 | 19 | 72 | BFY97907.1 hypothetical protein BsWGS_00947 [Bradybaena similaris] | diamond | 747 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 32017743 | 32017743 | PRJNA981359_S_NODE_52578_length_275_cov_3.029703_g52478_i0 | PRJNA981359 | 52578 | 275 | 3.029703 | 8.33168325 | Haliotis asinina | 109174 | Mollusca | Mollusca | 48.5 | 4.9e-4 | NR | XP_067671808.1 | 109174 | g52478 | i0 | 33 | 1.42909090909091 | 88 | 51 | 87.3 | 2 | 28 | 267 | 172 | 259 | XP_067671808.1 uncharacterized protein [Haliotis asinina] | diamond | 393 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina |
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);;