contig_metadata
21 rows where bioproject = "PRJNA874604" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11055466 | 11055466 | PRJNA874604_P_NODE_35969_length_322_cov_1.236948_g35617_i0 | PRJNA874604 | 35969 | 322 | 1.236948 | 3.98297256 | Arenicola marina | 6344 | Annelida | Annelida | 139 | 2.26e-28 | NTclustered | gi|158187777|gb|EU124973.1| | 6344 | g35617 | i0 | 77.586 | 58.0496894409938 | 232 | 48 | 71 | 2 | 9 | 238 | 295 | 524 | Arenicola marina ribosomal protein rpl23a mRNA, partial cds | blastn | 18692 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Arenicolidae | Arenicola | Arenicola marina | ||
| 13606385 | 13606385 | PRJNA874604_P_NODE_87171_length_245_cov_0.895349_g86819_i0 | PRJNA874604 | 87171 | 245 | 0.895349 | 2.19360505 | Hirudo verbana | 311461 | Annelida | Annelida | 132 | 2.76e-26 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g86819 | i0 | 95.181 | 0.338775510204082 | 83 | 4 | 34 | 0 | 163 | 245 | 9457500 | 9457418 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 83 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 13606484 | 13606484 | PRJNA874604_P_NODE_91751_length_244_cov_0.894737_g91399_i0 | PRJNA874604 | 91751 | 244 | 0.894737 | 2.18315828 | Hirudo verbana | 311461 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g91399 | i0 | 100 | 0.364754098360656 | 30 | 0 | 12 | 0 | 139 | 168 | 13017538 | 13017567 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 89 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 17429996 | 17429996 | PRJNA874604_P_NODE_40014_length_309_cov_1.631356_g39662_i0 | PRJNA874604 | 40014 | 309 | 1.631356 | 5.04089004 | Owenia fusiformis | 6347 | Annelida | Annelida | 109 | 6.630000000000001e-26 | NR | CAH1773728.1 | 6347 | g39662 | i0 | 48.5 | 1 | 103 | 49 | 96.1 | 1 | 308 | 12 | 300 | 402 | CAH1773728.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 309 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 21254840 | 21254840 | PRJNA874604_P_NODE_88837_length_245_cov_0.866279_g88485_i0 | PRJNA874604 | 88837 | 245 | 0.866279 | 2.12238355 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g88485 | i0 | 100 | 0.355102040816327 | 29 | 0 | 12 | 0 | 27 | 55 | 2229992 | 2229964 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 87 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 25077807 | 25077807 | PRJNA874604_P_NODE_35560_length_323_cov_1.808000_g35208_i0 | PRJNA874604 | 35560 | 323 | 1.808 | 5.83984 | Helobdella robusta | 6412 | Annelida | Annelida | 155 | 4.78e-45 | NR | XP_009019956.1 | 6412 | g35208 | i0 | 72 | 47.1733746130031 | 107 | 30 | 99.4 | 0 | 2 | 322 | 95 | 201 | XP_009019956.1 hypothetical protein HELRODRAFT_161829 [Helobdella robusta] | diamond | 15237 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 25078388 | 25078388 | PRJNA874604_P_NODE_65620_length_256_cov_1.360656_g65268_i0 | PRJNA874604 | 65620 | 256 | 1.360656 | 3.48327936 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 5e-4 | NTclustered | gi|2920003608|emb|OZ238872.1| | 1046305 | g65268 | i0 | 97.059 | 5.05078125 | 34 | 1 | 13 | 0 | 53 | 86 | 6507785 | 6507818 | Ailoscolex lacteospumosus genome assembly, chromosome: 13 | blastn | 1293 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 26643550 | 26643550 | PRJNA874604_P_NODE_36221_length_321_cov_1.241935_g35869_i0 | PRJNA874604 | 36221 | 321 | 1.241935 | 3.98661135 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 82.8 | 8.46e-16 | NR | KAK2161192.1 | 53620 | g35869 | i0 | 36.5 | 2.05607476635514 | 115 | 65 | 100 | 1 | 1 | 321 | 204 | 318 | KAK2161192.1 hypothetical protein LSH36_120g11029 [Paralvinella palmiformis] | diamond | 660 | 82.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 27094889 | 27094889 | PRJNA874604_P_NODE_37682_length_316_cov_1.806584_g37330_i0 | PRJNA874604 | 37682 | 316 | 1.806584 | 5.70880544 | Metazoa | 33208 | Annelida | Annelida | 100 | 3.4000000000000003e-22 | NR | CAH1801949.1 | 6347 | g37330 | i0 | 50.5 | 1.82278481012658 | 99 | 45 | 94 | 1 | 6 | 302 | 432 | 526 | CAH1801949.1 unnamed protein product [Owenia fusiformis] | diamond | 576 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29107976 | 29107976 | PRJNA874604_P_NODE_89688_length_244_cov_0.900585_g89336_i0 | PRJNA874604 | 89688 | 244 | 0.900585 | 2.1974274 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 40.4 | 0.0409 | NR | KAK2156626.1 | 53620 | g89336 | i0 | 43.5 | 0.565573770491803 | 46 | 25 | 55.3 | 1 | 152 | 18 | 23 | 68 | KAK2156626.1 hypothetical protein LSH36_208g00000 [Paralvinella palmiformis] | diamond | 138 | 40.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 29210828 | 29210828 | PRJNA874604_P_NODE_63069_length_260_cov_2.106952_g62717_i0 | PRJNA874604 | 63069 | 260 | 2.106952 | 5.4780752 | Opisthokonta | 33154 | Annelida | Annelida | 45.1 | 0.00721 | NR | KAK2165061.1 | 53620 | g62717 | i0 | 30.1 | 2.91923076923077 | 83 | 50 | 90 | 2 | 236 | 3 | 1163 | 1242 | KAK2165061.1 hypothetical protein LSH36_55g03001 [Paralvinella palmiformis] | diamond | 759 | 45.4 | 0.993392070484582 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 29242274 | 29242274 | PRJNA874604_P_NODE_73029_length_250_cov_0.870056_g72677_i0 | PRJNA874604 | 73029 | 250 | 0.870056 | 2.17514 | Metazoa | 33208 | Annelida | Annelida | 128 | 2.89e-34 | NR | ELT97074.1 | 283909 | g72677 | i0 | 70.2 | 9.06 | 84 | 24 | 99.6 | 1 | 1 | 249 | 82 | 165 | ELT97074.1 hypothetical protein CAPTEDRAFT_151499 [Capitella teleta] | diamond | 2265 | 129 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 29557824 | 29557824 | PRJNA874604_P_NODE_97290_length_242_cov_0.911243_g96938_i0 | PRJNA874604 | 97290 | 242 | 0.911243 | 2.20520806 | Metazoa | 33208 | Annelida | Annelida | 91.7 | 1.04e-21 | NR | CAH1787134.1 | 6347 | g96938 | i0 | 70.4 | 9.02479338842975 | 71 | 21 | 88 | 0 | 214 | 2 | 1 | 71 | CAH1787134.1 unnamed protein product [Owenia fusiformis] | diamond | 2184 | 92.4 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30023798 | 30023798 | PRJNA874604_P_NODE_11671_length_504_cov_2.858469_g11320_i0 | PRJNA874604 | 11671 | 504 | 2.858469 | 14.40668376 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 139 | 4.849999999999999e-37 | NR | KAK2142741.1 | 53620 | g11320 | i0 | 64.8 | 2.20238095238095 | 122 | 41 | 71.4 | 2 | 360 | 1 | 168 | 289 | KAK2142741.1 hypothetical protein LSH36_919g01064 [Paralvinella palmiformis] | diamond | 1110 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 30244945 | 30244945 | PRJNA874604_P_NODE_67072_length_253_cov_1.711111_g66720_i0 | PRJNA874604 | 67072 | 253 | 1.711111 | 4.32911083 | Owenia fusiformis | 6347 | Annelida | Annelida | 57 | 2.2e-7 | NR | CAH1798685.1 | 6347 | g66720 | i0 | 42.9 | 0.99604743083004 | 84 | 45 | 99.6 | 1 | 252 | 1 | 82 | 162 | CAH1798685.1 unnamed protein product [Owenia fusiformis] | diamond | 252 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30758438 | 30758438 | PRJNA874604_P_NODE_71414_length_250_cov_1.305085_g71062_i0 | PRJNA874604 | 71414 | 250 | 1.305085 | 3.2627125 | Metazoa | 33208 | Annelida | Annelida | 83.2 | 1.4e-16 | NR | XP_009012070.1 | 6412 | g71062 | i0 | 64.6 | 3.9 | 65 | 21 | 75.6 | 1 | 1 | 189 | 299 | 363 | XP_009012070.1 hypothetical protein HELRODRAFT_185327 [Helobdella robusta] | diamond | 975 | 83.6 | 0.995215311004785 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 30845183 | 30845183 | PRJNA874604_P_NODE_75714_length_249_cov_0.875000_g75362_i0 | PRJNA874604 | 75714 | 249 | 0.875 | 2.17875 | Helobdella robusta | 6412 | Annelida | Annelida | 69.3 | 1.82e-11 | NR | XP_009018294.1 | 6412 | g75362 | i0 | 41.6 | 1.91566265060241 | 77 | 45 | 92.8 | 0 | 231 | 1 | 1038 | 1114 | XP_009018294.1 hypothetical protein HELRODRAFT_191944 [Helobdella robusta] | diamond | 477 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 32426452 | 32426452 | PRJNA874604_P_NODE_42259_length_303_cov_1.004348_g41907_i0 | PRJNA874604 | 42259 | 303 | 1.004348 | 3.04317444 | Capitella teleta | 283909 | Annelida | Annelida | 86.3 | 3.94e-17 | NR | ELU05692.1 | 283909 | g41907 | i0 | 46.3 | 2.84158415841584 | 95 | 50 | 94.1 | 1 | 302 | 18 | 602 | 695 | ELU05692.1 hypothetical protein CAPTEDRAFT_168822 [Capitella teleta] | diamond | 861 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 32489866 | 32489866 | PRJNA874604_P_NODE_81539_length_247_cov_0.885057_g81187_i0 | PRJNA874604 | 81539 | 247 | 0.885057 | 2.18609079 | Capitella teleta | 283909 | Annelida | Annelida | 59.7 | 4.32e-8 | NR | ELT87809.1 | 283909 | g81187 | i0 | 59.6 | 0.631578947368421 | 52 | 21 | 63.2 | 0 | 166 | 11 | 1922 | 1973 | ELT87809.1 hypothetical protein CAPTEDRAFT_215541 [Capitella teleta] | diamond | 156 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 32497957 | 32497957 | PRJNA874604_P_NODE_85979_length_245_cov_1.790698_g85627_i0 | PRJNA874604 | 85979 | 245 | 1.790698 | 4.3872101 | Opisthokonta | 33154 | Annelida | Annelida | 57.4 | 2.31e-8 | NR | KAI0227703.1 | 104711 | g85627 | i0 | 63.4 | 2.42448979591837 | 41 | 14 | 50.2 | 1 | 124 | 2 | 6 | 45 | KAI0227703.1 Eukaryotic translation initiation factor eIF1 [Lamellibrachia satsuma] | diamond | 594 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 32616027 | 32616027 | PRJNA874604_P_NODE_86800_length_245_cov_0.895349_g86448_i0 | PRJNA874604 | 86800 | 245 | 0.895349 | 2.19360505 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 43.1 | 0.0285 | NR | KAI0239940.1 | 104711 | g86448 | i0 | 60.7 | 0.342857142857143 | 28 | 11 | 34.3 | 0 | 105 | 22 | 465 | 492 | KAI0239940.1 Protein FAM13A [Lamellibrachia satsuma] | diamond | 84 | 43.1 | 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);;