contig_metadata
23 rows where analysis = "blastn", bioproject = "PRJNA1186363" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1594377 | 1594377 | PRJNA1186363_P_NODE_23322_length_381_cov_6.392857_g22434_i0 | PRJNA1186363 | 23322 | 381 | 6.392857 | 24.35678517 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.01 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g22434 | i0 | 100 | 0.37007874015748 | 29 | 0 | 8 | 0 | 68 | 96 | 13463049 | 13463021 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 141 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 1594535 | 1594535 | PRJNA1186363_P_NODE_6002_length_869_cov_8.119347_g5281_i0 | PRJNA1186363 | 6002 | 869 | 8.119347 | 70.55712543 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.007 | NTclustered | gi|2918369697|emb|OZ237786.1| | 311461 | g5281 | i0 | 92.308 | 0.0448791714614499 | 39 | 3 | 4 | 0 | 356 | 394 | 10634032 | 10633994 | Hirudo verbana genome assembly, chromosome: 8 | blastn | 39 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 2870545 | 2870545 | PRJNA1186363_P_NODE_28623_length_329_cov_0.914062_g27735_i0 | PRJNA1186363 | 28623 | 329 | 0.914062 | 3.00726398 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.031 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g27735 | i0 | 94.118 | 0.103343465045593 | 34 | 2 | 10 | 0 | 59 | 92 | 10144416 | 10144449 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 34 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 3592472 | 3592472 | PRJNA1186363_P_NODE_21983_length_397_cov_1.925926_g21095_i0 | PRJNA1186363 | 21983 | 397 | 1.925926 | 7.64592622 | Metazoa | 33208 | Annelida | Annelida | 58.4 | 8.17e-4 | NTclustered | gi|219521937|gb|AC171127.2| | 6412 | g21095 | i0 | 97.059 | 0.483627204030227 | 34 | 1 | 9 | 0 | 313 | 346 | 38034 | 38067 | Helobdella robusta clone CH306-1A1, complete sequence | blastn | 192 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 4146541 | 4146541 | PRJNA1186363_P_NODE_15684_length_497_cov_1.099057_g14798_i0 | PRJNA1186363 | 15684 | 497 | 1.099057 | 5.46231329 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 2.9e-4 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g14798 | i0 | 97.143 | 4.4989939637827 | 35 | 1 | 7 | 0 | 356 | 390 | 32142150 | 32142184 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 2236 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 4146617 | 4146617 | PRJNA1186363_P_NODE_26124_length_352_cov_1.240143_g25236_i0 | PRJNA1186363 | 26124 | 352 | 1.240143 | 4.36530336 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.003 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g25236 | i0 | 100 | 0.0852272727272727 | 30 | 0 | 9 | 0 | 298 | 327 | 10454006 | 10453977 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 6144820 | 6144820 | PRJNA1186363_P_NODE_22245_length_394_cov_1.457944_g21357_i0 | PRJNA1186363 | 22245 | 394 | 1.457944 | 5.74429936 | Opisthokonta | 33154 | Annelida | Annelida | 52.8 | 0.038 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g21357 | i0 | 91.892 | 0.258883248730964 | 37 | 3 | 9 | 0 | 286 | 322 | 2402104 | 2402140 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 102 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 7972994 | 7972994 | PRJNA1186363_P_NODE_28427_length_330_cov_1.821012_g27539_i0 | PRJNA1186363 | 28427 | 330 | 1.821012 | 6.0093396 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.031 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g27539 | i0 | 100 | 0.263636363636364 | 28 | 0 | 8 | 0 | 137 | 164 | 4857046 | 4857019 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 87 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 7973047 | 7973047 | PRJNA1186363_P_NODE_3747_length_1076_cov_3.263210_g3205_i0 | PRJNA1186363 | 3747 | 1076 | 3.26321 | 35.1121396 | Helobdella robusta | 6412 | Annelida | Annelida | 54.7 | 0.03 | NTclustered | gi|675891115|ref|XM_009032812.1| | 6412 | g3205 | i0 | 94.286 | 0.0325278810408922 | 35 | 2 | 3 | 0 | 1008 | 1042 | 1175 | 1209 | Helobdella robusta hypothetical protein partial mRNA | blastn | 35 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 10523423 | 10523423 | PRJNA1186363_P_NODE_25749_length_356_cov_0.911661_g24861_i0 | PRJNA1186363 | 25749 | 356 | 0.911661 | 3.24551316 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 7.24e-4 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g24861 | i0 | 94.595 | 0.5 | 37 | 2 | 10 | 0 | 308 | 344 | 4501205 | 4501241 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 178 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 10523436 | 10523436 | PRJNA1186363_P_NODE_28129_length_333_cov_1.196154_g27241_i0 | PRJNA1186363 | 28129 | 333 | 1.196154 | 3.98319282 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.009 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g27241 | i0 | 96.97 | 1.04204204204204 | 33 | 0 | 10 | 1 | 248 | 279 | 1155727 | 1155695 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 347 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 11798264 | 11798264 | PRJNA1186363_P_NODE_12870_length_564_cov_1.022403_g11988_i0 | PRJNA1186363 | 12870 | 564 | 1.022403 | 5.76635292 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.015 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g11988 | i0 | 96.875 | 0.170212765957447 | 32 | 1 | 6 | 0 | 468 | 499 | 1467838 | 1467807 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 96 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 11798329 | 11798329 | PRJNA1186363_P_NODE_2190_length_1334_cov_4.420301_g1813_i0 | PRJNA1186363 | 2190 | 1334 | 4.420301 | 58.96681534 | Helobdella robusta | 6412 | Annelida | Annelida | 54.7 | 0.038 | NTclustered | gi|675891115|ref|XM_009032812.1| | 6412 | g1813 | i0 | 94.286 | 0.0262368815592204 | 35 | 2 | 3 | 0 | 299 | 333 | 1209 | 1175 | Helobdella robusta hypothetical protein partial mRNA | blastn | 35 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 11798425 | 11798425 | PRJNA1186363_P_NODE_36670_length_264_cov_1.633508_g35782_i0 | PRJNA1186363 | 36670 | 264 | 1.633508 | 4.31246112 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 1.44e-4 | NTclustered | gi|2920003371|emb|OZ238862.1| | 1046305 | g35782 | i0 | 100 | 11.6590909090909 | 32 | 0 | 12 | 0 | 11 | 42 | 28339428 | 28339459 | Ailoscolex lacteospumosus genome assembly, chromosome: 3 | blastn | 3078 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 13073386 | 13073386 | PRJNA1186363_P_NODE_38291_length_253_cov_0.866667_g37403_i0 | PRJNA1186363 | 38291 | 253 | 0.866667 | 2.19266751 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369720|emb|OZ237792.1| | 311461 | g37403 | i0 | 100 | 0.114624505928854 | 29 | 0 | 11 | 0 | 223 | 251 | 6529642 | 6529614 | Hirudo verbana genome assembly, chromosome: 14 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 14348714 | 14348714 | PRJNA1186363_P_NODE_192_length_2610_cov_2.726054_g141_i0 | PRJNA1186363 | 192 | 2610 | 2.726054 | 71.1500094 | Hirudo verbana | 311461 | Annelida | Annelida | 62.1 | 4.5e-4 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g141 | i0 | 97.222 | 0.0318007662835249 | 36 | 1 | 2 | 0 | 236 | 271 | 2972305 | 2972270 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 83 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 15622570 | 15622570 | PRJNA1186363_P_NODE_38553_length_253_cov_0.866667_g37665_i0 | PRJNA1186363 | 38553 | 253 | 0.866667 | 2.19266751 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 1.37e-4 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g37665 | i0 | 94.872 | 0.154150197628458 | 39 | 0 | 15 | 2 | 209 | 247 | 1582338 | 1582302 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 39 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 21996322 | 21996322 | PRJNA1186363_P_NODE_12138_length_584_cov_1.808219_g11256_i0 | PRJNA1186363 | 12138 | 584 | 1.808219 | 10.55999896 | Aeolosoma viride | 394736 | Annelida | Annelida | 364 | 6.529999999999998e-96 | NTclustered | gi|1151119859|gb|KY079093.1| | 394736 | g11256 | i0 | 85.154 | 58.5702054794521 | 357 | 51 | 61 | 2 | 3 | 358 | 1039 | 1394 | Aeolosoma viride beta-tubulin isoform 1 mRNA, complete cds | blastn | 34205 | 364 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Aeolosomatidae | Aeolosoma | Aeolosoma viride | |
| 21996338 | 21996338 | PRJNA1186363_P_NODE_13838_length_539_cov_1.609442_g12954_i0 | PRJNA1186363 | 13838 | 539 | 1.609442 | 8.67489238 | Helobdella robusta | 6412 | Annelida | Annelida | 161 | 8.43e-35 | NTclustered | gi|675858327|ref|XM_009016476.1| | 6412 | g12954 | i0 | 79.237 | 3.31354359925788 | 236 | 45 | 43 | 4 | 305 | 538 | 1227 | 994 | Helobdella robusta hypothetical protein partial mRNA | blastn | 1786 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 23271882 | 23271882 | PRJNA1186363_P_NODE_22379_length_393_cov_0.975000_g21491_i0 | PRJNA1186363 | 22379 | 393 | 0.975 | 3.83175 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 63.9 | 1.74e-5 | NTclustered | gi|2920003527|emb|OZ238867.1| | 1046305 | g21491 | i0 | 88.889 | 9.57760814249364 | 54 | 2 | 13 | 3 | 37 | 86 | 25516702 | 25516755 | Ailoscolex lacteospumosus genome assembly, chromosome: 8 | blastn | 3764 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 23271910 | 23271910 | PRJNA1186363_P_NODE_25079_length_363_cov_1.075862_g24191_i0 | PRJNA1186363 | 25079 | 363 | 1.075862 | 3.90537906 | Hirudo verbana | 311461 | Annelida | Annelida | 71.3 | 9.51e-8 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g24191 | i0 | 90.566 | 3.10468319559229 | 53 | 5 | 15 | 0 | 40 | 92 | 710108 | 710160 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 1127 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 24545829 | 24545829 | PRJNA1186363_P_NODE_43540_length_242_cov_1.473373_g42652_i0 | PRJNA1186363 | 43540 | 242 | 1.473373 | 3.56556266 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 4.69e-4 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g42652 | i0 | 92.857 | 9.51652892561983 | 42 | 0 | 16 | 2 | 201 | 239 | 22818944 | 22818985 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 2303 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 24545835 | 24545835 | PRJNA1186363_P_NODE_4580_length_982_cov_3.203520_g3964_i0 | PRJNA1186363 | 4580 | 982 | 3.20352 | 31.4585664 | Hirudo verbana | 311461 | Annelida | Annelida | 67.6 | 3.55e-6 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g3964 | i0 | 93.333 | 3.94602851323829 | 45 | 3 | 5 | 0 | 746 | 790 | 11585357 | 11585313 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 3875 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana |
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);;