contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA438111" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4261392 | 4261392 | PRJNA438111_P_NODE_5684_length_415_cov_3.911917_g5099_i0 | PRJNA438111 | 5684 | 415 | 3.911917 | 16.23445555 | Metazoa | 33208 | Annelida | Annelida | 162 | 1.26e-43 | NR | CAH1793813.1 | 6347 | g5099 | i0 | 60 | 9.10120481927711 | 140 | 54 | 99.8 | 2 | 415 | 2 | 203 | 342 | CAH1793813.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 3777 | 163 | 0.993865030674847 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 5537540 | 5537540 | PRJNA438111_P_NODE_1665_length_737_cov_8.847458_g1301_i0 | PRJNA438111 | 1665 | 737 | 8.847458 | 65.20576546 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 388 | 1.2499999999999997e-132 | NR | CAH1772965.1 | 6347 | g1301 | i0 | 78.4 | 60.753052917232 | 245 | 53 | 99.7 | 0 | 3 | 737 | 110 | 354 | CAH1772965.1 unnamed protein product [Owenia fusiformis] | diamond | 44775 | 390 | 0.994871794871795 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 8087175 | 8087175 | PRJNA438111_P_NODE_2347_length_628_cov_9.824708_g1911_i0 | PRJNA438111 | 2347 | 628 | 9.824708 | 61.69916624 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 256 | 2.34e-83 | NR | KAK2144140.1 | 53620 | g1911 | i0 | 63.9 | 27.859872611465 | 194 | 70 | 92.7 | 0 | 626 | 45 | 9 | 202 | KAK2144140.1 hypothetical protein LSH36_782g05025 [Paralvinella palmiformis] | diamond | 17496 | 256 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 16393052 | 16393052 | PRJNA438111_P_NODE_26313_length_213_cov_2.929348_g25688_i0 | PRJNA438111 | 26313 | 213 | 2.929348 | 6.23951124 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 101 | 6.189999999999999e-23 | NR | KAK2158033.1 | 53620 | g25688 | i0 | 69.6 | 12.6056338028169 | 69 | 21 | 97.2 | 0 | 208 | 2 | 749 | 817 | KAK2158033.1 hypothetical protein LSH36_178g02040 [Paralvinella palmiformis] | diamond | 2685 | 102 | 0.990196078431373 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 19560318 | 19560318 | PRJNA438111_P_NODE_5916_length_407_cov_4.198413_g5327_i0 | PRJNA438111 | 5916 | 407 | 4.198413 | 17.08754091 | Helobdella robusta | 6412 | Annelida | Annelida | 155 | 5.839999999999999e-45 | NR | XP_009015607.1 | 6412 | g5327 | i0 | 63.5 | 3.69287469287469 | 126 | 41 | 90.7 | 2 | 407 | 39 | 78 | 201 | XP_009015607.1 hypothetical protein HELRODRAFT_155684 [Helobdella robusta] | diamond | 1503 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 26743728 | 26743728 | PRJNA438111_P_NODE_3641_length_514_cov_5.173196_g3128_i0 | PRJNA438111 | 3641 | 514 | 5.173196 | 26.59022744 | Metazoa | 33208 | Annelida | Annelida | 162 | 7.58e-45 | NR | XP_009012062.1 | 6412 | g3128 | i0 | 50.9 | 6.86964980544747 | 167 | 79 | 96.9 | 3 | 16 | 513 | 5 | 169 | XP_009012062.1 hypothetical protein HELRODRAFT_122321, partial [Helobdella robusta] | diamond | 3531 | 162 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 27503265 | 27503265 | PRJNA438111_P_NODE_47843_length_184_cov_2.670968_g47218_i0 | PRJNA438111 | 47843 | 184 | 2.670968 | 4.91458112 | Metazoa | 33208 | Annelida | Annelida | 94.7 | 5.76e-22 | NR | CAH1779798.1 | 6347 | g47218 | i0 | 63.9 | 2.98369565217391 | 61 | 22 | 99.5 | 0 | 2 | 184 | 156 | 216 | CAH1779798.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 549 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27676430 | 27676430 | PRJNA438111_P_NODE_40424_length_193_cov_5.231707_g39799_i0 | PRJNA438111 | 40424 | 193 | 5.231707 | 10.09719451 | Capitella teleta | 283909 | Annelida | Annelida | 57 | 1.59e-7 | NR | ELU16969.1 | 283909 | g39799 | i0 | 39.7 | 2.93782383419689 | 63 | 37 | 97.9 | 1 | 192 | 4 | 182 | 243 | ELU16969.1 hypothetical protein CAPTEDRAFT_192533 [Capitella teleta] | diamond | 567 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 27739704 | 27739704 | PRJNA438111_P_NODE_81024_length_157_cov_2.664062_g80399_i0 | PRJNA438111 | 81024 | 157 | 2.664062 | 4.18257734 | Owenia fusiformis | 6347 | Annelida | Annelida | 65.9 | 7.77e-11 | NR | CAH1794822.1 | 6347 | g80399 | i0 | 54.8 | 1.60509554140127 | 42 | 19 | 80.3 | 0 | 3 | 128 | 523 | 564 | CAH1794822.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 252 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28433991 | 28433991 | PRJNA438111_P_NODE_14346_length_276_cov_2.963563_g13721_i0 | PRJNA438111 | 14346 | 276 | 2.963563 | 8.17943388 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 97.8 | 1.41e-21 | NR | CAD5124890.1 | 2664684 | g13721 | i0 | 53.8 | 0.869565217391304 | 80 | 37 | 87 | 0 | 275 | 36 | 347 | 426 | CAD5124890.1 DgyrCDS13142 [Dimorphilus gyrociliatus] | diamond | 240 | 97.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 28655046 | 28655046 | PRJNA438111_P_NODE_7107_length_375_cov_3.786127_g6496_i0 | PRJNA438111 | 7107 | 375 | 3.786127 | 14.19797625 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 63.5 | 8.25e-9 | NR | CAD5111239.1 | 2664684 | g6496 | i0 | 53.2 | 18.784 | 47 | 22 | 37.6 | 0 | 373 | 233 | 408 | 454 | CAD5111239.1 DgyrCDS568 [Dimorphilus gyrociliatus] | diamond | 7044 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 28749707 | 28749707 | PRJNA438111_P_NODE_38787_length_196_cov_3.479042_g38162_i0 | PRJNA438111 | 38787 | 196 | 3.479042 | 6.81892232 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 47.4 | 4.54e-4 | NR | KAK2147610.1 | 53620 | g38162 | i0 | 58.5 | 0.627551020408163 | 41 | 16 | 61.2 | 1 | 45 | 164 | 121 | 161 | KAK2147610.1 hypothetical protein LSH36_545g04026 [Paralvinella palmiformis] | diamond | 123 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 28875960 | 28875960 | PRJNA438111_P_NODE_56128_length_175_cov_2.986301_g55503_i0 | PRJNA438111 | 56128 | 175 | 2.986301 | 5.22602675 | Capitella teleta | 283909 | Annelida | Annelida | 65.9 | 3.45e-11 | NR | ELT88652.1 | 283909 | g55503 | i0 | 52.8 | 4.81714285714286 | 53 | 25 | 90.9 | 0 | 160 | 2 | 131 | 183 | ELT88652.1 hypothetical protein CAPTEDRAFT_226635 [Capitella teleta] | diamond | 843 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 29664973 | 29664973 | PRJNA438111_P_NODE_6330_length_395_cov_7.051913_g5735_i0 | PRJNA438111 | 6330 | 395 | 7.051913 | 27.85505635 | Owenia fusiformis | 6347 | Annelida | Annelida | 146 | 2.36e-38 | NR | CAH1779025.1 | 6347 | g5735 | i0 | 47.7 | 2.9620253164557 | 130 | 68 | 98.7 | 0 | 2 | 391 | 449 | 578 | CAH1779025.1 unnamed protein product [Owenia fusiformis] | diamond | 1170 | 146 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29949591 | 29949591 | PRJNA438111_P_NODE_23111_length_225_cov_2.239796_g22486_i0 | PRJNA438111 | 23111 | 225 | 2.239796 | 5.039541 | Capitella teleta | 283909 | Annelida | Annelida | 51.2 | 3.03e-5 | NR | ELT93796.1 | 283909 | g22486 | i0 | 41.9 | 0.826666666666667 | 62 | 36 | 82.7 | 0 | 223 | 38 | 1325 | 1386 | ELT93796.1 hypothetical protein CAPTEDRAFT_169570 [Capitella teleta] | diamond | 186 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 30029220 | 30029220 | PRJNA438111_P_NODE_44171_length_188_cov_5.540881_g43546_i0 | PRJNA438111 | 44171 | 188 | 5.540881 | 10.41685628 | Metazoa | 33208 | Annelida | Annelida | 117 | 4.62e-29 | NR | KAK2141508.1 | 53620 | g43546 | i0 | 80.6 | 76.1808510638298 | 62 | 12 | 98.9 | 0 | 188 | 3 | 366 | 427 | KAK2141508.1 hypothetical protein LSH36_1090g00121 [Paralvinella palmiformis] | diamond | 14322 | 118 | 0.991525423728814 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 30202098 | 30202098 | PRJNA438111_P_NODE_66012_length_167_cov_2.681159_g65387_i0 | PRJNA438111 | 66012 | 167 | 2.681159 | 4.47753553 | Alvinella pompejana | 6376 | Annelida | Annelida | 57.4 | 8.97e-8 | NR | QSG73581.1 | 6376 | g65387 | i0 | 49.1 | 1.97604790419162 | 55 | 28 | 98.8 | 0 | 166 | 2 | 341 | 395 | QSG73581.1 ganglioside-induced differentiation-associated protein 2 [Alvinella pompejana] | diamond | 330 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Alvinella | Alvinella pompejana | |
| 30581248 | 30581248 | PRJNA438111_P_NODE_61173_length_170_cov_4.921986_g60548_i0 | PRJNA438111 | 61173 | 170 | 4.921986 | 8.3673762 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 65.1 | 1.16e-10 | NR | CAD5115590.1 | 2664684 | g60548 | i0 | 54.5 | 2.77058823529412 | 55 | 25 | 97.1 | 0 | 168 | 4 | 147 | 201 | CAD5115590.1 DgyrCDS4551 [Dimorphilus gyrociliatus] | diamond | 471 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 30739385 | 30739385 | PRJNA438111_P_NODE_4654_length_458_cov_3.531469_g4102_i0 | PRJNA438111 | 4654 | 458 | 3.531469 | 16.17412802 | Helobdella robusta | 6412 | Annelida | Annelida | 46.2 | 0.0157 | NR | XP_009024095.1 | 6412 | g4102 | i0 | 28.8 | 0.818777292576419 | 125 | 74 | 76.6 | 5 | 398 | 48 | 157 | 274 | XP_009024095.1 hypothetical protein HELRODRAFT_85194, partial [Helobdella robusta] | diamond | 375 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 30771241 | 30771241 | PRJNA438111_P_NODE_65934_length_167_cov_2.891304_g65309_i0 | PRJNA438111 | 65934 | 167 | 2.891304 | 4.82847768 | Ridgeia piscesae | 27915 | Annelida | Annelida | 45.1 | 0.00204 | NR | KAK2156791.1 | 27915 | g65309 | i0 | 46.3 | 0.970059880239521 | 54 | 25 | 97 | 2 | 4 | 165 | 125 | 174 | KAK2156791.1 hypothetical protein NP493_1929g00000 [Ridgeia piscesae] | diamond | 162 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 31466621 | 31466621 | PRJNA438111_P_NODE_81476_length_156_cov_10.417323_g80851_i0 | PRJNA438111 | 81476 | 156 | 10.417323 | 16.25102388 | Capitella teleta | 283909 | Annelida | Annelida | 42.4 | 0.0162 | NR | ELU17460.1 | 283909 | g80851 | i0 | 42.3 | 1.73076923076923 | 52 | 24 | 88.5 | 1 | 16 | 153 | 507 | 558 | ELU17460.1 hypothetical protein CAPTEDRAFT_228346 [Capitella teleta] | diamond | 270 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 32020588 | 32020588 | PRJNA438111_P_NODE_61498_length_170_cov_3.120567_g60873_i0 | PRJNA438111 | 61498 | 170 | 3.120567 | 5.3049639 | Metazoa | 33208 | Annelida | Annelida | 62 | 2.21e-9 | NR | KAK2144151.1 | 53620 | g60873 | i0 | 48.2 | 3.95294117647059 | 56 | 29 | 98.8 | 0 | 169 | 2 | 475 | 530 | KAK2144151.1 hypothetical protein LSH36_781g01006 [Paralvinella palmiformis] | diamond | 672 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 32225793 | 32225793 | PRJNA438111_P_NODE_39778_length_194_cov_5.587879_g39153_i0 | PRJNA438111 | 39778 | 194 | 5.587879 | 10.84048526 | Helobdella robusta | 6412 | Annelida | Annelida | 72.8 | 4.89e-13 | NR | XP_009019568.1 | 6412 | g39153 | i0 | 59.4 | 1.97938144329897 | 64 | 20 | 99 | 2 | 193 | 2 | 96 | 153 | XP_009019568.1 hypothetical protein HELRODRAFT_161397 [Helobdella robusta] | diamond | 384 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 32715922 | 32715922 | PRJNA438111_P_NODE_6380_length_393_cov_37.258242_g5785_i0 | PRJNA438111 | 6380 | 393 | 37.258242 | 146.42489106 | Metazoa | 33208 | Annelida | Annelida | 117 | 9.14e-31 | NR | XP_009028086.1 | 6412 | g5785 | i0 | 45.8 | 4.56488549618321 | 120 | 64 | 91.6 | 1 | 387 | 28 | 24 | 142 | XP_009028086.1 hypothetical protein HELRODRAFT_186065 [Helobdella robusta] | diamond | 1794 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 32810354 | 32810354 | PRJNA438111_P_NODE_80300_length_157_cov_5.781250_g79675_i0 | PRJNA438111 | 80300 | 157 | 5.78125 | 9.0765625 | Metazoa | 33208 | Annelida | Annelida | 47 | 3.76e-4 | NR | XP_009014648.1 | 6412 | g79675 | i0 | 38.5 | 6.95541401273885 | 52 | 32 | 99.4 | 0 | 156 | 1 | 946 | 997 | XP_009014648.1 hypothetical protein HELRODRAFT_170597 [Helobdella robusta] | diamond | 1092 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 32825577 | 32825577 | PRJNA438111_P_NODE_21680_length_231_cov_5.257426_g21055_i0 | PRJNA438111 | 21680 | 231 | 5.257426 | 12.14465406 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 114 | 5.16e-28 | NR | CAD5113571.1 | 2664684 | g21055 | i0 | 72.4 | 4.8961038961039 | 76 | 21 | 98.7 | 0 | 230 | 3 | 51 | 126 | CAD5113571.1 DgyrCDS2735 [Dimorphilus gyrociliatus] | diamond | 1131 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus |
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);;