contig_metadata
11 rows where bioproject = "PRJNA630877" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26966825 | 26966825 | PRJNA630877_S_NODE_153822_length_155_cov_1.157895_g134685_i0 | PRJNA630877 | 153822 | 155 | 1.157895 | 1.79473725 | Metazoa | 33208 | Annelida | Annelida | 108 | 9.85e-26 | NR | CAH1782791.1 | 6347 | g134685 | i0 | 100 | 1326.63870967742 | 51 | 0 | 98.7 | 0 | 153 | 1 | 534 | 584 | CAH1782791.1 unnamed protein product [Owenia fusiformis] | diamond | 205629 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27378172 | 27378172 | PRJNA630877_S_NODE_48843_length_589_cov_3.810219_g30399_i0 | PRJNA630877 | 48843 | 589 | 3.810219 | 22.44218991 | Metazoa | 33208 | Annelida | Annelida | 50.4 | 9.92e-4 | NR | CAH1786587.1 | 6347 | g30399 | i0 | 59.5 | 12.1731748726655 | 42 | 12 | 21.4 | 1 | 127 | 2 | 109 | 145 | CAH1786587.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 7170 | 50.8 | 0.992125984251969 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27725634 | 27725634 | PRJNA630877_S_NODE_130044_length_177_cov_2.683824_g110907_i0 | PRJNA630877 | 130044 | 177 | 2.683824 | 4.75036848 | Metazoa | 33208 | Annelida | Annelida | 123 | 7.49e-32 | NR | UCK81534.1 | 6344 | g110907 | i0 | 98.3 | 433 | 59 | 1 | 100 | 0 | 177 | 1 | 134 | 192 | UCK81534.1 mitogen-activated protein kinase 8 [Arenicola marina] | diamond | 76641 | 124 | 0.991935483870968 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina | ||
| 28091498 | 28091498 | PRJNA630877_S_NODE_129825_length_178_cov_0.963504_g110688_i0 | PRJNA630877 | 129825 | 178 | 0.963504 | 1.71503712 | Owenia fusiformis | 6347 | Annelida | Annelida | 42.7 | 0.00998 | NR | CAH1778874.1 | 6347 | g110688 | i0 | 59.3 | 0.455056179775281 | 27 | 11 | 45.5 | 0 | 83 | 3 | 1 | 27 | CAH1778874.1 unnamed protein product [Owenia fusiformis] | diamond | 81 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28123155 | 28123155 | PRJNA630877_S_NODE_23685_length_1292_cov_4.855316_g12989_i0 | PRJNA630877 | 23685 | 1292 | 4.855316 | 62.73068272 | Ridgeia piscesae | 27915 | Annelida | Annelida | 53.5 | 5.19e-5 | NR | KAK2178774.1 | 27915 | g12989 | i0 | 59.5 | 0.0859133126934985 | 37 | 15 | 8.6 | 0 | 853 | 743 | 63 | 99 | KAK2178774.1 hypothetical protein NP493_528g03055 [Ridgeia piscesae] | diamond | 111 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 28830198 | 28830198 | PRJNA630877_S_NODE_128828_length_179_cov_1.231884_g109691_i0 | PRJNA630877 | 128828 | 179 | 1.231884 | 2.20507236 | Metazoa | 33208 | Annelida | Annelida | 114 | 1.26e-27 | NR | CBM42047.1 | 6344 | g109691 | i0 | 96.6 | 174.033519553073 | 59 | 2 | 98.9 | 0 | 178 | 2 | 152 | 210 | CBM42047.1 heat shock protein-70kDa [Arenicola marina] | diamond | 31152 | 115 | 0.991304347826087 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina | ||
| 29133689 | 29133689 | PRJNA630877_S_NODE_126509_length_182_cov_0.900709_g107372_i0 | PRJNA630877 | 126509 | 182 | 0.900709 | 1.63929038 | Ridgeia piscesae | 27915 | Annelida | Annelida | 43.1 | 0.00383 | NR | KAK2175364.1 | 27915 | g107372 | i0 | 47.4 | 0.626373626373626 | 38 | 20 | 62.6 | 0 | 134 | 21 | 48 | 85 | KAK2175364.1 hypothetical protein NP493_737g00021 [Ridgeia piscesae] | diamond | 114 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 29777449 | 29777449 | PRJNA630877_S_NODE_141511_length_165_cov_15.209677_g122374_i0 | PRJNA630877 | 141511 | 165 | 15.209677 | 25.09596705 | Metazoa | 33208 | Annelida | Annelida | 107 | 8.03e-26 | NR | XP_009021258.1 | 6412 | g122374 | i0 | 96.3 | 72.6545454545455 | 54 | 2 | 98.2 | 0 | 163 | 2 | 233 | 286 | XP_009021258.1 hypothetical protein HELRODRAFT_187209 [Helobdella robusta] | diamond | 11988 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 30346719 | 30346719 | PRJNA630877_S_NODE_29712_length_1059_cov_5.672888_g16511_i0 | PRJNA630877 | 29712 | 1059 | 5.672888 | 60.07588392 | Metazoa | 33208 | Annelida | Annelida | 98.2 | 1.69e-18 | NR | CAH1775482.1 | 6347 | g16511 | i0 | 97.9 | 8.05382436260623 | 47 | 1 | 13.3 | 0 | 918 | 1058 | 340 | 386 | CAH1775482.1 unnamed protein product [Owenia fusiformis] | diamond | 8529 | 98.6 | 0.995943204868154 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30744401 | 30744401 | PRJNA630877_S_NODE_20094_length_1460_cov_7.046512_g10956_i0 | PRJNA630877 | 20094 | 1460 | 7.046512 | 102.8790752 | Ridgeia piscesae | 27915 | Annelida | Annelida | 58.2 | 9.78e-6 | NR | KAK2183374.1 | 27915 | g10956 | i0 | 59.5 | 0.304109589041096 | 37 | 15 | 7.6 | 0 | 959 | 1069 | 72 | 108 | KAK2183374.1 hypothetical protein NP493_314g01000 [Ridgeia piscesae] | diamond | 444 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 31736804 | 31736804 | PRJNA630877_S_NODE_104797_length_216_cov_21.977143_g85660_i0 | PRJNA630877 | 104797 | 216 | 21.977143 | 47.47062888 | Metazoa | 33208 | Annelida | Annelida | 157 | 1.03e-42 | NR | CAH1796328.1 | 6347 | g85660 | i0 | 100 | 493.055555555556 | 71 | 0 | 98.6 | 0 | 214 | 2 | 618 | 688 | CAH1796328.1 unnamed protein product [Owenia fusiformis] | diamond | 106500 | 157 | 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);;