contig_metadata
27 rows where bioproject = "PRJEB14175", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25504667 | 25504667 | PRJEB14175_P_NODE_178481_length_246_cov_3.113514_g176214_i0 | PRJEB14175 | 178481 | 246 | 3.113514 | 7.65924444 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 200 | 7.5e-47 | NTclustered | gi|402761739|gb|JX184001.1| | 104782 | g176214 | i0 | 83.258 | 0.898373983739837 | 221 | 34 | 89 | 3 | 3 | 222 | 1521 | 1303 | Adineta vaga cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial | blastn | 221 | 200 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 25636898 | 25636898 | PRJEB14175_P_NODE_103578_length_350_cov_2.740484_g101312_i0 | PRJEB14175 | 103578 | 350 | 2.740484 | 9.591694 | Brachionus urceolaris | 204736 | Rotifera | other_Eukaryota | 494 | 4.57e-135 | NTclustered | gi|72153738|gb|DQ089740.1| | 204736 | g101312 | i0 | 92.733 | 63.46 | 344 | 21 | 97 | 4 | 10 | 350 | 2101 | 1759 | Brachionus urceolaris 28S ribosomal RNA gene, partial sequence | blastn | 22211 | 494 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus urceolaris | |
| 25746623 | 25746623 | PRJEB14175_P_NODE_34690_length_633_cov_7.351399_g32546_i0 | PRJEB14175 | 34690 | 633 | 7.351399 | 46.53435567 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 1125 | 0 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g32546 | i0 | 98.736 | 42.2243285939968 | 633 | 8 | 100 | 0 | 1 | 633 | 1507 | 2139 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 26728 | 1125 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 25780576 | 25780576 | PRJEB14175_P_NODE_272483_length_186_cov_34.360000_g270215_i0 | PRJEB14175 | 272483 | 186 | 34.36 | 63.9096 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 60.5 | 7.69e-9 | NR | CAF4489524.1 | 392032 | g270215 | i0 | 85.3 | 3.82258064516129 | 34 | 5 | 54.8 | 0 | 102 | 1 | 54 | 87 | CAF4489524.1 unnamed protein product [Rotaria socialis] | diamond | 711 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 25912335 | 25912335 | PRJEB14175_P_NODE_166300_length_258_cov_3.522843_g164033_i0 | PRJEB14175 | 166300 | 258 | 3.522843 | 9.08893494 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 68.2 | 3.18e-11 | NR | CAF1461758.1 | 249248 | g164033 | i0 | 53.6 | 2.11627906976744 | 56 | 26 | 65.1 | 0 | 25 | 192 | 232 | 287 | CAF1461758.1 unnamed protein product [Adineta ricciae] | diamond | 546 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 26424779 | 26424779 | PRJEB14175_P_NODE_179391_length_245_cov_4.543478_g177124_i0 | PRJEB14175 | 179391 | 245 | 4.543478 | 11.1315211 | Metazoa | 33208 | Rotifera | other_Eukaryota | 268 | 2.02e-67 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g177124 | i0 | 89.401 | 56.6489795918367 | 217 | 18 | 87 | 2 | 9 | 220 | 1815 | 1599 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 13879 | 268 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 32908604 | 32908604 | PRJEB14175_P_NODE_149873_length_277_cov_1.777778_g147606_i0 | PRJEB14175 | 149873 | 277 | 1.777778 | 4.92444506 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 58.2 | 3.6e-8 | NR | CAF1219011.1 | 392033 | g147606 | i0 | 88.5 | 1.44043321299639 | 26 | 3 | 28.2 | 0 | 3 | 80 | 115 | 140 | CAF1219011.1 unnamed protein product [Rotaria sordida] | diamond | 399 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 32909872 | 32909872 | PRJEB14175_P_NODE_50473_length_525_cov_2.547414_g48237_i0 | PRJEB14175 | 50473 | 525 | 2.547414 | 13.3739235 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 75.1 | 4.1e-12 | NR | CAF2094529.1 | 392030 | g48237 | i0 | 50 | 1.09714285714286 | 64 | 32 | 36.6 | 0 | 46 | 237 | 67 | 130 | CAF2094529.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 576 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 32922286 | 32922286 | PRJEB14175_P_NODE_130913_length_302_cov_11.149378_g128646_i0 | PRJEB14175 | 130913 | 302 | 11.149378 | 33.67112156 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 65.9 | 3.95e-11 | NR | UJR36849.1 | 104782 | g128646 | i0 | 63.6 | 0.824503311258278 | 44 | 15 | 42.7 | 1 | 282 | 154 | 68 | 111 | UJR36849.1 hypothetical protein I4U23_029562 [Adineta vaga] | diamond | 249 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 33025156 | 33025156 | PRJEB14175_P_NODE_216428_length_216_cov_1.651613_g214161_i0 | PRJEB14175 | 216428 | 216 | 1.651613 | 3.56748408 | root | 1 | Root_unresolved | Root_unresolved | 45.8 | 0.00213 | NR | CAF3946881.1 | 433720 | g214161 | i0 | 56.8 | 3.90277777777778 | 37 | 14 | 48.6 | 1 | 138 | 34 | 257 | 293 | CAF3946881.1 unnamed protein product [Adineta steineri] | diamond | 843 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 33029465 | 33029465 | PRJEB14175_P_NODE_37996_length_605_cov_22.799632_g35820_i0 | PRJEB14175 | 37996 | 605 | 22.799632 | 137.9377736 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 204 | 1.54e-63 | NR | CAF0930352.1 | 104777 | g35820 | i0 | 66.9 | 0.793388429752066 | 160 | 51 | 78.3 | 2 | 79 | 552 | 13 | 172 | CAF0930352.1 unnamed protein product [Brachionus calyciflorus] | diamond | 480 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 33029682 | 33029682 | PRJEB14175_P_NODE_61460_length_473_cov_3.504854_g59205_i0 | PRJEB14175 | 61460 | 473 | 3.504854 | 16.57795942 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 47 | 0.00685 | NR | KAI3388339.1 | 104778 | g59205 | i0 | 30.4 | 1.80126849894292 | 102 | 64 | 62.2 | 4 | 168 | 461 | 19 | 117 | KAI3388339.1 hypothetical protein SNEBB_007335 [Seison nebaliae] | diamond | 852 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 33045090 | 33045090 | PRJEB14175_P_NODE_131101_length_302_cov_4.174274_g128834_i0 | PRJEB14175 | 131101 | 302 | 4.174274 | 12.60630748 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 70.9 | 8.18e-12 | NR | CAF3349467.1 | 392032 | g128834 | i0 | 57.7 | 3.00993377483444 | 71 | 27 | 67.5 | 2 | 256 | 53 | 283 | 353 | CAF3349467.1 unnamed protein product [Rotaria socialis] | diamond | 909 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 33059233 | 33059233 | PRJEB14175_P_NODE_265893_length_195_cov_2.231343_g263625_i0 | PRJEB14175 | 265893 | 195 | 2.231343 | 4.35111885 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 61.2 | 6.08e-9 | NR | CAF0972083.1 | 433720 | g263625 | i0 | 78.8 | 2.53846153846154 | 33 | 7 | 50.8 | 0 | 1 | 99 | 940 | 972 | CAF0972083.1 unnamed protein product [Adineta steineri] | diamond | 495 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 33063383 | 33063383 | PRJEB14175_P_NODE_275245_length_179_cov_30.000000_g272977_i0 | PRJEB14175 | 275245 | 179 | 30 | 53.7 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 99 | 2.48e-22 | NR | CAF4897931.1 | 2762511 | g272977 | i0 | 82.4 | 6.83798882681564 | 51 | 9 | 85.5 | 0 | 2 | 154 | 442 | 492 | CAF4897931.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 1224 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 33063870 | 33063870 | PRJEB14175_P_NODE_8101_length_1225_cov_3.382302_g6860_i0 | PRJEB14175 | 8101 | 1225 | 3.382302 | 41.4331995 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 127 | 6.65e-29 | NR | CAF1317496.1 | 433720 | g6860 | i0 | 34.1 | 2.24081632653061 | 305 | 91 | 73.5 | 4 | 201 | 1100 | 118 | 317 | CAF1317496.1 unnamed protein product [Adineta steineri] | diamond | 2745 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 33076339 | 33076339 | PRJEB14175_P_NODE_49373_length_531_cov_3.191489_g47142_i0 | PRJEB14175 | 49373 | 531 | 3.191489 | 16.94680659 | Rotaria | 231623 | Rotifera | other_Eukaryota | 255 | 4.87e-84 | NR | CAF0910772.1 | 2762511 | g47142 | i0 | 78.4 | 4.57627118644068 | 162 | 35 | 91.5 | 0 | 45 | 530 | 1 | 162 | CAF0910772.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 2430 | 256 | 0.99609375 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 33096306 | 33096306 | PRJEB14175_P_NODE_129750_length_304_cov_4.485597_g127483_i0 | PRJEB14175 | 129750 | 304 | 4.485597 | 13.63621488 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 55.1 | 3.33e-6 | NR | CAF4526016.1 | 2762512 | g127483 | i0 | 52.2 | 0.453947368421053 | 46 | 22 | 45.4 | 0 | 304 | 167 | 144 | 189 | CAF4526016.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 138 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 33096369 | 33096369 | PRJEB14175_P_NODE_135918_length_295_cov_4.606838_g133651_i0 | PRJEB14175 | 135918 | 295 | 4.606838 | 13.5901721 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 145 | 1.0099999999999999e-38 | NR | CAF1322635.1 | 1234261 | g133651 | i0 | 82.9 | 0.833898305084746 | 82 | 14 | 83.4 | 0 | 280 | 35 | 391 | 472 | CAF1322635.1 unnamed protein product [Didymodactylos carnosus] | diamond | 246 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 33096561 | 33096561 | PRJEB14175_P_NODE_156902_length_268_cov_8.236715_g154635_i0 | PRJEB14175 | 156902 | 268 | 8.236715 | 22.0743962 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 62.4 | 5.86e-9 | NR | CAF1334116.1 | 1234261 | g154635 | i0 | 45.6 | 0.638059701492537 | 57 | 31 | 63.8 | 0 | 236 | 66 | 511 | 567 | CAF1334116.1 unnamed protein product [Didymodactylos carnosus] | diamond | 171 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 33110331 | 33110331 | PRJEB14175_P_NODE_207950_length_222_cov_1.900621_g205683_i0 | PRJEB14175 | 207950 | 222 | 1.900621 | 4.21937862 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 43.9 | 0.0108 | NR | CAF4093611.1 | 392030 | g205683 | i0 | 30 | 8.51351351351351 | 70 | 48 | 94.6 | 1 | 6 | 215 | 205 | 273 | CAF4093611.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 1890 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 33114005 | 33114005 | PRJEB14175_P_NODE_207759_length_222_cov_2.552795_g205492_i0 | PRJEB14175 | 207759 | 222 | 2.552795 | 5.6672049 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 57 | 9.49e-9 | NR | CAF1326126.1 | 1234261 | g205492 | i0 | 62 | 1.35135135135135 | 50 | 19 | 67.6 | 0 | 200 | 51 | 17 | 66 | CAF1326126.1 unnamed protein product [Didymodactylos carnosus] | diamond | 300 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 33130165 | 33130165 | PRJEB14175_P_NODE_101663_length_354_cov_2.621160_g99397_i0 | PRJEB14175 | 101663 | 354 | 2.62116 | 9.2789064 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 191 | 3.94e-58 | NR | CAF1083895.1 | 392033 | g99397 | i0 | 78.6 | 3.49152542372881 | 103 | 21 | 87.3 | 1 | 12 | 320 | 197 | 298 | CAF1083895.1 unnamed protein product [Rotaria sordida] | diamond | 1236 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 33147917 | 33147917 | PRJEB14175_P_NODE_178480_length_246_cov_3.113514_g176213_i0 | PRJEB14175 | 178480 | 246 | 3.113514 | 7.65924444 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 156 | 3.34e-47 | NR | RNA29896.1 | 10195 | g176213 | i0 | 86.4 | 0.98780487804878 | 81 | 11 | 98.8 | 0 | 1 | 243 | 52 | 132 | RNA29896.1 40S ribosomal S12 [Brachionus plicatilis] | diamond | 243 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 33164373 | 33164373 | PRJEB14175_P_NODE_123344_length_314_cov_2.359684_g121078_i0 | PRJEB14175 | 123344 | 314 | 2.359684 | 7.40940776 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 46.6 | 0.0011 | NR | CAF1077393.1 | 104777 | g121078 | i0 | 39.6 | 0.506369426751592 | 53 | 29 | 47.8 | 2 | 243 | 94 | 78 | 130 | CAF1077393.1 unnamed protein product [Brachionus calyciflorus] | diamond | 159 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 33165057 | 33165057 | PRJEB14175_P_NODE_196264_length_231_cov_2.147059_g193997_i0 | PRJEB14175 | 196264 | 231 | 2.147059 | 4.95970629 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 127 | 6.3e-34 | NR | CAF3845419.1 | 2762511 | g193997 | i0 | 88.4 | 1.79220779220779 | 69 | 8 | 89.6 | 0 | 25 | 231 | 138 | 206 | CAF3845419.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 414 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 33178580 | 33178580 | PRJEB14175_P_NODE_145512_length_282_cov_4.936652_g143245_i0 | PRJEB14175 | 145512 | 282 | 4.936652 | 13.92135864 | Rotaria | 231623 | Rotifera | other_Eukaryota | 44.3 | 0.0166 | NR | CAF0970422.1 | 392030 | g143245 | i0 | 58.3 | 1.47872340425532 | 36 | 10 | 38.3 | 1 | 41 | 148 | 484 | 514 | CAF0970422.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 417 | 44.7 | 0.991051454138702 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata |
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);;