contig_metadata
28 rows where analysis = "blastn", bioproject = "PRJEB20058" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22662880 | 22662880 | PRJEB20058_S_NODE_5098_length_271_cov_1.952381_g5060_i0 | PRJEB20058 | 5098 | 271 | 1.952381 | 5.29095251 | Metazoa | 33208 | Annelida | Annelida | 58.4 | 5.34e-4 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g5060 | i0 | 100 | 1.64944649446494 | 31 | 0 | 11 | 0 | 1 | 31 | 2381291 | 2381261 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 447 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 25515772 | 25515772 | PRJEB20058_P_NODE_168585_length_289_cov_2.723684_g165762_i0 | PRJEB20058 | 168585 | 289 | 2.723684 | 7.87144676 | Hirudo verbana | 311461 | Annelida | Annelida | 82.4 | 3.41e-11 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g165762 | i0 | 85.897 | 0.941176470588235 | 78 | 10 | 27 | 1 | 56 | 132 | 2147028 | 2147105 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 272 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 25518160 | 25518160 | PRJEB20058_P_NODE_224793_length_238_cov_7.073446_g221968_i0 | PRJEB20058 | 224793 | 238 | 7.073446 | 16.83480148 | Tubifex tubifex | 6386 | Annelida | Annelida | 73.1 | 1.64e-8 | NTclustered | gi|2660966826|gb|PP213159.1| | 6386 | g221968 | i0 | 85.714 | 2.53361344537815 | 70 | 8 | 29 | 2 | 106 | 174 | 972 | 904 | Tubifex tubifex glyceraldehyde-3-phosphate dehydrogenase (Gapdh) mRNA, complete cds | blastn | 603 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Tubifex | Tubifex tubifex | |
| 25518295 | 25518295 | PRJEB20058_P_NODE_228481_length_233_cov_33.534884_g225656_i0 | PRJEB20058 | 228481 | 233 | 33.534884 | 78.13627972 | Pectinaria gouldii | 260746 | Annelida | Annelida | 106 | 1.58e-18 | NTclustered | gi|557950049|gb|KF479363.1| | 260746 | g225656 | i0 | 78.212 | 1.62660944206009 | 179 | 30 | 74 | 6 | 40 | 212 | 356 | 181 | Pectinaria gouldii isolate KR11 40S ribosomal-like protein mRNA, complete cds | blastn | 379 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Pectinariidae | Pectinaria | Pectinaria gouldii | |
| 25522912 | 25522912 | PRJEB20058_P_NODE_9953_length_1322_cov_14.469469_g8511_i0 | PRJEB20058 | 9953 | 1322 | 14.469469 | 191.28638018 | Eisenia fetida | 6396 | Annelida | Annelida | 1585 | 0 | NTclustered | gi|2281547199|ref|NC_065213.1| | 6396 | g8511 | i0 | 89.045 | 81.8320726172466 | 1278 | 140 | 97 | 0 | 2 | 1279 | 1540 | 263 | Eisenia fetida mitochondrion, complete genome | blastn | 108182 | 1585 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia fetida | |
| 25649412 | 25649412 | PRJEB20058_P_NODE_116914_length_370_cov_10.223301_g114099_i0 | PRJEB20058 | 116914 | 370 | 10.223301 | 37.8262137 | Lumbricus terrestris | 6398 | Annelida | Annelida | 551 | 2.839999999999999e-152 | NTclustered | gi|377552810|gb|JN869609.1| | 6398 | g114099 | i0 | 95.442 | 81.3027027027027 | 351 | 6 | 92 | 1 | 30 | 370 | 1 | 351 | Lumbricus terrestris voucher 1510 cytochrome c oxidase subunit II (COII) gene, partial cds; mitochondrial | blastn | 30082 | 551 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus terrestris | |
| 25655032 | 25655032 | PRJEB20058_P_NODE_28858_length_780_cov_11.184979_g26436_i0 | PRJEB20058 | 28858 | 780 | 11.184979 | 87.2428362 | Eisenia fetida | 6396 | Annelida | Annelida | 878 | 0 | NTclustered | gi|2281547199|ref|NC_065213.1| | 6396 | g26436 | i0 | 87.209 | 59.2141025641026 | 774 | 96 | 99 | 2 | 10 | 780 | 2638 | 3411 | Eisenia fetida mitochondrion, complete genome | blastn | 46187 | 878 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia fetida | |
| 25655442 | 25655442 | PRJEB20058_P_NODE_35426_length_706_cov_22.282171_g32846_i0 | PRJEB20058 | 35426 | 706 | 22.282171 | 157.31212726 | Eisenia lagodechiensis | 3136321 | Annelida | Annelida | 821 | 0 | NTclustered | gi|2898690783|gb|PP571884.1| | 3136321 | g32846 | i0 | 88.496 | 94.042492917847 | 678 | 78 | 96 | 0 | 23 | 700 | 1603 | 2280 | Eisenia lagodechiensis mitochondrion, partial genome | blastn | 66394 | 821 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia lagodechiensis | |
| 25656798 | 25656798 | PRJEB20058_P_NODE_60554_length_538_cov_9.010482_g57794_i0 | PRJEB20058 | 60554 | 538 | 9.010482 | 48.47639316 | Eisenia fetida | 6396 | Annelida | Annelida | 974 | 0 | NTclustered | gi|807782432|gb|KP420660.1| | 6396 | g57794 | i0 | 99.44 | 1.74721189591078 | 536 | 3 | 99 | 0 | 1 | 536 | 17 | 552 | Eisenia fetida voucher EfG1 NADH dehydrogenase subunit II (ND2) gene, partial cds; mitochondrial | blastn | 940 | 974 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia fetida | |
| 25784913 | 25784913 | PRJEB20058_P_NODE_101987_length_402_cov_29.768328_g99180_i0 | PRJEB20058 | 101987 | 402 | 29.768328 | 119.66867856 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 62.1 | 6.4e-5 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g99180 | i0 | 100 | 0.082089552238806 | 33 | 0 | 8 | 0 | 4 | 36 | 7441146 | 7441114 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 33 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 25791555 | 25791555 | PRJEB20058_P_NODE_35835_length_702_cov_14.595944_g33250_i0 | PRJEB20058 | 35835 | 702 | 14.595944 | 102.46352688 | Eisenia fetida | 6396 | Annelida | Annelida | 769 | 0 | NTclustered | gi|2281547199|ref|NC_065213.1| | 6396 | g33250 | i0 | 87.187 | 3.18660968660969 | 679 | 83 | 96 | 2 | 6 | 680 | 11586 | 10908 | Eisenia fetida mitochondrion, complete genome | blastn | 2237 | 769 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia fetida | |
| 25794231 | 25794231 | PRJEB20058_P_NODE_86563_length_443_cov_1.942408_g83774_i0 | PRJEB20058 | 86563 | 443 | 1.942408 | 8.60486744 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 115 | 5.39e-21 | NTclustered | gi|2920003371|emb|OZ238862.1| | 1046305 | g83774 | i0 | 84.426 | 0.790067720090293 | 122 | 14 | 27 | 4 | 186 | 305 | 35141224 | 35141106 | Ailoscolex lacteospumosus genome assembly, chromosome: 3 | blastn | 350 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 25885516 | 25885516 | PRJEB20058_P_NODE_208531_length_250_cov_2.687831_g205707_i0 | PRJEB20058 | 208531 | 250 | 2.687831 | 6.7195775 | Annelida | 6340 | Annelida | Annelida | 95.3 | 3.71e-15 | NTclustered | gi|342220100|gb|HQ691211.1| | 6398 | g205707 | i0 | 100 | 27.132 | 51 | 0 | 20 | 0 | 1 | 51 | 345 | 295 | Lumbricus terrestris 18S ribosomal RNA gene, partial sequence | blastn | 6783 | 95.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus terrestris | |
| 25887087 | 25887087 | PRJEB20058_P_NODE_74379_length_482_cov_3.774347_g71602_i0 | PRJEB20058 | 74379 | 482 | 3.774347 | 18.19235254 | Eisenia | 6393 | Annelida | Annelida | 719 | 0 | NTclustered | gi|2281547199|ref|NC_065213.1| | 6396 | g71602 | i0 | 93.92 | 86.5145228215768 | 477 | 27 | 99 | 2 | 7 | 482 | 12336 | 11861 | Eisenia fetida mitochondrion, complete genome | blastn | 41700 | 719 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia fetida | |
| 25925167 | 25925167 | PRJEB20058_P_NODE_195980_length_259_cov_2.767677_g193156_i0 | PRJEB20058 | 195980 | 259 | 2.767677 | 7.16828343 | Eisenia fetida | 6396 | Annelida | Annelida | 462 | 9.2e-126 | NTclustered | gi|807782276|gb|KP420582.1| | 6396 | g193156 | i0 | 100 | 80.015444015444 | 250 | 0 | 97 | 0 | 1 | 250 | 250 | 1 | Eisenia fetida voucher EfG1 cytochrome c oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 20724 | 462 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia fetida | |
| 25926342 | 25926342 | PRJEB20058_P_NODE_225908_length_237_cov_2.653409_g223083_i0 | PRJEB20058 | 225908 | 237 | 2.653409 | 6.28857933 | Eisenia lagodechiensis | 3136321 | Annelida | Annelida | 209 | 1.19e-49 | NTclustered | gi|2898690783|gb|PP571884.1| | 3136321 | g223083 | i0 | 84.404 | 24.5443037974684 | 218 | 29 | 92 | 4 | 21 | 237 | 2351 | 2564 | Eisenia lagodechiensis mitochondrion, partial genome | blastn | 5817 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia lagodechiensis | |
| 25929565 | 25929565 | PRJEB20058_P_NODE_69388_length_500_cov_20.564920_g66617_i0 | PRJEB20058 | 69388 | 500 | 20.56492 | 102.8246 | Eisenia nordenskioldi nordenskioldi | 1269247 | Annelida | Annelida | 274 | 9.58e-69 | NTclustered | gi|1786486065|gb|MK642867.1| | 1269247 | g66617 | i0 | 77.426 | 0.948 | 474 | 97 | 94 | 9 | 10 | 478 | 3951 | 3483 | Eisenia nordenskioldi nordenskioldi from Russia mitochondrion, partial genome | blastn | 474 | 274 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia nordenskioldi | |
| 26063350 | 26063350 | PRJEB20058_P_NODE_28773_length_781_cov_10.941667_g26355_i0 | PRJEB20058 | 28773 | 781 | 10.941667 | 85.45441927 | Eisenia fetida | 6396 | Annelida | Annelida | 797 | 0 | NTclustered | gi|2281547199|ref|NC_065213.1| | 6396 | g26355 | i0 | 85.363 | 92.2599231754161 | 772 | 109 | 99 | 4 | 3 | 772 | 14236 | 15005 | Eisenia fetida mitochondrion, complete genome | blastn | 72055 | 797 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia fetida | |
| 26065058 | 26065058 | PRJEB20058_P_NODE_59037_length_545_cov_27.816116_g56282_i0 | PRJEB20058 | 59037 | 545 | 27.816116 | 151.5978322 | Eisenia fetida | 6396 | Annelida | Annelida | 556 | 9.32e-154 | NTclustered | gi|2281547199|ref|NC_065213.1| | 6396 | g56282 | i0 | 85.421 | 7.04036697247706 | 535 | 78 | 98 | 0 | 2 | 536 | 5864 | 5330 | Eisenia fetida mitochondrion, complete genome | blastn | 3837 | 556 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia fetida | |
| 26194184 | 26194184 | PRJEB20058_P_NODE_120286_length_364_cov_2.412541_g117470_i0 | PRJEB20058 | 120286 | 364 | 2.412541 | 8.78164924 | Eisenia fetida | 6396 | Annelida | Annelida | 379 | 1.39e-100 | NTclustered | gi|2281547199|ref|NC_065213.1| | 6396 | g117470 | i0 | 86.246 | 3.48076923076923 | 349 | 48 | 96 | 0 | 10 | 358 | 15141 | 15489 | Eisenia fetida mitochondrion, complete genome | blastn | 1267 | 379 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia fetida | |
| 26197240 | 26197240 | PRJEB20058_P_NODE_190886_length_264_cov_3.330049_g188062_i0 | PRJEB20058 | 190886 | 264 | 3.330049 | 8.79132936 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 73.1 | 1.85e-8 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g188062 | i0 | 93.878 | 0.185606060606061 | 49 | 2 | 18 | 1 | 57 | 104 | 25114103 | 25114151 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 49 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 26199635 | 26199635 | PRJEB20058_P_NODE_28678_length_782_cov_17.450763_g26266_i0 | PRJEB20058 | 28678 | 782 | 17.450763 | 136.46496666 | Bimastos eiseni | 320977 | Annelida | Annelida | 588 | 4.829999999999999e-163 | NTclustered | gi|2549886644|emb|OY365823.1| | 320977 | g26266 | i0 | 80.769 | 66.4040920716113 | 754 | 143 | 96 | 2 | 16 | 768 | 11198 | 11950 | Bimastos eiseni genome assembly, organelle: mitochondrion | blastn | 51928 | 588 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Bimastos | Bimastos eiseni | |
| 26338037 | 26338037 | PRJEB20058_P_NODE_75591_length_478_cov_1.688249_g72813_i0 | PRJEB20058 | 75591 | 478 | 1.6882490000000001 | 8.06983022 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.004 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g72813 | i0 | 96.97 | 0.445606694560669 | 33 | 1 | 7 | 0 | 164 | 196 | 3337457 | 3337425 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 213 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 26428990 | 26428990 | PRJEB20058_P_NODE_159535_length_300_cov_6.225941_g156712_i0 | PRJEB20058 | 159535 | 300 | 6.225941 | 18.677823 | Lumbricidae | 6392 | Annelida | Annelida | 538 | 1.76e-148 | NTclustered | gi|62084453|gb|AY874485.1| | 6396 | g156712 | i0 | 100 | 128.24 | 291 | 0 | 97 | 0 | 1 | 291 | 2023 | 1733 | Eisenia fetida voucher MPLe0033 28S large subunit ribosomal RNA gene, partial sequence | blastn | 38472 | 538 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia fetida | |
| 26470482 | 26470482 | PRJEB20058_P_NODE_219192_length_243_cov_1.510989_g216368_i0 | PRJEB20058 | 219192 | 243 | 1.510989 | 3.67170327 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 207 | 4.42e-49 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g216368 | i0 | 91.026 | 58.5267489711934 | 156 | 10 | 66 | 4 | 89 | 243 | 47699140 | 47699292 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 14222 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 26472941 | 26472941 | PRJEB20058_P_NODE_49624_length_596_cov_19.248598_g46902_i0 | PRJEB20058 | 49624 | 596 | 19.248598 | 114.72164408 | Henlea ventriculosa complex sp. L3 | 3394079 | Annelida | Annelida | 761 | 0 | NTclustered | gi|2891446477|gb|PP168479.1| | 3394079 | g46902 | i0 | 99.522 | 73.4446308724832 | 418 | 2 | 70 | 0 | 158 | 575 | 475 | 58 | Henlea ventriculosa complex sp. L3 voucher CE35184 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 43773 | 761 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Enchytraeida | Enchytraeidae | Henlea | Henlea ventriculosa complex sp. L3 | |
| 26564907 | 26564907 | PRJEB20058_P_NODE_146656_length_318_cov_21.237354_g143835_i0 | PRJEB20058 | 146656 | 318 | 21.237354 | 67.53478572 | Lumbricidae | 6392 | Annelida | Annelida | 540 | 5.22e-149 | NTclustered | gi|342220107|gb|HQ691218.1| | 6398 | g143835 | i0 | 98.689 | 126.839622641509 | 305 | 2 | 96 | 2 | 6 | 309 | 2131 | 2434 | Lumbricus terrestris 28S ribosomal RNA gene, partial sequence | blastn | 40335 | 540 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Lumbricus | Lumbricus terrestris | |
| 26565671 | 26565671 | PRJEB20058_P_NODE_200960_length_255_cov_22.494845_g198136_i0 | PRJEB20058 | 200960 | 255 | 22.494845 | 57.36185475 | Octolasion | 161231 | Annelida | Annelida | 399 | 7.179999999999999e-107 | NTclustered | gi|674656768|gb|KJ912579.1| | 334871 | g198136 | i0 | 97.845 | 78.7843137254902 | 232 | 3 | 90 | 1 | 3 | 232 | 635 | 404 | Octolasion lacteum isolate MPL260 16S ribosomal RNA gene, partial sequence; tRNA-Leu and tRNA-Ala genes, complete sequence; and tRNA-Ser gene, partial sequence; mitochondrial | blastn | 20090 | 399 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Octolasion | Octolasion lacteum |
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);;