contig_metadata
17 rows where bioproject = "PRJNA1105232" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14241376 | 14241376 | PRJNA1105232_S_NODE_1212_length_454_cov_13.503704_g998_i0 | PRJNA1105232 | 1212 | 454 | 13.503704 | 61.30681616 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 73.6 | 1.15e-13 | NR | RMZ94309.1 | 10195 | g998 | i0 | 45.6 | 3.27753303964758 | 68 | 37 | 44.9 | 0 | 369 | 166 | 4 | 71 | RMZ94309.1 ribosomal LP1 [Brachionus plicatilis] | diamond | 1488 | 74.3 | 0.990578734858681 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 26710500 | 26710500 | PRJNA1105232_S_NODE_17061_length_163_cov_0.912281_g16845_i0 | PRJNA1105232 | 17061 | 163 | 0.912281 | 1.48701803 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 51.2 | 2.99e-6 | NR | CAF4126320.1 | 392033 | g16845 | i0 | 48.8 | 9.77300613496933 | 43 | 22 | 79.1 | 0 | 130 | 2 | 22 | 64 | CAF4126320.1 unnamed protein product, partial [Rotaria sordida] | diamond | 1593 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 27194012 | 27194012 | PRJNA1105232_S_NODE_6422_length_240_cov_2.523560_g6206_i0 | PRJNA1105232 | 6422 | 240 | 2.52356 | 6.056544 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 54.3 | 2.96e-6 | NR | UJR27367.1 | 104782 | g6206 | i0 | 41.5 | 4.025 | 65 | 38 | 81.3 | 0 | 205 | 11 | 540 | 604 | UJR27367.1 hypothetical protein I4U23_008659 [Adineta vaga] | diamond | 966 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 27383874 | 27383874 | PRJNA1105232_S_NODE_14363_length_173_cov_1.258065_g14147_i0 | PRJNA1105232 | 14363 | 173 | 1.258065 | 2.17645245 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 83.2 | 8.04e-17 | NR | CAF1226109.1 | 392033 | g14147 | i0 | 76 | 0.867052023121387 | 50 | 12 | 86.7 | 0 | 1 | 150 | 567 | 616 | CAF1226109.1 unnamed protein product [Rotaria sordida] | diamond | 150 | 83.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 27668086 | 27668086 | PRJNA1105232_S_NODE_12264_length_185_cov_1.661765_g12048_i0 | PRJNA1105232 | 12264 | 185 | 1.661765 | 3.07426525 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 68.9 | 9.76e-12 | NR | KAI3379537.1 | 104778 | g12048 | i0 | 61.1 | 0.875675675675676 | 54 | 20 | 87.6 | 1 | 14 | 175 | 401 | 453 | KAI3379537.1 hypothetical protein SNEBB_000941 [Seison nebaliae] | diamond | 162 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 27920451 | 27920451 | PRJNA1105232_S_NODE_12165_length_186_cov_1.007299_g11949_i0 | PRJNA1105232 | 12165 | 186 | 1.007299 | 1.87357614 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 49.3 | 8.5e-5 | NR | CAF0735417.1 | 104777 | g11949 | i0 | 42.6 | 1.09677419354839 | 68 | 32 | 98.4 | 1 | 185 | 3 | 1800 | 1867 | CAF0735417.1 unnamed protein product [Brachionus calyciflorus] | diamond | 204 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 28015401 | 28015401 | PRJNA1105232_S_NODE_3025_length_323_cov_1.489051_g2809_i0 | PRJNA1105232 | 3025 | 323 | 1.489051 | 4.80963473 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 107 | 3.1e-25 | NR | RNA04689.1 | 10195 | g2809 | i0 | 51.4 | 0.975232198142415 | 105 | 50 | 97.5 | 1 | 323 | 9 | 229 | 332 | RNA04689.1 G alpha o subunit isoform X1 [Brachionus plicatilis] | diamond | 315 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 28109830 | 28109830 | PRJNA1105232_S_NODE_6725_length_236_cov_1.946524_g6509_i0 | PRJNA1105232 | 6725 | 236 | 1.946524 | 4.59379664 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 50.1 | 8.76e-5 | NR | CAF1195361.1 | 249248 | g6509 | i0 | 37.8 | 1.04237288135593 | 82 | 37 | 86.4 | 2 | 219 | 16 | 408 | 489 | CAF1195361.1 unnamed protein product [Adineta ricciae] | diamond | 246 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28290564 | 28290564 | PRJNA1105232_S_NODE_8106_length_219_cov_1.741176_g7890_i0 | PRJNA1105232 | 8106 | 219 | 1.741176 | 3.81317544 | root | 1 | Root_unresolved | Root_unresolved | 74.3 | 1.67e-13 | NR | CAF0728346.1 | 433720 | g7890 | i0 | 47.9 | 6 | 73 | 36 | 98.6 | 2 | 218 | 3 | 286 | 357 | CAF0728346.1 unnamed protein product [Adineta steineri] | diamond | 1314 | 74.7 | 0.994645247657296 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 28836103 | 28836103 | PRJNA1105232_S_NODE_8128_length_219_cov_1.111765_g7912_i0 | PRJNA1105232 | 8128 | 219 | 1.111765 | 2.43476535 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 106 | 2.9100000000000004e-26 | NR | CAF1372123.1 | 433720 | g7912 | i0 | 66.7 | 2.95890410958904 | 72 | 24 | 98.6 | 0 | 1 | 216 | 52 | 123 | CAF1372123.1 unnamed protein product [Adineta steineri] | diamond | 648 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 28922052 | 28922052 | PRJNA1105232_S_NODE_5768_length_251_cov_0.851485_g5552_i0 | PRJNA1105232 | 5768 | 251 | 0.851485 | 2.13722735 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 122 | 4.7399999999999994e-30 | NR | UJR33522.1 | 104782 | g5552 | i0 | 65.8 | 9.44223107569721 | 79 | 27 | 94.4 | 0 | 239 | 3 | 110 | 188 | UJR33522.1 hypothetical protein I4U23_020967 [Adineta vaga] | diamond | 2370 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 29774575 | 29774575 | PRJNA1105232_S_NODE_5471_length_256_cov_1.251208_g5255_i0 | PRJNA1105232 | 5471 | 256 | 1.251208 | 3.20309248 | Metazoa | 33208 | Rotifera | other_Eukaryota | 118 | 1.04e-31 | NR | CAF1356922.1 | 433720 | g5255 | i0 | 58.5 | 9.64453125 | 94 | 29 | 98.4 | 1 | 3 | 254 | 25 | 118 | CAF1356922.1 unnamed protein product, partial [Adineta steineri] | diamond | 2469 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29941492 | 29941492 | PRJNA1105232_S_NODE_4591_length_274_cov_1.617778_g4375_i0 | PRJNA1105232 | 4591 | 274 | 1.617778 | 4.43271172 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 96.3 | 5.97e-21 | NR | CAF1080161.1 | 249248 | g4375 | i0 | 56.5 | 0.930656934306569 | 85 | 31 | 86.5 | 1 | 1 | 237 | 381 | 465 | CAF1080161.1 unnamed protein product [Adineta ricciae] | diamond | 255 | 96.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 30510003 | 30510003 | PRJNA1105232_S_NODE_8633_length_214_cov_0.945455_g8417_i0 | PRJNA1105232 | 8633 | 214 | 0.945455 | 2.0232737 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 67.8 | 3.72e-11 | NR | CAF4504429.1 | 392032 | g8417 | i0 | 48.6 | 3.85514018691589 | 70 | 36 | 98.1 | 0 | 3 | 212 | 322 | 391 | CAF4504429.1 unnamed protein product [Rotaria socialis] | diamond | 825 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 30564215 | 30564215 | PRJNA1105232_S_NODE_2213_length_362_cov_1.750799_g1997_i0 | PRJNA1105232 | 2213 | 362 | 1.750799 | 6.33789238 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 98.6 | 3.36e-22 | NR | CAF3838279.1 | 392033 | g1997 | i0 | 46 | 7.44198895027624 | 113 | 59 | 92 | 2 | 334 | 2 | 155 | 267 | CAF3838279.1 unnamed protein product [Rotaria sordida] | diamond | 2694 | 99.4 | 0.991951710261569 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 32659665 | 32659665 | PRJNA1105232_S_NODE_16340_length_165_cov_1.344828_g16124_i0 | PRJNA1105232 | 16340 | 165 | 1.344828 | 2.2189662 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 61.6 | 7.56e-10 | NR | CAF1344529.1 | 249248 | g16124 | i0 | 56.6 | 0.963636363636364 | 53 | 20 | 90.9 | 1 | 14 | 163 | 103 | 155 | CAF1344529.1 unnamed protein product [Adineta ricciae] | diamond | 159 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32691293 | 32691293 | PRJNA1105232_S_NODE_15200_length_169_cov_1.291667_g14984_i0 | PRJNA1105232 | 15200 | 169 | 1.291667 | 2.18291723 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 64.7 | 7.46e-12 | NR | CAF1069178.1 | 104777 | g14984 | i0 | 65.5 | 0.976331360946746 | 55 | 17 | 97.6 | 1 | 167 | 3 | 33 | 85 | CAF1069178.1 unnamed protein product, partial [Brachionus calyciflorus] | diamond | 165 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus |
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);;