contig_metadata
24 rows where bioproject = "PRJNA1248424", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6730136 | 6730136 | PRJNA1248424_P_NODE_29306_length_528_cov_1.292308_g23275_i0 | PRJNA1248424 | 29306 | 528 | 1.292308 | 6.82338624 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 0.001 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g23275 | i0 | 94.595 | 0.125 | 37 | 2 | 7 | 0 | 178 | 214 | 10598735 | 10598771 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 66 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 6730485 | 6730485 | PRJNA1248424_P_NODE_45286_length_335_cov_1.187023_g39222_i0 | PRJNA1248424 | 45286 | 335 | 1.187023 | 3.97652705 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.032 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g39222 | i0 | 92.308 | 0.116417910447761 | 39 | 0 | 11 | 2 | 65 | 102 | 7036270 | 7036234 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 39 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 16929870 | 16929870 | PRJNA1248424_P_NODE_41514_length_361_cov_1.326389_g35452_i0 | PRJNA1248424 | 41514 | 361 | 1.326389 | 4.78826429 | Hirudo verbana | 311461 | Annelida | Annelida | 62.1 | 5.69e-5 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g35452 | i0 | 100 | 5.23268698060942 | 33 | 0 | 9 | 0 | 261 | 293 | 1426663 | 1426631 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 1889 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 16930015 | 16930015 | PRJNA1248424_P_NODE_49494_length_312_cov_1.874477_g43426_i0 | PRJNA1248424 | 49494 | 312 | 1.874477 | 5.84836824 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.008 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g43426 | i0 | 100 | 0.362179487179487 | 29 | 0 | 9 | 0 | 177 | 205 | 9718187 | 9718159 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 113 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 20753863 | 20753863 | PRJNA1248424_P_NODE_27457_length_575_cov_1.171315_g21459_i0 | PRJNA1248424 | 27457 | 575 | 1.171315 | 6.73506125 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 3.39e-4 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g21459 | i0 | 93.023 | 1.1304347826087 | 43 | 0 | 8 | 2 | 95 | 137 | 18517691 | 18517730 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 650 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 23304935 | 23304935 | PRJNA1248424_P_NODE_40359_length_370_cov_1.861953_g34298_i0 | PRJNA1248424 | 40359 | 370 | 1.861953 | 6.8892261 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.01 | NTclustered | gi|2920003371|emb|OZ238862.1| | 1046305 | g34298 | i0 | 96.875 | 0.0864864864864865 | 32 | 1 | 9 | 0 | 135 | 166 | 34030472 | 34030503 | Ailoscolex lacteospumosus genome assembly, chromosome: 3 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 23305556 | 23305556 | PRJNA1248424_P_NODE_71299_length_249_cov_0.875000_g65230_i0 | PRJNA1248424 | 71299 | 249 | 0.875 | 2.17875 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 4.84e-4 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g65230 | i0 | 97.059 | 0.253012048192771 | 34 | 1 | 14 | 0 | 193 | 226 | 35867349 | 35867316 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 63 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 26902016 | 26902016 | PRJNA1248424_P_NODE_32661_length_463_cov_1.720513_g26607_i0 | PRJNA1248424 | 32661 | 463 | 1.720513 | 7.96597519 | Metazoa | 33208 | Annelida | Annelida | 62.8 | 3.72e-8 | NR | KAK2174841.1 | 27915 | g26607 | i0 | 28.7 | 6.95896328293736 | 108 | 74 | 68 | 2 | 424 | 110 | 244 | 351 | KAK2174841.1 hypothetical protein NP493_774g00007 [Ridgeia piscesae] | diamond | 3222 | 63.2 | 0.993670886075949 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 26946956 | 26946956 | PRJNA1248424_P_NODE_18322_length_975_cov_2.171840_g13115_i0 | PRJNA1248424 | 18322 | 975 | 2.17184 | 21.17544 | Helobdella robusta | 6412 | Annelida | Annelida | 185 | 7.49e-49 | NR | XP_009015400.1 | 6412 | g13115 | i0 | 68.4 | 1.40307692307692 | 152 | 44 | 46.8 | 2 | 459 | 4 | 1 | 148 | XP_009015400.1 hypothetical protein HELRODRAFT_160147 [Helobdella robusta] | diamond | 1368 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 27660517 | 27660517 | PRJNA1248424_P_NODE_3224_length_3334_cov_10.761423_g2421_i0 | PRJNA1248424 | 3224 | 3334 | 10.761423 | 358.78584282 | Metazoa | 33208 | Annelida | Annelida | 409 | 2.6499999999999998e-118 | NR | CAH1783101.1 | 6347 | g2421 | i0 | 29 | 3.97810437912418 | 1101 | 715 | 94.6 | 19 | 1 | 3153 | 302 | 1385 | CAH1783101.1 unnamed protein product [Owenia fusiformis] | diamond | 13263 | 409 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28115780 | 28115780 | PRJNA1248424_P_NODE_67705_length_254_cov_1.850829_g61636_i0 | PRJNA1248424 | 67705 | 254 | 1.850829 | 4.70110566 | Helobdella robusta | 6412 | Annelida | Annelida | 107 | 8.58e-28 | NR | XP_009024807.1 | 6412 | g61636 | i0 | 67.1 | 0.826771653543307 | 70 | 23 | 82.7 | 0 | 2 | 211 | 41 | 110 | XP_009024807.1 hypothetical protein HELRODRAFT_178463 [Helobdella robusta] | diamond | 210 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28178775 | 28178775 | PRJNA1248424_P_NODE_33266_length_453_cov_1.497368_g27211_i0 | PRJNA1248424 | 33266 | 453 | 1.497368 | 6.78307704 | Ridgeia piscesae | 27915 | Annelida | Annelida | 62 | 2.05e-8 | NR | KAK2164893.1 | 27915 | g27211 | i0 | 28.9 | 0.642384105960265 | 97 | 69 | 64.2 | 0 | 335 | 45 | 114 | 210 | KAK2164893.1 hypothetical protein NP493_1386g00033 [Ridgeia piscesae] | diamond | 291 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 28291667 | 28291667 | PRJNA1248424_P_NODE_26926_length_588_cov_2.662136_g20935_i0 | PRJNA1248424 | 26926 | 588 | 2.662136 | 15.65335968 | Metazoa | 33208 | Annelida | Annelida | 89.7 | 6.71e-17 | NR | XP_009029716.1 | 6412 | g20935 | i0 | 33.8 | 12.1989795918367 | 157 | 97 | 79.1 | 5 | 37 | 501 | 1519 | 1670 | XP_009029716.1 hypothetical protein HELRODRAFT_194356 [Helobdella robusta] | diamond | 7173 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28526530 | 28526530 | PRJNA1248424_P_NODE_48147_length_320_cov_1.789474_g42080_i0 | PRJNA1248424 | 48147 | 320 | 1.789474 | 5.7263168 | Capitella teleta | 283909 | Annelida | Annelida | 49.3 | 2.38e-5 | NR | ELT95740.1 | 283909 | g42080 | i0 | 56.8 | 0.825 | 44 | 18 | 40.3 | 1 | 80 | 208 | 7 | 50 | ELT95740.1 hypothetical protein CAPTEDRAFT_140410 [Capitella teleta] | diamond | 264 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 29270429 | 29270429 | PRJNA1248424_P_NODE_72909_length_248_cov_0.874286_g66840_i0 | PRJNA1248424 | 72909 | 248 | 0.874286 | 2.16822928 | Metazoa | 33208 | Annelida | Annelida | 51.2 | 3.8e-5 | NR | CAH1781278.1 | 6347 | g66840 | i0 | 42 | 4.39112903225806 | 50 | 29 | 60.5 | 0 | 193 | 44 | 194 | 243 | CAH1781278.1 unnamed protein product [Owenia fusiformis] | diamond | 1089 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29757615 | 29757615 | PRJNA1248424_P_NODE_73231_length_247_cov_1.241379_g67162_i0 | PRJNA1248424 | 73231 | 247 | 1.241379 | 3.06620613 | Capitella teleta | 283909 | Annelida | Annelida | 55.5 | 6.52e-7 | NR | ELU08086.1 | 283909 | g67162 | i0 | 35.1 | 1.87044534412955 | 77 | 50 | 93.5 | 0 | 246 | 16 | 129 | 205 | ELU08086.1 hypothetical protein CAPTEDRAFT_108322, partial [Capitella teleta] | diamond | 462 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 29947274 | 29947274 | PRJNA1248424_P_NODE_21711_length_783_cov_1.374648_g16010_i0 | PRJNA1248424 | 21711 | 783 | 1.374648 | 10.76349384 | Helobdella robusta | 6412 | Annelida | Annelida | 209 | 2.4299999999999997e-61 | NR | XP_009011430.1 | 6412 | g16010 | i0 | 46.9 | 2.63984674329502 | 226 | 114 | 86.2 | 4 | 782 | 108 | 159 | 379 | XP_009011430.1 hypothetical protein HELRODRAFT_183591 [Helobdella robusta] | diamond | 2067 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 29947289 | 29947289 | PRJNA1248424_P_NODE_37791_length_395_cov_1.074534_g31734_i0 | PRJNA1248424 | 37791 | 395 | 1.074534 | 4.2444093 | Eurythoe complanata | 167815 | Annelida | Annelida | 77.4 | 1.95e-15 | NR | ABW23238.1 | 167815 | g31734 | i0 | 54.3 | 3.18227848101266 | 70 | 32 | 53.2 | 0 | 55 | 264 | 1 | 70 | ABW23238.1 ribosomal protein rplp2 [Eurythoe complanata] | diamond | 1257 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Eunicida | Amphinomidae | Eurythoe | Eurythoe complanata | |
| 29947302 | 29947302 | PRJNA1248424_P_NODE_68251_length_253_cov_1.016667_g62182_i0 | PRJNA1248424 | 68251 | 253 | 1.016667 | 2.57216751 | Nephasoma pellucidum | 360536 | Annelida | Annelida | 66.2 | 4.41e-11 | NR | CCD27765.1 | 360536 | g62182 | i0 | 75.6 | 0.972332015810277 | 41 | 10 | 48.6 | 0 | 129 | 7 | 87 | 127 | CCD27765.1 ribosomal protein l13, partial [Nephasoma pellucidum] | diamond | 246 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Golfingiida | Golfingiidae | Nephasoma | Nephasoma pellucidum | |
| 30958400 | 30958400 | PRJNA1248424_P_NODE_34194_length_439_cov_1.855191_g28139_i0 | PRJNA1248424 | 34194 | 439 | 1.855191 | 8.14428849 | Helobdella robusta | 6412 | Annelida | Annelida | 62.4 | 9.96e-9 | NR | XP_009017506.1 | 6412 | g28139 | i0 | 64.6 | 0.328018223234624 | 48 | 17 | 32.8 | 0 | 281 | 424 | 2 | 49 | XP_009017506.1 hypothetical protein HELRODRAFT_172593 [Helobdella robusta] | diamond | 144 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 31387476 | 31387476 | PRJNA1248424_P_NODE_82096_length_200_cov_2.330709_g76026_i0 | PRJNA1248424 | 82096 | 200 | 2.330709 | 4.661418 | Metazoa | 33208 | Annelida | Annelida | 53.1 | 1.4e-6 | NR | CAH1776373.1 | 6347 | g76026 | i0 | 66.7 | 5.67 | 30 | 10 | 45 | 0 | 199 | 110 | 110 | 139 | CAH1776373.1 unnamed protein product [Owenia fusiformis] | diamond | 1134 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31527444 | 31527444 | PRJNA1248424_P_NODE_56796_length_284_cov_1.137441_g50728_i0 | PRJNA1248424 | 56796 | 284 | 1.137441 | 3.23033244 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 48.1 | 7.78e-4 | NR | KAI0223599.1 | 104711 | g50728 | i0 | 45.7 | 0.485915492957746 | 46 | 25 | 48.6 | 0 | 46 | 183 | 432 | 477 | KAI0223599.1 Cubilin [Lamellibrachia satsuma] | diamond | 138 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 31875129 | 31875129 | PRJNA1248424_P_NODE_58897_length_278_cov_2.263415_g52829_i0 | PRJNA1248424 | 58897 | 278 | 2.263415 | 6.2922937 | Helobdella robusta | 6412 | Annelida | Annelida | 42.7 | 0.0481 | NR | XP_009013696.1 | 6412 | g52829 | i0 | 41.5 | 0.442446043165468 | 41 | 24 | 44.2 | 0 | 248 | 126 | 196 | 236 | XP_009013696.1 hypothetical protein HELRODRAFT_169610 [Helobdella robusta] | diamond | 123 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 32571577 | 32571577 | PRJNA1248424_P_NODE_35639_length_419_cov_2.965318_g29583_i0 | PRJNA1248424 | 35639 | 419 | 2.965318 | 12.42468242 | Ridgeia piscesae | 27915 | Annelida | Annelida | 65.1 | 3.65e-9 | NR | KAK2168343.1 | 27915 | g29583 | i0 | 50 | 11.9498806682578 | 56 | 28 | 40.1 | 0 | 359 | 192 | 354 | 409 | KAK2168343.1 hypothetical protein NP493_1234g00008 [Ridgeia piscesae] | diamond | 5007 | 65.1 | 1 | 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);;