contig_metadata
21 rows where bioproject = "PRJNA751877", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 726116 | 726116 | PRJNA751877_P_NODE_1161_length_706_cov_5.797788_g1044_i0 | PRJNA751877 | 1161 | 706 | 5.797788 | 40.93238328 | Hirudo nipponia | 42736 | Annelida | Annelida | 1303 | 0 | NTclustered | gi|2277007652|gb|MZ507570.1| | 42736 | g1044 | i0 | 100 | 76.2379603399433 | 705 | 0 | 99 | 0 | 2 | 706 | 12152 | 11448 | Hirudo nipponia mitochondrion, complete genome | blastn | 53824 | 1303 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo nipponia | |
| 726403 | 726403 | PRJNA751877_P_NODE_25041_length_248_cov_0.880000_g24919_i0 | PRJNA751877 | 25041 | 248 | 0.88 | 2.1824 | Hirudo verbana | 311461 | Annelida | Annelida | 161 | 3.5699999999999995e-35 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g24919 | i0 | 93.519 | 1.11290322580645 | 108 | 7 | 44 | 0 | 1 | 108 | 3697521 | 3697414 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 276 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 2002297 | 2002297 | PRJNA751877_P_NODE_18362_length_276_cov_1.137931_g18240_i0 | PRJNA751877 | 18362 | 276 | 1.137931 | 3.14068956 | Hirudo verbana | 311461 | Annelida | Annelida | 318 | 2.27e-82 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g18240 | i0 | 91.379 | 0.840579710144927 | 232 | 20 | 84 | 0 | 41 | 272 | 11877828 | 11877597 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 232 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 2002432 | 2002432 | PRJNA751877_P_NODE_24922_length_248_cov_0.880000_g24800_i0 | PRJNA751877 | 24922 | 248 | 0.88 | 2.1824 | Hirudo verbana | 311461 | Annelida | Annelida | 272 | 1.5799999999999996e-68 | NTclustered | gi|2918369706|emb|OZ237788.1| | 311461 | g24800 | i0 | 95.322 | 0.991935483870968 | 171 | 8 | 99 | 0 | 78 | 248 | 6313574 | 6313744 | Hirudo verbana genome assembly, chromosome: 10 | blastn | 246 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 3277519 | 3277519 | PRJNA751877_P_NODE_13623_length_311_cov_0.962185_g13501_i0 | PRJNA751877 | 13623 | 311 | 0.962185 | 2.99239535 | Hirudo verbana | 311461 | Annelida | Annelida | 270 | 7.3699999999999996e-68 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g13501 | i0 | 84.266 | 10.0257234726688 | 286 | 35 | 89 | 4 | 33 | 309 | 5103236 | 5103520 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 3118 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 3277748 | 3277748 | PRJNA751877_P_NODE_23883_length_249_cov_0.875000_g23761_i0 | PRJNA751877 | 23883 | 249 | 0.875 | 2.17875 | Hirudo verbana | 311461 | Annelida | Annelida | 93.5 | 1.33e-14 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g23761 | i0 | 92.308 | 7.37349397590361 | 65 | 5 | 26 | 0 | 1 | 65 | 9271396 | 9271332 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 1836 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 3277804 | 3277804 | PRJNA751877_P_NODE_26703_length_246_cov_0.861272_g26581_i0 | PRJNA751877 | 26703 | 246 | 0.861272 | 2.11872912 | Hirudo verbana | 311461 | Annelida | Annelida | 363 | 9.039999999999999e-96 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g26581 | i0 | 93.443 | 1.9349593495935 | 244 | 16 | 100 | 0 | 1 | 244 | 11630870 | 11630627 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 476 | 363 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 7105055 | 7105055 | PRJNA751877_P_NODE_22246_length_251_cov_0.865169_g22124_i0 | PRJNA751877 | 22246 | 251 | 0.865169 | 2.17157419 | Hirudo verbana | 311461 | Annelida | Annelida | 239 | 1.6300000000000002e-58 | NTclustered | gi|2918369706|emb|OZ237788.1| | 311461 | g22124 | i0 | 94.771 | 10.1474103585657 | 153 | 8 | 61 | 0 | 97 | 249 | 6003956 | 6004108 | Hirudo verbana genome assembly, chromosome: 10 | blastn | 2547 | 239 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 8379481 | 8379481 | PRJNA751877_P_NODE_14187_length_305_cov_3.551724_g14065_i0 | PRJNA751877 | 14187 | 305 | 3.551724 | 10.8327582 | Hirudo nipponia | 42736 | Annelida | Annelida | 564 | 2.95e-156 | NTclustered | gi|2277007652|gb|MZ507570.1| | 42736 | g14065 | i0 | 100 | 5.88852459016393 | 305 | 0 | 100 | 0 | 1 | 305 | 11035 | 11339 | Hirudo nipponia mitochondrion, complete genome | blastn | 1796 | 564 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo nipponia | |
| 10930345 | 10930345 | PRJNA751877_P_NODE_24749_length_248_cov_0.880000_g24627_i0 | PRJNA751877 | 24749 | 248 | 0.88 | 2.1824 | Hirudo verbana | 311461 | Annelida | Annelida | 274 | 4.399999999999999e-69 | NTclustered | gi|2918369620|emb|OZ237782.1| | 311461 | g24627 | i0 | 91.837 | 1.61693548387097 | 196 | 16 | 93 | 0 | 3 | 198 | 6036811 | 6037006 | Hirudo verbana genome assembly, chromosome: 4 | blastn | 401 | 274 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 10930429 | 10930429 | PRJNA751877_P_NODE_27909_length_244_cov_0.900585_g27787_i0 | PRJNA751877 | 27909 | 244 | 0.900585 | 2.1974274 | Hirudo nipponia | 42736 | Annelida | Annelida | 451 | 1.86e-122 | NTclustered | gi|2277007652|gb|MZ507570.1| | 42736 | g27787 | i0 | 100 | 44.4918032786885 | 244 | 0 | 100 | 0 | 1 | 244 | 1245 | 1488 | Hirudo nipponia mitochondrion, complete genome | blastn | 10856 | 451 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo nipponia | |
| 14754971 | 14754971 | PRJNA751877_P_NODE_11612_length_330_cov_1.412451_g11490_i0 | PRJNA751877 | 11612 | 330 | 1.412451 | 4.6610883 | Hirudo nipponia | 42736 | Annelida | Annelida | 610 | 4.09e-170 | NTclustered | gi|2277007652|gb|MZ507570.1| | 42736 | g11490 | i0 | 100 | 97.0606060606061 | 330 | 0 | 100 | 0 | 1 | 330 | 669 | 998 | Hirudo nipponia mitochondrion, complete genome | blastn | 32030 | 610 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo nipponia | |
| 14755395 | 14755395 | PRJNA751877_P_NODE_30292_length_241_cov_0.916667_g30170_i0 | PRJNA751877 | 30292 | 241 | 0.916667 | 2.20916747 | Hirudo verbana | 311461 | Annelida | Annelida | 230 | 9.34e-56 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g30170 | i0 | 84.711 | 1.00414937759336 | 242 | 23 | 99 | 10 | 3 | 241 | 9924466 | 9924696 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 242 | 230 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 16029031 | 16029031 | PRJNA751877_P_NODE_23073_length_250_cov_0.870056_g22951_i0 | PRJNA751877 | 23073 | 250 | 0.870056 | 2.17514 | Hirudo nipponia | 42736 | Annelida | Annelida | 451 | 1.91e-122 | NTclustered | gi|13432025|gb|AF223972.2|AF223972 | 42736 | g22951 | i0 | 99.2 | 2.596 | 250 | 2 | 100 | 0 | 1 | 250 | 250 | 1 | Hirudo nipponia non-classical Kazal type inhibitor bdellin-KL (Bdellin-KL) mRNA, complete cds | blastn | 649 | 451 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo nipponia | |
| 18577971 | 18577971 | PRJNA751877_P_NODE_17835_length_279_cov_1.203883_g17713_i0 | PRJNA751877 | 17835 | 279 | 1.203883 | 3.35883357 | Hirudo verbana | 311461 | Annelida | Annelida | 165 | 3.16e-36 | NTclustered | gi|2918369613|emb|OZ237779.1| | 311461 | g17713 | i0 | 92.241 | 1.06451612903226 | 116 | 9 | 99 | 0 | 164 | 279 | 5215841 | 5215726 | Hirudo verbana genome assembly, chromosome: 1 | blastn | 297 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 19853348 | 19853348 | PRJNA751877_P_NODE_18476_length_275_cov_1.331683_g18354_i0 | PRJNA751877 | 18476 | 275 | 1.331683 | 3.66212825 | Hirudo verbana | 311461 | Annelida | Annelida | 139 | 1.8899999999999999e-28 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g18354 | i0 | 90.476 | 1.92363636363636 | 105 | 10 | 46 | 0 | 149 | 253 | 4961256 | 4961152 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 529 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 21128834 | 21128834 | PRJNA751877_P_NODE_19237_length_270_cov_1.365482_g19115_i0 | PRJNA751877 | 19237 | 270 | 1.365482 | 3.6868014 | Hirudo verbana | 311461 | Annelida | Annelida | 134 | 8.590000000000001e-27 | NTclustered | gi|2918369614|emb|OZ237780.1| | 311461 | g19115 | i0 | 93.333 | 0.333333333333333 | 90 | 6 | 33 | 0 | 181 | 270 | 5149466 | 5149555 | Hirudo verbana genome assembly, chromosome: 2 | blastn | 90 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 21128963 | 21128963 | PRJNA751877_P_NODE_24957_length_248_cov_0.880000_g24835_i0 | PRJNA751877 | 24957 | 248 | 0.88 | 2.1824 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 82.4 | 4.06e-16 | NR | KAI0231143.1 | 104711 | g24835 | i0 | 48.6 | 23.4193548387097 | 74 | 35 | 89.5 | 1 | 25 | 246 | 211 | 281 | KAI0231143.1 Serine/threonine-protein phosphatase 4 catalytic subunit [Lamellibrachia satsuma] | diamond | 5808 | 83.2 | 0.990384615384615 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 26745805 | 26745805 | PRJNA751877_P_NODE_26801_length_245_cov_1.343023_g26679_i0 | PRJNA751877 | 26801 | 245 | 1.343023 | 3.29040635 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 107 | 6.22e-28 | NR | ABW90363.1 | 6446 | g26679 | i0 | 65 | 15.330612244898 | 80 | 28 | 98 | 0 | 242 | 3 | 8 | 87 | ABW90363.1 putative ribosomal protein L31 [Sipunculus nudus] | diamond | 3756 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Annelida | Sipuncula | Golfingiida | Sipunculidae | Sipunculus | Sipunculus nudus | |
| 26799545 | 26799545 | PRJNA751877_P_NODE_30041_length_241_cov_0.916667_g29919_i0 | PRJNA751877 | 30041 | 241 | 0.916667 | 2.20916747 | Helobdella robusta | 6412 | Annelida | Annelida | 106 | 3.44e-25 | NR | XP_009021338.1 | 6412 | g29919 | i0 | 98.1 | 1.94190871369295 | 52 | 1 | 64.7 | 0 | 85 | 240 | 20 | 71 | XP_009021338.1 hypothetical protein HELRODRAFT_185764 [Helobdella robusta] | diamond | 468 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 32329366 | 32329366 | PRJNA751877_P_NODE_16819_length_285_cov_1.339623_g16697_i0 | PRJNA751877 | 16819 | 285 | 1.339623 | 3.81792555 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 50.4 | 1.11e-4 | NR | KAK2153876.1 | 53620 | g16697 | i0 | 33.3 | 0.978947368421053 | 93 | 48 | 97.9 | 2 | 280 | 2 | 152 | 230 | KAK2153876.1 hypothetical protein LSH36_282g02013 [Paralvinella palmiformis] | diamond | 279 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis |
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);;