contig_metadata
20 rows where bioproject = "PRJNA608894", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5688915 | 5688915 | PRJNA608894_P_NODE_24065_length_394_cov_1.825545_g23568_i0 | PRJNA608894 | 24065 | 394 | 1.825545 | 7.1926473 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 139 | 2.21e-36 | NR | CAF1656256.1 | 249248 | g23568 | i0 | 51.7 | 1.79695431472081 | 118 | 56 | 89.1 | 1 | 356 | 6 | 98 | 215 | CAF1656256.1 unnamed protein product, partial [Adineta ricciae] | diamond | 708 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 12065221 | 12065221 | PRJNA608894_P_NODE_57330_length_244_cov_0.900585_g56831_i0 | PRJNA608894 | 57330 | 244 | 0.900585 | 2.1974274 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 96.3 | 1.02e-21 | NR | CAF0780643.1 | 1234261 | g56831 | i0 | 61.3 | 0.983606557377049 | 80 | 31 | 98.4 | 0 | 2 | 241 | 69 | 148 | CAF0780643.1 unnamed protein product [Didymodactylos carnosus] | diamond | 240 | 96.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 25373388 | 25373388 | PRJNA608894_P_NODE_32200_length_320_cov_1.230769_g31701_i0 | PRJNA608894 | 32200 | 320 | 1.230769 | 3.9384608 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 80.9 | 3.23e-16 | NR | CAF2066270.1 | 392030 | g31701 | i0 | 47.1 | 1.903125 | 104 | 52 | 96.6 | 3 | 317 | 9 | 71 | 172 | CAF2066270.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 609 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 27964465 | 27964465 | PRJNA608894_P_NODE_58225_length_243_cov_0.905882_g57726_i0 | PRJNA608894 | 58225 | 243 | 0.905882 | 2.20129326 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 85.5 | 1.88e-19 | NR | CAF5215442.1 | 392030 | g57726 | i0 | 47.5 | 0.987654320987654 | 80 | 42 | 98.8 | 0 | 243 | 4 | 18 | 97 | CAF5215442.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 240 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 28229966 | 28229966 | PRJNA608894_P_NODE_29326_length_341_cov_1.593284_g28827_i0 | PRJNA608894 | 29326 | 341 | 1.593284 | 5.43309844 | Rotaria | 231623 | Rotifera | other_Eukaryota | 68.2 | 1.44e-10 | NR | CAF3844071.1 | 392030 | g28827 | i0 | 39.6 | 4.51319648093842 | 101 | 58 | 88.9 | 2 | 7 | 309 | 131 | 228 | CAF3844071.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 1539 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 28311905 | 28311905 | PRJNA608894_P_NODE_60706_length_239_cov_2.674699_g60207_i0 | PRJNA608894 | 60706 | 239 | 2.674699 | 6.39253061 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 117 | 3.92e-29 | NR | CAF0996228.1 | 392030 | g60207 | i0 | 78.5 | 6.55230125523013 | 65 | 14 | 81.6 | 0 | 2 | 196 | 350 | 414 | CAF0996228.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 1566 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 28577589 | 28577589 | PRJNA608894_P_NODE_57627_length_243_cov_1.441176_g57128_i0 | PRJNA608894 | 57627 | 243 | 1.441176 | 3.50205768 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 69.7 | 1.13e-11 | NR | UJR35312.1 | 104782 | g57128 | i0 | 50 | 3.61728395061728 | 74 | 35 | 88.9 | 2 | 241 | 26 | 99 | 172 | UJR35312.1 hypothetical protein I4U23_028074 [Adineta vaga] | diamond | 879 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 28627808 | 28627808 | PRJNA608894_P_NODE_62007_length_226_cov_2.241830_g61508_i0 | PRJNA608894 | 62007 | 226 | 2.24183 | 5.0665358 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 67.8 | 4.27e-11 | NR | UJR10836.1 | 104782 | g61508 | i0 | 42.9 | 3.69026548672566 | 70 | 38 | 92.9 | 1 | 212 | 3 | 29 | 96 | UJR10836.1 hypothetical protein I4U23_015023 [Adineta vaga] | diamond | 834 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 29543121 | 29543121 | PRJNA608894_P_NODE_5530_length_1270_cov_5.920635_g5197_i0 | PRJNA608894 | 5530 | 1270 | 5.920635 | 75.1920645 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 75.1 | 2.23e-10 | NR | UJR29536.1 | 104782 | g5197 | i0 | 25.1 | 0.47007874015748 | 199 | 141 | 47 | 3 | 648 | 52 | 476 | 666 | UJR29536.1 hypothetical protein I4U23_010753 [Adineta vaga] | diamond | 597 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 29840536 | 29840536 | PRJNA608894_P_NODE_39991_length_283_cov_1.861905_g39492_i0 | PRJNA608894 | 39991 | 283 | 1.861905 | 5.26919115 | Rotaria | 231623 | Rotifera | other_Eukaryota | 165 | 1.8399999999999998e-47 | NR | CAF4649834.1 | 392030 | g39492 | i0 | 86.2 | 15.9434628975265 | 94 | 13 | 99.6 | 0 | 282 | 1 | 249 | 342 | CAF4649834.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 4512 | 166 | 0.993975903614458 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 31375835 | 31375835 | PRJNA608894_P_NODE_61296_length_233_cov_2.950000_g60797_i0 | PRJNA608894 | 61296 | 233 | 2.95 | 6.8735 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 44.3 | 0.00936 | NR | CAF2840576.1 | 2762512 | g60797 | i0 | 34.8 | 3.86266094420601 | 69 | 45 | 88.8 | 0 | 27 | 233 | 525 | 593 | CAF2840576.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 900 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 31565714 | 31565714 | PRJNA608894_P_NODE_35976_length_300_cov_2.766520_g35477_i0 | PRJNA608894 | 35976 | 300 | 2.76652 | 8.29956 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 86.7 | 2.94e-17 | NR | CAF0731428.1 | 104777 | g35477 | i0 | 42 | 2 | 100 | 55 | 100 | 2 | 1 | 300 | 1565 | 1661 | CAF0731428.1 unnamed protein product [Brachionus calyciflorus] | diamond | 600 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 31691988 | 31691988 | PRJNA608894_P_NODE_35057_length_305_cov_2.008621_g34558_i0 | PRJNA608894 | 35057 | 305 | 2.008621 | 6.12629405 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 48.9 | 5.24e-4 | NR | CAF1390506.1 | 2762511 | g34558 | i0 | 30.5 | 3.39344262295082 | 95 | 66 | 93.4 | 0 | 13 | 297 | 580 | 674 | CAF1390506.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 1035 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 31850082 | 31850082 | PRJNA608894_P_NODE_37917_length_291_cov_1.412844_g37418_i0 | PRJNA608894 | 37917 | 291 | 1.412844 | 4.11137604 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 103 | 4.22e-26 | NR | CAF3440507.1 | 2762512 | g37418 | i0 | 86.2 | 0.597938144329897 | 58 | 8 | 59.8 | 0 | 289 | 116 | 11 | 68 | CAF3440507.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 174 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 31850083 | 31850083 | PRJNA608894_P_NODE_39477_length_285_cov_1.603774_g38978_i0 | PRJNA608894 | 39477 | 285 | 1.603774 | 4.5707559 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 132 | 1.48e-34 | NR | CAF0828261.1 | 1234261 | g38978 | i0 | 66.3 | 2.97894736842105 | 95 | 32 | 100 | 0 | 285 | 1 | 266 | 360 | CAF0828261.1 unnamed protein product [Didymodactylos carnosus] | diamond | 849 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 32040032 | 32040032 | PRJNA608894_P_NODE_13718_length_614_cov_2.700555_g13239_i0 | PRJNA608894 | 13718 | 614 | 2.700555 | 16.5814077 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 112 | 3.28e-25 | NR | UJR26706.1 | 104782 | g13239 | i0 | 46.1 | 2.54071661237785 | 115 | 61 | 55.7 | 1 | 350 | 9 | 14 | 128 | UJR26706.1 hypothetical protein I4U23_008022 [Adineta vaga] | diamond | 1560 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 32198232 | 32198232 | PRJNA608894_P_NODE_56538_length_244_cov_1.695906_g56039_i0 | PRJNA608894 | 56538 | 244 | 1.695906 | 4.13801064 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 93.2 | 3.62e-20 | NR | CAF1142490.1 | 1234261 | g56039 | i0 | 52.6 | 1.91803278688525 | 78 | 36 | 94.7 | 1 | 233 | 3 | 117 | 194 | CAF1142490.1 unnamed protein product [Didymodactylos carnosus] | diamond | 468 | 93.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 32230054 | 32230054 | PRJNA608894_P_NODE_13178_length_635_cov_4.685053_g12701_i0 | PRJNA608894 | 13178 | 635 | 4.685053 | 29.75008655 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 120 | 2.47e-31 | NR | CAF3440507.1 | 2762512 | g12701 | i0 | 87 | 0.325984251968504 | 69 | 9 | 32.6 | 0 | 598 | 392 | 1 | 69 | CAF3440507.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 207 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 32766679 | 32766679 | PRJNA608894_P_NODE_31800_length_322_cov_3.228916_g31301_i0 | PRJNA608894 | 31800 | 322 | 3.228916 | 10.39710952 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 121 | 4.58e-30 | NR | CAF0733589.1 | 104777 | g31301 | i0 | 58.5 | 14.804347826087 | 106 | 42 | 98.8 | 1 | 3 | 320 | 263 | 366 | CAF0733589.1 unnamed protein product [Brachionus calyciflorus] | diamond | 4767 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 32766682 | 32766682 | PRJNA608894_P_NODE_43240_length_271_cov_9.232323_g42741_i0 | PRJNA608894 | 43240 | 271 | 9.232323 | 25.01959533 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 67 | 1.54e-11 | NR | CAF0745393.1 | 249248 | g42741 | i0 | 43.9 | 0.730627306273063 | 66 | 37 | 73.1 | 0 | 253 | 56 | 22 | 87 | CAF0745393.1 unnamed protein product [Adineta ricciae] | diamond | 198 | 67 | 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);;