contig_metadata
19 rows where bioproject = "PRJNA700095", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3234329 | 3234329 | PRJNA700095_P_NODE_67763_length_233_cov_2.375000_g66498_i0 | PRJNA700095 | 67763 | 233 | 2.375 | 5.53375 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.021 | NTclustered | gi|2918369718|emb|OZ237791.1| | 311461 | g66498 | i0 | 100 | 0.120171673819742 | 28 | 0 | 12 | 0 | 206 | 233 | 7808379 | 7808352 | Hirudo verbana genome assembly, chromosome: 13 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 9611863 | 9611863 | PRJNA700095_P_NODE_70368_length_209_cov_4.683824_g69103_i0 | PRJNA700095 | 70368 | 209 | 4.683824 | 9.78919216 | Hirudo verbana | 311461 | Annelida | Annelida | 84.2 | 6.5e-12 | NTclustered | gi|2918369697|emb|OZ237786.1| | 311461 | g69103 | i0 | 79.675 | 0.588516746411483 | 123 | 19 | 56 | 4 | 16 | 133 | 11097534 | 11097413 | Hirudo verbana genome assembly, chromosome: 8 | blastn | 123 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 10112861 | 10112861 | PRJNA700095_P_NODE_58748_length_245_cov_2.058140_g57484_i0 | PRJNA700095 | 58748 | 245 | 2.05814 | 5.042443 | Metazoa | 33208 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2920003578|emb|OZ238870.1| | 1046305 | g57484 | i0 | 100 | 0.710204081632653 | 29 | 0 | 12 | 0 | 174 | 202 | 14999051 | 14999079 | Ailoscolex lacteospumosus genome assembly, chromosome: 11 | blastn | 174 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 12162333 | 12162333 | PRJNA700095_P_NODE_32210_length_301_cov_1.135965_g30946_i0 | PRJNA700095 | 32210 | 301 | 1.135965 | 3.41925465 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.028 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g30946 | i0 | 100 | 0.0930232558139535 | 28 | 0 | 9 | 0 | 238 | 265 | 14524276 | 14524249 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 12162348 | 12162348 | PRJNA700095_P_NODE_34990_length_289_cov_1.583333_g33726_i0 | PRJNA700095 | 34990 | 289 | 1.583333 | 4.57583237 | Hirudo verbana | 311461 | Annelida | Annelida | 63.9 | 1.24e-5 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g33726 | i0 | 91.304 | 2.27681660899654 | 46 | 4 | 16 | 0 | 241 | 286 | 504418 | 504373 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 658 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 13436932 | 13436932 | PRJNA700095_P_NODE_33231_length_296_cov_1.381166_g31967_i0 | PRJNA700095 | 33231 | 296 | 1.381166 | 4.08825136 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.008 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g31967 | i0 | 96.875 | 0.108108108108108 | 32 | 1 | 11 | 0 | 22 | 53 | 13432709 | 13432678 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 19810059 | 19810059 | PRJNA700095_P_NODE_26696_length_331_cov_1.523256_g25432_i0 | PRJNA700095 | 26696 | 331 | 1.523256 | 5.04197736 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 1.86e-4 | NTclustered | gi|2918369706|emb|OZ237788.1| | 311461 | g25432 | i0 | 97.143 | 11.4441087613293 | 35 | 1 | 11 | 0 | 297 | 331 | 9285624 | 9285658 | Hirudo verbana genome assembly, chromosome: 10 | blastn | 3788 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 21085503 | 21085503 | PRJNA700095_P_NODE_17257_length_435_cov_2.044199_g15994_i0 | PRJNA700095 | 17257 | 435 | 2.044199 | 8.89226565 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.042 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g15994 | i0 | 100 | 0.064367816091954 | 28 | 0 | 6 | 0 | 28 | 55 | 2720699 | 2720672 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 21085598 | 21085598 | PRJNA700095_P_NODE_38697_length_279_cov_1.572816_g37433_i0 | PRJNA700095 | 38697 | 279 | 1.572816 | 4.38815664 | Hirudo verbana | 311461 | Annelida | Annelida | 65.8 | 3.3e-6 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g37433 | i0 | 95.122 | 11.3835125448029 | 41 | 2 | 15 | 0 | 231 | 271 | 797081 | 797041 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 3176 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 21085633 | 21085633 | PRJNA700095_P_NODE_45657_length_262_cov_2.074074_g44393_i0 | PRJNA700095 | 45657 | 262 | 2.074074 | 5.43407388 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 1.43e-4 | NTclustered | gi|2918369720|emb|OZ237792.1| | 311461 | g44393 | i0 | 94.737 | 2.00381679389313 | 38 | 2 | 15 | 0 | 78 | 115 | 7753600 | 7753563 | Hirudo verbana genome assembly, chromosome: 14 | blastn | 525 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 21085764 | 21085764 | PRJNA700095_P_NODE_70157_length_212_cov_6.496403_g68892_i0 | PRJNA700095 | 70157 | 212 | 6.496403 | 13.77237436 | Hirudo verbana | 311461 | Annelida | Annelida | 104 | 5.07e-18 | NTclustered | gi|2918369697|emb|OZ237786.1| | 311461 | g68892 | i0 | 82.031 | 0.60377358490566 | 128 | 17 | 58 | 4 | 33 | 155 | 11097531 | 11097405 | Hirudo verbana genome assembly, chromosome: 8 | blastn | 128 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 21085772 | 21085772 | PRJNA700095_P_NODE_8817_length_664_cov_4.263959_g7621_i0 | PRJNA700095 | 8817 | 664 | 4.263959 | 28.31268776 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 238 | 6.87e-71 | NR | CAH1802338.1 | 6347 | g7621 | i0 | 61.5 | 2.54819277108434 | 192 | 71 | 86.3 | 3 | 2 | 574 | 445 | 634 | CAH1802338.1 unnamed protein product [Owenia fusiformis] | diamond | 1692 | 238 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 22360306 | 22360306 | PRJNA700095_P_NODE_22518_length_367_cov_1.204082_g21254_i0 | PRJNA700095 | 22518 | 367 | 1.204082 | 4.41898094 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.035 | NTclustered | gi|2920003456|emb|OZ238864.1| | 1046305 | g21254 | i0 | 100 | 0.0762942779291553 | 28 | 0 | 8 | 0 | 151 | 178 | 21052951 | 21052924 | Ailoscolex lacteospumosus genome assembly, chromosome: 5 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 22360517 | 22360517 | PRJNA700095_P_NODE_62038_length_243_cov_1.458824_g60774_i0 | PRJNA700095 | 62038 | 243 | 1.458824 | 3.54494232 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g60774 | i0 | 100 | 0.230452674897119 | 28 | 0 | 12 | 0 | 159 | 186 | 16973001 | 16972974 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 23636113 | 23636113 | PRJNA700095_P_NODE_39819_length_276_cov_1.975369_g38555_i0 | PRJNA700095 | 39819 | 276 | 1.975369 | 5.45201844 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 1.52e-4 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g38555 | i0 | 100 | 0.115942028985507 | 32 | 0 | 12 | 0 | 89 | 120 | 666423 | 666454 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 32 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 28893821 | 28893821 | PRJNA700095_P_NODE_24648_length_347_cov_1.251825_g23384_i0 | PRJNA700095 | 24648 | 347 | 1.251825 | 4.34383275 | Opisthokonta | 33154 | Annelida | Annelida | 73.6 | 1.93e-12 | NR | CAH1800435.1 | 6347 | g23384 | i0 | 37.2 | 1.96253602305476 | 113 | 49 | 97.7 | 3 | 345 | 7 | 484 | 574 | CAH1800435.1 unnamed protein product [Owenia fusiformis] | diamond | 681 | 74.3 | 0.990578734858681 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29450822 | 29450822 | PRJNA700095_P_NODE_14050_length_499_cov_1.309859_g12791_i0 | PRJNA700095 | 14050 | 499 | 1.309859 | 6.53619641 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 54.3 | 3.36e-5 | NR | CAD5115989.1 | 2664684 | g12791 | i0 | 27.6 | 1.79759519038076 | 152 | 80 | 89.6 | 3 | 490 | 44 | 137 | 261 | CAD5115989.1 DgyrCDS4925 [Dimorphilus gyrociliatus] | diamond | 897 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 31042150 | 31042150 | PRJNA700095_P_NODE_32855_length_297_cov_3.272321_g31591_i0 | PRJNA700095 | 32855 | 297 | 3.272321 | 9.71879337 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 106 | 2.01e-24 | NR | KAK2188786.1 | 27915 | g31591 | i0 | 62.5 | 6.77777777777778 | 80 | 30 | 80.8 | 0 | 242 | 3 | 3 | 82 | KAK2188786.1 hypothetical protein NP493_121g01009 [Ridgeia piscesae] | diamond | 2013 | 107 | 0.990654205607477 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 31104856 | 31104856 | PRJNA700095_P_NODE_5735_length_826_cov_2.347942_g4690_i0 | PRJNA700095 | 5735 | 826 | 2.347942 | 19.39400092 | Metazoa | 33208 | Annelida | Annelida | 185 | 4.39e-51 | NR | CAH1780581.1 | 6347 | g4690 | i0 | 56 | 3.05084745762712 | 166 | 67 | 60.3 | 1 | 327 | 824 | 70 | 229 | CAH1780581.1 unnamed protein product [Owenia fusiformis] | diamond | 2520 | 186 | 0.99462365591397806 | 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);;