contig_metadata
18 rows where bioproject = "PRJNA1041773" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7822647 | 7822647 | PRJNA1041773_P_NODE_22527_length_438_cov_1.131507_g22196_i0 | PRJNA1041773 | 22527 | 438 | 1.131507 | 4.95600066 | Loimia sp. RM-2022 | 2927651 | Annelida | Annelida | 65.8 | 5.44e-6 | NTclustered | gi|2209439381|gb|ON017366.1| | 2927651 | g22196 | i0 | 97.368 | 0.0867579908675799 | 38 | 1 | 9 | 0 | 7 | 44 | 59 | 22 | Loimia sp. RM-2022 isolate R5 small subunit ribosomal RNA gene, partial sequence | blastn | 38 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Terebellidae | Loimia | Loimia sp. RM-2022 | |
| 13761782 | 13761782 | PRJNA1041773_P_NODE_36671_length_348_cov_1.640000_g36338_i0 | PRJNA1041773 | 36671 | 348 | 1.64 | 5.7072 | Aglaophamus | 311529 | Annelida | Annelida | 534 | 2.679999999999999e-147 | NTclustered | gi|289470457|gb|GU179386.1| | 329459 | g36338 | i0 | 94.302 | 81.3362068965517 | 351 | 16 | 100 | 3 | 1 | 348 | 795 | 446 | Aglaophamus malmgreni voucher MB36000133 28S ribosomal RNA gene, partial sequence | blastn | 28305 | 534 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nephtyidae | Aglaophamus | Aglaophamus malmgreni | |
| 18022909 | 18022909 | PRJNA1041773_P_NODE_92655_length_244_cov_2.491228_g92322_i0 | PRJNA1041773 | 92655 | 244 | 2.491228 | 6.07859632 | Aglaophamus circinata | 397538 | Annelida | Annelida | 440 | 4.019999999999999e-119 | NTclustered | gi|111559285|gb|DQ790020.1| | 397538 | g92322 | i0 | 99.18 | 99.6147540983606 | 244 | 2 | 100 | 0 | 1 | 244 | 2210 | 2453 | Aglaophamus circinata 28S large subunit ribosomal RNA gene, partial sequence | blastn | 24306 | 440 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nephtyidae | Aglaophamus | Aglaophamus circinata | |
| 19296714 | 19296714 | PRJNA1041773_P_NODE_83136_length_249_cov_0.875000_g82803_i0 | PRJNA1041773 | 83136 | 249 | 0.875 | 2.17875 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.002 | NTclustered | gi|2920003527|emb|OZ238867.1| | 1046305 | g82803 | i0 | 89.362 | 0.301204819277108 | 47 | 2 | 18 | 3 | 48 | 91 | 25213103 | 25213149 | Ailoscolex lacteospumosus genome assembly, chromosome: 8 | blastn | 75 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 26710294 | 26710294 | PRJNA1041773_P_NODE_61641_length_277_cov_0.774510_g61308_i0 | PRJNA1041773 | 61641 | 277 | 0.77451 | 2.1453927 | root | 1 | Root_unresolved | Root_unresolved | 63.5 | 2.31e-9 | NR | KAK2170054.1 | 27915 | g61308 | i0 | 42.9 | 0.996389891696751 | 56 | 32 | 60.6 | 0 | 51 | 218 | 163 | 218 | KAK2170054.1 hypothetical protein NP493_1165g00046 [Ridgeia piscesae] | diamond | 276 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 26749905 | 26749905 | PRJNA1041773_P_NODE_84421_length_248_cov_0.880000_g84088_i0 | PRJNA1041773 | 84421 | 248 | 0.88 | 2.1824 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 41.2 | 0.0471 | NR | KAI0223263.1 | 104711 | g84088 | i0 | 70.4 | 0.326612903225806 | 27 | 8 | 32.7 | 0 | 188 | 108 | 77 | 103 | KAI0223263.1 hypothetical protein LSAT2_025534, partial [Lamellibrachia satsuma] | diamond | 81 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 26845553 | 26845553 | PRJNA1041773_P_NODE_100621_length_241_cov_0.916667_g100288_i0 | PRJNA1041773 | 100621 | 241 | 0.916667 | 2.20916747 | Owenia fusiformis | 6347 | Annelida | Annelida | 50.4 | 6.67e-5 | NR | CAH1786753.1 | 6347 | g100288 | i0 | 47.8 | 0.572614107883817 | 46 | 24 | 57.3 | 0 | 239 | 102 | 413 | 458 | CAH1786753.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 138 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27121671 | 27121671 | PRJNA1041773_P_NODE_32262_length_369_cov_1.287162_g31930_i0 | PRJNA1041773 | 32262 | 369 | 1.287162 | 4.74962778 | root | 1 | Root_unresolved | Root_unresolved | 47.8 | 0.00236 | NR | KAK2154599.1 | 27915 | g31930 | i0 | 71.4 | 6.36585365853659 | 28 | 8 | 22.8 | 0 | 139 | 56 | 29 | 56 | KAK2154599.1 hypothetical protein NP493_2167g00018 [Ridgeia piscesae] | diamond | 2349 | 48.1 | 0.993762993762994 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 27446315 | 27446315 | PRJNA1041773_P_NODE_94583_length_244_cov_0.900585_g94250_i0 | PRJNA1041773 | 94583 | 244 | 0.900585 | 2.1974274 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 51.6 | 2.64e-5 | NR | KAI0232794.1 | 104711 | g94250 | i0 | 67.6 | 0.418032786885246 | 34 | 11 | 41.8 | 0 | 212 | 111 | 291 | 324 | KAI0232794.1 GDP-fucose protein O-fucosyltransferase 1 [Lamellibrachia satsuma] | diamond | 102 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 28077421 | 28077421 | PRJNA1041773_P_NODE_78285_length_251_cov_0.865169_g77952_i0 | PRJNA1041773 | 78285 | 251 | 0.865169 | 2.17157419 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 76.3 | 2.08e-15 | NR | KAI0229585.1 | 104711 | g77952 | i0 | 72.7 | 4.20717131474104 | 44 | 12 | 52.6 | 0 | 132 | 1 | 67 | 110 | KAI0229585.1 hypothetical protein LSAT2_019978, partial [Lamellibrachia satsuma] | diamond | 1056 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 28298464 | 28298464 | PRJNA1041773_P_NODE_52926_length_295_cov_0.851351_g52593_i0 | PRJNA1041773 | 52926 | 295 | 0.851351 | 2.51148545 | Capitella teleta | 283909 | Annelida | Annelida | 49.7 | 2.17e-4 | NR | ELU04211.1 | 283909 | g52593 | i0 | 44.4 | 0.549152542372881 | 54 | 30 | 54.9 | 0 | 163 | 2 | 224 | 277 | ELU04211.1 hypothetical protein CAPTEDRAFT_121441 [Capitella teleta] | diamond | 162 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 28930046 | 28930046 | PRJNA1041773_P_NODE_101728_length_241_cov_0.916667_g101395_i0 | PRJNA1041773 | 101728 | 241 | 0.916667 | 2.20916747 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 58.5 | 1.01e-7 | NR | KAK2156034.1 | 53620 | g101395 | i0 | 73.3 | 0.37344398340249 | 30 | 8 | 37.3 | 0 | 89 | 178 | 311 | 340 | KAK2156034.1 hypothetical protein LSH36_223g01066 [Paralvinella palmiformis] | diamond | 90 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 30193096 | 30193096 | PRJNA1041773_P_NODE_77832_length_251_cov_0.865169_g77499_i0 | PRJNA1041773 | 77832 | 251 | 0.865169 | 2.17157419 | Capitella teleta | 283909 | Annelida | Annelida | 65.9 | 2.75e-10 | NR | ELU04210.1 | 283909 | g77499 | i0 | 43.9 | 0.9800796812749 | 82 | 46 | 98 | 0 | 6 | 251 | 116 | 197 | ELU04210.1 hypothetical protein CAPTEDRAFT_203582 [Capitella teleta] | diamond | 246 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 31259497 | 31259497 | PRJNA1041773_P_NODE_47735_length_309_cov_1.084746_g47402_i0 | PRJNA1041773 | 47735 | 309 | 1.084746 | 3.35186514 | Metazoa | 33208 | Annelida | Annelida | 114 | 5.9000000000000005e-27 | NR | KAI0217658.1 | 104711 | g47402 | i0 | 53.8 | 5.81553398058252 | 91 | 42 | 88.3 | 0 | 275 | 3 | 721 | 811 | KAI0217658.1 hypothetical protein LSAT2_030614, partial [Lamellibrachia satsuma] | diamond | 1797 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 31575880 | 31575880 | PRJNA1041773_P_NODE_75036_length_254_cov_1.640884_g74703_i0 | PRJNA1041773 | 75036 | 254 | 1.640884 | 4.16784536 | Metazoa | 33208 | Annelida | Annelida | 107 | 5.61e-25 | NR | KAI0217658.1 | 104711 | g74703 | i0 | 57.8 | 2.74015748031496 | 83 | 35 | 98 | 0 | 5 | 253 | 722 | 804 | KAI0217658.1 hypothetical protein LSAT2_030614, partial [Lamellibrachia satsuma] | diamond | 696 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 31607405 | 31607405 | PRJNA1041773_P_NODE_70256_length_262_cov_0.994709_g69923_i0 | PRJNA1041773 | 70256 | 262 | 0.994709 | 2.60613758 | Metazoa | 33208 | Annelida | Annelida | 63.9 | 1.67e-9 | NR | KAI0217658.1 | 104711 | g69923 | i0 | 53.3 | 2.06106870229008 | 60 | 24 | 68.7 | 2 | 2 | 181 | 919 | 974 | KAI0217658.1 hypothetical protein LSAT2_030614, partial [Lamellibrachia satsuma] | diamond | 540 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 31805151 | 31805151 | PRJNA1041773_P_NODE_101497_length_241_cov_0.916667_g101164_i0 | PRJNA1041773 | 101497 | 241 | 0.916667 | 2.20916747 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 67.4 | 5.34e-12 | NR | KAI0229585.1 | 104711 | g101164 | i0 | 63 | 1.14522821576763 | 46 | 17 | 57.3 | 0 | 103 | 240 | 65 | 110 | KAI0229585.1 hypothetical protein LSAT2_019978, partial [Lamellibrachia satsuma] | diamond | 276 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 31995055 | 31995055 | PRJNA1041773_P_NODE_51038_length_300_cov_0.859031_g50705_i0 | PRJNA1041773 | 51038 | 300 | 0.859031 | 2.577093 | Capitella teleta | 283909 | Annelida | Annelida | 49.7 | 1.92e-4 | NR | ELU13791.1 | 283909 | g50705 | i0 | 34.9 | 0.86 | 86 | 56 | 86 | 0 | 294 | 37 | 133 | 218 | ELU13791.1 hypothetical protein CAPTEDRAFT_213860 [Capitella teleta] | diamond | 258 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta |
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);;