contig_metadata
23 rows where bioproject = "PRJNA493828", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6852334 | 6852334 | PRJNA493828_P_NODE_2666_length_649_cov_10.802083_g2325_i0 | PRJNA493828 | 2666 | 649 | 10.802083 | 70.10551867 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 1171 | 0 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g2325 | i0 | 99.381 | 41.7596302003082 | 646 | 4 | 99 | 0 | 4 | 649 | 2519 | 1874 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 27102 | 1171 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 10678058 | 10678058 | PRJNA493828_P_NODE_13249_length_320_cov_10.259109_g12830_i0 | PRJNA493828 | 13249 | 320 | 10.259109 | 32.8291488 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 566 | 8.669999999999999e-157 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g12830 | i0 | 99.048 | 45.88125 | 315 | 3 | 98 | 0 | 4 | 318 | 3045 | 2731 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 14682 | 566 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 10678151 | 10678151 | PRJNA493828_P_NODE_1949_length_755_cov_8.326979_g1625_i0 | PRJNA493828 | 1949 | 755 | 8.326979 | 62.86869145 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 1345 | 0 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g1625 | i0 | 98.808 | 93.1205298013245 | 755 | 9 | 100 | 0 | 1 | 755 | 1142 | 388 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 70306 | 1345 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 14503178 | 14503178 | PRJNA493828_P_NODE_11852_length_336_cov_3.216730_g11433_i0 | PRJNA493828 | 11852 | 336 | 3.21673 | 10.8082128 | Asplanchna sp. | 3231738 | Rotifera | other_Eukaryota | 342 | 1.68e-89 | NTclustered | gi|2778092479|gb|PP988071.1| | 3231738 | g11433 | i0 | 85.337 | 73.1101190476191 | 341 | 38 | 99 | 12 | 2 | 336 | 2264 | 1930 | Asplanchna sp. chromosome I mitochondrion, complete sequence | blastn | 24565 | 342 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sp. | |
| 15777244 | 15777244 | PRJNA493828_P_NODE_23733_length_274_cov_20.875622_g23314_i0 | PRJNA493828 | 23733 | 274 | 20.875622 | 57.19920428 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 492 | 1.2499999999999996e-134 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g23314 | i0 | 100 | 55.521897810219 | 266 | 0 | 97 | 0 | 6 | 271 | 1822 | 1557 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 15213 | 492 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 23426848 | 23426848 | PRJNA493828_P_NODE_11479_length_340_cov_4.928839_g11060_i0 | PRJNA493828 | 11479 | 340 | 4.928839 | 16.7580526 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 592 | 1.5299999999999996e-164 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g11060 | i0 | 99.69 | 76.3264705882353 | 323 | 1 | 95 | 0 | 18 | 340 | 5 | 327 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 25951 | 592 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 27709152 | 27709152 | PRJNA493828_P_NODE_44964_length_219_cov_5.095890_g44545_i0 | PRJNA493828 | 44964 | 219 | 5.09589 | 11.1599991 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 102 | 2.3399999999999994e-23 | NR | UJR20983.1 | 104782 | g44545 | i0 | 96 | 2.05479452054795 | 50 | 2 | 68.5 | 0 | 218 | 69 | 370 | 419 | UJR20983.1 hypothetical protein I4U23_024088 [Adineta vaga] | diamond | 450 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 27866443 | 27866443 | PRJNA493828_P_NODE_41245_length_236_cov_2.797546_g40826_i0 | PRJNA493828 | 41245 | 236 | 2.797546 | 6.60220856 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 78.2 | 1.93e-16 | NR | CAF1356670.1 | 249248 | g40826 | i0 | 74.5 | 2.8728813559322 | 55 | 12 | 69.9 | 1 | 19 | 183 | 42 | 94 | CAF1356670.1 unnamed protein product [Adineta ricciae] | diamond | 678 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27961296 | 27961296 | PRJNA493828_P_NODE_45585_length_214_cov_4.950355_g45166_i0 | PRJNA493828 | 45585 | 214 | 4.950355 | 10.5937597 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 94.7 | 1.29e-20 | NR | CAF1470691.1 | 249248 | g45166 | i0 | 71.4 | 0.883177570093458 | 63 | 17 | 86.9 | 1 | 2 | 187 | 355 | 417 | CAF1470691.1 unnamed protein product [Adineta ricciae] | diamond | 189 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28308693 | 28308693 | PRJNA493828_P_NODE_39726_length_241_cov_0.916667_g39307_i0 | PRJNA493828 | 39726 | 241 | 0.916667 | 2.20916747 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 113 | 4.12e-27 | NR | CAF1518878.1 | 249248 | g39307 | i0 | 73.4 | 0.983402489626556 | 79 | 21 | 98.3 | 0 | 238 | 2 | 24 | 102 | CAF1518878.1 unnamed protein product [Adineta ricciae] | diamond | 237 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28466632 | 28466632 | PRJNA493828_P_NODE_10386_length_355_cov_0.914894_g9967_i0 | PRJNA493828 | 10386 | 355 | 0.914894 | 3.2478737 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 62.8 | 1.3e-8 | NR | KAI3378399.1 | 104778 | g9967 | i0 | 36.4 | 1.96901408450704 | 121 | 68 | 98.9 | 4 | 353 | 3 | 414 | 529 | KAI3378399.1 hypothetical protein SNEBB_008308 [Seison nebaliae] | diamond | 699 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 28719141 | 28719141 | PRJNA493828_P_NODE_21627_length_282_cov_0.889952_g21208_i0 | PRJNA493828 | 21627 | 282 | 0.889952 | 2.50966464 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 63.2 | 2.17e-9 | NR | CAF3893110.1 | 2762511 | g21208 | i0 | 37.2 | 2.02127659574468 | 94 | 54 | 95.7 | 3 | 6 | 275 | 4 | 96 | CAF3893110.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 570 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 28845187 | 28845187 | PRJNA493828_P_NODE_17148_length_302_cov_4.179039_g16729_i0 | PRJNA493828 | 17148 | 302 | 4.179039 | 12.62069778 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 68.6 | 5.68e-12 | NR | RNA15979.1 | 10195 | g16729 | i0 | 48.1 | 0.764900662251656 | 77 | 40 | 76.5 | 0 | 233 | 3 | 77 | 153 | RNA15979.1 hypothetical protein BpHYR1_050970 [Brachionus plicatilis] | diamond | 231 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 28923957 | 28923957 | PRJNA493828_P_NODE_37788_length_243_cov_1.805882_g37369_i0 | PRJNA493828 | 37788 | 243 | 1.805882 | 4.38829326 | Adineta | 104781 | Rotifera | other_Eukaryota | 65.9 | 2.66e-10 | NR | UJR28918.1 | 104782 | g37369 | i0 | 88.6 | 1.2962962962963 | 35 | 4 | 43.2 | 0 | 105 | 209 | 692 | 726 | UJR28918.1 hypothetical protein I4U23_010136 [Adineta vaga] | diamond | 315 | 66.2 | 0.995468277945619 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 29334585 | 29334585 | PRJNA493828_P_NODE_22709_length_278_cov_1.502439_g22290_i0 | PRJNA493828 | 22709 | 278 | 1.502439 | 4.17678042 | Rotaria | 231623 | Rotifera | other_Eukaryota | 57.4 | 3.86e-7 | NR | CAF3903691.1 | 392030 | g22290 | i0 | 57.8 | 3.46402877697842 | 45 | 19 | 48.6 | 0 | 264 | 130 | 54 | 98 | CAF3903691.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 963 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 29634327 | 29634327 | PRJNA493828_P_NODE_43970_length_226_cov_5.006536_g43551_i0 | PRJNA493828 | 43970 | 226 | 5.006536 | 11.31477136 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 85.1 | 3.63e-17 | NR | CAF0857788.1 | 392033 | g43551 | i0 | 56.8 | 2.19026548672566 | 74 | 21 | 83.6 | 2 | 225 | 37 | 384 | 457 | CAF0857788.1 unnamed protein product [Rotaria sordida] | diamond | 495 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 29919060 | 29919060 | PRJNA493828_P_NODE_14131_length_312_cov_3.016736_g13712_i0 | PRJNA493828 | 14131 | 312 | 3.016736 | 9.41221632 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 86.7 | 1.66e-17 | NR | RNA44696.1 | 10195 | g13712 | i0 | 77.6 | 0.942307692307692 | 49 | 11 | 47.1 | 0 | 308 | 162 | 21 | 69 | RNA44696.1 Twitchin, partial [Brachionus plicatilis] | diamond | 294 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 29919062 | 29919062 | PRJNA493828_P_NODE_22671_length_278_cov_1.873171_g22252_i0 | PRJNA493828 | 22671 | 278 | 1.873171 | 5.20741538 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 110 | 9.23e-27 | NR | CAF2586522.1 | 2762512 | g22252 | i0 | 56.8 | 3.49640287769784 | 81 | 35 | 87.4 | 0 | 1 | 243 | 190 | 270 | CAF2586522.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 972 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 30203004 | 30203004 | PRJNA493828_P_NODE_35632_length_246_cov_1.531792_g35213_i0 | PRJNA493828 | 35632 | 246 | 1.531792 | 3.76820832 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 92.4 | 2.86e-20 | NR | CAF3325942.1 | 2762512 | g35213 | i0 | 61.6 | 1.78048780487805 | 73 | 28 | 89 | 0 | 28 | 246 | 1 | 73 | CAF3325942.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 438 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 30361706 | 30361706 | PRJNA493828_P_NODE_29812_length_256_cov_3.803279_g29393_i0 | PRJNA493828 | 29812 | 256 | 3.803279 | 9.73639424 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 77.4 | 8.74e-16 | NR | CAF0775232.1 | 104777 | g29393 | i0 | 53 | 3.03515625 | 66 | 31 | 77.3 | 0 | 253 | 56 | 78 | 143 | CAF0775232.1 unnamed protein product [Brachionus calyciflorus] | diamond | 777 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 30613896 | 30613896 | PRJNA493828_P_NODE_34593_length_247_cov_3.925287_g34174_i0 | PRJNA493828 | 34593 | 247 | 3.925287 | 9.69545889 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 48.1 | 8.76e-5 | NR | CAF4129484.1 | 433720 | g34174 | i0 | 46 | 0.607287449392713 | 50 | 27 | 60.7 | 0 | 204 | 55 | 29 | 78 | CAF4129484.1 unnamed protein product [Adineta steineri] | diamond | 150 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 31040641 | 31040641 | PRJNA493828_P_NODE_35975_length_246_cov_0.890173_g35556_i0 | PRJNA493828 | 35975 | 246 | 0.890173 | 2.18982558 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 79.7 | 2.28e-15 | NR | RNA44400.1 | 10195 | g35556 | i0 | 67.3 | 6.58536585365854 | 52 | 17 | 63.4 | 0 | 165 | 10 | 198 | 249 | RNA44400.1 BTB POZ domain-containing KCTD21 [Brachionus plicatilis] | diamond | 1620 | 80.5 | 0.990062111801242 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 32511692 | 32511692 | PRJNA493828_P_NODE_7559_length_408_cov_1.116418_g7145_i0 | PRJNA493828 | 7559 | 408 | 1.116418 | 4.55498544 | Brachionus rotundiformis | 96890 | Rotifera | other_Eukaryota | 81.6 | 4.85e-16 | NR | AYN44500.1 | 96890 | g7145 | i0 | 37.6 | 1.93382352941176 | 133 | 76 | 94.1 | 3 | 1 | 384 | 71 | 201 | AYN44500.1 glutathione S-transferase S4 [Brachionus rotundiformis] | diamond | 789 | 81.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rotundiformis |
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);;