contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA556992" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1805706 | 1805706 | PRJNA556992_P_NODE_547102_length_263_cov_2.226316_g544913_i0 | PRJNA556992 | 547102 | 263 | 2.226316 | 5.85521108 | Hirudo verbana | 311461 | Annelida | Annelida | 62.1 | 3.99e-5 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g544913 | i0 | 100 | 6.89733840304183 | 33 | 0 | 13 | 0 | 116 | 148 | 2156165 | 2156197 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 1814 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 1809194 | 1809194 | PRJNA556992_P_NODE_827522_length_244_cov_3.538012_g825332_i0 | PRJNA556992 | 827522 | 244 | 3.538012 | 8.63274928 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2920003508|emb|OZ238866.1| | 1046305 | g825332 | i0 | 100 | 0.122950819672131 | 30 | 0 | 12 | 0 | 162 | 191 | 21408429 | 21408458 | Ailoscolex lacteospumosus genome assembly, chromosome: 7 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 3082084 | 3082084 | PRJNA556992_P_NODE_634863_length_256_cov_2.032787_g632674_i0 | PRJNA556992 | 634863 | 256 | 2.032787 | 5.20393472 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2920003636|emb|OZ238874.1| | 1046305 | g632674 | i0 | 100 | 0.1171875 | 30 | 0 | 12 | 0 | 66 | 95 | 8778811 | 8778782 | Ailoscolex lacteospumosus genome assembly, chromosome: 15 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 3083665 | 3083665 | PRJNA556992_P_NODE_761143_length_248_cov_1.291429_g758954_i0 | PRJNA556992 | 761143 | 248 | 1.291429 | 3.20274392 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2920003484|emb|OZ238865.1| | 1046305 | g758954 | i0 | 96.875 | 0.241935483870968 | 32 | 1 | 13 | 0 | 26 | 57 | 4403031 | 4403000 | Ailoscolex lacteospumosus genome assembly, chromosome: 6 | blastn | 60 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 4349007 | 4349007 | PRJNA556992_P_NODE_1006104_length_230_cov_2.394904_g1003914_i0 | PRJNA556992 | 1006104 | 230 | 2.394904 | 5.5082792 | Salmacina sp. 2 SAM E3535 | 363318 | Annelida | Annelida | 106 | 1.55e-18 | NTclustered | gi|83843385|gb|DQ318578.1| | 363318 | g1003914 | i0 | 76.087 | 33.495652173913 | 230 | 39 | 99 | 12 | 1 | 227 | 365 | 149 | Salmacina sp. 2 SAM E3535 28S ribosomal RNA gene, partial sequence | blastn | 7704 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Serpulidae | Salmacina | Salmacina sp. 2 SAM E3535 | |
| 4351066 | 4351066 | PRJNA556992_P_NODE_1168944_length_197_cov_6.048387_g1166753_i0 | PRJNA556992 | 1168944 | 197 | 6.048387 | 11.91532239 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.005 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g1166753 | i0 | 94.444 | 0.182741116751269 | 36 | 0 | 17 | 2 | 154 | 187 | 2211960 | 2211995 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 36 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 4351169 | 4351169 | PRJNA556992_P_NODE_118224_length_385_cov_2.016026_g116037_i0 | PRJNA556992 | 118224 | 385 | 2.016026 | 7.7617001 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 69.4 | 3.65e-7 | NTclustered | gi|2920003644|emb|OZ238875.1| | 1046305 | g116037 | i0 | 79.798 | 8.23896103896104 | 99 | 16 | 25 | 3 | 122 | 218 | 1713925 | 1713829 | Ailoscolex lacteospumosus genome assembly, chromosome: 16 | blastn | 3172 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 4361889 | 4361889 | PRJNA556992_P_NODE_905804_length_240_cov_3.239521_g903614_i0 | PRJNA556992 | 905804 | 240 | 3.239521 | 7.7748504 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2920003527|emb|OZ238867.1| | 1046305 | g903614 | i0 | 96.875 | 0.133333333333333 | 32 | 1 | 13 | 0 | 4 | 35 | 4077997 | 4077966 | Ailoscolex lacteospumosus genome assembly, chromosome: 8 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 6899908 | 6899908 | PRJNA556992_P_NODE_1018466_length_228_cov_5.477419_g1016276_i0 | PRJNA556992 | 1018466 | 228 | 5.477419 | 12.48851532 | Hirudo verbana | 311461 | Annelida | Annelida | 67.6 | 7.26e-7 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g1016276 | i0 | 93.333 | 4.63157894736842 | 45 | 3 | 20 | 0 | 44 | 88 | 1633729 | 1633685 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 1056 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 6900320 | 6900320 | PRJNA556992_P_NODE_1051686_length_224_cov_5.973510_g1049496_i0 | PRJNA556992 | 1051686 | 224 | 5.97351 | 13.3806624 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.02 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g1049496 | i0 | 100 | 0.125 | 28 | 0 | 13 | 0 | 36 | 63 | 11304652 | 11304625 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 6910403 | 6910403 | PRJNA556992_P_NODE_740366_length_249_cov_1.494318_g738177_i0 | PRJNA556992 | 740366 | 249 | 1.494318 | 3.72085182 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 65.8 | 2.89e-6 | NTclustered | gi|2920003456|emb|OZ238864.1| | 1046305 | g738177 | i0 | 93.333 | 8.28915662650602 | 45 | 2 | 18 | 1 | 122 | 165 | 28286520 | 28286476 | Ailoscolex lacteospumosus genome assembly, chromosome: 5 | blastn | 2064 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 8778470 | 8778470 | PRJNA556992_P_NODE_256827_length_302_cov_1.655022_g254638_i0 | PRJNA556992 | 256827 | 302 | 1.655022 | 4.99816644 | Metazoa | 33208 | Annelida | Annelida | 150 | 9.689999999999999e-32 | NTclustered | gi|37785583|gb|AY210470.1| | 6426 | g254638 | i0 | 83.636 | 54.9072847682119 | 165 | 21 | 54 | 5 | 1 | 163 | 1180 | 1020 | Riftia pachyptila 28S ribosomal RNA gene, partial sequence | blastn | 16582 | 150 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Riftia | Riftia pachyptila | |
| 10053286 | 10053286 | PRJNA556992_P_NODE_1175428_length_196_cov_4.317073_g1173237_i0 | PRJNA556992 | 1175428 | 196 | 4.317073 | 8.46146308 | Opisthokonta | 33154 | Annelida | Annelida | 56.5 | 0.001 | NTclustered | gi|2920003644|emb|OZ238875.1| | 1046305 | g1173237 | i0 | 100 | 4.44897959183673 | 30 | 0 | 15 | 0 | 87 | 116 | 15950151 | 15950122 | Ailoscolex lacteospumosus genome assembly, chromosome: 16 | blastn | 872 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 13283879 | 13283879 | PRJNA556992_P_NODE_526991_length_265_cov_1.505208_g524802_i0 | PRJNA556992 | 526991 | 265 | 1.505208 | 3.9888012 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.024 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g524802 | i0 | 100 | 0.105660377358491 | 28 | 0 | 11 | 0 | 227 | 254 | 34174314 | 34174287 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 14560475 | 14560475 | PRJNA556992_P_NODE_662372_length_254_cov_1.535912_g660183_i0 | PRJNA556992 | 662372 | 254 | 1.535912 | 3.90121648 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 1.38e-4 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g660183 | i0 | 100 | 9.70472440944882 | 32 | 0 | 13 | 0 | 138 | 169 | 4034566 | 4034597 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 2465 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 15832032 | 15832032 | PRJNA556992_P_NODE_476173_length_269_cov_2.510204_g473984_i0 | PRJNA556992 | 476173 | 269 | 2.510204 | 6.75244876 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g473984 | i0 | 100 | 0.107806691449814 | 29 | 0 | 11 | 0 | 16 | 44 | 23323989 | 23324017 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 18375652 | 18375652 | PRJNA556992_P_NODE_1166215_length_198_cov_4.432000_g1164024_i0 | PRJNA556992 | 1166215 | 198 | 4.432 | 8.77536 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.017 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g1164024 | i0 | 96.875 | 0.161616161616162 | 32 | 0 | 16 | 1 | 109 | 139 | 10136141 | 10136110 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 32 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 18978481 | 18978481 | PRJNA556992_P_NODE_6855_length_1246_cov_29.639386_g5744_i0 | PRJNA556992 | 6855 | 1246 | 29.639386 | 369.30674956 | Metazoa | 33208 | Annelida | Annelida | 65.8 | 1.63e-5 | NTclustered | gi|2920003644|emb|OZ238875.1| | 1046305 | g5744 | i0 | 97.368 | 2.70465489566613 | 38 | 1 | 3 | 0 | 184 | 221 | 11357426 | 11357389 | Ailoscolex lacteospumosus genome assembly, chromosome: 16 | blastn | 3370 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 20925104 | 20925104 | PRJNA556992_P_NODE_1098297_length_213_cov_4.992857_g1096106_i0 | PRJNA556992 | 1098297 | 213 | 4.992857 | 10.63478541 | Hirudo verbana | 311461 | Annelida | Annelida | 73.1 | 1.44e-8 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g1096106 | i0 | 97.619 | 1.62910798122066 | 42 | 1 | 20 | 0 | 161 | 202 | 935453 | 935494 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 347 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 24761137 | 24761137 | PRJNA556992_P_NODE_937160_length_237_cov_2.609756_g934970_i0 | PRJNA556992 | 937160 | 237 | 2.609756 | 6.18512172 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2920003563|emb|OZ238869.1| | 1046305 | g934970 | i0 | 100 | 0.607594936708861 | 29 | 0 | 12 | 0 | 128 | 156 | 15529706 | 15529678 | Ailoscolex lacteospumosus genome assembly, chromosome: 10 | blastn | 144 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus |
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);;