contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA605033" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26668274 | 26668274 | PRJNA605033_P_NODE_153641_length_191_cov_2.192308_g152072_i0 | PRJNA605033 | 153641 | 191 | 2.192308 | 4.18730828 | Leptotrombidium deliense | 299467 | Arthropoda | Arthropoda | 62.8 | 1.6e-9 | NR | RWS25201.1 | 299467 | g152072 | i0 | 50 | 3.89528795811518 | 62 | 31 | 97.4 | 0 | 191 | 6 | 526 | 587 | RWS25201.1 pol polyprotein-like protein, partial [Leptotrombidium deliense] | diamond | 744 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Trombiculidae | Leptotrombidium | Leptotrombidium deliense | |
| 26700037 | 26700037 | PRJNA605033_P_NODE_85181_length_222_cov_2.320856_g83612_i0 | PRJNA605033 | 85181 | 222 | 2.320856 | 5.15230032 | Rhagoletis zephyria | 28612 | Arthropoda | Arthropoda | 47.4 | 6.59e-4 | NR | XP_017483872.1 | 28612 | g83612 | i0 | 76 | 0.337837837837838 | 25 | 6 | 33.8 | 0 | 222 | 148 | 188 | 212 | XP_017483872.1 PREDICTED: DEP domain-containing protein 5-like [Rhagoletis zephyria] | diamond | 75 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Tephritidae | Rhagoletis | Rhagoletis zephyria | |
| 26935012 | 26935012 | PRJNA605033_P_NODE_213082_length_161_cov_1.269841_g211513_i0 | PRJNA605033 | 213082 | 161 | 1.269841 | 2.04444401 | Trombidiformes | 83136 | Arthropoda | Arthropoda | 70.9 | 1.3e-12 | NR | RWS23121.1 | 299467 | g211513 | i0 | 91.7 | 2.01242236024845 | 36 | 3 | 67.1 | 0 | 160 | 53 | 306 | 341 | RWS23121.1 putative G-protein coupled receptor-like protein, partial [Leptotrombidium deliense] | diamond | 324 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Trombiculidae | Leptotrombidium | Leptotrombidium deliense | |
| 27016743 | 27016743 | PRJNA605033_P_NODE_73182_length_222_cov_2.871658_g71613_i0 | PRJNA605033 | 73182 | 222 | 2.871658 | 6.37508076 | Laodelphax striatellus | 195883 | Arthropoda | Arthropoda | 50.8 | 3.94e-5 | NR | RZF34290.1 | 195883 | g71613 | i0 | 92 | 0.337837837837838 | 25 | 2 | 33.8 | 0 | 2 | 76 | 451 | 475 | RZF34290.1 hypothetical protein LSTR_LSTR013447 [Laodelphax striatellus] | diamond | 75 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Delphacidae | Laodelphax | Laodelphax striatellus | |
| 27806794 | 27806794 | PRJNA605033_P_NODE_191884_length_169_cov_2.261194_g190315_i0 | PRJNA605033 | 191884 | 169 | 2.261194 | 3.82141786 | Panonychus citri | 50023 | Arthropoda | Arthropoda | 60.1 | 1.06e-8 | NR | XP_053200464.1 | 50023 | g190315 | i0 | 55.9 | 2.09467455621302 | 59 | 22 | 97.6 | 2 | 169 | 5 | 733 | 791 | XP_053200464.1 Ig-like and fibronectin type-III domain-containing protein 1 [Panonychus citri] | diamond | 354 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Tetranychidae | Panonychus | Panonychus citri | |
| 27946103 | 27946103 | PRJNA605033_P_NODE_109665_length_222_cov_1.802139_g108096_i0 | PRJNA605033 | 109665 | 222 | 1.802139 | 4.00074858 | Arachnida | 6854 | Arthropoda | Arthropoda | 51.2 | 1.35e-5 | NR | CAL6252857.1 | 34615 | g108096 | i0 | 100 | 3.24324324324324 | 24 | 0 | 32.4 | 0 | 149 | 220 | 118 | 141 | CAL6252857.1 unnamed protein product [Ixodes persulcatus] | diamond | 720 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Ixodida | Ixodidae | Ixodes | Ixodes persulcatus | |
| 28027671 | 28027671 | PRJNA605033_P_NODE_103325_length_222_cov_1.898396_g101756_i0 | PRJNA605033 | 103325 | 222 | 1.898396 | 4.21443912 | Blattella germanica | 6973 | Arthropoda | Arthropoda | 50.8 | 4.01e-5 | NR | PSN44020.1 | 6973 | g101756 | i0 | 96 | 0.337837837837838 | 25 | 1 | 33.8 | 0 | 222 | 148 | 59 | 83 | PSN44020.1 hypothetical protein C0J52_16980, partial [Blattella germanica] | diamond | 75 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Blattodea | Blattellidae | Blattella | Blattella germanica | |
| 28880024 | 28880024 | PRJNA605033_P_NODE_83688_length_222_cov_2.368984_g82119_i0 | PRJNA605033 | 83688 | 222 | 2.368984 | 5.25914448 | Orchesella dallaii | 48710 | Arthropoda | Arthropoda | 67 | 8.28e-11 | NR | CAL8085103.1 | 48710 | g82119 | i0 | 41.9 | 4 | 74 | 26 | 100 | 1 | 222 | 1 | 1062 | 1118 | CAL8085103.1 unnamed protein product [Orchesella dallaii] | diamond | 888 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Collembola | Entomobryomorpha | Orchesellidae | Orchesella | Orchesella dallaii | |
| 29069695 | 29069695 | PRJNA605033_P_NODE_160888_length_186_cov_1.490066_g159319_i0 | PRJNA605033 | 160888 | 186 | 1.490066 | 2.77152276 | Cordylochernes scorpioides | 51811 | Arthropoda | Arthropoda | 77.8 | 7.79e-15 | NR | UYV75983.1 | 51811 | g159319 | i0 | 75 | 0.709677419354839 | 44 | 11 | 71 | 0 | 186 | 55 | 137 | 180 | UYV75983.1 RASA1 [Cordylochernes scorpioides] | diamond | 132 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Pseudoscorpiones | Chernetidae | Cordylochernes | Cordylochernes scorpioides | |
| 29258760 | 29258760 | PRJNA605033_P_NODE_74309_length_222_cov_2.791444_g72740_i0 | PRJNA605033 | 74309 | 222 | 2.791444 | 6.19700568 | Blattella germanica | 6973 | Arthropoda | Arthropoda | 77 | 2.29e-14 | NR | PSN51582.1 | 6973 | g72740 | i0 | 52.2 | 1.24324324324324 | 92 | 25 | 98.6 | 1 | 221 | 3 | 83 | 174 | PSN51582.1 putative RNA-directed DNA polymerase from transposon X-element [Blattella germanica] | diamond | 276 | 77 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Blattodea | Blattellidae | Blattella | Blattella germanica | |
| 29290525 | 29290525 | PRJNA605033_P_NODE_234529_length_154_cov_1.084034_g232960_i0 | PRJNA605033 | 234529 | 154 | 1.084034 | 1.66941236 | Argiope bruennichi | 94029 | Arthropoda | Arthropoda | 47 | 7.33e-5 | NR | XP_055929869.1 | 94029 | g232960 | i0 | 56.4 | 1.36363636363636 | 39 | 16 | 76 | 1 | 6 | 122 | 40 | 77 | XP_055929869.1 LYR motif-containing protein 9-like [Argiope bruennichi] | diamond | 210 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Araneidae | Argiope | Argiope bruennichi | |
| 29322058 | 29322058 | PRJNA605033_P_NODE_172009_length_179_cov_1.805556_g170440_i0 | PRJNA605033 | 172009 | 179 | 1.805556 | 3.23194524 | Demodex folliculorum | 481310 | Arthropoda | Arthropoda | 86.3 | 5.66e-18 | NR | YP_009114842.1 | 481310 | g170440 | i0 | 97.8 | 0.754189944134078 | 45 | 1 | 75.4 | 0 | 43 | 177 | 339 | 383 | YP_009114842.1 NADH dehydrogenase subunit 4 [Demodex folliculorum] | diamond | 135 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Demodicidae | Demodex | Demodex folliculorum | |
| 29353844 | 29353844 | PRJNA605033_P_NODE_113349_length_222_cov_1.737968_g111780_i0 | PRJNA605033 | 113349 | 222 | 1.737968 | 3.85828896 | Panonychus citri | 50023 | Arthropoda | Arthropoda | 44.7 | 0.00624 | NR | XP_053207182.1 | 50023 | g111780 | i0 | 72 | 0.337837837837838 | 25 | 7 | 33.8 | 0 | 148 | 222 | 572 | 596 | XP_053207182.1 DNA polymerase alpha catalytic subunit-like [Panonychus citri] | diamond | 75 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Tetranychidae | Panonychus | Panonychus citri | |
| 29353886 | 29353886 | PRJNA605033_P_NODE_89369_length_222_cov_2.203209_g87800_i0 | PRJNA605033 | 89369 | 222 | 2.203209 | 4.89112398 | Panonychus citri | 50023 | Arthropoda | Arthropoda | 44.7 | 0.00568 | NR | XP_053203818.1 | 50023 | g87800 | i0 | 78.3 | 0.310810810810811 | 23 | 5 | 31.1 | 0 | 73 | 5 | 79 | 101 | XP_053203818.1 tRNA-splicing endonuclease subunit Sen2-like [Panonychus citri] | diamond | 69 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Tetranychidae | Panonychus | Panonychus citri | |
| 29795580 | 29795580 | PRJNA605033_P_NODE_101791_length_222_cov_1.925134_g100222_i0 | PRJNA605033 | 101791 | 222 | 1.925134 | 4.27379748 | Blattella germanica | 6973 | Arthropoda | Arthropoda | 40.8 | 0.0205 | NR | PSN55654.1 | 6973 | g100222 | i0 | 82.6 | 0.310810810810811 | 23 | 4 | 31.1 | 0 | 152 | 220 | 20 | 42 | PSN55654.1 hypothetical protein C0J52_21825, partial [Blattella germanica] | diamond | 69 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Blattodea | Blattellidae | Blattella | Blattella germanica | |
| 29985278 | 29985278 | PRJNA605033_P_NODE_109431_length_222_cov_1.802139_g107862_i0 | PRJNA605033 | 109431 | 222 | 1.802139 | 4.00074858 | Blattella germanica | 6973 | Arthropoda | Arthropoda | 48.9 | 1.96e-4 | NR | PSN35177.1 | 6973 | g107862 | i0 | 45.2 | 0.986486486486487 | 73 | 19 | 97.3 | 2 | 222 | 7 | 249 | 301 | PSN35177.1 hypothetical protein C0J52_22409 [Blattella germanica] | diamond | 219 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Blattodea | Blattellidae | Blattella | Blattella germanica | |
| 30648549 | 30648549 | PRJNA605033_P_NODE_70953_length_222_cov_3.037433_g69384_i0 | PRJNA605033 | 70953 | 222 | 3.037433 | 6.74310126 | Tetranychus urticae | 32264 | Arthropoda | Arthropoda | 49.3 | 1.46e-4 | NR | XP_015792649.2 | 32264 | g69384 | i0 | 42.9 | 1.94594594594595 | 70 | 16 | 94.6 | 1 | 210 | 1 | 680 | 725 | XP_015792649.2 LOW QUALITY PROTEIN: activating signal cointegrator 1 complex subunit 3-like, partial [Tetranychus urticae] | diamond | 432 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Tetranychidae | Tetranychus | Tetranychus urticae | |
| 30933233 | 30933233 | PRJNA605033_P_NODE_84134_length_222_cov_2.358289_g82565_i0 | PRJNA605033 | 84134 | 222 | 2.358289 | 5.2354015800000004 | Culex quinquefasciatus | 7176 | Arthropoda | Arthropoda | 55.1 | 1.29e-6 | NR | XP_038119209.1 | 7176 | g82565 | i0 | 45.9 | 1 | 74 | 16 | 100 | 1 | 222 | 1 | 460 | 509 | XP_038119209.1 facilitated trehalose transporter Tret1 [Culex quinquefasciatus] | diamond | 222 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Culex | Culex quinquefasciatus | |
| 30996364 | 30996364 | PRJNA605033_P_NODE_174414_length_178_cov_1.195804_g172845_i0 | PRJNA605033 | 174414 | 178 | 1.195804 | 2.12853112 | Nesidiocoris tenuis | 355587 | Arthropoda | Arthropoda | 39.3 | 0.0488 | NR | CAA9995168.1 | 355587 | g172845 | i0 | 64.3 | 0.471910112359551 | 28 | 7 | 42.1 | 1 | 56 | 130 | 39 | 66 | CAA9995168.1 unnamed protein product, partial [Nesidiocoris tenuis] | diamond | 84 | 39.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Miridae | Nesidiocoris | Nesidiocoris tenuis | |
| 31628633 | 31628633 | PRJNA605033_P_NODE_120436_length_222_cov_1.481283_g118867_i0 | PRJNA605033 | 120436 | 222 | 1.481283 | 3.28844826 | Belonocnema kinseyi | 2817044 | Arthropoda | Arthropoda | 44.7 | 0.00571 | NR | XP_033229276.1 | 2817044 | g118867 | i0 | 87 | 0.932432432432432 | 23 | 3 | 31.1 | 0 | 70 | 2 | 314 | 336 | XP_033229276.1 uncharacterized protein F54H12.2-like [Belonocnema kinseyi] | diamond | 207 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Cynipidae | Belonocnema | Belonocnema kinseyi | |
| 31628655 | 31628655 | PRJNA605033_P_NODE_183536_length_173_cov_1.992754_g181967_i0 | PRJNA605033 | 183536 | 173 | 1.992754 | 3.44746442 | Blattella germanica | 6973 | Arthropoda | Arthropoda | 53.5 | 8.76e-7 | NR | PSN29874.1 | 6973 | g181967 | i0 | 86.2 | 0.502890173410405 | 29 | 4 | 50.3 | 0 | 86 | 172 | 112 | 140 | PSN29874.1 hypothetical protein C0J52_28415, partial [Blattella germanica] | diamond | 87 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Blattodea | Blattellidae | Blattella | Blattella germanica | |
| 31641730 | 31641730 | PRJNA605033_P_NODE_102296_length_222_cov_1.914439_g100727_i0 | PRJNA605033 | 102296 | 222 | 1.914439 | 4.25005458 | Trombidiformes | 83136 | Arthropoda | Arthropoda | 45.1 | 0.00211 | NR | RWS23913.1 | 299467 | g100727 | i0 | 91.7 | 0.648648648648649 | 24 | 2 | 32.4 | 0 | 150 | 221 | 23 | 46 | RWS23913.1 ras-related and estrogen-regulated growth inhibitor-like protein [Leptotrombidium deliense] | diamond | 144 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Trombiculidae | Leptotrombidium | Leptotrombidium deliense | |
| 31863096 | 31863096 | PRJNA605033_P_NODE_105217_length_222_cov_1.866310_g103648_i0 | PRJNA605033 | 105217 | 222 | 1.86631 | 4.1432082 | Formicidae | 36668 | Arthropoda | Arthropoda | 50.1 | 3.24e-5 | NR | KYN50305.1 | 456900 | g103648 | i0 | 44.6 | 3.02702702702703 | 74 | 38 | 100 | 1 | 1 | 222 | 55 | 125 | KYN50305.1 hypothetical protein ALC62_10890 [Cyphomyrmex costatus] | diamond | 672 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Formicidae | Cyphomyrmex | Cyphomyrmex costatus | |
| 31989761 | 31989761 | PRJNA605033_P_NODE_166338_length_182_cov_2.673469_g164769_i0 | PRJNA605033 | 166338 | 182 | 2.673469 | 4.86571358 | Tetranychidae | 32262 | Arthropoda | Arthropoda | 68.9 | 9.45e-12 | NR | XP_015793294.1 | 32264 | g164769 | i0 | 63.3 | 1.61538461538462 | 49 | 18 | 80.8 | 0 | 149 | 3 | 195 | 243 | XP_015793294.1 sodium/potassium/calcium exchanger 4 isoform X2 [Tetranychus urticae] | diamond | 294 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Tetranychidae | Tetranychus | Tetranychus urticae | |
| 32021517 | 32021517 | PRJNA605033_P_NODE_107178_length_222_cov_1.834225_g105609_i0 | PRJNA605033 | 107178 | 222 | 1.834225 | 4.0719795 | Arthropoda | 6656 | Arthropoda | Arthropoda | 57 | 2.66e-7 | NR | ROT70832.1 | 6689 | g105609 | i0 | 42.4 | 5.93243243243243 | 92 | 34 | 98.6 | 1 | 2 | 220 | 963 | 1054 | ROT70832.1 hypothetical protein C7M84_010851 [Penaeus vannamei] | diamond | 1317 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Penaeidae | Penaeus | Penaeus vannamei | |
| 32609289 | 32609289 | PRJNA605033_P_NODE_240860_length_152_cov_1.367521_g239291_i0 | PRJNA605033 | 240860 | 152 | 1.367521 | 2.07863192 | Leptotrombidium deliense | 299467 | Arthropoda | Arthropoda | 65.9 | 7.42e-11 | NR | RWS26851.1 | 299467 | g239291 | i0 | 58 | 3.94736842105263 | 50 | 20 | 98.7 | 1 | 3 | 152 | 37 | 85 | RWS26851.1 hypothetical protein B4U80_10087 [Leptotrombidium deliense] | diamond | 600 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Trombiculidae | Leptotrombidium | Leptotrombidium deliense |
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);;