contig_metadata
27 rows where analysis = "blastn", bioproject = "PRJNA986481" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 973140 | 973140 | PRJNA986481_P_NODE_10641_length_502_cov_3.783664_g10120_i0 | PRJNA986481 | 10641 | 502 | 3.783664 | 18.99399328 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.049 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g10120 | i0 | 100 | 0.0557768924302789 | 28 | 0 | 6 | 0 | 109 | 136 | 11432275 | 11432302 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 973462 | 973462 | PRJNA986481_P_NODE_2921_length_873_cov_5.063107_g2570_i0 | PRJNA986481 | 2921 | 873 | 5.063107 | 44.20092411 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.024 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g2570 | i0 | 100 | 0.0332187857961054 | 29 | 0 | 3 | 0 | 324 | 352 | 2737464 | 2737436 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 2547729 | 2547729 | PRJNA986481_P_NODE_2462_length_936_cov_10.933484_g2140_i0 | PRJNA986481 | 2462 | 936 | 10.933484 | 102.33741024 | Metazoa | 33208 | Annelida | Annelida | 54.7 | 0.026 | NTclustered | gi|2918369706|emb|OZ237788.1| | 311461 | g2140 | i0 | 96.875 | 0.335470085470085 | 32 | 1 | 3 | 0 | 280 | 311 | 6726403 | 6726434 | Hirudo verbana genome assembly, chromosome: 10 | blastn | 314 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 3524350 | 3524350 | PRJNA986481_P_NODE_49603_length_253_cov_0.990196_g49078_i0 | PRJNA986481 | 49603 | 253 | 0.990196 | 2.50519588 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g49078 | i0 | 97.059 | 1.80237154150198 | 34 | 0 | 13 | 1 | 191 | 223 | 3049039 | 3049072 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 456 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 4801091 | 4801091 | PRJNA986481_P_NODE_11664_length_480_cov_1.559165_g11141_i0 | PRJNA986481 | 11664 | 480 | 1.559165 | 7.483992 | Helobdella robusta | 6412 | Annelida | Annelida | 62.1 | 7.77e-5 | NTclustered | gi|675882807|ref|XM_009028658.1| | 6412 | g11141 | i0 | 91.111 | 12.6479166666667 | 45 | 4 | 9 | 0 | 420 | 464 | 1702 | 1746 | Helobdella robusta hypothetical protein partial mRNA | blastn | 6071 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 5100326 | 5100326 | PRJNA986481_P_NODE_24104_length_334_cov_1.764912_g23579_i0 | PRJNA986481 | 24104 | 334 | 1.764912 | 5.89480608 | Metazoa | 33208 | Annelida | Annelida | 272 | 2.22e-68 | NTclustered | gi|112144547|gb|DQ813398.1| | 27908 | g23579 | i0 | 83.446 | 96.0239520958084 | 296 | 46 | 88 | 3 | 35 | 329 | 86 | 379 | Siboglinum fiordicum elongation factor-1 alpha (EF-1 alpha) mRNA, partial cds | blastn | 32072 | 274 | 0.992700729927007 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Siboglinum | Siboglinum fiordicum | |
| 6077237 | 6077237 | PRJNA986481_P_NODE_7245_length_601_cov_7.157609_g6749_i0 | PRJNA986481 | 7245 | 601 | 7.157609 | 43.01723009 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.017 | NTclustered | gi|2920003593|emb|OZ238871.1| | 1046305 | g6749 | i0 | 100 | 0.0482529118136439 | 29 | 0 | 5 | 0 | 442 | 470 | 5940211 | 5940183 | Ailoscolex lacteospumosus genome assembly, chromosome: 12 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 11176538 | 11176538 | PRJNA986481_P_NODE_10769_length_499_cov_2.351111_g10247_i0 | PRJNA986481 | 10769 | 499 | 2.351111 | 11.73204389 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.049 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g10247 | i0 | 96.774 | 0.062124248496994 | 31 | 1 | 6 | 0 | 25 | 55 | 703661 | 703631 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 12452572 | 12452572 | PRJNA986481_P_NODE_21150_length_356_cov_4.514658_g20625_i0 | PRJNA986481 | 21150 | 356 | 4.514658 | 16.07218248 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.034 | NTclustered | gi|2920003608|emb|OZ238872.1| | 1046305 | g20625 | i0 | 100 | 0.0786516853932584 | 28 | 0 | 8 | 0 | 30 | 57 | 6043542 | 6043515 | Ailoscolex lacteospumosus genome assembly, chromosome: 13 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 12452586 | 12452586 | PRJNA986481_P_NODE_22170_length_348_cov_3.103679_g21645_i0 | PRJNA986481 | 22170 | 348 | 3.103679 | 10.80080292 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 65.8 | 4.23e-6 | NTclustered | gi|2920003527|emb|OZ238867.1| | 1046305 | g21645 | i0 | 97.436 | 0.192528735632184 | 39 | 0 | 11 | 1 | 9 | 47 | 2020515 | 2020478 | Ailoscolex lacteospumosus genome assembly, chromosome: 8 | blastn | 67 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 12453216 | 12453216 | PRJNA986481_P_NODE_63270_length_205_cov_5.070513_g62745_i0 | PRJNA986481 | 63270 | 205 | 5.070513 | 10.39455165 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.018 | NTclustered | gi|2920003563|emb|OZ238869.1| | 1046305 | g62745 | i0 | 96.875 | 0.15609756097561 | 32 | 0 | 15 | 1 | 66 | 96 | 9480900 | 9480931 | Ailoscolex lacteospumosus genome assembly, chromosome: 10 | blastn | 32 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 13727568 | 13727568 | PRJNA986481_P_NODE_60531_length_241_cov_1.041667_g60006_i0 | PRJNA986481 | 60531 | 241 | 1.041667 | 2.51041747 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369718|emb|OZ237791.1| | 311461 | g60006 | i0 | 94.595 | 0.286307053941909 | 37 | 1 | 15 | 1 | 125 | 160 | 5574797 | 5574761 | Hirudo verbana genome assembly, chromosome: 13 | blastn | 69 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 13727596 | 13727596 | PRJNA986481_P_NODE_62751_length_224_cov_6.794286_g62226_i0 | PRJNA986481 | 62751 | 224 | 6.794286 | 15.21920064 | Arenicola marina | 6344 | Annelida | Annelida | 159 | 1.14e-34 | NTclustered | gi|158187717|gb|EU124943.1| | 6344 | g62226 | i0 | 86 | 63.8258928571429 | 150 | 19 | 67 | 2 | 76 | 224 | 346 | 198 | Arenicola marina ribosomal protein rps18 mRNA, partial cds | blastn | 14297 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina | ||
| 15001396 | 15001396 | PRJNA986481_P_NODE_28272_length_308_cov_2.942085_g27747_i0 | PRJNA986481 | 28272 | 308 | 2.942085 | 9.0616218 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 62.1 | 4.78e-5 | NTclustered | gi|2920003644|emb|OZ238875.1| | 1046305 | g27747 | i0 | 94.872 | 2.3474025974026 | 39 | 2 | 13 | 0 | 269 | 307 | 5036847 | 5036885 | Ailoscolex lacteospumosus genome assembly, chromosome: 16 | blastn | 723 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 15001939 | 15001939 | PRJNA986481_P_NODE_6872_length_617_cov_3.443662_g6386_i0 | PRJNA986481 | 6872 | 617 | 3.443662 | 21.24739454 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 0.001 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g6386 | i0 | 94.595 | 0.106969205834684 | 37 | 2 | 6 | 0 | 378 | 414 | 20957926 | 20957890 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 66 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 16276146 | 16276146 | PRJNA986481_P_NODE_16233_length_407_cov_8.265363_g15708_i0 | PRJNA986481 | 16233 | 407 | 8.265363 | 33.64002741 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.003 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g15708 | i0 | 96.97 | 1.46191646191646 | 33 | 1 | 8 | 0 | 180 | 212 | 794670 | 794638 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 595 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 16276759 | 16276759 | PRJNA986481_P_NODE_55993_length_245_cov_3.489796_g55468_i0 | PRJNA986481 | 55993 | 245 | 3.489796 | 8.5500002 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g55468 | i0 | 100 | 0.240816326530612 | 30 | 0 | 12 | 0 | 149 | 178 | 1642247 | 1642276 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 59 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 17551181 | 17551181 | PRJNA986481_P_NODE_17954_length_386_cov_3.047478_g17429_i0 | PRJNA986481 | 17954 | 386 | 3.047478 | 11.76326508 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 63.9 | 1.7e-5 | NTclustered | gi|2920003578|emb|OZ238870.1| | 1046305 | g17429 | i0 | 97.368 | 0.248704663212435 | 38 | 0 | 10 | 1 | 185 | 221 | 23663812 | 23663849 | Ailoscolex lacteospumosus genome assembly, chromosome: 11 | blastn | 96 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 17551758 | 17551758 | PRJNA986481_P_NODE_54514_length_247_cov_1.020202_g53989_i0 | PRJNA986481 | 54514 | 247 | 1.020202 | 2.51989894 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 1.33e-4 | NTclustered | gi|2918369706|emb|OZ237788.1| | 311461 | g53989 | i0 | 73.913 | 0.651821862348178 | 161 | 36 | 64 | 6 | 9 | 166 | 1253200 | 1253043 | Hirudo verbana genome assembly, chromosome: 10 | blastn | 161 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 17849736 | 17849736 | PRJNA986481_P_NODE_36614_length_269_cov_2.004545_g36089_i0 | PRJNA986481 | 36614 | 269 | 2.004545 | 5.39222605 | Metazoa | 33208 | Annelida | Annelida | 62.1 | 4.09e-5 | NTclustered | gi|675877141|ref|XM_009025883.1| | 6412 | g36089 | i0 | 93.023 | 11.9368029739777 | 43 | 2 | 16 | 1 | 187 | 228 | 2282 | 2240 | Helobdella robusta hypothetical protein partial mRNA | blastn | 3211 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 19123381 | 19123381 | PRJNA986481_P_NODE_22415_length_346_cov_2.276094_g21890_i0 | PRJNA986481 | 22415 | 346 | 2.276094 | 7.87528524 | Metazoa | 33208 | Annelida | Annelida | 56.5 | 0.003 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g21890 | i0 | 96.97 | 0.407514450867052 | 33 | 1 | 10 | 0 | 29 | 61 | 11037900 | 11037932 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 141 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 20100542 | 20100542 | PRJNA986481_P_NODE_9976_length_518_cov_4.458422_g9456_i0 | PRJNA986481 | 9976 | 518 | 4.458422 | 23.09462596 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 0.001 | NTclustered | gi|2920003323|emb|OZ238861.1| | 1046305 | g9456 | i0 | 97.059 | 0.0656370656370656 | 34 | 1 | 7 | 0 | 7 | 40 | 12803541 | 12803574 | Ailoscolex lacteospumosus genome assembly, chromosome: 2 | blastn | 34 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 21375481 | 21375481 | PRJNA986481_P_NODE_20697_length_360_cov_2.196141_g20172_i0 | PRJNA986481 | 20697 | 360 | 2.196141 | 7.9061076 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.009 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g20172 | i0 | 92.105 | 0.183333333333333 | 38 | 3 | 11 | 0 | 226 | 263 | 101134 | 101097 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 66 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 22650230 | 22650230 | PRJNA986481_P_NODE_10158_length_514_cov_3.206452_g9637_i0 | PRJNA986481 | 10158 | 514 | 3.206452 | 16.48116328 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.014 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g9637 | i0 | 100 | 0.056420233463035 | 29 | 0 | 6 | 0 | 58 | 86 | 20588122 | 20588150 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 22651079 | 22651079 | PRJNA986481_P_NODE_63418_length_200_cov_4.019868_g62893_i0 | PRJNA986481 | 63418 | 200 | 4.019868 | 8.039736 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.001 | NTclustered | gi|2920003323|emb|OZ238861.1| | 1046305 | g62893 | i0 | 94.595 | 0.185 | 37 | 1 | 19 | 1 | 30 | 66 | 11795501 | 11795536 | Ailoscolex lacteospumosus genome assembly, chromosome: 2 | blastn | 37 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 23926524 | 23926524 | PRJNA986481_P_NODE_62459_length_227_cov_3.528090_g61934_i0 | PRJNA986481 | 62459 | 227 | 3.52809 | 8.0087643 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 4.35e-4 | NTclustered | gi|2920003484|emb|OZ238865.1| | 1046305 | g61934 | i0 | 91.111 | 0.198237885462555 | 45 | 1 | 19 | 3 | 158 | 200 | 9833964 | 9833921 | Ailoscolex lacteospumosus genome assembly, chromosome: 6 | blastn | 45 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 25199995 | 25199995 | PRJNA986481_P_NODE_4960_length_708_cov_4.034901_g4531_i0 | PRJNA986481 | 4960 | 708 | 4.034901 | 28.56709908 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 67.6 | 2.53e-6 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g4531 | i0 | 93.333 | 0.271186440677966 | 45 | 3 | 6 | 0 | 247 | 291 | 27355140 | 27355184 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 192 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus |
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);;