contig_metadata
9 rows where bioproject = "PRJNA801875" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18652540 | 18652540 | PRJNA801875_P_NODE_2475_length_219_cov_2.076087_g2372_i0 | PRJNA801875 | 2475 | 219 | 2.076087 | 4.54663053 | Lepadella patella | 231622 | Rotifera | other_Eukaryota | 309 | 1.04e-79 | NTclustered | gi|83285192|gb|DQ297739.1| | 231622 | g2372 | i0 | 92.558 | 82.7260273972603 | 215 | 16 | 98 | 0 | 4 | 218 | 6 | 220 | Lepadella patella 28S ribosomal RNA gene, partial sequence | blastn | 18117 | 309 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lepadellidae | Lepadella | Lepadella patella | |
| 22478113 | 22478113 | PRJNA801875_P_NODE_2698_length_206_cov_2.555556_g2595_i0 | PRJNA801875 | 2698 | 206 | 2.555556 | 5.26444536 | Encentrum astridae | 360661 | Rotifera | other_Eukaryota | 167 | 6.159999999999999e-37 | NTclustered | gi|124388846|gb|EF151006.1| | 360661 | g2595 | i0 | 93.043 | 24.3009708737864 | 115 | 6 | 55 | 2 | 88 | 201 | 1907 | 1794 | Encentrum astridae 28S ribosomal RNA gene, partial sequence | blastn | 5006 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Dicranophoridae | Encentrum | Encentrum astridae | |
| 23753763 | 23753763 | PRJNA801875_P_NODE_4259_length_158_cov_2.926829_g4156_i0 | PRJNA801875 | 4259 | 158 | 2.926829 | 4.62438982 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 270 | 3.3099999999999996e-68 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g4156 | i0 | 97.468 | 3.00632911392405 | 158 | 4 | 100 | 0 | 1 | 158 | 10369 | 10212 | 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 | 475 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 27148522 | 27148522 | PRJNA801875_P_NODE_3282_length_182_cov_1.530612_g3179_i0 | PRJNA801875 | 3282 | 182 | 1.530612 | 2.78571384 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 78.2 | 3.04e-15 | NR | CAF0935085.1 | 433720 | g3179 | i0 | 57.6 | 4.86263736263736 | 59 | 25 | 97.3 | 0 | 4 | 180 | 151 | 209 | CAF0935085.1 unnamed protein product [Adineta steineri] | diamond | 885 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29327738 | 29327738 | PRJNA801875_P_NODE_2209_length_238_cov_1.103448_g2106_i0 | PRJNA801875 | 2209 | 238 | 1.103448 | 2.62620624 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 55.1 | 1.43e-6 | NR | CAF1441499.1 | 433720 | g2106 | i0 | 40 | 1.63865546218487 | 65 | 35 | 81.9 | 1 | 203 | 9 | 23 | 83 | CAF1441499.1 unnamed protein product [Adineta steineri] | diamond | 390 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29683683 | 29683683 | PRJNA801875_P_NODE_2690_length_207_cov_0.988372_g2587_i0 | PRJNA801875 | 2690 | 207 | 0.988372 | 2.04593004 | Rotaria | 231623 | Rotifera | other_Eukaryota | 43.9 | 0.00911 | NR | CAF3330539.1 | 392032 | g2587 | i0 | 34.7 | 3.6231884057971 | 49 | 32 | 71 | 0 | 3 | 149 | 580 | 628 | CAF3330539.1 unnamed protein product [Rotaria socialis] | diamond | 750 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 30726465 | 30726465 | PRJNA801875_P_NODE_1994_length_257_cov_1.779279_g1891_i0 | PRJNA801875 | 1994 | 257 | 1.779279 | 4.57274703 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 90.5 | 1.46e-19 | NR | UJR26272.1 | 104782 | g1891 | i0 | 52.4 | 2.90661478599222 | 84 | 40 | 98.1 | 0 | 253 | 2 | 71 | 154 | UJR26272.1 hypothetical protein I4U23_007612 [Adineta vaga] | diamond | 747 | 90.9 | 0.995599559955996 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 31295306 | 31295306 | PRJNA801875_P_NODE_1355_length_339_cov_3.753289_g1252_i0 | PRJNA801875 | 1355 | 339 | 3.753289 | 12.72364971 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 70.9 | 1.46e-11 | NR | CAF1684378.1 | 392030 | g1252 | i0 | 47.6 | 3.43362831858407 | 63 | 33 | 55.8 | 0 | 311 | 123 | 181 | 243 | CAF1684378.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 1164 | 71.6 | 0.990223463687151 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 31760856 | 31760856 | PRJNA801875_P_NODE_3417_length_178_cov_1.104895_g3314_i0 | PRJNA801875 | 3417 | 178 | 1.104895 | 1.9667131 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 74.3 | 3.14e-14 | NR | CAF1500775.1 | 1234261 | g3314 | i0 | 58.9 | 1.8876404494382 | 56 | 23 | 94.4 | 0 | 171 | 4 | 127 | 182 | CAF1500775.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 336 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus |
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);;