contig_metadata
9 rows where bioproject = "PRJNA1074407" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18040257 | 18040257 | PRJNA1074407_P_NODE_128735_length_264_cov_1.591623_g124897_i0 | PRJNA1074407 | 128735 | 264 | 1.591623 | 4.20188472 | Brachionus | 10194 | Rotifera | other_Eukaryota | 144 | 1.52e-40 | NR | WOV68823.1 | 392765 | g124897 | i0 | 83.9 | 2.96590909090909 | 87 | 14 | 98.9 | 0 | 3 | 263 | 59 | 145 | WOV68823.1 cytochrome c oxidase subunit 3 [Brachionus falcatus] | diamond | 783 | 145 | 0.993103448275862 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus falcatus | |
| 29688075 | 29688075 | PRJNA1074407_P_NODE_136430_length_248_cov_0.868571_g132592_i0 | PRJNA1074407 | 136430 | 248 | 0.868571 | 2.15405608 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 82.8 | 3.23e-16 | NR | CAF0877343.1 | 104777 | g132592 | i0 | 50.6 | 0.979838709677419 | 81 | 39 | 96.8 | 1 | 242 | 3 | 2210 | 2290 | CAF0877343.1 unnamed protein product [Brachionus calyciflorus] | diamond | 243 | 82.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 30035879 | 30035879 | PRJNA1074407_P_NODE_135651_length_249_cov_0.863636_g131813_i0 | PRJNA1074407 | 135651 | 249 | 0.863636 | 2.15045364 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 103 | 1.23e-25 | NR | RNA15550.1 | 10195 | g131813 | i0 | 66.7 | 0.867469879518072 | 72 | 24 | 86.7 | 0 | 249 | 34 | 13 | 84 | RNA15550.1 hypothetical protein BpHYR1_027025, partial [Brachionus plicatilis] | diamond | 216 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 30185214 | 30185214 | PRJNA1074407_P_NODE_105892_length_329_cov_0.820312_g102054_i0 | PRJNA1074407 | 105892 | 329 | 0.820312 | 2.69882648 | Brachionus | 10194 | Rotifera | other_Eukaryota | 46.6 | 0.00368 | NR | RNA12279.1 | 10195 | g102054 | i0 | 55 | 0.802431610942249 | 40 | 18 | 36.5 | 0 | 55 | 174 | 183 | 222 | RNA12279.1 mate recognition motif repeat [Brachionus plicatilis] | diamond | 264 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 30469875 | 30469875 | PRJNA1074407_P_NODE_132493_length_255_cov_1.252747_g128655_i0 | PRJNA1074407 | 132493 | 255 | 1.252747 | 3.19450485 | Brachionus | 10194 | Rotifera | other_Eukaryota | 129 | 8.149999999999999e-34 | NR | YP_001728980.1 | 10195 | g128655 | i0 | 84.9 | 2.57647058823529 | 73 | 11 | 85.9 | 0 | 220 | 2 | 31 | 103 | YP_001728980.1 cytochrome b [Brachionus plicatilis] | diamond | 657 | 129 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 30920692 | 30920692 | PRJNA1074407_P_NODE_147234_length_239_cov_0.915663_g143396_i0 | PRJNA1074407 | 147234 | 239 | 0.915663 | 2.18843457 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 78.2 | 9.66e-15 | NR | CAF0953685.1 | 104777 | g143396 | i0 | 43.9 | 1.02928870292887 | 82 | 43 | 99.2 | 1 | 3 | 239 | 321 | 402 | CAF0953685.1 unnamed protein product, partial [Brachionus calyciflorus] | diamond | 246 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 31268128 | 31268128 | PRJNA1074407_P_NODE_118815_length_290_cov_1.792627_g114977_i0 | PRJNA1074407 | 118815 | 290 | 1.792627 | 5.1986183 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 43.9 | 0.0237 | NR | CAF2385174.1 | 2762512 | g114977 | i0 | 35.8 | 0.693103448275862 | 67 | 40 | 66.2 | 1 | 273 | 82 | 232 | 298 | CAF2385174.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 201 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 31710941 | 31710941 | PRJNA1074407_P_NODE_132017_length_256_cov_1.491803_g128179_i0 | PRJNA1074407 | 132017 | 256 | 1.491803 | 3.81901568 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 77.4 | 2.7e-14 | NR | CAF0864311.1 | 104777 | g128179 | i0 | 58.3 | 1.3828125 | 60 | 22 | 68 | 2 | 3 | 176 | 913 | 971 | CAF0864311.1 unnamed protein product [Brachionus calyciflorus] | diamond | 354 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 32217180 | 32217180 | PRJNA1074407_P_NODE_110458_length_314_cov_1.493776_g106620_i0 | PRJNA1074407 | 110458 | 314 | 1.493776 | 4.69045664 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 101 | 9.809999999999999e-24 | NR | CAF0751051.1 | 104777 | g106620 | i0 | 51.6 | 0.907643312101911 | 95 | 45 | 89.8 | 1 | 16 | 297 | 82 | 176 | CAF0751051.1 unnamed protein product [Brachionus calyciflorus] | diamond | 285 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus |
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);;