contig_metadata
20 rows where bioproject = "PRJNA1214993", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5433432 | 5433432 | PRJNA1214993_P_NODE_11265_length_328_cov_1.207843_g11079_i0 | PRJNA1214993 | 11265 | 328 | 1.207843 | 3.96172504 | Owenia fusiformis | 6347 | Annelida | Annelida | 130 | 7.28e-36 | NR | CAH1784699.1 | 6347 | g11079 | i0 | 68.1 | 1.66463414634146 | 91 | 29 | 83.2 | 0 | 51 | 323 | 1 | 91 | CAH1784699.1 unnamed protein product [Owenia fusiformis] | diamond | 546 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 5433469 | 5433469 | PRJNA1214993_P_NODE_17405_length_268_cov_2.235897_g17219_i0 | PRJNA1214993 | 17405 | 268 | 2.235897 | 5.99220396 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g17219 | i0 | 100 | 0.108208955223881 | 29 | 0 | 11 | 0 | 2 | 30 | 17840576 | 17840604 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 5433505 | 5433505 | PRJNA1214993_P_NODE_23245_length_247_cov_0.885057_g23059_i0 | PRJNA1214993 | 23245 | 247 | 0.885057 | 2.18609079 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 4.8e-4 | NTclustered | gi|2920003563|emb|OZ238869.1| | 1046305 | g23059 | i0 | 89.583 | 0.311740890688259 | 48 | 2 | 18 | 3 | 71 | 115 | 8635696 | 8635743 | Ailoscolex lacteospumosus genome assembly, chromosome: 10 | blastn | 77 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 6708041 | 6708041 | PRJNA1214993_P_NODE_10866_length_333_cov_2.446154_g10680_i0 | PRJNA1214993 | 10866 | 333 | 2.446154 | 8.14569282 | Annelida | 6340 | Annelida | Annelida | 159 | 9.33e-46 | NR | XP_009025699.1 | 6412 | g10680 | i0 | 73.5 | 10.1711711711712 | 102 | 27 | 91.9 | 0 | 309 | 4 | 1 | 102 | XP_009025699.1 hypothetical protein HELRODRAFT_107583 [Helobdella robusta] | diamond | 3387 | 160 | 0.99375 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 7983750 | 7983750 | PRJNA1214993_P_NODE_23007_length_247_cov_0.896552_g22821_i0 | PRJNA1214993 | 23007 | 247 | 0.896552 | 2.21448344 | Metazoa | 33208 | Annelida | Annelida | 141 | 6.4699999999999995e-37 | NR | XP_009026502.1 | 6412 | g22821 | i0 | 86.4 | 45.2550607287449 | 81 | 11 | 98.4 | 0 | 245 | 3 | 321 | 401 | XP_009026502.1 hypothetical protein HELRODRAFT_193557 [Helobdella robusta] | diamond | 11178 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 7983807 | 7983807 | PRJNA1214993_P_NODE_3647_length_555_cov_1.334025_g3464_i0 | PRJNA1214993 | 3647 | 555 | 1.334025 | 7.40383875 | Theromyzon tessulatum | 13286 | Annelida | Annelida | 204 | 2.6299999999999997e-61 | NR | AAN28680.1 | 13286 | g3464 | i0 | 57.9 | 1.06486486486486 | 197 | 68 | 100 | 8 | 555 | 1 | 155 | 348 | AAN28680.1 cathepsin L [Theromyzon tessulatum] | diamond | 591 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Theromyzon | Theromyzon tessulatum | |
| 20731809 | 20731809 | PRJNA1214993_P_NODE_3957_length_533_cov_4.754348_g3772_i0 | PRJNA1214993 | 3957 | 533 | 4.754348 | 25.34067484 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 0.001 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g3772 | i0 | 97.143 | 0.842401500938086 | 35 | 0 | 7 | 1 | 286 | 320 | 12290707 | 12290740 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 449 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 22007017 | 22007017 | PRJNA1214993_P_NODE_10818_length_334_cov_1.490421_g10632_i0 | PRJNA1214993 | 10818 | 334 | 1.490421 | 4.97800614 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 6.77e-4 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g10632 | i0 | 97.143 | 0.104790419161677 | 35 | 0 | 10 | 1 | 295 | 329 | 5221475 | 5221508 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 35 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 22007131 | 22007131 | PRJNA1214993_P_NODE_24218_length_245_cov_0.906977_g24032_i0 | PRJNA1214993 | 24218 | 245 | 0.906977 | 2.22209365 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|2920003508|emb|OZ238866.1| | 1046305 | g24032 | i0 | 100 | 0.228571428571429 | 28 | 0 | 11 | 0 | 93 | 120 | 28942752 | 28942725 | Ailoscolex lacteospumosus genome assembly, chromosome: 7 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 27704828 | 27704828 | PRJNA1214993_P_NODE_17044_length_271_cov_1.575758_g16858_i0 | PRJNA1214993 | 17044 | 271 | 1.575758 | 4.27030418 | Helobdella robusta | 6412 | Annelida | Annelida | 98.2 | 1.26e-22 | NR | XP_009018535.1 | 6412 | g16858 | i0 | 69.6 | 3.04428044280443 | 69 | 21 | 76.4 | 0 | 212 | 6 | 4 | 72 | XP_009018535.1 hypothetical protein HELRODRAFT_185645 [Helobdella robusta] | diamond | 825 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 27862248 | 27862248 | PRJNA1214993_P_NODE_23605_length_246_cov_0.901734_g23419_i0 | PRJNA1214993 | 23605 | 246 | 0.901734 | 2.21826564 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 97.8 | 3.88e-23 | NR | KAK2164162.1 | 53620 | g23419 | i0 | 83.1 | 3.95121951219512 | 59 | 10 | 72 | 0 | 2 | 178 | 148 | 206 | KAK2164162.1 hypothetical protein LSH36_68g12029 [Paralvinella palmiformis] | diamond | 972 | 97.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 28196762 | 28196762 | PRJNA1214993_P_NODE_24686_length_244_cov_0.912281_g24500_i0 | PRJNA1214993 | 24686 | 244 | 0.912281 | 2.22596564 | Metazoa | 33208 | Annelida | Annelida | 92 | 1.66e-19 | NR | KAK2183549.1 | 27915 | g24500 | i0 | 50 | 1.90573770491803 | 78 | 39 | 95.9 | 0 | 239 | 6 | 176 | 253 | KAK2183549.1 hypothetical protein NP493_307g02082 [Ridgeia piscesae] | diamond | 465 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 29977826 | 29977826 | PRJNA1214993_P_NODE_23131_length_247_cov_0.885057_g22945_i0 | PRJNA1214993 | 23131 | 247 | 0.885057 | 2.18609079 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 51.2 | 3.88e-5 | NR | KAI0223900.1 | 104711 | g22945 | i0 | 34.1 | 1.94331983805668 | 82 | 53 | 98.4 | 1 | 1 | 243 | 208 | 289 | KAI0223900.1 hypothetical protein LSAT2_025012 [Lamellibrachia satsuma] | diamond | 480 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 30389025 | 30389025 | PRJNA1214993_P_NODE_12393_length_313_cov_1.541667_g12207_i0 | PRJNA1214993 | 12393 | 313 | 1.541667 | 4.82541771 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 92.4 | 4.6e-21 | NR | KAK2168654.1 | 53620 | g12207 | i0 | 53.2 | 1.77316293929712 | 94 | 44 | 90.1 | 0 | 284 | 3 | 18 | 111 | KAK2168654.1 hypothetical protein LSH36_15g12056 [Paralvinella palmiformis] | diamond | 555 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 30483464 | 30483464 | PRJNA1214993_P_NODE_25573_length_243_cov_0.905882_g25387_i0 | PRJNA1214993 | 25573 | 243 | 0.905882 | 2.20129326 | Capitella teleta | 283909 | Annelida | Annelida | 45.8 | 0.00295 | NR | ELT94983.1 | 283909 | g25387 | i0 | 43.8 | 0.790123456790123 | 64 | 34 | 77.8 | 2 | 212 | 24 | 196 | 258 | ELT94983.1 hypothetical protein CAPTEDRAFT_20769 [Capitella teleta] | diamond | 192 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 30704506 | 30704506 | PRJNA1214993_P_NODE_23154_length_247_cov_0.885057_g22968_i0 | PRJNA1214993 | 23154 | 247 | 0.885057 | 2.18609079 | Helobdella robusta | 6412 | Annelida | Annelida | 153 | 1.18e-41 | NR | XP_009028259.1 | 6412 | g22968 | i0 | 82.9 | 4.97975708502024 | 82 | 14 | 99.6 | 0 | 247 | 2 | 295 | 376 | XP_009028259.1 hypothetical protein HELRODRAFT_103347 [Helobdella robusta] | diamond | 1230 | 153 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 31115041 | 31115041 | PRJNA1214993_P_NODE_11415_length_326_cov_1.150198_g11229_i0 | PRJNA1214993 | 11415 | 326 | 1.150198 | 3.74964548 | Helobdella robusta | 6412 | Annelida | Annelida | 52.8 | 2.53e-6 | NR | XP_009025136.1 | 6412 | g11229 | i0 | 33.7 | 0.901840490797546 | 98 | 58 | 86.5 | 4 | 22 | 303 | 1 | 95 | XP_009025136.1 hypothetical protein HELRODRAFT_67787 [Helobdella robusta] | diamond | 294 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 32082924 | 32082924 | PRJNA1214993_P_NODE_14398_length_291_cov_1.431193_g14212_i0 | PRJNA1214993 | 14398 | 291 | 1.431193 | 4.16477163 | Metazoa | 33208 | Annelida | Annelida | 70.1 | 6.24e-12 | NR | XP_009026674.1 | 6412 | g14212 | i0 | 59.6 | 6.30927835051546 | 47 | 19 | 48.5 | 0 | 143 | 3 | 39 | 85 | XP_009026674.1 hypothetical protein HELRODRAFT_179618 [Helobdella robusta] | diamond | 1836 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 32273074 | 32273074 | PRJNA1214993_P_NODE_7178_length_403_cov_0.945455_g6993_i0 | PRJNA1214993 | 7178 | 403 | 0.945455 | 3.81018365 | Metazoa | 33208 | Annelida | Annelida | 164 | 6.489999999999998e-48 | NR | CAH1772980.1 | 6347 | g6993 | i0 | 61.7 | 9.26799007444169 | 128 | 49 | 95.3 | 0 | 19 | 402 | 33 | 160 | CAH1772980.1 unnamed protein product [Owenia fusiformis] | diamond | 3735 | 164 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32809515 | 32809515 | PRJNA1214993_P_NODE_15720_length_281_cov_1.500000_g15534_i0 | PRJNA1214993 | 15720 | 281 | 1.5 | 4.215 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 117 | 1.4899999999999998e-30 | NR | XP_009018646.1 | 6412 | g15534 | i0 | 65.8 | 10.9430604982206 | 79 | 27 | 84.3 | 0 | 45 | 281 | 12 | 90 | XP_009018646.1 hypothetical protein HELRODRAFT_185659 [Helobdella robusta] | diamond | 3075 | 117 | 1 | 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);;