contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA911178" and tax_phylum = "Nematoda"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1250020 | 1250020 | PRJNA911178_P_NODE_20561_length_741_cov_16.220060_g18388_i0 | PRJNA911178 | 20561 | 741 | 16.22006 | 120.1906446 | Metazoa | 33208 | Nematoda | Nematoda | 152 | 7.109999999999999e-32 | NTclustered | gi|158821894|gb|EU195958.1| | 473172 | g18388 | i0 | 94 | 22.7327935222672 | 100 | 6 | 13 | 0 | 1 | 100 | 1991 | 1892 | Protorhabditis sp. JB122 28S ribosomal RNA gene, partial sequence | blastn | 16845 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Protorhabditis | Protorhabditis sp. JB122 | |
| 5078276 | 5078276 | PRJNA911178_P_NODE_222924_length_259_cov_2.317204_g220450_i0 | PRJNA911178 | 222924 | 259 | 2.317204 | 6.00155836 | Halicephalobus | 114867 | Nematoda | Nematoda | 472 | 1.53e-128 | NTclustered | gi|564659230|gb|KF765478.1| | 114868 | g220450 | i0 | 100 | 92.2123552123552 | 255 | 0 | 98 | 0 | 1 | 255 | 288 | 34 | Halicephalobus gingivalis isolate Indigo S1342-13 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 23883 | 472 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Halicephalobus | Halicephalobus gingivalis | |
| 5996499 | 5996499 | PRJNA911178_P_NODE_55485_length_467_cov_1.862944_g53048_i0 | PRJNA911178 | 55485 | 467 | 1.862944 | 8.69994848 | Halicephalobus gingivalis | 114868 | Nematoda | Nematoda | 824 | 0 | NTclustered | gi|1003466878|gb|KU180686.1| | 114868 | g53048 | i0 | 98.915 | 35.406852248394 | 461 | 5 | 99 | 0 | 7 | 467 | 1186 | 1646 | Halicephalobus gingivalis 28S ribosomal RNA gene, partial sequence | blastn | 16535 | 824 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Halicephalobus | Halicephalobus gingivalis | |
| 7627677 | 7627677 | PRJNA911178_P_NODE_133506_length_320_cov_1.736842_g131033_i0 | PRJNA911178 | 133506 | 320 | 1.736842 | 5.5578944 | Chromadorea | 119089 | Nematoda | Nematoda | 100 | 1.06e-16 | NTclustered | gi|1380950762|gb|MH244508.1| | 2172462 | g131033 | i0 | 83.036 | 27.0375 | 112 | 17 | 35 | 2 | 28 | 138 | 779 | 669 | Coynema poeyi large subunit ribosomal RNA gene, partial sequence | blastn | 8652 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Hystrignathidae | Coynema | Coynema poeyi | |
| 8544576 | 8544576 | PRJNA911178_P_NODE_149787_length_305_cov_1.327586_g147314_i0 | PRJNA911178 | 149787 | 305 | 1.327586 | 4.0491373 | Diploscapter sp. | 55800 | Nematoda | Nematoda | 521 | 1.8e-143 | NTclustered | gi|2874367539|gb|PQ819468.1| | 55800 | g147314 | i0 | 97.705 | 16.1377049180328 | 305 | 4 | 100 | 2 | 1 | 305 | 55 | 356 | Diploscapter sp. isolate Beetle-FN84 large subunit ribosomal RNA gene, partial sequence | blastn | 4922 | 521 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter sp. | |
| 9819460 | 9819460 | PRJNA911178_P_NODE_136108_length_317_cov_4.250000_g133635_i0 | PRJNA911178 | 136108 | 317 | 4.25 | 13.4725 | Strongyloides ratti | 34506 | Nematoda | Nematoda | 54.7 | 0.008 | NTclustered | gi|1376154095|ref|XM_024646641.1| | 34506 | g133635 | i0 | 96.875 | 0.100946372239748 | 32 | 1 | 10 | 0 | 100 | 131 | 197 | 166 | Strongyloides ratti Zona pellucida domain-containing protein (SRAE_X000123300), partial mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Strongyloididae | Strongyloides | Strongyloides ratti | |
| 10178237 | 10178237 | PRJNA911178_P_NODE_140188_length_313_cov_4.137500_g137715_i0 | PRJNA911178 | 140188 | 313 | 4.1375 | 12.950375 | Metazoa | 33208 | Nematoda | Nematoda | 52.8 | 0.029 | NTclustered | gi|270309021|dbj|AB500154.1| | 6325 | g137715 | i0 | 100 | 0.626198083067093 | 28 | 0 | 9 | 0 | 286 | 313 | 28 | 1 | Bursaphelenchus mucronatus genes for 26S ribosomal RNA, intergenic spacer with variation 1, 18S ribosomal RNA, partial and complete sequence | blastn | 196 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Aphelenchoididae | Bursaphelenchus | Bursaphelenchus mucronatus | |
| 10178975 | 10178975 | PRJNA911178_P_NODE_302948_length_230_cov_2.305732_g300474_i0 | PRJNA911178 | 302948 | 230 | 2.305732 | 5.3031836 | Metazoa | 33208 | Nematoda | Nematoda | 409 | 1.0600000000000001e-109 | NTclustered | gi|158821895|gb|EU195959.1| | 479134 | g300474 | i0 | 99.119 | 71.9478260869565 | 227 | 2 | 99 | 0 | 1 | 227 | 1918 | 1692 | Diploscapter sp. JU359 28S ribosomal RNA gene, partial sequence | blastn | 16548 | 409 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter sp. JU359 | |
| 11453601 | 11453601 | PRJNA911178_P_NODE_189429_length_277_cov_3.602941_g186956_i0 | PRJNA911178 | 189429 | 277 | 3.602941 | 9.98014657 | Oscheius | 42476 | Nematoda | Nematoda | 60.2 | 1.52e-4 | NTclustered | gi|158821906|gb|EU195970.1| | 96645 | g186956 | i0 | 94.737 | 1.09747292418773 | 38 | 2 | 14 | 0 | 139 | 176 | 1403 | 1440 | Oscheius dolichuroides strain DF5018 28S ribosomal RNA gene, partial sequence | blastn | 304 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Oscheius | Oscheius dolichuroides | |
| 15278260 | 15278260 | PRJNA911178_P_NODE_288492_length_242_cov_0.911243_g286018_i0 | PRJNA911178 | 288492 | 242 | 0.911243 | 2.20520806 | Halicephalobus | 114867 | Nematoda | Nematoda | 429 | 8.619999999999998e-116 | NTclustered | gi|2452508156|gb|OQ594699.1| | 3032787 | g286018 | i0 | 100 | 87.3884297520661 | 232 | 0 | 96 | 0 | 10 | 241 | 75 | 306 | Halicephalobus sp. CFB169 small subunit ribosomal RNA gene, partial sequence | blastn | 21148 | 429 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Panagrolaimidae | Halicephalobus | Halicephalobus sp. CFB169 | |
| 16195657 | 16195657 | PRJNA911178_P_NODE_285193_length_242_cov_1.804734_g282719_i0 | PRJNA911178 | 285193 | 242 | 1.804734 | 4.36745628 | Pseudodiplogasteroides sp. VS-2014 | 1538704 | Nematoda | Nematoda | 152 | 2.0899999999999998e-32 | NTclustered | gi|675118779|gb|KJ877250.1| | 1538704 | g282719 | i0 | 83.234 | 45.5082644628099 | 167 | 26 | 69 | 2 | 76 | 241 | 3220 | 3055 | Pseudodiplogasteroides sp. VS-2014 strain SB257 28S ribosomal RNA gene, partial sequence | blastn | 11013 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Diplogasteridae | Pseudodiplogasteroides | Pseudodiplogasteroides sp. VS-2014 | |
| 19101856 | 19101856 | PRJNA911178_P_NODE_297875_length_237_cov_2.439024_g295401_i0 | PRJNA911178 | 297875 | 237 | 2.439024 | 5.78048688 | Metazoa | 33208 | Nematoda | Nematoda | 427 | 3.03e-115 | NTclustered | gi|2874367539|gb|PQ819468.1| | 55800 | g295401 | i0 | 100 | 46.6540084388186 | 231 | 0 | 97 | 0 | 7 | 237 | 366 | 596 | Diploscapter sp. isolate Beetle-FN84 large subunit ribosomal RNA gene, partial sequence | blastn | 11057 | 427 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter sp. | |
| 19102053 | 19102053 | PRJNA911178_P_NODE_49915_length_490_cov_1.954436_g47487_i0 | PRJNA911178 | 49915 | 490 | 1.954436 | 9.5767364 | Diploscapter | 55799 | Nematoda | Nematoda | 885 | 0 | NTclustered | gi|4099006|gb|U81586.1|DSU81586 | 55800 | g47487 | i0 | 99.385 | 86.1204081632653 | 488 | 3 | 99 | 0 | 1 | 488 | 1011 | 524 | Diploscapter sp. 18S small subunit ribosomal RNA gene, partial sequence | blastn | 42199 | 885 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter sp. | |
| 20018253 | 20018253 | PRJNA911178_P_NODE_150276_length_304_cov_4.844156_g147803_i0 | PRJNA911178 | 150276 | 304 | 4.844156 | 14.72623424 | Diploscapter sp. JU359 | 479134 | Nematoda | Nematoda | 542 | 1.38e-149 | NTclustered | gi|158821895|gb|EU195959.1| | 479134 | g147803 | i0 | 99.007 | 58.8190789473684 | 302 | 3 | 99 | 0 | 1 | 302 | 1585 | 1284 | Diploscapter sp. JU359 28S ribosomal RNA gene, partial sequence | blastn | 17881 | 542 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter sp. JU359 | |
| 21651933 | 21651933 | PRJNA911178_P_NODE_156917_length_299_cov_1.212389_g154444_i0 | PRJNA911178 | 156917 | 299 | 1.212389 | 3.62504311 | Diploscapter | 55799 | Nematoda | Nematoda | 540 | 4.87e-149 | NTclustered | gi|8515048|gb|AF083009.1| | 96671 | g154444 | i0 | 99.329 | 98.9297658862876 | 298 | 2 | 99 | 0 | 1 | 298 | 354 | 57 | Diploscapter sp. PS1897 18S ribosomal RNA gene, partial sequence | blastn | 29580 | 545 | 0.990825688073395 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Diploscapter | Diploscapter sp. PS1897 | |
| 22570026 | 22570026 | PRJNA911178_P_NODE_303778_length_228_cov_4.754839_g301304_i0 | PRJNA911178 | 303778 | 228 | 4.754839 | 10.84103292 | Caenorhabditis remanei | 31234 | Nematoda | Nematoda | 54.7 | 0.006 | NTclustered | gi|2445392365|ref|XM_053735414.1| | 31234 | g301304 | i0 | 100 | 0.12719298245614 | 29 | 0 | 13 | 0 | 171 | 199 | 877 | 905 | Caenorhabditis remanei uncharacterized protein (GCK72_023494), partial mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Rhabditidae | Caenorhabditis | Caenorhabditis remanei | |
| 25477435 | 25477435 | PRJNA911178_P_NODE_97540_length_365_cov_1.568493_g95070_i0 | PRJNA911178 | 97540 | 365 | 1.568493 | 5.72499945 | Ascarididae | 6250 | Nematoda | Nematoda | 588 | 2.1399999999999994e-163 | NTclustered | gi|32527518|gb|AY210806.1| | 6252 | g95070 | i0 | 96.111 | 99.572602739726 | 360 | 14 | 99 | 0 | 2 | 361 | 2425 | 2066 | Ascaris lumbricoides 5.8S ribosomal RNA and 28S ribosomal RNA genes, partial sequence | blastn | 36344 | 593 | 0.991568296795953 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Ascarididae | Ascaris | Ascaris lumbricoides |
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);;