contig_metadata
17 rows where bioproject = "PRJNA615175", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26681707 | 26681707 | PRJNA615175_P_NODE_4321_length_746_cov_3.384844_g4162_i0 | PRJNA615175 | 4321 | 746 | 3.384844 | 25.25093624 | root | 1 | Root_unresolved | Root_unresolved | 51.2 | 0.00199 | NR | CAF0765523.1 | 104777 | g4162 | i0 | 51.2 | 1.34718498659517 | 43 | 21 | 17.3 | 0 | 34 | 162 | 298 | 340 | CAF0765523.1 unnamed protein product [Brachionus calyciflorus] | diamond | 1005 | 51.6 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 27901384 | 27901384 | PRJNA615175_P_NODE_27685_length_251_cov_1.651685_g27517_i0 | PRJNA615175 | 27685 | 251 | 1.651685 | 4.14572935 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 50.1 | 6.03e-5 | NR | CAF1160447.1 | 249248 | g27517 | i0 | 35.5 | 2.8207171314741 | 62 | 38 | 71.7 | 1 | 250 | 71 | 106 | 167 | CAF1160447.1 unnamed protein product [Adineta ricciae] | diamond | 708 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27964633 | 27964633 | PRJNA615175_P_NODE_1445_length_1230_cov_8.922213_g1350_i0 | PRJNA615175 | 1445 | 1230 | 8.922213 | 109.7432199 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 294 | 1.63e-91 | NR | CAF0783990.1 | 249248 | g1350 | i0 | 39.6 | 9.27317073170732 | 442 | 220 | 98.8 | 11 | 14 | 1228 | 18 | 449 | CAF0783990.1 unnamed protein product [Adineta ricciae] | diamond | 11406 | 294 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28388109 | 28388109 | PRJNA615175_P_NODE_4946_length_694_cov_5.632850_g4784_i0 | PRJNA615175 | 4946 | 694 | 5.63285 | 39.091979 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 169 | 1.1999999999999998e-48 | NR | CAF3718238.1 | 392032 | g4784 | i0 | 47.8 | 6.09942363112392 | 205 | 96 | 84.3 | 4 | 694 | 110 | 9 | 212 | CAF3718238.1 unnamed protein product [Rotaria socialis] | diamond | 4233 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 28564656 | 28564656 | PRJNA615175_P_NODE_147_length_2509_cov_3.137931_g133_i0 | PRJNA615175 | 147 | 2509 | 3.137931 | 78.73068879 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 498 | 1.8699999999999993e-159 | NR | CAF1046807.1 | 1234261 | g133 | i0 | 37.3 | 0.993622957353527 | 831 | 432 | 98.4 | 13 | 2506 | 38 | 60 | 809 | CAF1046807.1 unnamed protein product [Didymodactylos carnosus] | diamond | 2493 | 498 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 29133120 | 29133120 | PRJNA615175_P_NODE_12649_length_402_cov_1.899696_g12481_i0 | PRJNA615175 | 12649 | 402 | 1.899696 | 7.63677792 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 54.7 | 1.38e-5 | NR | CAF0983132.1 | 1234261 | g12481 | i0 | 30.5 | 0.783582089552239 | 105 | 60 | 73.1 | 4 | 297 | 4 | 407 | 505 | CAF0983132.1 unnamed protein product [Didymodactylos carnosus] | diamond | 315 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 29322301 | 29322301 | PRJNA615175_P_NODE_9529_length_477_cov_3.727723_g9361_i0 | PRJNA615175 | 9529 | 477 | 3.727723 | 17.78123871 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 160 | 2.8899999999999995e-42 | NR | CAF0968545.1 | 433720 | g9361 | i0 | 57.6 | 4.78616352201258 | 125 | 53 | 78.6 | 0 | 75 | 449 | 573 | 697 | CAF0968545.1 unnamed protein product [Adineta steineri] | diamond | 2283 | 160 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29511722 | 29511722 | PRJNA615175_P_NODE_3910_length_787_cov_2.771709_g3758_i0 | PRJNA615175 | 3910 | 787 | 2.771709 | 21.81334983 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 113 | 3.03e-25 | NR | ACC43943.1 | 96448 | g3758 | i0 | 46.9 | 2.09656925031766 | 130 | 61 | 46.9 | 4 | 781 | 413 | 48 | 176 | ACC43943.1 unknown [Philodina roseola] | diamond | 1650 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 30187998 | 30187998 | PRJNA615175_P_NODE_3852_length_792_cov_17.777469_g3701_i0 | PRJNA615175 | 3852 | 792 | 17.777469 | 140.79755448 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 421 | 1.5199999999999999e-146 | NR | CAF0784306.1 | 249248 | g3701 | i0 | 77.5 | 3.94318181818182 | 262 | 56 | 98.9 | 2 | 4 | 786 | 1 | 260 | CAF0784306.1 unnamed protein product [Adineta ricciae] | diamond | 3123 | 421 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 30491096 | 30491096 | PRJNA615175_P_NODE_17453_length_335_cov_1.763359_g17285_i0 | PRJNA615175 | 17453 | 335 | 1.763359 | 5.90725265 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 55.8 | 2.77e-6 | NR | UJR31889.1 | 104782 | g17285 | i0 | 83.3 | 0.322388059701493 | 36 | 6 | 32.2 | 0 | 271 | 164 | 128 | 163 | UJR31889.1 hypothetical protein I4U23_019363 [Adineta vaga] | diamond | 108 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 31009541 | 31009541 | PRJNA615175_P_NODE_18254_length_327_cov_1.590551_g18086_i0 | PRJNA615175 | 18254 | 327 | 1.590551 | 5.20110177 | Philodinidae | 44580 | Rotifera | other_Eukaryota | 104 | 2.78e-26 | NR | CAF0831253.1 | 392033 | g18086 | i0 | 57.4 | 2.65137614678899 | 94 | 36 | 83.5 | 3 | 46 | 318 | 1 | 93 | CAF0831253.1 unnamed protein product [Rotaria sordida] | diamond | 867 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 31198685 | 31198685 | PRJNA615175_P_NODE_10055_length_463_cov_1.953846_g9887_i0 | PRJNA615175 | 10055 | 463 | 1.953846 | 9.04630698 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 141 | 1.81e-37 | NR | CAF0719324.1 | 433720 | g9887 | i0 | 49.7 | 2.81857451403888 | 145 | 68 | 94 | 2 | 439 | 5 | 199 | 338 | CAF0719324.1 unnamed protein product [Adineta steineri] | diamond | 1305 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 31755413 | 31755413 | PRJNA615175_P_NODE_4417_length_737_cov_4.137048_g4258_i0 | PRJNA615175 | 4417 | 737 | 4.137048 | 30.49004376 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 142 | 1.1599999999999999e-34 | NR | CAF0968545.1 | 433720 | g4258 | i0 | 60.7 | 1.36770691994573 | 112 | 42 | 44.8 | 1 | 409 | 80 | 647 | 758 | CAF0968545.1 unnamed protein product [Adineta steineri] | diamond | 1008 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32103410 | 32103410 | PRJNA615175_P_NODE_16598_length_345_cov_1.647059_g16430_i0 | PRJNA615175 | 16598 | 345 | 1.647059 | 5.68235355 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 44.3 | 0.0228 | NR | CAF0918673.1 | 1234261 | g16430 | i0 | 32.9 | 0.634782608695652 | 73 | 47 | 61.7 | 2 | 339 | 127 | 127 | 199 | CAF0918673.1 unnamed protein product [Didymodactylos carnosus] | diamond | 219 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 32166946 | 32166946 | PRJNA615175_P_NODE_4518_length_728_cov_10.691603_g4358_i0 | PRJNA615175 | 4518 | 728 | 10.691603 | 77.83486984 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 119 | 4.83e-28 | NR | CAF1137414.1 | 392033 | g4358 | i0 | 31.8 | 4.45054945054945 | 211 | 119 | 77.9 | 4 | 114 | 680 | 54 | 261 | CAF1137414.1 unnamed protein product [Rotaria sordida] | diamond | 3240 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 32356869 | 32356869 | PRJNA615175_P_NODE_979_length_1432_cov_4.034584_g905_i0 | PRJNA615175 | 979 | 1432 | 4.034584 | 57.77524288 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 487 | 6.369999999999999e-151 | NR | CAF3709489.1 | 2762511 | g905 | i0 | 52.5 | 10.3282122905028 | 493 | 216 | 99.7 | 2 | 2 | 1429 | 2373 | 2864 | CAF3709489.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 14790 | 487 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 32419974 | 32419974 | PRJNA615175_P_NODE_3999_length_778_cov_3.740426_g3843_i0 | PRJNA615175 | 3999 | 778 | 3.740426 | 29.10051428 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 119 | 7.13e-28 | NR | CAF2838268.1 | 2762512 | g3843 | i0 | 31.8 | 5.9305912596401 | 255 | 148 | 95.6 | 9 | 746 | 3 | 53 | 288 | CAF2838268.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 4614 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 |
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);;