contig_metadata
22 rows where analysis = "diamond", bioproject = "PRJNA896758" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 22549612 | 22549612 | PRJNA896758_P_NODE_14458_length_302_cov_1.008734_g14068_i0 | PRJNA896758 | 14458 | 302 | 1.008734 | 3.04637668 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 142 | 1.31e-37 | NR | KAK2143232.1 | 53620 | g14068 | i0 | 63.3 | 3.30794701986755 | 128 | 18 | 98.3 | 1 | 301 | 5 | 250 | 377 | KAK2143232.1 hypothetical protein LSH36_861g01031 [Paralvinella palmiformis] | diamond | 999 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 25098931 | 25098931 | PRJNA896758_P_NODE_620_length_1446_cov_3.592862_g426_i0 | PRJNA896758 | 620 | 1446 | 3.5928619999999998 | 51.95278452 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 169 | 7.56e-45 | NR | KAK2147523.1 | 53620 | g426 | i0 | 65.4 | 0.282157676348548 | 136 | 39 | 27.6 | 2 | 173 | 571 | 10 | 140 | KAK2147523.1 hypothetical protein LSH36_548g00001 [Paralvinella palmiformis] | diamond | 408 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 25470647 | 25470647 | PRJNA896758_P_NODE_1700_length_889_cov_2.154412_g1372_i0 | PRJNA896758 | 1700 | 889 | 2.154412 | 19.15272268 | Metazoa | 33208 | Annelida | Annelida | 241 | 1.51e-71 | NR | CAH1795116.1 | 6347 | g1372 | i0 | 76.1 | 19.2857142857143 | 155 | 37 | 52.3 | 0 | 414 | 878 | 150 | 304 | CAH1795116.1 unnamed protein product [Owenia fusiformis] | diamond | 17145 | 241 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27372089 | 27372089 | PRJNA896758_P_NODE_20203_length_258_cov_1.340541_g19813_i0 | PRJNA896758 | 20203 | 258 | 1.340541 | 3.45859578 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 89 | 2.44e-18 | NR | KAK2145023.1 | 53620 | g19813 | i0 | 59.5 | 0.86046511627907 | 74 | 28 | 86 | 2 | 35 | 256 | 532 | 603 | KAK2145023.1 hypothetical protein LSH36_708g01117 [Paralvinella palmiformis] | diamond | 222 | 89 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 27505981 | 27505981 | PRJNA896758_P_NODE_4663_length_527_cov_4.334802_g4276_i0 | PRJNA896758 | 4663 | 527 | 4.334802 | 22.84440654 | Metazoa | 33208 | Annelida | Annelida | 167 | 1.74e-48 | NR | WXB48350.1 | 6390 | g4276 | i0 | 64.3 | 3.38140417457305 | 112 | 39 | 63.2 | 1 | 103 | 435 | 111 | 222 | WXB48350.1 destabilase-lysozyme 2 [Enchytraeus albidus] | diamond | 1782 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Enchytraeida | Enchytraeidae | Enchytraeus | Enchytraeus albidus | |
| 27750907 | 27750907 | PRJNA896758_P_NODE_19644_length_262_cov_1.629630_g19254_i0 | PRJNA896758 | 19644 | 262 | 1.62963 | 4.2696306 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 114 | 1.37e-30 | NR | KAK2160041.1 | 53620 | g19254 | i0 | 64.4 | 3.98473282442748 | 87 | 26 | 99.6 | 1 | 1 | 261 | 8 | 89 | KAK2160041.1 hypothetical protein LSH36_141g03000 [Paralvinella palmiformis] | diamond | 1044 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 27876944 | 27876944 | PRJNA896758_P_NODE_23145_length_248_cov_0.880000_g22755_i0 | PRJNA896758 | 23145 | 248 | 0.88 | 2.1824 | Helobdella robusta | 6412 | Annelida | Annelida | 114 | 1.84e-29 | NR | XP_009020549.1 | 6412 | g22755 | i0 | 65.9 | 3.96774193548387 | 82 | 28 | 99.2 | 0 | 3 | 248 | 76 | 157 | XP_009020549.1 hypothetical protein HELRODRAFT_185710 [Helobdella robusta] | diamond | 984 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28540266 | 28540266 | PRJNA896758_P_NODE_21027_length_251_cov_1.730337_g20637_i0 | PRJNA896758 | 21027 | 251 | 1.730337 | 4.34314587 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 47.8 | 7.04e-4 | NR | CAD5122260.1 | 2664684 | g20637 | i0 | 59.5 | 0.884462151394422 | 42 | 17 | 50.2 | 0 | 81 | 206 | 270 | 311 | CAD5122260.1 DgyrCDS10705 [Dimorphilus gyrociliatus] | diamond | 222 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 29297859 | 29297859 | PRJNA896758_P_NODE_9829_length_364_cov_0.903780_g9439_i0 | PRJNA896758 | 9829 | 364 | 0.90378 | 3.2897592 | Capitella teleta | 283909 | Annelida | Annelida | 46.2 | 0.0076 | NR | ELU04705.1 | 283909 | g9439 | i0 | 43.6 | 0.453296703296703 | 55 | 25 | 40.4 | 1 | 179 | 325 | 133 | 187 | ELU04705.1 hypothetical protein CAPTEDRAFT_155099 [Capitella teleta] | diamond | 165 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 29462999 | 29462999 | PRJNA896758_P_NODE_2310_length_757_cov_1.678363_g1954_i0 | PRJNA896758 | 2310 | 757 | 1.678363 | 12.70520791 | Metazoa | 33208 | Annelida | Annelida | 378 | 2.72e-122 | NR | XP_009024174.1 | 6412 | g1954 | i0 | 82.2 | 11.5878467635403 | 225 | 39 | 89.2 | 1 | 81 | 755 | 2 | 225 | XP_009024174.1 hypothetical protein HELRODRAFT_101987 [Helobdella robusta] | diamond | 8772 | 381 | 0.992125984251969 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 29620790 | 29620790 | PRJNA896758_P_NODE_22270_length_249_cov_0.875000_g21880_i0 | PRJNA896758 | 22270 | 249 | 0.875 | 2.17875 | Sabellida | 6362 | Annelida | Annelida | 85.1 | 1.04e-17 | NR | KAK2174401.1 | 27915 | g21880 | i0 | 49.4 | 1.89156626506024 | 79 | 39 | 95.2 | 1 | 238 | 2 | 96 | 173 | KAK2174401.1 hypothetical protein NP493_802g03027 [Ridgeia piscesae] | diamond | 471 | 85.9 | 0.990686845168801 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 29707820 | 29707820 | PRJNA896758_P_NODE_20410_length_256_cov_1.683060_g20020_i0 | PRJNA896758 | 20410 | 256 | 1.68306 | 4.3086336 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 87 | 1e-17 | NR | CAD5116077.1 | 2664684 | g20020 | i0 | 52.1 | 0.83203125 | 71 | 34 | 83.2 | 0 | 217 | 5 | 18 | 88 | CAD5116077.1 DgyrCDS5007 [Dimorphilus gyrociliatus] | diamond | 213 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 29905598 | 29905598 | PRJNA896758_P_NODE_16871_length_281_cov_1.480769_g16481_i0 | PRJNA896758 | 16871 | 281 | 1.480769 | 4.16096089 | Metazoa | 33208 | Annelida | Annelida | 46.6 | 0.00243 | NR | UCK81521.1 | 6344 | g16481 | i0 | 41.7 | 1.39857651245552 | 60 | 33 | 63 | 2 | 105 | 281 | 55 | 113 | UCK81521.1 cathepsin K [Arenicola marina] | diamond | 393 | 47 | 0.991489361702128 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina | ||
| 30055528 | 30055528 | PRJNA896758_P_NODE_19231_length_265_cov_1.578125_g18841_i0 | PRJNA896758 | 19231 | 265 | 1.578125 | 4.18203125 | Owenia fusiformis | 6347 | Annelida | Annelida | 46.6 | 0.0021 | NR | CAH1776216.1 | 6347 | g18841 | i0 | 46.5 | 0.486792452830189 | 43 | 23 | 48.7 | 0 | 114 | 242 | 417 | 459 | CAH1776216.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 129 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30821697 | 30821697 | PRJNA896758_P_NODE_21614_length_250_cov_1.423729_g21224_i0 | PRJNA896758 | 21614 | 250 | 1.423729 | 3.5593225 | Metazoa | 33208 | Annelida | Annelida | 128 | 1.17e-33 | NR | CAH1798415.1 | 6347 | g21224 | i0 | 84.1 | 3.312 | 69 | 11 | 82.8 | 0 | 249 | 43 | 277 | 345 | CAH1798415.1 unnamed protein product [Owenia fusiformis] | diamond | 828 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30940542 | 30940542 | PRJNA896758_P_NODE_26554_length_241_cov_0.916667_g26164_i0 | PRJNA896758 | 26554 | 241 | 0.916667 | 2.20916747 | Helobdella robusta | 6412 | Annelida | Annelida | 120 | 1.21e-29 | NR | XP_009025268.1 | 6412 | g26164 | i0 | 63.2 | 0.946058091286307 | 76 | 28 | 94.6 | 0 | 231 | 4 | 869 | 944 | XP_009025268.1 hypothetical protein HELRODRAFT_95510 [Helobdella robusta] | diamond | 228 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 31137358 | 31137358 | PRJNA896758_P_NODE_26795_length_235_cov_2.376543_g26405_i0 | PRJNA896758 | 26795 | 235 | 2.376543 | 5.58487605 | Metazoa | 33208 | Annelida | Annelida | 46.6 | 0.00144 | NR | CAH1777391.1 | 6347 | g26405 | i0 | 60.7 | 2.05531914893617 | 28 | 11 | 35.7 | 0 | 1 | 84 | 365 | 392 | CAH1777391.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 483 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31635855 | 31635855 | PRJNA896758_P_NODE_18516_length_270_cov_1.563452_g18126_i0 | PRJNA896758 | 18516 | 270 | 1.563452 | 4.2213204 | Ridgeia piscesae | 27915 | Annelida | Annelida | 67.8 | 6.13e-13 | NR | KAK2182116.1 | 27915 | g18126 | i0 | 67.4 | 0.511111111111111 | 46 | 15 | 51.1 | 0 | 147 | 10 | 2 | 47 | KAK2182116.1 hypothetical protein NP493_366g02051 [Ridgeia piscesae] | diamond | 138 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 31991542 | 31991542 | PRJNA896758_P_NODE_11138_length_344_cov_1.136531_g10748_i0 | PRJNA896758 | 11138 | 344 | 1.136531 | 3.90966664 | Metazoa | 33208 | Annelida | Annelida | 68.6 | 1.02e-10 | NR | CAH1784010.1 | 6347 | g10748 | i0 | 60 | 7.22093023255814 | 55 | 22 | 48 | 0 | 180 | 344 | 96 | 150 | CAH1784010.1 unnamed protein product [Owenia fusiformis] | diamond | 2484 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32213208 | 32213208 | PRJNA896758_P_NODE_23238_length_247_cov_1.620690_g22848_i0 | PRJNA896758 | 23238 | 247 | 1.62069 | 4.0031043 | Metazoa | 33208 | Annelida | Annelida | 86.3 | 1.91e-17 | NR | CAH1789996.1 | 6347 | g22848 | i0 | 55.9 | 23.7206477732794 | 68 | 30 | 82.6 | 0 | 231 | 28 | 682 | 749 | CAH1789996.1 unnamed protein product [Owenia fusiformis] | diamond | 5859 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32237401 | 32237401 | PRJNA896758_P_NODE_15138_length_293_cov_3.640909_g14748_i0 | PRJNA896758 | 15138 | 293 | 3.640909 | 10.66786337 | Owenia fusiformis | 6347 | Annelida | Annelida | 69.3 | 1.45e-12 | NR | CAH1789242.1 | 6347 | g14748 | i0 | 47.3 | 1.12627986348123 | 55 | 29 | 56.3 | 0 | 173 | 9 | 76 | 130 | CAH1789242.1 unnamed protein product [Owenia fusiformis] | diamond | 330 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32876001 | 32876001 | PRJNA896758_P_NODE_12760_length_322_cov_1.232932_g12370_i0 | PRJNA896758 | 12760 | 322 | 1.232932 | 3.97004104 | Metazoa | 33208 | Annelida | Annelida | 93.2 | 3.4900000000000005e-21 | NR | XP_009009585.1 | 6412 | g12370 | i0 | 82 | 4.12732919254658 | 50 | 9 | 46.6 | 0 | 322 | 173 | 135 | 184 | XP_009009585.1 hypothetical protein HELRODRAFT_159451 [Helobdella robusta] | diamond | 1329 | 94 | 0.991489361702128 | 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);;