contig_metadata
29 rows where analysis = "diamond", bioproject = "PRJNA414036" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26790819 | 26790819 | PRJNA414036_P_NODE_78081_length_166_cov_2.595420_g76342_i0 | PRJNA414036 | 78081 | 166 | 2.59542 | 4.3083972 | Lumbricillus lineatus | 735370 | Annelida | Annelida | 51.2 | 2.08e-6 | NR | AMY27773.1 | 735370 | g76342 | i0 | 55.6 | 2.43975903614458 | 45 | 20 | 81.3 | 0 | 135 | 1 | 61 | 105 | AMY27773.1 histone H3, partial [Lumbricillus lineatus] | diamond | 405 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Enchytraeida | Enchytraeidae | Lumbricillus | Lumbricillus lineatus | |
| 27186825 | 27186825 | PRJNA414036_P_NODE_35742_length_248_cov_2.643192_g34006_i0 | PRJNA414036 | 35742 | 248 | 2.643192 | 6.55511616 | Metazoa | 33208 | Annelida | Annelida | 57 | 3.86e-7 | NR | CAH1801796.1 | 6347 | g34006 | i0 | 50.8 | 506.370967741935 | 65 | 32 | 78.6 | 0 | 204 | 10 | 1834 | 1898 | CAH1801796.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 125580 | 57.4 | 0.993031358885017 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28481805 | 28481805 | PRJNA414036_P_NODE_16746_length_365_cov_2.472727_g15043_i0 | PRJNA414036 | 16746 | 365 | 2.472727 | 9.02545355 | Metazoa | 33208 | Annelida | Annelida | 44.3 | 0.0387 | NR | CAH1796151.1 | 6347 | g15043 | i0 | 62.5 | 66.2794520547945 | 48 | 18 | 39.5 | 0 | 144 | 1 | 261 | 308 | CAH1796151.1 unnamed protein product [Owenia fusiformis] | diamond | 24192 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28513366 | 28513366 | PRJNA414036_P_NODE_73707_length_174_cov_13.431655_g71968_i0 | PRJNA414036 | 73707 | 174 | 13.431655 | 23.3710797 | Metazoa | 33208 | Annelida | Annelida | 73.6 | 6.27e-15 | NR | KAK2181635.1 | 27915 | g71968 | i0 | 62.5 | 1.93103448275862 | 56 | 21 | 96.6 | 0 | 5 | 172 | 54 | 109 | KAK2181635.1 hypothetical protein NP493_386g01017 [Ridgeia piscesae] | diamond | 336 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 28528493 | 28528493 | PRJNA414036_P_NODE_85407_length_155_cov_1.433333_g83668_i0 | PRJNA414036 | 85407 | 155 | 1.433333 | 2.22166615 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 43.1 | 0.00833 | NR | KAK2163986.1 | 53620 | g83668 | i0 | 74.2 | 30.8709677419355 | 31 | 8 | 60 | 0 | 109 | 17 | 117 | 147 | KAK2163986.1 hypothetical protein LSH36_71g06004 [Paralvinella palmiformis] | diamond | 4785 | 43.5 | 0.990804597701149 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 28671338 | 28671338 | PRJNA414036_P_NODE_81507_length_160_cov_17.128000_g79768_i0 | PRJNA414036 | 81507 | 160 | 17.128 | 27.4048 | Metazoa | 33208 | Annelida | Annelida | 56.6 | 1.1e-7 | NR | KAK2164473.1 | 53620 | g79768 | i0 | 64 | 14.0625 | 50 | 18 | 93.8 | 0 | 7 | 156 | 45 | 94 | KAK2164473.1 hypothetical protein LSH36_63g08036 [Paralvinella palmiformis] | diamond | 2250 | 57 | 0.992982456140351 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 28702896 | 28702896 | PRJNA414036_P_NODE_36387_length_245_cov_5.104762_g34651_i0 | PRJNA414036 | 36387 | 245 | 5.104762 | 12.5066669 | Metazoa | 33208 | Annelida | Annelida | 76.6 | 4.37e-14 | NR | XP_009030811.1 | 6412 | g34651 | i0 | 63 | 25.7510204081633 | 81 | 30 | 99.2 | 0 | 3 | 245 | 198 | 278 | XP_009030811.1 hypothetical protein HELRODRAFT_194553 [Helobdella robusta] | diamond | 6309 | 77 | 0.994805194805195 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28828948 | 28828948 | PRJNA414036_P_NODE_24668_length_305_cov_3.918519_g22936_i0 | PRJNA414036 | 24668 | 305 | 3.918519 | 11.95148295 | Opisthokonta | 33154 | Annelida | Annelida | 61.6 | 1.16e-8 | NR | XP_009023783.1 | 6412 | g22936 | i0 | 66 | 6.9344262295082 | 47 | 16 | 46.2 | 0 | 5 | 145 | 29 | 75 | XP_009023783.1 hypothetical protein HELRODRAFT_113995 [Helobdella robusta] | diamond | 2115 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28970373 | 28970373 | PRJNA414036_P_NODE_21028_length_329_cov_8.255102_g19301_i0 | PRJNA414036 | 21028 | 329 | 8.255102 | 27.15928558 | Hydroides elegans | 216498 | Annelida | Annelida | 64.7 | 2.28e-10 | NR | BAF63847.1 | 216498 | g19301 | i0 | 79.5 | 0.802431610942249 | 44 | 9 | 40.1 | 0 | 244 | 113 | 7 | 50 | BAF63847.1 putative F0 subunit of ATP synthase [Hydroides elegans] | diamond | 264 | 65.1 | 0.993855606758833 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Serpulidae | Hydroides | Hydroides elegans | |
| 28970381 | 28970381 | PRJNA414036_P_NODE_8488_length_456_cov_11.247031_g7111_i0 | PRJNA414036 | 8488 | 456 | 11.247031 | 51.28646136 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 53.1 | 7.26e-5 | NR | CAD5125663.1 | 2664684 | g7111 | i0 | 36.1 | 6.61184210526316 | 147 | 94 | 96.7 | 0 | 6 | 446 | 116 | 262 | CAD5125663.1 DgyrCDS13864 [Dimorphilus gyrociliatus] | diamond | 3015 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 29317596 | 29317596 | PRJNA414036_P_NODE_59229_length_219_cov_9.543478_g57490_i0 | PRJNA414036 | 59229 | 219 | 9.543478 | 20.90021682 | Owenia fusiformis | 6347 | Annelida | Annelida | 52.4 | 1.11e-5 | NR | CAH1774925.1 | 6347 | g57490 | i0 | 51.4 | 56.5753424657534 | 70 | 34 | 95.9 | 0 | 210 | 1 | 131 | 200 | CAH1774925.1 unnamed protein product [Owenia fusiformis] | diamond | 12390 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29492099 | 29492099 | PRJNA414036_P_NODE_20010_length_337_cov_6.493377_g18284_i0 | PRJNA414036 | 20010 | 337 | 6.493377 | 21.88268049 | Metazoa | 33208 | Annelida | Annelida | 59.3 | 1.59e-7 | NR | XP_009009636.1 | 6412 | g18284 | i0 | 87.9 | 16.1572700296736 | 33 | 4 | 29.4 | 0 | 230 | 328 | 80 | 112 | XP_009009636.1 hypothetical protein HELRODRAFT_155612 [Helobdella robusta] | diamond | 5445 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 29632984 | 29632984 | PRJNA414036_P_NODE_4270_length_541_cov_4.788538_g3468_i0 | PRJNA414036 | 4270 | 541 | 4.788538 | 25.90599058 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 60.5 | 5.16e-8 | NR | CAD5111098.1 | 2664684 | g3468 | i0 | 56.8 | 0.820702402957486 | 74 | 32 | 41 | 0 | 539 | 318 | 68 | 141 | CAD5111098.1 DgyrCDS444 [Dimorphilus gyrociliatus] | diamond | 444 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 29664596 | 29664596 | PRJNA414036_P_NODE_74490_length_173_cov_1.913043_g72751_i0 | PRJNA414036 | 74490 | 173 | 1.913043 | 3.30956439 | Ridgeia piscesae | 27915 | Annelida | Annelida | 40.8 | 0.0335 | NR | KAK2181635.1 | 27915 | g72751 | i0 | 47.8 | 0.797687861271676 | 46 | 24 | 79.8 | 0 | 167 | 30 | 78 | 123 | KAK2181635.1 hypothetical protein NP493_386g01017 [Ridgeia piscesae] | diamond | 138 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 30282162 | 30282162 | PRJNA414036_P_NODE_80012_length_163_cov_1.656250_g78273_i0 | PRJNA414036 | 80012 | 163 | 1.65625 | 2.6996875 | Metazoa | 33208 | Annelida | Annelida | 48.9 | 8.21e-5 | NR | CAH1800649.1 | 6347 | g78273 | i0 | 67.3 | 94.6932515337423 | 49 | 16 | 90.2 | 0 | 3 | 149 | 2030 | 2078 | CAH1800649.1 unnamed protein product [Owenia fusiformis] | diamond | 15435 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30549421 | 30549421 | PRJNA414036_P_NODE_60293_length_215_cov_3.833333_g58554_i0 | PRJNA414036 | 60293 | 215 | 3.833333 | 8.24166595 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 63.9 | 6.77e-10 | NR | CAD5117832.1 | 2664684 | g58554 | i0 | 65.2 | 1.92558139534884 | 46 | 11 | 57.2 | 1 | 145 | 23 | 265 | 310 | CAD5117832.1 DgyrCDS6578 [Dimorphilus gyrociliatus] | diamond | 414 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 30833840 | 30833840 | PRJNA414036_P_NODE_80954_length_161_cov_4.682540_g79215_i0 | PRJNA414036 | 80954 | 161 | 4.68254 | 7.5388894 | Helobdella robusta | 6412 | Annelida | Annelida | 47.4 | 2.77e-4 | NR | XP_009023447.1 | 6412 | g79215 | i0 | 73.8 | 2.34782608695652 | 42 | 11 | 78.3 | 0 | 36 | 161 | 151 | 192 | XP_009023447.1 hypothetical protein HELRODRAFT_176975 [Helobdella robusta] | diamond | 378 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 31008489 | 31008489 | PRJNA414036_P_NODE_894_length_746_cov_3.748242_g730_i0 | PRJNA414036 | 894 | 746 | 3.748242 | 27.96188532 | root | 1 | Root_unresolved | Root_unresolved | 122 | 1.57e-27 | NR | ELU09753.1 | 283909 | g730 | i0 | 60.9 | 44.0026809651475 | 115 | 45 | 46.2 | 0 | 302 | 646 | 374 | 488 | ELU09753.1 hypothetical protein CAPTEDRAFT_225689 [Capitella teleta] | diamond | 32826 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 31687368 | 31687368 | PRJNA414036_P_NODE_7137_length_477_cov_3.615385_g5906_i0 | PRJNA414036 | 7137 | 477 | 3.615385 | 17.24538645 | Ridgeia piscesae | 27915 | Annelida | Annelida | 69.7 | 5.95e-12 | NR | KAK2186780.1 | 27915 | g5906 | i0 | 57.1 | 0.440251572327044 | 70 | 30 | 44 | 0 | 162 | 371 | 56 | 125 | KAK2186780.1 hypothetical protein NP493_189g03019 [Ridgeia piscesae] | diamond | 210 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 31704059 | 31704059 | PRJNA414036_P_NODE_13337_length_397_cov_5.287293_g11700_i0 | PRJNA414036 | 13337 | 397 | 5.287293 | 20.99055321 | Opisthokonta | 33154 | Annelida | Annelida | 46.2 | 0.0126 | NR | XP_009015678.1 | 6412 | g11700 | i0 | 61.8 | 165.831234256927 | 55 | 21 | 41.6 | 0 | 232 | 396 | 554 | 608 | XP_009015678.1 hypothetical protein HELRODRAFT_149039, partial [Helobdella robusta] | diamond | 65835 | 46.6 | 0.991416309012876 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 31704062 | 31704062 | PRJNA414036_P_NODE_31777_length_265_cov_5.495652_g30041_i0 | PRJNA414036 | 31777 | 265 | 5.495652 | 14.5634778 | Metazoa | 33208 | Annelida | Annelida | 63.9 | 1.72e-9 | NR | CAH1793612.1 | 6347 | g30041 | i0 | 53.7 | 17.6377358490566 | 82 | 38 | 92.8 | 0 | 19 | 264 | 96 | 177 | CAH1793612.1 unnamed protein product [Owenia fusiformis] | diamond | 4674 | 64.3 | 0.993779160186625 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31925458 | 31925458 | PRJNA414036_P_NODE_83597_length_157_cov_3.344262_g81858_i0 | PRJNA414036 | 83597 | 157 | 3.344262 | 5.25049134 | Metazoa | 33208 | Annelida | Annelida | 50.4 | 2.14e-5 | NR | CAH1776247.1 | 6347 | g81858 | i0 | 65.3 | 251.866242038217 | 49 | 17 | 93.6 | 0 | 155 | 9 | 621 | 669 | CAH1776247.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 39543 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32003851 | 32003851 | PRJNA414036_P_NODE_27618_length_287_cov_2.031746_g25883_i0 | PRJNA414036 | 27618 | 287 | 2.031746 | 5.83111102 | Owenia fusiformis | 6347 | Annelida | Annelida | 44.7 | 0.0128 | NR | CAH1778284.1 | 6347 | g25883 | i0 | 85 | 0.209059233449477 | 20 | 3 | 20.9 | 0 | 114 | 173 | 7 | 26 | CAH1778284.1 unnamed protein product [Owenia fusiformis] | diamond | 60 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32257272 | 32257272 | PRJNA414036_P_NODE_88538_length_151_cov_1.508621_g86799_i0 | PRJNA414036 | 88538 | 151 | 1.508621 | 2.27801771 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 62.4 | 8.62e-10 | NR | KAI0208181.1 | 104711 | g86799 | i0 | 84.8 | 39.9933774834437 | 33 | 5 | 65.6 | 0 | 45 | 143 | 105 | 137 | KAI0208181.1 Golgi phosphoprotein 3 [Lamellibrachia satsuma] | diamond | 6039 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 32352070 | 32352070 | PRJNA414036_P_NODE_36799_length_244_cov_1.889952_g35063_i0 | PRJNA414036 | 36799 | 244 | 1.889952 | 4.61148288 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 88.6 | 2.82e-18 | NR | KAK2142785.1 | 53620 | g35063 | i0 | 61.6 | 0.897540983606557 | 73 | 28 | 89.8 | 0 | 11 | 229 | 668 | 740 | KAK2142785.1 hypothetical protein LSH36_913g00008 [Paralvinella palmiformis] | diamond | 219 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 32383505 | 32383505 | PRJNA414036_P_NODE_9719_length_439_cov_3.893564_g8236_i0 | PRJNA414036 | 9719 | 439 | 3.893564 | 17.09274596 | Helobdella robusta | 6412 | Annelida | Annelida | 63.2 | 7.9e-10 | NR | XP_009022547.1 | 6412 | g8236 | i0 | 56.8 | 3.03416856492027 | 74 | 32 | 50.6 | 0 | 55 | 276 | 22 | 95 | XP_009022547.1 hypothetical protein HELRODRAFT_67237, partial [Helobdella robusta] | diamond | 1332 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 32446971 | 32446971 | PRJNA414036_P_NODE_24079_length_309_cov_2.233577_g22347_i0 | PRJNA414036 | 24079 | 309 | 2.233577 | 6.90175293 | Capitella teleta | 283909 | Annelida | Annelida | 45.8 | 0.00469 | NR | ELU01028.1 | 283909 | g22347 | i0 | 59.3 | 1.04854368932039 | 54 | 22 | 52.4 | 0 | 294 | 133 | 49 | 102 | ELU01028.1 hypothetical protein CAPTEDRAFT_1495 [Capitella teleta] | diamond | 324 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 32747297 | 32747297 | PRJNA414036_P_NODE_58500_length_222_cov_6.807487_g56761_i0 | PRJNA414036 | 58500 | 222 | 6.807487 | 15.11262114 | Metazoa | 33208 | Annelida | Annelida | 73.2 | 5.23e-13 | NR | CAH1774925.1 | 6347 | g56761 | i0 | 65.7 | 98.3783783783784 | 70 | 24 | 94.6 | 0 | 9 | 218 | 133 | 202 | CAH1774925.1 unnamed protein product [Owenia fusiformis] | diamond | 21840 | 73.6 | 0.994565217391304 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32887985 | 32887985 | PRJNA414036_P_NODE_70060_length_183_cov_2.898649_g68321_i0 | PRJNA414036 | 70060 | 183 | 2.898649 | 5.30452767 | Capitella teleta | 283909 | Annelida | Annelida | 42.7 | 0.0177 | NR | ELU07808.1 | 283909 | g68321 | i0 | 66.7 | 8.95081967213115 | 42 | 14 | 68.9 | 0 | 183 | 58 | 587 | 628 | ELU07808.1 hypothetical protein CAPTEDRAFT_152314 [Capitella teleta] | diamond | 1638 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta |
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);;