contig_metadata
18 rows where bioproject = "PRJNA917598", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 897019 | 897019 | PRJNA917598_P_NODE_85021_length_248_cov_0.880000_g84077_i0 | PRJNA917598 | 85021 | 248 | 0.88 | 2.1824 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 73.6 | 5.69e-13 | NR | CAF0789065.1 | 1234261 | g84077 | i0 | 48.8 | 2.02016129032258 | 84 | 41 | 99.2 | 1 | 246 | 1 | 939 | 1022 | CAF0789065.1 unnamed protein product [Didymodactylos carnosus] | diamond | 501 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 7273652 | 7273652 | PRJNA917598_P_NODE_19146_length_533_cov_2.297826_g18209_i0 | PRJNA917598 | 19146 | 533 | 2.297826 | 12.24741258 | Brachionus rubens | 392764 | Rotifera | other_Eukaryota | 132 | 6.53e-26 | NTclustered | gi|632795126|gb|KJ489417.1| | 392764 | g18209 | i0 | 76.538 | 3.02626641651032 | 260 | 49 | 47 | 11 | 258 | 510 | 6832 | 7086 | Brachionus rubens chromosome I mitochondrion, complete sequence | blastn | 1613 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rubens | |
| 15279217 | 15279217 | PRJNA917598_P_NODE_34472_length_391_cov_1.600629_g33528_i0 | PRJNA917598 | 34472 | 391 | 1.600629 | 6.25845939 | Brachionus | 10194 | Rotifera | other_Eukaryota | 84.7 | 2.39e-16 | NR | YP_001728980.1 | 10195 | g33528 | i0 | 83 | 1.44245524296675 | 47 | 8 | 36.1 | 0 | 250 | 390 | 88 | 134 | YP_001728980.1 cytochrome b [Brachionus plicatilis] | diamond | 564 | 85.1 | 0.995299647473561 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 17475165 | 17475165 | PRJNA917598_P_NODE_80674_length_251_cov_0.865169_g79730_i0 | PRJNA917598 | 80674 | 251 | 0.865169 | 2.17157419 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 130 | 5.78e-33 | NR | CAF0937620.1 | 104777 | g79730 | i0 | 73.5 | 0.99203187250996006 | 83 | 22 | 99.2 | 0 | 1 | 249 | 293 | 375 | CAF0937620.1 unnamed protein product [Brachionus calyciflorus] | diamond | 249 | 130 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 20023401 | 20023401 | PRJNA917598_P_NODE_70376_length_271_cov_1.530303_g69432_i0 | PRJNA917598 | 70376 | 271 | 1.530303 | 4.14712113 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 115 | 1.02e-30 | NR | CAF0787208.1 | 104777 | g69432 | i0 | 64.4 | 0.996309963099631 | 90 | 32 | 99.6 | 0 | 270 | 1 | 9 | 98 | CAF0787208.1 unnamed protein product [Brachionus calyciflorus] | diamond | 270 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 23849328 | 23849328 | PRJNA917598_P_NODE_84899_length_248_cov_0.880000_g83955_i0 | PRJNA917598 | 84899 | 248 | 0.88 | 2.1824 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 69.7 | 1.68e-12 | NR | CAF3322786.1 | 2762511 | g83955 | i0 | 63.8 | 0.568548387096774 | 47 | 17 | 56.9 | 0 | 1 | 141 | 127 | 173 | CAF3322786.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 141 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 26810405 | 26810405 | PRJNA917598_P_NODE_90601_length_244_cov_0.900585_g89657_i0 | PRJNA917598 | 90601 | 244 | 0.900585 | 2.1974274 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 91.7 | 2.39e-19 | NR | CAF1490875.1 | 249248 | g89657 | i0 | 64.5 | 67.6967213114754 | 62 | 22 | 76.2 | 0 | 232 | 47 | 1064 | 1125 | CAF1490875.1 unnamed protein product, partial [Adineta ricciae] | diamond | 16518 | 92.4 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27411463 | 27411463 | PRJNA917598_P_NODE_80383_length_251_cov_0.865169_g79439_i0 | PRJNA917598 | 80383 | 251 | 0.865169 | 2.17157419 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 122 | 2.34e-30 | NR | CAF0773885.1 | 1234261 | g79439 | i0 | 68.7 | 28.7330677290837 | 83 | 26 | 99.2 | 0 | 249 | 1 | 289 | 371 | CAF0773885.1 unnamed protein product [Didymodactylos carnosus] | diamond | 7212 | 123 | 0.991869918699187 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 27498730 | 27498730 | PRJNA917598_P_NODE_68963_length_274_cov_1.492537_g68019_i0 | PRJNA917598 | 68963 | 274 | 1.492537 | 4.08955138 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 75.9 | 8.73e-15 | NR | RNA03447.1 | 10195 | g68019 | i0 | 67.4 | 0.470802919708029 | 43 | 14 | 47.1 | 0 | 145 | 273 | 16 | 58 | RNA03447.1 stanniocalcin family [Brachionus plicatilis] | diamond | 129 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 27751440 | 27751440 | PRJNA917598_P_NODE_75884_length_259_cov_1.645161_g74940_i0 | PRJNA917598 | 75884 | 259 | 1.645161 | 4.26096699 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 65.9 | 2.29e-10 | NR | CAF3754121.1 | 2762511 | g74940 | i0 | 41.6 | 4.12355212355212 | 89 | 46 | 98.5 | 2 | 255 | 1 | 82 | 168 | CAF3754121.1 unnamed protein product, partial [Rotaria sp. Silwood1] | diamond | 1068 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 27845787 | 27845787 | PRJNA917598_P_NODE_64804_length_282_cov_1.464115_g63860_i0 | PRJNA917598 | 64804 | 282 | 1.464115 | 4.1288043 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 94 | 3.16e-20 | NR | CAF1142490.1 | 1234261 | g63860 | i0 | 53.6 | 3.59574468085106 | 84 | 36 | 89.4 | 1 | 29 | 280 | 28 | 108 | CAF1142490.1 unnamed protein product [Didymodactylos carnosus] | diamond | 1014 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 28635563 | 28635563 | PRJNA917598_P_NODE_85147_length_248_cov_0.880000_g84203_i0 | PRJNA917598 | 85147 | 248 | 0.88 | 2.1824 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 147 | 8.81e-39 | NR | CAF0764388.1 | 104777 | g84203 | i0 | 87.8 | 1.98387096774194 | 82 | 10 | 99.2 | 0 | 3 | 248 | 1136 | 1217 | CAF0764388.1 unnamed protein product [Brachionus calyciflorus] | diamond | 492 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 29771789 | 29771789 | PRJNA917598_P_NODE_75571_length_260_cov_1.310160_g74627_i0 | PRJNA917598 | 75571 | 260 | 1.31016 | 3.406416 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 97.8 | 1.9599999999999994e-23 | NR | RNA26745.1 | 10195 | g74627 | i0 | 83.1 | 1.36153846153846 | 59 | 10 | 68.1 | 0 | 83 | 259 | 1 | 59 | RNA26745.1 ferritin [Brachionus plicatilis] | diamond | 354 | 97.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 29810701 | 29810701 | PRJNA917598_P_NODE_89931_length_245_cov_0.895349_g88987_i0 | PRJNA917598 | 89931 | 245 | 0.895349 | 2.19360505 | Rotaria | 231623 | Rotifera | other_Eukaryota | 42.7 | 0.0396 | NR | CAF3908660.1 | 392030 | g88987 | i0 | 40.7 | 4.11428571428571 | 59 | 34 | 72.2 | 1 | 64 | 240 | 972 | 1029 | CAF3908660.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 1008 | 43.1 | 0.990719257540603 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 31130176 | 31130176 | PRJNA917598_P_NODE_62335_length_286_cov_3.201878_g61391_i0 | PRJNA917598 | 62335 | 286 | 3.201878 | 9.15737108 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 69.7 | 2.01e-11 | NR | CAF0894804.1 | 104777 | g61391 | i0 | 59.1 | 0.891608391608392 | 44 | 17 | 45.1 | 1 | 285 | 157 | 452 | 495 | CAF0894804.1 unnamed protein product [Brachionus calyciflorus] | diamond | 255 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 31288448 | 31288448 | PRJNA917598_P_NODE_83675_length_249_cov_0.875000_g82731_i0 | PRJNA917598 | 83675 | 249 | 0.875 | 2.17875 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 124 | 1.09e-30 | NR | CAF1408428.1 | 392033 | g82731 | i0 | 75.3 | 7.2289156626506 | 77 | 19 | 92.8 | 0 | 248 | 18 | 688 | 764 | CAF1408428.1 unnamed protein product [Rotaria sordida] | diamond | 1800 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 31320090 | 31320090 | PRJNA917598_P_NODE_53995_length_310_cov_3.248945_g53051_i0 | PRJNA917598 | 53995 | 310 | 3.248945 | 10.0717295 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 86.7 | 2.64e-17 | NR | CAF1057364.1 | 2762511 | g53051 | i0 | 85.7 | 2.37096774193548 | 49 | 7 | 47.4 | 0 | 162 | 308 | 317 | 365 | CAF1057364.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 735 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 32340001 | 32340001 | PRJNA917598_P_NODE_36339_length_381_cov_1.000000_g35395_i0 | PRJNA917598 | 36339 | 381 | 1 | 3.81 | Brachionus | 10194 | Rotifera | other_Eukaryota | 195 | 8.700000000000002e-60 | NR | RNA19223.1 | 10195 | g35395 | i0 | 78 | 3.8740157480315 | 123 | 27 | 96.9 | 0 | 379 | 11 | 50 | 172 | RNA19223.1 erythrocyte band 7 integral membrane [Brachionus plicatilis] | diamond | 1476 | 196 | 0.994897959183674 | 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);;