contig_metadata
23 rows where bioproject = "PRJNA662254" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8814913 | 8814913 | PRJNA662254_P_NODE_28967_length_308_cov_1.310638_g28316_i0 | PRJNA662254 | 28967 | 308 | 1.310638 | 4.03676504 | Helobdella robusta | 6412 | Annelida | Annelida | 164 | 5.34e-45 | NR | XP_009018982.1 | 6412 | g28316 | i0 | 77.5 | 0.993506493506494 | 102 | 23 | 99.4 | 0 | 1 | 306 | 497 | 598 | XP_009018982.1 hypothetical protein HELRODRAFT_192148 [Helobdella robusta] | diamond | 306 | 164 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 10832368 | 10832368 | PRJNA662254_P_NODE_22289_length_348_cov_1.672727_g21638_i0 | PRJNA662254 | 22289 | 348 | 1.672727 | 5.82108996 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.009 | NTclustered | gi|2918369718|emb|OZ237791.1| | 311461 | g21638 | i0 | 92.105 | 1.2183908045977 | 38 | 3 | 11 | 0 | 303 | 340 | 956879 | 956916 | Hirudo verbana genome assembly, chromosome: 13 | blastn | 424 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 19755374 | 19755374 | PRJNA662254_P_NODE_8916_length_561_cov_3.116803_g8276_i0 | PRJNA662254 | 8916 | 561 | 3.116803 | 17.48526483 | Metazoa | 33208 | Annelida | Annelida | 194 | 6.22e-58 | NR | CAH1793798.1 | 6347 | g8276 | i0 | 58.7 | 11.8395721925134 | 179 | 66 | 95.2 | 4 | 561 | 28 | 86 | 257 | CAH1793798.1 unnamed protein product [Owenia fusiformis] | diamond | 6642 | 194 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 23580919 | 23580919 | PRJNA662254_P_NODE_32859_length_290_cov_1.336406_g32208_i0 | PRJNA662254 | 32859 | 290 | 1.336406 | 3.8755774 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g32208 | i0 | 100 | 0.1 | 29 | 0 | 10 | 0 | 153 | 181 | 17840576 | 17840604 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 23580931 | 23580931 | PRJNA662254_P_NODE_35819_length_280_cov_0.772947_g35168_i0 | PRJNA662254 | 35819 | 280 | 0.772947 | 2.1642516 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 1.54e-4 | NTclustered | gi|2920003371|emb|OZ238862.1| | 1046305 | g35168 | i0 | 97.143 | 0.889285714285714 | 35 | 1 | 13 | 0 | 62 | 96 | 31382065 | 31382099 | Ailoscolex lacteospumosus genome assembly, chromosome: 3 | blastn | 249 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 23581020 | 23581020 | PRJNA662254_P_NODE_53739_length_247_cov_0.885057_g53088_i0 | PRJNA662254 | 53739 | 247 | 0.885057 | 2.18609079 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 130 | 4.03e-33 | NR | XP_009022681.1 | 6412 | g53088 | i0 | 80.5 | 58.748987854251 | 82 | 16 | 99.6 | 0 | 246 | 1 | 308 | 389 | XP_009022681.1 hypothetical protein HELRODRAFT_155881 [Helobdella robusta] | diamond | 14511 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 24854604 | 24854604 | PRJNA662254_P_NODE_49220_length_249_cov_0.875000_g48569_i0 | PRJNA662254 | 49220 | 249 | 0.875 | 2.17875 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2920003593|emb|OZ238871.1| | 1046305 | g48569 | i0 | 100 | 0.232931726907631 | 30 | 0 | 12 | 0 | 211 | 240 | 22622290 | 22622261 | Ailoscolex lacteospumosus genome assembly, chromosome: 12 | blastn | 58 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 26682006 | 26682006 | PRJNA662254_P_NODE_45661_length_251_cov_0.865169_g45010_i0 | PRJNA662254 | 45661 | 251 | 0.865169 | 2.17157419 | Metazoa | 33208 | Annelida | Annelida | 70.5 | 1.98e-13 | NR | AHA44496.1 | 260746 | g45010 | i0 | 48.1 | 6.37051792828685 | 77 | 40 | 92 | 0 | 10 | 240 | 34 | 110 | AHA44496.1 40S ribosomal-like protein [Pectinaria gouldii] | diamond | 1599 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Pectinariidae | Pectinaria | Pectinaria gouldii | |
| 26986416 | 26986416 | PRJNA662254_P_NODE_8202_length_588_cov_2.267961_g7572_i0 | PRJNA662254 | 8202 | 588 | 2.267961 | 13.33561068 | Owenia fusiformis | 6347 | Annelida | Annelida | 155 | 1.3699999999999999e-42 | NR | CAH1798522.1 | 6347 | g7572 | i0 | 48.3 | 5.75510204081633 | 174 | 81 | 84.7 | 5 | 498 | 1 | 51 | 223 | CAH1798522.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 3384 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27239385 | 27239385 | PRJNA662254_P_NODE_51143_length_248_cov_0.880000_g50492_i0 | PRJNA662254 | 51143 | 248 | 0.88 | 2.1824 | Ridgeia piscesae | 27915 | Annelida | Annelida | 73.6 | 5.67e-13 | NR | KAK2180386.1 | 27915 | g50492 | i0 | 44.3 | 4.70564516129032 | 79 | 44 | 95.6 | 0 | 246 | 10 | 1440 | 1518 | KAK2180386.1 hypothetical protein NP493_445g02003 [Ridgeia piscesae] | diamond | 1167 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 27776535 | 27776535 | PRJNA662254_P_NODE_20824_length_359_cov_8.041958_g20173_i0 | PRJNA662254 | 20824 | 359 | 8.041958 | 28.87062922 | Owenia fusiformis | 6347 | Annelida | Annelida | 83.6 | 7.1e-18 | NR | CAH1781962.1 | 6347 | g20173 | i0 | 35.6 | 1.98050139275766 | 118 | 75 | 97.8 | 1 | 353 | 3 | 1 | 118 | CAH1781962.1 unnamed protein product [Owenia fusiformis] | diamond | 711 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27997516 | 27997516 | PRJNA662254_P_NODE_10885_length_502_cov_1.291375_g10235_i0 | PRJNA662254 | 10885 | 502 | 1.291375 | 6.4827025 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 57 | 4.94e-6 | NR | CAD5125039.1 | 2664684 | g10235 | i0 | 30.8 | 1.04581673306773 | 91 | 58 | 51.4 | 2 | 474 | 217 | 23 | 113 | CAD5125039.1 DgyrCDS13283 [Dimorphilus gyrociliatus] | diamond | 525 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 28041222 | 28041222 | PRJNA662254_P_NODE_56765_length_245_cov_0.895349_g56114_i0 | PRJNA662254 | 56765 | 245 | 0.895349 | 2.19360505 | Metazoa | 33208 | Annelida | Annelida | 99 | 6.43e-22 | NR | CAH1781656.1 | 6347 | g56114 | i0 | 96 | 34.2734693877551 | 50 | 2 | 61.2 | 0 | 3 | 152 | 1476 | 1525 | CAH1781656.1 unnamed protein product [Owenia fusiformis] | diamond | 8397 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28388389 | 28388389 | PRJNA662254_P_NODE_56086_length_246_cov_0.890173_g55435_i0 | PRJNA662254 | 56086 | 246 | 0.890173 | 2.18982558 | Sabellida | 6362 | Annelida | Annelida | 49.3 | 1.77e-4 | NR | KAI0240437.1 | 104711 | g55435 | i0 | 43.5 | 1.1219512195122 | 46 | 26 | 56.1 | 0 | 1 | 138 | 141 | 186 | KAI0240437.1 hypothetical protein LSAT2_008834 [Lamellibrachia satsuma] | diamond | 276 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 28471135 | 28471135 | PRJNA662254_P_NODE_42846_length_256_cov_1.524590_g42195_i0 | PRJNA662254 | 42846 | 256 | 1.52459 | 3.9029504 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 48.9 | 2.94e-4 | NR | CAD5124627.1 | 2664684 | g42195 | i0 | 56.8 | 0.43359375 | 37 | 16 | 43.4 | 0 | 113 | 3 | 1113 | 1149 | CAD5124627.1 DgyrCDS12896 [Dimorphilus gyrociliatus] | diamond | 111 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 28641234 | 28641234 | PRJNA662254_P_NODE_7187_length_633_cov_1.650000_g6562_i0 | PRJNA662254 | 7187 | 633 | 1.65 | 10.4445 | Metazoa | 33208 | Annelida | Annelida | 58.2 | 4.71e-6 | NR | KAK2158550.1 | 53620 | g6562 | i0 | 36.7 | 2.96208530805687 | 79 | 50 | 37.4 | 0 | 580 | 344 | 8 | 86 | KAK2158550.1 hypothetical protein LSH36_167g01033 [Paralvinella palmiformis] | diamond | 1875 | 58.5 | 0.994871794871795 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 28692232 | 28692232 | PRJNA662254_P_NODE_3527_length_941_cov_2.180876_g3042_i0 | PRJNA662254 | 3527 | 941 | 2.180876 | 20.52204316 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 304 | 1.0200000000000001e-91 | NR | CAD5115251.1 | 2664684 | g3042 | i0 | 47.5 | 6.02869287991498 | 318 | 159 | 98.8 | 4 | 2 | 931 | 73 | 390 | CAD5115251.1 DgyrCDS4245 [Dimorphilus gyrociliatus] | diamond | 5673 | 304 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 28912779 | 28912779 | PRJNA662254_P_NODE_32908_length_290_cov_1.124424_g32257_i0 | PRJNA662254 | 32908 | 290 | 1.124424 | 3.2608296 | Capitella teleta | 283909 | Annelida | Annelida | 97.8 | 7.51e-22 | NR | ELT91003.1 | 283909 | g32257 | i0 | 59.7 | 0.744827586206897 | 72 | 25 | 70.3 | 1 | 86 | 289 | 183 | 254 | ELT91003.1 hypothetical protein CAPTEDRAFT_24523, partial [Capitella teleta] | diamond | 216 | 97.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 28976305 | 28976305 | PRJNA662254_P_NODE_44848_length_251_cov_0.865169_g44197_i0 | PRJNA662254 | 44848 | 251 | 0.865169 | 2.17157419 | Helobdella robusta | 6412 | Annelida | Annelida | 86.7 | 1.46e-17 | NR | XP_009026946.1 | 6412 | g44197 | i0 | 56.1 | 5.8804780876494 | 82 | 36 | 98 | 0 | 246 | 1 | 88 | 169 | XP_009026946.1 hypothetical protein HELRODRAFT_102867 [Helobdella robusta] | diamond | 1476 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 29260182 | 29260182 | PRJNA662254_P_NODE_64789_length_241_cov_0.916667_g64138_i0 | PRJNA662254 | 64789 | 241 | 0.916667 | 2.20916747 | Helobdella robusta | 6412 | Annelida | Annelida | 58.5 | 9.33e-8 | NR | XP_009030617.1 | 6412 | g64138 | i0 | 77.4 | 1.9045643153527 | 31 | 7 | 38.6 | 0 | 147 | 239 | 220 | 250 | XP_009030617.1 hypothetical protein HELRODRAFT_108545 [Helobdella robusta] | diamond | 459 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 31408736 | 31408736 | PRJNA662254_P_NODE_57936_length_245_cov_0.895349_g57285_i0 | PRJNA662254 | 57936 | 245 | 0.895349 | 2.19360505 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 74.7 | 8.86e-14 | NR | KAI0213553.1 | 104711 | g57285 | i0 | 73.2 | 0.502040816326531 | 41 | 11 | 50.2 | 0 | 227 | 105 | 15 | 55 | KAI0213553.1 Cytochrome P450 10 [Lamellibrachia satsuma] | diamond | 123 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 32547849 | 32547849 | PRJNA662254_P_NODE_64939_length_241_cov_0.916667_g64288_i0 | PRJNA662254 | 64939 | 241 | 0.916667 | 2.20916747 | Capitella teleta | 283909 | Annelida | Annelida | 53.9 | 3.79e-6 | NR | ELT97879.1 | 283909 | g64288 | i0 | 42.2 | 1.03319502074689 | 83 | 35 | 87.1 | 2 | 3 | 212 | 120 | 202 | ELT97879.1 hypothetical protein CAPTEDRAFT_219816 [Capitella teleta] | diamond | 249 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 32736734 | 32736734 | PRJNA662254_P_NODE_44080_length_252_cov_1.525140_g43429_i0 | PRJNA662254 | 44080 | 252 | 1.52514 | 3.8433528 | Owenia fusiformis | 6347 | Annelida | Annelida | 52.8 | 1.12e-5 | NR | CAH1777247.1 | 6347 | g43429 | i0 | 43.7 | 0.845238095238095 | 71 | 39 | 84.5 | 1 | 3 | 215 | 11 | 80 | CAH1777247.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 213 | 52.8 | 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);;