contig_metadata
16 rows where bioproject = "PRJNA533623" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 505911 | 505911 | PRJNA533623_P_NODE_11861_length_683_cov_13.802251_g10240_i0 | PRJNA533623 | 11861 | 683 | 13.802251 | 94.26937433 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.019 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g10240 | i0 | 96.875 | 0.0468521229868228 | 32 | 1 | 5 | 0 | 305 | 336 | 7746332 | 7746301 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 5610609 | 5610609 | PRJNA533623_P_NODE_54365_length_276_cov_1.190698_g52586_i0 | PRJNA533623 | 54365 | 276 | 1.190698 | 3.28632648 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2920003608|emb|OZ238872.1| | 1046305 | g52586 | i0 | 100 | 0.105072463768116 | 29 | 0 | 11 | 0 | 187 | 215 | 1322101 | 1322073 | Ailoscolex lacteospumosus genome assembly, chromosome: 13 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 6883877 | 6883877 | PRJNA533623_P_NODE_28566_length_426_cov_50.816438_g26796_i0 | PRJNA533623 | 28566 | 426 | 50.816438 | 216.47802588 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.003 | NTclustered | gi|2920003456|emb|OZ238864.1| | 1046305 | g26796 | i0 | 100 | 0.0704225352112676 | 30 | 0 | 7 | 0 | 5 | 34 | 26558371 | 26558342 | Ailoscolex lacteospumosus genome assembly, chromosome: 5 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 6884050 | 6884050 | PRJNA533623_P_NODE_35706_length_371_cov_3.648387_g33934_i0 | PRJNA533623 | 35706 | 371 | 3.648387 | 13.53551577 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.035 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g33934 | i0 | 100 | 0.30188679245283 | 28 | 0 | 8 | 0 | 289 | 316 | 14886920 | 14886947 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 112 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 8158976 | 8158976 | PRJNA533623_P_NODE_24527_length_466_cov_8.150617_g22765_i0 | PRJNA533623 | 24527 | 466 | 8.150617 | 37.98187522 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 241 | 4.87e-79 | NR | KAI0235858.1 | 104711 | g22765 | i0 | 74.1 | 33.2188841201717 | 143 | 37 | 92.1 | 0 | 24 | 452 | 34 | 176 | KAI0235858.1 Peptidyl-prolyl cis-trans isomerase H [Lamellibrachia satsuma] | diamond | 15480 | 242 | 0.995867768595041 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 13259870 | 13259870 | PRJNA533623_P_NODE_20931_length_509_cov_6.627232_g19184_i0 | PRJNA533623 | 20931 | 509 | 6.627232 | 33.73261088 | Eisenoides carolinensis | 1046328 | Annelida | Annelida | 651 | 0 | NTclustered | gi|341833248|gb|HQ728939.1| | 1046328 | g19184 | i0 | 92.747 | 102.306483300589 | 455 | 18 | 89 | 6 | 10 | 462 | 2270 | 1829 | Eisenoides carolinensis 28S large subunit ribosomal RNA gene, partial sequence | blastn | 52074 | 651 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Lumbricidae | Eisenoides | Eisenoides carolinensis | |
| 22182617 | 22182617 | PRJNA533623_P_NODE_15078_length_607_cov_5.862637_g13376_i0 | PRJNA533623 | 15078 | 607 | 5.862637 | 35.58620659 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.005 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g13376 | i0 | 100 | 0.0494233937397035 | 30 | 0 | 5 | 0 | 538 | 567 | 17463074 | 17463045 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 27203993 | 27203993 | PRJNA533623_P_NODE_42962_length_328_cov_8.149813_g41188_i0 | PRJNA533623 | 42962 | 328 | 8.149813 | 26.73138664 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 44.7 | 0.0215 | NR | KAK2142483.1 | 53620 | g41188 | i0 | 71.4 | 0.25609756097561 | 28 | 8 | 25.6 | 0 | 218 | 135 | 2545 | 2572 | KAK2142483.1 hypothetical protein LSH36_950g00056 [Paralvinella palmiformis] | diamond | 84 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 27330770 | 27330770 | PRJNA533623_P_NODE_7183_length_863_cov_11.082294_g5796_i0 | PRJNA533623 | 7183 | 863 | 11.082294 | 95.64019722 | Owenia fusiformis | 6347 | Annelida | Annelida | 144 | 1.1699999999999999e-34 | NR | CAH1792718.1 | 6347 | g5796 | i0 | 56.7 | 15.2016222479722 | 120 | 49 | 41.7 | 1 | 456 | 97 | 211 | 327 | CAH1792718.1 unnamed protein product [Owenia fusiformis] | diamond | 13119 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28040356 | 28040356 | PRJNA533623_P_NODE_46045_length_313_cov_1.369048_g44269_i0 | PRJNA533623 | 46045 | 313 | 1.369048 | 4.28512024 | Opisthokonta | 33154 | Annelida | Annelida | 105 | 1.2999999999999998e-24 | NR | KAK2146210.1 | 53620 | g44269 | i0 | 65.7 | 6.78594249201278 | 70 | 24 | 67.1 | 0 | 222 | 13 | 147 | 216 | KAK2146210.1 hypothetical protein LSH36_624g01057 [Paralvinella palmiformis] | diamond | 2124 | 106 | 0.990566037735849 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 28671878 | 28671878 | PRJNA533623_P_NODE_32187_length_396_cov_13.794030_g30416_i0 | PRJNA533623 | 32187 | 396 | 13.79403 | 54.6243588 | Metazoa | 33208 | Annelida | Annelida | 105 | 9.499999999999999e-24 | NR | XP_009019935.1 | 6412 | g30416 | i0 | 90 | 1.92424242424242 | 60 | 6 | 45.5 | 0 | 51 | 230 | 418 | 477 | XP_009019935.1 hypothetical protein HELRODRAFT_188740 [Helobdella robusta] | diamond | 762 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28734967 | 28734967 | PRJNA533623_P_NODE_67707_length_227_cov_3.596386_g65926_i0 | PRJNA533623 | 67707 | 227 | 3.596386 | 8.16379622 | Metazoa | 33208 | Annelida | Annelida | 43.5 | 0.0153 | NR | XP_009025404.1 | 6412 | g65926 | i0 | 75 | 1.88986784140969 | 24 | 6 | 31.7 | 0 | 23 | 94 | 263 | 286 | XP_009025404.1 hypothetical protein HELRODRAFT_107343 [Helobdella robusta] | diamond | 429 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28751482 | 28751482 | PRJNA533623_P_NODE_10667_length_718_cov_11.602740_g9090_i0 | PRJNA533623 | 10667 | 718 | 11.60274 | 83.3076732 | Owenia fusiformis | 6347 | Annelida | Annelida | 85.5 | 4.49e-15 | NR | CAH1780213.1 | 6347 | g9090 | i0 | 48.9 | 1.73816155988858 | 92 | 45 | 37.6 | 1 | 221 | 490 | 42 | 133 | CAH1780213.1 unnamed protein product [Owenia fusiformis] | diamond | 1248 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28909066 | 28909066 | PRJNA533623_P_NODE_12388_length_669_cov_9.527961_g10742_i0 | PRJNA533623 | 12388 | 669 | 9.527961 | 63.74205909 | Owenia fusiformis | 6347 | Annelida | Annelida | 129 | 9.77e-32 | NR | CAH1779301.1 | 6347 | g10742 | i0 | 54.5 | 0.502242152466368 | 112 | 49 | 49.3 | 1 | 280 | 609 | 270 | 381 | CAH1779301.1 unnamed protein product [Owenia fusiformis] | diamond | 336 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31816123 | 31816123 | PRJNA533623_P_NODE_3917_length_1122_cov_41.839774_g2854_i0 | PRJNA533623 | 3917 | 1122 | 41.839774 | 469.44226428 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 150 | 1.4e-36 | NR | KAK2161537.1 | 53620 | g2854 | i0 | 43.8 | 1.14705882352941 | 203 | 91 | 51.6 | 9 | 15 | 593 | 304 | 493 | KAK2161537.1 hypothetical protein LSH36_115g13038 [Paralvinella palmiformis] | diamond | 1287 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 32575711 | 32575711 | PRJNA533623_P_NODE_2979_length_1252_cov_16.624685_g2061_i0 | PRJNA533623 | 2979 | 1252 | 16.624685 | 208.1410562 | Owenia fusiformis | 6347 | Annelida | Annelida | 139 | 5.96e-35 | NR | CAH1779367.1 | 6347 | g2061 | i0 | 36.9 | 1.60782747603834 | 225 | 129 | 53 | 6 | 405 | 1067 | 14 | 229 | CAH1779367.1 unnamed protein product [Owenia fusiformis] | diamond | 2013 | 139 | 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);;