contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA889065" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8516325 | 8516325 | PRJNA889065_S_NODE_7967_length_337_cov_2.319728_g7729_i0 | PRJNA889065 | 7967 | 337 | 2.319728 | 7.81748336 | root | 1 | Root_unresolved | Root_unresolved | 142 | 1.72e-36 | NR | CAH1790728.1 | 6347 | g7729 | i0 | 58.9 | 38.813056379822 | 112 | 46 | 99.7 | 0 | 1 | 336 | 49 | 160 | CAH1790728.1 unnamed protein product [Owenia fusiformis] | diamond | 13080 | 143 | 0.993006993006993 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 16544715 | 16544715 | PRJNA889065_S_NODE_1633_length_642_cov_9.647746_g1457_i0 | PRJNA889065 | 1633 | 642 | 9.647746 | 61.93852932 | Opisthokonta | 33154 | Annelida | Annelida | 141 | 3.45e-38 | NR | KAK2145242.1 | 53620 | g1457 | i0 | 37.6 | 12.1028037383178 | 186 | 114 | 86.9 | 1 | 638 | 81 | 13 | 196 | KAK2145242.1 hypothetical protein LSH36_693g02006 [Paralvinella palmiformis] | diamond | 7770 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 19990047 | 19990047 | PRJNA889065_S_NODE_4756_length_428_cov_5.553247_g4518_i0 | PRJNA889065 | 4756 | 428 | 5.553247 | 23.76789716 | Metazoa | 33208 | Annelida | Annelida | 241 | 1.59e-75 | NR | CAH1794133.1 | 6347 | g4518 | i0 | 86.6 | 54.7359813084112 | 142 | 19 | 99.5 | 0 | 3 | 428 | 233 | 374 | CAH1794133.1 unnamed protein product [Owenia fusiformis] | diamond | 23427 | 241 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27149899 | 27149899 | PRJNA889065_S_NODE_642_length_894_cov_19.101058_g547_i0 | PRJNA889065 | 642 | 894 | 19.101058 | 170.76345852 | Ridgeia piscesae | 27915 | Annelida | Annelida | 173 | 7.78e-49 | NR | KAK2143823.1 | 27915 | g547 | i0 | 41.2 | 1.74832214765101 | 260 | 149 | 86.2 | 2 | 861 | 91 | 5 | 263 | KAK2143823.1 hypothetical protein NP493_4403g00003 [Ridgeia piscesae] | diamond | 1563 | 173 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 27568803 | 27568803 | PRJNA889065_S_NODE_38064_length_154_cov_1.630631_g37826_i0 | PRJNA889065 | 38064 | 154 | 1.630631 | 2.51117174 | Metazoa | 33208 | Annelida | Annelida | 55.8 | 2.53e-7 | NR | CAH1799444.1 | 6347 | g37826 | i0 | 66.7 | 6.33116883116883 | 36 | 12 | 70.1 | 0 | 3 | 110 | 64 | 99 | CAH1799444.1 unnamed protein product [Owenia fusiformis] | diamond | 975 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28003281 | 28003281 | PRJNA889065_S_NODE_2885_length_519_cov_2.178571_g2661_i0 | PRJNA889065 | 2885 | 519 | 2.178571 | 11.30678349 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 133 | 1.52e-32 | NR | KAI0232061.1 | 104711 | g2661 | i0 | 67.4 | 3.1849710982659 | 86 | 28 | 49.7 | 0 | 152 | 409 | 426 | 511 | KAI0232061.1 U2 snRNP-associated SURP motif-containing protein [Lamellibrachia satsuma] | diamond | 1653 | 133 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 28823739 | 28823739 | PRJNA889065_S_NODE_788_length_835_cov_6.363636_g674_i0 | PRJNA889065 | 788 | 835 | 6.363636 | 53.1363606 | Capitella teleta | 283909 | Annelida | Annelida | 199 | 7.01e-57 | NR | ELU18888.1 | 283909 | g674 | i0 | 39.7 | 2.71976047904192 | 257 | 150 | 92.3 | 2 | 6 | 776 | 215 | 466 | ELU18888.1 hypothetical protein CAPTEDRAFT_226782 [Capitella teleta] | diamond | 2271 | 199 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 29210899 | 29210899 | PRJNA889065_S_NODE_20589_length_214_cov_3.228070_g20351_i0 | PRJNA889065 | 20589 | 214 | 3.22807 | 6.9080698 | Polychaeta | 6341 | Annelida | Annelida | 67 | 6.83e-11 | NR | KAK2169770.1 | 53620 | g20351 | i0 | 49.3 | 4.82242990654206 | 69 | 32 | 95.3 | 2 | 6 | 209 | 365 | 431 | KAK2169770.1 hypothetical protein LSH36_7g14012 [Paralvinella palmiformis] | diamond | 1032 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 29897634 | 29897634 | PRJNA889065_S_NODE_1011_length_765_cov_6.342105_g872_i0 | PRJNA889065 | 1011 | 765 | 6.342105 | 48.51710325 | Helobdella robusta | 6412 | Annelida | Annelida | 143 | 3.23e-38 | NR | XP_009019383.1 | 6412 | g872 | i0 | 49.1 | 0.63921568627451 | 163 | 81 | 63.1 | 2 | 711 | 229 | 1 | 163 | XP_009019383.1 hypothetical protein HELRODRAFT_155763 [Helobdella robusta] | diamond | 489 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 29905557 | 29905557 | PRJNA889065_S_NODE_9651_length_307_cov_3.200758_g9413_i0 | PRJNA889065 | 9651 | 307 | 3.200758 | 9.82632706 | Metazoa | 33208 | Annelida | Annelida | 55.8 | 1.61e-6 | NR | ELT94827.1 | 283909 | g9413 | i0 | 38.6 | 2.74592833876221 | 70 | 43 | 68.4 | 0 | 10 | 219 | 23 | 92 | ELT94827.1 hypothetical protein CAPTEDRAFT_226902 [Capitella teleta] | diamond | 843 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 30316629 | 30316629 | PRJNA889065_S_NODE_20952_length_213_cov_1.070588_g20714_i0 | PRJNA889065 | 20952 | 213 | 1.070588 | 2.28035244 | Metazoa | 33208 | Annelida | Annelida | 52 | 1.34e-5 | NR | KAK2168012.1 | 53620 | g20714 | i0 | 38.2 | 4.05633802816901 | 68 | 34 | 95.8 | 1 | 213 | 10 | 74 | 133 | KAK2168012.1 hypothetical protein LSH36_21g02059 [Paralvinella palmiformis] | diamond | 864 | 52.4 | 0.99236641221374 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 30403490 | 30403490 | PRJNA889065_S_NODE_3453_length_485_cov_3.108597_g3224_i0 | PRJNA889065 | 3453 | 485 | 3.108597 | 15.07669545 | Owenia fusiformis | 6347 | Annelida | Annelida | 85.5 | 5.27e-16 | NR | CAH1788298.1 | 6347 | g3224 | i0 | 43.6 | 0.680412371134021 | 110 | 62 | 68 | 0 | 58 | 387 | 40 | 149 | CAH1788298.1 unnamed protein product [Owenia fusiformis] | diamond | 330 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31035269 | 31035269 | PRJNA889065_S_NODE_33695_length_165_cov_1.508197_g33457_i0 | PRJNA889065 | 33695 | 165 | 1.508197 | 2.48852505 | Owenia fusiformis | 6347 | Annelida | Annelida | 59.3 | 1.67e-8 | NR | CAH1799299.1 | 6347 | g33457 | i0 | 60.9 | 1.72727272727273 | 46 | 18 | 83.6 | 0 | 20 | 157 | 21 | 66 | CAH1799299.1 unnamed protein product [Owenia fusiformis] | diamond | 285 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31256163 | 31256163 | PRJNA889065_S_NODE_14155_length_257_cov_3.205607_g13917_i0 | PRJNA889065 | 14155 | 257 | 3.205607 | 8.23840999 | Ridgeia piscesae | 27915 | Annelida | Annelida | 45.8 | 0.00276 | NR | KAK2175499.1 | 27915 | g13917 | i0 | 46.4 | 0.653696498054475 | 56 | 28 | 64.2 | 2 | 195 | 31 | 147 | 201 | KAK2175499.1 hypothetical protein NP493_728g01075 [Ridgeia piscesae] | diamond | 168 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 31319401 | 31319401 | PRJNA889065_S_NODE_2815_length_523_cov_28.400000_g2592_i0 | PRJNA889065 | 2815 | 523 | 28.4 | 148.532 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 62.4 | 7.81e-9 | NR | KAK2163798.1 | 53620 | g2592 | i0 | 29.2 | 0.550669216061185 | 96 | 68 | 55.1 | 0 | 171 | 458 | 44 | 139 | KAK2163798.1 hypothetical protein LSH36_74g11125 [Paralvinella palmiformis] | diamond | 288 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 31414380 | 31414380 | PRJNA889065_S_NODE_7636_length_343_cov_3.083333_g7398_i0 | PRJNA889065 | 7636 | 343 | 3.083333 | 10.57583219 | Capitella teleta | 283909 | Annelida | Annelida | 100 | 9.26e-22 | NR | ELU18522.1 | 283909 | g7398 | i0 | 42.9 | 0.918367346938776 | 105 | 60 | 91.8 | 0 | 23 | 337 | 696 | 800 | ELU18522.1 hypothetical protein CAPTEDRAFT_219848 [Capitella teleta] | diamond | 315 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 31453943 | 31453943 | PRJNA889065_S_NODE_4176_length_451_cov_5.289216_g3942_i0 | PRJNA889065 | 4176 | 451 | 5.289216 | 23.85436416 | Metazoa | 33208 | Annelida | Annelida | 54.7 | 1.39e-5 | NR | XP_009020093.1 | 6412 | g3942 | i0 | 30.6 | 4.77605321507761 | 134 | 87 | 86.5 | 4 | 432 | 43 | 36 | 167 | XP_009020093.1 hypothetical protein HELRODRAFT_188804 [Helobdella robusta] | diamond | 2154 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 31699050 | 31699050 | PRJNA889065_S_NODE_8597_length_324_cov_5.096085_g8359_i0 | PRJNA889065 | 8597 | 324 | 5.096085 | 16.5113154 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 52.4 | 4.08e-5 | NR | CAD5116920.1 | 2664684 | g8359 | i0 | 40.3 | 4.01851851851852 | 62 | 37 | 57.4 | 0 | 5 | 190 | 1442 | 1503 | CAD5116920.1 DgyrCDS5761 [Dimorphilus gyrociliatus] | diamond | 1302 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 31738299 | 31738299 | PRJNA889065_S_NODE_38637_length_153_cov_1.036364_g38399_i0 | PRJNA889065 | 38637 | 153 | 1.036364 | 1.58563692 | Metazoa | 33208 | Annelida | Annelida | 93.6 | 1.31e-20 | NR | KAK2192903.1 | 27915 | g38399 | i0 | 90 | 158.823529411765 | 50 | 5 | 98 | 0 | 3 | 152 | 895 | 944 | KAK2192903.1 hypothetical protein NP493_21g11012 [Ridgeia piscesae] | diamond | 24300 | 94.4 | 0.991525423728813 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 31864804 | 31864804 | PRJNA889065_S_NODE_12877_length_268_cov_3.871111_g12639_i0 | PRJNA889065 | 12877 | 268 | 3.871111 | 10.37457748 | Opisthokonta | 33154 | Annelida | Annelida | 113 | 5.990000000000001e-27 | NR | KAK2165573.1 | 53620 | g12639 | i0 | 66.7 | 4.34328358208955 | 78 | 26 | 87.3 | 0 | 5 | 238 | 57 | 134 | KAK2165573.1 hypothetical protein LSH36_48g03046 [Paralvinella palmiformis] | diamond | 1164 | 114 | 0.991228070175439 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 32078595 | 32078595 | PRJNA889065_S_NODE_15118_length_249_cov_3.009709_g14880_i0 | PRJNA889065 | 15118 | 249 | 3.009709 | 7.49417541 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 72 | 1.99e-12 | NR | KAK2145597.1 | 53620 | g14880 | i0 | 42.7 | 2.73493975903614 | 75 | 33 | 90.4 | 1 | 4 | 228 | 130 | 194 | KAK2145597.1 hypothetical protein LSH36_669g01023 [Paralvinella palmiformis] | diamond | 681 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 32173790 | 32173790 | PRJNA889065_S_NODE_2998_length_511_cov_5.542735_g2774_i0 | PRJNA889065 | 2998 | 511 | 5.542735 | 28.32337585 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 97.8 | 2.79e-21 | NR | CAD5124207.1 | 2664684 | g2774 | i0 | 34 | 0.951076320939335 | 162 | 103 | 94.5 | 2 | 1 | 483 | 89 | 247 | CAD5124207.1 DgyrCDS12506 [Dimorphilus gyrociliatus] | diamond | 486 | 97.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 32173802 | 32173802 | PRJNA889065_S_NODE_7538_length_345_cov_4.122517_g7300_i0 | PRJNA889065 | 7538 | 345 | 4.122517 | 14.22268365 | Ridgeia piscesae | 27915 | Annelida | Annelida | 92.8 | 3.31e-19 | NR | KAK2182166.1 | 27915 | g7300 | i0 | 47.6 | 5.33913043478261 | 105 | 52 | 89.6 | 2 | 343 | 35 | 611 | 714 | KAK2182166.1 hypothetical protein NP493_364g02050 [Ridgeia piscesae] | diamond | 1842 | 92.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 32458474 | 32458474 | PRJNA889065_S_NODE_179_length_1281_cov_29.817447_g141_i0 | PRJNA889065 | 179 | 1281 | 29.817447 | 381.96149607 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 332 | 2.04e-100 | NR | CAD5115251.1 | 2664684 | g141 | i0 | 49.1 | 4.61826697892272 | 330 | 164 | 76.3 | 3 | 210 | 1187 | 61 | 390 | CAD5115251.1 DgyrCDS4245 [Dimorphilus gyrociliatus] | diamond | 5916 | 332 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 32655258 | 32655258 | PRJNA889065_S_NODE_1860_length_609_cov_11.360424_g1669_i0 | PRJNA889065 | 1860 | 609 | 11.360424 | 69.18498216 | Metazoa | 33208 | Annelida | Annelida | 87.4 | 2.01e-16 | NR | KAI0208194.1 | 104711 | g1669 | i0 | 34.3 | 3.42364532019704 | 178 | 109 | 83.7 | 2 | 606 | 97 | 153 | 330 | KAI0208194.1 Secretory carrier-associated membrane protein 3 [Lamellibrachia satsuma] | diamond | 2085 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 32875964 | 32875964 | PRJNA889065_S_NODE_8500_length_326_cov_3.088339_g8262_i0 | PRJNA889065 | 8500 | 326 | 3.088339 | 10.06798514 | Metazoa | 33208 | Annelida | Annelida | 106 | 3.28e-24 | NR | XP_009018954.1 | 6412 | g8262 | i0 | 42.7 | 25.3711656441718 | 110 | 55 | 98.5 | 2 | 321 | 1 | 423 | 527 | XP_009018954.1 hypothetical protein HELRODRAFT_112476 [Helobdella robusta] | diamond | 8271 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta |
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);;