contig_metadata
24 rows where analysis = "diamond", bioproject = "PRJNA637328" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5712825 | 5712825 | PRJNA637328_S_NODE_1405_length_306_cov_1.349442_g1328_i0 | PRJNA637328 | 1405 | 306 | 1.349442 | 4.12929252 | Coccinella septempunctata | 41139 | Arthropoda | Arthropoda | 149 | 9.73e-45 | NR | XP_044767144.1 | 41139 | g1328 | i0 | 78.5 | 0.774509803921569 | 79 | 17 | 77.5 | 0 | 6 | 242 | 1 | 79 | XP_044767144.1 cytochrome c oxidase subunit 6B2-like isoform X2 [Coccinella septempunctata] | diamond | 237 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Coccinellidae | Coccinella | Coccinella septempunctata | |
| 15912084 | 15912084 | PRJNA637328_S_NODE_3013_length_183_cov_1.308219_g2936_i0 | PRJNA637328 | 3013 | 183 | 1.308219 | 2.39404077 | Liposcelis entomophila | 550478 | Arthropoda | Arthropoda | 84 | 4.95e-17 | NR | QWV54006.1 | 550478 | g2936 | i0 | 95.2 | 0.688524590163934 | 42 | 2 | 68.9 | 0 | 128 | 3 | 1067 | 1108 | QWV54006.1 vitellogenin [Liposcelis entomophila] | diamond | 126 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Liposcelididae | Liposcelis | Liposcelis entomophila | |
| 26796225 | 26796225 | PRJNA637328_S_NODE_1361_length_314_cov_2.176895_g1284_i0 | PRJNA637328 | 1361 | 314 | 2.176895 | 6.8354503 | Liposcelis entomophila | 550478 | Arthropoda | Arthropoda | 157 | 6.949999999999998e-42 | NR | QWV54006.1 | 550478 | g1284 | i0 | 77.9 | 0.993630573248408 | 104 | 23 | 99.4 | 0 | 313 | 2 | 496 | 599 | QWV54006.1 vitellogenin [Liposcelis entomophila] | diamond | 312 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Liposcelididae | Liposcelis | Liposcelis entomophila | |
| 26998391 | 26998391 | PRJNA637328_S_NODE_482_length_792_cov_2.733775_g433_i0 | PRJNA637328 | 482 | 792 | 2.733775 | 21.651498 | Insecta | 50557 | Arthropoda | Arthropoda | 203 | 1.22e-56 | NR | XP_002432713.1 | 121224 | g433 | i0 | 47.4 | 2.22727272727273 | 194 | 102 | 73.5 | 0 | 583 | 2 | 232 | 425 | XP_002432713.1 basic juvenile hormone sensitive hemolymph protein two, putative [Pediculus humanus corporis] | diamond | 1764 | 203 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Pediculidae | Pediculus | Pediculus humanus | |
| 27017702 | 27017702 | PRJNA637328_S_NODE_1462_length_299_cov_2.671756_g1385_i0 | PRJNA637328 | 1462 | 299 | 2.671756 | 7.98855044 | Pediculus humanus corporis | 121224 | Arthropoda | Arthropoda | 135 | 2.2e-34 | NR | XP_002430692.1 | 121224 | g1385 | i0 | 58.6 | 0.993311036789298 | 99 | 41 | 99.3 | 0 | 297 | 1 | 235 | 333 | XP_002430692.1 hemocyanin subunit, putative [Pediculus humanus corporis] | diamond | 297 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Pediculidae | Pediculus | Pediculus humanus | |
| 27270602 | 27270602 | PRJNA637328_S_NODE_603_length_628_cov_6.101523_g541_i0 | PRJNA637328 | 603 | 628 | 6.101523 | 38.31756444 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 355 | 1.95e-122 | NR | KAK2724467.1 | 6661 | g541 | i0 | 99.5 | 0.993630573248408 | 208 | 1 | 99.4 | 0 | 628 | 5 | 8 | 215 | KAK2724467.1 hypothetical protein QYM36_001091 [Artemia franciscana] | diamond | 624 | 355 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 27997101 | 27997101 | PRJNA637328_S_NODE_2745_length_193_cov_3.557692_g2668_i0 | PRJNA637328 | 2745 | 193 | 3.557692 | 6.86634556 | Lysiphlebus testaceipes | 77504 | Arthropoda | Arthropoda | 99.4 | 7.480000000000001e-26 | NR | Q56FL2.1 | 77504 | g2668 | i0 | 89.6 | 2.98445595854922 | 48 | 5 | 74.6 | 0 | 191 | 48 | 9 | 56 | Q56FL2.1 RecName: Full=Small ribosomal subunit protein uS14; AltName: Full=40S ribosomal protein S29 [Lysiphlebus testaceipes] | diamond | 576 | 99.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Braconidae | Lysiphlebus | Lysiphlebus testaceipes | |
| 28249399 | 28249399 | PRJNA637328_S_NODE_4226_length_151_cov_2.807018_g4149_i0 | PRJNA637328 | 4226 | 151 | 2.807018 | 4.23859718 | Liposcelis entomophila | 550478 | Arthropoda | Arthropoda | 89 | 5.28e-19 | NR | QWV54006.1 | 550478 | g4149 | i0 | 91.3 | 0.913907284768212 | 46 | 4 | 91.4 | 0 | 12 | 149 | 1 | 46 | QWV54006.1 vitellogenin [Liposcelis entomophila] | diamond | 138 | 89 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Liposcelididae | Liposcelis | Liposcelis entomophila | |
| 28280948 | 28280948 | PRJNA637328_P_NODE_17906_length_246_cov_1.324873_g17429_i0 | PRJNA637328 | 17906 | 246 | 1.324873 | 3.25918758 | Laodelphax striatellus | 195883 | Arthropoda | Arthropoda | 110 | 2.96e-28 | NR | RZF33676.1 | 195883 | g17429 | i0 | 66.7 | 7.64634146341463 | 78 | 26 | 95.1 | 0 | 11 | 244 | 89 | 166 | RZF33676.1 hypothetical protein LSTR_LSTR007054 [Laodelphax striatellus] | diamond | 1881 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Delphacidae | Laodelphax | Laodelphax striatellus | |
| 28375792 | 28375792 | PRJNA637328_S_NODE_3826_length_159_cov_1.909836_g3749_i0 | PRJNA637328 | 3826 | 159 | 1.909836 | 3.03663924 | Liposcelis entomophila | 550478 | Arthropoda | Arthropoda | 87 | 2.87e-18 | NR | QWV54006.1 | 550478 | g3749 | i0 | 84.3 | 0.962264150943396 | 51 | 8 | 96.2 | 0 | 5 | 157 | 50 | 100 | QWV54006.1 vitellogenin [Liposcelis entomophila] | diamond | 153 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Liposcelididae | Liposcelis | Liposcelis entomophila | |
| 28502215 | 28502215 | PRJNA637328_S_NODE_2847_length_189_cov_2.625000_g2770_i0 | PRJNA637328 | 2847 | 189 | 2.625 | 4.96125 | Pediculus humanus corporis | 121224 | Arthropoda | Arthropoda | 82.8 | 1.36e-16 | NR | XP_002430692.1 | 121224 | g2770 | i0 | 61 | 0.936507936507937 | 59 | 23 | 93.7 | 0 | 179 | 3 | 333 | 391 | XP_002430692.1 hemocyanin subunit, putative [Pediculus humanus corporis] | diamond | 177 | 82.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Pediculidae | Pediculus | Pediculus humanus | |
| 29039156 | 29039156 | PRJNA637328_S_NODE_3548_length_166_cov_1.286822_g3471_i0 | PRJNA637328 | 3548 | 166 | 1.286822 | 2.13612452 | Liposcelis entomophila | 550478 | Arthropoda | Arthropoda | 84.3 | 2.91e-17 | NR | QWV54006.1 | 550478 | g3471 | i0 | 70.9 | 0.993975903614458 | 55 | 16 | 99.4 | 0 | 166 | 2 | 1495 | 1549 | QWV54006.1 vitellogenin [Liposcelis entomophila] | diamond | 165 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Liposcelididae | Liposcelis | Liposcelis entomophila | |
| 29165458 | 29165458 | PRJNA637328_S_NODE_2969_length_184_cov_2.904762_g2892_i0 | PRJNA637328 | 2969 | 184 | 2.904762 | 5.34476208 | Pediculus humanus corporis | 121224 | Arthropoda | Arthropoda | 99.8 | 1.45e-22 | NR | XP_002430692.1 | 121224 | g2892 | i0 | 75.4 | 0.994565217391304 | 61 | 15 | 99.5 | 0 | 183 | 1 | 461 | 521 | XP_002430692.1 hemocyanin subunit, putative [Pediculus humanus corporis] | diamond | 183 | 99.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Pediculidae | Pediculus | Pediculus humanus | |
| 29322980 | 29322980 | PRJNA637328_S_NODE_4289_length_150_cov_1.380531_g4212_i0 | PRJNA637328 | 4289 | 150 | 1.380531 | 2.0707965 | Artemia franciscana | 6661 | Arthropoda | Arthropoda | 69.3 | 1.92e-13 | NR | XP_065560387.1 | 6661 | g4212 | i0 | 68.8 | 0.96 | 48 | 15 | 96 | 0 | 3 | 146 | 30 | 77 | XP_065560387.1 endocuticle structural glycoprotein SgAbd-1-like [Artemia franciscana] | diamond | 144 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Branchiopoda | Anostraca | Artemiidae | Artemia | Artemia franciscana | |
| 30080812 | 30080812 | PRJNA637328_S_NODE_4012_length_155_cov_2.118644_g3935_i0 | PRJNA637328 | 4012 | 155 | 2.118644 | 3.2838982 | Liposcelis entomophila | 550478 | Arthropoda | Arthropoda | 94.4 | 7.37e-21 | NR | QWV54006.1 | 550478 | g3935 | i0 | 89.6 | 0.929032258064516 | 48 | 5 | 92.9 | 0 | 8 | 151 | 1191 | 1238 | QWV54006.1 vitellogenin [Liposcelis entomophila] | diamond | 144 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Liposcelididae | Liposcelis | Liposcelis entomophila | |
| 30207102 | 30207102 | PRJNA637328_S_NODE_3572_length_165_cov_2.507812_g3495_i0 | PRJNA637328 | 3572 | 165 | 2.507812 | 4.1378898 | Liposcelis entomophila | 550478 | Arthropoda | Arthropoda | 106 | 5.66e-25 | NR | QWV54006.1 | 550478 | g3495 | i0 | 98.1 | 0.981818181818182 | 54 | 1 | 98.2 | 0 | 162 | 1 | 738 | 791 | QWV54006.1 vitellogenin [Liposcelis entomophila] | diamond | 162 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Liposcelididae | Liposcelis | Liposcelis entomophila | |
| 30523282 | 30523282 | PRJNA637328_S_NODE_793_length_468_cov_1.870070_g717_i0 | PRJNA637328 | 793 | 468 | 1.87007 | 8.7519276 | Pediculus humanus corporis | 121224 | Arthropoda | Arthropoda | 138 | 1.5199999999999996e-34 | NR | XP_002432713.1 | 121224 | g717 | i0 | 49.2 | 0.769230769230769 | 120 | 57 | 74.4 | 1 | 458 | 111 | 587 | 706 | XP_002432713.1 basic juvenile hormone sensitive hemolymph protein two, putative [Pediculus humanus corporis] | diamond | 360 | 138 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Pediculidae | Pediculus | Pediculus humanus | |
| 30618021 | 30618021 | PRJNA637328_S_NODE_2853_length_189_cov_1.493421_g2776_i0 | PRJNA637328 | 2853 | 189 | 1.493421 | 2.82256569 | Pediculus humanus corporis | 121224 | Arthropoda | Arthropoda | 86.3 | 8.24e-18 | NR | XP_002430692.1 | 121224 | g2776 | i0 | 72.9 | 0.761904761904762 | 48 | 13 | 76.2 | 0 | 3 | 146 | 388 | 435 | XP_002430692.1 hemocyanin subunit, putative [Pediculus humanus corporis] | diamond | 144 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Pediculidae | Pediculus | Pediculus humanus | |
| 31029088 | 31029088 | PRJNA637328_S_NODE_3155_length_178_cov_2.290780_g3078_i0 | PRJNA637328 | 3155 | 178 | 2.29078 | 4.0775884 | Pediculus humanus corporis | 121224 | Arthropoda | Arthropoda | 66.2 | 8.06e-11 | NR | XP_002430692.1 | 121224 | g3078 | i0 | 59.3 | 0.99438202247191 | 59 | 22 | 99.4 | 2 | 178 | 2 | 184 | 240 | XP_002430692.1 hemocyanin subunit, putative [Pediculus humanus corporis] | diamond | 177 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Pediculidae | Pediculus | Pediculus humanus | |
| 31376727 | 31376727 | PRJNA637328_S_NODE_1416_length_305_cov_3.757463_g1339_i0 | PRJNA637328 | 1416 | 305 | 3.757463 | 11.46026215 | Perla marginata | 227363 | Arthropoda | Arthropoda | 98.6 | 1.82e-21 | NR | CAM84199.1 | 227363 | g1339 | i0 | 51.7 | 0.855737704918033 | 87 | 40 | 83.6 | 1 | 304 | 50 | 507 | 593 | CAM84199.1 hexamerin 4, partial [Perla marginata] | diamond | 261 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Plecoptera | Perlidae | Perla | Perla marginata | |
| 31471666 | 31471666 | PRJNA637328_S_NODE_756_length_490_cov_3.783664_g681_i0 | PRJNA637328 | 756 | 490 | 3.783664 | 18.5399536 | Ceuthophilus sp. XZ-2 | 3073481 | Arthropoda | Arthropoda | 182 | 7.81e-53 | NR | AUO15581.1 | 2057961 | g681 | i0 | 50.9 | 6.06122448979592 | 165 | 79 | 99.8 | 1 | 489 | 1 | 128 | 292 | AUO15581.1 hexamerin-like protein 3, partial [Ceuthophilus sp. XZ-2017] | diamond | 2970 | 182 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Orthoptera | Rhaphidophoridae | Ceuthophilus | Ceuthophilus sp. XZ-2017 | |
| 31945776 | 31945776 | PRJNA637328_P_NODE_8157_length_321_cov_1.687500_g7682_i0 | PRJNA637328 | 8157 | 321 | 1.6875 | 5.416875 | Penaeus vannamei | 6689 | Arthropoda | Arthropoda | 80.9 | 3.85e-15 | NR | ROT62018.1 | 6689 | g7682 | i0 | 43.8 | 5.23364485981308 | 112 | 46 | 88.8 | 2 | 318 | 34 | 452 | 563 | ROT62018.1 heat shock protein 70 kDa [Penaeus vannamei] | diamond | 1680 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Penaeidae | Penaeus | Penaeus vannamei | |
| 32167653 | 32167653 | PRJNA637328_S_NODE_1838_length_252_cov_1.706977_g1761_i0 | PRJNA637328 | 1838 | 252 | 1.706977 | 4.30158204 | Liposcelis entomophila | 550478 | Arthropoda | Arthropoda | 118 | 1.23e-28 | NR | QWV54006.1 | 550478 | g1761 | i0 | 78.6 | 0.833333333333333 | 70 | 15 | 83.3 | 0 | 212 | 3 | 1659 | 1728 | QWV54006.1 vitellogenin [Liposcelis entomophila] | diamond | 210 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Liposcelididae | Liposcelis | Liposcelis entomophila | |
| 32433272 | 32433272 | PRJNA637328_P_NODE_6259_length_353_cov_1.483553_g5784_i0 | PRJNA637328 | 6259 | 353 | 1.483553 | 5.23694209 | Ixodes | 6944 | Arthropoda | Arthropoda | 45.8 | 0.00973 | NR | EEC00197.1 | 6945 | g5784 | i0 | 52.6 | 0.645892351274788 | 38 | 16 | 31.4 | 2 | 222 | 332 | 314 | 350 | EEC00197.1 zinc finger protein, putative [Ixodes scapularis] | diamond | 228 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Ixodida | Ixodidae | Ixodes | Ixodes scapularis |
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);;