contig_metadata
14 rows where bioproject = "PRJNA800090", tax_kingdom = "Metazoa" and tax_phylum = "Platyhelminthes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10149892 | 10149892 | PRJNA800090_P_NODE_95608_length_335_cov_1.417293_g93423_i0 | PRJNA800090 | 95608 | 335 | 1.417293 | 4.74793155 | Dalyellia | 1311978 | Platyhelminthes | Platyhelminthes | 99 | 4e-16 | NTclustered | gi|472441160|gb|KC529574.1| | 1311979 | g93423 | i0 | 90.541 | 22.1611940298507 | 74 | 7 | 22 | 0 | 262 | 335 | 1410 | 1483 | Dalyellia tatrica isolate UH252.7 28S ribosomal RNA gene, partial sequence | blastn | 7424 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Rhabdocoela | Dalyelliidae | Dalyellia | Dalyellia tatrica | |
| 24172085 | 24172085 | PRJNA800090_P_NODE_164119_length_243_cov_1.344828_g161934_i0 | PRJNA800090 | 164119 | 243 | 1.344828 | 3.26793204 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 79.7 | 9.16e-16 | NR | CAH8431391.1 | 39320 | g161934 | i0 | 50 | 5.39506172839506 | 74 | 35 | 88.9 | 2 | 24 | 239 | 81 | 154 | CAH8431391.1 unnamed protein product [Heterobilharzia americana] | diamond | 1311 | 80.1 | 0.995006242197254 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana | |
| 27220801 | 27220801 | PRJNA800090_P_NODE_106402_length_314_cov_1.191837_g104217_i0 | PRJNA800090 | 106402 | 314 | 1.191837 | 3.74236818 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 48.5 | 7.95e-4 | NR | KAF8565987.1 | 34504 | g104217 | i0 | 43.3 | 4.05095541401274 | 67 | 36 | 62.1 | 2 | 64 | 258 | 14 | 80 | KAF8565987.1 hypothetical protein P879_01891 [Paragonimus westermani] | diamond | 1272 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 27695140 | 27695140 | PRJNA800090_P_NODE_176664_length_234_cov_1.036364_g174479_i0 | PRJNA800090 | 176664 | 234 | 1.036364 | 2.42509176 | root | 1 | Root_unresolved | Root_unresolved | 105 | 1.99e-24 | NR | KAF7258771.1 | 59628 | g174479 | i0 | 64.9 | 7.8974358974359 | 77 | 27 | 98.7 | 0 | 232 | 2 | 683 | 759 | KAF7258771.1 hypothetical protein EG68_03765 [Paragonimus skrjabini miyazakii] | diamond | 1848 | 106 | 0.990566037735849 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus skrjabini miyazakii | |
| 27884277 | 27884277 | PRJNA800090_P_NODE_181245_length_232_cov_1.766871_g179060_i0 | PRJNA800090 | 181245 | 232 | 1.766871 | 4.09914072 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 85.9 | 1.17e-18 | NR | THD22758.1 | 6192 | g179060 | i0 | 60 | 9.20689655172414 | 70 | 28 | 90.5 | 0 | 210 | 1 | 6 | 75 | THD22758.1 Ribosomal protein rpl13a [Fasciola hepatica] | diamond | 2136 | 85.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 29264423 | 29264423 | PRJNA800090_P_NODE_127149_length_282_cov_1.225352_g124964_i0 | PRJNA800090 | 127149 | 282 | 1.225352 | 3.45549264 | Echinococcus multilocularis | 6211 | Platyhelminthes | Platyhelminthes | 45.4 | 0.00588 | NR | CDS37392.1 | 6211 | g124964 | i0 | 39.4 | 1.47872340425532 | 71 | 31 | 71.3 | 4 | 81 | 281 | 206 | 268 | CDS37392.1 calbindin 32 [Echinococcus multilocularis] | diamond | 417 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus multilocularis | |
| 29769684 | 29769684 | PRJNA800090_P_NODE_152971_length_253_cov_1.690217_g150786_i0 | PRJNA800090 | 152971 | 253 | 1.690217 | 4.27624901 | Cichlidogyrus casuarinus | 1844966 | Platyhelminthes | Platyhelminthes | 43.1 | 0.00691 | NR | KAL3308385.1 | 1844966 | g150786 | i0 | 86.4 | 0.260869565217391 | 22 | 3 | 26.1 | 0 | 242 | 177 | 53 | 74 | KAL3308385.1 hypothetical protein Ciccas_013085 [Cichlidogyrus casuarinus] | diamond | 66 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus | |
| 29999976 | 29999976 | PRJNA800090_P_NODE_130271_length_277_cov_2.302885_g128086_i0 | PRJNA800090 | 130271 | 277 | 2.302885 | 6.37899145 | Hymenolepididae | 6214 | Platyhelminthes | Platyhelminthes | 51.2 | 4.62e-5 | NR | CDS31946.1 | 85433 | g128086 | i0 | 40.5 | 2.43682310469314 | 74 | 38 | 79.1 | 3 | 226 | 8 | 179 | 247 | CDS31946.1 calbindin 32 [Hymenolepis microstoma] | diamond | 675 | 51.6 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 30031504 | 30031504 | PRJNA800090_P_NODE_18711_length_928_cov_5.381839_g17008_i0 | PRJNA800090 | 18711 | 928 | 5.381839 | 49.94346592 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 317 | 1.8e-104 | NR | VDD81745.1 | 53468 | g17008 | i0 | 61.4 | 8.89008620689655 | 272 | 90 | 87.9 | 2 | 72 | 887 | 1 | 257 | VDD81745.1 unnamed protein product, partial [Mesocestoides corti] | diamond | 8250 | 317 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti | |
| 30157590 | 30157590 | PRJNA800090_P_NODE_97812_length_330_cov_2.145594_g95627_i0 | PRJNA800090 | 97812 | 330 | 2.145594 | 7.0804602 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 95.5 | 5.66e-22 | NR | THD22313.1 | 6192 | g95627 | i0 | 50.5 | 9.92727272727273 | 91 | 44 | 82.7 | 1 | 276 | 4 | 16 | 105 | THD22313.1 Calponin transgelin [Fasciola hepatica] | diamond | 3276 | 96.3 | 0.991692627206646 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 31643111 | 31643111 | PRJNA800090_P_NODE_154096_length_252_cov_1.573770_g151911_i0 | PRJNA800090 | 154096 | 252 | 1.57377 | 3.9659004 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 47.4 | 9.93e-4 | NR | XP_009162112.1 | 6198 | g151911 | i0 | 37 | 6.89285714285714 | 81 | 48 | 94 | 2 | 237 | 1 | 11 | 90 | XP_009162112.1 hypothetical protein T265_12432, partial [Opisthorchis viverrini] | diamond | 1737 | 47.8 | 0.99163179916318 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 32140594 | 32140594 | PRJNA800090_P_NODE_193198_length_228_cov_0.905660_g191013_i0 | PRJNA800090 | 193198 | 228 | 0.90566 | 2.0649048 | Schistosoma mattheei | 31246 | Platyhelminthes | Platyhelminthes | 90.9 | 3.53e-19 | NR | VDP49313.1 | 31246 | g191013 | i0 | 80.4 | 6.78947368421053 | 56 | 11 | 73.7 | 0 | 228 | 61 | 693 | 748 | VDP49313.1 unnamed protein product [Schistosoma mattheei] | diamond | 1548 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mattheei | |
| 32181237 | 32181237 | PRJNA800090_P_NODE_160018_length_247_cov_1.005618_g157833_i0 | PRJNA800090 | 160018 | 247 | 1.005618 | 2.48387646 | root | 1 | Root_unresolved | Root_unresolved | 81.3 | 1.08e-15 | NR | CAH8477542.1 | 57078 | g157833 | i0 | 47.6 | 5.93927125506073 | 82 | 38 | 93.5 | 1 | 234 | 4 | 244 | 325 | CAH8477542.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 1467 | 82 | 0.991463414634146 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 32552100 | 32552100 | PRJNA800090_P_NODE_109719_length_308_cov_1.707113_g107534_i0 | PRJNA800090 | 109719 | 308 | 1.707113 | 5.25790804 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 58.9 | 7.88e-8 | NR | CAL5135167.1 | 300641 | g107534 | i0 | 39.8 | 3.42857142857143 | 88 | 53 | 85.7 | 0 | 264 | 1 | 11 | 98 | CAL5135167.1 unnamed protein product [Calicophoron daubneyi] | diamond | 1056 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi |
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);;