contig_metadata
22 rows where bioproject = "PRJNA1010662", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1429721 | 1429721 | PRJNA1010662_P_NODE_6742_length_214_cov_1.254545_g6683_i0 | PRJNA1010662 | 6742 | 214 | 1.254545 | 2.6847263 | Helobdella robusta | 6412 | Annelida | Annelida | 189 | 1.3799999999999999e-43 | NTclustered | gi|675891503|ref|XM_009033006.1| | 6412 | g6683 | i0 | 85.246 | 21.9859813084112 | 183 | 27 | 86 | 0 | 1 | 183 | 363 | 545 | Helobdella robusta hypothetical protein partial mRNA | blastn | 4705 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 2705149 | 2705149 | PRJNA1010662_P_NODE_4663_length_246_cov_2.502538_g4604_i0 | PRJNA1010662 | 4663 | 246 | 2.502538 | 6.15624348 | Opisthokonta | 33154 | Annelida | Annelida | 140 | 3.1899999999999993e-40 | NR | KAI0212693.1 | 104711 | g4604 | i0 | 82.7 | 15.5731707317073 | 81 | 14 | 98.8 | 0 | 246 | 4 | 26 | 106 | KAI0212693.1 60S ribosomal protein L10-like [Lamellibrachia satsuma] | diamond | 3831 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 7807478 | 7807478 | PRJNA1010662_P_NODE_5847_length_225_cov_2.494318_g5788_i0 | PRJNA1010662 | 5847 | 225 | 2.494318 | 5.6122155 | Owenia fusiformis | 6347 | Annelida | Annelida | 116 | 1.14e-30 | NR | CAH1798696.1 | 6347 | g5788 | i0 | 73 | 2.96 | 74 | 20 | 98.7 | 0 | 2 | 223 | 33 | 106 | CAH1798696.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 666 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 9082400 | 9082400 | PRJNA1010662_P_NODE_3808_length_268_cov_1.771689_g3749_i0 | PRJNA1010662 | 3808 | 268 | 1.771689 | 4.74812652 | Helobdella robusta | 6412 | Annelida | Annelida | 137 | 1.89e-35 | NR | XP_009022669.1 | 6412 | g3749 | i0 | 78.4 | 0.985074626865672 | 88 | 17 | 98.5 | 1 | 266 | 3 | 462 | 547 | XP_009022669.1 hypothetical protein HELRODRAFT_185027 [Helobdella robusta] | diamond | 264 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 20556087 | 20556087 | PRJNA1010662_P_NODE_4697_length_246_cov_1.035533_g4638_i0 | PRJNA1010662 | 4697 | 246 | 1.035533 | 2.54741118 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.022 | NTclustered | gi|2918369718|emb|OZ237791.1| | 311461 | g4638 | i0 | 100 | 0.113821138211382 | 28 | 0 | 11 | 0 | 185 | 212 | 5534842 | 5534869 | Hirudo verbana genome assembly, chromosome: 13 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 27097688 | 27097688 | PRJNA1010662_P_NODE_17342_length_154_cov_2.380952_g17283_i0 | PRJNA1010662 | 17342 | 154 | 2.380952 | 3.66666608 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 66.6 | 4.13e-11 | NR | CAD5120535.1 | 2664684 | g17283 | i0 | 60.4 | 1.03246753246753 | 53 | 18 | 97.4 | 2 | 2 | 151 | 344 | 396 | CAD5120535.1 DgyrCDS9100 [Dimorphilus gyrociliatus] | diamond | 159 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 27311749 | 27311749 | PRJNA1010662_P_NODE_3523_length_277_cov_1.065789_g3464_i0 | PRJNA1010662 | 3523 | 277 | 1.065789 | 2.95223553 | Metazoa | 33208 | Annelida | Annelida | 102 | 3.9e-23 | NR | CAH1785139.1 | 6347 | g3464 | i0 | 60 | 3.83393501805054 | 90 | 30 | 96.4 | 2 | 3 | 269 | 394 | 478 | CAH1785139.1 unnamed protein product [Owenia fusiformis] | diamond | 1062 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27666559 | 27666559 | PRJNA1010662_P_NODE_2224_length_341_cov_1.746575_g2165_i0 | PRJNA1010662 | 2224 | 341 | 1.746575 | 5.95582075 | Owenia fusiformis | 6347 | Annelida | Annelida | 46.6 | 0.00406 | NR | CAH1791283.1 | 6347 | g2165 | i0 | 29.3 | 3.09677419354839 | 116 | 68 | 95.9 | 5 | 338 | 12 | 68 | 176 | CAH1791283.1 unnamed protein product [Owenia fusiformis] | diamond | 1056 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28076752 | 28076752 | PRJNA1010662_P_NODE_8065_length_200_cov_1.357616_g8006_i0 | PRJNA1010662 | 8065 | 200 | 1.357616 | 2.715232 | Owenia fusiformis | 6347 | Annelida | Annelida | 42 | 0.039 | NR | CAH1791281.1 | 6347 | g8006 | i0 | 35.6 | 0.885 | 59 | 34 | 82.5 | 1 | 22 | 186 | 232 | 290 | CAH1791281.1 unnamed protein product [Owenia fusiformis] | diamond | 177 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 28637890 | 28637890 | PRJNA1010662_P_NODE_15267_length_164_cov_0.904348_g15208_i0 | PRJNA1010662 | 15267 | 164 | 0.904348 | 1.48313072 | Polychaeta | 6341 | Annelida | Annelida | 53.5 | 1.99e-6 | NR | CAH1775312.1 | 6347 | g15208 | i0 | 53.2 | 1.64634146341463 | 47 | 22 | 86 | 0 | 22 | 162 | 1178 | 1224 | CAH1775312.1 unnamed protein product [Owenia fusiformis] | diamond | 270 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29150731 | 29150731 | PRJNA1010662_P_NODE_4629_length_247_cov_1.580808_g4570_i0 | PRJNA1010662 | 4629 | 247 | 1.580808 | 3.90459576 | Owenia fusiformis | 6347 | Annelida | Annelida | 72 | 1.91e-12 | NR | CAH1795464.1 | 6347 | g4570 | i0 | 47.4 | 0.947368421052632 | 78 | 40 | 94.7 | 1 | 10 | 243 | 470 | 546 | CAH1795464.1 unnamed protein product [Owenia fusiformis] | diamond | 234 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 29560641 | 29560641 | PRJNA1010662_P_NODE_16210_length_163_cov_0.903509_g16151_i0 | PRJNA1010662 | 16210 | 163 | 0.903509 | 1.47271967 | Capitella teleta | 283909 | Annelida | Annelida | 49.7 | 4.34e-5 | NR | ELU16041.1 | 283909 | g16151 | i0 | 38.5 | 0.957055214723926 | 52 | 32 | 95.7 | 0 | 6 | 161 | 467 | 518 | ELU16041.1 hypothetical protein CAPTEDRAFT_174522 [Capitella teleta] | diamond | 156 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 30003085 | 30003085 | PRJNA1010662_P_NODE_7431_length_206_cov_1.942675_g7372_i0 | PRJNA1010662 | 7431 | 206 | 1.942675 | 4.0019105 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 50.1 | 5.96e-5 | NR | KAK2165006.1 | 53620 | g7372 | i0 | 63.3 | 0.436893203883495 | 30 | 11 | 43.7 | 0 | 203 | 114 | 212 | 241 | KAK2165006.1 hypothetical protein LSH36_56g03060 [Paralvinella palmiformis] | diamond | 90 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 30097613 | 30097613 | PRJNA1010662_P_NODE_16672_length_162_cov_0.920354_g16613_i0 | PRJNA1010662 | 16672 | 162 | 0.920354 | 1.49097348 | Capitella teleta | 283909 | Annelida | Annelida | 42 | 0.024 | NR | ELU10555.1 | 283909 | g16613 | i0 | 46.7 | 1.59259259259259 | 45 | 24 | 83.3 | 0 | 28 | 162 | 335 | 379 | ELU10555.1 hypothetical protein CAPTEDRAFT_194024 [Capitella teleta] | diamond | 258 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 30160681 | 30160681 | PRJNA1010662_P_NODE_5792_length_226_cov_1.734463_g5733_i0 | PRJNA1010662 | 5792 | 226 | 1.734463 | 3.91988638 | Capitella teleta | 283909 | Annelida | Annelida | 63.9 | 7.75e-10 | NR | ELU08353.1 | 283909 | g5733 | i0 | 47 | 3.54424778761062 | 66 | 27 | 87.6 | 1 | 9 | 206 | 256 | 313 | ELU08353.1 hypothetical protein CAPTEDRAFT_227676 [Capitella teleta] | diamond | 801 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 30729601 | 30729601 | PRJNA1010662_P_NODE_11734_length_173_cov_1.516129_g11675_i0 | PRJNA1010662 | 11734 | 173 | 1.516129 | 2.62290317 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 59.7 | 2.75e-9 | NR | CAD5112496.1 | 2664684 | g11675 | i0 | 50.8 | 1.02312138728324 | 59 | 23 | 97.1 | 3 | 6 | 173 | 90 | 145 | CAD5112496.1 DgyrCDS1711 [Dimorphilus gyrociliatus] | diamond | 177 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 30911869 | 30911869 | PRJNA1010662_P_NODE_6574_length_216_cov_1.233533_g6515_i0 | PRJNA1010662 | 6574 | 216 | 1.233533 | 2.66443128 | Metazoa | 33208 | Annelida | Annelida | 77.4 | 3.67e-15 | NR | CAH1783703.1 | 6347 | g6515 | i0 | 53.5 | 16.2083333333333 | 71 | 33 | 98.6 | 0 | 216 | 4 | 114 | 184 | CAH1783703.1 unnamed protein product [Owenia fusiformis] | diamond | 3501 | 77.8 | 0.994858611825193 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30950988 | 30950988 | PRJNA1010662_P_NODE_12114_length_170_cov_4.157025_g12055_i0 | PRJNA1010662 | 12114 | 170 | 4.157025 | 7.0669425 | Paralvinella palmiformis | 53620 | Annelida | Annelida | 81.3 | 2.82e-17 | NR | KAK2153013.1 | 53620 | g12055 | i0 | 71.4 | 3.95294117647059 | 56 | 16 | 98.8 | 0 | 169 | 2 | 57 | 112 | KAK2153013.1 hypothetical protein LSH36_311g03070 [Paralvinella palmiformis] | diamond | 672 | 81.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 31013958 | 31013958 | PRJNA1010662_P_NODE_15715_length_163_cov_2.552632_g15656_i0 | PRJNA1010662 | 15715 | 163 | 2.552632 | 4.16079016 | Helobdella robusta | 6412 | Annelida | Annelida | 81.6 | 6.64e-18 | NR | XP_009021356.1 | 6412 | g15656 | i0 | 61.1 | 12.8834355828221 | 54 | 21 | 99.4 | 0 | 162 | 1 | 10 | 63 | XP_009021356.1 hypothetical protein HELRODRAFT_157357 [Helobdella robusta] | diamond | 2100 | 81.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 32208399 | 32208399 | PRJNA1010662_P_NODE_16518_length_162_cov_0.964602_g16459_i0 | PRJNA1010662 | 16518 | 162 | 0.964602 | 1.56265524 | Siboglinidae | 41324 | Annelida | Annelida | 64.3 | 2.88e-10 | NR | KAK2192343.1 | 27915 | g16459 | i0 | 65.8 | 2.24074074074074 | 38 | 13 | 70.4 | 0 | 1 | 114 | 282 | 319 | KAK2192343.1 hypothetical protein NP493_33g04003 [Ridgeia piscesae] | diamond | 363 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 32469198 | 32469198 | PRJNA1010662_P_NODE_8619_length_195_cov_1.061644_g8560_i0 | PRJNA1010662 | 8619 | 195 | 1.061644 | 2.0702058 | Owenia fusiformis | 6347 | Annelida | Annelida | 42.7 | 0.0193 | NR | CAH1777883.1 | 6347 | g8560 | i0 | 51.5 | 0.969230769230769 | 33 | 16 | 50.8 | 0 | 176 | 78 | 81 | 113 | CAH1777883.1 unnamed protein product [Owenia fusiformis] | diamond | 189 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32556706 | 32556706 | PRJNA1010662_P_NODE_15259_length_164_cov_0.904348_g15200_i0 | PRJNA1010662 | 15259 | 164 | 0.904348 | 1.48313072 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 58.9 | 5.94e-9 | NR | KAK2192437.1 | 27915 | g15200 | i0 | 57.7 | 6.73170731707317 | 52 | 20 | 95.1 | 2 | 158 | 3 | 80 | 129 | KAK2192437.1 hypothetical protein NP493_31g02041 [Ridgeia piscesae] | diamond | 1104 | 58.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);;