contig_metadata
19 rows where bioproject = "PRJNA938397", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11459771 | 11459771 | PRJNA938397_S_NODE_27969_length_208_cov_23.894737_g27728_i0 | PRJNA938397 | 27969 | 208 | 23.894737 | 49.70105296 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 57.8 | 4.91e-9 | NR | RNA21320.1 | 10195 | g27728 | i0 | 64.7 | 11.5240384615385 | 34 | 12 | 49 | 0 | 180 | 79 | 40 | 73 | RNA21320.1 cytochrome c oxidase copper chaperone [Brachionus plicatilis] | diamond | 2397 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 16215414 | 16215414 | PRJNA938397_S_NODE_13953_length_292_cov_15.050980_g13712_i0 | PRJNA938397 | 13953 | 292 | 15.05098 | 43.9488616 | Metazoa | 33208 | Rotifera | other_Eukaryota | 59.7 | 7.18e-8 | NR | CAF1021331.1 | 104777 | g13712 | i0 | 61.5 | 3.76027397260274 | 39 | 15 | 40.1 | 0 | 24 | 140 | 785 | 823 | CAF1021331.1 unnamed protein product [Brachionus calyciflorus] | diamond | 1098 | 60.1 | 0.993344425956739 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 21315062 | 21315062 | PRJNA938397_S_NODE_27837_length_209_cov_5.470930_g27596_i0 | PRJNA938397 | 27837 | 209 | 5.47093 | 11.4342437 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 99.4 | 7.24e-23 | NR | RNA11224.1 | 10195 | g27596 | i0 | 67.6 | 1.96650717703349 | 68 | 21 | 96.2 | 1 | 6 | 206 | 188 | 255 | RNA11224.1 cathepsin L [Brachionus plicatilis] | diamond | 411 | 99.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 21315638 | 21315638 | PRJNA938397_S_NODE_42097_length_169_cov_4.318182_g41856_i0 | PRJNA938397 | 42097 | 169 | 4.318182 | 7.29772758 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 113 | 1.44e-27 | NR | CAF1387427.1 | 249248 | g41856 | i0 | 85.7 | 11.9467455621302 | 56 | 8 | 99.4 | 0 | 168 | 1 | 559 | 614 | CAF1387427.1 unnamed protein product [Adineta ricciae] | diamond | 2019 | 114 | 0.991228070175439 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 26930106 | 26930106 | PRJNA938397_S_NODE_49842_length_155_cov_3.415254_g49601_i0 | PRJNA938397 | 49842 | 155 | 3.415254 | 5.2936437 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 48.1 | 1.32e-4 | NR | CAF0715762.1 | 104777 | g49601 | i0 | 63.3 | 4.64516129032258 | 30 | 11 | 58.1 | 0 | 9 | 98 | 251 | 280 | CAF0715762.1 unnamed protein product [Brachionus calyciflorus] | diamond | 720 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 27221390 | 27221390 | PRJNA938397_S_NODE_22582_length_232_cov_10.246154_g22341_i0 | PRJNA938397 | 22582 | 232 | 10.246154 | 23.77107728 | Metazoa | 33208 | Rotifera | other_Eukaryota | 84.7 | 5.36e-17 | NR | CAF0851289.1 | 104777 | g22341 | i0 | 58.9 | 4.22844827586207 | 56 | 23 | 72.4 | 0 | 231 | 64 | 334 | 389 | CAF0851289.1 unnamed protein product [Brachionus calyciflorus] | diamond | 981 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 28383024 | 28383024 | PRJNA938397_S_NODE_42726_length_168_cov_2.580153_g42485_i0 | PRJNA938397 | 42726 | 168 | 2.580153 | 4.33465704 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 89.7 | 5.89e-22 | NR | CAF1459940.1 | 1234261 | g42485 | i0 | 71.9 | 4 | 57 | 14 | 98.2 | 2 | 3 | 167 | 7 | 63 | CAF1459940.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 672 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 28477810 | 28477810 | PRJNA938397_S_NODE_16146_length_273_cov_8.394068_g15905_i0 | PRJNA938397 | 16146 | 273 | 8.394068 | 22.91580564 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 66.2 | 2.85e-10 | NR | RNA36379.1 | 10195 | g15905 | i0 | 47.7 | 7.87912087912088 | 65 | 34 | 71.4 | 0 | 232 | 38 | 719 | 783 | RNA36379.1 inner nuclear membrane Man1 [Brachionus plicatilis] | diamond | 2151 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 30119622 | 30119622 | PRJNA938397_S_NODE_22832_length_231_cov_7.108247_g22591_i0 | PRJNA938397 | 22832 | 231 | 7.108247 | 16.42005057 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 70.9 | 2.12e-12 | NR | CAF0893039.1 | 104777 | g22591 | i0 | 58.2 | 0.714285714285714 | 55 | 22 | 71.4 | 1 | 227 | 63 | 234 | 287 | CAF0893039.1 unnamed protein product [Brachionus calyciflorus] | diamond | 165 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 30442884 | 30442884 | PRJNA938397_S_NODE_26073_length_216_cov_5.407821_g25832_i0 | PRJNA938397 | 26073 | 216 | 5.407821 | 11.68089336 | Metazoa | 33208 | Rotifera | other_Eukaryota | 67.8 | 2.82e-11 | NR | CAF0762324.1 | 104777 | g25832 | i0 | 56.9 | 6.72222222222222 | 58 | 23 | 79.2 | 2 | 17 | 187 | 264 | 320 | CAF0762324.1 unnamed protein product [Brachionus calyciflorus] | diamond | 1452 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 30727067 | 30727067 | PRJNA938397_S_NODE_17474_length_263_cov_21.907080_g17233_i0 | PRJNA938397 | 17474 | 263 | 21.90708 | 57.6156204 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 69.7 | 1.34e-11 | NR | CAF3670618.1 | 392033 | g17233 | i0 | 43.5 | 4.24334600760456 | 62 | 34 | 70.7 | 1 | 1 | 186 | 320 | 380 | CAF3670618.1 unnamed protein product [Rotaria sordida] | diamond | 1116 | 70.1 | 0.994293865905849 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 31043399 | 31043399 | PRJNA938397_S_NODE_31895_length_195_cov_4.993671_g31654_i0 | PRJNA938397 | 31895 | 195 | 4.993671 | 9.73765845 | Metazoa | 33208 | Rotifera | other_Eukaryota | 42.7 | 0.00628 | NR | UJR26311.1 | 104782 | g31654 | i0 | 64 | 3.84615384615385 | 25 | 9 | 38.5 | 0 | 188 | 114 | 67 | 91 | UJR26311.1 hypothetical protein I4U23_007649 [Adineta vaga] | diamond | 750 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 31447098 | 31447098 | PRJNA938397_S_NODE_13116_length_300_cov_21.212928_g12875_i0 | PRJNA938397 | 13116 | 300 | 21.212928 | 63.638784 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 42 | 0.0284 | NR | CAF4502069.1 | 2762512 | g12875 | i0 | 33.3 | 0.6 | 60 | 40 | 60 | 0 | 4 | 183 | 16 | 75 | CAF4502069.1 unnamed protein product, partial [Rotaria sp. Silwood2] | diamond | 180 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 31447099 | 31447099 | PRJNA938397_S_NODE_27196_length_211_cov_43.408046_g26955_i0 | PRJNA938397 | 27196 | 211 | 43.408046 | 91.59097706 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 40.4 | 0.0323 | NR | CAF4051568.1 | 392030 | g26955 | i0 | 47.5 | 0.568720379146919 | 40 | 20 | 55.5 | 1 | 208 | 92 | 39 | 78 | CAF4051568.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 120 | 40.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 31984729 | 31984729 | PRJNA938397_S_NODE_20598_length_243_cov_13.509709_g20357_i0 | PRJNA938397 | 20598 | 243 | 13.509709 | 32.82859287 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 50.4 | 1.47e-5 | NR | CAF0988611.1 | 249248 | g20357 | i0 | 45.2 | 0.518518518518518 | 42 | 23 | 51.9 | 0 | 240 | 115 | 80 | 121 | CAF0988611.1 unnamed protein product [Adineta ricciae] | diamond | 126 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32403238 | 32403238 | PRJNA938397_S_NODE_28159_length_208_cov_3.017544_g27918_i0 | PRJNA938397 | 28159 | 208 | 3.017544 | 6.27649152 | Metazoa | 33208 | Rotifera | other_Eukaryota | 73.9 | 1.93e-13 | NR | CAF1033404.1 | 104777 | g27918 | i0 | 65.9 | 7.91826923076923 | 44 | 13 | 63.5 | 1 | 3 | 134 | 337 | 378 | CAF1033404.1 unnamed protein product, partial [Brachionus calyciflorus] | diamond | 1647 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 32529979 | 32529979 | PRJNA938397_S_NODE_45159_length_163_cov_3.793651_g44918_i0 | PRJNA938397 | 45159 | 163 | 3.793651 | 6.18365113 | Metazoa | 33208 | Rotifera | other_Eukaryota | 56.6 | 8.98e-8 | NR | CAF3414080.1 | 392032 | g44918 | i0 | 57.9 | 5.59509202453988 | 38 | 16 | 69.9 | 0 | 6 | 119 | 185 | 222 | CAF3414080.1 unnamed protein product [Rotaria socialis] | diamond | 912 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 32593005 | 32593005 | PRJNA938397_S_NODE_53439_length_150_cov_1.362832_g53198_i0 | PRJNA938397 | 53439 | 150 | 1.362832 | 2.044248 | Metazoa | 33208 | Rotifera | other_Eukaryota | 86.7 | 2.84e-18 | NR | RMZ99815.1 | 10195 | g53198 | i0 | 85.7 | 2.94 | 49 | 7 | 98 | 0 | 149 | 3 | 362 | 410 | RMZ99815.1 cAMP-dependent kinase type I-beta regulatory subunit isoform X1 [Brachionus plicatilis] | diamond | 441 | 87 | 0.996551724137931 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 32680080 | 32680080 | PRJNA938397_S_NODE_11380_length_319_cov_4.237589_g11139_i0 | PRJNA938397 | 11380 | 319 | 4.237589 | 13.51790891 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 55.1 | 4.23e-6 | NR | CAF0726300.1 | 104777 | g11139 | i0 | 48.1 | 0.489028213166144 | 52 | 27 | 48.9 | 0 | 312 | 157 | 578 | 629 | CAF0726300.1 unnamed protein product [Brachionus calyciflorus] | diamond | 156 | 55.1 | 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);;