contig_metadata
16 rows where bioproject = "PRJNA942359", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4751454 | 4751454 | PRJNA942359_P_NODE_3844_length_411_cov_1.153846_g3729_i0 | PRJNA942359 | 3844 | 411 | 1.153846 | 4.74230706 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 571 | 2.4499999999999996e-158 | NTclustered | gi|402761731|gb|JX183997.1| | 104788 | g3729 | i0 | 91.727 | 95.9172749391728 | 411 | 34 | 100 | 0 | 1 | 411 | 1080 | 670 | Macrotrachela quadricornifera isolate HR cytochrome c oxidase subunit 1 (COX1) gene, partial cds; mitochondrial | blastn | 39422 | 571 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera | |
| 8575788 | 8575788 | PRJNA942359_P_NODE_12807_length_253_cov_2.900000_g12692_i0 | PRJNA942359 | 12807 | 253 | 2.9 | 7.337 | Philodina sp. CWB-2005 | 338313 | Rotifera | other_Eukaryota | 355 | 1.56e-93 | NTclustered | gi|71840278|gb|DQ078586.1| | 338313 | g12692 | i0 | 92.063 | 99.0079051383399 | 252 | 20 | 99 | 0 | 2 | 253 | 156 | 407 | Philodina sp. CWB-2005 clone Kof1.1 cytochrome oxidase subunit 1 (cox1) gene, partial cds; mitochondrial | blastn | 25049 | 355 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina sp. CWB-2005 | |
| 11126436 | 11126436 | PRJNA942359_P_NODE_11009_length_270_cov_1.583756_g10894_i0 | PRJNA942359 | 11009 | 270 | 1.583756 | 4.2761412 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 279 | 1.04e-70 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g10894 | i0 | 85.448 | 27.1111111111111 | 268 | 39 | 99 | 0 | 1 | 268 | 10931 | 10664 | Philodina citrina complete mitochondrial genome | blastn | 7320 | 279 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 13676590 | 13676590 | PRJNA942359_P_NODE_14331_length_251_cov_0.876404_g14216_i0 | PRJNA942359 | 14331 | 251 | 0.876404 | 2.19977404 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 289 | 1.59e-73 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g14216 | i0 | 87.854 | 4.09561752988048 | 247 | 29 | 98 | 1 | 1 | 247 | 9840 | 10085 | Philodina citrina complete mitochondrial genome | blastn | 1028 | 289 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 21325084 | 21325084 | PRJNA942359_P_NODE_1877_length_568_cov_3.464646_g1763_i0 | PRJNA942359 | 1877 | 568 | 3.464646 | 19.67918928 | Philodina citrina | 468664 | Rotifera | other_Eukaryota | 699 | 0 | NTclustered | gi|407227484|emb|FR856884.1| | 468664 | g1763 | i0 | 89.005 | 34.6197183098592 | 573 | 52 | 100 | 8 | 1 | 568 | 1786 | 2352 | Philodina citrina complete mitochondrial genome | blastn | 19664 | 699 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina citrina | |
| 27253235 | 27253235 | PRJNA942359_P_NODE_9283_length_288_cov_1.195349_g9168_i0 | PRJNA942359 | 9283 | 288 | 1.195349 | 3.44260512 | Rotaria | 231623 | Rotifera | other_Eukaryota | 65.5 | 6.48e-10 | NR | CAF1556691.1 | 392030 | g9168 | i0 | 96.9 | 2.6875 | 32 | 1 | 33.3 | 0 | 3 | 98 | 892 | 923 | CAF1556691.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 774 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 27600980 | 27600980 | PRJNA942359_P_NODE_6124_length_340_cov_1.168539_g6009_i0 | PRJNA942359 | 6124 | 340 | 1.168539 | 3.9730326 | Rotaria | 231623 | Rotifera | other_Eukaryota | 211 | 4.43e-64 | NR | CAF3449955.1 | 392032 | g6009 | i0 | 89.2 | 4.89705882352941 | 111 | 12 | 97.9 | 0 | 6 | 338 | 186 | 296 | CAF3449955.1 unnamed protein product [Rotaria socialis] | diamond | 1665 | 212 | 0.995283018867924 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 27727470 | 27727470 | PRJNA942359_P_NODE_15704_length_249_cov_0.886364_g15589_i0 | PRJNA942359 | 15704 | 249 | 0.886364 | 2.20704636 | Rotaria | 231623 | Rotifera | other_Eukaryota | 135 | 8.42e-36 | NR | CAF5081441.1 | 2762511 | g15589 | i0 | 88.9 | 6.7710843373494 | 81 | 9 | 97.6 | 0 | 243 | 1 | 47 | 127 | CAF5081441.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 1686 | 136 | 0.992647058823529 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 27790366 | 27790366 | PRJNA942359_P_NODE_13104_length_253_cov_0.866667_g12989_i0 | PRJNA942359 | 13104 | 253 | 0.866667 | 2.19266751 | Rotaria | 231623 | Rotifera | other_Eukaryota | 87.4 | 8.1e-18 | NR | CAF1222992.1 | 392033 | g12989 | i0 | 69.8 | 1.25691699604743 | 53 | 16 | 62.8 | 0 | 249 | 91 | 761 | 813 | CAF1222992.1 unnamed protein product [Rotaria sordida] | diamond | 318 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 28453422 | 28453422 | PRJNA942359_P_NODE_15586_length_249_cov_0.886364_g15471_i0 | PRJNA942359 | 15586 | 249 | 0.886364 | 2.20704636 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 162 | 4.84e-44 | NR | UJR38210.1 | 104782 | g15471 | i0 | 100 | 13.8313253012048 | 82 | 0 | 98.8 | 0 | 247 | 2 | 911 | 992 | UJR38210.1 hypothetical protein I4U23_030883 [Adineta vaga] | diamond | 3444 | 162 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 30727120 | 30727120 | PRJNA942359_P_NODE_16194_length_248_cov_0.891429_g16079_i0 | PRJNA942359 | 16194 | 248 | 0.891429 | 2.21074392 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 112 | 1.79e-27 | NR | UJR31548.1 | 104782 | g16079 | i0 | 69.6 | 5.84274193548387 | 69 | 21 | 83.5 | 0 | 209 | 3 | 3 | 71 | UJR31548.1 hypothetical protein I4U23_019035 [Adineta vaga] | diamond | 1449 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 31510771 | 31510771 | PRJNA942359_P_NODE_17976_length_245_cov_0.906977_g17861_i0 | PRJNA942359 | 17976 | 245 | 0.906977 | 2.22209365 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 148 | 6.18e-41 | NR | CAF3737740.1 | 392033 | g17861 | i0 | 86.4 | 2.97551020408163 | 81 | 11 | 99.2 | 0 | 243 | 1 | 222 | 302 | CAF3737740.1 unnamed protein product [Rotaria sordida] | diamond | 729 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 31605552 | 31605552 | PRJNA942359_P_NODE_9276_length_288_cov_1.293023_g9161_i0 | PRJNA942359 | 9276 | 288 | 1.293023 | 3.72390624 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 154 | 5.68e-41 | NR | UJR28455.1 | 104782 | g9161 | i0 | 82.8 | 11.7083333333333 | 93 | 16 | 96.9 | 0 | 286 | 8 | 977 | 1069 | UJR28455.1 hypothetical protein I4U23_009695 [Adineta vaga] | diamond | 3372 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 31763601 | 31763601 | PRJNA942359_P_NODE_9957_length_281_cov_1.302885_g9842_i0 | PRJNA942359 | 9957 | 281 | 1.302885 | 3.66110685 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 118 | 1.64e-28 | NR | CAF1112184.1 | 433720 | g9842 | i0 | 61.8 | 0.950177935943061 | 89 | 34 | 95 | 0 | 5 | 271 | 235 | 323 | CAF1112184.1 unnamed protein product [Adineta steineri] | diamond | 267 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32586357 | 32586357 | PRJNA942359_P_NODE_9639_length_284_cov_1.872038_g9524_i0 | PRJNA942359 | 9639 | 284 | 1.872038 | 5.31658792 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 134 | 6.32e-39 | NR | CAF1028279.1 | 392033 | g9524 | i0 | 79.1 | 1.8169014084507 | 86 | 18 | 90.8 | 0 | 262 | 5 | 1 | 86 | CAF1028279.1 unnamed protein product [Rotaria sordida] | diamond | 516 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 32876256 | 32876256 | PRJNA942359_P_NODE_12520_length_256_cov_1.442623_g12405_i0 | PRJNA942359 | 12520 | 256 | 1.442623 | 3.69311488 | Rotaria | 231623 | Rotifera | other_Eukaryota | 128 | 6.3899999999999985e-34 | NR | CAF3831644.1 | 392030 | g12405 | i0 | 83.1 | 9.26953125 | 83 | 14 | 97.3 | 0 | 251 | 3 | 64 | 146 | CAF3831644.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 2373 | 129 | 0.992248062015504 | 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);;