contig_metadata
13 rows where bioproject = "PRJNA1092581", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4845879 | 4845879 | PRJNA1092581_P_NODE_108984_length_241_cov_6.172619_g108451_i0 | PRJNA1092581 | 108984 | 241 | 6.172619 | 14.87601179 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 107 | 5.14e-27 | NR | CAF0926281.1 | 249248 | g108451 | i0 | 86.7 | 4.48132780082988 | 60 | 8 | 74.7 | 0 | 2 | 181 | 129 | 188 | CAF0926281.1 unnamed protein product [Adineta ricciae] | diamond | 1080 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 10399676 | 10399676 | PRJNA1092581_P_NODE_2189_length_1451_cov_8.270682_g2014_i0 | PRJNA1092581 | 2189 | 1451 | 8.270682 | 120.00759582 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 346 | 1.92e-109 | NR | CAF0931324.1 | 433720 | g2014 | i0 | 66 | 1.03170227429359 | 250 | 77 | 51.1 | 5 | 1020 | 280 | 338 | 582 | CAF0931324.1 unnamed protein product [Adineta steineri] | diamond | 1497 | 346 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 27320533 | 27320533 | PRJNA1092581_P_NODE_67843_length_318_cov_14.922449_g67310_i0 | PRJNA1092581 | 67843 | 318 | 14.922449 | 47.45338782 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 92.4 | 3.24e-22 | NR | CAF0994775.1 | 1234261 | g67310 | i0 | 67.6 | 0.669811320754717 | 71 | 23 | 67 | 0 | 262 | 50 | 1 | 71 | CAF0994775.1 unnamed protein product [Didymodactylos carnosus] | diamond | 213 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 28006758 | 28006758 | PRJNA1092581_P_NODE_9505_length_872_cov_3.220275_g9082_i0 | PRJNA1092581 | 9505 | 872 | 3.220275 | 28.080798 | Metazoa | 33208 | Rotifera | other_Eukaryota | 132 | 2.08e-32 | NR | RNA39219.1 | 10195 | g9082 | i0 | 37.7 | 7.99197247706422 | 212 | 128 | 72.6 | 4 | 869 | 237 | 100 | 308 | RNA39219.1 ATP synthase subunit mitochondrial, partial [Brachionus plicatilis] | diamond | 6969 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 28606377 | 28606377 | PRJNA1092581_P_NODE_17287_length_668_cov_3.105882_g16777_i0 | PRJNA1092581 | 17287 | 668 | 3.105882 | 20.74729176 | Philodinidae | 44580 | Rotifera | other_Eukaryota | 208 | 8.86e-58 | NR | CAF1361376.1 | 392030 | g16777 | i0 | 52.5 | 2.73952095808383 | 204 | 90 | 91.2 | 5 | 17 | 625 | 2353 | 2550 | CAF1361376.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 1830 | 208 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 29584896 | 29584896 | PRJNA1092581_P_NODE_87690_length_273_cov_11.160000_g87157_i0 | PRJNA1092581 | 87690 | 273 | 11.16 | 30.4668 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 70.9 | 2.86e-12 | NR | CAF1324690.1 | 249248 | g87157 | i0 | 71.7 | 5.68131868131868 | 46 | 13 | 50.5 | 0 | 258 | 121 | 191 | 236 | CAF1324690.1 unnamed protein product [Adineta ricciae] | diamond | 1551 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 29593449 | 29593449 | PRJNA1092581_P_NODE_78230_length_293_cov_2.736364_g77697_i0 | PRJNA1092581 | 78230 | 293 | 2.736364 | 8.01754652 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 79.7 | 2.03e-16 | NR | CAF1128076.1 | 2762511 | g77697 | i0 | 44.6 | 2.4778156996587 | 83 | 42 | 80.9 | 2 | 239 | 3 | 6 | 88 | CAF1128076.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 726 | 79.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 29783236 | 29783236 | PRJNA1092581_P_NODE_58491_length_347_cov_6.496350_g57958_i0 | PRJNA1092581 | 58491 | 347 | 6.49635 | 22.5423345 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 108 | 3.3e-28 | NR | CAF0725183.1 | 249248 | g57958 | i0 | 70 | 0.605187319884726 | 70 | 21 | 60.5 | 0 | 284 | 75 | 7 | 76 | CAF0725183.1 unnamed protein product [Adineta ricciae] | diamond | 210 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 29878153 | 29878153 | PRJNA1092581_P_NODE_39911_length_433_cov_3.508333_g39378_i0 | PRJNA1092581 | 39911 | 433 | 3.508333 | 15.19108189 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 191 | 7.39e-57 | NR | UJR33402.1 | 104782 | g39378 | i0 | 65.5 | 5.02309468822171 | 145 | 48 | 99.1 | 1 | 5 | 433 | 155 | 299 | UJR33402.1 hypothetical protein I4U23_020848 [Adineta vaga] | diamond | 2175 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 29909761 | 29909761 | PRJNA1092581_P_NODE_49391_length_383_cov_5.219355_g48858_i0 | PRJNA1092581 | 49391 | 383 | 5.219355 | 19.99012965 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 60.8 | 2.6e-8 | NR | UJR35169.1 | 104782 | g48858 | i0 | 61 | 0.321148825065274 | 41 | 16 | 32.1 | 0 | 29 | 151 | 163 | 203 | UJR35169.1 hypothetical protein I4U23_027936 [Adineta vaga] | diamond | 123 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 30438341 | 30438341 | PRJNA1092581_P_NODE_37593_length_448_cov_1.312000_g37061_i0 | PRJNA1092581 | 37593 | 448 | 1.312 | 5.87776 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 53.1 | 7.77e-5 | NR | CAF1019309.1 | 249248 | g37061 | i0 | 29.3 | 2.69866071428571 | 92 | 60 | 61.6 | 1 | 2 | 277 | 653 | 739 | CAF1019309.1 unnamed protein product [Adineta ricciae] | diamond | 1209 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32303889 | 32303889 | PRJNA1092581_P_NODE_31459_length_493_cov_4.945238_g30927_i0 | PRJNA1092581 | 31459 | 493 | 4.945238 | 24.38002334 | Rotaria | 231623 | Rotifera | other_Eukaryota | 94.4 | 5.79e-19 | NR | CAF3599888.1 | 2762511 | g30927 | i0 | 37.2 | 1.72819472616633 | 145 | 81 | 86.4 | 3 | 492 | 67 | 902 | 1039 | CAF3599888.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 852 | 95.1 | 0.992639327024185 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 32808579 | 32808579 | PRJNA1092581_P_NODE_73140_length_305_cov_2.620690_g72607_i0 | PRJNA1092581 | 73140 | 305 | 2.62069 | 7.9931045 | Rotaria | 231623 | Rotifera | other_Eukaryota | 65.5 | 6.97e-10 | NR | CAF2098077.1 | 392030 | g72607 | i0 | 43.3 | 5.28196721311475 | 90 | 44 | 87.5 | 4 | 2 | 268 | 274 | 357 | CAF2098077.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 1611 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata |
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);;