contig_metadata
26 rows where bioproject = "PRJEB27957" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 23381 | 23381 | PRJEB27957_P_NODE_123941_length_162_cov_1.380531_g123831_i0 | PRJEB27957 | 123941 | 162 | 1.380531 | 2.23646022 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.004 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g123831 | i0 | 100 | 0.716049382716049 | 29 | 0 | 18 | 0 | 72 | 100 | 1073810 | 1073838 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 116 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 986806 | 986806 | PRJEB27957_P_NODE_47721_length_236_cov_1.155080_g47611_i0 | PRJEB27957 | 47721 | 236 | 1.15508 | 2.7259888 | Clitellata | 42113 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369718|emb|OZ237791.1| | 311461 | g47611 | i0 | 90.698 | 3.85593220338983 | 43 | 3 | 18 | 1 | 174 | 216 | 7451644 | 7451603 | Hirudo verbana genome assembly, chromosome: 13 | blastn | 910 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 2573291 | 2573291 | PRJEB27957_P_NODE_113683_length_166_cov_0.888889_g113573_i0 | PRJEB27957 | 113683 | 166 | 0.888889 | 1.47555574 | Hirudo verbana | 311461 | Annelida | Annelida | 63.9 | 6.42e-6 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g113573 | i0 | 100 | 20.7650602409639 | 34 | 0 | 20 | 0 | 2 | 35 | 6232217 | 6232250 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 3447 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 2573318 | 2573318 | PRJEB27957_P_NODE_34743_length_267_cov_1.403670_g34633_i0 | PRJEB27957 | 34743 | 267 | 1.40367 | 3.7477989 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2920003608|emb|OZ238872.1| | 1046305 | g34633 | i0 | 100 | 0.108614232209738 | 29 | 0 | 11 | 0 | 235 | 263 | 11452995 | 11452967 | Ailoscolex lacteospumosus genome assembly, chromosome: 13 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 2573349 | 2573349 | PRJEB27957_P_NODE_82263_length_189_cov_1.485714_g82153_i0 | PRJEB27957 | 82263 | 189 | 1.485714 | 2.80799946 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.001 | NTclustered | gi|2920003608|emb|OZ238872.1| | 1046305 | g82153 | i0 | 97.059 | 0.349206349206349 | 34 | 0 | 18 | 1 | 68 | 101 | 3075722 | 3075690 | Ailoscolex lacteospumosus genome assembly, chromosome: 13 | blastn | 66 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 2573352 | 2573352 | PRJEB27957_P_NODE_86123_length_185_cov_1.529412_g86013_i0 | PRJEB27957 | 86123 | 185 | 1.529412 | 2.8294122 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.016 | NTclustered | gi|2918369718|emb|OZ237791.1| | 311461 | g86013 | i0 | 100 | 0.151351351351351 | 28 | 0 | 15 | 0 | 71 | 98 | 970409 | 970382 | Hirudo verbana genome assembly, chromosome: 13 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 2573356 | 2573356 | PRJEB27957_P_NODE_90003_length_181_cov_1.575758_g89893_i0 | PRJEB27957 | 90003 | 181 | 1.575758 | 2.85212198 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.004 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g89893 | i0 | 100 | 0.624309392265193 | 29 | 0 | 16 | 0 | 82 | 110 | 31935514 | 31935542 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 113 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 5125794 | 5125794 | PRJEB27957_P_NODE_112985_length_166_cov_0.888889_g112875_i0 | PRJEB27957 | 112985 | 166 | 0.888889 | 1.47555574 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.001 | NTclustered | gi|2918369710|emb|OZ237789.1| | 311461 | g112875 | i0 | 97.059 | 0.204819277108434 | 34 | 0 | 20 | 1 | 124 | 157 | 5516482 | 5516450 | Hirudo verbana genome assembly, chromosome: 11 | blastn | 34 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 8950441 | 8950441 | PRJEB27957_P_NODE_40968_length_250_cov_2.039801_g40858_i0 | PRJEB27957 | 40968 | 250 | 2.039801 | 5.0995025 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.023 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g40858 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 97 | 124 | 29685084 | 29685111 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 8950479 | 8950479 | PRJEB27957_P_NODE_97448_length_174_cov_1.248000_g97338_i0 | PRJEB27957 | 97448 | 174 | 1.248 | 2.17152 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 8.75e-5 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g97338 | i0 | 100 | 0.867816091954023 | 32 | 0 | 18 | 0 | 110 | 141 | 43872463 | 43872494 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 151 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 10226155 | 10226155 | PRJEB27957_P_NODE_16769_length_351_cov_1.324503_g16659_i0 | PRJEB27957 | 16769 | 351 | 1.324503 | 4.64900553 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.033 | NTclustered | gi|2920003578|emb|OZ238870.1| | 1046305 | g16659 | i0 | 96.875 | 0.0911680911680912 | 32 | 0 | 9 | 1 | 318 | 348 | 6106646 | 6106677 | Ailoscolex lacteospumosus genome assembly, chromosome: 11 | blastn | 32 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 10226172 | 10226172 | PRJEB27957_P_NODE_47989_length_235_cov_1.956989_g47879_i0 | PRJEB27957 | 47989 | 235 | 1.956989 | 4.59892415 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 1.26e-4 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g47879 | i0 | 97.143 | 6.47659574468085 | 35 | 1 | 15 | 0 | 201 | 235 | 775007 | 775041 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 1522 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 12776987 | 12776987 | PRJEB27957_P_NODE_56711_length_221_cov_0.906977_g56601_i0 | PRJEB27957 | 56711 | 221 | 0.906977 | 2.00441917 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2920003651|emb|OZ238876.1| | 1046305 | g56601 | i0 | 92.5 | 4.90045248868778 | 40 | 2 | 18 | 1 | 163 | 201 | 14449001 | 14449040 | Ailoscolex lacteospumosus genome assembly, chromosome: 17 | blastn | 1083 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 16600229 | 16600229 | PRJEB27957_P_NODE_41854_length_248_cov_1.688442_g41744_i0 | PRJEB27957 | 41854 | 248 | 1.688442 | 4.18733616 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g41744 | i0 | 100 | 0.112903225806452 | 28 | 0 | 11 | 0 | 18 | 45 | 3555865 | 3555838 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 17874990 | 17874990 | PRJEB27957_P_NODE_124215_length_162_cov_0.920354_g124105_i0 | PRJEB27957 | 124215 | 162 | 0.920354 | 1.49097348 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.004 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g124105 | i0 | 100 | 0.179012345679012 | 29 | 0 | 18 | 0 | 62 | 90 | 24027007 | 24026979 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 17875006 | 17875006 | PRJEB27957_P_NODE_37375_length_259_cov_2.228571_g37265_i0 | PRJEB27957 | 37375 | 259 | 2.228571 | 5.77199889 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g37265 | i0 | 100 | 0.115830115830116 | 30 | 0 | 12 | 0 | 198 | 227 | 5051785 | 5051756 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 19148933 | 19148933 | PRJEB27957_P_NODE_95376_length_176_cov_1.228346_g95266_i0 | PRJEB27957 | 95376 | 176 | 1.228346 | 2.16188896 | Helobdella robusta | 6412 | Annelida | Annelida | 52.8 | 0.015 | NTclustered | gi|675851193|ref|XM_009012909.1| | 6412 | g95266 | i0 | 100 | 0.159090909090909 | 28 | 0 | 16 | 0 | 105 | 132 | 1059 | 1032 | Helobdella robusta hypothetical protein mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 21700151 | 21700151 | PRJEB27957_P_NODE_81958_length_189_cov_2.192857_g81848_i0 | PRJEB27957 | 81958 | 189 | 2.192857 | 4.14449973 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.016 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g81848 | i0 | 100 | 0.148148148148148 | 28 | 0 | 15 | 0 | 99 | 126 | 20596915 | 20596888 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 22975335 | 22975335 | PRJEB27957_P_NODE_103759_length_169_cov_0.866667_g103649_i0 | PRJEB27957 | 103759 | 169 | 0.866667 | 1.46466723 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.014 | NTclustered | gi|2918369706|emb|OZ237788.1| | 311461 | g103649 | i0 | 100 | 0.165680473372781 | 28 | 0 | 17 | 0 | 51 | 78 | 5982845 | 5982872 | Hirudo verbana genome assembly, chromosome: 10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 22975359 | 22975359 | PRJEB27957_P_NODE_128039_length_151_cov_3.147059_g127929_i0 | PRJEB27957 | 128039 | 151 | 3.147059 | 4.75205909 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.003 | NTclustered | gi|2920003623|emb|OZ238873.1| | 1046305 | g127929 | i0 | 100 | 0.933774834437086 | 29 | 0 | 19 | 0 | 78 | 106 | 15581462 | 15581490 | Ailoscolex lacteospumosus genome assembly, chromosome: 14 | blastn | 141 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 22975373 | 22975373 | PRJEB27957_P_NODE_39899_length_253_cov_1.274510_g39789_i0 | PRJEB27957 | 39899 | 253 | 1.27451 | 3.2245103 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g39789 | i0 | 100 | 0.114624505928854 | 29 | 0 | 11 | 0 | 170 | 198 | 6106019 | 6105991 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 22975406 | 22975406 | PRJEB27957_P_NODE_92779_length_178_cov_2.015504_g92669_i0 | PRJEB27957 | 92779 | 178 | 2.015504 | 3.58759712 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.004 | NTclustered | gi|2920003418|emb|OZ238863.1| | 1046305 | g92669 | i0 | 96.875 | 1.14044943820225 | 32 | 1 | 18 | 0 | 147 | 178 | 20256658 | 20256689 | Ailoscolex lacteospumosus genome assembly, chromosome: 4 | blastn | 203 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 25212938 | 25212938 | PRJEB27957_P_NODE_54660_length_224_cov_1.188571_g54550_i0 | PRJEB27957 | 54660 | 224 | 1.188571 | 2.66239904 | Metazoa | 33208 | Annelida | Annelida | 52.8 | 0.02 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g54550 | i0 | 100 | 0.375 | 28 | 0 | 13 | 0 | 88 | 115 | 1282803 | 1282776 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 26906619 | 26906619 | PRJEB27957_P_NODE_27442_length_292_cov_2.139918_g27332_i0 | PRJEB27957 | 27442 | 292 | 2.139918 | 6.24856056 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 49.7 | 2.05e-5 | NR | KAK2157171.1 | 53620 | g27332 | i0 | 52.3 | 0.452054794520548 | 44 | 21 | 45.2 | 0 | 227 | 96 | 22 | 65 | KAK2157171.1 hypothetical protein LSH36_196g03088 [Paralvinella palmiformis] | diamond | 132 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 30159308 | 30159308 | PRJEB27957_P_NODE_71792_length_201_cov_1.026316_g71682_i0 | PRJEB27957 | 71792 | 201 | 1.026316 | 2.06289516 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 50.1 | 5.55e-5 | NR | KAI0213684.1 | 104711 | g71682 | i0 | 61.8 | 0.507462686567164 | 34 | 13 | 50.7 | 0 | 103 | 2 | 626 | 659 | KAI0213684.1 putative RNA-directed DNA polymerase from transposon BS [Lamellibrachia satsuma] | diamond | 102 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 31859840 | 31859840 | PRJEB27957_P_NODE_104357_length_169_cov_0.866667_g104247_i0 | PRJEB27957 | 104357 | 169 | 0.866667 | 1.46466723 | Metazoa | 33208 | Annelida | Annelida | 43.5 | 0.00593 | NR | KAI0234953.1 | 104711 | g104247 | i0 | 73.1 | 4.61538461538461 | 26 | 7 | 46.2 | 0 | 27 | 104 | 62 | 87 | KAI0234953.1 hypothetical protein LSAT2_014678, partial [Lamellibrachia satsuma] | diamond | 780 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma |
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);;