contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1069776" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2735654 | 2735654 | PRJNA1069776_S_NODE_6443_length_348_cov_962.157377_g6129_i0 | PRJNA1069776 | 6443 | 348 | 962.157377 | 3348.30767196 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 320 | 8.18e-83 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g6129 | i0 | 97.849 | 129.295977011494 | 186 | 3 | 100 | 1 | 164 | 348 | 1720 | 1905 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 44995 | 320 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 4011058 | 4011058 | PRJNA1069776_S_NODE_16184_length_257_cov_3.682243_g15870_i0 | PRJNA1069776 | 16184 | 257 | 3.682243 | 9.46336451 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 263 | 9.92e-66 | NTclustered | gi|60700756|gb|AY915859.1| | 6182 | g15870 | i0 | 91.192 | 2.22178988326848 | 193 | 17 | 75 | 0 | 40 | 232 | 193 | 1 | Schistosoma japonicum SJCHGC09793 protein mRNA, complete cds | blastn | 571 | 263 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 5287613 | 5287613 | PRJNA1069776_S_NODE_33165_length_188_cov_6.179310_g32851_i0 | PRJNA1069776 | 33165 | 188 | 6.17931 | 11.6171028 | Monotoplana cf. diorchis | 104924 | Platyhelminthes | Platyhelminthes | 73.1 | 1.24e-8 | NTclustered | gi|10944981|emb|AJ270174.1| | 104924 | g32851 | i0 | 100 | 20.7340425531915 | 39 | 0 | 21 | 0 | 85 | 123 | 1633 | 1595 | Monotoplana cf. diorchis partial 28S rRNA gene | blastn | 3898 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Proseriata | Monotoplanidae | Monotoplana | Monotoplana cf. diorchis | |
| 9112661 | 9112661 | PRJNA1069776_S_NODE_6728_length_344_cov_1245.382060_g6414_i0 | PRJNA1069776 | 6728 | 344 | 1245.38206 | 4284.1142864 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 318 | 2.909999999999999e-82 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g6414 | i0 | 98.352 | 132.212209302326 | 182 | 2 | 100 | 1 | 1 | 181 | 1905 | 1724 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 45481 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 10388151 | 10388151 | PRJNA1069776_S_NODE_41349_length_170_cov_4.535433_g41035_i0 | PRJNA1069776 | 41349 | 170 | 4.535433 | 7.7102361 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 215 | 1.71e-51 | NTclustered | gi|60691997|gb|AY915382.1| | 6182 | g41035 | i0 | 89.412 | 23.1882352941176 | 170 | 18 | 100 | 0 | 1 | 170 | 183 | 352 | Schistosoma japonicum SJCHGC05510 protein mRNA, partial cds | blastn | 3942 | 215 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 12938425 | 12938425 | PRJNA1069776_S_NODE_22711_length_222_cov_7.178771_g22397_i0 | PRJNA1069776 | 22711 | 222 | 7.178771 | 15.93687162 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 315 | 2.27e-81 | NTclustered | gi|60698688|gb|AY915747.1| | 6182 | g22397 | i0 | 93.81 | 2.28378378378378 | 210 | 12 | 96 | 1 | 14 | 222 | 296 | 87 | Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds | blastn | 507 | 315 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum |
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);;