contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA999043" and tax_clade = "Opisthokonta"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 979557 | 979557 | PRJNA999043_P_NODE_16141_length_336_cov_1.273764_g16046_i0 | PRJNA999043 | 16141 | 336 | 1.273764 | 4.27984704 | Tropilaelaps mercedesae | 418985 | Arthropoda | Arthropoda | 176 | 6e-51 | NR | OQR74553.1 | 418985 | g16046 | i0 | 82.1 | 1.99107142857143 | 112 | 19 | 99.1 | 1 | 3 | 335 | 36 | 147 | OQR74553.1 hypothetical protein BIW11_08987, partial [Tropilaelaps mercedesae] | diamond | 669 | 176 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Laelapidae | Tropilaelaps | Tropilaelaps mercedesae | |
| 3530478 | 3530478 | PRJNA999043_P_NODE_23463_length_245_cov_0.895349_g23368_i0 | PRJNA999043 | 23463 | 245 | 0.895349 | 2.19360505 | Alectoris rufa | 9079 | Chordata | Chordata | 86.7 | 1.54e-19 | NR | CAK6566519.1 | 9079 | g23368 | i0 | 75 | 2.08163265306122 | 56 | 14 | 68.6 | 0 | 74 | 241 | 80 | 135 | CAK6566519.1 unnamed protein product [Alectoris rufa] | diamond | 510 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Alectoris | Alectoris rufa | |
| 8632982 | 8632982 | PRJNA999043_P_NODE_24087_length_243_cov_0.905882_g23992_i0 | PRJNA999043 | 24087 | 243 | 0.905882 | 2.20129326 | Alectoris rufa | 9079 | Chordata | Chordata | 86.3 | 7.91e-19 | NR | CAK6566476.1 | 9079 | g23992 | i0 | 61.1 | 0.888888888888889 | 72 | 28 | 88.9 | 0 | 15 | 230 | 80 | 151 | CAK6566476.1 unnamed protein product [Alectoris rufa] | diamond | 216 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Alectoris | Alectoris rufa | |
| 9907760 | 9907760 | PRJNA999043_P_NODE_16768_length_323_cov_0.924000_g16673_i0 | PRJNA999043 | 16768 | 323 | 0.924 | 2.98452 | Varroa destructor | 109461 | Arthropoda | Arthropoda | 212 | 7.97e-62 | NR | XP_022663764.1 | 109461 | g16673 | i0 | 92.5 | 1.98761609907121 | 107 | 8 | 99.4 | 0 | 322 | 2 | 584 | 690 | XP_022663764.1 translation elongation factor 2-like [Varroa destructor] | diamond | 642 | 212 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Varroidae | Varroa | Varroa destructor | |
| 15007700 | 15007700 | PRJNA999043_P_NODE_23172_length_246_cov_0.890173_g23077_i0 | PRJNA999043 | 23172 | 246 | 0.890173 | 2.18982558 | Alectoris rufa | 9079 | Chordata | Chordata | 65.9 | 1.04e-10 | NR | CAK6571032.1 | 9079 | g23077 | i0 | 49.2 | 0.74390243902439 | 61 | 31 | 74.4 | 0 | 197 | 15 | 164 | 224 | CAK6571032.1 unnamed protein product [Alectoris rufa] | diamond | 183 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Alectoris | Alectoris rufa | |
| 26684042 | 26684042 | PRJNA999043_P_NODE_24381_length_242_cov_0.911243_g24286_i0 | PRJNA999043 | 24381 | 242 | 0.911243 | 2.20520806 | Phasianidae | 9005 | Chordata | Chordata | 82 | 2.91e-16 | NR | AQM51742.1 | 9043 | g24286 | i0 | 72.4 | 5.03305785123967 | 58 | 16 | 71.9 | 0 | 174 | 1 | 85 | 142 | AQM51742.1 NADH dehydrogenase subunit 2 [Lophura edwardsi] | diamond | 1218 | 82.8 | 0.990338164251208 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Lophura | Lophura edwardsi | |
| 26709618 | 26709618 | PRJNA999043_P_NODE_23261_length_246_cov_0.890173_g23166_i0 | PRJNA999043 | 23261 | 246 | 0.890173 | 2.18982558 | Meleagris gallopavo | 9103 | Chordata | Chordata | 43.1 | 0.0264 | NR | XP_031409115.1 | 9103 | g23166 | i0 | 45.3 | 0.646341463414634 | 53 | 29 | 64.6 | 0 | 62 | 220 | 265 | 317 | XP_031409115.1 protein mono-ADP-ribosyltransferase PARP14-like [Meleagris gallopavo] | diamond | 159 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Meleagris | Meleagris gallopavo | |
| 27247774 | 27247774 | PRJNA999043_P_NODE_23963_length_244_cov_0.871345_g23868_i0 | PRJNA999043 | 23963 | 244 | 0.871345 | 2.1260818 | Galendromus occidentalis | 34638 | Arthropoda | Arthropoda | 52.8 | 1.11e-5 | NR | XP_003737251.1 | 34638 | g23868 | i0 | 100 | 0.307377049180328 | 25 | 0 | 30.7 | 0 | 169 | 243 | 1 | 25 | XP_003737251.1 serine/threonine-protein kinase PAK 3 [Galendromus occidentalis] | diamond | 75 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Galendromus | Galendromus occidentalis | |
| 27632719 | 27632719 | PRJNA999043_P_NODE_24484_length_242_cov_0.911243_g24389_i0 | PRJNA999043 | 24484 | 242 | 0.911243 | 2.20520806 | Chordata | 7711 | Chordata | Chordata | 52.8 | 1.09e-5 | NR | XP_051779371.1 | 27687 | g24389 | i0 | 52.5 | 2.97520661157025 | 40 | 19 | 49.6 | 0 | 241 | 122 | 691 | 730 | XP_051779371.1 probable E3 ubiquitin-protein ligase HERC4 isoform X2 [Erpetoichthys calabaricus] | diamond | 720 | 53.1 | 0.994350282485876 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Erpetoichthys | Erpetoichthys calabaricus | |
| 27721969 | 27721969 | PRJNA999043_P_NODE_17784_length_304_cov_1.000000_g17689_i0 | PRJNA999043 | 17784 | 304 | 1 | 3.04 | Galendromus occidentalis | 34638 | Arthropoda | Arthropoda | 155 | 3.05e-42 | NR | XP_003740670.1 | 34638 | g17689 | i0 | 75.2 | 0.996710526315789 | 101 | 25 | 99.7 | 0 | 304 | 2 | 117 | 217 | XP_003740670.1 cholinesterase [Galendromus occidentalis] | diamond | 303 | 155 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Galendromus | Galendromus occidentalis | |
| 27727731 | 27727731 | PRJNA999043_P_NODE_22304_length_249_cov_0.875000_g22209_i0 | PRJNA999043 | 22304 | 249 | 0.875 | 2.17875 | Chordata | 7711 | Chordata | Chordata | 62.4 | 4.97e-9 | NR | XP_039909930.1 | 43150 | g22209 | i0 | 66.7 | 9.21686746987952 | 45 | 15 | 54.2 | 0 | 249 | 115 | 734 | 778 | XP_039909930.1 LOW QUALITY PROTEIN: stAR-related lipid transfer protein 13-like, partial [Hirundo rustica] | diamond | 2295 | 62.8 | 0.993630573248408 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Hirundinidae | Hirundo | Hirundo rustica | |
| 27847691 | 27847691 | PRJNA999043_P_NODE_20924_length_258_cov_0.859459_g20829_i0 | PRJNA999043 | 20924 | 258 | 0.859459 | 2.21740422 | Mycteria americana | 33587 | Chordata | Chordata | 87.4 | 1.04e-18 | NR | KAK4830788.1 | 33587 | g20829 | i0 | 62.5 | 1.67441860465116 | 72 | 27 | 83.7 | 0 | 221 | 6 | 172 | 243 | KAK4830788.1 hypothetical protein QYF61_013621 [Mycteria americana] | diamond | 432 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Ciconiiformes | Ciconiidae | Mycteria | Mycteria americana | |
| 27942640 | 27942640 | PRJNA999043_P_NODE_24885_length_241_cov_0.916667_g24790_i0 | PRJNA999043 | 24885 | 241 | 0.916667 | 2.20916747 | Galendromus occidentalis | 34638 | Arthropoda | Arthropoda | 43.9 | 0.0149 | NR | XP_028967959.1 | 34638 | g24790 | i0 | 59 | 0.485477178423237 | 39 | 16 | 48.5 | 0 | 8 | 124 | 1861 | 1899 | XP_028967959.1 titin homolog [Galendromus occidentalis] | diamond | 117 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Galendromus | Galendromus occidentalis | |
| 28763369 | 28763369 | PRJNA999043_P_NODE_17367_length_312_cov_0.857741_g17272_i0 | PRJNA999043 | 17367 | 312 | 0.857741 | 2.67615192 | Grus japonensis | 30415 | Chordata | Chordata | 65.9 | 2.14e-10 | NR | GAB0181774.1 | 30415 | g17272 | i0 | 41.1 | 3.43269230769231 | 90 | 53 | 86.5 | 0 | 272 | 3 | 94 | 183 | GAB0181774.1 hypothetical protein GRJ2_000642700 [Grus japonensis] | diamond | 1071 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Gruiformes | Gruidae | Grus | Grus japonensis | |
| 28794830 | 28794830 | PRJNA999043_P_NODE_24247_length_243_cov_0.905882_g24152_i0 | PRJNA999043 | 24247 | 243 | 0.905882 | 2.20129326 | Meira miltonrushii | 1280837 | Fungi | Fungi | 99.4 | 4.4800000000000005e-22 | NR | XP_025353979.1 | 1280837 | g24152 | i0 | 71.3 | 0.987654320987654 | 80 | 5 | 98.8 | 1 | 242 | 3 | 372 | 433 | XP_025353979.1 uncharacterized protein FA14DRAFT_147643 [Meira miltonrushii] | diamond | 240 | 99.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira miltonrushii | |
| 29457795 | 29457795 | PRJNA999043_P_NODE_22890_length_247_cov_0.885057_g22795_i0 | PRJNA999043 | 22890 | 247 | 0.885057 | 2.18609079 | Kockiozyma suomiensis | 1337062 | Fungi | Fungi | 64.7 | 7.19e-10 | NR | XP_066763481.1 | 1337062 | g22795 | i0 | 54.5 | 1.55465587044534 | 55 | 25 | 66.8 | 0 | 165 | 1 | 356 | 410 | XP_066763481.1 uncharacterized protein V2V93DRAFT_375430 [Kockiozyma suomiensis] | diamond | 384 | 64.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lipomycetes | Lipomycetales | Lipomycetaceae | Kockiozyma | Kockiozyma suomiensis | |
| 29653055 | 29653055 | PRJNA999043_P_NODE_23510_length_245_cov_0.895349_g23415_i0 | PRJNA999043 | 23510 | 245 | 0.895349 | 2.19360505 | Chordata | 7711 | Chordata | Chordata | 52.4 | 1.5e-5 | NR | XP_006001705.1 | 7897 | g23415 | i0 | 87.5 | 4.99591836734694 | 24 | 3 | 29.4 | 0 | 194 | 123 | 141 | 164 | XP_006001705.1 dual specificity protein kinase CLK2 [Latimeria chalumnae] | diamond | 1224 | 52.8 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Chordata | Coelacanthiformes | Coelacanthidae | Latimeria | Latimeria chalumnae | ||
| 30406088 | 30406088 | PRJNA999043_P_NODE_22533_length_248_cov_0.880000_g22438_i0 | PRJNA999043 | 22533 | 248 | 0.88 | 2.1824 | Ovis aries | 9940 | Chordata | Chordata | 63.5 | 1.82e-9 | NR | XDA77494.1 | 9940 | g22438 | i0 | 52.5 | 0.967741935483871 | 80 | 38 | 96.8 | 0 | 4 | 243 | 236 | 315 | XDA77494.1 hypothetical protein R6Z07_007693 [Ovis aries] | diamond | 240 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Bovidae | Ovis | Ovis aries | |
| 31100624 | 31100624 | PRJNA999043_P_NODE_13515_length_401_cov_2.320122_g13420_i0 | PRJNA999043 | 13515 | 401 | 2.320122 | 9.30368922 | Galendromus occidentalis | 34638 | Arthropoda | Arthropoda | 73.6 | 1.51e-13 | NR | XP_003739867.1 | 34638 | g13420 | i0 | 46.2 | 1.18204488778055 | 158 | 35 | 90.5 | 3 | 376 | 14 | 1 | 145 | XP_003739867.1 cuticle protein 16.5 [Galendromus occidentalis] | diamond | 474 | 73.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Galendromus | Galendromus occidentalis | |
| 31638260 | 31638260 | PRJNA999043_P_NODE_24496_length_242_cov_0.911243_g24401_i0 | PRJNA999043 | 24496 | 242 | 0.911243 | 2.20520806 | Alectoris rufa | 9079 | Chordata | Chordata | 47 | 7.54e-4 | NR | CAK6567702.1 | 9079 | g24401 | i0 | 41.9 | 0.768595041322314 | 62 | 29 | 68.2 | 1 | 59 | 223 | 133 | 194 | CAK6567702.1 unnamed protein product [Alectoris rufa] | diamond | 186 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Alectoris | Alectoris rufa | |
| 31859652 | 31859652 | PRJNA999043_P_NODE_16597_length_326_cov_3.189723_g16502_i0 | PRJNA999043 | 16597 | 326 | 3.189723 | 10.398496979999999 | Bufotes viridis | 30338 | Chordata | Chordata | 67 | 8.5e-11 | NR | CAK8641430.1 | 30338 | g16502 | i0 | 48.8 | 2.17177914110429 | 86 | 42 | 78.2 | 2 | 2 | 256 | 136 | 220 | CAK8641430.1 Transposable element Tc3 transposase [Bufotes viridis] | diamond | 708 | 67.4 | 0.99406528189911 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 31986200 | 31986200 | PRJNA999043_P_NODE_23958_length_244_cov_0.888889_g23863_i0 | PRJNA999043 | 23958 | 244 | 0.888889 | 2.16888916 | Alectoris rufa | 9079 | Chordata | Chordata | 48.5 | 8.88e-5 | NR | CAK6566379.1 | 9079 | g23863 | i0 | 64.5 | 0.762295081967213 | 31 | 11 | 38.1 | 0 | 113 | 205 | 77 | 107 | CAK6566379.1 unnamed protein product [Alectoris rufa] | diamond | 186 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Galliformes | Phasianidae | Alectoris | Alectoris rufa | |
| 32055394 | 32055394 | PRJNA999043_P_NODE_22498_length_248_cov_0.880000_g22403_i0 | PRJNA999043 | 22498 | 248 | 0.88 | 2.1824 | Varroa | 62624 | Arthropoda | Arthropoda | 170 | 1.26e-49 | NR | XP_022705918.1 | 62625 | g22403 | i0 | 95.1 | 2.9758064516129 | 82 | 4 | 99.2 | 0 | 247 | 2 | 170 | 251 | XP_022705918.1 synaptic vesicle membrane protein VAT-1 homolog-like isoform X2 [Varroa jacobsoni] | diamond | 738 | 170 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Varroidae | Varroa | Varroa jacobsoni | |
| 32271227 | 32271227 | PRJNA999043_P_NODE_21438_length_252_cov_1.290503_g21343_i0 | PRJNA999043 | 21438 | 252 | 1.290503 | 3.25206756 | Galendromus occidentalis | 34638 | Arthropoda | Arthropoda | 71.2 | 2.98e-12 | NR | XP_028967367.1 | 34638 | g21343 | i0 | 60.8 | 0.94047619047619 | 79 | 24 | 85.7 | 1 | 36 | 251 | 1 | 79 | XP_028967367.1 uncharacterized protein KIAA0754-like [Galendromus occidentalis] | diamond | 237 | 71.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Mesostigmata | Phytoseiidae | Galendromus | Galendromus occidentalis | |
| 32587574 | 32587574 | PRJNA999043_P_NODE_20939_length_257_cov_1.836957_g20844_i0 | PRJNA999043 | 20939 | 257 | 1.836957 | 4.72097949 | Seison nebaliae | 104778 | Rotifera | other_Eukaryota | 43.1 | 0.031 | NR | KAI3381297.1 | 104778 | g20844 | i0 | 33.3 | 0.770428015564202 | 66 | 40 | 72.4 | 2 | 38 | 223 | 52 | 117 | KAI3381297.1 hypothetical protein SNEBB_005489 [Seison nebaliae] | diamond | 198 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Pararotatoria | Seisonacea | Seisonidae | Seison | Seison nebaliae |
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);;