contig_metadata
22 rows where bioproject = "PRJNA1248424", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2903366 | 2903366 | PRJNA1248424_P_NODE_3683_length_3146_cov_5.462089_g2751_i0 | PRJNA1248424 | 3683 | 3146 | 5.462089 | 171.83731994 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 513 | 7.879999999999999e-157 | NR | KAI3378399.1 | 104778 | g2751 | i0 | 44.5 | 1.17005721551176 | 613 | 318 | 57.5 | 8 | 425 | 2233 | 879 | 1479 | KAI3378399.1 hypothetical protein SNEBB_008308 [Seison nebaliae] | diamond | 3681 | 513 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 11831889 | 11831889 | PRJNA1248424_P_NODE_75550_length_245_cov_0.895349_g69481_i0 | PRJNA1248424 | 75550 | 245 | 0.895349 | 2.19360505 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 149 | 4.11e-44 | NR | RNA44166.1 | 10195 | g69481 | i0 | 92 | 0.918367346938776 | 75 | 6 | 91.8 | 0 | 3 | 227 | 79 | 153 | RNA44166.1 40S ribosomal S15 [Brachionus plicatilis] | diamond | 225 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 15655656 | 15655656 | PRJNA1248424_P_NODE_44113_length_343_cov_1.133333_g38050_i0 | PRJNA1248424 | 44113 | 343 | 1.133333 | 3.88733219 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 168 | 3.11e-47 | NR | YP_001739865.1 | 10195 | g38050 | i0 | 71.8 | 1.92419825072886 | 110 | 31 | 96.2 | 0 | 2 | 331 | 387 | 496 | YP_001739865.1 cytochrome c oxidase subunit I [Brachionus plicatilis] | diamond | 660 | 168 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 26820651 | 26820651 | PRJNA1248424_P_NODE_76741_length_244_cov_0.900585_g70672_i0 | PRJNA1248424 | 76741 | 244 | 0.900585 | 2.1974274 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 45.4 | 0.00407 | NR | RNA20776.1 | 10195 | g70672 | i0 | 33.8 | 0.799180327868853 | 65 | 40 | 79.9 | 2 | 224 | 30 | 77 | 138 | RNA20776.1 serine protease 27-like, partial [Brachionus plicatilis] | diamond | 195 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 27105064 | 27105064 | PRJNA1248424_P_NODE_68522_length_252_cov_1.290503_g62453_i0 | PRJNA1248424 | 68522 | 252 | 1.290503 | 3.25206756 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 97.4 | 2.28e-21 | NR | CAF1351809.1 | 1234261 | g62453 | i0 | 61 | 0.916666666666667 | 77 | 30 | 91.7 | 0 | 15 | 245 | 334 | 410 | CAF1351809.1 unnamed protein product [Didymodactylos carnosus] | diamond | 231 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 27881321 | 27881321 | PRJNA1248424_P_NODE_24125_length_681_cov_1.720395_g18233_i0 | PRJNA1248424 | 24125 | 681 | 1.720395 | 11.71588995 | Metazoa | 33208 | Rotifera | other_Eukaryota | 119 | 1.18e-26 | NR | KAI3379074.1 | 104778 | g18233 | i0 | 46.8 | 1.47136563876652 | 111 | 58 | 48.5 | 1 | 135 | 464 | 1350 | 1460 | KAI3379074.1 hypothetical protein SNEBB_002215 [Seison nebaliae] | diamond | 1002 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 28241983 | 28241983 | PRJNA1248424_P_NODE_14846_length_1243_cov_3.514530_g10428_i0 | PRJNA1248424 | 14846 | 1243 | 3.51453 | 43.6856079 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 267 | 1.35e-81 | NR | CAF3423606.1 | 2762512 | g10428 | i0 | 60.8 | 0.480289621882542 | 199 | 78 | 48 | 0 | 209 | 805 | 91 | 289 | CAF3423606.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 597 | 267 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 28241991 | 28241991 | PRJNA1248424_P_NODE_36466_length_410_cov_0.955490_g30410_i0 | PRJNA1248424 | 36466 | 410 | 0.95549 | 3.917509 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 44.7 | 0.0246 | NR | CAF1470293.1 | 249248 | g30410 | i0 | 37.5 | 0.468292682926829 | 64 | 38 | 46.8 | 1 | 266 | 75 | 1 | 62 | CAF1470293.1 unnamed protein product [Adineta ricciae] | diamond | 192 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28512818 | 28512818 | PRJNA1248424_P_NODE_74627_length_246_cov_0.890173_g68558_i0 | PRJNA1248424 | 74627 | 246 | 0.890173 | 2.18982558 | Metazoa | 33208 | Rotifera | other_Eukaryota | 117 | 8.7e-29 | NR | RNA24969.1 | 10195 | g68558 | i0 | 73.8 | 2.92682926829268 | 80 | 21 | 97.6 | 0 | 241 | 2 | 449 | 528 | RNA24969.1 calcium uptake 1 mitochondrial isoform X2 [Brachionus plicatilis] | diamond | 720 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 28936876 | 28936876 | PRJNA1248424_P_NODE_21868_length_776_cov_4.004267_g16153_i0 | PRJNA1248424 | 21868 | 776 | 4.004267 | 31.07311192 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 70.1 | 1.28e-9 | NR | CAF4257245.1 | 2762512 | g16153 | i0 | 29.8 | 1.09020618556701 | 141 | 97 | 54.5 | 1 | 432 | 10 | 17 | 155 | CAF4257245.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 846 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 30168236 | 30168236 | PRJNA1248424_P_NODE_37872_length_394_cov_1.271028_g31815_i0 | PRJNA1248424 | 37872 | 394 | 1.271028 | 5.00785032 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 86.7 | 6.49e-18 | NR | CAF3324976.1 | 392032 | g31815 | i0 | 40.9 | 3.47208121827411 | 110 | 61 | 83.8 | 1 | 346 | 17 | 10 | 115 | CAF3324976.1 unnamed protein product [Rotaria socialis] | diamond | 1368 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 30484426 | 30484426 | PRJNA1248424_P_NODE_26533_length_600_cov_1.117647_g20553_i0 | PRJNA1248424 | 26533 | 600 | 1.117647 | 6.705882 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 48.9 | 0.00625 | NR | CAF1476590.1 | 392030 | g20553 | i0 | 36.1 | 0.83 | 83 | 51 | 40.5 | 1 | 305 | 63 | 544 | 626 | CAF1476590.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 498 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 30578891 | 30578891 | PRJNA1248424_P_NODE_70273_length_250_cov_0.870056_g64204_i0 | PRJNA1248424 | 70273 | 250 | 0.870056 | 2.17514 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 40.8 | 0.0394 | NR | CAF4571795.1 | 392032 | g64204 | i0 | 38.2 | 0.66 | 55 | 34 | 66 | 0 | 57 | 221 | 6 | 60 | CAF4571795.1 unnamed protein product, partial [Rotaria socialis] | diamond | 165 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 30768792 | 30768792 | PRJNA1248424_P_NODE_58694_length_279_cov_1.315534_g52626_i0 | PRJNA1248424 | 58694 | 279 | 1.315534 | 3.67033986 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 157 | 6.9099999999999986e-43 | NR | CAF0784665.1 | 104777 | g52626 | i0 | 82.4 | 0.978494623655914 | 91 | 16 | 97.8 | 0 | 2 | 274 | 286 | 376 | CAF0784665.1 unnamed protein product [Brachionus calyciflorus] | diamond | 273 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 30831825 | 30831825 | PRJNA1248424_P_NODE_21154_length_810_cov_30.168250_g15520_i0 | PRJNA1248424 | 21154 | 810 | 30.16825 | 244.362825 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 185 | 6.739999999999999e-54 | NR | UJR08980.1 | 104782 | g15520 | i0 | 50 | 9.37037037037037 | 174 | 87 | 64.4 | 0 | 728 | 207 | 38 | 211 | UJR08980.1 hypothetical protein I4U23_013230 [Adineta vaga] | diamond | 7590 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 31305851 | 31305851 | PRJNA1248424_P_NODE_27415_length_576_cov_1.493042_g21417_i0 | PRJNA1248424 | 27415 | 576 | 1.493042 | 8.59992192 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 88.6 | 1.43e-16 | NR | KAI3378399.1 | 104778 | g21417 | i0 | 34.7 | 0.869791666666667 | 167 | 100 | 84.9 | 4 | 84 | 572 | 388 | 549 | KAI3378399.1 hypothetical protein SNEBB_008308 [Seison nebaliae] | diamond | 501 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 31527456 | 31527456 | PRJNA1248424_P_NODE_70556_length_250_cov_0.870056_g64487_i0 | PRJNA1248424 | 70556 | 250 | 0.870056 | 2.17514 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 61.6 | 8.67e-9 | NR | CAF0946219.1 | 104777 | g64487 | i0 | 46.4 | 5.832 | 56 | 30 | 67.2 | 0 | 179 | 12 | 77 | 132 | CAF0946219.1 unnamed protein product [Brachionus calyciflorus] | diamond | 1458 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 31653668 | 31653668 | PRJNA1248424_P_NODE_30717_length_497_cov_2.757075_g24678_i0 | PRJNA1248424 | 30717 | 497 | 2.757075 | 13.70266275 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 46.6 | 0.0174 | NR | CAF4259624.1 | 433720 | g24678 | i0 | 56.8 | 0.857142857142857 | 37 | 16 | 22.3 | 0 | 316 | 426 | 54 | 90 | CAF4259624.1 unnamed protein product, partial [Adineta steineri] | diamond | 426 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32001841 | 32001841 | PRJNA1248424_P_NODE_76618_length_244_cov_0.900585_g70549_i0 | PRJNA1248424 | 76618 | 244 | 0.900585 | 2.1974274 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 85.1 | 4.72e-17 | NR | KAI3378399.1 | 104778 | g70549 | i0 | 50 | 0.983606557377049 | 80 | 39 | 97.1 | 1 | 1 | 237 | 1340 | 1419 | KAI3378399.1 hypothetical protein SNEBB_008308 [Seison nebaliae] | diamond | 240 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 32096715 | 32096715 | PRJNA1248424_P_NODE_18738_length_948_cov_17.747429_g13468_i0 | PRJNA1248424 | 18738 | 948 | 17.747429 | 168.24562692 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 53.1 | 1.13e-4 | NR | UJR14136.1 | 104782 | g13468 | i0 | 44.6 | 0.658227848101266 | 74 | 34 | 22.2 | 2 | 190 | 399 | 27 | 97 | UJR14136.1 hypothetical protein I4U23_001130 [Adineta vaga] | diamond | 624 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 32634058 | 32634058 | PRJNA1248424_P_NODE_76860_length_244_cov_0.900585_g70791_i0 | PRJNA1248424 | 76860 | 244 | 0.900585 | 2.1974274 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 63.5 | 1.77e-9 | NR | RNA06162.1 | 10195 | g70791 | i0 | 45.1 | 0.872950819672131 | 71 | 37 | 87.3 | 2 | 8 | 220 | 523 | 591 | RNA06162.1 nose resistant to fluoxetine 6-like, partial [Brachionus plicatilis] | diamond | 213 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 32778135 | 32778135 | PRJNA1248424_P_NODE_78860_length_242_cov_0.911243_g72791_i0 | PRJNA1248424 | 78860 | 242 | 0.911243 | 2.20520806 | Metazoa | 33208 | Rotifera | other_Eukaryota | 50.4 | 5.44e-5 | NR | CAF0890053.1 | 104777 | g72791 | i0 | 53.5 | 1.16528925619835 | 43 | 20 | 53.3 | 0 | 238 | 110 | 54 | 96 | CAF0890053.1 unnamed protein product [Brachionus calyciflorus] | diamond | 282 | 50.8 | 0.992125984251969 | 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);;