contig_metadata
40 rows where analysis = "diamond", bioproject = "PRJNA851399" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19085424 | 19085424 | PRJNA851399_P_NODE_19875_length_178_cov_1.348837_g19422_i0 | PRJNA851399 | 19875 | 178 | 1.348837 | 2.40092986 | Periplaneta americana | 6978 | Arthropoda | Arthropoda | 105 | 8.56e-25 | NR | KAJ4427128.1 | 6978 | g19422 | i0 | 76.3 | 222.640449438202 | 59 | 14 | 99.4 | 0 | 177 | 1 | 252 | 310 | KAJ4427128.1 hypothetical protein ANN_24744 [Periplaneta americana] | diamond | 39630 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Blattodea | Blattidae | Periplaneta | Periplaneta americana | |
| 23791546 | 23791546 | PRJNA851399_P_NODE_25219_length_167_cov_1.211864_g24766_i0 | PRJNA851399 | 25219 | 167 | 1.211864 | 2.02381288 | Trichonephila clavipes | 2585209 | Arthropoda | Arthropoda | 72.4 | 5.4e-15 | NR | GFV92182.1 | 2585209 | g24766 | i0 | 62.3 | 1.90419161676647 | 53 | 20 | 95.2 | 0 | 160 | 2 | 9 | 61 | GFV92182.1 histone-lysine N-methyltransferase SETMAR [Trichonephila clavipes] | diamond | 318 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Nephilidae | Trichonephila | Trichonephila clavipes | |
| 27055082 | 27055082 | PRJNA851399_P_NODE_37262_length_162_cov_0.902655_g36809_i0 | PRJNA851399 | 37262 | 162 | 0.902655 | 1.4623011 | Araneus ventricosus | 182803 | Arthropoda | Arthropoda | 50.8 | 1.7e-5 | NR | GBM06898.1 | 182803 | g36809 | i0 | 50 | 0.888888888888889 | 48 | 23 | 87 | 1 | 151 | 11 | 959 | 1006 | GBM06898.1 hypothetical protein AVEN_147838-1 [Araneus ventricosus] | diamond | 144 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Araneidae | Araneus | Araneus ventricosus | |
| 27086674 | 27086674 | PRJNA851399_P_NODE_39322_length_161_cov_1.821429_g38869_i0 | PRJNA851399 | 39322 | 161 | 1.821429 | 2.93250069 | Blattella germanica | 6973 | Arthropoda | Arthropoda | 54.3 | 1.01e-6 | NR | PSN39976.1 | 6973 | g38869 | i0 | 45.3 | 6.83850931677019 | 53 | 29 | 98.8 | 0 | 3 | 161 | 449 | 501 | PSN39976.1 hypothetical protein C0J52_20373 [Blattella germanica] | diamond | 1101 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Blattodea | Blattellidae | Blattella | Blattella germanica | |
| 27149374 | 27149374 | PRJNA851399_P_NODE_12642_length_214_cov_1.496970_g12189_i0 | PRJNA851399 | 12642 | 214 | 1.49697 | 3.2035158 | Cryptotermes secundus | 105785 | Arthropoda | Arthropoda | 94.7 | 9.14e-21 | NR | PNF23216.1 | 105785 | g12189 | i0 | 70 | 2.46728971962617 | 60 | 18 | 84.1 | 0 | 180 | 1 | 119 | 178 | PNF23216.1 hypothetical protein B7P43_G02735 [Cryptotermes secundus] | diamond | 528 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Blattodea | Kalotermitidae | Cryptotermes | Cryptotermes secundus | |
| 27220992 | 27220992 | PRJNA851399_P_NODE_16022_length_189_cov_1.357143_g15569_i0 | PRJNA851399 | 16022 | 189 | 1.357143 | 2.56500027 | Arthropoda | 6656 | Arthropoda | Arthropoda | 57.8 | 5.97e-8 | NR | XP_023213908.1 | 218467 | g15569 | i0 | 45.2 | 30.5079365079365 | 62 | 34 | 98.4 | 0 | 188 | 3 | 171 | 232 | XP_023213908.1 uncharacterized protein LOC111616768, partial [Centruroides sculpturatus] | diamond | 5766 | 58.2 | 0.993127147766323 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Scorpiones | Buthidae | Centruroides | Centruroides sculpturatus | |
| 27244603 | 27244603 | PRJNA851399_P_NODE_35143_length_163_cov_0.894737_g34690_i0 | PRJNA851399 | 35143 | 163 | 0.894737 | 1.45842131 | Aphis craccivora | 307492 | Arthropoda | Arthropoda | 66.2 | 6.24e-11 | NR | KAF0718269.1 | 307492 | g34690 | i0 | 52.8 | 1.85889570552147 | 53 | 25 | 97.5 | 0 | 161 | 3 | 862 | 914 | KAF0718269.1 AP2/ERF domain-containing protein PFD0985w-like, partial [Aphis craccivora] | diamond | 303 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Aphididae | Aphis | Aphis craccivora | |
| 27252781 | 27252781 | PRJNA851399_P_NODE_30623_length_165_cov_0.879310_g30170_i0 | PRJNA851399 | 30623 | 165 | 0.87931 | 1.4508615 | Oppiidae | 229795 | Arthropoda | Arthropoda | 90.1 | 3.56e-20 | NR | CAD7656660.1 | 334625 | g30170 | i0 | 74.1 | 1.96363636363636 | 54 | 14 | 98.2 | 0 | 3 | 164 | 114 | 167 | CAD7656660.1 unnamed protein product [Oppiella nova] | diamond | 324 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Oppiidae | Oppiella | Oppiella nova | |
| 27402744 | 27402744 | PRJNA851399_P_NODE_39943_length_161_cov_0.910714_g39490_i0 | PRJNA851399 | 39943 | 161 | 0.910714 | 1.46624954 | Anoplophora glabripennis | 217634 | Arthropoda | Arthropoda | 70.9 | 1.39e-12 | NR | XP_018574832.1 | 217634 | g39490 | i0 | 65.3 | 4.67701863354037 | 49 | 16 | 91.3 | 1 | 152 | 6 | 260 | 307 | XP_018574832.1 uncharacterized protein LOC108913716 [Anoplophora glabripennis] | diamond | 753 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Cerambycidae | Anoplophora | Anoplophora glabripennis | |
| 27907558 | 27907558 | PRJNA851399_P_NODE_15925_length_189_cov_1.457143_g15472_i0 | PRJNA851399 | 15925 | 189 | 1.457143 | 2.75400027 | Photinus pyralis | 7054 | Arthropoda | Arthropoda | 77.8 | 7.64e-15 | NR | KAB0790202.1 | 7054 | g15472 | i0 | 56.1 | 0.904761904761905 | 57 | 25 | 90.5 | 0 | 17 | 187 | 1 | 57 | KAB0790202.1 hypothetical protein PPYR_15461 [Photinus pyralis] | diamond | 171 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Lampyridae | Photinus | Photinus pyralis | |
| 27979190 | 27979190 | PRJNA851399_P_NODE_35185_length_163_cov_0.894737_g34732_i0 | PRJNA851399 | 35185 | 163 | 0.894737 | 1.45842131 | Aphididae | 27482 | Arthropoda | Arthropoda | 45.1 | 0.00187 | NR | CAI6344434.1 | 13131 | g34732 | i0 | 63 | 2.46625766871166 | 27 | 10 | 49.7 | 0 | 86 | 6 | 412 | 438 | CAI6344434.1 unnamed protein product [Macrosiphum euphorbiae] | diamond | 402 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Aphididae | Macrosiphum | Macrosiphum euphorbiae | |
| 28191743 | 28191743 | PRJNA851399_P_NODE_39646_length_161_cov_1.142857_g39193_i0 | PRJNA851399 | 39646 | 161 | 1.142857 | 1.83999977 | Tribolium castaneum | 7070 | Arthropoda | Arthropoda | 44.3 | 0.00355 | NR | XP_970210.1 | 7070 | g39193 | i0 | 40.4 | 0.968944099378882 | 52 | 30 | 96.9 | 1 | 4 | 159 | 1038 | 1088 | XP_970210.1 vitellogenin [Tribolium castaneum] | diamond | 156 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Tenebrionidae | Tribolium | Tribolium castaneum | |
| 28200034 | 28200034 | PRJNA851399_P_NODE_25206_length_167_cov_1.271186_g24753_i0 | PRJNA851399 | 25206 | 167 | 1.271186 | 2.12288062 | Timema | 61471 | Arthropoda | Arthropoda | 54.3 | 5.76e-7 | NR | CAD7570974.1 | 61474 | g24753 | i0 | 72.7 | 1.16766467065868 | 33 | 9 | 59.3 | 0 | 7 | 105 | 170 | 202 | CAD7570974.1 unnamed protein product [Timema californicum] | diamond | 195 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Phasmatodea | Timematidae | Timema | Timema californicum | |
| 28413085 | 28413085 | PRJNA851399_P_NODE_36606_length_162_cov_2.778761_g36153_i0 | PRJNA851399 | 36606 | 162 | 2.778761 | 4.50159282 | Centruroides sculpturatus | 218467 | Arthropoda | Arthropoda | 66.6 | 1.95e-12 | NR | XP_023214631.1 | 218467 | g36153 | i0 | 60.4 | 0.981481481481482 | 53 | 21 | 98.1 | 0 | 2 | 160 | 6 | 58 | XP_023214631.1 histone-lysine N-methyltransferase SETMAR-like [Centruroides sculpturatus] | diamond | 159 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Scorpiones | Buthidae | Centruroides | Centruroides sculpturatus | |
| 28507809 | 28507809 | PRJNA851399_P_NODE_5187_length_437_cov_55.123711_g4735_i0 | PRJNA851399 | 5187 | 437 | 55.123711 | 240.89061707 | Tribolium castaneum | 7070 | Arthropoda | Arthropoda | 76.6 | 9.41e-16 | NR | EFA13579.1 | 7070 | g4735 | i0 | 97.3 | 0.254004576659039 | 37 | 1 | 25.4 | 0 | 138 | 248 | 1 | 37 | EFA13579.1 hypothetical protein TcasGA2_TC001890 [Tribolium castaneum] | diamond | 111 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Tenebrionidae | Tribolium | Tribolium castaneum | |
| 28642415 | 28642415 | PRJNA851399_P_NODE_13267_length_208_cov_1.157233_g12814_i0 | PRJNA851399 | 13267 | 208 | 1.157233 | 2.40704464 | Timema | 61471 | Arthropoda | Arthropoda | 95.1 | 8.4e-22 | NR | CAD7573791.1 | 61474 | g12814 | i0 | 56.1 | 7.61538461538461 | 66 | 26 | 90.9 | 1 | 207 | 19 | 110 | 175 | CAD7573791.1 unnamed protein product [Timema californicum] | diamond | 1584 | 95.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Phasmatodea | Timematidae | Timema | Timema californicum | |
| 28728792 | 28728792 | PRJNA851399_P_NODE_30587_length_165_cov_0.879310_g30134_i0 | PRJNA851399 | 30587 | 165 | 0.87931 | 1.4508615 | Ischnura elegans | 197161 | Arthropoda | Arthropoda | 44.3 | 0.00367 | NR | XP_046399462.1 | 197161 | g30134 | i0 | 38.3 | 0.854545454545454 | 47 | 29 | 85.5 | 0 | 21 | 161 | 372 | 418 | XP_046399462.1 uncharacterized protein LOC124165957 [Ischnura elegans] | diamond | 141 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Odonata | Coenagrionidae | Ischnura | Ischnura elegans | |
| 29076239 | 29076239 | PRJNA851399_P_NODE_30088_length_165_cov_0.879310_g29635_i0 | PRJNA851399 | 30088 | 165 | 0.87931 | 1.4508615 | Stegodyphus dumicola | 202533 | Arthropoda | Arthropoda | 74.3 | 7.45e-15 | NR | XP_035210476.1 | 202533 | g29635 | i0 | 61.1 | 0.981818181818182 | 54 | 21 | 98.2 | 0 | 164 | 3 | 76 | 129 | XP_035210476.1 histone-lysine N-methyltransferase SETMAR-like [Stegodyphus dumicola] | diamond | 162 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Eresidae | Stegodyphus | Stegodyphus dumicola | |
| 29107745 | 29107745 | PRJNA851399_P_NODE_9228_length_266_cov_1.410138_g8775_i0 | PRJNA851399 | 9228 | 266 | 1.410138 | 3.75096708 | Asbolus verrucosus | 1661398 | Arthropoda | Arthropoda | 117 | 2.08e-28 | NR | RZC42857.1 | 1661398 | g8775 | i0 | 65.5 | 0.981203007518797 | 87 | 30 | 98.1 | 0 | 264 | 4 | 2841 | 2927 | RZC42857.1 vitellogenin [Asbolus verrucosus] | diamond | 261 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Tenebrionidae | Asbolus | Asbolus verrucosus | |
| 29170926 | 29170926 | PRJNA851399_P_NODE_1309_length_1011_cov_54.938669_g1086_i0 | PRJNA851399 | 1309 | 1011 | 54.938669 | 555.42994359 | Tribolium castaneum | 7070 | Arthropoda | Arthropoda | 75.9 | 9.49e-13 | NR | KYB24744.1 | 7070 | g1086 | i0 | 83.3 | 0.124629080118694 | 42 | 7 | 12.5 | 0 | 127 | 252 | 97 | 138 | KYB24744.1 hypothetical protein TcasGA2_TC031173 [Tribolium castaneum] | diamond | 126 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Tenebrionidae | Tribolium | Tribolium castaneum | |
| 29454569 | 29454569 | PRJNA851399_P_NODE_12030_length_221_cov_0.761628_g11577_i0 | PRJNA851399 | 12030 | 221 | 0.761628 | 1.68319788 | Petrolisthes cinctipes | 88211 | Arthropoda | Arthropoda | 106 | 1.23e-24 | NR | KAK3890300.1 | 88211 | g11577 | i0 | 69.9 | 6.93665158371041 | 73 | 22 | 99.1 | 0 | 1 | 219 | 731 | 803 | KAK3890300.1 hypothetical protein Pcinc_005829 [Petrolisthes cinctipes] | diamond | 1533 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Porcellanidae | Petrolisthes | Petrolisthes cinctipes | |
| 29454574 | 29454574 | PRJNA851399_P_NODE_33990_length_164_cov_0.886957_g33537_i0 | PRJNA851399 | 33990 | 164 | 0.886957 | 1.45460948 | Araneus ventricosus | 182803 | Arthropoda | Arthropoda | 78.2 | 1.16e-16 | NR | GBN73266.1 | 182803 | g33537 | i0 | 68.4 | 5.25 | 57 | 14 | 97 | 1 | 163 | 5 | 47 | 103 | GBN73266.1 hypothetical protein AVEN_249691-1 [Araneus ventricosus] | diamond | 861 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Araneidae | Araneus | Araneus ventricosus | |
| 29612477 | 29612477 | PRJNA851399_P_NODE_42170_length_155_cov_2.075472_g41717_i0 | PRJNA851399 | 42170 | 155 | 2.075472 | 3.2169816 | Araneus ventricosus | 182803 | Arthropoda | Arthropoda | 74.7 | 5.15e-15 | NR | GBL82061.1 | 182803 | g41717 | i0 | 66.7 | 0.987096774193548 | 51 | 17 | 98.7 | 0 | 155 | 3 | 90 | 140 | GBL82061.1 hypothetical protein AVEN_253408-1 [Araneus ventricosus] | diamond | 153 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Araneidae | Araneus | Araneus ventricosus | |
| 29644011 | 29644011 | PRJNA851399_P_NODE_34150_length_164_cov_0.869565_g33697_i0 | PRJNA851399 | 34150 | 164 | 0.869565 | 1.4260866 | Planococcus citri | 170843 | Arthropoda | Arthropoda | 100 | 2.2e-23 | NR | XP_065202084.1 | 170843 | g33697 | i0 | 95.9 | 1.79268292682927 | 49 | 2 | 89.6 | 0 | 147 | 1 | 168 | 216 | XP_065202084.1 L-threonine ammonia-lyase isoform X1 [Planococcus citri] | diamond | 294 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Pseudococcidae | Planococcus | Planococcus citri | |
| 29738841 | 29738841 | PRJNA851399_P_NODE_35330_length_163_cov_0.894737_g34877_i0 | PRJNA851399 | 35330 | 163 | 0.894737 | 1.45842131 | Bradysia coprophila | 38358 | Arthropoda | Arthropoda | 100 | 4.179999999999999e-23 | NR | XP_037025272.1 | 38358 | g34877 | i0 | 87 | 0.993865030674847 | 54 | 7 | 99.4 | 0 | 163 | 2 | 191 | 244 | XP_037025272.1 solute carrier organic anion transporter family member 74D-like [Bradysia coprophila] | diamond | 162 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Sciaridae | Bradysia | Bradysia coprophila | |
| 30434485 | 30434485 | PRJNA851399_P_NODE_24753_length_167_cov_2.016949_g24300_i0 | PRJNA851399 | 24753 | 167 | 2.016949 | 3.36830483 | Euphydryas editha | 104508 | Arthropoda | Arthropoda | 58.9 | 2.59e-8 | NR | CAH2109000.1 | 104508 | g24300 | i0 | 51 | 0.916167664670659 | 51 | 25 | 91.6 | 0 | 165 | 13 | 681 | 731 | CAH2109000.1 unnamed protein product [Euphydryas editha] | diamond | 153 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Nymphalidae | Euphydryas | Euphydryas editha | |
| 30434487 | 30434487 | PRJNA851399_P_NODE_36393_length_163_cov_0.894737_g35940_i0 | PRJNA851399 | 36393 | 163 | 0.894737 | 1.45842131 | Cryptotermes secundus | 105785 | Arthropoda | Arthropoda | 55.1 | 4.44e-7 | NR | PNF29904.1 | 105785 | g35940 | i0 | 58.8 | 1.28834355828221 | 34 | 14 | 62.6 | 0 | 7 | 108 | 226 | 259 | PNF29904.1 hypothetical protein B7P43_G07269, partial [Cryptotermes secundus] | diamond | 210 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Blattodea | Kalotermitidae | Cryptotermes | Cryptotermes secundus | |
| 30939830 | 30939830 | PRJNA851399_P_NODE_38914_length_162_cov_0.902655_g38461_i0 | PRJNA851399 | 38914 | 162 | 0.902655 | 1.4623011 | Ephemera danica | 1049336 | Arthropoda | Arthropoda | 44.3 | 0.00368 | NR | KAF4524515.1 | 1049336 | g38461 | i0 | 37 | 2 | 54 | 34 | 100 | 0 | 162 | 1 | 532 | 585 | KAF4524515.1 hypothetical protein B566_EDAN011526 [Ephemera danica] | diamond | 324 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Ephemeroptera | Ephemeridae | Ephemera | Ephemera danica | |
| 30971396 | 30971396 | PRJNA851399_P_NODE_35494_length_163_cov_0.894737_g35041_i0 | PRJNA851399 | 35494 | 163 | 0.894737 | 1.45842131 | Centruroides sculpturatus | 218467 | Arthropoda | Arthropoda | 46.2 | 5.92e-4 | NR | XP_023223020.1 | 218467 | g35041 | i0 | 55.8 | 0.791411042944785 | 43 | 18 | 77.3 | 1 | 128 | 3 | 164 | 206 | XP_023223020.1 uncharacterized protein LOC111624419 [Centruroides sculpturatus] | diamond | 129 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Scorpiones | Buthidae | Centruroides | Centruroides sculpturatus | |
| 31128885 | 31128885 | PRJNA851399_P_NODE_5895_length_399_cov_2.148571_g5443_i0 | PRJNA851399 | 5895 | 399 | 2.148571 | 8.57279829 | Ceratitis capitata | 7213 | Arthropoda | Arthropoda | 47.8 | 7.21e-4 | NR | CAD7011254.1 | 7213 | g5443 | i0 | 61.5 | 0.571428571428571 | 39 | 15 | 29.3 | 0 | 209 | 325 | 85 | 123 | CAD7011254.1 unnamed protein product [Ceratitis capitata] | diamond | 228 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Tephritidae | Ceratitis | Ceratitis capitata | |
| 31168832 | 31168832 | PRJNA851399_P_NODE_10255_length_246_cov_0.852792_g9802_i0 | PRJNA851399 | 10255 | 246 | 0.852792 | 2.09786832 | Diorhabda | 217246 | Arthropoda | Arthropoda | 72.4 | 1.01e-12 | NR | XP_057658791.1 | 1163345 | g9802 | i0 | 51.6 | 1.51219512195122 | 62 | 30 | 75.6 | 0 | 56 | 241 | 197 | 258 | XP_057658791.1 uncharacterized protein LOC130895485 isoform X3 [Diorhabda carinulata] | diamond | 372 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Chrysomelidae | Diorhabda | Diorhabda carinulata | |
| 31508865 | 31508865 | PRJNA851399_P_NODE_9376_length_262_cov_3.361502_g8923_i0 | PRJNA851399 | 9376 | 262 | 3.361502 | 8.80713524 | Ceratitis capitata | 7213 | Arthropoda | Arthropoda | 48.5 | 9.65e-5 | NR | CAD7011254.1 | 7213 | g8923 | i0 | 70.6 | 0.641221374045801 | 34 | 10 | 38.9 | 0 | 191 | 90 | 89 | 122 | CAD7011254.1 unnamed protein product [Ceratitis capitata] | diamond | 168 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Tephritidae | Ceratitis | Ceratitis capitata | |
| 31603680 | 31603680 | PRJNA851399_P_NODE_21136_length_175_cov_1.603175_g20683_i0 | PRJNA851399 | 21136 | 175 | 1.603175 | 2.80555625 | Periplaneta americana | 6978 | Arthropoda | Arthropoda | 82.4 | 2.42e-17 | NR | KAJ4426647.1 | 6978 | g20683 | i0 | 60.3 | 1.98857142857143 | 58 | 23 | 99.4 | 0 | 2 | 175 | 133 | 190 | KAJ4426647.1 hypothetical protein ANN_26445 [Periplaneta americana] | diamond | 348 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Blattodea | Blattidae | Periplaneta | Periplaneta americana | |
| 31856556 | 31856556 | PRJNA851399_P_NODE_9517_length_260_cov_0.862559_g9064_i0 | PRJNA851399 | 9517 | 260 | 0.862559 | 2.2426534 | Ischnura elegans | 197161 | Arthropoda | Arthropoda | 101 | 9.35e-23 | NR | XP_046382273.1 | 197161 | g9064 | i0 | 54.8 | 0.969230769230769 | 84 | 38 | 96.9 | 0 | 255 | 4 | 73 | 156 | XP_046382273.1 uncharacterized protein LOC124153218 [Ischnura elegans] | diamond | 252 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Odonata | Coenagrionidae | Ischnura | Ischnura elegans | |
| 32109760 | 32109760 | PRJNA851399_P_NODE_15838_length_189_cov_2.185714_g15385_i0 | PRJNA851399 | 15838 | 189 | 2.185714 | 4.13099946 | Ignelater luminosus | 2038154 | Arthropoda | Arthropoda | 55.8 | 4.13e-7 | NR | KAF2887598.1 | 2038154 | g15385 | i0 | 40 | 0.952380952380952 | 60 | 36 | 95.2 | 0 | 8 | 187 | 192 | 251 | KAF2887598.1 hypothetical protein ILUMI_18575 [Ignelater luminosus] | diamond | 180 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Elateridae | Ignelater | Ignelater luminosus | |
| 32236693 | 32236693 | PRJNA851399_P_NODE_4758_length_466_cov_46.067146_g4310_i0 | PRJNA851399 | 4758 | 466 | 46.067146 | 214.67290036 | Tribolium castaneum | 7070 | Arthropoda | Arthropoda | 71.6 | 1.31e-12 | NR | KYB24744.1 | 7070 | g4310 | i0 | 48.8 | 0.804721030042919 | 125 | 24 | 54.7 | 2 | 371 | 117 | 1 | 125 | KYB24744.1 hypothetical protein TcasGA2_TC031173 [Tribolium castaneum] | diamond | 375 | 71.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Tenebrionidae | Tribolium | Tribolium castaneum | |
| 32363144 | 32363144 | PRJNA851399_P_NODE_29939_length_165_cov_0.879310_g29486_i0 | PRJNA851399 | 29939 | 165 | 0.87931 | 1.4508615 | Araneus ventricosus | 182803 | Arthropoda | Arthropoda | 54.3 | 1.06e-6 | NR | GBL79937.1 | 182803 | g29486 | i0 | 55.8 | 2.83636363636364 | 52 | 22 | 92.7 | 1 | 11 | 163 | 220 | 271 | GBL79937.1 hypothetical protein AVEN_28978-1 [Araneus ventricosus] | diamond | 468 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Araneidae | Araneus | Araneus ventricosus | |
| 32741877 | 32741877 | PRJNA851399_P_NODE_32500_length_164_cov_0.886957_g32047_i0 | PRJNA851399 | 32500 | 164 | 0.886957 | 1.45460948 | Parasteatoda tepidariorum | 114398 | Arthropoda | Arthropoda | 45.1 | 0.00196 | NR | XP_042908649.2 | 114398 | g32047 | i0 | 48.6 | 0.676829268292683 | 37 | 19 | 67.7 | 0 | 15 | 125 | 298 | 334 | XP_042908649.2 uncharacterized protein [Parasteatoda tepidariorum] | diamond | 111 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Theridiidae | Parasteatoda | Parasteatoda tepidariorum | |
| 32836085 | 32836085 | PRJNA851399_P_NODE_41960_length_157_cov_2.833333_g41507_i0 | PRJNA851399 | 41960 | 157 | 2.833333 | 4.44833281 | Blattella germanica | 6973 | Arthropoda | Arthropoda | 79.3 | 1.39e-17 | NR | PSN58481.1 | 6973 | g41507 | i0 | 69.2 | 3.97452229299363 | 52 | 16 | 99.4 | 0 | 157 | 2 | 29 | 80 | PSN58481.1 hypothetical protein C0J52_00800 [Blattella germanica] | diamond | 624 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Blattodea | Blattellidae | Blattella | Blattella germanica | |
| 32907264 | 32907264 | PRJNA851399_P_NODE_21320_length_174_cov_2.232000_g20867_i0 | PRJNA851399 | 21320 | 174 | 2.232 | 3.88368 | Odonata | 6961 | Arthropoda | Arthropoda | 44.3 | 0.00443 | NR | XP_071449443.1 | 62018 | g20867 | i0 | 56.8 | 1.31034482758621 | 44 | 16 | 70.7 | 1 | 123 | 1 | 2739 | 2782 | XP_071449443.1 streptococcal hemagglutinin-like [Hetaerina americana] | diamond | 228 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Odonata | Calopterygidae | Hetaerina | Hetaerina americana |
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);;