contig_metadata
15 rows where bioproject = "PRJNA1102048", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2762501 | 2762501 | PRJNA1102048_P_NODE_8543_length_297_cov_1.375000_g8439_i0 | PRJNA1102048 | 8543 | 297 | 1.375 | 4.08375 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 1.65e-4 | NTclustered | gi|2918369720|emb|OZ237792.1| | 311461 | g8439 | i0 | 94.737 | 1.76767676767677 | 38 | 2 | 13 | 0 | 46 | 83 | 7753600 | 7753563 | Hirudo verbana genome assembly, chromosome: 14 | blastn | 525 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 8673238 | 8673238 | PRJNA1102048_P_NODE_16927_length_242_cov_1.763314_g16823_i0 | PRJNA1102048 | 16927 | 242 | 1.763314 | 4.26721988 | Clitellata | 42113 | Annelida | Annelida | 54.7 | 0.006 | NTclustered | gi|2918369693|emb|OZ237785.1| | 311461 | g16823 | i0 | 100 | 1.19834710743802 | 29 | 0 | 12 | 0 | 82 | 110 | 698614 | 698586 | Hirudo verbana genome assembly, chromosome: 7 | blastn | 290 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 12965644 | 12965644 | PRJNA1102048_P_NODE_811_length_801_cov_5.081044_g722_i0 | PRJNA1102048 | 811 | 801 | 5.081044 | 40.69916244 | Metazoa | 33208 | Annelida | Annelida | 304 | 9.36e-100 | NR | KAK2146210.1 | 53620 | g722 | i0 | 69.2 | 16.1535580524345 | 208 | 64 | 77.9 | 0 | 785 | 162 | 6 | 213 | KAK2146210.1 hypothetical protein LSH36_624g01057 [Paralvinella palmiformis] | diamond | 12939 | 305 | 0.99672131147541 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 16788857 | 16788857 | PRJNA1102048_P_NODE_17494_length_241_cov_1.190476_g17390_i0 | PRJNA1102048 | 17494 | 241 | 1.190476 | 2.86904716 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 69.4 | 2.15e-7 | NTclustered | gi|2920003508|emb|OZ238866.1| | 1046305 | g17390 | i0 | 97.5 | 153.385892116183 | 40 | 1 | 20 | 0 | 121 | 160 | 26418807 | 26418846 | Ailoscolex lacteospumosus genome assembly, chromosome: 7 | blastn | 36966 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 24437582 | 24437582 | PRJNA1102048_P_NODE_11040_length_267_cov_1.262887_g10936_i0 | PRJNA1102048 | 11040 | 267 | 1.262887 | 3.37190829 | Randiella sp. FB-2019 | 2507462 | Annelida | Annelida | 65.8 | 3.14e-6 | NTclustered | gi|1561760516|gb|MK011238.1| | 2507462 | g10936 | i0 | 100 | 0.131086142322097 | 35 | 0 | 13 | 0 | 113 | 147 | 890 | 856 | Randiella sp. FB-2019 hemoglobin linker chain mRNA, partial cds | blastn | 35 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Randiellida | Randiellidae | Randiella | Randiella sp. FB-2019 | |
| 27722799 | 27722799 | PRJNA1102048_P_NODE_7424_length_318_cov_1.885714_g7320_i0 | PRJNA1102048 | 7424 | 318 | 1.885714 | 5.99657052 | Metazoa | 33208 | Annelida | Annelida | 114 | 1.95e-27 | NR | CAH1773728.1 | 6347 | g7320 | i0 | 64.1 | 3.78301886792453 | 78 | 25 | 70.8 | 1 | 93 | 317 | 171 | 248 | CAH1773728.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 1203 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27731394 | 27731394 | PRJNA1102048_P_NODE_6644_length_335_cov_3.519084_g6540_i0 | PRJNA1102048 | 6644 | 335 | 3.519084 | 11.7889314 | Helobdella robusta | 6412 | Annelida | Annelida | 142 | 2.88e-40 | NR | XP_009014586.1 | 6412 | g6540 | i0 | 64 | 1.99701492537313 | 111 | 37 | 99.4 | 1 | 333 | 1 | 47 | 154 | XP_009014586.1 hypothetical protein HELRODRAFT_110719 [Helobdella robusta] | diamond | 669 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 28078291 | 28078291 | PRJNA1102048_P_NODE_5805_length_357_cov_3.535211_g5701_i0 | PRJNA1102048 | 5805 | 357 | 3.535211 | 12.62070327 | Capitella teleta | 283909 | Annelida | Annelida | 109 | 3.3500000000000006e-27 | NR | ELU11053.1 | 283909 | g5701 | i0 | 57.7 | 0.932773109243697 | 111 | 47 | 93.3 | 0 | 357 | 25 | 94 | 204 | ELU11053.1 hypothetical protein CAPTEDRAFT_183211 [Capitella teleta] | diamond | 333 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 28858929 | 28858929 | PRJNA1102048_P_NODE_13948_length_249_cov_0.863636_g13844_i0 | PRJNA1102048 | 13948 | 249 | 0.863636 | 2.15045364 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 46.2 | 0.00235 | NR | ELU09794.1 | 283909 | g13844 | i0 | 31.6 | 5.79518072289157 | 79 | 46 | 95.2 | 1 | 248 | 12 | 291 | 361 | ELU09794.1 hypothetical protein CAPTEDRAFT_169940 [Capitella teleta] | diamond | 1443 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 30312236 | 30312236 | PRJNA1102048_P_NODE_11092_length_266_cov_1.595855_g10988_i0 | PRJNA1102048 | 11092 | 266 | 1.595855 | 4.2449743 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 80.5 | 6.04e-16 | NR | KAI0217810.1 | 104711 | g10988 | i0 | 51.1 | 2.96616541353383 | 88 | 42 | 98.1 | 1 | 6 | 266 | 42 | 129 | KAI0217810.1 putative bifunctional dTTP/UTP pyrophosphatase/methyltransferase protein [Lamellibrachia satsuma] | diamond | 789 | 80.9 | 0.995055624227441 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 30564195 | 30564195 | PRJNA1102048_P_NODE_7593_length_315_cov_1.909091_g7489_i0 | PRJNA1102048 | 7593 | 315 | 1.909091 | 6.01363665 | Metazoa | 33208 | Annelida | Annelida | 71.6 | 6.22e-12 | NR | CAH1795347.1 | 6347 | g7489 | i0 | 39 | 7.73333333333333 | 100 | 56 | 93.3 | 3 | 3 | 296 | 607 | 703 | CAH1795347.1 unnamed protein product [Owenia fusiformis] | diamond | 2436 | 72 | 0.994444444444444 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30572936 | 30572936 | PRJNA1102048_P_NODE_16433_length_243_cov_1.682353_g16329_i0 | PRJNA1102048 | 16433 | 243 | 1.682353 | 4.08811779 | Ridgeia piscesae | 27915 | Annelida | Annelida | 50.4 | 6.79e-5 | NR | KAK2183154.1 | 27915 | g16329 | i0 | 37.9 | 0.814814814814815 | 66 | 39 | 81.5 | 1 | 21 | 218 | 118 | 181 | KAK2183154.1 hypothetical protein NP493_322g01013 [Ridgeia piscesae] | diamond | 198 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 32059139 | 32059139 | PRJNA1102048_P_NODE_9438_length_285_cov_1.084906_g9334_i0 | PRJNA1102048 | 9438 | 285 | 1.084906 | 3.0919821 | Ridgeia piscesae | 27915 | Annelida | Annelida | 84.3 | 2.02e-18 | NR | KAK2192663.1 | 27915 | g9334 | i0 | 52.9 | 0.715789473684211 | 68 | 27 | 67.4 | 2 | 94 | 285 | 23 | 89 | KAK2192663.1 hypothetical protein NP493_25g00038 [Ridgeia piscesae] | diamond | 204 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 32839997 | 32839997 | PRJNA1102048_P_NODE_5340_length_372_cov_1.244147_g5236_i0 | PRJNA1102048 | 5340 | 372 | 1.244147 | 4.62822684 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 53.5 | 2.68e-5 | NR | KAK2153378.1 | 53620 | g5236 | i0 | 45 | 3.65322580645161 | 60 | 31 | 48.4 | 1 | 177 | 356 | 5 | 62 | KAK2153378.1 hypothetical protein LSH36_299g03010 [Paralvinella palmiformis] | diamond | 1359 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 32848780 | 32848780 | PRJNA1102048_P_NODE_7480_length_317_cov_2.155738_g7376_i0 | PRJNA1102048 | 7480 | 317 | 2.155738 | 6.83368946 | Ridgeia piscesae | 27915 | Annelida | Annelida | 43.9 | 0.0347 | NR | KAK2183706.1 | 27915 | g7376 | i0 | 54.3 | 0.331230283911672 | 35 | 16 | 33.1 | 0 | 107 | 3 | 566 | 600 | KAK2183706.1 hypothetical protein NP493_299g03061 [Ridgeia piscesae] | diamond | 105 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae |
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);;