contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA1233465" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25672185 | 25672185 | PRJNA1233465b_S_NODE_103954_length_271_cov_2.842342_g102269_i0 | PRJNA1233465 | 103954 | 271 | 2.842342 | 7.70274682 | Metazoa | 33208 | Annelida | Annelida | 72 | 1.27e-12 | NR | XP_009027458.1 | 6412 | g102269 | i0 | 70.7 | 11.9889298892989 | 41 | 11 | 45.4 | 1 | 269 | 147 | 56 | 95 | XP_009027458.1 hypothetical protein HELRODRAFT_95625 [Helobdella robusta] | diamond | 3249 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 32931528 | 32931528 | PRJNA1233465a_S_NODE_163193_length_189_cov_1.078571_g161919_i0 | PRJNA1233465 | 163193 | 189 | 1.078571 | 2.03849919 | Capitella teleta | 283909 | Annelida | Annelida | 48.1 | 1.99e-4 | NR | ELU17098.1 | 283909 | g161919 | i0 | 41.3 | 1.96825396825397 | 63 | 35 | 96.8 | 1 | 186 | 4 | 83 | 145 | ELU17098.1 hypothetical protein CAPTEDRAFT_217120 [Capitella teleta] | diamond | 372 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 32932414 | 32932414 | PRJNA1233465b_S_NODE_350945_length_164_cov_1.191304_g349260_i0 | PRJNA1233465 | 350945 | 164 | 1.191304 | 1.95373856 | Capitella teleta | 283909 | Annelida | Annelida | 45.4 | 0.00122 | NR | ELT96916.1 | 283909 | g349260 | i0 | 48.9 | 0.859756097560976 | 47 | 24 | 86 | 0 | 22 | 162 | 24 | 70 | ELT96916.1 hypothetical protein CAPTEDRAFT_203287 [Capitella teleta] | diamond | 141 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 32933152 | 32933152 | PRJNA1233465e_S_NODE_107785_length_187_cov_1.137681_g106475_i0 | PRJNA1233465 | 107785 | 187 | 1.137681 | 2.12746347 | Ridgeia piscesae | 27915 | Annelida | Annelida | 66.6 | 4.02e-12 | NR | KAK2181635.1 | 27915 | g106475 | i0 | 58.1 | 0.994652406417112 | 62 | 26 | 99.5 | 0 | 186 | 1 | 33 | 94 | KAK2181635.1 hypothetical protein NP493_386g01017 [Ridgeia piscesae] | diamond | 186 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 32940746 | 32940746 | PRJNA1233465b_S_NODE_269737_length_184_cov_0.859259_g268052_i0 | PRJNA1233465 | 269737 | 184 | 0.859259 | 1.58103656 | Metazoa | 33208 | Annelida | Annelida | 73.6 | 1.13e-14 | NR | ABW23146.1 | 6344 | g268052 | i0 | 86.4 | 45.9130434782609 | 44 | 6 | 71.7 | 0 | 172 | 41 | 62 | 105 | ABW23146.1 ribosomal protein rps16 [Arenicola marina] | diamond | 8448 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina | ||
| 32940782 | 32940782 | PRJNA1233465b_S_NODE_34105_length_402_cov_5.430595_g32431_i0 | PRJNA1233465 | 34105 | 402 | 5.430595 | 21.8309919 | Metazoa | 33208 | Annelida | Annelida | 48.1 | 0.00233 | NR | KAK2151757.1 | 27915 | g32431 | i0 | 53.5 | 0.992537313432836 | 43 | 19 | 31.3 | 1 | 103 | 228 | 200 | 242 | KAK2151757.1 hypothetical protein NP493_2575g00001 [Ridgeia piscesae] | diamond | 399 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 32941101 | 32941101 | PRJNA1233465f_S_NODE_161913_length_194_cov_1.544828_g159633_i0 | PRJNA1233465 | 161913 | 194 | 1.544828 | 2.99696632 | Metazoa | 33208 | Annelida | Annelida | 60.8 | 7.9e-10 | NR | KAK2181635.1 | 27915 | g159633 | i0 | 52.5 | 3.75773195876289 | 61 | 29 | 94.3 | 0 | 11 | 193 | 16 | 76 | KAK2181635.1 hypothetical protein NP493_386g01017 [Ridgeia piscesae] | diamond | 729 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 32951157 | 32951157 | PRJNA1233465f_S_NODE_175602_length_188_cov_0.884892_g173322_i0 | PRJNA1233465 | 175602 | 188 | 0.884892 | 1.66359696 | Ridgeia piscesae | 27915 | Annelida | Annelida | 57 | 2.31e-8 | NR | KAK2181635.1 | 27915 | g173322 | i0 | 56 | 0.797872340425532 | 50 | 22 | 79.8 | 0 | 35 | 184 | 78 | 127 | KAK2181635.1 hypothetical protein NP493_386g01017 [Ridgeia piscesae] | diamond | 150 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 32951452 | 32951452 | PRJNA1233465f_S_NODE_3394_length_1014_cov_6.872539_g2174_i0 | PRJNA1233465 | 3394 | 1014 | 6.872539 | 69.68754546 | Ridgeia piscesae | 27915 | Annelida | Annelida | 107 | 1.39e-24 | NR | KAK2181635.1 | 27915 | g2174 | i0 | 52 | 0.369822485207101 | 125 | 60 | 37 | 0 | 565 | 939 | 3 | 127 | KAK2181635.1 hypothetical protein NP493_386g01017 [Ridgeia piscesae] | diamond | 375 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 32968484 | 32968484 | PRJNA1233465f_S_NODE_2050_length_1310_cov_4.553529_g1123_i0 | PRJNA1233465 | 2050 | 1310 | 4.553529 | 59.6512299 | Ridgeia piscesae | 27915 | Annelida | Annelida | 117 | 1.16e-27 | NR | KAK2181635.1 | 27915 | g1123 | i0 | 53.5 | 0.290839694656489 | 127 | 59 | 29.1 | 0 | 161 | 541 | 3 | 129 | KAK2181635.1 hypothetical protein NP493_386g01017 [Ridgeia piscesae] | diamond | 381 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 32975107 | 32975107 | PRJNA1233465b_S_NODE_93074_length_282_cov_8.712446_g91389_i0 | PRJNA1233465 | 93074 | 282 | 8.712446 | 24.56909772 | root | 1 | Root_unresolved | Root_unresolved | 60.5 | 2.97e-8 | NR | ELU11326.1 | 283909 | g91389 | i0 | 55.6 | 3.79787234042553 | 54 | 24 | 57.4 | 0 | 25 | 186 | 122 | 175 | ELU11326.1 hypothetical protein CAPTEDRAFT_210610 [Capitella teleta] | diamond | 1071 | 60.8 | 0.995065789473684 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 32975358 | 32975358 | PRJNA1233465f_S_NODE_113034_length_227_cov_0.719101_g110754_i0 | PRJNA1233465 | 113034 | 227 | 0.719101 | 1.63235927 | Metazoa | 33208 | Annelida | Annelida | 65.5 | 2.82e-11 | NR | ABW23146.1 | 6344 | g110754 | i0 | 84.2 | 66.8193832599119 | 38 | 6 | 50.2 | 0 | 62 | 175 | 72 | 109 | ABW23146.1 ribosomal protein rps16 [Arenicola marina] | diamond | 15168 | 65.9 | 0.993930197268589 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina | ||
| 32984160 | 32984160 | PRJNA1233465d_S_NODE_2475_length_825_cov_3.324742_g1712_i0 | PRJNA1233465 | 2475 | 825 | 3.324742 | 27.4291215 | Ridgeia piscesae | 27915 | Annelida | Annelida | 90.5 | 1.1e-18 | NR | KAK2181635.1 | 27915 | g1712 | i0 | 53.1 | 0.356363636363636 | 98 | 46 | 35.6 | 0 | 496 | 789 | 3 | 100 | KAK2181635.1 hypothetical protein NP493_386g01017 [Ridgeia piscesae] | diamond | 294 | 90.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 33026051 | 33026051 | PRJNA1233465a_S_NODE_167612_length_187_cov_0.818841_g166338_i0 | PRJNA1233465 | 167612 | 187 | 0.818841 | 1.53123267 | Metazoa | 33208 | Annelida | Annelida | 60.5 | 1.49e-9 | NR | ABW23146.1 | 6344 | g166338 | i0 | 86.5 | 74.197860962566807 | 37 | 5 | 59.4 | 0 | 142 | 32 | 75 | 111 | ABW23146.1 ribosomal protein rps16 [Arenicola marina] | diamond | 13875 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina | ||
| 33035891 | 33035891 | PRJNA1233465e_S_NODE_3732_length_747_cov_2.607450_g2748_i0 | PRJNA1233465 | 3732 | 747 | 2.60745 | 19.4776515 | Ridgeia piscesae | 27915 | Annelida | Annelida | 117 | 1.79e-29 | NR | KAK2181635.1 | 27915 | g2748 | i0 | 53.5 | 0.51004016064257 | 127 | 59 | 51 | 0 | 174 | 554 | 3 | 129 | KAK2181635.1 hypothetical protein NP493_386g01017 [Ridgeia piscesae] | diamond | 381 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 33043138 | 33043138 | PRJNA1233465b_S_NODE_288708_length_178_cov_1.527132_g287023_i0 | PRJNA1233465 | 288708 | 178 | 1.527132 | 2.71829496 | Metazoa | 33208 | Annelida | Annelida | 42 | 0.0294 | NR | KAK2153328.1 | 53620 | g287023 | i0 | 55.3 | 11.4943820224719 | 38 | 17 | 64 | 0 | 148 | 35 | 118 | 155 | KAK2153328.1 hypothetical protein LSH36_300g01024 [Paralvinella palmiformis] | diamond | 2046 | 42.4 | 0.990566037735849 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 33070214 | 33070214 | PRJNA1233465f_S_NODE_10165_length_612_cov_3.285968_g8229_i0 | PRJNA1233465 | 10165 | 612 | 3.285968 | 20.11012416 | Ridgeia piscesae | 27915 | Annelida | Annelida | 77 | 3.26e-14 | NR | KAK2181635.1 | 27915 | g8229 | i0 | 55.8 | 0.377450980392157 | 77 | 34 | 37.7 | 0 | 382 | 612 | 3 | 79 | KAK2181635.1 hypothetical protein NP493_386g01017 [Ridgeia piscesae] | diamond | 231 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 33077254 | 33077254 | PRJNA1233465b_S_NODE_374509_length_161_cov_0.857143_g372824_i0 | PRJNA1233465 | 374509 | 161 | 0.857143 | 1.38000023 | Metazoa | 33208 | Annelida | Annelida | 66.6 | 4.12e-12 | NR | ABW23146.1 | 6344 | g372824 | i0 | 77.3 | 80.3478260869565 | 44 | 10 | 82 | 0 | 161 | 30 | 69 | 112 | ABW23146.1 ribosomal protein rps16 [Arenicola marina] | diamond | 12936 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina | ||
| 33094287 | 33094287 | PRJNA1233465a_S_NODE_54766_length_285_cov_4.635593_g53492_i0 | PRJNA1233465 | 54766 | 285 | 4.635593 | 13.21144005 | root | 1 | Root_unresolved | Root_unresolved | 60.5 | 2.97e-8 | NR | ELU11326.1 | 283909 | g53492 | i0 | 55.6 | 3.75789473684211 | 54 | 24 | 56.8 | 0 | 259 | 98 | 122 | 175 | ELU11326.1 hypothetical protein CAPTEDRAFT_210610 [Capitella teleta] | diamond | 1071 | 60.8 | 0.995065789473684 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 33104116 | 33104116 | PRJNA1233465e_S_NODE_2110_length_965_cov_4.636463_g1338_i0 | PRJNA1233465 | 2110 | 965 | 4.636463 | 44.74186795 | Ridgeia piscesae | 27915 | Annelida | Annelida | 108 | 2.61e-25 | NR | KAK2181635.1 | 27915 | g1338 | i0 | 52 | 0.394818652849741 | 127 | 61 | 39.5 | 0 | 558 | 938 | 3 | 129 | KAK2181635.1 hypothetical protein NP493_386g01017 [Ridgeia piscesae] | diamond | 381 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 33104714 | 33104714 | PRJNA1233465f_S_NODE_182078_length_185_cov_1.125000_g179798_i0 | PRJNA1233465 | 182078 | 185 | 1.125 | 2.08125 | Ridgeia piscesae | 27915 | Annelida | Annelida | 49.7 | 1.43e-5 | NR | KAK2186780.1 | 27915 | g179798 | i0 | 54.5 | 0.891891891891892 | 55 | 25 | 89.2 | 0 | 19 | 183 | 22 | 76 | KAK2186780.1 hypothetical protein NP493_189g03019 [Ridgeia piscesae] | diamond | 165 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 33120737 | 33120737 | PRJNA1233465d_S_NODE_6111_length_575_cov_3.098859_g5107_i0 | PRJNA1233465 | 6111 | 575 | 3.098859 | 17.81843925 | Ridgeia piscesae | 27915 | Annelida | Annelida | 117 | 3.29e-30 | NR | KAK2181635.1 | 27915 | g5107 | i0 | 53.5 | 0.662608695652174 | 127 | 59 | 66.3 | 0 | 138 | 518 | 3 | 129 | KAK2181635.1 hypothetical protein NP493_386g01017 [Ridgeia piscesae] | diamond | 381 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 33120927 | 33120927 | PRJNA1233465e_S_NODE_11007_length_486_cov_2.471396_g9752_i0 | PRJNA1233465 | 11007 | 486 | 2.471396 | 12.01098456 | Ridgeia piscesae | 27915 | Annelida | Annelida | 108 | 3.76e-27 | NR | KAK2181635.1 | 27915 | g9752 | i0 | 53.5 | 0.783950617283951 | 127 | 59 | 78.4 | 0 | 97 | 477 | 3 | 129 | KAK2181635.1 hypothetical protein NP493_386g01017 [Ridgeia piscesae] | diamond | 381 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 33145477 | 33145477 | PRJNA1233465a_S_NODE_87199_length_241_cov_3.984375_g85925_i0 | PRJNA1233465 | 87199 | 241 | 3.984375 | 9.60234375 | Metazoa | 33208 | Annelida | Annelida | 53.1 | 6.57e-6 | NR | XP_009027458.1 | 6412 | g85925 | i0 | 63.6 | 9.08713692946058 | 33 | 11 | 41.1 | 1 | 3 | 101 | 64 | 95 | XP_009027458.1 hypothetical protein HELRODRAFT_95625 [Helobdella robusta] | diamond | 2190 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 33171386 | 33171386 | PRJNA1233465b_S_NODE_306264_length_173_cov_1.645161_g304579_i0 | PRJNA1233465 | 306264 | 173 | 1.645161 | 2.84612853 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 45.8 | 0.0012 | NR | KAI0235282.1 | 104711 | g304579 | i0 | 40.5 | 2.27167630057803 | 42 | 25 | 72.8 | 0 | 152 | 27 | 241 | 282 | KAI0235282.1 hypothetical protein LSAT2_014203 [Lamellibrachia satsuma] | diamond | 393 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 33179831 | 33179831 | PRJNA1233465d_S_NODE_126152_length_167_cov_0.864407_g125041_i0 | PRJNA1233465 | 126152 | 167 | 0.864407 | 1.44355969 | Metazoa | 33208 | Annelida | Annelida | 53.9 | 1.01e-6 | NR | YP_009050473.1 | 27915 | g125041 | i0 | 61.8 | 15.0359281437126 | 34 | 13 | 61.1 | 0 | 64 | 165 | 164 | 197 | YP_009050473.1 cytochrome c oxidase subunit II [Ridgeia piscesae] | diamond | 2511 | 54.3 | 0.992633517495396 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae |
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);;