contig_metadata
27 rows where bioproject = "PRJNA270367" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 370014 | 370014 | PRJNA270367_P_NODE_26901_length_219_cov_1.347059_g26696_i0 | PRJNA270367 | 26901 | 219 | 1.347059 | 2.95005921 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 4.16e-4 | NTclustered | gi|2920003563|emb|OZ238869.1| | 1046305 | g26696 | i0 | 97.059 | 0.301369863013699 | 34 | 1 | 16 | 0 | 98 | 131 | 8686968 | 8686935 | Ailoscolex lacteospumosus genome assembly, chromosome: 10 | blastn | 66 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 370163 | 370163 | PRJNA270367_P_NODE_4241_length_665_cov_1.571429_g4052_i0 | PRJNA270367 | 4241 | 665 | 1.571429 | 10.45000285 | Metazoa | 33208 | Annelida | Annelida | 322 | 1.4399999999999997e-106 | NR | CAH1795591.1 | 6347 | g4052 | i0 | 68.8 | 46.7548872180451 | 221 | 69 | 99.7 | 0 | 664 | 2 | 124 | 344 | CAH1795591.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 31092 | 325 | 0.990769230769231 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 4197125 | 4197125 | PRJNA270367_P_NODE_2664_length_846_cov_5.690088_g2492_i0 | PRJNA270367 | 2664 | 846 | 5.690088 | 48.13814448 | Metazoa | 33208 | Annelida | Annelida | 294 | 1.03e-95 | NR | CAH1793798.1 | 6347 | g2492 | i0 | 66 | 18.1489361702128 | 215 | 73 | 76.2 | 0 | 839 | 195 | 1 | 215 | CAH1793798.1 unnamed protein product [Owenia fusiformis] | diamond | 15354 | 296 | 0.993243243243243 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 4197311 | 4197311 | PRJNA270367_P_NODE_484_length_2230_cov_2.542412_g385_i0 | PRJNA270367 | 484 | 2230 | 2.542412 | 56.6957876 | Metazoa | 33208 | Annelida | Annelida | 635 | 1.8299999999999991e-215 | NR | WRM33297.1 | 6396 | g385 | i0 | 51.4 | 22.3587443946188 | 720 | 322 | 94.3 | 11 | 2191 | 89 | 39 | 749 | WRM33297.1 heat shock protein 90B1 [Eisenia fetida] | diamond | 49860 | 636 | 0.998427672955975 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia fetida | |
| 8710452 | 8710452 | PRJNA270367_P_NODE_19347_length_276_cov_1.488987_g19142_i0 | PRJNA270367 | 19347 | 276 | 1.488987 | 4.10960412 | Owenia fusiformis | 6347 | Annelida | Annelida | 135 | 2.0999999999999999e-38 | NR | CAH1778456.1 | 6347 | g19142 | i0 | 75.9 | 0.902173913043478 | 83 | 20 | 90.2 | 0 | 250 | 2 | 17 | 99 | CAH1778456.1 unnamed protein product [Owenia fusiformis] | diamond | 249 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 14399261 | 14399261 | PRJNA270367_P_NODE_8312_length_465_cov_9.302885_g8113_i0 | PRJNA270367 | 8312 | 465 | 9.302885 | 43.25841525 | Opisthokonta | 33154 | Annelida | Annelida | 176 | 1.32e-53 | NR | CAH1785383.1 | 6347 | g8113 | i0 | 65.9 | 22.8516129032258 | 132 | 45 | 85.2 | 0 | 449 | 54 | 1 | 132 | CAH1785383.1 unnamed protein product [Owenia fusiformis] | diamond | 10626 | 177 | 0.994350282485876 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 15085923 | 15085923 | PRJNA270367_P_NODE_43432_length_165_cov_0.896552_g43227_i0 | PRJNA270367 | 43432 | 165 | 0.896552 | 1.4793108 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 59.3 | 1.35e-8 | NR | KAK2141670.1 | 53620 | g43227 | i0 | 53.5 | 2.18181818181818 | 43 | 20 | 78.2 | 0 | 136 | 8 | 80 | 122 | KAK2141670.1 hypothetical protein LSH36_1059g02002 [Paralvinella palmiformis] | diamond | 360 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 15672967 | 15672967 | PRJNA270367_P_NODE_8613_length_457_cov_1.196078_g8414_i0 | PRJNA270367 | 8613 | 457 | 1.196078 | 5.46607646 | Theromyzon tessulatum | 13286 | Annelida | Annelida | 147 | 5.15e-40 | NR | AAN28680.1 | 13286 | g8414 | i0 | 57.3 | 0.938730853391685 | 143 | 49 | 86.7 | 6 | 3 | 398 | 210 | 351 | AAN28680.1 cathepsin L [Theromyzon tessulatum] | diamond | 429 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Theromyzon | Theromyzon tessulatum | |
| 23321854 | 23321854 | PRJNA270367_P_NODE_12379_length_374_cov_1.160000_g12177_i0 | PRJNA270367 | 12379 | 374 | 1.16 | 4.3384 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.01 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g12177 | i0 | 90.476 | 0.561497326203209 | 42 | 3 | 11 | 1 | 123 | 163 | 10476896 | 10476855 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 210 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 24596221 | 24596221 | PRJNA270367_P_NODE_34020_length_187_cov_1.507246_g33815_i0 | PRJNA270367 | 34020 | 187 | 1.507246 | 2.81855002 | Metazoa | 33208 | Annelida | Annelida | 92 | 3.85e-20 | NR | CAH1802234.1 | 6347 | g33815 | i0 | 71.4 | 17.9358288770053 | 63 | 17 | 99.5 | 1 | 2 | 187 | 154 | 216 | CAH1802234.1 unnamed protein product [Owenia fusiformis] | diamond | 3354 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 26680126 | 26680126 | PRJNA270367_P_NODE_10961_length_400_cov_1.148148_g10759_i0 | PRJNA270367 | 10961 | 400 | 1.148148 | 4.592592 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 105 | 8.22e-25 | NR | XP_009022843.1 | 6412 | g10759 | i0 | 64.3 | 4.2675 | 98 | 27 | 72.8 | 4 | 15 | 305 | 167 | 257 | XP_009022843.1 hypothetical protein HELRODRAFT_185039 [Helobdella robusta] | diamond | 1707 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 27074019 | 27074019 | PRJNA270367_P_NODE_34882_length_184_cov_1.540741_g34677_i0 | PRJNA270367 | 34882 | 184 | 1.540741 | 2.83496344 | Pectinaria gouldii | 260746 | Annelida | Annelida | 72 | 2.58e-14 | NR | ACJ09354.1 | 260746 | g34677 | i0 | 65.6 | 0.994565217391304 | 61 | 21 | 99.5 | 0 | 183 | 1 | 2 | 62 | ACJ09354.1 hypothetical protein [Pectinaria gouldii] | diamond | 183 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Pectinariidae | Pectinaria | Pectinaria gouldii | |
| 27232061 | 27232061 | PRJNA270367_P_NODE_41223_length_167_cov_1.338983_g41018_i0 | PRJNA270367 | 41223 | 167 | 1.338983 | 2.23610161 | Helobdella robusta | 6412 | Annelida | Annelida | 48.1 | 1.34e-4 | NR | XP_009027767.1 | 6412 | g41018 | i0 | 72.4 | 7.07784431137725 | 29 | 8 | 52.1 | 0 | 3 | 89 | 23 | 51 | XP_009027767.1 hypothetical protein HELRODRAFT_87750, partial [Helobdella robusta] | diamond | 1182 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 27376553 | 27376553 | PRJNA270367_P_NODE_41503_length_167_cov_0.881356_g41298_i0 | PRJNA270367 | 41503 | 167 | 0.881356 | 1.47186452 | Metazoa | 33208 | Annelida | Annelida | 55.5 | 4.22e-7 | NR | KAK2150428.1 | 53620 | g41298 | i0 | 53.8 | 9.17964071856287 | 52 | 24 | 93.4 | 0 | 156 | 1 | 97 | 148 | KAK2150428.1 hypothetical protein LSH36_405g00044 [Paralvinella palmiformis] | diamond | 1533 | 55.8 | 0.99462365591397806 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 27629046 | 27629046 | PRJNA270367_P_NODE_29384_length_206_cov_1.980892_g29179_i0 | PRJNA270367 | 29384 | 206 | 1.980892 | 4.08063752 | Metazoa | 33208 | Annelida | Annelida | 80.5 | 9.08e-16 | NR | XP_009019471.1 | 6412 | g29179 | i0 | 65.7 | 37.0776699029126 | 67 | 21 | 97.6 | 2 | 206 | 6 | 19 | 83 | XP_009019471.1 hypothetical protein HELRODRAFT_94372 [Helobdella robusta] | diamond | 7638 | 80.9 | 0.995055624227441 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28021762 | 28021762 | PRJNA270367_P_NODE_40265_length_168_cov_1.327731_g40060_i0 | PRJNA270367 | 40265 | 168 | 1.327731 | 2.23058808 | Helobdella robusta | 6412 | Annelida | Annelida | 59.3 | 1.97e-8 | NR | XP_009029697.1 | 6412 | g40060 | i0 | 53.1 | 0.875 | 49 | 18 | 78.6 | 1 | 34 | 165 | 278 | 326 | XP_009029697.1 hypothetical protein HELRODRAFT_157973 [Helobdella robusta] | diamond | 147 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28621636 | 28621636 | PRJNA270367_P_NODE_40547_length_168_cov_0.873950_g40342_i0 | PRJNA270367 | 40547 | 168 | 0.87395 | 1.468236 | Owenia fusiformis | 6347 | Annelida | Annelida | 77.4 | 7.94e-15 | NR | CAH1796120.1 | 6347 | g40342 | i0 | 63.6 | 4.91071428571429 | 55 | 20 | 98.2 | 0 | 2 | 166 | 582 | 636 | CAH1796120.1 unnamed protein product [Owenia fusiformis] | diamond | 825 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29000743 | 29000743 | PRJNA270367_P_NODE_22988_length_244_cov_0.994872_g22783_i0 | PRJNA270367 | 22988 | 244 | 0.994872 | 2.42748768 | Spirobranchus lamarcki | 2082999 | Annelida | Annelida | 149 | 1.4099999999999999e-42 | NR | ADB11399.1 | 2082999 | g22783 | i0 | 76.9 | 0.959016393442623 | 78 | 17 | 95.9 | 1 | 10 | 243 | 53 | 129 | ADB11399.1 bacterial endonuclease I-like protein, partial [Spirobranchus lamarcki] | diamond | 234 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Serpulidae | Spirobranchus | Spirobranchus lamarcki | |
| 29018431 | 29018431 | PRJNA270367_P_NODE_12168_length_377_cov_2.137195_g11966_i0 | PRJNA270367 | 12168 | 377 | 2.137195 | 8.05722515 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 147 | 1.91e-38 | NR | XP_009028811.1 | 6412 | g11966 | i0 | 74.5 | 125.403183023873 | 102 | 26 | 81.2 | 0 | 65 | 370 | 11 | 112 | XP_009028811.1 hypothetical protein HELRODRAFT_69344 [Helobdella robusta] | diamond | 47277 | 148 | 0.993243243243243 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 29694696 | 29694696 | PRJNA270367_P_NODE_38310_length_172_cov_1.691057_g38105_i0 | PRJNA270367 | 38310 | 172 | 1.691057 | 2.90861804 | Owenia fusiformis | 6347 | Annelida | Annelida | 60.1 | 1.06e-8 | NR | CAH1787209.1 | 6347 | g38105 | i0 | 46.6 | 1.01162790697674 | 58 | 29 | 97.7 | 1 | 3 | 170 | 996 | 1053 | CAH1787209.1 unnamed protein product [Owenia fusiformis] | diamond | 174 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29852973 | 29852973 | PRJNA270367_P_NODE_12531_length_371_cov_1.680124_g12329_i0 | PRJNA270367 | 12531 | 371 | 1.680124 | 6.23326004 | Owenia fusiformis | 6347 | Annelida | Annelida | 47.8 | 0.00238 | NR | CAH1786800.1 | 6347 | g12329 | i0 | 51.2 | 0.630727762803235 | 41 | 20 | 33.2 | 0 | 131 | 9 | 51 | 91 | CAH1786800.1 unnamed protein product [Owenia fusiformis] | diamond | 234 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30376554 | 30376554 | PRJNA270367_P_NODE_12652_length_369_cov_1.728125_g12450_i0 | PRJNA270367 | 12652 | 369 | 1.728125 | 6.37678125 | Metazoa | 33208 | Annelida | Annelida | 101 | 3.89e-24 | NR | XP_009030877.1 | 6412 | g12450 | i0 | 41.9 | 13.219512195122 | 124 | 69 | 98.4 | 2 | 363 | 1 | 4 | 127 | XP_009030877.1 hypothetical protein HELRODRAFT_104248 [Helobdella robusta] | diamond | 4878 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 30534037 | 30534037 | PRJNA270367_P_NODE_32513_length_193_cov_1.229167_g32308_i0 | PRJNA270367 | 32513 | 193 | 1.229167 | 2.37229231 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 70.5 | 3.21e-12 | NR | KAK2194039.1 | 27915 | g32308 | i0 | 57.1 | 4.92746113989637 | 63 | 27 | 97.9 | 0 | 193 | 5 | 26 | 88 | KAK2194039.1 hypothetical protein NP493_3g07025 [Ridgeia piscesae] | diamond | 951 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 30990467 | 30990467 | PRJNA270367_P_NODE_34174_length_187_cov_1.036232_g33969_i0 | PRJNA270367 | 34174 | 187 | 1.036232 | 1.93775384 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 42.7 | 0.0185 | NR | CAD5123953.1 | 2664684 | g33969 | i0 | 41.3 | 3.03208556149733 | 63 | 36 | 99.5 | 1 | 187 | 2 | 312 | 374 | CAD5123953.1 DgyrCDS12258 [Dimorphilus gyrociliatus] | diamond | 567 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 31464727 | 31464727 | PRJNA270367_P_NODE_14976_length_331_cov_1.308511_g14771_i0 | PRJNA270367 | 14976 | 331 | 1.308511 | 4.33117141 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 46.2 | 0.00552 | NR | KAI0211808.1 | 104711 | g14771 | i0 | 40 | 0.6797583081571 | 75 | 39 | 63.4 | 3 | 13 | 222 | 187 | 260 | KAI0211808.1 hypothetical protein LSAT2_003332 [Lamellibrachia satsuma] | diamond | 225 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 31749050 | 31749050 | PRJNA270367_P_NODE_21457_length_256_cov_1.265700_g21252_i0 | PRJNA270367 | 21457 | 256 | 1.2657 | 3.240192 | Owenia fusiformis | 6347 | Annelida | Annelida | 65.9 | 3.06e-10 | NR | CAH1776584.1 | 6347 | g21252 | i0 | 43.4 | 2.671875 | 76 | 41 | 89.1 | 1 | 4 | 231 | 210 | 283 | CAH1776584.1 unnamed protein product [Owenia fusiformis] | diamond | 684 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32652118 | 32652118 | PRJNA270367_P_NODE_14960_length_331_cov_1.751773_g14755_i0 | PRJNA270367 | 14960 | 331 | 1.751773 | 5.79836863 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 118 | 1.08e-28 | NR | CAH1785551.1 | 6347 | g14755 | i0 | 63.3 | 21.1359516616314 | 90 | 32 | 81.6 | 1 | 61 | 330 | 27 | 115 | CAH1785551.1 unnamed protein product [Owenia fusiformis] | diamond | 6996 | 118 | 1 | 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);;