contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA993416" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27095527 | 27095527 | PRJNA993416_P_NODE_15202_length_244_cov_0.871345_g15097_i0 | PRJNA993416 | 15202 | 244 | 0.871345 | 2.1260818 | root | 1 | Root_unresolved | Root_unresolved | 128 | 3.46e-32 | NR | XP_023324937.1 | 1294199 | g15097 | i0 | 76.5 | 2.98770491803279 | 81 | 19 | 99.6 | 0 | 2 | 244 | 298 | 378 | XP_023324937.1 vigilin [Eurytemora carolleeae] | diamond | 729 | 128 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Hexanauplia | Calanoida | Temoridae | Eurytemora | Eurytemora carolleeae | |
| 27474750 | 27474750 | PRJNA993416_P_NODE_15683_length_242_cov_0.952663_g15578_i0 | PRJNA993416 | 15683 | 242 | 0.952663 | 2.30544446 | Anura | 8342 | Chordata | Chordata | 62 | 5.94e-9 | NR | XP_053548577.1 | 8345 | g15578 | i0 | 52.9 | 66.8181818181818 | 70 | 33 | 86.8 | 0 | 13 | 222 | 551 | 620 | XP_053548577.1 ubiquitin thioesterase ZRANB1 [Bombina bombina] | diamond | 16170 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bombinatoridae | Bombina | Bombina bombina | |
| 27753258 | 27753258 | PRJNA993416_P_NODE_11104_length_264_cov_1.193717_g10999_i0 | PRJNA993416 | 11104 | 264 | 1.193717 | 3.15141288 | Ixodes hexagonus | 34612 | Arthropoda | Arthropoda | 63.5 | 2.17e-9 | NR | CAL6191666.1 | 34612 | g10999 | i0 | 62.5 | 1.14772727272727 | 48 | 18 | 54.5 | 0 | 107 | 250 | 402 | 449 | CAL6191666.1 unnamed protein product, partial [Ixodes hexagonus] | diamond | 303 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Arachnida | Ixodida | Ixodidae | Ixodes | Ixodes hexagonus | |
| 28258083 | 28258083 | PRJNA993416_P_NODE_6066_length_338_cov_1.596226_g5961_i0 | PRJNA993416 | 6066 | 338 | 1.596226 | 5.39524388 | Echinostoma caproni | 27848 | Platyhelminthes | Platyhelminthes | 42.4 | 0.0417 | NR | VDP22364.1 | 27848 | g5961 | i0 | 35.7 | 0.745562130177515 | 84 | 43 | 66.6 | 2 | 14 | 238 | 29 | 110 | VDP22364.1 unnamed protein product [Echinostoma caproni] | diamond | 252 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinostoma | Echinostoma caproni | |
| 28384504 | 28384504 | PRJNA993416_P_NODE_2806_length_511_cov_6.374429_g2701_i0 | PRJNA993416 | 2806 | 511 | 6.374429 | 32.57333219 | Bufotes viridis | 30338 | Chordata | Chordata | 80.5 | 4.64e-15 | NR | CAK8641430.1 | 30338 | g2701 | i0 | 53.8 | 0.469667318982387 | 80 | 35 | 46.4 | 2 | 1 | 237 | 142 | 220 | CAK8641430.1 Transposable element Tc3 transposase [Bufotes viridis] | diamond | 240 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 28731900 | 28731900 | PRJNA993416_P_NODE_10287_length_271_cov_2.318182_g10182_i0 | PRJNA993416 | 10287 | 271 | 2.318182 | 6.28227322 | Apaloderma vittatum | 57397 | Chordata | Chordata | 59.3 | 9.7e-9 | NR | XP_009873761.1 | 57397 | g10182 | i0 | 58.3 | 0.929889298892989 | 84 | 35 | 93 | 0 | 15 | 266 | 1 | 84 | XP_009873761.1 PREDICTED: F-box/LRR-repeat protein 14, partial [Apaloderma vittatum] | diamond | 252 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Trogoniformes | Trogonidae | Apaloderma | Apaloderma vittatum | |
| 28858049 | 28858049 | PRJNA993416_P_NODE_2008_length_609_cov_3.503731_g1906_i0 | PRJNA993416 | 2008 | 609 | 3.503731 | 21.33772179 | Bufotes viridis | 30338 | Chordata | Chordata | 110 | 5.35e-26 | NR | CAK8641430.1 | 30338 | g1906 | i0 | 52.3 | 0.916256157635468 | 111 | 51 | 54.2 | 2 | 6 | 335 | 111 | 220 | CAK8641430.1 Transposable element Tc3 transposase [Bufotes viridis] | diamond | 558 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 28895490 | 28895490 | PRJNA993416_P_NODE_12748_length_250_cov_0.870056_g12643_i0 | PRJNA993416 | 12748 | 250 | 0.870056 | 2.17514 | Chordata | 7711 | Chordata | Chordata | 169 | 6.78e-48 | NR | KAJ1131131.1 | 8319 | g12643 | i0 | 100 | 113.16 | 82 | 0 | 98.4 | 0 | 248 | 3 | 265 | 346 | KAJ1131131.1 hypothetical protein NDU88_009474 [Pleurodeles waltl] | diamond | 28290 | 169 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl | |
| 29047705 | 29047705 | PRJNA993416_P_NODE_12388_length_251_cov_0.865169_g12283_i0 | PRJNA993416 | 12388 | 251 | 0.865169 | 2.17157419 | Manis pentadactyla | 143292 | Chordata | Chordata | 108 | 5.899999999999999e-26 | NR | KAI5133326.1 | 143292 | g12283 | i0 | 63.4 | 40.1832669322709 | 82 | 30 | 98 | 0 | 1 | 246 | 262 | 343 | KAI5133326.1 Tubulin Alpha-3D Chain [Manis pentadactyla] | diamond | 10086 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Pholidota | Manidae | Manis | Manis pentadactyla | |
| 29394967 | 29394967 | PRJNA993416_P_NODE_2009_length_609_cov_3.324627_g1906_i1 | PRJNA993416 | 2009 | 609 | 3.324627 | 20.24697843 | Bufotes viridis | 30338 | Chordata | Chordata | 110 | 5.35e-26 | NR | CAK8641430.1 | 30338 | g1906 | i1 | 52.3 | 0.916256157635468 | 111 | 51 | 54.2 | 2 | 6 | 335 | 111 | 220 | CAK8641430.1 Transposable element Tc3 transposase [Bufotes viridis] | diamond | 558 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 29678725 | 29678725 | PRJNA993416_P_NODE_10250_length_272_cov_1.276382_g10145_i0 | PRJNA993416 | 10250 | 272 | 1.276382 | 3.47175904 | Thrips palmi | 161013 | Arthropoda | Arthropoda | 152 | 3.26e-45 | NR | XP_034255971.1 | 161013 | g10145 | i0 | 78.9 | 1.98529411764706 | 90 | 19 | 99.3 | 0 | 3 | 272 | 22 | 111 | XP_034255971.1 60S ribosomal protein L14 isoform X2 [Thrips palmi] | diamond | 540 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Thysanoptera | Thripidae | Thrips | Thrips palmi | |
| 30057932 | 30057932 | PRJNA993416_P_NODE_16591_length_229_cov_2.448718_g16486_i0 | PRJNA993416 | 16591 | 229 | 2.448718 | 5.60756422 | Polypterus senegalus | 55291 | Chordata | Chordata | 148 | 1.9e-39 | NR | KAG2469874.1 | 55291 | g16486 | i0 | 100 | 25.5458515283843 | 75 | 0 | 98.3 | 0 | 227 | 3 | 2122 | 2196 | KAG2469874.1 SPTN1 protein, partial [Polypterus senegalus] | diamond | 5850 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 30253820 | 30253820 | PRJNA993416_P_NODE_12072_length_253_cov_4.211111_g11967_i0 | PRJNA993416 | 12072 | 253 | 4.211111 | 10.65411083 | Amphibia | 8292 | Chordata | Chordata | 102 | 1.87e-23 | NR | KAJ1132056.1 | 8319 | g11967 | i0 | 65.1 | 36.4150197628459 | 83 | 29 | 98.4 | 0 | 3 | 251 | 162 | 244 | KAJ1132056.1 hypothetical protein NDU88_010386 [Pleurodeles waltl] | diamond | 9213 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Caudata | Salamandridae | Pleurodeles | Pleurodeles waltl | |
| 30406039 | 30406039 | PRJNA993416_P_NODE_9953_length_274_cov_3.129353_g9848_i0 | PRJNA993416 | 9953 | 274 | 3.129353 | 8.57442722 | Polypterus senegalus | 55291 | Chordata | Chordata | 111 | 2.25e-26 | NR | KAG2463490.1 | 55291 | g9848 | i0 | 65.2 | 68.6058394160584 | 89 | 31 | 97.4 | 0 | 269 | 3 | 101 | 189 | KAG2463490.1 PRPS1 pyrophosphokinase, partial [Polypterus senegalus] | diamond | 18798 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Cladistia | Polypteriformes | Polypteridae | Polypterus | Polypterus senegalus | |
| 31043745 | 31043745 | PRJNA993416_P_NODE_16015_length_241_cov_1.732143_g15910_i0 | PRJNA993416 | 16015 | 241 | 1.732143 | 4.17446463 | Metazoa | 33208 | Rotifera | other_Eukaryota | 50.1 | 9.26e-5 | NR | RMZ94862.1 | 10195 | g15910 | i0 | 50 | 1.39419087136929 | 44 | 22 | 54.8 | 0 | 148 | 17 | 227 | 270 | RMZ94862.1 serine protease 27-like [Brachionus plicatilis] | diamond | 336 | 50.4 | 0.994047619047619 | Eukaryota | Opisthokonta | Metazoa | Rotifera | Eurotatoria | Ploima | Brachionidae | Brachionus | Brachionus plicatilis | |
| 31069344 | 31069344 | PRJNA993416_P_NODE_16335_length_241_cov_0.821429_g16230_i0 | PRJNA993416 | 16335 | 241 | 0.821429 | 1.97964389 | Rhinatrema bivittatum | 194408 | Chordata | Chordata | 61.6 | 7.99e-9 | NR | XP_029463040.1 | 194408 | g16230 | i0 | 52.3 | 7.28215767634855 | 65 | 31 | 80.9 | 0 | 240 | 46 | 188 | 252 | XP_029463040.1 methionine--tRNA ligase, mitochondrial isoform X2 [Rhinatrema bivittatum] | diamond | 1755 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Gymnophiona | Rhinatrematidae | Rhinatrema | Rhinatrema bivittatum | |
| 31195111 | 31195111 | PRJNA993416_P_NODE_15655_length_242_cov_1.366864_g15550_i0 | PRJNA993416 | 15655 | 242 | 1.366864 | 3.30781088 | Bufotes viridis | 30338 | Chordata | Chordata | 173 | 2.0099999999999998e-52 | NR | CAK8659804.1 | 30338 | g15550 | i0 | 97.5 | 18.8057851239669 | 80 | 2 | 99.2 | 0 | 241 | 2 | 115 | 194 | CAK8659804.1 Proteasome subunit beta type-3, partial [Bufotes viridis] | diamond | 4551 | 174 | 0.994252873563218 | Eukaryota | Opisthokonta | Metazoa | Chordata | Amphibia | Anura | Bufonidae | Bufotes | Bufotes viridis | |
| 31227002 | 31227002 | PRJNA993416_P_NODE_14655_length_245_cov_0.895349_g14550_i0 | PRJNA993416 | 14655 | 245 | 0.895349 | 2.19360505 | Chironomus riparius | 315576 | Arthropoda | Arthropoda | 89 | 2.08e-18 | NR | CAG9799483.1 | 315576 | g14550 | i0 | 55.7 | 0.96734693877551 | 79 | 30 | 96.7 | 2 | 239 | 3 | 331 | 404 | CAG9799483.1 unnamed protein product [Chironomus riparius] | diamond | 237 | 89 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Chironomus | Chironomus riparius | |
| 31385442 | 31385442 | PRJNA993416_P_NODE_13696_length_248_cov_0.862857_g13591_i0 | PRJNA993416 | 13696 | 248 | 0.862857 | 2.13988536 | Chironomus riparius | 315576 | Arthropoda | Arthropoda | 107 | 7.02e-25 | NR | CAG9804166.1 | 315576 | g13591 | i0 | 59.3 | 0.979838709677419 | 81 | 33 | 98 | 0 | 3 | 245 | 101 | 181 | CAG9804166.1 unnamed protein product [Chironomus riparius] | diamond | 243 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Diptera | Chironomidae | Chironomus | Chironomus riparius | |
| 31764810 | 31764810 | PRJNA993416_P_NODE_7097_length_310_cov_3.548523_g6992_i0 | PRJNA993416 | 7097 | 310 | 3.548523 | 11.0004213 | Halocaridina rubra | 373956 | Arthropoda | Arthropoda | 66.6 | 3.32e-10 | NR | KAK7081739.1 | 373956 | g6992 | i0 | 56 | 3.83225806451613 | 50 | 22 | 48.4 | 0 | 2 | 151 | 309 | 358 | KAK7081739.1 hypothetical protein SK128_005861 [Halocaridina rubra] | diamond | 1188 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Malacostraca | Decapoda | Atyidae | Halocaridina | Halocaridina rubra | |
| 31796258 | 31796258 | PRJNA993416_P_NODE_14397_length_246_cov_0.890173_g14292_i0 | PRJNA993416 | 14397 | 246 | 0.890173 | 2.18982558 | Monodon monoceros | 40151 | Chordata | Chordata | 119 | 1.16e-31 | NR | TKC53834.1 | 40151 | g14292 | i0 | 88.6 | 61.8780487804878 | 70 | 6 | 85.4 | 1 | 246 | 37 | 82 | 149 | TKC53834.1 hypothetical protein EI555_018584, partial [Monodon monoceros] | diamond | 15222 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Artiodactyla | Monodontidae | Monodon | Monodon monoceros | |
| 31802161 | 31802161 | PRJNA993416_P_NODE_7117_length_310_cov_2.810127_g7012_i0 | PRJNA993416 | 7117 | 310 | 2.810127 | 8.7113937 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 46.2 | 0.005 | NR | XP_037869477.1 | 7091 | g7012 | i0 | 50 | 6.09677419354839 | 42 | 21 | 40.6 | 0 | 308 | 183 | 1337 | 1378 | XP_037869477.1 uncharacterized protein LOC101741169 isoform X1 [Bombyx mori] | diamond | 1890 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Arthropoda | Insecta | Lepidoptera | Bombycidae | Bombyx | Bombyx mori | |
| 31897263 | 31897263 | PRJNA993416_P_NODE_12717_length_250_cov_1.305085_g12612_i0 | PRJNA993416 | 12717 | 250 | 1.305085 | 3.2627125 | Aves | 8782 | Chordata | Chordata | 116 | 1.7699999999999999e-28 | NR | XP_040431241.1 | 8869 | g12612 | i0 | 94.4 | 12.792 | 54 | 3 | 64.8 | 0 | 88 | 249 | 114 | 167 | XP_040431241.1 actin-related protein 2/3 complex subunit 1B isoform X1 [Cygnus olor] | diamond | 3198 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Anseriformes | Anatidae | Cygnus | Cygnus olor | |
| 31992150 | 31992150 | PRJNA993416_P_NODE_14418_length_246_cov_0.878613_g14313_i0 | PRJNA993416 | 14418 | 246 | 0.878613 | 2.16138798 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 102 | 4.9e-25 | NR | CAD22112.1 | 6317 | g14313 | i0 | 69.3 | 365.390243902439 | 75 | 23 | 91.5 | 0 | 2 | 226 | 114 | 188 | CAD22112.1 tubulin, partial [Ostertagia ostertagi] | diamond | 89886 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Nematoda | Chromadorea | Rhabditida | Trichostrongylidae | Ostertagia | Ostertagia ostertagi | |
| 32467065 | 32467065 | PRJNA993416_P_NODE_16619_length_227_cov_3.474026_g16514_i0 | PRJNA993416 | 16619 | 227 | 3.474026 | 7.88603902 | Mammalia | 40674 | Chordata | Chordata | 77.4 | 1.52e-14 | NR | XP_006895653.1 | 28737 | g16514 | i0 | 58.1 | 233.484581497797 | 74 | 31 | 97.8 | 0 | 2 | 223 | 172 | 245 | XP_006895653.1 PREDICTED: tubulin alpha-4A chain-like [Elephantulus edwardii] | diamond | 53001 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Chordata | Mammalia | Macroscelidea | Macroscelididae | Elephantulus | Elephantulus edwardii | |
| 32876570 | 32876570 | PRJNA993416_P_NODE_8520_length_287_cov_1.079439_g8415_i0 | PRJNA993416 | 8520 | 287 | 1.079439 | 3.09798993 | Zosterops | 36298 | Chordata | Chordata | 183 | 1.3799999999999999e-52 | NR | TRZ09930.1 | 364589 | g8415 | i0 | 88.4 | 24.8257839721254 | 95 | 11 | 99.3 | 0 | 2 | 286 | 426 | 520 | TRZ09930.1 hypothetical protein HGM15179_017189 [Zosterops borbonicus] | diamond | 7125 | 184 | 0.994565217391304 | Eukaryota | Opisthokonta | Metazoa | Chordata | Aves | Passeriformes | Zosteropidae | Zosterops | Zosterops borbonicus |
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);;