contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA934332" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17488853 | 17488853 | PRJNA934332_P_NODE_1034_length_592_cov_1.038536_g950_i0 | PRJNA934332 | 1034 | 592 | 1.038536 | 6.14813312 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 157 | 5.1399999999999985e-43 | NR | CAF0943387.1 | 433720 | g950 | i0 | 44.4 | 4.01351351351351 | 196 | 104 | 96.8 | 3 | 584 | 12 | 65 | 260 | CAF0943387.1 unnamed protein product [Adineta steineri] | diamond | 2376 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 26866970 | 26866970 | PRJNA934332_P_NODE_9261_length_246_cov_1.427746_g9174_i0 | PRJNA934332 | 9261 | 246 | 1.427746 | 3.51225516 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 65.5 | 3.12e-10 | NR | CAF1030218.1 | 249248 | g9174 | i0 | 43.8 | 1.95121951219512 | 80 | 42 | 97.6 | 2 | 6 | 245 | 234 | 310 | CAF1030218.1 unnamed protein product [Adineta ricciae] | diamond | 480 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 26930077 | 26930077 | PRJNA934332_P_NODE_8022_length_250_cov_0.870056_g7935_i0 | PRJNA934332 | 8022 | 250 | 0.870056 | 2.17514 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 139 | 5.469999999999999e-37 | NR | UJR21102.1 | 104782 | g7935 | i0 | 76.2 | 5.04 | 84 | 19 | 99.6 | 1 | 1 | 249 | 50 | 133 | UJR21102.1 hypothetical protein I4U23_024202 [Adineta vaga] | diamond | 1260 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 27436039 | 27436039 | PRJNA934332_P_NODE_4823_length_301_cov_2.307018_g4736_i0 | PRJNA934332 | 4823 | 301 | 2.307018 | 6.94412418 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 102 | 1.87e-25 | NR | CAF4591474.1 | 1234261 | g4736 | i0 | 55.2 | 0.867109634551495 | 87 | 39 | 86.7 | 0 | 261 | 1 | 4 | 90 | CAF4591474.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 261 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 28263587 | 28263587 | PRJNA934332_P_NODE_8226_length_249_cov_0.875000_g8139_i0 | PRJNA934332 | 8226 | 249 | 0.875 | 2.17875 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 109 | 7.73e-27 | NR | CAF1218123.1 | 249248 | g8139 | i0 | 60.8 | 13.3975903614458 | 79 | 29 | 95.2 | 1 | 12 | 248 | 1 | 77 | CAF1218123.1 unnamed protein product [Adineta ricciae] | diamond | 3336 | 110 | 0.990909090909091 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 30189897 | 30189897 | PRJNA934332_P_NODE_10052_length_244_cov_0.900585_g9965_i0 | PRJNA934332 | 10052 | 244 | 0.900585 | 2.1974274 | Metazoa | 33208 | Rotifera | other_Eukaryota | 52.4 | 1.03e-5 | NR | CAF4858985.1 | 392032 | g9965 | i0 | 37.6 | 3.98360655737705 | 85 | 45 | 98.4 | 3 | 240 | 1 | 101 | 182 | CAF4858985.1 unnamed protein product [Rotaria socialis] | diamond | 972 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 30498950 | 30498950 | PRJNA934332_P_NODE_11213_length_241_cov_0.916667_g11126_i0 | PRJNA934332 | 11213 | 241 | 0.916667 | 2.20916747 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 95.1 | 4.63e-21 | NR | CAF0954160.1 | 1234261 | g11126 | i0 | 59.7 | 0.95850622406639 | 77 | 31 | 95.9 | 0 | 6 | 236 | 43 | 119 | CAF0954160.1 unnamed protein product [Didymodactylos carnosus] | diamond | 231 | 95.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 30941441 | 30941441 | PRJNA934332_P_NODE_5934_length_278_cov_1.375610_g5847_i0 | PRJNA934332 | 5934 | 278 | 1.37561 | 3.8241958 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 121 | 4.02e-32 | NR | CAF1688935.1 | 249248 | g5847 | i0 | 59.8 | 2.85971223021583 | 87 | 35 | 93.9 | 0 | 276 | 16 | 90 | 176 | CAF1688935.1 unnamed protein product, partial [Adineta ricciae] | diamond | 795 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 31232461 | 31232461 | PRJNA934332_P_NODE_2995_length_367_cov_0.731293_g2908_i0 | PRJNA934332 | 2995 | 367 | 0.731293 | 2.68384531 | root | 1 | Root_unresolved | Root_unresolved | 100 | 1.3100000000000002e-21 | NR | CAF1184052.1 | 1234261 | g2908 | i0 | 43.1 | 2.01089918256131 | 123 | 67 | 98.1 | 1 | 363 | 4 | 2570 | 2692 | CAF1184052.1 unnamed protein product [Didymodactylos carnosus] | diamond | 738 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 31858131 | 31858131 | PRJNA934332_P_NODE_7617_length_251_cov_0.865169_g7530_i0 | PRJNA934332 | 7617 | 251 | 0.865169 | 2.17157419 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 98.2 | 1.3e-21 | NR | CAF4139178.1 | 433720 | g7530 | i0 | 56.5 | 6.09561752988048 | 85 | 35 | 99.2 | 1 | 250 | 2 | 625 | 709 | CAF4139178.1 unnamed protein product, partial [Adineta steineri] | diamond | 1530 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 32111383 | 32111383 | PRJNA934332_P_NODE_3418_length_348_cov_0.970909_g3331_i0 | PRJNA934332 | 3418 | 348 | 0.970909 | 3.37876332 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 48.5 | 0.00111 | NR | CAF2956367.1 | 2762512 | g3331 | i0 | 30.9 | 1.62068965517241 | 94 | 55 | 76.7 | 3 | 78 | 344 | 177 | 265 | CAF2956367.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 564 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 |
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);;