contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA1159911" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26787309 | 26787309 | PRJNA1159911_P_NODE_96361_length_244_cov_1.292398_g95819_i0 | PRJNA1159911 | 96361 | 244 | 1.292398 | 3.15345112 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 141 | 7.49e-38 | NR | CAF1059647.1 | 392033 | g95819 | i0 | 75 | 0.983606557377049 | 80 | 20 | 98.4 | 0 | 242 | 3 | 12 | 91 | CAF1059647.1 unnamed protein product [Rotaria sordida] | diamond | 240 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 26850679 | 26850679 | PRJNA1159911_P_NODE_45501_length_369_cov_1.040541_g44959_i0 | PRJNA1159911 | 45501 | 369 | 1.040541 | 3.83959629 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 166 | 2.13e-50 | NR | CAF4454395.1 | 1234261 | g44959 | i0 | 68.4 | 5.79674796747967 | 117 | 37 | 95.1 | 0 | 2 | 352 | 2 | 118 | CAF4454395.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 2139 | 166 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 26977035 | 26977035 | PRJNA1159911_P_NODE_71522_length_280_cov_1.487923_g70980_i0 | PRJNA1159911 | 71522 | 280 | 1.487923 | 4.1661844 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 78.2 | 1.7e-14 | NR | CAF1058167.1 | 1234261 | g70980 | i0 | 64 | 1.38214285714286 | 50 | 18 | 53.6 | 0 | 11 | 160 | 359 | 408 | CAF1058167.1 unnamed protein product [Didymodactylos carnosus] | diamond | 387 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 27040412 | 27040412 | PRJNA1159911_P_NODE_71582_length_280_cov_1.333333_g71040_i0 | PRJNA1159911 | 71582 | 280 | 1.333333 | 3.7333324 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 75.1 | 1.1e-13 | NR | CAF1407559.1 | 392033 | g71040 | i0 | 38.8 | 4.28571428571429 | 80 | 45 | 85.7 | 1 | 11 | 250 | 46 | 121 | CAF1407559.1 unnamed protein product, partial [Rotaria sordida] | diamond | 1200 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 27470651 | 27470651 | PRJNA1159911_P_NODE_95103_length_245_cov_0.895349_g94561_i0 | PRJNA1159911 | 95103 | 245 | 0.895349 | 2.19360505 | Philodinidae | 44580 | Rotifera | other_Eukaryota | 71.2 | 2.98e-12 | NR | CAF1372845.1 | 392030 | g94561 | i0 | 56.9 | 3.12244897959184 | 51 | 22 | 62.4 | 0 | 1 | 153 | 241 | 291 | CAF1372845.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 765 | 71.6 | 0.994413407821229 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 27672391 | 27672391 | PRJNA1159911_P_NODE_59644_length_312_cov_0.966527_g59102_i0 | PRJNA1159911 | 59644 | 312 | 0.966527 | 3.01556424 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 52 | 4.62e-5 | NR | CAF0878089.1 | 392033 | g59102 | i0 | 36.4 | 2.96153846153846 | 77 | 48 | 73.1 | 1 | 304 | 77 | 5 | 81 | CAF0878089.1 unnamed protein product [Rotaria sordida] | diamond | 924 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 28714210 | 28714210 | PRJNA1159911_P_NODE_51447_length_341_cov_2.294776_g50905_i0 | PRJNA1159911 | 51447 | 341 | 2.294776 | 7.82518616 | Philodina roseola | 96448 | Rotifera | other_Eukaryota | 80.5 | 4.6e-15 | NR | ACC43943.1 | 96448 | g50905 | i0 | 40 | 1.05571847507331 | 120 | 65 | 99.4 | 3 | 339 | 1 | 154 | 273 | ACC43943.1 unknown [Philodina roseola] | diamond | 360 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Philodina | Philodina roseola | |
| 29219510 | 29219510 | PRJNA1159911_P_NODE_97969_length_243_cov_0.905882_g97427_i0 | PRJNA1159911 | 97969 | 243 | 0.905882 | 2.20129326 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 88.6 | 1.76e-18 | NR | CAF1142490.1 | 1234261 | g97427 | i0 | 53.4 | 1.80246913580247 | 73 | 34 | 90.1 | 0 | 24 | 242 | 85 | 157 | CAF1142490.1 unnamed protein product [Didymodactylos carnosus] | diamond | 438 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 29282316 | 29282316 | PRJNA1159911_P_NODE_89549_length_249_cov_1.289773_g89007_i0 | PRJNA1159911 | 89549 | 249 | 1.289773 | 3.21153477 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 73.9 | 1.02e-13 | NR | CAF1604280.1 | 1234261 | g89007 | i0 | 41.8 | 2.19277108433735 | 91 | 43 | 97.6 | 3 | 3 | 245 | 144 | 234 | CAF1604280.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 546 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 29377232 | 29377232 | PRJNA1159911_P_NODE_88429_length_250_cov_0.870056_g87887_i0 | PRJNA1159911 | 88429 | 250 | 0.870056 | 2.17514 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 78.6 | 7.98e-17 | NR | KAI3386568.1 | 104778 | g87887 | i0 | 46.2 | 0.936 | 78 | 42 | 93.6 | 0 | 234 | 1 | 1 | 78 | KAI3386568.1 hypothetical protein SNEBB_009484 [Seison nebaliae] | diamond | 234 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 29977188 | 29977188 | PRJNA1159911_P_NODE_88491_length_250_cov_0.870056_g87949_i0 | PRJNA1159911 | 88491 | 250 | 0.870056 | 2.17514 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 93.6 | 1.09e-20 | NR | CAF1304304.1 | 433720 | g87949 | i0 | 53.8 | 2.808 | 78 | 36 | 93.6 | 0 | 17 | 250 | 1 | 78 | CAF1304304.1 unnamed protein product [Adineta steineri] | diamond | 702 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 30344646 | 30344646 | PRJNA1159911_P_NODE_100372_length_241_cov_1.833333_g99830_i0 | PRJNA1159911 | 100372 | 241 | 1.833333 | 4.41833253 | Rotaria | 231623 | Rotifera | other_Eukaryota | 100 | 2.39e-23 | NR | CAF1031041.1 | 392030 | g99830 | i0 | 84.6 | 3.24896265560166 | 52 | 8 | 64.7 | 0 | 240 | 85 | 194 | 245 | CAF1031041.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 783 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 30767104 | 30767104 | PRJNA1159911_P_NODE_87134_length_251_cov_0.865169_g86592_i0 | PRJNA1159911 | 87134 | 251 | 0.865169 | 2.17157419 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 43.1 | 0.0172 | NR | CAF1561881.1 | 1234261 | g86592 | i0 | 48.3 | 0.346613545816733 | 29 | 15 | 34.7 | 0 | 1 | 87 | 135 | 163 | CAF1561881.1 unnamed protein product [Didymodactylos carnosus] | diamond | 87 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 30818005 | 30818005 | PRJNA1159911_P_NODE_95194_length_245_cov_0.895349_g94652_i0 | PRJNA1159911 | 95194 | 245 | 0.895349 | 2.19360505 | Adineta | 104781 | Rotifera | other_Eukaryota | 150 | 7.649999999999999e-43 | NR | UJR38082.1 | 104782 | g94652 | i0 | 90.1 | 1.98367346938776 | 81 | 8 | 99.2 | 0 | 3 | 245 | 104 | 184 | UJR38082.1 hypothetical protein I4U23_030763 [Adineta vaga] | diamond | 486 | 151 | 0.993377483443709 | 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);;