contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA309466" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5480358 | 5480358 | PRJNA309466_P_NODE_8705_length_209_cov_2.568750_g8648_i0 | PRJNA309466 | 8705 | 209 | 2.56875 | 5.3686875 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 124 | 5.28e-34 | NR | CAF0771406.1 | 433720 | g8648 | i0 | 100 | 9.11483253588517 | 64 | 0 | 91.9 | 0 | 4 | 195 | 39 | 102 | CAF0771406.1 unnamed protein product [Adineta steineri] | diamond | 1905 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 26694312 | 26694312 | PRJNA309466_P_NODE_16641_length_166_cov_0.888889_g16584_i0 | PRJNA309466 | 16641 | 166 | 0.888889 | 1.47555574 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 98.6 | 2.74e-22 | NR | CAF3741961.1 | 2762511 | g16584 | i0 | 81.5 | 1.95180722891566 | 54 | 10 | 97.6 | 0 | 2 | 163 | 43 | 96 | CAF3741961.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 324 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 27344910 | 27344910 | PRJNA309466_P_NODE_4683_length_266_cov_1.880184_g4627_i0 | PRJNA309466 | 4683 | 266 | 1.880184 | 5.00128944 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 154 | 4.31e-41 | NR | CAF1126081.1 | 249248 | g4627 | i0 | 83.9 | 11.8759398496241 | 87 | 14 | 98.1 | 0 | 5 | 265 | 2978 | 3064 | CAF1126081.1 unnamed protein product [Adineta ricciae] | diamond | 3159 | 155 | 0.993548387096774 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 29158658 | 29158658 | PRJNA309466_P_NODE_16849_length_165_cov_1.741379_g16792_i0 | PRJNA309466 | 16849 | 165 | 1.741379 | 2.87327535 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 88.2 | 6.68e-20 | NR | CAF1190777.1 | 392033 | g16792 | i0 | 68.5 | 1.96363636363636 | 54 | 17 | 98.2 | 0 | 3 | 164 | 110 | 163 | CAF1190777.1 unnamed protein product [Rotaria sordida] | diamond | 324 | 88.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 29176220 | 29176220 | PRJNA309466_P_NODE_9329_length_204_cov_4.251613_g9272_i0 | PRJNA309466 | 9329 | 204 | 4.251613 | 8.67329052 | Rotaria | 231623 | Rotifera | other_Eukaryota | 117 | 1.15e-28 | NR | CAF3184778.1 | 392032 | g9272 | i0 | 83.6 | 9.73529411764706 | 67 | 11 | 98.5 | 0 | 2 | 202 | 586 | 652 | CAF3184778.1 unnamed protein product [Rotaria socialis] | diamond | 1986 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 30060081 | 30060081 | PRJNA309466_P_NODE_17311_length_164_cov_0.904348_g17254_i0 | PRJNA309466 | 17311 | 164 | 0.904348 | 1.48313072 | Rotaria | 231623 | Rotifera | other_Eukaryota | 77.8 | 4.91e-15 | NR | CAF1160516.1 | 392033 | g17254 | i0 | 81.3 | 7.17073170731707 | 48 | 9 | 87.8 | 0 | 1 | 144 | 314 | 361 | CAF1160516.1 unnamed protein product [Rotaria sordida] | diamond | 1176 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 30264121 | 30264121 | PRJNA309466_P_NODE_19072_length_156_cov_7.495327_g19015_i0 | PRJNA309466 | 19072 | 156 | 7.495327 | 11.69271012 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 61.2 | 3.47e-9 | NR | CAF0953406.1 | 433720 | g19015 | i0 | 59.6 | 2.19230769230769 | 57 | 14 | 92.3 | 2 | 1 | 144 | 495 | 551 | CAF0953406.1 unnamed protein product [Adineta steineri] | diamond | 342 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 30660537 | 30660537 | PRJNA309466_P_NODE_17553_length_163_cov_1.824561_g17496_i0 | PRJNA309466 | 17553 | 163 | 1.824561 | 2.97403443 | Rotaria | 231623 | Rotifera | other_Eukaryota | 98.2 | 3.74e-22 | NR | CAF0792199.1 | 2762511 | g17496 | i0 | 92 | 9.20245398773006 | 50 | 4 | 92 | 0 | 159 | 10 | 1075 | 1124 | CAF0792199.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 1500 | 99 | 0.991919191919192 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 31545730 | 31545730 | PRJNA309466_P_NODE_6236_length_235_cov_2.220430_g6179_i0 | PRJNA309466 | 6236 | 235 | 2.22043 | 5.2180105 | Adineta | 104781 | Rotifera | other_Eukaryota | 128 | 2.29e-33 | NR | UJR27421.1 | 104782 | g6179 | i0 | 84.2 | 2.91063829787234 | 76 | 12 | 97 | 0 | 4 | 231 | 38 | 113 | UJR27421.1 hypothetical protein I4U23_008711 [Adineta vaga] | diamond | 684 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 31717773 | 31717773 | PRJNA309466_P_NODE_5577_length_247_cov_2.030303_g5520_i0 | PRJNA309466 | 5577 | 247 | 2.030303 | 5.01484841 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 70.5 | 6.79e-12 | NR | CAF2470098.1 | 2762512 | g5520 | i0 | 69.2 | 1.26315789473684 | 52 | 16 | 63.2 | 0 | 92 | 247 | 645 | 696 | CAF2470098.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 312 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 31893473 | 31893473 | PRJNA309466_P_NODE_6397_length_233_cov_1.016304_g6340_i0 | PRJNA309466 | 6397 | 233 | 1.016304 | 2.36798832 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 131 | 5.939999999999999e-34 | NR | CAF1111633.1 | 392033 | g6340 | i0 | 92.5 | 7.80257510729614 | 67 | 5 | 86.3 | 0 | 206 | 6 | 1 | 67 | CAF1111633.1 unnamed protein product [Rotaria sordida] | diamond | 1818 | 132 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 32192395 | 32192395 | PRJNA309466_P_NODE_17398_length_164_cov_0.904348_g17341_i0 | PRJNA309466 | 17398 | 164 | 0.904348 | 1.48313072 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 43.1 | 0.00953 | NR | UJR20863.1 | 104782 | g17341 | i0 | 66.7 | 0.49390243902439 | 27 | 9 | 49.4 | 0 | 162 | 82 | 1811 | 1837 | UJR20863.1 hypothetical protein I4U23_023972 [Adineta vaga] | diamond | 81 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 32287571 | 32287571 | PRJNA309466_P_NODE_16599_length_166_cov_0.888889_g16542_i0 | PRJNA309466 | 16599 | 166 | 0.888889 | 1.47555574 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 53.9 | 1.52e-6 | NR | UJR23322.1 | 104782 | g16542 | i0 | 59.3 | 0.975903614457831 | 54 | 22 | 97.6 | 0 | 165 | 4 | 270 | 323 | UJR23322.1 hypothetical protein I4U23_026336 [Adineta vaga] | diamond | 162 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 32652173 | 32652173 | PRJNA309466_P_NODE_8940_length_207_cov_3.987342_g8883_i0 | PRJNA309466 | 8940 | 207 | 3.987342 | 8.25379794 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 131 | 8.999999999999999e-34 | NR | CAF0912165.1 | 249248 | g8883 | i0 | 95.6 | 6.89855072463768 | 68 | 3 | 98.6 | 0 | 2 | 205 | 483 | 550 | CAF0912165.1 unnamed protein product [Adineta ricciae] | diamond | 1428 | 132 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae |
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);;