contig_metadata
22 rows where bioproject = "PRJNA675331", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2443886 | 2443886 | PRJNA675331_P_NODE_4262_length_458_cov_2.579221_g4090_i0 | PRJNA675331 | 4262 | 458 | 2.579221 | 11.81283218 | Phragmatopoma lapidosa | 341668 | Annelida | Annelida | 248 | 2.22e-81 | NR | AIU94796.1 | 341668 | g4090 | i0 | 82.9 | 0.956331877729258 | 146 | 23 | 95.6 | 1 | 456 | 19 | 22 | 165 | AIU94796.1 hypothetical protein [Phragmatopoma lapidosa] | diamond | 438 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Sabellariidae | Phragmatopoma | Phragmatopoma lapidosa | |
| 3198707 | 3198707 | PRJNA675331_P_NODE_5283_length_416_cov_1.565598_g5111_i0 | PRJNA675331 | 5283 | 416 | 1.565598 | 6.51288768 | Metazoa | 33208 | Annelida | Annelida | 224 | 1.78e-71 | NR | ABW23163.1 | 6344 | g5111 | i0 | 80.4 | 10.9471153846154 | 138 | 27 | 99.5 | 0 | 414 | 1 | 17 | 154 | ABW23163.1 ribosomal protein rpl7a, partial [Arenicola marina] | diamond | 4554 | 226 | 0.991150442477876 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina | ||
| 3198719 | 3198719 | PRJNA675331_P_NODE_8863_length_331_cov_0.891473_g8691_i0 | PRJNA675331 | 8863 | 331 | 0.891473 | 2.95077563 | Capitella teleta | 283909 | Annelida | Annelida | 154 | 3.13e-44 | NR | ELU06653.1 | 283909 | g8691 | i0 | 71.6 | 96.8157099697885 | 109 | 26 | 98.8 | 1 | 1 | 327 | 31 | 134 | ELU06653.1 hypothetical protein CAPTEDRAFT_168698 [Capitella teleta] | diamond | 32046 | 155 | 0.993548387096774 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 18500004 | 18500004 | PRJNA675331_P_NODE_14855_length_272_cov_1.427136_g14683_i0 | PRJNA675331 | 14855 | 272 | 1.427136 | 3.88180992 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.025 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g14683 | i0 | 100 | 0.102941176470588 | 28 | 0 | 10 | 0 | 127 | 154 | 2886667 | 2886640 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 27239881 | 27239881 | PRJNA675331_P_NODE_21663_length_245_cov_0.895349_g21491_i0 | PRJNA675331 | 21663 | 245 | 0.895349 | 2.19360505 | Owenia fusiformis | 6347 | Annelida | Annelida | 55.8 | 9.09e-7 | NR | CAH1791574.1 | 6347 | g21491 | i0 | 77.1 | 0.893877551020408 | 35 | 8 | 42.9 | 0 | 110 | 6 | 44 | 78 | CAH1791574.1 unnamed protein product [Owenia fusiformis] | diamond | 219 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27461277 | 27461277 | PRJNA675331_P_NODE_6103_length_389_cov_1.452532_g5931_i0 | PRJNA675331 | 6103 | 389 | 1.452532 | 5.65034948 | Owenia fusiformis | 6347 | Annelida | Annelida | 91.3 | 2.13e-18 | NR | CAH1780542.1 | 6347 | g5931 | i0 | 37.7 | 1.06426735218509 | 138 | 70 | 97.9 | 6 | 3 | 383 | 479 | 611 | CAH1780542.1 unnamed protein product [Owenia fusiformis] | diamond | 414 | 91.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27630980 | 27630980 | PRJNA675331_P_NODE_3664_length_490_cov_2.285372_g3492_i0 | PRJNA675331 | 3664 | 490 | 2.285372 | 11.1983228 | Metazoa | 33208 | Annelida | Annelida | 154 | 5.029999999999999e-42 | NR | ELU12623.1 | 283909 | g3492 | i0 | 81.6 | 7.62244897959184 | 87 | 16 | 53.3 | 0 | 488 | 228 | 23 | 109 | ELU12623.1 hypothetical protein CAPTEDRAFT_166603 [Capitella teleta] | diamond | 3735 | 155 | 0.993548387096774 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 28262107 | 28262107 | PRJNA675331_P_NODE_10846_length_305_cov_1.103448_g10674_i0 | PRJNA675331 | 10846 | 305 | 1.103448 | 3.3655164 | Metazoa | 33208 | Annelida | Annelida | 132 | 7.919999999999999e-37 | NR | CAH1797529.1 | 6347 | g10674 | i0 | 67 | 7.82950819672131 | 100 | 31 | 98.4 | 1 | 301 | 2 | 8 | 105 | CAH1797529.1 unnamed protein product [Owenia fusiformis] | diamond | 2388 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28281861 | 28281861 | PRJNA675331_P_NODE_5446_length_410_cov_1.367953_g5274_i0 | PRJNA675331 | 5446 | 410 | 1.367953 | 5.6086073 | Owenia fusiformis | 6347 | Annelida | Annelida | 76.3 | 4.89e-13 | NR | CAH1780542.1 | 6347 | g5274 | i0 | 37 | 1.06829268292683 | 146 | 77 | 99.5 | 6 | 409 | 2 | 592 | 732 | CAH1780542.1 unnamed protein product [Owenia fusiformis] | diamond | 438 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28483379 | 28483379 | PRJNA675331_P_NODE_24086_length_241_cov_0.916667_g23914_i0 | PRJNA675331 | 24086 | 241 | 0.916667 | 2.20916747 | Metazoa | 33208 | Annelida | Annelida | 93.2 | 1.59e-20 | NR | KAI0234730.1 | 104711 | g23914 | i0 | 60.6 | 3.53526970954357 | 71 | 28 | 88.4 | 0 | 240 | 28 | 58 | 128 | KAI0234730.1 Methyltransferase-like protein 9 [Lamellibrachia satsuma] | diamond | 852 | 93.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 28692719 | 28692719 | PRJNA675331_P_NODE_20327_length_247_cov_0.885057_g20155_i0 | PRJNA675331 | 20327 | 247 | 0.885057 | 2.18609079 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 135 | 1.7100000000000002e-36 | NR | KAK2144829.1 | 53620 | g20155 | i0 | 74.4 | 7.42105263157895 | 78 | 20 | 94.7 | 0 | 244 | 11 | 13 | 90 | KAK2144829.1 hypothetical protein LSH36_726g00011 [Paralvinella palmiformis] | diamond | 1833 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 28893635 | 28893635 | PRJNA675331_P_NODE_7468_length_356_cov_1.088339_g7296_i0 | PRJNA675331 | 7468 | 356 | 1.088339 | 3.87448684 | Opisthokonta | 33154 | Annelida | Annelida | 134 | 1.2499999999999999e-34 | NR | CAH1773901.1 | 6347 | g7296 | i0 | 53.7 | 5.14887640449438 | 123 | 52 | 99.4 | 1 | 355 | 2 | 202 | 324 | CAH1773901.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 1833 | 135 | 0.992592592592593 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29398900 | 29398900 | PRJNA675331_P_NODE_21809_length_245_cov_0.895349_g21637_i0 | PRJNA675331 | 21809 | 245 | 0.895349 | 2.19360505 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 99 | 6.37e-22 | NR | KAK2181249.1 | 27915 | g21637 | i0 | 63 | 6.8938775510204104 | 81 | 27 | 95.5 | 2 | 236 | 3 | 282 | 362 | KAK2181249.1 hypothetical protein NP493_405g05002 [Ridgeia piscesae] | diamond | 1689 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 30251896 | 30251896 | PRJNA675331_P_NODE_19832_length_248_cov_0.880000_g19660_i0 | PRJNA675331 | 19832 | 248 | 0.88 | 2.1824 | Metazoa | 33208 | Annelida | Annelida | 96.3 | 4.939999999999999e-23 | NR | XP_009028586.1 | 6412 | g19660 | i0 | 59 | 8.49193548387097 | 78 | 32 | 94.4 | 0 | 235 | 2 | 2 | 79 | XP_009028586.1 hypothetical protein HELRODRAFT_181061 [Helobdella robusta] | diamond | 2106 | 96.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 30283728 | 30283728 | PRJNA675331_P_NODE_9612_length_320_cov_0.935223_g9440_i0 | PRJNA675331 | 9612 | 320 | 0.935223 | 2.9927136 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 130 | 1.35e-35 | NR | CAH1784699.1 | 6347 | g9440 | i0 | 63.4 | 21.159375 | 101 | 36 | 94.7 | 1 | 11 | 313 | 8 | 107 | CAH1784699.1 unnamed protein product [Owenia fusiformis] | diamond | 6771 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30366691 | 30366691 | PRJNA675331_P_NODE_4012_length_470_cov_1.962217_g3840_i0 | PRJNA675331 | 4012 | 470 | 1.962217 | 9.2224199 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 50.8 | 6.29e-4 | NR | KAK2164254.1 | 53620 | g3840 | i0 | 44.9 | 0.312765957446809 | 49 | 24 | 31.3 | 1 | 462 | 316 | 3261 | 3306 | KAK2164254.1 hypothetical protein LSH36_67g06060 [Paralvinella palmiformis] | diamond | 147 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 31218989 | 31218989 | PRJNA675331_P_NODE_21155_length_246_cov_0.890173_g20983_i0 | PRJNA675331 | 21155 | 246 | 0.890173 | 2.18982558 | Owenia fusiformis | 6347 | Annelida | Annelida | 68.6 | 3.16e-11 | NR | CAH1780542.1 | 6347 | g20983 | i0 | 38.5 | 0.951219512195122 | 78 | 47 | 95.1 | 1 | 11 | 244 | 739 | 815 | CAH1780542.1 unnamed protein product [Owenia fusiformis] | diamond | 234 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31504207 | 31504207 | PRJNA675331_P_NODE_5216_length_419_cov_1.335260_g5044_i0 | PRJNA675331 | 5216 | 419 | 1.33526 | 5.5947394 | Owenia fusiformis | 6347 | Annelida | Annelida | 77.8 | 1.5700000000000001e-13 | NR | CAH1780542.1 | 6347 | g5044 | i0 | 29.6 | 1.47494033412888 | 206 | 77 | 99.5 | 7 | 418 | 2 | 379 | 583 | CAH1780542.1 unnamed protein product [Owenia fusiformis] | diamond | 618 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31927032 | 31927032 | PRJNA675331_P_NODE_1177_length_829_cov_1.105820_g1029_i0 | PRJNA675331 | 1177 | 829 | 1.10582 | 9.1672478 | Metazoa | 33208 | Annelida | Annelida | 57.8 | 1.86e-5 | NR | KAI0226827.1 | 104711 | g1029 | i0 | 50 | 0.756332931242461 | 56 | 27 | 19.9 | 1 | 827 | 663 | 382 | 437 | KAI0226827.1 G2/mitotic-specific cyclin-A [Lamellibrachia satsuma] | diamond | 627 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 31927038 | 31927038 | PRJNA675331_P_NODE_3217_length_520_cov_2.328859_g3047_i0 | PRJNA675331 | 3217 | 520 | 2.328859 | 12.1100668 | Metazoa | 33208 | Annelida | Annelida | 82.4 | 7.48e-16 | NR | CAH1778726.1 | 6347 | g3047 | i0 | 37.3 | 1.93846153846154 | 153 | 76 | 80.8 | 6 | 511 | 92 | 1 | 146 | CAH1778726.1 unnamed protein product [Owenia fusiformis] | diamond | 1008 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32611135 | 32611135 | PRJNA675331_P_NODE_15480_length_268_cov_1.574359_g15308_i0 | PRJNA675331 | 15480 | 268 | 1.574359 | 4.21928212 | Owenia fusiformis | 6347 | Annelida | Annelida | 65.1 | 6.83e-10 | NR | CAH1776474.1 | 6347 | g15308 | i0 | 49.3 | 0.794776119402985 | 71 | 33 | 76.1 | 2 | 64 | 267 | 260 | 330 | CAH1776474.1 unnamed protein product [Owenia fusiformis] | diamond | 213 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32737225 | 32737225 | PRJNA675331_P_NODE_1680_length_703_cov_1.703175_g1519_i0 | PRJNA675331 | 1680 | 703 | 1.703175 | 11.97332025 | Owenia fusiformis | 6347 | Annelida | Annelida | 143 | 6.059999999999999e-35 | NR | CAH1780542.1 | 6347 | g1519 | i0 | 36.5 | 1.02844950213371 | 241 | 140 | 99.9 | 6 | 703 | 2 | 662 | 896 | CAH1780542.1 unnamed protein product [Owenia fusiformis] | diamond | 723 | 143 | 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);;