contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA951412" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26899113 | 26899113 | PRJNA951412_P_NODE_3021_length_281_cov_1.495192_g2936_i0 | PRJNA951412 | 3021 | 281 | 1.495192 | 4.20148952 | Candidula unifasciata | 100452 | Mollusca | Mollusca | 62.4 | 7.14e-9 | NR | CAG5131342.1 | 100452 | g2936 | i0 | 47.7 | 1.39857651245552 | 65 | 32 | 67.3 | 1 | 280 | 92 | 584 | 648 | CAG5131342.1 unnamed protein product, partial [Candidula unifasciata] | diamond | 393 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 26968768 | 26968768 | PRJNA951412_P_NODE_3682_length_261_cov_1.654255_g3597_i0 | PRJNA951412 | 3682 | 261 | 1.654255 | 4.31760555 | Metazoa | 33208 | Mollusca | Mollusca | 72.4 | 1.65e-12 | NR | KAH9523589.1 | 55810 | g3597 | i0 | 50.7 | 3.60919540229885 | 67 | 32 | 75.9 | 1 | 61 | 258 | 78 | 144 | KAH9523589.1 hypothetical protein Btru_040407 [Bulinus truncatus] | diamond | 942 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Bulinus | Bulinus truncatus | ||
| 27601070 | 27601070 | PRJNA951412_P_NODE_3044_length_280_cov_2.251208_g2959_i0 | PRJNA951412 | 3044 | 280 | 2.251208 | 6.3033824 | Metazoa | 33208 | Mollusca | Mollusca | 111 | 3.99e-26 | NR | XP_053378868.1 | 6596 | g2959 | i0 | 59 | 4.69285714285714 | 83 | 34 | 88.9 | 0 | 1 | 249 | 435 | 517 | XP_053378868.1 phenylalanine--tRNA ligase beta subunit-like [Mercenaria mercenaria] | diamond | 1314 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 27721071 | 27721071 | PRJNA951412_P_NODE_1884_length_335_cov_1.187023_g1799_i0 | PRJNA951412 | 1884 | 335 | 1.187023 | 3.97652705 | Mya arenaria | 6604 | Mollusca | Mollusca | 47 | 0.00114 | NR | XP_052810817.1 | 6604 | g1799 | i0 | 49.1 | 0.474626865671642 | 53 | 26 | 46.6 | 1 | 330 | 175 | 85 | 137 | XP_052810817.1 microsomal glutathione S-transferase 3-like [Mya arenaria] | diamond | 159 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 28169194 | 28169194 | PRJNA951412_P_NODE_5445_length_248_cov_2.222857_g5360_i0 | PRJNA951412 | 5445 | 248 | 2.222857 | 5.51268536 | root | 1 | Root_unresolved | Root_unresolved | 92.4 | 1.33e-19 | NR | XP_053380060.1 | 6596 | g5360 | i0 | 56.8 | 18.5443548387097 | 74 | 29 | 85.9 | 2 | 3 | 215 | 289 | 362 | XP_053380060.1 deleted in malignant brain tumors 1 protein-like [Mercenaria mercenaria] | diamond | 4599 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 28447007 | 28447007 | PRJNA951412_P_NODE_3546_length_264_cov_2.518325_g3461_i0 | PRJNA951412 | 3546 | 264 | 2.518325 | 6.648378 | Octopus vulgaris | 6645 | Mollusca | Mollusca | 45.8 | 0.0012 | NR | CAI9738083.1 | 6645 | g3461 | i0 | 60 | 0.454545454545455 | 40 | 13 | 45.5 | 1 | 65 | 184 | 8 | 44 | CAI9738083.1 Hypothetical predicted protein [Octopus vulgaris] | diamond | 120 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus vulgaris | |
| 28579746 | 28579746 | PRJNA951412_P_NODE_1987_length_329_cov_1.210938_g1902_i0 | PRJNA951412 | 1987 | 329 | 1.210938 | 3.98398602 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 113 | 8.61e-28 | NR | XP_013094420.2 | 6526 | g1902 | i0 | 54.1 | 6.90273556231003 | 109 | 49 | 98.5 | 1 | 4 | 327 | 83 | 191 | XP_013094420.2 uncharacterized protein LOC106078174 [Biomphalaria glabrata] | diamond | 2271 | 114 | 0.991228070175439 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 29456846 | 29456846 | PRJNA951412_P_NODE_2610_length_296_cov_1.394619_g2525_i0 | PRJNA951412 | 2610 | 296 | 1.394619 | 4.12807224 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 112 | 7.44e-27 | NR | XP_070192329.1 | 31220 | g2525 | i0 | 55.2 | 3.9222972972973 | 96 | 41 | 97.3 | 1 | 294 | 7 | 375 | 468 | XP_070192329.1 dipeptidyl peptidase 1-like [Littorina saxatilis] | diamond | 1161 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 29709350 | 29709350 | PRJNA951412_P_NODE_5310_length_249_cov_0.880682_g5225_i0 | PRJNA951412 | 5310 | 249 | 0.880682 | 2.19289818 | Octopus vulgaris | 6645 | Mollusca | Mollusca | 56.2 | 1.02e-7 | NR | CAI9741215.1 | 6645 | g5225 | i0 | 60.9 | 0.55421686746988 | 46 | 13 | 49.4 | 1 | 4 | 126 | 22 | 67 | CAI9741215.1 Hypothetical predicted protein [Octopus vulgaris] | diamond | 138 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus vulgaris | |
| 30348649 | 30348649 | PRJNA951412_P_NODE_7012_length_244_cov_0.912281_g6927_i0 | PRJNA951412 | 7012 | 244 | 0.912281 | 2.22596564 | root | 1 | Root_unresolved | Root_unresolved | 50.1 | 1.03e-4 | NR | XP_070205506.1 | 31220 | g6927 | i0 | 44.1 | 2.16393442622951 | 59 | 31 | 72.5 | 1 | 226 | 50 | 72 | 128 | XP_070205506.1 NACHT domain- and WD repeat-containing protein 1-like [Littorina saxatilis] | diamond | 528 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 31352848 | 31352848 | PRJNA951412_P_NODE_4656_length_251_cov_0.870787_g4571_i0 | PRJNA951412 | 4656 | 251 | 0.870787 | 2.18567537 | Octopus vulgaris | 6645 | Mollusca | Mollusca | 99.8 | 2.8200000000000003e-22 | NR | CAI9729668.1 | 6645 | g4571 | i0 | 78.3 | 0.99203187250996006 | 83 | 15 | 99.2 | 2 | 251 | 3 | 68 | 147 | CAI9729668.1 Hypothetical predicted protein [Octopus vulgaris] | diamond | 249 | 99.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus vulgaris | |
| 31637334 | 31637334 | PRJNA951412_P_NODE_616_length_591_cov_5.675676_g531_i0 | PRJNA951412 | 616 | 591 | 5.675676 | 33.54324516 | Mactra antiquata | 2302425 | Mollusca | Mollusca | 150 | 1.95e-41 | NR | KAL4237229.1 | 2302425 | g531 | i0 | 45.8 | 1.70558375634518 | 177 | 92 | 89.3 | 3 | 63 | 590 | 36 | 209 | KAL4237229.1 hypothetical protein ACF0H5_001948 [Mactra antiquata] | diamond | 1008 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Mactridae | Mactra | Mactra antiquata | |
| 32302178 | 32302178 | PRJNA951412_P_NODE_3899_length_255_cov_3.280220_g3814_i0 | PRJNA951412 | 3899 | 255 | 3.28022 | 8.364561 | Mya arenaria | 6604 | Mollusca | Mollusca | 69.7 | 1.39e-12 | NR | WAR00047.1 | 6604 | g3814 | i0 | 46.2 | 2.75294117647059 | 78 | 39 | 91.8 | 1 | 12 | 245 | 32 | 106 | WAR00047.1 SAP3-like protein [Mya arenaria] | diamond | 702 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 32838301 | 32838301 | PRJNA951412_P_NODE_2260_length_312_cov_3.092050_g2175_i0 | PRJNA951412 | 2260 | 312 | 3.09205 | 9.647196 | Mytilus edulis | 6550 | Mollusca | Mollusca | 43.5 | 0.0459 | NR | CAG2198384.1 | 6550 | g2175 | i0 | 56.8 | 0.355769230769231 | 37 | 15 | 35.6 | 1 | 193 | 303 | 671 | 706 | CAG2198384.1 unnamed protein product [Mytilus edulis] | diamond | 111 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis |
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);;