contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA1010662" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27571657 | 27571657 | PRJNA1010662_P_NODE_8844_length_193_cov_1.076389_g8785_i0 | PRJNA1010662 | 8844 | 193 | 1.076389 | 2.07743077 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 53.1 | 2.97e-7 | NR | CAF3293589.1 | 2762512 | g8785 | i0 | 63.8 | 1.60103626943005 | 47 | 14 | 73.1 | 1 | 36 | 176 | 33 | 76 | CAF3293589.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 309 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 28329361 | 28329361 | PRJNA1010662_P_NODE_5966_length_224_cov_1.148571_g5907_i0 | PRJNA1010662 | 5966 | 224 | 1.148571 | 2.57279904 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 95.1 | 2.74e-23 | NR | CAF3856195.1 | 392033 | g5907 | i0 | 55.1 | 9.17410714285714 | 69 | 31 | 92.4 | 0 | 216 | 10 | 42 | 110 | CAF3856195.1 unnamed protein product [Rotaria sordida] | diamond | 2055 | 95.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 28360875 | 28360875 | PRJNA1010662_P_NODE_12926_length_168_cov_0.873950_g12867_i0 | PRJNA1010662 | 12926 | 168 | 0.87395 | 1.468236 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 54.7 | 6.55e-7 | NR | CAF0808790.1 | 392033 | g12867 | i0 | 51.8 | 1 | 56 | 26 | 98.2 | 1 | 167 | 3 | 126 | 181 | CAF0808790.1 unnamed protein product [Rotaria sordida] | diamond | 168 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 28613595 | 28613595 | PRJNA1010662_P_NODE_12447_length_169_cov_1.291667_g12388_i0 | PRJNA1010662 | 12447 | 169 | 1.291667 | 2.18291723 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 63.2 | 7.32e-10 | NR | CAF1558790.1 | 249248 | g12388 | i0 | 47.3 | 2.85798816568047 | 55 | 29 | 97.6 | 0 | 168 | 4 | 184 | 238 | CAF1558790.1 unnamed protein product [Adineta ricciae] | diamond | 483 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28771438 | 28771438 | PRJNA1010662_P_NODE_9327_length_189_cov_1.471429_g9268_i0 | PRJNA1010662 | 9327 | 189 | 1.471429 | 2.78100081 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 68.9 | 7.63e-12 | NR | CAF4678618.1 | 2762512 | g9268 | i0 | 68.3 | 12.3650793650794 | 60 | 19 | 95.2 | 0 | 186 | 7 | 130 | 189 | CAF4678618.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 2337 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 29079815 | 29079815 | PRJNA1010662_P_NODE_12988_length_168_cov_0.873950_g12929_i0 | PRJNA1010662 | 12988 | 168 | 0.87395 | 1.468236 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 83.2 | 6.57e-17 | NR | CAF0748453.1 | 249248 | g12929 | i0 | 64.8 | 5.82142857142857 | 54 | 19 | 96.4 | 0 | 6 | 167 | 69 | 122 | CAF0748453.1 unnamed protein product [Adineta ricciae] | diamond | 978 | 83.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 29584594 | 29584594 | PRJNA1010662_P_NODE_17010_length_161_cov_2.517857_g16951_i0 | PRJNA1010662 | 17010 | 161 | 2.517857 | 4.05374977 | Metazoa | 33208 | Rotifera | other_Eukaryota | 76.3 | 1.85e-14 | NR | RNA41395.1 | 10195 | g16951 | i0 | 66 | 6.91304347826087 | 53 | 18 | 98.8 | 0 | 160 | 2 | 494 | 546 | RNA41395.1 propionyl- carboxylase beta mitochondrial [Brachionus plicatilis] | diamond | 1113 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 29655142 | 29655142 | PRJNA1010662_P_NODE_5250_length_235_cov_1.650538_g5191_i0 | PRJNA1010662 | 5250 | 235 | 1.650538 | 3.8787643 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 42.4 | 0.0308 | NR | CAF0947839.1 | 249248 | g5191 | i0 | 48.6 | 0.472340425531915 | 37 | 19 | 47.2 | 0 | 234 | 124 | 132 | 168 | CAF0947839.1 unnamed protein product [Adineta ricciae] | diamond | 111 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 30066006 | 30066006 | PRJNA1010662_P_NODE_11632_length_173_cov_2.766129_g11573_i0 | PRJNA1010662 | 11632 | 173 | 2.766129 | 4.78540317 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 58.2 | 2.52e-8 | NR | CAF5105708.1 | 2762511 | g11573 | i0 | 69.6 | 2.91329479768786 | 56 | 17 | 97.1 | 0 | 5 | 172 | 39 | 94 | CAF5105708.1 unnamed protein product, partial [Rotaria sp. Silwood1] | diamond | 504 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 30256019 | 30256019 | PRJNA1010662_P_NODE_13052_length_168_cov_0.873950_g12993_i0 | PRJNA1010662 | 13052 | 168 | 0.87395 | 1.468236 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 50.4 | 2.12e-5 | NR | RNA16066.1 | 10195 | g12993 | i0 | 50 | 1.80357142857143 | 50 | 21 | 83.9 | 2 | 7 | 147 | 1 | 49 | RNA16066.1 vacuolar sorting-associated 52 -like protein [Brachionus plicatilis] | diamond | 303 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 30287689 | 30287689 | PRJNA1010662_P_NODE_15532_length_164_cov_0.895652_g15473_i0 | PRJNA1010662 | 15532 | 164 | 0.895652 | 1.46886928 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 62.4 | 1.48e-9 | NR | CAF1325290.1 | 433720 | g15473 | i0 | 79.4 | 3.10975609756098 | 34 | 7 | 62.2 | 0 | 143 | 42 | 532 | 565 | CAF1325290.1 unnamed protein product [Adineta steineri] | diamond | 510 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 30343529 | 30343529 | PRJNA1010662_P_NODE_9252_length_190_cov_1.099291_g9193_i0 | PRJNA1010662 | 9252 | 190 | 1.099291 | 2.0886529 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 43.9 | 0.00276 | NR | CAF0826706.1 | 249248 | g9193 | i0 | 48.8 | 10.9105263157895 | 41 | 21 | 64.7 | 0 | 2 | 124 | 84 | 124 | CAF0826706.1 unnamed protein product [Adineta ricciae] | diamond | 2073 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 30406544 | 30406544 | PRJNA1010662_P_NODE_7373_length_207_cov_1.310127_g7314_i0 | PRJNA1010662 | 7373 | 207 | 1.310127 | 2.71196289 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 95.5 | 6e-21 | NR | RNA08825.1 | 10195 | g7314 | i0 | 58.2 | 9.89855072463768 | 67 | 28 | 97.1 | 0 | 6 | 206 | 515 | 581 | RNA08825.1 Glycyl-tRNA synthetase [Brachionus plicatilis] | diamond | 2049 | 95.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 30753766 | 30753766 | PRJNA1010662_P_NODE_6894_length_212_cov_1.576687_g6835_i0 | PRJNA1010662 | 6894 | 212 | 1.576687 | 3.34257644 | Metazoa | 33208 | Rotifera | other_Eukaryota | 95.9 | 4.82e-21 | NR | CAF0741332.1 | 1234261 | g6835 | i0 | 60.9 | 30.2830188679245 | 69 | 27 | 97.6 | 0 | 4 | 210 | 142 | 210 | CAF0741332.1 unnamed protein product [Didymodactylos carnosus] | diamond | 6420 | 96.7 | 0.991726990692865 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 31235055 | 31235055 | PRJNA1010662_P_NODE_15435_length_164_cov_0.904348_g15376_i0 | PRJNA1010662 | 15435 | 164 | 0.904348 | 1.48313072 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 63.2 | 7.9e-10 | NR | CAF0983473.1 | 249248 | g15376 | i0 | 44.4 | 4.86585365853659 | 54 | 30 | 98.8 | 0 | 1 | 162 | 19 | 72 | CAF0983473.1 unnamed protein product [Adineta ricciae] | diamond | 798 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 31955091 | 31955091 | PRJNA1010662_P_NODE_16257_length_163_cov_0.894737_g16198_i0 | PRJNA1010662 | 16257 | 163 | 0.894737 | 1.45842131 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.4 | 4.03e-6 | NR | CAF5177405.1 | 392030 | g16198 | i0 | 53.3 | 3.44171779141104 | 45 | 21 | 82.8 | 0 | 140 | 6 | 34 | 78 | CAF5177405.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 561 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 32184273 | 32184273 | PRJNA1010662_P_NODE_12218_length_170_cov_1.528926_g12159_i0 | PRJNA1010662 | 12218 | 170 | 1.528926 | 2.5991742 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 95.1 | 6.5900000000000005e-22 | NR | CAF3672381.1 | 2762511 | g12159 | i0 | 67.9 | 7.90588235294118 | 56 | 18 | 98.8 | 0 | 169 | 2 | 37 | 92 | CAF3672381.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 1344 | 95.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 32215918 | 32215918 | PRJNA1010662_P_NODE_10078_length_184_cov_1.281481_g10019_i0 | PRJNA1010662 | 10078 | 184 | 1.281481 | 2.35792504 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 97.4 | 4.7e-22 | NR | CAF1544120.1 | 433720 | g10019 | i0 | 67.2 | 1.89130434782609 | 58 | 19 | 94.6 | 0 | 183 | 10 | 185 | 242 | CAF1544120.1 unnamed protein product [Adineta steineri] | diamond | 348 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32303569 | 32303569 | PRJNA1010662_P_NODE_11339_length_175_cov_2.119048_g11280_i0 | PRJNA1010662 | 11339 | 175 | 2.119048 | 3.708334 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 68.6 | 1.98e-13 | NR | CAF1004371.1 | 104777 | g11280 | i0 | 66 | 6.03428571428571 | 47 | 16 | 80.6 | 0 | 142 | 2 | 3 | 49 | CAF1004371.1 unnamed protein product [Brachionus calyciflorus] | diamond | 1056 | 68.9 | 0.995645863570392 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 32429901 | 32429901 | PRJNA1010662_P_NODE_16459_length_162_cov_1.380531_g16400_i0 | PRJNA1010662 | 16459 | 162 | 1.380531 | 2.23646022 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 77.8 | 5.26e-16 | NR | CAF0930107.1 | 433720 | g16400 | i0 | 66 | 3.88888888888889 | 53 | 18 | 98.1 | 0 | 159 | 1 | 73 | 125 | CAF0930107.1 unnamed protein product [Adineta steineri] | diamond | 630 | 78.2 | 0.994884910485933 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32595514 | 32595514 | PRJNA1010662_P_NODE_6320_length_219_cov_1.323529_g6261_i0 | PRJNA1010662 | 6320 | 219 | 1.323529 | 2.89852851 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 75.1 | 1.08e-13 | NR | RNA11317.1 | 10195 | g6261 | i0 | 50 | 6.10958904109589 | 74 | 31 | 93.2 | 2 | 12 | 215 | 1374 | 1447 | RNA11317.1 acyloxyacyl hydrolase [Brachionus plicatilis] | diamond | 1338 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 32619348 | 32619348 | PRJNA1010662_P_NODE_12540_length_169_cov_0.866667_g12481_i0 | PRJNA1010662 | 12540 | 169 | 0.866667 | 1.46466723 | root | 1 | Root_unresolved | Root_unresolved | 58.2 | 4.85e-8 | NR | CAF1230431.1 | 392033 | g12481 | i0 | 52.3 | 12.6568047337278 | 44 | 21 | 78.1 | 0 | 6 | 137 | 746 | 789 | CAF1230431.1 unnamed protein product [Rotaria sordida] | diamond | 2139 | 58.5 | 0.994871794871795 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 32658030 | 32658030 | PRJNA1010662_P_NODE_8820_length_193_cov_1.375000_g8761_i0 | PRJNA1010662 | 8820 | 193 | 1.375 | 2.65375 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 62 | 3.07e-9 | NR | CAF4794565.1 | 2762511 | g8761 | i0 | 44.1 | 8.00518134715026 | 68 | 33 | 97.9 | 1 | 4 | 192 | 315 | 382 | CAF4794565.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 1545 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 32815730 | 32815730 | PRJNA1010662_P_NODE_10960_length_178_cov_1.201550_g10901_i0 | PRJNA1010662 | 10960 | 178 | 1.20155 | 2.138759 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 89 | 8.24e-19 | NR | RNA41011.1 | 10195 | g10901 | i0 | 57.6 | 1.8876404494382 | 59 | 25 | 99.4 | 0 | 177 | 1 | 2640 | 2698 | RNA41011.1 Serine threonine- kinase [Brachionus plicatilis] | diamond | 336 | 89 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 32815747 | 32815747 | PRJNA1010662_P_NODE_6920_length_212_cov_1.251534_g6861_i0 | PRJNA1010662 | 6920 | 212 | 1.251534 | 2.65325208 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 50.4 | 1.79e-5 | NR | CAF0927357.1 | 2762511 | g6861 | i0 | 37.7 | 2.25 | 53 | 31 | 75 | 1 | 1 | 159 | 5 | 55 | CAF0927357.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 477 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 |
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);;