contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA665531" and tax_kingdom = "Metazoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14658194 | 14658194 | PRJNA665531_P_NODE_12692_length_291_cov_1.233945_g12456_i0 | PRJNA665531 | 12692 | 291 | 1.233945 | 3.59077995 | Trombidiformes | 83136 | Arthropoda | Arthropoda | 196 | 5.53e-59 | NR | XP_015793326.1 | 32264 | g12456 | i0 | 93.8 | 4.94845360824742 | 96 | 6 | 99 | 0 | 290 | 3 | 219 | 314 | XP_015793326.1 rab GDP dissociation inhibitor beta [Tetranychus urticae] | diamond | 1440 | 197 | 0.99492385786802 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Tetranychidae | Tetranychus | Tetranychus urticae | |
| 14658417 | 14658417 | PRJNA665531_P_NODE_3592_length_596_cov_2.355641_g3361_i0 | PRJNA665531 | 3592 | 596 | 2.355641 | 14.03962036 | Sus scrofa | 9823 | Chordata | Chordata | 340 | 3.249999999999999e-112 | NR | XP_020938199.1 | 9823 | g3361 | i0 | 91.4 | 1.77684563758389 | 185 | 9 | 89.6 | 1 | 540 | 7 | 47 | 231 | XP_020938199.1 ribonuclease inhibitor isoform X2 [Sus scrofa] | diamond | 1059 | 340 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Suidae | Sus | Sus scrofa | |
| 27124862 | 27124862 | PRJNA665531_P_NODE_5662_length_457_cov_5.523438_g5426_i0 | PRJNA665531 | 5662 | 457 | 5.523438 | 25.24211166 | root | 1 | Root_unresolved | Root_unresolved | 198 | 6.35e-60 | NR | XP_045731795.2 | 9716 | g5426 | i0 | 62.1 | 95.0021881838074 | 145 | 55 | 95.2 | 0 | 22 | 456 | 123 | 267 | XP_045731795.2 ras-related C3 botulinum toxin substrate 1 [Mirounga angustirostris] | diamond | 43416 | 199 | 0.994974874371859 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Carnivora | Phocidae | Mirounga | Mirounga angustirostris | |
| 27429370 | 27429370 | PRJNA665531_P_NODE_13983_length_277_cov_1.509804_g13747_i0 | PRJNA665531 | 13983 | 277 | 1.509804 | 4.18215708 | Tetranychus urticae | 32264 | Arthropoda | Arthropoda | 164 | 1.91e-46 | NR | XP_015793326.1 | 32264 | g13747 | i0 | 90.1 | 2.95667870036101 | 91 | 9 | 98.6 | 0 | 275 | 3 | 21 | 111 | XP_015793326.1 rab GDP dissociation inhibitor beta [Tetranychus urticae] | diamond | 819 | 164 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Trombidiformes | Tetranychidae | Tetranychus | Tetranychus urticae | |
| 27883219 | 27883219 | PRJNA665531_P_NODE_14325_length_274_cov_1.338308_g14089_i0 | PRJNA665531 | 14325 | 274 | 1.338308 | 3.66696392 | Diptera | 7147 | Arthropoda | Arthropoda | 98.2 | 2.2699999999999994e-23 | NR | XP_037894365.1 | 7396 | g14089 | i0 | 63.3 | 2.7043795620438 | 79 | 23 | 86.5 | 1 | 238 | 2 | 49 | 121 | XP_037894365.1 ADP-ribose glycohydrolase OARD1 isoform X1 [Glossina fuscipes] | diamond | 741 | 99 | 0.991919191919192 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Glossinidae | Glossina | Glossina fuscipes | |
| 28104128 | 28104128 | PRJNA665531_P_NODE_8925_length_351_cov_5.751799_g8689_i0 | PRJNA665531 | 8925 | 351 | 5.751799 | 20.18881449 | Metazoa | 33208 | Mollusca | Mollusca | 82.4 | 2.85e-16 | NR | XP_059141807.1 | 109671 | g8689 | i0 | 52.5 | 3.37606837606838 | 59 | 28 | 50.4 | 0 | 276 | 100 | 191 | 249 | XP_059141807.1 carboxypeptidase inhibitor SmCI-like [Physella acuta] | diamond | 1185 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 28313270 | 28313270 | PRJNA665531_P_NODE_12026_length_299_cov_2.429204_g11790_i0 | PRJNA665531 | 12026 | 299 | 2.429204 | 7.26331996 | Pediculus humanus corporis | 121224 | Arthropoda | Arthropoda | 105 | 1.4699999999999999e-24 | NR | XP_002432521.1 | 121224 | g11790 | i0 | 50 | 0.862876254180602 | 86 | 43 | 86.3 | 0 | 260 | 3 | 10 | 95 | XP_002432521.1 uncharacterized protein Phum_PHUM589680 [Pediculus humanus corporis] | diamond | 258 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Pediculidae | Pediculus | Pediculus humanus | |
| 28313274 | 28313274 | PRJNA665531_P_NODE_6746_length_413_cov_1.341176_g6510_i0 | PRJNA665531 | 6746 | 413 | 1.341176 | 5.53905688 | Staurois parvus | 386267 | Chordata | Chordata | 44.3 | 0.00475 | NR | CAI9623369.1 | 386267 | g6510 | i0 | 50 | 0.276029055690073 | 38 | 19 | 27.6 | 0 | 246 | 359 | 25 | 62 | CAI9623369.1 unnamed protein product [Staurois parvus] | diamond | 114 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Ranidae | Staurois | Staurois parvus | |
| 29039648 | 29039648 | PRJNA665531_P_NODE_19048_length_242_cov_1.112426_g18812_i0 | PRJNA665531 | 19048 | 242 | 1.112426 | 2.69207092 | Notodromas monacha | 399045 | Arthropoda | Arthropoda | 42 | 0.00756 | NR | CAD7275672.1 | 399045 | g18812 | i0 | 43.6 | 0.91735537190082606 | 39 | 22 | 48.3 | 0 | 213 | 97 | 19 | 57 | CAD7275672.1 unnamed protein product [Notodromas monacha] | diamond | 222 | 42 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Ostracoda | Podocopida | Cyprididae | Notodromas | Notodromas monacha | |
| 29146612 | 29146612 | PRJNA665531_P_NODE_19289_length_241_cov_1.339286_g19053_i0 | PRJNA665531 | 19289 | 241 | 1.339286 | 3.22767926 | Insecta | 50557 | Arthropoda | Arthropoda | 166 | 2e-45 | NR | XP_069682867.1 | 6978 | g19053 | i0 | 91.1 | 8.91286307053942 | 79 | 7 | 98.3 | 0 | 241 | 5 | 1158 | 1236 | XP_069682867.1 Ig-like and fibronectin type-III domain-containing protein 1 isoform X2 [Periplaneta americana] | diamond | 2148 | 167 | 0.994011976047904 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Blattodea | Blattidae | Periplaneta | Periplaneta americana | |
| 29367352 | 29367352 | PRJNA665531_P_NODE_19209_length_241_cov_2.380952_g18973_i0 | PRJNA665531 | 19209 | 241 | 2.380952 | 5.73809432 | Rodentia | 9989 | Chordata | Chordata | 84 | 2.17e-18 | NR | XP_040601539.1 | 10036 | g18973 | i0 | 54.5 | 2.850622406639 | 77 | 32 | 92.1 | 1 | 20 | 241 | 34 | 110 | XP_040601539.1 calmodulin-A-like [Mesocricetus auratus] | diamond | 687 | 84.7 | 0.991735537190083 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Rodentia | Cricetidae | Mesocricetus | Mesocricetus auratus | |
| 29512852 | 29512852 | PRJNA665531_P_NODE_9010_length_349_cov_2.307971_g8774_i0 | PRJNA665531 | 9010 | 349 | 2.307971 | 8.05481879 | Erpetoichthys calabaricus | 27687 | Chordata | Chordata | 76.6 | 9.56e-14 | NR | XP_051791274.1 | 27687 | g8774 | i0 | 50.5 | 4.16905444126075 | 97 | 20 | 82.5 | 2 | 288 | 1 | 156 | 225 | XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus] | diamond | 1455 | 76.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 30903019 | 30903019 | PRJNA665531_P_NODE_12174_length_297_cov_2.401786_g11938_i0 | PRJNA665531 | 12174 | 297 | 2.401786 | 7.13330442 | Dalotia coriaria | 877792 | Arthropoda | Arthropoda | 57.8 | 3.59e-7 | NR | XP_065171304.1 | 877792 | g11938 | i0 | 42.4 | 1.96969696969697 | 59 | 32 | 57.6 | 1 | 3 | 173 | 504 | 562 | XP_065171304.1 LOW QUALITY PROTEIN: kelch-like protein 9 [Dalotia coriaria] | diamond | 585 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Coleoptera | Staphylinidae | Dalotia | Dalotia coriaria | |
| 31736979 | 31736979 | PRJNA665531_P_NODE_19777_length_234_cov_2.124224_g19541_i0 | PRJNA665531 | 19777 | 234 | 2.124224 | 4.97068416 | Metazoa | 33208 | Arthropoda | Arthropoda | 46.6 | 0.00144 | NR | DBA43570.1 | 207636 | g19541 | i0 | 47.7 | 3.6025641025641 | 44 | 22 | 55.1 | 1 | 231 | 103 | 338 | 381 | DBA43570.1 TPA_asm: CYTB [Bombus haemorrhoidalis] | diamond | 843 | 47 | 0.991489361702128 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Apidae | Bombus | Bombus haemorrhoidalis | |
| 31851370 | 31851370 | PRJNA665531_P_NODE_19317_length_241_cov_0.916667_g19081_i0 | PRJNA665531 | 19317 | 241 | 0.916667 | 2.20916747 | Adineta ricciae | 249248 | Rotifera | other_Eukaryota | 124 | 1.4399999999999999e-32 | NR | CAF1553994.1 | 249248 | g19081 | i0 | 75.9 | 0.983402489626556 | 79 | 2 | 98.3 | 1 | 239 | 3 | 88 | 149 | CAF1553994.1 unnamed protein product, partial [Adineta ricciae] | diamond | 237 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Adinetida | Adinetidae | Adineta | Adineta ricciae |
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);;