contig_metadata
24 rows where bioproject = "PRJEB11748", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4810935 | 4810935 | PRJEB11748_P_NODE_148084_length_337_cov_12.634058_g145903_i0 | PRJEB11748 | 148084 | 337 | 12.634058 | 42.57677546 | Ploima | 84394 | Rotifera | other_Eukaryota | 446 | 1.25e-120 | NTclustered | gi|61200811|gb|AY829085.1| | 84397 | g145903 | i0 | 91.239 | 57.593471810089 | 331 | 24 | 97 | 4 | 11 | 337 | 2104 | 1775 | Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence | blastn | 19409 | 448 | 0.995535714285714 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sieboldii | |
| 6397227 | 6397227 | PRJEB11748_P_NODE_38766_length_701_cov_13.584375_g36765_i0 | PRJEB11748 | 38766 | 701 | 13.584375 | 95.22646875 | Asplanchna sieboldii | 84397 | Rotifera | other_Eukaryota | 1107 | 0 | NTclustered | gi|61200811|gb|AY829085.1| | 84397 | g36765 | i0 | 95.982 | 83.5820256776034 | 672 | 24 | 96 | 2 | 22 | 691 | 1434 | 2104 | Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence | blastn | 58591 | 1107 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sieboldii | |
| 14044022 | 14044022 | PRJEB11748_P_NODE_203752_length_280_cov_11.926941_g201569_i0 | PRJEB11748 | 203752 | 280 | 11.926941 | 33.3954348 | Macrotrachela quadricornifera | 104788 | Rotifera | other_Eukaryota | 351 | 2.27e-92 | NTclustered | gi|402761759|gb|JX184011.1| | 104788 | g201569 | i0 | 91.406 | 15.6 | 256 | 22 | 91 | 0 | 3 | 258 | 617 | 362 | Macrotrachela quadricornifera isolate MQ cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial | blastn | 4368 | 351 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Macrotrachela | Macrotrachela quadricornifera | |
| 16287338 | 16287338 | PRJEB11748_P_NODE_367293_length_189_cov_2.492188_g365110_i0 | PRJEB11748 | 367293 | 189 | 2.492188 | 4.71023532 | root | 1 | Root_unresolved | Root_unresolved | 67.8 | 1.96e-11 | NR | CAF1315415.1 | 392033 | g365110 | i0 | 60.4 | 7.36507936507936 | 53 | 21 | 84.1 | 0 | 188 | 30 | 1 | 53 | CAF1315415.1 unnamed protein product [Rotaria sordida] | diamond | 1392 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 18836628 | 18836628 | PRJEB11748_P_NODE_40855_length_680_cov_96.096931_g38823_i0 | PRJEB11748 | 40855 | 680 | 96.096931 | 653.4591308 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 1075 | 0 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g38823 | i0 | 97.91 | 38.6544117647059 | 622 | 11 | 91 | 2 | 36 | 656 | 2190 | 1570 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 26285 | 1081 | 0.994449583718779 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 19140680 | 19140680 | PRJEB11748_P_NODE_164116_length_318_cov_14.455253_g161933_i0 | PRJEB11748 | 164116 | 318 | 14.455253 | 45.96770454 | Asplanchna sieboldii | 84397 | Rotifera | other_Eukaryota | 451 | 2.51e-122 | NTclustered | gi|61200811|gb|AY829085.1| | 84397 | g161933 | i0 | 94.237 | 88.9874213836478 | 295 | 17 | 93 | 0 | 1 | 295 | 1727 | 1433 | Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence | blastn | 28298 | 451 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sieboldii | |
| 26621207 | 26621207 | PRJEB11748_P_NODE_144181_length_342_cov_39.967972_g142002_i0 | PRJEB11748 | 144181 | 342 | 39.967972 | 136.69046424 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 64.7 | 3.59e-11 | NR | CAF0964141.1 | 1234261 | g142002 | i0 | 52.5 | 0.517543859649123 | 59 | 28 | 51.8 | 0 | 122 | 298 | 13 | 71 | CAF0964141.1 unnamed protein product [Didymodactylos carnosus] | diamond | 177 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 27000899 | 27000899 | PRJEB11748_P_NODE_100122_length_417_cov_9.974719_g97952_i0 | PRJEB11748 | 100122 | 417 | 9.974719 | 41.59457823 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 46.2 | 0.00607 | NR | CAF0980087.1 | 1234261 | g97952 | i0 | 31.1 | 0.647482014388489 | 90 | 58 | 62.6 | 3 | 289 | 29 | 68 | 156 | CAF0980087.1 unnamed protein product [Didymodactylos carnosus] | diamond | 270 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 27000919 | 27000919 | PRJEB11748_P_NODE_130262_length_362_cov_7.591362_g128085_i0 | PRJEB11748 | 130262 | 362 | 7.591362 | 27.48073044 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 53.1 | 3e-5 | NR | CAF1399572.1 | 1234261 | g128085 | i0 | 32.9 | 1.81491712707182 | 73 | 47 | 58.8 | 1 | 66 | 278 | 316 | 388 | CAF1399572.1 unnamed protein product [Didymodactylos carnosus] | diamond | 657 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 27349215 | 27349215 | PRJEB11748_P_NODE_302103_length_218_cov_8.464968_g299920_i0 | PRJEB11748 | 302103 | 218 | 8.464968 | 18.45363024 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 64.7 | 1.66e-10 | NR | CAF1362956.1 | 433720 | g299920 | i0 | 46 | 0.688073394495413 | 50 | 27 | 68.8 | 0 | 28 | 177 | 168 | 217 | CAF1362956.1 unnamed protein product [Adineta steineri] | diamond | 150 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 27469246 | 27469246 | PRJEB11748_P_NODE_51443_length_597_cov_279.048507_g49335_i0 | PRJEB11748 | 51443 | 597 | 279.048507 | 1665.91958679 | Rotaria | 231623 | Rotifera | other_Eukaryota | 62.4 | 1.44e-7 | NR | CAF0788271.1 | 2762511 | g49335 | i0 | 62.2 | 0.698492462311558 | 45 | 17 | 22.6 | 0 | 335 | 201 | 232 | 276 | CAF0788271.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 417 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 27879537 | 27879537 | PRJEB11748_P_NODE_291825_length_223_cov_8.240741_g289642_i0 | PRJEB11748 | 291825 | 223 | 8.240741 | 18.37685243 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 59.3 | 1.03e-8 | NR | CAF0756576.1 | 249248 | g289642 | i0 | 86.2 | 1.95067264573991 | 29 | 4 | 39 | 0 | 197 | 111 | 146 | 174 | CAF0756576.1 unnamed protein product [Adineta ricciae] | diamond | 435 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28454332 | 28454332 | PRJEB11748_P_NODE_339506_length_202_cov_15.843972_g337323_i0 | PRJEB11748 | 339506 | 202 | 15.843972 | 32.00482344 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 94.7 | 4.59e-21 | NR | CAF1110113.1 | 392033 | g337323 | i0 | 87 | 1.6039603960396 | 54 | 7 | 80.2 | 0 | 39 | 200 | 240 | 293 | CAF1110113.1 unnamed protein product [Rotaria sordida] | diamond | 324 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 28738180 | 28738180 | PRJEB11748_P_NODE_142527_length_345_cov_2.281690_g140348_i0 | PRJEB11748 | 142527 | 345 | 2.28169 | 7.8718305 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 88.6 | 1e-17 | NR | CAF4027074.1 | 2762511 | g140348 | i0 | 79.3 | 0.504347826086956 | 58 | 8 | 47 | 1 | 184 | 345 | 462 | 519 | CAF4027074.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 174 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 29149194 | 29149194 | PRJEB11748_P_NODE_43289_length_658_cov_8.120603_g41226_i0 | PRJEB11748 | 43289 | 658 | 8.120603 | 53.43356774 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 238 | 4.619999999999999e-74 | NR | CAF0869285.1 | 2762511 | g41226 | i0 | 87.9 | 3.87082066869301 | 141 | 14 | 64.3 | 1 | 558 | 136 | 1 | 138 | CAF0869285.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 2547 | 238 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 29395108 | 29395108 | PRJEB11748_P_NODE_149009_length_336_cov_7.156364_g146828_i0 | PRJEB11748 | 149009 | 336 | 7.156364 | 24.04538304 | Adineta | 104781 | Rotifera | other_Eukaryota | 139 | 1.31e-39 | NR | CAF1681391.1 | 249248 | g146828 | i0 | 84.4 | 3.4375 | 77 | 12 | 68.8 | 0 | 23 | 253 | 67 | 143 | CAF1681391.1 unnamed protein product, partial [Adineta ricciae] | diamond | 1155 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 31012366 | 31012366 | PRJEB11748_P_NODE_297855_length_220_cov_8.314465_g295672_i0 | PRJEB11748 | 297855 | 220 | 8.314465 | 18.291823 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 53.9 | 2.96e-6 | NR | CAF2141632.1 | 392030 | g295672 | i0 | 47.3 | 1.5 | 55 | 29 | 75 | 0 | 170 | 6 | 87 | 141 | CAF2141632.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 330 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 31233377 | 31233377 | PRJEB11748_P_NODE_325875_length_208_cov_1.659864_g323692_i0 | PRJEB11748 | 325875 | 208 | 1.659864 | 3.45251712 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 52 | 1.29e-5 | NR | RNA27956.1 | 10195 | g323692 | i0 | 42.1 | 0.822115384615385 | 57 | 33 | 82.2 | 0 | 1 | 171 | 109 | 165 | RNA27956.1 acid-sensing ion channel 1 isoform X2 [Brachionus plicatilis] | diamond | 171 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 31423301 | 31423301 | PRJEB11748_P_NODE_274616_length_232_cov_6.953216_g272433_i0 | PRJEB11748 | 274616 | 232 | 6.953216 | 16.13146112 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 67.4 | 6.61e-11 | NR | CAF0806124.1 | 104777 | g272433 | i0 | 47.7 | 0.84051724137931 | 65 | 33 | 82.8 | 1 | 39 | 230 | 3959 | 4023 | CAF0806124.1 unnamed protein product [Brachionus calyciflorus] | diamond | 195 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 31454919 | 31454919 | PRJEB11748_P_NODE_148576_length_337_cov_2.260870_g146395_i0 | PRJEB11748 | 148576 | 337 | 2.26087 | 7.6191319 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 105 | 1.11e-25 | NR | CAF1322360.1 | 433720 | g146395 | i0 | 48.6 | 0.934718100890208 | 105 | 50 | 90.8 | 4 | 24 | 329 | 104 | 207 | CAF1322360.1 unnamed protein product [Adineta steineri] | diamond | 315 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 31612996 | 31612996 | PRJEB11748_P_NODE_148236_length_337_cov_6.884058_g146055_i0 | PRJEB11748 | 148236 | 337 | 6.884058 | 23.19927546 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 81.6 | 2.39e-15 | NR | CAF1150649.1 | 392033 | g146055 | i0 | 75 | 0.462908011869436 | 52 | 13 | 46.3 | 0 | 81 | 236 | 403 | 454 | CAF1150649.1 unnamed protein product [Rotaria sordida] | diamond | 156 | 81.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 31676119 | 31676119 | PRJEB11748_P_NODE_127817_length_366_cov_3.813115_g125640_i0 | PRJEB11748 | 127817 | 366 | 3.813115 | 13.9560009 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 152 | 7.42e-43 | NR | CAF3423896.1 | 2762511 | g125640 | i0 | 84.5 | 0.688524590163934 | 84 | 13 | 68.9 | 0 | 264 | 13 | 13 | 96 | CAF3423896.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 252 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 31834260 | 31834260 | PRJEB11748_P_NODE_190977_length_291_cov_17.430435_g188794_i0 | PRJEB11748 | 190977 | 291 | 17.430435 | 50.72256585 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 51.2 | 6.53e-5 | NR | CAF3531707.1 | 2762511 | g188794 | i0 | 47.6 | 3.03092783505155 | 42 | 22 | 43.3 | 0 | 229 | 104 | 389 | 430 | CAF3531707.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 882 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 32467461 | 32467461 | PRJEB11748_P_NODE_101179_length_415_cov_4.717514_g99009_i0 | PRJEB11748 | 101179 | 415 | 4.717514 | 19.5776831 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 45.4 | 0.0249 | NR | CAF1410972.1 | 1234261 | g99009 | i0 | 33.3 | 0.910843373493976 | 63 | 42 | 45.5 | 0 | 373 | 185 | 72 | 134 | CAF1410972.1 unnamed protein product [Didymodactylos carnosus] | diamond | 378 | 45.4 | 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);;