contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1241156" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5453352 | 5453352 | PRJNA1241156_S_NODE_34465_length_317_cov_6.021898_g34005_i0 | PRJNA1241156 | 34465 | 317 | 6.021898 | 19.08941666 | Riggenbachiella amazonense | 1921625 | Platyhelminthes | Platyhelminthes | 52.8 | 0.03 | NTclustered | gi|1791271074|gb|MN624071.1| | 1921625 | g34005 | i0 | 100 | 0.0883280757097792 | 28 | 0 | 9 | 0 | 235 | 262 | 1399 | 1372 | Riggenbachiella amazonense isolate PI 582a4 cytochrome c oxidase subunit I (cox1) gene, complete cds; mitochondrial | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Proteocephalidea | Monticelliidae | Riggenbachiella | Riggenbachiella amazonense | |
| 5453862 | 5453862 | PRJNA1241156_S_NODE_73645_length_210_cov_134.652695_g73185_i0 | PRJNA1241156 | 73645 | 210 | 134.652695 | 282.7706595 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 233 | 6.13e-57 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g73185 | i0 | 97.794 | 92.2619047619048 | 136 | 1 | 100 | 1 | 75 | 210 | 1779 | 1912 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 19375 | 233 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 10554483 | 10554483 | PRJNA1241156_S_NODE_71809_length_221_cov_5.449438_g71349_i0 | PRJNA1241156 | 71809 | 221 | 5.449438 | 12.04325798 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 398 | 2.1799999999999995e-106 | NTclustered | gi|60698688|gb|AY915747.1| | 6182 | g71349 | i0 | 99.095 | 2.37556561085973 | 221 | 2 | 100 | 0 | 1 | 221 | 343 | 123 | Schistosoma japonicum SJCHGC09661 protein mRNA, partial cds | blastn | 525 | 398 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 14379149 | 14379149 | PRJNA1241156_S_NODE_47232_length_283_cov_2.683333_g46772_i0 | PRJNA1241156 | 47232 | 283 | 2.683333 | 7.59383239 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.026 | NTclustered | gi|690523605|emb|LN075866.1| | 99802 | g46772 | i0 | 100 | 0.0989399293286219 | 28 | 0 | 10 | 0 | 225 | 252 | 3938 | 3965 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0072974 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 16927493 | 16927493 | PRJNA1241156_S_NODE_6094_length_477_cov_14.944700_g5646_i0 | PRJNA1241156 | 6094 | 477 | 14.9447 | 71.286219 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 366 | 1.4599999999999993e-96 | NTclustered | gi|60600058|gb|AY810684.1| | 6182 | g5646 | i0 | 99.02 | 6.38364779874214 | 204 | 2 | 43 | 0 | 274 | 477 | 1 | 204 | Schistosoma japonicum SJCHGC04723 protein mRNA, partial cds | blastn | 3045 | 366 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 19475776 | 19475776 | PRJNA1241156_S_NODE_24176_length_349_cov_169.552288_g23716_i0 | PRJNA1241156 | 24176 | 349 | 169.552288 | 591.73748512 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 355 | 2.24e-93 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g23716 | i0 | 98.049 | 69.6991404011461 | 205 | 3 | 58 | 1 | 1 | 204 | 1456 | 1252 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 24325 | 355 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 23302101 | 23302101 | PRJNA1241156_S_NODE_2079_length_700_cov_8.528158_g1784_i0 | PRJNA1241156 | 2079 | 700 | 8.528158 | 59.697106 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 505 | 4.459999999999998e-138 | NTclustered | gi|60698656|gb|AY915745.1| | 6182 | g1784 | i0 | 98.264 | 7.71142857142857 | 288 | 5 | 41 | 0 | 1 | 288 | 180 | 467 | Schistosoma japonicum SJCHGC09658 protein mRNA, partial cds | blastn | 5398 | 505 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 23302535 | 23302535 | PRJNA1241156_S_NODE_53059_length_268_cov_3211.951111_g52599_i0 | PRJNA1241156 | 53059 | 268 | 3211.951111 | 8608.02897748 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 165 | 3.02e-36 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g52599 | i0 | 95.192 | 21.7126865671642 | 104 | 5 | 39 | 0 | 1 | 104 | 1359 | 1256 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 5819 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 23302794 | 23302794 | PRJNA1241156_S_NODE_75099_length_205_cov_3372.018519_g74639_i0 | PRJNA1241156 | 75099 | 205 | 3372.018519 | 6912.63796395 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 152 | 1.7199999999999998e-32 | NTclustered | gi|56757963|gb|AY815390.1| | 6182 | g74639 | i0 | 98.824 | 44.0926829268293 | 85 | 1 | 42 | 0 | 121 | 205 | 1258 | 1342 | Schistosoma japonicum SJCHGC01951 protein mRNA, complete cds | blastn | 9039 | 152 | 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);;