contig_metadata
16 rows where bioproject = "PRJNA734348", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1197448 | 1197448 | PRJNA734348_P_NODE_76881_length_263_cov_2.057895_g76183_i0 | PRJNA734348 | 76881 | 263 | 2.057895 | 5.41226385 | Adineta | 104781 | Rotifera | other_Eukaryota | 420 | 5.71e-113 | NTclustered | gi|1005055598|gb|KU860741.1| | 1813167 | g76183 | i0 | 95.455 | 92.0304182509506 | 264 | 11 | 100 | 1 | 1 | 263 | 145 | 408 | Adineta vaga complex sp. D JFF-2016 isolate H3-14b 28S ribosomal RNA gene, partial sequence | blastn | 24204 | 420 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga complex sp. D JFF-2016 | |
| 8372106 | 8372106 | PRJNA734348_P_NODE_74347_length_265_cov_3.015625_g73649_i0 | PRJNA734348 | 74347 | 265 | 3.015625 | 7.99140625 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 479 | 9.38e-131 | NTclustered | gi|72153731|gb|DQ089739.1| | 104782 | g73649 | i0 | 99.245 | 58.0264150943396 | 265 | 2 | 100 | 0 | 1 | 265 | 2719 | 2455 | Adineta vaga 28S ribosomal RNA gene, partial sequence | blastn | 15377 | 479 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 14746489 | 14746489 | PRJNA734348_P_NODE_146832_length_212_cov_5.805755_g146134_i0 | PRJNA734348 | 146832 | 212 | 5.8057550000000004 | 12.3082006 | Adineta vaga | 104782 | Rotifera | other_Eukaryota | 272 | 1.3099999999999999e-68 | NTclustered | gi|259129963|gb|GQ398061.1| | 104782 | g146134 | i0 | 94.35 | 2.5188679245283 | 177 | 10 | 83 | 0 | 36 | 212 | 10398 | 10222 | Adineta vaga 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence | blastn | 534 | 272 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 26650853 | 26650853 | PRJNA734348_P_NODE_150461_length_197_cov_4.588710_g149763_i0 | PRJNA734348 | 150461 | 197 | 4.58871 | 9.0397587 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 103 | 4.81e-24 | NR | CAF1444607.1 | 249248 | g149763 | i0 | 73.8 | 7.79695431472081 | 65 | 17 | 99 | 0 | 2 | 196 | 363 | 427 | CAF1444607.1 unnamed protein product [Adineta ricciae] | diamond | 1536 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae | |
| 28230956 | 28230956 | PRJNA734348_P_NODE_134846_length_240_cov_2.604790_g134148_i0 | PRJNA734348 | 134846 | 240 | 2.60479 | 6.251496 | Rotaria | 231623 | Rotifera | other_Eukaryota | 88.6 | 2.34e-18 | NR | CAF4903980.1 | 392032 | g134148 | i0 | 58.3 | 7.4 | 72 | 29 | 90 | 1 | 239 | 24 | 36 | 106 | CAF4903980.1 unnamed protein product [Rotaria socialis] | diamond | 1776 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 28663201 | 28663201 | PRJNA734348_P_NODE_81307_length_259_cov_2.725806_g80609_i0 | PRJNA734348 | 81307 | 259 | 2.725806 | 7.05983754 | Rotaria magnacalcarata | 392030 | Rotifera | other_Eukaryota | 67.4 | 9.67e-11 | NR | CAF4043758.1 | 392030 | g80609 | i0 | 55.2 | 0.671814671814672 | 58 | 26 | 67.2 | 0 | 174 | 1 | 226 | 283 | CAF4043758.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 174 | 67.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 28894116 | 28894116 | PRJNA734348_P_NODE_108688_length_247_cov_0.885057_g107990_i0 | PRJNA734348 | 108688 | 247 | 0.885057 | 2.18609079 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 100 | 3.33e-23 | NR | CAF3279697.1 | 392032 | g107990 | i0 | 63 | 2.95141700404858 | 81 | 30 | 98.4 | 0 | 4 | 246 | 123 | 203 | CAF3279697.1 unnamed protein product [Rotaria socialis] | diamond | 729 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 28925736 | 28925736 | PRJNA734348_P_NODE_87708_length_254_cov_1.646409_g87010_i0 | PRJNA734348 | 87708 | 254 | 1.646409 | 4.18187886 | Adineta | 104781 | Rotifera | other_Eukaryota | 60.5 | 8.45e-10 | NR | UJR08309.1 | 104782 | g87010 | i0 | 96.3 | 0.637795275590551 | 27 | 1 | 31.9 | 0 | 99 | 179 | 1 | 27 | UJR08309.1 hypothetical protein I4U23_012580 [Adineta vaga] | diamond | 162 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta vaga | |
| 28978922 | 28978922 | PRJNA734348_P_NODE_112648_length_246_cov_0.890173_g111950_i0 | PRJNA734348 | 112648 | 246 | 0.890173 | 2.18982558 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 72 | 1.9e-12 | NR | CAF4104489.1 | 433720 | g111950 | i0 | 56.9 | 1.24390243902439 | 51 | 22 | 62.2 | 0 | 174 | 22 | 340 | 390 | CAF4104489.1 unnamed protein product, partial [Adineta steineri] | diamond | 306 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29231566 | 29231566 | PRJNA734348_P_NODE_58049_length_281_cov_2.942308_g57352_i0 | PRJNA734348 | 58049 | 281 | 2.942308 | 8.26788548 | Adineta steineri | 433720 | Rotifera | other_Eukaryota | 105 | 2.32e-25 | NR | CAF4225657.1 | 433720 | g57352 | i0 | 50.5 | 2.11387900355872 | 99 | 43 | 99.3 | 1 | 279 | 1 | 47 | 145 | CAF4225657.1 unnamed protein product, partial [Adineta steineri] | diamond | 594 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta steineri | |
| 29578492 | 29578492 | PRJNA734348_P_NODE_76150_length_264_cov_1.429319_g75452_i0 | PRJNA734348 | 76150 | 264 | 1.429319 | 3.77340216 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 76.3 | 7.63e-14 | NR | CAF0912973.1 | 1234261 | g75452 | i0 | 68 | 0.568181818181818 | 50 | 16 | 56.8 | 0 | 155 | 6 | 8 | 57 | CAF0912973.1 unnamed protein product [Didymodactylos carnosus] | diamond | 150 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus | |
| 29904788 | 29904788 | PRJNA734348_P_NODE_144031_length_226_cov_4.176471_g143333_i0 | PRJNA734348 | 144031 | 226 | 4.176471 | 9.43882446 | Eurotatoria | 2816136 | Rotifera | other_Eukaryota | 62 | 4.85e-9 | NR | CAF0879575.1 | 104777 | g143333 | i0 | 72.2 | 0.969026548672566 | 36 | 10 | 47.8 | 0 | 116 | 223 | 289 | 324 | CAF0879575.1 unnamed protein product [Brachionus calyciflorus] | diamond | 219 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus calyciflorus | |
| 30842412 | 30842412 | PRJNA734348_P_NODE_139974_length_232_cov_2.880503_g139276_i0 | PRJNA734348 | 139974 | 232 | 2.880503 | 6.68276696 | Rotaria socialis | 392032 | Rotifera | other_Eukaryota | 82 | 4.83e-16 | NR | CAF3434864.1 | 392032 | g139276 | i0 | 52.1 | 9.40086206896552 | 73 | 34 | 94.4 | 1 | 220 | 2 | 859 | 930 | CAF3434864.1 unnamed protein product [Rotaria socialis] | diamond | 2181 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria socialis | |
| 32307571 | 32307571 | PRJNA734348_P_NODE_52439_length_287_cov_2.154206_g51742_i0 | PRJNA734348 | 52439 | 287 | 2.154206 | 6.18257122 | Philodinidae | 44580 | Rotifera | other_Eukaryota | 85.1 | 8.14e-17 | NR | CAF3963525.1 | 392030 | g51742 | i0 | 50 | 7.90243902439024 | 76 | 38 | 79.4 | 0 | 283 | 56 | 130 | 205 | CAF3963525.1 unnamed protein product [Rotaria magnacalcarata] | diamond | 2268 | 85.5 | 0.9953216374269 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria magnacalcarata | |
| 32581939 | 32581939 | PRJNA734348_P_NODE_95399_length_250_cov_1.564972_g94701_i0 | PRJNA734348 | 95399 | 250 | 1.564972 | 3.91243 | Rotaria sp. Silwood2 | 2762512 | Rotifera | other_Eukaryota | 87.4 | 3.64e-20 | NR | CAF2408154.1 | 2762512 | g94701 | i0 | 65.2 | 0.792 | 66 | 15 | 69.6 | 1 | 249 | 76 | 43 | 108 | CAF2408154.1 unnamed protein product [Rotaria sp. Silwood2] | diamond | 198 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Rotaria | Rotaria sp. Silwood2 | |
| 32865118 | 32865118 | PRJNA734348_P_NODE_78340_length_262_cov_1.571429_g77642_i0 | PRJNA734348 | 78340 | 262 | 1.571429 | 4.11714398 | Didymodactylos carnosus | 1234261 | Rotifera | other_Eukaryota | 146 | 2.88e-40 | NR | CAF1381070.1 | 1234261 | g77642 | i0 | 83.7 | 0.984732824427481 | 86 | 14 | 98.5 | 0 | 3 | 260 | 148 | 233 | CAF1381070.1 unnamed protein product [Didymodactylos carnosus] | diamond | 258 | 146 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Philodinida | Philodinidae | Didymodactylos | Didymodactylos carnosus |
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);;