contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA832865" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9751953 | 9751953 | PRJNA832865_S_NODE_91828_length_254_cov_1.701657_g86742_i0 | PRJNA832865 | 91828 | 254 | 1.701657 | 4.32220878 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 149 | 1.26e-44 | NR | RNA38687.1 | 10195 | g86742 | i0 | 85.7 | 1.98425196850394 | 84 | 12 | 99.2 | 0 | 2 | 253 | 10 | 93 | RNA38687.1 60S ribosomal L31 [Brachionus plicatilis] | diamond | 504 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 26833133 | 26833133 | PRJNA832865_S_NODE_15321_length_1024_cov_4.840168_g11358_i0 | PRJNA832865 | 15321 | 1024 | 4.840168 | 49.56332032 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 88.6 | 4.5e-15 | NR | KAI3378399.1 | 104778 | g11358 | i0 | 34.7 | 0.4892578125 | 167 | 100 | 47.8 | 4 | 490 | 978 | 388 | 549 | KAI3378399.1 hypothetical protein SNEBB_008308 [Seison nebaliae] | diamond | 501 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 28381007 | 28381007 | PRJNA832865_S_NODE_25046_length_631_cov_30.019713_g20089_i0 | PRJNA832865 | 25046 | 631 | 30.019713 | 189.42438903 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 49.7 | 0.00396 | NR | CAF4346778.1 | 2762512 | g20089 | i0 | 25.2 | 2.44374009508716 | 143 | 91 | 62.3 | 4 | 429 | 37 | 209 | 347 | CAF4346778.1 unnamed protein product, partial [Rotaria sp. Silwood2] | diamond | 1542 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 28886092 | 28886092 | PRJNA832865_S_NODE_19368_length_816_cov_2.854643_g14787_i0 | PRJNA832865 | 19368 | 816 | 2.854643 | 23.29388688 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 221 | 1.42e-65 | NR | CAF3423606.1 | 2762512 | g14787 | i0 | 63.1 | 1.16176470588235 | 157 | 58 | 57.7 | 0 | 809 | 339 | 133 | 289 | CAF3423606.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 948 | 221 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 28926281 | 28926281 | PRJNA832865_S_NODE_101108_length_247_cov_0.885057_g96022_i0 | PRJNA832865 | 101108 | 247 | 0.885057 | 2.18609079 | Brachionus | 10194 | Rotifera | other_Eukaryota | 60.8 | 1.61e-8 | NR | RNA09267.1 | 10195 | g96022 | i0 | 40.3 | 1.53036437246964 | 72 | 43 | 87.4 | 0 | 219 | 4 | 425 | 496 | RNA09267.1 acid-sensing ion channel 5 [Brachionus plicatilis] | diamond | 378 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 29139120 | 29139120 | PRJNA832865_S_NODE_88689_length_259_cov_1.483871_g83603_i0 | PRJNA832865 | 88689 | 259 | 1.483871 | 3.84322589 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 96.7 | 2.18e-24 | NR | RNA32574.1 | 10195 | g83603 | i0 | 74.1 | 1.8996138996139 | 54 | 14 | 62.5 | 0 | 229 | 68 | 1 | 54 | RNA32574.1 ribosomal S14p S29e [Brachionus plicatilis] | diamond | 492 | 96.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 29202104 | 29202104 | PRJNA832865_S_NODE_21869_length_723_cov_1.261538_g17074_i0 | PRJNA832865 | 21869 | 723 | 1.261538 | 9.12091974 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 60.8 | 1.38e-6 | NR | CAF3704228.1 | 2762511 | g17074 | i0 | 50 | 2.32365145228216 | 56 | 28 | 23.2 | 0 | 554 | 721 | 527 | 582 | CAF3704228.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 1680 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 29873621 | 29873621 | PRJNA832865_S_NODE_108191_length_242_cov_1.751479_g103105_i0 | PRJNA832865 | 108191 | 242 | 1.751479 | 4.23857918 | Brachionus | 10194 | Rotifera | other_Eukaryota | 129 | 1.87e-35 | NR | YP_001728983.1 | 10195 | g103105 | i0 | 87.5 | 7.93388429752066 | 80 | 10 | 99.2 | 0 | 3 | 242 | 101 | 180 | YP_001728983.1 ATP synthase F0 subunit 6 [Brachionus plicatilis] | diamond | 1920 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 29991422 | 29991422 | PRJNA832865_S_NODE_19891_length_794_cov_13.528433_g15264_i0 | PRJNA832865 | 19891 | 794 | 13.528433 | 107.41575802 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 185 | 5.709999999999999e-54 | NR | UJR08980.1 | 104782 | g15264 | i0 | 50 | 8.70906801007557 | 174 | 87 | 65.7 | 0 | 719 | 198 | 38 | 211 | UJR08980.1 hypothetical protein I4U23_013230 [Adineta vaga] | diamond | 6915 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 30244302 | 30244302 | PRJNA832865_S_NODE_75072_length_284_cov_1.293839_g69986_i0 | PRJNA832865 | 75072 | 284 | 1.293839 | 3.67450276 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 48.9 | 3.59e-4 | NR | CAF1496207.1 | 1234261 | g69986 | i0 | 42 | 0.72887323943662 | 69 | 40 | 72.9 | 0 | 65 | 271 | 58 | 126 | CAF1496207.1 unnamed protein product [Didymodactylos carnosus] | diamond | 207 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 30907834 | 30907834 | PRJNA832865_S_NODE_23654_length_666_cov_2.897133_g18752_i0 | PRJNA832865 | 23654 | 666 | 2.897133 | 19.29490578 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 86.3 | 2.1e-15 | NR | KAI3378399.1 | 104778 | g18752 | i0 | 34.8 | 0.698198198198198 | 155 | 92 | 68 | 4 | 487 | 35 | 388 | 537 | KAI3378399.1 hypothetical protein SNEBB_008308 [Seison nebaliae] | diamond | 465 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 31002528 | 31002528 | PRJNA832865_S_NODE_38854_length_429_cov_1.441011_g33769_i0 | PRJNA832865 | 38854 | 429 | 1.441011 | 6.18193719 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 47.4 | 0.00253 | NR | CAF2885819.1 | 2762512 | g33769 | i0 | 47.5 | 0.825174825174825 | 59 | 30 | 41.3 | 1 | 429 | 253 | 106 | 163 | CAF2885819.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 354 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 31168745 | 31168745 | PRJNA832865_S_NODE_95675_length_250_cov_1.209040_g90589_i0 | PRJNA832865 | 95675 | 250 | 1.20904 | 3.0226 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 1.13e-5 | NR | CAF1652461.1 | 249248 | g90589 | i0 | 46.6 | 3.6 | 58 | 31 | 69.6 | 0 | 179 | 6 | 12 | 69 | CAF1652461.1 unnamed protein product [Adineta ricciae] | diamond | 900 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 31517051 | 31517051 | PRJNA832865_S_NODE_30816_length_522_cov_1.472160_g25755_i0 | PRJNA832865 | 30816 | 522 | 1.47216 | 7.6846752 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.9 | 0.00389 | NR | CAF1080327.1 | 249248 | g25755 | i0 | 39.7 | 1.13218390804598 | 63 | 30 | 36.2 | 2 | 57 | 245 | 688 | 742 | CAF1080327.1 unnamed protein product [Adineta ricciae] | diamond | 591 | 49.3 | 0.991886409736308 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 31611812 | 31611812 | PRJNA832865_S_NODE_25036_length_632_cov_1.787120_g20081_i0 | PRJNA832865 | 25036 | 632 | 1.78712 | 11.2945984 | Metazoa | 33208 | Rotifera | other_Eukaryota | 128 | 3.23e-30 | NR | KAI3379074.1 | 104778 | g20081 | i0 | 43.3 | 5.63924050632911 | 134 | 75 | 63.1 | 1 | 3 | 401 | 1327 | 1460 | KAI3379074.1 hypothetical protein SNEBB_002215 [Seison nebaliae] | diamond | 3564 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 31634747 | 31634747 | PRJNA832865_S_NODE_85876_length_264_cov_1.209424_g80790_i0 | PRJNA832865 | 85876 | 264 | 1.209424 | 3.19287936 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 85.1 | 5.65e-17 | NR | CAF0828461.1 | 104777 | g80790 | i0 | 44.8 | 2.03409090909091 | 87 | 47 | 98.9 | 1 | 2 | 262 | 395 | 480 | CAF0828461.1 unnamed protein product [Brachionus calyciflorus] | diamond | 537 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 31928039 | 31928039 | PRJNA832865_S_NODE_112117_length_235_cov_2.851852_g107031_i0 | PRJNA832865 | 112117 | 235 | 2.851852 | 6.7018522 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 43.9 | 0.00617 | NR | RNA06941.1 | 10195 | g107031 | i0 | 60 | 1.81276595744681 | 25 | 10 | 31.9 | 0 | 199 | 125 | 74 | 98 | RNA06941.1 hypothetical protein BpHYR1_048519 [Brachionus plicatilis] | diamond | 426 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 31982692 | 31982692 | PRJNA832865_S_NODE_41938_length_405_cov_1.725904_g36852_i0 | PRJNA832865 | 41938 | 405 | 1.725904 | 6.9899112 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 137 | 1.7099999999999996e-34 | NR | KAI3378399.1 | 104778 | g36852 | i0 | 49.2 | 3.9037037037037 | 128 | 64 | 94.1 | 1 | 388 | 8 | 1321 | 1448 | KAI3378399.1 hypothetical protein SNEBB_008308 [Seison nebaliae] | diamond | 1581 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 32276338 | 32276338 | PRJNA832865_S_NODE_73278_length_288_cov_1.227907_g68192_i0 | PRJNA832865 | 73278 | 288 | 1.227907 | 3.53637216 | Metazoa | 33208 | Rotifera | other_Eukaryota | 47.8 | 0.00102 | NR | CAF4371509.1 | 392030 | g68192 | i0 | 33.3 | 2.97916666666667 | 96 | 40 | 99 | 3 | 286 | 2 | 226 | 298 | CAF4371509.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 858 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 32686748 | 32686748 | PRJNA832865_S_NODE_41160_length_411_cov_1.079882_g36074_i0 | PRJNA832865 | 41160 | 411 | 1.079882 | 4.43831502 | Metazoa | 33208 | Rotifera | other_Eukaryota | 125 | 2.11e-30 | NR | KAI3378399.1 | 104778 | g36074 | i0 | 44.4 | 1.97080291970803 | 135 | 74 | 98.5 | 1 | 7 | 411 | 501 | 634 | KAI3378399.1 hypothetical protein SNEBB_008308 [Seison nebaliae] | diamond | 810 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae |
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);;