contig_metadata
11 rows where bioproject = "PRJNA451191" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5544807 | 5544807 | PRJNA451191_P_NODE_5305_length_707_cov_2.986068_g5055_i0 | PRJNA451191 | 5305 | 707 | 2.986068 | 21.11150076 | root | 1 | Root_unresolved | Root_unresolved | 221 | 5.41e-64 | NR | CAH8840565.1 | 157069 | g5055 | i0 | 45.5 | 1.95615275813296 | 233 | 127 | 98.9 | 0 | 5 | 703 | 331 | 563 | CAH8840565.1 unnamed protein product [Trichobilharzia regenti] | diamond | 1383 | 221 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 26965724 | 26965724 | PRJNA451191_P_NODE_55162_length_202_cov_0.921986_g54891_i0 | PRJNA451191 | 55162 | 202 | 0.921986 | 1.86241172 | root | 1 | Root_unresolved | Root_unresolved | 53.5 | 3.45e-6 | NR | VZI24942.1 | 99802 | g54891 | i0 | 54.1 | 3.31188118811881 | 37 | 17 | 55 | 0 | 92 | 202 | 818 | 854 | VZI24942.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 669 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 28260714 | 28260714 | PRJNA451191_P_NODE_44486_length_213_cov_1.631579_g44215_i0 | PRJNA451191 | 44486 | 213 | 1.631579 | 3.47526327 | root | 1 | Root_unresolved | Root_unresolved | 50.1 | 4.22e-5 | NR | CAH8590375.1 | 6187 | g44215 | i0 | 42.2 | 1.61971830985915 | 64 | 34 | 90.1 | 1 | 213 | 22 | 46 | 106 | CAH8590375.1 unnamed protein product [Schistosoma intercalatum] | diamond | 345 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma intercalatum | |
| 28402527 | 28402527 | PRJNA451191_P_NODE_47166_length_209_cov_2.027027_g46895_i0 | PRJNA451191 | 47166 | 209 | 2.027027 | 4.23648643 | Trichobilharzia regenti | 157069 | Platyhelminthes | Platyhelminthes | 72.4 | 8.3e-13 | NR | CAH8840565.1 | 157069 | g46895 | i0 | 52.2 | 0.990430622009569 | 69 | 33 | 99 | 0 | 207 | 1 | 223 | 291 | CAH8840565.1 unnamed protein product [Trichobilharzia regenti] | diamond | 207 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 29002882 | 29002882 | PRJNA451191_P_NODE_13428_length_403_cov_1.783626_g13157_i0 | PRJNA451191 | 13428 | 403 | 1.783626 | 7.18801278 | Schistosoma margrebowiei | 48269 | Platyhelminthes | Platyhelminthes | 52 | 3.59e-5 | NR | VDO75992.1 | 48269 | g13157 | i0 | 46.7 | 3.75186104218362 | 45 | 24 | 33.5 | 0 | 150 | 16 | 73 | 117 | VDO75992.1 unnamed protein product [Schistosoma margrebowiei] | diamond | 1512 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma margrebowiei | |
| 29065703 | 29065703 | PRJNA451191_P_NODE_40748_length_223_cov_1.604938_g40477_i0 | PRJNA451191 | 40748 | 223 | 1.604938 | 3.57901174 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 48.1 | 3.47e-4 | NR | VZI49151.1 | 99802 | g40477 | i0 | 43.4 | 3.55156950672646 | 53 | 30 | 71.3 | 0 | 164 | 6 | 435 | 487 | VZI49151.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 792 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 29696664 | 29696664 | PRJNA451191_P_NODE_31990_length_251_cov_2.926316_g31719_i0 | PRJNA451191 | 31990 | 251 | 2.926316 | 7.34505316 | Trichobilharzia regenti | 157069 | Platyhelminthes | Platyhelminthes | 115 | 9.91e-28 | NR | CAH8840565.1 | 157069 | g31719 | i0 | 68.3 | 0.9800796812749 | 82 | 26 | 98 | 0 | 249 | 4 | 223 | 304 | CAH8840565.1 unnamed protein product [Trichobilharzia regenti] | diamond | 246 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 31024002 | 31024002 | PRJNA451191_P_NODE_52935_length_204_cov_0.909091_g52664_i0 | PRJNA451191 | 52935 | 204 | 0.909091 | 1.85454564 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 47.8 | 3.89e-4 | NR | VZI19895.1 | 99802 | g52664 | i0 | 40 | 3.30882352941176 | 75 | 34 | 94.1 | 3 | 13 | 204 | 414 | 488 | VZI19895.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 675 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 31149887 | 31149887 | PRJNA451191_P_NODE_49135_length_207_cov_1.780822_g48864_i0 | PRJNA451191 | 49135 | 207 | 1.780822 | 3.68630154 | Trichobilharzia regenti | 157069 | Platyhelminthes | Platyhelminthes | 73.2 | 4.44e-13 | NR | CAH8840565.1 | 157069 | g48864 | i0 | 46.3 | 1.94202898550725 | 67 | 36 | 97.1 | 0 | 4 | 204 | 552 | 618 | CAH8840565.1 unnamed protein product [Trichobilharzia regenti] | diamond | 402 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 31814477 | 31814477 | PRJNA451191_P_NODE_18777_length_333_cov_1.073529_g18506_i0 | PRJNA451191 | 18777 | 333 | 1.073529 | 3.57485157 | Trichobilharzia regenti | 157069 | Platyhelminthes | Platyhelminthes | 66.6 | 4.32e-10 | NR | CAH8840565.1 | 157069 | g18506 | i0 | 62.7 | 2.35135135135135 | 51 | 19 | 45.9 | 0 | 2 | 154 | 226 | 276 | CAH8840565.1 unnamed protein product [Trichobilharzia regenti] | diamond | 783 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 32099187 | 32099187 | PRJNA451191_P_NODE_22118_length_304_cov_1.337449_g21847_i0 | PRJNA451191 | 22118 | 304 | 1.337449 | 4.06584496 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 62.4 | 9.47e-9 | NR | VZI45314.1 | 99802 | g21847 | i0 | 53.6 | 0.552631578947368 | 56 | 26 | 55.3 | 0 | 234 | 67 | 293 | 348 | VZI45314.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 168 | 62.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei |
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);;