contig_metadata
16 rows where bioproject = "PRJNA564013" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13303285 | 13303285 | PRJNA564013_P_NODE_220051_length_287_cov_7.619469_g217200_i0 | PRJNA564013 | 220051 | 287 | 7.619469 | 21.86787603 | Adineta vaga complex sp. A JFF-2016 | 1813164 | Rotifera | other_Eukaryota | 396 | 1.06e-105 | NTclustered | gi|1005055512|gb|KU860655.1| | 1813164 | g217200 | i0 | 94.882 | 55.8118466898955 | 254 | 12 | 89 | 1 | 11 | 264 | 2114 | 1862 | Adineta vaga complex sp. A JFF-2016 isolate H001 28S ribosomal RNA gene, partial sequence | blastn | 16018 | 396 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga complex sp. A JFF-2016 | |
| 21534931 | 21534931 | PRJNA564013_P_NODE_373377_length_174_cov_5.725664_g370525_i0 | PRJNA564013 | 373377 | 174 | 5.725664 | 9.96265536 | Adineta | 104781 | Rotifera | other_Eukaryota | 274 | 2.87e-69 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g370525 | i0 | 99.338 | 24.367816091954 | 151 | 1 | 87 | 0 | 24 | 174 | 1955 | 2105 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 4240 | 274 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 26681435 | 26681435 | PRJNA564013_P_NODE_230361_length_278_cov_4.308756_g227509_i0 | PRJNA564013 | 230361 | 278 | 4.308756 | 11.97834168 | Rotaria | 231623 | Rotifera | other_Eukaryota | 123 | 1.59e-30 | NR | CAF3708103.1 | 392032 | g227509 | i0 | 77.4 | 9.06474820143885 | 84 | 19 | 90.6 | 0 | 278 | 27 | 101 | 184 | CAF3708103.1 unnamed protein product [Rotaria socialis] | diamond | 2520 | 124 | 0.991935483870968 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 26952543 | 26952543 | PRJNA564013_P_NODE_353602_length_196_cov_2.755556_g350750_i0 | PRJNA564013 | 353602 | 196 | 2.755556 | 5.40088976 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 42.7 | 0.00995 | NR | CAF0787208.1 | 104777 | g350750 | i0 | 75 | 0.428571428571429 | 28 | 7 | 42.9 | 0 | 112 | 195 | 91 | 118 | CAF0787208.1 unnamed protein product [Brachionus calyciflorus] | diamond | 84 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 27584726 | 27584726 | PRJNA564013_P_NODE_225984_length_282_cov_3.647059_g223133_i0 | PRJNA564013 | 225984 | 282 | 3.647059 | 10.28470638 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 56.2 | 1.06e-6 | NR | CAF3830914.1 | 433720 | g223133 | i0 | 57.1 | 0.893617021276596 | 42 | 18 | 44.7 | 0 | 178 | 53 | 321 | 362 | CAF3830914.1 unnamed protein product, partial [Adineta steineri] | diamond | 252 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 28089898 | 28089898 | PRJNA564013_P_NODE_279265_length_239_cov_2.960674_g276413_i0 | PRJNA564013 | 279265 | 239 | 2.960674 | 7.07601086 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 114 | 1.33e-27 | NR | CAF2074576.1 | 392030 | g276413 | i0 | 61.8 | 4.49372384937239 | 89 | 14 | 86.6 | 1 | 226 | 20 | 389 | 477 | CAF2074576.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 1074 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 28451223 | 28451223 | PRJNA564013_P_NODE_197506_length_308_cov_9.684211_g194655_i0 | PRJNA564013 | 197506 | 308 | 9.684211 | 29.82736988 | Rotaria | 231623 | Rotifera | other_Eukaryota | 43.5 | 0.0429 | NR | CAF2087824.1 | 392030 | g194655 | i0 | 52.8 | 1.05194805194805 | 36 | 17 | 35.1 | 0 | 94 | 201 | 369 | 404 | CAF2087824.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 324 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 29429601 | 29429601 | PRJNA564013_P_NODE_286169_length_234_cov_4.069364_g283317_i0 | PRJNA564013 | 286169 | 234 | 4.069364 | 9.52231176 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 128 | 5.5299999999999996e-34 | NR | CAF1342213.1 | 433720 | g283317 | i0 | 88.6 | 9.87179487179487 | 70 | 8 | 89.7 | 0 | 234 | 25 | 248 | 317 | CAF1342213.1 unnamed protein product [Adineta steineri] | diamond | 2310 | 129 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29921462 | 29921462 | PRJNA564013_P_NODE_219571_length_288_cov_2.255507_g216720_i0 | PRJNA564013 | 219571 | 288 | 2.255507 | 6.49586016 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 53.9 | 4.94e-6 | NR | UJR34022.1 | 104782 | g216720 | i0 | 47.1 | 3.36458333333333 | 68 | 35 | 69.8 | 1 | 264 | 64 | 161 | 228 | UJR34022.1 hypothetical protein I4U23_021436 [Adineta vaga] | diamond | 969 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 30142102 | 30142102 | PRJNA564013_P_NODE_72212_length_475_cov_31.251208_g69398_i0 | PRJNA564013 | 72212 | 475 | 31.251208 | 148.443238 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 44.7 | 0.0305 | NR | CAF1415493.1 | 433720 | g69398 | i0 | 33.7 | 0.543157894736842 | 86 | 47 | 54.3 | 3 | 472 | 215 | 29 | 104 | CAF1415493.1 unnamed protein product [Adineta steineri] | diamond | 258 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 31533211 | 31533211 | PRJNA564013_P_NODE_278716_length_239_cov_7.623596_g275864_i0 | PRJNA564013 | 278716 | 239 | 7.623596 | 18.22039444 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 63.9 | 1.18e-9 | NR | CAF0935257.1 | 392033 | g275864 | i0 | 47 | 0.828451882845188 | 66 | 34 | 81.6 | 1 | 18 | 212 | 98 | 163 | CAF0935257.1 unnamed protein product [Rotaria sordida] | diamond | 198 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 31564836 | 31564836 | PRJNA564013_P_NODE_12276_length_1007_cov_12.543340_g10458_i0 | PRJNA564013 | 12276 | 1007 | 12.54334 | 126.3114338 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 135 | 1.2499999999999998e-32 | NR | CAF3564471.1 | 392033 | g10458 | i0 | 41.6 | 3.49453823237339 | 173 | 82 | 51.5 | 1 | 475 | 993 | 72 | 225 | CAF3564471.1 unnamed protein product [Rotaria sordida] | diamond | 3519 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 32007552 | 32007552 | PRJNA564013_P_NODE_83898_length_443_cov_5.795812_g81069_i0 | PRJNA564013 | 83898 | 443 | 5.795812 | 25.67544716 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 105 | 3.1399999999999995e-23 | NR | UJR15369.1 | 104782 | g81069 | i0 | 52.3 | 5.06546275395034 | 132 | 47 | 88.7 | 5 | 2 | 394 | 729 | 845 | UJR15369.1 hypothetical protein I4U23_002317 [Adineta vaga] | diamond | 2244 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 32545643 | 32545643 | PRJNA564013_P_NODE_329499_length_209_cov_0.878378_g326647_i0 | PRJNA564013 | 329499 | 209 | 0.878378 | 1.83581002 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 112 | 5.24e-29 | NR | CAF3362276.1 | 392032 | g326647 | i0 | 71 | 2.97129186602871 | 69 | 20 | 99 | 0 | 207 | 1 | 79 | 147 | CAF3362276.1 unnamed protein product [Rotaria socialis] | diamond | 621 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 32608491 | 32608491 | PRJNA564013_P_NODE_39260_length_618_cov_13.298025_g36561_i0 | PRJNA564013 | 39260 | 618 | 13.298025 | 82.1817945 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 149 | 1.1499999999999999e-42 | NR | CAF0885578.1 | 392033 | g36561 | i0 | 82.4 | 0.868932038834951 | 91 | 16 | 44.2 | 0 | 47 | 319 | 19 | 109 | CAF0885578.1 unnamed protein product [Rotaria sordida] | diamond | 537 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 32702818 | 32702818 | PRJNA564013_P_NODE_220340_length_287_cov_4.026549_g217489_i0 | PRJNA564013 | 220340 | 287 | 4.026549 | 11.55619563 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 49.7 | 2.29e-4 | NR | CAF0707513.1 | 104777 | g217489 | i0 | 30.1 | 1.93379790940767 | 93 | 36 | 97.2 | 1 | 282 | 4 | 534 | 597 | CAF0707513.1 unnamed protein product [Brachionus calyciflorus] | diamond | 555 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus |
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);;