contig_metadata
17 rows where bioproject = "PRJNA541476", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 508589 | 508589 | PRJNA541476_P_NODE_19061_length_286_cov_2.511737_g18855_i0 | PRJNA541476 | 19061 | 286 | 2.511737 | 7.18356782 | Capitella teleta | 283909 | Annelida | Annelida | 152 | 2.01e-42 | NR | ELU01488.1 | 283909 | g18855 | i0 | 76.8 | 3.98601398601399 | 95 | 22 | 99.7 | 0 | 2 | 286 | 76 | 170 | ELU01488.1 hypothetical protein CAPTEDRAFT_173477 [Capitella teleta] | diamond | 1140 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 1783811 | 1783811 | PRJNA541476_P_NODE_12482_length_331_cov_1.197674_g12276_i0 | PRJNA541476 | 12482 | 331 | 1.197674 | 3.96430094 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 58.4 | 6.7e-4 | NTclustered | gi|2920003545|emb|OZ238868.1| | 1046305 | g12276 | i0 | 97.059 | 0.102719033232628 | 34 | 1 | 10 | 0 | 181 | 214 | 5052356 | 5052323 | Ailoscolex lacteospumosus genome assembly, chromosome: 9 | blastn | 34 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 8161275 | 8161275 | PRJNA541476_P_NODE_15227_length_308_cov_1.293617_g15021_i0 | PRJNA541476 | 15227 | 308 | 1.293617 | 3.98434036 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 65.8 | 3.69e-6 | NTclustered | gi|2920003257|emb|OZ238860.1| | 1046305 | g15021 | i0 | 88.679 | 13.2564935064935 | 53 | 6 | 17 | 0 | 56 | 108 | 28656880 | 28656932 | Ailoscolex lacteospumosus genome assembly, chromosome: 1 | blastn | 4083 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 9436738 | 9436738 | PRJNA541476_P_NODE_15368_length_307_cov_1.324786_g15162_i0 | PRJNA541476 | 15368 | 307 | 1.324786 | 4.06709302 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 160 | 2.0199999999999999e-47 | NR | CAH1798696.1 | 6347 | g15162 | i0 | 73.5 | 8.92182410423453 | 102 | 27 | 99.7 | 0 | 1 | 306 | 14 | 115 | CAH1798696.1 unnamed protein product, partial [Owenia fusiformis] | diamond | 2739 | 160 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 15811162 | 15811162 | PRJNA541476_P_NODE_10333_length_355_cov_3.400709_g10127_i0 | PRJNA541476 | 10333 | 355 | 3.400709 | 12.07251695 | Helobdella robusta | 6412 | Annelida | Annelida | 56.5 | 0.003 | NTclustered | gi|675849589|ref|XM_009012107.1| | 6412 | g10127 | i0 | 100 | 0.0845070422535211 | 30 | 0 | 8 | 0 | 129 | 158 | 28 | 57 | Helobdella robusta hypothetical protein partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 16421314 | 16421314 | PRJNA541476_P_NODE_18373_length_290_cov_1.105991_g18167_i0 | PRJNA541476 | 18373 | 290 | 1.105991 | 3.2073739 | Metazoa | 33208 | Annelida | Annelida | 52.8 | 0.027 | NTclustered | gi|2918369718|emb|OZ237791.1| | 311461 | g18167 | i0 | 100 | 0.289655172413793 | 28 | 0 | 10 | 0 | 232 | 259 | 8554368 | 8554341 | Hirudo verbana genome assembly, chromosome: 13 | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 19634455 | 19634455 | PRJNA541476_P_NODE_1036_length_1148_cov_5.138605_g906_i0 | PRJNA541476 | 1036 | 1148 | 5.138605 | 58.9911854 | Helobdella robusta | 6412 | Annelida | Annelida | 63.9 | 5.4e-5 | NTclustered | gi|675862479|ref|XM_009018552.1| | 6412 | g906 | i0 | 97.368 | 0.0592334494773519 | 38 | 0 | 3 | 1 | 891 | 928 | 4046 | 4010 | Helobdella robusta hypothetical protein partial mRNA | blastn | 68 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 26666065 | 26666065 | PRJNA541476_P_NODE_13421_length_322_cov_1.686747_g13215_i0 | PRJNA541476 | 13421 | 322 | 1.686747 | 5.43132534 | Owenia fusiformis | 6347 | Annelida | Annelida | 45.1 | 0.0143 | NR | CAH1791738.1 | 6347 | g13215 | i0 | 30.2 | 0.894409937888199 | 96 | 51 | 89.4 | 2 | 321 | 34 | 164 | 243 | CAH1791738.1 unnamed protein product [Owenia fusiformis] | diamond | 288 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 27646752 | 27646752 | PRJNA541476_P_NODE_39844_length_242_cov_0.923077_g39638_i0 | PRJNA541476 | 39844 | 242 | 0.923077 | 2.23384634 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 120 | 8.53e-31 | NR | CAD5114121.1 | 2664684 | g39638 | i0 | 67.6 | 0.91735537190082606 | 74 | 24 | 91.7 | 0 | 224 | 3 | 34 | 107 | CAD5114121.1 DgyrCDS3267 [Dimorphilus gyrociliatus] | diamond | 222 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 29240143 | 29240143 | PRJNA541476_P_NODE_13109_length_325_cov_1.269841_g12903_i0 | PRJNA541476 | 13109 | 325 | 1.269841 | 4.12698325 | Metazoa | 33208 | Annelida | Annelida | 165 | 9.449999999999999e-47 | NR | ANS60440.1 | 6359 | g12903 | i0 | 68.5 | 39.8307692307692 | 108 | 34 | 99.7 | 0 | 324 | 1 | 242 | 349 | ANS60440.1 glycogen synthase kinase-3 beta [Platynereis dumerilii] | diamond | 12945 | 166 | 0.993975903614458 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Phyllodocida | Nereididae | Platynereis | Platynereis dumerilii | |
| 29888488 | 29888488 | PRJNA541476_P_NODE_6971_length_428_cov_1.602817_g6767_i0 | PRJNA541476 | 6971 | 428 | 1.602817 | 6.86005676 | Owenia fusiformis | 6347 | Annelida | Annelida | 75.5 | 8.78e-13 | NR | CAH1778322.1 | 6347 | g6767 | i0 | 38.2 | 0.953271028037383 | 136 | 66 | 83.4 | 3 | 2 | 358 | 58 | 192 | CAH1778322.1 unnamed protein product [Owenia fusiformis] | diamond | 408 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30299454 | 30299454 | PRJNA541476_P_NODE_26332_length_258_cov_2.167568_g26126_i0 | PRJNA541476 | 26332 | 258 | 2.167568 | 5.59232544 | Helobdella robusta | 6412 | Annelida | Annelida | 47.8 | 7.7e-4 | NR | XP_009025366.1 | 6412 | g26126 | i0 | 35.3 | 0.790697674418605 | 68 | 34 | 77.9 | 2 | 255 | 55 | 377 | 435 | XP_009025366.1 hypothetical protein HELRODRAFT_155987 [Helobdella robusta] | diamond | 204 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 30503559 | 30503559 | PRJNA541476_P_NODE_42413_length_200_cov_4.716535_g42207_i0 | PRJNA541476 | 42413 | 200 | 4.716535 | 9.43307 | Opisthokonta | 33154 | Annelida | Annelida | 108 | 1.26e-25 | NR | CAH1778446.1 | 6347 | g42207 | i0 | 77.3 | 5.94 | 66 | 15 | 99 | 0 | 3 | 200 | 353 | 418 | CAH1778446.1 unnamed protein product [Owenia fusiformis] | diamond | 1188 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 30583187 | 30583187 | PRJNA541476_P_NODE_2433_length_756_cov_2.396779_g2250_i0 | PRJNA541476 | 2433 | 756 | 2.396779 | 18.11964924 | Capitella teleta | 283909 | Annelida | Annelida | 247 | 5.39e-75 | NR | ELT93314.1 | 283909 | g2250 | i0 | 53.7 | 1.79761904761905 | 229 | 88 | 90.5 | 4 | 1 | 684 | 254 | 465 | ELT93314.1 hypothetical protein CAPTEDRAFT_225336 [Capitella teleta] | diamond | 1359 | 247 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 32164501 | 32164501 | PRJNA541476_P_NODE_37258_length_244_cov_0.912281_g37052_i0 | PRJNA541476 | 37258 | 244 | 0.912281 | 2.22596564 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 69.7 | 2.94e-12 | NR | CAD5122949.1 | 2664684 | g37052 | i0 | 53.2 | 0.762295081967213 | 62 | 29 | 76.2 | 0 | 242 | 57 | 82 | 143 | CAD5122949.1 DgyrCDS11344 [Dimorphilus gyrociliatus] | diamond | 186 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus | ||
| 32259573 | 32259573 | PRJNA541476_P_NODE_4458_length_542_cov_3.643923_g4259_i0 | PRJNA541476 | 4458 | 542 | 3.643923 | 19.75006266 | Lamellibrachia satsuma | 104711 | Annelida | Annelida | 67.4 | 1.98e-9 | NR | KAI0237492.1 | 104711 | g4259 | i0 | 38.4 | 0.952029520295203 | 86 | 47 | 44.8 | 2 | 244 | 2 | 549 | 633 | KAI0237492.1 Protein neuralized [Lamellibrachia satsuma] | diamond | 516 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Lamellibrachia | Lamellibrachia satsuma | |
| 32733171 | 32733171 | PRJNA541476_P_NODE_10900_length_348_cov_3.509091_g10694_i0 | PRJNA541476 | 10900 | 348 | 3.509091 | 12.21163668 | Owenia fusiformis | 6347 | Annelida | Annelida | 62.4 | 1.7e-8 | NR | CAH1794302.1 | 6347 | g10694 | i0 | 44.8 | 0.577586206896552 | 67 | 35 | 56 | 1 | 14 | 208 | 2980 | 3046 | CAH1794302.1 unnamed protein product [Owenia fusiformis] | diamond | 201 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis |
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);;