contig_metadata
8 rows where analysis = "diamond", bioproject = "PRJEB20058" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26565071 | 26565071 | PRJEB20058_P_NODE_158072_length_302_cov_9.078838_g155249_i0 | PRJEB20058 | 158072 | 302 | 9.078838 | 27.41809076 | Rodentolepis nana | 102285 | Platyhelminthes | Platyhelminthes | 170 | 1.85e-52 | NR | VDN95956.1 | 102285 | g155249 | i0 | 96.3 | 0.814569536423841 | 82 | 3 | 81.5 | 0 | 281 | 36 | 49 | 130 | VDN95956.1 unnamed protein product [Rodentolepis nana] | diamond | 246 | 170 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Rodentolepis | Rodentolepis nana | |
| 32910590 | 32910590 | PRJEB20058_P_NODE_141697_length_326_cov_2.577358_g138876_i0 | PRJEB20058 | 141697 | 326 | 2.577358 | 8.40218708 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 142 | 1.86e-40 | NR | AAX25032.2 | 6182 | g138876 | i0 | 89.6 | 0.708588957055215 | 77 | 8 | 70.9 | 0 | 8 | 238 | 111 | 187 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 231 | 142 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32922955 | 32922955 | PRJEB20058_P_NODE_87257_length_441_cov_2.026316_g84467_i0 | PRJEB20058 | 87257 | 441 | 2.026316 | 8.93605356 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 145 | 8.01e-38 | NR | CAH8616825.1 | 57078 | g84467 | i0 | 53 | 11.8367346938776 | 134 | 60 | 91.2 | 1 | 428 | 27 | 80 | 210 | CAH8616825.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 5220 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 32974272 | 32974272 | PRJEB20058_P_NODE_137882_length_332_cov_3.630996_g135061_i0 | PRJEB20058 | 137882 | 332 | 3.630996 | 12.05490672 | Hymenolepis | 6215 | Platyhelminthes | Platyhelminthes | 131 | 9.57e-34 | NR | VUZ43496.1 | 6216 | g135061 | i0 | 84.1 | 1.2289156626506 | 69 | 11 | 62.3 | 0 | 64 | 270 | 361 | 429 | VUZ43496.1 unnamed protein product [Hymenolepis diminuta] | diamond | 408 | 132 | 0.992424242424242 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 33030272 | 33030272 | PRJEB20058_P_NODE_140012_length_328_cov_58.955056_g137191_i0 | PRJEB20058 | 140012 | 328 | 58.955056 | 193.37258368 | Hymenolepis diminuta | 6216 | Platyhelminthes | Platyhelminthes | 171 | 9.3e-53 | NR | VDL57338.1 | 6216 | g137191 | i0 | 88 | 0.841463414634146 | 92 | 11 | 84.1 | 0 | 15 | 290 | 18 | 109 | VDL57338.1 unnamed protein product [Hymenolepis diminuta] | diamond | 276 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 33076524 | 33076524 | PRJEB20058_P_NODE_186453_length_269_cov_1.350962_g183630_i0 | PRJEB20058 | 186453 | 269 | 1.350962 | 3.63408778 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 113 | 8.850000000000001e-27 | NR | CAH8547834.1 | 6184 | g183630 | i0 | 57.8 | 12.8810408921933 | 83 | 35 | 92.6 | 0 | 268 | 20 | 662 | 744 | CAH8547834.1 unnamed protein product [Schistosoma bovis] | diamond | 3465 | 114 | 0.991228070175439 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma bovis | |
| 33098551 | 33098551 | PRJEB20058_P_NODE_160958_length_298_cov_27.936709_g158135_i0 | PRJEB20058 | 160958 | 298 | 27.936709 | 83.25139282 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 75.9 | 1.69e-13 | NR | TNN20133.1 | 6182 | g158135 | i0 | 44.1 | 1.80201342281879 | 102 | 38 | 83.6 | 4 | 297 | 49 | 997 | 1098 | TNN20133.1 Tyrosyl-DNA phosphodiesterase 1 isoform 2 [Schistosoma japonicum] | diamond | 537 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 33150656 | 33150656 | PRJEB20058_P_NODE_99024_length_409_cov_176.606322_g96218_i0 | PRJEB20058 | 99024 | 409 | 176.606322 | 722.31985698 | Alloglossidium progeneticum | 1748108 | Platyhelminthes | Platyhelminthes | 45.4 | 0.017 | NR | ALM03067.1 | 1748108 | g96218 | i0 | 43.4 | 0.557457212713936 | 76 | 34 | 49.1 | 2 | 98 | 298 | 120 | 195 | ALM03067.1 NADH dehydrogenase subunit 1, partial [Alloglossidium progeneticum] | diamond | 228 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Alloglossidiidae | Alloglossidium | Alloglossidium progeneticum |
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);;