contig_metadata
16 rows where bioproject = "PRJNA235310", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6745001 | 6745001 | PRJNA235310_P_NODE_2246_length_259_cov_2.723810_g2220_i0 | PRJNA235310 | 2246 | 259 | 2.72381 | 7.0546679 | Proales similis | 360698 | Rotifera | other_Eukaryota | 145 | 1.0699999999999998e-41 | NR | QKV49091.1 | 360698 | g2220 | i0 | 80 | 1.94594594594595 | 85 | 17 | 98.5 | 0 | 3 | 257 | 130 | 214 | QKV49091.1 cytochrome c oxidase subunit II [Proales similis] | diamond | 504 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Proalidae | Proales | Proales similis | |
| 19493311 | 19493311 | PRJNA235310_P_NODE_276_length_651_cov_3.740864_g254_i0 | PRJNA235310 | 276 | 651 | 3.740864 | 24.35302464 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 370 | 1.57e-97 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g254 | i0 | 78.583 | 26.4715821812596 | 593 | 104 | 89 | 20 | 1 | 582 | 11819 | 11239 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 17233 | 370 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 20182683 | 20182683 | PRJNA235310_P_NODE_756_length_453_cov_1.858911_g730_i0 | PRJNA235310 | 756 | 453 | 1.858911 | 8.42086683 | Brachionus | 10194 | Rotifera | other_Eukaryota | 355 | 2.99e-93 | NTclustered | gi|1802791198|gb|MN256531.1| | 392764 | g730 | i0 | 81.25 | 63.4591611479029 | 464 | 65 | 100 | 16 | 1 | 453 | 11771 | 11319 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 28747 | 355 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 21458362 | 21458362 | PRJNA235310_P_NODE_237_length_694_cov_4.573643_g216_i0 | PRJNA235310 | 237 | 694 | 4.573643 | 31.74108242 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 119 | 2.45e-29 | NR | RMZ98034.1 | 10195 | g216 | i0 | 46.2 | 0.674351585014409 | 156 | 77 | 64.4 | 3 | 537 | 91 | 65 | 220 | RMZ98034.1 Nascent polypeptide-associated complex subunit alpha [Brachionus plicatilis] | diamond | 468 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 27232002 | 27232002 | PRJNA235310_P_NODE_2843_length_227_cov_0.876404_g2817_i0 | PRJNA235310 | 2843 | 227 | 0.876404 | 1.98943708 | Brachionus falcatus | 392765 | Rotifera | other_Eukaryota | 50.1 | 2.74e-5 | NR | WOV68819.1 | 392765 | g2817 | i0 | 43.1 | 0.951541850220264 | 72 | 37 | 93.8 | 2 | 11 | 223 | 51 | 119 | WOV68819.1 NADH dehydrogenase subunit 6 [Brachionus falcatus] | diamond | 216 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus falcatus | |
| 27818480 | 27818480 | PRJNA235310_P_NODE_3164_length_213_cov_1.743902_g3138_i0 | PRJNA235310 | 3164 | 213 | 1.743902 | 3.71451126 | Adineta | 104781 | Rotifera | other_Eukaryota | 78.2 | 1.09e-16 | NR | CAF0825333.1 | 249248 | g3138 | i0 | 79.5 | 4.36619718309859 | 39 | 8 | 54.9 | 0 | 6 | 122 | 1 | 39 | CAF0825333.1 unnamed protein product [Adineta ricciae] | diamond | 930 | 78.6 | 0.994910941475827 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28337310 | 28337310 | PRJNA235310_P_NODE_1046_length_391_cov_16.687135_g1020_i0 | PRJNA235310 | 1046 | 391 | 16.687135 | 65.24669785 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 86.7 | 9.79e-19 | NR | RNA30453.1 | 10195 | g1020 | i0 | 71.2 | 1.01278772378517 | 66 | 18 | 49.9 | 1 | 355 | 161 | 75 | 140 | RNA30453.1 small subunit ribosomal S30e [Brachionus plicatilis] | diamond | 396 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 28968851 | 28968851 | PRJNA235310_P_NODE_1328_length_350_cov_1.372093_g1302_i0 | PRJNA235310 | 1328 | 350 | 1.372093 | 4.8023255 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 106 | 4.18e-26 | NR | RNA25306.1 | 10195 | g1302 | i0 | 52.6 | 2.79428571428571 | 114 | 53 | 97.7 | 1 | 2 | 343 | 8 | 120 | RNA25306.1 transmembrane and coiled-coil domain-containing 1 [Brachionus plicatilis] | diamond | 978 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 29189939 | 29189939 | PRJNA235310_P_NODE_2069_length_273_cov_0.928571_g2043_i0 | PRJNA235310 | 2069 | 273 | 0.928571 | 2.53499883 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 52 | 3.03e-5 | NR | CAF1411793.1 | 433720 | g2043 | i0 | 34.3 | 0.769230769230769 | 70 | 46 | 76.9 | 0 | 252 | 43 | 603 | 672 | CAF1411793.1 unnamed protein product [Adineta steineri] | diamond | 210 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29189945 | 29189945 | PRJNA235310_P_NODE_5509_length_166_cov_0.888889_g5483_i0 | PRJNA235310 | 5509 | 166 | 0.888889 | 1.47555574 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 67.8 | 3.83e-12 | NR | CAF0853952.1 | 249248 | g5483 | i0 | 70 | 4.33734939759036 | 40 | 12 | 72.3 | 0 | 1 | 120 | 153 | 192 | CAF0853952.1 unnamed protein product [Adineta ricciae] | diamond | 720 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 29252677 | 29252677 | PRJNA235310_P_NODE_3529_length_201_cov_1.026316_g3503_i0 | PRJNA235310 | 3529 | 201 | 1.026316 | 2.06289516 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 46.6 | 3.73e-4 | NR | UJR30147.1 | 104782 | g3503 | i0 | 42.6 | 0.91044776119403 | 61 | 34 | 89.6 | 1 | 182 | 3 | 35 | 95 | UJR30147.1 hypothetical protein I4U23_017687 [Adineta vaga] | diamond | 183 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 30358851 | 30358851 | PRJNA235310_P_NODE_5192_length_168_cov_0.873950_g5166_i0 | PRJNA235310 | 5192 | 168 | 0.87395 | 1.468236 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 88.6 | 2.13e-19 | NR | CAF0890961.1 | 249248 | g5166 | i0 | 74.5 | 3.92857142857143 | 55 | 14 | 98.2 | 0 | 3 | 167 | 224 | 278 | CAF0890961.1 unnamed protein product [Adineta ricciae] | diamond | 660 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 31116402 | 31116402 | PRJNA235310_P_NODE_2715_length_232_cov_0.819672_g2689_i0 | PRJNA235310 | 2715 | 232 | 0.819672 | 1.90163904 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 76.3 | 4.96e-14 | NR | CAF0732195.1 | 104777 | g2689 | i0 | 52.9 | 0.905172413793103 | 70 | 30 | 90.5 | 1 | 230 | 21 | 1011 | 1077 | CAF0732195.1 unnamed protein product [Brachionus calyciflorus] | diamond | 210 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 31527836 | 31527836 | PRJNA235310_P_NODE_736_length_458_cov_1.564792_g710_i0 | PRJNA235310 | 736 | 458 | 1.564792 | 7.16674736 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 91.3 | 2.24e-19 | NR | CAF1168873.1 | 249248 | g710 | i0 | 39.5 | 1.67685589519651 | 129 | 72 | 83.8 | 3 | 74 | 457 | 43 | 166 | CAF1168873.1 unnamed protein product [Adineta ricciae] | diamond | 768 | 91.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 31812398 | 31812398 | PRJNA235310_P_NODE_3017_length_219_cov_0.864706_g2991_i0 | PRJNA235310 | 3017 | 219 | 0.864706 | 1.89370614 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 48.5 | 2.43e-4 | NR | UJR18188.1 | 104782 | g2991 | i0 | 33.9 | 0.849315068493151 | 62 | 41 | 84.9 | 0 | 190 | 5 | 395 | 456 | UJR18188.1 hypothetical protein I4U23_005089 [Adineta vaga] | diamond | 186 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 31875499 | 31875499 | PRJNA235310_P_NODE_97_length_900_cov_2.850764_g81_i0 | PRJNA235310 | 97 | 900 | 2.850764 | 25.656876 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 63.5 | 5.17e-9 | NR | UJR19098.1 | 104782 | g81 | i0 | 43.9 | 0.22 | 66 | 31 | 22 | 1 | 345 | 542 | 13 | 72 | UJR19098.1 hypothetical protein I4U23_022229 [Adineta vaga] | diamond | 198 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga |
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);;