contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA725806" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1987716 | 1987716 | PRJNA725806_P_NODE_10342_length_372_cov_4.400000_g10054_i0 | PRJNA725806 | 10342 | 372 | 4.4 | 16.368 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 189 | 4.709999999999999e-53 | NR | CAH8535350.1 | 57078 | g10054 | i0 | 72.4 | 8.92741935483871 | 123 | 34 | 99.2 | 0 | 371 | 3 | 263 | 385 | CAH8535350.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 3321 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 17289708 | 17289708 | PRJNA725806_P_NODE_103994_length_194_cov_6.331210_g103692_i0 | PRJNA725806 | 103994 | 194 | 6.33121 | 12.2825474 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 129 | 6.599999999999999e-33 | NR | TNN20003.1 | 6182 | g103692 | i0 | 93.8 | 113.752577319588 | 64 | 4 | 99 | 0 | 2 | 193 | 1547 | 1610 | TNN20003.1 Dynein heavy chain 6, axonemal, partial [Schistosoma japonicum] | diamond | 22068 | 130 | 0.992307692307692 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 26904476 | 26904476 | PRJNA725806_P_NODE_63481_length_230_cov_14.497409_g63183_i0 | PRJNA725806 | 63481 | 230 | 14.497409 | 33.3440407 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 45.1 | 0.00488 | NR | CAH8429417.1 | 6184 | g63183 | i0 | 46.7 | 3.52173913043478 | 45 | 24 | 58.7 | 0 | 76 | 210 | 658 | 702 | CAH8429417.1 unnamed protein product [Schistosoma bovis] | diamond | 810 | 45.4 | 0.993392070484582 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma bovis | |
| 28220715 | 28220715 | PRJNA725806_P_NODE_9946_length_376_cov_1.339233_g9659_i0 | PRJNA725806 | 9946 | 376 | 1.339233 | 5.03551608 | Hymenolepis microstoma | 85433 | Platyhelminthes | Platyhelminthes | 190 | 9.83e-54 | NR | CDS27897.2 | 85433 | g9659 | i0 | 69.7 | 19.1489361702128 | 122 | 37 | 97.3 | 0 | 10 | 375 | 10 | 131 | CDS27897.2 gag pol polyprotein [Hymenolepis microstoma] | diamond | 7200 | 190 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 28789054 | 28789054 | PRJNA725806_P_NODE_9927_length_376_cov_2.507375_g9640_i0 | PRJNA725806 | 9927 | 376 | 2.507375 | 9.42773 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 45.1 | 0.0262 | NR | CAL5140267.1 | 300641 | g9640 | i0 | 52.3 | 0.686170212765957 | 44 | 19 | 33.5 | 1 | 127 | 2 | 574 | 617 | CAL5140267.1 unnamed protein product [Calicophoron daubneyi] | diamond | 258 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi | |
| 29462258 | 29462258 | PRJNA725806_P_NODE_40010_length_265_cov_4.399123_g39713_i0 | PRJNA725806 | 40010 | 265 | 4.399123 | 11.65767595 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 44.3 | 0.0134 | NR | XP_024346464.1 | 6210 | g39713 | i0 | 73.9 | 3.8377358490566 | 23 | 6 | 26 | 0 | 90 | 22 | 18 | 40 | XP_024346464.1 Radial spoke head 1 [Echinococcus granulosus] | diamond | 1017 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 29578301 | 29578301 | PRJNA725806_P_NODE_30310_length_286_cov_4.489960_g30013_i0 | PRJNA725806 | 30310 | 286 | 4.48996 | 12.8412856 | Hymenolepis diminuta | 6216 | Platyhelminthes | Platyhelminthes | 45.4 | 0.00671 | NR | VUZ57598.1 | 6216 | g30013 | i0 | 36.8 | 2.61188811188811 | 57 | 35 | 58.7 | 1 | 283 | 116 | 248 | 304 | VUZ57598.1 unnamed protein product [Hymenolepis diminuta] | diamond | 747 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 30567813 | 30567813 | PRJNA725806_P_NODE_196473_length_150_cov_0.955752_g196171_i0 | PRJNA725806 | 196473 | 150 | 0.955752 | 1.433628 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 42.7 | 0.0104 | NR | VEL44402.1 | 117903 | g196171 | i0 | 53.7 | 34.82 | 41 | 17 | 78 | 1 | 25 | 141 | 134 | 174 | VEL44402.1 unnamed protein product, partial [Protopolystoma xenopodis] | diamond | 5223 | 43.1 | 0.990719257540603 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Polystomatidea | Polystomatidae | Protopolystoma | Protopolystoma xenopodis | |
| 31379592 | 31379592 | PRJNA725806_P_NODE_81796_length_212_cov_1.674286_g81495_i0 | PRJNA725806 | 81796 | 212 | 1.674286 | 3.54948632 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 58.5 | 6.69e-8 | NR | PAA52757.1 | 282301 | g81495 | i0 | 52.4 | 2.81603773584906 | 63 | 30 | 89.2 | 0 | 211 | 23 | 456 | 518 | PAA52757.1 hypothetical protein BOX15_Mlig015759g1 [Macrostomum lignano] | diamond | 597 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31453209 | 31453209 | PRJNA725806_P_NODE_93256_length_202_cov_4.757576_g92954_i0 | PRJNA725806 | 93256 | 202 | 4.757576 | 9.61030352 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 44.7 | 0.00452 | NR | CAH8522787.1 | 6185 | g92954 | i0 | 32.4 | 9.74257425742574 | 71 | 38 | 90.6 | 2 | 197 | 15 | 88 | 158 | CAH8522787.1 unnamed protein product [Schistosoma haematobium] | diamond | 1968 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 32244281 | 32244281 | PRJNA725806_P_NODE_138098_length_174_cov_5.065693_g137796_i0 | PRJNA725806 | 138098 | 174 | 5.065693 | 8.81430582 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 48.5 | 5.1e-5 | NR | VUZ54585.1 | 6216 | g137796 | i0 | 59 | 3.39655172413793 | 39 | 15 | 65.5 | 1 | 124 | 11 | 22 | 60 | VUZ54585.1 unnamed protein product [Hymenolepis diminuta] | diamond | 591 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta |
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);;