contig_metadata
13 rows where bioproject = "PRJNA1199330" and tax_phylum = "Rotifera"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26755828 | 26755828 | PRJNA1199330_P_NODE_2641_length_1319_cov_5.978331_g2323_i0 | PRJNA1199330 | 2641 | 1319 | 5.978331 | 78.85418589 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 115 | 8.89e-24 | NR | CAF4693225.1 | 2762511 | g2323 | i0 | 27.7 | 0.657316148597422 | 289 | 194 | 65.3 | 4 | 248 | 1108 | 118 | 393 | CAF4693225.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 867 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 27040970 | 27040970 | PRJNA1199330_P_NODE_80562_length_272_cov_1.884422_g79863_i0 | PRJNA1199330 | 80562 | 272 | 1.884422 | 5.12562784 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 57 | 4.75e-7 | NR | CAF0804958.1 | 2762511 | g79863 | i0 | 43.9 | 1.88602941176471 | 57 | 32 | 62.9 | 0 | 97 | 267 | 14 | 70 | CAF0804958.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 513 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 28209385 | 28209385 | PRJNA1199330_P_NODE_50066_length_302_cov_3.698690_g49367_i0 | PRJNA1199330 | 50066 | 302 | 3.69869 | 11.1700438 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 92.8 | 1.76e-19 | NR | CAF0955812.1 | 392033 | g49367 | i0 | 47 | 0.993377483443709 | 100 | 53 | 99.3 | 0 | 1 | 300 | 333 | 432 | CAF0955812.1 unnamed protein product [Rotaria sordida] | diamond | 300 | 92.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 29156971 | 29156971 | PRJNA1199330_P_NODE_30529_length_374_cov_2.073090_g29833_i0 | PRJNA1199330 | 30529 | 374 | 2.07309 | 7.7533566 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 53.5 | 2.13e-5 | NR | CAF2893496.1 | 2762512 | g29833 | i0 | 34 | 0.77807486631016 | 97 | 38 | 57 | 2 | 315 | 103 | 140 | 236 | CAF2893496.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 291 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 29598512 | 29598512 | PRJNA1199330_P_NODE_2830_length_1273_cov_3.984167_g2323_i1 | PRJNA1199330 | 2830 | 1273 | 3.984167 | 50.71844591 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 115 | 5.3e-24 | NR | CAF4693225.1 | 2762511 | g2323 | i1 | 26.6 | 0.681068342498036 | 289 | 197 | 67.6 | 4 | 248 | 1108 | 118 | 393 | CAF4693225.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 867 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 29693188 | 29693188 | PRJNA1199330_P_NODE_72510_length_279_cov_2.703883_g71811_i0 | PRJNA1199330 | 72510 | 279 | 2.703883 | 7.54383357 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 62 | 1.56e-9 | NR | CAF2705991.1 | 2762512 | g71811 | i0 | 37.1 | 0.956989247311828 | 89 | 46 | 95.7 | 2 | 2 | 268 | 80 | 158 | CAF2705991.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 267 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 30198702 | 30198702 | PRJNA1199330_P_NODE_118412_length_237_cov_3.000000_g117713_i0 | PRJNA1199330 | 118412 | 237 | 3 | 7.11 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 56.2 | 6.03e-7 | NR | CAF0731763.1 | 433720 | g117713 | i0 | 47.5 | 2.9873417721519 | 59 | 31 | 74.7 | 0 | 7 | 183 | 62 | 120 | CAF0731763.1 unnamed protein product [Adineta steineri] | diamond | 708 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 30217749 | 30217749 | PRJNA1199330_P_NODE_60792_length_290_cov_1.428571_g60093_i0 | PRJNA1199330 | 60792 | 290 | 1.428571 | 4.1428559 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 50.4 | 1.14e-4 | NR | RNA42143.1 | 10195 | g60093 | i0 | 42.4 | 3.3 | 59 | 30 | 61 | 1 | 207 | 31 | 126 | 180 | RNA42143.1 speckle-type POZ B-like isoform X1 [Brachionus plicatilis] | diamond | 957 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 30925844 | 30925844 | PRJNA1199330_P_NODE_101094_length_252_cov_2.541899_g100395_i0 | PRJNA1199330 | 101094 | 252 | 2.541899 | 6.40558548 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 49.3 | 1.92e-4 | NR | CAF1650164.1 | 249248 | g100395 | i0 | 53.8 | 0.464285714285714 | 39 | 18 | 46.4 | 0 | 233 | 117 | 332 | 370 | CAF1650164.1 unnamed protein product, partial [Adineta ricciae] | diamond | 117 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 31513817 | 31513817 | PRJNA1199330_P_NODE_61896_length_289_cov_1.444444_g61197_i0 | PRJNA1199330 | 61896 | 289 | 1.444444 | 4.17444316 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 50.4 | 9.41e-5 | NR | UJR34341.1 | 104782 | g61197 | i0 | 28.1 | 10.1003460207612 | 89 | 56 | 92.4 | 1 | 275 | 9 | 8 | 88 | UJR34341.1 hypothetical protein I4U23_021744 [Adineta vaga] | diamond | 2919 | 50.8 | 0.992125984251969 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 31671628 | 31671628 | PRJNA1199330_P_NODE_116357_length_242_cov_0.923077_g115658_i0 | PRJNA1199330 | 116357 | 242 | 0.923077 | 2.23384634 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 53.9 | 4.21e-6 | NR | UJR11689.1 | 104782 | g115658 | i0 | 39.7 | 7.00413223140496 | 63 | 38 | 78.1 | 0 | 193 | 5 | 620 | 682 | UJR11689.1 hypothetical protein I4U23_015870 [Adineta vaga] | diamond | 1695 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 32746599 | 32746599 | PRJNA1199330_P_NODE_68540_length_283_cov_1.485714_g67841_i0 | PRJNA1199330 | 68540 | 283 | 1.485714 | 4.20457062 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 87.4 | 1.89e-18 | NR | RNA34143.1 | 10195 | g67841 | i0 | 76.5 | 1.09187279151943 | 51 | 12 | 54.1 | 0 | 282 | 130 | 216 | 266 | RNA34143.1 3-oxo-5-alpha-steroid 4-dehydrogenase 2 [Brachionus plicatilis] | diamond | 309 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 32822167 | 32822167 | PRJNA1199330_P_NODE_3740_length_1106_cov_9.247822_g3335_i0 | PRJNA1199330 | 3740 | 1106 | 9.247822 | 102.28091132 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 71.2 | 1.98e-9 | NR | CAF1504689.1 | 249248 | g3335 | i0 | 28.4 | 0.621157323688969 | 229 | 121 | 60.5 | 9 | 785 | 117 | 181 | 372 | CAF1504689.1 unnamed protein product [Adineta ricciae] | diamond | 687 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae |
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);;