contig_metadata
26 rows where bioproject = "PRJNA1113956", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6126752 | 6126752 | PRJNA1113956_P_NODE_165_length_3103_cov_8.700330_g135_i1 | PRJNA1113956 | 165 | 3103 | 8.70033 | 269.9712399 | Philodinidae | 44580 | Rotifera | other_Eukaryota | 223 | 3.6099999999999985e-55 | NR | CAF0730115.1 | 1234261 | g135 | i1 | 42.2 | 6.83725427006123 | 282 | 160 | 27.2 | 2 | 671 | 1513 | 1503 | 1782 | CAF0730115.1 unnamed protein product [Didymodactylos carnosus] | diamond | 21216 | 223 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 9149609 | 9149609 | PRJNA1113956_P_NODE_128_length_3320_cov_5.893748_g108_i1 | PRJNA1113956 | 128 | 3320 | 5.893748 | 195.6724336 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 354 | 1.6099999999999998e-99 | NR | RNA45173.1 | 10195 | g108 | i1 | 32.8 | 5.1460843373494 | 789 | 428 | 64.6 | 15 | 2147 | 3 | 505 | 1265 | RNA45173.1 DNA excision repair ERCC-6 isoform X1 [Brachionus plicatilis] | diamond | 17085 | 354 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 21425831 | 21425831 | PRJNA1113956_P_NODE_157_length_3134_cov_8.363280_g135_i0 | PRJNA1113956 | 157 | 3134 | 8.36328 | 262.1051952 | Philodinidae | 44580 | Rotifera | other_Eukaryota | 223 | 3.9199999999999985e-55 | NR | CAF0730115.1 | 1234261 | g135 | i0 | 42.2 | 6.76962348436503 | 282 | 160 | 26.9 | 2 | 702 | 1544 | 1503 | 1782 | CAF0730115.1 unnamed protein product [Didymodactylos carnosus] | diamond | 21216 | 223 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 23174234 | 23174234 | PRJNA1113956_P_NODE_1699_length_1416_cov_3.172003_g1387_i1 | PRJNA1113956 | 1699 | 1416 | 3.172003 | 44.91556248 | Metazoa | 33208 | Rotifera | other_Eukaryota | 291 | 3.16e-91 | NR | CAF0930666.1 | 104777 | g1387 | i1 | 48.8 | 18.0360169491525 | 301 | 140 | 63.6 | 4 | 12 | 911 | 51 | 338 | CAF0930666.1 unnamed protein product [Brachionus calyciflorus] | diamond | 25539 | 291 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 27375503 | 27375503 | PRJNA1113956_P_NODE_14403_length_328_cov_1.207843_g14063_i0 | PRJNA1113956 | 14403 | 328 | 1.207843 | 3.96172504 | Metazoa | 33208 | Rotifera | other_Eukaryota | 78.6 | 1.95e-14 | NR | CAF1499466.1 | 249248 | g14063 | i0 | 42.4 | 3.20121951219512 | 92 | 50 | 84.1 | 1 | 52 | 327 | 104 | 192 | CAF1499466.1 unnamed protein product, partial [Adineta ricciae] | diamond | 1050 | 79.3 | 0.991172761664565 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27700135 | 27700135 | PRJNA1113956_P_NODE_15764_length_305_cov_1.879310_g15424_i0 | PRJNA1113956 | 15764 | 305 | 1.87931 | 5.7318955 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 98.6 | 2.4299999999999994e-24 | NR | CAF0795723.1 | 1234261 | g15424 | i0 | 55.1 | 4.68196721311475 | 78 | 35 | 76.7 | 0 | 242 | 9 | 20 | 97 | CAF0795723.1 unnamed protein product [Didymodactylos carnosus] | diamond | 1428 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 28142057 | 28142057 | PRJNA1113956_P_NODE_6485_length_634_cov_2.067736_g6161_i0 | PRJNA1113956 | 6485 | 634 | 2.067736 | 13.10944624 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 99.4 | 1.55e-20 | NR | CAF4920798.1 | 392030 | g6161 | i0 | 33.7 | 0.870662460567823 | 184 | 112 | 87.1 | 1 | 8 | 559 | 217 | 390 | CAF4920798.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 552 | 99.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 28489198 | 28489198 | PRJNA1113956_P_NODE_2887_length_1088_cov_3.958621_g2666_i0 | PRJNA1113956 | 2887 | 1088 | 3.958621 | 43.06979648 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 300 | 4.89e-95 | NR | CAF0893436.1 | 433720 | g2666 | i0 | 43.3 | 3.87683823529412 | 344 | 189 | 93.5 | 3 | 20 | 1036 | 41 | 383 | CAF0893436.1 unnamed protein product [Adineta steineri] | diamond | 4218 | 300 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 28615536 | 28615536 | PRJNA1113956_P_NODE_3807_length_917_cov_3.159953_g3539_i0 | PRJNA1113956 | 3807 | 917 | 3.159953 | 28.97676901 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 276 | 1.7999999999999997e-88 | NR | CAF1000576.1 | 249248 | g3539 | i0 | 49.2 | 4.82224645583424 | 297 | 133 | 93.2 | 6 | 913 | 59 | 17 | 307 | CAF1000576.1 unnamed protein product [Adineta ricciae] | diamond | 4422 | 276 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28678743 | 28678743 | PRJNA1113956_P_NODE_4107_length_873_cov_2.003750_g3830_i0 | PRJNA1113956 | 4107 | 873 | 2.00375 | 17.4927375 | Brachionus rotundiformis | 96890 | Rotifera | other_Eukaryota | 102 | 1.86e-20 | NR | AWV66643.1 | 96890 | g3830 | i0 | 26.7 | 0.938144329896907 | 273 | 170 | 83.5 | 6 | 765 | 37 | 210 | 482 | AWV66643.1 cysteine protease ATG4-like-2 [Brachionus rotundiformis] | diamond | 819 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rotundiformis | |
| 30067934 | 30067934 | PRJNA1113956_P_NODE_772_length_1900_cov_6.413793_g701_i0 | PRJNA1113956 | 772 | 1900 | 6.413793 | 121.862067 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 340 | 2.52e-105 | NR | CAF4517191.1 | 392032 | g701 | i0 | 37 | 4.3657894736842104 | 568 | 294 | 87 | 13 | 166 | 1818 | 17 | 537 | CAF4517191.1 unnamed protein product [Rotaria socialis] | diamond | 8295 | 340 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 30162512 | 30162512 | PRJNA1113956_P_NODE_15252_length_314_cov_0.958506_g14912_i0 | PRJNA1113956 | 15252 | 314 | 0.958506 | 3.00970884 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 50.1 | 2.19e-4 | NR | CAF2997181.1 | 2762512 | g14912 | i0 | 38.2 | 2.62738853503185 | 55 | 34 | 52.5 | 0 | 4 | 168 | 124 | 178 | CAF2997181.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 825 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 30375450 | 30375450 | PRJNA1113956_P_NODE_312_length_2588_cov_25.894235_g273_i0 | PRJNA1113956 | 312 | 2588 | 25.894235 | 670.1428018 | root | 1 | Root_unresolved | Root_unresolved | 139 | 9.37e-30 | NR | CAF0890256.1 | 392033 | g273 | i0 | 29.2 | 1.88369397217929 | 325 | 201 | 35.9 | 9 | 1600 | 2529 | 418 | 728 | CAF0890256.1 unnamed protein product [Rotaria sordida] | diamond | 4875 | 140 | 0.992857142857143 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 30605009 | 30605009 | PRJNA1113956_P_NODE_8773_length_492_cov_2.162291_g8435_i0 | PRJNA1113956 | 8773 | 492 | 2.162291 | 10.63847172 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 49.7 | 0.00167 | NR | RNA18724.1 | 10195 | g8435 | i0 | 29.5 | 2.29878048780488 | 129 | 68 | 67.1 | 5 | 355 | 26 | 537 | 661 | RNA18724.1 protocadherin Fat 1 isoform X1 [Brachionus plicatilis] | diamond | 1131 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 31047723 | 31047723 | PRJNA1113956_P_NODE_14395_length_328_cov_1.509804_g14055_i0 | PRJNA1113956 | 14395 | 328 | 1.509804 | 4.95215712 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 43.9 | 0.0364 | NR | CAF1466901.1 | 392030 | g14055 | i0 | 51.2 | 1.125 | 41 | 20 | 37.5 | 0 | 201 | 79 | 160 | 200 | CAF1466901.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 369 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 31079180 | 31079180 | PRJNA1113956_P_NODE_5435_length_724_cov_3.795699_g5128_i0 | PRJNA1113956 | 5435 | 724 | 3.795699 | 27.48086076 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 61.6 | 4.71e-7 | NR | UJR22920.1 | 104782 | g5128 | i0 | 26.3 | 1.23066298342541 | 160 | 112 | 63.8 | 2 | 173 | 634 | 27 | 186 | UJR22920.1 hypothetical protein I4U23_025948 [Adineta vaga] | diamond | 891 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 31426782 | 31426782 | PRJNA1113956_P_NODE_5176_length_749_cov_6.866864_g4870_i0 | PRJNA1113956 | 5176 | 749 | 6.866864 | 51.43281136 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 80.1 | 4.45e-13 | NR | CAF0764395.1 | 433720 | g4870 | i0 | 71.2 | 1.81041388518024 | 52 | 15 | 20.8 | 0 | 325 | 170 | 530 | 581 | CAF0764395.1 unnamed protein product [Adineta steineri] | diamond | 1356 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 31481475 | 31481475 | PRJNA1113956_P_NODE_15496_length_309_cov_3.072034_g15156_i0 | PRJNA1113956 | 15496 | 309 | 3.072034 | 9.49258506 | Metazoa | 33208 | Rotifera | other_Eukaryota | 70.5 | 1.97e-13 | NR | RNA07666.1 | 10195 | g15156 | i0 | 50.8 | 1.77669902912621 | 61 | 30 | 59.2 | 0 | 288 | 106 | 20 | 80 | RNA07666.1 migration and invasion enhancer 1 [Brachionus plicatilis] | diamond | 549 | 71.2 | 0.990168539325843 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 31544524 | 31544524 | PRJNA1113956_P_NODE_1836_length_1366_cov_12.741686_g1685_i0 | PRJNA1113956 | 1836 | 1366 | 12.741686 | 174.05143076 | Metazoa | 33208 | Rotifera | other_Eukaryota | 693 | 1.83e-248 | NR | UJR26688.1 | 104782 | g1685 | i0 | 77.3 | 18.2811127379209 | 437 | 96 | 95.8 | 2 | 1361 | 54 | 1 | 435 | UJR26688.1 hypothetical protein I4U23_008004 [Adineta vaga] | diamond | 24972 | 693 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 31616572 | 31616572 | PRJNA1113956_P_NODE_6736_length_615_cov_6.527675_g6411_i0 | PRJNA1113956 | 6736 | 615 | 6.527675 | 40.14520125 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 47.4 | 0.00519 | NR | CAF0875994.1 | 104777 | g6411 | i0 | 29.8 | 1.21463414634146 | 121 | 80 | 56.6 | 1 | 123 | 470 | 20 | 140 | CAF0875994.1 unnamed protein product [Brachionus calyciflorus] | diamond | 747 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 31837845 | 31837845 | PRJNA1113956_P_NODE_7797_length_540_cov_2.027837_g7463_i0 | PRJNA1113956 | 7797 | 540 | 2.027837 | 10.9503198 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 116 | 1.8700000000000003e-27 | NR | RMZ95287.1 | 10195 | g7463 | i0 | 45.9 | 1.54444444444444 | 148 | 69 | 78.3 | 7 | 424 | 2 | 75 | 218 | RMZ95287.1 Beta-1-4-N-acetylgalactosaminyltransferase bre-4, partial [Brachionus plicatilis] | diamond | 834 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 31987163 | 31987163 | PRJNA1113956_P_NODE_6458_length_635_cov_35.314947_g6134_i0 | PRJNA1113956 | 6458 | 635 | 35.314947 | 224.24991345 | Metazoa | 33208 | Rotifera | other_Eukaryota | 106 | 4.3999999999999995e-25 | NR | RNA40519.1 | 10195 | g6134 | i0 | 35.1 | 7.38425196850394 | 174 | 108 | 81.3 | 3 | 588 | 73 | 1 | 171 | RNA40519.1 translationally-controlled tumor -like isoform 1 [Brachionus plicatilis] | diamond | 4689 | 107 | 0.990654205607477 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 32091145 | 32091145 | PRJNA1113956_P_NODE_4118_length_871_cov_46.327068_g3841_i0 | PRJNA1113956 | 4118 | 871 | 46.327068 | 403.50876228 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 144 | 1.12e-37 | NR | CAF4171232.1 | 392032 | g3841 | i0 | 41.8 | 0.799081515499426 | 232 | 113 | 77.8 | 4 | 738 | 61 | 42 | 257 | CAF4171232.1 unnamed protein product [Rotaria socialis] | diamond | 696 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 32376020 | 32376020 | PRJNA1113956_P_NODE_9139_length_475_cov_2.159204_g8800_i0 | PRJNA1113956 | 9139 | 475 | 2.159204 | 10.256219 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 159 | 1.12e-45 | NR | CAF4039907.1 | 392030 | g8800 | i0 | 50.3 | 11.0715789473684 | 147 | 72 | 92.2 | 1 | 468 | 31 | 77 | 223 | CAF4039907.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 5259 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 32502695 | 32502695 | PRJNA1113956_P_NODE_10219_length_433_cov_0.855556_g9880_i0 | PRJNA1113956 | 10219 | 433 | 0.855556 | 3.70455748 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 52 | 1.16e-4 | NR | UJR09767.1 | 104782 | g9880 | i0 | 38.2 | 0.852193995381062 | 123 | 55 | 82.4 | 4 | 362 | 6 | 70 | 175 | UJR09767.1 hypothetical protein I4U23_013994 [Adineta vaga] | diamond | 369 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 32786005 | 32786005 | PRJNA1113956_P_NODE_15260_length_313_cov_7.883333_g14920_i0 | PRJNA1113956 | 15260 | 313 | 7.883333 | 24.67483229 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 53.5 | 1.36e-6 | NR | RNA33392.1 | 10195 | g14920 | i0 | 40.7 | 2.52076677316294 | 86 | 46 | 77.6 | 3 | 3 | 245 | 6 | 91 | RNA33392.1 vacuolar ATPase assembly integral membrane vma21 [Brachionus plicatilis] | diamond | 789 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis |
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);;