contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA557895" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26808237 | 26808237 | PRJNA557895_P_NODE_15781_length_231_cov_2.615385_g15426_i0 | PRJNA557895 | 15781 | 231 | 2.615385 | 6.04153935 | Metazoa | 33208 | Rotifera | other_Eukaryota | 70.5 | 4.58e-14 | NR | CAF4832847.1 | 392032 | g15426 | i0 | 60.7 | 7.18181818181818 | 56 | 21 | 71.4 | 1 | 3 | 167 | 12 | 67 | CAF4832847.1 unnamed protein product, partial [Rotaria socialis] | diamond | 1659 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 28057906 | 28057906 | PRJNA557895_P_NODE_18805_length_213_cov_1.554878_g18450_i0 | PRJNA557895 | 18805 | 213 | 1.554878 | 3.31189014 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 84.7 | 2.39e-17 | NR | CAF3715554.1 | 433720 | g18450 | i0 | 71.2 | 1.46478873239437 | 52 | 15 | 73.2 | 0 | 58 | 213 | 157 | 208 | CAF3715554.1 unnamed protein product [Adineta steineri] | diamond | 312 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 28721129 | 28721129 | PRJNA557895_P_NODE_37667_length_162_cov_0.902655_g37312_i0 | PRJNA557895 | 37667 | 162 | 0.902655 | 1.4623011 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 55.5 | 2.02e-7 | NR | CAF4400316.1 | 1234261 | g37312 | i0 | 51.1 | 1.74074074074074 | 47 | 23 | 87 | 0 | 142 | 2 | 66 | 112 | CAF4400316.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 282 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 28973766 | 28973766 | PRJNA557895_P_NODE_12508_length_261_cov_1.391509_g12153_i0 | PRJNA557895 | 12508 | 261 | 1.391509 | 3.63183849 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 86.3 | 2.23e-17 | NR | RNA38746.1 | 10195 | g12153 | i0 | 50 | 1.97701149425287 | 86 | 41 | 98.9 | 2 | 260 | 3 | 216 | 299 | RNA38746.1 dynamin isoform X6 [Brachionus plicatilis] | diamond | 516 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 29082526 | 29082526 | PRJNA557895_P_NODE_28088_length_173_cov_1.233871_g27733_i0 | PRJNA557895 | 28088 | 173 | 1.233871 | 2.13459683 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 45.1 | 0.00212 | NR | KAI3381033.1 | 104778 | g27733 | i0 | 44.4 | 1.73410404624277 | 54 | 26 | 93.6 | 2 | 11 | 172 | 3 | 52 | KAI3381033.1 hypothetical protein SNEBB_004841 [Seison nebaliae] | diamond | 300 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 29461007 | 29461007 | PRJNA557895_P_NODE_35670_length_163_cov_0.894737_g35315_i0 | PRJNA557895 | 35670 | 163 | 0.894737 | 1.45842131 | Adineta | 104781 | Rotifera | other_Eukaryota | 55.5 | 4.11e-7 | NR | UJR24979.1 | 104782 | g35315 | i0 | 41.5 | 3.90184049079755 | 53 | 31 | 97.5 | 0 | 1 | 159 | 316 | 368 | UJR24979.1 hypothetical protein I4U23_006342 [Adineta vaga] | diamond | 636 | 55.8 | 0.99462365591397806 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 30458418 | 30458418 | PRJNA557895_P_NODE_6533_length_350_cov_1.611296_g6178_i0 | PRJNA557895 | 6533 | 350 | 1.611296 | 5.639536 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 110 | 3.4900000000000006e-27 | NR | CAF4171232.1 | 392032 | g6178 | i0 | 53.9 | 0.985714285714286 | 115 | 52 | 98.6 | 1 | 2 | 346 | 124 | 237 | CAF4171232.1 unnamed protein product [Rotaria socialis] | diamond | 345 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 30678988 | 30678988 | PRJNA557895_P_NODE_29473_length_168_cov_1.058824_g29118_i0 | PRJNA557895 | 29473 | 168 | 1.058824 | 1.77882432 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 48.5 | 2.53e-5 | NR | CAF3739707.1 | 2762511 | g29118 | i0 | 42.6 | 2.89285714285714 | 54 | 31 | 96.4 | 0 | 6 | 167 | 56 | 109 | CAF3739707.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 486 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 30742330 | 30742330 | PRJNA557895_P_NODE_30334_length_167_cov_0.864407_g29979_i0 | PRJNA557895 | 30334 | 167 | 0.864407 | 1.44355969 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 50.1 | 3.47e-5 | NR | CAF0708011.1 | 104777 | g29979 | i0 | 38.2 | 2.96407185628743 | 55 | 34 | 98.8 | 0 | 166 | 2 | 774 | 828 | CAF0708011.1 unnamed protein product [Brachionus calyciflorus] | diamond | 495 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 30868644 | 30868644 | PRJNA557895_P_NODE_15294_length_235_cov_1.096774_g14939_i0 | PRJNA557895 | 15294 | 235 | 1.096774 | 2.5774189 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 127 | 1.36e-32 | NR | RNA30386.1 | 10195 | g14939 | i0 | 78.2 | 0.995744680851064 | 78 | 17 | 99.6 | 0 | 1 | 234 | 177 | 254 | RNA30386.1 dihydrolipoamide dehydrogenase E3 subunit [Brachionus plicatilis] | diamond | 234 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 31420136 | 31420136 | PRJNA557895_P_NODE_16636_length_225_cov_2.227273_g16281_i0 | PRJNA557895 | 16636 | 225 | 2.227273 | 5.01136425 | Metazoa | 33208 | Rotifera | other_Eukaryota | 57.4 | 6.51e-8 | NR | CAF1601206.1 | 1234261 | g16281 | i0 | 38.7 | 4.81333333333333 | 75 | 43 | 100 | 2 | 1 | 225 | 39 | 110 | CAF1601206.1 unnamed protein product, partial [Didymodactylos carnosus] | diamond | 1083 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 31515311 | 31515311 | PRJNA557895_P_NODE_21796_length_199_cov_1.020000_g21441_i0 | PRJNA557895 | 21796 | 199 | 1.02 | 2.0298 | Metazoa | 33208 | Rotifera | other_Eukaryota | 95.5 | 5.33e-21 | NR | CAF0843465.1 | 104777 | g21441 | i0 | 70.8 | 1.95979899497487 | 65 | 19 | 98 | 0 | 197 | 3 | 69 | 133 | CAF0843465.1 unnamed protein product [Brachionus calyciflorus] | diamond | 390 | 95.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 31862776 | 31862776 | PRJNA557895_P_NODE_13697_length_250_cov_1.263682_g13342_i0 | PRJNA557895 | 13697 | 250 | 1.263682 | 3.159205 | Brachionus | 10194 | Rotifera | other_Eukaryota | 100 | 1.94e-22 | NR | RNA08825.1 | 10195 | g13342 | i0 | 54.3 | 2.916 | 81 | 37 | 97.2 | 0 | 4 | 246 | 587 | 667 | RNA08825.1 Glycyl-tRNA synthetase [Brachionus plicatilis] | diamond | 729 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 32355373 | 32355373 | PRJNA557895_P_NODE_14939_length_238_cov_1.412698_g14584_i0 | PRJNA557895 | 14939 | 238 | 1.412698 | 3.3622212400000002 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 115 | 6.46e-28 | NR | CAF0818411.1 | 104777 | g14584 | i0 | 67.1 | 2.98739495798319 | 79 | 25 | 99.6 | 1 | 1 | 237 | 496 | 573 | CAF0818411.1 unnamed protein product [Brachionus calyciflorus] | diamond | 711 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 32527710 | 32527710 | PRJNA557895_P_NODE_12059_length_266_cov_0.940092_g11704_i0 | PRJNA557895 | 12059 | 266 | 0.940092 | 2.50064472 | Opisthokonta | 33154 | Rotifera | other_Eukaryota | 43.1 | 0.037 | NR | KAI3389377.1 | 104778 | g11704 | i0 | 56.4 | 0.81203007518797 | 39 | 11 | 37.2 | 1 | 101 | 3 | 1016 | 1054 | KAI3389377.1 hypothetical protein SNEBB_001007 [Seison nebaliae] | diamond | 216 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 32545203 | 32545203 | PRJNA557895_P_NODE_13779_length_249_cov_1.480000_g13424_i0 | PRJNA557895 | 13779 | 249 | 1.48 | 3.6852 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 89.4 | 3.36e-21 | NR | CAF0806762.1 | 249248 | g13424 | i0 | 57.1 | 0.927710843373494 | 77 | 33 | 92.8 | 0 | 246 | 16 | 5 | 81 | CAF0806762.1 unnamed protein product [Adineta ricciae] | diamond | 231 | 89.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae |
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);;