contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA473641" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2995442 | 2995442 | PRJNA473641_P_NODE_12063_length_295_cov_1.040541_g11980_i0 | PRJNA473641 | 12063 | 295 | 1.040541 | 3.06959595 | Metazoa | 33208 | Mollusca | Mollusca | 171 | 2.3399999999999997e-47 | NR | CAG2218899.1 | 6550 | g11980 | i0 | 81.3 | 18.7016949152542 | 96 | 18 | 97.6 | 0 | 292 | 5 | 582 | 677 | CAG2218899.1 ACO [Mytilus edulis] | diamond | 5517 | 172 | 0.994186046511628 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 15747807 | 15747807 | PRJNA473641_P_NODE_2553_length_531_cov_2.237991_g2470_i0 | PRJNA473641 | 2553 | 531 | 2.237991 | 11.88373221 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 199 | 2.8e-62 | NR | XP_070189609.1 | 31220 | g2470 | i0 | 65.3 | 4.25423728813559 | 150 | 51 | 84.7 | 1 | 7 | 456 | 1 | 149 | XP_070189609.1 superoxide dismutase [Cu-Zn]-like [Littorina saxatilis] | diamond | 2259 | 199 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 18296892 | 18296892 | PRJNA473641_P_NODE_6735_length_364_cov_0.725086_g6652_i0 | PRJNA473641 | 6735 | 364 | 0.725086 | 2.6393130400000002 | Metazoa | 33208 | Mollusca | Mollusca | 82 | 5.57e-16 | NR | XHY98683.1 | 97200 | g6652 | i0 | 54.1 | 2.8021978021978 | 85 | 39 | 70.1 | 0 | 363 | 109 | 20 | 104 | XHY98683.1 cytochrome c oxidase subunit III [Cepaea hortensis] | diamond | 1020 | 82.8 | 0.990338164251208 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Helicidae | Cepaea | Cepaea hortensis | |
| 27392408 | 27392408 | PRJNA473641_P_NODE_25723_length_241_cov_0.916667_g25640_i0 | PRJNA473641 | 25723 | 241 | 0.916667 | 2.20916747 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 54.7 | 2.2e-6 | NR | XP_052251345.1 | 45954 | g25640 | i0 | 41.3 | 1.79253112033195 | 75 | 37 | 90.9 | 3 | 234 | 16 | 246 | 315 | XP_052251345.1 UBX domain-containing protein 6-like [Dreissena polymorpha] | diamond | 432 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 28023825 | 28023825 | PRJNA473641_P_NODE_4145_length_438_cov_1.326027_g4062_i0 | PRJNA473641 | 4145 | 438 | 1.326027 | 5.80799826 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 94.7 | 8.63e-22 | NR | KAH3866887.1 | 45954 | g4062 | i0 | 57.7 | 0.486301369863014 | 71 | 30 | 48.6 | 0 | 205 | 417 | 60 | 130 | KAH3866887.1 hypothetical protein DPMN_030010 [Dreissena polymorpha] | diamond | 213 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 28212920 | 28212920 | PRJNA473641_P_NODE_19826_length_248_cov_0.880000_g19743_i0 | PRJNA473641 | 19826 | 248 | 0.88 | 2.1824 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 61.2 | 1.16e-8 | NR | XP_041363619.1 | 1735272 | g19743 | i0 | 44.3 | 1.80241935483871 | 79 | 43 | 95.6 | 1 | 2 | 238 | 242 | 319 | XP_041363619.1 synaptotagmin-15-like [Gigantopelta aegis] | diamond | 447 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 28576626 | 28576626 | PRJNA473641_P_NODE_18007_length_250_cov_0.870056_g17924_i0 | PRJNA473641 | 18007 | 250 | 0.870056 | 2.17514 | Metazoa | 33208 | Mollusca | Mollusca | 123 | 1.63e-33 | NR | XP_022345525.1 | 6565 | g17924 | i0 | 73.2 | 1.968 | 82 | 22 | 98.4 | 0 | 2 | 247 | 10 | 91 | XP_022345525.1 soma ferritin-like [Crassostrea virginica] | diamond | 492 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 29460422 | 29460422 | PRJNA473641_P_NODE_1630_length_642_cov_1.397188_g1548_i0 | PRJNA473641 | 1630 | 642 | 1.397188 | 8.96994696 | Metazoa | 33208 | Mollusca | Mollusca | 252 | 7.59e-75 | NR | XP_055862496.1 | 6526 | g1548 | i0 | 59 | 15.4158878504673 | 210 | 82 | 98.1 | 2 | 13 | 642 | 432 | 637 | XP_055862496.1 major vault protein-like [Biomphalaria glabrata] | diamond | 9897 | 253 | 0.99604743083004 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 29855120 | 29855120 | PRJNA473641_P_NODE_22031_length_245_cov_1.343023_g21948_i0 | PRJNA473641 | 22031 | 245 | 1.343023 | 3.29040635 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 70.5 | 6.06e-12 | NR | XP_045204505.2 | 6596 | g21948 | i0 | 60 | 1.83673469387755 | 50 | 20 | 61.2 | 0 | 8 | 157 | 377 | 426 | XP_045204505.2 argininosuccinate synthase-like [Mercenaria mercenaria] | diamond | 450 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 29934576 | 29934576 | PRJNA473641_P_NODE_20171_length_248_cov_0.880000_g20088_i0 | PRJNA473641 | 20171 | 248 | 0.88 | 2.1824 | Metazoa | 33208 | Mollusca | Mollusca | 127 | 6.69e-33 | NR | XP_064595148.1 | 13599 | g20088 | i0 | 72 | 15.8709677419355 | 82 | 23 | 99.2 | 0 | 246 | 1 | 196 | 277 | XP_064595148.1 S-adenosylmethionine synthase-like [Liolophura japonica] | diamond | 3936 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 30392586 | 30392586 | PRJNA473641_P_NODE_18713_length_249_cov_0.875000_g18630_i0 | PRJNA473641 | 18713 | 249 | 0.875 | 2.17875 | Mya arenaria | 6604 | Mollusca | Mollusca | 48.9 | 2.69e-4 | NR | XP_052787882.1 | 6604 | g18630 | i0 | 60.6 | 1.19277108433735 | 33 | 13 | 39.8 | 0 | 242 | 144 | 962 | 994 | XP_052787882.1 adenylate kinase isoenzyme 5-like isoform X10 [Mya arenaria] | diamond | 297 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 32479233 | 32479233 | PRJNA473641_P_NODE_23799_length_243_cov_0.905882_g23716_i0 | PRJNA473641 | 23799 | 243 | 0.905882 | 2.20129326 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 74.3 | 2.69e-13 | NR | CAE1274822.1 | 158019 | g23716 | i0 | 71.1 | 0.555555555555556 | 45 | 13 | 55.6 | 0 | 2 | 136 | 416 | 460 | CAE1274822.1 psd [Acanthosepion pharaonis] | diamond | 135 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 32699748 | 32699748 | PRJNA473641_P_NODE_3720_length_457_cov_1.593750_g3637_i0 | PRJNA473641 | 3720 | 457 | 1.59375 | 7.2834375 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 93.6 | 2.98e-21 | NR | KAH3866887.1 | 45954 | g3637 | i0 | 57.7 | 0.466083150984683 | 71 | 30 | 46.6 | 0 | 327 | 115 | 60 | 130 | KAH3866887.1 hypothetical protein DPMN_030010 [Dreissena polymorpha] | diamond | 213 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 32857268 | 32857268 | PRJNA473641_P_NODE_22500_length_245_cov_0.895349_g22417_i0 | PRJNA473641 | 22500 | 245 | 0.895349 | 2.19360505 | Argopecten irradians | 31199 | Mollusca | Mollusca | 42.7 | 0.0365 | NR | XP_069107634.1 | 31199 | g22417 | i0 | 29.4 | 0.83265306122449 | 68 | 39 | 72.2 | 1 | 67 | 243 | 92 | 159 | XP_069107634.1 uncharacterized protein [Argopecten irradians] | diamond | 204 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians |
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);;