contig_metadata
28 rows where bioproject = "PRJNA999043" and tax_phylum = "Arthropoda"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 979557 | 979557 | PRJNA999043_P_NODE_16141_length_336_cov_1.273764_g16046_i0 | PRJNA999043 | 16141 | 336 | 1.273764 | 4.27984704 | Tropilaelaps mercedesae | 418985 | Arthropoda | Arthropoda | 176 | 6e-51 | NR | OQR74553.1 | 418985 | g16046 | i0 | 82.1 | 1.99107142857143 | 112 | 19 | 99.1 | 1 | 3 | 335 | 36 | 147 | OQR74553.1 hypothetical protein BIW11_08987, partial [Tropilaelaps mercedesae] | diamond | 669 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Laelapidae | Tropilaelaps | Tropilaelaps mercedesae | |
| 980273 | 980273 | PRJNA999043_P_NODE_9421_length_543_cov_1.431915_g9329_i0 | PRJNA999043 | 9421 | 543 | 1.431915 | 7.77529845 | Galendromus occidentalis | 34638 | Arthropoda | Arthropoda | 322 | 3.69e-83 | NTclustered | gi|1634083861|ref|XM_029111724.1| | 34638 | g9329 | i0 | 84.024 | 0.622467771639042 | 338 | 51 | 62 | 2 | 17 | 351 | 1 | 338 | PREDICTED: Metaseiulus occidentalis adult-specific rigid cuticular protein 15.5-like (LOC100903176), mRNA | blastn | 338 | 322 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Galendromus | Galendromus occidentalis | |
| 1274026 | 1274026 | PRJNA999043_P_NODE_21061_length_256_cov_1.262295_g20966_i0 | PRJNA999043 | 21061 | 256 | 1.262295 | 3.2314752 | Phytoseiidae | 34636 | Arthropoda | Arthropoda | 473 | 4.189999999999999e-129 | NTclustered | gi|365799480|dbj|AB618055.1| | 84382 | g20966 | i0 | 100 | 100.12109375 | 256 | 0 | 100 | 0 | 1 | 256 | 19 | 274 | Neoseiulus californicus genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence, isolate: 02NcaCI | blastn | 25631 | 473 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Neoseiulus | Neoseiulus californicus | |
| 3529995 | 3529995 | PRJNA999043_P_NODE_12183_length_440_cov_2.656676_g12089_i0 | PRJNA999043 | 12183 | 440 | 2.656676 | 11.6893744 | Neoseiulus californicus | 84382 | Arthropoda | Arthropoda | 813 | 0 | NTclustered | gi|2583621169|gb|OR195436.2| | 84382 | g12089 | i0 | 100 | 3.45909090909091 | 440 | 0 | 100 | 0 | 1 | 440 | 11563 | 11124 | Neoseiulus californicus isolate Biodefence Line-02 mitochondrion, complete genome | blastn | 1522 | 813 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Neoseiulus | Neoseiulus californicus | |
| 6082591 | 6082591 | PRJNA999043_P_NODE_13045_length_415_cov_1.122807_g12950_i0 | PRJNA999043 | 13045 | 415 | 1.1228070000000001 | 4.65964905 | Galendromus occidentalis | 34638 | Arthropoda | Arthropoda | 326 | 2.13e-84 | NTclustered | gi|1078801832|ref|XR_001951152.1| | 34638 | g12950 | i0 | 82.014 | 2.00963855421687 | 417 | 44 | 99 | 15 | 2 | 414 | 565 | 176 | PREDICTED: Metaseiulus occidentalis uncharacterized LOC100904891 (LOC100904891), transcript variant X1, ncRNA | blastn | 834 | 326 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Galendromus | Galendromus occidentalis | |
| 6082612 | 6082612 | PRJNA999043_P_NODE_13505_length_402_cov_0.936170_g13410_i0 | PRJNA999043 | 13505 | 402 | 0.93617 | 3.7634034 | Neoseiulus californicus | 84382 | Arthropoda | Arthropoda | 741 | 0 | NTclustered | gi|2583621169|gb|OR195436.2| | 84382 | g13410 | i0 | 100 | 2.99253731343284 | 401 | 0 | 99 | 0 | 2 | 402 | 8833 | 8433 | Neoseiulus californicus isolate Biodefence Line-02 mitochondrion, complete genome | blastn | 1203 | 741 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Neoseiulus | Neoseiulus californicus | |
| 9907760 | 9907760 | PRJNA999043_P_NODE_16768_length_323_cov_0.924000_g16673_i0 | PRJNA999043 | 16768 | 323 | 0.924 | 2.98452 | Varroa destructor | 109461 | Arthropoda | Arthropoda | 212 | 7.97e-62 | NR | XP_022663764.1 | 109461 | g16673 | i0 | 92.5 | 1.98761609907121 | 107 | 8 | 99.4 | 0 | 322 | 2 | 584 | 690 | XP_022663764.1 translation elongation factor 2-like [Varroa destructor] | diamond | 642 | 212 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Varroidae | Varroa | Varroa destructor | |
| 11182970 | 11182970 | PRJNA999043_P_NODE_18829_length_287_cov_1.079439_g18734_i0 | PRJNA999043 | 18829 | 287 | 1.079439 | 3.09798993 | Neoseiulus californicus | 84382 | Arthropoda | Arthropoda | 531 | 2.799999999999999e-146 | NTclustered | gi|2583621169|gb|OR195436.2| | 84382 | g18734 | i0 | 100 | 3 | 287 | 0 | 100 | 0 | 1 | 287 | 4398 | 4684 | Neoseiulus californicus isolate Biodefence Line-02 mitochondrion, complete genome | blastn | 861 | 531 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Neoseiulus | Neoseiulus californicus | |
| 12459249 | 12459249 | PRJNA999043_P_NODE_5810_length_761_cov_2.324128_g5729_i0 | PRJNA999043 | 5810 | 761 | 2.324128 | 17.68661408 | Neoseiulus californicus | 84382 | Arthropoda | Arthropoda | 1406 | 0 | NTclustered | gi|2424878079|ref|NC_069213.1| | 84382 | g5729 | i0 | 100 | 64.5177398160315 | 761 | 0 | 100 | 0 | 1 | 761 | 9750 | 10510 | Neoseiulus californicus mitochondrion, complete sequence | blastn | 49098 | 1406 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Neoseiulus | Neoseiulus californicus | |
| 12753322 | 12753322 | PRJNA999043_P_NODE_18090_length_299_cov_1.362832_g17995_i0 | PRJNA999043 | 18090 | 299 | 1.362832 | 4.07486768 | Neoseiulus | 84381 | Arthropoda | Arthropoda | 553 | 6.25e-153 | NTclustered | gi|2419915145|gb|OQ190151.1| | 84382 | g17995 | i0 | 100 | 67.7558528428094 | 299 | 0 | 100 | 0 | 1 | 299 | 41 | 339 | Neoseiulus californicus isolate 123x cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial | blastn | 20259 | 553 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Neoseiulus | Neoseiulus californicus | |
| 13733116 | 13733116 | PRJNA999043_P_NODE_18031_length_300_cov_1.017621_g17936_i0 | PRJNA999043 | 18031 | 300 | 1.017621 | 3.052863 | Galendromus occidentalis | 34638 | Arthropoda | Arthropoda | 294 | 4.1999999999999997e-75 | NTclustered | gi|391346772|ref|XM_003747595.1| | 34638 | g17936 | i0 | 84.333 | 1 | 300 | 47 | 100 | 0 | 1 | 300 | 531 | 830 | PREDICTED: Metaseiulus occidentalis 60S ribosomal protein L6 (LOC100905840), mRNA | blastn | 300 | 294 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Galendromus | Galendromus occidentalis | |
| 13733135 | 13733135 | PRJNA999043_P_NODE_18411_length_293_cov_1.581818_g18316_i0 | PRJNA999043 | 18411 | 293 | 1.581818 | 4.63472674 | Neoseiulus californicus | 84382 | Arthropoda | Arthropoda | 534 | 2.21e-147 | NTclustered | gi|2583621169|gb|OR195436.2| | 84382 | g18316 | i0 | 99.659 | 8.11945392491468 | 293 | 0 | 100 | 1 | 1 | 293 | 1210 | 1501 | Neoseiulus californicus isolate Biodefence Line-02 mitochondrion, complete genome | blastn | 2379 | 534 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Neoseiulus | Neoseiulus californicus | |
| 13733260 | 13733260 | PRJNA999043_P_NODE_21151_length_255_cov_1.269231_g21056_i0 | PRJNA999043 | 21151 | 255 | 1.269231 | 3.23653905 | Neoseiulus californicus | 84382 | Arthropoda | Arthropoda | 472 | 1.5e-128 | NTclustered | gi|2583621169|gb|OR195436.2| | 84382 | g21056 | i0 | 100 | 3.90980392156863 | 255 | 0 | 100 | 0 | 1 | 255 | 4147 | 4401 | Neoseiulus californicus isolate Biodefence Line-02 mitochondrion, complete genome | blastn | 997 | 472 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Neoseiulus | Neoseiulus californicus | |
| 15007542 | 15007542 | PRJNA999043_P_NODE_18992_length_284_cov_1.459716_g18897_i0 | PRJNA999043 | 18992 | 284 | 1.459716 | 4.14559344 | Galendromus occidentalis | 34638 | Arthropoda | Arthropoda | 331 | 3.0100000000000002e-86 | NTclustered | gi|1634086026|ref|XM_029112624.1| | 34638 | g18897 | i0 | 87.9 | 77.8767605633803 | 281 | 34 | 99 | 0 | 4 | 284 | 8105 | 7825 | PREDICTED: Metaseiulus occidentalis myosin heavy chain, muscle (LOC100899376), mRNA | blastn | 22117 | 331 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Galendromus | Galendromus occidentalis | |
| 15007645 | 15007645 | PRJNA999043_P_NODE_21452_length_252_cov_1.055866_g21357_i0 | PRJNA999043 | 21452 | 252 | 1.055866 | 2.66078232 | Neoseiulus californicus | 84382 | Arthropoda | Arthropoda | 466 | 6.89e-127 | NTclustered | gi|2424878079|ref|NC_069213.1| | 84382 | g21357 | i0 | 100 | 97.3253968253968 | 252 | 0 | 100 | 0 | 1 | 252 | 458 | 709 | Neoseiulus californicus mitochondrion, complete sequence | blastn | 24526 | 466 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Neoseiulus | Neoseiulus californicus | |
| 16282449 | 16282449 | PRJNA999043_P_NODE_19393_length_278_cov_1.492683_g19298_i0 | PRJNA999043 | 19393 | 278 | 1.492683 | 4.14965874 | Galendromus occidentalis | 34638 | Arthropoda | Arthropoda | 211 | 3.9900000000000002e-50 | NTclustered | gi|1078801824|ref|XM_018638354.1| | 34638 | g19298 | i0 | 81.053 | 5.48561151079137 | 285 | 37 | 100 | 11 | 1 | 278 | 20 | 294 | PREDICTED: Metaseiulus occidentalis ferritin heavy chain, oocyte isoform (LOC100907502), transcript variant X4, mRNA | blastn | 1525 | 211 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Galendromus | Galendromus occidentalis | |
| 18831181 | 18831181 | PRJNA999043_P_NODE_13475_length_402_cov_1.954407_g13380_i0 | PRJNA999043 | 13475 | 402 | 1.954407 | 7.85671614 | Neoseiulus californicus | 84382 | Arthropoda | Arthropoda | 741 | 0 | NTclustered | gi|2583621169|gb|OR195436.2| | 84382 | g13380 | i0 | 100 | 4.06965174129353 | 401 | 0 | 99 | 0 | 2 | 402 | 2030 | 1630 | Neoseiulus californicus isolate Biodefence Line-02 mitochondrion, complete genome | blastn | 1636 | 741 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Neoseiulus | Neoseiulus californicus | |
| 18831218 | 18831218 | PRJNA999043_P_NODE_14355_length_379_cov_1.006536_g14260_i0 | PRJNA999043 | 14355 | 379 | 1.006536 | 3.81477144 | Timema shepardi | 629360 | Arthropoda | Arthropoda | 52.8 | 0.036 | NTclustered | gi|1937826618|emb|OC000300.1| | 629360 | g14260 | i0 | 100 | 0.0738786279683377 | 28 | 0 | 7 | 0 | 206 | 233 | 36796 | 36769 | 2_Tsi_b3v08 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Phasmatodea | Timematidae | Timema | Timema shepardi | |
| 18831573 | 18831573 | PRJNA999043_P_NODE_23575_length_245_cov_0.895349_g23480_i0 | PRJNA999043 | 23575 | 245 | 0.895349 | 2.19360505 | Penaeus monodon | 6687 | Arthropoda | Arthropoda | 54.7 | 0.006 | NTclustered | gi|1935939192|ref|XM_037940161.1| | 6687 | g23480 | i0 | 100 | 0.118367346938776 | 29 | 0 | 12 | 0 | 6 | 34 | 953 | 981 | PREDICTED: Penaeus monodon cell wall protein SED1-like (LOC119591421), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Penaeidae | Penaeus | Penaeus monodon | |
| 21676423 | 21676423 | PRJNA999043_P_NODE_8677_length_575_cov_1.525896_g8585_i0 | PRJNA999043 | 8677 | 575 | 1.525896 | 8.773902 | Aphis | 80764 | Arthropoda | Arthropoda | 1061 | 0 | NTclustered | gi|1752270906|gb|MN102349.1| | 80765 | g8585 | i0 | 100 | 100.878260869565 | 574 | 0 | 99 | 0 | 1 | 574 | 12548 | 11975 | Aphis gossypii mitochondrion, complete genome | blastn | 58005 | 1061 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Aphididae | Aphis | Aphis gossypii | |
| 22657082 | 22657082 | PRJNA999043_P_NODE_5658_length_775_cov_12.927350_g5579_i0 | PRJNA999043 | 5658 | 775 | 12.92735 | 100.1869625 | Neoseiulus californicus | 84382 | Arthropoda | Arthropoda | 1432 | 0 | NTclustered | gi|2583621169|gb|OR195436.2| | 84382 | g5579 | i0 | 100 | 58.3741935483871 | 775 | 0 | 100 | 0 | 1 | 775 | 5351 | 6125 | Neoseiulus californicus isolate Biodefence Line-02 mitochondrion, complete genome | blastn | 45240 | 1432 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Neoseiulus | Neoseiulus californicus | |
| 22951755 | 22951755 | PRJNA999043_P_NODE_22198_length_249_cov_0.875000_g22103_i0 | PRJNA999043 | 22198 | 249 | 0.875 | 2.17875 | Drosophila | 7215 | Arthropoda | Arthropoda | 460 | 3.16e-125 | NTclustered | gi|21064836|gb|AY113643.1| | 7227 | g22103 | i0 | 100 | 57.4578313253012 | 249 | 0 | 100 | 0 | 1 | 249 | 364 | 116 | Drosophila melanogaster RH74176 full insert cDNA | blastn | 14307 | 460 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Drosophilidae | Drosophila | Drosophila melanogaster | |
| 27247774 | 27247774 | PRJNA999043_P_NODE_23963_length_244_cov_0.871345_g23868_i0 | PRJNA999043 | 23963 | 244 | 0.871345 | 2.1260818 | Galendromus occidentalis | 34638 | Arthropoda | Arthropoda | 52.8 | 1.11e-5 | NR | XP_003737251.1 | 34638 | g23868 | i0 | 100 | 0.307377049180328 | 25 | 0 | 30.7 | 0 | 169 | 243 | 1 | 25 | XP_003737251.1 serine/threonine-protein kinase PAK 3 [Galendromus occidentalis] | diamond | 75 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Galendromus | Galendromus occidentalis | |
| 27721969 | 27721969 | PRJNA999043_P_NODE_17784_length_304_cov_1.000000_g17689_i0 | PRJNA999043 | 17784 | 304 | 1 | 3.04 | Galendromus occidentalis | 34638 | Arthropoda | Arthropoda | 155 | 3.05e-42 | NR | XP_003740670.1 | 34638 | g17689 | i0 | 75.2 | 0.996710526315789 | 101 | 25 | 99.7 | 0 | 304 | 2 | 117 | 217 | XP_003740670.1 cholinesterase [Galendromus occidentalis] | diamond | 303 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Galendromus | Galendromus occidentalis | |
| 27942640 | 27942640 | PRJNA999043_P_NODE_24885_length_241_cov_0.916667_g24790_i0 | PRJNA999043 | 24885 | 241 | 0.916667 | 2.20916747 | Galendromus occidentalis | 34638 | Arthropoda | Arthropoda | 43.9 | 0.0149 | NR | XP_028967959.1 | 34638 | g24790 | i0 | 59 | 0.485477178423237 | 39 | 16 | 48.5 | 0 | 8 | 124 | 1861 | 1899 | XP_028967959.1 titin homolog [Galendromus occidentalis] | diamond | 117 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Galendromus | Galendromus occidentalis | |
| 31100624 | 31100624 | PRJNA999043_P_NODE_13515_length_401_cov_2.320122_g13420_i0 | PRJNA999043 | 13515 | 401 | 2.320122 | 9.30368922 | Galendromus occidentalis | 34638 | Arthropoda | Arthropoda | 73.6 | 1.51e-13 | NR | XP_003739867.1 | 34638 | g13420 | i0 | 46.2 | 1.18204488778055 | 158 | 35 | 90.5 | 3 | 376 | 14 | 1 | 145 | XP_003739867.1 cuticle protein 16.5 [Galendromus occidentalis] | diamond | 474 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Galendromus | Galendromus occidentalis | |
| 32055394 | 32055394 | PRJNA999043_P_NODE_22498_length_248_cov_0.880000_g22403_i0 | PRJNA999043 | 22498 | 248 | 0.88 | 2.1824 | Varroa | 62624 | Arthropoda | Arthropoda | 170 | 1.26e-49 | NR | XP_022705918.1 | 62625 | g22403 | i0 | 95.1 | 2.9758064516129 | 82 | 4 | 99.2 | 0 | 247 | 2 | 170 | 251 | XP_022705918.1 synaptic vesicle membrane protein VAT-1 homolog-like isoform X2 [Varroa jacobsoni] | diamond | 738 | 170 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Varroidae | Varroa | Varroa jacobsoni | |
| 32271227 | 32271227 | PRJNA999043_P_NODE_21438_length_252_cov_1.290503_g21343_i0 | PRJNA999043 | 21438 | 252 | 1.290503 | 3.25206756 | Galendromus occidentalis | 34638 | Arthropoda | Arthropoda | 71.2 | 2.98e-12 | NR | XP_028967367.1 | 34638 | g21343 | i0 | 60.8 | 0.94047619047619 | 79 | 24 | 85.7 | 1 | 36 | 251 | 1 | 79 | XP_028967367.1 uncharacterized protein KIAA0754-like [Galendromus occidentalis] | diamond | 237 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Galendromus | Galendromus occidentalis |
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);;