contig_metadata
9 rows where bioproject = "PRJNA700095" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4511414 | 4511414 | PRJNA700095_P_NODE_69284_length_226_cov_2.928105_g68019_i0 | PRJNA700095 | 69284 | 226 | 2.928105 | 6.6175173 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 366 | 6.32e-97 | NTclustered | gi|60598655|gb|AY809988.1| | 6182 | g68019 | i0 | 99.02 | 100.194690265487 | 204 | 2 | 90 | 0 | 21 | 224 | 662 | 459 | Schistosoma japonicum SJCHGC09533 protein mRNA, partial cds | blastn | 22644 | 366 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 15985763 | 15985763 | PRJNA700095_P_NODE_27313_length_326_cov_22.517787_g26049_i0 | PRJNA700095 | 27313 | 326 | 22.517787 | 73.40798562 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 503 | 7.039999999999998e-138 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g26049 | i0 | 95.092 | 124.898773006135 | 326 | 5 | 100 | 2 | 1 | 326 | 1610 | 1924 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 40717 | 503 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 19810096 | 19810096 | PRJNA700095_P_NODE_33916_length_293_cov_1.500000_g32652_i0 | PRJNA700095 | 33916 | 293 | 1.5 | 4.395 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 503 | 6.24e-138 | NTclustered | gi|60698688|gb|AY915747.1| | 6182 | g32652 | i0 | 97.611 | 2.44027303754266 | 293 | 7 | 100 | 0 | 1 | 293 | 402 | 110 | Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds | blastn | 715 | 503 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 26841039 | 26841039 | PRJNA700095_P_NODE_39941_length_276_cov_1.477833_g38677_i0 | PRJNA700095 | 39941 | 276 | 1.477833 | 4.07881908 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 55.8 | 1.18e-6 | NR | VUZ55185.1 | 6216 | g38677 | i0 | 45.6 | 8.43478260869565 | 57 | 31 | 62 | 0 | 172 | 2 | 46 | 102 | VUZ55185.1 unnamed protein product, partial [Hymenolepis diminuta] | diamond | 2328 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 27504931 | 27504931 | PRJNA700095_P_NODE_69963_length_216_cov_4.020979_g68698_i0 | PRJNA700095 | 69963 | 216 | 4.020979 | 8.68531464 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 46.2 | 0.00158 | NR | TNN08009.1 | 6182 | g68698 | i0 | 37.2 | 9.55555555555556 | 43 | 27 | 59.7 | 0 | 144 | 16 | 377 | 419 | TNN08009.1 CCR4-NOT transcription complex subunit 11 isoform 1 [Schistosoma japonicum] | diamond | 2064 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27683337 | 27683337 | PRJNA700095_P_NODE_42264_length_270_cov_1.558376_g41000_i0 | PRJNA700095 | 42264 | 270 | 1.558376 | 4.2076152 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 50.4 | 9.79e-5 | NR | CAL5135764.1 | 300641 | g41000 | i0 | 44.1 | 1.51111111111111 | 68 | 27 | 75.6 | 2 | 221 | 18 | 9 | 65 | CAL5135764.1 unnamed protein product [Calicophoron daubneyi] | diamond | 408 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi | |
| 29746229 | 29746229 | PRJNA700095_P_NODE_18350_length_418_cov_0.884058_g17087_i0 | PRJNA700095 | 18350 | 418 | 0.884058 | 3.69536244 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.6 | 2.68e-6 | NR | VZI22467.1 | 99802 | g17087 | i0 | 27.8 | 10.0478468899522 | 126 | 83 | 90.4 | 3 | 3 | 380 | 141 | 258 | VZI22467.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 4200 | 57 | 0.992982456140351 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 29893369 | 29893369 | PRJNA700095_P_NODE_19171_length_406_cov_1.510511_g17908_i0 | PRJNA700095 | 19171 | 406 | 1.510511 | 6.13267466 | Schistosoma margrebowiei | 48269 | Platyhelminthes | Platyhelminthes | 108 | 2.9400000000000004e-27 | NR | VDP18829.1 | 48269 | g17908 | i0 | 52.6 | 2.15024630541872 | 97 | 44 | 71.7 | 1 | 398 | 108 | 35 | 129 | VDP18829.1 unnamed protein product [Schistosoma margrebowiei] | diamond | 873 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma margrebowiei | |
| 30504757 | 30504757 | PRJNA700095_P_NODE_67053_length_236_cov_2.656442_g65789_i0 | PRJNA700095 | 67053 | 236 | 2.656442 | 6.26920312 | Diphyllobothriidae | 28843 | Platyhelminthes | Platyhelminthes | 66.6 | 2.55e-11 | NR | VDN09442.1 | 60516 | g65789 | i0 | 42.9 | 1.95762711864407 | 77 | 44 | 97.9 | 0 | 232 | 2 | 73 | 149 | VDN09442.1 unnamed protein product, partial [Dibothriocephalus latus] | diamond | 462 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Dibothriocephalus | Dibothriocephalus latus |
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);;