contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA667863" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 633995 | 633995 | PRJNA667863_P_NODE_11621_length_250_cov_3.033898_g11587_i0 | PRJNA667863 | 11621 | 250 | 3.033898 | 7.584745 | Hirudo verbana | 311461 | Annelida | Annelida | 97.1 | 1.03e-15 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g11587 | i0 | 87.059 | 9.516 | 85 | 11 | 34 | 0 | 122 | 206 | 4315990 | 4316074 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 2379 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 634188 | 634188 | PRJNA667863_P_NODE_7121_length_277_cov_1.632353_g7087_i0 | PRJNA667863 | 7121 | 277 | 1.632353 | 4.52161781 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 100 | 8.97e-17 | NTclustered | gi|2920003508|emb|OZ238866.1| | 1046305 | g7087 | i0 | 89.744 | 0.490974729241877 | 78 | 8 | 28 | 0 | 187 | 264 | 2105013 | 2104936 | Ailoscolex lacteospumosus genome assembly, chromosome: 7 | blastn | 136 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 3184936 | 3184936 | PRJNA667863_P_NODE_383_length_739_cov_37.692192_g354_i0 | PRJNA667863 | 383 | 739 | 37.692192 | 278.54529888 | Pectinaria gouldii | 260746 | Annelida | Annelida | 401 | 6.379999999999999e-107 | NTclustered | gi|557950043|gb|KF479360.1| | 260746 | g354 | i0 | 80.492 | 60.573748308525 | 528 | 99 | 71 | 4 | 28 | 553 | 1 | 526 | Pectinaria gouldii isolate CM68 60S ribosomal-like protein mRNA, complete cds | blastn | 44764 | 405 | 0.990123456790123 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Pectinariidae | Pectinaria | Pectinaria gouldii | |
| 3184940 | 3184940 | PRJNA667863_P_NODE_403_length_726_cov_34.353752_g374_i0 | PRJNA667863 | 403 | 726 | 34.353752 | 249.40823952 | Arenicola marina | 6344 | Annelida | Annelida | 291 | 1.4099999999999998e-73 | NTclustered | gi|158187777|gb|EU124973.1| | 6344 | g374 | i0 | 79.206 | 39.2410468319559 | 428 | 79 | 58 | 7 | 85 | 507 | 535 | 113 | Arenicola marina ribosomal protein rpl23a mRNA, partial cds | blastn | 28489 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina | ||
| 3715276 | 3715276 | PRJNA667863_P_NODE_963_length_511_cov_16.714612_g930_i0 | PRJNA667863 | 963 | 511 | 16.714612 | 85.41166732 | Polynoidae | 46593 | Annelida | Annelida | 86.1 | 4.93e-12 | NTclustered | gi|2054260827|gb|MZ131647.1| | 862921 | g930 | i0 | 77.564 | 5.19373776908023 | 156 | 26 | 30 | 8 | 118 | 270 | 10319 | 10170 | Arctonoe vittata mitochondrion, complete genome | blastn | 2654 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Polynoidae | Arctonoe | Arctonoe vittata | |
| 4461935 | 4461935 | PRJNA667863_P_NODE_344_length_773_cov_24.861429_g316_i0 | PRJNA667863 | 344 | 773 | 24.861429 | 192.17884617 | Eurythoe complanata | 167815 | Annelida | Annelida | 416 | 2.39e-111 | NTclustered | gi|158187819|gb|EU124994.1| | 167815 | g316 | i0 | 79.333 | 3.10349288486417 | 600 | 117 | 77 | 7 | 6 | 601 | 120 | 716 | Eurythoe complanata ribosomal protein rps3a mRNA, complete cds | blastn | 2399 | 416 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Eunicida | Amphinomidae | Eurythoe | Eurythoe complanata | |
| 4461963 | 4461963 | PRJNA667863_P_NODE_6324_length_285_cov_1.301887_g6290_i0 | PRJNA667863 | 6324 | 285 | 1.301887 | 3.71037795 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 82.4 | 3.36e-11 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g6290 | i0 | 80.556 | 0.378947368421053 | 108 | 19 | 38 | 2 | 26 | 132 | 15590648 | 15590542 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 108 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 5737301 | 5737301 | PRJNA667863_P_NODE_105_length_1202_cov_34.190434_g89_i0 | PRJNA667863 | 105 | 1202 | 34.190434 | 410.96901668 | Aeolosoma sp. THS-2006 | 397537 | Annelida | Annelida | 778 | 0 | NTclustered | gi|112144441|gb|DQ813345.1| | 397537 | g89 | i0 | 82.708 | 83.8111480865225 | 879 | 147 | 73 | 3 | 314 | 1188 | 974 | 97 | Aeolosoma sp. THS-2006 elongation factor-1 alpha (EF-1 alpha) mRNA, partial cds | blastn | 100741 | 778 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma sp. THS-2006 | |
| 9562399 | 9562399 | PRJNA667863_P_NODE_13788_length_246_cov_2.664740_g13754_i0 | PRJNA667863 | 13788 | 246 | 2.66474 | 6.5552604 | Hirudo verbana | 311461 | Annelida | Annelida | 128 | 3.59e-25 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g13754 | i0 | 80.864 | 0.658536585365854 | 162 | 31 | 66 | 0 | 83 | 244 | 12338702 | 12338541 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 162 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 10838032 | 10838032 | PRJNA667863_P_NODE_1129_length_479_cov_2.502463_g1096_i0 | PRJNA667863 | 1129 | 479 | 2.502463 | 11.98679777 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 65.8 | 5.99e-6 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g1096 | i0 | 83.333 | 0.150313152400835 | 72 | 10 | 15 | 2 | 263 | 333 | 46960383 | 46960453 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 72 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 13387944 | 13387944 | PRJNA667863_P_NODE_1231_length_464_cov_11.928389_g1198_i0 | PRJNA667863 | 1231 | 464 | 11.928389 | 55.34772496 | Aeolosoma viride | 394736 | Annelida | Annelida | 438 | 2.9599999999999992e-118 | NTclustered | gi|1151119859|gb|KY079093.1| | 394736 | g1198 | i0 | 90.606 | 71.3900862068966 | 330 | 31 | 71 | 0 | 134 | 463 | 69 | 398 | Aeolosoma viride beta-tubulin isoform 1 mRNA, complete cds | blastn | 33125 | 438 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma viride | |
| 15936805 | 15936805 | PRJNA667863_P_NODE_133_length_1126_cov_893.659069_g114_i0 | PRJNA667863 | 133 | 1126 | 893.659069 | 10062.60111694 | Aeolosoma sp. GG-2011 | 1071604 | Annelida | Annelida | 359 | 6.029999999999998e-94 | NTclustered | gi|342220097|gb|HQ691208.1| | 1071604 | g114 | i0 | 81.25 | 17.2619893428064 | 464 | 70 | 40 | 12 | 134 | 585 | 472 | 14 | Aeolosoma sp. GG-2011 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 19437 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma sp. GG-2011 | |
| 17212026 | 17212026 | PRJNA667863_P_NODE_18814_length_221_cov_5.175676_g18780_i0 | PRJNA667863 | 18814 | 221 | 5.175676 | 11.43824396 | Aeolosoma sp. THS-2006 | 397537 | Annelida | Annelida | 385 | 1.6999999999999995e-102 | NTclustered | gi|111559284|gb|DQ790019.1| | 397537 | g18780 | i0 | 98.19 | 101.135746606335 | 221 | 2 | 99 | 2 | 2 | 221 | 2861 | 2642 | Aeolosoma sp. THS-2006 28S large subunit ribosomal RNA gene, partial sequence | blastn | 22351 | 385 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma sp. THS-2006 | |
| 18486269 | 18486269 | PRJNA667863_P_NODE_10555_length_254_cov_3.773481_g10521_i0 | PRJNA667863 | 10555 | 254 | 3.773481 | 9.58464174 | Hirudo verbana | 311461 | Annelida | Annelida | 132 | 2.88e-26 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g10521 | i0 | 79.67 | 0.940944881889764 | 182 | 37 | 72 | 0 | 73 | 254 | 9317769 | 9317950 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 239 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 19761007 | 19761007 | PRJNA667863_P_NODE_876_length_527_cov_3.856828_g843_i0 | PRJNA667863 | 876 | 527 | 3.856828 | 20.32548356 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 300 | 1.67e-76 | NTclustered | gi|2920003508|emb|OZ238866.1| | 1046305 | g843 | i0 | 77.395 | 33.0777988614801 | 522 | 106 | 98 | 11 | 4 | 519 | 2296170 | 2295655 | Ailoscolex lacteospumosus genome assembly, chromosome: 7 | blastn | 17432 | 300 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 21036420 | 21036420 | PRJNA667863_P_NODE_15017_length_244_cov_1.748538_g14983_i0 | PRJNA667863 | 15017 | 244 | 1.748538 | 4.26643272 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 99 | 2.79e-16 | NTclustered | gi|2920003456|emb|OZ238864.1| | 1046305 | g14983 | i0 | 96.61 | 1.09426229508197 | 59 | 2 | 24 | 0 | 184 | 242 | 18502891 | 18502833 | Ailoscolex lacteospumosus genome assembly, chromosome: 5 | blastn | 267 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 22311234 | 22311234 | PRJNA667863_P_NODE_11378_length_251_cov_0.865169_g11344_i0 | PRJNA667863 | 11378 | 251 | 0.865169 | 2.17157419 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 165 | 2.8e-36 | NTclustered | gi|2920003371|emb|OZ238862.1| | 1046305 | g11344 | i0 | 78.8 | 37.0119521912351 | 250 | 50 | 99 | 3 | 1 | 248 | 17235962 | 17236210 | Ailoscolex lacteospumosus genome assembly, chromosome: 3 | blastn | 9290 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 22311340 | 22311340 | PRJNA667863_P_NODE_3178_length_343_cov_8.481481_g3144_i0 | PRJNA667863 | 3178 | 343 | 8.481481 | 29.09147983 | Arenicola marina | 6344 | Annelida | Annelida | 148 | 4.02e-31 | NTclustered | gi|2108986873|gb|MZ593354.1| | 6344 | g3144 | i0 | 79.343 | 3.99708454810496 | 213 | 42 | 62 | 2 | 2 | 213 | 1461 | 1672 | Arenicola marina ATP synthase subunit beta, mitochondrial (ATPB) mRNA, partial cds; nuclear gene for mitochondrial product | blastn | 1371 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina | ||
| 22311376 | 22311376 | PRJNA667863_P_NODE_5818_length_289_cov_14.148148_g5784_i0 | PRJNA667863 | 5818 | 289 | 14.148148 | 40.88814772 | Hydroides elegans | 216498 | Annelida | Annelida | 255 | 1.9e-63 | NTclustered | gi|92430140|gb|DQ463963.1| | 216498 | g5784 | i0 | 87.168 | 40.6643598615917 | 226 | 27 | 78 | 2 | 51 | 275 | 399 | 175 | Hydroides elegans histone variant H2A.Z mRNA, partial cds | blastn | 11752 | 255 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Serpulidae | Hydroides | Hydroides elegans | |
| 23586740 | 23586740 | PRJNA667863_P_NODE_19279_length_206_cov_4.375940_g19245_i0 | PRJNA667863 | 19279 | 206 | 4.37594 | 9.0144364 | Helobdella robusta | 6412 | Annelida | Annelida | 58.4 | 3.87e-4 | NTclustered | gi|675887617|ref|XM_009031063.1| | 6412 | g19245 | i0 | 100 | 2.73300970873786 | 31 | 0 | 15 | 0 | 152 | 182 | 1304 | 1274 | Helobdella robusta hypothetical protein partial mRNA | blastn | 563 | 58.4 | 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);;