contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA450343" and tax_phylum = "Annelida"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6816844 | 6816844 | PRJNA450343_P_NODE_7766_length_194_cov_1.055172_g7698_i0 | PRJNA450343 | 7766 | 194 | 1.055172 | 2.04703368 | Metazoa | 33208 | Annelida | Annelida | 114 | 4.53e-30 | NR | ABW23174.1 | 6344 | g7698 | i0 | 85.9 | 9.89690721649485 | 64 | 9 | 99 | 0 | 1 | 192 | 73 | 136 | ABW23174.1 ribosomal protein rpl19 [Arenicola marina] | diamond | 1920 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina | ||
| 8092234 | 8092234 | PRJNA450343_P_NODE_2147_length_373_cov_1.481481_g2079_i0 | PRJNA450343 | 2147 | 373 | 1.481481 | 5.52592413 | Metazoa | 33208 | Annelida | Annelida | 181 | 1.69e-53 | NR | KAK2148578.1 | 53620 | g2079 | i0 | 76.8 | 7.17426273458445 | 112 | 26 | 90.1 | 0 | 372 | 37 | 224 | 335 | KAK2148578.1 hypothetical protein LSH36_491g04001 [Paralvinella palmiformis] | diamond | 2676 | 182 | 0.994505494505495 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 11917841 | 11917841 | PRJNA450343_P_NODE_9350_length_178_cov_1.813953_g9282_i0 | PRJNA450343 | 9350 | 178 | 1.813953 | 3.22883634 | Metazoa | 33208 | Annelida | Annelida | 85.1 | 3.3e-20 | NR | XP_009015315.1 | 6412 | g9282 | i0 | 75.9 | 3.67415730337079 | 54 | 13 | 91 | 0 | 164 | 3 | 1 | 54 | XP_009015315.1 hypothetical protein HELRODRAFT_64670 [Helobdella robusta] | diamond | 654 | 85.5 | 0.9953216374269 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 26949424 | 26949424 | PRJNA450343_P_NODE_4782_length_243_cov_1.051546_g4714_i0 | PRJNA450343 | 4782 | 243 | 1.051546 | 2.55525678 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 67.8 | 5.19e-11 | NR | CAD5121438.1 | 2664684 | g4714 | i0 | 38.6 | 1.98765432098765 | 83 | 47 | 97.5 | 1 | 237 | 1 | 123 | 205 | CAD5121438.1 DgyrCDS9949 [Dimorphilus gyrociliatus] | diamond | 483 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 27960446 | 27960446 | PRJNA450343_P_NODE_3505_length_286_cov_0.860759_g3437_i0 | PRJNA450343 | 3505 | 286 | 0.860759 | 2.46177074 | Owenia fusiformis | 6347 | Annelida | Annelida | 112 | 3.02e-28 | NR | CAH1797053.1 | 6347 | g3437 | i0 | 56.4 | 0.986013986013986 | 94 | 38 | 95.5 | 1 | 12 | 284 | 27 | 120 | CAH1797053.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 282 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28276102 | 28276102 | PRJNA450343_P_NODE_8926_length_182_cov_1.533835_g8858_i0 | PRJNA450343 | 8926 | 182 | 1.533835 | 2.7915797 | Helobdella robusta | 6412 | Annelida | Annelida | 75.1 | 3.23e-14 | NR | XP_009020629.1 | 6412 | g8858 | i0 | 58.3 | 0.989010989010989 | 60 | 25 | 98.9 | 0 | 3 | 182 | 209 | 268 | XP_009020629.1 hypothetical protein HELRODRAFT_185715 [Helobdella robusta] | diamond | 180 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28387147 | 28387147 | PRJNA450343_P_NODE_12086_length_165_cov_0.793103_g12018_i0 | PRJNA450343 | 12086 | 165 | 0.793103 | 1.30861995 | Metazoa | 33208 | Annelida | Annelida | 83.2 | 2.7e-18 | NR | CAH1782605.1 | 6347 | g12018 | i0 | 66.7 | 5.87272727272727 | 54 | 18 | 98.2 | 0 | 162 | 1 | 1 | 54 | CAH1782605.1 unnamed protein product [Owenia fusiformis] | diamond | 969 | 83.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28529002 | 28529002 | PRJNA450343_P_NODE_6047_length_217_cov_1.517857_g5979_i0 | PRJNA450343 | 6047 | 217 | 1.517857 | 3.29374969 | Owenia fusiformis | 6347 | Annelida | Annelida | 105 | 4.160000000000001e-27 | NR | CAH1794757.1 | 6347 | g5979 | i0 | 82 | 3.24884792626728 | 61 | 11 | 84.3 | 0 | 183 | 1 | 21 | 81 | CAH1794757.1 unnamed protein product [Owenia fusiformis] | diamond | 705 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28639996 | 28639996 | PRJNA450343_P_NODE_1007_length_563_cov_19.608949_g941_i0 | PRJNA450343 | 1007 | 563 | 19.608949 | 110.39838287 | Metazoa | 33208 | Annelida | Annelida | 171 | 1.51e-51 | NR | CAH1789098.1 | 6347 | g941 | i0 | 94 | 18.3836589698046 | 84 | 5 | 44.8 | 0 | 514 | 263 | 18 | 101 | CAH1789098.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 10350 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29239749 | 29239749 | PRJNA450343_P_NODE_9809_length_174_cov_1.224000_g9741_i0 | PRJNA450343 | 9809 | 174 | 1.224 | 2.12976 | Sabellida | 6362 | Annelida | Annelida | 52.8 | 1.65e-6 | NR | KAI0221400.1 | 104711 | g9741 | i0 | 49 | 4.36206896551724 | 49 | 25 | 84.5 | 0 | 162 | 16 | 1 | 49 | KAI0221400.1 TCTP domain-containing protein [Lamellibrachia satsuma] | diamond | 759 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 29286472 | 29286472 | PRJNA450343_P_NODE_2949_length_313_cov_1.727273_g2881_i0 | PRJNA450343 | 2949 | 313 | 1.727273 | 5.40636449 | Capitella teleta | 283909 | Annelida | Annelida | 43.5 | 0.0376 | NR | ELT94232.1 | 283909 | g2881 | i0 | 35.3 | 0.488817891373802 | 51 | 31 | 47 | 1 | 219 | 73 | 39 | 89 | ELT94232.1 hypothetical protein CAPTEDRAFT_214176, partial [Capitella teleta] | diamond | 153 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 29712912 | 29712912 | PRJNA450343_P_NODE_3830_length_272_cov_1.475336_g3762_i0 | PRJNA450343 | 3830 | 272 | 1.475336 | 4.01291392 | Metazoa | 33208 | Annelida | Annelida | 46.6 | 0.00223 | NR | KAK2173521.1 | 27915 | g3762 | i0 | 86.4 | 0.727941176470588 | 22 | 3 | 24.3 | 0 | 271 | 206 | 367 | 388 | KAK2173521.1 hypothetical protein NP493_870g02027 [Ridgeia piscesae] | diamond | 198 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 29791605 | 29791605 | PRJNA450343_P_NODE_5791_length_222_cov_1.179191_g5723_i0 | PRJNA450343 | 5791 | 222 | 1.179191 | 2.61780402 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 77.8 | 2.43e-15 | NR | KAK2153599.1 | 53620 | g5723 | i0 | 69.8 | 0.716216216216216 | 53 | 16 | 71.6 | 0 | 159 | 1 | 9 | 61 | KAK2153599.1 hypothetical protein LSH36_291g01017 [Paralvinella palmiformis] | diamond | 159 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 30377100 | 30377100 | PRJNA450343_P_NODE_8712_length_184_cov_1.511111_g8644_i0 | PRJNA450343 | 8712 | 184 | 1.511111 | 2.78044424 | Metazoa | 33208 | Annelida | Annelida | 91.7 | 9.52e-23 | NR | XP_009015315.1 | 6412 | g8644 | i0 | 74.1 | 2.83695652173913 | 58 | 15 | 94.6 | 0 | 175 | 2 | 1 | 58 | XP_009015315.1 hypothetical protein HELRODRAFT_64670 [Helobdella robusta] | diamond | 522 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 30644629 | 30644629 | PRJNA450343_P_NODE_2213_length_367_cov_1.597484_g2145_i0 | PRJNA450343 | 2213 | 367 | 1.597484 | 5.86276628 | Ridgeia piscesae | 27915 | Annelida | Annelida | 102 | 1.03e-23 | NR | KAK2187225.1 | 27915 | g2145 | i0 | 40.4 | 0.931880108991826 | 114 | 65 | 93.2 | 1 | 346 | 5 | 102 | 212 | KAK2187225.1 hypothetical protein NP493_172g00023 [Ridgeia piscesae] | diamond | 342 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 30929186 | 30929186 | PRJNA450343_P_NODE_8814_length_183_cov_1.865672_g8746_i0 | PRJNA450343 | 8814 | 183 | 1.865672 | 3.41417976 | Owenia fusiformis | 6347 | Annelida | Annelida | 68.6 | 6.83e-12 | NR | CAH1795408.1 | 6347 | g8746 | i0 | 58.3 | 5.91803278688525 | 60 | 24 | 98.4 | 1 | 181 | 2 | 27 | 85 | CAH1795408.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 1083 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30960857 | 30960857 | PRJNA450343_P_NODE_4774_length_243_cov_1.175258_g4706_i0 | PRJNA450343 | 4774 | 243 | 1.175258 | 2.85587694 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 101 | 3.259999999999999e-23 | NR | KAI0218025.1 | 104711 | g4706 | i0 | 68.2 | 0.814814814814815 | 66 | 21 | 81.5 | 0 | 241 | 44 | 267 | 332 | KAI0218025.1 Pyruvate dehydrogenase E1 component subunit alpha type II, mitochondrial [Lamellibrachia satsuma] | diamond | 198 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 31134657 | 31134657 | PRJNA450343_P_NODE_2315_length_357_cov_1.724026_g2247_i0 | PRJNA450343 | 2315 | 357 | 1.724026 | 6.15477282 | Metazoa | 33208 | Annelida | Annelida | 64.7 | 1.37e-9 | NR | CAH1798697.1 | 6347 | g2247 | i0 | 33.7 | 2.70588235294118 | 101 | 64 | 84.9 | 1 | 346 | 44 | 53 | 150 | CAH1798697.1 unnamed protein product [Owenia fusiformis] | diamond | 966 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31149877 | 31149877 | PRJNA450343_P_NODE_13535_length_162_cov_0.902655_g13467_i0 | PRJNA450343 | 13535 | 162 | 0.902655 | 1.4623011 | Ridgeia piscesae | 27915 | Annelida | Annelida | 46.2 | 1.36e-4 | NR | KAK2188740.1 | 27915 | g13467 | i0 | 69.2 | 0.481481481481481 | 26 | 8 | 48.1 | 0 | 149 | 72 | 72 | 97 | KAK2188740.1 hypothetical protein NP493_123g01000 [Ridgeia piscesae] | diamond | 78 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 31529965 | 31529965 | PRJNA450343_P_NODE_10696_length_167_cov_0.864407_g10628_i0 | PRJNA450343 | 10696 | 167 | 0.864407 | 1.44355969 | Capitella teleta | 283909 | Annelida | Annelida | 45.1 | 0.00204 | NR | ELT93188.1 | 283909 | g10628 | i0 | 60 | 0.538922155688623 | 30 | 12 | 53.9 | 0 | 33 | 122 | 271 | 300 | ELT93188.1 hypothetical protein CAPTEDRAFT_223994 [Capitella teleta] | diamond | 90 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 31909396 | 31909396 | PRJNA450343_P_NODE_13737_length_161_cov_0.910714_g13669_i0 | PRJNA450343 | 13737 | 161 | 0.910714 | 1.46624954 | Owenia fusiformis | 6347 | Annelida | Annelida | 61.6 | 2.64e-9 | NR | CAH1796465.1 | 6347 | g13669 | i0 | 53.1 | 1.82608695652174 | 49 | 23 | 91.3 | 0 | 2 | 148 | 213 | 261 | CAH1796465.1 unnamed protein product [Owenia fusiformis] | diamond | 294 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32194219 | 32194219 | PRJNA450343_P_NODE_11998_length_165_cov_0.879310_g11930_i0 | PRJNA450343 | 11998 | 165 | 0.87931 | 1.4508615 | Owenia fusiformis | 6347 | Annelida | Annelida | 80.9 | 4.48e-16 | NR | CAH1772659.1 | 6347 | g11930 | i0 | 66.7 | 0.981818181818182 | 54 | 18 | 98.2 | 0 | 164 | 3 | 13 | 66 | CAH1772659.1 unnamed protein product [Owenia fusiformis] | diamond | 162 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32305630 | 32305630 | PRJNA450343_P_NODE_10759_length_167_cov_0.864407_g10691_i0 | PRJNA450343 | 10759 | 167 | 0.864407 | 1.44355969 | Metazoa | 33208 | Annelida | Annelida | 84.7 | 2.67e-19 | NR | CAH1783432.1 | 6347 | g10691 | i0 | 97.7 | 9.30538922155689 | 43 | 1 | 77.2 | 0 | 131 | 3 | 1 | 43 | CAH1783432.1 unnamed protein product [Owenia fusiformis] | diamond | 1554 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32590186 | 32590186 | PRJNA450343_P_NODE_5839_length_221_cov_1.290698_g5771_i0 | PRJNA450343 | 5839 | 221 | 1.290698 | 2.85244258 | Metazoa | 33208 | Annelida | Annelida | 128 | 2.41e-32 | NR | CAH1784217.1 | 6347 | g5771 | i0 | 86.3 | 16.8190045248869 | 73 | 10 | 99.1 | 0 | 220 | 2 | 541 | 613 | CAH1784217.1 unnamed protein product [Owenia fusiformis] | diamond | 3717 | 129 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis |
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);;