contig_metadata
11 rows where bioproject = "PRJNA703759", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7062684 | 7062684 | PRJNA703759_P_NODE_18606_length_319_cov_1.121951_g18130_i0 | PRJNA703759 | 18606 | 319 | 1.121951 | 3.57902369 | Ailoscolex lacteospumosus | 1046305 | Annelida | Annelida | 52.8 | 0.03 | NTclustered | gi|2920003563|emb|OZ238869.1| | 1046305 | g18130 | i0 | 100 | 0.0877742946708464 | 28 | 0 | 9 | 0 | 290 | 317 | 8346153 | 8346126 | Ailoscolex lacteospumosus genome assembly, chromosome: 10 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Crassiclitellata | Ailoscolecidae | Ailoscolex | Ailoscolex lacteospumosus | |
| 9612919 | 9612919 | PRJNA703759_P_NODE_31408_length_262_cov_1.322751_g30932_i0 | PRJNA703759 | 31408 | 262 | 1.322751 | 3.46560762 | Hirudo verbana | 311461 | Annelida | Annelida | 58.4 | 5.14e-4 | NTclustered | gi|2918369720|emb|OZ237792.1| | 311461 | g30932 | i0 | 97.059 | 0.381679389312977 | 34 | 1 | 13 | 0 | 229 | 262 | 599566 | 599599 | Hirudo verbana genome assembly, chromosome: 14 | blastn | 100 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 10888863 | 10888863 | PRJNA703759_P_NODE_47709_length_244_cov_0.912281_g47233_i0 | PRJNA703759 | 47709 | 244 | 0.912281 | 2.22596564 | Metazoa | 33208 | Annelida | Annelida | 83.6 | 5.68e-18 | NR | XP_009013953.1 | 6412 | g47233 | i0 | 94.9 | 163.967213114754 | 39 | 2 | 48 | 0 | 242 | 126 | 131 | 169 | XP_009013953.1 hypothetical protein HELRODRAFT_156666 [Helobdella robusta] | diamond | 40008 | 84.3 | 0.991696322657177 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 22361271 | 22361271 | PRJNA703759_P_NODE_17018_length_331_cov_1.209302_g16542_i0 | PRJNA703759 | 17018 | 331 | 1.209302 | 4.00278962 | Hirudo verbana | 311461 | Annelida | Annelida | 52.8 | 0.031 | NTclustered | gi|2918369714|emb|OZ237790.1| | 311461 | g16542 | i0 | 100 | 0.338368580060423 | 28 | 0 | 8 | 0 | 142 | 169 | 801141 | 801114 | Hirudo verbana genome assembly, chromosome: 12 | blastn | 112 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Hirudinida | Hirudinidae | Hirudo | Hirudo verbana | |
| 29052045 | 29052045 | PRJNA703759_P_NODE_39688_length_249_cov_1.772727_g39212_i0 | PRJNA703759 | 39688 | 249 | 1.772727 | 4.41409023 | Metazoa | 33208 | Annelida | Annelida | 104 | 8.469999999999998e-24 | NR | XP_009018416.1 | 6412 | g39212 | i0 | 62.5 | 104.192771084337 | 80 | 30 | 96.4 | 0 | 9 | 248 | 150 | 229 | XP_009018416.1 hypothetical protein HELRODRAFT_185638 [Helobdella robusta] | diamond | 25944 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Annelida | Clitellata | Rhynchobdellida | Glossiphoniidae | Helobdella | Helobdella robusta | |
| 29861701 | 29861701 | PRJNA703759_P_NODE_41071_length_248_cov_1.965714_g40595_i0 | PRJNA703759 | 41071 | 248 | 1.965714 | 4.87497072 | Capitella teleta | 283909 | Annelida | Annelida | 45.4 | 8.17e-4 | NR | ELU15022.1 | 283909 | g40595 | i0 | 48 | 0.604838709677419 | 50 | 25 | 60.5 | 1 | 98 | 247 | 36 | 84 | ELU15022.1 hypothetical protein CAPTEDRAFT_55021, partial [Capitella teleta] | diamond | 150 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 29924946 | 29924946 | PRJNA703759_P_NODE_16871_length_332_cov_1.382239_g16395_i0 | PRJNA703759 | 16871 | 332 | 1.382239 | 4.58903348 | Capitella teleta | 283909 | Annelida | Annelida | 48.9 | 1.38e-4 | NR | ELU06023.1 | 283909 | g16395 | i0 | 34.8 | 1.80722891566265 | 66 | 38 | 55.1 | 1 | 274 | 92 | 44 | 109 | ELU06023.1 hypothetical protein CAPTEDRAFT_56022, partial [Capitella teleta] | diamond | 600 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Capitellidae | Capitella | Capitella teleta | ||
| 31726253 | 31726253 | PRJNA703759_P_NODE_37557_length_251_cov_0.876404_g37081_i0 | PRJNA703759 | 37557 | 251 | 0.876404 | 2.19977404 | Ridgeia piscesae | 27915 | Annelida | Annelida | 47 | 0.00108 | NR | KAK2167647.1 | 27915 | g37081 | i0 | 33.3 | 0.932270916334661 | 78 | 52 | 93.2 | 0 | 16 | 249 | 44 | 121 | KAK2167647.1 hypothetical protein NP493_1267g00018 [Ridgeia piscesae] | diamond | 234 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Siboglinidae | Ridgeia | Ridgeia piscesae | |
| 31895616 | 31895616 | PRJNA703759_P_NODE_38577_length_250_cov_0.881356_g38101_i0 | PRJNA703759 | 38577 | 250 | 0.881356 | 2.20339 | Metazoa | 33208 | Annelida | Annelida | 45.4 | 0.0046 | NR | KAK2160274.1 | 53620 | g38101 | i0 | 40 | 1.824 | 45 | 27 | 54 | 0 | 11 | 145 | 297 | 341 | KAK2160274.1 hypothetical protein LSH36_137g07058 [Paralvinella palmiformis] | diamond | 456 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Terebellida | Alvinellidae | Paralvinella | Paralvinella palmiformis | |
| 31990469 | 31990469 | PRJNA703759_P_NODE_31278_length_262_cov_1.714286_g30802_i0 | PRJNA703759 | 31278 | 262 | 1.714286 | 4.49142932 | Metazoa | 33208 | Annelida | Annelida | 65.5 | 4.7e-10 | NR | CAH1801411.1 | 6347 | g30802 | i0 | 44.1 | 3.13740458015267 | 68 | 38 | 77.9 | 0 | 256 | 53 | 242 | 309 | CAH1801411.1 unnamed protein product [Owenia fusiformis] | diamond | 822 | 65.9 | 0.993930197268589 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Sabellida | Oweniidae | Owenia | Owenia fusiformis | |
| 32674809 | 32674809 | PRJNA703759_P_NODE_43020_length_247_cov_0.896552_g42544_i0 | PRJNA703759 | 43020 | 247 | 0.896552 | 2.21448344 | Dimorphilus gyrociliatus | 2664684 | Annelida | Annelida | 60.5 | 2.08e-8 | NR | CAD5112779.1 | 2664684 | g42544 | i0 | 37 | 1.77327935222672 | 73 | 46 | 88.7 | 0 | 3 | 221 | 15 | 87 | CAD5112779.1 DgyrCDS1990 [Dimorphilus gyrociliatus] | diamond | 438 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Annelida | Polychaeta | Dinophilidae | Dimorphilus | Dimorphilus gyrociliatus |
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);;