contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA168635" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2329569 | 2329569 | PRJNA168635_P_NODE_28162_length_166_cov_0.888889_g27746_i0 | PRJNA168635 | 28162 | 166 | 0.888889 | 1.47555574 | Asplanchna sp. | 3231738 | Rotifera | other_Eukaryota | 87 | 2.99e-18 | NR | XDF22620.1 | 3231738 | g27746 | i0 | 72.2 | 0.975903614457831 | 54 | 15 | 97.6 | 0 | 3 | 164 | 426 | 479 | XDF22620.1 cytochrome c oxidase subunit I [Asplanchna sp.] | diamond | 162 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sp. | |
| 26789211 | 26789211 | PRJNA168635_P_NODE_23601_length_172_cov_2.504065_g23185_i0 | PRJNA168635 | 23601 | 172 | 2.504065 | 4.3069918 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 84.3 | 3.07e-17 | NR | CAF1575851.1 | 433720 | g23185 | i0 | 85.5 | 1.91860465116279 | 55 | 8 | 95.9 | 0 | 166 | 2 | 351 | 405 | CAF1575851.1 unnamed protein product [Adineta steineri] | diamond | 330 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 27231919 | 27231919 | PRJNA168635_P_NODE_24163_length_171_cov_1.696721_g23747_i0 | PRJNA168635 | 24163 | 171 | 1.696721 | 2.90139291 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 58.5 | 3.88e-8 | NR | CAF4702689.1 | 2762511 | g23747 | i0 | 72.7 | 1.54385964912281 | 44 | 12 | 77.2 | 0 | 171 | 40 | 1707 | 1750 | CAF4702689.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 264 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 27295174 | 27295174 | PRJNA168635_P_NODE_25083_length_169_cov_1.691667_g24667_i0 | PRJNA168635 | 25083 | 169 | 1.691667 | 2.85891723 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 43.9 | 0.00485 | NR | CAF1016870.1 | 104777 | g24667 | i0 | 75.8 | 0.585798816568047 | 33 | 8 | 58.6 | 0 | 6 | 104 | 155 | 187 | CAF1016870.1 unnamed protein product [Brachionus calyciflorus] | diamond | 99 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 27326823 | 27326823 | PRJNA168635_P_NODE_19783_length_183_cov_1.544776_g19367_i0 | PRJNA168635 | 19783 | 183 | 1.544776 | 2.82694008 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 52.8 | 5.03e-6 | NR | CAF3921928.1 | 433720 | g19367 | i0 | 50 | 0.950819672131147 | 58 | 29 | 95.1 | 0 | 174 | 1 | 143 | 200 | CAF3921928.1 unnamed protein product [Adineta steineri] | diamond | 174 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 27534106 | 27534106 | PRJNA168635_P_NODE_33223_length_158_cov_6.715596_g32807_i0 | PRJNA168635 | 33223 | 158 | 6.715596 | 10.61064168 | Rotaria | 231623 | Rotifera | other_Eukaryota | 95.9 | 1.7400000000000003e-21 | NR | CAF1010865.1 | 2762511 | g32807 | i0 | 92.3 | 4.93670886075949 | 52 | 4 | 98.7 | 0 | 156 | 1 | 354 | 405 | CAF1010865.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 780 | 95.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 27786865 | 27786865 | PRJNA168635_P_NODE_26344_length_168_cov_0.873950_g25928_i0 | PRJNA168635 | 26344 | 168 | 0.87395 | 1.468236 | Rotaria | 231623 | Rotifera | other_Eukaryota | 65.1 | 1.74e-10 | NR | CAF4112879.1 | 392030 | g25928 | i0 | 76.1 | 8.10714285714286 | 46 | 7 | 75 | 1 | 163 | 38 | 374 | 419 | CAF4112879.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 1362 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 28260114 | 28260114 | PRJNA168635_P_NODE_31926_length_162_cov_0.920354_g31510_i0 | PRJNA168635 | 31926 | 162 | 0.920354 | 1.49097348 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 47.4 | 2.83e-4 | NR | CAF3591783.1 | 392033 | g31510 | i0 | 80.8 | 2.35185185185185 | 26 | 5 | 48.1 | 0 | 80 | 3 | 105 | 130 | CAF3591783.1 unnamed protein product [Rotaria sordida] | diamond | 381 | 47.8 | 0.99163179916318 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 28431976 | 28431976 | PRJNA168635_P_NODE_19786_length_183_cov_1.544776_g19370_i0 | PRJNA168635 | 19786 | 183 | 1.544776 | 2.82694008 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 82.8 | 1.25e-16 | NR | CAF3187117.1 | 2762512 | g19370 | i0 | 79.2 | 0.786885245901639 | 48 | 10 | 78.7 | 0 | 178 | 35 | 284 | 331 | CAF3187117.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 144 | 82.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 28463659 | 28463659 | PRJNA168635_P_NODE_13906_length_216_cov_14.886228_g13490_i0 | PRJNA168635 | 13906 | 216 | 14.886228 | 32.15425248 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 47 | 2.01e-4 | NR | CAF1472279.1 | 433720 | g13490 | i0 | 85.2 | 0.375 | 27 | 4 | 37.5 | 0 | 129 | 209 | 90 | 116 | CAF1472279.1 unnamed protein product [Adineta steineri] | diamond | 81 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 28481342 | 28481342 | PRJNA168635_P_NODE_25306_length_169_cov_0.866667_g24890_i0 | PRJNA168635 | 25306 | 169 | 0.866667 | 1.46466723 | Rotaria | 231623 | Rotifera | other_Eukaryota | 98.2 | 8.789999999999999e-23 | NR | CAF4792651.1 | 392030 | g24890 | i0 | 95.5 | 7.02958579881657 | 44 | 2 | 78.1 | 0 | 134 | 3 | 117 | 160 | CAF4792651.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 1188 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 28621508 | 28621508 | PRJNA168635_P_NODE_19487_length_184_cov_1.518519_g19071_i0 | PRJNA168635 | 19487 | 184 | 1.518519 | 2.79407496 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 80.9 | 1.34e-16 | NR | CAF3452822.1 | 392032 | g19071 | i0 | 69 | 1.89130434782609 | 58 | 18 | 94.6 | 0 | 177 | 4 | 188 | 245 | CAF3452822.1 unnamed protein product [Rotaria socialis] | diamond | 348 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 28747668 | 28747668 | PRJNA168635_P_NODE_26247_length_168_cov_0.873950_g25831_i0 | PRJNA168635 | 26247 | 168 | 0.87395 | 1.468236 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 88.2 | 1.34e-18 | NR | CAF3847313.1 | 433720 | g25831 | i0 | 61 | 4.10714285714286 | 59 | 20 | 100 | 1 | 1 | 168 | 377 | 435 | CAF3847313.1 unnamed protein product [Adineta steineri] | diamond | 690 | 88.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29032068 | 29032068 | PRJNA168635_P_NODE_25788_length_168_cov_3.445378_g25372_i0 | PRJNA168635 | 25788 | 168 | 3.445378 | 5.78823504 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 107 | 3.04e-25 | NR | CAF4215544.1 | 392032 | g25372 | i0 | 87.3 | 6.875 | 55 | 7 | 98.2 | 0 | 3 | 167 | 206 | 260 | CAF4215544.1 unnamed protein product [Rotaria socialis] | diamond | 1155 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 29302261 | 29302261 | PRJNA168635_P_NODE_27469_length_167_cov_0.881356_g27053_i0 | PRJNA168635 | 27469 | 167 | 0.881356 | 1.47186452 | Rotaria | 231623 | Rotifera | other_Eukaryota | 86.7 | 4.25e-18 | NR | CAF2214207.1 | 392030 | g27053 | i0 | 88.9 | 23.4431137724551 | 45 | 5 | 80.8 | 0 | 167 | 33 | 164 | 208 | CAF2214207.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 3915 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 29694556 | 29694556 | PRJNA168635_P_NODE_25050_length_169_cov_1.708333_g24634_i0 | PRJNA168635 | 25050 | 169 | 1.708333 | 2.88708277 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 51.2 | 1.37e-5 | NR | CAF2582720.1 | 2762512 | g24634 | i0 | 48.2 | 3.01775147928994 | 56 | 28 | 97.6 | 1 | 4 | 168 | 206 | 261 | CAF2582720.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 510 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 29820955 | 29820955 | PRJNA168635_P_NODE_29131_length_165_cov_0.896552_g28715_i0 | PRJNA168635 | 29131 | 165 | 0.896552 | 1.4793108 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 43.5 | 0.00671 | NR | CAF0815109.1 | 104777 | g28715 | i0 | 51 | 1.78181818181818 | 49 | 21 | 89.1 | 1 | 14 | 160 | 1 | 46 | CAF0815109.1 unnamed protein product [Brachionus calyciflorus] | diamond | 294 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 30186403 | 30186403 | PRJNA168635_P_NODE_20012_length_182_cov_2.127820_g19596_i0 | PRJNA168635 | 20012 | 182 | 2.12782 | 3.8726324 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 102 | 6.4599999999999986e-24 | NR | CAF1202170.1 | 249248 | g19596 | i0 | 75 | 11.8351648351648 | 60 | 15 | 98.9 | 0 | 180 | 1 | 290 | 349 | CAF1202170.1 unnamed protein product [Adineta ricciae] | diamond | 2154 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 30439468 | 30439468 | PRJNA168635_P_NODE_22593_length_175_cov_1.357143_g22177_i0 | PRJNA168635 | 22593 | 175 | 1.357143 | 2.37500025 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 47.4 | 2.6e-4 | NR | CAF1427323.1 | 1234261 | g22177 | i0 | 52.5 | 2.53714285714286 | 40 | 18 | 68.6 | 1 | 170 | 51 | 177 | 215 | CAF1427323.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 444 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 31829933 | 31829933 | PRJNA168635_P_NODE_27737_length_166_cov_1.769231_g27321_i0 | PRJNA168635 | 27737 | 166 | 1.769231 | 2.93692346 | Rotaria | 231623 | Rotifera | other_Eukaryota | 57.8 | 6.26e-8 | NR | CAF4933572.1 | 392030 | g27321 | i0 | 92.6 | 4.26506024096386 | 27 | 2 | 48.8 | 0 | 84 | 164 | 46 | 72 | CAF4933572.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 708 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 31861628 | 31861628 | PRJNA168635_P_NODE_27757_length_166_cov_1.743590_g27341_i0 | PRJNA168635 | 27757 | 166 | 1.74359 | 2.8943594 | Rotaria | 231623 | Rotifera | other_Eukaryota | 58.9 | 1.35e-9 | NR | CAF3950448.1 | 392030 | g27341 | i0 | 81.8 | 7.75301204819277 | 33 | 6 | 59.6 | 0 | 101 | 3 | 12 | 44 | CAF3950448.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 1287 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 32160511 | 32160511 | PRJNA168635_P_NODE_16598_length_196_cov_4.006803_g16182_i0 | PRJNA168635 | 16598 | 196 | 4.006803 | 7.85333388 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 42.7 | 0.0196 | NR | RNA40893.1 | 10195 | g16182 | i0 | 43.5 | 0.704081632653061 | 46 | 25 | 70.4 | 1 | 6 | 143 | 100 | 144 | RNA40893.1 DNA polymerase zeta catalytic subunit, partial [Brachionus plicatilis] | diamond | 138 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 32305022 | 32305022 | PRJNA168635_P_NODE_28759_length_165_cov_1.301724_g28343_i0 | PRJNA168635 | 28759 | 165 | 1.301724 | 2.1478446 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 56.6 | 7.3e-8 | NR | CAF0938054.1 | 249248 | g28343 | i0 | 77.1 | 2.54545454545455 | 35 | 8 | 63.6 | 0 | 107 | 3 | 21 | 55 | CAF0938054.1 unnamed protein product [Adineta ricciae] | diamond | 420 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32589569 | 32589569 | PRJNA168635_P_NODE_32059_length_162_cov_0.920354_g31643_i0 | PRJNA168635 | 32059 | 162 | 0.920354 | 1.49097348 | Rotaria | 231623 | Rotifera | other_Eukaryota | 82.8 | 9.69e-17 | NR | CAF2163852.1 | 392030 | g31643 | i0 | 71.7 | 5.88888888888889 | 53 | 15 | 98.1 | 0 | 159 | 1 | 2543 | 2595 | CAF2163852.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 954 | 82.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 32729115 | 32729115 | PRJNA168635_P_NODE_19480_length_184_cov_1.525926_g19064_i0 | PRJNA168635 | 19480 | 184 | 1.525926 | 2.80770384 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 90.1 | 3.7400000000000005e-21 | NR | CAF1235178.1 | 249248 | g19064 | i0 | 71 | 2.02173913043478 | 62 | 17 | 99.5 | 1 | 183 | 1 | 37 | 98 | CAF1235178.1 unnamed protein product, partial [Adineta ricciae] | diamond | 372 | 90.1 | 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);;