contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA971676" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4773037 | 4773037 | PRJNA971676_P_NODE_22584_length_242_cov_0.911243_g22495_i0 | PRJNA971676 | 22584 | 242 | 0.911243 | 2.20520806 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 152 | 8.35e-43 | NR | CAF1670478.1 | 249248 | g22495 | i0 | 85 | 6.94214876033058 | 80 | 12 | 99.2 | 0 | 2 | 241 | 89 | 168 | CAF1670478.1 unnamed protein product, partial [Adineta ricciae] | diamond | 1680 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 7644630 | 7644630 | PRJNA971676_P_NODE_9506_length_291_cov_2.018349_g9417_i0 | PRJNA971676 | 9506 | 291 | 2.018349 | 5.87339559 | Rotaria | 231623 | Rotifera | other_Eukaryota | 141 | 3.31e-38 | NR | CAF4522565.1 | 392032 | g9417 | i0 | 76.7 | 10.5154639175258 | 86 | 20 | 88.7 | 0 | 30 | 287 | 1 | 86 | CAF4522565.1 unnamed protein product [Rotaria socialis] | diamond | 3060 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 23897160 | 23897160 | PRJNA971676_P_NODE_21719_length_243_cov_0.905882_g21630_i0 | PRJNA971676 | 21719 | 243 | 0.905882 | 2.20129326 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 127 | 2.2099999999999998e-32 | NR | CAF1172820.1 | 1234261 | g21630 | i0 | 84.8 | 0.975308641975309 | 79 | 12 | 97.5 | 0 | 241 | 5 | 44 | 122 | CAF1172820.1 unnamed protein product [Didymodactylos carnosus] | diamond | 237 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 27025939 | 27025939 | PRJNA971676_P_NODE_12442_length_263_cov_1.336842_g12353_i0 | PRJNA971676 | 12442 | 263 | 1.336842 | 3.51589446 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 110 | 6.840000000000001e-29 | NR | CAF0751333.1 | 249248 | g12353 | i0 | 96.6 | 0.661596958174905 | 58 | 2 | 66.2 | 0 | 261 | 88 | 26 | 83 | CAF0751333.1 unnamed protein product [Adineta ricciae] | diamond | 174 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27247213 | 27247213 | PRJNA971676_P_NODE_14763_length_250_cov_0.870056_g14674_i0 | PRJNA971676 | 14763 | 250 | 0.870056 | 2.17514 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 58.5 | 1.13e-7 | NR | CAF0925939.1 | 104777 | g14674 | i0 | 48.3 | 1.068 | 89 | 37 | 96 | 3 | 11 | 250 | 245 | 333 | CAF0925939.1 unnamed protein product [Brachionus calyciflorus] | diamond | 267 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 27658042 | 27658042 | PRJNA971676_P_NODE_9604_length_290_cov_1.304147_g9515_i0 | PRJNA971676 | 9604 | 290 | 1.304147 | 3.7820263 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 48.1 | 7e-4 | NR | CAF0810886.1 | 1234261 | g9515 | i0 | 33.3 | 1.92413793103448 | 93 | 45 | 96.2 | 1 | 281 | 3 | 27 | 102 | CAF0810886.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 558 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 27942092 | 27942092 | PRJNA971676_P_NODE_17625_length_247_cov_0.885057_g17536_i0 | PRJNA971676 | 17625 | 247 | 0.885057 | 2.18609079 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 165 | 2.1599999999999998e-47 | NR | CAF1656256.1 | 249248 | g17536 | i0 | 95.1 | 3.98380566801619 | 82 | 4 | 99.6 | 0 | 1 | 246 | 325 | 406 | CAF1656256.1 unnamed protein product, partial [Adineta ricciae] | diamond | 984 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28825823 | 28825823 | PRJNA971676_P_NODE_18228_length_246_cov_1.687861_g18139_i0 | PRJNA971676 | 18228 | 246 | 1.687861 | 4.15213806 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 67.4 | 5.1e-11 | NR | CAF2080998.1 | 392030 | g18139 | i0 | 45.5 | 3.75609756097561 | 77 | 41 | 92.7 | 1 | 17 | 244 | 95 | 171 | CAF2080998.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 924 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 28927032 | 28927032 | PRJNA971676_P_NODE_21348_length_243_cov_0.905882_g21259_i0 | PRJNA971676 | 21348 | 243 | 0.905882 | 2.20129326 | Brachionus | 10194 | Rotifera | other_Eukaryota | 59.7 | 1.31e-8 | NR | RNA32102.1 | 10195 | g21259 | i0 | 36 | 2.11111111111111 | 86 | 49 | 98.8 | 2 | 243 | 4 | 91 | 176 | RNA32102.1 hypothetical protein BpHYR1_050508 [Brachionus plicatilis] | diamond | 513 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 29047197 | 29047197 | PRJNA971676_P_NODE_9448_length_292_cov_1.410959_g9359_i0 | PRJNA971676 | 9448 | 292 | 1.410959 | 4.12000028 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 63.9 | 2.45e-9 | NR | CAF0821153.1 | 104777 | g9359 | i0 | 54.6 | 0.996575342465753 | 97 | 42 | 99.7 | 1 | 291 | 1 | 246 | 340 | CAF0821153.1 unnamed protein product [Brachionus calyciflorus] | diamond | 291 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 29110344 | 29110344 | PRJNA971676_P_NODE_22288_length_242_cov_0.911243_g22199_i0 | PRJNA971676 | 22288 | 242 | 0.911243 | 2.20520806 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 140 | 6.469999999999998e-41 | NR | CAF1685326.1 | 249248 | g22199 | i0 | 81.1 | 1.83471074380165 | 74 | 14 | 91.7 | 0 | 13 | 234 | 1 | 74 | CAF1685326.1 unnamed protein product, partial [Adineta ricciae] | diamond | 444 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 29615093 | 29615093 | PRJNA971676_P_NODE_18510_length_246_cov_0.890173_g18421_i0 | PRJNA971676 | 18510 | 246 | 0.890173 | 2.18982558 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 60.8 | 1.58e-8 | NR | CAF1099421.1 | 1234261 | g18421 | i0 | 41.8 | 1.92682926829268 | 79 | 42 | 96.3 | 1 | 3 | 239 | 510 | 584 | CAF1099421.1 unnamed protein product [Didymodactylos carnosus] | diamond | 474 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 31384914 | 31384914 | PRJNA971676_P_NODE_18916_length_246_cov_0.890173_g18827_i0 | PRJNA971676 | 18916 | 246 | 0.890173 | 2.18982558 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 101 | 3.86e-23 | NR | CAF0986930.1 | 249248 | g18827 | i0 | 77.1 | 1.70731707317073 | 70 | 16 | 85.4 | 0 | 37 | 246 | 1 | 70 | CAF0986930.1 unnamed protein product [Adineta ricciae] | diamond | 420 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 31795770 | 31795770 | PRJNA971676_P_NODE_16437_length_249_cov_0.875000_g16348_i0 | PRJNA971676 | 16437 | 249 | 0.875 | 2.17875 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 47 | 0.00135 | NR | RNA22496.1 | 10195 | g16348 | i0 | 42.2 | 1.08433734939759 | 90 | 40 | 98.8 | 3 | 1 | 246 | 14 | 99 | RNA22496.1 cohesin subunit SA-1-like isoform X2 [Brachionus plicatilis] | diamond | 270 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis |
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);;