contig_metadata
19 rows where bioproject = "PRJNA1063685", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2730389 | 2730389 | PRJNA1063685_S_NODE_7663_length_669_cov_17.001678_g7172_i0 | PRJNA1063685 | 7663 | 669 | 17.001678 | 113.74122582 | Hirudo verbana | 311461 | Annelida | Annelida | 65.8 | 8.56e-6 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g7172 | i0 | 100 | 3.33931240657698 | 35 | 0 | 5 | 0 | 467 | 501 | 9025701 | 9025667 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 2234 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 6557612 | 6557612 | PRJNA1063685_S_NODE_4546_length_746_cov_477.161961_g4125_i0 | PRJNA1063685 | 4546 | 746 | 477.161961 | 3559.62822906 | Hirudo verbana | 311461 | Annelida | Annelida | 60.2 | 4.47e-4 | NTclustered | gi|2918369702|emb|OZ237787.1| | 311461 | g4125 | i0 | 94.737 | 0.592493297587131 | 38 | 2 | 5 | 0 | 585 | 622 | 1192910 | 1192873 | Hirudo verbana genome assembly, chromosome: 9 | blastn | 442 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 6557731 | 6557731 | PRJNA1063685_S_NODE_62146_length_273_cov_1.325000_g61603_i0 | PRJNA1063685 | 62146 | 273 | 1.325 | 3.61725 | Hirudo verbana | 311461 | Annelida | Annelida | 54.7 | 0.007 | NTclustered | gi|2918369616|emb|OZ237781.1| | 311461 | g61603 | i0 | 100 | 0.106227106227106 | 29 | 0 | 11 | 0 | 47 | 75 | 12366435 | 12366407 | Hirudo verbana genome assembly, chromosome: 3 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 7832216 | 7832216 | PRJNA1063685_S_NODE_37627_length_381_cov_2.769481_g37084_i0 | PRJNA1063685 | 37627 | 381 | 2.769481 | 10.55172261 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.036 | NTclustered | gi|2918369643|emb|OZ237784.1| | 311461 | g37084 | i0 | 100 | 0.073490813648294 | 28 | 0 | 7 | 0 | 257 | 284 | 504391 | 504418 | Hirudo verbana genome assembly, chromosome: 6 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 12933331 | 12933331 | PRJNA1063685_S_NODE_37071_length_384_cov_3.819936_g36528_i0 | PRJNA1063685 | 37071 | 384 | 3.819936 | 14.66855424 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.037 | NTclustered | gi|2918369621|emb|OZ237783.1| | 311461 | g36528 | i0 | 100 | 0.21875 | 28 | 0 | 7 | 0 | 215 | 242 | 676105 | 676078 | Hirudo verbana genome assembly, chromosome: 5 | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 16314526 | 16314526 | PRJNA1063685_S_NODE_66813_length_259_cov_1.424731_g66270_i0 | PRJNA1063685 | 66813 | 259 | 1.424731 | 3.69005329 | Leptonerilla | 317905 | Annelida | Annelida | 207 | 4.76e-49 | NTclustered | gi|67541528|gb|AY834758.2| | 317906 | g66270 | i0 | 83.408 | 86.030888030888 | 223 | 37 | 86 | 0 | 1 | 223 | 801 | 1023 | Leptonerilla prospera 18S ribosomal RNA gene, partial sequence | blastn | 22282 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Nerillidae | Leptonerilla | Leptonerilla prospera | ||
| 19305430 | 19305430 | PRJNA1063685_S_NODE_5476_length_719_cov_10.051084_g5025_i0 | PRJNA1063685 | 5476 | 719 | 10.051084 | 72.26729396 | Metazoa | 33208 | Annelida | Annelida | 342 | 4.8e-112 | NR | CAH1796655.1 | 6347 | g5025 | i0 | 70.7 | 41.8456189151599 | 239 | 68 | 99.7 | 1 | 717 | 1 | 294 | 530 | CAH1796655.1 unnamed protein product [Owenia fusiformis] | diamond | 30087 | 342 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 19305522 | 19305522 | PRJNA1063685_S_NODE_6976_length_683_cov_10.911475_g6488_i0 | PRJNA1063685 | 6976 | 683 | 10.911475 | 74.52537425 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 56.5 | 0.005 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g6488 | i0 | 87.755 | 0.0717423133235725 | 49 | 5 | 7 | 1 | 350 | 398 | 14450832 | 14450785 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 49 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 23131717 | 23131717 | PRJNA1063685_S_NODE_20479_length_505_cov_5.828704_g19941_i0 | PRJNA1063685 | 20479 | 505 | 5.828704 | 29.4349552 | Helobdella robusta | 6412 | Annelida | Annelida | 52.8 | 0.049 | NTclustered | gi|675868781|ref|XM_009021703.1| | 6412 | g19941 | i0 | 100 | 0.0554455445544554 | 28 | 0 | 6 | 0 | 186 | 213 | 787 | 760 | Helobdella robusta hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 26615553 | 26615553 | PRJNA1063685_S_NODE_31061_length_421_cov_5.066092_g30519_i0 | PRJNA1063685 | 31061 | 421 | 5.066092 | 21.32824732 | Opisthokonta | 33154 | Annelida | Annelida | 52.4 | 1.13e-4 | NR | ELU00773.1 | 283909 | g30519 | i0 | 80.8 | 2.49406175771971 | 26 | 5 | 18.5 | 0 | 10 | 87 | 1003 | 1028 | ELU00773.1 hypothetical protein CAPTEDRAFT_224225 [Capitella teleta] | diamond | 1050 | 52.8 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 26972110 | 26972110 | PRJNA1063685_S_NODE_19162_length_518_cov_4.564045_g18625_i0 | PRJNA1063685 | 19162 | 518 | 4.564045 | 23.6417531 | Spirobranchus lamarcki | 2082999 | Annelida | Annelida | 246 | 1.9100000000000003e-79 | NR | ADB11399.1 | 2082999 | g18625 | i0 | 68.4 | 0.915057915057915 | 158 | 49 | 91.5 | 1 | 2 | 475 | 108 | 264 | ADB11399.1 bacterial endonuclease I-like protein, partial [Spirobranchus lamarcki] | diamond | 474 | 246 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Serpulidae | Spirobranchus | Spirobranchus lamarcki | |
| 28038092 | 28038092 | PRJNA1063685_S_NODE_2525_length_851_cov_10.417738_g2161_i0 | PRJNA1063685 | 2525 | 851 | 10.417738 | 88.65495038 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 237 | 4.35e-72 | NR | CAH1800309.1 | 6347 | g2161 | i0 | 47.6 | 14.1045828437133 | 267 | 135 | 92.4 | 4 | 1 | 786 | 134 | 400 | CAH1800309.1 unnamed protein product [Owenia fusiformis] | diamond | 12003 | 237 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28046198 | 28046198 | PRJNA1063685_S_NODE_45345_length_341_cov_1.242537_g44802_i0 | PRJNA1063685 | 45345 | 341 | 1.242537 | 4.23705117 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 144 | 5.15e-38 | NR | KAI0243020.1 | 104711 | g44802 | i0 | 67.3 | 5.83284457478006 | 110 | 35 | 96.8 | 1 | 332 | 3 | 59 | 167 | KAI0243020.1 T-complex protein 1 subunit delta [Lamellibrachia satsuma] | diamond | 1989 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 28235413 | 28235413 | PRJNA1063685_S_NODE_24146_length_473_cov_2.712500_g23606_i0 | PRJNA1063685 | 24146 | 473 | 2.7125 | 12.830125 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 85.5 | 5.4e-16 | NR | KAI0241744.1 | 104711 | g23606 | i0 | 38.6 | 1.80761099365751 | 132 | 77 | 82.5 | 3 | 6 | 395 | 477 | 606 | KAI0241744.1 ATP-dependent RNA helicase DDX54 [Lamellibrachia satsuma] | diamond | 855 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 28298764 | 28298764 | PRJNA1063685_S_NODE_7206_length_678_cov_11.090909_g6717_i0 | PRJNA1063685 | 7206 | 678 | 11.090909 | 75.19636302 | Spirobranchus lamarcki | 2082999 | Annelida | Annelida | 361 | 7.5599999999999985e-124 | NR | ADB11399.1 | 2082999 | g6717 | i0 | 72.9 | 0.946902654867257 | 214 | 57 | 94.7 | 1 | 2 | 643 | 52 | 264 | ADB11399.1 bacterial endonuclease I-like protein, partial [Spirobranchus lamarcki] | diamond | 642 | 361 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Serpulidae | Spirobranchus | Spirobranchus lamarcki | |
| 29498580 | 29498580 | PRJNA1063685_S_NODE_42350_length_356_cov_2.876325_g41807_i0 | PRJNA1063685 | 42350 | 356 | 2.876325 | 10.239717 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 125 | 1.5599999999999998e-31 | NR | CAD5124890.1 | 2664684 | g41807 | i0 | 50.9 | 2.91573033707865 | 116 | 56 | 97.8 | 1 | 348 | 1 | 272 | 386 | CAD5124890.1 DgyrCDS13142 [Dimorphilus gyrociliatus] | diamond | 1038 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 29656110 | 29656110 | PRJNA1063685_S_NODE_60690_length_277_cov_6.073529_g60147_i0 | PRJNA1063685 | 60690 | 277 | 6.073529 | 16.82367533 | Owenia fusiformis | 6347 | Annelida | Annelida | 43.5 | 0.028 | NR | CAH1775233.1 | 6347 | g60147 | i0 | 38.2 | 0.595667870036101 | 55 | 31 | 56.3 | 1 | 88 | 243 | 241 | 295 | CAH1775233.1 unnamed protein product [Owenia fusiformis] | diamond | 165 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 31520963 | 31520963 | PRJNA1063685_S_NODE_22036_length_490_cov_22.647482_g21497_i0 | PRJNA1063685 | 22036 | 490 | 22.647482 | 110.9726618 | Spirobranchus lamarcki | 2082999 | Annelida | Annelida | 241 | 1.79e-77 | NR | ADB11399.1 | 2082999 | g21497 | i0 | 70.2 | 0.924489795918367 | 151 | 44 | 92.4 | 1 | 466 | 14 | 1 | 150 | ADB11399.1 bacterial endonuclease I-like protein, partial [Spirobranchus lamarcki] | diamond | 453 | 241 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Serpulidae | Spirobranchus | Spirobranchus lamarcki | |
| 31670676 | 31670676 | PRJNA1063685_S_NODE_6117_length_702_cov_22.939587_g5644_i0 | PRJNA1063685 | 6117 | 702 | 22.939587 | 161.03590074 | Opisthokonta | 33154 | Annelida | Annelida | 149 | 2.78e-41 | NR | XP_009016532.1 | 6412 | g5644 | i0 | 43.9 | 8.48290598290598 | 180 | 99 | 76.9 | 2 | 650 | 111 | 6 | 183 | XP_009016532.1 hypothetical protein HELRODRAFT_77994 [Helobdella robusta] | diamond | 5955 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta |
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);;