contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA493828" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26633682 | 26633682 | PRJNA493828_P_NODE_28001_length_261_cov_3.335106_g27582_i0 | PRJNA493828 | 28001 | 261 | 3.335106 | 8.70462666 | Sinanodonta woodiana | 1069815 | Mollusca | Mollusca | 45.8 | 0.00377 | NR | KAL3846548.1 | 1069815 | g27582 | i0 | 52.1 | 0.551724137931034 | 48 | 21 | 52.9 | 2 | 25 | 162 | 377 | 424 | KAL3846548.1 hypothetical protein ACJMK2_017527 [Sinanodonta woodiana] | diamond | 144 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Sinanodonta | Sinanodonta woodiana | |
| 26902826 | 26902826 | PRJNA493828_P_NODE_32861_length_250_cov_0.870056_g32442_i0 | PRJNA493828 | 32861 | 250 | 0.870056 | 2.17514 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 129 | 1.52e-35 | NR | XP_063446337.1 | 6551 | g32442 | i0 | 79.5 | 15.936 | 83 | 17 | 99.6 | 0 | 1 | 249 | 15 | 97 | XP_063446337.1 small ribosomal subunit protein uS4 [Mytilus trossulus] | diamond | 3984 | 130 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 27393112 | 27393112 | PRJNA493828_P_NODE_35563_length_246_cov_1.774566_g35144_i0 | PRJNA493828 | 35563 | 246 | 1.774566 | 4.36543236 | Pinctada imbricata | 66713 | Mollusca | Mollusca | 99.4 | 2.18e-22 | NR | KAK3108822.1 | 66713 | g35144 | i0 | 52.5 | 1.95121951219512 | 80 | 38 | 97.6 | 0 | 245 | 6 | 94 | 173 | KAK3108822.1 hypothetical protein FSP39_016459 [Pinctada imbricata] | diamond | 480 | 99.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 27487728 | 27487728 | PRJNA493828_P_NODE_45383_length_216_cov_4.006993_g44964_i0 | PRJNA493828 | 45383 | 216 | 4.006993 | 8.65510488 | Argopecten irradians | 31199 | Mollusca | Mollusca | 43.1 | 0.0147 | NR | XP_069108365.1 | 31199 | g44964 | i0 | 45 | 0.555555555555556 | 40 | 21 | 55.6 | 1 | 203 | 84 | 11 | 49 | XP_069108365.1 uncharacterized protein [Argopecten irradians] | diamond | 120 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 27550687 | 27550687 | PRJNA493828_P_NODE_7164_length_417_cov_2.125000_g6753_i0 | PRJNA493828 | 7164 | 417 | 2.125 | 8.86125 | Mytilus edulis | 6550 | Mollusca | Mollusca | 103 | 1.18e-24 | NR | CAG2185356.1 | 6550 | g6753 | i0 | 38.1 | 1 | 139 | 82 | 99.3 | 3 | 2 | 415 | 18 | 153 | CAG2185356.1 unnamed protein product [Mytilus edulis] | diamond | 417 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 27929742 | 27929742 | PRJNA493828_P_NODE_18065_length_296_cov_2.192825_g17646_i0 | PRJNA493828 | 18065 | 296 | 2.192825 | 6.490762 | Mytilus galloprovincialis | 29158 | Mollusca | Mollusca | 62.8 | 1.92e-9 | NR | VDI11545.1 | 29158 | g17646 | i0 | 44.1 | 2.39189189189189 | 59 | 33 | 59.8 | 0 | 113 | 289 | 3 | 61 | VDI11545.1 Hypothetical predicted protein [Mytilus galloprovincialis] | diamond | 708 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus galloprovincialis | |
| 28687781 | 28687781 | PRJNA493828_P_NODE_35107_length_247_cov_0.885057_g34688_i0 | PRJNA493828 | 35107 | 247 | 0.885057 | 2.18609079 | Ostrea edulis | 37623 | Mollusca | Mollusca | 96.7 | 4.28e-21 | NR | XP_048741889.2 | 37623 | g34688 | i0 | 60.3 | 8.55060728744939 | 78 | 31 | 94.7 | 0 | 1 | 234 | 922 | 999 | XP_048741889.2 ubiquitin-like modifier-activating enzyme 1 isoform X3 [Ostrea edulis] | diamond | 2112 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 29919069 | 29919069 | PRJNA493828_P_NODE_34971_length_247_cov_0.954023_g34552_i0 | PRJNA493828 | 34971 | 247 | 0.954023 | 2.35643681 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 62.8 | 3.38e-9 | NR | XP_041377266.1 | 1735272 | g34552 | i0 | 36.6 | 7.04453441295547 | 82 | 48 | 94.7 | 1 | 14 | 247 | 80 | 161 | XP_041377266.1 uncharacterized protein LOC121389682 [Gigantopelta aegis] | diamond | 1740 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 30013788 | 30013788 | PRJNA493828_P_NODE_16631_length_307_cov_1.512821_g16212_i0 | PRJNA493828 | 16631 | 307 | 1.512821 | 4.64436047 | Physella acuta | 109671 | Mollusca | Mollusca | 55.8 | 1.9e-6 | NR | XP_059141207.1 | 109671 | g16212 | i0 | 39.4 | 1.8371335504886 | 94 | 55 | 90.9 | 2 | 279 | 1 | 228 | 320 | XP_059141207.1 uncharacterized protein LOC131929040 [Physella acuta] | diamond | 564 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 30234845 | 30234845 | PRJNA493828_P_NODE_2372_length_688_cov_2.417886_g2032_i0 | PRJNA493828 | 2372 | 688 | 2.417886 | 16.63505568 | Argopecten irradians | 31199 | Mollusca | Mollusca | 112 | 1.37e-24 | NR | XP_069137814.1 | 31199 | g2032 | i0 | 47.2 | 1.03343023255814 | 125 | 57 | 54.5 | 4 | 586 | 212 | 15 | 130 | XP_069137814.1 uncharacterized protein [Argopecten irradians] | diamond | 711 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 30866703 | 30866703 | PRJNA493828_P_NODE_39674_length_241_cov_0.916667_g39255_i0 | PRJNA493828 | 39674 | 241 | 0.916667 | 2.20916747 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 56.2 | 6.46e-7 | NR | XP_070209272.1 | 31220 | g39255 | i0 | 43.4 | 0.946058091286307 | 76 | 41 | 93.4 | 2 | 225 | 1 | 17 | 91 | XP_070209272.1 uncharacterized protein [Littorina saxatilis] | diamond | 228 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 31514857 | 31514857 | PRJNA493828_P_NODE_44856_length_220_cov_5.333333_g44437_i0 | PRJNA493828 | 44856 | 220 | 5.333333 | 11.7333326 | Myida | 278205 | Mollusca | Mollusca | 61.2 | 1.13e-9 | NR | WAR01585.1 | 6604 | g44437 | i0 | 73 | 5.30454545454545 | 37 | 10 | 50.5 | 0 | 6 | 116 | 98 | 134 | WAR01585.1 LZTR1-like protein [Mya arenaria] | diamond | 1167 | 61.6 | 0.993506493506494 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 31609545 | 31609545 | PRJNA493828_P_NODE_12876_length_324_cov_10.406375_g12457_i0 | PRJNA493828 | 12876 | 324 | 10.406375 | 33.716655 | Metazoa | 33208 | Mollusca | Mollusca | 52.4 | 3.73e-6 | NR | KAH9489076.1 | 55810 | g12457 | i0 | 53.2 | 4 | 47 | 22 | 43.5 | 0 | 94 | 234 | 35 | 81 | KAH9489076.1 hypothetical protein Btru_057716 [Bulinus truncatus] | diamond | 1296 | 52.8 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Bulinus | Bulinus truncatus | ||
| 31656962 | 31656962 | PRJNA493828_P_NODE_27757_length_262_cov_2.095238_g27338_i0 | PRJNA493828 | 27757 | 262 | 2.095238 | 5.48952356 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 40.4 | 0.0418 | NR | KAH3706159.1 | 45954 | g27338 | i0 | 47.1 | 0.389312977099237 | 34 | 18 | 38.9 | 0 | 48 | 149 | 32 | 65 | KAH3706159.1 hypothetical protein DPMN_065539 [Dreissena polymorpha] | diamond | 102 | 40.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 32163503 | 32163503 | PRJNA493828_P_NODE_8838_length_380_cov_1.000000_g8422_i0 | PRJNA493828 | 8838 | 380 | 1 | 3.8 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 121 | 2.13e-31 | NR | XP_021368105.1 | 6573 | g8422 | i0 | 45.5 | 2.03684210526316 | 132 | 66 | 99.5 | 1 | 1 | 378 | 62 | 193 | XP_021368105.1 uncharacterized protein K02A2.6-like [Mizuhopecten yessoensis] | diamond | 774 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 32432187 | 32432187 | PRJNA493828_P_NODE_17559_length_299_cov_9.000000_g17140_i0 | PRJNA493828 | 17559 | 299 | 9 | 26.91 | Metazoa | 33208 | Mollusca | Mollusca | 117 | 1.97e-30 | NR | WAR22791.1 | 6604 | g17140 | i0 | 79.4 | 42.3411371237458 | 68 | 14 | 68.2 | 0 | 71 | 274 | 149 | 216 | WAR22791.1 RS12-like protein [Mya arenaria] | diamond | 12660 | 118 | 0.991525423728814 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria |
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);;