contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA1063685" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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 | |
| 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);;