contig_metadata
28 rows where analysis = "blastn", bioproject = "PRJNA493827" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 470420 | 470420 | PRJNA493827_P_NODE_139341_length_289_cov_1.703704_g137143_i0 | PRJNA493827 | 139341 | 289 | 1.703704 | 4.92370456 | Hirudo verbana | 311461 | Annelida | Annelida | 202 | 2.51e-47 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g137143 | i0 | 80.144 | 1.50865051903114 | 277 | 49 | 96 | 1 | 3 | 279 | 9434447 | 9434717 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 436 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 474265 | 474265 | PRJNA493827_P_NODE_9241_length_1385_cov_2.019055_g8054_i0 | PRJNA493827 | 9241 | 1385 | 2.019055 | 27.96391175 | Hirudo verbana | 311461 | Annelida | Annelida | 62.1 | 2.36e-4 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g8054 | i0 | 97.222 | 0.675090252707581 | 36 | 1 | 3 | 0 | 1172 | 1207 | 10453370 | 10453335 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 935 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 1749252 | 1749252 | PRJNA493827_P_NODE_97022_length_348_cov_1.309091_g94824_i0 | PRJNA493827 | 97022 | 348 | 1.309091 | 4.55563668 | Mesenchytraeus cf. gelidus SL-2017 | 2052679 | Annelida | Annelida | 226 | 1.8399999999999998e-54 | NTclustered | gi|1068288576|gb|KU728806.1| | 2052679 | g94824 | i0 | 79.056 | 74.5402298850575 | 339 | 63 | 96 | 8 | 1 | 335 | 493 | 159 | Mesenchytraeus cf. gelidus SL-2017 actin mRNA, complete cds | blastn | 25940 | 226 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Enchytraeida | Enchytraeidae | Mesenchytraeus | Mesenchytraeus cf. gelidus SL-2017 | |
| 3020908 | 3020908 | PRJNA493827_P_NODE_126263_length_304_cov_1.467532_g124065_i0 | PRJNA493827 | 126263 | 304 | 1.467532 | 4.46129728 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.028 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g124065 | i0 | 100 | 0.0921052631578947 | 28 | 0 | 9 | 0 | 229 | 256 | 2838851 | 2838824 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 3024514 | 3024514 | PRJNA493827_P_NODE_68843_length_419_cov_1.745665_g66646_i0 | PRJNA493827 | 68843 | 419 | 1.745665 | 7.31433635 | Bradabyssa aff. villosa CMC02 | 868096 | Annelida | Annelida | 158 | 8.31e-34 | NTclustered | gi|304269376|gb|HM473202.1| | 868096 | g66646 | i0 | 78.481 | 53.1837708830549 | 237 | 45 | 57 | 4 | 183 | 419 | 457 | 687 | Brada villosa CMC02 voucher BIOUG<CAN>:BAMPOL0433 28S ribosomal RNA gene, partial sequence | blastn | 22284 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Flabelligeridae | Bradabyssa | Bradabyssa aff. villosa CMC02 | |
| 4299117 | 4299117 | PRJNA493827_P_NODE_231944_length_241_cov_0.916667_g229746_i0 | PRJNA493827 | 231944 | 241 | 0.916667 | 2.20916747 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g229746 | i0 | 100 | 0.485477178423237 | 30 | 0 | 12 | 0 | 137 | 166 | 487716 | 487745 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 117 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 4299724 | 4299724 | PRJNA493827_P_NODE_39184_length_584_cov_2.898239_g37006_i0 | PRJNA493827 | 39184 | 584 | 2.898239 | 16.92571576 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 93.5 | 3.4e-14 | NTclustered | gi|2920003608|emb|OZ238872.1| | 1046305 | g37006 | i0 | 83.168 | 3.11472602739726 | 101 | 17 | 20 | 0 | 269 | 369 | 4362289 | 4362189 | Ailoscolex lacteospumosus genome assembly, chromosome: 13 | blastn | 1819 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 5576529 | 5576529 | PRJNA493827_P_NODE_42145_length_559_cov_1.818930_g39959_i0 | PRJNA493827 | 42145 | 559 | 1.81893 | 10.1678187 | Helobdella robusta | 6412 | Annelida | Annelida | 54.7 | 0.015 | NTclustered | gi|675848801|ref|XM_009011713.1| | 6412 | g39959 | i0 | 96.875 | 0.0572450805008945 | 32 | 1 | 6 | 0 | 60 | 91 | 1025 | 994 | Helobdella robusta hypothetical protein partial mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 6848306 | 6848306 | PRJNA493827_P_NODE_156446_length_274_cov_1.283582_g154248_i0 | PRJNA493827 | 156446 | 274 | 1.283582 | 3.51701468 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 5.41e-4 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g154248 | i0 | 97.059 | 2.42335766423358 | 34 | 1 | 12 | 0 | 5 | 38 | 1147419 | 1147386 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 664 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 6850499 | 6850499 | PRJNA493827_P_NODE_40226_length_575_cov_1.221116_g38046_i0 | PRJNA493827 | 40226 | 575 | 1.221116 | 7.021417 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.004 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g38046 | i0 | 96.97 | 0.0573913043478261 | 33 | 1 | 6 | 0 | 341 | 373 | 14622783 | 14622751 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 33 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 8123074 | 8123074 | PRJNA493827_P_NODE_124707_length_306_cov_1.321888_g122509_i0 | PRJNA493827 | 124707 | 306 | 1.321888 | 4.04497728 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.029 | NTclustered | gi|2918369720|emb|OZ237792.1| | 311461 | g122509 | i0 | 100 | 0.0915032679738562 | 28 | 0 | 9 | 0 | 96 | 123 | 8036120 | 8036147 | Hirudo verbana genome assembly, chromosome: 14 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 8126591 | 8126591 | PRJNA493827_P_NODE_64207_length_436_cov_2.707989_g62010_i0 | PRJNA493827 | 64207 | 436 | 2.707989 | 11.80683204 | Helobdella robusta | 6412 | Annelida | Annelida | 102 | 4.12e-17 | NTclustered | gi|675872865|ref|XM_009023745.1| | 6412 | g62010 | i0 | 76.596 | 0.431192660550459 | 188 | 43 | 43 | 1 | 38 | 224 | 872 | 1059 | Helobdella robusta hypothetical protein partial mRNA | blastn | 188 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 8126807 | 8126807 | PRJNA493827_P_NODE_72747_length_406_cov_2.030030_g70550_i0 | PRJNA493827 | 72747 | 406 | 2.03003 | 8.2419218 | Helobdella robusta | 6412 | Annelida | Annelida | 52.8 | 0.039 | NTclustered | gi|675884511|ref|XM_009029510.1| | 6412 | g70550 | i0 | 100 | 0.0689655172413793 | 28 | 0 | 7 | 0 | 37 | 64 | 52 | 25 | Helobdella robusta hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 9399770 | 9399770 | PRJNA493827_P_NODE_204048_length_247_cov_0.885057_g201850_i0 | PRJNA493827 | 204048 | 247 | 0.885057 | 2.18609079 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 1.33e-4 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g201850 | i0 | 100 | 3.92712550607287 | 32 | 0 | 13 | 0 | 100 | 131 | 2219925 | 2219956 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 970 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 9400843 | 9400843 | PRJNA493827_P_NODE_36828_length_606_cov_10.555347_g34664_i0 | PRJNA493827 | 36828 | 606 | 10.555347 | 63.96540282 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 3.59e-4 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g34664 | i0 | 92.857 | 0.0693069306930693 | 42 | 1 | 7 | 2 | 4 | 44 | 1571915 | 1571875 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 42 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 9402317 | 9402317 | PRJNA493827_P_NODE_97308_length_347_cov_2.208029_g95110_i0 | PRJNA493827 | 97308 | 347 | 2.208029 | 7.66186063 | Pristina aequiseta | 212339 | Annelida | Annelida | 462 | 1.2799999999999998e-125 | NTclustered | gi|285029437|gb|GQ355455.1| | 212339 | g95110 | i0 | 90.831 | 88.2939481268012 | 349 | 26 | 100 | 5 | 1 | 347 | 341 | 685 | Pristina aequiseta 28S ribosomal RNA gene, partial sequence | blastn | 30638 | 462 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Pristina | Pristina aequiseta | |
| 10675943 | 10675943 | PRJNA493827_P_NODE_230649_length_241_cov_2.041667_g228451_i0 | PRJNA493827 | 230649 | 241 | 2.041667 | 4.92041747 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|2920003371|emb|OZ238862.1| | 1046305 | g228451 | i0 | 100 | 0.116182572614108 | 28 | 0 | 12 | 0 | 50 | 77 | 9110316 | 9110343 | Ailoscolex lacteospumosus genome assembly, chromosome: 3 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 11948487 | 11948487 | PRJNA493827_P_NODE_11550_length_1217_cov_3.815559_g10189_i0 | PRJNA493827 | 11550 | 1217 | 3.815559 | 46.43535303 | Helobdella robusta | 6412 | Annelida | Annelida | 58.4 | 0.003 | NTclustered | gi|675875753|ref|XM_009025189.1| | 6412 | g10189 | i0 | 97.059 | 0.220213640098603 | 34 | 1 | 3 | 0 | 135 | 168 | 1366 | 1333 | Helobdella robusta hypothetical protein partial mRNA | blastn | 268 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 11951969 | 11951969 | PRJNA493827_P_NODE_53290_length_486_cov_3.963680_g51099_i0 | PRJNA493827 | 53290 | 486 | 3.96368 | 19.2634848 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.013 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g51099 | i0 | 100 | 0.0596707818930041 | 29 | 0 | 6 | 0 | 128 | 156 | 22500078 | 22500106 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 14499721 | 14499721 | PRJNA493827_P_NODE_168472_length_264_cov_0.937173_g166274_i0 | PRJNA493827 | 168472 | 264 | 0.937173 | 2.47413672 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 296 | 1.01e-75 | NTclustered | gi|2920003508|emb|OZ238866.1| | 1046305 | g166274 | i0 | 87.5 | 18.0795454545455 | 256 | 32 | 97 | 0 | 1 | 256 | 20770514 | 20770769 | Ailoscolex lacteospumosus genome assembly, chromosome: 7 | blastn | 4773 | 296 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 14503030 | 14503030 | PRJNA493827_P_NODE_95152_length_351_cov_3.352518_g92954_i0 | PRJNA493827 | 95152 | 351 | 3.352518 | 11.76733818 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.009 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g92954 | i0 | 100 | 0.484330484330484 | 29 | 0 | 8 | 0 | 49 | 77 | 21213062 | 21213034 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 170 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 15773177 | 15773177 | PRJNA493827_P_NODE_148153_length_281_cov_1.480769_g145955_i0 | PRJNA493827 | 148153 | 281 | 1.480769 | 4.16096089 | Arenicola marina | 6344 | Annelida | Annelida | 195 | 4.07e-45 | NTclustered | gi|158187717|gb|EU124943.1| | 6344 | g145955 | i0 | 84.236 | 54.373665480427 | 203 | 29 | 72 | 3 | 9 | 210 | 146 | 346 | Arenicola marina ribosomal protein rps18 mRNA, partial cds | blastn | 15279 | 195 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina | ||
| 15773957 | 15773957 | PRJNA493827_P_NODE_185753_length_251_cov_0.865169_g183555_i0 | PRJNA493827 | 185753 | 251 | 0.865169 | 2.17157419 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 1.36e-4 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g183555 | i0 | 97.143 | 0.139442231075697 | 35 | 1 | 14 | 0 | 47 | 81 | 5693282 | 5693316 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 35 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 15774034 | 15774034 | PRJNA493827_P_NODE_189513_length_250_cov_0.870056_g187315_i0 | PRJNA493827 | 189513 | 250 | 0.870056 | 2.17514 | Hirudo verbana | 311461 | Annelida | Annelida | 62.1 | 3.76e-5 | NTclustered | gi|2918369720|emb|OZ237792.1| | 311461 | g187315 | i0 | 100 | 0.132 | 33 | 0 | 13 | 0 | 49 | 81 | 6007605 | 6007637 | Hirudo verbana genome assembly, chromosome: 14 | blastn | 33 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 18324049 | 18324049 | PRJNA493827_P_NODE_237375_length_232_cov_3.125786_g235176_i0 | PRJNA493827 | 237375 | 232 | 3.125786 | 7.25182352 | Loimia sp. RM-2022 | 2927651 | Annelida | Annelida | 65.8 | 2.66e-6 | NTclustered | gi|2209439381|gb|ON017366.1| | 2927651 | g235176 | i0 | 97.368 | 0.163793103448276 | 38 | 1 | 16 | 0 | 132 | 169 | 22 | 59 | Loimia sp. RM-2022 isolate R5 small subunit ribosomal RNA gene, partial sequence | blastn | 38 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Terebellidae | Loimia | Loimia sp. RM-2022 | |
| 20873344 | 20873344 | PRJNA493827_P_NODE_198037_length_248_cov_0.885714_g195839_i0 | PRJNA493827 | 198037 | 248 | 0.885714 | 2.19657072 | Lumbricidae sp. Bozorgi-2018 | 2419836 | Annelida | Annelida | 134 | 7.79e-27 | NTclustered | gi|1594445602|dbj|LC427092.1| | 2419836 | g195839 | i0 | 79.167 | 41.5846774193548 | 192 | 40 | 77 | 0 | 17 | 208 | 561 | 752 | Lumbricidae sp. Bozorgi-2018 gene for 28S ribosomal RNA, partial sequence | blastn | 10313 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricidae sp. Bozorgi-2018 | ||
| 21506445 | 21506445 | PRJNA493827_P_NODE_104237_length_335_cov_1.717557_g102039_i0 | PRJNA493827 | 104237 | 335 | 1.717557 | 5.75381595 | Metazoa | 33208 | Annelida | Annelida | 54.7 | 0.009 | NTclustered | gi|675854895|ref|XM_009014760.1| | 6412 | g102039 | i0 | 96.875 | 0.358208955223881 | 32 | 1 | 10 | 0 | 82 | 113 | 108 | 139 | Helobdella robusta hypothetical protein partial mRNA | blastn | 120 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 23425768 | 23425768 | PRJNA493827_P_NODE_58419_length_461_cov_1.461340_g56223_i0 | PRJNA493827 | 58419 | 461 | 1.46134 | 6.7367774 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.045 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g56223 | i0 | 100 | 0.0607375271149675 | 28 | 0 | 6 | 0 | 218 | 245 | 1944487 | 1944514 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana |
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);;