contig_metadata
14 rows where bioproject = "PRJNA550047", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21522491 | 21522491 | PRJNA550047_P_NODE_212517_length_302_cov_11.362445_g210548_i0 | PRJNA550047 | 212517 | 302 | 11.362445 | 34.3145839 | Metazoa | 33208 | Rotifera | other_Eukaryota | 279 | 1.18e-70 | NTclustered | gi|1399047|gb|U41281.1|PAU41281 | 44582 | g210548 | i0 | 100 | 74.794701986755 | 151 | 0 | 94 | 0 | 1 | 151 | 417 | 267 | Philodina acuticornis 18S rRNA gene | blastn | 22588 | 279 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina acuticornis | |
| 23469508 | 23469508 | PRJNA550047_P_NODE_496679_length_231_cov_14.867089_g494706_i0 | PRJNA550047 | 496679 | 231 | 14.867089 | 34.34297559 | Anomopus telphusae | 338910 | Rotifera | other_Eukaryota | 405 | 1.38e-108 | NTclustered | gi|72153748|gb|DQ089741.1| | 338910 | g494706 | i0 | 98.268 | 43.974025974026 | 231 | 4 | 100 | 0 | 1 | 231 | 2447 | 2677 | Anomopus telphusae 28S ribosomal RNA gene, partial sequence | blastn | 10158 | 405 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Anomopus | Anomopus telphusae | |
| 26793271 | 26793271 | PRJNA550047_P_NODE_344781_length_287_cov_7.247664_g342811_i0 | PRJNA550047 | 344781 | 287 | 7.247664 | 20.80079568 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 126 | 1.7599999999999998e-31 | NR | CAF3916464.1 | 433720 | g342811 | i0 | 75.3 | 2.2787456445993 | 73 | 18 | 76.3 | 0 | 285 | 67 | 122 | 194 | CAF3916464.1 unnamed protein product [Adineta steineri] | diamond | 654 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 27409088 | 27409088 | PRJNA550047_P_NODE_27883_length_433_cov_11.266667_g25961_i0 | PRJNA550047 | 27883 | 433 | 11.266667 | 48.78466811 | Rotaria | 231623 | Rotifera | other_Eukaryota | 149 | 6.12e-41 | NR | CAF4218272.1 | 392033 | g25961 | i0 | 84.1 | 3.97690531177829 | 82 | 13 | 56.8 | 0 | 246 | 1 | 164 | 245 | CAF4218272.1 unnamed protein product, partial [Rotaria sordida] | diamond | 1722 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 27535202 | 27535202 | PRJNA550047_P_NODE_521243_length_223_cov_11.046667_g519270_i0 | PRJNA550047 | 521243 | 223 | 11.046667 | 24.63406741 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 124 | 4.6699999999999996e-32 | NR | CAF0842336.1 | 249248 | g519270 | i0 | 75.7 | 2.97309417040359 | 74 | 18 | 99.6 | 0 | 222 | 1 | 284 | 357 | CAF0842336.1 unnamed protein product [Adineta ricciae] | diamond | 663 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27693335 | 27693335 | PRJNA550047_P_NODE_600604_length_198_cov_4.384000_g598631_i0 | PRJNA550047 | 600604 | 198 | 4.384 | 8.68032 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 119 | 5.36e-30 | NR | CAF1022903.1 | 392033 | g598631 | i0 | 87.3 | 5.72727272727273 | 63 | 8 | 95.5 | 0 | 10 | 198 | 368 | 430 | CAF1022903.1 unnamed protein product [Rotaria sordida] | diamond | 1134 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 28814615 | 28814615 | PRJNA550047_P_NODE_215768_length_301_cov_16.842105_g213799_i0 | PRJNA550047 | 215768 | 301 | 16.842105 | 50.69473605 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 43.9 | 0.0289 | NR | CAF4576008.1 | 392030 | g213799 | i0 | 59.4 | 0.956810631229236 | 32 | 12 | 31.9 | 1 | 301 | 206 | 189 | 219 | CAF4576008.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 288 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 29067750 | 29067750 | PRJNA550047_P_NODE_486328_length_235_cov_5.962963_g484355_i0 | PRJNA550047 | 486328 | 235 | 5.962963 | 14.01296305 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 41.6 | 0.0257 | NR | CAF0868378.1 | 433720 | g484355 | i0 | 63.3 | 0.765957446808511 | 30 | 11 | 38.3 | 0 | 47 | 136 | 4 | 33 | CAF0868378.1 unnamed protein product, partial [Adineta steineri] | diamond | 180 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29762066 | 29762066 | PRJNA550047_P_NODE_413251_length_260_cov_4.294118_g411279_i0 | PRJNA550047 | 413251 | 260 | 4.294118 | 11.1647068 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 51.6 | 2.43e-6 | NR | CAF3900116.1 | 2762511 | g411279 | i0 | 42.2 | 3.02307692307692 | 64 | 36 | 72.7 | 1 | 206 | 18 | 10 | 73 | CAF3900116.1 unnamed protein product, partial [Rotaria sp. Silwood1] | diamond | 786 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 30172669 | 30172669 | PRJNA550047_P_NODE_138212_length_345_cov_5.485294_g136252_i0 | PRJNA550047 | 138212 | 345 | 5.485294 | 18.9242643 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 48.9 | 6.13e-5 | NR | CAF4341319.1 | 433720 | g136252 | i0 | 92 | 0.217391304347826 | 25 | 2 | 21.7 | 0 | 149 | 75 | 52 | 76 | CAF4341319.1 unnamed protein product, partial [Adineta steineri] | diamond | 75 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 31468827 | 31468827 | PRJNA550047_P_NODE_579696_length_204_cov_8.465649_g577723_i0 | PRJNA550047 | 579696 | 204 | 8.465649 | 17.26992396 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 59.7 | 5.7e-9 | NR | CAF2165557.1 | 392030 | g577723 | i0 | 65 | 0.588235294117647 | 40 | 14 | 58.8 | 0 | 2 | 121 | 46 | 85 | CAF2165557.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 120 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 32006319 | 32006319 | PRJNA550047_P_NODE_27258_length_437_cov_6.969780_g25337_i0 | PRJNA550047 | 27258 | 437 | 6.96978 | 30.4579386 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 63.5 | 1.56e-8 | NR | CAF3609291.1 | 392032 | g25337 | i0 | 65.4 | 0.356979405034325 | 52 | 17 | 35 | 1 | 3 | 155 | 265 | 316 | CAF3609291.1 unnamed protein product [Rotaria socialis] | diamond | 156 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 32795980 | 32795980 | PRJNA550047_P_NODE_433640_length_252_cov_11.972067_g431668_i0 | PRJNA550047 | 433640 | 252 | 11.972067 | 30.16960884 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 91.7 | 5.36e-20 | NR | CAF3447321.1 | 2762512 | g431668 | i0 | 56.6 | 1.97619047619048 | 83 | 35 | 98.8 | 1 | 2 | 250 | 8 | 89 | CAF3447321.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 498 | 91.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 32796004 | 32796004 | PRJNA550047_P_NODE_48980_length_345_cov_26.838235_g47020_i0 | PRJNA550047 | 48980 | 345 | 26.838235 | 92.59191075 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 45.1 | 0.0188 | NR | CAF4914033.1 | 2762511 | g47020 | i0 | 42.9 | 1.16521739130435 | 49 | 28 | 42.6 | 0 | 196 | 342 | 346 | 394 | CAF4914033.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 402 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 |
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);;