contig_metadata
9 rows where bioproject = "PRJNA554794", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19647282 | 19647282 | PRJNA554794_P_NODE_20916_length_187_cov_0.681159_g16987_i0 | PRJNA554794 | 20916 | 187 | 0.681159 | 1.27376733 | Brachionus falcatus | 392765 | Rotifera | other_Eukaryota | 152 | 1.5299999999999998e-32 | NTclustered | gi|2615504964|gb|OR601541.1| | 392765 | g16987 | i0 | 84.713 | 47.331550802139 | 157 | 18 | 83 | 6 | 3 | 157 | 10384 | 10232 | Brachionus falcatus chromosome 1 mitochondrion, complete sequence | blastn | 8851 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus falcatus | |
| 27078248 | 27078248 | PRJNA554794_P_NODE_24742_length_161_cov_0.901786_g20813_i0 | PRJNA554794 | 24742 | 161 | 0.901786 | 1.45187546 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 43.1 | 0.00856 | NR | CAF1620202.1 | 249248 | g20813 | i0 | 43.1 | 1.90062111801242 | 51 | 29 | 95 | 0 | 3 | 155 | 157 | 207 | CAF1620202.1 unnamed protein product, partial [Adineta ricciae] | diamond | 306 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27267842 | 27267842 | PRJNA554794_P_NODE_20203_length_198_cov_1.033557_g16274_i0 | PRJNA554794 | 20203 | 198 | 1.033557 | 2.04644286 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 55.8 | 1.12e-7 | NR | CAF1128076.1 | 2762511 | g16274 | i0 | 41 | 0.924242424242424 | 61 | 32 | 86.4 | 2 | 172 | 2 | 6 | 66 | CAF1128076.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 183 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 28671981 | 28671981 | PRJNA554794_P_NODE_22967_length_166_cov_0.863248_g19038_i0 | PRJNA554794 | 22967 | 166 | 0.863248 | 1.43299168 | Metazoa | 33208 | Rotifera | other_Eukaryota | 73.9 | 9.57e-14 | NR | RNA11224.1 | 10195 | g19038 | i0 | 64.8 | 3.90361445783133 | 54 | 19 | 97.6 | 0 | 164 | 3 | 188 | 241 | RNA11224.1 cathepsin L [Brachionus plicatilis] | diamond | 648 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 28735045 | 28735045 | PRJNA554794_P_NODE_14267_length_224_cov_1.434286_g10338_i0 | PRJNA554794 | 14267 | 224 | 1.434286 | 3.21280064 | root | 1 | Root_unresolved | Root_unresolved | 58.5 | 1.18e-8 | NR | CAF3790859.1 | 433720 | g10338 | i0 | 64.4 | 3.05357142857143 | 73 | 26 | 97.8 | 0 | 221 | 3 | 4 | 76 | CAF3790859.1 unnamed protein product [Adineta steineri] | diamond | 684 | 58.9 | 0.99320882852292 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 30268120 | 30268120 | PRJNA554794_P_NODE_14612_length_217_cov_1.761905_g10683_i0 | PRJNA554794 | 14612 | 217 | 1.761905 | 3.82333385 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 45.8 | 0.00218 | NR | CAF1371257.1 | 1234261 | g10683 | i0 | 45.8 | 3.13824884792627 | 59 | 31 | 81.6 | 1 | 177 | 1 | 180 | 237 | CAF1371257.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 681 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 31135151 | 31135151 | PRJNA554794_P_NODE_21215_length_183_cov_1.283582_g17286_i0 | PRJNA554794 | 21215 | 183 | 1.283582 | 2.34895506 | Metazoa | 33208 | Rotifera | other_Eukaryota | 104 | 3.15e-26 | NR | CAF1066595.1 | 249248 | g17286 | i0 | 78.7 | 59 | 61 | 13 | 100 | 0 | 183 | 1 | 133 | 193 | CAF1066595.1 unnamed protein product [Adineta ricciae] | diamond | 10797 | 105 | 0.990476190476191 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 32069721 | 32069721 | PRJNA554794_P_NODE_14138_length_227_cov_0.932584_g10209_i0 | PRJNA554794 | 14138 | 227 | 0.932584 | 2.11696568 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 59.7 | 1.23e-8 | NR | CAF0950857.1 | 104777 | g10209 | i0 | 35.9 | 1.03083700440529 | 78 | 46 | 97.8 | 1 | 6 | 227 | 69 | 146 | CAF0950857.1 unnamed protein product [Brachionus calyciflorus] | diamond | 234 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 32228134 | 32228134 | PRJNA554794_P_NODE_19698_length_207_cov_1.272152_g15769_i0 | PRJNA554794 | 19698 | 207 | 1.272152 | 2.63335464 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 52.4 | 9.13e-6 | NR | CAF0917748.1 | 104777 | g15769 | i0 | 42.3 | 5.23188405797101 | 52 | 30 | 75.4 | 0 | 52 | 207 | 30 | 81 | CAF0917748.1 unnamed protein product [Brachionus calyciflorus] | diamond | 1083 | 52.4 | 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);;