contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA698538" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3735841 | 3735841 | PRJNA698538_S_NODE_15083_length_312_cov_1.933054_g14917_i0 | PRJNA698538 | 15083 | 312 | 1.933054 | 6.03112848 | Blomia tropicalis | 40697 | Arthropoda | Arthropoda | 85.1 | 4.33e-19 | NR | KAJ6224266.1 | 40697 | g14917 | i0 | 66 | 0.480769230769231 | 50 | 17 | 48.1 | 0 | 92 | 241 | 44 | 93 | KAJ6224266.1 hypothetical protein RDWZM_002811 [Blomia tropicalis] | diamond | 150 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Echimyopodidae | Blomia | Blomia tropicalis | |
| 5785075 | 5785075 | PRJNA698538_S_NODE_8405_length_365_cov_1.523973_g8239_i0 | PRJNA698538 | 8405 | 365 | 1.523973 | 5.56250145 | Blomia tropicalis | 40697 | Arthropoda | Arthropoda | 202 | 1.8100000000000003e-64 | NR | KAI2799039.1 | 40697 | g8239 | i0 | 83.8 | 1.82465753424658 | 111 | 18 | 91.2 | 0 | 363 | 31 | 39 | 149 | KAI2799039.1 60S ribosomal protein L27A, partial [Blomia tropicalis] | diamond | 666 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Echimyopodidae | Blomia | Blomia tropicalis | |
| 8334407 | 8334407 | PRJNA698538_S_NODE_13167_length_325_cov_0.916667_g13001_i0 | PRJNA698538 | 13167 | 325 | 0.916667 | 2.97916775 | Amphipoda | 6821 | Arthropoda | Arthropoda | 61.2 | 3.09e-8 | NR | XP_047736830.1 | 294128 | g13001 | i0 | 36.5 | 4.57846153846154 | 96 | 49 | 88.6 | 3 | 25 | 312 | 481 | 564 | XP_047736830.1 DDB1- and CUL4-associated factor 12 homolog isoform X1 [Hyalella azteca] | diamond | 1488 | 61.6 | 0.993506493506494 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Amphipoda | Hyalellidae | Hyalella | Hyalella azteca | |
| 9609902 | 9609902 | PRJNA698538_S_NODE_27448_length_248_cov_3.960000_g27282_i0 | PRJNA698538 | 27448 | 248 | 3.96 | 9.8208 | Opisthokonta | 33154 | Arthropoda | Arthropoda | 131 | 7.45e-38 | NR | CAL6252305.1 | 34615 | g27282 | i0 | 92.5 | 3.18145161290323 | 67 | 5 | 81 | 0 | 218 | 18 | 4 | 70 | CAL6252305.1 unnamed protein product [Ixodes persulcatus] | diamond | 789 | 131 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Ixodida | Ixodidae | Ixodes | Ixodes persulcatus | |
| 10885531 | 10885531 | PRJNA698538_S_NODE_27069_length_250_cov_0.751412_g26903_i0 | PRJNA698538 | 27069 | 250 | 0.751412 | 1.87853 | Arachnida | 6854 | Arthropoda | Arthropoda | 110 | 5.47e-28 | NR | XP_046911003.1 | 6954 | g26903 | i0 | 81.8 | 92.664 | 66 | 12 | 79.2 | 0 | 248 | 51 | 141 | 206 | XP_046911003.1 60S ribosomal protein L23a-like [Dermatophagoides farinae] | diamond | 23166 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Pyroglyphidae | Dermatophagoides | Dermatophagoides farinae | |
| 13435240 | 13435240 | PRJNA698538_S_NODE_23971_length_263_cov_2.247368_g23805_i0 | PRJNA698538 | 23971 | 263 | 2.247368 | 5.91057784 | Culex pipiens pallens | 42434 | Arthropoda | Arthropoda | 62.8 | 4.16e-9 | NR | XP_039446575.1 | 42434 | g23805 | i0 | 46.5 | 1.5171102661597 | 71 | 38 | 81 | 0 | 230 | 18 | 552 | 622 | XP_039446575.1 uncharacterized protein LOC128092265 [Culex pipiens pallens] | diamond | 399 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Culicidae | Culex | Culex pipiens | |
| 24907941 | 24907941 | PRJNA698538_S_NODE_8700_length_362_cov_1.439446_g8534_i0 | PRJNA698538 | 8700 | 362 | 1.439446 | 5.21079452 | Lepidoglyphus destructor | 36936 | Arthropoda | Arthropoda | 138 | 7.12e-38 | NR | AAQ55487.1 | 36936 | g8534 | i0 | 67.3 | 0.812154696132597 | 98 | 28 | 81.2 | 1 | 362 | 69 | 167 | 260 | AAQ55487.1 allergen Lep d 3 [Lepidoglyphus destructor] | diamond | 294 | 138 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Glycyphagidae | Lepidoglyphus | Lepidoglyphus destructor | |
| 26998874 | 26998874 | PRJNA698538_S_NODE_11502_length_337_cov_1.746212_g11336_i0 | PRJNA698538 | 11502 | 337 | 1.746212 | 5.88473444 | Metazoa | 33208 | Arthropoda | Arthropoda | 66.2 | 4.37e-10 | NR | XP_042145395.1 | 6945 | g11336 | i0 | 58.2 | 3.89910979228487 | 55 | 20 | 46.3 | 1 | 333 | 178 | 232 | 286 | XP_042145395.1 putative tRNA (cytidine(32)/guanosine(34)-2'-O)-methyltransferase [Ixodes scapularis] | diamond | 1314 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Ixodida | Ixodidae | Ixodes | Ixodes scapularis | |
| 27220114 | 27220114 | PRJNA698538_S_NODE_4882_length_413_cov_71.176471_g4716_i0 | PRJNA698538 | 4882 | 413 | 71.176471 | 293.95882523 | root | 1 | Root_unresolved | Root_unresolved | 53.1 | 5.63e-5 | NR | GBN61280.1 | 182803 | g4716 | i0 | 50.9 | 4.71428571428571 | 53 | 26 | 38.5 | 0 | 290 | 132 | 1136 | 1188 | GBN61280.1 putative RNA-directed DNA polymerase from transposon X-element [Araneus ventricosus] | diamond | 1947 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Araneae | Araneidae | Araneus | Araneus ventricosus | |
| 27251919 | 27251919 | PRJNA698538_S_NODE_32403_length_204_cov_4.114504_g32237_i0 | PRJNA698538 | 32403 | 204 | 4.114504 | 8.39358816 | Arachnida | 6854 | Arthropoda | Arthropoda | 49.3 | 1.13e-5 | NR | KAH7942857.1 | 34632 | g32237 | i0 | 82.1 | 2.22058823529412 | 28 | 5 | 41.2 | 0 | 203 | 120 | 53 | 80 | KAH7942857.1 hypothetical protein HPB52_002034 [Rhipicephalus sanguineus] | diamond | 453 | 49.7 | 0.991951710261569 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Ixodida | Ixodidae | Rhipicephalus | Rhipicephalus sanguineus | |
| 27462096 | 27462096 | PRJNA698538_S_NODE_6043_length_394_cov_2.105919_g5877_i0 | PRJNA698538 | 6043 | 394 | 2.105919 | 8.29732086 | Medioppia subpectinata | 1979941 | Arthropoda | Arthropoda | 243 | 2.74e-75 | NR | CAD7620986.1 | 1979941 | g5877 | i0 | 89.1 | 1.9492385786802 | 128 | 14 | 97.5 | 0 | 2 | 385 | 426 | 553 | CAD7620986.1 unnamed protein product [Medioppia subpectinata] | diamond | 768 | 243 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Oppiidae | Medioppia | Medioppia subpectinata | |
| 27726137 | 27726137 | PRJNA698538_S_NODE_29464_length_243_cov_0.894118_g29298_i0 | PRJNA698538 | 29464 | 243 | 0.894118 | 2.17270674 | Metazoa | 33208 | Arthropoda | Arthropoda | 45.1 | 0.00574 | NR | XP_037288319.1 | 6941 | g29298 | i0 | 44.7 | 4.83950617283951 | 38 | 21 | 46.9 | 0 | 3 | 116 | 842 | 879 | XP_037288319.1 uncharacterized protein ZC84.1-like isoform X8 [Rhipicephalus microplus] | diamond | 1176 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Ixodida | Ixodidae | Rhipicephalus | Rhipicephalus microplus | |
| 27777813 | 27777813 | PRJNA698538_S_NODE_27924_length_247_cov_1.655172_g27758_i0 | PRJNA698538 | 27924 | 247 | 1.655172 | 4.08827484 | Orchesella cincta | 48709 | Arthropoda | Arthropoda | 57.8 | 5.63e-9 | NR | ODM98801.1 | 48709 | g27758 | i0 | 80 | 0.364372469635628 | 30 | 6 | 36.4 | 0 | 242 | 153 | 22 | 51 | ODM98801.1 hypothetical protein Ocin01_07883 [Orchesella cincta] | diamond | 90 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Collembola | Entomobryomorpha | Orchesellidae | Orchesella | Orchesella cincta | |
| 27820604 | 27820604 | PRJNA698538_S_NODE_19124_length_288_cov_1.790698_g18958_i0 | PRJNA698538 | 19124 | 288 | 1.790698 | 5.15721024 | Oppiidae | 229795 | Arthropoda | Arthropoda | 93.6 | 6.2e-22 | NR | CAD7656826.1 | 334625 | g18958 | i0 | 74.6 | 1.23958333333333 | 59 | 15 | 61.5 | 0 | 287 | 111 | 87 | 145 | CAD7656826.1 unnamed protein product [Oppiella nova] | diamond | 357 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Oppiidae | Oppiella | Oppiella nova | |
| 28377484 | 28377484 | PRJNA698538_S_NODE_17846_length_295_cov_3.189189_g17680_i0 | PRJNA698538 | 17846 | 295 | 3.189189 | 9.40810755 | Schistocerca gregaria | 7010 | Arthropoda | Arthropoda | 58.2 | 2.64e-7 | NR | XP_049848983.1 | 7010 | g17680 | i0 | 35.1 | 0.783050847457627 | 77 | 50 | 78.3 | 0 | 6 | 236 | 1103 | 1179 | XP_049848983.1 uncharacterized protein LOC126316991 [Schistocerca gregaria] | diamond | 231 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Orthoptera | Acrididae | Schistocerca | Schistocerca gregaria | |
| 28893817 | 28893817 | PRJNA698538_S_NODE_30648_length_236_cov_2.834356_g30482_i0 | PRJNA698538 | 30648 | 236 | 2.834356 | 6.68908016 | Opisthokonta | 33154 | Arthropoda | Arthropoda | 44.7 | 0.007 | NR | KAK3849799.1 | 88211 | g30482 | i0 | 59.4 | 1.28389830508475 | 32 | 13 | 40.7 | 0 | 8 | 103 | 321 | 352 | KAK3849799.1 hypothetical protein Pcinc_043460 [Petrolisthes cinctipes] | diamond | 303 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Porcellanidae | Petrolisthes | Petrolisthes cinctipes | |
| 29009450 | 29009450 | PRJNA698538_S_NODE_17688_length_296_cov_3.434978_g17522_i0 | PRJNA698538 | 17688 | 296 | 3.434978 | 10.16753488 | Polyplax serrata | 468196 | Arthropoda | Arthropoda | 70.1 | 1.79e-11 | NR | KAK6639969.1 | 468196 | g17522 | i0 | 47.3 | 0.942567567567568 | 93 | 47 | 93.2 | 2 | 2 | 277 | 353 | 444 | KAK6639969.1 hypothetical protein RUM43_008246 [Polyplax serrata] | diamond | 279 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Psocodea | Polyplacidae | Polyplax | Polyplax serrata | |
| 29261439 | 29261439 | PRJNA698538_S_NODE_11369_length_338_cov_2.324528_g11203_i0 | PRJNA698538 | 11369 | 338 | 2.324528 | 7.85690464 | Medioppia subpectinata | 1979941 | Arthropoda | Arthropoda | 57.4 | 1.37e-7 | NR | CAD7642457.1 | 1979941 | g11203 | i0 | 68.3 | 0.363905325443787 | 41 | 12 | 35.5 | 1 | 3 | 122 | 107 | 147 | CAD7642457.1 unnamed protein product [Medioppia subpectinata] | diamond | 123 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Oppiidae | Medioppia | Medioppia subpectinata | |
| 30240740 | 30240740 | PRJNA698538_S_NODE_7072_length_380_cov_1.641694_g6906_i0 | PRJNA698538 | 7072 | 380 | 1.641694 | 6.2384372 | Glycyphagus domesticus | 105145 | Arthropoda | Arthropoda | 89.7 | 2.98e-19 | NR | AAQ54608.1 | 105145 | g6906 | i0 | 45.7 | 3.71052631578947 | 92 | 49 | 72.6 | 1 | 368 | 93 | 124 | 214 | AAQ54608.1 Gly d 8 [Glycyphagus domesticus] | diamond | 1410 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Glycyphagidae | Glycyphagus | Glycyphagus domesticus | |
| 30504752 | 30504752 | PRJNA698538_S_NODE_32073_length_214_cov_4.368794_g31907_i0 | PRJNA698538 | 32073 | 214 | 4.368794 | 9.34921916 | Psyllidae | 30092 | Arthropoda | Arthropoda | 112 | 1.61e-28 | NR | XP_017301022.1 | 121845 | g31907 | i0 | 87.5 | 24.4485981308411 | 64 | 8 | 89.7 | 0 | 3 | 194 | 176 | 239 | XP_017301022.1 LOW QUALITY PROTEIN: 14-3-3 protein epsilon [Diaphorina citri] | diamond | 5232 | 113 | 0.991150442477876 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hemiptera | Psyllidae | Diaphorina | Diaphorina citri | |
| 31062429 | 31062429 | PRJNA698538_S_NODE_29255_length_243_cov_1.811765_g29089_i0 | PRJNA698538 | 29255 | 243 | 1.811765 | 4.40258895 | Histiostomatidae sp. XFX | 2652661 | Arthropoda | Arthropoda | 82.8 | 1.1e-16 | NR | QFG71639.1 | 2652661 | g29089 | i0 | 52.8 | 0.888888888888889 | 72 | 34 | 88.9 | 0 | 8 | 223 | 216 | 287 | QFG71639.1 NADH dehydrogenase subunit 2 [Histiostomatidae sp. XFX] | diamond | 216 | 82.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Sarcoptiformes | Histiostomatidae | Histiostomatidae sp. XFX | ||
| 31389692 | 31389692 | PRJNA698538_S_NODE_15856_length_307_cov_2.632479_g15690_i0 | PRJNA698538 | 15856 | 307 | 2.632479 | 8.08171053 | Arthropoda | 6656 | Arthropoda | Arthropoda | 94 | 6.14e-20 | NR | XP_004518483.1 | 7213 | g15690 | i0 | 61.6 | 7.36807817589577 | 73 | 28 | 71.3 | 0 | 283 | 65 | 371 | 443 | XP_004518483.1 adenosine 3'-phospho 5'-phosphosulfate transporter 1 [Ceratitis capitata] | diamond | 2262 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Tephritidae | Ceratitis | Ceratitis capitata | |
| 31568330 | 31568330 | PRJNA698538_S_NODE_11756_length_335_cov_2.645038_g11590_i0 | PRJNA698538 | 11756 | 335 | 2.645038 | 8.8608773 | Anabrus simplex | 316456 | Arthropoda | Arthropoda | 86.3 | 5.94e-17 | NR | XP_066992419.2 | 316456 | g11590 | i0 | 43.4 | 0.886567164179105 | 99 | 55 | 88.7 | 1 | 322 | 26 | 83 | 180 | XP_066992419.2 U3 small nucleolar RNA-associated protein 14 homolog A [Anabrus simplex] | diamond | 297 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Orthoptera | Tettigoniidae | Anabrus | Anabrus simplex | |
| 32105846 | 32105846 | PRJNA698538_S_NODE_15878_length_307_cov_2.260684_g15712_i0 | PRJNA698538 | 15878 | 307 | 2.260684 | 6.94029988 | Fopius arisanus | 64838 | Arthropoda | Arthropoda | 58.9 | 1.29e-7 | NR | XP_011305167.1 | 64838 | g15712 | i0 | 41.1 | 1.41693811074919 | 73 | 42 | 71.3 | 1 | 297 | 79 | 160 | 231 | XP_011305167.1 uncharacterized protein [Fopius arisanus] | diamond | 435 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Hymenoptera | Braconidae | Fopius | Fopius arisanus | |
| 32232718 | 32232718 | PRJNA698538_S_NODE_20278_length_282_cov_1.473684_g20112_i0 | PRJNA698538 | 20278 | 282 | 1.473684 | 4.15578888 | Bradysia odoriphaga | 1564500 | Arthropoda | Arthropoda | 55.1 | 2.28e-6 | NR | KAG4067698.1 | 1564500 | g20112 | i0 | 60.5 | 0.457446808510638 | 43 | 17 | 45.7 | 0 | 2 | 130 | 241 | 283 | KAG4067698.1 hypothetical protein HA402_005470 [Bradysia odoriphaga] | diamond | 129 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Sciaridae | Bradysia | Bradysia odoriphaga |
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);;