contig_metadata
21 rows where bioproject = "PRJNA757618", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5836016 | 5836016 | PRJNA757618_P_NODE_27225_length_253_cov_0.866667_g26173_i0 | PRJNA757618 | 27225 | 253 | 0.866667 | 2.19266751 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 130 | 6.06e-33 | NR | UJR37748.1 | 104782 | g26173 | i0 | 88.5 | 0.723320158102767 | 61 | 7 | 72.3 | 0 | 1 | 183 | 573 | 633 | UJR37748.1 hypothetical protein I4U23_030442 [Adineta vaga] | diamond | 183 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 26672769 | 26672769 | PRJNA757618_P_NODE_45561_length_243_cov_0.917647_g44509_i0 | PRJNA757618 | 45561 | 243 | 0.917647 | 2.22988221 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 101 | 1.69e-23 | NR | CAF1198044.1 | 249248 | g44509 | i0 | 75.7 | 0.864197530864197 | 70 | 17 | 86.4 | 0 | 241 | 32 | 231 | 300 | CAF1198044.1 unnamed protein product [Adineta ricciae] | diamond | 210 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27053043 | 27053043 | PRJNA757618_P_NODE_47522_length_242_cov_0.923077_g46470_i0 | PRJNA757618 | 47522 | 242 | 0.923077 | 2.23384634 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 105 | 1.34e-27 | NR | UJR17500.1 | 104782 | g46470 | i0 | 70.8 | 1.78512396694215 | 72 | 19 | 86.8 | 1 | 212 | 3 | 1 | 72 | UJR17500.1 hypothetical protein I4U23_004395 [Adineta vaga] | diamond | 432 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 27210788 | 27210788 | PRJNA757618_P_NODE_43222_length_244_cov_0.912281_g42170_i0 | PRJNA757618 | 43222 | 244 | 0.912281 | 2.22596564 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 43.9 | 0.0152 | NR | CAF0816583.1 | 249248 | g42170 | i0 | 90.5 | 0.258196721311475 | 21 | 2 | 25.8 | 0 | 182 | 244 | 146 | 166 | CAF0816583.1 unnamed protein product [Adineta ricciae] | diamond | 63 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27442318 | 27442318 | PRJNA757618_P_NODE_28163_length_252_cov_0.871508_g27111_i0 | PRJNA757618 | 28163 | 252 | 0.871508 | 2.19620016 | Adineta | 104781 | Rotifera | other_Eukaryota | 125 | 6.179999999999998e-32 | NR | CAF1679404.1 | 249248 | g27111 | i0 | 88.9 | 1.5 | 63 | 7 | 75 | 0 | 1 | 189 | 231 | 293 | CAF1679404.1 unnamed protein product, partial [Adineta ricciae] | diamond | 378 | 126 | 0.992063492063492 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27558268 | 27558268 | PRJNA757618_P_NODE_29544_length_251_cov_0.876404_g28492_i0 | PRJNA757618 | 29544 | 251 | 0.876404 | 2.19977404 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 157 | 1.29e-46 | NR | CAF1442219.1 | 249248 | g28492 | i0 | 88 | 5.9402390438247 | 83 | 10 | 99.2 | 0 | 249 | 1 | 36 | 118 | CAF1442219.1 unnamed protein product [Adineta ricciae] | diamond | 1491 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27568197 | 27568197 | PRJNA757618_P_NODE_35864_length_248_cov_0.885714_g34812_i0 | PRJNA757618 | 35864 | 248 | 0.885714 | 2.19657072 | Rotaria | 231623 | Rotifera | other_Eukaryota | 119 | 3.35e-29 | NR | CAF3718132.1 | 392033 | g34812 | i0 | 67.1 | 3.96774193548387 | 82 | 27 | 99.2 | 0 | 247 | 2 | 877 | 958 | CAF3718132.1 unnamed protein product, partial [Rotaria sordida] | diamond | 984 | 120 | 0.991666666666667 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 28000731 | 28000731 | PRJNA757618_P_NODE_23645_length_262_cov_1.650794_g22593_i0 | PRJNA757618 | 23645 | 262 | 1.650794 | 4.32508028 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 52.4 | 3.06e-6 | NR | CAF4411488.1 | 433720 | g22593 | i0 | 43.2 | 0.927480916030534 | 81 | 43 | 92.7 | 2 | 11 | 253 | 26 | 103 | CAF4411488.1 unnamed protein product, partial [Adineta steineri] | diamond | 243 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 28411093 | 28411093 | PRJNA757618_P_NODE_36726_length_247_cov_1.097701_g35674_i0 | PRJNA757618 | 36726 | 247 | 1.097701 | 2.71132147 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 83.6 | 1.53e-16 | NR | CAF1296375.1 | 433720 | g35674 | i0 | 70.7 | 2.81781376518219 | 58 | 17 | 70.4 | 0 | 236 | 63 | 436 | 493 | CAF1296375.1 unnamed protein product [Adineta steineri] | diamond | 696 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 28568784 | 28568784 | PRJNA757618_P_NODE_28447_length_252_cov_0.865922_g27395_i0 | PRJNA757618 | 28447 | 252 | 0.865922 | 2.18212344 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 117 | 9.51e-29 | NR | CAF1679820.1 | 249248 | g27395 | i0 | 73.5 | 0.988095238095238 | 83 | 4 | 98.8 | 1 | 2 | 250 | 222 | 286 | CAF1679820.1 unnamed protein product, partial [Adineta ricciae] | diamond | 249 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28915905 | 28915905 | PRJNA757618_P_NODE_45088_length_243_cov_0.917647_g44036_i0 | PRJNA757618 | 45088 | 243 | 0.917647 | 2.22988221 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 51.6 | 1.56e-5 | NR | CAF0741714.1 | 249248 | g44036 | i0 | 56.8 | 1.37037037037037 | 37 | 16 | 45.7 | 0 | 132 | 242 | 50 | 86 | CAF0741714.1 unnamed protein product [Adineta ricciae] | diamond | 333 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28979468 | 28979468 | PRJNA757618_P_NODE_28108_length_252_cov_0.871508_g27056_i0 | PRJNA757618 | 28108 | 252 | 0.871508 | 2.19620016 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 91.7 | 1.92e-19 | NR | CAF1462309.1 | 433720 | g27056 | i0 | 58.2 | 20.7380952380952 | 67 | 28 | 79.8 | 0 | 202 | 2 | 370 | 436 | CAF1462309.1 unnamed protein product [Adineta steineri] | diamond | 5226 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29074244 | 29074244 | PRJNA757618_P_NODE_45408_length_243_cov_0.917647_g44356_i0 | PRJNA757618 | 45408 | 243 | 0.917647 | 2.22988221 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 46.2 | 0.00205 | NR | CAF0879330.1 | 1234261 | g44356 | i0 | 30.3 | 0.938271604938272 | 76 | 47 | 93.8 | 1 | 237 | 10 | 121 | 190 | CAF0879330.1 unnamed protein product [Didymodactylos carnosus] | diamond | 228 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 29768558 | 29768558 | PRJNA757618_P_NODE_28471_length_252_cov_0.865922_g27419_i0 | PRJNA757618 | 28471 | 252 | 0.865922 | 2.18212344 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 53.5 | 6.5e-6 | NR | CAF0764189.1 | 1234261 | g27419 | i0 | 39.5 | 0.964285714285714 | 81 | 13 | 96.4 | 1 | 251 | 9 | 187 | 231 | CAF0764189.1 unnamed protein product [Didymodactylos carnosus] | diamond | 243 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 30179203 | 30179203 | PRJNA757618_P_NODE_37612_length_247_cov_0.890805_g36560_i0 | PRJNA757618 | 37612 | 247 | 0.890805 | 2.20028835 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 68.2 | 4.1e-11 | NR | UJR08271.1 | 104782 | g36560 | i0 | 82.4 | 0.412955465587045 | 34 | 5 | 40.1 | 1 | 3 | 101 | 318 | 351 | UJR08271.1 hypothetical protein I4U23_012543 [Adineta vaga] | diamond | 102 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 30252528 | 30252528 | PRJNA757618_P_NODE_33332_length_249_cov_0.886364_g32280_i0 | PRJNA757618 | 33332 | 249 | 0.886364 | 2.20704636 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 80.9 | 1.5e-15 | NR | UJR26848.1 | 104782 | g32280 | i0 | 61.8 | 7.68674698795181 | 68 | 6 | 81.9 | 1 | 248 | 45 | 198 | 245 | UJR26848.1 hypothetical protein I4U23_008160 [Adineta vaga] | diamond | 1914 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 31126820 | 31126820 | PRJNA757618_P_NODE_26955_length_253_cov_0.866667_g25903_i0 | PRJNA757618 | 26955 | 253 | 0.866667 | 2.19266751 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 46.6 | 0.00174 | NR | UJR25428.1 | 104782 | g25903 | i0 | 91.7 | 0.284584980237154 | 24 | 2 | 28.5 | 0 | 251 | 180 | 408 | 431 | UJR25428.1 hypothetical protein I4U23_006775 [Adineta vaga] | diamond | 72 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 31854531 | 31854531 | PRJNA757618_P_NODE_36417_length_248_cov_0.862857_g35365_i0 | PRJNA757618 | 36417 | 248 | 0.862857 | 2.13988536 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 116 | 2.33e-28 | NR | UJR07828.1 | 104782 | g35365 | i0 | 62.2 | 0.991935483870968 | 82 | 31 | 99.2 | 0 | 2 | 247 | 76 | 157 | UJR07828.1 hypothetical protein I4U23_012111 [Adineta vaga] | diamond | 246 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 32297945 | 32297945 | PRJNA757618_P_NODE_17619_length_287_cov_1.453271_g16567_i0 | PRJNA757618 | 17619 | 287 | 1.453271 | 4.17088777 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 43.5 | 0.0335 | NR | CAF1524545.1 | 433720 | g16567 | i0 | 46.3 | 1.24390243902439 | 41 | 22 | 42.9 | 0 | 158 | 36 | 177 | 217 | CAF1524545.1 unnamed protein product [Adineta steineri] | diamond | 357 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32424151 | 32424151 | PRJNA757618_P_NODE_28559_length_252_cov_0.865922_g27507_i0 | PRJNA757618 | 28559 | 252 | 0.865922 | 2.18212344 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 148 | 2.65e-39 | NR | CAF0968199.1 | 249248 | g27507 | i0 | 85.5 | 0.988095238095238 | 83 | 12 | 98.8 | 0 | 250 | 2 | 263 | 345 | CAF0968199.1 unnamed protein product [Adineta ricciae] | diamond | 249 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32749451 | 32749451 | PRJNA757618_P_NODE_44860_length_243_cov_0.917647_g43808_i0 | PRJNA757618 | 44860 | 243 | 0.917647 | 2.22988221 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 90.1 | 7.88e-19 | NR | UJR37479.1 | 104782 | g43808 | i0 | 95.9 | 6.04938271604938 | 49 | 2 | 60.5 | 0 | 149 | 3 | 418 | 466 | UJR37479.1 hypothetical protein I4U23_030182 [Adineta vaga] | diamond | 1470 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga |
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);;