contig_metadata
12 rows where bioproject = "PRJNA207719" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6158752 | 6158752 | PRJNA207719_P_NODE_905_length_201_cov_3.046512_g885_i0 | PRJNA207719 | 905 | 201 | 3.046512 | 6.12348912 | Gyrodactylidae | 37845 | Platyhelminthes | Platyhelminthes | 355 | 1.19e-93 | NTclustered | gi|44885231|emb|AJ542394.1| | 37629 | g885 | i0 | 98.515 | 102.194029850746 | 202 | 2 | 100 | 1 | 1 | 201 | 3192 | 2991 | Gyrodactylus salaris 28S rRNA gene | blastn | 20541 | 355 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Gyrodactylidea | Gyrodactylidae | Gyrodactylus | Gyrodactylus salaris | |
| 8020474 | 8020474 | PRJNA207719_P_NODE_307_length_384_cov_3.129577_g287_i0 | PRJNA207719 | 307 | 384 | 3.129577 | 12.01757568 | Cichlidogyrus casuarinus | 1844966 | Platyhelminthes | Platyhelminthes | 174 | 6.93e-52 | NR | KAL3316812.1 | 1844966 | g287 | i0 | 69.5 | 1 | 128 | 39 | 100 | 0 | 384 | 1 | 57 | 184 | KAL3316812.1 hypothetical protein Ciccas_004541 [Cichlidogyrus casuarinus] | diamond | 384 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus | |
| 20768583 | 20768583 | PRJNA207719_P_NODE_1297_length_155_cov_1.730159_g1277_i0 | PRJNA207719 | 1297 | 155 | 1.730159 | 2.68174645 | Cichlidogyrus casuarinus | 1844966 | Platyhelminthes | Platyhelminthes | 88.6 | 6.24e-19 | NR | KAL3314241.1 | 1844966 | g1277 | i0 | 69.2 | 12.7161290322581 | 65 | 5 | 96.8 | 1 | 153 | 4 | 113 | 177 | KAL3314241.1 60S ribosomal protein L4 [Cichlidogyrus casuarinus] | diamond | 1971 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus | |
| 20768584 | 20768584 | PRJNA207719_P_NODE_357_length_357_cov_2.597561_g337_i0 | PRJNA207719 | 357 | 357 | 2.597561 | 9.27329277 | Gyrodactylus macracanthus | 607939 | Platyhelminthes | Platyhelminthes | 238 | 1.78e-77 | NR | ACT54579.1 | 607939 | g337 | i0 | 95.8 | 0.991596638655462 | 118 | 5 | 99.2 | 0 | 2 | 355 | 24 | 141 | ACT54579.1 elongation factor 1 alpha, partial [Gyrodactylus macracanthus] | diamond | 354 | 238 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Gyrodactylidea | Gyrodactylidae | Macracanthus | Macracanthus macracanthus | |
| 22043643 | 22043643 | PRJNA207719_P_NODE_1098_length_177_cov_2.952703_g1078_i0 | PRJNA207719 | 1098 | 177 | 2.952703 | 5.22628431 | Cichlidogyrus casuarinus | 1844966 | Platyhelminthes | Platyhelminthes | 94 | 1.07e-21 | NR | KAL3316812.1 | 1844966 | g1078 | i0 | 78.9 | 0.966101694915254 | 57 | 12 | 96.6 | 0 | 177 | 7 | 192 | 248 | KAL3316812.1 hypothetical protein Ciccas_004541 [Cichlidogyrus casuarinus] | diamond | 171 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus | |
| 24593298 | 24593298 | PRJNA207719_P_NODE_400_length_330_cov_2.109635_g380_i0 | PRJNA207719 | 400 | 330 | 2.109635 | 6.9617955 | Macrogyrodactylus karibae | 696689 | Platyhelminthes | Platyhelminthes | 383 | 9.699999999999998e-102 | NTclustered | gi|1346678829|gb|MG973078.1| | 696689 | g380 | i0 | 87.651 | 35.9757575757576 | 332 | 38 | 100 | 3 | 1 | 330 | 6235 | 6565 | Macrogyrodactylus karibae isolate M_ka small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 11872 | 383 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Gyrodactylidea | Gyrodactylidae | Macrogyrodactylus | Macrogyrodactylus karibae | |
| 26806969 | 26806969 | PRJNA207719_P_NODE_881_length_206_cov_2.056497_g861_i0 | PRJNA207719 | 881 | 206 | 2.056497 | 4.23638382 | Cyclophyllidea | 6201 | Platyhelminthes | Platyhelminthes | 101 | 1.95e-26 | NR | KAH9280715.1 | 6210 | g861 | i0 | 95.6 | 1.98058252427184 | 68 | 3 | 99 | 0 | 2 | 205 | 3 | 70 | KAH9280715.1 hypothetical protein ECG_07396 [Echinococcus granulosus] | diamond | 408 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 27642839 | 27642839 | PRJNA207719_P_NODE_1244_length_161_cov_1.621212_g1224_i0 | PRJNA207719 | 1244 | 161 | 1.621212 | 2.61015132 | Echinostoma caproni | 27848 | Platyhelminthes | Platyhelminthes | 67 | 1.48e-12 | NR | VDP93666.1 | 27848 | g1224 | i0 | 64.7 | 3.80124223602484 | 51 | 18 | 95 | 0 | 8 | 160 | 7 | 57 | VDP93666.1 unnamed protein product [Echinostoma caproni] | diamond | 612 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinostoma | Echinostoma caproni | |
| 28116142 | 28116142 | PRJNA207719_P_NODE_465_length_306_cov_2.808664_g445_i0 | PRJNA207719 | 465 | 306 | 2.808664 | 8.59451184 | Hymenolepis microstoma | 85433 | Platyhelminthes | Platyhelminthes | 42.4 | 0.0118 | NR | CDS27476.1 | 85433 | g445 | i0 | 46.5 | 0.42156862745098 | 43 | 19 | 38.2 | 1 | 299 | 183 | 1 | 43 | CDS27476.1 expressed protein [Hymenolepis microstoma] | diamond | 129 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 28955176 | 28955176 | PRJNA207719_P_NODE_688_length_241_cov_3.452830_g668_i0 | PRJNA207719 | 688 | 241 | 3.45283 | 8.3213203 | Cyclophyllidea | 6201 | Platyhelminthes | Platyhelminthes | 77.4 | 1.26e-16 | NR | KAH9280715.1 | 6210 | g668 | i0 | 92.1 | 0.946058091286307 | 38 | 3 | 47.3 | 0 | 237 | 124 | 8 | 45 | KAH9280715.1 hypothetical protein ECG_07396 [Echinococcus granulosus] | diamond | 228 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 30471068 | 30471068 | PRJNA207719_P_NODE_1173_length_169_cov_1.885714_g1153_i0 | PRJNA207719 | 1173 | 169 | 1.885714 | 3.18685666 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 110 | 1.7500000000000002e-26 | NR | QGN03550.1 | 6161 | g1153 | i0 | 94.5 | 158.165680473373 | 55 | 3 | 97.6 | 0 | 3 | 167 | 35 | 89 | QGN03550.1 heat shock protein 70-2 [Dugesia japonica] | diamond | 26730 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 32287289 | 32287289 | PRJNA207719_P_NODE_1319_length_153_cov_1.790323_g1299_i0 | PRJNA207719 | 1319 | 153 | 1.790323 | 2.73919419 | Cichlidogyrus casuarinus | 1844966 | Platyhelminthes | Platyhelminthes | 80.5 | 5.26e-16 | NR | KAL3309952.1 | 1844966 | g1299 | i0 | 72 | 4.90196078431373 | 50 | 14 | 98 | 0 | 151 | 2 | 607 | 656 | KAL3309952.1 Elongation factor 2, partial [Cichlidogyrus casuarinus] | diamond | 750 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus |
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);;