contig_metadata
20 rows where bioproject = "PRJNA763243", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1205037 | 1205037 | PRJNA763243_P_NODE_17961_length_369_cov_16.466216_g17616_i0 | PRJNA763243 | 17961 | 369 | 16.466216 | 60.76033704 | Adinetidae | 104780 | Rotifera | other_Eukaryota | 673 | 0 | NTclustered | gi|2537903787|gb|KM043252.2| | 104782 | g17616 | i0 | 99.728 | 99.2845528455285 | 367 | 1 | 99 | 0 | 1 | 367 | 902 | 536 | Adineta vaga voucher AD005 18S ribosomal RNA gene, partial sequence | blastn | 36636 | 673 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 1205103 | 1205103 | PRJNA763243_P_NODE_32401_length_299_cov_8.991150_g32055_i0 | PRJNA763243 | 32401 | 299 | 8.99115 | 26.8835385 | Ploima | 84394 | Rotifera | other_Eukaryota | 466 | 8.38e-127 | NTclustered | gi|61200802|gb|AY829083.1| | 96446 | g32055 | i0 | 95.254 | 95.9966555183946 | 295 | 13 | 99 | 1 | 4 | 298 | 1423 | 1716 | Lecane bulla 28S ribosomal RNA gene, partial sequence | blastn | 28703 | 466 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lecanidae | Lecane | Lecane bulla | |
| 3756903 | 3756903 | PRJNA763243_P_NODE_24583_length_325_cov_14.234127_g24237_i0 | PRJNA763243 | 24583 | 325 | 14.234127 | 46.26091275 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 555 | 1.9099999999999995e-153 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g24237 | i0 | 98.113 | 79.3138461538462 | 318 | 6 | 98 | 0 | 5 | 322 | 7005 | 6688 | Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 25777 | 560 | 0.991071428571429 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 4571446 | 4571446 | PRJNA763243_P_NODE_32184_length_300_cov_4.493392_g31838_i0 | PRJNA763243 | 32184 | 300 | 4.493392 | 13.480176 | Lepadella patella | 231622 | Rotifera | other_Eukaryota | 396 | 1.12e-105 | NTclustered | gi|83285192|gb|DQ297739.1| | 231622 | g31838 | i0 | 94.574 | 88.9766666666667 | 258 | 10 | 85 | 4 | 45 | 300 | 1 | 256 | Lepadella patella 28S ribosomal RNA gene, partial sequence | blastn | 26693 | 396 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lepadellidae | Lepadella | Lepadella patella | |
| 5846949 | 5846949 | PRJNA763243_P_NODE_44365_length_266_cov_3.145078_g44019_i0 | PRJNA763243 | 44365 | 266 | 3.145078 | 8.36590748 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 139 | 9.749999999999999e-40 | NR | RNA13848.1 | 10195 | g44019 | i0 | 74.1 | 0.913533834586466 | 81 | 20 | 91.4 | 1 | 8 | 250 | 85 | 164 | RNA13848.1 peptidyl-prolyl cis-trans isomerase [Brachionus plicatilis] | diamond | 243 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 7583290 | 7583290 | PRJNA763243_P_NODE_48466_length_257_cov_4.255435_g48120_i0 | PRJNA763243 | 48466 | 257 | 4.255435 | 10.93646795 | Adineta | 104781 | Rotifera | other_Eukaryota | 403 | 5.599999999999998e-108 | NTclustered | gi|1005055598|gb|KU860741.1| | 1813167 | g48120 | i0 | 95.294 | 84.5214007782101 | 255 | 10 | 99 | 2 | 1 | 254 | 383 | 130 | Adineta vaga complex sp. D JFF-2016 isolate H3-14b 28S ribosomal RNA gene, partial sequence | blastn | 21722 | 403 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga complex sp. D JFF-2016 | |
| 10948113 | 10948113 | PRJNA763243_P_NODE_70229_length_219_cov_7.205479_g69883_i0 | PRJNA763243 | 70229 | 219 | 7.205479 | 15.77999901 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 272 | 1.37e-68 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g69883 | i0 | 99.333 | 2.72146118721461 | 150 | 1 | 100 | 0 | 70 | 219 | 10370 | 10221 | Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 596 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 11409079 | 11409079 | PRJNA763243_P_NODE_5389_length_610_cov_7.376164_g5066_i0 | PRJNA763243 | 5389 | 610 | 7.376164 | 44.9946004 | Adineta | 104781 | Rotifera | other_Eukaryota | 1101 | 0 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g5066 | i0 | 99.504 | 42.4885245901639 | 605 | 3 | 99 | 0 | 3 | 607 | 2105 | 1501 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 25918 | 1101 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 13959374 | 13959374 | PRJNA763243_P_NODE_74691_length_199_cov_9.595238_g74345_i0 | PRJNA763243 | 74691 | 199 | 9.595238 | 19.09452362 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 363 | 7.019999999999998e-96 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g74345 | i0 | 100 | 96.1758793969849 | 196 | 0 | 98 | 0 | 4 | 199 | 691 | 496 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 19139 | 363 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 18594610 | 18594610 | PRJNA763243_P_NODE_26855_length_314_cov_2.307054_g26509_i0 | PRJNA763243 | 26855 | 314 | 2.307054 | 7.24414956 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 88.2 | 9.36e-18 | NR | CAF2139880.1 | 392030 | g26509 | i0 | 46.9 | 0.936305732484076 | 98 | 50 | 93.6 | 2 | 16 | 309 | 29 | 124 | CAF2139880.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 294 | 88.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 22883040 | 22883040 | PRJNA763243_P_NODE_67998_length_228_cov_6.406452_g67652_i0 | PRJNA763243 | 67998 | 228 | 6.406452 | 14.60671056 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 353 | 4.98e-93 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g67652 | i0 | 95.111 | 93.2719298245614 | 225 | 10 | 99 | 1 | 4 | 228 | 7019 | 7242 | Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 21266 | 353 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 24969251 | 24969251 | PRJNA763243_P_NODE_12980_length_423_cov_4.185714_g12635_i0 | PRJNA763243 | 12980 | 423 | 4.185714 | 17.70557022 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 760 | 0 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g12635 | i0 | 99.286 | 58.1678486997636 | 420 | 3 | 99 | 0 | 1 | 420 | 2806 | 2387 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 24605 | 760 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 27947289 | 27947289 | PRJNA763243_P_NODE_68185_length_228_cov_2.077419_g67839_i0 | PRJNA763243 | 68185 | 228 | 2.077419 | 4.73651532 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 99 | 4.2099999999999996e-23 | NR | CAF0784306.1 | 249248 | g67839 | i0 | 69.7 | 4.38157894736842 | 66 | 20 | 86.8 | 0 | 223 | 26 | 26 | 91 | CAF0784306.1 unnamed protein product [Adineta ricciae] | diamond | 999 | 100 | 0.99 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28095435 | 28095435 | PRJNA763243_P_NODE_38405_length_281_cov_1.394231_g38059_i0 | PRJNA763243 | 38405 | 281 | 1.394231 | 3.91778911 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 50.8 | 8.78e-5 | NR | CAF3813850.1 | 433720 | g38059 | i0 | 45.7 | 2.59430604982206 | 81 | 41 | 83.3 | 3 | 42 | 275 | 1949 | 2029 | CAF3813850.1 unnamed protein product [Adineta steineri] | diamond | 729 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29042853 | 29042853 | PRJNA763243_P_NODE_49288_length_256_cov_1.207650_g48942_i0 | PRJNA763243 | 49288 | 256 | 1.20765 | 3.091584 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 69.3 | 1.86e-11 | NR | CAF4294673.1 | 2762512 | g48942 | i0 | 48.6 | 3.36328125 | 72 | 36 | 83.2 | 1 | 233 | 21 | 314 | 385 | CAF4294673.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 861 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 29683481 | 29683481 | PRJNA763243_P_NODE_70890_length_216_cov_4.825175_g70544_i0 | PRJNA763243 | 70890 | 216 | 4.825175 | 10.422378 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 48.9 | 1.65e-4 | NR | CAF0858903.1 | 392033 | g70544 | i0 | 48 | 2.86111111111111 | 50 | 24 | 69.4 | 1 | 164 | 15 | 10 | 57 | CAF0858903.1 unnamed protein product [Rotaria sordida] | diamond | 618 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 29800362 | 29800362 | PRJNA763243_P_NODE_47731_length_259_cov_1.494624_g47385_i0 | PRJNA763243 | 47731 | 259 | 1.494624 | 3.87107616 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 66.6 | 1.33e-10 | NR | CAF4273345.1 | 433720 | g47385 | i0 | 72.1 | 0.498069498069498 | 43 | 12 | 49.8 | 0 | 256 | 128 | 1 | 43 | CAF4273345.1 unnamed protein product, partial [Adineta steineri] | diamond | 129 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 30621767 | 30621767 | PRJNA763243_P_NODE_65593_length_236_cov_2.748466_g65247_i0 | PRJNA763243 | 65593 | 236 | 2.748466 | 6.48637976 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 51.2 | 8.99e-6 | NR | CAF1525794.1 | 433720 | g65247 | i0 | 51.1 | 0.572033898305085 | 45 | 22 | 57.2 | 0 | 161 | 27 | 31 | 75 | CAF1525794.1 unnamed protein product, partial [Adineta steineri] | diamond | 135 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32234785 | 32234785 | PRJNA763243_P_NODE_11218_length_451_cov_3.582011_g10875_i0 | PRJNA763243 | 11218 | 451 | 3.582011 | 16.15486961 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 96.7 | 5.53e-20 | NR | CAF1108276.1 | 249248 | g10875 | i0 | 56.5 | 1.68292682926829 | 85 | 36 | 55.9 | 1 | 271 | 20 | 2 | 86 | CAF1108276.1 unnamed protein product, partial [Adineta ricciae] | diamond | 759 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32551198 | 32551198 | PRJNA763243_P_NODE_35539_length_289_cov_1.384259_g35193_i0 | PRJNA763243 | 35539 | 289 | 1.384259 | 4.00050851 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 70.5 | 1.17e-11 | NR | CAF1119553.1 | 392033 | g35193 | i0 | 45.2 | 3.86159169550173 | 93 | 46 | 96.5 | 2 | 4 | 282 | 11 | 98 | CAF1119553.1 unnamed protein product [Rotaria sordida] | diamond | 1116 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida |
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);;