contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA635874" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26859840 | 26859840 | PRJNA635874_P_NODE_62541_length_245_cov_0.895349_g62394_i0 | PRJNA635874 | 62541 | 245 | 0.895349 | 2.19360505 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 55.1 | 1.77e-6 | NR | CAF3679437.1 | 2762511 | g62394 | i0 | 37.3 | 1.01632653061224 | 83 | 38 | 94.3 | 2 | 239 | 9 | 1488 | 1562 | CAF3679437.1 unnamed protein product, partial [Rotaria sp. Silwood1] | diamond | 249 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 26985968 | 26985968 | PRJNA635874_P_NODE_57042_length_247_cov_0.885057_g56895_i0 | PRJNA635874 | 57042 | 247 | 0.885057 | 2.18609079 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 50.8 | 4.44e-6 | NR | CAF0795258.1 | 392033 | g56895 | i0 | 66.7 | 0.582995951417004 | 48 | 14 | 55.9 | 2 | 2 | 139 | 33 | 80 | CAF0795258.1 unnamed protein product [Rotaria sordida] | diamond | 144 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 27428877 | 27428877 | PRJNA635874_P_NODE_47063_length_251_cov_0.865169_g46916_i0 | PRJNA635874 | 47063 | 251 | 0.865169 | 2.17157419 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 57.4 | 7.76e-8 | NR | CAF1579466.1 | 1234261 | g46916 | i0 | 43.8 | 2.77290836653386 | 48 | 27 | 57.4 | 0 | 249 | 106 | 120 | 167 | CAF1579466.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 696 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 27807737 | 27807737 | PRJNA635874_P_NODE_57784_length_247_cov_0.885057_g57637_i0 | PRJNA635874 | 57784 | 247 | 0.885057 | 2.18609079 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 63.9 | 2.68e-11 | NR | CAF1026739.1 | 392033 | g57637 | i0 | 50.8 | 0.716599190283401 | 59 | 29 | 71.7 | 0 | 69 | 245 | 2 | 60 | CAF1026739.1 unnamed protein product [Rotaria sordida] | diamond | 177 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 28880903 | 28880903 | PRJNA635874_P_NODE_14768_length_396_cov_1.232198_g14621_i0 | PRJNA635874 | 14768 | 396 | 1.232198 | 4.87950408 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 103 | 1.68e-25 | NR | CAF1526727.1 | 433720 | g14621 | i0 | 44.5 | 1.63636363636364 | 110 | 60 | 83.3 | 1 | 12 | 341 | 1 | 109 | CAF1526727.1 unnamed protein product [Adineta steineri] | diamond | 648 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 28924940 | 28924940 | PRJNA635874_P_NODE_45688_length_252_cov_1.296089_g45541_i0 | PRJNA635874 | 45688 | 252 | 1.296089 | 3.26614428 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 125 | 8.26e-33 | NR | CAF1646217.1 | 249248 | g45541 | i0 | 67.5 | 4.94047619047619 | 83 | 27 | 98.8 | 0 | 1 | 249 | 72 | 154 | CAF1646217.1 unnamed protein product, partial [Adineta ricciae] | diamond | 1245 | 125 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 29480597 | 29480597 | PRJNA635874_P_NODE_2090_length_851_cov_3.498715_g1974_i0 | PRJNA635874 | 2090 | 851 | 3.498715 | 29.77406465 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 104 | 3.15e-24 | NR | CAF3440507.1 | 2762512 | g1974 | i0 | 73.5 | 0.239717978848414 | 68 | 18 | 24 | 0 | 785 | 582 | 1 | 68 | CAF3440507.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 204 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 30124851 | 30124851 | PRJNA635874_P_NODE_49232_length_250_cov_0.870056_g49085_i0 | PRJNA635874 | 49232 | 250 | 0.870056 | 2.17514 | Adineta | 104781 | Rotifera | other_Eukaryota | 52.8 | 1.09e-5 | NR | UJR12533.1 | 104782 | g49085 | i0 | 36.6 | 2.976 | 82 | 49 | 98.4 | 2 | 248 | 3 | 181 | 259 | UJR12533.1 hypothetical protein I4U23_016709 [Adineta vaga] | diamond | 744 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 30491775 | 30491775 | PRJNA635874_P_NODE_32233_length_294_cov_1.045249_g32086_i0 | PRJNA635874 | 32233 | 294 | 1.045249 | 3.07303206 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 112 | 1.59e-29 | NR | CAF4815959.1 | 2762511 | g32086 | i0 | 49 | 5 | 98 | 50 | 100 | 0 | 294 | 1 | 6 | 103 | CAF4815959.1 unnamed protein product, partial [Rotaria sp. Silwood1] | diamond | 1470 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 31009685 | 31009685 | PRJNA635874_P_NODE_17274_length_373_cov_0.903333_g17127_i0 | PRJNA635874 | 17274 | 373 | 0.903333 | 3.36943209 | Rotaria | 231623 | Rotifera | other_Eukaryota | 145 | 1.04e-40 | NR | CAF3232693.1 | 392032 | g17127 | i0 | 59.2 | 9.01608579088472 | 125 | 41 | 92.5 | 1 | 352 | 8 | 15 | 139 | CAF3232693.1 unnamed protein product [Rotaria socialis] | diamond | 3363 | 146 | 0.993150684931507 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 31534912 | 31534912 | PRJNA635874_P_NODE_57956_length_247_cov_0.885057_g57809_i0 | PRJNA635874 | 57956 | 247 | 0.885057 | 2.18609079 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 106 | 1.2699999999999999e-24 | NR | CAF3730229.1 | 2762511 | g57809 | i0 | 57.8 | 1.09311740890688 | 90 | 29 | 98.4 | 2 | 245 | 3 | 1756 | 1845 | CAF3730229.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 270 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 31692822 | 31692822 | PRJNA635874_P_NODE_67417_length_243_cov_0.905882_g67270_i0 | PRJNA635874 | 67417 | 243 | 0.905882 | 2.20129326 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 47.4 | 3.41e-4 | NR | CAF0744213.1 | 1234261 | g67270 | i0 | 32.4 | 0.876543209876543 | 71 | 47 | 86.4 | 1 | 34 | 243 | 63 | 133 | CAF0744213.1 unnamed protein product [Didymodactylos carnosus] | diamond | 213 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 32167625 | 32167625 | PRJNA635874_P_NODE_61818_length_245_cov_0.895349_g61671_i0 | PRJNA635874 | 61818 | 245 | 0.895349 | 2.19360505 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 105 | 4.78e-25 | NR | CAF3329803.1 | 392032 | g61671 | i0 | 61.3 | 4.89795918367347 | 80 | 31 | 98 | 0 | 245 | 6 | 156 | 235 | CAF3329803.1 unnamed protein product [Rotaria socialis] | diamond | 1200 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis |
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);;