contig_metadata
13 rows where bioproject = "PRJDB12578", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 486 | 486 | PRJDB12578_S_NODE_105321_length_276_cov_1.127753_g82263_i0 | PRJDB12578 | 105321 | 276 | 1.127753 | 3.11259828 | Proales similis | 360698 | Rotifera | other_Eukaryota | 65.8 | 3.26e-6 | NTclustered | gi|1859640894|gb|MN970216.1| | 360698 | g82263 | i0 | 85.075 | 0.242753623188406 | 67 | 7 | 24 | 3 | 102 | 167 | 11535 | 11599 | Proales similis mitochondrion, complete genome | blastn | 67 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Proalidae | Proales | Proales similis | |
| 2996 | 2996 | PRJDB12578_S_NODE_170681_length_185_cov_1.139706_g147623_i0 | PRJDB12578 | 170681 | 185 | 1.139706 | 2.1084561 | Lepadella patella | 231622 | Rotifera | other_Eukaryota | 259 | 8.67e-65 | NTclustered | gi|83285192|gb|DQ297739.1| | 231622 | g147623 | i0 | 91.935 | 62.1891891891892 | 186 | 14 | 100 | 1 | 1 | 185 | 515 | 330 | Lepadella patella 28S ribosomal RNA gene, partial sequence | blastn | 11505 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lepadellidae | Lepadella | Lepadella patella | |
| 3828985 | 3828985 | PRJDB12578_S_NODE_166144_length_188_cov_2.402878_g143086_i0 | PRJDB12578 | 166144 | 188 | 2.402878 | 4.51741064 | Lepadella patella | 231622 | Rotifera | other_Eukaryota | 243 | 8.91e-60 | NTclustered | gi|83285192|gb|DQ297739.1| | 231622 | g143086 | i0 | 94.34 | 76.7287234042553 | 159 | 7 | 84 | 2 | 30 | 187 | 1 | 158 | Lepadella patella 28S ribosomal RNA gene, partial sequence | blastn | 14425 | 243 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lepadellidae | Lepadella | Lepadella patella | |
| 9908915 | 9908915 | PRJDB12578_S_NODE_154028_length_199_cov_1.506667_g130970_i0 | PRJDB12578 | 154028 | 199 | 1.506667 | 2.99826733 | Ploima | 84394 | Rotifera | other_Eukaryota | 313 | 7.18e-81 | NTclustered | gi|72153738|gb|DQ089740.1| | 204736 | g130970 | i0 | 94.975 | 97.9798994974874 | 199 | 10 | 100 | 0 | 1 | 199 | 2522 | 2324 | Brachionus urceolaris 28S ribosomal RNA gene, partial sequence | blastn | 19498 | 313 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus urceolaris | |
| 11481601 | 11481601 | PRJDB12578_S_NODE_188890_length_172_cov_1.138211_g165832_i0 | PRJDB12578 | 188890 | 172 | 1.138211 | 1.95772292 | Trichocerca elongata | 360704 | Rotifera | other_Eukaryota | 235 | 1.33e-57 | NTclustered | gi|83285210|gb|DQ297757.1| | 360704 | g165832 | i0 | 91.279 | 14.2093023255814 | 172 | 15 | 100 | 0 | 1 | 172 | 336 | 507 | Trichocerca elongata 28S ribosomal RNA gene, partial sequence | blastn | 2444 | 235 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Trichocercidae | Trichocerca | Trichocerca elongata | |
| 11484607 | 11484607 | PRJDB12578_S_NODE_59850_length_669_cov_7.919355_g37538_i0 | PRJDB12578 | 59850 | 669 | 7.919355 | 52.98048495 | Adineta vaga complex sp. B JFF-2016 | 1813165 | Rotifera | other_Eukaryota | 1122 | 0 | NTclustered | gi|1005055631|gb|KU860774.1| | 1813165 | g37538 | i0 | 96.87 | 41.4603886397608 | 671 | 19 | 100 | 2 | 1 | 669 | 2107 | 1437 | Adineta vaga complex sp. B JFF-2016 isolate H158a 28S ribosomal RNA gene, partial sequence | blastn | 27737 | 1122 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga complex sp. B JFF-2016 | |
| 17558657 | 17558657 | PRJDB12578_S_NODE_159094_length_194_cov_3.186207_g136036_i0 | PRJDB12578 | 159094 | 194 | 3.186207 | 6.18124158 | Ploima | 84394 | Rotifera | other_Eukaryota | 311 | 2.5000000000000004e-80 | NTclustered | gi|61200811|gb|AY829085.1| | 84397 | g136036 | i0 | 95.408 | 99.5412371134021 | 196 | 7 | 100 | 1 | 1 | 194 | 1449 | 1644 | Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence | blastn | 19311 | 311 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Asplanchnidae | Asplanchna | Asplanchna sieboldii | |
| 18832506 | 18832506 | PRJDB12578_S_NODE_163635_length_190_cov_3.021277_g140577_i0 | PRJDB12578 | 163635 | 190 | 3.021277 | 5.7404263 | Metazoa | 33208 | Rotifera | other_Eukaryota | 351 | 1.4399999999999997e-92 | NTclustered | gi|37785582|gb|AY210469.1| | 96448 | g140577 | i0 | 100 | 99.321052631579 | 190 | 0 | 100 | 0 | 1 | 190 | 2960 | 3149 | Philodina roseola 28S ribosomal RNA gene, partial sequence | blastn | 18871 | 351 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 21678500 | 21678500 | PRJDB12578_S_NODE_140718_length_213_cov_1.262195_g117660_i0 | PRJDB12578 | 140718 | 213 | 1.262195 | 2.68847535 | Lepadella patella | 231622 | Rotifera | other_Eukaryota | 263 | 7.95e-66 | NTclustered | gi|83285192|gb|DQ297739.1| | 231622 | g117660 | i0 | 89.202 | 19.0798122065728 | 213 | 20 | 99 | 3 | 3 | 213 | 727 | 516 | Lepadella patella 28S ribosomal RNA gene, partial sequence | blastn | 4064 | 263 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Lepadellidae | Lepadella | Lepadella patella | |
| 21679239 | 21679239 | PRJDB12578_S_NODE_160158_length_193_cov_3.312500_g137100_i0 | PRJDB12578 | 160158 | 193 | 3.3125 | 6.393125 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 357 | 3.1499999999999996e-94 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g137100 | i0 | 100 | 5.66839378238342 | 193 | 0 | 100 | 0 | 1 | 193 | 10236 | 10044 | 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 | 1094 | 357 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 22954835 | 22954835 | PRJDB12578_S_NODE_167919_length_187_cov_1.405797_g144861_i0 | PRJDB12578 | 167919 | 187 | 1.405797 | 2.62884039 | Brachionus angularis | 396692 | Rotifera | other_Eukaryota | 132 | 1.9999999999999998e-26 | NTclustered | gi|1999716433|gb|MT875425.1| | 396692 | g144861 | i0 | 85.075 | 40.1176470588235 | 134 | 15 | 72 | 4 | 1 | 134 | 10012 | 10140 | Brachionus angularis chromosome I mitochondrion, complete sequence | blastn | 7502 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus angularis | |
| 29716259 | 29716259 | PRJDB12578_S_NODE_156310_length_197_cov_1.391892_g133252_i0 | PRJDB12578 | 156310 | 197 | 1.391892 | 2.74202724 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 45.4 | 0.00226 | NR | CAF3365564.1 | 2762511 | g133252 | i0 | 40.4 | 0.868020304568528 | 57 | 34 | 86.8 | 0 | 21 | 191 | 81 | 137 | CAF3365564.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 171 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 30790652 | 30790652 | PRJDB12578_S_NODE_163054_length_191_cov_1.436620_g139996_i0 | PRJDB12578 | 163054 | 191 | 1.43662 | 2.7439442 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 89.4 | 1.82e-19 | NR | CAF0893366.1 | 1234261 | g139996 | i0 | 61.3 | 1.94764397905759 | 62 | 24 | 97.4 | 0 | 5 | 190 | 178 | 239 | CAF0893366.1 unnamed protein product [Didymodactylos carnosus] | diamond | 372 | 89.4 | 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);;