contig_metadata
18 rows where bioproject = "PRJEB12237", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2260855 | 2260855 | PRJEB12237_P_NODE_1982_length_507_cov_7.663136_g1795_i0 | PRJEB12237 | 1982 | 507 | 7.663136 | 38.85209952 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 104 | 1.9899999999999999e-25 | NR | CAF3440507.1 | 2762512 | g1795 | i0 | 71 | 0.408284023668639 | 69 | 20 | 40.8 | 0 | 28 | 234 | 1 | 69 | CAF3440507.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 207 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 5123060 | 5123060 | PRJEB12237_P_NODE_305_length_1250_cov_3.482305_g228_i0 | PRJEB12237 | 305 | 1250 | 3.482305 | 43.5288125 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 232 | 6.15e-70 | NR | CAF1518631.1 | 249248 | g228 | i0 | 48.9 | 3.984 | 262 | 123 | 62.6 | 6 | 908 | 126 | 4 | 255 | CAF1518631.1 unnamed protein product [Adineta ricciae] | diamond | 4980 | 232 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 5123062 | 5123062 | PRJEB12237_P_NODE_3365_length_364_cov_1.407295_g3169_i0 | PRJEB12237 | 3365 | 364 | 1.407295 | 5.1225538 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 93.2 | 1.03e-19 | NR | CAF1245849.1 | 1234261 | g3169 | i0 | 42.9 | 2.91758241758242 | 119 | 65 | 95.6 | 2 | 10 | 357 | 102 | 220 | CAF1245849.1 unnamed protein product [Didymodactylos carnosus] | diamond | 1062 | 93.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 12774325 | 12774325 | PRJEB12237_P_NODE_871_length_784_cov_3.129506_g728_i0 | PRJEB12237 | 871 | 784 | 3.129506 | 24.53532704 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 171 | 5.25e-49 | NR | CAF0930293.1 | 1234261 | g728 | i0 | 51.1 | 0.719387755102041 | 188 | 89 | 70.8 | 3 | 707 | 153 | 15 | 202 | CAF0930293.1 unnamed protein product [Didymodactylos carnosus] | diamond | 564 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 16597496 | 16597496 | PRJEB12237_P_NODE_5494_length_255_cov_1.572727_g5298_i0 | PRJEB12237 | 5494 | 255 | 1.572727 | 4.01045385 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 157 | 1.82e-42 | NR | CAF0920398.1 | 1234261 | g5298 | i0 | 82.1 | 11.8588235294118 | 84 | 15 | 98.8 | 0 | 3 | 254 | 551 | 634 | CAF0920398.1 unnamed protein product [Didymodactylos carnosus] | diamond | 3024 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 27032925 | 27032925 | PRJEB12237_P_NODE_11382_length_156_cov_1.314050_g11186_i0 | PRJEB12237 | 11382 | 156 | 1.31405 | 2.049918 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 63.5 | 5.08e-10 | NR | CAF3400906.1 | 392032 | g11186 | i0 | 58.8 | 2.94230769230769 | 51 | 21 | 98.1 | 0 | 155 | 3 | 312 | 362 | CAF3400906.1 unnamed protein product [Rotaria socialis] | diamond | 459 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 27532239 | 27532239 | PRJEB12237_P_NODE_6343_length_230_cov_1.435897_g6147_i0 | PRJEB12237 | 6343 | 230 | 1.435897 | 3.3025631 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 92.8 | 2.6800000000000003e-21 | NR | CAF1594417.1 | 249248 | g6147 | i0 | 56 | 4.91739130434783 | 75 | 33 | 97.8 | 0 | 230 | 6 | 81 | 155 | CAF1594417.1 unnamed protein product, partial [Adineta ricciae] | diamond | 1131 | 92.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27974276 | 27974276 | PRJEB12237_P_NODE_7325_length_207_cov_2.331395_g7129_i0 | PRJEB12237 | 7325 | 207 | 2.331395 | 4.82598765 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 97.4 | 1.74e-22 | NR | CAF0892122.1 | 104777 | g7129 | i0 | 74.6 | 1.95652173913043 | 67 | 17 | 97.1 | 0 | 2 | 202 | 8 | 74 | CAF0892122.1 unnamed protein product [Brachionus calyciflorus] | diamond | 405 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 28422842 | 28422842 | PRJEB12237_P_NODE_10106_length_167_cov_1.818182_g9910_i0 | PRJEB12237 | 10106 | 167 | 1.818182 | 3.03636394 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 57.8 | 9.08e-9 | NR | CAF0756985.1 | 104777 | g9910 | i0 | 61.4 | 0.790419161676647 | 44 | 17 | 79 | 0 | 166 | 35 | 75 | 118 | CAF0756985.1 unnamed protein product [Brachionus calyciflorus] | diamond | 132 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 28574141 | 28574141 | PRJEB12237_P_NODE_7247_length_209_cov_1.603448_g7051_i0 | PRJEB12237 | 7247 | 209 | 1.603448 | 3.35120632 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 85.5 | 7.95e-20 | NR | CAF5085579.1 | 392030 | g7051 | i0 | 53.6 | 7.13397129186603 | 69 | 30 | 96.2 | 1 | 8 | 208 | 4 | 72 | CAF5085579.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 1491 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 29174260 | 29174260 | PRJEB12237_P_NODE_5389_length_259_cov_1.294643_g5193_i0 | PRJEB12237 | 5389 | 259 | 1.294643 | 3.35312537 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 87.4 | 1.6e-18 | NR | CAF0784306.1 | 249248 | g5193 | i0 | 57.7 | 2.46718146718147 | 71 | 30 | 82.2 | 0 | 215 | 3 | 1 | 71 | CAF0784306.1 unnamed protein product [Adineta ricciae] | diamond | 639 | 87.8 | 0.995444191343964 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 29457964 | 29457964 | PRJEB12237_P_NODE_9470_length_175_cov_1.114286_g9274_i0 | PRJEB12237 | 9470 | 175 | 1.114286 | 1.9500005 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 63.5 | 4.5e-10 | NR | UJR10693.1 | 104782 | g9274 | i0 | 62.3 | 1.81714285714286 | 53 | 20 | 90.9 | 0 | 159 | 1 | 61 | 113 | UJR10693.1 hypothetical protein I4U23_014887 [Adineta vaga] | diamond | 318 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 29805488 | 29805488 | PRJEB12237_P_NODE_4031_length_322_cov_2.759582_g3835_i0 | PRJEB12237 | 4031 | 322 | 2.759582 | 8.88585404 | Metazoa | 33208 | Rotifera | other_Eukaryota | 47 | 0.002 | NR | CAF3722415.1 | 392032 | g3835 | i0 | 36.2 | 1.98447204968944 | 94 | 48 | 87.6 | 3 | 3 | 284 | 91 | 172 | CAF3722415.1 unnamed protein product [Rotaria socialis] | diamond | 639 | 47.4 | 0.991561181434599 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 31138524 | 31138524 | PRJEB12237_P_NODE_1315_length_632_cov_2.510888_g1149_i0 | PRJEB12237 | 1315 | 632 | 2.510888 | 15.86881216 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 108 | 6.909999999999998e-24 | NR | CAF1159794.1 | 249248 | g1149 | i0 | 37.8 | 2.33544303797468 | 164 | 88 | 77.8 | 4 | 630 | 139 | 282 | 431 | CAF1159794.1 unnamed protein product [Adineta ricciae] | diamond | 1476 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 31328504 | 31328504 | PRJEB12237_P_NODE_5276_length_263_cov_3.504386_g5080_i0 | PRJEB12237 | 5276 | 263 | 3.504386 | 9.21653518 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 65.1 | 7.65e-11 | NR | CAF0745393.1 | 249248 | g5080 | i0 | 41.4 | 2.24714828897338 | 70 | 41 | 79.8 | 0 | 4 | 213 | 17 | 86 | CAF0745393.1 unnamed protein product [Adineta ricciae] | diamond | 591 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32372673 | 32372673 | PRJEB12237_P_NODE_2839_length_412_cov_2.015915_g2643_i0 | PRJEB12237 | 2839 | 412 | 2.015915 | 8.3055698 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 141 | 1.7299999999999999e-40 | NR | CAF4591474.1 | 1234261 | g2643 | i0 | 55 | 1.74757281553398 | 120 | 54 | 87.4 | 0 | 43 | 402 | 4 | 123 | CAF4591474.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 720 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 32587743 | 32587743 | PRJEB12237_P_NODE_6379_length_229_cov_1.432990_g6183_i0 | PRJEB12237 | 6379 | 229 | 1.43299 | 3.2815471 | Metazoa | 33208 | Rotifera | other_Eukaryota | 55.1 | 1.44e-6 | NR | RNA08580.1 | 10195 | g6183 | i0 | 45.5 | 3.62882096069869 | 66 | 34 | 83.8 | 2 | 38 | 229 | 1436 | 1501 | RNA08580.1 intraflagellar transport 172-like protein [Brachionus plicatilis] | diamond | 831 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 32814236 | 32814236 | PRJEB12237_P_NODE_11220_length_157_cov_1.311475_g11024_i0 | PRJEB12237 | 11220 | 157 | 1.311475 | 2.05901575 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 91.3 | 8.99e-20 | NR | CAF0866805.1 | 1234261 | g11024 | i0 | 84.6 | 3.97452229299363 | 52 | 8 | 99.4 | 0 | 157 | 2 | 463 | 514 | CAF0866805.1 unnamed protein product [Didymodactylos carnosus] | diamond | 624 | 91.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus |
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);;