contig_metadata
15 rows where bioproject = "PRJNA408129" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 15721060 | 15721060 | PRJNA408129_S_NODE_173_length_531_cov_11548.965587_g160_i0 | PRJNA408129 | 173 | 531 | 11548.965587 | 61325.00726697 | Metazoa | 33208 | Rotifera | other_Eukaryota | 136 | 9.83e-34 | NR | CAF0742170.1 | 104777 | g160 | i0 | 76.1 | 6.92655367231638 | 88 | 21 | 49.7 | 0 | 524 | 261 | 579 | 666 | CAF0742170.1 unnamed protein product [Brachionus calyciflorus] | diamond | 3678 | 136 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 20820143 | 20820143 | PRJNA408129_S_NODE_2997_length_304_cov_17.689139_g2979_i0 | PRJNA408129 | 2997 | 304 | 17.689139 | 53.77498256 | Metazoa | 33208 | Rotifera | other_Eukaryota | 84.3 | 5.85e-18 | NR | RNA21358.1 | 10195 | g2979 | i0 | 68.9 | 6.99671052631579 | 61 | 18 | 59.2 | 1 | 3 | 182 | 113 | 173 | RNA21358.1 ferritin [Brachionus plicatilis] | diamond | 2127 | 84.7 | 0.995277449822904 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 26980550 | 26980550 | PRJNA408129_S_NODE_24282_length_168_cov_4.770992_g24264_i0 | PRJNA408129 | 24282 | 168 | 4.770992 | 8.01526656 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 54.7 | 7.43e-7 | NR | CAF1280549.1 | 249248 | g24264 | i0 | 80 | 1.07142857142857 | 30 | 6 | 53.6 | 0 | 95 | 6 | 86 | 115 | CAF1280549.1 unnamed protein product [Adineta ricciae] | diamond | 180 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27991637 | 27991637 | PRJNA408129_S_NODE_11025_length_215_cov_5.792135_g11007_i0 | PRJNA408129 | 11025 | 215 | 5.792135 | 12.45309025 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 59.7 | 2.71e-8 | NR | CAF3861611.1 | 2762511 | g11007 | i0 | 54.2 | 0.669767441860465 | 48 | 22 | 67 | 0 | 64 | 207 | 581 | 628 | CAF3861611.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 144 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 28307271 | 28307271 | PRJNA408129_S_NODE_11626_length_212_cov_2.862857_g11608_i0 | PRJNA408129 | 11626 | 212 | 2.862857 | 6.06925684 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 66.2 | 1.37e-11 | NR | CAF0817539.1 | 1234261 | g11608 | i0 | 51.4 | 1.0188679245283 | 72 | 30 | 97.6 | 2 | 3 | 209 | 58 | 127 | CAF0817539.1 unnamed protein product [Didymodactylos carnosus] | diamond | 216 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 28812125 | 28812125 | PRJNA408129_S_NODE_11348_length_213_cov_9.409091_g11330_i0 | PRJNA408129 | 11348 | 213 | 9.409091 | 20.04136383 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 46.6 | 8.69e-4 | NR | CAF4646489.1 | 2762511 | g11330 | i0 | 46.2 | 1.33802816901408 | 39 | 21 | 54.9 | 0 | 117 | 1 | 109 | 147 | CAF4646489.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 285 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 28955633 | 28955633 | PRJNA408129_S_NODE_7068_length_244_cov_2.743961_g7050_i0 | PRJNA408129 | 7068 | 244 | 2.743961 | 6.69526484 | Rotaria | 231623 | Rotifera | other_Eukaryota | 64.3 | 9.36e-10 | NR | CAF4985287.1 | 2762511 | g7050 | i0 | 55.2 | 6.78688524590164 | 58 | 26 | 71.3 | 0 | 7 | 180 | 456 | 513 | CAF4985287.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 1656 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 29380776 | 29380776 | PRJNA408129_S_NODE_35829_length_150_cov_2.690265_g35811_i0 | PRJNA408129 | 35829 | 150 | 2.690265 | 4.0353975 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 54.3 | 8.46e-7 | NR | CAF1302854.1 | 249248 | g35811 | i0 | 56.5 | 1.84 | 46 | 20 | 92 | 0 | 142 | 5 | 285 | 330 | CAF1302854.1 unnamed protein product [Adineta ricciae] | diamond | 276 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 29555111 | 29555111 | PRJNA408129_S_NODE_12430_length_208_cov_1.461988_g12412_i0 | PRJNA408129 | 12430 | 208 | 1.461988 | 3.04093504 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 57.8 | 1.69e-8 | NR | CAF5150111.1 | 392030 | g12412 | i0 | 100 | 3.76442307692308 | 29 | 0 | 41.8 | 0 | 15 | 101 | 108 | 136 | CAF5150111.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 783 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 29917707 | 29917707 | PRJNA408129_S_NODE_16851_length_188_cov_4.801325_g16833_i0 | PRJNA408129 | 16851 | 188 | 4.801325 | 9.026491 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 66.2 | 6.05e-11 | NR | CAF3893164.1 | 2762511 | g16833 | i0 | 51.6 | 9.8936170212766 | 62 | 30 | 98.9 | 0 | 2 | 187 | 181 | 242 | CAF3893164.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 1860 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 30107025 | 30107025 | PRJNA408129_S_NODE_19312_length_181_cov_1.291667_g19294_i0 | PRJNA408129 | 19312 | 181 | 1.291667 | 2.33791727 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 75.1 | 5.82e-14 | NR | CAF1082272.1 | 392033 | g19294 | i0 | 56.9 | 0.961325966850829 | 58 | 25 | 96.1 | 0 | 176 | 3 | 382 | 439 | CAF1082272.1 unnamed protein product [Rotaria sordida] | diamond | 174 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 30960276 | 30960276 | PRJNA408129_S_NODE_13214_length_203_cov_5.728916_g13196_i0 | PRJNA408129 | 13214 | 203 | 5.728916 | 11.62969948 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 42 | 0.0405 | NR | CAF1497617.1 | 249248 | g13196 | i0 | 57.9 | 0.561576354679803 | 38 | 16 | 56.2 | 0 | 146 | 33 | 75 | 112 | CAF1497617.1 unnamed protein product [Adineta ricciae] | diamond | 114 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 31592724 | 31592724 | PRJNA408129_S_NODE_12236_length_209_cov_1.546512_g12218_i0 | PRJNA408129 | 12236 | 209 | 1.546512 | 3.23221008 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 57 | 2.22e-7 | NR | CAF4286779.1 | 2762512 | g12218 | i0 | 49 | 3.66028708133971 | 51 | 26 | 73.2 | 0 | 28 | 180 | 461 | 511 | CAF4286779.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 765 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 31782128 | 31782128 | PRJNA408129_S_NODE_27877_length_161_cov_10.282258_g27859_i0 | PRJNA408129 | 27877 | 161 | 10.282258 | 16.55443538 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 50.4 | 1.18e-6 | NR | UJR13821.1 | 104782 | g27859 | i0 | 95.5 | 0.819875776397516 | 22 | 1 | 41 | 0 | 147 | 82 | 35 | 56 | UJR13821.1 hypothetical protein I4U23_000832 [Adineta vaga] | diamond | 132 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 32527009 | 32527009 | PRJNA408129_S_NODE_15919_length_192_cov_1.696774_g15901_i0 | PRJNA408129 | 15919 | 192 | 1.696774 | 3.25780608 | Rotaria | 231623 | Rotifera | other_Eukaryota | 88.6 | 1.91e-21 | NR | CAF3559733.1 | 392032 | g15901 | i0 | 83.7 | 2.015625 | 43 | 7 | 67.2 | 0 | 191 | 63 | 26 | 68 | CAF3559733.1 unnamed protein product, partial [Rotaria socialis] | diamond | 387 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis |
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);;