contig_metadata
20 rows where bioproject = "PRJNA597223" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1845067 | 1845067 | PRJNA597223_P_NODE_69402_length_171_cov_11.220588_g67556_i0 | PRJNA597223 | 69402 | 171 | 11.220588 | 19.18720548 | Eisenia fetida | 6396 | Annelida | Annelida | 285 | 1.3e-72 | NTclustered | gi|11494215|gb|AF212166.1|AF212166 | 6396 | g67556 | i0 | 97.041 | 36.625730994152 | 169 | 5 | 99 | 0 | 3 | 171 | 3421 | 3589 | Eisenia fetida 28S ribosomal RNA gene, partial sequence | blastn | 6263 | 285 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia fetida | |
| 1845068 | 1845068 | PRJNA597223_P_NODE_69522_length_171_cov_2.750000_g67676_i0 | PRJNA597223 | 69522 | 171 | 2.75 | 4.7025 | Paranais litoralis | 74742 | Annelida | Annelida | 252 | 1.32e-62 | NTclustered | gi|1494622622|gb|MK076421.1| | 74742 | g67676 | i0 | 94.083 | 133.093567251462 | 169 | 4 | 99 | 3 | 1 | 169 | 1639 | 1477 | Paranais litoralis isolate PARliHBMD large subunit ribosomal RNA gene, partial sequence | blastn | 22759 | 252 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Paranais | Paranais litoralis | |
| 3120604 | 3120604 | PRJNA597223_S_NODE_1763_length_222_cov_3.464481_g1706_i0 | PRJNA597223 | 1763 | 222 | 3.464481 | 7.69114782 | Octodrilus complanatus | 1046380 | Annelida | Annelida | 327 | 2.92e-85 | NTclustered | gi|341833250|gb|HQ728941.1| | 1046380 | g1706 | i0 | 95.61 | 122.477477477477 | 205 | 7 | 92 | 2 | 10 | 213 | 2162 | 2365 | Octodrilus complanatus 28S large subunit ribosomal RNA gene, partial sequence | blastn | 27190 | 327 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Octodrilus | Octodrilus complanatus | |
| 4396896 | 4396896 | PRJNA597223_P_NODE_5704_length_728_cov_8.111111_g4399_i0 | PRJNA597223 | 5704 | 728 | 8.111111 | 59.04888808 | Pristina longiseta | 188231 | Annelida | Annelida | 819 | 0 | NTclustered | gi|2698734377|gb|PP490770.1| | 188231 | g4399 | i0 | 93.085 | 50.5961538461538 | 564 | 32 | 77 | 6 | 168 | 728 | 1 | 560 | Pristina longiseta small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 36834 | 819 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Pristina | Pristina longiseta | |
| 5672814 | 5672814 | PRJNA597223_P_NODE_35465_length_244_cov_18.942584_g33619_i0 | PRJNA597223 | 35465 | 244 | 18.942584 | 46.21990496 | Stylaria sp. THS-2006 | 397589 | Annelida | Annelida | 291 | 4.28e-74 | NTclustered | gi|111559330|gb|DQ790065.1| | 397589 | g33619 | i0 | 97.647 | 99.2827868852459 | 170 | 3 | 100 | 1 | 75 | 244 | 1939 | 2107 | Stylaria sp. THS-2006 28S large subunit ribosomal RNA gene, partial sequence | blastn | 24225 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Stylaria | Stylaria sp. THS-2006 | |
| 6947542 | 6947542 | PRJNA597223_P_NODE_5986_length_711_cov_14.806213_g4644_i0 | PRJNA597223 | 5986 | 711 | 14.806213 | 105.27217443 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.02 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g4644 | i0 | 100 | 0.0407876230661041 | 29 | 0 | 4 | 0 | 529 | 557 | 5488833 | 5488861 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 10773512 | 10773512 | PRJNA597223_P_NODE_49849_length_198_cov_1.128834_g48003_i0 | PRJNA597223 | 49849 | 198 | 1.128834 | 2.23509132 | Eurythoe complanata | 167815 | Annelida | Annelida | 121 | 8.069999999999999e-34 | NR | ABW23230.1 | 167815 | g48003 | i0 | 86.4 | 3.93939393939394 | 66 | 9 | 100 | 0 | 1 | 198 | 50 | 115 | ABW23230.1 ribosomal protein rpl31 [Eurythoe complanata] | diamond | 780 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Eunicida | Amphinomidae | Eurythoe | Eurythoe complanata | |
| 12048077 | 12048077 | PRJNA597223_P_NODE_27230_length_294_cov_10.710425_g25384_i0 | PRJNA597223 | 27230 | 294 | 10.710425 | 31.4886495 | Stylaria sp. THS-2006 | 397589 | Annelida | Annelida | 503 | 6.26e-138 | NTclustered | gi|111559330|gb|DQ790065.1| | 397589 | g25384 | i0 | 97.611 | 131.578231292517 | 293 | 7 | 99 | 0 | 1 | 293 | 2180 | 2472 | Stylaria sp. THS-2006 28S large subunit ribosomal RNA gene, partial sequence | blastn | 38684 | 503 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Stylaria | Stylaria sp. THS-2006 | |
| 15871513 | 15871513 | PRJNA597223_P_NODE_13593_length_459_cov_48.525943_g11822_i0 | PRJNA597223 | 13593 | 459 | 48.525943 | 222.73407837 | Pristina aequiseta | 212339 | Annelida | Annelida | 658 | 0 | NTclustered | gi|285029437|gb|GQ355455.1| | 212339 | g11822 | i0 | 92.609 | 96.0980392156863 | 460 | 30 | 100 | 4 | 1 | 459 | 719 | 263 | Pristina aequiseta 28S ribosomal RNA gene, partial sequence | blastn | 44109 | 658 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Pristina | Pristina aequiseta | |
| 15871629 | 15871629 | PRJNA597223_P_NODE_26293_length_301_cov_82.255639_g24449_i0 | PRJNA597223 | 26293 | 301 | 82.255639 | 247.58947339 | Nais communis | 188228 | Annelida | Annelida | 387 | 6.76e-103 | NTclustered | gi|1494622621|gb|MK076420.1| | 188228 | g24449 | i0 | 93.462 | 114.578073089701 | 260 | 17 | 86 | 0 | 41 | 300 | 3619 | 3360 | Nais communis isolate NAIco_IUCB large subunit ribosomal RNA gene, partial sequence | blastn | 34488 | 387 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Nais | Nais communis | |
| 17718715 | 17718715 | PRJNA597223_P_NODE_8714_length_589_cov_9.093863_g7152_i0 | PRJNA597223 | 8714 | 589 | 9.093863 | 53.56285307 | Pristina | 150439 | Annelida | Annelida | 399 | 1.8099999999999997e-106 | NTclustered | gi|2889522280|gb|PP139054.1| | 3386439 | g7152 | i0 | 87.465 | 41.5993208828523 | 359 | 29 | 61 | 10 | 230 | 587 | 732 | 389 | Pristina foreli complex sp. CEA voucher CE2855 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 24502 | 403 | 0.990074441687345 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Pristina | Pristina foreli complex sp. CEA | |
| 18420776 | 18420776 | PRJNA597223_P_NODE_17855_length_389_cov_2.319209_g16035_i0 | PRJNA597223 | 17855 | 389 | 2.319209 | 9.02172301 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.01 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g16035 | i0 | 96.875 | 0.0822622107969152 | 32 | 1 | 8 | 0 | 1 | 32 | 9773523 | 9773492 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 18421019 | 18421019 | PRJNA597223_P_NODE_40715_length_224_cov_0.962963_g38869_i0 | PRJNA597223 | 40715 | 224 | 0.962963 | 2.15703712 | Lumbricidae | 6392 | Annelida | Annelida | 118 | 9.539999999999999e-30 | NR | YP_010481492.1 | 538895 | g38869 | i0 | 77 | 8.91964285714286 | 74 | 17 | 99.1 | 0 | 224 | 3 | 1 | 74 | YP_010481492.1 cytochrome b [Eisenia nordenskioldi] | diamond | 1998 | 119 | 0.991596638655462 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenia | Eisenia nordenskioldi | |
| 19695838 | 19695838 | PRJNA597223_P_NODE_70836_length_169_cov_2.559701_g68990_i0 | PRJNA597223 | 70836 | 169 | 2.559701 | 4.32589469 | Hirudo verbana | 311461 | Annelida | Annelida | 100 | 4.97e-17 | NTclustered | gi|2918369697|emb|OZ237786.1| | 311461 | g68990 | i0 | 79.333 | 2.46745562130178 | 150 | 26 | 86 | 5 | 4 | 149 | 11097585 | 11097437 | Hirudo verbana genome assembly, chromosome: 8 | blastn | 417 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 20971138 | 20971138 | PRJNA597223_P_NODE_19857_length_364_cov_2.075988_g18025_i0 | PRJNA597223 | 19857 | 364 | 2.075988 | 7.55659632 | Stylaria sp. THS-2006 | 397589 | Annelida | Annelida | 387 | 8.339999999999998e-103 | NTclustered | gi|112144557|gb|DQ813403.1| | 397589 | g18025 | i0 | 85.106 | 44.1043956043956 | 376 | 39 | 99 | 6 | 1 | 363 | 226 | 597 | Stylaria sp. THS-2006 elongation factor-1 alpha (EF-1 alpha) mRNA, partial cds | blastn | 16054 | 387 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Stylaria | Stylaria sp. THS-2006 | |
| 23521688 | 23521688 | PRJNA597223_P_NODE_66559_length_176_cov_2.397163_g64713_i0 | PRJNA597223 | 66559 | 176 | 2.397163 | 4.21900688 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.015 | NTclustered | gi|2920003371|emb|OZ238862.1| | 1046305 | g64713 | i0 | 100 | 0.159090909090909 | 28 | 0 | 16 | 0 | 131 | 158 | 16399811 | 16399784 | Ailoscolex lacteospumosus genome assembly, chromosome: 3 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 24794941 | 24794941 | PRJNA597223_P_NODE_1860_length_1245_cov_13.032231_g1212_i0 | PRJNA597223 | 1860 | 1245 | 13.032231 | 162.25127595 | Pristina longiseta | 188231 | Annelida | Annelida | 891 | 0 | NTclustered | gi|2169792353|gb|OM001222.1| | 188231 | g1212 | i0 | 97.154 | 40.1815261044177 | 527 | 15 | 42 | 0 | 121 | 647 | 527 | 1 | Pristina longiseta voucher CW649 large subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 50026 | 891 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Tubificida | Naididae | Pristina | Pristina longiseta | |
| 24795046 | 24795046 | PRJNA597223_P_NODE_28580_length_285_cov_2.188000_g26734_i0 | PRJNA597223 | 28580 | 285 | 2.188 | 6.2358 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.026 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g26734 | i0 | 96.875 | 0.112280701754386 | 32 | 0 | 11 | 1 | 242 | 272 | 3221913 | 3221944 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 32 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 26903509 | 26903509 | PRJNA597223_P_NODE_50781_length_196_cov_1.149068_g48935_i0 | PRJNA597223 | 50781 | 196 | 1.149068 | 2.25217328 | Metazoa | 33208 | Annelida | Annelida | 67 | 2.25e-11 | NR | XP_009017047.1 | 6412 | g48935 | i0 | 90.3 | 7.17857142857143 | 31 | 3 | 47.4 | 0 | 3 | 95 | 214 | 244 | XP_009017047.1 hypothetical protein HELRODRAFT_186995 [Helobdella robusta] | diamond | 1407 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 32779660 | 32779660 | PRJNA597223_P_NODE_83320_length_154_cov_1.840336_g81474_i0 | PRJNA597223 | 83320 | 154 | 1.840336 | 2.83411744 | root | 1 | Root_unresolved | Root_unresolved | 98.6 | 7.9999999999999985e-25 | NR | CAH1788156.1 | 6347 | g81474 | i0 | 92.2 | 15.8961038961039 | 51 | 4 | 99.4 | 0 | 2 | 154 | 49 | 99 | CAH1788156.1 unnamed protein product [Owenia fusiformis] | diamond | 2448 | 98.6 | 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);;