contig_metadata
17 rows where analysis = "diamond", bioproject = "PRJNA493828" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27709152 | 27709152 | PRJNA493828_P_NODE_44964_length_219_cov_5.095890_g44545_i0 | PRJNA493828 | 44964 | 219 | 5.09589 | 11.1599991 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 102 | 2.3399999999999994e-23 | NR | UJR20983.1 | 104782 | g44545 | i0 | 96 | 2.05479452054795 | 50 | 2 | 68.5 | 0 | 218 | 69 | 370 | 419 | UJR20983.1 hypothetical protein I4U23_024088 [Adineta vaga] | diamond | 450 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 27866443 | 27866443 | PRJNA493828_P_NODE_41245_length_236_cov_2.797546_g40826_i0 | PRJNA493828 | 41245 | 236 | 2.797546 | 6.60220856 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 78.2 | 1.93e-16 | NR | CAF1356670.1 | 249248 | g40826 | i0 | 74.5 | 2.8728813559322 | 55 | 12 | 69.9 | 1 | 19 | 183 | 42 | 94 | CAF1356670.1 unnamed protein product [Adineta ricciae] | diamond | 678 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 27961296 | 27961296 | PRJNA493828_P_NODE_45585_length_214_cov_4.950355_g45166_i0 | PRJNA493828 | 45585 | 214 | 4.950355 | 10.5937597 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 94.7 | 1.29e-20 | NR | CAF1470691.1 | 249248 | g45166 | i0 | 71.4 | 0.883177570093458 | 63 | 17 | 86.9 | 1 | 2 | 187 | 355 | 417 | CAF1470691.1 unnamed protein product [Adineta ricciae] | diamond | 189 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28308693 | 28308693 | PRJNA493828_P_NODE_39726_length_241_cov_0.916667_g39307_i0 | PRJNA493828 | 39726 | 241 | 0.916667 | 2.20916747 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 113 | 4.12e-27 | NR | CAF1518878.1 | 249248 | g39307 | i0 | 73.4 | 0.983402489626556 | 79 | 21 | 98.3 | 0 | 238 | 2 | 24 | 102 | CAF1518878.1 unnamed protein product [Adineta ricciae] | diamond | 237 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28466632 | 28466632 | PRJNA493828_P_NODE_10386_length_355_cov_0.914894_g9967_i0 | PRJNA493828 | 10386 | 355 | 0.914894 | 3.2478737 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 62.8 | 1.3e-8 | NR | KAI3378399.1 | 104778 | g9967 | i0 | 36.4 | 1.96901408450704 | 121 | 68 | 98.9 | 4 | 353 | 3 | 414 | 529 | KAI3378399.1 hypothetical protein SNEBB_008308 [Seison nebaliae] | diamond | 699 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae | |
| 28719141 | 28719141 | PRJNA493828_P_NODE_21627_length_282_cov_0.889952_g21208_i0 | PRJNA493828 | 21627 | 282 | 0.889952 | 2.50966464 | Rotaria sp. Silwood1 | 2762511 | Rotifera | other_Eukaryota | 63.2 | 2.17e-9 | NR | CAF3893110.1 | 2762511 | g21208 | i0 | 37.2 | 2.02127659574468 | 94 | 54 | 95.7 | 3 | 6 | 275 | 4 | 96 | CAF3893110.1 unnamed protein product [Rotaria sp. Silwood1] | diamond | 570 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood1 | |
| 28845187 | 28845187 | PRJNA493828_P_NODE_17148_length_302_cov_4.179039_g16729_i0 | PRJNA493828 | 17148 | 302 | 4.179039 | 12.62069778 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 68.6 | 5.68e-12 | NR | RNA15979.1 | 10195 | g16729 | i0 | 48.1 | 0.764900662251656 | 77 | 40 | 76.5 | 0 | 233 | 3 | 77 | 153 | RNA15979.1 hypothetical protein BpHYR1_050970 [Brachionus plicatilis] | diamond | 231 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 28923957 | 28923957 | PRJNA493828_P_NODE_37788_length_243_cov_1.805882_g37369_i0 | PRJNA493828 | 37788 | 243 | 1.805882 | 4.38829326 | Adineta | 104781 | Rotifera | other_Eukaryota | 65.9 | 2.66e-10 | NR | UJR28918.1 | 104782 | g37369 | i0 | 88.6 | 1.2962962962963 | 35 | 4 | 43.2 | 0 | 105 | 209 | 692 | 726 | UJR28918.1 hypothetical protein I4U23_010136 [Adineta vaga] | diamond | 315 | 66.2 | 0.995468277945619 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 29334585 | 29334585 | PRJNA493828_P_NODE_22709_length_278_cov_1.502439_g22290_i0 | PRJNA493828 | 22709 | 278 | 1.502439 | 4.17678042 | Rotaria | 231623 | Rotifera | other_Eukaryota | 57.4 | 3.86e-7 | NR | CAF3903691.1 | 392030 | g22290 | i0 | 57.8 | 3.46402877697842 | 45 | 19 | 48.6 | 0 | 264 | 130 | 54 | 98 | CAF3903691.1 unnamed protein product, partial [Rotaria magnacalcarata] | diamond | 963 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 29634327 | 29634327 | PRJNA493828_P_NODE_43970_length_226_cov_5.006536_g43551_i0 | PRJNA493828 | 43970 | 226 | 5.006536 | 11.31477136 | Rotaria sordida | 392033 | Rotifera | other_Eukaryota | 85.1 | 3.63e-17 | NR | CAF0857788.1 | 392033 | g43551 | i0 | 56.8 | 2.19026548672566 | 74 | 21 | 83.6 | 2 | 225 | 37 | 384 | 457 | CAF0857788.1 unnamed protein product [Rotaria sordida] | diamond | 495 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sordida | |
| 29919060 | 29919060 | PRJNA493828_P_NODE_14131_length_312_cov_3.016736_g13712_i0 | PRJNA493828 | 14131 | 312 | 3.016736 | 9.41221632 | Brachionus plicatilis | 10195 | Rotifera | other_Eukaryota | 86.7 | 1.66e-17 | NR | RNA44696.1 | 10195 | g13712 | i0 | 77.6 | 0.942307692307692 | 49 | 11 | 47.1 | 0 | 308 | 162 | 21 | 69 | RNA44696.1 Twitchin, partial [Brachionus plicatilis] | diamond | 294 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 29919062 | 29919062 | PRJNA493828_P_NODE_22671_length_278_cov_1.873171_g22252_i0 | PRJNA493828 | 22671 | 278 | 1.873171 | 5.20741538 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 110 | 9.23e-27 | NR | CAF2586522.1 | 2762512 | g22252 | i0 | 56.8 | 3.49640287769784 | 81 | 35 | 87.4 | 0 | 1 | 243 | 190 | 270 | CAF2586522.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 972 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 30203004 | 30203004 | PRJNA493828_P_NODE_35632_length_246_cov_1.531792_g35213_i0 | PRJNA493828 | 35632 | 246 | 1.531792 | 3.76820832 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 92.4 | 2.86e-20 | NR | CAF3325942.1 | 2762512 | g35213 | i0 | 61.6 | 1.78048780487805 | 73 | 28 | 89 | 0 | 28 | 246 | 1 | 73 | CAF3325942.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 438 | 92.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 30361706 | 30361706 | PRJNA493828_P_NODE_29812_length_256_cov_3.803279_g29393_i0 | PRJNA493828 | 29812 | 256 | 3.803279 | 9.73639424 | Brachionus calyciflorus | 104777 | Rotifera | other_Eukaryota | 77.4 | 8.74e-16 | NR | CAF0775232.1 | 104777 | g29393 | i0 | 53 | 3.03515625 | 66 | 31 | 77.3 | 0 | 253 | 56 | 78 | 143 | CAF0775232.1 unnamed protein product [Brachionus calyciflorus] | diamond | 777 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 30613896 | 30613896 | PRJNA493828_P_NODE_34593_length_247_cov_3.925287_g34174_i0 | PRJNA493828 | 34593 | 247 | 3.925287 | 9.69545889 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 48.1 | 8.76e-5 | NR | CAF4129484.1 | 433720 | g34174 | i0 | 46 | 0.607287449392713 | 50 | 27 | 60.7 | 0 | 204 | 55 | 29 | 78 | CAF4129484.1 unnamed protein product [Adineta steineri] | diamond | 150 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 31040641 | 31040641 | PRJNA493828_P_NODE_35975_length_246_cov_0.890173_g35556_i0 | PRJNA493828 | 35975 | 246 | 0.890173 | 2.18982558 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 79.7 | 2.28e-15 | NR | RNA44400.1 | 10195 | g35556 | i0 | 67.3 | 6.58536585365854 | 52 | 17 | 63.4 | 0 | 165 | 10 | 198 | 249 | RNA44400.1 BTB POZ domain-containing KCTD21 [Brachionus plicatilis] | diamond | 1620 | 80.5 | 0.990062111801242 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 32511692 | 32511692 | PRJNA493828_P_NODE_7559_length_408_cov_1.116418_g7145_i0 | PRJNA493828 | 7559 | 408 | 1.116418 | 4.55498544 | Brachionus rotundiformis | 96890 | Rotifera | other_Eukaryota | 81.6 | 4.85e-16 | NR | AYN44500.1 | 96890 | g7145 | i0 | 37.6 | 1.93382352941176 | 133 | 76 | 94.1 | 3 | 1 | 384 | 71 | 201 | AYN44500.1 glutathione S-transferase S4 [Brachionus rotundiformis] | diamond | 789 | 81.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus rotundiformis |
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);;