contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA867519" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 848111 | 848111 | PRJNA867519_P_NODE_25701_length_251_cov_0.865169_g25547_i0 | PRJNA867519 | 25701 | 251 | 0.865169 | 2.17157419 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.023 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g25547 | i0 | 100 | 0.111553784860558 | 28 | 0 | 11 | 0 | 44 | 71 | 4488387 | 4488414 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 1236975 | 1236975 | PRJNA867519_P_NODE_23721_length_259_cov_1.532258_g23567_i0 | PRJNA867519 | 23721 | 259 | 1.532258 | 3.96854822 | Opisthokonta | 33154 | Annelida | Annelida | 62.1 | 3.92e-5 | NTclustered | gi|675861031|ref|XM_009017828.1| | 6412 | g23567 | i0 | 88.235 | 5.88803088803089 | 51 | 6 | 20 | 0 | 36 | 86 | 903 | 853 | Helobdella robusta hypothetical protein partial mRNA | blastn | 1525 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 3398798 | 3398798 | PRJNA867519_P_NODE_16823_length_290_cov_1.087558_g16669_i0 | PRJNA867519 | 16823 | 290 | 1.087558 | 3.1539182 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2920003578|emb|OZ238870.1| | 1046305 | g16669 | i0 | 96.875 | 0.110344827586207 | 32 | 1 | 11 | 0 | 44 | 75 | 21362107 | 21362138 | Ailoscolex lacteospumosus genome assembly, chromosome: 11 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 7226329 | 7226329 | PRJNA867519_P_NODE_2306_length_661_cov_2.244898_g2157_i0 | PRJNA867519 | 2306 | 661 | 2.244898 | 14.83877578 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.018 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g2157 | i0 | 100 | 0.0438729198184569 | 29 | 0 | 4 | 0 | 348 | 376 | 17840604 | 17840576 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 11051734 | 11051734 | PRJNA867519_P_NODE_11809_length_336_cov_1.171103_g11655_i0 | PRJNA867519 | 11809 | 336 | 1.171103 | 3.93490608 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.032 | NTclustered | gi|2918369718|emb|OZ237791.1| | 311461 | g11655 | i0 | 100 | 0.0833333333333333 | 28 | 0 | 8 | 0 | 101 | 128 | 5534869 | 5534842 | Hirudo verbana genome assembly, chromosome: 13 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 13601809 | 13601809 | PRJNA867519_P_NODE_26991_length_249_cov_1.312500_g26837_i0 | PRJNA867519 | 26991 | 249 | 1.3125 | 3.268125 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369720|emb|OZ237792.1| | 311461 | g26837 | i0 | 100 | 1.01606425702811 | 29 | 0 | 12 | 0 | 185 | 213 | 2041534 | 2041562 | Hirudo verbana genome assembly, chromosome: 14 | blastn | 253 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 13601927 | 13601927 | PRJNA867519_P_NODE_9071_length_373_cov_1.056667_g8917_i0 | PRJNA867519 | 9071 | 373 | 1.056667 | 3.94136791 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 62.1 | 5.9e-5 | NTclustered | gi|2920003508|emb|OZ238866.1| | 1046305 | g8917 | i0 | 97.297 | 0.195710455764075 | 37 | 0 | 10 | 1 | 88 | 123 | 10496977 | 10497013 | Ailoscolex lacteospumosus genome assembly, chromosome: 7 | blastn | 73 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 16150705 | 16150705 | PRJNA867519_P_NODE_16813_length_290_cov_1.147465_g16659_i0 | PRJNA867519 | 16813 | 290 | 1.147465 | 3.3276485 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2920003593|emb|OZ238871.1| | 1046305 | g16659 | i0 | 100 | 0.1 | 29 | 0 | 10 | 0 | 115 | 143 | 17930624 | 17930596 | Ailoscolex lacteospumosus genome assembly, chromosome: 12 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 17426412 | 17426412 | PRJNA867519_P_NODE_5594_length_458_cov_0.997403_g5440_i0 | PRJNA867519 | 5594 | 458 | 0.997403 | 4.56810574 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 80.5 | 2.04e-10 | NTclustered | gi|2920003636|emb|OZ238874.1| | 1046305 | g5440 | i0 | 88.406 | 0.853711790393013 | 69 | 5 | 15 | 3 | 251 | 317 | 8169967 | 8170034 | Ailoscolex lacteospumosus genome assembly, chromosome: 15 | blastn | 391 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 18699455 | 18699455 | PRJNA867519_P_NODE_24155_length_257_cov_1.255435_g24001_i0 | PRJNA867519 | 24155 | 257 | 1.255435 | 3.22646795 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 111 | 3.8e-20 | NTclustered | gi|2920003608|emb|OZ238872.1| | 1046305 | g24001 | i0 | 78.698 | 8.03501945525292 | 169 | 34 | 65 | 2 | 87 | 254 | 3408969 | 3409136 | Ailoscolex lacteospumosus genome assembly, chromosome: 13 | blastn | 2065 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 19974658 | 19974658 | PRJNA867519_P_NODE_21656_length_268_cov_1.579487_g21502_i0 | PRJNA867519 | 21656 | 268 | 1.579487 | 4.23302516 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 60.2 | 1.47e-4 | NTclustered | gi|2920003456|emb|OZ238864.1| | 1046305 | g21502 | i0 | 97.143 | 0.130597014925373 | 35 | 1 | 13 | 0 | 8 | 42 | 18071972 | 18071938 | Ailoscolex lacteospumosus genome assembly, chromosome: 5 | blastn | 35 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 22524758 | 22524758 | PRJNA867519_P_NODE_15478_length_300_cov_1.581498_g15324_i0 | PRJNA867519 | 15478 | 300 | 1.581498 | 4.744494 | Helobdella robusta | 6412 | Annelida | Annelida | 58.4 | 6e-4 | NTclustered | gi|675851267|ref|XM_009012946.1| | 6412 | g15324 | i0 | 92.683 | 1.06 | 41 | 2 | 14 | 1 | 178 | 218 | 4532 | 4493 | Helobdella robusta hypothetical protein partial mRNA | blastn | 318 | 58.4 | 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);;