contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA797475" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16083807 | 16083807 | PRJNA797475_P_NODE_10673_length_323_cov_1.232000_g10574_i0 | PRJNA797475 | 10673 | 323 | 1.232 | 3.97936 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 107 | 1.74e-26 | NR | CAF0930293.1 | 1234261 | g10574 | i0 | 53.5 | 1.93188854489164 | 101 | 46 | 92.9 | 1 | 316 | 17 | 18 | 118 | CAF0930293.1 unnamed protein product [Didymodactylos carnosus] | diamond | 624 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 18632926 | 18632926 | PRJNA797475_P_NODE_23915_length_248_cov_1.320000_g23816_i0 | PRJNA797475 | 23915 | 248 | 1.32 | 3.2736 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 110 | 3.0400000000000004e-27 | NR | CAF0892122.1 | 104777 | g23816 | i0 | 71.6 | 3.91935483870968 | 81 | 23 | 98 | 0 | 247 | 5 | 3 | 83 | CAF0892122.1 unnamed protein product [Brachionus calyciflorus] | diamond | 972 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 26841703 | 26841703 | PRJNA797475_P_NODE_16281_length_277_cov_1.289216_g16182_i0 | PRJNA797475 | 16281 | 277 | 1.289216 | 3.57112832 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 146 | 5.13e-39 | NR | CAF1441548.1 | 249248 | g16182 | i0 | 76.7 | 20.4693140794224 | 90 | 21 | 97.5 | 0 | 276 | 7 | 423 | 512 | CAF1441548.1 unnamed protein product [Adineta ricciae] | diamond | 5670 | 146 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 26958784 | 26958784 | PRJNA797475_P_NODE_28782_length_243_cov_0.905882_g28683_i0 | PRJNA797475 | 28782 | 243 | 0.905882 | 2.20129326 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 80.1 | 5.36e-16 | NR | CAF1687300.1 | 249248 | g28683 | i0 | 46.8 | 2.92592592592593 | 79 | 42 | 97.5 | 0 | 3 | 239 | 152 | 230 | CAF1687300.1 unnamed protein product, partial [Adineta ricciae] | diamond | 711 | 80.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27116889 | 27116889 | PRJNA797475_P_NODE_15342_length_282_cov_1.105263_g15243_i0 | PRJNA797475 | 15342 | 282 | 1.105263 | 3.11684166 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 72 | 3.52e-13 | NR | UJR24672.1 | 104782 | g15243 | i0 | 42 | 0.861702127659574 | 81 | 47 | 86.2 | 0 | 279 | 37 | 10 | 90 | UJR24672.1 hypothetical protein I4U23_006045 [Adineta vaga] | diamond | 243 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 27252567 | 27252567 | PRJNA797475_P_NODE_26703_length_245_cov_0.895349_g26604_i0 | PRJNA797475 | 26703 | 245 | 0.895349 | 2.19360505 | Metazoa | 33208 | Rotifera | other_Eukaryota | 109 | 1.11e-25 | NR | CAF0836133.1 | 104777 | g26604 | i0 | 64.2 | 7.93469387755102 | 81 | 29 | 99.2 | 0 | 244 | 2 | 303 | 383 | CAF0836133.1 unnamed protein product [Brachionus calyciflorus] | diamond | 1944 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 29138387 | 29138387 | PRJNA797475_P_NODE_9129_length_344_cov_1.988930_g9030_i0 | PRJNA797475 | 9129 | 344 | 1.98893 | 6.8419192 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 182 | 2.3699999999999997e-56 | NR | KAI3387873.1 | 104778 | g9030 | i0 | 73.7 | 0.994186046511628 | 114 | 30 | 99.4 | 0 | 342 | 1 | 32 | 145 | KAI3387873.1 hypothetical protein SNEBB_008664 [Seison nebaliae] | diamond | 342 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 29241965 | 29241965 | PRJNA797475_P_NODE_12949_length_297_cov_2.566964_g12850_i0 | PRJNA797475 | 12949 | 297 | 2.566964 | 7.62388308 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 4.25e-6 | NR | UJR07917.1 | 104782 | g12850 | i0 | 51 | 2.42424242424242 | 49 | 21 | 49.5 | 1 | 1 | 147 | 325 | 370 | UJR07917.1 hypothetical protein I4U23_012200 [Adineta vaga] | diamond | 720 | 55.1 | 0.992740471869329 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 29295983 | 29295983 | PRJNA797475_P_NODE_25169_length_247_cov_0.885057_g25070_i0 | PRJNA797475 | 25169 | 247 | 0.885057 | 2.18609079 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 63.2 | 3.15e-10 | NR | CAF1148101.1 | 1234261 | g25070 | i0 | 45.7 | 0.983805668016194 | 81 | 43 | 98.4 | 1 | 3 | 245 | 13 | 92 | CAF1148101.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 243 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 29737784 | 29737784 | PRJNA797475_P_NODE_17890_length_268_cov_2.328205_g17791_i0 | PRJNA797475 | 17890 | 268 | 2.328205 | 6.2395894 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 43.9 | 0.00803 | NR | RNA09523.1 | 10195 | g17791 | i0 | 42.6 | 0.604477611940298 | 54 | 27 | 57.1 | 2 | 2 | 154 | 76 | 128 | RNA09523.1 hypothetical protein BpHYR1_005795 [Brachionus plicatilis] | diamond | 162 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 29959101 | 29959101 | PRJNA797475_P_NODE_13811_length_290_cov_1.299539_g13712_i0 | PRJNA797475 | 13811 | 290 | 1.299539 | 3.7686631 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 113 | 3.32e-30 | NR | CAF3440507.1 | 2762512 | g13712 | i0 | 78.3 | 0.713793103448276 | 69 | 15 | 71.4 | 0 | 30 | 236 | 1 | 69 | CAF3440507.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 207 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 30243582 | 30243582 | PRJNA797475_P_NODE_20072_length_257_cov_1.673913_g19973_i0 | PRJNA797475 | 20072 | 257 | 1.673913 | 4.30195641 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 65.1 | 3.45e-10 | NR | CAF4042716.1 | 392033 | g19973 | i0 | 41.5 | 6.5136186770428 | 65 | 35 | 75.9 | 1 | 204 | 10 | 109 | 170 | CAF4042716.1 unnamed protein product, partial [Rotaria sordida] | diamond | 1674 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 31792067 | 31792067 | PRJNA797475_P_NODE_21537_length_251_cov_0.865169_g21438_i0 | PRJNA797475 | 21537 | 251 | 0.865169 | 2.17157419 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 51.6 | 2.92e-5 | NR | CAF1416974.1 | 249248 | g21438 | i0 | 40 | 0.956175298804781 | 80 | 46 | 93.2 | 2 | 246 | 13 | 273 | 352 | CAF1416974.1 unnamed protein product [Adineta ricciae] | diamond | 240 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32235573 | 32235573 | PRJNA797475_P_NODE_18558_length_265_cov_1.604167_g18459_i0 | PRJNA797475 | 18558 | 265 | 1.604167 | 4.25104255 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 97.1 | 8.96e-24 | NR | RNA03737.1 | 10195 | g18459 | i0 | 86.4 | 0.667924528301887 | 59 | 8 | 66.8 | 0 | 87 | 263 | 2 | 60 | RNA03737.1 60S ribosomal L30 [Brachionus plicatilis] | diamond | 177 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis |
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);;